aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_schema.sql9
1 files changed, 6 insertions, 3 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index e3dbb9d4ca..84eb54444f 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -874,9 +874,12 @@ CREATE TABLE phpbb_users (
user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
user_full_folder int(11) DEFAULT '-3' NOT NULL,
user_emailtime int(11) DEFAULT '0' NOT NULL,
- user_sortby_type varchar(1) DEFAULT '' NOT NULL,
- user_sortby_dir varchar(1) DEFAULT '' NOT NULL,
- user_show_days tinyint(1) DEFAULT '' NOT NULL,
+ user_topic_show_days smallint(4) DEFAULT 0 NOT NULL,
+ user_topic_sortby_type varchar(1) DEFAULT '' NOT NULL,
+ user_topic_sortby_dir varchar(1) DEFAULT '' NOT NULL,
+ user_post_show_days smallint(4) DEFAULT 0 NOT NULL,
+ user_post_sortby_type varchar(1) DEFAULT '' NOT NULL,
+ user_post_sortby_dir varchar(1) DEFAULT '' NOT NULL,
user_notify tinyint(1) DEFAULT '0' NOT NULL,
user_notify_pm tinyint(1) DEFAULT '1' NOT NULL,
user_notify_type tinyint(4) DEFAULT '0' NOT NULL,