aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mssql_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
-rw-r--r--phpBB/install/schemas/mssql_schema.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index c71b5f0f40..4f8de86d90 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -1588,8 +1588,12 @@ ALTER TABLE [phpbb_users] WITH NOCHECK ADD
CONSTRAINT [DF_users__user_message_rules] DEFAULT (0) FOR [user_message_rules],
CONSTRAINT [DF_users__user_full_folder] DEFAULT ((-3)) FOR [user_full_folder],
CONSTRAINT [DF_users__user_emailtime] DEFAULT (0) FOR [user_emailtime],
+ CONSTRAINT [DF_users__user_topic_sortby_type] DEFAULT ('t') FOR [user_topic_sortby_type],
+ CONSTRAINT [DF_users__user_topic_sortby_dir] DEFAULT ('d') FOR [user_topic_sortby_dir],
CONSTRAINT [DF_users__user_topic_show_days] DEFAULT (0) FOR [user_topic_show_days],
CONSTRAINT [DF_users__user_post_show_days] DEFAULT (0) FOR [user_post_show_days],
+ CONSTRAINT [DF_users__user_post_sortby_type] DEFAULT ('t') FOR [user_post_sortby_type],
+ CONSTRAINT [DF_users__user_post_sortby_dir] DEFAULT ('a') FOR [user_post_sortby_dir],
CONSTRAINT [DF_users__user_notify] DEFAULT (0) FOR [user_notify],
CONSTRAINT [DF_users__user_notify_pm] DEFAULT (1) FOR [user_notify_pm],
CONSTRAINT [DF_users__user_notify_type] DEFAULT (0) FOR [user_notify_type],