From 60352821bfd61c266c6cda5f797cc7036a9499d2 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 7 Dec 2004 16:55:38 +0000 Subject: - 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. --- database/database.mysql | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) (limited to 'database/database.mysql') 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, @@ -530,6 +527,17 @@ CREATE TABLE poll_choices ( KEY nid (nid) ) 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' -- -- cgit v1.2.3