diff options
| author | Chris Smith <toonarmy@phpbb.com> | 2010-07-07 23:23:11 +0100 |
|---|---|---|
| committer | Oleg Pudeyev <oleg@bsdpower.com> | 2012-03-14 22:57:30 -0400 |
| commit | af789040b8880f908df0a26d5239d07d77c34124 (patch) | |
| tree | ba441cdc82d719f8ac5bdeda5b30c3df1bf73943 /phpBB/install/schemas/mssql_schema.sql | |
| parent | 6e1278655ff3f250b4f1e09aa8674bae8d86287a (diff) | |
| download | forums-af789040b8880f908df0a26d5239d07d77c34124.tar forums-af789040b8880f908df0a26d5239d07d77c34124.tar.gz forums-af789040b8880f908df0a26d5239d07d77c34124.tar.bz2 forums-af789040b8880f908df0a26d5239d07d77c34124.tar.xz forums-af789040b8880f908df0a26d5239d07d77c34124.zip | |
[feature/new-tz-handling] Modify database schemas.
- Dropped the user_dst column which is no longer required.
- Modified the user_timezone column to take a string, max length 100.
PHPBB3-9558
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 736917fdcb..fc1afcbbff 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -1576,8 +1576,7 @@ CREATE TABLE [phpbb_users] ( [user_inactive_time] [int] DEFAULT (0) NOT NULL , [user_posts] [int] DEFAULT (0) NOT NULL , [user_lang] [varchar] (30) DEFAULT ('') NOT NULL , - [user_timezone] [float] DEFAULT (0) NOT NULL , - [user_dst] [int] DEFAULT (0) NOT NULL , + [user_timezone] [varchar] (100) DEFAULT ('UTC') NOT NULL , [user_dateformat] [varchar] (30) DEFAULT ('d M Y H:i') NOT NULL , [user_style] [int] DEFAULT (0) NOT NULL , [user_rank] [int] DEFAULT (0) NOT NULL , |