diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-01-20 20:57:45 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-01-20 20:57:45 +0000 |
| commit | 9c1a4bdac16945c7d616b3449cc7d97a2548fc22 (patch) | |
| tree | 27e35d979f7b8fd6b7844a6cba941b5b04a438bd /phpBB/install | |
| parent | a7ef13c639e048e9ee9edc25e7f7d9a5bf155812 (diff) | |
| download | forums-9c1a4bdac16945c7d616b3449cc7d97a2548fc22.tar forums-9c1a4bdac16945c7d616b3449cc7d97a2548fc22.tar.gz forums-9c1a4bdac16945c7d616b3449cc7d97a2548fc22.tar.bz2 forums-9c1a4bdac16945c7d616b3449cc7d97a2548fc22.tar.xz forums-9c1a4bdac16945c7d616b3449cc7d97a2548fc22.zip | |
- bugfixes
- default sort options for posts too
- adjusted format_date to remove the (time intensive) preg_ calls
- temporary style.php code.
git-svn-id: file:///svn/phpbb/trunk@5068 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 11 | ||||
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 12 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 9 | ||||
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 7 |
4 files changed, 28 insertions, 11 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index a5eeb65efc..edd5c53e32 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -755,9 +755,14 @@ CREATE TABLE phpbb_users ( user_message_rules INTEGER DEFAULT 0 NOT NULL, user_full_folder INTEGER DEFAULT -3 NOT NULL, user_emailtime INTEGER DEFAULT 0 NOT NULL, - user_sortby_type VARCHAR(1) NOT NULL, - user_sortby_dir VARCHAR(1) NOT NULL, - user_show_days INTEGER DEFAULT 0 NOT NULL, + 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_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_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 7fd24a8de6..0af42cb739 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -760,9 +760,12 @@ CREATE TABLE [phpbb_users] ( [user_message_rules] [int] NOT NULL , [user_full_folder] [int] NOT NULL , [user_emailtime] [int] NOT NULL , - [user_sortby_type] [varchar] (1) NOT NULL , - [user_sortby_dir] [varchar] (1) NOT NULL , - [user_show_days] [int] NOT NULL , + [user_post_show_days] [int] NOT NULL , + [user_post_sortby_type] [varchar] (1) NOT NULL , + [user_post_sortby_dir] [varchar] (1) NOT NULL , + [user_topic_show_days] [int] NOT NULL , + [user_topic_sortby_type] [varchar] (1) NOT NULL , + [user_topic_sortby_dir] [varchar] (1) NOT NULL , [user_notify] [int] NOT NULL , [user_notify_pm] [int] NOT NULL , [user_notify_type] [int] NOT NULL , @@ -1557,7 +1560,8 @@ 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_show_days] DEFAULT (0) FOR [user_show_days], + 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_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 e3dbb9d4ca..84eb54444f 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -874,9 +874,12 @@ CREATE TABLE phpbb_users ( user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, user_full_folder int(11) DEFAULT '-3' NOT NULL, user_emailtime int(11) DEFAULT '0' NOT NULL, - user_sortby_type varchar(1) DEFAULT '' NOT NULL, - user_sortby_dir varchar(1) DEFAULT '' NOT NULL, - user_show_days tinyint(1) DEFAULT '' 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_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_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/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index d656f2968d..0de7a6421a 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -1165,7 +1165,12 @@ CREATE TABLE phpbb_users ( user_emailtime INT4 DEFAULT '0' NOT NULL, user_sortby_type varchar(1) DEFAULT '' NOT NULL, user_sortby_dir varchar(1) DEFAULT '' NOT NULL, - user_show_days INT2 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_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_notify INT2 DEFAULT '0' NOT NULL, user_notify_pm INT2 DEFAULT '1' NOT NULL, user_notify_type INT2 DEFAULT '0' NOT NULL, |