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 NOT NULL DEFAULT '1970-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1970-01-01 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`)
) AUTO_INCREMENT=10000 COMMENT='Blog Articles';

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

INSERT INTO wbblogcategory (catid,title,brief) VALUES
(1, "Anderes", "Themen die sonst nirgends dazu passen.");
