diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-04-20 00:22:29 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-04-20 00:22:29 +0000 |
| commit | 5b0bba72b1c619af2f39859ec0c262f860f991ac (patch) | |
| tree | 9fb003cf223ff6bf2e26feb78a35603dff88a471 /phpBB/db | |
| parent | 65aa92182826eb06830626df49ab7a0210b06718 (diff) | |
| download | forums-5b0bba72b1c619af2f39859ec0c262f860f991ac.tar forums-5b0bba72b1c619af2f39859ec0c262f860f991ac.tar.gz forums-5b0bba72b1c619af2f39859ec0c262f860f991ac.tar.bz2 forums-5b0bba72b1c619af2f39859ec0c262f860f991ac.tar.xz forums-5b0bba72b1c619af2f39859ec0c262f860f991ac.zip | |
merged from 2.0.0 branch (marked merge_point_20020420) + assorted updates and trial stuff for example session alterations
git-svn-id: file:///svn/phpbb/trunk@2532 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/schemas/ms_access_primer.zip | bin | 51251 -> 51985 bytes | |||
| -rw-r--r-- | phpBB/db/schemas/mssql_basic.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_basic.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_basic.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 2 |
7 files changed, 6 insertions, 6 deletions
diff --git a/phpBB/db/schemas/ms_access_primer.zip b/phpBB/db/schemas/ms_access_primer.zip Binary files differindex a39a45254f..047823591c 100644 --- a/phpBB/db/schemas/ms_access_primer.zip +++ b/phpBB/db/schemas/ms_access_primer.zip diff --git a/phpBB/db/schemas/mssql_basic.sql b/phpBB/db/schemas/mssql_basic.sql index 7aa37b616b..5a1a444275 100644 --- a/phpBB/db/schemas/mssql_basic.sql +++ b/phpBB/db/schemas/mssql_basic.sql @@ -67,7 +67,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_user INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020402]'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020420]'); /* -- Categories diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index a4ee0eb5aa..ac95defdd6 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -318,7 +318,7 @@ CREATE TABLE [phpbb_users] ( [user_regdate] [int] NOT NULL , [user_level] [smallint] NOT NULL , [user_posts] [int] NOT NULL , - [user_timezone] [real] NOT NULL , + [user_timezone] [decimal] (4,2) NOT NULL , [user_style] [int] NULL , [user_lang] [varchar] (255) NULL , [user_dateformat] [varchar] (14) NOT NULL , diff --git a/phpBB/db/schemas/mysql_basic.sql b/phpBB/db/schemas/mysql_basic.sql index 11f0c0744a..4c77db59ef 100644 --- a/phpBB/db/schemas/mysql_basic.sql +++ b/phpBB/db/schemas/mysql_basic.sql @@ -60,7 +60,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020402]'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020420]'); # -- Categories diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 75e9fffd46..02459360d4 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -463,7 +463,7 @@ CREATE TABLE phpbb_users ( user_regdate int(11) DEFAULT '0' NOT NULL, user_level tinyint(4) DEFAULT '0', user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_timezone float DEFAULT '0' NOT NULL, + user_timezone decimal(4,2) DEFAULT '0' NOT NULL, user_style tinyint(4), user_lang varchar(255), user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, diff --git a/phpBB/db/schemas/postgres_basic.sql b/phpBB/db/schemas/postgres_basic.sql index 895a635b3d..884b7f6b96 100644 --- a/phpBB/db/schemas/postgres_basic.sql +++ b/phpBB/db/schemas/postgres_basic.sql @@ -61,7 +61,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020402]'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020420]'); -- Categories INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 10); diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 7298cd553f..92be0f31ca 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -478,7 +478,7 @@ CREATE TABLE phpbb_users ( user_avatar_type int2 DEFAULT '0' NOT NULL, user_level int4 DEFAULT '1', user_lang varchar(255), - user_timezone real DEFAULT '0' NOT NULL, + user_timezone decimal(4) DEFAULT '0' NOT NULL, user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL, user_notify_pm int2 DEFAULT '1' NOT NULL, user_popup_pm int2 DEFAULT '0' NOT NULL, |