diff options
| -rw-r--r-- | database/database.mysql | 6 | ||||
| -rw-r--r-- | database/database.pgsql | 2 |
2 files changed, 6 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql index 5a75d15fc..ac0653b88 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -166,11 +166,13 @@ CREATE TABLE feed ( -- Table structure for table 'forum' -- -CREATE TABLE forum ( +CREATE TABLE forum2 ( nid int(10) unsigned NOT NULL default '0', + tid int(10) unsigned NOT NULL default '0', icon varchar(255) NOT NULL default '', shadow int(10) unsigned NOT NULL default '0', - PRIMARY KEY (nid) + PRIMARY KEY (nid), + KEY tid (tid) ) TYPE=MyISAM; -- diff --git a/database/database.pgsql b/database/database.pgsql index f564135d8..1d78a0c5f 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -165,10 +165,12 @@ CREATE TABLE feed ( CREATE TABLE forum ( nid integer NOT NULL default '0', + tid integer NOT NULL default '0', icon varchar(255) NOT NULL default '', shadow integer NOT NULL default '0', PRIMARY KEY (nid) ); +CREATE INDEX forum_tid_idx ON forum(tid); -- -- Table structure for history |