knowledge base

[Duvelske]

Hallo allemaal,

Ik wilde vragen of iemand toevallig een sql dump heeft (ook structuur) van de knowledge base. (die op mx-system.com staat) dit vanwege het feit dat ik de install file niet kan laten werken en de update file evenmin.

Bij voorbaat dank!

[Luuk]

Code: Selecteer alles

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_description varchar(255) binary NOT NULL default "",
  						article_date varchar(255) binary NOT NULL default "",
  						article_author_id mediumint(8) NOT NULL,
						username VARCHAR(255),
  						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;
					
INSERT INTO phpbb_kb_articles VALUES (1, 1, "Test Article", "This is a test article for your KB", "1057708235", 2, "", "93074f48a9", "This is a test article for your Knowledge Base. This MOD is based on code written by wGEric < eric@egcnetwork.com > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo < jonohlsson@hotmail.com > (Jon Ohlsson) - http://www.mx-system.com/ \r\n\r\nBe sure you add categories and article types in the ACP and also change the Configuration to your liking.\r\n\r\nHave fun and enjoy your new Knowledge Base!  :D", 1, 1, 0, 0,0,0);

CREATE TABLE phpbb_kb_categories (
  			 	   	    category_id mediumint(8) unsigned NOT NULL auto_increment, 
  						category_name VARCHAR(255) binary NOT NULL, 
  						category_details VARCHAR(255) binary NOT NULL, 
 						number_articles mediumint(8) unsigned NOT NULL,
						parent mediumint(8) unsigned,
						cat_order mediumint(8) unsigned NOT NULL,
					  	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;
					
			  
INSERT INTO phpbb_kb_categories VALUES (1, "Test Category 1", "This is a test category", "0", "0", "10", "0", "0", "0", "0", "0", "2", "0", "0", "", "", "", "", "", "", "", "", "", "0" );

CREATE TABLE phpbb_kb_config (
			  			config_name VARCHAR(255) NOT NULL default "", 
						config_value varchar(255) NOT NULL default "",
						PRIMARY KEY  (config_name)
						) 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");
					
CREATE TABLE phpbb_kb_types (
  				 	       	id mediumint(8) unsigned NOT NULL auto_increment, 
  						   	type varchar(255) binary DEFAULT "" NOT NULL, 
  						   	KEY id (id)
					  ) TYPE=MyISAM;
					  
INSERT INTO phpbb_kb_types VALUES (1, "Test Type 1");

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_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_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_description 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;

Zoiets?

[Duvelske]

:thumb: thnx dat heeft flink geholpen