CREATE TABLE `authors` (
  `id` int(11) NOT NULL auto_increment,
  `realname` varchar(255) collate utf8_unicode_ci NOT NULL,
  `username` varchar(20) collate utf8_unicode_ci NOT NULL,
  `password` varchar(64) collate utf8_unicode_ci NOT NULL,
  `email` varchar(128) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `entries` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(200) collate utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `author` varchar(60) collate utf8_unicode_ci NOT NULL default 'anonymous',
  `author_id` int(11) NOT NULL default '0',
  `body` text collate utf8_unicode_ci NOT NULL,
  `extended_body` text collate utf8_unicode_ci NOT NULL,
  `has_extended` tinyint(1) NOT NULL default '0',
  `comment_count` int(4) NOT NULL default '0',
  `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `body` (`body`),
  FULLTEXT KEY `extended_body` (`extended_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;