CREATE TABLE `authors` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `approved_by_id` int(11) unsigned NOT NULL default '0',
  `name` varchar(80) default NULL,
  `login` varchar(80) default NULL,
  `email` varchar(255) default NULL,
  `note` text,
  `password` varchar(40) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

CREATE TABLE `books` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `intro` text,
  `body` text,
  `position` int(11) default NULL,
  `published` int(1) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

CREATE TABLE `chapters` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `book_id` int(11) unsigned default NULL,
  `parent_id` int(11) unsigned default NULL,
  `position` int(10) unsigned default NULL,
  `title` varchar(255) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `position` (`parent_id`,`position`)
) TYPE=InnoDB;

CREATE TABLE `page_revisions` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `page_id` int(11) unsigned default NULL,
  `author_id` int(11) unsigned default NULL,
  `revision` int(11) default NULL,
  `title` varchar(255) default NULL,
  `body` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `page_id` (`page_id`)
) TYPE=InnoDB;

CREATE TABLE `pages` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `author_id` int(11) unsigned default NULL,
  `chapter_id` int(11) unsigned default NULL,
  `title` varchar(255) default NULL,
  `body` text,
  `position` int(10) unsigned default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `chapter` (`chapter_id`)
) TYPE=InnoDB;