API tools faq
paste
Gh05t666include

Leak & RMS ? http://www.lefthand.pl/

Gh05t666include
Apr 30th, 2020
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.22 KB | None | 0 0
raw download clone embed print report
  1. /*http://www.lefthand.pl/
  2.  
  3. (MSSQL)
  4.  
  5. $Id: mssql_basic.sql,v 1.1.2.27 grahamje Exp $
  6.  
  7. */
  8.  
  9. BEGIN TRANSACTION;
  10.  
  11. /*
  12. -- Config
  13. */
  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','[email protected]');
  44. INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');
  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 ('search_flood_interval','15');
  55. INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_min_chars','3');
  56. INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
  57. INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
  58. INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
  59. INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
  60. INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
  61. INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
  62. INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
  63. INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
  64. INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
  65. INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
  66. INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
  67. INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
  68. INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
  69. INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
  70. INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
  71. INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
  72. INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
  73. INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0');
  74. INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
  75. INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.yourdomain.tld');
  76. INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
  77. INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
  78. INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.21');
  79. INSERT INTO phpbb_config (config_name, config_value) VALUES ('rand_seed', '0');
  80.  
  81. /*
  82. -- Categories
  83. */
  84. SET IDENTITY_INSERT phpbb_categories ON;
  85.  
  86. INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
  87.  
  88. SET IDENTITY_INSERT phpbb_categories OFF;
  89.  
  90.  
  91. /*
  92. -- Forums
  93. */
  94. 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);
  95.  
  96. /*
  97. -- Users
  98. Default Admin --> username: admin
  99. 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', '[email protected]', '', '', '', '', '', '', 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;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!