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/mysql_41_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/mysql_41_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index 9615905625..30fb7a8623 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -914,8 +914,7 @@ CREATE TABLE phpbb_users ( user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL, user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_lang varchar(30) DEFAULT '' NOT NULL, - user_timezone decimal(5,2) DEFAULT '0' NOT NULL, - user_dst tinyint(1) UNSIGNED 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 mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, |