From 4e2ee96d4c04fbee06abcd3d0bf84a7893792c7f Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
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.mssql | 1 -
 database/database.mysql | 2 +-
 database/database.pgsql | 1 -
 3 files changed, 1 insertion(+), 3 deletions(-)

(limited to 'database')

diff --git a/database/database.mssql b/database/database.mssql
index 25aee6143..16cb59fdf 100644
--- a/database/database.mssql
+++ b/database/database.mssql
@@ -345,7 +345,6 @@ CREATE TABLE [dbo].[users] (
   [timestamp] [float] NOT NULL ,
   [status] [smallint] NOT NULL ,
   [timezone] [varchar] (8) NULL ,
-  [rating] [float] NULL ,
   [language] [char] (2) NULL ,
   [init] [varchar] (128) NULL ,
   [data] [varchar] (8000) NULL ,
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,
diff --git a/database/database.pgsql b/database/database.pgsql
index 6e042464f..74b5cde3c 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -509,7 +509,6 @@ CREATE TABLE users (
   timestamp integer NOT NULL default '0',
   status smallint 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 default '',
-- 
cgit v1.2.3