summaryrefslogtreecommitdiffstats
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert2003-08-22 17:06:44 (GMT)
committerDries Buytaert2003-08-22 17:06:44 (GMT)
commit4e2ee96d4c04fbee06abcd3d0bf84a7893792c7f (patch)
treefe81455832b44894f1cb9b96a3690279a2c195f9 /database
parent134c9eb8878a814d6955e6471aa10f93302d20f8 (diff)
- 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.
Diffstat (limited to 'database')
-rw-r--r--database/database.mssql1
-rw-r--r--database/database.mysql2
-rw-r--r--database/database.pgsql1
3 files changed, 1 insertions, 3 deletions
diff --git a/database/database.mssql b/database/database.mssql
index 25aee61..16cb59f 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 81e0f2c..e64bf68 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 6e04246..74b5cde 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 '',