3 Basic DB data for phpBB2 devel (MSSQL)
5 $Id: mssql_basic.sql,v 1.1.2.22 2005/12/29 11:51:12 acydburn Exp $
14 INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
15 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
16 INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
17 INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
18 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
19 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
20 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
21 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
22 INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600');
23 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
24 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
25 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
26 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
27 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
28 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
29 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
30 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
31 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
32 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
33 INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
34 INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
35 INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
36 INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
37 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
38 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
39 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
40 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
41 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
42 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
43 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
44 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0');
45 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
46 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
47 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
48 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
49 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
50 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
51 INSERT INTO phpbb_config (config_name, config_value) VALUES ('sendmail_fix','0');
52 INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
53 INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
54 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
55 INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
56 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
57 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
58 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
59 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
60 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
61 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
62 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
63 INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
64 INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
65 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
66 INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
67 INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
68 INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
69 INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
70 INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
71 INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0');
72 INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
73 INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld');
74 INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
75 INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
76 INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.19');
81 SET IDENTITY_INSERT phpbb_categories ON;
83 INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
85 SET IDENTITY_INSERT phpbb_categories OFF;
91 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 1, 'Test Forum 1', 'This is just a test forum, nothing special here.', '', 1, 1, 1, 1, '', 1, '', '', '', '', 1, 1, 3, 3, 1, 1, 3);
95 Default Admin --> username: admin
96 password: admin (change this or remove it once everything is working!)
98 INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 1, 1, 0, 1, 1, NULL, '', '', 0, '', '', '', 0, 0);
99 INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);
105 SET IDENTITY_INSERT phpbb_ranks ON;
107 INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Site Admin', -1, 1, '');
109 SET IDENTITY_INSERT phpbb_ranks OFF;
115 SET IDENTITY_INSERT phpbb_groups ON;
117 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (1, 1, 'Anonymous', 'Personal User', '', 1);
118 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (2, 1, 'Admin', 'Personal User', '', 1);
120 SET IDENTITY_INSERT phpbb_groups OFF;
125 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, '');
126 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, '');
132 SET IDENTITY_INSERT phpbb_topics ON;
134 INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_first_post_id, topic_last_post_id, topic_moved_id) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 1, 0, 0, 0, 1, 1, '');
136 SET IDENTITY_INSERT phpbb_topics OFF;
142 SET IDENTITY_INSERT phpbb_posts ON;
144 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');
145 INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
147 SET IDENTITY_INSERT phpbb_posts OFF;
153 SET IDENTITY_INSERT phpbb_themes ON;
155 INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '');
157 SET IDENTITY_INSERT phpbb_themes OFF;
159 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', '', '', '');
165 SET IDENTITY_INSERT phpbb_smilies ON;
167 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy');
168 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy');
169 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
170 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile');
171 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile');
172 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile');
173 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad');
174 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad');
175 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad');
176 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised');
177 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised');
178 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised');
179 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, ':shock:', 'icon_eek.gif', 'Shocked');
180 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, ':?', 'icon_confused.gif', 'Confused');
181 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':-?', 'icon_confused.gif', 'Confused');
182 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':???:', 'icon_confused.gif', 'Confused');
183 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, '8)', 'icon_cool.gif', 'Cool');
184 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, '8-)', 'icon_cool.gif', 'Cool');
185 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, ':cool:', 'icon_cool.gif', 'Cool');
186 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, ':lol:', 'icon_lol.gif', 'Laughing');
187 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':x', 'icon_mad.gif', 'Mad');
188 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':-x', 'icon_mad.gif', 'Mad');
189 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':mad:', 'icon_mad.gif', 'Mad');
190 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':P', 'icon_razz.gif', 'Razz');
191 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':-P', 'icon_razz.gif', 'Razz');
192 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':razz:', 'icon_razz.gif', 'Razz');
193 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':oops:', 'icon_redface.gif', 'Embarassed');
194 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
195 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
196 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
197 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
198 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':wink:', 'icon_wink.gif', 'Wink');
199 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ';)', 'icon_wink.gif', 'Wink');
200 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ';-)', 'icon_wink.gif', 'Wink');
201 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ':!:', 'icon_exclaim.gif', 'Exclamation');
202 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ':?:', 'icon_question.gif', 'Question');
203 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':idea:', 'icon_idea.gif', 'Idea');
204 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':arrow:', 'icon_arrow.gif', 'Arrow');
205 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':|', 'icon_neutral.gif', 'Neutral');
206 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':-|', 'icon_neutral.gif', 'Neutral');
207 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':neutral:', 'icon_neutral.gif', 'Neutral');
208 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
210 SET IDENTITY_INSERT phpbb_smilies OFF;
216 SET IDENTITY_INSERT phpbb_search_wordlist ON;
218 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 );
219 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 );
220 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 );
221 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 );
222 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 );
223 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 );
224 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 );
225 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 );
226 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 );
227 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 );
228 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 );
229 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 );
231 SET IDENTITY_INSERT phpbb_search_wordlist OFF;
235 -- Search Word Matches
237 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 );
238 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 );
239 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 );
240 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 );
241 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 );
242 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 );
243 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 );
244 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 );
245 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 );
246 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 );
247 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 );
248 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 );
249 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 );