+ array('topic_posts_approved', 'topics.topic_replies + 1', ''),

+ array('topic_posts_unapproved', 0, ''),

+ array('topic_posts_softdeleted',0, ''),

+ array('topic_posts_approved', 'topics.topic_replies + 1', ''),

+ array('topic_posts_unapproved', 0, ''),

+ array('topic_posts_softdeleted',0, ''),

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+require($phpbb_root_path . 'includes/startup.' . $phpEx);

+require($phpbb_root_path . 'phpbb/class_loader.' . $phpEx);

+require($phpbb_root_path . 'config.' . $phpEx);

+include($phpbb_root_path . 'includes/utf/utf_normalizer.' . $phpEx);

+$phpbb_class_loader = new phpbb_class_loader('phpbb_', "{$phpbb_root_path}phpbb/", $phpEx);

+ new phpbb_di_extension_core($phpbb_root_path . 'config/'),

+ ->core_path('phpbb/db/migration/data/')

+ echo '<br />' . $user->lang['DATABASE_UPDATE_NOT_COMPLETED'] . '<br /><br />';

+ echo '<a href="' . append_sid($phpbb_root_path . 'install/database_update.' . $phpEx, 'type=' . $request->variable('type', 0) . '&amp;language=' . $request->variable('language', 'en')) . '" class="button1">' . $user->lang['DATABASE_UPDATE_CONTINUE'] . '</a>';

+ echo '<a href="' . append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=update&amp;sub=update_db&amp;language=' . $request->variable('language', 'en')) . '" class="button1">' . $user->lang['CONTINUE_UPDATE_NOW'] . '</a>';

+ global $phpbb_root_path, $table_prefix;

+function phpbb_include_updated($path, $optional = false)

+{

+ global $phpbb_root_path;

+

+ $new_path = $phpbb_root_path . 'install/update/new/' . $path;

+ $old_path = $phpbb_root_path . $path;

+

+ if (file_exists($new_path))

+ {

+ include($new_path);

+ }

+ else if (!$optional || file_exists($old_path))

+ {

+ include($old_path);

+ }

+}

+

+phpbb_require_updated('phpbb/class_loader.' . $phpEx);

+phpbb_require_updated('includes/functions.' . $phpEx);

+phpbb_require_updated('includes/functions_container.' . $phpEx);

+phpbb_include_updated('includes/functions_admin.' . $phpEx);

+phpbb_include_updated('includes/utf/utf_normalizer.' . $phpEx);

+phpbb_include_updated('includes/utf/utf_tools.' . $phpEx);

+phpbb_require_updated('includes/functions_install.' . $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);

+$language = basename($request->variable('language', ''));

+$load_lang_files = array('common', 'acp/common', 'acp/board', 'install', 'posting');

+$new_path = $phpbb_root_path . 'install/update/new/language/' . $language . '/';

+$old_path = $phpbb_root_path . 'language/' . $language . '/';

+

+// NOTE: we can not use "phpbb_include_updated" as the files uses vars which would be required

+// to be global while loading.

+foreach ($load_lang_files as $lang_file)

+{

+ if (file_exists($new_path . $lang_file . '.' . $phpEx))

+ {

+ include($new_path . $lang_file . '.' . $phpEx);

+ }

+ else

+ {

+ include($old_path . $lang_file . '.' . $phpEx);

+ }

+}

+$mode = $request->variable('mode', 'overview');

+$sub = $request->variable('sub', '');

+$paths = array($phpbb_root_path . 'install/update/new/adm/style', $phpbb_admin_path . 'style');

+$paths = array_filter($paths, 'is_dir');

+$template->set_custom_style('adm', $paths);

+

+ include_once($phpbb_root_path . 'phpbb/search/fulltext_native.' . $phpEx);

+ * This "installs" all migrations from (root path)/phpbb/db/migrations/data.

+ ->core_path('phpbb/db/migration/data/')

+ 'module_stages' => array('INTRO', 'VERSION_CHECK', 'FILE_CHECK', 'UPDATE_FILES', 'UPDATE_DB'),

+ global $template, $phpEx, $phpbb_root_path, $user, $db, $config, $cache, $auth, $language;

+ // We must enable super globals, otherwise creating a new instance of the request class,

+ // using the new container with a dbal connection will fail with the following PHP Notice:

+ // Object of class phpbb_request_deactivated_super_global could not be converted to int

+ $request->enable_super_globals();

+

+ $phpbb_container = phpbb_create_update_container($phpbb_root_path, $phpEx, $phpbb_root_path . 'install/update/new/config');

