Moderator: Integra Moderator
"Teelk";p="21367" wrote:Are you sure? I've got it installed on a test board with CH 2.1.6 and it functions the same as the IM one.
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');
Registered users: App360MonitorBot, Bing [Bot], Google [Bot]