From 9f6864cd0c95719f35bced2383cf1df72d5a2a9c Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Mon, 3 Oct 2005 21:52:56 +0000 Subject: okok, maybe assigning a default ordering is not that bad. harhar git-svn-id: file:///svn/phpbb/trunk@5251 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/schemas/postgres_schema.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'phpBB/install/schemas/postgres_schema.sql') diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 3f22b3af0b..0248852182 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -1165,11 +1165,11 @@ CREATE TABLE phpbb_users ( user_sortby_type varchar(1) DEFAULT '' NOT NULL, user_sortby_dir varchar(1) DEFAULT '' NOT NULL, user_topic_show_days INT4 DEFAULT '0' NOT NULL, - user_topic_sortby_type varchar(1) DEFAULT '' NOT NULL, - user_topic_sortby_dir varchar(1) DEFAULT '' 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 INT4 DEFAULT '0' NOT NULL, - user_post_sortby_type varchar(1) DEFAULT '' NOT NULL, - user_post_sortby_dir varchar(1) DEFAULT '' NOT NULL, + user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL, + user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL, user_notify INT2 DEFAULT '0' NOT NULL, user_notify_pm INT2 DEFAULT '1' NOT NULL, user_notify_type INT2 DEFAULT '0' NOT NULL, -- cgit v1.2.1