IntegraMOD

CREATE TABLE phpbb_kb_articles (   article_id mediumint(8) unsigned NOT NULL auto_increment,   article_category_id mediumint(8) unsigned NOT NULL default '0',   article_title varchar(255) binary NOT NULL default '',   article_de.scription varchar(255) binary NOT NULL default '',   article_date varchar(255) binary NOT NULL default '',   article_author_id mediumint(8) unsigned NOT NULL default '0',   username varchar(255) default NULL,   bbcode_uid varchar(10) binary NOT NULL default '',   article_body text NOT NULL,   article_type mediumint(8) unsigned NOT NULL default '0',   approved tinyint(1) unsigned NOT NULL default '0',   topic_id mediumint(8) unsigned NOT NULL default '0',   views bigint(8) NOT NULL default '0',   article_rating double(6,4) NOT NULL default '0.0000',   article_totalvotes int(255) NOT NULL default '0',   KEY article_id (article_id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_categories (   category_id mediumint(8) unsigned NOT NULL auto_increment,   category_name varchar(255) binary NOT NULL default '',   category_details varchar(255) binary NOT NULL default '',   number_articles mediumint(8) unsigned NOT NULL default '0',   parent mediumint(8) unsigned default NULL,   cat_order mediumint(8) unsigned NOT NULL default '0',   auth_view tinyint(3) NOT NULL DEFAULT "0",   auth_post tinyint(3) NOT NULL DEFAULT "0",   auth_rate tinyint(3) NOT NULL DEFAULT "0",   auth_comment tinyint(3) NOT NULL DEFAULT "0",   auth_edit tinyint(3) NOT NULL DEFAULT "0",   auth_delete tinyint(3) NOT NULL DEFAULT "2",   auth_approval tinyint(3) NOT NULL DEFAULT "0",   auth_approval_edit tinyint(3) NOT NULL DEFAULT "0",   auth_view_groups varchar(255),   auth_post_groups varchar(255),   auth_rate_groups varchar(255),   auth_comment_groups varchar(255),   auth_edit_groups varchar(255),   auth_delete_groups varchar(255),   auth_approval_groups varchar(255),   auth_approval_edit_groups varchar(255),   auth_moderator_groups varchar(255),   comments_forum_id tinyint(3) NOT NULL DEFAULT "-1",   KEY category_id (category_id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_config (   config_name varchar(255) NOT NULL default '',   config_value varchar(255) default NULL,   PRIMARY KEY  (config_name)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_results (   search_id int(11) unsigned NOT NULL default '0',   session_id varchar(32) NOT NULL default '',   search_array text NOT NULL,   PRIMARY KEY  (search_id),   KEY session_id (session_id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_types (   id mediumint(8) unsigned NOT NULL auto_increment,   type varchar(255) binary NOT NULL default '',   KEY id (id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_votes (   votes_ip varchar(50) NOT NULL default '0',   votes_userid int(50) NOT NULL default '0',   votes_file int(50) NOT NULL default '0') TYPE=MyISAM;  CREATE TABLE phpbb_kb_wordlist (   word_text varchar(50) binary NOT NULL default '',   word_id mediumint(8) unsigned NOT NULL auto_increment,   word_common tinyint(1) unsigned NOT NULL default '0',   PRIMARY KEY  (word_text),   KEY word_id (word_id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_wordmatch (   article_id mediumint(8) unsigned NOT NULL default '0',   word_id mediumint(8) unsigned NOT NULL default '0',   title_match tinyint(1) NOT NULL default '0',   KEY post_id (article_id),   KEY word_id (word_id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_custom (   custom_id int(50) NOT NULL auto_increment,   custom_name text NOT NULL,   custom_de.scription text NOT NULL,   data text NOT NULL,   field_order int(20) NOT NULL default '0',   field_type tinyint(2) NOT NULL default '0',   regex varchar(255) NOT NULL default '',   PRIMARY KEY  (custom_id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_customdata (   customdata_file int(50) NOT NULL default '0',   customdata_custom int(50) NOT NULL default '0',   data text NOT NULL) TYPE=MyISAM;        INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_new", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("notify", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("admin_id", "2");INSERT INTO phpbb_kb_config (config_name, config_value) values("show_pretext",0);INSERT INTO phpbb_kb_config (config_name, config_value) values("pt_header","Article Submission Instructions");INSERT INTO phpbb_kb_config (config_name, config_value) values("pt_body","Please check your references and include as much information as you can.");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("use_comments", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("del_topic", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("use_ratings", "0");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("comments_show", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("bump_post", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("stats_list", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("header_banner", "1");  INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("votes_check_userid", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("votes_check_ip", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("art_pagination", "5");  INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("comments_pagination", "5");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("news_sort", "Alphabetic");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("news_sort_par", "ASC");  INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("wysiwyg", "0");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("wysiwyg_path", "modules/");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_html", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_bbcode", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_smilies", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("formatting_fixup", "0");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allowed_html_tags", "b,i,u,a");  INSERT INTO phpbb_kb_types VALUES (1, 'Test Type 1');