Verzeichnisstruktur phpBB-2.0.0
- Veröffentlicht
- 03.04.2002
So funktioniert es
|
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
mssql_basic.sql
001 /*
002
003 Basic DB data for phpBB2 devel (MSSQL)
004
005 $Id$
006
007 */
008
009 BEGIN TRANSACTION;
010
011 /*
012 -- Config
013 */
014 INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
015 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
016 INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
017 INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
018 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
019 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
020 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
021 INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
022 INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600');
023 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
024 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
025 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
026 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
027 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
028 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
029 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
030 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
031 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
032 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
033 INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
034 INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
035 INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
036 INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
037 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
038 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
039 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
040 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
041 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
042 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
043 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
044 INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');
045 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
046 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
047 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
048 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
049 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
050 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
051 INSERT INTO phpbb_config (config_name, config_value) VALUES ('sendmail_fix','0');
052 INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
053 INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
054 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_flood_interval','15');
055 INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_min_chars','3');
056 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
057 INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
058 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
059 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
060 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
061 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
062 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
063 INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
064 INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
065 INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
066 INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
067 INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
068 INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
069 INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
070 INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
071 INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
072 INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
073 INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0');
074 INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
075 INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld');
076 INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
077 INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
078 INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.23');
079 INSERT INTO phpbb_config (config_name, config_value) VALUES ('rand_seed', '0');
080
081 /*
082 -- Categories
083 */
084 SET IDENTITY_INSERT phpbb_categories ON;
085
086 INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
087
088 SET IDENTITY_INSERT phpbb_categories OFF;
089
090
091 /*
092 -- Forums
093 */
094 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, 1, 1, 3, 3, 1, 1, 3);
095
096 /*
097 -- Users
098 Default Admin --> username: admin
099 password: admin (change this or remove it once everything is working!)
100 */
101 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);
102 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);
103
104
105 /*
106 -- Ranks
107 */
108 SET IDENTITY_INSERT phpbb_ranks ON;
109
110 INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Site Admin', -1, 1, '');
111
112 SET IDENTITY_INSERT phpbb_ranks OFF;
113
114
115 /*
116 -- Groups
117 */
118 SET IDENTITY_INSERT phpbb_groups ON;
119
120 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (1, 1, 'Anonymous', 'Personal User', '', 1);
121 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (2, 1, 'Admin', 'Personal User', '', 1);
122
123 SET IDENTITY_INSERT phpbb_groups OFF;
124
125 /*
126 -- User -> Group
127 */
128 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, '');
129 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, '');
130
131
132 /*
133 -- Demo Topic
134 */
135 SET IDENTITY_INSERT phpbb_topics ON;
136
137 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, '');
138
139 SET IDENTITY_INSERT phpbb_topics OFF;
140
141
142 /*
143 -- Demo Post
144 */
145 SET IDENTITY_INSERT phpbb_posts ON;
146
147 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');
148 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!');
149
150 SET IDENTITY_INSERT phpbb_posts OFF;
151
152
153 /*
154 -- Themes
155 */
156 SET IDENTITY_INSERT phpbb_themes ON;
157
158 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', '', '', '');
159
160 SET IDENTITY_INSERT phpbb_themes OFF;
161
162 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', '', '', '');
163
164
165 /*
166 -- Smilies
167 */
168 SET IDENTITY_INSERT phpbb_smilies ON;
169
170 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy');
171 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy');
172 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
173 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile');
174 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile');
175 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile');
176 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad');
177 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad');
178 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad');
179 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised');
180 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised');
181 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised');
182 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, ':shock:', 'icon_eek.gif', 'Shocked');
183 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, ':?', 'icon_confused.gif', 'Confused');
184 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':-?', 'icon_confused.gif', 'Confused');
185 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':???:', 'icon_confused.gif', 'Confused');
186 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, '8)', 'icon_cool.gif', 'Cool');
187 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, '8-)', 'icon_cool.gif', 'Cool');
188 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, ':cool:', 'icon_cool.gif', 'Cool');
189 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, ':lol:', 'icon_lol.gif', 'Laughing');
190 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':x', 'icon_mad.gif', 'Mad');
191 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':-x', 'icon_mad.gif', 'Mad');
192 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':mad:', 'icon_mad.gif', 'Mad');
193 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':P', 'icon_razz.gif', 'Razz');
194 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':-P', 'icon_razz.gif', 'Razz');
195 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':razz:', 'icon_razz.gif', 'Razz');
196 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':oops:', 'icon_redface.gif', 'Embarassed');
197 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
198 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
199 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
200 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
201 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':wink:', 'icon_wink.gif', 'Wink');
202 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ';)', 'icon_wink.gif', 'Wink');
203 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ';-)', 'icon_wink.gif', 'Wink');
204 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ':!:', 'icon_exclaim.gif', 'Exclamation');
205 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ':?:', 'icon_question.gif', 'Question');
206 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':idea:', 'icon_idea.gif', 'Idea');
207 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':arrow:', 'icon_arrow.gif', 'Arrow');
208 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':|', 'icon_neutral.gif', 'Neutral');
209 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':-|', 'icon_neutral.gif', 'Neutral');
210 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':neutral:', 'icon_neutral.gif', 'Neutral');
211 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
212
213 SET IDENTITY_INSERT phpbb_smilies OFF;
214
215
216 /*
217 -- Search Words
218 */
219 SET IDENTITY_INSERT phpbb_search_wordlist ON;
220
221 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 );
222 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 );
223 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 );
224 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 );
225 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 );
226 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 );
227 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 );
228 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 );
229 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 );
230 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 );
231 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 );
232 INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 );
233
234 SET IDENTITY_INSERT phpbb_search_wordlist OFF;
235
236
237 /*
238 -- Search Word Matches
239 */
240 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 );
241 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 );
242 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 );
243 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 );
244 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 );
245 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 );
246 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 );
247 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 );
248 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 );
249 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 );
250 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 );
251 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 );
252 INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 );
253
254 COMMIT;