Recent changes to support-requestshttps://sourceforge.net/p/tphpguestbook/support-requests/2004-05-27T20:54:05ZRecent changes to support-requestsschema files2004-05-27T20:54:05Z2004-05-27T20:54:05ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.netc46d5286506b6e750f545b14903195084545e07a<div class="markdown_content"><p>Here is a schema that works for postgres. However, the<br />
php scripts required some serious hacking. Most<br />
notably, postgres field names are case insensitive. <br />
So, every time DB_FETCHMODE_ASSOC was used, row keys<br />
had to be converted to lower case. The install script<br />
is also totally busted.</p>
<p>-- Table structure for table 'phpGB_Posts'<br />
--<br />
CREATE TABLE phpGB_Posts (<br />
PostId SERIAL NOT NULL PRIMARY KEY,<br />
Name varchar(255) NOT NULL default '',<br />
EMail varchar(255) NOT NULL default '',<br />
Website varchar(255) default '',<br />
Post text NOT NULL,<br />
Date timestamp NOT NULL,<br />
IP varchar(15) NOT NULL default ''<br />
);</p>
<p>--<br />
-- Table structure for table 'phpGB_Smilies'<br />
--<br />
CREATE TABLE phpGB_Smilies (<br />
SmiliesId smallint NOT NULL PRIMARY KEY,<br />
Code varchar(50) NOT NULL,<br />
Description varchar(100) NOT NULL,<br />
Filename varchar(50) NOT NULL<br />
);</p>
<p>--<br />
-- Table structure for table 'phpGB_Config'<br />
--<br />
CREATE TABLE phpGB_Config (<br />
ConfigName varchar(255) NOT NULL PRIMARY KEY,<br />
ConfigValue varchar(255) NOT NULL<br />
);<br />
--<br />
-- Table structure for table 'phpGB_Users'<br />
--<br />
CREATE TABLE phpGB_Users (<br />
UserId serial NOT NULL PRIMARY KEY,<br />
Username varchar(50) NOT NULL,<br />
Password varchar(50) NOT NULL<br />
);</p></div>