Post
by mjg » Sun Sep 25, 2005 8:30 am
Here it is, thanks for looking:
CREATE TABLE `faqadminlog` (
`id` int(11) NOT NULL auto_increment,
`time` int(11) NOT NULL default '0',
`usr` int(11) NOT NULL default '0',
`text` text NOT NULL,
`ip` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=68 ;
CREATE TABLE `faqadminsessions` (
`uin` varchar(50) binary NOT NULL default '',
`usr` tinytext NOT NULL,
`pass` varchar(64) binary NOT NULL default '',
`ip` text NOT NULL,
`time` int(11) NOT NULL default '0'
) TYPE=MyISAM;
CREATE TABLE `faqcategories` (
`id` int(11) NOT NULL auto_increment,
`lang` varchar(5) NOT NULL default '',
`parent_id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`,`lang`)
) TYPE=MyISAM AUTO_INCREMENT=217240 ;
CREATE TABLE `faqchanges` (
`id` int(11) NOT NULL auto_increment,
`beitrag` int(11) NOT NULL default '0',
`lang` varchar(5) NOT NULL default '',
`usr` int(11) NOT NULL default '0',
`datum` int(11) NOT NULL default '0',
`what` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
CREATE TABLE `faqcomments` (
`id_comment` int(11) NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`usr` 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 ;
CREATE TABLE `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` longtext 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=31 ;
CREATE TABLE `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 ;
CREATE TABLE `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=2 ;
CREATE TABLE `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=271 ;
CREATE TABLE `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` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
CREATE TABLE `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=31 ;
CREATE TABLE `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',
`usr` 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=3 ;