mysql_basic.sql - DriveHQ Cloud IT/Storage service

Yes No
Do you want to visit DriveHQ English website?
mysql_basic.sql - Hosted on DriveHQ Cloud IT Platform
返回上层目录
上传
下载
共享
发布
新建文件夹
新建文件
复制
剪切
删除
粘贴
评论
升级服务
路径: \\mustafa1\fora\db\schemas\mysql_basic.sql
旋转
特效
属性
历史版本
#
# Basic DB data for phpBB2 modified v1.12.5 by Przemo
#

# -- album
INSERT INTO phpbb_album VALUES (6, 'af8a9f4b3bc6ef0c9174b2b46051f5a7.jpg', 'af8a9f4b3bc6ef0c9174b2b46051f5a7.jpg', 'Zdjecie 4', 'opis zdjecia opis zdjecia opis zdjecia opis zdjecia', 2, 'Przemo', '7f000001', 1055091404, 1, 5, 0, 1);
INSERT INTO phpbb_album VALUES (3, '324c3dcd885b202cbe12358ab21e3073.jpg', '324c3dcd885b202cbe12358ab21e3073.jpg', 'Zdjecie 2', '', 2, 'Przemo', '7f000001', 1055091316, 1, 0, 0, 1);
INSERT INTO phpbb_album VALUES (5, '66738c6936cc0a48670409a2a85dcf7a.jpg', '66738c6936cc0a48670409a2a85dcf7a.jpg', 'Las', 'LasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLas', 2, 'Przemo', '7f000001', 1055091390, 1, 0, 0, 1);

# -- album_cat
INSERT INTO phpbb_album_cat VALUES (1, 0, 0, 'Przyroda', 'Tutaj dajemy zdj�cia krajobraz�w :)', 10, -1, 0, 0, 0, 0, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

# -- album_config
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', '4');
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', '');
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', '1');
INSERT INTO phpbb_album_config VALUES ('album_version', '.0.51');
INSERT INTO phpbb_album_config VALUES ('watermark_width', '10');
INSERT INTO phpbb_album_config VALUES ('watermark_height', '10');
INSERT INTO phpbb_album_config VALUES ('watermark_transparent', '0');

# -- attachments_config
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir', 'files');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img', 'images/icon_clip.gif');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon', 'images/icon_clip.gif');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize', '262144');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota', '52428800');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm', '262144');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments', '10');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm', '1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach', '1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review', '1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server', '');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path', '');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path', '');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user', '');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass', '');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined', '1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail', '1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize', '12000');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode', '1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2', '0');

# -- categories
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order, cat_main_type, cat_main, cat_desc) VALUES (1, 'G��wna kategoria forum', 10, 'c', 0, 'G��wna kategoria forum');
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order, cat_main_type, cat_main, cat_desc) VALUES (4, 'Kategoria Portal i Sondy', 80, 'c', 1, '');
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order, cat_main_type, cat_main, cat_desc) VALUES (3, 'Kategoria SubFor', 40, 'f', 2, '');

