text: PRAGMA foreign_keys=OFF;
  BEGIN TRANSACTION;
  CREATE TABLE "django_migrations" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app" varchar(255) NOT NULL, "name" varchar(255) NOT NULL, "applied" datetime NOT NULL);
  INSERT INTO "django_migrations" VALUES(1,'ahmia','0001_initial','2016-01-12 16:29:38.393318');
  INSERT INTO "django_migrations" VALUES(2,'contenttypes','0001_initial','2016-01-12 16:29:38.578246');
  INSERT INTO "django_migrations" VALUES(3,'auth','0001_initial','2016-01-12 16:29:38.829531');
  INSERT INTO "django_migrations" VALUES(4,'sites','0001_initial','2016-01-12 16:29:39.041272');
  CREATE TABLE "ahmia_hiddenwebsite" ("url" varchar(200) NOT NULL UNIQUE, "id" varchar(16) NOT NULL PRIMARY KEY, "banned" bool NOT NULL, "online" bool NOT NULL, "md5" varchar(32) NOT NULL UNIQUE, "updated" datetime NOT NULL);
  CREATE TABLE "ahmia_hiddenwebsitedescription" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" text NULL, "description" text NULL, "relation" varchar(200) NULL, "subject" text NULL, "type" text NULL, "updated" datetime NOT NULL, "language" text NULL, "contactInformation" text NULL, "officialInfo" bool NOT NULL, "about_id" varchar(16) NOT NULL REFERENCES "ahmia_hiddenwebsite" ("id"));
  CREATE TABLE "ahmia_hiddenwebsitepopularity" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "clicks" integer unsigned NULL, "public_backlinks" integer unsigned NULL, "tor2web" integer unsigned NULL, "about_id" varchar(16) NOT NULL REFERENCES "ahmia_hiddenwebsite" ("id"));
  CREATE TABLE "ahmia_hiddenwebsitestatus" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "time" datetime NOT NULL, "online" bool NOT NULL, "about_id" varchar(16) NOT NULL REFERENCES "ahmia_hiddenwebsite" ("id"));
  CREATE TABLE "ahmia_websiteindex" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "domain" text NOT NULL, "url" varchar(200) NOT NULL UNIQUE, "tor2web_url" varchar(200) NOT NULL UNIQUE, "text" text NOT NULL, "title" text NOT NULL, "h1" text NOT NULL, "h2" text NOT NULL, "crawling_session" text NOT NULL, "server_header" text NOT NULL, "date_inserted" datetime NOT NULL);
  CREATE TABLE "django_content_type" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL, "app_label" varchar(100) NOT NULL, "model" varchar(100) NOT NULL, UNIQUE ("app_label", "model"));
  INSERT INTO "django_content_type" VALUES(1,'permission','auth','permission');
  INSERT INTO "django_content_type" VALUES(2,'group','auth','group');
  INSERT INTO "django_content_type" VALUES(3,'user','auth','user');
  INSERT INTO "django_content_type" VALUES(4,'content type','contenttypes','contenttype');
  INSERT INTO "django_content_type" VALUES(5,'site','sites','site');
  INSERT INTO "django_content_type" VALUES(6,'hidden website','ahmia','hiddenwebsite');
  INSERT INTO "django_content_type" VALUES(7,'hidden website description','ahmia','hiddenwebsitedescription');
  INSERT INTO "django_content_type" VALUES(8,'hidden website popularity','ahmia','hiddenwebsitepopularity');
  INSERT INTO "django_content_type" VALUES(9,'hidden website status','ahmia','hiddenwebsitestatus');
  INSERT INTO "django_content_type" VALUES(10,'website index','ahmia','websiteindex');
  CREATE TABLE "auth_permission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(50) NOT NULL, "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id"), "codename" varchar(100) NOT NULL, UNIQUE ("content_type_id", "codename"));
  INSERT INTO "auth_permission" VALUES(1,'Can add permission',1,'add_permission');
  INSERT INTO "auth_permission" VALUES(2,'Can change permission',1,'change_permission');
  INSERT INTO "auth_permission" VALUES(3,'Can delete permission',1,'delete_permission');
  INSERT INTO "auth_permission" VALUES(4,'Can add group',2,'add_group');
  INSERT INTO "auth_permission" VALUES(5,'Can change group',2,'change_group');
  INSERT INTO "auth_permission" VALUES(6,'Can delete group',2,'delete_group');
  INSERT INTO "auth_permission" VALUES(7,'Can add user',3,'add_user');
  INSERT INTO "auth_permission" VALUES(8,'Can change user',3,'change_user');
  INSERT INTO "auth_permission" VALUES(9,'Can delete user',3,'delete_user');
  INSERT INTO "auth_permission" VALUES(10,'Can add content type',4,'add_contenttype');
  INSERT INTO "auth_permission" VALUES(11,'Can change content type',4,'change_contenttype');
  INSERT INTO "auth_permission" VALUES(12,'Can delete content type',4,'delete_contenttype');
  INSERT INTO "auth_permission" VALUES(13,'Can add site',5,'add_site');
  INSERT INTO "auth_permission" VALUES(14,'Can change site',5,'change_site');
  INSERT INTO "auth_permission" VALUES(15,'Can delete site',5,'delete_site');
  INSERT INTO "auth_permission" VALUES(16,'Can add hidden website',6,'add_hiddenwebsite');
  INSERT INTO "auth_permission" VALUES(17,'Can change hidden website',6,'change_hiddenwebsite');
  INSERT INTO "auth_permission" VALUES(18,'Can delete hidden website',6,'delete_hiddenwebsite');
  INSERT INTO "auth_permission" VALUES(19,'Can add hidden website description',7,'add_hiddenwebsitedescription');
  INSERT INTO "auth_permission" VALUES(20,'Can change hidden website description',7,'change_hiddenwebsitedescription');
  INSERT INTO "auth_permission" VALUES(21,'Can delete hidden website description',7,'delete_hiddenwebsitedescription');
  INSERT INTO "auth_permission" VALUES(22,'Can add hidden website popularity',8,'add_hiddenwebsitepopularity');
  INSERT INTO "auth_permission" VALUES(23,'Can change hidden website popularity',8,'change_hiddenwebsitepopularity');
  INSERT INTO "auth_permission" VALUES(24,'Can delete hidden website popularity',8,'delete_hiddenwebsitepopularity');
  INSERT INTO "auth_permission" VALUES(25,'Can add hidden website status',9,'add_hiddenwebsitestatus');
  INSERT INTO "auth_permission" VALUES(26,'Can change hidden website status',9,'change_hiddenwebsitestatus');
  INSERT INTO "auth_permission" VALUES(27,'Can delete hidden website status',9,'delete_hiddenwebsitestatus');
  INSERT INTO "auth_permission" VALUES(28,'Can add website index',10,'add_websiteindex');
  INSERT INTO "auth_permission" VALUES(29,'Can change website index',10,'change_websiteindex');
  INSERT INTO "auth_permission" VALUES(30,'Can delete website index',10,'delete_websiteindex');
  CREATE TABLE "auth_group" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(80) NOT NULL UNIQUE);
  CREATE TABLE "auth_group_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id"), "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"), UNIQUE ("group_id", "permission_id"));
  CREATE TABLE "auth_user" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "password" varchar(128) NOT NULL, "last_login" datetime NOT NULL, "is_superuser" bool NOT NULL, "username" varchar(30) NOT NULL UNIQUE, "first_name" varchar(30) NOT NULL, "last_name" varchar(30) NOT NULL, "email" varchar(75) NOT NULL, "is_staff" bool NOT NULL, "is_active" bool NOT NULL, "date_joined" datetime NOT NULL);
  INSERT INTO "auth_user" VALUES(1,'pbkdf2_sha256$15000$FIMYSdq4NCrG$o8GgyAQ02kpLNa3il/4ZtCOsdnojmb9GHbAkGvghhXM=','2016-01-12 16:30:13.567927',1,'admin1','','','info@mikaela.nl',1,1,'2016-01-12 16:30:13.567927');
  CREATE TABLE "auth_user_groups" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id"), "group_id" integer NOT NULL REFERENCES "auth_group" ("id"), UNIQUE ("user_id", "group_id"));
  CREATE TABLE "auth_user_user_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id"), "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"), UNIQUE ("user_id", "permission_id"));
  CREATE TABLE "django_site" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "domain" varchar(100) NOT NULL, "name" varchar(50) NOT NULL);
  INSERT INTO "django_site" VALUES(1,'example.com','example.com');
  DELETE FROM sqlite_sequence;
  INSERT INTO "sqlite_sequence" VALUES('django_migrations',4);
  INSERT INTO "sqlite_sequence" VALUES('django_content_type',10);
  INSERT INTO "sqlite_sequence" VALUES('auth_permission',30);
  INSERT INTO "sqlite_sequence" VALUES('django_site',1);
  INSERT INTO "sqlite_sequence" VALUES('auth_user',1);
  CREATE INDEX "ahmia_hiddenwebsitedescription_c4e72238" ON "ahmia_hiddenwebsitedescription" ("about_id");
  CREATE INDEX "ahmia_hiddenwebsitepopularity_c4e72238" ON "ahmia_hiddenwebsitepopularity" ("about_id");
  CREATE INDEX "ahmia_hiddenwebsitestatus_c4e72238" ON "ahmia_hiddenwebsitestatus" ("about_id");
  CREATE INDEX "auth_permission_417f1b1c" ON "auth_permission" ("content_type_id");
  CREATE INDEX "auth_group_permissions_0e939a4f" ON "auth_group_permissions" ("group_id");
  CREATE INDEX "auth_group_permissions_8373b171" ON "auth_group_permissions" ("permission_id");
  CREATE INDEX "auth_user_groups_e8701ad4" ON "auth_user_groups" ("user_id");
  CREATE INDEX "auth_user_groups_0e939a4f" ON "auth_user_groups" ("group_id");
  CREATE INDEX "auth_user_user_permissions_e8701ad4" ON "auth_user_user_permissions" ("user_id");
  CREATE INDEX "auth_user_user_permissions_8373b171" ON "auth_user_user_permissions" ("permission_id");
  COMMIT;
  