diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-03-21 13:59:33 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-03-21 13:59:33 +0000 |
| commit | 1ed2ed30728532e78fa4664f8f1fe17fe8d3ec52 (patch) | |
| tree | 078ebb41ad01d33d033bbffc912a28a90512cca1 /phpBB/db | |
| parent | 5047d43ca3bd96160210bdbc8a3eef2d3c01ae54 (diff) | |
| download | forums-1ed2ed30728532e78fa4664f8f1fe17fe8d3ec52.tar forums-1ed2ed30728532e78fa4664f8f1fe17fe8d3ec52.tar.gz forums-1ed2ed30728532e78fa4664f8f1fe17fe8d3ec52.tar.bz2 forums-1ed2ed30728532e78fa4664f8f1fe17fe8d3ec52.tar.xz forums-1ed2ed30728532e78fa4664f8f1fe17fe8d3ec52.zip | |
Re-fix schemas to allow decimal/real numbers in timezone ...
git-svn-id: file:///svn/phpbb/trunk@2390 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index 3084fde5c6..a4ee0eb5aa 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -318,7 +318,7 @@ CREATE TABLE [phpbb_users] ( [user_regdate] [int] NOT NULL , [user_level] [smallint] NOT NULL , [user_posts] [int] NOT NULL , - [user_timezone] [smallint] NOT NULL , + [user_timezone] [real] NOT NULL , [user_style] [int] NULL , [user_lang] [varchar] (255) NULL , [user_dateformat] [varchar] (14) NOT NULL , diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 8d0e08e545..75e9fffd46 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -463,7 +463,7 @@ CREATE TABLE phpbb_users ( user_regdate int(11) DEFAULT '0' NOT NULL, user_level tinyint(4) DEFAULT '0', user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_timezone tinyint(4) DEFAULT '0' NOT NULL, + user_timezone float DEFAULT '0' NOT NULL, user_style tinyint(4), user_lang varchar(255), user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 2ccd892d94..7298cd553f 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -478,7 +478,7 @@ CREATE TABLE phpbb_users ( user_avatar_type int2 DEFAULT '0' NOT NULL, user_level int4 DEFAULT '1', user_lang varchar(255), - user_timezone int4 DEFAULT '0' NOT NULL, + user_timezone real DEFAULT '0' NOT NULL, user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL, user_notify_pm int2 DEFAULT '1' NOT NULL, user_popup_pm int2 DEFAULT '0' NOT NULL, |