diff options
| -rw-r--r-- | database/database.mysql | 25 |
1 files changed, 20 insertions, 5 deletions
diff --git a/database/database.mysql b/database/database.mysql index 2964018fc..45d864e7e 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -194,6 +194,21 @@ CREATE TABLE comments ( ) TYPE=MyISAM; -- +-- Table structre for table 'node_last_comment' +-- + +CREATE TABLE node_comment_statistics ( + nid int(10) unsigned NOT NULL auto_increment, + cid int(10) unsigned NOT NULL default '0', + last_comment_timestamp int(11) NOT NULL default '0', + last_comment_name varchar(60) default NULL, + last_comment_uid int(10) NOT NULL default '0', + comment_count int(10) unsigned NOT NULL default '0', + PRIMARY KEY (nid), + KEY node_comment_timestamp (last_comment_timestamp) +) TYPE=MyISAM; + +-- -- Table structure for table 'directory' -- @@ -227,7 +242,7 @@ CREATE TABLE files ( -- CREATE TABLE filter_formats ( - format int(4) NOT NULL default '0' auto_increment, + format int(4) NOT NULL auto_increment, name varchar(255) NOT NULL default '', roles varchar(255) NOT NULL default '', cache tinyint(2) NOT NULL default '0', @@ -252,8 +267,7 @@ CREATE TABLE filters ( CREATE TABLE forum ( nid int(10) unsigned NOT NULL default '0', - tid int(10) unsigned NOT NULL default '0', - shadow int(10) unsigned NOT NULL default '0', + tid int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), KEY tid (tid) ) TYPE=MyISAM; @@ -390,7 +404,8 @@ CREATE TABLE node ( KEY node_moderate (moderate), KEY node_promote_status (promote, status), KEY node_created (created), - KEY node_changed (changed) + KEY node_changed (changed), + KEY node_status_type (status, type, nid) ) TYPE=MyISAM; -- @@ -537,7 +552,7 @@ CREATE TABLE sessions ( timestamp int(11) NOT NULL default '0', session longtext, KEY uid (uid), - KEY sid (sid(4)), + KEY sid (sid), KEY timestamp (timestamp) ) TYPE=MyISAM; |