CREATE TABLE  authors (
  id              INTEGER,
  approved_by_id  INTEGER   NOT NULL  DEFAULT 0,
  name            VARCHAR,
  login           VARCHAR,
  email           VARCHAR,
  note            TEXT,
  password        VARCHAR,
  created_at      TIMESTAMP,
  updated_at      TIMESTAMP,
  
  PRIMARY KEY     (id)
);

CREATE TABLE  books (
  id              INTEGER,
  title           VARCHAR,
  intro           TEXT,
  body            TEXT,
  published       TINYINT,
  position        INTEGER,
  created_at      TIMESTAMP,
  updated_at      TIMESTAMP,
  
  PRIMARY KEY     (id)
);

CREATE TABLE  chapters (
  id              INTEGER,
  book_id         INTEGER,
  parent_id       INTEGER,
  position        INTEGER,
  title           VARCHAR,
  created_at      TIMESTAMP,
  updated_at      TIMESTAMP,
    
  PRIMARY KEY     (id)
);

CREATE TABLE  pages (
  id              INTEGER,
  chapter_id      INTEGER,
  author_id       INTEGER,
  title           VARCHAR,
  body            TEXT,
  position        INTEGER,
  created_at      TIMESTAMP,
  updated_at      TIMESTAMP,
    
  PRIMARY KEY     (id)
);

CREATE TABLE  page_revisions (
  id              INTEGER,
  page_id         INTEGER,
  author_id       INTEGER,
  revision        INTEGER,
  title           VARCHAR,
  body            TEXT,
  created_at      TIMESTAMP,
  updated_at      TIMESTAMP,
    
  PRIMARY KEY     (id)
);

CREATE INDEX position ON chapters (position, id);
CREATE INDEX pospage  ON pages    (position, id);