From 4e2ee96d4c04fbee06abcd3d0bf84a7893792c7f Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Fri, 22 Aug 2003 17:06:44 +0000 Subject: - Removed left-overs from the rating module. Patch by Gerhard. Updated the PostgreSQL and MSSQL database scheme as well. - Made sure the update script updates the correct tables when database prefixing is enabled. Patch by Bart Jansens. - Improved the breadcrumb navigation of the book and the forum module as per Keith Instone's suggestions. - Updated page titles (or block titles) and links to match. Suggested by Keith Instone. - Added missing 'thread' field to the comment table of the MySQL database scheme. Fixes bug #2590. --- database/database.mysql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'database/database.mysql') diff --git a/database/database.mysql b/database/database.mysql index 81e0f2c53..e64bf687a 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -125,6 +125,7 @@ CREATE TABLE comments ( link varchar(16) NOT NULL default '', score mediumint(9) NOT NULL default '0', status tinyint(3) unsigned NOT NULL default '0', + thread varchar(255) NOT NULL, users mediumtext, PRIMARY KEY (cid), KEY lid (nid) @@ -509,7 +510,6 @@ CREATE TABLE users ( timestamp int(11) NOT NULL default '0', status tinyint(4) NOT NULL default '0', timezone varchar(8) default NULL, - rating decimal(8,2) default NULL, language char(2) NOT NULL default '', init varchar(64) default '', data text, -- cgit v1.2.3