diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-12-07 16:55:38 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-12-07 16:55:38 +0000 |
| commit | 60352821bfd61c266c6cda5f797cc7036a9499d2 (patch) | |
| tree | 9bdf38ec0b9c752caab1397a24a21fff78099151 /database/database.mysql | |
| parent | 1365740f6eab386aa16ba39c6f324a3c30adb78d (diff) | |
| download | brdo-60352821bfd61c266c6cda5f797cc7036a9499d2.tar.gz brdo-60352821bfd61c266c6cda5f797cc7036a9499d2.tar.bz2 | |
- Refactored the queue module: removed the queue module's field from the node table. With help from Gerhard.
- Slight addition to INSTALL.txt with regard to PHP versions.
- Updated/reworded some node type descriptions as per Boris' suggestions.
- Adding missing {} around a table name in update.php.
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 14 |
1 files changed, 11 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql index 933516980..5d8e15a36 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -394,8 +394,6 @@ CREATE TABLE node ( nid int(10) unsigned NOT NULL auto_increment, type varchar(16) NOT NULL default '', title varchar(128) NOT NULL default '', - score int(11) NOT NULL default '0', - votes int(11) NOT NULL default '0', uid int(10) NOT NULL default '0', status int(4) NOT NULL default '1', created int(11) NOT NULL default '0', @@ -403,7 +401,6 @@ CREATE TABLE node ( comment int(2) NOT NULL default '0', promote int(2) NOT NULL default '0', moderate int(2) NOT NULL default '0', - users longtext NOT NULL, teaser longtext NOT NULL, body longtext NOT NULL, revisions longtext NOT NULL, @@ -531,6 +528,17 @@ CREATE TABLE poll_choices ( ) TYPE=MyISAM; -- +-- Table structure for table 'queue' +-- + +CREATE TABLE queue ( + nid int(10) unsigned NOT NULL, + uid int(10) unsigned NOT NULL, + vote int(3) NOT NULL default '0', + PRIMARY KEY (nid, uid) +) TYPE=MyISAM; + +-- -- Table structure for table 'role' -- |