aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/firebird_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 21628465dc..80e6cced79 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -761,11 +761,11 @@ CREATE TABLE phpbb_users (
user_sortby_type VARCHAR(2) NOT NULL,
user_sortby_dir VARCHAR(2) NOT NULL,
user_topic_show_days INTEGER DEFAULT 0 NOT NULL,
- user_topic_sortby_type VARCHAR(1) NOT NULL,
- user_topic_sortby_dir VARCHAR(1) NOT NULL,
+ user_topic_sortby_type VARCHAR(1) DEFAULT 't' NOT NULL,
+ user_topic_sortby_dir VARCHAR(1) DEFAULT 'd' NOT NULL,
user_post_show_days INTEGER DEFAULT 0 NOT NULL,
- user_post_sortby_type VARCHAR(2) NOT NULL,
- user_post_sortby_dir VARCHAR(2) NOT NULL,
+ user_post_sortby_type VARCHAR(2) DEFAULT 't' NOT NULL,
+ user_post_sortby_dir VARCHAR(2) DEFAULT 'a' NOT NULL,
user_notify INTEGER DEFAULT 0 NOT NULL,
user_notify_pm INTEGER DEFAULT 1 NOT NULL,
user_notify_type INTEGER DEFAULT 0 NOT NULL,