aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mssql_schema.sql
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2005-10-03 21:52:56 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2005-10-03 21:52:56 +0000
commit9f6864cd0c95719f35bced2383cf1df72d5a2a9c (patch)
tree3cdb17d6b579a0af65e8a318310a4af7e31e218d /phpBB/install/schemas/mssql_schema.sql
parent9439a3f49a0c528782ed9e7d34aee4770e07bdc2 (diff)
downloadforums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar.gz
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar.bz2
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar.xz
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.zip
okok, maybe assigning a default ordering is not that bad. harhar
git-svn-id: file:///svn/phpbb/trunk@5251 89ea8834-ac86-4346-8a33-228a782c2dd0
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],