+ $user->add_lang(array('common', 'acp/common', 'acp/board', 'install', 'posting'));

+ $paths = array($phpbb_root_path . 'install/update/new/adm/style', $phpbb_admin_path . 'style');

+ $paths = array_filter($paths, 'is_dir');

+ $template->set_custom_style('adm', $paths);

+ if (version_compare(strtolower($this->latest_version), strtolower($this->update_info['version']['to']), '>'))

+ // What about the language file? Got it updated?

+ if (in_array('language/' . $language . '/install.' . $phpEx, $this->update_info['files']))

+ $lang = array();

+ include($this->new_location . 'language/' . $language . '/install.' . $phpEx);

+ // this is the user's language.. just merge it

+ $user->lang = array_merge($user->lang, $lang);

+ if ($language != 'en' && in_array('language/en/install.' . $phpEx, $this->update_info['files']))

+ 'U_ACTION' => append_sid($this->p_master->module_url, "language=$language&amp;mode=$mode&amp;sub=file_check"),

+ 'S_UP_TO_DATE' => $up_to_date,

+ 'CURRENT_VERSION' => $this->current_version,

+ ));

+ if ($this->latest_version != $this->update_info['version']['to'])

+ 'L_EVERYTHING_UP_TO_DATE' => $user->lang('EVERYTHING_UP_TO_DATE', append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login'), append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login&amp;redirect=' . $phpbb_adm_relative_path . 'index.php%3Fi=send_statistics%26mode=send_statistics')),

+ // Do not display incompatible package note after successful update

+ if ($config['version'] == $this->update_info['version']['to'])

+ {

+ $template->assign_var('S_ERROR', false);

+ }

+ 'S_UP_TO_DATE' => $up_to_date,

+ // Since some people try to update to RC releases, but phpBB.com tells them the last version is the version they currently run

+ // we are faced with the updater thinking the database schema is up-to-date; which it is, but should be updated none-the-less

+ // We now try to cope with this by triggering the update process

+ if (version_compare(str_replace('rc', 'RC', strtolower($this->current_version)), str_replace('rc', 'RC', strtolower($this->update_info['version']['to'])), '<'))

+ {

+ $template->assign_vars(array(

+ 'S_UP_TO_DATE' => false,

+ ));

+ }

+

+ global $phpbb_container;

+ $phpbb_log = $phpbb_container->get('log');

+

+ $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_UPDATE_PHPBB', time(), array($this->current_version, $this->update_to_version));

+# 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);;

+

+

+ forum_posts_approved INTEGER DEFAULT 0 NOT NULL,

+ forum_posts_unapproved INTEGER DEFAULT 0 NOT NULL,

+ forum_posts_softdeleted INTEGER DEFAULT 0 NOT NULL,

+ forum_topics_approved INTEGER DEFAULT 0 NOT NULL,

+ forum_topics_unapproved INTEGER DEFAULT 0 NOT NULL,

+ forum_topics_softdeleted INTEGER DEFAULT 0 NOT NULL,

+ post_visibility INTEGER DEFAULT 0 NOT NULL,

+ post_edit_locked INTEGER DEFAULT 0 NOT NULL,

+ post_delete_time INTEGER DEFAULT 0 NOT NULL,

+ post_delete_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

+ post_delete_user INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_posts_post_visibility ON phpbb_posts(post_visibility);;

+ topic_visibility INTEGER DEFAULT 0 NOT NULL,

+ topic_posts_approved INTEGER DEFAULT 0 NOT NULL,

+ topic_posts_unapproved INTEGER DEFAULT 0 NOT NULL,

+ topic_posts_softdeleted INTEGER DEFAULT 0 NOT NULL,

+ poll_vote_change INTEGER DEFAULT 0 NOT NULL,

+ topic_delete_time INTEGER DEFAULT 0 NOT NULL,

+ topic_delete_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

+ topic_delete_user INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_topics_topic_visibility ON phpbb_topics(topic_visibility);;

+CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics(forum_id, topic_visibility, topic_last_post_id);;

+ 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

+

+

