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