DROP TABLE IF EXISTS `mgw_faq_faqadminlog`;
CREATE TABLE `mgw_faq_faqadminlog` (
  `id` int(11) NOT NULL auto_increment,
  `time` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `text` text NOT NULL,
  `ip` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

DROP TABLE IF EXISTS `mgw_faq_faqadminsessions`;
CREATE TABLE `mgw_faq_faqadminsessions` (
  `uin` varchar(50) binary NOT NULL default '',
  `user` tinytext NOT NULL,
  `pass` varchar(64) binary NOT NULL default '',
  `ip` text NOT NULL,
  `time` int(11) NOT NULL default '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS `mgw_faq_faqchanges`;
CREATE TABLE `mgw_faq_faqchanges` (
  `id` int(11) NOT NULL auto_increment,
  `beitrag` int(11) NOT NULL default '0',
  `lang` varchar(5) NOT NULL default '',
  `user` int(11) NOT NULL default '0',
  `datum` int(11) NOT NULL default '0',
  `what` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `mgw_faq_faqcomments`;
CREATE TABLE `mgw_faq_faqcomments` (
  `id_comment` int(11) NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `user` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `comment` text NOT NULL,
  `datum` int(15) NOT NULL default '0',
  `helped` text NOT NULL,
  PRIMARY KEY  (`id_comment`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `mgw_faq_faqdata`;
CREATE TABLE `mgw_faq_faqdata` (
  `id` int(11) NOT NULL auto_increment,
  `lang` varchar(5) NOT NULL default '',
  `active` char(3) NOT NULL default '',
  `rubrik` text NOT NULL,
  `keywords` text NOT NULL,
  `thema` text NOT NULL,
  `content` text NOT NULL,
  `author` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `comment` enum('y','n') NOT NULL default 'y',
  `datum` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`,`lang`),
  FULLTEXT KEY `keywords` (`keywords`,`thema`,`content`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `mgw_faq_faqfragen`;
CREATE TABLE `mgw_faq_faqfragen` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `ask_username` varchar(100) NOT NULL default '',
  `ask_usermail` varchar(100) NOT NULL default '',
  `ask_rubrik` varchar(100) NOT NULL default '',
  `ask_content` text NOT NULL,
  `ask_date` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `mgw_faq_faqnews`;
CREATE TABLE `mgw_faq_faqnews` (
  `id` int(11) NOT NULL auto_increment,
  `header` varchar(255) NOT NULL default '',
  `artikel` text NOT NULL,
  `datum` varchar(14) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `linktitel` varchar(255) NOT NULL default '',
  `target` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `mgw_faq_faqrights`;
CREATE TABLE `mgw_faq_faqrights` (
  `id` int(11) NOT NULL auto_increment,
  `short` text NOT NULL,
  `name` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=23 ;

INSERT INTO `mgw_faq_faqrights` VALUES (1, 'adduser', 'Benutzer hinzufgen');
INSERT INTO `mgw_faq_faqrights` VALUES (2, 'edituser', 'Benutzer editieren');
INSERT INTO `mgw_faq_faqrights` VALUES (3, 'deluser', 'Benutzer lschen');
INSERT INTO `mgw_faq_faqrights` VALUES (4, 'addbt', 'Beitrag hinzufgen');
INSERT INTO `mgw_faq_faqrights` VALUES (5, 'editbt', 'Beitrag editieren');
INSERT INTO `mgw_faq_faqrights` VALUES (6, 'delbt', 'Beitrag lschen');
INSERT INTO `mgw_faq_faqrights` VALUES (7, 'viewlog', 'Log ansehen');
INSERT INTO `mgw_faq_faqrights` VALUES (8, 'adminlog', 'Adminlog einsehen');
INSERT INTO `mgw_faq_faqrights` VALUES (9, 'delcomment', 'Kommentar lschen');
INSERT INTO `mgw_faq_faqrights` VALUES (10, 'addnews', 'News hinzufgen');
INSERT INTO `mgw_faq_faqrights` VALUES (11, 'editnews', 'News editieren');
INSERT INTO `mgw_faq_faqrights` VALUES (12, 'delnews', 'News lschen');
INSERT INTO `mgw_faq_faqrights` VALUES (13, 'addcateg', 'Kategorie hinzufgen');
INSERT INTO `mgw_faq_faqrights` VALUES (14, 'editcateg', 'Kategorie editeren');
INSERT INTO `mgw_faq_faqrights` VALUES (15, 'delcateg', 'Kategorie lschen');
INSERT INTO `mgw_faq_faqrights` VALUES (16, 'passwd', 'Kennwort ndern');
INSERT INTO `mgw_faq_faqrights` VALUES (17, 'editconfig', 'Konfiguration editieren');
INSERT INTO `mgw_faq_faqrights` VALUES (18, 'addatt', 'Attachments anfgen');
INSERT INTO `mgw_faq_faqrights` VALUES (19, 'delatt', 'Attachment lschen');
INSERT INTO `mgw_faq_faqrights` VALUES (20, 'backup', 'Sicherung erstellen');
INSERT INTO `mgw_faq_faqrights` VALUES (21, 'restore', 'Sicherung wiederherstellen');
INSERT INTO `mgw_faq_faqrights` VALUES (22, 'delquestion', 'Offene Fragen lschen');

DROP TABLE IF EXISTS `mgw_faq_faqrubrik`;
CREATE TABLE `mgw_faq_faqrubrik` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `rubrik` text NOT NULL,
  `titel` varchar(255) NOT NULL default '',
  `datum` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `mgw_faq_faqsessions`;
CREATE TABLE `mgw_faq_faqsessions` (
  `sid` int(11) NOT NULL auto_increment,
  `ip` text NOT NULL,
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=72 ;

DROP TABLE IF EXISTS `mgw_faq_faqstatistik`;
CREATE TABLE `mgw_faq_faqstatistik` (
  `id` int(2) NOT NULL auto_increment,
  `shortn` text NOT NULL,
  `longn` text NOT NULL,
  `param` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;

INSERT INTO `mgw_faq_faqstatistik` VALUES (1, 'mainpage', 'Hauptseite', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (2, 'overview', 'Rubrikbersicht', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (3, 'rubrikview', 'Rubrikanzeige', 'Rubrik');
INSERT INTO `mgw_faq_faqstatistik` VALUES (4, 'artikelview', 'Artikelanzeige', 'Artikel');
INSERT INTO `mgw_faq_faqstatistik` VALUES (5, 'searchpage', 'Suchseite', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (6, 'searchresult', 'Suchergebnis', 'Suchbegriffe');
INSERT INTO `mgw_faq_faqstatistik` VALUES (7, 'savenewentry', 'Eintrag speichern', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (8, 'entrypflichfeldfehler', 'Eintrag Pflichfeldfehler', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (9, 'commentpage', 'Kommentarseite', 'Artikel');
INSERT INTO `mgw_faq_faqstatistik` VALUES (10, 'commentsave', 'Kommantarspeicherung', 'Artikel');
INSERT INTO `mgw_faq_faqstatistik` VALUES (11, 'commentpflichtfeldfehler', 'Kommentarspeicherung Pflichtfeldfehler', 'Artikel');
INSERT INTO `mgw_faq_faqstatistik` VALUES (12, 'newentrypage', 'Eintrageseite', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (13, 'faqhelp', 'Faq Hilfeseite', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (14, 'contact', 'Faq Kontaktseite', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (16, 'savevoting', 'Bewertung abgegeben', 'Artikel');
INSERT INTO `mgw_faq_faqstatistik` VALUES (17, 'savevotingerror', 'Votingabgabe verhindert', 'Artikel');
INSERT INTO `mgw_faq_faqstatistik` VALUES (18, 'oldSession', 'Alte Session, aber neue IP', 'Session-ID');
INSERT INTO `mgw_faq_faqstatistik` VALUES (19, 'frage', 'Seite zum Fragestellen', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (20, 'xml', 'XML-Ausgabe erstellt', 'XML-Output');
INSERT INTO `mgw_faq_faqstatistik` VALUES (21, 'antworten', 'Antwortseite', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (22, 'frageabsenden', 'Frage absenden', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (23, 'sendmail', 'FAQ Kontaktseite', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (24, 'fragen', 'Frage stellen Formular', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (25, 'NewSession', 'Neue Session', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (26, 'send2friend', 'FAQ weiterempfohlen', '');
INSERT INTO `mgw_faq_faqstatistik` VALUES (27, 's2fmail', 'FAQ Empfehlung versendet', '');

DROP TABLE IF EXISTS `mgw_faq_faquser`;
CREATE TABLE `mgw_faq_faquser` (
  `id` int(2) NOT NULL auto_increment,
  `name` text NOT NULL,
  `pass` varchar(64) binary NOT NULL default '',
  `realname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `rights` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

DROP TABLE IF EXISTS `mgw_faq_faqvisits`;
CREATE TABLE `mgw_faq_faqvisits` (
  `id` int(11) NOT NULL auto_increment,
  `lang` varchar(5) NOT NULL default '',
  `visits` int(11) NOT NULL default '0',
  `last_visit` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`,`lang`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `mgw_faq_faqvoting`;
CREATE TABLE `mgw_faq_faqvoting` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `artikel` int(11) unsigned NOT NULL default '0',
  `vote` int(11) unsigned NOT NULL default '0',
  `user` int(11) unsigned NOT NULL default '0',
  `datum` varchar(20) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


