DROP TABLE IF EXISTS `k4_faq_items`;
CREATE TABLE `k4_faq_items` (
  `item_id` int(10) unsigned NOT NULL auto_increment,
  `section_id` int(10) unsigned NOT NULL,
  `relation_id` int(10) unsigned default NULL,
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  PRIMARY KEY  (`item_id`),
  KEY `section_id` (`section_id`),
  KEY `relation_id` (`relation_id`),
  FULLTEXT(`question`, `answer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;


INSERT INTO `k4_faq_items` (`item_id`, `section_id`, `relation_id`, `question`, `answer`) VALUES (1, 1, NULL, 'How do I register on this board?', 'You can become member of this awesome peace of code through accepting our registration agreement and completing the registration process afterwards.'),
(2, 1, NULL, 'How do I resign from this board?', 'Actually you neither are able to delete your account nor you can resign from this board as it''s still under development where such a feature is not yet built in.'),
(3, 2, 1, 'Wie registriere ich mich auf diesem Forum?', 'Du kannst Mitglied dieses unglaublichen Stücks Programmierarbeit werden indem du unsere Registrierungsbestimmungen akzeptierst und danach den Registrierungsprozess abschließt.'),
(4, 4, 2, 'Wie löse ich mein Benutzerkonto auf?', 'Gegenwärtig ist es nicht möglich seinen Benutzer oder dessen Benutzerkonto zu löschen, da sich die Forensoftware noch in Entwicklung befindet und noch keine solche Funktion zur Verfügung stellt.');

-- --------------------------------------------------------

DROP TABLE IF EXISTS `k4_faq_sections`;
CREATE TABLE `k4_faq_sections` (
  `section_id` int(10) unsigned NOT NULL auto_increment,
  `language_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned default NULL,
  `relation_id` int(10) unsigned default NULL,
  `title` varchar(100) NOT NULL,
  `description` text,
  PRIMARY KEY  (`section_id`),
  KEY `language_id` (`language_id`,`relation_id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;


INSERT INTO `k4_faq_sections` (`section_id`, `language_id`, `parent_id`, `relation_id`, `title`, `description`) VALUES (1, 1, NULL, NULL, 'Account Management', 'How to organize, customize and control your user account.'),
(2, 2, NULL, 1, 'Kontoverwaltung', 'Organisation und Verwaltung des Benutzerkontos.'),
(3, 1, NULL, NULL, 'General Board Usage', 'Browsing, viewing, reading of the k4 bulletin board and much more.'),
(4, 2, NULL, 3, 'Allgemeine Benützung der Foren', 'Stöbern, lesen und schreiben von Beiträgen in den k4BB Foren.');

-- --------------------------------------------------------

DROP TABLE IF EXISTS `k4_languages`;
CREATE TABLE `k4_languages` (
  `language_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(16) NOT NULL,
  `foreign` varchar(16) NOT NULL,
  `code` varchar(2) NOT NULL,
  PRIMARY KEY  (`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;


INSERT INTO `k4_languages` (`language_id`, `name`, `foreign`, `code`) VALUES (1, 'english', 'english', 'en'),
(2, 'german', 'deutsch', 'de');