diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-02-06 19:14:19 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-02-06 19:14:19 +0000 |
| commit | 4ea6d5048dd5a9e9084d61d307a667e65819c266 (patch) | |
| tree | 985ef9aab436076c3641d919cf1017696234137f | |
| parent | 10cb57a0b7e51423be74546e1c8a474b187b8052 (diff) | |
| download | brdo-4ea6d5048dd5a9e9084d61d307a667e65819c266.tar.gz brdo-4ea6d5048dd5a9e9084d61d307a667e65819c266.tar.bz2 | |
- Updated the database scheme.
| -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 |