From 5a90260d95e4618bf02e179a1bdd93a78aeeb4f9 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Mon, 13 Sep 2004 13:50:06 +0000
Subject: - Patch #10775 by crackermackjack: fixed error in the database.mysql
 file that is incompatible with Mysql > 4.1.x.

- Patch #10786 by crackermackjack: fixed bug in session keys (bug in particular MySQL version).
---
 database/database.mysql | 25 ++++++++++++++++++++-----
 1 file changed, 20 insertions(+), 5 deletions(-)

(limited to 'database/database.mysql')

diff --git a/database/database.mysql b/database/database.mysql
index 2964018fc..45d864e7e 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -193,6 +193,21 @@ CREATE TABLE comments (
   KEY lid (nid)
 ) 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;
 
-- 
cgit v1.2.3