-- 
-- Tabellenstruktur fr Tabelle `forum_bereiche`
-- 

CREATE TABLE `forum_bereiche` (
  `beid` int(10) unsigned NOT NULL auto_increment,
  `fkid` int(10) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `beschreibung` text NOT NULL,
  `themen` int(10) unsigned NOT NULL default '0',
  `comments` int(10) unsigned NOT NULL default '0',
  `lastauthor` varchar(50) NOT NULL default '',
  `lastpost` varchar(20) NOT NULL default '01.01.05, 13:37',
  `zeit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`beid`)
) TYPE=MyISAM;

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

-- 
-- Tabellenstruktur fr Tabelle `forum_kategorie`
-- 

CREATE TABLE `forum_kategorie` (
  `fkid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`fkid`)
) TYPE=MyISAM;

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

-- 
-- Tabellenstruktur fr Tabelle `forum_posts`
-- 

CREATE TABLE `forum_posts` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `poid` int(10) unsigned NOT NULL default '0',
  `beid` int(10) unsigned NOT NULL default '1',
  `fkid` int(10) unsigned NOT NULL default '1',
  `topic` varchar(70) NOT NULL default '',
  `body` text NOT NULL,
  `author` varchar(70) NOT NULL default '',
  `date` varchar(20) NOT NULL default '01.01.05, 13:37',
  PRIMARY KEY  (`pid`)
) TYPE=MyISAM;

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

-- 
-- Tabellenstruktur fr Tabelle `forum_posts_titel`
-- 

CREATE TABLE `forum_posts_titel` (
  `poid` int(10) unsigned NOT NULL auto_increment,
  `beid` int(10) unsigned NOT NULL default '0',
  `topic` varchar(70) NOT NULL default '',
  `author` varchar(50) NOT NULL default '',
  `lastauthor` varchar(50) NOT NULL default '',
  `lastpost` varchar(20) NOT NULL default '01.01.05, 13:37',
  `comments` int(10) unsigned NOT NULL default '0',
  `klicks` int(10) unsigned NOT NULL default '0',
  `status` tinyint(3) unsigned NOT NULL default '0',
  `zeit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`poid`)
) TYPE=MyISAM;