diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-08-22 17:06:44 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-08-22 17:06:44 +0000 |
| commit | 4e2ee96d4c04fbee06abcd3d0bf84a7893792c7f (patch) | |
| tree | fe81455832b44894f1cb9b96a3690279a2c195f9 /database | |
| parent | 134c9eb8878a814d6955e6471aa10f93302d20f8 (diff) | |
| download | brdo-4e2ee96d4c04fbee06abcd3d0bf84a7893792c7f.tar.gz brdo-4e2ee96d4c04fbee06abcd3d0bf84a7893792c7f.tar.bz2 | |
- 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.mssql | 1 | ||||
| -rw-r--r-- | database/database.mysql | 2 | ||||
| -rw-r--r-- | database/database.pgsql | 1 |
3 files changed, 1 insertions, 3 deletions
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 '', |