Ik zit een beetje met de sql query te stoeien, kan iemand deze eens voor me nazien want er zitten volgens mij nog wat foutjes in...
Code: Selecteer alles
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_articles`
--
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) NOT NULL default '',
`article_description` varchar(255) NOT NULL default '',
`article_date` varchar(255) NOT NULL default '',
`article_author_id` mediumint(8) NOT NULL default '0',
`username` varchar(255) default NULL,
`bbcode_uid` varchar(10) 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 AUTO_INCREMENT=2 ;
--
-- Gegevens voor tabel `phpbb_kb_articles`
--
INSERT INTO `phpbb_kb_articles` (`article_id`, `article_category_id`, `article_title`, `article_description`, `article_date`, `article_author_id`, `username`, `bbcode_uid`, `article_body`, `article_type`, `approved`, `topic_id`, `views`, `article_rating`, `article_totalvotes`) 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.0000, 0);
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_categories`
--
CREATE TABLE `phpbb_kb_categories` (
`category_id` mediumint(8) unsigned NOT NULL auto_increment,
`category_name` varchar(255) NOT NULL default '',
`category_details` varchar(255) 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) default NULL,
`auth_post_groups` varchar(255) default NULL,
`auth_rate_groups` varchar(255) default NULL,
`auth_comment_groups` varchar(255) default NULL,
`auth_edit_groups` varchar(255) default NULL,
`auth_delete_groups` varchar(255) default NULL,
`auth_approval_groups` varchar(255) default NULL,
`auth_approval_edit_groups` varchar(255) default NULL,
`auth_moderator_groups` varchar(255) default NULL,
`comments_forum_id` tinyint(3) NOT NULL default '-1',
KEY `category_id` (`category_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Gegevens voor tabel `phpbb_kb_categories`
--
INSERT INTO `phpbb_kb_categories` (`category_id`, `category_name`, `category_details`, `number_articles`, `parent`, `cat_order`, `auth_view`, `auth_post`, `auth_rate`, `auth_comment`, `auth_edit`, `auth_delete`, `auth_approval`, `auth_approval_edit`, `auth_view_groups`, `auth_post_groups`, `auth_rate_groups`, `auth_comment_groups`, `auth_edit_groups`, `auth_delete_groups`, `auth_approval_groups`, `auth_approval_edit_groups`, `auth_moderator_groups`, `comments_forum_id`) VALUES
(1, 'Test Category 1', 'This is a test category', 0, 0, 10, 0, 0, 0, 0, 0, 2, 0, 0, '', '', '', '', '', '', '', '', '', 0);
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_config`
--
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;
--
-- Gegevens voor tabel `phpbb_kb_config`
--
INSERT INTO `phpbb_kb_config` (`config_name`, `config_value`) VALUES
('allow_new', '1'),
('notify', '1'),
('admin_id', '2'),
('show_pretext', '0'),
('pt_header', 'Article Submission Instructions'),
('pt_body', 'Please check your references and include as much information as you can.'),
('use_comments', '1'),
('del_topic', '1'),
('use_ratings', '0'),
('comments_show', '1'),
('bump_post', '1'),
('stats_list', '1'),
('header_banner', '1'),
('votes_check_userid', '1'),
('votes_check_ip', '1'),
('art_pagination', '5'),
('comments_pagination', '5'),
('news_sort', 'Alphabetic'),
('news_sort_par', 'ASC'),
('wysiwyg', '0'),
('wysiwyg_path', 'modules/'),
('allow_html', '1'),
('allow_bbcode', '1'),
('allow_smilies', '1'),
('formatting_fixup', '0'),
('allowed_html_tags', 'b,i,u,a');
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_custom`
--
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 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_customdata`
--
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;
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_results`
--
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;
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_types`
--
CREATE TABLE `phpbb_kb_types` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`type` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Gegevens tabel `phpbb_kb_types`
--
INSERT INTO `phpbb_kb_types` (`id`, `type`) VALUES
(1, 'Test Type 1');
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_votes`
--
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;
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_wordlist`
--
CREATE TABLE `phpbb_kb_wordlist` (
`word_text` varchar(50) 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 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabel structuur voor `phpbb_kb_wordmatch`
--
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;
