aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2005-10-03 21:52:56 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2005-10-03 21:52:56 +0000
commit9f6864cd0c95719f35bced2383cf1df72d5a2a9c (patch)
tree3cdb17d6b579a0af65e8a318310a4af7e31e218d
parent9439a3f49a0c528782ed9e7d34aee4770e07bdc2 (diff)
downloadforums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar.gz
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar.bz2
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.tar.xz
forums-9f6864cd0c95719f35bced2383cf1df72d5a2a9c.zip
okok, maybe assigning a default ordering is not that bad. harhar
git-svn-id: file:///svn/phpbb/trunk@5251 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat
-rw-r--r--phpBB/install/schemas/firebird_schema.sql8
-rw-r--r--phpBB/install/schemas/mssql_schema.sql4
-rw-r--r--phpBB/install/schemas/mysql_schema.sql8
-rw-r--r--phpBB/install/schemas/oracle_schema.sql8
-rw-r--r--phpBB/install/schemas/postgres_schema.sql8
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql8
6 files changed, 24 insertions, 20 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,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index c71b5f0f40..4f8de86d90 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -1588,8 +1588,12 @@ ALTER TABLE [phpbb_users] WITH NOCHECK ADD
CONSTRAINT [DF_users__user_message_rules] DEFAULT (0) FOR [user_message_rules],
CONSTRAINT [DF_users__user_full_folder] DEFAULT ((-3)) FOR [user_full_folder],
CONSTRAINT [DF_users__user_emailtime] DEFAULT (0) FOR [user_emailtime],
+ CONSTRAINT [DF_users__user_topic_sortby_type] DEFAULT ('t') FOR [user_topic_sortby_type],
+ CONSTRAINT [DF_users__user_topic_sortby_dir] DEFAULT ('d') FOR [user_topic_sortby_dir],
CONSTRAINT [DF_users__user_topic_show_days] DEFAULT (0) FOR [user_topic_show_days],
CONSTRAINT [DF_users__user_post_show_days] DEFAULT (0) FOR [user_post_show_days],
+ CONSTRAINT [DF_users__user_post_sortby_type] DEFAULT ('t') FOR [user_post_sortby_type],
+ CONSTRAINT [DF_users__user_post_sortby_dir] DEFAULT ('a') FOR [user_post_sortby_dir],
CONSTRAINT [DF_users__user_notify] DEFAULT (0) FOR [user_notify],
CONSTRAINT [DF_users__user_notify_pm] DEFAULT (1) FOR [user_notify_pm],
CONSTRAINT [DF_users__user_notify_type] DEFAULT (0) FOR [user_notify_type],
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index d99d74a638..97318e7a1e 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -895,11 +895,11 @@ CREATE TABLE phpbb_users (
user_full_folder int(11) DEFAULT '-3' NOT NULL,
user_emailtime int(11) DEFAULT '0' NOT NULL,
user_topic_show_days smallint(4) 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 smallint(4) 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 tinyint(1) DEFAULT '0' NOT NULL,
user_notify_pm tinyint(1) DEFAULT '1' NOT NULL,
user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
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,
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,
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 56958910f6..88e1ed05ba 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -882,11 +882,11 @@ CREATE TABLE phpbb_users (
user_full_folder int(11) NOT NULL DEFAULT '-3',
user_emailtime int(11) NOT NULL DEFAULT '0',
user_topic_show_days smallint(4) NOT NULL DEFAULT '0',
- user_topic_sortby_type varchar(1) NOT NULL DEFAULT '',
- user_topic_sortby_dir varchar(1) NOT NULL DEFAULT '',
+ user_topic_sortby_type varchar(1) NOT NULL DEFAULT 't',
+ user_topic_sortby_dir varchar(1) NOT NULL DEFAULT 'd',
user_post_show_days smallint(4) NOT NULL DEFAULT '0',
- user_post_sortby_type varchar(1) NOT NULL DEFAULT '',
- user_post_sortby_dir varchar(1) NOT NULL DEFAULT '',
+ user_post_sortby_type varchar(1) NOT NULL DEFAULT 't',
+ user_post_sortby_dir varchar(1) NOT NULL DEFAULT 'a',
user_notify tinyint(1) NOT NULL DEFAULT '0',
user_notify_pm tinyint(1) NOT NULL DEFAULT '1',
user_notify_type tinyint(4) NOT NULL DEFAULT '0',
generated by cgit v1.2.1 (git 2.21.0) at 2025-07-23 05:12:07 +0000