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/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