diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-09-18 17:01:06 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-09-18 17:01:06 +0000 |
| commit | 5486af9dfe44201d7c8b63854baf6c206680b37b (patch) | |
| tree | 0fb5b376114fdb3294e7ffc73ea5b536c02ca8fd | |
| parent | dec4ddd3a58ee0f72170435db68e6310389f8000 (diff) | |
| download | brdo-5486af9dfe44201d7c8b63854baf6c206680b37b.tar.gz brdo-5486af9dfe44201d7c8b63854baf6c206680b37b.tar.bz2 | |
- Patch #31343 by Robert Douglas et al: fixed database table problem with forum table.
| -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 |