Verzeichnisstruktur phpBB-3.3.15
- Veröffentlicht
- 28.08.2024
So funktioniert es
|
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
schema_data.sql
001 #
002 # $Id$
003 #
004
005 # POSTGRES BEGIN #
006
007 # -- Config
008 INSERT INTO phpbb_config (config_name, config_value) VALUES ('active_sessions', '0');
009 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_attachments', '1');
010 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin', '1');
011 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar', '1');
012 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_gravatar', '0');
013 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local', '0');
014 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote', '0');
015 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote_upload', '0');
016 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload', '1');
017 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode', '1');
018 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays', '1');
019 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_board_notifications', '1');
020 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bookmarks', '1');
021 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_cdn', '0');
022 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_emailreuse', '0');
023 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_forum_notify', '1');
024 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_live_searches', '1');
025 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_mass_pm', '1');
026 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_name_chars', 'USERNAME_CHARS_ANY');
027 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange', '0');
028 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_nocensors', '0');
029 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_password_reset', '1');
030 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_pm_attach', '0');
031 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_pm_report', '1');
032 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_post_flash', '1');
033 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_post_links', '1');
034 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_privmsg', '1');
035 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_quick_reply', '1');
036 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig', '1');
037 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_bbcode', '1');
038 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_flash', '0');
039 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_img', '1');
040 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_links', '1');
041 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_pm', '1');
042 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_smilies', '1');
043 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies', '1');
044 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_topic_notify', '1');
045 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allowed_schemes_links', 'http,https,ftp');
046 INSERT INTO phpbb_config (config_name, config_value) VALUES ('assets_version', '1');
047 INSERT INTO phpbb_config (config_name, config_value) VALUES ('attachment_quota', '52428800');
048 INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_bbcode_pm', '1');
049 INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_flash_pm', '0');
050 INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_img_pm', '1');
051 INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_method', 'db');
052 INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_smilies_pm', '1');
053 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize', '6144');
054 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path', 'images/avatars/gallery');
055 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height', '90');
056 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width', '90');
057 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_min_height', '20');
058 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_min_width', '20');
059 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path', 'images/avatars/upload');
060 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_salt', 'phpbb_avatar');
061 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_contact', 'contact@yourdomain.tld');
062 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_contact_name', '');
063 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable', '0');
064 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable_msg', '');
065 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email', 'address@yourdomain.tld');
066 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form', '0');
067 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig', '{L_CONFIG_BOARD_EMAIL_SIG}');
068 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_hide_emails', '1');
069 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_index_text', '');
070 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone', 'UTC');
071 INSERT INTO phpbb_config (config_name, config_value) VALUES ('browser_check', '1');
072 INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_interval', '10');
073 INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_type', 'd');
074 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cache_gc', '7200');
075 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd', '0');
076 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_3d_noise', '1');
077 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_fonts', '1');
078 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_foreground_noise', '0');
079 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_wave', '0');
080 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_x_grid', '25');
081 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_y_grid', '25');
082 INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_plugin', 'core.captcha.plugins.nogd');
083 INSERT INTO phpbb_config (config_name, config_value) VALUES ('check_attachment_content', '1');
084 INSERT INTO phpbb_config (config_name, config_value) VALUES ('check_dnsbl', '0');
085 INSERT INTO phpbb_config (config_name, config_value) VALUES ('chg_passforce', '0');
086 INSERT INTO phpbb_config (config_name, config_value) VALUES ('confirm_refresh', '1');
087 INSERT INTO phpbb_config (config_name, config_value) VALUES ('contact_admin_form_enable', '1');
088 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain', '');
089 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name', 'phpbb3');
090 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_notice', '0');
091 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path', '/');
092 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure', '0');
093 INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_enable', '0');
094 INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
095 INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
096 INSERT INTO phpbb_config (config_name, config_value) VALUES ('database_gc', '604800');
097 INSERT INTO phpbb_config (config_name, config_value) VALUES ('dbms_version', '');
098 INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat', 'D M d, Y g:i a');
099 INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_search_return_chars', '300');
100 INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style', '1');
101 INSERT INTO phpbb_config (config_name, config_value) VALUES ('delete_time', '0');
102 INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_last_edited', '1');
103 INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_last_subject', '1');
104 INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_order', '0');
105 INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_unapproved_posts', '1');
106 INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time', '0');
107 INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_check_mx', '1');
108 INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_enable', '1');
109 INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_force_sender', '0');
110 INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_max_chunk_size', '50');
111 INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size', '20');
112 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_accurate_pm_button', '1');
113 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');
114 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_mod_rewrite', '0');
115 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_pm_icons', '1');
116 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_post_confirm', '1');
117 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_queue_trigger', '0');
118 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_update_hashes', '1');
119 INSERT INTO phpbb_config (config_name, config_value) VALUES ('extension_force_unstable', '0');
120 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_enable', '1');
121 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_forum', '1');
122 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_http_auth', '0');
123 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_item_statistics', '1');
124 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_limit', '10');
125 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_limit_post', '15');
126 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_limit_topic', '10');
127 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_overall', '1');
128 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_overall_forums', '0');
129 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_overall_forums_limit', '15');
130 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_overall_topics', '0');
131 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_overall_topics_limit', '15');
132 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_topic', '1');
133 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_topics_active', '0');
134 INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_topics_new', '1');
135 INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval', '15');
136 INSERT INTO phpbb_config (config_name, config_value) VALUES ('force_server_vars', '0');
137 INSERT INTO phpbb_config (config_name, config_value) VALUES ('form_token_lifetime', '7200');
138 INSERT INTO phpbb_config (config_name, config_value) VALUES ('form_token_mintime', '0');
139 INSERT INTO phpbb_config (config_name, config_value) VALUES ('form_token_sid_guests', '1');
140 INSERT INTO phpbb_config (config_name, config_value) VALUES ('forward_pm', '1');
141 INSERT INTO phpbb_config (config_name, config_value) VALUES ('forwarded_for_check', '0');
142 INSERT INTO phpbb_config (config_name, config_value) VALUES ('full_folder_action', '2');
143 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_mysql_max_word_len', '254');
144 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_mysql_min_word_len', '4');
145 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_native_common_thres', '5');
146 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_native_load_upd', '1');
147 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_native_max_chars', '14');
148 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_native_min_chars', '3');
149 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_postgres_max_word_len', '254');
150 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_postgres_min_word_len', '4');
151 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_postgres_ts_name', 'simple');
152 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_sphinx_indexer_mem_limit', '512');
153 INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_sphinx_stopwords', '0');
154 INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress', '0');
155 INSERT INTO phpbb_config (config_name, config_value) VALUES ('help_send_statistics', '1');
156 INSERT INTO phpbb_config (config_name, config_value) VALUES ('help_send_statistics_time', '0');
157 INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold', '25');
158 INSERT INTO phpbb_config (config_name, config_value) VALUES ('icons_path', 'images/icons');
159 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_create_thumbnail', '0');
160 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_display_inlined', '1');
161 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_link_height', '0');
162 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_link_width', '0');
163 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_max_height', '0');
164 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_max_thumb_width', '400');
165 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_max_width', '0');
166 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_min_thumb_filesize', '12000');
167 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_quality', '85');
168 INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_strip_metadata', '0');
169 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_check', '3');
170 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_login_limit_max', '50');
171 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_login_limit_time', '21600');
172 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_login_limit_use_forwarded', '0');
173 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_allow_self_signed', '0');
174 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_enable', '0');
175 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_host', '');
176 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_package_size', '20');
177 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_password', '');
178 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_port', '5222');
179 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_use_ssl', '0');
180 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_username', '');
181 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_verify_peer', '1');
182 INSERT INTO phpbb_config (config_name, config_value) VALUES ('jab_verify_peer_name', '1');
183 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_base_dn', '');
184 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_email', '');
185 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_password', '');
186 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_port', '');
187 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_server', '');
188 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_uid', '');
189 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_user', '');
190 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_user_filter', '');
191 INSERT INTO phpbb_config (config_name, config_value) VALUES ('legend_sort_groupname', '0');
192 INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_load', '0');
193 INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_search_load', '0');
194 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_anon_lastread', '0');
195 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_birthdays', '1');
196 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_memberlist', '1');
197 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_pm', '1');
198 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_viewprofile', '1');
199 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_viewtopic', '1');
200 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_lastread', '1');
201 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_track', '1');
202 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_font_awesome_url', 'https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css');
203 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js');
204 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_jumpbox', '1');
205 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_moderators', '1');
206 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_notifications', '1');
207 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online', '1');
208 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online_guests', '1');
209 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online_time', '5');
210 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_onlinetrack', '1');
211 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_search', '1');
212 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_tplcompile', '0');
213 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_unreads_search', '1');
214 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_user_activity', '1');
215 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_user_activity_limit', '5000');
216 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments', '3');
217 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments_pm', '1');
218 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time', '0');
219 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize', '262144');
220 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize_pm', '262144');
221 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '3');
222 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_name_chars', '20');
223 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_num_search_keywords', '10');
224 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options', '10');
225 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_chars', '60000');
226 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_font_size', '200');
227 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_img_height', '0');
228 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_img_width', '0');
229 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_smilies', '0');
230 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_urls', '0');
231 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_quote_depth', '3');
232 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_reg_attempts', '5');
233 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars', '255');
234 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_font_size', '200');
235 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_img_height', '0');
236 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_img_width', '0');
237 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_smilies', '0');
238 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_urls', '5');
239 INSERT INTO phpbb_config (config_name, config_value) VALUES ('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title');
240 INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_name_chars', '3');
241 INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_pass_chars', '6');
242 INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_post_chars', '1');
243 INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_search_author_chars', '3');
244 INSERT INTO phpbb_config (config_name, config_value) VALUES ('new_member_group_default', '0');
245 INSERT INTO phpbb_config (config_name, config_value) VALUES ('new_member_post_limit', '3');
246 INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style', '0');
247 INSERT INTO phpbb_config (config_name, config_value) VALUES ('pass_complex', 'PASS_TYPE_ANY');
248 INSERT INTO phpbb_config (config_name, config_value) VALUES ('plupload_salt', 'phpbb_plupload');
249 INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_edit_time', '0');
250 INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_boxes', '4');
251 INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs', '50');
252 INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_recipients', '0');
253 INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page', '10');
254 INSERT INTO phpbb_config (config_name, config_value) VALUES ('print_pm', '1');
255 INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '60');
256 INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_trigger_posts', '3');
257 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ranks_path', 'images/ranks');
258 INSERT INTO phpbb_config (config_name, config_value) VALUES ('read_notification_expire_days', '30');
259 INSERT INTO phpbb_config (config_name, config_value) VALUES ('read_notification_gc', '86400');
260 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_domain', 'google.com');
261 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_key', '');
262 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_method', 'post');
263 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_secret', '');
264 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_threshold_default', '0.5');
265 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_threshold_login', '0.5');
266 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_threshold_post', '0.5');
267 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_threshold_register', '0.5');
268 INSERT INTO phpbb_config (config_name, config_value) VALUES ('recaptcha_v3_threshold_report', '0.5');
269 INSERT INTO phpbb_config (config_name, config_value) VALUES ('referer_validation', '1');
270 INSERT INTO phpbb_config (config_name, config_value) VALUES ('remote_upload_verify', '0');
271 INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation', '0');
272 INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '');
273 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_anonymous_interval', '0');
274 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_block_size', '250');
275 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_gc', '7200');
276 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_interval', '0');
277 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_store_results', '1800');
278 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_type', '\phpbb\search\fulltext_native');
279 INSERT INTO phpbb_config (config_name, config_value) VALUES ('secure_allow_deny', '1');
280 INSERT INTO phpbb_config (config_name, config_value) VALUES ('secure_allow_empty_referer', '1');
281 INSERT INTO phpbb_config (config_name, config_value) VALUES ('secure_downloads', '0');
282 INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', '');
283 INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '');
284 INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_protocol', '');
285 INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_gc', '3600');
286 INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length', '3600');
287 INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc', '{L_CONFIG_SITE_DESC}');
288 INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_home_text', '');
289 INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_home_url', '');
290 INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename', '{L_CONFIG_SITENAME}');
291 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path', 'images/smilies');
292 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_per_page', '50');
293 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_allow_self_signed', '0');
294 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_auth_method', 'PLAIN');
295 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery', '0');
296 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host', '');
297 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_port', '25');
298 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_verify_peer', '1');
299 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_verify_peer_name', '1');
300 INSERT INTO phpbb_config (config_name, config_value) VALUES ('teampage_forums', '1');
301 INSERT INTO phpbb_config (config_name, config_value) VALUES ('teampage_memberships', '1');
302 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.pm_text_cron_interval', '10');
303 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.pm_text_last_cron', '0');
304 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.poll_option_cron_interval', '10');
305 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.poll_option_last_cron', '0');
306 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.poll_title_cron_interval', '10');
307 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.poll_title_last_cron', '0');
308 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.post_text_cron_interval', '10');
309 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.post_text_last_cron', '0');
310 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.user_signature_cron_interval', '10');
311 INSERT INTO phpbb_config (config_name, config_value) VALUES ('text_reparser.user_signature_last_cron', '0');
312 INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page', '25');
313 INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');
314 INSERT INTO phpbb_config (config_name, config_value) VALUES ('update_hashes_last_cron', '0');
315 INSERT INTO phpbb_config (config_name, config_value) VALUES ('update_hashes_lock', '0');
316 INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');
317 INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');
318 INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_system_cron', '0');
319 INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.3.15');
320 INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');
321 INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');
322
323 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('cache_last_gc', '0', 1);
324 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('cron_lock', '0', 1);
325 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('database_last_gc', '0', 1);
326 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('last_queue_run', '0', 1);
327 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_colour', 'AA0000', 1);
328 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_id', '2', 1);
329 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_username', '', 1);
330 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_files', '0', 1);
331 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_posts', '1', 1);
332 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_topics', '1', 1);
333 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_users', '1', 1);
334 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('plupload_last_gc', '0', 1);
335 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('rand_seed', '0', 1);
336 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('rand_seed_last_update', '0', 1);
337 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('read_notification_last_gc', '0', 1);
338 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_date', '0', 1);
339 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_users', '0', 1);
340 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('reparse_lock', '0', 1);
341 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('search_indexing_state', '', 1);
342 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('search_last_gc', '0', 1);
343 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('session_last_gc', '0', 1);
344 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('smtp_password', '', 1);
345 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('smtp_username', '', 1);
346 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('upload_dir_size', '0', 1);
347 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('warnings_last_gc', '0', 1);
348
349 # Config text
350 INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('contact_admin_info', '');
351 INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('contact_admin_info_uid', '');
352 INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('contact_admin_info_bitfield', '');
353 INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('contact_admin_info_flags', '7');
354
355 # -- Forum related auth options
356 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_', 1);
357 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_announce', 1);
358 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_announce_global', 1);
359 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_attach', 1);
360 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_bbcode', 1);
361 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_bump', 1);
362 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_delete', 1);
363 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_download', 1);
364 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_edit', 1);
365 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_email', 1);
366 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_flash', 1);
367 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_icons', 1);
368 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_ignoreflood', 1);
369 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_img', 1);
370 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_list', 1);
371 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_list_topics', 1);
372 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_noapprove', 1);
373 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_poll', 1);
374 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_post', 1);
375 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_postcount', 1);
376 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_print', 1);
377 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_read', 1);
378 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_reply', 1);
379 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_report', 1);
380 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_search', 1);
381 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_sigs', 1);
382 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_smilies', 1);
383 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_sticky', 1);
384 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_subscribe', 1);
385 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_user_lock', 1);
386 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_vote', 1);
387 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_votechg', 1);
388 INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_softdelete', 1);
389
390 # -- Moderator related auth options
391 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_', 1, 1);
392 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_approve', 1, 1);
393 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_chgposter', 1, 1);
394 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_delete', 1, 1);
395 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_edit', 1, 1);
396 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_info', 1, 1);
397 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_lock', 1, 1);
398 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_merge', 1, 1);
399 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_move', 1, 1);
400 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_report', 1, 1);
401 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_split', 1, 1);
402 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_softdelete', 1, 1);
403
404 # -- Global moderator auth option (not a local option)
405 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_ban', 0, 1);
406 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_pm_report', 0, 1);
407 INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_warn', 0, 1);
408
409 # -- Admin related auth options
410 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_', 1);
411 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_aauth', 1);
412 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_attach', 1);
413 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_authgroups', 1);
414 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_authusers', 1);
415 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_backup', 1);
416 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_ban', 1);
417 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_bbcode', 1);
418 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_board', 1);
419 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_bots', 1);
420 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_clearlogs', 1);
421 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_email', 1);
422 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_extensions', 1);
423 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_fauth', 1);
424 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_forum', 1);
425 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_forumadd', 1);
426 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_forumdel', 1);
427 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_group', 1);
428 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_groupadd', 1);
429 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_groupdel', 1);
430 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_icons', 1);
431 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_jabber', 1);
432 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_language', 1);
433 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_mauth', 1);
434 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_modules', 1);
435 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_names', 1);
436 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_phpinfo', 1);
437 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_profile', 1);
438 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_prune', 1);
439 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_ranks', 1);
440 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_reasons', 1);
441 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_roles', 1);
442 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_search', 1);
443 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_server', 1);
444 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_styles', 1);
445 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_switchperm', 1);
446 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_uauth', 1);
447 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_user', 1);
448 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_userdel', 1);
449 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_viewauth', 1);
450 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_viewlogs', 1);
451 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_words', 1);
452
453 # -- User related auth options
454 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_', 1);
455 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_attach', 1);
456 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgavatar', 1);
457 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgcensors', 1);
458 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgemail', 1);
459 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chggrp', 1);
460 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgname', 1);
461 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgpasswd', 1);
462 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgprofileinfo', 1);
463 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_download', 1);
464 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_emoji', 1);
465 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_hideonline', 1);
466 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_ignoreflood', 1);
467 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_masspm', 1);
468 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_masspm_group', 1);
469 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_attach', 1);
470 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_bbcode', 1);
471 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_delete', 1);
472 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_download', 1);
473 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_edit', 1);
474 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_emailpm', 1);
475 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_flash', 1);
476 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_forward', 1);
477 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_img', 1);
478 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_printpm', 1);
479 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_smilies', 1);
480 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_readpm', 1);
481 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_savedrafts', 1);
482 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_search', 1);
483 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_sendemail', 1);
484 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_sendim', 1);
485 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_sendpm', 1);
486 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_sig', 1);
487 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_viewonline', 1);
488 INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_viewprofile', 1);
489
490
491 # -- standard auth roles
492 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_ADMIN_STANDARD', 'ROLE_DESCRIPTION_ADMIN_STANDARD', 'a_', 1);
493 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_ADMIN_FORUM', 'ROLE_DESCRIPTION_ADMIN_FORUM', 'a_', 3);
494 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_ADMIN_USERGROUP', 'ROLE_DESCRIPTION_ADMIN_USERGROUP', 'a_', 4);
495 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_ADMIN_FULL', 'ROLE_DESCRIPTION_ADMIN_FULL', 'a_', 2);
496 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_FULL', 'ROLE_DESCRIPTION_USER_FULL', 'u_', 3);
497 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_STANDARD', 'ROLE_DESCRIPTION_USER_STANDARD', 'u_', 1);
498 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_LIMITED', 'ROLE_DESCRIPTION_USER_LIMITED', 'u_', 2);
499 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_NOPM', 'ROLE_DESCRIPTION_USER_NOPM', 'u_', 4);
500 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_NOAVATAR', 'ROLE_DESCRIPTION_USER_NOAVATAR', 'u_', 5);
501 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_MOD_FULL', 'ROLE_DESCRIPTION_MOD_FULL', 'm_', 3);
502 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_MOD_STANDARD', 'ROLE_DESCRIPTION_MOD_STANDARD', 'm_', 1);
503 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_MOD_SIMPLE', 'ROLE_DESCRIPTION_MOD_SIMPLE', 'm_', 2);
504 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_MOD_QUEUE', 'ROLE_DESCRIPTION_MOD_QUEUE', 'm_', 4);
505 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_FULL', 'ROLE_DESCRIPTION_FORUM_FULL', 'f_', 7);
506 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_STANDARD', 'ROLE_DESCRIPTION_FORUM_STANDARD', 'f_', 5);
507 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_NOACCESS', 'ROLE_DESCRIPTION_FORUM_NOACCESS', 'f_', 1);
508 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_READONLY', 'ROLE_DESCRIPTION_FORUM_READONLY', 'f_', 2);
509 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_LIMITED', 'ROLE_DESCRIPTION_FORUM_LIMITED', 'f_', 3);
510 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_BOT', 'ROLE_DESCRIPTION_FORUM_BOT', 'f_', 9);
511 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_ONQUEUE', 'ROLE_DESCRIPTION_FORUM_ONQUEUE', 'f_', 8);
512 INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_POLLS', 'ROLE_DESCRIPTION_FORUM_POLLS', 'f_', 6);
513 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);
514
515 # 23
516 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);
517
518 # 24
519 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);
520
521 # -- phpbb_styles
522 INSERT INTO phpbb_styles (style_name, style_copyright, style_active, style_path, bbcode_bitfield, style_parent_id, style_parent_tree) VALUES ('prosilver', '© phpBB Limited', 1, 'prosilver', '//g=', 0, '');
523
524 # -- Forums
525 INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents) VALUES ('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 'Admin', 'AA0000', 972086460, '', '', '', '', '', '', '', 0, 0, '');
526
527 INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_subject, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_freq, prune_days, prune_viewed, forum_parents, forum_flags) VALUES ('{L_FORUMS_TEST_FORUM_TITLE}', '{L_FORUMS_TEST_FORUM_DESC}', 2, 3, 1, 1, 1, 0, 0, 1, 0, 0, 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, '', '', '', '', '', '', '', 1, 7, 7, '', 48);
528
529 # -- Users / Anonymous user
530 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_jabber, user_actkey, user_actkey_expiration, user_newpasswd, user_allow_massemail) VALUES (2, 1, 'Anonymous', 'anonymous', 0, '', '', 'en', 1, 0, '', 0, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', 0, '', 0);
531
532 # -- username: Admin password: admin (change this or remove it once everything is working!)
533 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_jabber, user_actkey, user_actkey_expiration, user_newpasswd) VALUES (3, 5, 'Admin', 'admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', 0, '');
534
535 # -- Groups
536 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);
537 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);
538 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);
539 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', 2, '', '', '', 0);
540 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);
541 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);
542 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);
543
544 # -- Teampage
545 INSERT INTO phpbb_teampage (group_id, teampage_name, teampage_position, teampage_parent) VALUES (5, '', 1, 0);
546 INSERT INTO phpbb_teampage (group_id, teampage_name, teampage_position, teampage_parent) VALUES (4, '', 2, 0);
547
548 # -- User -> Group
549 INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (1, 1, 0, 0);
550 INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (2, 2, 0, 0);
551 INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (4, 2, 0, 0);
552 INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (5, 2, 0, 1);
553
554 # -- Ranks
555 INSERT INTO phpbb_ranks (rank_title, rank_min, rank_special, rank_image) VALUES ('{L_RANKS_SITE_ADMIN_TITLE}', 0, 1, '');
556
557 # -- Roles data
558
559 # Standard Admin (a_)
560 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');
561
562 # Forum admin (a_)
563 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');
564
565 # User and Groups Admin (a_)
566 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');
567
568 # Full Admin (a_)
569 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_%';
570
571 # All Features (u_)
572 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_%';
573
574 # Standard Features (u_)
575 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');
576
577 # Limited Features (u_)
578 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');
579
580 # No Private Messages (u_)
581 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');
582 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');
583
584 # No Avatar (u_)
585 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');
586 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');
587
588 # Full Moderator (m_)
589 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_%';
590
591 # Standard Moderator (m_)
592 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');
593
594 # Simple Moderator (m_)
595 INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 12, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option IN ('m_', 'm_delete', 'm_softdelete', 'm_edit', 'm_info', 'm_report', 'm_pm_report');
596
597 # Queue Moderator (m_)
598 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');
599
600 # Full Access (f_)
601 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_%';
602
603 # Standard Access (f_)
604 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_announce_global', 'f_flash', 'f_ignoreflood', 'f_poll', 'f_sticky', 'f_user_lock');
605
606 # No Access (f_)
607 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_';
608
609 # Read Only Access (f_)
610 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_list_topics', 'f_read', 'f_search', 'f_subscribe', 'f_print');
611
612 # Limited Access (f_)
613 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_announce_global', 'f_attach', 'f_bump', 'f_delete', 'f_flash', 'f_icons', 'f_ignoreflood', 'f_poll', 'f_sticky', 'f_user_lock', 'f_votechg');
614
615 # Bot Access (f_)
616 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_list_topics', 'f_read', 'f_print');
617
618 # On Moderation Queue (f_)
619 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_announce_global', 'f_bump', 'f_delete', 'f_flash', 'f_icons', 'f_ignoreflood', 'f_poll', 'f_sticky', 'f_user_lock', 'f_votechg', 'f_noapprove');
620 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');
621
622 # Standard Access + Polls (f_)
623 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_announce_global', 'f_flash', 'f_ignoreflood', 'f_sticky', 'f_user_lock');
624
625 # Limited Access + Polls (f_)
626 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_announce_global', 'f_attach', 'f_bump', 'f_delete', 'f_flash', 'f_icons', 'f_ignoreflood', 'f_sticky', 'f_user_lock', 'f_votechg');
627
628 # New Member (u_)
629 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', 'u_chgprofileinfo');
630
631 # New Member (f_)
632 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');
633
634
635 # Permissions
636
637 # GUESTS - u_download and u_search ability
638 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');
639
640 # Admin user - full user features
641 INSERT INTO phpbb_acl_users (user_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (2, 0, 0, 5, 0);
642
643 # ADMINISTRATOR Group - full user features
644 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (5, 0, 0, 5, 0);
645
646 # ADMINISTRATOR Group - standard admin
647 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (5, 0, 0, 1, 0);
648
649 # REGISTERED and REGISTERED_COPPA having standard user features
650 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (2, 0, 0, 6, 0);
651 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (3, 0, 0, 6, 0);
652
653 # GLOBAL_MODERATORS having full user features
654 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (4, 0, 0, 5, 0);
655
656 # GLOBAL_MODERATORS having full global moderator access
657 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (4, 0, 0, 10, 0);
658
659 # Giving all groups read only access to the first category
660 # since administrators and moderators are already within the registered users group we do not need to set them here
661 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (1, 1, 0, 17, 0);
662 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (2, 1, 0, 17, 0);
663 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (3, 1, 0, 17, 0);
664 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (6, 1, 0, 17, 0);
665
666 # Giving access to the first forum
667
668 # guests having read only access
669 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (1, 2, 0, 17, 0);
670
671 # registered and registered_coppa having standard access
672 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (2, 2, 0, 15, 0);
673 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (3, 2, 0, 15, 0);
674
675 # global moderators having standard access + polls
676 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (4, 2, 0, 21, 0);
677
678 # administrators having full forum and full moderator access
679 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (5, 2, 0, 14, 0);
680 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (5, 2, 0, 10, 0);
681
682 # Bots having bot access
683 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (6, 2, 0, 19, 0);
684
685 # NEW MEMBERS are not allowed to send private messages
686 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (7, 0, 0, 23, 0);
687
688 # NEW MEMBERS on the queue
689 INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (7, 2, 0, 24, 0);
690
691
692 # -- Demo Topic
693 INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, topic_views, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, forum_id, topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_first_poster_colour, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour, topic_last_post_subject, topic_last_post_time, topic_last_view_time, poll_title, topic_visibility) VALUES ('{L_TOPICS_TOPIC_TITLE}', 2, 972086460, 0, 1, 0, 0, 2, 0, 0, 1, 'Admin', 'AA0000', 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, 972086460, '', 1);
694
695 # -- Demo Post
696 INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, icon_id, post_time, post_username, poster_ip, post_subject, post_text, post_checksum, bbcode_uid, post_visibility) VALUES (1, 2, 2, 0, 972086460, '', '127.0.0.1', '{L_TOPICS_TOPIC_TITLE}', '{L_DEFAULT_INSTALL_POST}', '5dd683b17f641daf84c040bfefc58ce9', '', 1);
697
698 # -- Admin posted to the demo topic
699 INSERT INTO phpbb_topics_posted (user_id, topic_id, topic_posted) VALUES (2, 1, 1);
700
701 # -- Smilies
702 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);
703 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);
704 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);
705 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);
706 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);
707 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);
708 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);
709 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);
710 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);
711 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);
712 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);
713 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);
714 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);
715 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);
716 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);
717 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);
718 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);
719 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);
720 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);
721 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);
722 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);
723 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);
724 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);
725 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);
726 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);
727 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);
728 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);
729 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);
730 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);
731 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);
732 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);
733 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);
734 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);
735 INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':!:', 'icon_exclaim.gif', '{L_SMILIES_EXCLAMATION}', 15, 17, 34);
736 INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':?:', 'icon_question.gif', '{L_SMILIES_QUESTION}', 15, 17, 35);
737 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);
738 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);
739 INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':|', 'icon_neutral.gif', '{L_SMILIES_NEUTRAL}', 15, 17, 38);
740 INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':-|', 'icon_neutral.gif', '{L_SMILIES_NEUTRAL}', 15, 17, 39);
741 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);
742 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);
743 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);
744
745 # -- icons
746 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/fire.gif', 16, 16, 1, 1);
747 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/redface.gif', 16, 16, 9, 1);
748 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/mrgreen.gif', 16, 16, 10, 1);
749 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/heart.gif', 16, 16, 4, 1);
750 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/star.gif', 16, 16, 2, 1);
751 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/radioactive.gif', 16, 16, 3, 1);
752 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/thinking.gif', 16, 16, 5, 1);
753 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/info.gif', 16, 16, 8, 1);
754 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/question.gif', 16, 16, 6, 1);
755 INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/alert.gif', 16, 16, 7, 1);
756
757 # -- reasons
758 INSERT INTO phpbb_reports_reasons (reason_title, reason_description, reason_order) VALUES ('warez', '{L_REPORT_WAREZ}', 1);
759 INSERT INTO phpbb_reports_reasons (reason_title, reason_description, reason_order) VALUES ('spam', '{L_REPORT_SPAM}', 2);
760 INSERT INTO phpbb_reports_reasons (reason_title, reason_description, reason_order) VALUES ('off_topic', '{L_REPORT_OFF_TOPIC}', 3);
761 INSERT INTO phpbb_reports_reasons (reason_title, reason_description, reason_order) VALUES ('other', '{L_REPORT_OTHER}', 4);
762
763 # -- extension_groups
764 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, '');
765 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, '');
766 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, '');
767 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, '');
768 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, '');
769
770 # -- extensions
771 INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'gif');
772 INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'png');
773 INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'jpeg');
774 INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'jpg');
775 INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'tif');
776 INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'tiff');
777 INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'tga');
778
779 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'gtar');
780 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'gz');
781 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'tar');
782 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'zip');
783 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'rar');
784 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'ace');
785 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'torrent');
786 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'tgz');
787 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, 'bz2');
788 INSERT INTO phpbb_extensions (group_id, extension) VALUES (2, '7z');
789
790 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'txt');
791 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'c');
792 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'h');
793 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'cpp');
794 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'hpp');
795 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'diz');
796 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'csv');
797 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'ini');
798 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'log');
799 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'js');
800 INSERT INTO phpbb_extensions (group_id, extension) VALUES (3, 'xml');
801
802 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'xls');
803 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'xlsx');
804 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'xlsm');
805 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'xlsb');
806 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'doc');
807 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'docx');
808 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'docm');
809 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'dot');
810 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'dotx');
811 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'dotm');
812 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'pdf');
813 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'ai');
814 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'ps');
815 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'ppt');
816 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'pptx');
817 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'pptm');
818 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'odg');
819 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'odp');
820 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'ods');
821 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'odt');
822 INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'rtf');
823
824 INSERT INTO phpbb_extensions (group_id, extension) VALUES (5, 'mp3');
825 INSERT INTO phpbb_extensions (group_id, extension) VALUES (5, 'mpeg');
826 INSERT INTO phpbb_extensions (group_id, extension) VALUES (5, 'mpg');
827 INSERT INTO phpbb_extensions (group_id, extension) VALUES (5, 'ogg');
828 INSERT INTO phpbb_extensions (group_id, extension) VALUES (5, 'ogm');
829
830 # Add default profile fields
831 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_location', 'profilefields.type.string', 'phpbb_location', '20', '2', '100', '', '', '.*', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 1, 0, '', '');
832 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_website', 'profilefields.type.url', 'phpbb_website', '40', '12', '255', '', '', '', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 2, 1, 'VISIT_WEBSITE', '%s');
833 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_interests', 'profilefields.type.text', 'phpbb_interests', '3|30', '2', '500', '', '', '.*', 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 3, 0, '', '');
834 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_occupation', 'profilefields.type.text', 'phpbb_occupation', '3|30', '2', '500', '', '', '.*', 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 4, 0, '', '');
835 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_icq', 'profilefields.type.string', 'phpbb_icq', '20', '3', '15', '', '', '[0-9]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 6, 1, 'SEND_ICQ_MESSAGE', 'https://www.icq.com/people/%s/');
836 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_yahoo', 'profilefields.type.string', 'phpbb_yahoo', '40', '5', '255', '', '', '.*', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 8, 1, 'SEND_YIM_MESSAGE', 'ymsgr:sendim?%s');
837 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_facebook', 'profilefields.type.string', 'phpbb_facebook', '20', '5', '50', '', '', '[\w.]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 9, 1, 'VIEW_FACEBOOK_PROFILE', 'https://facebook.com/%s/');
838 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_twitter', 'profilefields.type.string', 'phpbb_twitter', '20', '1', '15', '', '', '[\w_]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 10, 1, 'VIEW_TWITTER_PROFILE', 'https://twitter.com/%s');
839 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_skype', 'profilefields.type.string', 'phpbb_skype', '20', '6', '32', '', '', '[a-zA-Z][\w\.,\-_]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 11, 1, 'VIEW_SKYPE_PROFILE', 'skype:%s?userinfo');
840 INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_youtube', 'profilefields.type.string', 'phpbb_youtube', '20', '3', '60', '', '', '(@[a-zA-Z0-9_.-]{3,30}|c/[a-zA-Z][\w\.,\-_]+|(channel|user)/[a-zA-Z][\w\.,\-_]+)', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 12, 1, 'VIEW_YOUTUBE_PROFILE', 'https://youtube.com/%s');
841
842 # User Notification Options (for first user)
843 INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.post', 0, 2, 'notification.method.board');
844 INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.post', 0, 2, 'notification.method.email');
845 INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.topic', 0, 2, 'notification.method.board');
846 INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.topic', 0, 2, 'notification.method.email');
847 INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.forum', 0, 2, 'notification.method.board');
848 INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.forum', 0, 2, 'notification.method.email');
849
850 # POSTGRES COMMIT #
851