diff options
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/database_update.php | 10 | ||||
| -rw-r--r-- | phpBB/install/index.php | 22 | ||||
| -rw-r--r-- | phpBB/install/install_convert.php | 8 | ||||
| -rw-r--r-- | phpBB/install/install_install.php | 21 | ||||
| -rw-r--r-- | phpBB/install/install_update.php | 10 | ||||
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 21 | ||||
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 37 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_40_schema.sql | 20 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 20 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 28 | ||||
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 24 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 3 | ||||
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 20 | 
13 files changed, 208 insertions, 36 deletions
| diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 3be5ea659c..fa8ec6b6ce 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -77,16 +77,16 @@ require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);  set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler');  // Setup class loader first -$phpbb_class_loader = new phpbb_class_loader('phpbb_', "{$phpbb_root_path}phpbb/", $phpEx); +$phpbb_class_loader = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}phpbb/", $phpEx);  $phpbb_class_loader->register();  // Set up container (must be done here because extensions table may not exist)  $container_extensions = array( -	new phpbb_di_extension_config($phpbb_root_path . 'config.' . $phpEx), -	new phpbb_di_extension_core($phpbb_root_path . 'config/'), +	new \phpbb\di\extension\config($phpbb_root_path . 'config.' . $phpEx), +	new \phpbb\di\extension\core($phpbb_root_path . 'config/'),  );  $container_passes = array( -	new phpbb_di_pass_collection_pass(), +	new \phpbb\di\pass\collection_pass(),  );  $phpbb_container = phpbb_create_container($container_extensions, $phpbb_root_path, $phpEx); @@ -211,7 +211,7 @@ while (!$migrator->finished())  	{  		$migrator->update();  	} -	catch (phpbb_db_migration_exception $e) +	catch (\phpbb\db\migration\exception $e)  	{  		echo $e->getLocalisedMessage($user); diff --git a/phpBB/install/index.php b/phpBB/install/index.php index bd39e231f4..2a3bb36bf6 100644 --- a/phpBB/install/index.php +++ b/phpBB/install/index.php @@ -108,11 +108,11 @@ phpbb_include_updated('includes/utf/utf_tools.' . $phpEx);  phpbb_require_updated('includes/functions_install.' . $phpEx);  // Setup class loader first -$phpbb_class_loader_new = new phpbb_class_loader('phpbb_', "{$phpbb_root_path}install/update/new/phpbb/", $phpEx); +$phpbb_class_loader_new = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}install/update/new/phpbb/", $phpEx);  $phpbb_class_loader_new->register(); -$phpbb_class_loader = new phpbb_class_loader('phpbb_', "{$phpbb_root_path}phpbb/", $phpEx); +$phpbb_class_loader = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}phpbb/", $phpEx);  $phpbb_class_loader->register(); -$phpbb_class_loader_ext = new phpbb_class_loader('phpbb_ext_', "{$phpbb_root_path}ext/", $phpEx); +$phpbb_class_loader_ext = new \phpbb\class_loader('\\', "{$phpbb_root_path}ext/", $phpEx);  $phpbb_class_loader_ext->register();  // Set up container @@ -219,8 +219,8 @@ $sub = $request->variable('sub', '');  // Set PHP error handler to ours  set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler'); -$user = new phpbb_user(); -$auth = new phpbb_auth(); +$user = new \phpbb\user(); +$auth = new \phpbb\auth\auth();  // Add own hook handler, if present. :o  if (file_exists($phpbb_root_path . 'includes/hooks/index.' . $phpEx)) @@ -240,19 +240,15 @@ else  }  // Set some standard variables we want to force -$config = new phpbb_config(array( +$config = new \phpbb\config\config(array(  	'load_tplcompile'	=> '1'  )); -$phpbb_style_resource_locator = new phpbb_style_resource_locator(); -$phpbb_style_path_provider = new phpbb_style_path_provider(); -$template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $user, new phpbb_template_context()); -$phpbb_style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $phpbb_style_resource_locator, $phpbb_style_path_provider, $template); -$phpbb_style->set_ext_dir_prefix('adm/'); - +$phpbb_filesystem = $phpbb_container->get('filesystem'); +$template = new \phpbb\template\twig\twig($phpbb_filesystem, $config, $user, new \phpbb\template\context());  $paths = array($phpbb_root_path . 'install/update/new/adm/style', $phpbb_admin_path . 'style');  $paths = array_filter($paths, 'is_dir'); -$phpbb_style->set_custom_style('admin', $paths, array(), ''); +$template->set_custom_style('adm', $paths);  $template->assign_var('T_ASSETS_PATH', '../assets');  $template->assign_var('T_TEMPLATE_PATH', $phpbb_admin_path . 'style'); diff --git a/phpBB/install/install_convert.php b/phpBB/install/install_convert.php index 8a8c440036..4d3e1d3d4a 100644 --- a/phpBB/install/install_convert.php +++ b/phpBB/install/install_convert.php @@ -130,7 +130,7 @@ class install_convert extends module  				unset($dbpasswd);  				// We need to fill the config to let internal functions correctly work -				$config = new phpbb_config_db($db, new phpbb_cache_driver_null, CONFIG_TABLE); +				$config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);  				set_config(null, null, null, $config);  				set_config_count(null, null, null, $config); @@ -345,7 +345,7 @@ class install_convert extends module  		$this->page_title = $lang['STAGE_SETTINGS'];  		// We need to fill the config to let internal functions correctly work -		$config = new phpbb_config_db($db, new phpbb_cache_driver_null, CONFIG_TABLE); +		$config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);  		set_config(null, null, null, $config);  		set_config_count(null, null, null, $config); @@ -586,7 +586,7 @@ class install_convert extends module  		unset($dbpasswd);  		// We need to fill the config to let internal functions correctly work -		$config = new phpbb_config_db($db, new phpbb_cache_driver_null, CONFIG_TABLE); +		$config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);  		set_config(null, null, null, $config);  		set_config_count(null, null, null, $config); @@ -739,7 +739,7 @@ class install_convert extends module  		// For conversions we are a bit less strict and set to a search backend we know exist...  		if (!class_exists($search_type))  		{ -			$search_type = 'phpbb_search_fulltext_native'; +			$search_type = '\phpbb\search\fulltext_native';  			set_config('search_type', $search_type);  		} diff --git a/phpBB/install/install_install.php b/phpBB/install/install_install.php index ea23c318e3..c273660d08 100644 --- a/phpBB/install/install_install.php +++ b/phpBB/install/install_install.php @@ -102,7 +102,7 @@ class install_install extends module  			break;  			case 'final': -				// Enable super globals to prevent issues with the new phpbb_request object +				// Enable super globals to prevent issues with the new \phpbb\request\request object  				$request->enable_super_globals();  				// Create a normal container now @@ -1179,7 +1179,7 @@ class install_install extends module  		// Ok tables have been built, let's fill in the basic information  		$sql_query = file_get_contents('schemas/schema_data.sql'); -		// Deal with any special comments +		// Deal with any special comments and characters  		switch ($data['dbms'])  		{  			case 'mssql': @@ -1191,6 +1191,11 @@ class install_install extends module  			case 'postgres':  				$sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query);  			break; + +			case 'mysql': +			case 'mysqli': +				$sql_query = str_replace('\\', '\\\\', $sql_query); +			break;  		}  		// Change prefix @@ -1438,12 +1443,12 @@ class install_install extends module  		include_once($phpbb_root_path . 'phpbb/search/fulltext_native.' . $phpEx);  		// We need to fill the config to let internal functions correctly work -		$config = new phpbb_config_db($db, new phpbb_cache_driver_null, CONFIG_TABLE); +		$config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);  		set_config(null, null, null, $config);  		set_config_count(null, null, null, $config);  		$error = false; -		$search = new phpbb_search_fulltext_native($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user); +		$search = new \phpbb\search\fulltext_native($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);  		$sql = 'SELECT post_id, post_subject, post_text, poster_id, forum_id  			FROM ' . POSTS_TABLE; @@ -1753,7 +1758,7 @@ class install_install extends module  		$data = $this->get_submitted_data();  		// We need to fill the config to let internal functions correctly work -		$config = new phpbb_config_db($db, new phpbb_cache_driver_null, CONFIG_TABLE); +		$config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);  		set_config(null, null, null, $config);  		set_config_count(null, null, null, $config); @@ -1827,7 +1832,7 @@ class install_install extends module  		$data = $this->get_submitted_data();  		// We need to fill the config to let internal functions correctly work -		$config = new phpbb_config_db($db, new phpbb_cache_driver_null, CONFIG_TABLE); +		$config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);  		set_config(null, null, null, $config);  		set_config_count(null, null, null, $config); @@ -1892,8 +1897,8 @@ class install_install extends module  	* "installs" means it adds all migrations to the migrations table, but does not  	* perform any of the actions in the migrations.  	* -	* @param phpbb_extension_manager $extension_manager -	* @param phpbb_db_migrator $migrator +	* @param \phpbb\extension\manager $extension_manager +	* @param \phpbb\db\migrator $migrator  	*/  	function populate_migrations($extension_manager, $migrator)  	{ diff --git a/phpBB/install/install_update.php b/phpBB/install/install_update.php index 4ae39f202f..b7b358ab2f 100644 --- a/phpBB/install/install_update.php +++ b/phpBB/install/install_update.php @@ -70,7 +70,7 @@ class install_update extends module  	function main($mode, $sub)  	{ -		global $phpbb_style, $template, $phpEx, $phpbb_root_path, $user, $db, $config, $cache, $auth, $language; +		global $template, $phpEx, $phpbb_root_path, $user, $db, $config, $cache, $auth, $language;  		global $request, $phpbb_admin_path, $phpbb_adm_relative_path, $phpbb_container;  		// We must enable super globals, otherwise creating a new instance of the request class, @@ -111,7 +111,7 @@ class install_update extends module  		unset($dbpasswd);  		// We need to fill the config to let internal functions correctly work -		$config = new phpbb_config_db($db, new phpbb_cache_driver_null, CONFIG_TABLE); +		$config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);  		set_config(null, null, null, $config);  		set_config_count(null, null, null, $config); @@ -143,7 +143,7 @@ class install_update extends module  		// Set custom template again. ;)  		$paths = array($phpbb_root_path . 'install/update/new/adm/style', $phpbb_admin_path . 'style');  		$paths = array_filter($paths, 'is_dir'); -		$phpbb_style->set_custom_style('admin', $paths, array(), ''); +		$template->set_custom_style('adm', $paths);  		$template->assign_vars(array(  			'S_USER_LANG'			=> $user->lang['USER_LANG'], @@ -250,7 +250,7 @@ class install_update extends module  		$this->include_file('includes/diff/renderer.' . $phpEx);  		// Make sure we stay at the file check if checking the files again -		if ($request->variable('check_again', false, false, phpbb_request_interface::POST)) +		if ($request->variable('check_again', false, false, \phpbb\request\request_interface::POST))  		{  			$sub = $this->p_master->sub = 'file_check';  		} @@ -338,7 +338,7 @@ class install_update extends module  				$action = request_var('action', '');  				// We are directly within an update. To make sure our update list is correct we check its status. -				$update_list = ($request->variable('check_again', false, false, phpbb_request_interface::POST)) ? false : $cache->get('_update_list'); +				$update_list = ($request->variable('check_again', false, false, \phpbb\request\request_interface::POST)) ? false : $cache->get('_update_list');  				$modified = ($update_list !== false) ? @filemtime($cache->get_driver()->cache_dir . 'data_update_list.' . $phpEx) : 0;  				// Make sure the list is up-to-date diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 73bdfe777c..a9b7f58099 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -128,6 +128,27 @@ CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users(user_id);;  CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users(auth_option_id);;  CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users(auth_role_id);; +# Table: 'phpbb_oauth_tokens' +CREATE TABLE phpbb_oauth_tokens ( +	user_id INTEGER DEFAULT 0 NOT NULL, +	session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL, +	provider VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL, +	oauth_token BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL +);; + +CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens(user_id);; +CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens(provider);; + +# Table: 'phpbb_oauth_accounts' +CREATE TABLE phpbb_oauth_accounts ( +	user_id INTEGER DEFAULT 0 NOT NULL, +	provider VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL, +	oauth_provider_id BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL +);; + +ALTER TABLE phpbb_oauth_accounts ADD PRIMARY KEY (user_id, provider);; + +  # Table: 'phpbb_banlist'  CREATE TABLE phpbb_banlist (  	ban_id INTEGER NOT NULL, diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index cbf824ce8d..bea116b7d6 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -167,6 +167,43 @@ GO  /* +	Table: 'phpbb_oauth_tokens' +*/ +CREATE TABLE [phpbb_oauth_tokens] ( +	[user_id] [int] DEFAULT (0) NOT NULL , +	[session_id] [char] (32) DEFAULT ('') NOT NULL , +	[provider] [varchar] (255) DEFAULT ('') NOT NULL , +	[oauth_token] [text] DEFAULT ('') NOT NULL  +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +GO + +CREATE  INDEX [user_id] ON [phpbb_oauth_tokens]([user_id]) ON [PRIMARY] +GO + +CREATE  INDEX [provider] ON [phpbb_oauth_tokens]([provider]) ON [PRIMARY] +GO + + +/* +	Table: 'phpbb_oauth_accounts' +*/ +CREATE TABLE [phpbb_oauth_accounts] ( +	[user_id] [int] DEFAULT (0) NOT NULL , +	[provider] [varchar] (255) DEFAULT ('') NOT NULL , +	[oauth_provider_id] [varchar] (4000) DEFAULT ('') NOT NULL  +) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_oauth_accounts] WITH NOCHECK ADD  +	CONSTRAINT [PK_phpbb_oauth_accounts] PRIMARY KEY  CLUSTERED  +	( +		[user_id], +		[provider] +	)  ON [PRIMARY]  +GO + + +/*  	Table: 'phpbb_banlist'  */  CREATE TABLE [phpbb_banlist] ( diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql index 6d487335bb..da464f3ae7 100644 --- a/phpBB/install/schemas/mysql_40_schema.sql +++ b/phpBB/install/schemas/mysql_40_schema.sql @@ -90,6 +90,26 @@ CREATE TABLE phpbb_acl_users (  ); +# Table: 'phpbb_oauth_tokens' +CREATE TABLE phpbb_oauth_tokens ( +	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, +	session_id binary(32) DEFAULT '' NOT NULL, +	provider varbinary(255) DEFAULT '' NOT NULL, +	oauth_token mediumblob NOT NULL, +	KEY user_id (user_id), +	KEY provider (provider) +); + + +# Table: 'phpbb_oauth_accounts' +CREATE TABLE phpbb_oauth_accounts ( +	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, +	provider varbinary(255) DEFAULT '' NOT NULL, +	oauth_provider_id blob NOT NULL, +	PRIMARY KEY (user_id, provider) +); + +  # Table: 'phpbb_banlist'  CREATE TABLE phpbb_banlist (  	ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index 5b64027d4e..fa8929d860 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -90,6 +90,26 @@ CREATE TABLE phpbb_acl_users (  ) CHARACTER SET `utf8` COLLATE `utf8_bin`; +# Table: 'phpbb_oauth_tokens' +CREATE TABLE phpbb_oauth_tokens ( +	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, +	session_id char(32) DEFAULT '' NOT NULL, +	provider varchar(255) DEFAULT '' NOT NULL, +	oauth_token mediumtext NOT NULL, +	KEY user_id (user_id), +	KEY provider (provider) +) CHARACTER SET `utf8` COLLATE `utf8_bin`; + + +# Table: 'phpbb_oauth_accounts' +CREATE TABLE phpbb_oauth_accounts ( +	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, +	provider varchar(255) DEFAULT '' NOT NULL, +	oauth_provider_id text NOT NULL, +	PRIMARY KEY (user_id, provider) +) CHARACTER SET `utf8` COLLATE `utf8_bin`; + +  # Table: 'phpbb_banlist'  CREATE TABLE phpbb_banlist (  	ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 598910c143..a2e9780b9f 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -211,6 +211,34 @@ CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id)  /  /* +	Table: 'phpbb_oauth_tokens' +*/ +CREATE TABLE phpbb_oauth_tokens ( +	user_id number(8) DEFAULT '0' NOT NULL, +	session_id char(32) DEFAULT '' , +	provider varchar2(255) DEFAULT '' , +	oauth_token clob DEFAULT ''  +) +/ + +CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens (user_id) +/ +CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (provider) +/ + +/* +	Table: 'phpbb_oauth_accounts' +*/ +CREATE TABLE phpbb_oauth_accounts ( +	user_id number(8) DEFAULT '0' NOT NULL, +	provider varchar2(255) DEFAULT '' , +	oauth_provider_id clob DEFAULT '' , +	CONSTRAINT pk_phpbb_oauth_accounts PRIMARY KEY (user_id, provider) +) +/ + + +/*  	Table: 'phpbb_banlist'  */  CREATE TABLE phpbb_banlist ( diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index fe90befb72..ecafe8f43f 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -189,6 +189,30 @@ CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id);  CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id);  /* +	Table: 'phpbb_oauth_tokens' +*/ +CREATE TABLE phpbb_oauth_tokens ( +	user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0), +	session_id char(32) DEFAULT '' NOT NULL, +	provider varchar(255) DEFAULT '' NOT NULL, +	oauth_token TEXT DEFAULT '' NOT NULL +); + +CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens (user_id); +CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (provider); + +/* +	Table: 'phpbb_oauth_accounts' +*/ +CREATE TABLE phpbb_oauth_accounts ( +	user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0), +	provider varchar(255) DEFAULT '' NOT NULL, +	oauth_provider_id varchar(4000) DEFAULT '' NOT NULL, +	PRIMARY KEY (user_id, provider) +); + + +/*  	Table: 'phpbb_banlist'  */  CREATE SEQUENCE phpbb_banlist_seq; diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index 0a31b89aab..70138f35fd 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -101,6 +101,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_function_nam  INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_max_chunk_size', '50');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size', '20');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_mod_rewrite', '0');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_pm_icons', '1');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_post_confirm', '1');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_enable', '1'); @@ -236,7 +237,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_block_size'  INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_gc', '7200');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_interval', '0');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_anonymous_interval', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_type', 'phpbb_search_fulltext_native'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_type', 'phpbb\search\fulltext_native');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_store_results', '1800');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('secure_allow_deny', '1');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('secure_allow_empty_referer', '1'); diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 6224a37df4..d076b9823b 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -89,6 +89,26 @@ CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id);  CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id);  CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id); +# Table: 'phpbb_oauth_tokens' +CREATE TABLE phpbb_oauth_tokens ( +	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0', +	session_id char(32) NOT NULL DEFAULT '', +	provider varchar(255) NOT NULL DEFAULT '', +	oauth_token mediumtext(16777215) NOT NULL DEFAULT '' +); + +CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens (user_id); +CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (provider); + +# Table: 'phpbb_oauth_accounts' +CREATE TABLE phpbb_oauth_accounts ( +	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0', +	provider varchar(255) NOT NULL DEFAULT '', +	oauth_provider_id text(65535) NOT NULL DEFAULT '', +	PRIMARY KEY (user_id, provider) +); + +  # Table: 'phpbb_banlist'  CREATE TABLE phpbb_banlist (  	ban_id INTEGER PRIMARY KEY NOT NULL , | 
