diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-06-14 12:24:23 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-06-14 12:24:23 +0000 |
| commit | a5ca1704be423c4f5d2e430cbb1d138b73d84299 (patch) | |
| tree | 58d843a437dbfae66083374d476855e237d03b14 | |
| parent | 2e91e6471329e49a07b05a3353bab00cf2b2815a (diff) | |
| download | forums-a5ca1704be423c4f5d2e430cbb1d138b73d84299.tar forums-a5ca1704be423c4f5d2e430cbb1d138b73d84299.tar.gz forums-a5ca1704be423c4f5d2e430cbb1d138b73d84299.tar.bz2 forums-a5ca1704be423c4f5d2e430cbb1d138b73d84299.tar.xz forums-a5ca1704be423c4f5d2e430cbb1d138b73d84299.zip | |
Single basic file ... hopefully this'll work okay ...
git-svn-id: file:///svn/phpbb/trunk@4128 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/firebird_basic.sql | 410 | ||||
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 272 | ||||
| -rw-r--r-- | phpBB/install/schemas/mssql_basic.sql | 244 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_basic.sql | 81 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 290 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_basic.sql | 186 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_triggers.sql | 217 | ||||
| -rw-r--r-- | phpBB/install/schemas/postgres_basic.sql | 184 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 532 |
9 files changed, 707 insertions, 1709 deletions
diff --git a/phpBB/install/schemas/firebird_basic.sql b/phpBB/install/schemas/firebird_basic.sql deleted file mode 100644 index 377e72af19..0000000000 --- a/phpBB/install/schemas/firebird_basic.sql +++ /dev/null @@ -1,410 +0,0 @@ -# -# Basic DB data for phpBB2 devel -# -# $Id$ -# - -# -- Config -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable_msg',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb22'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_attachments','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_topic_notify','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_forum_notify','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','10'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','30'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars/upload'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('icons_path','images/icons'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_enable','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_load', '2.0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('active_sessions', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_gc', '3600'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_gc', '7200'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_check', '4'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '2.1.1 [20021119]'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_chars', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_smilies', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_search_chars','3'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_search_chars','10'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_boxes','4'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs','50'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_port','25'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_interval','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','90'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','90'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_enable','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_method','db'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_server', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_base_dn', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_uid', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('lastread', '432000'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize', '262144'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('attachment_quota', '52428800'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments', '3'); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('upload_dir', 'files', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_users', '0', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_date', '0', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_id', '2', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_username', '', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_users', '1', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_posts', '1', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_topics', '1', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('session_last_gc', '0', 1); -INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('search_last_gc', '0', 1); - - -# -- lang -INSERT INTO phpbb_lang (lang_dir, lang_english_name, lang_local_name, lang_iso, lang_author) VALUES ('en', 'English [UK]', 'English [UK]', 'en_gb', 'phpBB Group'); - - -# -- auth options -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_list', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_read', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_post', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_reply', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_quote', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_edit', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_delete', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_poll', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_vote', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_announce', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_sticky', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_attach', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_download', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_html', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_bbcode', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_smilies', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_img', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_flash', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_sigs', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_search', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_email', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_rate', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_print', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_ignoreflood', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_ignorequeue', 1); -INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_postcount', 1); - -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_edit', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_delete', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_move', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_lock', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_split', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_merge', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_approve', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_unrate', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_auth', 1, 1); -INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_ip', 1, 1); - -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_server', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_defaults', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_board', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_cookies', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_clearlogs', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_words', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_icons', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_bbcode', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_attach', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_email', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_styles', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_user', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_useradd', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_userdel', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_ranks', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_ban', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_names', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_group', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_groupadd', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_groupdel', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_forum', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_forumadd', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_forumdel', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_prune', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_auth', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authmods', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authadmins', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authusers', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authgroups', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_backup', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_restore', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_search', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_events', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_cron', 1); - -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_sendemail', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_readpm', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_sendpm', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_viewonline', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_viewprofile', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgavatar', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgcolor', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgemail', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgname', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgpasswd', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_search', 1); - - -# -- phpbb_styles -INSERT INTO phpbb_styles (style_id, template_id, theme_id, imageset_id, style_name) VALUES (1, 1, 1, 1, 'subSilver'); - -# -- phpbb_styles_imageset -INSERT INTO phpbb_styles_imageset VALUES (1, 'subSilver © phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply-locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply-locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/icon_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/icon_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_icq_add.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_msnm.gif" width="59" height="18" border="0"', '', '', '', '', '', '', '', '"imagesets/subSilver/item.reported.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_minipost.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_minipost_new.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_latest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/icon_newest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/folder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_locked_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new_posted.gif" width="19" height="18" border="0"', '', '', '"imagesets/subSilver/voting_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" height="12" border="0"', '"imagesets/subSilver/voting_rcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/ratings/{RATE}.gif" width="45" height="17" border="0"'); - -# -- phpbb_styles_template -INSERT INTO phpbb_styles_template (template_id, template_name, template_path, poll_length, pm_box_length) VALUES (1, 'subSilver © phpBB Group', 'subSilver', 205, 175); - -# -- phpbb_styles_theme -INSERT INTO phpbb_styles_theme (theme_id, css_data, css_external) VALUES (1, 'body {background: white url(''templates/subSilver/images/background.png'') repeat-x;}\nth { background-image: url(''templates/subSilver/images/cellpic3.gif'') }\ntd.cat { background-image: url(''templates/subSilver/images/cellpic1.gif'') }\ntd.rowpic { background-image: url(''templates/subSilver/images/cellpic2.jpg''); background-repeat: repeat-y }\ntd.icqback { background-image: url(''templates/subSilver/images/icon_icq_add.gif''); background-repeat: no-repeat }', 'subSilver/subSilver.css'); - - -# -- Forums -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_post_time) VALUES (1, 'My first Category', '', 1, 4, 0, 0, 1, 1, 1, 2, 'Admin', 972086460); - -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_post_time) VALUES (2, 'Test Forum 1', 'This is just a test forum.', 2, 3, 1, 1, 1, 1, 1, 2, 'Admin', 972086460); - - -# -- Users -INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 1, 'Anonymous', 0, '', '', '', '', '', '', '', '', 0, 0, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, 0, '', '', 0, '', '', '', 0, 0); - -# -- username: Admin password: admin (change this or remove it once everything is working!) -INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active, user_founder) VALUES ( 2, 'Admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'en', 0, 'd M Y h:i a', '', '', 0, 1, 1); - - -# -- Ranks -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL); - - -# -- Groups -INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (1, 'GUESTS', 3); -INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (2, 'INACTIVE', 3); -INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (3, 'REGISTERED', 3); -INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (4, 'SUPER_MODERATORS', 3); -INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (5, 'ADMINISTRATORS', 3); - - -# -- User -> Group -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, 1, 0); -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (3, 2, 0); -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (5, 2, 0); - - -# -- User auth -INSERT INTO phpbb_auth_users (user_id, forum_id, auth_option_id, auth_allow_deny) SELECT 2, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value LIKE 'm_%'; -INSERT INTO phpbb_auth_users (user_id, forum_id, auth_option_id, auth_allow_deny) SELECT 2, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value LIKE 'm_%'; - - -# -- Group auth -# -- give very limited rights to GUEST and INACTIVE groups -# -- give basic, typically non-contencious rights to REGISTERED users -# -- give all admin rights to ADMIN group -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 1, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 1, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 2, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 2, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 3, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('f_', 'f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_edit', 'f_delete', 'f_vote', 'f_download', 'f_bbcode', 'f_smilies', 'f_img', 'f_flash', 'f_sigs', 'f_search', 'f_email', 'f_print', 'f_postcount'); -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 3, 1, auth_option_id, 2 FROM phpbb_auth_options WHERE auth_value IN ('f_poll', 'f_announce', 'f_sticky', 'f_attach', 'f_html', 'f_rate'); - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 3, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('f_', 'f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_edit', 'f_delete', 'f_vote', 'f_download', 'f_bbcode', 'f_smilies', 'f_img', 'f_flash', 'f_sigs', 'f_search', 'f_email', 'f_print', 'f_postcount'); -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 3, 2, auth_option_id, 2 FROM phpbb_auth_options WHERE auth_value IN ('f_poll', 'f_announce', 'f_sticky', 'f_attach', 'f_html', 'f_rate'); - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 5, 0, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value LIKE 'a_%'; - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 1, 0, auth_option_id, 0 FROM phpbb_auth_options WHERE auth_value IN ('u_%'); - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 2, 0, auth_option_id, 0 FROM phpbb_auth_options WHERE auth_value IN ('u_%'); - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 3, 0, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('u_', 'u_sendemail', 'u_readpm', 'u_sendpm', 'u_viewprofile', 'u_chgavatar', 'u_chgemail', 'u_chgpasswd', 'u_search'); -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 3, 2, auth_option_id, 2 FROM phpbb_auth_options WHERE auth_value IN ('u_viewonline', 'u_chgcolor', 'u_chgname'); - -INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) SELECT 5, 0, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_value IN ('u_%'); - - -# -- Moderator cache -INSERT INTO phpbb_moderator_cache (user_id, forum_id, username) VALUES (2, 2, 'Admin'); - - -# -- Demo Topic -INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_post_time) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 2, 0, 0, 1, 'Admin', 1, 2, 'Admin', 972086460); - - -# -- Demo Post -INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip, post_subject, post_text) VALUES (1, 1, 2, 2, 972086460, NULL, '127.0.0.1', NULL, 'This is an example post in your phpBB 2.2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!'); - - -# -- Smilies -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':D', 'icon_biggrin.gif', 'Very Happy', 15, 15, 1); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':)', 'icon_smile.gif', 'Smile', 15, 15, 2); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':(', 'icon_sad.gif', 'Sad', 15, 15, 3); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':o', 'icon_surprised.gif', 'Surprised', 15, 15, 4); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':eek:', 'icon_surprised.gif', 'Surprised', 15, 15, 5); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( '8O', 'icon_eek.gif', 'Shocked', 15, 15, 6); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':?', 'icon_confused.gif', 'Confused', 15, 15, 7); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( '8)', 'icon_cool.gif', 'Cool', 15, 15, 8); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':lol:', 'icon_lol.gif', 'Laughing', 15, 15, 9); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':x', 'icon_mad.gif', 'Mad', 15, 15, 10); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':P', 'icon_razz.gif', 'Razz', 15, 15, 11); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':oops:', 'icon_redface.gif', 'Embarassed', 15, 15, 12); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':cry:', 'icon_cry.gif', 'Crying or Very sad', 15, 15, 13); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 15, 15, 14); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 15, 15, 15); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 15, 15, 16); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ';)', 'icon_wink.gif', 'Wink', 15, 15, 17); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':!:', 'icon_exclaim.gif', 'Exclamation', 15, 15, 18); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':?:', 'icon_question.gif', 'Question', 15, 15, 19); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':idea:', 'icon_idea.gif', 'Idea', 15, 15, 20); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':arrow:', 'icon_arrow.gif', 'Arrow', 15, 15, 21); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':|', 'icon_neutral.gif', 'Neutral', 15, 15, 22); -INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height, smile_order) VALUES ( ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 15, 15, 23); - - -# -- icons ... these are just some of those in CVS -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('misc/arrow_bold_rgt.gif', 19, 19, 1, 1, 1); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('smile/redface_anim.gif', 19, 19, 9, 1, 2); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('smile/mr_green.gif', 19, 19, 10, 1, 3); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('misc/musical.gif', 19, 19, 4, 1, 4); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('misc/asterix.gif', 19, 19, 2, 1, 5); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('misc/square.gif', 19, 19, 3, 1, 6); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('smile/alien_grn.gif', 19, 19, 5, 1, 7); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('smile/idea.gif', 19, 19, 8, 1, 8); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('smile/question.gif', 19, 19, 6, 1, 9); -INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting, icons_order) VALUES ('smile/exclaim.gif', 19, 19, 7, 1, 10); - - -# -- ucp modules -INSERT INTO phpbb_ucp_modules (module_id, module_langname, module_filename, module_order) VALUES (1, 'Profile Settings', 'ucp/usercp_profile', 1); -INSERT INTO phpbb_ucp_modules (module_id, module_langname, module_filename, module_order) VALUES (2, 'Black/While Lists', 'ucp/usercp_lists', 2); - - -# -- wordlist -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 ); - - -# -- wordmatch -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 ); - - -# -- reasons -INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES ( 1, 0, 'warez', 'The reported post contains links to pirated or illegal software.' ); -INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES ( 2, 1, 'other', 'The reported post does not fit into any other category, please use the description field.' ); - -# -- forbidden_extensions -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (1,'php'); -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (2,'php3'); -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (3,'php4'); -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (4,'phtml'); -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (5,'pl'); -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (6,'asp'); -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (7,'cgi'); -INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (7,'aspx'); - -# -- extension_groups -INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (1,'Images',1,1,1,0); -INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (2,'Archives',0,1,1,0); -INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (3,'Plain Text',0,0,1,0); -INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (4,'Documents',0,0,1,0); -INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (5,'Real Media',0,0,2,0); -INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (6,'Streams',2,0,1,0); -INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (7,'Flash Files',3,0,1,0); - -# -- extensions -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (1, 1,'gif', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (2, 1,'png', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (3, 1,'jpeg', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (4, 1,'jpg', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (5, 1,'tif', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (6, 1,'tga', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (7, 2,'gtar', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (8, 2,'gz', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (9, 2,'tar', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (10, 2,'zip', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (11, 2,'rar', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (12, 2,'ace', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (13, 3,'txt', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (14, 3,'c', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (15, 3,'h', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (16, 3,'cpp', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (17, 3,'hpp', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (18, 3,'diz', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (19, 4,'xls', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (20, 4,'doc', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (21, 4,'dot', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (22, 4,'pdf', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (23, 4,'ai', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (24, 4,'ps', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (25, 4,'ppt', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (26, 5,'rm', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (27, 6,'wma', ''); -INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (28, 7,'swf', ''); diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index b0ea7fec99..feb7323016 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -4,10 +4,7 @@ # $Id$ # -# -------------------------------------------------------- -# -# Table structure for table `phpbb_attachments` -# +# Table: phpbb_attachments CREATE TABLE phpbb_attachments ( attach_id INTEGER DEFAULT 0 NOT NULL, post_id INTEGER DEFAULT 0 NOT NULL, @@ -20,11 +17,7 @@ CREATE INDEX phpbb_attachments_attach_id ON phpbb_attachments (attach_id); CREATE INDEX phpbb_attachments_post_id ON phpbb_attachments (post_id); CREATE INDEX phpbb_attachments_privmsgs_id ON phpbb_attachments (privmsgs_id); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_attach_desc` -# +# Table: phpbb_attach_desc CREATE TABLE phpbb_attach_desc ( attach_id INTEGER NOT NULL, physical_filename VARCHAR(255) NOT NULL, @@ -52,10 +45,7 @@ CREATE TRIGGER phpbb_attach_desc_trig NEW.attach_id = GEN_ID(phpbb_attach_desc_gen, 1)| END; -# -------------------------------------------------------- -# -# Table structure for table `phpbb_auth_groups` -# +# Table: phpbb_auth_groups CREATE TABLE phpbb_auth_groups ( group_id INTEGER DEFAULT 0 NOT NULL, forum_id INTEGER DEFAULT 0 NOT NULL, @@ -66,11 +56,7 @@ CREATE TABLE phpbb_auth_groups ( CREATE INDEX phpbb_auth_groups_group_id ON phpbb_auth_groups (group_id); CREATE INDEX phpbb_auth_groups_option_id ON phpbb_auth_groups (auth_option_id); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_auth_options` -# +# Table: phpbb_auth_options CREATE TABLE phpbb_auth_options ( auth_option_id SMALLINT NOT NULL, auth_value CHAR(20) NOT NULL, @@ -91,11 +77,7 @@ CREATE TRIGGER phpbb_auth_options_trig NEW.auth_option_id = GEN_ID(phpbb_auth_options_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table phpbb_auth_presets -# +# Table: phpbb_auth_presets CREATE TABLE phpbb_auth_presets ( preset_id SMALLINT NOT NULL, preset_name VARCHAR(50) NOT NULL, @@ -116,11 +98,7 @@ CREATE TRIGGER phpbb_auth_presets_trig NEW.preset_id = GEN_ID(phpbb_auth_presets_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_auth_users` -# +# Table: phpbb_auth_users CREATE TABLE phpbb_auth_users ( user_id INTEGER DEFAULT 0 NOT NULL, forum_id INTEGER DEFAULT 0 NOT NULL, @@ -131,11 +109,7 @@ CREATE TABLE phpbb_auth_users ( CREATE INDEX phpbb_auth_users_user_id ON phpbb_auth_users (user_id); CREATE INDEX phpbb_auth_users_option_id ON phpbb_auth_users (auth_option_id); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_banlist' -# +# Table: 'phpbb_banlist' CREATE TABLE phpbb_banlist ( ban_id INTEGER NOT NULL, ban_userid INTEGER, @@ -158,11 +132,7 @@ CREATE TRIGGER phpbb_banlist_trig NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_config' -# +# Table: 'phpbb_config' CREATE TABLE phpbb_config ( config_name VARCHAR(50) NOT NULL, config_value VARCHAR(255) NOT NULL, @@ -172,11 +142,7 @@ CREATE TABLE phpbb_config ( CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_confirm' -# +# Table: 'phpbb_confirm' CREATE TABLE phpbb_confirm ( confirm_id CHAR(32) DEFAULT '' NOT NULL, session_id CHAR(32) DEFAULT '' NOT NULL, @@ -185,11 +151,7 @@ CREATE TABLE phpbb_confirm ( ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_disallow' -# +# Table: 'phpbb_disallow' CREATE TABLE phpbb_disallow ( disallow_id INTEGER NOT NULL, disallow_username VARCHAR(30), @@ -206,11 +168,7 @@ CREATE TRIGGER phpbb_disallow_trig NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_extensions' -# +# Table: 'phpbb_extensions' CREATE TABLE phpbb_extensions ( extension_id INTEGER NOT NULL, group_id INTEGER DEFAULT 0 NOT NULL, @@ -229,10 +187,7 @@ CREATE TRIGGER phpbb_extensions_trig NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1)| END; -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_extension_groups' -# +# Table: 'phpbb_extension_groups' CREATE TABLE phpbb_extension_groups ( group_id INTEGER NOT NULL, group_name VARCHAR(20) NOT NULL, @@ -253,11 +208,7 @@ CREATE TRIGGER phpbb_extension_groups_trig NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_forbidden_extensions' -# +# Table: 'phpbb_forbidden_extensions' CREATE TABLE phpbb_forbidden_extensions ( extension_id INTEGER NOT NULL, extension VARCHAR(100) NOT NULL, @@ -274,11 +225,7 @@ CREATE TRIGGER phpbb_forbidden_extensions_trig NEW.extension_id = GEN_ID(phpbb_forbidden_extensions_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_forums' -# +# Table: 'phpbb_forums' CREATE TABLE phpbb_forums ( forum_id SMALLINT NOT NULL, parent_id SMALLINT NOT NULL, @@ -319,10 +266,7 @@ CREATE TRIGGER phpbb_forums_trig NEW.forum_id = GEN_ID(phpbb_forums_gen, 1)| END; -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_forums_watch' -# +# Table: 'phpbb_forums_watch' CREATE TABLE phpbb_forums_watch ( forum_id SMALLINT DEFAULT 0 NOT NULL, user_id INTEGER DEFAULT 0 NOT NULL, @@ -333,11 +277,7 @@ CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id); CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id); CREATE INDEX phpbb_forums_watch_status ON phpbb_forums_watch (notify_status); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_groups' -# +# Table: 'phpbb_groups' CREATE TABLE phpbb_groups ( group_id INTEGER NOT NULL, group_type SMALLINT DEFAULT 1 NOT NULL, @@ -361,21 +301,13 @@ CREATE TRIGGER phpbb_groups_trig NEW.group_id = GEN_ID(phpbb_groups_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_groups_moderator' -# +# Table: 'phpbb_groups_moderator' CREATE TABLE phpbb_groups_moderator ( group_id INTEGER NOT NULL, user_id INTEGER NOT NULL ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_icons' -# +# Table: 'phpbb_icons' CREATE TABLE phpbb_icons ( icons_id SMALLINT NOT NULL, icons_url VARCHAR(50), @@ -396,11 +328,7 @@ CREATE TRIGGER phpbb_icons_trig NEW.icons_id = GEN_ID(phpbb_icons_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_lang' -# +# Table: 'phpbb_lang' CREATE TABLE phpbb_lang ( lang_id SMALLINT NOT NULL, lang_iso VARCHAR(5) NOT NULL, @@ -421,11 +349,7 @@ CREATE TRIGGER phpbb_lang_trig NEW.lang_id = GEN_ID(phpbb_lang_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_lastread' -# +# Table: 'phpbb_lastread' CREATE TABLE phpbb_lastread ( user_id INTEGER DEFAULT 0 NOT NULL, lastread_type SMALLINT DEFAULT 0 NOT NULL, @@ -435,11 +359,7 @@ CREATE TABLE phpbb_lastread ( PRIMARY KEY (user_id, topic_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_log_moderator' -# +# Table: 'phpbb_log_moderator' CREATE TABLE phpbb_log_moderator ( log_id INTEGER DEFAULT 0 NOT NULL, user_id INTEGER DEFAULT 0 NOT NULL, @@ -465,11 +385,7 @@ CREATE TRIGGER phpbb_log_moderator_trig NEW.log_id = GEN_ID(phpbb_log_moderator_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_log_admin' -# +# Table: 'phpbb_log_admin' CREATE TABLE phpbb_log_admin ( log_id INTEGER DEFAULT 0 NOT NULL, user_id INTEGER DEFAULT 0 NOT NULL, @@ -491,11 +407,7 @@ CREATE TRIGGER phpbb_log_admin_trig NEW.log_id = GEN_ID(phpbb_log_admin_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_moderator_cache' -# +# Table: 'phpbb_moderator_cache' CREATE TABLE phpbb_moderator_cache ( forum_id INTEGER NOT NULL, user_id INTEGER, @@ -508,11 +420,7 @@ CREATE TABLE phpbb_moderator_cache ( CREATE INDEX phpbb_mod_cache_disp ON phpbb_moderator_cache (display_on_index); CREATE INDEX phpbb_mod_cache_forum ON phpbb_moderator_cache (forum_id); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_vote_results' -# +# Table: 'phpbb_vote_results' CREATE TABLE phpbb_poll_results ( poll_option_id SMALLINT DEFAULT 0 NOT NULL, topic_id INTEGER NOT NULL, @@ -523,11 +431,7 @@ CREATE TABLE phpbb_poll_results ( CREATE INDEX phpbb_poll_results_id ON phpbb_poll_results (poll_option_id); CREATE INDEX phpbb_poll_results_topic_id ON phpbb_poll_results (topic_id); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_vote_voters' -# +# Table: 'phpbb_vote_voters' CREATE TABLE phpbb_poll_voters ( topic_id INTEGER DEFAULT 0 NOT NULL, poll_option_id SMALLINT DEFAULT 0 NOT NULL, @@ -539,11 +443,7 @@ CREATE INDEX phpbb_poll_voters_topic ON phpbb_poll_voters (topic_id); CREATE INDEX phpbb_poll_voters_vote_user ON phpbb_poll_voters (vote_user_id); CREATE INDEX phpbb_poll_voters_vote_ip ON phpbb_poll_voters (vote_user_ip); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_posts' -# +# Table: 'phpbb_posts' CREATE TABLE phpbb_posts ( post_id INTEGER NOT NULL, topic_id INTEGER DEFAULT 0 NOT NULL, @@ -585,11 +485,7 @@ CREATE TRIGGER phpbb_posts_trig NEW.post_id = GEN_ID(phpbb_posts_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_privmsgs' -# +# Table: 'phpbb_privmsgs' CREATE TABLE phpbb_privmsgs ( privmsgs_id INTEGER NOT NULL, privmsgs_attachment SMALLINT DEFAULT 0 NOT NULL, @@ -620,11 +516,7 @@ CREATE TRIGGER phpbb_privmsgs_trig NEW.privmsgs_id = GEN_ID(phpbb_privmsgs_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_ranks' -# +# Table: 'phpbb_ranks' CREATE TABLE phpbb_ranks ( rank_id SMALLINT NOT NULL, rank_title VARCHAR(50) NOT NULL, @@ -645,11 +537,7 @@ CREATE TRIGGER phpbb_ranks_trig NEW.rank_id = GEN_ID(phpbb_ranks_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_ratings' -# +# Table: 'phpbb_ratings' CREATE TABLE phpbb_ratings ( post_id INTEGER DEFAULT 0 NOT NULL, user_id SMALLINT DEFAULT 0 NOT NULL, @@ -659,11 +547,7 @@ CREATE TABLE phpbb_ratings ( CREATE INDEX phpbb_ratings_user_id ON phpbb_ratings (user_id); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_reports_reasons' -# +# Table: 'phpbb_reports_reasons' CREATE TABLE phpbb_reports_reasons ( reason_id INTEGER NOT NULL, reason_priority SMALLINT DEFAULT 0 NOT NULL, @@ -682,11 +566,7 @@ CREATE TRIGGER phpbb_reports_reasons_trig NEW.reason_id = GEN_ID(phpbb_reports_reasons_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_reports' -# +# Table: 'phpbb_reports' CREATE TABLE phpbb_reports ( report_id SMALLINT NOT NULL, reason_id SMALLINT DEFAULT 0 NOT NULL, @@ -707,11 +587,7 @@ CREATE TRIGGER phpbb_reports_trig NEW.report_id = GEN_ID(phpbb_reports_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_search_results` -# +# Table: phpbb_search_results CREATE TABLE phpbb_search_results ( search_id INTEGER DEFAULT 0 NOT NULL, session_id VARCHAR(32) DEFAULT '' NOT NULL, @@ -721,11 +597,7 @@ CREATE TABLE phpbb_search_results ( CREATE INDEX phpbb_search_results_session_id ON phpbb_search_results (session_id); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_search_wordlist` -# +# Table: phpbb_search_wordlist CREATE TABLE phpbb_search_wordlist ( word_id INTEGER NOT NULL, word_text VARCHAR(50) DEFAULT '' NOT NULL, @@ -736,11 +608,7 @@ CREATE TABLE phpbb_search_wordlist ( CREATE INDEX phpbb_search_wordlist_text ON phpbb_search_wordlist (word_text); CREATE INDEX phpbb_search_wordlist_common ON phpbb_search_wordlist (word_common); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_search_wordmatch` -# +# Table: phpbb_search_wordmatch CREATE TABLE phpbb_search_wordmatch ( post_id INTEGER DEFAULT 0 NOT NULL, word_id INTEGER DEFAULT 0 NOT NULL, @@ -750,11 +618,7 @@ CREATE TABLE phpbb_search_wordmatch ( CREATE INDEX phpbb_search_wordmatch_post ON phpbb_search_wordmatch (post_id); CREATE INDEX phpbb_search_wordmatch_word ON phpbb_search_wordmatch (word_id); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_sessions' -# +# Table: 'phpbb_sessions' CREATE TABLE phpbb_sessions ( session_id VARCHAR(32) DEFAULT '' NOT NULL, session_user_id INTEGER DEFAULT 0 NOT NULL, @@ -770,11 +634,7 @@ CREATE TABLE phpbb_sessions ( CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_smilies' -# +# Table: 'phpbb_smilies' CREATE TABLE phpbb_smilies ( smile_id SMALLINT NOT NULL, code CHAR(10), @@ -797,11 +657,7 @@ CREATE TRIGGER phpbb_smilies_trig NEW.smile_id = GEN_ID(phpbb_smilies_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles' -# +# Table: 'phpbb_styles' CREATE TABLE phpbb_styles ( style_id SMALLINT NOT NULL, template_id CHAR(50) NOT NULL, @@ -824,11 +680,7 @@ CREATE TRIGGER phpbb_styles_trig NEW.style_id = GEN_ID(phpbb_styles_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles_template' -# +# Table: 'phpbb_styles_template' CREATE TABLE phpbb_styles_template ( template_id SMALLINT NOT NULL, template_name VARCHAR(30) NOT NULL, @@ -848,11 +700,7 @@ CREATE TRIGGER phpbb_styles_template_trig NEW.template_id = GEN_ID(phpbb_styles_template_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles_theme' -# +# Table: 'phpbb_styles_theme' CREATE TABLE phpbb_styles_theme ( theme_id SMALLINT NOT NULL, theme_name VARCHAR(60), @@ -871,11 +719,7 @@ CREATE TRIGGER phpbb_styles_theme_trig NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles_imageset' -# +# Table: 'phpbb_styles_imageset' CREATE TABLE phpbb_styles_imageset ( imageset_id SMALLINT NOT NULL, imageset_name VARCHAR(100), @@ -955,11 +799,7 @@ CREATE TRIGGER phpbb_styles_imageset_trig NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_topics' -# +# Table: 'phpbb_topics' CREATE TABLE phpbb_topics ( topic_id INTEGER NOT NULL, forum_id INTEGER DEFAULT 0 NOT NULL, @@ -1003,11 +843,7 @@ CREATE TRIGGER phpbb_topics_trig NEW.topic_id = GEN_ID(phpbb_topics_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_topics_watch' -# +# Table: 'phpbb_topics_watch' CREATE TABLE phpbb_topics_watch ( topic_id INTEGER DEFAULT 0 NOT NULL, user_id INTEGER DEFAULT 0 NOT NULL, @@ -1018,11 +854,7 @@ CREATE INDEX phpbb_topics_watch_topic ON phpbb_topics_watch (topic_id); CREATE INDEX phpbb_topics_watch_user ON phpbb_topics_watch (user_id); CREATE INDEX phpbb_topics_watch_status ON phpbb_topics_watch (notify_status); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_ucp_modules' -# +# Table: 'phpbb_ucp_modules' CREATE TABLE phpbb_ucp_modules ( module_id INTEGER DEFAULT 0 NOT NULL, module_langname VARCHAR(50) NOT NULL, @@ -1042,11 +874,7 @@ CREATE TRIGGER phpbb_ucp_modules_trig NEW.module_id = GEN_ID(phpbb_ucp_modules_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_user_group' -# +# Table: 'phpbb_user_group' CREATE TABLE phpbb_user_group ( group_id INTEGER DEFAULT 0 NOT NULL, user_id INTEGER DEFAULT 0 NOT NULL, @@ -1056,11 +884,7 @@ CREATE TABLE phpbb_user_group ( CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id); CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_users' -# +# Table: 'phpbb_users' CREATE TABLE phpbb_users ( user_id INTEGER NOT NULL, user_active SMALLINT DEFAULT 1, @@ -1136,11 +960,7 @@ CREATE TRIGGER phpbb_users_trig NEW.user_id = GEN_ID(phpbb_users_gen, 1)| END; - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_words' -# +# Table: 'phpbb_words' CREATE TABLE phpbb_words ( word_id INTEGER NOT NULL, word CHAR(100) NOT NULL, diff --git a/phpBB/install/schemas/mssql_basic.sql b/phpBB/install/schemas/mssql_basic.sql deleted file mode 100644 index efc3032ca1..0000000000 --- a/phpBB/install/schemas/mssql_basic.sql +++ /dev/null @@ -1,244 +0,0 @@ -/* - - Basic DB data for phpBB2 devel (MSSQL) - - $Id$ - -*/ - -BEGIN TRANSACTION; - -/* - -- Config -*/ -INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020421]'); - -/* - -- Categories -*/ -SET IDENTITY_INSERT phpbb_categories ON; - -INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1); - -SET IDENTITY_INSERT phpbb_categories OFF; - - -/* - -- Forums -*/ -INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 1, 'Test Forum 1', 'This is just a test forum, nothing special here.', '', 1, 1, 1, 1, '', 1, '', '', '', '', 1, 1, 3, 1, 1, 1, 3); - -/* - -- Users - Default Admin --> username: admin - password: admin (change this or remove it once everything is working!) -*/ -INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', '', '', '', '', 0, 0); -INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1); - - -/* - -- Ranks -*/ -SET IDENTITY_INSERT phpbb_ranks ON; - -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Site Admin', -1, 1, ''); - -SET IDENTITY_INSERT phpbb_ranks OFF; - - -/* - -- Groups -*/ -INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (1, 1, 'Anonymous', 'Personal User', '', 1); -INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (2, 1, 'Admin', 'Personal User', '', 1); - - -/* - -- User -> Group -*/ -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, ''); -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, ''); - - -/* - -- Demo Topic -*/ -SET IDENTITY_INSERT phpbb_topics ON; - -INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_first_post_id, topic_last_post_id, topic_moved_id) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 1, 0, 0, 0, 1, 1, ''); - -SET IDENTITY_INSERT phpbb_topics OFF; - - -/* - -- Demo Post -*/ -SET IDENTITY_INSERT phpbb_posts ON; - -INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, NULL, '7F000001'); -INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!'); - -SET IDENTITY_INSERT phpbb_posts OFF; - - -/* - -- Themes -*/ -SET IDENTITY_INSERT phpbb_themes ON; - -INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', ''); - -SET IDENTITY_INSERT phpbb_themes OFF; - -INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', ''); - - -/* - -- Smilies -*/ -SET IDENTITY_INSERT phpbb_smilies ON; - -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, '8O', 'icon_eek.gif', 'Shocked'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, '8-O', 'icon_eek.gif', 'Shocked'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':shock:', 'icon_eek.gif', 'Shocked'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':?', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, ':-?', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, ':???:', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, '8)', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, '8-)', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':cool:', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':lol:', 'icon_lol.gif', 'Laughing'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':x', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':-x', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':mad:', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':P', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':-P', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':razz:', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':oops:', 'icon_redface.gif', 'Embarassed'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':cry:', 'icon_cry.gif', 'Crying or Very sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':evil:', 'icon_evil.gif', 'Evil or Very Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':twisted:', 'icon_twisted.gif', 'Twisted Evil'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ':wink:', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ';)', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ';-)', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':!:', 'icon_exclaim.gif', 'Exclamation'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':?:', 'icon_question.gif', 'Question'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':idea:', 'icon_idea.gif', 'Idea'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':arrow:', 'icon_arrow.gif', 'Arrow'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':|', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':-|', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 43, ':neutral:', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 44, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green'); - -SET IDENTITY_INSERT phpbb_smilies OFF; - - -/* - -- Search Words -*/ -SET IDENTITY_INSERT phpbb_search_wordlist ON; - -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 ); - -SET IDENTITY_INSERT phpbb_search_wordlist OFF; - - -/* - -- Search Word Matches -*/ -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 ); - -COMMIT; diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index 36e665d204..5d3a11601f 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -238,38 +238,76 @@ INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgcensors', INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_search', 1); +# MSSQL IDENTITY phpbb_styles ON # + # -- phpbb_styles INSERT INTO phpbb_styles (style_id, template_id, theme_id, imageset_id, style_name, bbcode_bitfield) VALUES (1, 1, 1, 1, 'subSilver', 2817); +# MSSQL IDENTITY phpbb_styles OFF # + + +# MSSQL IDENTITY phpbb_styles_imageset ON # + # -- phpbb_styles_imageset INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_path, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_ip, btn_quote, btn_search, btn_edit, btn_report, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_online, btn_offline, btn_topic_watch, btn_topic_unwatch, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, sub_forum, sub_forum_new, folder, folder_posted, folder_new, folder_new_posted, folder_hot, folder_hot_posted, folder_hot_new, folder_hot_new_posted, folder_locked, folder_locked_posted, folder_locked_new, folder_locked_new_posted, folder_sticky, folder_sticky_posted, folder_sticky_new, folder_sticky_new_posted, folder_announce, folder_announce_posted, folder_announce_new, folder_announce_new_posted, poll_left, poll_center, poll_right) VALUES (1, 'subSilver © phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/btn_post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_post_pm.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_reply.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_report.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_icq.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_msnm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_online.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_offline.gif" width="59" height="18" border="0"', '', '', '"imagesets/subSilver/icon_unapproved.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_reported.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_attach.gif" width="14" height="18" border="0"', '"imagesets/subSilver/icon_minipost.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_minipost_new.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_latest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/icon_newest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/folder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_locked_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/vote_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" height="12" border="0"', '"imagesets/subSilver/vote_rcap.gif" width="4" height="12" border="0"'); +# MSSQL IDENTITY phpbb_styles_imageset OFF # + + +# MSSQL IDENTITY phpbb_styles_template ON # + # -- phpbb_styles_template INSERT INTO phpbb_styles_template (template_id, template_name, template_path, poll_length, pm_box_length) VALUES (1, 'subSilver © phpBB Group', 'subSilver', 205, 175); +# MSSQL IDENTITY phpbb_styles_template OFF # + + +# MSSQL IDENTITY phpbb_styles_theme ON # + # -- phpbb_styles_theme INSERT INTO phpbb_styles_theme (theme_id, css_data, css_external) VALUES (1, 'body {background: white url(\'templates/subSilver/images/background.png\') repeat-x;}\nth { background-image: url(\'templates/subSilver/images/cellpic3.gif\') }\ntd.cat { background-image: url(\'templates/subSilver/images/cellpic1.gif\') }\ntd.rowpic { background-image: url(\'templates/subSilver/images/cellpic2.jpg\'); background-repeat: repeat-y }\ntd.icqback { background-image: url(\'templates/subSilver/images/icon_icq_add.gif\'); background-repeat: no-repeat }', 'subSilver/subSilver.css'); +# MSSQL IDENTITY phpbb_styles_theme OFF # + + +# MSSQL IDENTITY phpbb_lang ON # # -- Language INSERT INTO phpbb_lang (lang_id, lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES (1, 'en', 'en', 'English [ UK ]', 'English [ UK ]', 'phpBB Group'); +# MSSQL IDENTITY phpbb_lang OFF # + + +# MSSQL IDENTITY phpbb_forums ON # # -- Forums INSERT INTO phpbb_forums (forum_id, 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_post_time) VALUES (1, 'My first Category', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 972086460); INSERT INTO phpbb_forums (forum_id, 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_post_time) VALUES (2, 'Test Forum 1', 'This is just a test forum.', 2, 3, 1, 1, 1, 1, 1, 1, 2, 'Admin', 972086460); +# MSSQL IDENTITY phpbb_forums OFF # + + +# MSSQL IDENTITY phpbb_users ON # # -- Users INSERT INTO phpbb_users (user_id, user_founder, username, user_regdate, user_password, user_email, user_lang, user_style) VALUES (1, 0, 'Anonymous', 0, '', '', 'en', 1); -# -- username: Admin password: admin (change this or remove it once everything is working!) +# -- username: Admin password: admin (change this or remove it ON #ce everything is working!) INSERT INTO phpbb_users (user_id, user_founder, username, user_regdate, user_password, user_email, user_lang, user_style, user_rank) VALUES (2, 1, 'Admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1); +# MSSQL IDENTITY phpbb_users OFF # + + +# MSSQL IDENTITY phpbb_ranks ON # + # -- Ranks INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Site Admin', -1, 1, NULL); +# MSSQL IDENTITY phpbb_ranks OFF # + + +# MSSQL IDENTITY phpbb_groups ON # # -- Groups INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (1, 'GUESTS', 3); @@ -281,6 +319,8 @@ INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (6, 'SUPER_MO INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (7, 'ADMINISTRATORS', 3); INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (8, 'BANNED', 3); +# MSSQL IDENTITY phpbb_groups OFF # + # -- User -> Group INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, 1, 0); @@ -319,13 +359,22 @@ INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) INSERT INTO phpbb_moderator_cache (user_id, forum_id, username) VALUES (2, 2, 'Admin'); +# MSSQL IDENTITY phpbb_topics ON # + # -- Demo Topic INSERT INTO phpbb_topics (topic_id, 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_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_post_time) VALUES (1, 'Welcome to phpBB 2', 2, 972086460, 0, 0, 0, 2, 0, 0, 1, 'Admin', 1, 2, 'Admin', 972086460); +# MSSQL IDENTITY phpbb_topics OFF # + + +# MSSQL IDENTITY phpbb_posts ON # # -- Demo Post INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip, post_subject, post_text) VALUES (1, 1, 2, 2, 972086460, NULL, '127.0.0.1', 'Welcome to phpBB 2', 'This is an example post in your phpBB 2.2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!'); +# MSSQL IDENTITY phpbb_posts OFF # + + # -- Smilies INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':D', 'icon_biggrin.gif', 'Very Happy', 15, 15); INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':)', 'icon_smile.gif', 'Smile', 15, 15); @@ -363,6 +412,7 @@ INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, disp INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/idea.gif', 19, 19, 8, 1); INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/question.gif', 19, 19, 6, 1); INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/exclaim.gif', 19, 19, 7, 1); + # -- ucp modules INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (1, 'MAIN', 'main', 1); @@ -371,7 +421,9 @@ INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_o INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (4, 'MESSAGING', 'pm', 4); INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (5, 'LISTS', 'zebra', 5); - + +# MSSQL IDENTITY phpbb_search_wordlist ON # + # -- wordlist INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (1, 'example', 0); INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (2, 'post', 0); @@ -386,6 +438,10 @@ INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (10, INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (11, 'working', 0); INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (12, 'welcome', 0); +# MSSQL IDENTITY phpbb_search_wordlist OFF # + + +# MSSQL IDENTITY phpbb_search_wordmatch ON # # -- wordmatch INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (1, 1, 0); @@ -402,11 +458,20 @@ INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (11, 1 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (12, 1, 1); INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (3, 1, 1); +# MSSQL IDENTITY phpbb_search_wordmatch OFF # + + +# MSSQL IDENTITY phpbb_reports_reasons ON # # -- reasons INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (1, 0, 'warez', 'The reported post contains links to pirated or illegal software.'); INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (2, 1, 'other', 'The reported post does not fit into any other category, please use the description field.'); +# MSSQL IDENTITY phpbb_reports_reasons OFF # + + +# MSSQL IDENTITY phpbb_forbidden_extensions ON # + # -- forbidden_extensions INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (1, 'php'); INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (2, 'php3'); @@ -417,6 +482,11 @@ INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (6, 'asp INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (7, 'cgi'); INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (8, 'aspx'); +# MSSQL IDENTITY phpbb_forbidden_extensions OFF # + + +# MSSQL IDENTITY phpbb_extension_groups ON # + # -- extension_groups INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (1, 'Images', 1, 1, 1, '', 0); INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (2, 'Archives', 0, 1, 1, '', 0); @@ -425,6 +495,11 @@ INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, d INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (5, 'Real Media', 3, 0, 2, '', 0); INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (6, 'Windows Media', 2, 0, 1, '', 0); +# MSSQL IDENTITY phpbb_extension_groups OFF # + + +# MSSQL IDENTITY phpbb_extensions ON # + # -- extensions INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (1, 1, 'gif', ''); INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (2, 1, 'png', ''); @@ -453,3 +528,5 @@ INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (25, 4, 'ppt', ''); INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (26, 5, 'rm', ''); INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (27, 6, 'wma', ''); + +# MSSQL IDENTITY phpbb_extensions OFF # diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index c7a254e2e1..8ac0cae222 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -1,13 +1,10 @@ # -# phpbb - MySQL schema +# phpbb - MySQL schema - phpBB 2.2 (c) phpBB Group, 2003 # # $Id$ # -# -------------------------------------------------------- -# -# Table structure for table `phpbb_attachments` -# +# Table: phpbb_attachments CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -17,11 +14,7 @@ CREATE TABLE phpbb_attachments ( KEY attach_id (attach_id) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_attachments_desc` -# +# Table: phpbb_attachments_desc CREATE TABLE phpbb_attach_desc ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, @@ -39,11 +32,7 @@ CREATE TABLE phpbb_attach_desc ( KEY filesize (filesize) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_auth_groups` -# +# Table: phpbb_auth_groups CREATE TABLE phpbb_auth_groups ( group_id mediumint(8) unsigned NOT NULL default '0', forum_id mediumint(8) unsigned NOT NULL default '0', @@ -53,11 +42,7 @@ CREATE TABLE phpbb_auth_groups ( KEY auth_option_id (auth_option_id) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_auth_options` -# +# Table: phpbb_auth_options CREATE TABLE phpbb_auth_options ( auth_option_id tinyint(4) NOT NULL auto_increment, auth_option char(20) NOT NULL, @@ -68,11 +53,7 @@ CREATE TABLE phpbb_auth_options ( KEY auth_option (auth_option) ); - -# -------------------------------------------------------- -# -# Table structure for table phpbb_auth_presets -# +# Table: phpbb_auth_presets CREATE TABLE phpbb_auth_presets ( preset_id tinyint(4) NOT NULL auto_increment, preset_name varchar(50) DEFAULT '' NOT NULL, @@ -83,11 +64,7 @@ CREATE TABLE phpbb_auth_presets ( KEY preset_type (preset_type) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_auth_users` -# +# Table: phpbb_auth_users CREATE TABLE phpbb_auth_users ( user_id mediumint(8) UNSIGNED NOT NULL default '0', forum_id mediumint(8) UNSIGNED NOT NULL default '0', @@ -97,11 +74,7 @@ CREATE TABLE phpbb_auth_users ( KEY auth_option_id (auth_option_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_banlist' -# +# Table: 'phpbb_banlist' CREATE TABLE phpbb_banlist ( ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, ban_userid mediumint(8) UNSIGNED DEFAULT 0 NOT NULL, @@ -115,11 +88,7 @@ CREATE TABLE phpbb_banlist ( PRIMARY KEY (ban_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_config' -# +# Table: 'phpbb_config' CREATE TABLE phpbb_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, @@ -128,11 +97,7 @@ CREATE TABLE phpbb_config ( KEY is_dynamic (is_dynamic) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_confirm' -# +# Table: 'phpbb_confirm' CREATE TABLE phpbb_confirm ( confirm_id char(32) DEFAULT '' NOT NULL, session_id char(32) DEFAULT '' NOT NULL, @@ -142,22 +107,14 @@ CREATE TABLE phpbb_confirm ( KEY time (time) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_disallow' -# +# Table: 'phpbb_disallow' CREATE TABLE phpbb_disallow ( disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment, disallow_username varchar(30) DEFAULT '' NOT NULL, PRIMARY KEY (disallow_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_extensions' -# +# Table: 'phpbb_extensions' CREATE TABLE phpbb_extensions ( extension_id mediumint(8) UNSIGNED NOT NULL auto_increment, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -166,11 +123,7 @@ CREATE TABLE phpbb_extensions ( PRIMARY KEY (extension_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_extension_groups' -# +# Table: 'phpbb_extension_groups' CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, @@ -182,22 +135,14 @@ CREATE TABLE phpbb_extension_groups ( PRIMARY KEY (group_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_forbidden_extensions' -# +# Table: 'phpbb_forbidden_extensions' CREATE TABLE phpbb_forbidden_extensions ( extension_id mediumint(8) UNSIGNED NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (extension_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_forums' -# +# Table: 'phpbb_forums' CREATE TABLE phpbb_forums ( forum_id smallint(5) UNSIGNED NOT NULL auto_increment, parent_id smallint(5) UNSIGNED NOT NULL, @@ -232,11 +177,7 @@ CREATE TABLE phpbb_forums ( KEY forum_last_post_id (forum_last_post_id) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_forum_access` -# +# Table: phpbb_forum_access CREATE TABLE phpbb_forum_access ( forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -244,11 +185,7 @@ CREATE TABLE phpbb_forum_access ( PRIMARY KEY (forum_id,user_id,session_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_forums_marking' -# +# Table: 'phpbb_forums_marking' CREATE TABLE phpbb_forums_marking ( user_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, forum_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, @@ -256,11 +193,7 @@ CREATE TABLE phpbb_forums_marking ( PRIMARY KEY (user_id, forum_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_forums_watch' -# +# Table: 'phpbb_forums_watch' CREATE TABLE phpbb_forums_watch ( forum_id smallint(5) UNSIGNED NOT NULL DEFAULT '0', user_id mediumint(8) NOT NULL DEFAULT '0', @@ -270,11 +203,7 @@ CREATE TABLE phpbb_forums_watch ( KEY notify_status (notify_status) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_groups' -# +# Table: 'phpbb_groups' CREATE TABLE phpbb_groups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, @@ -288,21 +217,13 @@ CREATE TABLE phpbb_groups ( PRIMARY KEY (group_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_groups_moderator' -# +# Table: 'phpbb_groups_moderator' CREATE TABLE phpbb_groups_moderator ( group_id mediumint(8) NOT NULL, user_id mediumint(8) NOT NULL ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_icons' -# +# Table: 'phpbb_icons' CREATE TABLE phpbb_icons ( icons_id tinyint(4) UNSIGNED NOT NULL auto_increment, icons_url varchar(50), @@ -313,11 +234,7 @@ CREATE TABLE phpbb_icons ( PRIMARY KEY (icons_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_lang' -# +# Table: 'phpbb_lang' CREATE TABLE phpbb_lang ( lang_id tinyint(4) UNSIGNED NOT NULL auto_increment, lang_iso varchar(5) NOT NULL, @@ -328,11 +245,7 @@ CREATE TABLE phpbb_lang ( PRIMARY KEY (lang_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_log_moderator' -# +# Table: 'phpbb_log_moderator' CREATE TABLE phpbb_log_moderator ( log_id mediumint(5) UNSIGNED NOT NULL DEFAULT '0' auto_increment, user_id mediumint(8) NOT NULL DEFAULT '0', @@ -348,11 +261,7 @@ CREATE TABLE phpbb_log_moderator ( KEY user_id (user_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_log_admin' -# +# Table: 'phpbb_log_admin' CREATE TABLE phpbb_log_admin ( log_id mediumint(5) UNSIGNED NOT NULL DEFAULT '0' auto_increment, user_id mediumint(8) NOT NULL DEFAULT '0', @@ -364,11 +273,7 @@ CREATE TABLE phpbb_log_admin ( KEY user_id (user_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_moderator_cache' -# +# Table: 'phpbb_moderator_cache' CREATE TABLE phpbb_moderator_cache ( forum_id mediumint(8) unsigned NOT NULL, user_id mediumint(8) unsigned default NULL, @@ -380,11 +285,7 @@ CREATE TABLE phpbb_moderator_cache ( KEY forum_id (forum_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_vote_results' -# +# Table: 'phpbb_vote_results' CREATE TABLE phpbb_poll_results ( poll_option_id tinyint(4) unsigned NOT NULL DEFAULT '0', topic_id mediumint(8) UNSIGNED NOT NULL, @@ -394,11 +295,7 @@ CREATE TABLE phpbb_poll_results ( KEY topic_id (topic_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_vote_voters' -# +# Table: 'phpbb_vote_voters' CREATE TABLE phpbb_poll_voters ( topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', poll_option_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0', @@ -409,11 +306,7 @@ CREATE TABLE phpbb_poll_voters ( KEY vote_user_ip (vote_user_ip) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_posts' -# +# Table: 'phpbb_posts' CREATE TABLE phpbb_posts ( post_id mediumint(8) UNSIGNED NOT NULL auto_increment, topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -448,11 +341,7 @@ CREATE TABLE phpbb_posts ( KEY post_approved (post_approved) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_privmsgs' -# +# Table: 'phpbb_privmsgs' CREATE TABLE phpbb_privmsgs ( privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment, privmsgs_attachment tinyint(1) DEFAULT '0' NOT NULL, @@ -473,11 +362,7 @@ CREATE TABLE phpbb_privmsgs ( KEY privmsgs_to_userid (privmsgs_to_userid) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_ranks' -# +# Table: 'phpbb_ranks' CREATE TABLE phpbb_ranks ( rank_id smallint(5) UNSIGNED NOT NULL auto_increment, rank_title varchar(50) NOT NULL, @@ -488,11 +373,7 @@ CREATE TABLE phpbb_ranks ( PRIMARY KEY (rank_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_ratings' -# +# Table: 'phpbb_ratings' CREATE TABLE phpbb_ratings ( post_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', user_id tinyint(4) UNSIGNED UNSIGNED NOT NULL DEFAULT '0', @@ -501,11 +382,7 @@ CREATE TABLE phpbb_ratings ( KEY user_id (user_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_reports_reasons' -# +# Table: 'phpbb_reports_reasons' CREATE TABLE phpbb_reports_reasons ( reason_id smallint(6) NOT NULL auto_increment, reason_priority tinyint(4) NOT NULL default '0', @@ -514,11 +391,7 @@ CREATE TABLE phpbb_reports_reasons ( PRIMARY KEY (reason_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_reports' -# +# Table: 'phpbb_reports' CREATE TABLE phpbb_reports ( report_id smallint(5) unsigned NOT NULL auto_increment, reason_id smallint(5) unsigned NOT NULL default '0', @@ -530,11 +403,7 @@ CREATE TABLE phpbb_reports ( PRIMARY KEY (report_id) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_search_results` -# +# Table: phpbb_search_results CREATE TABLE phpbb_search_results ( search_id int(11) UNSIGNED NOT NULL default '0', session_id varchar(32) DEFAULT '' NOT NULL, @@ -543,11 +412,7 @@ CREATE TABLE phpbb_search_results ( KEY session_id (session_id) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_search_wordlist` -# +# Table: phpbb_search_wordlist CREATE TABLE phpbb_search_wordlist ( word_text varchar(50) binary DEFAULT '' NOT NULL, word_id mediumint(8) UNSIGNED NOT NULL auto_increment, @@ -556,11 +421,7 @@ CREATE TABLE phpbb_search_wordlist ( KEY word_id (word_id) ); - -# -------------------------------------------------------- -# -# Table structure for table `phpbb_search_wordmatch` -# +# Table: phpbb_search_wordmatch CREATE TABLE phpbb_search_wordmatch ( post_id mediumint(8) UNSIGNED NOT NULL default '0', word_id mediumint(8) UNSIGNED NOT NULL default '0', @@ -568,11 +429,7 @@ CREATE TABLE phpbb_search_wordmatch ( KEY word_id (word_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_sessions' -# +# Table: 'phpbb_sessions' CREATE TABLE phpbb_sessions ( session_id varchar(32) DEFAULT '' NOT NULL, session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -587,11 +444,7 @@ CREATE TABLE phpbb_sessions ( KEY session_time (session_time) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_smilies' -# +# Table: 'phpbb_smilies' CREATE TABLE phpbb_smilies ( smile_id tinyint(4) UNSIGNED NOT NULL auto_increment, code char(10), @@ -604,11 +457,7 @@ CREATE TABLE phpbb_smilies ( PRIMARY KEY (smile_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles' -# +# Table: 'phpbb_styles' CREATE TABLE phpbb_styles ( style_id tinyint(4) UNSIGNED NOT NULL auto_increment, template_id char(50) NOT NULL, @@ -622,11 +471,7 @@ CREATE TABLE phpbb_styles ( KEY (imageset_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles_template' -# +# Table: 'phpbb_styles_template' CREATE TABLE phpbb_styles_template ( template_id tinyint(4) UNSIGNED NOT NULL auto_increment, template_name varchar(30) NOT NULL, @@ -636,11 +481,7 @@ CREATE TABLE phpbb_styles_template ( PRIMARY KEY (template_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles_theme' -# +# Table: 'phpbb_styles_theme' CREATE TABLE phpbb_styles_theme ( theme_id tinyint(4) UNSIGNED NOT NULL auto_increment, theme_name varchar(60), @@ -649,11 +490,7 @@ CREATE TABLE phpbb_styles_theme ( PRIMARY KEY (theme_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_styles_imageset' -# +# Table: 'phpbb_styles_imageset' CREATE TABLE phpbb_styles_imageset ( imageset_id tinyint(4) unsigned NOT NULL auto_increment, imageset_name varchar(100) DEFAULT '' NOT NULL, @@ -720,11 +557,7 @@ CREATE TABLE phpbb_styles_imageset ( PRIMARY KEY (imageset_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_topics' -# +# Table: 'phpbb_topics' CREATE TABLE phpbb_topics ( topic_id mediumint(8) UNSIGNED NOT NULL auto_increment, forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -761,11 +594,7 @@ CREATE TABLE phpbb_topics ( KEY topic_type (topic_type) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_topic_marking' -# +# Table: 'phpbb_topic_marking' CREATE TABLE phpbb_topics_marking ( user_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, topic_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, @@ -774,11 +603,7 @@ CREATE TABLE phpbb_topics_marking ( PRIMARY KEY (user_id, topic_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_topics_watch' -# +# Table: 'phpbb_topics_watch' CREATE TABLE phpbb_topics_watch ( topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', user_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', @@ -788,10 +613,7 @@ CREATE TABLE phpbb_topics_watch ( KEY notify_status (notify_status) ); -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_ucp_modules' -# +# Table: 'phpbb_ucp_modules' CREATE TABLE phpbb_ucp_modules ( module_id mediumint(8) DEFAULT '0' AUTO_INCREMENT NOT NULL, module_name varchar(50) NOT NULL, @@ -801,11 +623,7 @@ CREATE TABLE phpbb_ucp_modules ( PRIMARY KEY (module_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_user_group' -# +# Table: 'phpbb_user_group' CREATE TABLE phpbb_user_group ( group_id mediumint(8) DEFAULT '0' NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -814,11 +632,7 @@ CREATE TABLE phpbb_user_group ( KEY user_id (user_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_users' -# +# Table: 'phpbb_users' CREATE TABLE phpbb_users ( user_id mediumint(8) UNSIGNED NOT NULL auto_increment, user_active tinyint(1) DEFAULT '1' NOT NULL, @@ -891,14 +705,10 @@ CREATE TABLE phpbb_users ( KEY user_birthday (user_birthday(6)) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_words' -# +# Table: 'phpbb_words' CREATE TABLE phpbb_words ( word_id mediumint(8) UNSIGNED NOT NULL auto_increment, word char(100) NOT NULL, replacement char(100) NOT NULL, PRIMARY KEY (word_id) -); +);
\ No newline at end of file diff --git a/phpBB/install/schemas/oracle_basic.sql b/phpBB/install/schemas/oracle_basic.sql deleted file mode 100644 index 96c24cc8c9..0000000000 --- a/phpBB/install/schemas/oracle_basic.sql +++ /dev/null @@ -1,186 +0,0 @@ -/* -* Basic DB data for phpBB2 devel -* -* $Id$ -*/ - --- Config -INSERT INTO phpbb_config VALUES ('board_disable','0'); -INSERT INTO phpbb_config VALUES ('board_startdate','994190324'); -INSERT INTO phpbb_config VALUES ('sitename','yourdomain.com'); -INSERT INTO phpbb_config VALUES ('cookie_name','phpbb2oracle'); -INSERT INTO phpbb_config VALUES ('cookie_path','/'); -INSERT INTO phpbb_config VALUES ('cookie_domain',''); -INSERT INTO phpbb_config VALUES ('cookie_secure','0'); -INSERT INTO phpbb_config VALUES ('session_length','900'); -INSERT INTO phpbb_config VALUES ('allow_html','0'); -INSERT INTO phpbb_config VALUES ('allow_html_tags','b,i,u,pre'); -INSERT INTO phpbb_config VALUES ('allow_bbcode','1'); -INSERT INTO phpbb_config VALUES ('allow_smilies','1'); -INSERT INTO phpbb_config VALUES ('allow_sig','1'); -INSERT INTO phpbb_config VALUES ('allow_namechange','0'); -INSERT INTO phpbb_config VALUES ('allow_theme_create','0'); -INSERT INTO phpbb_config VALUES ('allow_avatar_local','0'); -INSERT INTO phpbb_config VALUES ('allow_avatar_remote','1'); -INSERT INTO phpbb_config VALUES ('allow_avatar_upload','1'); -INSERT INTO phpbb_config VALUES ('override_user_style','0'); -INSERT INTO phpbb_config VALUES ('posts_per_page','15'); -INSERT INTO phpbb_config VALUES ('topics_per_page','50'); -INSERT INTO phpbb_config VALUES ('hot_threshold','25'); -INSERT INTO phpbb_config VALUES ('max_poll_options','10'); -INSERT INTO phpbb_config VALUES ('max_sig_chars','255'); -INSERT INTO phpbb_config VALUES ('max_inbox_privmsgs','50'); -INSERT INTO phpbb_config VALUES ('max_sentbox_privmsgs','25'); -INSERT INTO phpbb_config VALUES ('max_savebox_privmsgs','50'); -INSERT INTO phpbb_config VALUES ('board_email_sig','Thanks, The Management'); -INSERT INTO phpbb_config VALUES ('board_email','youraddress@yourdomain.com'); -INSERT INTO phpbb_config VALUES ('smtp_delivery','0'); -INSERT INTO phpbb_config VALUES ('smtp_host',''); -INSERT INTO phpbb_config VALUES ('require_activation','0'); -INSERT INTO phpbb_config VALUES ('require_admin_activation','0'); -INSERT INTO phpbb_config VALUES ('flood_interval','15'); -INSERT INTO phpbb_config VALUES ('avatar_filesize','6144'); -INSERT INTO phpbb_config VALUES ('avatar_max_width','80'); -INSERT INTO phpbb_config VALUES ('avatar_max_height','80'); -INSERT INTO phpbb_config VALUES ('avatar_path','images/avatars'); -INSERT INTO phpbb_config VALUES ('smilies_path','images/smiles'); -INSERT INTO phpbb_config VALUES ('default_style','8'); -INSERT INTO phpbb_config VALUES ('default_admin_style','2'); -INSERT INTO phpbb_config VALUES ('default_lang','english'); -INSERT INTO phpbb_config VALUES ('default_dateformat','D M d, Y g:i a'); -INSERT INTO phpbb_config VALUES ('board_timezone','0'); -INSERT INTO phpbb_config VALUES ('prune_enable','1'); -INSERT INTO phpbb_config VALUES ('gzip_compress','1'); -INSERT INTO phpbb_config VALUES ('record_online_users','0'); -INSERT INTO phpbb_config VALUES ('record_online_date','0'); -INSERT INTO phpbb_config VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config VALUES ('version', 'RC-4'); -INSERT INTO phpbb_config VALUES ('server_name', 'www.yourdomain.tld'); -INSERT INTO phpbb_config VALUES ('server_port', '80'); - --- Categories -INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1); - - --- Forums -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum, nothing special here.', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 3, 3, 3, 3); - - --- Users -INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active, user_template) VALUES - ( '-1', 'Anonymous', '0', '972086460', '1', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '0', '', '', '', '0', '0', '1', '1', '', '', '', '-8', 'D M d, Y g:i a', '', '', '0', '0'); - --- username: admin password: admin (change this or remove it once everything is working!) -INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( '2', 'Admin', '1', '972086460', '21232f297a57a5a743894a0e4a801fc3', '', 'admin@yourdomain.com', '', '', '', '', '', 'A Signature', '1', '2', '', '', '', '0', '0', '1', '0', '1', '1', '1', '1', '1', '', 'english', '-8', 'd M Y h:i a', '', '', '0', '1'); - - --- Ranks -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '1', 'Site Admin', '-1', '1', ''); -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '2', 'Newbie', '0', '0', ''); -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '5', 'Here Often', '10', '0', ''); -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '6', 'Should Get Out More', '50', '0', ''); -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '7', 'Has No Life', '200', '0', ''); - - --- Groups -INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1); -INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1); - - --- User -> Group -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0); -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0); - - --- User Access (admin is set as ... an admin) -INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_mod) VALUES (2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1); - - --- Demo Topic -INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_last_post_id) VALUES (1, 'Demo Topic', 2, 972086460, 0, 0, 1, 0, 0, 1); - - --- Demo Post -INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, '', '7F000001'); -INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, 'This is the subject', 'This is a demo post in the demo topic, what do you think of it?'); - - --- Themes -INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1,'Original default','Default','','','','','','','','','','','','','','','','','','','','','CCCCCC','DDDDDD','','','','','','','',NULL,NULL,NULL,'','','','','',''); -INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (2,'PSO [ Grey ]','PSO', '','','FFFFFF','000000','002266','004411','','','','','','','','','000000','D2D2D2','BCBCBC','','','','EDEDED','DEDEDE','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'','','','','',''); -INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (3,'PSO [ Wheat ] ','PSO','','','FFFFFF','000000','002266','004411','','','','','','','','','001100','E5CCA5','D4A294','','','','EBE4D9','DAD1C4','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','',''); -INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (4,'PSO [ Ocean ]','PSO','','','DFF5FF','000000','011001','2100cc','','','','','','','','','000000','A7C1CB','7897A8','','','','83D7CC','A0CCE0','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'','','','','',''); -INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (6,'PSO [ Blue ]','PSO','','','FFFFFF','000000','417FB9','4E6172','0000AA','','','','','','','','000000','90BAE2','5195D4','','','','cde3f2','daedFd','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','',''); -INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (7,'PSO [ Cool Midnight ]','PSO', '','','444444','ECECEC','EDF2F2','DDEDED','FFFFFF','EDF2F2','','','','','','','000000','80707F','66555F','','','','60707D','667A80','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',NULL,NULL,NULL,'ECECEC','ECECEC','ECECEC','','',''); -INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (8,'PSO [ Pastel Purple ]','PSO','','','FFFFFF','000000','445588','337744','','','','','','','','','CCCCDD','CCCCDD','DDDDEE','','','','EFEFEF','FEFEFE','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',1,2,3,'','','0000EE','','',''); -INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (9,'subSilver','subSilver','subSilver','','E5E5E5','000000','006699','5584AA','FF9933','EDF2F2','EFEFEF','DEE3E7','c2cdd6','','','','CBD3D9','BCBCBC','1B7CAD','','','','AEBDC4','006699','FFFFFF','row1','row2','','Verdana,Arial,Helvetica,sans-serif','Verdana,Arial,Helvetica,sans-serif','courier','','','','004c75','004c75','004c75','','',''); - - --- Smilies -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '2', ':-D', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '3', ':grin:', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '4', ':)', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '5', ':-)', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '6', ':smile:', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '7', ':(', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '8', ':-(', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '9', ':sad:', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '10', ':o', 'icon_eek.gif', 'Surprised'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '11', ':-o', 'icon_eek.gif', 'Surprised'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '12', ':eek:', 'icon_eek.gif', 'Surprised'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '13', ':?', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '14', ':-?', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '15', ':???:', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '16', '8)', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '17', '8-)', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '18', ':cool:', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '19', ':lol:', 'icon_lol.gif', 'Laughing'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '20', ':x', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '21', ':-x', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '22', ':mad:', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '23', ':P', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '24', ':-P', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '25', ':razz:', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '26', ':oops:', 'icon_redface.gif', 'Embarassed'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '27', ':cry:', 'icon_cry.gif', 'Crying or Very sad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '28', ':evil:', 'icon_evil.gif', 'Evil or Very Mad'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '29', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '30', ':wink:', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '31', ';)', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '32', ';-)', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '33', ':!:', 'icon_exclaim.gif', 'Exclamation'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '34', ':?:', 'icon_question.gif', 'Question'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '35', ':idea:', 'icon_idea.gif', 'Idea'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '36', ':arrow:', 'icon_arrow.gif', 'Arrow'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '37', ':|', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', ':-|', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '39', ':neutral:', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '40', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green'); - --- Words -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '1', 'asshole', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '2', 'assram*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '3', 'asswipe', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '4', 'asstool*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '5', 'bastard', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '6', 'bitch', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '7', 'bollock*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '8', 'crap*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '9', '*crap', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '10', 'cunt*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '11', 'dickweed', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '12', 'dickwad', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '13', 'dickhead', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '14', '*fuck*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '15', 'fuk*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '16', 'masturbat*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '17', 'piss*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '18', 'prick', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '19', 'pussy', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '20', '*shit*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '21', 'slut', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '22', 'tits', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '23', '*wank*', '*beep*'); - -COMMIT; diff --git a/phpBB/install/schemas/oracle_triggers.sql b/phpBB/install/schemas/oracle_triggers.sql deleted file mode 100644 index f22fa46f66..0000000000 --- a/phpBB/install/schemas/oracle_triggers.sql +++ /dev/null @@ -1,217 +0,0 @@ -/* - phpBB2 Oracle 8i Triggers File - (c) 2001 The phpBB Group - - $Id$ - */ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_groups --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_PHPBB_GROUPS_ID_SEQ" -BEFORE INSERT OR UPDATE OF "GROUP_ID" ON "PHPBB"."PHPBB_GROUPS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_GROUPS_ID_SEQ.NEXTVAL -INTO :NEW.group_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_banlist --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_PHPBB_BANLIST_ID_SEQ" -BEFORE INSERT OR UPDATE OF "BAN_ID" ON "PHPBB"."PHPBB_BANLIST" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_BANLIST_ID_SEQ.NEXTVAL -INTO :NEW.ban_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_categories --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_CATEGORIES_ID_SEQ" -BEFORE INSERT OR UPDATE OF "CAT_ID" ON "PHPBB"."PHPBB_CATEGORIES" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_CATEGORIES_ID_SEQ.NEXTVAL -INTO :NEW.cat_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_disallow --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_DISALLOW_ID_SEQ" -BEFORE INSERT OR UPDATE OF "DISALLOW_ID" ON "PHPBB"."PHPBB_DISALLOW" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_DISALLOW_ID_SEQ.NEXTVAL -INTO :NEW.disallow_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_forums --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_FORUMS_ID_SEQ" -BEFORE INSERT OR UPDATE OF "FORUM_ID" ON "PHPBB"."PHPBB_FORUMS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_FORUMS_ID_SEQ.NEXTVAL -INTO :NEW.forum_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_forum_prune --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_FORUM_PRUNE_ID_SEQ" -BEFORE INSERT OR UPDATE OF "PRUNE_ID" ON "PHPBB"."PHPBB_FORUM_PRUNE" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_FORUM_PRUNE_ID_SEQ.NEXTVAL -INTO :NEW.prune_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_posts --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_POSTS_ID_SEQ" -BEFORE INSERT OR UPDATE OF "POST_ID" ON "PHPBB"."PHPBB_POSTS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_POSTS_ID_SEQ.NEXTVAL -INTO :NEW.post_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_privmsgs --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_PRIVMSGS_ID_SEQ" -BEFORE INSERT OR UPDATE OF "PRIVMSGS_ID" ON "PHPBB"."PHPBB_PRIVMSGS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_PRIVMSGS_ID_SEQ.NEXTVAL -INTO :NEW.privmsgs_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_ranks --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_RANK_ID_SEQ" -BEFORE INSERT OR UPDATE OF "RANK_ID" ON "PHPBB"."PHPBB_RANKS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_RANKS_ID_SEQ.NEXTVAL -INTO :NEW.rank_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_smilies --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_SMILIES_ID_SEQ" -BEFORE INSERT OR UPDATE OF "SMILIES_ID" ON "PHPBB"."PHPBB_SMILIES" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_SMILIES_ID_SEQ.NEXTVAL -INTO :NEW.smilies_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_themes --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_THEMES_ID_SEQ" -BEFORE INSERT OR UPDATE OF "THEMES_ID" ON "PHPBB"."PHPBB_THEMES" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_THEMES_ID_SEQ.NEXTVAL -INTO :NEW.themes_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_topics --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_TOPICS_ID_SEQ" -BEFORE INSERT OR UPDATE OF "TOPIC_ID" ON "PHPBB"."PHPBB_TOPICS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_TOPICS_ID_SEQ.NEXTVAL -INTO :NEW.topic_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_users --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_USERS_ID_SEQ" -BEFORE INSERT OR UPDATE OF "USER_ID" ON "PHPBB"."PHPBB_USERS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_USERS_ID_SEQ.NEXTVAL -INTO :NEW.user_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_vote_desc --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_VOTE_DESC_ID_SEQ" -BEFORE INSERT OR UPDATE OF "VOTE_ID" ON "PHPBB"."PHPBB_VOTE_DESC" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_VOTE_DESC_ID_SEQ.NEXTVAL -INTO :NEW.vote_id -FROM DUAL; -END; -/ - -/* -------------------------------------------------------- - Trigger structure for table phpbb_words --------------------------------------------------------- */ -CREATE OR REPLACE TRIGGER "PHPBB"."SET_WORDS_ID_SEQ" -BEFORE INSERT OR UPDATE OF "WORD_ID" ON "PHPBB"."PHPBB_WORDS" -REFERENCING OLD AS OLD NEW AS NEW -FOR EACH ROW -BEGIN -SELECT PHPBB_WORDS_ID_SEQ.NEXTVAL -INTO :NEW.word_id -FROM DUAL; -END; -/ - -COMMIT; diff --git a/phpBB/install/schemas/postgres_basic.sql b/phpBB/install/schemas/postgres_basic.sql deleted file mode 100644 index 6f820ebb08..0000000000 --- a/phpBB/install/schemas/postgres_basic.sql +++ /dev/null @@ -1,184 +0,0 @@ -/* -* Basic DB data for phpBB2 devel -* -* $Id$ -*/ - --- Config -INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password',''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', ''); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020421]'); - --- Categories -INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 10); - - --- Forums -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum.', 1, 10, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 1, 1, 1, 3); - --- Users -INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', '', '', '', '', 0, 0); - --- username: admin password: admin (change this or remove it once everything is working!) -INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1); - - --- Ranks -INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL); - - --- Groups -INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1); -INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1); - - --- User -> Group -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0); -INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0); - - --- Demo Topic -INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_first_post_id, topic_last_post_id) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 1, 0, 0, 0, 1, 1); - - --- Demo Post -INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, NULL, '7F000001'); -INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!'); - - --- Themes -INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', NULL, 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', NULL, NULL, NULL, '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', NULL, 'row1', 'row2', NULL, 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', NULL, NULL, NULL); - -INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', NULL, NULL, NULL, 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', NULL, 'Background for topic posts', '2nd background for topic posts', NULL, 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', NULL, NULL, NULL); - - --- Smilies -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':D', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-D', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':grin:', 'icon_biggrin.gif', 'Very Happy'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':)', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-)', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':smile:', 'icon_smile.gif', 'Smile'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':(', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-(', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':sad:', 'icon_sad.gif', 'Sad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':o', 'icon_surprised.gif', 'Surprised'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-o', 'icon_surprised.gif', 'Surprised'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':eek:', 'icon_surprised.gif', 'Surprised'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8O', 'icon_eek.gif', 'Shocked'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8-O', 'icon_eek.gif', 'Shocked'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':shock:', 'icon_eek.gif', 'Shocked'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':?', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-?', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':???:', 'icon_confused.gif', 'Confused'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8)', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8-)', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':cool:', 'icon_cool.gif', 'Cool'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':lol:', 'icon_lol.gif', 'Laughing'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':x', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-x', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':mad:', 'icon_mad.gif', 'Mad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':P', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-P', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':razz:', 'icon_razz.gif', 'Razz'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':oops:', 'icon_redface.gif', 'Embarassed'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':cry:', 'icon_cry.gif', 'Crying or Very sad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':evil:', 'icon_evil.gif', 'Evil or Very Mad'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':twisted:', 'icon_twisted.gif', 'Twisted Evil'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':wink:', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ';)', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ';-)', 'icon_wink.gif', 'Wink'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':!:', 'icon_exclaim.gif', 'Exclamation'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':?:', 'icon_question.gif', 'Question'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':idea:', 'icon_idea.gif', 'Idea'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':arrow:', 'icon_arrow.gif', 'Arrow'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':|', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-|', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':neutral:', 'icon_neutral.gif', 'Neutral'); -INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green'); - - --- wordlist -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 ); -INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 ); - - --- wordmatch -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 ); -INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 ); diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql new file mode 100644 index 0000000000..5d3a11601f --- /dev/null +++ b/phpBB/install/schemas/schema_data.sql @@ -0,0 +1,532 @@ +# +# Basic DB data for phpBB2 devel +# +# $Id$ +# + +# -- Config +INSERT INTO phpbb_config (config_name, config_value) VALUES ('active_sessions', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_attachments','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_topic_notify','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_forum_notify','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_nocensors','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_emailreuse','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_name_chars','.*?'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable_msg',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_dst','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb22'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_name_chars','3'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_name_chars','30'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_pass_chars','6'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_pass_chars','30'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_ratings','10'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','10'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','25'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars/upload'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('icons_path','images/icons'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ranks_path','images/ranks'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_enable','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_load', '2.0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online_time', '5'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_birthdays', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_moderators', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_search', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_search_upd', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_search_phr', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_lastread', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_track', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_gc', '3600'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_gc', '7200'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '600'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_check', '4'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('browser_check', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '2.1.1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_chars', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_smilies', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_quote_depth', '3'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_search_chars','3'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_search_chars','10'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_boxes','4'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs','50'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_last_edited', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','address@yourdomain.tld'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_contact','contact@yourdomain.tld'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size','50'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_port','25'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_interval','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_min_width','20'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_min_height','20'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','90'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','90'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_enable','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_method','db'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_server', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_base_dn', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_uid', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('lastread', '432000'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_order', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_ftp_upload', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize', '262144'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize_pm','262144'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('attachment_quota', '52428800'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments', '3'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments_pm', '1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_pm_attach', '0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_dir', 'files'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ftp_server', ''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ftp_path',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('download_path',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ftp_user',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ftp_pass',''); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('ftp_pasv_mode','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_display_inlined','1'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_max_width','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_max_height','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_link_width','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_link_height','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_create_thumbnail','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_imagick', ''); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_users', '0', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_date', '0', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_id', '2', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_username', '', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_users', '1', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_posts', '1', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_topics', '1', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('session_last_gc', '0', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('search_last_gc', '0', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('last_queue_run', '0', 1); + +# -- auth options +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_list', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_read', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_post', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_reply', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_quote', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_edit', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_delete', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_poll', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_vote', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_votechg', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_announce', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_sticky', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_attach', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_download', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_html', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_bbcode', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_smilies', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_img', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_flash', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_sigs', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_search', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_email', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_rate', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_print', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_ignoreflood', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_postcount', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_moderate', 1); +INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_report', 1); + +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_edit', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_delete', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_move', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_lock', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_split', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_merge', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_approve', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_unrate', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_auth', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_ip', 1, 1); +INSERT INTO phpbb_auth_options (auth_option, is_local, is_global) VALUES ('m_info', 1, 1); + +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_server', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_defaults', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_board', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_cookies', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_clearlogs', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_words', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_icons', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_bbcode', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_attach', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_email', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_styles', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_user', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_useradd', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_userdel', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_ranks', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_ban', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_names', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_group', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_groupadd', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_groupdel', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_forum', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_forumadd', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_forumdel', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_prune', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_auth', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_authmods', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_authadmins', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_authusers', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_authgroups', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_authdeps', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_backup', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_restore', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_search', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_events', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_cron', 1); + +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_sendemail', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_readpm', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_sendpm', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_viewonline', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_viewprofile', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgavatar', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chggrp', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgemail', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgname', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgpasswd', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgcensors', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_search', 1); + + +# MSSQL IDENTITY phpbb_styles ON # + +# -- phpbb_styles +INSERT INTO phpbb_styles (style_id, template_id, theme_id, imageset_id, style_name, bbcode_bitfield) VALUES (1, 1, 1, 1, 'subSilver', 2817); + +# MSSQL IDENTITY phpbb_styles OFF # + + +# MSSQL IDENTITY phpbb_styles_imageset ON # + +# -- phpbb_styles_imageset +INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_path, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_ip, btn_quote, btn_search, btn_edit, btn_report, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_online, btn_offline, btn_topic_watch, btn_topic_unwatch, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, sub_forum, sub_forum_new, folder, folder_posted, folder_new, folder_new_posted, folder_hot, folder_hot_posted, folder_hot_new, folder_hot_new_posted, folder_locked, folder_locked_posted, folder_locked_new, folder_locked_new_posted, folder_sticky, folder_sticky_posted, folder_sticky_new, folder_sticky_new_posted, folder_announce, folder_announce_posted, folder_announce_new, folder_announce_new_posted, poll_left, poll_center, poll_right) VALUES (1, 'subSilver © phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/btn_post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_post_pm.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_reply.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_report.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_icq.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_msnm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_online.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_offline.gif" width="59" height="18" border="0"', '', '', '"imagesets/subSilver/icon_unapproved.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_reported.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_attach.gif" width="14" height="18" border="0"', '"imagesets/subSilver/icon_minipost.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_minipost_new.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_latest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/icon_newest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/folder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_locked_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/vote_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" height="12" border="0"', '"imagesets/subSilver/vote_rcap.gif" width="4" height="12" border="0"'); + +# MSSQL IDENTITY phpbb_styles_imageset OFF # + + +# MSSQL IDENTITY phpbb_styles_template ON # + +# -- phpbb_styles_template +INSERT INTO phpbb_styles_template (template_id, template_name, template_path, poll_length, pm_box_length) VALUES (1, 'subSilver © phpBB Group', 'subSilver', 205, 175); + +# MSSQL IDENTITY phpbb_styles_template OFF # + + +# MSSQL IDENTITY phpbb_styles_theme ON # + +# -- phpbb_styles_theme +INSERT INTO phpbb_styles_theme (theme_id, css_data, css_external) VALUES (1, 'body {background: white url(\'templates/subSilver/images/background.png\') repeat-x;}\nth { background-image: url(\'templates/subSilver/images/cellpic3.gif\') }\ntd.cat { background-image: url(\'templates/subSilver/images/cellpic1.gif\') }\ntd.rowpic { background-image: url(\'templates/subSilver/images/cellpic2.jpg\'); background-repeat: repeat-y }\ntd.icqback { background-image: url(\'templates/subSilver/images/icon_icq_add.gif\'); background-repeat: no-repeat }', 'subSilver/subSilver.css'); + +# MSSQL IDENTITY phpbb_styles_theme OFF # + + +# MSSQL IDENTITY phpbb_lang ON # + +# -- Language +INSERT INTO phpbb_lang (lang_id, lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES (1, 'en', 'en', 'English [ UK ]', 'English [ UK ]', 'phpBB Group'); + +# MSSQL IDENTITY phpbb_lang OFF # + + +# MSSQL IDENTITY phpbb_forums ON # + +# -- Forums +INSERT INTO phpbb_forums (forum_id, 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_post_time) VALUES (1, 'My first Category', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 972086460); + +INSERT INTO phpbb_forums (forum_id, 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_post_time) VALUES (2, 'Test Forum 1', 'This is just a test forum.', 2, 3, 1, 1, 1, 1, 1, 1, 2, 'Admin', 972086460); + +# MSSQL IDENTITY phpbb_forums OFF # + + +# MSSQL IDENTITY phpbb_users ON # + +# -- Users +INSERT INTO phpbb_users (user_id, user_founder, username, user_regdate, user_password, user_email, user_lang, user_style) VALUES (1, 0, 'Anonymous', 0, '', '', 'en', 1); + +# -- username: Admin password: admin (change this or remove it ON #ce everything is working!) +INSERT INTO phpbb_users (user_id, user_founder, username, user_regdate, user_password, user_email, user_lang, user_style, user_rank) VALUES (2, 1, 'Admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1); + +# MSSQL IDENTITY phpbb_users OFF # + + +# MSSQL IDENTITY phpbb_ranks ON # + +# -- Ranks +INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Site Admin', -1, 1, NULL); + +# MSSQL IDENTITY phpbb_ranks OFF # + + +# MSSQL IDENTITY phpbb_groups ON # + +# -- Groups +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (1, 'GUESTS', 3); +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (2, 'INACTIVE', 3); +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (3, 'INACTIVE_COPPA', 3); +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (4, 'REGISTERED', 3); +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (5, 'REGISTERED_COPPA', 3); +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (6, 'SUPER_MODERATORS', 3); +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (7, 'ADMINISTRATORS', 3); +INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (8, 'BANNED', 3); + +# MSSQL IDENTITY phpbb_groups OFF # + + +# -- User -> Group +INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, 1, 0); +INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (4, 2, 0); +INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (7, 2, 0); + + +# -- User auth +INSERT INTO phpbb_auth_users (user_id, forum_id, auth_option_id, auth_setting) SELECT 2, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option LIKE 'm_%'; +INSERT INTO phpbb_auth_users (user_id, forum_id, auth_option_id, auth_setting) SELECT 2, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option LIKE 'm_%'; + + +# -- Group auth +# -- give very limited rights to GUEST and INACTIVE groups +# -- give basic, typically non-contencious rights to REGISTERED users +# -- give all admin rights to ADMIN group +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 1, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 1, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); + +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 2, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 2, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option IN ('f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_bbcode', 'f_search', 'f_print'); + +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 3, 1, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option IN ('f_', 'f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_edit', 'f_delete', 'f_vote', 'f_download', 'f_bbcode', 'f_smilies', 'f_img', 'f_flash', 'f_sigs', 'f_search', 'f_email', 'f_print', 'f_postcount'); +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 3, 1, auth_option_id, 2 FROM phpbb_auth_options WHERE auth_option IN ('f_poll', 'f_announce', 'f_sticky', 'f_attach', 'f_html', 'f_rate'); + +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 3, 2, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option IN ('f_', 'f_list', 'f_read', 'f_post', 'f_reply', 'f_quote', 'f_edit', 'f_delete', 'f_vote', 'f_download', 'f_bbcode', 'f_smilies', 'f_img', 'f_flash', 'f_sigs', 'f_search', 'f_email', 'f_print', 'f_postcount'); +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 3, 2, auth_option_id, 2 FROM phpbb_auth_options WHERE auth_option IN ('f_poll', 'f_announce', 'f_sticky', 'f_attach', 'f_html', 'f_rate'); + +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 5, 0, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option LIKE 'a_%'; + +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 3, 0, auth_option_id, 1 FROM phpbb_auth_options WHERE auth_option IN ('u_%'); +INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_setting) SELECT 5, 0, auth_option_id, 2 FROM phpbb_auth_options WHERE auth_option IN ('u_%') AND auth_option NOT IN ('u_chgcensors', 'u_chggrp'); + + +# -- Moderator cache +INSERT INTO phpbb_moderator_cache (user_id, forum_id, username) VALUES (2, 2, 'Admin'); + + +# MSSQL IDENTITY phpbb_topics ON # + +# -- Demo Topic +INSERT INTO phpbb_topics (topic_id, 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_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_post_time) VALUES (1, 'Welcome to phpBB 2', 2, 972086460, 0, 0, 0, 2, 0, 0, 1, 'Admin', 1, 2, 'Admin', 972086460); + +# MSSQL IDENTITY phpbb_topics OFF # + + +# MSSQL IDENTITY phpbb_posts ON # + +# -- Demo Post +INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip, post_subject, post_text) VALUES (1, 1, 2, 2, 972086460, NULL, '127.0.0.1', 'Welcome to phpBB 2', 'This is an example post in your phpBB 2.2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!'); + +# MSSQL IDENTITY phpbb_posts OFF # + + +# -- Smilies +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':D', 'icon_biggrin.gif', 'Very Happy', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':)', 'icon_smile.gif', 'Smile', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':(', 'icon_sad.gif', 'Sad', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':o', 'icon_surprised.gif', 'Surprised', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':eek:', 'icon_surprised.gif', 'Surprised', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES ('8O', 'icon_eek.gif', 'Shocked', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':?', 'icon_confused.gif', 'Confused', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES ('8)', 'icon_cool.gif', 'Cool', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':lol:', 'icon_lol.gif', 'Laughing', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':x', 'icon_mad.gif', 'Mad', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':P', 'icon_razz.gif', 'Razz', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':oops:', 'icon_redface.gif', 'Embarassed', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':cry:', 'icon_cry.gif', 'Crying or Very sad', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':evil:', 'icon_evil.gif', 'Evil or Very Mad', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':twisted:', 'icon_twisted.gif', 'Twisted Evil', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (';)', 'icon_wink.gif', 'Wink', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':!:', 'icon_exclaim.gif', 'Exclamation', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':?:', 'icon_question.gif', 'Question', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':idea:', 'icon_idea.gif', 'Idea', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':arrow:', 'icon_arrow.gif', 'Arrow', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':|', 'icon_neutral.gif', 'Neutral', 15, 15); +INSERT INTO phpbb_smilies (code, smile_url, emoticon, smile_width, smile_height) VALUES (':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 15, 15); + + +# -- icons ... these are just some of those in CVS +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/arrow_bold_rgt.gif', 19, 19, 1, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/redface_anim.gif', 19, 19, 9, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/mr_green.gif', 19, 19, 10, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/musical.gif', 19, 19, 4, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/asterix.gif', 19, 19, 2, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/square.gif', 19, 19, 3, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/alien_grn.gif', 19, 19, 5, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/idea.gif', 19, 19, 8, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/question.gif', 19, 19, 6, 1); +INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/exclaim.gif', 19, 19, 7, 1); + + +# -- ucp modules +INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (1, 'MAIN', 'main', 1); +INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (2, 'PROFILE', 'profile', 2); +INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (3, 'PREFERENCES', 'prefs', 3); +INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (4, 'MESSAGING', 'pm', 4); +INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (5, 'LISTS', 'zebra', 5); + + +# MSSQL IDENTITY phpbb_search_wordlist ON # + +# -- wordlist +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (1, 'example', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (2, 'post', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (3, 'phpbb', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (4, 'installation', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (5, 'delete', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (6, 'topic', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (7, 'forum', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (8, 'since', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (9, 'everything', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (10, 'seems', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (11, 'working', 0); +INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES (12, 'welcome', 0); + +# MSSQL IDENTITY phpbb_search_wordlist OFF # + + +# MSSQL IDENTITY phpbb_search_wordmatch ON # + +# -- wordmatch +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (1, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (2, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (3, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (4, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (5, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (6, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (7, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (8, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (9, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (10, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (11, 1, 0); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (12, 1, 1); +INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (3, 1, 1); + +# MSSQL IDENTITY phpbb_search_wordmatch OFF # + + +# MSSQL IDENTITY phpbb_reports_reasons ON # + +# -- reasons +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (1, 0, 'warez', 'The reported post contains links to pirated or illegal software.'); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (2, 1, 'other', 'The reported post does not fit into any other category, please use the description field.'); + +# MSSQL IDENTITY phpbb_reports_reasons OFF # + + +# MSSQL IDENTITY phpbb_forbidden_extensions ON # + +# -- forbidden_extensions +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (1, 'php'); +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (2, 'php3'); +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (3, 'php4'); +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (4, 'phtml'); +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (5, 'pl'); +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (6, 'asp'); +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (7, 'cgi'); +INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (8, 'aspx'); + +# MSSQL IDENTITY phpbb_forbidden_extensions OFF # + + +# MSSQL IDENTITY phpbb_extension_groups ON # + +# -- extension_groups +INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (1, 'Images', 1, 1, 1, '', 0); +INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (2, 'Archives', 0, 1, 1, '', 0); +INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (3, 'Plain Text', 0, 0, 1, '', 0); +INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (4, 'Documents', 0, 0, 1, '', 0); +INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (5, 'Real Media', 3, 0, 2, '', 0); +INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize) VALUES (6, 'Windows Media', 2, 0, 1, '', 0); + +# MSSQL IDENTITY phpbb_extension_groups OFF # + + +# MSSQL IDENTITY phpbb_extensions ON # + +# -- extensions +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (1, 1, 'gif', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (2, 1, 'png', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (3, 1, 'jpeg', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (4, 1, 'jpg', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (5, 1, 'tif', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (6, 1, 'tga', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (7, 2, 'gtar', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (8, 2, 'gz', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (9, 2, 'tar', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (10, 2, 'zip', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (11, 2, 'rar', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (12, 2, 'ace', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (13, 3, 'txt', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (14, 3, 'c', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (15, 3, 'h', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (16, 3, 'cpp', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (17, 3, 'hpp', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (18, 3, 'diz', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (19, 4, 'xls', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (20, 4, 'doc', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (21, 4, 'dot', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (22, 4, 'pdf', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (23, 4, 'ai', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (24, 4, 'ps', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (25, 4, 'ppt', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (26, 5, 'rm', ''); +INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (27, 6, 'wma', ''); + +# MSSQL IDENTITY phpbb_extensions OFF # |