diff options
| author | Dries Buytaert <dries@buytaert.net> | 2006-01-27 15:52:44 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2006-01-27 15:52:44 +0000 |
| commit | 41e5f369f406e9bf24a3adc2474f5f10011520b2 (patch) | |
| tree | 0eea0fed52851bb8dad77aa2cc2399cedd11d02c /database | |
| parent | d958fad0d685b5a50c6e0caab9bc42b403a243f6 (diff) | |
| download | brdo-41e5f369f406e9bf24a3adc2474f5f10011520b2.tar.gz brdo-41e5f369f406e9bf24a3adc2474f5f10011520b2.tar.bz2 | |
- Patch #45810 by killes: vid is not updated when the forum node is stored with "sticky" or "promote to front" checked.
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 4 | ||||
| -rw-r--r-- | database/database.pgsql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/database/database.mysql b/database/database.mysql index 5a5dac52a..38f8bb272 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -335,8 +335,8 @@ 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), + PRIMARY KEY (vid), + KEY nid (nid), KEY tid (tid) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */ ; diff --git a/database/database.pgsql b/database/database.pgsql index 8d8925729..80f1e8199 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -318,10 +318,10 @@ CREATE TABLE forum ( nid integer NOT NULL default '0', vid integer NOT NULL default '0', tid integer NOT NULL default '0', - PRIMARY KEY (nid) + PRIMARY KEY (vid) ); CREATE INDEX forum_tid_idx ON forum(tid); -CREATE INDEX forum_vid_idx ON forum(vid); +CREATE INDEX forum_vid_idx ON forum(nid); -- -- Table structure for history |