From 9f6864cd0c95719f35bced2383cf1df72d5a2a9c Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
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

