phpBB/install/schemas/schema_data.php

   1 <?php
   2
   3 $schema_data = $schema_updates = array();
   4
   5 // We need some default increments first, so add them first
   6
   7 // phpbb_styles_imageset
   8 $schema_data[] = array(
   9         'table'         => 'phpbb_styles_imageset',
  10         'columns'       => array('imageset_name', 'imageset_copyright', 'imageset_path'),
  11         'data'          => array(
  12                 array('prosilver', '&copy; phpBB Group', 'prosilver'),
  13         ),
  14         'store_auto_increment'  => 'IMAGESET_ID',
  15 );
  16
  17 // phpbb_styles_template
  18 $schema_data[] = array(
  19         'table'         => 'phpbb_styles_template',
  20         'columns'       => array('template_name', 'template_copyright', 'template_path', 'bbcode_bitfield'),
  21         'data'          => array(
  22                 array('prosilver', '&copy; phpBB Group', 'prosilver', 'lNg='),
  23         ),
  24         'store_auto_increment'  => 'TEMPLATE_ID',
  25 );
  26
  27 // phpbb_styles_theme
  28 $schema_data[] = array(
  29         'table'         => 'phpbb_styles_theme',
  30         'columns'       => array('theme_name', 'theme_copyright', 'theme_path', 'theme_storedb', 'theme_data'),
  31         'data'          => array(
  32                 array('prosilver', '&copy; phpBB Group', 'prosilver', 1, ''),
  33         ),
  34         'store_auto_increment'  => 'THEME_ID',
  35 );
  36
  37 // phpbb_styles
  38 $schema_data[] = array(
  39         'table'         => 'phpbb_styles',
  40         'columns'       => array('style_name', 'style_copyright', 'style_active', 'template_id', 'theme_id', 'imageset_id'),
  41         'data'          => array(
  42                 array('prosilver', '&copy; phpBB Group', 1, array('auto_increment' => 'TEMPLATE_ID:0'), array('auto_increment' => 'THEME_ID:0'), array('auto_increment' => 'IMAGESET_ID:0')),
  43         ),
  44         'store_auto_increment'  => 'STYLE_ID',
  45 );
  46
  47 // phpbb_config
  48 $schema_data[] = array(
  49         'table'         => 'phpbb_config',
  50         'columns'       => array('string:config_name', 'string:config_value'),
  51         'data'          => array(
  52                 array('active_sessions', '0'),
  53                 array('allow_attachments', '1'),
  54                 array('allow_autologin', '1'),
  55                 array('allow_avatar_local', '0'),
  56                 array('allow_avatar_remote', '0'),
  57                 array('allow_avatar_upload', '0'),
  58                 array('allow_bbcode', '1'),
  59                 array('allow_birthdays', '1'),
  60                 array('allow_bookmarks', '1'),
  61                 array('allow_emailreuse', '0'),
  62                 array('allow_forum_notify', '1'),
  63                 array('allow_mass_pm', '1'),
  64                 array('allow_name_chars', 'USERNAME_CHARS_ANY'),
  65                 array('allow_namechange', '0'),
  66                 array('allow_nocensors', '0'),
  67                 array('allow_pm_attach', '0'),
  68                 array('allow_post_flash', '1'),
  69                 array('allow_post_links', '1'),
  70                 array('allow_privmsg', '1'),
  71                 array('allow_sig', '1'),
  72                 array('allow_sig_bbcode', '1'),
  73                 array('allow_sig_flash', '0'),
  74                 array('allow_sig_img', '1'),
  75                 array('allow_sig_links', '1'),
  76                 array('allow_sig_pm', '1'),
  77                 array('allow_sig_smilies', '1'),
  78                 array('allow_smilies', '1'),
  79                 array('allow_topic_notify', '1'),
  80                 array('attachment_quota', '52428800'),
  81                 array('auth_bbcode_pm', '1'),
  82                 array('auth_flash_pm', '0'),
  83                 array('auth_img_pm', '1'),
  84                 array('auth_method', 'db'),
  85                 array('auth_smilies_pm', '1'),
  86                 array('avatar_filesize', '6144'),
  87                 array('avatar_gallery_path', 'images/avatars/gallery'),
  88                 array('avatar_max_height', '90'),
  89                 array('avatar_max_width', '90'),
  90                 array('avatar_min_height', '20'),
  91                 array('avatar_min_width', '20'),
  92                 array('avatar_path', 'images/avatars/upload'),
  93                 array('avatar_salt', '{AVATAR_SALT}'),
  94                 array('board_contact', '{BOARD_CONTACT}'),
  95                 array('board_disable', '0'),
  96                 array('board_disable_msg', ''),
  97                 array('board_dst', '0'),
  98                 array('board_email', '{BOARD_EMAIL}'),
  99                 array('board_email_from', '0'),
 100                 array('board_email_sig', '{L_CONFIG_BOARD_EMAIL_SIG}'),
 101                 array('board_hide_emails', '1'),
 102                 array('board_startdate', '{BOARD_STARTDATE}'),
 103                 array('board_timezone', '0'),
 104                 array('browser_check', '1'),
 105                 array('bump_interval', '10'),
 106                 array('bump_type', 'd'),
 107                 array('cache_gc', '7200'),
 108                 array('captcha_plugin', '{CAPTCHA_PLUGIN}'),
 109                 array('captcha_gd_foreground_noise', '0'),
 110                 array('captcha_gd_x_grid', '25'),
 111                 array('captcha_gd_y_grid', '25'),
 112                 array('captcha_gd_wave', '0'),
 113                 array('captcha_gd_3d_noise', '1'),
 114                 array('captcha_gd_fonts', '1'),
 115                 array('confirm_refresh', '1'),
 116                 array('check_attachment_content', '1'),
 117                 array('check_dnsbl', '0'),
 118                 array('chg_passforce', '0'),
 119                 array('cookie_domain', '{COOKIE_DOMAIN}'),
 120                 array('cookie_name', '{COOKIE_NAME}'),
 121                 array('cookie_path', '/'),
 122                 array('cookie_secure', '{COOKIE_SECURE}'),
 123                 array('coppa_enable', '0'),
 124                 array('coppa_fax', ''),
 125                 array('coppa_mail', ''),
 126                 array('database_gc', '604800'),
 127                 array('dbms_version', '{DBMS_VERSION}'),
 128                 array('default_dateformat', '{DEFAULT_DATEFORMAT}'),
 129                 array('default_lang', '{DEFAULT_LANG}'),
 130                 array('default_style', array('auto_increment' => 'STYLE_ID:0')),
 131                 array('display_last_edited', '1'),
 132                 array('display_order', '0'),
 133                 array('edit_time', '0'),
 134                 array('email_check_mx', '0'),
 135                 array('email_enable', '{EMAIL_ENABLE}'),
 136                 array('email_function_name', 'mail'),
 137                 array('email_package_size', '50'),
 138                 array('enable_confirm', '1'),
 139                 array('enable_pm_icons', '1'),
 140                 array('enable_post_confirm', '1'),
 141                 array('enable_queue_trigger', '0'),
 142                 array('flood_interval', '15'),
 143                 array('force_server_vars', '{FORCE_SERVER_VARS}'),
 144                 array('form_token_lifetime', '7200'),
 145                 array('form_token_mintime', '0'),
 146                 array('form_token_sid_guests', '1'),
 147                 array('forward_pm', '1'),
 148                 array('forwarded_for_check', '0'),
 149                 array('full_folder_action', '2'),
 150                 array('fulltext_mysql_max_word_len', '254'),
 151                 array('fulltext_mysql_min_word_len', '4'),
 152                 array('fulltext_native_common_thres', '5'),
 153                 array('fulltext_native_load_upd', '1'),
 154                 array('fulltext_native_max_chars', '14'),
 155                 array('fulltext_native_min_chars', '3'),
 156                 array('gzip_compress', '0'),
 157                 array('hot_threshold', '25'),
 158                 array('icons_path', 'images/icons'),
 159                 array('img_create_thumbnail', '0'),
 160                 array('img_display_inlined', '1'),
 161                 array('img_imagick', '{IMG_IMAGICK}'),
 162                 array('img_link_height', '0'),
 163                 array('img_link_width', '0'),
 164                 array('img_max_height', '0'),
 165                 array('img_max_thumb_width', '400'),
 166                 array('img_max_width', '0'),
 167                 array('img_min_thumb_filesize', '12000'),
 168                 array('ip_check', '3'),
 169                 array('jab_enable', '0'),
 170                 array('jab_host', ''),
 171                 array('jab_password', ''),
 172                 array('jab_package_size', '20'),
 173                 array('jab_port', '5222'),
 174                 array('jab_use_ssl', '0'),
 175                 array('jab_username', ''),
 176                 array('ldap_base_dn', ''),
 177                 array('ldap_email', ''),
 178                 array('ldap_password', ''),
 179                 array('ldap_port', ''),
 180                 array('ldap_server', ''),
 181                 array('ldap_uid', ''),
 182                 array('ldap_user', ''),
 183                 array('ldap_user_filter', ''),
 184                 array('limit_load', '0'),
 185                 array('limit_search_load', '0'),
 186                 array('load_anon_lastread', '0'),
 187                 array('load_birthdays', '1'),
 188                 array('load_cpf_memberlist', '0'),
 189                 array('load_cpf_viewprofile', '1'),
 190                 array('load_cpf_viewtopic', '0'),
 191                 array('load_db_lastread', '1'),
 192                 array('load_db_track', '1'),
 193                 array('load_jumpbox', '1'),
 194                 array('load_moderators', '1'),
 195                 array('load_online', '1'),
 196                 array('load_online_guests', '1'),
 197                 array('load_online_time', '5'),
 198                 array('load_online_track', '1'),
 199                 array('load_search', '1'),
 200                 array('load_tplcompile', '0'),
 201                 array('load_user_activity', '1'),
 202                 array('max_attachments', '3'),
 203                 array('max_attachments_pm', '1'),
 204                 array('max_autologin_time', '0'),
 205                 array('max_filesize', '262144'),
 206                 array('max_filesize_pm', '262144'),
 207                 array('max_login_attempts', '3'),
 208                 array('max_name_chars', '20'),
 209                 array('max_num_search_keywords', '10'),
 210                 array('max_pass_chars', '30'),
 211                 array('max_poll_options', '10'),
 212                 array('max_poll_chars', '60000'),
 213                 array('max_post_font_size', '200'),
 214                 array('max_post_img_height', '0'),
 215                 array('max_post_img_width', '0'),
 216                 array('max_post_smilies', '0'),
 217                 array('max_post_urls', '0'),
 218                 array('max_quote_depth', '3'),
 219                 array('max_reg_attempts', '5'),
 220                 array('max_sig_chars', '255'),
 221                 array('max_sig_font_size', '200'),
 222                 array('max_sig_img_height', '0'),
 223                 array('max_sig_img_width', '0'),
 224                 array('max_sig_smilies', '0'),
 225                 array('max_sig_urls', '5'),
 226                 array('min_name_chars', '3'),
 227                 array('min_pass_chars', '6'),
 228                 array('min_search_author_chars', '3'),
 229                 array('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title'),
 230                 array('override_user_style', '0'),
 231                 array('pass_complex', 'PASS_TYPE_ANY'),
 232                 array('pm_edit_time', '0'),
 233                 array('pm_max_boxes', '4'),
 234                 array('pm_max_msgs', '50'),
 235                 array('pm_max_recipients', '0'),
 236                 array('posts_per_page', '10'),
 237                 array('print_pm', '1'),
 238                 array('queue_interval', '600'),
 239                 array('queue_trigger_posts', '3'),
 240                 array('ranks_path', 'images/ranks'),
 241                 array('require_activation', '0'),
 242                 array('referer_validation', '{REFERER_VALIDATION}'),
 243                 array('script_path', '{SCRIPT_PATH}'),
 244                 array('search_block_size', '250'),
 245                 array('search_gc', '7200'),
 246                 array('search_indexing_state', ''),
 247                 array('search_interval', '0'),
 248                 array('search_anonymous_interval', '0'),
 249                 array('search_type', 'fulltext_native'),
 250                 array('search_store_results', '1800'),
 251                 array('secure_allow_deny', '1'),
 252                 array('secure_allow_empty_referer', '1'),
 253                 array('secure_downloads', '0'),
 254                 array('server_name', '{SERVER_NAME}'),
 255                 array('server_port', '{SERVER_PORT}'),
 256                 array('server_protocol', '{SERVER_PROTOCOL}'),
 257                 array('session_gc', '3600'),
 258                 array('session_length', '3600'),
 259                 array('site_desc', '{L_CONFIG_SITE_DESC}'),
 260                 array('sitename', '{L_CONFIG_SITENAME}'),
 261                 array('smilies_path', 'images/smilies'),
 262                 array('smtp_auth_method', '{SMTP_AUTH_METHOD}'),
 263                 array('smtp_delivery', '{SMTP_DELIVERY}'),
 264                 array('smtp_host', '{SMTP_HOST}'),
 265                 array('smtp_password', '{SMTP_PASSWORD}'),
 266                 array('smtp_port', '25'),
 267                 array('smtp_username', '{SMTP_USERNAME}'),
 268                 array('topics_per_page', '25'),
 269                 array('tpl_allow_php', '0'),
 270                 array('upload_icons_path', 'images/upload_icons'),
 271                 array('upload_path', 'files'),
 272                 array('version', '3.1.0-dev1'),
 273                 array('warnings_expire_days', '90'),
 274                 array('warnings_gc', '14400'),
 275         ),
 276 );
 277
 278 // Ranks
 279 $schema_data[] = array(
 280         'table'         => 'phpbb_ranks',
 281         'columns'       => array('rank_title', 'rank_min', 'rank_special', 'rank_image'),
 282         'data'          => array(
 283                 array('{L_RANKS_SITE_ADMIN_TITLE}', 0, 1, ''),
 284         ),
 285         'store_auto_increment'  => 'RANK_ID',
 286 );
 287
 288 // Groups
 289 $schema_data[] = array(
 290         'table'         => 'phpbb_groups',
 291         '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'),
 292         'data'          => array(
 293                 array('GUESTS', 'guests', 3, 0, '', 0, '', '', '', 0),
 294                 array('REGISTERED', 'registered', 3, 0, '', 0, '', '', '', 5),
 295                 array('REGISTERED_COPPA', 'registered_coppa', 3, 0, '', 0, '', '', '', 5),
 296                 array('GLOBAL_MODERATORS', 'global_moderators', 3, 0, '00AA00', 1, '', '', '', 50),
 297                 array('ADMINISTRATORS', 'administrators', 3, 1, 'AA0000', 1, '', '', '', 50),
 298                 array('BOTS', 'bots', 3, 0, '9E8DA7', 0, '', '', '', 5),
 299         ),
 300         'store_auto_increment'  => 'GROUP_ID',
 301 );
 302
 303 // Users
 304 $schema_data[] = array(
 305         'table'         => 'phpbb_users',
 306         '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'),
 307         'data'          => array(
 308                 // Anonymous
 309                 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}'),
 310                 // Admin
 311                 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}'),
 312         ),
 313         'store_auto_increment'  => 'USER_ID',
 314 );
 315
 316 // Dynamic config values
 317 $schema_data[] = array(
 318         'table'         => 'phpbb_config',
 319         'columns'       => array('string:config_name', 'string:config_value', 'is_dynamic'),
 320         'data'          => array(
 321                 array('cache_last_gc', '0', 1),
 322                 array('cron_lock', '0', 1),
 323                 array('database_last_gc', '0', 1),
 324                 array('last_queue_run', '0', 1),
 325                 array('newest_user_colour', 'AA0000', 1),
 326                 array('newest_user_id', array('auto_increment' => 'USER_ID:1'), 1),
 327                 array('newest_username', '{NEWEST_USERNAME}', 1),
 328                 array('num_files', '0', 1),
 329                 array('num_posts', '1', 1),
 330                 array('num_topics', '1', 1),
 331                 array('num_users', '1', 1),
 332                 array('rand_seed', '0', 1),
 333                 array('rand_seed_last_update', '0', 1),
 334                 array('record_online_date', '0', 1),
 335                 array('record_online_users', '0', 1),
 336                 array('search_last_gc', '0', 1),
 337                 array('session_last_gc', '0', 1),
 338                 array('upload_dir_size', '0', 1),
 339                 array('warnings_last_gc', '0', 1),
 340         ),
 341 );
 342
 343 // Forums
 344 $schema_data[] = array(
 345         'table'         => 'phpbb_forums',
 346         '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'),
 347         'data'          => array(
 348                 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, ''),
 349                 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, ''),
 350         ),
 351         'store_auto_increment' => 'FORUM_ID',
 352 );
 353
 354 // Demo Topic
 355 $schema_data[] = array(
 356         'table'         => 'phpbb_topics',
 357         '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'),
 358         'data'          => array(
 359                 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, ''),
 360         ),
 361         'store_auto_increment' => 'TOPIC_ID',
 362 );
 363
 364 // Demo Post
 365 $schema_data[] = array(
 366         'table'         => 'phpbb_posts',
 367         'columns'       => array('topic_id', 'forum_id', 'poster_id', 'icon_id', 'post_time', 'post_username', 'poster_ip', 'post_subject', 'post_text', 'post_checksum', 'bbcode_uid'),
 368         'data'          => array(
 369                 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}', '', ''),
 370         ),
 371         'store_auto_increment' => 'POST_ID',
 372 );
 373
 374 // Admin posted to the demo topic
 375 $schema_data[] = array(
 376         'table'         => 'phpbb_topics_posted',
 377         'columns'       => array('user_id', 'topic_id', 'topic_posted'),
 378         'data'          => array(
 379                 array(array('auto_increment' => 'USER_ID:1'), array('auto_increment' => 'TOPIC_ID:0'), 1),
 380         ),
 381 );
 382
 383 // Update forums table
 384 $schema_updates[] = array(
 385         'table'         => 'phpbb_forums',
 386         'columns'       => array('forum_last_post_id'),
 387         'data'          => array(array('auto_increment' => 'POST_ID:0')),
 388 );
 389
 390 // Update topics table
 391 $schema_updates[] = array(
 392         'table'         => 'phpbb_topics',
 393         'columns'       => array('topic_first_post_id', 'topic_last_post_id'),
 394         'data'          => array(array('auto_increment' => 'POST_ID:0'), array('auto_increment' => 'POST_ID:0')),
 395         'where'         => array(
 396                 array('topic_id' => array('auto_increment' => 'TOPIC_ID:0')),
 397         ),
 398 );
 399
 400 // User -> Group
 401 $schema_data[] = array(
 402         'table'         => 'phpbb_user_group',
 403         'columns'       => array('group_id', 'user_id', 'user_pending', 'group_leader'),
 404         'data'          => array(
 405                 array(array('auto_increment' => 'GROUP_ID:0'), array('auto_increment' => 'USER_ID:0'), 0, 0),
 406                 array(array('auto_increment' => 'GROUP_ID:1'), array('auto_increment' => 'USER_ID:1'), 0, 0),
 407                 array(array('auto_increment' => 'GROUP_ID:3'), array('auto_increment' => 'USER_ID:1'), 0, 0),
 408                 array(array('auto_increment' => 'GROUP_ID:4'), array('auto_increment' => 'USER_ID:1'), 0, 1),
 409         ),
 410 );
 411
 412 // Forum related auth options
 413 $schema_data[] = array(
 414         'table'         => 'phpbb_acl_options',
 415         'columns'       => array('auth_option', 'is_local', 'is_global'),
 416         'data'          => array(
 417                 array('f_', 1, 0),
 418                 array('f_announce', 1, 0),
 419                 array('f_attach', 1, 0),
 420                 array('f_bbcode', 1, 0),
 421                 array('f_bump', 1, 0),
 422                 array('f_delete', 1, 0),
 423                 array('f_download', 1, 0),
 424                 array('f_edit', 1, 0),
 425                 array('f_email', 1, 0),
 426                 array('f_flash', 1, 0),
 427                 array('f_icons', 1, 0),
 428                 array('f_ignoreflood', 1, 0),
 429                 array('f_img', 1, 0),
 430                 array('f_list', 1, 0),
 431                 array('f_noapprove', 1, 0),
 432                 array('f_poll', 1, 0),
 433                 array('f_post', 1, 0),
 434                 array('f_postcount', 1, 0),
 435                 array('f_print', 1, 0),
 436                 array('f_read', 1, 0),
 437                 array('f_reply', 1, 0),
 438                 array('f_report', 1, 0),
 439                 array('f_search', 1, 0),
 440                 array('f_sigs', 1, 0),
 441                 array('f_smilies', 1, 0),
 442                 array('f_sticky', 1, 0),
 443                 array('f_subscribe', 1, 0),
 444                 array('f_user_lock', 1, 0),
 445                 array('f_vote', 1, 0),
 446                 array('f_votechg', 1, 0),
 447
 448                 // Moderator related auth options
 449                 array('m_', 1, 1),
 450                 array('m_approve', 1, 1),
 451                 array('m_chgposter', 1, 1),
 452                 array('m_delete', 1, 1),
 453                 array('m_edit', 1, 1),
 454                 array('m_info', 1, 1),
 455                 array('m_lock', 1, 1),
 456                 array('m_merge', 1, 1),
 457                 array('m_move', 1, 1),
 458                 array('m_report', 1, 1),
 459                 array('m_split', 1, 1),
 460
 461                 // Global moderator auth option (not a local option)
 462                 array('m_ban', 0, 1),
 463                 array('m_warn', 0, 1),
 464
 465                 // Admin related auth options
 466                 array('a_', 0, 1),
 467                 array('a_aauth', 0, 1),
 468                 array('a_attach', 0, 1),
 469                 array('a_authgroups', 0, 1),
 470                 array('a_authusers', 0, 1),
 471                 array('a_backup', 0, 1),
 472                 array('a_ban', 0, 1),
 473                 array('a_bbcode', 0, 1),
 474                 array('a_board', 0, 1),
 475                 array('a_bots', 0, 1),
 476                 array('a_clearlogs', 0, 1),
 477                 array('a_email', 0, 1),
 478                 array('a_fauth', 0, 1),
 479                 array('a_forum', 0, 1),
 480                 array('a_forumadd', 0, 1),
 481                 array('a_forumdel', 0, 1),
 482                 array('a_group', 0, 1),
 483                 array('a_groupadd', 0, 1),
 484                 array('a_groupdel', 0, 1),
 485                 array('a_icons', 0, 1),
 486                 array('a_jabber', 0, 1),
 487                 array('a_language', 0, 1),
 488                 array('a_mauth', 0, 1),
 489                 array('a_modules', 0, 1),
 490                 array('a_names', 0, 1),
 491                 array('a_phpinfo', 0, 1),
 492                 array('a_profile', 0, 1),
 493                 array('a_prune', 0, 1),
 494                 array('a_ranks', 0, 1),
 495                 array('a_reasons', 0, 1),
 496                 array('a_roles', 0, 1),
 497                 array('a_search', 0, 1),
 498                 array('a_server', 0, 1),
 499                 array('a_styles', 0, 1),
 500                 array('a_switchperm', 0, 1),
 501                 array('a_uauth', 0, 1),
 502                 array('a_user', 0, 1),
 503                 array('a_userdel', 0, 1),
 504                 array('a_viewauth', 0, 1),
 505                 array('a_viewlogs', 0, 1),
 506                 array('a_words', 0, 1),
 507
 508                 // User related auth options
 509                 array('u_', 0, 1),
 510                 array('u_attach', 0, 1),
 511                 array('u_chgavatar', 0, 1),
 512                 array('u_chgcensors', 0, 1),
 513                 array('u_chgemail', 0, 1),
 514                 array('u_chggrp', 0, 1),
 515                 array('u_chgname', 0, 1),
 516                 array('u_chgpasswd', 0, 1),
 517                 array('u_download', 0, 1),
 518                 array('u_hideonline', 0, 1),
 519                 array('u_ignoreflood', 0, 1),
 520                 array('u_masspm', 0, 1),
 521                 array('u_masspm_group', 0, 1),
 522                 array('u_pm_attach', 0, 1),
 523                 array('u_pm_bbcode', 0, 1),
 524                 array('u_pm_delete', 0, 1),
 525                 array('u_pm_download', 0, 1),
 526                 array('u_pm_edit', 0, 1),
 527                 array('u_pm_emailpm', 0, 1),
 528                 array('u_pm_flash', 0, 1),
 529                 array('u_pm_forward', 0, 1),
 530                 array('u_pm_img', 0, 1),
 531                 array('u_pm_printpm', 0, 1),
 532                 array('u_pm_smilies', 0, 1),
 533                 array('u_readpm', 0, 1),
 534                 array('u_savedrafts', 0, 1),
 535                 array('u_search', 0, 1),
 536                 array('u_sendemail', 0, 1),
 537                 array('u_sendim', 0, 1),
 538                 array('u_sendpm', 0, 1),
 539                 array('u_sig', 0, 1),
 540                 array('u_viewonline', 0, 1),
 541                 array('u_viewprofile', 0, 1),
 542         ),
 543         'store_auto_increment'  => 'AUTH_OPTION_ID',
 544 );
 545
 546 // standard auth roles
 547 $schema_data[] = array(
 548         'table'         => 'phpbb_acl_roles',
 549         'columns'       => array('role_name', 'role_description', 'role_type', 'role_order'),
 550         'data'          => array(
 551                 array('ROLE_ADMIN_STANDARD', 'ROLE_DESCRIPTION_ADMIN_STANDARD', 'a_', 1),
 552                 array('ROLE_ADMIN_FORUM', 'ROLE_DESCRIPTION_ADMIN_FORUM', 'a_', 3),
 553                 array('ROLE_ADMIN_USERGROUP', 'ROLE_DESCRIPTION_ADMIN_USERGROUP', 'a_', 4),
 554                 array('ROLE_ADMIN_FULL', 'ROLE_DESCRIPTION_ADMIN_FULL', 'a_', 2),
 555                 array('ROLE_USER_FULL', 'ROLE_DESCRIPTION_USER_FULL', 'u_', 3),
 556                 array('ROLE_USER_STANDARD', 'ROLE_DESCRIPTION_USER_STANDARD', 'u_', 1),
 557                 array('ROLE_USER_LIMITED', 'ROLE_DESCRIPTION_USER_LIMITED', 'u_', 2),
 558                 array('ROLE_USER_NOPM', 'ROLE_DESCRIPTION_USER_NOPM', 'u_', 4),
 559                 array('ROLE_USER_NOAVATAR', 'ROLE_DESCRIPTION_USER_NOAVATAR', 'u_', 5),
 560                 array('ROLE_MOD_FULL', 'ROLE_DESCRIPTION_MOD_FULL', 'm_', 3),
 561                 array('ROLE_MOD_STANDARD', 'ROLE_DESCRIPTION_MOD_STANDARD', 'm_', 1),
 562                 array('ROLE_MOD_SIMPLE', 'ROLE_DESCRIPTION_MOD_SIMPLE', 'm_', 2),
 563                 array('ROLE_MOD_QUEUE', 'ROLE_DESCRIPTION_MOD_QUEUE', 'm_', 4),
 564                 array('ROLE_FORUM_FULL', 'ROLE_DESCRIPTION_FORUM_FULL', 'f_', 7),
 565                 array('ROLE_FORUM_STANDARD', 'ROLE_DESCRIPTION_FORUM_STANDARD', 'f_', 5),
 566                 array('ROLE_FORUM_NOACCESS', 'ROLE_DESCRIPTION_FORUM_NOACCESS', 'f_', 1),
 567                 array('ROLE_FORUM_READONLY', 'ROLE_DESCRIPTION_FORUM_READONLY', 'f_', 2),
 568                 array('ROLE_FORUM_LIMITED', 'ROLE_DESCRIPTION_FORUM_LIMITED', 'f_', 3),
 569                 array('ROLE_FORUM_BOT', 'ROLE_DESCRIPTION_FORUM_BOT', 'f_', 9),
 570                 array('ROLE_FORUM_ONQUEUE', 'ROLE_DESCRIPTION_FORUM_ONQUEUE', 'f_', 8),
 571                 array('ROLE_FORUM_POLLS', 'ROLE_DESCRIPTION_FORUM_POLLS', 'f_', 6),
 572                 array('ROLE_FORUM_LIMITED_POLLS', 'ROLE_DESCRIPTION_FORUM_LIMITED_POLLS', 'f_', 4),
 573                 array('ROLE_USER_GUESTS', 'ROLE_DESCRIPTION_USER_GUESTS', 'u_', 6),
 574         ),
 575         'store_auto_increment'  => 'ROLE_ID',
 576 );
 577
 578 // Permissions
 579
 580 $schema_data[] = array(
 581         'table'         => 'phpbb_acl_groups',
 582         'columns'       => array('group_id', 'forum_id', 'auth_option_id', 'auth_role_id', 'auth_setting'),
 583         'data'          => array(
 584                 // GUESTS - u_download and u_search ability
 585                 array(array('auto_increment' => 'GROUP_ID:0'), 0, 0, array('auto_increment' => 'ROLE_ID:22'), 0),
 586                 // ADMINISTRATOR Group - full user features
 587                 array(array('auto_increment' => 'GROUP_ID:4'), 0, 0, array('auto_increment' => 'ROLE_ID:4'), 0),
 588                 // ADMINISTRATOR Group - standard admin
 589                 array(array('auto_increment' => 'GROUP_ID:4'), 0, 0, array('auto_increment' => 'ROLE_ID:0'), 0),
 590                 // REGISTERED and REGISTERED_COPPA having standard user features
 591                 array(array('auto_increment' => 'GROUP_ID:1'), 0, 0, array('auto_increment' => 'ROLE_ID:5'), 0),
 592                 array(array('auto_increment' => 'GROUP_ID:2'), 0, 0, array('auto_increment' => 'ROLE_ID:5'), 0),
 593                 // GLOBAL_MODERATORS having full user features
 594                 array(array('auto_increment' => 'GROUP_ID:3'), 0, 0, array('auto_increment' => 'ROLE_ID:4'), 0),
 595                 // GLOBAL_MODERATORS having full global moderator access
 596                 array(array('auto_increment' => 'GROUP_ID:3'), 0, 0, array('auto_increment' => 'ROLE_ID:9'), 0),
 597
 598                 // Giving all groups read only access to the first category
 599                 // since administrators and moderators are already within the registered users group we do not need to set them here
 600                 array(array('auto_increment' => 'GROUP_ID:0'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
 601                 array(array('auto_increment' => 'GROUP_ID:1'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
 602                 array(array('auto_increment' => 'GROUP_ID:2'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
 603                 array(array('auto_increment' => 'GROUP_ID:5'), array('auto_increment' => 'FORUM_ID:0'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
 604
 605                 // Giving access to the first forum
 606                 // guests having read only access
 607                 array(array('auto_increment' => 'GROUP_ID:0'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:16'), 0),
 608                 // registered and registered_coppa having standard access
 609                 array(array('auto_increment' => 'GROUP_ID:1'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:14'), 0),
 610                 array(array('auto_increment' => 'GROUP_ID:2'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:14'), 0),
 611                 // global moderators having standard access + polls
 612                 array(array('auto_increment' => 'GROUP_ID:3'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:20'), 0),
 613                 // administrators having full forum and full moderator access
 614                 array(array('auto_increment' => 'GROUP_ID:4'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:13'), 0),
 615                 array(array('auto_increment' => 'GROUP_ID:4'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:9'), 0),
 616                 // Bots having bot access
 617                 array(array('auto_increment' => 'GROUP_ID:5'), array('auto_increment' => 'FORUM_ID:1'), 0, array('auto_increment' => 'ROLE_ID:18'), 0),
 618         ),
 619 );
 620
 621 // phpbb_styles_imageset_data
 622 $schema_data[] = array(
 623         'table'         => 'phpbb_styles_imageset_data',
 624         'columns'       => array('image_name', 'image_filename', 'image_lang', 'image_height', 'image_width', 'imageset_id'),
 625         'data'          => array(
 626                 array('site_logo', 'site_logo.gif', '', 52, 139, array('auto_increment' => 'IMAGESET_ID:0')),
 627                 array('forum_link', 'forum_link.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 628                 array('forum_read', 'forum_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 629                 array('forum_read_locked', 'forum_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 630                 array('forum_read_subforum', 'forum_read_subforum.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 631                 array('forum_unread', 'forum_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 632                 array('forum_unread_locked', 'forum_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 633                 array('forum_unread_subforum', 'forum_unread_subforum.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 634                 array('topic_moved', 'topic_moved.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 635                 array('topic_read', 'topic_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 636                 array('topic_read_mine', 'topic_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 637                 array('topic_read_hot', 'topic_read_hot.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 638                 array('topic_read_hot_mine', 'topic_read_hot_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 639                 array('topic_read_locked', 'topic_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 640                 array('topic_read_locked_mine', 'topic_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 641                 array('topic_unread', 'topic_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 642                 array('topic_unread_mine', 'topic_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 643                 array('topic_unread_hot', 'topic_unread_hot.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 644                 array('topic_unread_hot_mine', 'topic_unread_hot_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 645                 array('topic_unread_locked', 'topic_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 646                 array('topic_unread_locked_mine', 'topic_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 647                 array('sticky_read', 'sticky_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 648                 array('sticky_read_mine', 'sticky_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 649                 array('sticky_read_locked', 'sticky_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 650                 array('sticky_read_locked_mine', 'sticky_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 651                 array('sticky_unread', 'sticky_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 652                 array('sticky_unread_mine', 'sticky_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 653                 array('sticky_unread_locked', 'sticky_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 654                 array('sticky_unread_locked_mine', 'sticky_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 655                 array('announce_read', 'announce_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 656                 array('announce_read_mine', 'announce_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 657                 array('announce_read_locked', 'announce_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 658                 array('announce_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 659                 array('announce_unread', 'announce_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 660                 array('announce_unread_mine', 'announce_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 661                 array('announce_unread_locked', 'announce_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 662                 array('announce_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 663                 array('global_read', 'announce_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 664                 array('global_read_mine', 'announce_read_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 665                 array('global_read_locked', 'announce_read_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 666                 array('global_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 667                 array('global_unread', 'announce_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 668                 array('global_unread_mine', 'announce_unread_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 669                 array('global_unread_locked', 'announce_unread_locked.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 670                 array('global_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 671                 array('pm_read', 'topic_read.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 672                 array('pm_unread', 'topic_unread.gif', '', 27, 27, array('auto_increment' => 'IMAGESET_ID:0')),
 673                 array('icon_back_top', 'icon_back_top.gif', '', 11, 11, array('auto_increment' => 'IMAGESET_ID:0')),
 674                 array('icon_contact_aim', 'icon_contact_aim.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 675                 array('icon_contact_email', 'icon_contact_email.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 676                 array('icon_contact_icq', 'icon_contact_icq.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 677                 array('icon_contact_jabber', 'icon_contact_jabber.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 678                 array('icon_contact_msnm', 'icon_contact_msnm.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 679                 array('icon_contact_www', 'icon_contact_www.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 680                 array('icon_contact_yahoo', 'icon_contact_yahoo.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 681                 array('icon_post_delete', 'icon_post_delete.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 682                 array('icon_post_info', 'icon_post_info.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 683                 array('icon_post_report', 'icon_post_report.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 684                 array('icon_post_target', 'icon_post_target.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
 685                 array('icon_post_target_unread', 'icon_post_target_unread.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
 686                 array('icon_topic_attach', 'icon_topic_attach.gif', '', 10, 7, array('auto_increment' => 'IMAGESET_ID:0')),
 687                 array('icon_topic_latest', 'icon_topic_latest.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
 688                 array('icon_topic_newest', 'icon_topic_newest.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
 689                 array('icon_topic_reported', 'icon_topic_reported.gif', '', 14, 16, array('auto_increment' => 'IMAGESET_ID:0')),
 690                 array('icon_topic_unapproved', 'icon_topic_unapproved.gif', '', 14, 16, array('auto_increment' => 'IMAGESET_ID:0')),
 691                 array('icon_user_warn', 'icon_user_warn.gif', '', 20, 20, array('auto_increment' => 'IMAGESET_ID:0')),
 692                 array('subforum_read', 'subforum_read.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
 693                 array('subforum_unread', 'subforum_unread.gif', '', 9, 11, array('auto_increment' => 'IMAGESET_ID:0')),
 694         ),
 695 );
 696
 697 // Smilies
 698 $schema_data[] = array(
 699         'table'         => 'phpbb_smilies',
 700         'columns'       => array('code', 'smiley_url', 'emotion', 'smiley_width', 'smiley_height', 'smiley_order'),
 701         'data'          => array(
 702                 array(':D', 'icon_e_biggrin.gif', '{L_SMILIES_VERY_HAPPY}', 15, 17, 1),
 703                 array(':-D', 'icon_e_biggrin.gif', '{L_SMILIES_VERY_HAPPY}', 15, 17, 2),
 704                 array(':grin:', 'icon_e_biggrin.gif', '{L_SMILIES_VERY_HAPPY}', 15, 17, 3),
 705                 array(':)', 'icon_e_smile.gif', '{L_SMILIES_SMILE}', 15, 17, 4),
 706                 array(':-)', 'icon_e_smile.gif', '{L_SMILIES_SMILE}', 15, 17, 5),
 707                 array(':smile:', 'icon_e_smile.gif', '{L_SMILIES_SMILE}', 15, 17, 6),
 708                 array(';)', 'icon_e_wink.gif', '{L_SMILIES_WINK}', 15, 17, 7),
 709                 array(';-)', 'icon_e_wink.gif', '{L_SMILIES_WINK}', 15, 17, 8),
 710                 array(':wink:', 'icon_e_wink.gif', '{L_SMILIES_WINK}', 15, 17, 9),
 711                 array(':(', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 10),
 712                 array(':-(', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 11),
 713                 array(':sad:', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 12),
 714                 array(':o', 'icon_e_surprised.gif', '{L_SMILIES_SURPRISED}', 15, 17, 13),
 715                 array(':-o', 'icon_e_surprised.gif', '{L_SMILIES_SURPRISED}', 15, 17, 14),
 716                 array(':eek:', 'icon_e_surprised.gif', '{L_SMILIES_SURPRISED}', 15, 17, 15),
 717                 array(':shock:', 'icon_eek.gif', '{L_SMILIES_SHOCKED}', 15, 17, 16),
 718                 array(':?', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 17),
 719                 array(':-?', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 18),
 720                 array(':???:', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 19),
 721                 array('8-)', 'icon_cool.gif', '{L_SMILIES_COOL}', 15, 17, 20),
 722                 array(':cool:', 'icon_cool.gif', '{L_SMILIES_COOL}', 15, 17, 21),
 723                 array(':lol:', 'icon_lol.gif', '{L_SMILIES_LAUGHING}', 15, 17, 22),
 724                 array(':x', 'icon_mad.gif', '{L_SMILIES_MAD}', 15, 17, 23),
 725                 array(':-x', 'icon_mad.gif', '{L_SMILIES_MAD}', 15, 17, 24),
 726                 array(':mad:', 'icon_mad.gif', '{L_SMILIES_MAD}', 15, 17, 25),
 727                 array(':P', 'icon_razz.gif', '{L_SMILIES_RAZZ}', 15, 17, 26),
 728                 array(':-P', 'icon_razz.gif', '{L_SMILIES_RAZZ}', 15, 17, 27),
 729                 array(':razz:', 'icon_razz.gif', '{L_SMILIES_RAZZ}', 15, 17, 28),
 730                 array(':oops:', 'icon_redface.gif', '{L_SMILIES_EMARRASSED}', 15, 17, 29),
 731                 array(':cry:', 'icon_cry.gif', '{L_SMILIES_CRYING}', 15, 17, 30),
 732                 array(':evil:', 'icon_evil.gif', '{L_SMILIES_EVIL}', 15, 17, 31),
 733                 array(':twisted:', 'icon_twisted.gif', '{L_SMILIES_TWISTED_EVIL}', 15, 17, 32),
 734                 array(':roll:', 'icon_rolleyes.gif', '{L_SMILIES_ROLLING_EYES}', 15, 17, 33),
 735                 array(':!:', 'icon_exclaim.gif', '{L_SMILIES_EXCLAMATION}', 15, 17, 34),
 736                 array(':?:', 'icon_question.gif', '{L_SMILIES_QUESTION}', 15, 17, 35),
 737                 array(':idea:', 'icon_idea.gif', '{L_SMILIES_IDEA}', 15, 17, 36),
 738                 array(':arrow:', 'icon_arrow.gif', '{L_SMILIES_ARROW}', 15, 17, 37),
 739                 array(':|', 'icon_neutral.gif', '{L_SMILIES_NEUTRAL}', 15, 17, 38),
 740                 array(':-|', 'icon_neutral.gif', '{L_SMILIES_NEUTRAL}', 15, 17, 39),
 741                 array(':mrgreen:', 'icon_mrgreen.gif', '{L_SMILIES_MR_GREEN}', 15, 17, 40),
 742                 array(':geek:', 'icon_e_geek.gif', '{L_SMILIES_GEEK}', 17, 17, 41),
 743                 array(':ugeek:', 'icon_e_ugeek.gif', '{L_SMILIES_UBER_GEEK}', 17, 18, 42),
 744         ),
 745 );
 746
 747 // icons
 748 $schema_data[] = array(
 749         'table'         => 'phpbb_icons',
 750         'columns'       => array('icons_url', 'icons_width', 'icons_height', 'icons_order', 'display_on_posting'),
 751         'data'          => array(
 752                 array('misc/fire.gif', 16, 16, 1, 1),
 753                 array('smile/redface.gif', 16, 16, 9, 1),
 754                 array('smile/mrgreen.gif', 16, 16, 10, 1),
 755                 array('misc/heart.gif', 16, 16, 4, 1),
 756                 array('misc/star.gif', 16, 16, 2, 1),
 757                 array('misc/radioactive.gif', 16, 16, 3, 1),
 758                 array('misc/thinking.gif', 16, 16, 5, 1),
 759                 array('smile/info.gif', 16, 16, 8, 1),
 760                 array('smile/question.gif', 16, 16, 6, 1),
 761                 array('smile/alert.gif', 16, 16, 7, 1),
 762         ),
 763 );
 764
 765 // reasons
 766 $schema_data[] = array(
 767         'table'         => 'phpbb_reports_reasons',
 768         'columns'       => array('reason_title', 'reason_description', 'reason_order'),
 769         'data'          => array(
 770                 array('warez', '{L_REPORT_WAREZ}', 1),
 771                 array('spam', '{L_REPORT_SPAM}', 2),
 772                 array('off_topic', '{L_REPORT_OFF_TOPIC}', 3),
 773                 array('other', '{L_REPORT_OTHER}', 4),
 774         ),
 775 );
 776
 777 // extension_groups
 778 $schema_data[] = array(
 779         'table'         => 'phpbb_extension_groups',
 780         'columns'       => array('group_name', 'cat_id', 'allow_group', 'download_mode', 'upload_icon', 'max_filesize', 'allowed_forums'),
 781         'data'          => array(
 782                 array('{L_EXT_GROUP_IMAGES}', 1, 1, 1, '', 0, ''),
 783                 array('{L_EXT_GROUP_ARCHIVES}', 0, 1, 1, '', 0, ''),
 784                 array('{L_EXT_GROUP_PLAIN_TEXT}', 0, 0, 1, '', 0, ''),
 785                 array('{L_EXT_GROUP_DOCUMENTS}', 0, 0, 1, '', 0, ''),
 786                 array('{L_EXT_GROUP_REAL_MEDIA}', 3, 0, 1, '', 0, ''),
 787                 array('{L_EXT_GROUP_WINDOWS_MEDIA}', 2, 0, 1, '', 0, ''),
 788                 array('{L_EXT_GROUP_FLASH_FILES}', 5, 0, 1, '', 0, ''),
 789                 array('{L_EXT_GROUP_QUICKTIME_MEDIA}', 6, 0, 1, '', 0, ''),
 790                 array('{L_EXT_GROUP_DOWNLOADABLE_FILES}', 0, 0, 1, '', 0, ''),
 791         ),
 792         'store_auto_increment'  => 'EXT_GROUP_ID',
 793 );
 794
 795 // extensions
 796 $schema_data[] = array(
 797         'table'         => 'phpbb_extensions',
 798         'columns'       => array('group_id', 'extension'),
 799         'data'          => array(
 800                 array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'gif'),
 801                 array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'png'),
 802                 array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'jpeg'),
 803                 array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'jpg'),
 804                 array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'tif'),
 805                 array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'tiff'),
 806                 array(array('auto_increment' => 'EXT_GROUP_ID:0'), 'tga'),
 807
 808                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'gtar'),
 809                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'gz'),
 810                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'tar'),
 811                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'zip'),
 812                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'rar'),
 813                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'ace'),
 814                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'torrent'),
 815                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'tgz'),
 816                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), 'bz2'),
 817                 array(array('auto_increment' => 'EXT_GROUP_ID:1'), '7z'),
 818
 819                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'txt'),
 820                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'c'),
 821                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'h'),
 822                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'cpp'),
 823                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'hpp'),
 824                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'diz'),
 825                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'csv'),
 826                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'ini'),
 827                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'log'),
 828                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'js'),
 829                 array(array('auto_increment' => 'EXT_GROUP_ID:2'), 'xml'),
 830
 831                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xls'),
 832                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xlsx'),
 833                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xlsm'),
 834                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'xlsb'),
 835                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'doc'),
 836                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'docx'),
 837                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'docm'),
 838                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'dot'),
 839                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'dotx'),
 840                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'dotm'),
 841                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'pdf'),
 842                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ai'),
 843                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ps'),
 844                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ppt'),
 845                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'pptx'),
 846                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'pptm'),
 847                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'odg'),
 848                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'odp'),
 849                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'ods'),
 850                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'odt'),
 851                 array(array('auto_increment' => 'EXT_GROUP_ID:3'), 'rtf'),
 852
 853                 array(array('auto_increment' => 'EXT_GROUP_ID:4'), 'rm'),
 854                 array(array('auto_increment' => 'EXT_GROUP_ID:4'), 'ram'),
 855
 856                 array(array('auto_increment' => 'EXT_GROUP_ID:5'), 'wma'),
 857                 array(array('auto_increment' => 'EXT_GROUP_ID:5'), 'wmv'),
 858
 859                 array(array('auto_increment' => 'EXT_GROUP_ID:6'), 'swf'),
 860
 861                 array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'mov'),
 862                 array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'm4v'),
 863                 array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'm4a'),
 864                 array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'mp4'),
 865                 array(array('auto_increment' => 'EXT_GROUP_ID:7'), '3gp'),
 866                 array(array('auto_increment' => 'EXT_GROUP_ID:7'), '3g2'),
 867                 array(array('auto_increment' => 'EXT_GROUP_ID:7'), 'qt'),
 868
 869                 array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'mpeg'),
 870                 array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'mpg'),
 871                 array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'mp3'),
 872                 array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'ogg'),
 873                 array(array('auto_increment' => 'EXT_GROUP_ID:8'), 'ogm'),
 874         ),
 875 );
 876
 877 ?>