diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-03 21:52:56 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-03 21:52:56 +0000 |
| commit | 9f6864cd0c95719f35bced2383cf1df72d5a2a9c (patch) | |
| tree | 3cdb17d6b579a0af65e8a318310a4af7e31e218d /phpBB/install/schemas/sqlite_schema.sql | |
| parent | 9439a3f49a0c528782ed9e7d34aee4770e07bdc2 (diff) | |
| download | forums-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 (limited to 'phpBB/install/schemas/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
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', |