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/oracle_schema.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'phpBB/install/schemas/oracle_schema.sql')

diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 405ec79ff8..84e8befa2c 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -1651,11 +1651,11 @@ CREATE TABLE phpbb_users (
   user_full_folder number(11) DEFAULT '1' NOT NULL,
   user_emailtime number(11) DEFAULT '0' NOT NULL,
   user_topic_show_days number(4) DEFAULT '0' NOT NULL,
-  user_topic_sortby_type varchar2(1) DEFAULT '',
-  user_topic_sortby_dir varchar2(1) DEFAULT '',
+  user_topic_sortby_type varchar2(1) DEFAULT 't',
+  user_topic_sortby_dir varchar2(1) DEFAULT 'd',
   user_post_show_days number(4) DEFAULT '0' NOT NULL,
-  user_post_sortby_type varchar2(1) DEFAULT '',
-  user_post_sortby_dir varchar2(1) DEFAULT '',
+  user_post_sortby_type varchar2(1) DEFAULT 't',
+  user_post_sortby_dir varchar2(1) DEFAULT 'a',
   user_notify number(1) DEFAULT '0' NOT NULL,
   user_notify_pm number(1) DEFAULT '1' NOT NULL,
   user_notify_type number(4) DEFAULT '0' NOT NULL,
-- 
cgit v1.2.1

