1/*
2
3  Basic DB data for phpBB2 devel (MSSQL)
4
5 $Id: mssql_basic.sql 8367 2008-02-02 15:05:23Z acydburn $
6
7*/
8
9BEGIN TRANSACTION;
10
11/*
12  -- Config
13*/
14INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
15INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
16INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
17INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
18INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
19INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
20INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
21INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
22INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600');
23INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
24INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
25INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
26INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
27INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
28INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
29INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
30INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
31INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
32INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
33INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
34INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
35INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
36INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
37INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
38INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
39INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
40INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
41INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
42INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
43INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
44INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');
45INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
46INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
47INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
48INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
49INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
50INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
51INSERT INTO phpbb_config (config_name, config_value) VALUES ('sendmail_fix','0');
52INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
53INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
54INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_flood_interval','15');
55INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_min_chars','3');
56INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
57INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
58INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
59INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
60INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
61INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
62INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
63INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
64INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
65INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
66INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
67INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
68INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
69INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
70INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
71INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
72INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
73INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0');
74INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
75INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld');
76INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
77INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
78INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.23');
79INSERT INTO phpbb_config (config_name, config_value) VALUES ('rand_seed', '0');
80
81/*
82  -- Categories
83*/
84SET IDENTITY_INSERT phpbb_categories ON;
85
86INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
87
88SET IDENTITY_INSERT phpbb_categories OFF;
89
90
91/*
92  -- Forums
93*/
94INSERT 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, 1, 1, 3, 3, 1, 1, 3);
95
96/*
97  -- Users
98  Default Admin --> username: admin
99                    password: admin (change this or remove it once everything is working!)
100*/
101INSERT 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);
102INSERT 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);
103
104
105/*
106  -- Ranks
107*/
108SET IDENTITY_INSERT phpbb_ranks ON;
109
110INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Site Admin', -1, 1, '');
111
112SET IDENTITY_INSERT phpbb_ranks OFF;
113
114
115/*
116  -- Groups
117*/
118SET IDENTITY_INSERT phpbb_groups ON;
119
120INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (1, 1, 'Anonymous', 'Personal User', '', 1);
121INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (2, 1, 'Admin', 'Personal User', '', 1);
122
123SET IDENTITY_INSERT phpbb_groups OFF;
124
125/*
126  -- User -> Group
127*/
128INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, '');
129INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, '');
130
131
132/*
133  -- Demo Topic
134*/
135SET IDENTITY_INSERT phpbb_topics ON;
136
137INSERT 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, '');
138
139SET IDENTITY_INSERT phpbb_topics OFF;
140
141
142/*
143  -- Demo Post
144*/
145SET IDENTITY_INSERT phpbb_posts ON;
146
147INSERT 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');
148INSERT 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!');
149
150SET IDENTITY_INSERT phpbb_posts OFF;
151
152
153/*
154  -- Themes
155*/
156SET IDENTITY_INSERT phpbb_themes ON;
157
158INSERT 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', '', '', '');
159
160SET IDENTITY_INSERT phpbb_themes OFF;
161
162INSERT 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', '', '', '');
163
164
165/*
166  -- Smilies
167*/
168SET IDENTITY_INSERT phpbb_smilies ON;
169
170INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy');
171INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy');
172INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
173INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile');
174INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile');
175INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile');
176INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad');
177INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad');
178INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad');
179INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised');
180INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised');
181INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised');
182INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, ':shock:', 'icon_eek.gif', 'Shocked');
183INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, ':?', 'icon_confused.gif', 'Confused');
184INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':-?', 'icon_confused.gif', 'Confused');
185INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':???:', 'icon_confused.gif', 'Confused');
186INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, '8)', 'icon_cool.gif', 'Cool');
187INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, '8-)', 'icon_cool.gif', 'Cool');
188INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, ':cool:', 'icon_cool.gif', 'Cool');
189INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, ':lol:', 'icon_lol.gif', 'Laughing');
190INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':x', 'icon_mad.gif', 'Mad');
191INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':-x', 'icon_mad.gif', 'Mad');
192INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':mad:', 'icon_mad.gif', 'Mad');
193INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':P', 'icon_razz.gif', 'Razz');
194INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':-P', 'icon_razz.gif', 'Razz');
195INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':razz:', 'icon_razz.gif', 'Razz');
196INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':oops:', 'icon_redface.gif', 'Embarassed');
197INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
198INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
199INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
200INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
201INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':wink:', 'icon_wink.gif', 'Wink');
202INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ';)', 'icon_wink.gif', 'Wink');
203INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ';-)', 'icon_wink.gif', 'Wink');
204INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ':!:', 'icon_exclaim.gif', 'Exclamation');
205INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ':?:', 'icon_question.gif', 'Question');
206INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':idea:', 'icon_idea.gif', 'Idea');
207INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':arrow:', 'icon_arrow.gif', 'Arrow');
208INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':|', 'icon_neutral.gif', 'Neutral');
209INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':-|', 'icon_neutral.gif', 'Neutral');
210INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':neutral:', 'icon_neutral.gif', 'Neutral');
211INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
212
213SET IDENTITY_INSERT phpbb_smilies OFF;
214
215
216/*
217  -- Search Words
218*/
219SET IDENTITY_INSERT phpbb_search_wordlist ON;
220
221INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 );
222INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 );
223INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 );
224INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 );
225INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 );
226INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 );
227INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 );
228INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 );
229INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 );
230INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 );
231INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 );
232INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 );
233
234SET IDENTITY_INSERT phpbb_search_wordlist OFF;
235
236
237/*
238  -- Search Word Matches
239*/
240INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 );
241INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 );
242INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 );
243INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 );
244INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 );
245INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 );
246INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 );
247INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 );
248INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 );
249INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 );
250INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 );
251INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 );
252INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 );
253
254COMMIT;