+/*

+ [forum_posts_approved] [int] DEFAULT (0) NOT NULL ,

+ [forum_posts_unapproved] [int] DEFAULT (0) NOT NULL ,

+ [forum_posts_softdeleted] [int] DEFAULT (0) NOT NULL ,

+ [forum_topics_approved] [int] DEFAULT (0) NOT NULL ,

+ [forum_topics_unapproved] [int] DEFAULT (0) NOT NULL ,

+ [forum_topics_softdeleted] [int] DEFAULT (0) NOT NULL ,

+ [post_visibility] [int] DEFAULT (0) NOT NULL ,

+ [post_edit_locked] [int] DEFAULT (0) NOT NULL ,

+ [post_delete_time] [int] DEFAULT (0) NOT NULL ,

+ [post_delete_reason] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [post_delete_user] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [post_visibility] ON [phpbb_posts]([post_visibility]) ON [PRIMARY]

+ [topic_visibility] [int] DEFAULT (0) NOT NULL ,

+ [topic_posts_approved] [int] DEFAULT (0) NOT NULL ,

+ [topic_posts_unapproved] [int] DEFAULT (0) NOT NULL ,

+ [topic_posts_softdeleted] [int] DEFAULT (0) NOT NULL ,

+ [poll_vote_change] [int] DEFAULT (0) NOT NULL ,

+ [topic_delete_time] [int] DEFAULT (0) NOT NULL ,

+ [topic_delete_reason] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [topic_delete_user] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [topic_visibility] ON [phpbb_topics]([topic_visibility]) ON [PRIMARY]

+CREATE INDEX [forum_appr_last] ON [phpbb_topics]([forum_id], [topic_visibility], [topic_last_post_id]) ON [PRIMARY]

+# 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)

+);

+

+

+ forum_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ post_visibility tinyint(3) DEFAULT '0' NOT NULL,

+ post_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ post_delete_reason blob NOT NULL,

+ post_delete_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY post_visibility (post_visibility),

+ topic_visibility tinyint(3) DEFAULT '0' NOT NULL,

+ topic_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_delete_reason blob NOT NULL,

+ topic_delete_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY topic_visibility (topic_visibility),

+ KEY forum_appr_last (forum_id, topic_visibility, topic_last_post_id),

+# 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`;

+

+

+ forum_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ post_visibility tinyint(3) DEFAULT '0' NOT NULL,

+ post_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ post_delete_reason varchar(255) DEFAULT '' NOT NULL,

+ post_delete_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY post_visibility (post_visibility),

+ topic_visibility tinyint(3) DEFAULT '0' NOT NULL,

+ topic_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_delete_reason varchar(255) DEFAULT '' NOT NULL,

+ topic_delete_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY topic_visibility (topic_visibility),

+ KEY forum_appr_last (forum_id, topic_visibility, topic_last_post_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)

+)

+/

+

+

+/*

+ forum_posts_approved number(8) DEFAULT '0' NOT NULL,

+ forum_posts_unapproved number(8) DEFAULT '0' NOT NULL,

+ forum_posts_softdeleted number(8) DEFAULT '0' NOT NULL,

+ forum_topics_approved number(8) DEFAULT '0' NOT NULL,

+ forum_topics_unapproved number(8) DEFAULT '0' NOT NULL,

+ forum_topics_softdeleted number(8) DEFAULT '0' NOT NULL,

+ post_visibility number(3) DEFAULT '0' NOT NULL,

+ post_delete_time number(11) DEFAULT '0' NOT NULL,

+ post_delete_reason varchar2(765) DEFAULT '' ,

+ post_delete_user number(8) DEFAULT '0' NOT NULL,

+CREATE INDEX phpbb_posts_post_visibility ON phpbb_posts (post_visibility)

+ topic_visibility number(3) DEFAULT '0' NOT NULL,

+ topic_posts_approved number(8) DEFAULT '0' NOT NULL,

+ topic_posts_unapproved number(8) DEFAULT '0' NOT NULL,

+ topic_posts_softdeleted number(8) DEFAULT '0' NOT NULL,

+ topic_delete_time number(11) DEFAULT '0' NOT NULL,

+ topic_delete_reason varchar2(765) DEFAULT '' ,

+ topic_delete_user number(8) DEFAULT '0' NOT NULL,

+CREATE INDEX phpbb_topics_topic_visibility ON phpbb_topics (topic_visibility)

+CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics (forum_id, topic_visibility, topic_last_post_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)

+);

+

+

+/*

+ forum_posts_approved INT4 DEFAULT '0' NOT NULL CHECK (forum_posts_approved >= 0),

+ forum_posts_unapproved INT4 DEFAULT '0' NOT NULL CHECK (forum_posts_unapproved >= 0),

+ forum_posts_softdeleted INT4 DEFAULT '0' NOT NULL CHECK (forum_posts_softdeleted >= 0),

+ forum_topics_approved INT4 DEFAULT '0' NOT NULL CHECK (forum_topics_approved >= 0),

+ forum_topics_unapproved INT4 DEFAULT '0' NOT NULL CHECK (forum_topics_unapproved >= 0),

+ forum_topics_softdeleted INT4 DEFAULT '0' NOT NULL CHECK (forum_topics_softdeleted >= 0),

+ post_visibility INT2 DEFAULT '0' NOT NULL,

+ post_delete_time INT4 DEFAULT '0' NOT NULL CHECK (post_delete_time >= 0),

+ post_delete_reason varchar(255) DEFAULT '' NOT NULL,

+ post_delete_user INT4 DEFAULT '0' NOT NULL CHECK (post_delete_user >= 0),

+CREATE INDEX phpbb_posts_post_visibility ON phpbb_posts (post_visibility);

+ topic_visibility INT2 DEFAULT '0' NOT NULL,

+ topic_posts_approved INT4 DEFAULT '0' NOT NULL CHECK (topic_posts_approved >= 0),

+ topic_posts_unapproved INT4 DEFAULT '0' NOT NULL CHECK (topic_posts_unapproved >= 0),

+ topic_posts_softdeleted INT4 DEFAULT '0' NOT NULL CHECK (topic_posts_softdeleted >= 0),

+ topic_delete_time INT4 DEFAULT '0' NOT NULL CHECK (topic_delete_time >= 0),

+ topic_delete_reason varchar(255) DEFAULT '' NOT NULL,

+ topic_delete_user INT4 DEFAULT '0' NOT NULL CHECK (topic_delete_user >= 0),

+CREATE INDEX phpbb_topics_topic_visibility ON phpbb_topics (topic_visibility);

+CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics (forum_id, topic_visibility, topic_last_post_id);

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('assets_version', '1');

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_pm', '0');

+INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_softdelete', 1);

+INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_softdelete', 1, 1);

+INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents) VALUES ('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 'Admin', 'AA0000', 972086460, '', '', '', '', '', '', '', 0, 0, '');

+INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_subject, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents, forum_flags) VALUES ('{L_FORUMS_TEST_FORUM_TITLE}', '{L_FORUMS_TEST_FORUM_DESC}', 2, 3, 1, 1, 1, 0, 0, 1, 0, 0, 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, '', '', '', '', '', '', '', 0, 0, '', 48);

+INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 12, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option IN ('m_', 'm_delete', 'm_softdelete', 'm_edit', 'm_info', 'm_report');

+INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, topic_views, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, forum_id, topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_first_poster_colour, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour, topic_last_post_subject, topic_last_post_time, topic_last_view_time, poll_title, topic_visibility) VALUES ('{L_TOPICS_TOPIC_TITLE}', 2, 972086460, 0, 1, 0, 0, 2, 0, 0, 1, 'Admin', 'AA0000', 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, 972086460, '', 1);

+INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, icon_id, post_time, post_username, poster_ip, post_subject, post_text, post_checksum, bbcode_uid, post_visibility) VALUES (1, 2, 2, 0, 972086460, '', '127.0.0.1', '{L_TOPICS_TOPIC_TITLE}', '{L_DEFAULT_INSTALL_POST}', '5dd683b17f641daf84c040bfefc58ce9', '', 1);

+# 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)

+);

+

+

+ forum_posts_approved INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ forum_posts_unapproved INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ forum_posts_softdeleted INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ forum_topics_approved INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ forum_topics_unapproved INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ forum_topics_softdeleted INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ post_visibility tinyint(3) NOT NULL DEFAULT '0',

+ post_edit_locked INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ post_delete_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ post_delete_reason text(65535) NOT NULL DEFAULT '',

+ post_delete_user INTEGER UNSIGNED NOT NULL DEFAULT '0'

+CREATE INDEX phpbb_posts_post_visibility ON phpbb_posts (post_visibility);

+ topic_visibility tinyint(3) NOT NULL DEFAULT '0',

+ topic_posts_approved INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ topic_posts_unapproved INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ topic_posts_softdeleted INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ poll_vote_change INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ topic_delete_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ topic_delete_reason text(65535) NOT NULL DEFAULT '',

+ topic_delete_user INTEGER UNSIGNED NOT NULL DEFAULT '0'

+CREATE INDEX phpbb_topics_topic_visibility ON phpbb_topics (topic_visibility);

+CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics (forum_id, topic_visibility, topic_last_post_id);