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/sqlite_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/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 257937275c..5066ac97df 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -886,8 +886,7 @@ CREATE TABLE phpbb_users ( user_inactive_time INTEGER UNSIGNED NOT NULL DEFAULT '0', user_posts INTEGER UNSIGNED NOT NULL DEFAULT '0', user_lang varchar(30) NOT NULL DEFAULT '', - user_timezone decimal(5,2) NOT NULL DEFAULT '0', - user_dst INTEGER UNSIGNED NOT NULL DEFAULT '0', + user_timezone varchar(100) NOT NULL DEFAULT 'UTC', user_dateformat varchar(30) NOT NULL DEFAULT 'd M Y H:i', user_style INTEGER UNSIGNED NOT NULL DEFAULT '0', user_rank INTEGER UNSIGNED NOT NULL DEFAULT '0', |