diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 2 | ||||
| -rw-r--r-- | database/database.pgsql | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/database/database.mysql b/database/database.mysql index 920782aaa..8a6f8afa0 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -294,8 +294,10 @@ CREATE TABLE flood ( CREATE TABLE forum ( nid int(10) unsigned NOT NULL default '0', + vid int(10) unsigned NOT NULL default '0', tid int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), + KEY vid (vid), KEY tid (tid) ) TYPE=MyISAM; diff --git a/database/database.pgsql b/database/database.pgsql index f083a3bd9..367d98662 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -291,11 +291,13 @@ CREATE TABLE flood ( CREATE TABLE forum ( nid integer NOT NULL default '0', + vid integer NOT NULL default '0', tid integer NOT NULL default '0', shadow integer NOT NULL default '0', PRIMARY KEY (nid) ); CREATE INDEX forum_tid_idx ON forum(tid); +CREATE INDEX forum_vid_idx ON forum(vid); -- -- Table structure for history |