2 files changed, 0 insertions, 1958 deletions
diff --git a/phpBB/install/schemas/schema_data.php b/phpBB/install/schemas/schema_data.php
deleted file mode 100644
index 766a918340..0000000000
--- a/phpBB/install/schemas/schema_data.php
+++ /dev/null
@@ -1,877 +0,0 @@
-<?php
-
-$schema_data = $schema_updates = array();
-
-// We need some default increments first, so add them first
-
-// phpbb_styles_imageset
-$schema_data[] = array(
-	'table'		=> 'phpbb_styles_imageset',
-	'columns'	=> array('imageset_name', 'imageset_copyright', 'imageset_path'),
-	'data'		=> array(
-		array('prosilver', '&copy; phpBB Group', 'prosilver'),
-	),
-	'store_auto_increment'	=> 'IMAGESET_ID',
-);
-
-// phpbb_styles_template
-$schema_data[] = array(
-	'table'		=> 'phpbb_styles_template',
-	'columns'	=> array('template_name', 'template_copyright', 'template_path', 'bbcode_bitfield'),
-	'data'		=> array(
-		array('prosilver', '&copy; phpBB Group', 'prosilver', 'lNg='),
-	),
-	'store_auto_increment'	=> 'TEMPLATE_ID',
-);
-
-// phpbb_styles_theme
-$schema_data[] = array(
-	'table'		=> 'phpbb_styles_theme',
-	'columns'	=> array('theme_name', 'theme_copyright', 'theme_path', 'theme_storedb', 'theme_data'),
-	'data'		=> array(
-		array('prosilver', '&copy; phpBB Group', 'prosilver', 1, ''),
-	),
-	'store_auto_increment'	=> 'THEME_ID',
-);
-
-// phpbb_styles
-$schema_data[] = array(
-	'table'		=> 'phpbb_styles',
-	'columns'	=> array('style_name', 'style_copyright', 'style_active', 'template_id', 'theme_id', 'imageset_id'),
-	'data'		=> array(
-		array('prosilver', '&copy; phpBB Group', 1, array('auto_increment' => 'TEMPLATE_ID:0'), array('auto_increment' => 'THEME_ID:0'), array('auto_increment' => 'IMAGESET_ID:0')),
-	),
-	'store_auto_increment'	=> 'STYLE_ID',
-);
-
-// phpbb_config
-$schema_data[] = array(
-	'table'		=> 'phpbb_config',
-	'columns'	=> array('string:config_name', 'string:config_value'),
-	'data'		=> array(
-		array('active_sessions', '0'),
-		array('allow_attachments', '1'),
-		array('allow_autologin', '1'),
-		array('allow_avatar_local', '0'),
-		array('allow_avatar_remote', '0'),
-		array('allow_avatar_upload', '0'),
-		array('allow_bbcode', '1'),
-		array('allow_birthdays', '1'),
-		array('allow_bookmarks', '1'),
-		array('allow_emailreuse', '0'),
-		array('allow_forum_notify', '1'),
-		array('allow_mass_pm', '1'),
-		array('allow_name_chars', 'USERNAME_CHARS_ANY'),
-		array('allow_namechange', '0'),
-		array('allow_nocensors', '0'),
-		array('allow_pm_attach', '0'),
-		array('allow_post_flash', '1'),
-		array('allow_post_links', '1'),
-		array('allow_privmsg', '1'),
-		array('allow_sig', '1'),
-		array('allow_sig_bbcode', '1'),
-		array('allow_sig_flash', '0'),
-		array('allow_sig_img', '1'),
-		array('allow_sig_links', '1'),
-		array('allow_sig_pm', '1'),
-		array('allow_sig_smilies', '1'),
-		array('allow_smilies', '1'),
-		array('allow_topic_notify', '1'),
-		array('attachment_quota', '52428800'),
-		array('auth_bbcode_pm', '1'),
-		array('auth_flash_pm', '0'),
-		array('auth_img_pm', '1'),
-		array('auth_method', 'db'),
-		array('auth_smilies_pm', '1'),
-		array('avatar_filesize', '6144'),
-		array('avatar_gallery_path', 'images/avatars/gallery'),
-		array('avatar_max_height', '90'),
-		array('avatar_max_width', '90'),
-		array('avatar_min_height', '20'),
-		array('avatar_min_width', '20'),
-		array('avatar_path', 'images/avatars/upload'),
-		array('avatar_salt', '{AVATAR_SALT}'),
-		array('board_contact', '{BOARD_CONTACT}'),
-		array('board_disable', '0'),
-		array('board_disable_msg', ''),
-		array('board_dst', '0'),
-		array('board_email', '{BOARD_EMAIL}'),
-		array('board_email_from', '0'),
-		array('board_email_sig', '{L_CONFIG_BOARD_EMAIL_SIG}'),
-		array('board_hide_emails', '1'),
-		array('board_startdate', '{BOARD_STARTDATE}'),
-		array('board_timezone', '0'),
-		array('browser_check', '1'),
-		array('bump_interval', '10'),
-		array('bump_type', 'd'),
-		array('cache_gc', '7200'),
-		array('captcha_plugin', '{CAPTCHA_PLUGIN}'),
-		array('captcha_gd_foreground_noise', '0'),
-		array('captcha_gd_x_grid', '25'),
-		array('captcha_gd_y_grid', '25'),
-		array('captcha_gd_wave', '0'),
-		array('captcha_gd_3d_noise', '1'),
-		array('captcha_gd_fonts', '1'),
-		array('confirm_refresh', '1'),
-		array('check_attachment_content', '1'),
-		array('check_dnsbl', '0'),
-		array('chg_passforce', '0'),
-		array('cookie_domain', '{COOKIE_DOMAIN}'),
-		array('cookie_name', '{COOKIE_NAME}'),
-		array('cookie_path', '/'),
-		array('cookie_secure', '{COOKIE_SECURE}'),
-		array('coppa_enable', '0'),
-		array('coppa_fax', ''),
-		array('coppa_mail', ''),
-		array('database_gc', '604800'),
-		array('dbms_version', '{DBMS_VERSION}'),
-		array('default_dateformat', '{DEFAULT_DATEFORMAT}'),
-		array('default_lang', '{DEFAULT_LANG}'),
-		array('default_style', array('auto_increment' => 'STYLE_ID:0')),
-		array('display_last_edited', '1'),
-		array('display_order', '0'),
-		array('edit_time', '0'),
-		array('email_check_mx', '0'),
-		array('email_enable', '{EMAIL_ENABLE}'),
-		array('email_function_name', 'mail'),
-		array('email_package_size', '50'),
-		array('enable_confirm', '1'),
-		array('enable_pm_icons', '1'),
-		array('enable_post_confirm', '1'),
-		array('enable_queue_trigger', '0'),
-		array('flood_interval', '15'),
-		array('force_server_vars', '{FORCE_SERVER_VARS}'),
-		array('form_token_lifetime', '7200'),
-		array('form_token_mintime', '0'),
-		array('form_token_sid_guests', '1'),
-		array('forward_pm', '1'),
-		array('forwarded_for_check', '0'),
-		array('full_folder_action', '2'),
-		array('fulltext_mysql_max_word_len', '254'),
-		array('fulltext_mysql_min_word_len', '4'),
-		array('fulltext_native_common_thres', '5'),
-		array('fulltext_native_load_upd', '1'),
-		array('fulltext_native_max_chars', '14'),
-		array('fulltext_native_min_chars', '3'),
-		array('gzip_compress', '0'),
-		array('hot_threshold', '25'),
-		array('icons_path', 'images/icons'),
-		array('img_create_thumbnail', '0'),
-		array('img_display_inlined', '1'),
-		array('img_imagick', '{IMG_IMAGICK}'),
-		array('img_link_height', '0'),
-		array('img_link_width', '0'),
-		array('img_max_height', '0'),
-		array('img_max_thumb_width', '400'),
-		array('img_max_width', '0'),
-		array('img_min_thumb_filesize', '12000'),
-		array('ip_check', '3'),
-		array('jab_enable', '0'),
-		array('jab_host', ''),
-		array('jab_password', ''),
-		array('jab_package_size', '20'),
-		array('jab_port', '5222'),
-		array('jab_use_ssl', '0'),
-		array('jab_username', ''),
-		array('ldap_base_dn', ''),
-		array('ldap_email', ''),
-		array('ldap_password', ''),
-		array('ldap_port', ''),
-		array('ldap_server', ''),
-		array('ldap_uid', ''),
-		array('ldap_user', ''),
-		array('ldap_user_filter', ''),
-		array('limit_load', '0'),
-		array('limit_search_load', '0'),
-		array('load_anon_lastread', '0'),
-		array('load_birthdays', '1'),
-		array('load_cpf_memberlist', '0'),
-		array('load_cpf_viewprofile', '1'),
-		array('load_cpf_viewtopic', '0'),
-		array('load_db_lastread', '1'),
-		array('load_db_track', '1'),
-		array('load_jumpbox', '1'),
-		array('load_moderators', '1'),
-		array('load_online', '1'),
-		array('load_online_guests', '1'),
-		array('load_online_time', '5'),
-		array('load_online_track', '1'),
-		array('load_search', '1'),
-		array('load_tplcompile', '0'),
-		array('load_user_activity', '1'),
-		array('max_attachments', '3'),
-		array('max_attachments_pm', '1'),
-		array('max_autologin_time', '0'),
-		array('max_filesize', '262144'),
-		array('max_filesize_pm', '262144'),
-		array('max_login_attempts', '3'),
-		array('max_name_chars', '20'),
-		array('max_num_search_keywords', '10'),
-		array('max_pass_chars', '30'),
-		array('max_poll_options', '10'),
-		array('max_poll_chars', '60000'),
-		array('max_post_font_size', '200'),
-		array('max_post_img_height', '0'),
-		array('max_post_img_width', '0'),
-		array('max_post_smilies', '0'),
-		array('max_post_urls', '0'),
-		array('max_quote_depth', '3'),
-		array('max_reg_attempts', '5'),
-		array('max_sig_chars', '255'),
-		array('max_sig_font_size', '200'),
-		array('max_sig_img_height', '0'),
-		array('max_sig_img_width', '0'),
-		array('max_sig_smilies', '0'),
-		array('max_sig_urls', '5'),
-		array('min_name_chars', '3'),
-		array('min_pass_chars', '6'),
-		array('min_search_author_chars', '3'),
-		array('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title'),
-		array('override_user_style', '0'),
-		array('pass_complex', 'PASS_TYPE_ANY'),
-		array('pm_edit_time', '0'),
-		array('pm_max_boxes', '4'),
-		array('pm_max_msgs', '50'),
-		array('pm_max_recipients', '0'),
-		array('posts_per_page', '10'),
-		array('print_pm', '1'),
-		array('queue_interval', '600'),
-		array('queue_trigger_posts', '3'),
-		array('ranks_path', 'images/ranks'),
-		array('require_activation', '0'),
-		array('referer_validation', '{REFERER_VALIDATION}'),
-		array('script_path', '{SCRIPT_PATH}'),
-		array('search_block_size', '250'),
-		array('search_gc', '7200'),
-		array('search_indexing_state', ''),
-		array('search_interval', '0'),
-		array('search_anonymous_interval', '0'),
-		array('search_type', 'fulltext_native'),
-		array('search_store_results', '1800'),
-		array('secure_allow_deny', '1'),
-		array('secure_allow_empty_referer', '1'),
-		array('secure_downloads', '0'),
-		array('server_name', '{SERVER_NAME}'),
-		array('server_port', '{SERVER_PORT}'),
-		array('server_protocol', '{SERVER_PROTOCOL}'),
-		array('session_gc', '3600'),
-		array('session_length', '3600'),
-		array('site_desc', '{L_CONFIG_SITE_DESC}'),
-		array('sitename', '{L_CONFIG_SITENAME}'),
-		array('smilies_path', 'images/smilies'),
-		array('smtp_auth_method', '{SMTP_AUTH_METHOD}'),
-		array('smtp_delivery', '{SMTP_DELIVERY}'),
-		array('smtp_host', '{SMTP_HOST}'),
-		array('smtp_password', '{SMTP_PASSWORD}'),
-		array('smtp_port', '25'),
-		array('smtp_username', '{SMTP_USERNAME}'),
-		array('topics_per_page', '25'),
-		array('tpl_allow_php', '0'),
-		array('upload_icons_path', 'images/upload_icons'),
-		array('upload_path', 'files'),
-		array('version', '3.1.0-dev1'),
-		array('warnings_expire_days', '90'),
-		array('warnings_gc', '14400'),
-	),
-);
-
-// Ranks
-$schema_data[] = array(
-	'table'		=> 'phpbb_ranks',
-	'columns'	=> array('rank_title', 'rank_min', 'rank_special', 'rank_image'),
-	'data'		=> array(
-		array('{L_RANKS_SITE_ADMIN_TITLE}', 0, 1, ''),
-	),
-	'store_auto_increment'	=> 'RANK_ID',
-);
-
-// Groups
-$schema_data[] = array(
-	'table'		=> 'phpbb_groups',
-	'columns'	=> array('group_name', 'group_name_clean', 'group_type', 'group_founder_manage', 'group_colour', 'group_legend', 'group_avatar', 'group_desc', 'group_desc_uid', 'group_max_recipients'),
-	'data'		=> array(
-		array('GUESTS', 'guests', 3, 0, '', 0, '', '', '', 0),
-		array('REGISTERED', 'registered', 3, 0, '', 0, '', '', '', 5),
-		array('REGISTERED_COPPA', 'registered_coppa', 3, 0, '', 0, '', '', '', 5),
-		array('GLOBAL_MODERATORS', 'global_moderators', 3, 0, '00AA00', 1, '', '', '', 50),
-		array('ADMINISTRATORS', 'administrators', 3, 1, 'AA0000', 1, '', '', '', 50),
-		array('BOTS', 'bots', 3, 0, '9E8DA7', 0, '', '', '', 5),
-	),
-	'store_auto_increment'	=> 'GROUP_ID',
-);
-
-// Users
-$schema_data[] = array(
-	'table'		=> 'phpbb_users',
-	'columns'	=> array('user_type', 'group_id', 'username', 'username_clean', 'user_regdate', 'user_password', 'user_email', 'user_lang', 'user_style', 'user_rank', 'user_colour', 'user_posts', 'user_permissions', 'user_ip', 'user_birthday', 'user_lastpage', 'user_last_confirm_key', 'user_post_sortby_type', 'user_post_sortby_dir', 'user_topic_sortby_type', 'user_topic_sortby_dir', 'user_avatar', 'user_sig', 'user_sig_bbcode_uid', 'user_from', 'user_icq', 'user_aim', 'user_yim', 'user_msnm', 'user_jabber', 'user_website', 'user_occ', 'user_interests', 'user_actkey', 'user_newpasswd', 'user_allow_massemail', 'user_email_hash', 'user_dateformat'),
-	'data'		=> array(
-		// Anonymous
-		array(2, array('auto_increment' => 'GROUP_ID:0'), 'Anonymous', 'anonymous', '{CURRENT_TIME}', '', '', '{DEFAULT_LANG}', array('auto_increment' => 'STYLE_ID:0'), 0, '', 0, '', '{USER_IP}', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '{DEFAULT_DATEFORMAT}'),
-		// Admin
-		array(3, array('auto_increment' => 'GROUP_ID:4'), '{ADMIN_NAME}', '{ADMIN_NAME_CLEAN}', '{CURRENT_TIME}', '{ADMIN_PASSWORD}', '{ADMIN_EMAIL}', '{DEFAULT_LANG}', array('auto_increment' => 'STYLE_ID:0'), array('auto_increment' => 'RANK_ID:0'), 'AA0000', 1, '', '{USER_IP}', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, '{ADMIN_EMAIL_HASH}', '{DEFAULT_DATEFORMAT}'),
-	),
-	'store_auto_increment'	=> 'USER_ID',
-);
-
-// Dynamic config values
-$schema_data[] = array(
-	'table'		=> 'phpbb_config',
-	'columns'	=> array('string:config_name', 'string:config_value', 'is_dynamic'),
-	'data'		=> array(
-		array('cache_last_gc', '0', 1),
-		array('cron_lock', '0', 1),
-		array('database_last_gc', '0', 1),
-		array('last_queue_run', '0', 1),
-		array('newest_user_colour', 'AA0000', 1),
-		array('newest_user_id', array('auto_increment' => 'USER_ID:1'), 1),
-		array('newest_username', '{NEWEST_USERNAME}', 1),
-		array('num_files', '0', 1),
-		array('num_posts', '1', 1),
-		array('num_topics', '1', 1),
-		array('num_users', '1', 1),
-		array('rand_seed', '0', 1),
-		array('rand_seed_last_update', '0', 1),
-		array('record_online_date', '0', 1),
-		array('record_online_users', '0', 1),
-		array('search_last_gc', '0', 1),
-		array('session_last_gc', '0', 1),
-		array('upload_dir_size', '0', 1),
-		array('warnings_last_gc', '0', 1),
-	),
-);
-
-// Forums
-$schema_data[] = array(
-	'table'		=> 'phpbb_forums',
-	'columns'	=> array('forum_name', 'forum_desc', 'left_id', 'right_id', 'parent_id', 'forum_type', 'forum_posts', 'forum_topics', 'forum_topics_real', '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'),
-	'data'		=> array(
-		array('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 1, 1, 1, 0, array('auto_increment' => 'USER_ID:1'), '{ADMIN_NAME}', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', '{CURRENT_TIME}', '', '', '', '', '', '', '', 0, 0, ''),
-		array('{L_FORUMS_TEST_FORUM_TITLE}', '{L_FORUMS_TEST_FORUM_DESC}', 2, 3, array('auto_increment' => 'FORUM_ID:0'), 1, 1, 1, 1, 0, array('auto_increment' => 'USER_ID:1'), '{ADMIN_NAME}', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', '{CURRENT_TIME}', '', '', '', '', '', '', '', 0, 0, ''),
-	),
-	'store_auto_increment' => 'FORUM_ID',
-);
-
-// Demo Topic
-$schema_data[] = array(
-	'table'		=> 'phpbb_topics',
-	'columns'	=> array('topic_title', 'topic_poster', 'topic_time', 'topic_views', 'topic_replies', 'topic_replies_real', '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'),
-	'data'		=> array(
-		array('{L_TOPICS_TOPIC_TITLE}', array('auto_increment' => 'USER_ID:1'), '{CURRENT_TIME}', 0, 0, 0, array('auto_increment' => 'FORUM_ID:1'), 0, 0, 0, '{ADMIN_NAME}', 'AA0000', 0, array('auto_increment' => 'USER_ID:1'), '{ADMIN_NAME}', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', '{CURRENT_TIME}', 0, ''),
-	),
-	'store_auto_increment' => 'TOPIC_ID',
-);
-
-// Demo Post
-$schema_data[] = array(
-	'table'		=> 'phpbb_posts',
-	'columns'	=> array('topic_id', 'forum_id', 'poster_id', 'icon_id', 'post_time', 'post_username', 'poster_ip', 'post_subject', 'post_text', 'post_checksum', 'bbcode_uid'),
-	'data'		=> array(
-		array(array('auto_increment' => 'TOPIC_ID:0'), array('auto_increment' => 'FORUM_ID:1'), array('auto_increment' => 'USER_ID:1'), 0, '{CURRENT_TIME}', '', '{USER_IP}', '{L_TOPICS_TOPIC_TITLE}', '{L_DEFAULT_INSTALL_POST}', '', ''),
-	),
-	'store_auto_increment' => 'POST_ID',
-);
-
-// Admin posted to the demo topic
-$schema_data[] = array(
-	'table'		=> 'phpbb_topics_posted',
-	'columns'	=> array('user_id', 'topic_id', 'topic_posted'),
-	'data'		=> array(
-		array(array('auto_increment' => 'USER_ID:1'), array('auto_increment' => 'TOPIC_ID:0'), 1),
-	),
-);
-
-// Update forums table
-$schema_updates[] = array(
-	'table'		=> 'phpbb_forums',
-	'columns'	=> array('forum_last_post_id'),
-	'data'		=> array(array('auto_increment' => 'POST_ID:0')),
-);
-
-// Update topics table
-$schema_updates[] = array(
-	'table'		=> 'phpbb_topics',
-	'columns'	=> array('topic_first_post_id', 'topic_last_post_id'),
-	'data'		=> array(array('auto_increment' => 'POST_ID:0'), array('auto_increment' => 'POST_ID:0')),
-	'where'		=> array(
-		array('topic_id' => array('auto_increment' => 'TOPIC_ID:0')),
-	),
-);
-
-// User -> Group
-$schema_data[] = array(
-	'table'		=> 'phpbb_user_group',
-	'columns'	=> array('group_id', 'user_id', 'user_pending', 'group_leader'),
-	'data'		=> array(
-		array(array('auto_increment' => 'GROUP_ID:0'), array('auto_increment' => 'USER_ID:0'), 0, 0),
-		array(array('auto_increment' => 'GROUP_ID:1'), array('auto_increment' => 'USER_ID:1'), 0, 0),
-		array(array('auto_increment' => 'GROUP_ID:3'), array('auto_increment' => 'USER_ID:1'), 0, 0),
-		array(array('auto_increment' => 'GROUP_ID:4'), array('auto_increment' => 'USER_ID:1'), 0, 1),
-	),
-);
-
-// Forum related auth options
-$schema_data[] = array(
-	'table'		=> 'phpbb_acl_options',
-	'columns'	=> array('auth_option', 'is_local', 'is_global'),
-	'data'		=> array(
-		array('f_', 1, 0),
-		array('f_announce', 1, 0),
-		array('f_attach', 1, 0),
-		array('f_bbcode', 1, 0),
-		array('f_bump', 1, 0),
-		array('f_delete', 1, 0),
-		array('f_download', 1, 0),
-		array('f_edit', 1, 0),
-		array('f_email', 1, 0),
-		array('f_flash', 1, 0),
-		array('f_icons', 1, 0),
-		array('f_ignoreflood', 1, 0),
-		array('f_img', 1, 0),
-		array('f_list', 1, 0),
-		array('f_noapprove', 1, 0),
-		array('f_poll', 1, 0),
-		array('f_post', 1, 0),
-		array('f_postcount', 1, 0),
-		array('f_print', 1, 0),
-		array('f_read', 1, 0),
-		array('f_reply', 1, 0),
-		array('f_report', 1, 0),
-		array('f_search', 1, 0),
-		array('f_sigs', 1, 0),
-		array('f_smilies', 1, 0),
-		array('f_sticky', 1, 0),
-		array('f_subscribe', 1, 0),
-		array('f_user_lock', 1, 0),
-		array('f_vote', 1, 0),
-		array('f_votechg', 1, 0),
-
-		// Moderator related auth options
-		array('m_', 1, 1),
-		array('m_approve', 1, 1),
-		array('m_chgposter', 1, 1),
-		array('m_delete', 1, 1),
-		array('m_edit', 1, 1),
-		array('m_info', 1, 1),
-		array('m_lock', 1, 1),
-		array('m_merge', 1, 1),
-		array('m_move', 1, 1),
-		array('m_report', 1, 1),
-		array('m_split', 1, 1),
-
-		// Global moderator auth option (not a local option)
-		array('m_ban', 0, 1),
-		array('m_warn', 0, 1),
-
-		// Admin related auth options
-		array('a_', 0, 1),
-		array('a_aauth', 0, 1),
-		array('a_attach', 0, 1),
-		array('a_authgroups', 0, 1),
-		array('a_authusers', 0, 1),
-		array('a_backup', 0, 1),
-		array('a_ban', 0, 1),
-		array('a_bbcode', 0, 1),
-		array('a_board', 0, 1),
-		array('a_bots', 0, 1),
-		array('a_clearlogs', 0, 1),
-		array('a_email', 0, 1),
-		array('a_fauth', 0, 1),
-		array('a_forum', 0, 1),
-		array('a_forumadd', 0, 1),
-		array('a_forumdel', 0, 1),
-		array('a_group', 0, 1),
-		array('a_groupadd', 0, 1),
-		array('a_groupdel', 0, 1),
-		array('a_icons', 0, 1),
-		array('a_jabber', 0, 1),
-		array('a_language', 0, 1),
-		array('a_mauth', 0, 1),
-		array('a_modules', 0, 1),
-		array('a_names', 0, 1),
-		array('a_phpinfo', 0, 1),
-		array('a_profile', 0, 1),
-		array('a_prune', 0, 1),
-		array('a_ranks', 0, 1),
-		array('a_reasons', 0, 1),
-		array('a_roles', 0, 1),
-		array('a_search', 0, 1),
-		array('a_server', 0, 1),
-		array('a_styles', 0, 1),
-		array('a_switchperm', 0, 1),
-		array('a_uauth', 0, 1),
-		array('a_user', 0, 1),
-		array('a_userdel', 0, 1),
-		array('a_viewauth', 0, 1),
-		array('a_viewlogs', 0, 1),
-		array('a_words', 0, 1),
-
-		// User related auth options
-		array('u_', 0, 1),
-		array('u_attach', 0, 1),
-		array('u_chgavatar', 0, 1),
-		array('u_chgcensors', 0, 1),
-		array('u_chgemail', 0, 1),
-		array('u_chggrp', 0, 1),
-		array('u_chgname', 0, 1),
-		array('u_chgpasswd', 0, 1),
-		array('u_download', 0, 1),
-		array('u_hideonline', 0, 1),
-		array('u_ignoreflood', 0, 1),
-		array('u_masspm', 0, 1),
-		array('u_masspm_group', 0, 1),
-		array('u_pm_attach', 0, 1),
-		array('u_pm_bbcode', 0, 1),
-		array('u_pm_delete', 0, 1),
-		array('u_pm_download', 0, 1),
-		array('u_pm_edit', 0, 1),
-		array('u_pm_emailpm', 0, 1),
-		array('u_pm_flash', 0, 1),
-		array('u_pm_forward', 0, 1),
-		array('u_pm_img', 0, 1),
-		array('u_pm_printpm', 0, 1),
-		array('u_pm_smilies', 0, 1),
-		array('u_readpm', 0, 1),
-		array('u_savedrafts', 0, 1),
-		array('u_search', 0, 1),
-		array('u_sendemail', 0, 1),
-		array('u_sendim', 0, 1),
-		array('u_sendpm', 0, 1),
-		array('u_sig', 0, 1),
-		array('u_viewonline', 0, 1),
-		array('u_viewprofile', 0, 1),
-	),
-	'store_auto_increment'	=> 'AUTH_OPTION_ID',
-);
-
-// standard auth roles
-$schema_data[] = array(
-	'table'		=> 'phpbb_acl_roles',
-	'columns'	=> array('role_name', 'role_description', 'role_type', 'role_order'),
-	'data'		=> array(
-		array('ROLE_ADMIN_STANDARD', 'ROLE_DESCRIPTION_ADMIN_STANDARD', 'a_', 1),
-		array('ROLE_ADMIN_FORUM', 'ROLE_DESCRIPTION_ADMIN_FORUM', 'a_', 3),
-		array('ROLE_ADMIN_USERGROUP', 'ROLE_DESCRIPTION_ADMIN_USERGROUP', 'a_', 4),
-		array('ROLE_ADMIN_FULL', 'ROLE_DESCRIPTION_ADMIN_FULL', 'a_', 2),
-		array('ROLE_USER_FULL', 'ROLE_DESCRIPTION_USER_FULL', 'u_', 3),
-		array('ROLE_USER_STANDARD', 'ROLE_DESCRIPTION_USER_STANDARD', 'u_', 1),
-		array('ROLE_USER_LIMITED', 'ROLE_DESCRIPTION_USER_LIMITED', 'u_', 2),
-		array('ROLE_USER_NOPM', 'ROLE_DESCRIPTION_USER_NOPM', 'u_', 4),
-		array('ROLE_USER_NOAVATAR', 'ROLE_DESCRIPTION_USER_NOAVATAR', 'u_', 5),
-		array('ROLE_MOD_FULL', 'ROLE_DESCRIPTION_MOD_FULL', 'm_', 3),
-		array('ROLE_MOD_STANDARD', 'ROLE_DESCRIPTION_MOD_STANDARD', 'm_', 1),
-		array('ROLE_MOD_SIMPLE', 'ROLE_DESCRIPTION_MOD_SIMPLE', 'm_', 2),
-		array('ROLE_MOD_QUEUE', 'ROLE_DESCRIPTION_MOD_QUEUE', 'm_', 4),
-		array('ROLE_FORUM_FULL', 'ROLE_DESCRIPTION_FORUM_FULL', 'f_', 7),
-		array('ROLE_FORUM_STANDARD', 'ROLE_DESCRIPTION_FORUM_STANDARD', 'f_', 5),
-		array('ROLE_FORUM_NOACCESS', 'ROLE_DESCRIPTION_FORUM_NOACCESS', 'f_', 1),
-		array('ROLE_FORUM_READONLY', 'ROLE_DESCRIPTION_FORUM_READONLY', 'f_', 2),
-		array('ROLE_FORUM_LIMITED', 'ROLE_DESCRIPTION_FORUM_LIMITED', 'f_', 3),
-		array('ROLE_FORUM_BOT', 'ROLE_DESCRIPTION_FORUM_BOT', 'f_', 9),
-		array('ROLE_FORUM_ONQUEUE', 'ROLE_DESCRIPTION_FORUM_ONQUEUE', 'f_', 8),
-		array('ROLE_FORUM_POLLS', 'ROLE_DESCRIPTION_FORUM_POLLS', 'f_', 6),
-		array('ROLE_FORUM_LIMITED_POLLS', 'ROLE_DESCRIPTION_FORUM_LIMITED_POLLS', 'f_', 4),
-		array('ROLE_USER_GUESTS', 'ROLE_DESCRIPTION_USER_GUESTS', 'u_', 6),
-	),
-	'store_auto_increment'	=> 'ROLE_ID',
-);
-
-// Permissions
-
-$schema_data[] = array(
-	'table'		=> 'phpbb_acl_groups',
-	'columns'	=> array('group_id', 'forum_id', 'auth_option_id', 'auth_role_id', 'auth_setting'),
-	'data'		=> array(
-		// GUESTS - u_download and u_search ability
-		array(array('auto_increment' => 'GROUP_ID:0'), 0, 0, array('auto_increment' => 'ROLE_ID:22'), 0),
-		// ADMINISTRATOR Group - full user features
-		array(array('auto_increment' => 'GROUP_ID:4'), 0, 0, array('auto_increment' => 'ROLE_ID:4'), 0),
-		// ADMINISTRATOR Group - standard admin
-		array(array('auto_increment' => 'GROUP_ID:4'), 0, 0, array('auto_increment' => 'ROLE_ID:0'), 0),
-		// REGISTERED and REGISTERED_COPPA having standard user features
-		array(array('auto_increment' => 'GROUP_ID:1'), 0, 0, array('auto_increment' => 'ROLE_ID:5'), 0),
-		array(array('auto_increment' => 'GROUP_ID:2'), 0, 0, array('auto_increment' => 'ROLE_ID:5'), 0),
-		// GLOBAL_MODERATORS having full user features
-		array(array('auto_increment' => 'GROUP_ID:3'), 0, 0, array('auto_increment' => 'ROLE_ID:4'), 0),
-		// GLOBAL_MODERATORS having full global moderator access
-		array(array('auto_increment' => 'GROUP_ID:3'), 0, 0, array('auto_increment' => 'ROLE_ID:9'), 0),
-
-		// Giving all groups read only access to the first category
-		// since administrators and moderators are already within the registered users group we do not need to set them here
-		array(array('auto_increment' => 'GROUP_ID:0'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
-		array(array('auto_increment' => 'GROUP_ID:1'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
-		array(array('auto_increment' => 'GROUP_ID:2'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
-		array(array('auto_increment' => 'GROUP_ID:5'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
-
-		// Giving access to the first forum
-		// guests having read only access
-		array(array('auto_increment' => 'GROUP_ID:0'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
-		// registered and registered_coppa having standard access
-		array(array('auto_increment' => 'GROUP_ID:1'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:14'), 0),
-		array(array('auto_increment' => 'GROUP_ID:2'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:14'), 0),
-		// global moderators having standard access + polls
-		array(array('auto_increment' => 'GROUP_ID:3'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:20'), 0),
-		// administrators having full forum and full moderator access
-		array(array('auto_increment' => 'GROUP_ID:4'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:13'), 0),
-		array(array('auto_increment' => 'GROUP_ID:4'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:9'), 0),
-		// Bots having bot access
-		array(array('auto_increment' => 'GROUP_ID:5'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:18'), 0),
-	),
-);
-
-// phpbb_styles_imageset_data
-$schema_data[] = array(
-	'table'		=> 'phpbb_styles_imageset_data',
-	'columns'	=> array('image_name', 'image_filename', 'image_lang', 'image_height', 'image_width', 'imageset_id'),
-	'data'		=> array(
-		array('site_logo', 'site_logo.gif', '', 52, 139, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('forum_link', 'forum_link.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('forum_read', 'forum_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('forum_read_locked', 'forum_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('forum_read_subforum', 'forum_read_subforum.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('forum_unread', 'forum_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('forum_unread_locked', 'forum_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('forum_unread_subforum', 'forum_unread_subforum.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_moved', 'topic_moved.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_read', 'topic_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_read_mine', 'topic_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_read_hot', 'topic_read_hot.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_read_hot_mine', 'topic_read_hot_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_read_locked', 'topic_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_read_locked_mine', 'topic_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_unread', 'topic_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_unread_mine', 'topic_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_unread_hot', 'topic_unread_hot.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_unread_hot_mine', 'topic_unread_hot_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_unread_locked', 'topic_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('topic_unread_locked_mine', 'topic_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_read', 'sticky_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_read_mine', 'sticky_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_read_locked', 'sticky_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_read_locked_mine', 'sticky_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_unread', 'sticky_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_unread_mine', 'sticky_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_unread_locked', 'sticky_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('sticky_unread_locked_mine', 'sticky_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_read', 'announce_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_read_mine', 'announce_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_read_locked', 'announce_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_unread', 'announce_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_unread_mine', 'announce_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_unread_locked', 'announce_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('announce_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_read', 'announce_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_read_mine', 'announce_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_read_locked', 'announce_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_unread', 'announce_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_unread_mine', 'announce_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_unread_locked', 'announce_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('global_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('pm_read', 'topic_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('pm_unread', 'topic_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_back_top', 'icon_back_top.gif', '', 11, 11, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_contact_aim', 'icon_contact_aim.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_contact_email', 'icon_contact_email.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_contact_icq', 'icon_contact_icq.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_contact_jabber', 'icon_contact_jabber.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_contact_msnm', 'icon_contact_msnm.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_contact_www', 'icon_contact_www.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_contact_yahoo', 'icon_contact_yahoo.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_post_delete', 'icon_post_delete.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_post_info', 'icon_post_info.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_post_report', 'icon_post_report.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_post_target', 'icon_post_target.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_post_target_unread', 'icon_post_target_unread.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_topic_attach', 'icon_topic_attach.gif', '', 10, 7, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_topic_latest', 'icon_topic_latest.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_topic_newest', 'icon_topic_newest.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_topic_reported', 'icon_topic_reported.gif', '', 14, 16, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_topic_unapproved', 'icon_topic_unapproved.gif', '', 14, 16, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('icon_user_warn', 'icon_user_warn.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('subforum_read', 'subforum_read.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
-		array('subforum_unread', 'subforum_unread.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
-	),
-);
-
-// Smilies
-$schema_data[] = array(
-	'table'		=> 'phpbb_smilies',
-	'columns'	=> array('code', 'smiley_url', 'emotion', 'smiley_width', 'smiley_height', 'smiley_order'),
-	'data'		=> array(
-		array(':D', 'icon_e_biggrin.gif', '{L_SMILIES_VERY_HAPPY}', 15, 17, 1),
-		array(':-D', 'icon_e_biggrin.gif', '{L_SMILIES_VERY_HAPPY}', 15, 17, 2),
-		array(':grin:', 'icon_e_biggrin.gif', '{L_SMILIES_VERY_HAPPY}', 15, 17, 3),
-		array(':)', 'icon_e_smile.gif', '{L_SMILIES_SMILE}', 15, 17, 4),
-		array(':-)', 'icon_e_smile.gif', '{L_SMILIES_SMILE}', 15, 17, 5),
-		array(':smile:', 'icon_e_smile.gif', '{L_SMILIES_SMILE}', 15, 17, 6),
-		array(';)', 'icon_e_wink.gif', '{L_SMILIES_WINK}', 15, 17, 7),
-		array(';-)', 'icon_e_wink.gif', '{L_SMILIES_WINK}', 15, 17, 8),
-		array(':wink:', 'icon_e_wink.gif', '{L_SMILIES_WINK}', 15, 17, 9),
-		array(':(', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 10),
-		array(':-(', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 11),
-		array(':sad:', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 12),
-		array(':o', 'icon_e_surprised.gif', '{L_SMILIES_SURPRISED}', 15, 17, 13),
-		array(':-o', 'icon_e_surprised.gif', '{L_SMILIES_SURPRISED}', 15, 17, 14),
-		array(':eek:', 'icon_e_surprised.gif', '{L_SMILIES_SURPRISED}', 15, 17, 15),
-		array(':shock:', 'icon_eek.gif', '{L_SMILIES_SHOCKED}', 15, 17, 16),
-		array(':?', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 17),
-		array(':-?', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 18),
-		array(':???:', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 19),
-		array('8-)', 'icon_cool.gif', '{L_SMILIES_COOL}', 15, 17, 20),
-		array(':cool:', 'icon_cool.gif', '{L_SMILIES_COOL}', 15, 17, 21),
-		array(':lol:', 'icon_lol.gif', '{L_SMILIES_LAUGHING}', 15, 17, 22),
-		array(':x', 'icon_mad.gif', '{L_SMILIES_MAD}', 15, 17, 23),
-		array(':-x', 'icon_mad.gif', '{L_SMILIES_MAD}', 15, 17, 24),
-		array(':mad:', 'icon_mad.gif', '{L_SMILIES_MAD}', 15, 17, 25),
-		array(':P', 'icon_razz.gif', '{L_SMILIES_RAZZ}', 15, 17, 26),
-		array(':-P', 'icon_razz.gif', '{L_SMILIES_RAZZ}', 15, 17, 27),
-		array(':razz:', 'icon_razz.gif', '{L_SMILIES_RAZZ}', 15, 17, 28),
-		array(':oops:', 'icon_redface.gif', '{L_SMILIES_EMARRASSED}', 15, 17, 29),
-		array(':cry:', 'icon_cry.gif', '{L_SMILIES_CRYING}', 15, 17, 30),
-		array(':evil:', 'icon_evil.gif', '{L_SMILIES_EVIL}', 15, 17, 31),
-		array(':twisted:', 'icon_twisted.gif', '{L_SMILIES_TWISTED_EVIL}', 15, 17, 32),
-		array(':roll:', 'icon_rolleyes.gif', '{L_SMILIES_ROLLING_EYES}', 15, 17, 33),
-		array(':!:', 'icon_exclaim.gif', '{L_SMILIES_EXCLAMATION}', 15, 17, 34),
-		array(':?:', 'icon_question.gif', '{L_SMILIES_QUESTION}', 15, 17, 35),
-		array(':idea:', 'icon_idea.gif', '{L_SMILIES_IDEA}', 15, 17, 36),
-		array(':arrow:', 'icon_arrow.gif', '{L_SMILIES_ARROW}', 15, 17, 37),
-		array(':|', 'icon_neutral.gif', '{L_SMILIES_NEUTRAL}', 15, 17, 38),
-		array(':-|', 'icon_neutral.gif', '{L_SMILIES_NEUTRAL}', 15, 17, 39),
-		array(':mrgreen:', 'icon_mrgreen.gif', '{L_SMILIES_MR_GREEN}', 15, 17, 40),
-		array(':geek:', 'icon_e_geek.gif', '{L_SMILIES_GEEK}', 17, 17, 41),
-		array(':ugeek:', 'icon_e_ugeek.gif', '{L_SMILIES_UBER_GEEK}', 17, 18, 42),
-	),
-);
-
-// icons
-$schema_data[] = array(
-	'table'		=> 'phpbb_icons',
-	'columns'	=> array('icons_url', 'icons_width', 'icons_height', 'icons_order', 'display_on_posting'),
-	'data'		=> array(
-		array('misc/fire.gif', 16, 16, 1, 1),
-		array('smile/redface.gif', 16, 16, 9, 1),
-		array('smile/mrgreen.gif', 16, 16, 10, 1),
-		array('misc/heart.gif', 16, 16, 4, 1),
-		array('misc/star.gif', 16, 16, 2, 1),
-		array('misc/radioactive.gif', 16, 16, 3, 1),
-		array('misc/thinking.gif', 16, 16, 5, 1),
-		array('smile/info.gif', 16, 16, 8, 1),
-		array('smile/question.gif', 16, 16, 6, 1),
-		array('smile/alert.gif', 16, 16, 7, 1),
-	),
-);
-
-// reasons
-$schema_data[] = array(
-	'table'		=> 'phpbb_reports_reasons',
-	'columns'	=> array('reason_title', 'reason_description', 'reason_order'),
-	'data'		=> array(
-		array('warez', '{L_REPORT_WAREZ}', 1),
-		array('spam', '{L_REPORT_SPAM}', 2),
-		array('off_topic', '{L_REPORT_OFF_TOPIC}', 3),
-		array('other', '{L_REPORT_OTHER}', 4),
-	),
-);
-
-// extension_groups
-$schema_data[] = array(
-	'table'		=> 'phpbb_extension_groups',
-	'columns'	=> array('group_name', 'cat_id', 'allow_group', 'download_mode', 'upload_icon', 'max_filesize', 'allowed_forums'),
-	'data'		=> array(
-		array('{L_EXT_GROUP_IMAGES}', 1, 1, 1, '', 0, ''),
-		array('{L_EXT_GROUP_ARCHIVES}', 0, 1, 1, '', 0, ''),
-		array('{L_EXT_GROUP_PLAIN_TEXT}', 0, 0, 1, '', 0, ''),
-		array('{L_EXT_GROUP_DOCUMENTS}', 0, 0, 1, '', 0, ''),
-		array('{L_EXT_GROUP_REAL_MEDIA}', 3, 0, 1, '', 0, ''),
-		array('{L_EXT_GROUP_WINDOWS_MEDIA}', 2, 0, 1, '', 0, ''),
-		array('{L_EXT_GROUP_FLASH_FILES}', 5, 0, 1, '', 0, ''),
-		array('{L_EXT_GROUP_QUICKTIME_MEDIA}', 6, 0, 1, '', 0, ''),
-		array('{L_EXT_GROUP_DOWNLOADABLE_FILES}', 0, 0, 1, '', 0, ''),
-	),
-	'store_auto_increment'	=> 'EXT_GROUP_ID',
-);
-
-// extensions
-$schema_data[] = array(
-	'table'		=> 'phpbb_extensions',
-	'columns'	=> array('group_id', 'extension'),
-	'data'		=> array(
-		array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'gif'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'png'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'jpeg'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'jpg'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'tif'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'tiff'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'tga'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'gtar'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'gz'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'tar'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'zip'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'rar'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'ace'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'torrent'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'tgz'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'bz2'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:1'), '7z'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'txt'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'c'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'h'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'cpp'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'hpp'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'diz'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'csv'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'ini'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'log'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'js'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'xml'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xls'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xlsx'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xlsm'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xlsb'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'doc'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'docx'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'docm'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'dot'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'dotx'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'dotm'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'pdf'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ai'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ps'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ppt'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'pptx'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'pptm'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'odg'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'odp'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ods'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'odt'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'rtf'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:4'), 'rm'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:4'), 'ram'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:5'), 'wma'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:5'), 'wmv'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:6'), 'swf'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'mov'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'm4v'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'm4a'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'mp4'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:7'), '3gp'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:7'), '3g2'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'qt'),
-
-		array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'mpeg'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'mpg'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'mp3'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'ogg'),
-		array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'ogm'),
-	),
-);
-
-?>
-\ No newline at end of file
diff --git a/phpBB/install/schemas/schema_structure.php b/phpBB/install/schemas/schema_structure.php
deleted file mode 100644
index 641fafc4ac..0000000000
--- a/phpBB/install/schemas/schema_structure.php
+++ /dev/null
@@ -1,1081 +0,0 @@
-<?php
-
-$schema_data = array();
-
-$schema_data['phpbb_attachments'] = array(
-	'COLUMNS'		=> array(
-		'attach_id'			=> array('UINT', NULL, 'auto_increment'),
-		'post_msg_id'		=> array('UINT', 0),
-		'topic_id'			=> array('UINT', 0),
-		'in_message'		=> array('BOOL', 0),
-		'poster_id'			=> array('UINT', 0),
-		'is_orphan'			=> array('BOOL', 1),
-		'physical_filename'	=> array('VCHAR', ''),
-		'real_filename'		=> array('VCHAR', ''),
-		'download_count'	=> array('UINT', 0),
-		'attach_comment'	=> array('TEXT_UNI', ''),
-		'extension'			=> array('VCHAR:100', ''),
-		'mimetype'			=> array('VCHAR:100', ''),
-		'filesize'			=> array('UINT:20', 0),
-		'filetime'			=> array('TIMESTAMP', 0),
-		'thumbnail'			=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> 'attach_id',
-	'KEYS'			=> array(
-		'filetime'			=> array('INDEX', 'filetime'),
-		'post_msg_id'		=> array('INDEX', 'post_msg_id'),
-		'topic_id'			=> array('INDEX', 'topic_id'),
-		'poster_id'			=> array('INDEX', 'poster_id'),
-		'is_orphan'			=> array('INDEX', 'is_orphan'),
-	),
-);
-
-$schema_data['phpbb_acl_groups'] = array(
-	'COLUMNS'		=> array(
-		'group_id'			=> array('UINT', 0),
-		'forum_id'			=> array('UINT', 0),
-		'auth_option_id'	=> array('UINT', 0),
-		'auth_role_id'		=> array('UINT', 0),
-		'auth_setting'		=> array('TINT:2', 0),
-	),
-	'KEYS'			=> array(
-		'group_id'		=> array('INDEX', 'group_id'),
-		'auth_opt_id'	=> array('INDEX', 'auth_option_id'),
-		'auth_role_id'	=> array('INDEX', 'auth_role_id'),
-	),
-);
-
-$schema_data['phpbb_acl_options'] = array(
-	'COLUMNS'		=> array(
-		'auth_option_id'	=> array('UINT', NULL, 'auto_increment'),
-		'auth_option'		=> array('VCHAR:50', ''),
-		'is_global'			=> array('BOOL', 0),
-		'is_local'			=> array('BOOL', 0),
-		'founder_only'		=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> 'auth_option_id',
-	'KEYS'			=> array(
-		'auth_option'		=> array('UNIQUE', 'auth_option'),
-	),
-);
-
-$schema_data['phpbb_acl_roles'] = array(
-	'COLUMNS'		=> array(
-		'role_id'			=> array('UINT', NULL, 'auto_increment'),
-		'role_name'			=> array('VCHAR_UNI', ''),
-		'role_description'	=> array('TEXT_UNI', ''),
-		'role_type'			=> array('VCHAR:10', ''),
-		'role_order'		=> array('USINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'role_id',
-	'KEYS'			=> array(
-		'role_type'			=> array('INDEX', 'role_type'),
-		'role_order'		=> array('INDEX', 'role_order'),
-	),
-);
-
-$schema_data['phpbb_acl_roles_data'] = array(
-	'COLUMNS'		=> array(
-		'role_id'			=> array('UINT', 0),
-		'auth_option_id'	=> array('UINT', 0),
-		'auth_setting'		=> array('TINT:2', 0),
-	),
-	'PRIMARY_KEY'	=> array('role_id', 'auth_option_id'),
-	'KEYS'			=> array(
-		'ath_op_id'			=> array('INDEX', 'auth_option_id'),
-	),
-);
-
-$schema_data['phpbb_acl_users'] = array(
-	'COLUMNS'		=> array(
-		'user_id'			=> array('UINT', 0),
-		'forum_id'			=> array('UINT', 0),
-		'auth_option_id'	=> array('UINT', 0),
-		'auth_role_id'		=> array('UINT', 0),
-		'auth_setting'		=> array('TINT:2', 0),
-	),
-	'KEYS'			=> array(
-		'user_id'			=> array('INDEX', 'user_id'),
-		'auth_option_id'	=> array('INDEX', 'auth_option_id'),
-		'auth_role_id'		=> array('INDEX', 'auth_role_id'),
-	),
-);
-
-$schema_data['phpbb_banlist'] = array(
-	'COLUMNS'		=> array(
-		'ban_id'			=> array('UINT', NULL, 'auto_increment'),
-		'ban_userid'		=> array('UINT', 0),
-		'ban_ip'			=> array('VCHAR:40', ''),
-		'ban_email'			=> array('VCHAR_UNI:100', ''),
-		'ban_start'			=> array('TIMESTAMP', 0),
-		'ban_end'			=> array('TIMESTAMP', 0),
-		'ban_exclude'		=> array('BOOL', 0),
-		'ban_reason'		=> array('VCHAR_UNI', ''),
-		'ban_give_reason'	=> array('VCHAR_UNI', ''),
-	),
-	'PRIMARY_KEY'			=> 'ban_id',
-	'KEYS'			=> array(
-		'ban_end'			=> array('INDEX', 'ban_end'),
-		'ban_user'			=> array('INDEX', array('ban_userid', 'ban_exclude')),
-		'ban_email'			=> array('INDEX', array('ban_email', 'ban_exclude')),
-		'ban_ip'			=> array('INDEX', array('ban_ip', 'ban_exclude')),
-	),
-);
-
-$schema_data['phpbb_bbcodes'] = array(
-	'COLUMNS'		=> array(
-		'bbcode_id'				=> array('TINT:3', 0),
-		'bbcode_tag'			=> array('VCHAR:16', ''),
-		'bbcode_helpline'		=> array('VCHAR_UNI', ''),
-		'display_on_posting'	=> array('BOOL', 0),
-		'bbcode_match'			=> array('TEXT_UNI', ''),
-		'bbcode_tpl'			=> array('MTEXT_UNI', ''),
-		'first_pass_match'		=> array('MTEXT_UNI', ''),
-		'first_pass_replace'	=> array('MTEXT_UNI', ''),
-		'second_pass_match'		=> array('MTEXT_UNI', ''),
-		'second_pass_replace'	=> array('MTEXT_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> 'bbcode_id',
-	'KEYS'			=> array(
-		'display_on_post'		=> array('INDEX', 'display_on_posting'),
-	),
-);
-
-$schema_data['phpbb_bookmarks'] = array(
-	'COLUMNS'		=> array(
-		'topic_id'			=> array('UINT', 0),
-		'user_id'			=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'			=> array('topic_id', 'user_id'),
-);
-
-$schema_data['phpbb_bots'] = array(
-	'COLUMNS'		=> array(
-		'bot_id'			=> array('UINT', NULL, 'auto_increment'),
-		'bot_active'		=> array('BOOL', 1),
-		'bot_name'			=> array('STEXT_UNI', ''),
-		'user_id'			=> array('UINT', 0),
-		'bot_agent'			=> array('VCHAR', ''),
-		'bot_ip'			=> array('VCHAR', ''),
-	),
-	'PRIMARY_KEY'	=> 'bot_id',
-	'KEYS'			=> array(
-		'bot_active'		=> array('INDEX', 'bot_active'),
-	),
-);
-
-$schema_data['phpbb_config'] = array(
-	'COLUMNS'		=> array(
-		'config_name'		=> array('VCHAR', ''),
-		'config_value'		=> array('VCHAR_UNI', ''),
-		'is_dynamic'		=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> 'config_name',
-	'KEYS'			=> array(
-		'is_dynamic'		=> array('INDEX', 'is_dynamic'),
-	),
-);
-
-$schema_data['phpbb_confirm'] = array(
-	'COLUMNS'		=> array(
-		'confirm_id'		=> array('CHAR:32', ''),
-		'session_id'		=> array('CHAR:32', ''),
-		'confirm_type'		=> array('TINT:3', 0),
-		'code'				=> array('VCHAR:8', ''),
-		'seed'				=> array('UINT:10', 0),
-	),
-	'PRIMARY_KEY'	=> array('session_id', 'confirm_id'),
-	'KEYS'			=> array(
-		'confirm_type'		=> array('INDEX', 'confirm_type'),
-	),
-);
-
-$schema_data['phpbb_disallow'] = array(
-	'COLUMNS'		=> array(
-		'disallow_id'		=> array('UINT', NULL, 'auto_increment'),
-		'disallow_username'	=> array('VCHAR_UNI:255', ''),
-	),
-	'PRIMARY_KEY'	=> 'disallow_id',
-);
-
-$schema_data['phpbb_drafts'] = array(
-	'COLUMNS'		=> array(
-		'draft_id'			=> array('UINT', NULL, 'auto_increment'),
-		'user_id'			=> array('UINT', 0),
-		'topic_id'			=> array('UINT', 0),
-		'forum_id'			=> array('UINT', 0),
-		'save_time'			=> array('TIMESTAMP', 0),
-		'draft_subject'		=> array('STEXT_UNI', ''),
-		'draft_message'		=> array('MTEXT_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> 'draft_id',
-	'KEYS'			=> array(
-		'save_time'			=> array('INDEX', 'save_time'),
-	),
-);
-
-$schema_data['phpbb_extensions'] = array(
-	'COLUMNS'		=> array(
-		'extension_id'		=> array('UINT', NULL, 'auto_increment'),
-		'group_id'			=> array('UINT', 0),
-		'extension'			=> array('VCHAR:100', ''),
-	),
-	'PRIMARY_KEY'	=> 'extension_id',
-);
-
-$schema_data['phpbb_extension_groups'] = array(
-	'COLUMNS'		=> array(
-		'group_id'			=> array('UINT', NULL, 'auto_increment'),
-		'group_name'		=> array('VCHAR_UNI', ''),
-		'cat_id'			=> array('TINT:2', 0),
-		'allow_group'		=> array('BOOL', 0),
-		'download_mode'		=> array('BOOL', 1),
-		'upload_icon'		=> array('VCHAR', ''),
-		'max_filesize'		=> array('UINT:20', 0),
-		'allowed_forums'	=> array('TEXT', ''),
-		'allow_in_pm'		=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> 'group_id',
-);
-
-$schema_data['phpbb_forums'] = array(
-	'COLUMNS'		=> array(
-		'forum_id'				=> array('UINT', NULL, 'auto_increment'),
-		'parent_id'				=> array('UINT', 0),
-		'left_id'				=> array('UINT', 0),
-		'right_id'				=> array('UINT', 0),
-		'forum_parents'			=> array('MTEXT', ''),
-		'forum_name'			=> array('STEXT_UNI', ''),
-		'forum_desc'			=> array('TEXT_UNI', ''),
-		'forum_desc_bitfield'	=> array('VCHAR:255', ''),
-		'forum_desc_options'	=> array('UINT:11', 7),
-		'forum_desc_uid'		=> array('VCHAR:8', ''),
-		'forum_link'			=> array('VCHAR_UNI', ''),
-		'forum_password'		=> array('VCHAR_UNI:40', ''),
-		'forum_style'			=> array('UINT', 0),
-		'forum_image'			=> array('VCHAR', ''),
-		'forum_rules'			=> array('TEXT_UNI', ''),
-		'forum_rules_link'		=> array('VCHAR_UNI', ''),
-		'forum_rules_bitfield'	=> array('VCHAR:255', ''),
-		'forum_rules_options'	=> array('UINT:11', 7),
-		'forum_rules_uid'		=> array('VCHAR:8', ''),
-		'forum_topics_per_page'	=> array('TINT:4', 0),
-		'forum_type'			=> array('TINT:4', 0),
-		'forum_status'			=> array('TINT:4', 0),
-		'forum_posts'			=> array('UINT', 0),
-		'forum_topics'			=> array('UINT', 0),
-		'forum_topics_real'		=> array('UINT', 0),
-		'forum_last_post_id'	=> array('UINT', 0),
-		'forum_last_poster_id'	=> array('UINT', 0),
-		'forum_last_post_subject' => array('STEXT_UNI', ''),
-		'forum_last_post_time'	=> array('TIMESTAMP', 0),
-		'forum_last_poster_name'=> array('VCHAR_UNI', ''),
-		'forum_last_poster_colour'=> array('VCHAR:6', ''),
-		'forum_flags'			=> array('TINT:4', 32),
-		'display_subforum_list'	=> array('BOOL', 1),
-		'display_on_index'		=> array('BOOL', 1),
-		'enable_indexing'		=> array('BOOL', 1),
-		'enable_icons'			=> array('BOOL', 1),
-		'enable_prune'			=> array('BOOL', 0),
-		'prune_next'			=> array('TIMESTAMP', 0),
-		'prune_days'			=> array('UINT', 0),
-		'prune_viewed'			=> array('UINT', 0),
-		'prune_freq'			=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'forum_id',
-	'KEYS'			=> array(
-		'left_right_id'			=> array('INDEX', array('left_id', 'right_id')),
-		'forum_lastpost_id'		=> array('INDEX', 'forum_last_post_id'),
-	),
-);
-
-$schema_data['phpbb_forums_access'] = array(
-	'COLUMNS'		=> array(
-		'forum_id'				=> array('UINT', 0),
-		'user_id'				=> array('UINT', 0),
-		'session_id'			=> array('CHAR:32', ''),
-	),
-	'PRIMARY_KEY'	=> array('forum_id', 'user_id', 'session_id'),
-);
-
-$schema_data['phpbb_forums_track'] = array(
-	'COLUMNS'		=> array(
-		'user_id'				=> array('UINT', 0),
-		'forum_id'				=> array('UINT', 0),
-		'mark_time'				=> array('TIMESTAMP', 0),
-	),
-	'PRIMARY_KEY'	=> array('user_id', 'forum_id'),
-);
-
-$schema_data['phpbb_forums_watch'] = array(
-	'COLUMNS'		=> array(
-		'forum_id'				=> array('UINT', 0),
-		'user_id'				=> array('UINT', 0),
-		'notify_status'			=> array('BOOL', 0),
-	),
-	'KEYS'			=> array(
-		'forum_id'				=> array('INDEX', 'forum_id'),
-		'user_id'				=> array('INDEX', 'user_id'),
-		'notify_stat'			=> array('INDEX', 'notify_status'),
-	),
-);
-
-$schema_data['phpbb_groups'] = array(
-	'COLUMNS'		=> array(
-		'group_id'				=> array('UINT', NULL, 'auto_increment'),
-		'group_type'			=> array('TINT:4', 1),
-		'group_founder_manage'	=> array('BOOL', 0),
-		'group_name'			=> array('VCHAR_UNI', ''),
-		'group_name_clean'		=> array('VCHAR_UNI', ''),
-		'group_desc'			=> array('TEXT_UNI', ''),
-		'group_desc_bitfield'	=> array('VCHAR:255', ''),
-		'group_desc_options'	=> array('UINT:11', 7),
-		'group_desc_uid'		=> array('VCHAR:8', ''),
-		'group_display'			=> array('BOOL', 0),
-		'group_avatar'			=> array('VCHAR', ''),
-		'group_avatar_type'		=> array('TINT:2', 0),
-		'group_avatar_width'	=> array('USINT', 0),
-		'group_avatar_height'	=> array('USINT', 0),
-		'group_rank'			=> array('UINT', 0),
-		'group_colour'			=> array('VCHAR:6', ''),
-		'group_sig_chars'		=> array('UINT', 0),
-		'group_receive_pm'		=> array('BOOL', 0),
-		'group_message_limit'	=> array('UINT', 0),
-		'group_max_recipients'	=> array('UINT', 0),
-		'group_legend'			=> array('BOOL', 1),
-	),
-	'PRIMARY_KEY'	=> 'group_id',
-	'KEYS'			=> array(
-		'group_legend_name'		=> array('INDEX', array('group_legend', 'group_name')),
-	),
-);
-
-$schema_data['phpbb_icons'] = array(
-	'COLUMNS'		=> array(
-		'icons_id'				=> array('UINT', NULL, 'auto_increment'),
-		'icons_url'				=> array('VCHAR', ''),
-		'icons_width'			=> array('TINT:4', 0),
-		'icons_height'			=> array('TINT:4', 0),
-		'icons_order'			=> array('UINT', 0),
-		'display_on_posting'	=> array('BOOL', 1),
-	),
-	'PRIMARY_KEY'	=> 'icons_id',
-	'KEYS'			=> array(
-		'display_on_posting'	=> array('INDEX', 'display_on_posting'),
-	),
-);
-
-$schema_data['phpbb_lang'] = array(
-	'COLUMNS'		=> array(
-		'lang_id'				=> array('TINT:4', NULL, 'auto_increment'),
-		'lang_iso'				=> array('VCHAR:30', ''),
-		'lang_dir'				=> array('VCHAR:30', ''),
-		'lang_english_name'		=> array('VCHAR_UNI:100', ''),
-		'lang_local_name'		=> array('VCHAR_UNI:255', ''),
-		'lang_author'			=> array('VCHAR_UNI:255', ''),
-	),
-	'PRIMARY_KEY'	=> 'lang_id',
-	'KEYS'			=> array(
-		'lang_iso'				=> array('INDEX', 'lang_iso'),
-	),
-);
-
-$schema_data['phpbb_log'] = array(
-	'COLUMNS'		=> array(
-		'log_id'				=> array('UINT', NULL, 'auto_increment'),
-		'log_type'				=> array('TINT:4', 0),
-		'user_id'				=> array('UINT', 0),
-		'forum_id'				=> array('UINT', 0),
-		'topic_id'				=> array('UINT', 0),
-		'reportee_id'			=> array('UINT', 0),
-		'log_ip'				=> array('VCHAR:40', ''),
-		'log_time'				=> array('TIMESTAMP', 0),
-		'log_operation'			=> array('TEXT_UNI', ''),
-		'log_data'				=> array('MTEXT_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> 'log_id',
-	'KEYS'			=> array(
-		'log_type'				=> array('INDEX', 'log_type'),
-		'forum_id'				=> array('INDEX', 'forum_id'),
-		'topic_id'				=> array('INDEX', 'topic_id'),
-		'reportee_id'			=> array('INDEX', 'reportee_id'),
-		'user_id'				=> array('INDEX', 'user_id'),
-	),
-);
-
-$schema_data['phpbb_moderator_cache'] = array(
-	'COLUMNS'		=> array(
-		'forum_id'				=> array('UINT', 0),
-		'user_id'				=> array('UINT', 0),
-		'username'				=> array('VCHAR_UNI:255', ''),
-		'group_id'				=> array('UINT', 0),
-		'group_name'			=> array('VCHAR_UNI', ''),
-		'display_on_index'		=> array('BOOL', 1),
-	),
-	'KEYS'			=> array(
-		'disp_idx'				=> array('INDEX', 'display_on_index'),
-		'forum_id'				=> array('INDEX', 'forum_id'),
-	),
-);
-
-$schema_data['phpbb_modules'] = array(
-	'COLUMNS'		=> array(
-		'module_id'				=> array('UINT', NULL, 'auto_increment'),
-		'module_enabled'		=> array('BOOL', 1),
-		'module_display'		=> array('BOOL', 1),
-		'module_basename'		=> array('VCHAR', ''),
-		'module_class'			=> array('VCHAR:10', ''),
-		'parent_id'				=> array('UINT', 0),
-		'left_id'				=> array('UINT', 0),
-		'right_id'				=> array('UINT', 0),
-		'module_langname'		=> array('VCHAR', ''),
-		'module_mode'			=> array('VCHAR', ''),
-		'module_auth'			=> array('VCHAR', ''),
-	),
-	'PRIMARY_KEY'	=> 'module_id',
-	'KEYS'			=> array(
-		'left_right_id'			=> array('INDEX', array('left_id', 'right_id')),
-		'module_enabled'		=> array('INDEX', 'module_enabled'),
-		'class_left_id'			=> array('INDEX', array('module_class', 'left_id')),
-	),
-);
-
-$schema_data['phpbb_poll_options'] = array(
-	'COLUMNS'		=> array(
-		'poll_option_id'		=> array('TINT:4', 0),
-		'topic_id'				=> array('UINT', 0),
-		'poll_option_text'		=> array('TEXT_UNI', ''),
-		'poll_option_total'		=> array('UINT', 0),
-	),
-	'KEYS'			=> array(
-		'poll_opt_id'			=> array('INDEX', 'poll_option_id'),
-		'topic_id'				=> array('INDEX', 'topic_id'),
-	),
-);
-
-$schema_data['phpbb_poll_votes'] = array(
-	'COLUMNS'		=> array(
-		'topic_id'				=> array('UINT', 0),
-		'poll_option_id'		=> array('TINT:4', 0),
-		'vote_user_id'			=> array('UINT', 0),
-		'vote_user_ip'			=> array('VCHAR:40', ''),
-	),
-	'KEYS'			=> array(
-		'topic_id'				=> array('INDEX', 'topic_id'),
-		'vote_user_id'			=> array('INDEX', 'vote_user_id'),
-		'vote_user_ip'			=> array('INDEX', 'vote_user_ip'),
-	),
-);
-
-$schema_data['phpbb_posts'] = array(
-	'COLUMNS'		=> array(
-		'post_id'				=> array('UINT', NULL, 'auto_increment'),
-		'topic_id'				=> array('UINT', 0),
-		'forum_id'				=> array('UINT', 0),
-		'poster_id'				=> array('UINT', 0),
-		'icon_id'				=> array('UINT', 0),
-		'poster_ip'				=> array('VCHAR:40', ''),
-		'post_time'				=> array('TIMESTAMP', 0),
-		'post_approved'			=> array('BOOL', 1),
-		'post_reported'			=> array('BOOL', 0),
-		'enable_bbcode'			=> array('BOOL', 1),
-		'enable_smilies'		=> array('BOOL', 1),
-		'enable_magic_url'		=> array('BOOL', 1),
-		'enable_sig'			=> array('BOOL', 1),
-		'post_username'			=> array('VCHAR_UNI:255', ''),
-		'post_subject'			=> array('STEXT_UNI', '', 'true_sort'),
-		'post_text'				=> array('MTEXT_UNI', ''),
-		'post_checksum'			=> array('VCHAR:32', ''),
-		'post_attachment'		=> array('BOOL', 0),
-		'bbcode_bitfield'		=> array('VCHAR:255', ''),
-		'bbcode_uid'			=> array('VCHAR:8', ''),
-		'post_postcount'		=> array('BOOL', 1),
-		'post_edit_time'		=> array('TIMESTAMP', 0),
-		'post_edit_reason'		=> array('STEXT_UNI', ''),
-		'post_edit_user'		=> array('UINT', 0),
-		'post_edit_count'		=> array('USINT', 0),
-		'post_edit_locked'		=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> 'post_id',
-	'KEYS'			=> array(
-		'forum_id'				=> array('INDEX', 'forum_id'),
-		'topic_id'				=> array('INDEX', 'topic_id'),
-		'poster_ip'				=> array('INDEX', 'poster_ip'),
-		'poster_id'				=> array('INDEX', 'poster_id'),
-		'post_approved'			=> array('INDEX', 'post_approved'),
-		'tid_post_time'			=> array('INDEX', array('topic_id', 'post_time')),
-	),
-);
-
-$schema_data['phpbb_privmsgs'] = array(
-	'COLUMNS'		=> array(
-		'msg_id'				=> array('UINT', NULL, 'auto_increment'),
-		'root_level'			=> array('UINT', 0),
-		'author_id'				=> array('UINT', 0),
-		'icon_id'				=> array('UINT', 0),
-		'author_ip'				=> array('VCHAR:40', ''),
-		'message_time'			=> array('TIMESTAMP', 0),
-		'enable_bbcode'			=> array('BOOL', 1),
-		'enable_smilies'		=> array('BOOL', 1),
-		'enable_magic_url'		=> array('BOOL', 1),
-		'enable_sig'			=> array('BOOL', 1),
-		'message_subject'		=> array('STEXT_UNI', ''),
-		'message_text'			=> array('MTEXT_UNI', ''),
-		'message_edit_reason'	=> array('STEXT_UNI', ''),
-		'message_edit_user'		=> array('UINT', 0),
-		'message_attachment'	=> array('BOOL', 0),
-		'bbcode_bitfield'		=> array('VCHAR:255', ''),
-		'bbcode_uid'			=> array('VCHAR:8', ''),
-		'message_edit_time'		=> array('TIMESTAMP', 0),
-		'message_edit_count'	=> array('USINT', 0),
-		'to_address'			=> array('TEXT_UNI', ''),
-		'bcc_address'			=> array('TEXT_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> 'msg_id',
-	'KEYS'			=> array(
-		'author_ip'				=> array('INDEX', 'author_ip'),
-		'message_time'			=> array('INDEX', 'message_time'),
-		'author_id'				=> array('INDEX', 'author_id'),
-		'root_level'			=> array('INDEX', 'root_level'),
-	),
-);
-
-$schema_data['phpbb_privmsgs_folder'] = array(
-	'COLUMNS'		=> array(
-		'folder_id'				=> array('UINT', NULL, 'auto_increment'),
-		'user_id'				=> array('UINT', 0),
-		'folder_name'			=> array('VCHAR_UNI', ''),
-		'pm_count'				=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'folder_id',
-	'KEYS'			=> array(
-		'user_id'				=> array('INDEX', 'user_id'),
-	),
-);
-
-$schema_data['phpbb_privmsgs_rules'] = array(
-	'COLUMNS'		=> array(
-		'rule_id'				=> array('UINT', NULL, 'auto_increment'),
-		'user_id'				=> array('UINT', 0),
-		'rule_check'			=> array('UINT', 0),
-		'rule_connection'		=> array('UINT', 0),
-		'rule_string'			=> array('VCHAR_UNI', ''),
-		'rule_user_id'			=> array('UINT', 0),
-		'rule_group_id'			=> array('UINT', 0),
-		'rule_action'			=> array('UINT', 0),
-		'rule_folder_id'		=> array('INT:11', 0),
-	),
-	'PRIMARY_KEY'	=> 'rule_id',
-	'KEYS'			=> array(
-		'user_id'				=> array('INDEX', 'user_id'),
-	),
-);
-
-$schema_data['phpbb_privmsgs_to'] = array(
-	'COLUMNS'		=> array(
-		'msg_id'				=> array('UINT', 0),
-		'user_id'				=> array('UINT', 0),
-		'author_id'				=> array('UINT', 0),
-		'pm_deleted'			=> array('BOOL', 0),
-		'pm_new'				=> array('BOOL', 1),
-		'pm_unread'				=> array('BOOL', 1),
-		'pm_replied'			=> array('BOOL', 0),
-		'pm_marked'				=> array('BOOL', 0),
-		'pm_forwarded'			=> array('BOOL', 0),
-		'folder_id'				=> array('INT:11', 0),
-	),
-	'KEYS'			=> array(
-		'msg_id'				=> array('INDEX', 'msg_id'),
-		'author_id'				=> array('INDEX', 'author_id'),
-		'usr_flder_id'			=> array('INDEX', array('user_id', 'folder_id')),
-	),
-);
-
-$schema_data['phpbb_profile_fields'] = array(
-	'COLUMNS'		=> array(
-		'field_id'				=> array('UINT', NULL, 'auto_increment'),
-		'field_name'			=> array('VCHAR_UNI', ''),
-		'field_type'			=> array('TINT:4', 0),
-		'field_ident'			=> array('VCHAR:20', ''),
-		'field_length'			=> array('VCHAR:20', ''),
-		'field_minlen'			=> array('VCHAR', ''),
-		'field_maxlen'			=> array('VCHAR', ''),
-		'field_novalue'			=> array('VCHAR_UNI', ''),
-		'field_default_value'	=> array('VCHAR_UNI', ''),
-		'field_validation'		=> array('VCHAR_UNI:20', ''),
-		'field_required'		=> array('BOOL', 0),
-		'field_show_on_reg'		=> array('BOOL', 0),
-		'field_show_profile'	=> array('BOOL', 0),
-		'field_hide'			=> array('BOOL', 0),
-		'field_no_view'			=> array('BOOL', 0),
-		'field_active'			=> array('BOOL', 0),
-		'field_order'			=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'field_id',
-	'KEYS'			=> array(
-		'fld_type'			=> array('INDEX', 'field_type'),
-		'fld_ordr'			=> array('INDEX', 'field_order'),
-	),
-);
-
-$schema_data['phpbb_profile_fields_data'] = array(
-	'COLUMNS'		=> array(
-		'user_id'				=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'user_id',
-);
-
-$schema_data['phpbb_profile_fields_lang'] = array(
-	'COLUMNS'		=> array(
-		'field_id'				=> array('UINT', 0),
-		'lang_id'				=> array('UINT', 0),
-		'option_id'				=> array('UINT', 0),
-		'field_type'			=> array('TINT:4', 0),
-		'lang_value'			=> array('VCHAR_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> array('field_id', 'lang_id', 'option_id'),
-);
-
-$schema_data['phpbb_profile_lang'] = array(
-	'COLUMNS'		=> array(
-		'field_id'				=> array('UINT', 0),
-		'lang_id'				=> array('UINT', 0),
-		'lang_name'				=> array('VCHAR_UNI', ''),
-		'lang_explain'			=> array('TEXT_UNI', ''),
-		'lang_default_value'	=> array('VCHAR_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> array('field_id', 'lang_id'),
-);
-
-$schema_data['phpbb_ranks'] = array(
-	'COLUMNS'		=> array(
-		'rank_id'				=> array('UINT', NULL, 'auto_increment'),
-		'rank_title'			=> array('VCHAR_UNI', ''),
-		'rank_min'				=> array('UINT', 0),
-		'rank_special'			=> array('BOOL', 0),
-		'rank_image'			=> array('VCHAR', ''),
-	),
-	'PRIMARY_KEY'	=> 'rank_id',
-);
-
-$schema_data['phpbb_reports'] = array(
-	'COLUMNS'		=> array(
-		'report_id'				=> array('UINT', NULL, 'auto_increment'),
-		'reason_id'				=> array('USINT', 0),
-		'post_id'				=> array('UINT', 0),
-		'user_id'				=> array('UINT', 0),
-		'user_notify'			=> array('BOOL', 0),
-		'report_closed'			=> array('BOOL', 0),
-		'report_time'			=> array('TIMESTAMP', 0),
-		'report_text'			=> array('MTEXT_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> 'report_id',
-);
-
-$schema_data['phpbb_reports_reasons'] = array(
-	'COLUMNS'		=> array(
-		'reason_id'				=> array('USINT', NULL, 'auto_increment'),
-		'reason_title'			=> array('VCHAR_UNI', ''),
-		'reason_description'	=> array('MTEXT_UNI', ''),
-		'reason_order'			=> array('USINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'reason_id',
-);
-
-$schema_data['phpbb_search_results'] = array(
-	'COLUMNS'		=> array(
-		'search_key'			=> array('VCHAR:32', ''),
-		'search_time'			=> array('TIMESTAMP', 0),
-		'search_keywords'		=> array('MTEXT_UNI', ''),
-		'search_authors'		=> array('MTEXT', ''),
-	),
-	'PRIMARY_KEY'	=> 'search_key',
-);
-
-$schema_data['phpbb_search_wordlist'] = array(
-	'COLUMNS'		=> array(
-		'word_id'			=> array('UINT', NULL, 'auto_increment'),
-		'word_text'			=> array('VCHAR_UNI', ''),
-		'word_common'		=> array('BOOL', 0),
-		'word_count'		=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'word_id',
-	'KEYS'			=> array(
-		'wrd_txt'			=> array('UNIQUE', 'word_text'),
-		'wrd_cnt'			=> array('INDEX', 'word_count'),
-	),
-);
-
-$schema_data['phpbb_search_wordmatch'] = array(
-	'COLUMNS'		=> array(
-		'post_id'			=> array('UINT', 0),
-		'word_id'			=> array('UINT', 0),
-		'title_match'		=> array('BOOL', 0),
-	),
-	'KEYS'			=> array(
-		'unq_mtch'			=> array('UNIQUE', array('word_id', 'post_id', 'title_match')),
-		'word_id'			=> array('INDEX', 'word_id'),
-		'post_id'			=> array('INDEX', 'post_id'),
-	),
-);
-
-$schema_data['phpbb_sessions'] = array(
-	'COLUMNS'		=> array(
-		'session_id'			=> array('CHAR:32', ''),
-		'session_user_id'		=> array('UINT', 0),
-		'session_forum_id'		=> array('UINT', 0),
-		'session_last_visit'	=> array('TIMESTAMP', 0),
-		'session_start'			=> array('TIMESTAMP', 0),
-		'session_time'			=> array('TIMESTAMP', 0),
-		'session_ip'			=> array('VCHAR:40', ''),
-		'session_browser'		=> array('VCHAR:150', ''),
-		'session_forwarded_for'	=> array('VCHAR:255', ''),
-		'session_page'			=> array('VCHAR_UNI', ''),
-		'session_viewonline'	=> array('BOOL', 1),
-		'session_autologin'		=> array('BOOL', 0),
-		'session_admin'			=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> 'session_id',
-	'KEYS'			=> array(
-		'session_time'		=> array('INDEX', 'session_time'),
-		'session_user_id'	=> array('INDEX', 'session_user_id'),
-		'session_fid'		=> array('INDEX', 'session_forum_id'),
-	),
-);
-
-$schema_data['phpbb_sessions_keys'] = array(
-	'COLUMNS'		=> array(
-		'key_id'			=> array('CHAR:32', ''),
-		'user_id'			=> array('UINT', 0),
-		'last_ip'			=> array('VCHAR:40', ''),
-		'last_login'		=> array('TIMESTAMP', 0),
-	),
-	'PRIMARY_KEY'	=> array('key_id', 'user_id'),
-	'KEYS'			=> array(
-		'last_login'		=> array('INDEX', 'last_login'),
-	),
-);
-
-$schema_data['phpbb_sitelist'] = array(
-	'COLUMNS'		=> array(
-		'site_id'		=> array('UINT', NULL, 'auto_increment'),
-		'site_ip'		=> array('VCHAR:40', ''),
-		'site_hostname'	=> array('VCHAR', ''),
-		'ip_exclude'	=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'		=> 'site_id',
-);
-
-$schema_data['phpbb_smilies'] = array(
-	'COLUMNS'		=> array(
-		'smiley_id'			=> array('UINT', NULL, 'auto_increment'),
-		// We may want to set 'code' to VCHAR:50 or check if unicode support is possible... at the moment only ASCII characters are allowed.
-		'code'				=> array('VCHAR_UNI:50', ''),
-		'emotion'			=> array('VCHAR_UNI:50', ''),
-		'smiley_url'		=> array('VCHAR:50', ''),
-		'smiley_width'		=> array('USINT', 0),
-		'smiley_height'		=> array('USINT', 0),
-		'smiley_order'		=> array('UINT', 0),
-		'display_on_posting'=> array('BOOL', 1),
-	),
-	'PRIMARY_KEY'	=> 'smiley_id',
-	'KEYS'			=> array(
-		'display_on_post'		=> array('INDEX', 'display_on_posting'),
-	),
-);
-
-$schema_data['phpbb_styles'] = array(
-	'COLUMNS'		=> array(
-		'style_id'				=> array('UINT', NULL, 'auto_increment'),
-		'style_name'			=> array('VCHAR_UNI:255', ''),
-		'style_copyright'		=> array('VCHAR_UNI', ''),
-		'style_active'			=> array('BOOL', 1),
-		'template_id'			=> array('UINT', 0),
-		'theme_id'				=> array('UINT', 0),
-		'imageset_id'			=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'	=> 'style_id',
-	'KEYS'			=> array(
-		'style_name'		=> array('UNIQUE', 'style_name'),
-		'template_id'		=> array('INDEX', 'template_id'),
-		'theme_id'			=> array('INDEX', 'theme_id'),
-		'imageset_id'		=> array('INDEX', 'imageset_id'),
-	),
-);
-
-$schema_data['phpbb_styles_template'] = array(
-	'COLUMNS'		=> array(
-		'template_id'			=> array('UINT', NULL, 'auto_increment'),
-		'template_name'			=> array('VCHAR_UNI:255', ''),
-		'template_copyright'	=> array('VCHAR_UNI', ''),
-		'template_path'			=> array('VCHAR:100', ''),
-		'bbcode_bitfield'		=> array('VCHAR:255', 'kNg='),
-		'template_storedb'		=> array('BOOL', 0),
-		'template_inherits_id'		=> array('UINT:4', 0),
-		'template_inherit_path'		=> array('VCHAR', ''),
-	),
-	'PRIMARY_KEY'	=> 'template_id',
-	'KEYS'			=> array(
-		'tmplte_nm'				=> array('UNIQUE', 'template_name'),
-	),
-);
-
-$schema_data['phpbb_styles_theme'] = array(
-	'COLUMNS'		=> array(
-		'theme_id'				=> array('UINT', NULL, 'auto_increment'),
-		'theme_name'			=> array('VCHAR_UNI:255', ''),
-		'theme_copyright'		=> array('VCHAR_UNI', ''),
-		'theme_path'			=> array('VCHAR:100', ''),
-		'theme_storedb'			=> array('BOOL', 0),
-		'theme_mtime'			=> array('TIMESTAMP', 0),
-		'theme_data'			=> array('MTEXT_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> 'theme_id',
-	'KEYS'			=> array(
-		'theme_name'		=> array('UNIQUE', 'theme_name'),
-	),
-);
-
-$schema_data['phpbb_styles_imageset'] = array(
-	'COLUMNS'		=> array(
-		'imageset_id'				=> array('UINT', NULL, 'auto_increment'),
-		'imageset_name'				=> array('VCHAR_UNI:255', ''),
-		'imageset_copyright'		=> array('VCHAR_UNI', ''),
-		'imageset_path'				=> array('VCHAR:100', ''),
-	),
-	'PRIMARY_KEY'		=> 'imageset_id',
-	'KEYS'				=> array(
-		'imgset_nm'			=> array('UNIQUE', 'imageset_name'),
-	),
-);
-
-$schema_data['phpbb_styles_imageset_data'] = array(
-	'COLUMNS'		=> array(
-		'image_id'				=> array('UINT', NULL, 'auto_increment'),
-		'image_name'			=> array('VCHAR:200', ''),
-		'image_filename'		=> array('VCHAR:200', ''),
-		'image_lang'			=> array('VCHAR:30', ''),
-		'image_height'			=> array('USINT', 0),
-		'image_width'			=> array('USINT', 0),
-		'imageset_id'			=> array('UINT', 0),
-	),
-	'PRIMARY_KEY'		=> 'image_id',
-	'KEYS'				=> array(
-		'i_d'			=> array('INDEX', 'imageset_id'),
-	),
-);
-
-$schema_data['phpbb_topics'] = array(
-	'COLUMNS'		=> array(
-		'topic_id'					=> array('UINT', NULL, 'auto_increment'),
-		'forum_id'					=> array('UINT', 0),
-		'icon_id'					=> array('UINT', 0),
-		'topic_attachment'			=> array('BOOL', 0),
-		'topic_approved'			=> array('BOOL', 1),
-		'topic_reported'			=> array('BOOL', 0),
-		'topic_title'				=> array('STEXT_UNI', '', 'true_sort'),
-		'topic_poster'				=> array('UINT', 0),
-		'topic_time'				=> array('TIMESTAMP', 0),
-		'topic_time_limit'			=> array('TIMESTAMP', 0),
-		'topic_views'				=> array('UINT', 0),
-		'topic_replies'				=> array('UINT', 0),
-		'topic_replies_real'		=> array('UINT', 0),
-		'topic_status'				=> array('TINT:3', 0),
-		'topic_type'				=> array('TINT:3', 0),
-		'topic_first_post_id'		=> array('UINT', 0),
-		'topic_first_poster_name'	=> array('VCHAR_UNI', ''),
-		'topic_first_poster_colour'	=> array('VCHAR:6', ''),
-		'topic_last_post_id'		=> array('UINT', 0),
-		'topic_last_poster_id'		=> array('UINT', 0),
-		'topic_last_poster_name'	=> array('VCHAR_UNI', ''),
-		'topic_last_poster_colour'	=> array('VCHAR:6', ''),
-		'topic_last_post_subject'	=> array('STEXT_UNI', ''),
-		'topic_last_post_time'		=> array('TIMESTAMP', 0),
-		'topic_last_view_time'		=> array('TIMESTAMP', 0),
-		'topic_moved_id'			=> array('UINT', 0),
-		'topic_bumped'				=> array('BOOL', 0),
-		'topic_bumper'				=> array('UINT', 0),
-		'poll_title'				=> array('STEXT_UNI', ''),
-		'poll_start'				=> array('TIMESTAMP', 0),
-		'poll_length'				=> array('TIMESTAMP', 0),
-		'poll_max_options'			=> array('TINT:4', 1),
-		'poll_last_vote'			=> array('TIMESTAMP', 0),
-		'poll_vote_change'			=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> 'topic_id',
-	'KEYS'			=> array(
-		'forum_id'			=> array('INDEX', 'forum_id'),
-		'forum_id_type'		=> array('INDEX', array('forum_id', 'topic_type')),
-		'last_post_time'	=> array('INDEX', 'topic_last_post_time'),
-		'topic_approved'	=> array('INDEX', 'topic_approved'),
-		'forum_appr_last'	=> array('INDEX', array('forum_id', 'topic_approved', 'topic_last_post_id')),
-		'fid_time_moved'	=> array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),
-	),
-);
-
-$schema_data['phpbb_topics_track'] = array(
-	'COLUMNS'		=> array(
-		'user_id'			=> array('UINT', 0),
-		'topic_id'			=> array('UINT', 0),
-		'forum_id'			=> array('UINT', 0),
-		'mark_time'			=> array('TIMESTAMP', 0),
-	),
-	'PRIMARY_KEY'	=> array('user_id', 'topic_id'),
-	'KEYS'			=> array(
-		'forum_id'			=> array('INDEX', 'forum_id'),
-	),
-);
-
-$schema_data['phpbb_topics_posted'] = array(
-	'COLUMNS'		=> array(
-		'user_id'			=> array('UINT', 0),
-		'topic_id'			=> array('UINT', 0),
-		'topic_posted'		=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> array('user_id', 'topic_id'),
-);
-
-$schema_data['phpbb_topics_watch'] = array(
-	'COLUMNS'		=> array(
-		'topic_id'			=> array('UINT', 0),
-		'user_id'			=> array('UINT', 0),
-		'notify_status'		=> array('BOOL', 0),
-	),
-	'KEYS'			=> array(
-		'topic_id'			=> array('INDEX', 'topic_id'),
-		'user_id'			=> array('INDEX', 'user_id'),
-		'notify_stat'		=> array('INDEX', 'notify_status'),
-	),
-);
-
-$schema_data['phpbb_user_group'] = array(
-	'COLUMNS'		=> array(
-		'group_id'			=> array('UINT', 0),
-		'user_id'			=> array('UINT', 0),
-		'group_leader'		=> array('BOOL', 0),
-		'user_pending'		=> array('BOOL', 1),
-	),
-	'KEYS'			=> array(
-		'group_id'			=> array('INDEX', 'group_id'),
-		'user_id'			=> array('INDEX', 'user_id'),
-		'group_leader'		=> array('INDEX', 'group_leader'),
-	),
-);
-
-$schema_data['phpbb_users'] = array(
-	'COLUMNS'		=> array(
-		'user_id'					=> array('UINT', NULL, 'auto_increment'),
-		'user_type'					=> array('TINT:2', 0),
-		'group_id'					=> array('UINT', 3),
-		'user_permissions'			=> array('MTEXT', ''),
-		'user_perm_from'			=> array('UINT', 0),
-		'user_ip'					=> array('VCHAR:40', ''),
-		'user_regdate'				=> array('TIMESTAMP', 0),
-		'username'					=> array('VCHAR_UNI', ''),
-		'username_clean'			=> array('VCHAR_UNI', ''),
-		'user_password'				=> array('VCHAR_UNI:40', ''),
-		'user_passchg'				=> array('TIMESTAMP', 0),
-		'user_pass_convert'			=> array('BOOL', 0),
-		'user_email'				=> array('VCHAR_UNI:100', ''),
-		'user_email_hash'			=> array('BINT', 0),
-		'user_birthday'				=> array('VCHAR:10', ''),
-		'user_lastvisit'			=> array('TIMESTAMP', 0),
-		'user_lastmark'				=> array('TIMESTAMP', 0),
-		'user_lastpost_time'		=> array('TIMESTAMP', 0),
-		'user_lastpage'				=> array('VCHAR_UNI:200', ''),
-		'user_last_confirm_key'		=> array('VCHAR:10', ''),
-		'user_last_search'			=> array('TIMESTAMP', 0),
-		'user_warnings'				=> array('TINT:4', 0),
-		'user_last_warning'			=> array('TIMESTAMP', 0),
-		'user_login_attempts'		=> array('TINT:4', 0),
-		'user_inactive_reason'		=> array('TINT:2', 0),
-		'user_inactive_time'		=> array('TIMESTAMP', 0),
-		'user_posts'				=> array('UINT', 0),
-		'user_lang'					=> array('VCHAR:30', ''),
-		'user_timezone'				=> array('DECIMAL', 0),
-		'user_dst'					=> array('BOOL', 0),
-		'user_dateformat'			=> array('VCHAR_UNI:30', 'd M Y H:i'),
-		'user_style'				=> array('UINT', 0),
-		'user_rank'					=> array('UINT', 0),
-		'user_colour'				=> array('VCHAR:6', ''),
-		'user_new_privmsg'			=> array('INT:4', 0),
-		'user_unread_privmsg'		=> array('INT:4', 0),
-		'user_last_privmsg'			=> array('TIMESTAMP', 0),
-		'user_message_rules'		=> array('BOOL', 0),
-		'user_full_folder'			=> array('INT:11', -3),
-		'user_emailtime'			=> array('TIMESTAMP', 0),
-		'user_topic_show_days'		=> array('USINT', 0),
-		'user_topic_sortby_type'	=> array('VCHAR:1', 't'),
-		'user_topic_sortby_dir'		=> array('VCHAR:1', 'd'),
-		'user_post_show_days'		=> array('USINT', 0),
-		'user_post_sortby_type'		=> array('VCHAR:1', 't'),
-		'user_post_sortby_dir'		=> array('VCHAR:1', 'a'),
-		'user_notify'				=> array('BOOL', 0),
-		'user_notify_pm'			=> array('BOOL', 1),
-		'user_notify_type'			=> array('TINT:4', 0),
-		'user_allow_pm'				=> array('BOOL', 1),
-		'user_allow_viewonline'		=> array('BOOL', 1),
-		'user_allow_viewemail'		=> array('BOOL', 1),
-		'user_allow_massemail'		=> array('BOOL', 1),
-		'user_options'				=> array('UINT:11', 895),
-		'user_avatar'				=> array('VCHAR', ''),
-		'user_avatar_type'			=> array('TINT:2', 0),
-		'user_avatar_width'			=> array('USINT', 0),
-		'user_avatar_height'		=> array('USINT', 0),
-		'user_sig'					=> array('MTEXT_UNI', ''),
-		'user_sig_bbcode_uid'		=> array('VCHAR:8', ''),
-		'user_sig_bbcode_bitfield'	=> array('VCHAR:255', ''),
-		'user_from'					=> array('VCHAR_UNI:100', ''),
-		'user_icq'					=> array('VCHAR:15', ''),
-		'user_aim'					=> array('VCHAR_UNI', ''),
-		'user_yim'					=> array('VCHAR_UNI', ''),
-		'user_msnm'					=> array('VCHAR_UNI', ''),
-		'user_jabber'				=> array('VCHAR_UNI', ''),
-		'user_website'				=> array('VCHAR_UNI:200', ''),
-		'user_occ'					=> array('TEXT_UNI', ''),
-		'user_interests'			=> array('TEXT_UNI', ''),
-		'user_actkey'				=> array('VCHAR:32', ''),
-		'user_newpasswd'			=> array('VCHAR_UNI:40', ''),
-		'user_form_salt'			=> array('VCHAR_UNI:32', ''),
-
-	),
-	'PRIMARY_KEY'	=> 'user_id',
-	'KEYS'			=> array(
-		'user_birthday'				=> array('INDEX', 'user_birthday'),
-		'user_email_hash'			=> array('INDEX', 'user_email_hash'),
-		'user_type'					=> array('INDEX', 'user_type'),
-		'username_clean'			=> array('UNIQUE', 'username_clean'),
-	),
-);
-
-$schema_data['phpbb_warnings'] = array(
-	'COLUMNS'		=> array(
-		'warning_id'			=> array('UINT', NULL, 'auto_increment'),
-		'user_id'				=> array('UINT', 0),
-		'post_id'				=> array('UINT', 0),
-		'log_id'				=> array('UINT', 0),
-		'warning_time'			=> array('TIMESTAMP', 0),
-	),
-	'PRIMARY_KEY'	=> 'warning_id',
-);
-
-$schema_data['phpbb_words'] = array(
-	'COLUMNS'		=> array(
-		'word_id'				=> array('UINT', NULL, 'auto_increment'),
-		'word'					=> array('VCHAR_UNI', ''),
-		'replacement'			=> array('VCHAR_UNI', ''),
-	),
-	'PRIMARY_KEY'	=> 'word_id',
-);
-
-$schema_data['phpbb_zebra'] = array(
-	'COLUMNS'		=> array(
-		'user_id'				=> array('UINT', 0),
-		'zebra_id'				=> array('UINT', 0),
-		'friend'				=> array('BOOL', 0),
-		'foe'					=> array('BOOL', 0),
-	),
-	'PRIMARY_KEY'	=> array('user_id', 'zebra_id'),
-);
-
-?>