[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/install/schemas/ -> mssql_basic.sql (source)

   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  
   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','youraddress@yourdomain.com');
  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.23');
  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', '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;


Generated: Mon Jan 14 19:21:40 2013 Cross-referenced by PHPXref 0.7.1