aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2007-12-05 15:18:21 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2007-12-05 15:18:21 +0000
commit7f2d596c087c34c196af9d5627580b26ddfcc449 (patch)
tree9eeaf73394fe7140f31fccd04d8e5a342f203e32 /phpBB/install
parent3aacfcff2a6b6c40a6913652ff8c7c3c44f0aa30 (diff)
downloadforums-7f2d596c087c34c196af9d5627580b26ddfcc449.tar
forums-7f2d596c087c34c196af9d5627580b26ddfcc449.tar.gz
forums-7f2d596c087c34c196af9d5627580b26ddfcc449.tar.bz2
forums-7f2d596c087c34c196af9d5627580b26ddfcc449.tar.xz
forums-7f2d596c087c34c196af9d5627580b26ddfcc449.zip
fix unread/new pm columns
git-svn-id: file:///svn/phpbb/trunk@8267 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
-rw-r--r--phpBB/install/database_update.php12
-rw-r--r--phpBB/install/schemas/mysql_40_schema.sql4
-rw-r--r--phpBB/install/schemas/mysql_41_schema.sql4
-rw-r--r--phpBB/install/schemas/postgres_schema.sql4
-rw-r--r--phpBB/install/schemas/schema_data.sql2
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql4
6 files changed, 20 insertions, 10 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php
index b3be23858d..3b506a55b2 100644
--- a/phpBB/install/database_update.php
+++ b/phpBB/install/database_update.php
@@ -8,7 +8,7 @@
*
*/
-$updates_to_version = '3.0.RC8';
+$updates_to_version = '3.0.RC9-dev';
// Return if we "just include it" to find out for which version the database update is responsuble for
if (defined('IN_PHPBB') && defined('IN_INSTALL'))
@@ -463,6 +463,16 @@ $database_update_info = array(
),
),
),
+ // Changes from 3.0.RC8 to the next version
+ '3.0.RC8' => array(
+ // Change the following columns
+ 'change_columns' => array(
+ USERS_TABLE => array(
+ 'user_new_privmsg' => array('INT:4', 0),
+ 'user_unread_privmsg' => array('INT:4', 0),
+ ),
+ ),
+ ),
);
// Determine mapping database type
diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql
index a4f617209b..0f20b1030a 100644
--- a/phpBB/install/schemas/mysql_40_schema.sql
+++ b/phpBB/install/schemas/mysql_40_schema.sql
@@ -917,8 +917,8 @@ CREATE TABLE phpbb_users (
user_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_colour varbinary(6) DEFAULT '' NOT NULL,
- user_new_privmsg tinyint(4) DEFAULT '0' NOT NULL,
- user_unread_privmsg tinyint(4) DEFAULT '0' NOT NULL,
+ user_new_privmsg int(4) DEFAULT '0' NOT NULL,
+ user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
user_full_folder int(11) DEFAULT '-3' NOT NULL,
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index 618b98b280..2d91b0259e 100644
--- a/phpBB/install/schemas/mysql_41_schema.sql
+++ b/phpBB/install/schemas/mysql_41_schema.sql
@@ -917,8 +917,8 @@ CREATE TABLE phpbb_users (
user_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_colour varchar(6) DEFAULT '' NOT NULL,
- user_new_privmsg tinyint(4) DEFAULT '0' NOT NULL,
- user_unread_privmsg tinyint(4) DEFAULT '0' NOT NULL,
+ user_new_privmsg int(4) DEFAULT '0' NOT NULL,
+ user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
user_full_folder int(11) DEFAULT '-3' NOT NULL,
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 34ebe22742..1f20c17583 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -1180,8 +1180,8 @@ CREATE TABLE phpbb_users (
user_style INT2 DEFAULT '0' NOT NULL CHECK (user_style >= 0),
user_rank INT4 DEFAULT '0' NOT NULL CHECK (user_rank >= 0),
user_colour varchar(6) DEFAULT '' NOT NULL,
- user_new_privmsg INT2 DEFAULT '0' NOT NULL,
- user_unread_privmsg INT2 DEFAULT '0' NOT NULL,
+ user_new_privmsg INT4 DEFAULT '0' NOT NULL,
+ user_unread_privmsg INT4 DEFAULT '0' NOT NULL,
user_last_privmsg INT4 DEFAULT '0' NOT NULL CHECK (user_last_privmsg >= 0),
user_message_rules INT2 DEFAULT '0' NOT NULL CHECK (user_message_rules >= 0),
user_full_folder INT4 DEFAULT '-3' NOT NULL,
diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql
index 51e87629fe..272b9f13e0 100644
--- a/phpBB/install/schemas/schema_data.sql
+++ b/phpBB/install/schemas/schema_data.sql
@@ -213,7 +213,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page',
INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');
-INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.RC8');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.RC9-dev');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 5e2d28b5bc..fa5884cc5b 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -887,8 +887,8 @@ CREATE TABLE phpbb_users (
user_style INTEGER UNSIGNED NOT NULL DEFAULT '0',
user_rank INTEGER UNSIGNED NOT NULL DEFAULT '0',
user_colour varchar(6) NOT NULL DEFAULT '',
- user_new_privmsg tinyint(4) NOT NULL DEFAULT '0',
- user_unread_privmsg tinyint(4) NOT NULL DEFAULT '0',
+ user_new_privmsg int(4) NOT NULL DEFAULT '0',
+ user_unread_privmsg int(4) NOT NULL DEFAULT '0',
user_last_privmsg INTEGER UNSIGNED NOT NULL DEFAULT '0',
user_message_rules INTEGER UNSIGNED NOT NULL DEFAULT '0',
user_full_folder int(11) NOT NULL DEFAULT '-3',
generated by cgit v1.2.1 (git 2.21.0) at 2025-02-15 06:36:24 +0000