DROP TABLE IF EXISTS `wbblog`;
CREATE TABLE `wbblog` (
  `blogid` int(10) NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL,
  `vfsfid` int(11) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `body` text NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`blogid`),
  KEY `created` (`created`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM  AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8 COMMENT='Blog Articles';

DROP TABLE IF EXISTS `wbblogcategory`;
CREATE TABLE `wbblogcategory` (
  `catid` int(11) NOT NULL auto_increment,
  `title` varchar(250) NOT NULL,
  `brief` text NOT NULL,
  `created` datetime NOT NULL,
  `changed` datetime NOT NULL,
  `owner` varchar(250) NOT NULL default '*',
  `other` set('list','publish','edit') NOT NULL,
  `moderated` tinyint(1) NOT NULL default '0',
  `commentable` enum('nobody','user','admin','anonymous') NOT NULL,
  `uid` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`catid`),
  KEY `title` (`title`)
) ENGINE=MyISAM  AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8 COMMENT='Blog Categories';
