#
# Basic DB data for phpBB-WAP devel
#
# $Id: mysql_basic.sql, v6 2008/08/05 17:00:00 Exp $
# -- 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','phpbb-wap.ru');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','Форум phpBB-WAP');
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 ('enable_confirm', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','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','10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','10');
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','Форумы phpBB-WAP');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','[email protected]');
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 ('sendmail_fix','0');
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_flood_interval','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_min_chars','3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
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','9');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','d M, G:i');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','4');
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', 'localhost');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '4');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rand_seed', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_enabled', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_enabled', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reports_enabled', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_least_respected', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_ban_warnings', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_delete_expired', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_warning_expire', '1,100');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_ban_expire', '1,100');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_perms', '0,0,1,3,3,3,3,5,3,5,3,3,3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_none', '0,0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_mod_norep', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_reviews_per_page', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_reports_per_page', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_display', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_most_respected', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_days_req', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_posts_req', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_points_req', '-100000');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_warnings_req', '100000');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_rotation_limit', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_time_limit', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_check_rate', '60');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_last_check_time', '1152884749');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_empty_reviews', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_positive_only', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_check_reports', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_reports_color', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('reputation_admin_norep', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('online_time', '60');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_user_topics_per_page', '50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_user_posts_per_page', '50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_required', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_greeting', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_user_age', '100');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_user_age', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_check_day', '7');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('index_announcement', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('index_spisok', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('send_user_icq', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_icq', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_icq_pass', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_icq_interval', '60');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_check_icq_time', '0');
# -- Categories
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (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, 'Тестовый форум', 'Ля-Ля', 1, 10, 1, 1, 1, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 1);
# -- 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_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, 1, 1, 0, 1, 1, NULL, '', '', 0, '', '', '', 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_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, '202cb962ac59075b964b07152d234b70', '[email protected]', '', '', '', '', '', '', 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'russian', 0, 'd M, G:i', '', '', 0, 1);
# -- Ranks
INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Админ форума', -1, 1, NULL);
INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (2, 'Юзер', 0, 0, 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, 'Вас приветствует форум phpBB-WAP!', 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, 'Привет! Если ты читаешь это сообщение, значит форум phpBB-WAP v6 успешно установился! Пользуйся на здоровье :)');
INSERT INTO phpbb_styles_css VALUES ('1', 'Синий', 'body { background-color : #e2f0f8;}
font,th,td,p {
color: #494949;
font-family: sans-serif;
font-size: 12px;
}
a:link,a:active,a:visited {
color: #40A7FC;
text-decoration: none;
}
a:hover { text-decoration: none; color: black; position: relative; top: 1px; }
td.catSides { background-color: #228FEA; border-bottom: 3px solid #1581DA; border-top: 3px solid #40A7FC; border-left: 3px solid #40A7FC; border-right: 3px solid #1581DA; height: 23px; }
td.row1 { background-color: #D3E5F0; border-bottom: 3px solid #C1DCED; border-top: 3px solid #E9F2F8; border-left: 3px solid #E9F2F8; border-right: 3px solid #C1DCED;}
td.row_easy { background-color: #E9F2F8; border-bottom: 3px solid #C1DCED; border-top: 3px solid #FFFFFF; border-left: 3px solid #FFFFFF; border-right: 3px solid #C1DCED; padding: 1px;}
td.row_hard { background-color: #D3E5F0; border-bottom: 3px solid #C1DCED; border-top: 3px solid #E9F2F8; border-left: 3px solid #E9F2F8; border-right: 3px solid #C1DCED; padding: 1px;}
.subbutton { color: #FFF; background-color: #228FEA; border-top: 2px solid #40A7FC; border-left: 2px solid #40A7FC; border-right: 2px solid #1581DA; border-bottom: 2px solid #1581DA; }
.forumline { font-size: none; background-color: #999999;}
.genmed { font-size : 11px; }
.cattitle {
color: #FFFFFF;
font-weight: bold;
font-size: 11px;}
a.cattitle { color: #FFFFFF; text-decoration: none; }
a.mainmenu { color: #333333; text-decoration: none; font-weight: bold;}
a.buttom { color: #40A7FC; border: 1px solid #C1DCED; background: #D3E5F0; padding: 0px 2px 0px; line-height: 1.5;}');
INSERT INTO phpbb_styles_css VALUES ('2', 'Жёлтый', 'body { background-color : #FFFFB9;}
font,th,td,p {
color: #494949;
font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
a:link,a:active,a:visited {
color: green;
text-decoration: none;
}
a:hover { text-decoration: none; color: black; position: relative; top: 1px; }
td.catSides { background-color: #FFBF40; border-bottom: 1px solid #FFAA00; border-left: 1px solid #FFAA00; border-right: 1px solid #FFAA00; height: 23px; }
td.row1 { background-color: #FFFF90; border-bottom: 1px solid #FFBF40; border-left: 1px solid #FFBF40; border-right: 1px solid #FFBF40;}
td.row_easy { background-color: #FFFF90; border-bottom: 1px solid #FFBF40; border-left: 1px solid #FFBF40; border-right: 1px solid #FFBF40; padding: 1px;}
td.row_hard { background-color: #FFFF70; border-bottom: 1px solid #FFBF40; border-left: 1px solid #FFBF40; border-right: 1px solid #FFBF40; padding: 1px;}
.forumline { font-size: none; background-color: #999999;}
.genmed { font-size : 11px; }
.cattitle {
color: #494949;
font-weight: bold;
font-size: 11px;}
a.cattitle { color: green; text-decoration: none; }
a.mainmenu { color: #333333; text-decoration: none; font-weight: bold;}
a.buttom { color: green; border: 1px solid #FFBF40; background: #FFBF40; padding: 0px 2px 0px; line-height: 1.5;}');
INSERT INTO phpbb_styles_css VALUES ('3', 'Серый', 'body { background-color : #FFFFFF; color: #494949; font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
a:link,a:active,a:visited { color: #3B678D; text-decoration: none; }
a:hover { text-decoration: none; color: black; position: relative; top: 1px; }
td.catSides { background: url(images/cellpic1.gif); background-color: #D4D6D4; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; height: 23px; }
td.row1 { background-color: #EBEBEB; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; }
td.row_easy { background-color: #EBEBEB; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; padding: 1px; }
td.row_hard { background-color: #D4D6D4; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; padding: 1px; }
.forumline { font-size: none; background-color: #999999;}
.genmed { font-size : 11px; }
.cattitle { color: #333333; font-weight: bold; font-size: 11px; }
a.cattitle { color: #3B678D; text-decoration: none; }
a.mainmenu { color: #333333; text-decoration: none; font-weight: bold; }
a.buttom { color: #333333; border: 1px solid #999999; background: #D4D6D4; padding: 0px 2px 0px; line-height: 1.5; }');
INSERT INTO phpbb_styles_css VALUES ('4', 'Чёрно-зелёный', 'body { background-color : #000000;}
font,th,td,p {
color: #FFD700;
font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
a:link,a:active,a:visited {
color: #00FF00;
text-decoration: none;
}
td.catSides { background-color: #222222; border-bottom: 3px solid #131313; border-left: 3px solid #3b3b3b; border-top: 3px solid #3b3b3b; border-right: 3px solid #131313; height: 23px; }
td.row1 { background-color: #222222; border-bottom: 1px solid #444444; border-left: 1px solid #444444; border-right: 1px solid #444444;}
td.row_easy { background-color: #525252; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; padding: 1px;}
td.row_hard { background-color: #727272; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; padding: 1px;}
.forumline { font-size: none; background-color: #999999;}
.genmed { font-size : 11px; }
.cattitle {
color: #ffffff;
font-weight: bold;
font-size: 11px;}
a.cattitle { color: #3B678D; text-decoration: none; }
a.mainmenu { color: #333333; text-decoration: none; font-weight: bold;}
a.buttom { color: #000000; border: 1px solid #999999; background: #727272; padding: 0px 2px 0px; line-height: 1.5;}');
INSERT INTO phpbb_styles_css VALUES ('5', 'Чёрно-синий', 'body { background-color : #000000;}
font,th,td,p {
color: #FFFFFF;
font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
a:link,a:active,a:visited {
color: #0099FF;
text-decoration: none;
}
td.catSides { background-color: #003366; border-bottom: 3px solid #002b55; border-left: 3px solid #004284; border-top: 3px solid #004284; border-right: 3px solid #002b55; height: 23px; }
td.row1 { background-color: #000000; border-bottom: 1px solid #557898; border-left: 1px solid #557898; border-right: 1px solid #557898;}
td.row_easy { background-color: #002255; border-bottom: 1px solid #557898; border-left: 1px solid #557898; border-right: 1px solid #557898; padding: 1px;}
td.row_hard { background-color: #000000; border-bottom: 1px solid #557898; border-left: 1px solid #557898; border-right: 1px solid #557898; padding: 1px;}
.forumline { font-size: none; background-color: #557898;}
.genmed { font-size : 11px; }
.off { font-size: 10px; color: #999999 }
.cattitle {
color: #00FF00;
font-weight: bold;
font-size: 11px;}
a.cattitle { color: #008000; text-decoration: none; }
a.mainmenu { color: #008000; text-decoration: none; font-weight: bold;}
a.buttom { color: #008000; border: 1px solid #557898; background: #ADD2F5; padding: 0px 2px 0px; line-height: 1.5;}');
INSERT INTO phpbb_styles_css VALUES ('6', 'Зелёный', 'body { background-color : #294000;}
font,th,td,p {
color: #FFFFFF;
font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
a:link,a:active,a:visited {
color: #34EB5E;
text-decoration: none;
}
td.catSides { background-color: #3B7D32; border-bottom: 1px solid #557898; border-left: 1px solid #557898; border-right: 1px solid #557898; height: 23px; }
td.row1 { background-color: #295723 ;border-bottom: 1px solid #557898; border-left: 1px solid #557898; border-right: 1px solid #557898;}
td.row_easy { background-color: #1f6516; border-bottom: 1px solid #557898; border-left: 1px solid #557898; border-right: 1px solid #557898; padding: 1px;}
td.row_hard { background-color: #295723; border-bottom: 1px solid #557898; border-left: 1px solid #557898; border-right: 1px solid #557898; padding: 1px;}
.forumline { font-size: none; background-color: #557898;}
.genmed { font-size : 11px; }
.off { font-size: 10px; color: #999999 }
.cattitle {
color: #00FF00;
font-weight: bold;
font-size: 11px;}
a.cattitle { color: #000000; text-decoration: none; }
a.mainmenu { color: 000000; text-decoration: none; font-weight: bold;}
a.buttom { color: #000000; border: 1px solid #557898; background: #ADD2F5; padding: 0px 2px 0px; line-height: 1.5;}');
INSERT INTO phpbb_styles_css VALUES ('7', 'Розовый', 'body { background-color : #ffdbf6;}
font,th,td,p {
color: #494949;
font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
a:link,a:active,a:visited {
color: #fb1ac3;
text-decoration: none;
}
a:hover { text-decoration: none; color: black; position: relative; top: 1px; }
td.catSides { background-color: #ed01b3; border-bottom: 3px solid #d802a3; border-top: 3px solid #fb01bd; border-left: 3px solid #fb01bd; border-right: 3px solid #d802a3; height: 23px; }
td.row1 { background-color: #fed0f3; border-bottom: 3px solid #fec4f0; border-top: 3px solid #fee7f8; border-left: 3px solid #fee7f8; border-right: 3px solid #fec4f0;}
td.row_easy { background-color: #fee7f8; border-bottom: 3px solid #ffdcf6; border-top: 3px solid #ffffff; border-left: 3px solid #ffffff; border-right: 3px solid #ffdcf6; padding: 1px;}
td.row_hard { background-color: #fed0f3; border-bottom: 3px solid #fec4f0; border-top: 3px solid #fee7f8; border-left: 3px solid #fee7f8; border-right: 3px solid #fec4f0; padding: 1px;}
.subbutton { color: #FFF; background-color: #ed01b3; border-top: 2px solid #fb01bd; border-left: 2px solid #fb01bd; border-right: 2px solid #d802a3; border-bottom: 2px solid #d802a3; }
.forumline { font-size: none; background-color: #999999;}
.genmed { font-size : 11px; }
.cattitle {
color: #FFFFFF;
font-weight: bold;
font-size: 11px;}
a.cattitle { color: #FFFFFF; text-decoration: none; }
a.mainmenu { color: #333333; text-decoration: none; font-weight: bold;}
a.buttom { color: #fb1ac3; border: 1px solid #fec4f0; background: #fed0f3; padding: 0px 2px 0px; line-height: 1.5;}');
INSERT INTO phpbb_styles_css VALUES ('8', 'Чёрно-красный', 'body { background-color : #000000; }
font,th,td,p { color: #FFFFFF; font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
a:link,a:active,a:visited
{ color: #FF9900;text-decoration: none; }
a:hover { text-decoration: none; color: #FFFF00; position: relative; top: 1px; }
td.catSides { background-color: #990000; border-bottom: 3px solid #660000; border-left: 3px solid #CC0000; border-top: 3px solid #CC0000; border-right: 3px solid #660000; height: 23px; }
td.row1 { background-color: #000000; border-bottom: 1px solid #CC3300; border-left: 1px solid #CC3300; border-right: 1px solid #CC3300;}
td.row_easy { background-color: #660000; border-bottom: 1px solid #CC3300; border-left: 1px solid #CC3300; border-right: 1px solid #CC3300; padding: 1px;}
td.row_hard { background-color: #000000; border-bottom: 1px solid #CC3300; border-left: 1px solid #CC3300; border-right: 1px solid #CC3300; padding: 1px;}
.forumline { font-size: none; background-color: #CC3300;}
.genmed { font-size : 11px; }
.off { font-size: 10px; color: #999999 }
.cattitle { color: #00FF00; font-weight: bold; font-size: 11px; }
a.cattitle { color: #008000; text-decoration: none; }
a.mainmenu { color: #008000; text-decoration: none; font-weight: bold;}
a.buttom { color: #990033; border: 1px solid #990033; background: #FFCC66; padding: 0px 2px 0px; line-height: 1.5;}');
INSERT INTO phpbb_styles_css VALUES ('9', 'phpBB-WAP', 'body { background-color : #DCDCDC; color: #494949; font-family: sans-serif; font-size: 12px; }
td { font-size: 12px; }
a:link,a:active,a:visited { color: #0000FF; text-decoration: none; }
a:hover { text-decoration: none; color: black; position: relative; top: 1px; }
div.cat { color: #DDDDDD; background: url(images/fon_grey.gif); background-color: #696969; padding: 0px 2px 0px; }
td.catSides { background: url(images/vista.gif); background-color: #696969; border-bottom: 1px solid #DCDCDC; height: 28px; }
td.row1 { background-color: #EBEBEB; border-bottom: 1px solid #DCDCDC; }
td.row_easy { background-color: #EBEBEB; }
td.row_hard { background-color: #D4D6D4; }
.forumline { font-size: none; background-color: #999999;}
.genmed { font-size : 11px; }
.cattitle {
color: #FFFFFF;
font-weight: bold;
font-size: 12px; }
a.cattitle { color: #FFFFFF; text-decoration: none; }
a.mainmenu { color: #333333; text-decoration: none; font-weight: bold; }
a.buttom { color: #494949; border: 1px solid #C4C6C4; background: #D4D6D4; padding: 0px 2px 0px; line-height: 1.5; }');
# -- Smilies
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':hello:', '43.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':heart:', '42.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':happy:', '41.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':hack:', '40.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, '%O', '39.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, '%]', '38.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, '%-(', '37.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, '%(', '36.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, '%)', '35.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':!', '34.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ';/', '33.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':@', '32.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, ':?', '31.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, ':-Z', '30.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':Z', '29.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':F', '28.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, ':R', '26.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, ':-|', '25.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, ':X', '24.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, ':Q', '23.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':|', '22.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':-P', '21.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':P', '20.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':-E', '19.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':E', '18.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':A', '17.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':-L', '16.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':L', '15.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':-D', '14.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':D', '13.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':-O', '12.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':O', '11.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, '8)', '10.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ':*', '9.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ':-(', '8.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ':(', '7.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ';-)', '6.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ';)', '5.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':-))', '4.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':))', '3.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':-)', '2.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':)', '1.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 43, ':help:', '44.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 44, ':holiday:', '45.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 45, ':huh:', '46.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 46, ':idea:', '47.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 47, ':inlove:', '48.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 48, ':insult:', '49.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 49, ':kaka:', '50.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 50, ':kid:', '51.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 51, ':klown:', '53.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 52, ':lame:', '54.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 53, ':lang:', '55.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 54, ':lips:', '56.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 55, ':lool:', '52.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 56, ':lol:', '57.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 57, ':love:', '58.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 58, ':kiss:', '59.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 59, ':mda:', '60.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 60, ':ninja:', '61.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 61, ':nunu:', '62.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 62, ':off:', '63.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 63, ':onlain:', '64.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 64, ':oops:', '65.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 65, ':overlook:', '66.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 66, ':pash:', '67.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 67, ':pensive:', '68.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 68, ':police:', '69.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 69, ':proud:', '70.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 70, ':punk:', '71.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 71, ':rasta:', '72.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 72, ':read:', '73.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 73, ':rip:', '74.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 74, ':russia:', '75.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 75, ':sad:', '76.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 76, ':scared:', '77.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 77, ':shish:', '78.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 78, ':shock:', '79.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 79, ':shut_up:', '80.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 80, ':smile:', '81.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 81, ':smoke:', '82.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 82, ':sorry:', '83.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 83, ':spam:', '84.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 84, ':spider:', '85.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 85, ':stop:', '86.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 86, ':sun:', '87.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 87, ':ubanned:', '88.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 88, ':uff:', '89.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 89, ':up:', '90.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 90, ':welcome:', '91.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 91, ':wow:', '92.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 92, ':yo:', '93.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 93, ':zip:', '94.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 94, ':admin:', '95.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 95, ':afflict:', '96.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 96, ':angry:', '97.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 97, ':ban:', '98.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 98, ':beer:', '99.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 99, ':bomb:', '100.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 100, ':bravo:', '101.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 101, ':champ:', '102.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 102, ':closed:', '103.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 103, ':cry:', '104.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 104, ':dead:', '105.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 105, ':death:', '106.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 106, ':dont:', '107.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 107, ':down:', '108.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 108, ':drink:', '109.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 109, ':erm:', '110.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 110, ':evil:', '111.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 111, ':fine:', '112.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 112, ':fyou:', '113.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 113, ':gloomy:', '114.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 114, ':grin:', '115.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 115, ':gun:', '116.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 116, ':faq:', '117.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 117, ':flud:', '118.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 118, ':hangs:', '120.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 119, ':peace:', '120.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 120, ':hangs:', '119.gif', ' ');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 121, ':wall:', '121.gif', ' ');
# -- 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 );
# -- attachments_config
INSERT INTO phpbb_attachments_config VALUES ('upload_dir', 'files');
INSERT INTO phpbb_attachments_config VALUES ('upload_img', 'images/icon_clip.gif');
INSERT INTO phpbb_attachments_config VALUES ('topic_icon', 'images/icon_clip.gif');
INSERT INTO phpbb_attachments_config VALUES ('display_order', '0');
INSERT INTO phpbb_attachments_config VALUES ('max_filesize', '102400');
INSERT INTO phpbb_attachments_config VALUES ('attachment_quota', '0');
INSERT INTO phpbb_attachments_config VALUES ('max_filesize_pm', '102400');
INSERT INTO phpbb_attachments_config VALUES ('max_attachments', '5');
INSERT INTO phpbb_attachments_config VALUES ('max_attachments_pm', '3');
INSERT INTO phpbb_attachments_config VALUES ('disable_mod', '0');
INSERT INTO phpbb_attachments_config VALUES ('allow_pm_attach', '1');
INSERT INTO phpbb_attachments_config VALUES ('attachment_topic_review', '0');
INSERT INTO phpbb_attachments_config VALUES ('allow_ftp_upload', '0');
INSERT INTO phpbb_attachments_config VALUES ('show_apcp', '0');
INSERT INTO phpbb_attachments_config VALUES ('attach_version', '2.4.5');
INSERT INTO phpbb_attachments_config VALUES ('default_upload_quota', '0');
INSERT INTO phpbb_attachments_config VALUES ('default_pm_quota', '0');
INSERT INTO phpbb_attachments_config VALUES ('ftp_server', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_path', '');
INSERT INTO phpbb_attachments_config VALUES ('download_path', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_user', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_pass', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_pasv_mode', '1');
INSERT INTO phpbb_attachments_config VALUES ('img_display_inlined', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_max_width', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_max_height', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_link_width', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_link_height', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_create_thumbnail', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_min_thumb_filesize', '12000');
INSERT INTO phpbb_attachments_config VALUES ('img_imagick', '');
INSERT INTO phpbb_attachments_config VALUES ('use_gd2', '0');
INSERT INTO phpbb_attachments_config VALUES ('wma_autoplay', '0');
INSERT INTO phpbb_attachments_config VALUES ('flash_autoplay', '0');
# -- forbidden_extensions
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (8,'php5');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (9,'php6');
# -- extension_groups
INSERT INTO phpbb_extension_groups VALUES (1, 'Прочее', 0, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (2, 'Видео', 0, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (3, 'Картинки', 1, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (4, 'Архивы', 0, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (5, 'Мелодии', 0, 1, 1, '', 102400, '');
# -- extensions
INSERT INTO phpbb_extensions VALUES (1, 3, 'gif', '');
INSERT INTO phpbb_extensions VALUES (2, 3, 'png', '');
INSERT INTO phpbb_extensions VALUES (3, 3, 'jpeg', '');
INSERT INTO phpbb_extensions VALUES (4, 3, 'jpg', '');
INSERT INTO phpbb_extensions VALUES (5, 4, 'tar', '');
INSERT INTO phpbb_extensions VALUES (6, 4, 'zip', '');
INSERT INTO phpbb_extensions VALUES (7, 4, 'rar', '');
INSERT INTO phpbb_extensions VALUES (8, 1, 'txt', '');
INSERT INTO phpbb_extensions VALUES (9, 1, 'sis', '');
INSERT INTO phpbb_extensions VALUES (10, 1, 'jad', '');
INSERT INTO phpbb_extensions VALUES (11, 4, 'jar', '');
INSERT INTO phpbb_extensions VALUES (12, 5, 'aac', '');
INSERT INTO phpbb_extensions VALUES (13, 2, 'avi', '');
INSERT INTO phpbb_extensions VALUES (14, 2, 'mp4', '');
INSERT INTO phpbb_extensions VALUES (15, 2, '3gp', '');
INSERT INTO phpbb_extensions VALUES (16, 5, 'amr', '');
INSERT INTO phpbb_extensions VALUES (17, 5, 'mmf', '');
INSERT INTO phpbb_extensions VALUES (18, 5, 'mp3', '');
INSERT INTO phpbb_extensions VALUES (19, 5, 'wav', '');
INSERT INTO phpbb_extensions VALUES (20, 5, 'midi', '');
INSERT INTO phpbb_extensions VALUES (21, 5, 'mid', '');
INSERT INTO phpbb_extensions VALUES (22, 3, 'bmp', '');
# -- default quota limits
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880);
INSERT INTO phpbb_album_config VALUES ('max_pics', '1024');
INSERT INTO phpbb_album_config VALUES ('user_pics_limit', '50');
INSERT INTO phpbb_album_config VALUES ('mod_pics_limit', '250');
INSERT INTO phpbb_album_config VALUES ('max_file_size', '128000');
INSERT INTO phpbb_album_config VALUES ('max_width', '800');
INSERT INTO phpbb_album_config VALUES ('max_height', '600');
INSERT INTO phpbb_album_config VALUES ('rows_per_page', '3');
INSERT INTO phpbb_album_config VALUES ('cols_per_page', '1');
INSERT INTO phpbb_album_config VALUES ('fullpic_popup', '1');
INSERT INTO phpbb_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO phpbb_album_config VALUES ('thumbnail_size', '125');
INSERT INTO phpbb_album_config VALUES ('thumbnail_cache', '1');
INSERT INTO phpbb_album_config VALUES ('sort_method', 'pic_time');
INSERT INTO phpbb_album_config VALUES ('sort_order', 'DESC');
INSERT INTO phpbb_album_config VALUES ('jpg_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('png_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('gif_allowed', '0');
INSERT INTO phpbb_album_config VALUES ('desc_length', '512');
INSERT INTO phpbb_album_config VALUES ('hotlink_prevent', '0');
INSERT INTO phpbb_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO phpbb_album_config VALUES ('personal_gallery', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_private', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_limit', '10');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_view', '-1');
INSERT INTO phpbb_album_config VALUES ('rate', '1');
INSERT INTO phpbb_album_config VALUES ('rate_scale', '10');
INSERT INTO phpbb_album_config VALUES ('comment', '1');
INSERT INTO phpbb_album_config VALUES ('gd_version', '2');
INSERT INTO phpbb_album_config VALUES ('album_version', '.0.54');