# -- config
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.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 ('cookie_domain', '');
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_secure', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length', '900');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('check_address', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename', 'Nazwa twojego forum');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc', 'Kr�tki tekst opisuj�cy twoje forum');
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_avatar_local', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload', '1');
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', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options', '30');
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', 'Administrator Forum');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email', 'twojlogin@twojadres.pl');
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', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize', '12144');
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', 'Y-m-d, H:i');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone', '1.00');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress', '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 ('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 ('version', '1.12.5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_photo_remote', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_photo_upload', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_filesize', '40000');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_max_height', '200');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_max_width', '200');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_path', 'images/photos');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_custom_rank', '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 ('cload', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cchat', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cstat', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cregist', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cstyles', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ccount', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cchat2', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cbirth', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cpost', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ctop', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cfriend', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cage', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cjoin', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cfrom', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cposts', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('clevell', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cleveld', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cignore', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cquick', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cgg', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('csearch', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cicq', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cllogin', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('clevelp', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cyahoo', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cmsn', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cjob', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cinter', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cemail', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cbbcode', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chtml', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('csmiles', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('clang', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ctimezone', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cbstyle', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('refresh', '0' );
INSERT INTO phpbb_config (config_name, config_value) VALUES ('meta_keywords', '' );
INSERT INTO phpbb_config (config_name, config_value) VALUES ('meta_description', '' );
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cavatar', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('clog', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cagent', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_require', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('crestrict', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('validate', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_b', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_i', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_u', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_q', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_c', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_l', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_im', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_ur', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_ce', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_f', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_s', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('button_hi', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('color_box', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('size_box', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('glow_box', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('freak', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode_quest', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sql', 'http://');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cregist_b', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_custom_color', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_color_view', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_color_use', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('post_icon', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('auto_date', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('newest', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('download', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ipview', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_badwords', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('album_gallery', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('address_whois', 'http://www.dnsstuff.com/tools/whois.ch?ip=');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('u_o_t_d', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('expire', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('expire_value', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('numer_gg', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('haslo_gg', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('block_time', '40');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_error', '10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_password_len', '3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('force_complex_password', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('password_not_login', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('del_user_notify', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_aim', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_website', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_location', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('post_footer', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('graphic', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_custom_rank', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_location', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_color_mod', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_rank_mod', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_image', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sig_images_path', 'images/signatures');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sig_image_filesize', '30000');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sig_image_max_width', '400');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sig_image_max_height', '50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hide_viewed_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hide_edited_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('who_viewed', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('who_viewed_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('gender', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_gender', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('main_admin_id', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('day_to_prune', '120');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('banner_top', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('banner_top_enable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('banner_bottom', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('banner_bottom_enable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('header_enable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('not_edit_admin', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('staff_forums', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('staff_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_columns', '4');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_rows', '8');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_w_columns', '8');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('generate_time', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('name_color', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('desc_color', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_nick_color', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_warnings', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_edit_warnings', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_value_warning', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('write_warnings', '3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ban_warnings', '6');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('expire_warnings', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_mods_public', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewtopic_warnings', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_msg_enable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_msg', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('width_forum', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('width_table', '800');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('width_color1', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('width_color2', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('table_border', '6');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rebuild_search', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('generate_time_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('r_a_r_time', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('visitors', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_return_path', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_from', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('poster_posts', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sub_forum', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sub_forum_over', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('split_cat', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('split_cat_over', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_topic_title', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_topic_title_over', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_topic_title_length', '24');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sub_level_links', '2');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sub_level_links_over', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_viewonline', '2');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_viewonline_over', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ignore_topics', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topic_color', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topic_color_all', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topic_color_mod', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_image_img', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_dtable_notify', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_no_guestes', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_no_auth_users', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_no_auth_groups', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_disabled_users', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_disabled_groups', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_only_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_popup_height', '250');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_popup_width', '700');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_popup_links_target', '2');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_disable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sendmail_fix', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_visitors_time', '24');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars_admin', '6');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars_mod', '3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewonline', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('restrict_smilies', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topic_preview', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('not_anonymous_posting', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('not_anonymous_quickreply', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_smilies', '24');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('portal_link', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('overlib',	'1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('notify_gg', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('admin_notify_gg',	'');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('admin_notify_reply', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('admin_notify_message', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topic_start_date', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topic_start_dateformat', 'd-m-y');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('autorepair_tables', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('echange_banner', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('banners_list', '<center><a href="http://phpbb.com" target="_blank"><img src="images/link_phpbb.gif" alt="" border="0" /></a></center><br />[banner]<center><a href="http://forumimages.com" target="_blank"><img src="images/link_forumimages.gif" alt="" border="0" /></a></center><br />[banner]<center><embed src="images/clock.swf" quality=high type="application/x-shockwave-flash" width="80" height="80" /></center>');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('split_messages', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('split_messages_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('split_messages_mod', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('admin_html', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('jr_admin_html', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_html', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('helped', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('del_notify_method', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('del_notify_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('del_notify_choice', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('open_in_windows', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('title_explain', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_action_unlocked', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_action_locked', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_action_moved', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_action_expired', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_action_edited_by_others', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_action_edited_self', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_action_edited_self_all', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_mod_delete_actions', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('show_rules', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_spy', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_spy_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('post_overlib', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ph_days', '14');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ph_len', '8');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ph_mod', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('ph_mod_delete', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('newestuser', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topiccount', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('postcount', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('usercount', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('lastpost', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('anonymous_simple', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('onmouse', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_data', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('data', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_resync', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('advert', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('advert_foot', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('view_ad_by', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('advert_width', '150');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('advert_separator', ' • ');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('advert_separator_l', '<br /><hr />');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('adv_person_time', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('group_rank_hack_version', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('disable_type', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rh_without_days', '3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rh_max_posts', '1000');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('public_category', '');

# -- extension_groups
INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) 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, forum_permissions) 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, forum_permissions) 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, forum_permissions) 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, forum_permissions) VALUES (5,'Real Media',0,0,2,'',0,'');
INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (6,'Streams',2,0,1,'',0,'');
INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (7,'Flash Files',3,0,1,'',0,'');

# -- extensions
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (1, 1, 'gif', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (2, 1, 'png', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (3, 1, 'jpeg', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (4, 1, 'jpg', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (5, 1, 'tif', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (6, 1, 'tga', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (7, 2, 'gtar', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (8, 2, 'gz', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (9, 2, 'tar', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (10, 2, 'zip', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (11, 2, 'rar', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (12, 2, 'ace', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (13, 3, 'txt', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (14, 3, 'c', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (15, 3, 'h', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (16, 3, 'cpp', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (17, 3, 'hpp', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (18, 3, 'diz', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (19, 4, 'xls', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (20, 4, 'doc', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (21, 4, 'dot', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (22, 4, 'pdf', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (23, 4, 'ai', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (24, 4, 'ps', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (25, 4, 'ppt', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (26, 5, 'rm', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (27, 6, 'wma', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (31, 6, 'avi', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (32, 6, 'mpg', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (33, 6, 'mpeg', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (34, 6, 'mp3', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (35, 6, 'wav', '');

# -- 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');

# -- 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_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, password, forum_sort, forum_color, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, main_type, forum_moderate, no_count) VALUES (1, 1, 'Testowe forum', 'Testowe forum.', 0, 20, 1, 1, 5, NULL, 0, 0, 0, 1, 0, 1, 1, 3, 3, 3, 1, 1, 1, 1, '', 'SORT_FPDATE', '', '', 0, 0, 0, 'c', 0, 0);
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_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, password, forum_sort, forum_color, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, main_type, forum_moderate, no_count) VALUES (2, 1, 'Test SubFor', 'W tym forum, znajduj� si� dwa testowe fora, mo�na w nim r�wnie� pisa� tematy', 0, 30, 1, 1, 3, NULL, 0, 0, 0, 1, 0, 1, 1, 3, 3, 3, 1, 1, 1, 1, '', 'SORT_FPDATE', '', '', 0, 0, 0, 'c', 0, 0);
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_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, password, forum_sort, forum_color, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, main_type, forum_moderate, no_count) VALUES (3, 3, 'Testowe podforum 1', 'Testowe podforum 1', 0, 50, 0, 0, 0, NULL, 0, 0, 0, 1, 0, 1, 1, 3, 3, 3, 1, 1, 1, 1, '', 'SORT_FPDATE', '', '', 0, 0, 0, 'c', 0, 0);
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_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, password, forum_sort, forum_color, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, main_type, forum_moderate, no_count) VALUES (4, 3, 'Testowe podforum 2', 'Testowe podforum 2', 0, 60, 0, 0, 0, NULL, 0, 0, 0, 1, 0, 1, 1, 3, 3, 3, 1, 1, 1, 1, '', 'SORT_FPDATE', '', '', 0, 0, 0, 'c', 0, 0);
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_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, password, forum_sort, forum_color, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, main_type, forum_moderate, no_count) VALUES (6, 4, 'Portal', 'To jest forum do umieszczania news�w w Portalu. W tym forum tylko moderatorzy mog� zak�adac nowe tematy', 0, 90, 3, 3, 10, NULL, 0, 0, 0, 1, 0, 1, 1, 3, 3, 3, 1, 1, 1, 1, '', 'SORT_FPDATE', 'FF0000', '', 0, 0, 0, 'c', 0, 0);
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_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, password, forum_sort, forum_color, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, main_type, forum_moderate, no_count) VALUES (7, 4, 'Sondy', 'To jest forum do umieszczania sond kt�re b�d� w portalu, tutaj tylko moderatorzy mog� umieszcza� sondy i pisa� posty.', 0, 100, 1, 1, 7, NULL, 0, 0, 0, 1, 0, 1, 1, 3, 3, 3, 1, 1, 1, 1, '', 'SORT_FPDATE', '32CD32', '', 0, 0, 0, 'c', 0, 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);

# -- pa_*
INSERT INTO phpbb_pa_cat VALUES (1, 'Test Category', 'Test category', 0, 0, 0, 1);
INSERT INTO phpbb_pa_settings (settings_id, settings_dbname, settings_sitename, settings_dburl, settings_topnumber, settings_homeurl, settings_newdays, settings_stats, settings_viewall, settings_showss, settings_disable, allow_html, allow_bbcode, allow_smilies, allow_comment_links, no_comment_link_message, allow_comment_images, no_comment_image_message, max_comment_chars, directly_linked) VALUES ('1', 'Download Index', 'My Site', 'http://yoursite_URL/phpBB2', '10', 'http://yoursite_URL', '5', '0', '1', '1', '0', '0', '1', '1', '0', 'No links please', '0', 'No images please', '1000', '0');

# -- portal_config
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('portal_on', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('link_logo', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('own_header', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('portal_header_body', '<table class="topbkg" width="100%" cellspacing="0" cellpadding="0" border="0"><tr><td align="center"><a href="index.php"><img src="images/portal_logo.jpg" border="0" alt="Forum" /></a></td><td align="center"><span class="gensmall">To jest w�asny nag��wek. Mo�esz go ca�kowicie zmieni� w panelu admina, prawdopodobnie kolorystyka jest nieodpowiednia, mo�esz j� dobra� w zale�no�ci jakiego stylu u�ywasz. Jezeli w kodzie HTML nag��wka wpiszesz tylko: <b>get_from_template</b> nag��wek portalu b�dzie pobierany z pliku <b>portal_header.tpl</b> w katalogu aktualnego stylu, dzia�aj� w nim {ZMIENNE} styl�w dok�adnie tak samo jak w nag��wku forum.</span></td><td align="right"><img src="images/phpbb2_logor.jpg" alt="" /></td></tr></table><table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="topnav"><a href="index.php" class="mainmenu">Forum</a>  •  <a href="chatbox_mod/chatbox.php" class="mainmenu">Chat</a>  •  <a href="faq.php" class="mainmenu">Pomoc</a>  •  <a href="search.php" class="mainmenu">Szukaj</a>  •  <a href="memberlist.php" class="mainmenu">U�ytkownicy</a>  •  <a href="groupcp.php" class="mainmenu">Grupy</a>  •  <a href="statistics.php" class="mainmenu">Statystyki</a>  •  <a href="album.php" class="mainmenu">Album</a>  •  <a href="dload.php" class="mainmenu">Download</a></td></tr></table><br />');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('portal_footer_body', '<table class="topbkg" width="100%" cellspacing="0" cellpadding="0" border="0"><tr><td align="center"><span class="gensmall">W tym miejscu mo�esz ustawi� w�asn� stopk� portalu</span></td></tr></table>');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('news_forum', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('body_news_forum', '<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline"><tr><td class="catHead" height="25"><span class="genmed"><b>Tytu� news�w lub strony</b></span></td>\r\n</tr><tr><td class="row1" align="left"><span class="gensmall" style="line-height:150%">Dowolna tresc opisuj�ca portal, strone, forum ...<br /> </span></td></tr></table><br />');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('number_of_news', '20');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('news_length', '2000');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('witch_news_forum', '6');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('witch_poll_forum', '7');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('except_forum', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('poll', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('download_pos', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('portal_menu_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links_a2', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('search_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('stat_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('recent_topics_a', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('top_posters_a', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links1', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links2', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links3', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links4', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links5', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links6', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links7', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links8', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module1', 'portal_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module2', 'register_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module3', 'info_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module4', 'search_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module5', 'stats_user_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module6', 'whoonline_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module7', 'poll_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module8', 'links_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module9', 'clock_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module10', 'custom_module1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module11', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module12', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module13', 'birthday_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module14', 'recent_topics_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module15', 'login_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module16', 'album_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module17', 'download');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module18', 'top_posters_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module19', 'chat_menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module20', 'blank_module1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module21', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module22', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module23', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('module24', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('links_body', '<object><center><br /><a href="http://phpbb.com" target="_blank"><img src="images/link_phpbb.gif" alt="" border="0" title="phpBB" /></a><br /><br /><a href="http://www.forumimages.com/" target="_blank"><img src="images/link_forumimages.gif" alt="" border="0" title="ForumImages" /></a><br /><br /><a href="http://phpbb.com/" target="_blank"><img src="images/links_google.gif" alt="" border="0" title="Google" /></a><br /><br /><a href="http://www.apache.org/" target="_blank"><img src="images/link_apache.gif" alt="" border="0" title="Apache Software Foundation" /></a></center></object><br /><br />');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom1_body', 'jaka� tre��, lub tre�� i html');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom1_name', 'W�asne menu');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom1_body_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom1_body_on', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom2_body', 'jaka� tre��, lub tre�� i html');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom2_name', 'W�asne menu 2');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom2_body_a', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom2_body_on', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc1', 'w�asny link');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address1', 'http://www.przemo.org');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc2', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address2', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc3', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address3', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc4', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address4', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc5', 'Statystyki');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address5', 'statistics.php');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc6', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address6', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc7', 'Kto tu rzadzi :)');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address7', 'staff.php');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_desc8', 'wlasny link2');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('custom_address8', 'http://www.phpbb.com');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank1_body_on', '1');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank1_body', '<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline"><tr><td class="catHead" height="25" align="right"><span class="genmed"><b>Wlasny modul</b></span></td></tr><tr><td class="row1" align="right"><span class="genmed" style="line-height: 150%"><iframe src="http://phpbb.com" width="100%" height="300"></iframe></span></td></tr></table><br />');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank2_body_on', '0');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank2_body', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank3_body_on', '0');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank3_body', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank4_body_on', '0');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('blank4_body', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('birthday_a', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('info_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('login_a', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('whoonline_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('chat_a', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('register_a', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('album_recent_pics', '2');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('album_a', 'left');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('recent_pics', '2');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('album_pos', 'right');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('own_body', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('value_recent_topics', '10');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('value_top_posters', '10');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('ri_time', '');
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('ri_data', '');

# -- posts
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, user_agent, post_icon, post_expire, post_marked, post_approve) VALUES (7, 5, 7, 2, 1065137203, '7f000001', '', 1, 0, 1, 0, NULL, 0, 0, '', 0, 0, 'n', 1);
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, user_agent, post_icon, post_expire, post_marked, post_approve) VALUES (3, 2, 2, 2, 1064458873, '7f000001', '', 1, 0, 1, 0, NULL, 0, 0, '', 0, 0, 'n', 1);
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, user_agent, post_icon, post_expire, post_marked, post_approve) VALUES (5, 4, 1, 2, 1065136668, '7f000001', '', 1, 0, 0, 0, NULL, 0, 0, '', 2, 0, 'n', 1);
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, user_agent, post_icon, post_expire, post_marked, post_approve) VALUES (8, 6, 6, 2, 1065137320, '7f000001', '', 1, 0, 1, 0, NULL, 0, 0, '', 0, 0, 'n', 1);
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, user_agent, post_icon, post_expire, post_marked, post_approve) VALUES (9, 7, 6, 2, 1065137383, '7f000001', '', 1, 0, 1, 0, NULL, 0, 0, '', 0, 0, 'n', 1);
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, user_agent, post_icon, post_expire, post_marked, post_approve) VALUES (10, 8, 6, 2, 1065137404, '7f000001', '', 1, 0, 1, 0, NULL, 0, 0, '', 0, 0, 'n', 1);

# -- posts_text
INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES (9, 'e7c9e3e71f', 'test drugiego newsa', '[URL=http://www.przemo.org]test[/URL] [b:e7c9e3e71f]test[/b:e7c9e3e71f] [size=18:e7c9e3e71f][shadow=red:e7c9e3e71f]test[/shadow:e7c9e3e71f][/size:e7c9e3e71f]\r\n\r\nt\r\n\r\ne\r\n\r\ns\r\n\r\nt\r\n\r\n\r\n\r\nn\r\n\r\ne\r\n\r\nw\r\n\r\ns\r\n\r\na');
INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES (10, '331bdf8fba', 'Skr�cona instrukcja obs�ugi portalu', '[size=18:331bdf8fba][b:331bdf8fba]PORTAL[/b:331bdf8fba][/size:331bdf8fba] \r\nPortal jest zintegrowany z forum. Mog� by� w nim umieszczane newsy. Newsy s� pobierane z wybranego forum (jednego lub kilku) Najlepiej nada� temu forum prawa tylko do czytania dla u�ytkownik�w, a prawa do pisania nowych temat�w tylko dla moderator�w tego forum (newsman�w) Je�li chcemy �eby u�ytkownicy mogli komentowa� newsy to musimy nada� prawa do odpowiedzi. \r\nSondy w portalu r�wnie� s� pobierane z wyznaczonego forum. \r\nJe�eli jeste� w widoku temat�w, lub widoku tematu, lub piszesz post w jednym z forum kt�re jest przypisane do Portalu to link do strony g��wnej wskazuje na portal. \r\nW portalu dowolnie mo�esz kszta�towa� modu�y, nag��wek, stopk�.\r\n\r\nJe�eli do adresu portalu dodamy parametr np [b:331bdf8fba]?s=1[/b:331bdf8fba] (portal.php?s=1) portal wy�wietli pierwsze posty z temat�w istniej�cych w forum o ID [b:331bdf8fba]1[/b:331bdf8fba]\r\n\r\nMo�na utworzy� w�asne pliki HTML w katalogu forum, kt�re b�d� odczytywane przez portal, jeden testowy plik to [b:331bdf8fba]portal_page1.html[/b:331bdf8fba]\r\nGdy do adresu portalu dodamy parametr ?show=1 (portal.php?show=1) portal wy�wietli zawarto�� pliku. Kolejne pliki powinny mie� nazw� portal_page[b:331bdf8fba]NUMER[/b:331bdf8fba].html np. portal_page2.html, portal_page3.html itd. (?show=2, ?show=3)\r\nS�u�y to do tworzenia link�w i umieszczania ich w menu portalu.\r\n\r\nJe�eli chcesz aby twoja domena wskazywala najpierw na portal to w katalogu forum utw�rz plik: index.html kt�ry wygl�da tak: \r\nKod: \r\n[code:1:331bdf8fba]<html> \r\n<head> \r\n  <meta http-equiv="Refresh" content="0; url=portal.php"> \r\n</head> \r\n</html> [/code:1:331bdf8fba]\r\nDzia�a to tylko na serwerach, kt�re w pierwszej kolejno�ci odczytuj� pliki *.html');
INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES (3, 'b63934e592', 'Testowy temat w SubForum', 'Testowy temat w SubForum');
INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES (7, '2fe4a4ef6b', 'Sonda1', 'sonda1');
INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES (8, 'c93fefdf03', 'Test trzeciego newsa', '[URL=http://www.przemo.org]test[/URL] [b:c93fefdf03]test[/b:c93fefdf03] [size=18:c93fefdf03][shadow=red:c93fefdf03]test[/shadow:c93fefdf03][/size:c93fefdf03]\r\n\r\nt\r\n\r\ne\r\n\r\ns\r\n\r\nt\r\n\r\n.\r\n.\r\n.\r\n.\r\n.\r\n.\r\n.\r\n\r\nn\r\n\r\ne');
INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES (5, 'bcf3b5262c', 'Witaj na forum phpBB modified by Przemo', 'Dzi�kuj�, za wybranie [URL=http://www.przemo.org/phpBB2/]phpBB modified by Przemo[/URL] do obs�ugi Twojego Forum.\r\n\r\nZapoznaj si� dok�adnie z instrukcjami zamieszczonymi w pliku [b:bcf3b5262c]/docs/readme.html[/b:bcf3b5262c] w katalogu forum.');

# -- 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);

# -- topics
INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, topic_icon, topic_expire, topic_color, topic_title_e, topic_action, topic_action_user, topic_action_date, topic_tree_width) VALUES (5, 7, 'Sonda1', 2, 1065137203, 0, 0, 0, 1, 0, 7, 7, 0, 0, 0, 0, '', '', 0, 0, 0, 0);
INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, topic_icon, topic_expire, topic_color, topic_title_e, topic_action, topic_action_user, topic_action_date, topic_tree_width) VALUES (2, 2, 'Testowy temat w SubForum', 2, 1064458873, 0, 0, 0, 0, 0, 3, 3, 0, 0, 0, 0, '', '', 0, 0, 0, 0);
INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, topic_icon, topic_expire, topic_color, topic_title_e, topic_action, topic_action_user, topic_action_date, topic_tree_width) VALUES (4, 1, 'Witaj na forum phpBB modified by Przemo', 2, 1065136668, 0, 0, 0, 0, 0, 5, 5, 0, 0, 2, 0, 'green', '', 0, 0, 0, 0);
INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, topic_icon, topic_expire, topic_color, topic_title_e, topic_action, topic_action_user, topic_action_date, topic_tree_width) VALUES (6, 6, 'Test trzeciego newsa', 2, 1065137320, 0, 0, 0, 0, 0, 8, 8, 0, 0, 0, 0, '', '', 0, 0, 0, 0);
INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, topic_icon, topic_expire, topic_color, topic_title_e, topic_action, topic_action_user, topic_action_date, topic_tree_width) VALUES (7, 6, 'test drugiego newsa', 2, 1065137383, 0, 0, 0, 0, 0, 9, 9, 0, 0, 0, 0, '', '', 0, 0, 0, 0);
INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, topic_icon, topic_expire, topic_color, topic_title_e, topic_action, topic_action_user, topic_action_date, topic_tree_width) VALUES (8, 6, 'Skr�cona instrukcja obs�ugi portalu', 2, 1065137404, 0, 0, 0, 0, 0, 10, 10, 0, 0, 0, 0, 'green', '', 0, 0, 0, 0);

# -- 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_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 1, 1, 1, 1, 0, 1, 1, 0, '', 'polish', 1.00, '', '', 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_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, '', '', 1.00, '', '', 0, 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);

# -- vote
INSERT INTO phpbb_vote_desc (vote_id, topic_id, vote_text, vote_start, vote_length) VALUES (1, 5, 'Czy podoba Ci si� Portal i Forum?', 1065137203, 0);
INSERT INTO phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) VALUES (1, 1, 'Tak', 0);
INSERT INTO phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) VALUES (1, 2, 'Nie', 0);

# -- ranks
INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Administrator', -1, 1, NULL);

# -- stats_config
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('install_date', 'time()');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('return_limit', '10');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('version', '2.1.3');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('modules_dir', 'stat_modules');
INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('page_views', '0');

# -- stats_modules

INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (1, 'new_posts_by_month', 1, 1, 10, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (2, 'new_topics_by_month', 1, 1, 20, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (3, 'new_users_by_month', 1, 1, 30, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (4, 'most_active_topics', 1, 1, 40, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (5, 'most_viewed_topics', 1, 1, 50, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (6, 'latest_topics', 1, 1, 60, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (7, 'priv_msgs', 1, 1, 70, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (8, 'top_posters', 1, 1, 80, 24, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (9, 'last_active_users', 1, 1, 90, 0, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (10, 'users_from_where', 1, 1, 100, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (11, 'age_statistics', 1, 1, 110, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (12, 'users_gender', 1, 1, 120, 48, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (13, 'top_smilies', 1, 1, 130, 64, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (14, 'top_words', 1, 1, 140, 64, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');
INSERT INTO phpbb_stats_modules (module_id, name, active, installed, display_order, update_time, auth_value, module_info_cache, module_db_cache, module_result_cache, module_info_time, module_cache_time) VALUES (15, 'user_agent', 1, 1, 150, 64, 0, '[BLOB]', '[BLOB]', '[BLOB]', '0', '0');


# -- shoutbox_config
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest_view', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest', '0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_users_view', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_users', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete_all', '0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete', '0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete_m', '0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit_all', '0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit', '0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit_m', '0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_bbcode', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_smilies', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('links_names', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('make_links', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('count_msg', '100');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('delete_days', '30');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('text_lenght', '500');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('word_lenght', '80');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_format', 'D G:i');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_on', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shoutbox_on', '1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_width', '630');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_height', '130');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id', '');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view', '');

# -- smilies
INSERT INTO phpbb_smilies VALUES (1, ':-)', 'icon_smile.gif', '', 1);
INSERT INTO phpbb_smilies VALUES (2, ';-)', 'icon_wink.gif', '', 2);
INSERT INTO phpbb_smilies VALUES (3, ':->', 'icon_smile2.gif', '', 3);
INSERT INTO phpbb_smilies VALUES (4, ':-D', 'icon_biggrin.gif', '', 4);
INSERT INTO phpbb_smilies VALUES (5, ':-P', 'icon_razz.gif', '', 5);
INSERT INTO phpbb_smilies VALUES (6, ':-o', 'icon_surprised.gif', '', 6);
INSERT INTO phpbb_smilies VALUES (7, ':mrgreen:', 'icon_mrgreen.gif', '', 7);
INSERT INTO phpbb_smilies VALUES (8, ':lol:', 'icon_lol.gif', '', 8);
INSERT INTO phpbb_smilies VALUES (9, ':-(', 'icon_sad.gif', '', 9);
INSERT INTO phpbb_smilies VALUES (10, ':-|', 'icon_neutral.gif', '', 10);
INSERT INTO phpbb_smilies VALUES (11, ':-/', 'icon_curve.gif', '', 11);
INSERT INTO phpbb_smilies VALUES (12, ':-?', 'icon_confused.gif', '', 12);
INSERT INTO phpbb_smilies VALUES (13, ':-x', 'icon_mad.gif', '', 13);
INSERT INTO phpbb_smilies VALUES (14, ':shock:', 'icon_eek.gif', '', 14);
INSERT INTO phpbb_smilies VALUES (15, ':cry:', 'icon_cry.gif', '', 15);
INSERT INTO phpbb_smilies VALUES (16, ':oops:', 'icon_redface.gif', '', 16);
INSERT INTO phpbb_smilies VALUES (17, '8-)', 'icon_cool.gif', '', 17);
INSERT INTO phpbb_smilies VALUES (18, ':evil:', 'icon_evil.gif', '', 18);
INSERT INTO phpbb_smilies VALUES (19, ':roll:', 'icon_rolleyes.gif', '', 19);
INSERT INTO phpbb_smilies VALUES (20, ':!:', 'icon_exclaim.gif', '', 20);
INSERT INTO phpbb_smilies VALUES (21, ':?:', 'icon_question.gif', '', 21);
INSERT INTO phpbb_smilies VALUES (22, ':idea:', 'icon_idea.gif', '', 22);
INSERT INTO phpbb_smilies VALUES (23, ':arrow:', 'icon_arrow.gif', '', 23);

# -- 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, fontcolor_admin, fontcolor_jradmin, fontcolor_mod, tr_color_helped, factive_color, faonmouse_color, faonmouse2_color) 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', '', '', '', 'FFA34F', '993333', '006600', 'F0EDDE', 'F9F9F0', 'DEE3E7', 'EFEFEF');

# -- themes_name
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', '', '', '');
mysql_basic.sql
网页地址
文件地址
Would you like to comment?
