SQLite dump for new Anchor site

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE anchor_categories (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  title VARCHAR(150) NOT NULL,
  slug VARCHAR(40) NOT NULL,
  description text NOT NULL
);
INSERT INTO "anchor_categories" VALUES(1,'Uncategorised','uncategorised','Uncategorised');
CREATE TABLE anchor_comments (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  post INTEGER,
  STATUS VARCHAR CHECK(STATUS IN ('pending','approved','spam')) NOT NULL,
  DATE datetime NOT NULL,
  name VARCHAR(140) NOT NULL,
  email VARCHAR(140) NOT NULL,
  text text NOT NULL
);
CREATE TABLE anchor_extend (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  TYPE VARCHAR CHECK(TYPE IN ('post','page')) NOT NULL,
  FIELD VARCHAR CHECK(FIELD IN('text','html','image','file')) NOT NULL,
  KEY VARCHAR(160) NOT NULL,
  label VARCHAR(160) NOT NULL,
  attributes text NOT NULL
);
CREATE TABLE anchor_meta (
  KEY VARCHAR(140) NOT NULL,
  VALUE text NOT NULL
);
INSERT INTO "anchor_meta" VALUES('auto_published_comments','0');
INSERT INTO "anchor_meta" VALUES('comment_moderation_keys','');
INSERT INTO "anchor_meta" VALUES('comment_notifications','0');
INSERT INTO "anchor_meta" VALUES('current_migration','140');
INSERT INTO "anchor_meta" VALUES('date_format','jS M, Y');
INSERT INTO "anchor_meta" VALUES('description',' ');
INSERT INTO "anchor_meta" VALUES('home_page','1');
INSERT INTO "anchor_meta" VALUES('posts_page','1');
INSERT INTO "anchor_meta" VALUES('posts_per_page','6');
INSERT INTO "anchor_meta" VALUES('sitename','Unconfigured Anchor Site');
INSERT INTO "anchor_meta" VALUES('theme','default');
INSERT INTO "anchor_meta" VALUES('last_update_check','2014-11-20 12:19:31');
INSERT INTO "anchor_meta" VALUES('update_version','0.9.2');
CREATE TABLE anchor_page_meta (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  page INT(6) NOT NULL,
  extend INT(6) NOT NULL,
  DATA text NOT NULL
);
CREATE TABLE anchor_pages (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  parent INT(6) NOT NULL,
  slug VARCHAR(150) NOT NULL,
  name VARCHAR(64) NOT NULL,
  title VARCHAR(150) NOT NULL,
  content text NOT NULL,
  STATUS VARCHAR CHECK (STATUS IN ('draft','published','archived')) NOT NULL,
  redirect text NOT NULL,
  show_in_menu tinyint(1) NOT NULL,
  menu_order INT(4) NOT NULL
);
INSERT INTO "anchor_pages" VALUES(1,0,'posts','Posts','My posts and thoughts','Welcome!','published','',1,0);
CREATE TABLE anchor_post_meta (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  post INT(6) NOT NULL,
  extend INT(6) NOT NULL,
  DATA text NOT NULL
);
CREATE TABLE anchor_posts (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  title VARCHAR(150) NOT NULL,
  slug VARCHAR(150) NOT NULL,
  description text NOT NULL,
  html text NOT NULL,
  css text NOT NULL,
  js text NOT NULL,
  created datetime NOT NULL,
  author INT(6) NOT NULL,
  category INT(6) NOT NULL,
  STATUS VARCHAR CHECK(STATUS IN ('draft','published','archived')) NOT NULL,
  comments tinyint(1) NOT NULL
);
INSERT INTO "anchor_posts" VALUES(1,'Hello World','hello-world','This is the first post.','Hello World!\r\n\r\nThis is the first post.','','','2014-11-20 17:12:06',1,1,'published',0);
CREATE TABLE anchor_sessions (
  id CHAR(32) NOT NULL,
  expire INT(10) NOT NULL,
  DATA text NOT NULL
);
CREATE TABLE anchor_users (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  username VARCHAR(100) NOT NULL,
  password text NOT NULL,
  email VARCHAR(140) NOT NULL,
  real_name VARCHAR(140) NOT NULL,
  bio text NOT NULL,
  STATUS VARCHAR CHECK(STATUS IN ('inactive','active')) NOT NULL,
  ROLE VARCHAR CHECK(ROLE IN ('administrator','editor','user')) NOT NULL
);
INSERT INTO "anchor_users" VALUES(1,'admin','$1$iuVMmuiP$hGdyzZVNr52F0Vd9Eq3MX0','admin@example.com','Administrator','Sysop','active','administrator');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('anchor_categories',1);
INSERT INTO "sqlite_sequence" VALUES('anchor_pages',1);
INSERT INTO "sqlite_sequence" VALUES('anchor_posts',1);
INSERT INTO "sqlite_sequence" VALUES('anchor_users',1);
CREATE INDEX i_anchor_comments_post ON anchor_comments(post);
CREATE INDEX i_anchor_comments_status ON anchor_comments(STATUS);
CREATE INDEX i_anchor_page_meta_page ON anchor_page_meta(page);
CREATE INDEX i_anchor_page_meta_extend ON anchor_page_meta(extend);
CREATE INDEX i_anchor_pages_status ON anchor_pages(STATUS);
CREATE INDEX i_anchor_pages_slug ON anchor_pages(slug);
CREATE INDEX i_anchor_post_meta_post ON anchor_post_meta(post);
CREATE INDEX i_anchor_post_meta_extend ON anchor_post_meta(extend);
CREATE INDEX i_anchor_posts_status ON anchor_posts(STATUS);
CREATE INDEX i_anchor_posts_slug ON anchor_posts(slug);
COMMIT;