diff options
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/database_update.php | 12 | ||||
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 3 | ||||
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 3 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_40_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 3 | 
9 files changed, 24 insertions, 3 deletions
| diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index bf2d3a1c70..b28879de4d 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -424,6 +424,15 @@ $database_update_info = array(  			),  		),  	), +	// Changes from 3.0.RC5 to the next version +	'3.0.RC5'			=> array( +		// Add the following columns +		'add_columns'		=> array( +			USER_TABLE	=> array( +				'user_form_salt'	=> array('VCHAR_UNI:32', ''), +			), +		), +	),  );  // Determine mapping database type @@ -1510,6 +1519,9 @@ if (version_compare($current_version, '3.0.RC5', '<='))  		WHERE bot_agent = '" . $db->sql_escape('Mediapartners-Google/') . "'";  	_sql($sql, $errored, $error_ary); +	set_config('form_token_lifetime', '7200'); +	set_config('form_token_mintime', '0'); +  	$no_updates = false;  } diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 38ef13c412..37e14af4e5 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -1354,7 +1354,8 @@ CREATE TABLE phpbb_users (  	user_occ BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,  	user_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,  	user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL, -	user_newpasswd VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE +	user_newpasswd VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE, +	user_form_salt VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE  );;  ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);; diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 37e8f66b2a..54b3a1fa08 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -1621,7 +1621,8 @@ CREATE TABLE [phpbb_users] (  	[user_occ] [varchar] (4000) DEFAULT ('') NOT NULL ,  	[user_interests] [varchar] (4000) DEFAULT ('') NOT NULL ,  	[user_actkey] [varchar] (32) DEFAULT ('') NOT NULL , -	[user_newpasswd] [varchar] (32) DEFAULT ('') NOT NULL  +	[user_newpasswd] [varchar] (32) DEFAULT ('') NOT NULL , +	[user_form_salt] [varchar] (32) DEFAULT ('') NOT NULL   ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]  GO diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql index a1450cacee..478963e541 100644 --- a/phpBB/install/schemas/mysql_40_schema.sql +++ b/phpBB/install/schemas/mysql_40_schema.sql @@ -955,6 +955,7 @@ CREATE TABLE phpbb_users (  	user_interests blob NOT NULL,  	user_actkey varbinary(32) DEFAULT '' NOT NULL,  	user_newpasswd varbinary(96) DEFAULT '' NOT NULL, +	user_form_salt varbinary(96) DEFAULT '' NOT NULL,  	PRIMARY KEY (user_id),  	KEY user_birthday (user_birthday),  	KEY user_email_hash (user_email_hash), diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index 4cee662be6..88657aa4ac 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -955,6 +955,7 @@ CREATE TABLE phpbb_users (  	user_interests text NOT NULL,  	user_actkey varchar(32) DEFAULT '' NOT NULL,  	user_newpasswd varchar(32) DEFAULT '' NOT NULL, +	user_form_salt varchar(32) DEFAULT '' NOT NULL,  	PRIMARY KEY (user_id),  	KEY user_birthday (user_birthday),  	KEY user_email_hash (user_email_hash), diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index aabc00f0e2..a91f4d07ba 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -1772,6 +1772,7 @@ CREATE TABLE phpbb_users (  	user_interests clob DEFAULT '' ,  	user_actkey varchar2(32) DEFAULT '' ,  	user_newpasswd varchar2(96) DEFAULT '' , +	user_form_salt varchar2(96) DEFAULT '' ,  	CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id),  	CONSTRAINT u_phpbb_username_clean UNIQUE (username_clean)  ) diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 5d4c6f477b..9b439d9fb2 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -1218,6 +1218,7 @@ CREATE TABLE phpbb_users (  	user_interests varchar(4000) DEFAULT '' NOT NULL,  	user_actkey varchar(32) DEFAULT '' NOT NULL,  	user_newpasswd varchar(32) DEFAULT '' NOT NULL, +	user_form_salt varchar(32) DEFAULT '' NOT NULL,  	PRIMARY KEY (user_id)  ); diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index b80dc5583f..b155cd5d95 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -88,6 +88,8 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_pm_icons',  INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_post_confirm', '1');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval', '15');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('force_server_vars', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('form_token_lifetime', '7200'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('form_token_mintime', '0');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('forward_pm', '1');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('forwarded_for_check', '0');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('full_folder_action', '2'); diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 546cfb0321..f5156144e2 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -924,7 +924,8 @@ CREATE TABLE phpbb_users (  	user_occ text(65535) NOT NULL DEFAULT '',  	user_interests text(65535) NOT NULL DEFAULT '',  	user_actkey varchar(32) NOT NULL DEFAULT '', -	user_newpasswd varchar(32) NOT NULL DEFAULT '' +	user_newpasswd varchar(32) NOT NULL DEFAULT '', +	user_form_salt varchar(32) NOT NULL DEFAULT ''  );  CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday); | 
