CREATE TABLE `wp_forum_forums` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `parent_id` int(11) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `views` int(11) NOT NULL default '0',
  `sort` int(11) NOT NULL default '0',
  `starter` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ;

CREATE TABLE `wp_forum_groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ;

CREATE TABLE `wp_forum_posts` (
  `id` int(11) NOT NULL auto_increment,
  `author_name` varchar(255) default NULL,
  `author_email` varchar(255) default NULL,
  `author_web` varchar(255) default NULL,
  `text` longtext,
  `thread_id` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `author_id` int(11) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `views` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ;

CREATE TABLE `wp_forum_threads` (
  `id` int(11) NOT NULL auto_increment,
  `forum_id` int(11) NOT NULL default '0',
  `views` int(11) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` varchar(20) NOT NULL default 'open',
  `starter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ;