SQLite format 3@ W#W-% I ^O-b6i+eindexindex_storytime_sites_on_selected_root_page_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_selected_root_page_id" ON "storytime_sites" ("selected_root_page_id")i++ tablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime, "selected_root_page_id" integer)>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id")!++ytablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "content" text, "excerpt" text, "published" boolean, "post_type" varchar(255), "created_at" datetime, "updated_at" datetime)$Y7Eindexindex_storytime_permissions_on_role_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_role_id" ON "storytime_permissions" ("role_id")* ]7Mindexindex_storytime_permissions_on_action_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_action_id" ON "storytime_permissions" ("action_id")c 77etablestorytime_permissionsstorytime_permissions CREATE TABLE "storytime_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_id" integer, "action_id" integer, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_pages_on_user_idstorytime_pages CREATE INDEX "index_storytime_pages_on_user_id" ON "storytime_pages" ("user_id") ++Otablestorytime_pagesstorytime_pages CREATE TABLE "storytime_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "slug" varchar(255), "content" text, "published" boolean, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_media_on_user_idstorytime_media CREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id")Q++Ytablestorytime_mediastorytime_media CREATE TABLE "storytime_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar(255), "user_id" integer, "created_at" datetime, "updated_at" datetime)Y//atablestorytime_actionsstorytime_actionsCREATE TABLE "storytime_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "guid" varchar(255), "created_at" datetime, "updated_at" datetime))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) //Etablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar(255), "created_at" date  7storytime_permissions#/storytime_actions+storytime_roles     DL%AAManage Users1f7d472014-05-27 01:24:34.8478722014-05-27 01:24:34.847872T5AAManage Site Settings47342a2014-05-27 01:24:34.8453322014-05-27 01:24:34.845332W;AAPublish Own Posts/Pages5030ed2014-05-27 01:24:34.8425672014-05-27 01:24:34.842567aOAAManage Other People's Posts/Pagesd8a1b12014-05-27 01:24:34.8396052014-05-27 01:24:34.839605     #G Q [  e ' o 1 x : D N<#AA2014-05-27 01:41:14.8052822014-05-27 01:41:14.805282<"AA2014-05-27 01:41:14.8024012014-05-27 01:41:14.802401;! AA2014-05-27 01:41:14.8003762014-05-27 01:41:14.800376;  AA2014-05-27 01:41:14.7984242014-05-27 01:41:14.798424<AA2014-05-27 01:41:14.7959202014-05-27 01:41:14.795920<AA2014-05-27 01:41:14.7937722014-05-27 01:41:14.793772; AA2014-05-27 01:41:14.7856942014-05-27 01:41:14.785694<AA2014-05-27 01:35:18.1414642014-05-27 01:35:18.141464<AA2014-05-27 01:35:18.1380392014-05-27 01:35:18.138039; AA2014-05-27 01:35:18.1341522014-05-27 01:35:18.134152; AA2014-05-27 01:35:18.1315592014-05-27 01:35:18.131559<AA2014-05-27 01:35:18.1293532014-05-27 01:35:18.129353<AA2014-05-27 01:35:18.1271312014-05-27 01:35:18.127131; AA2014-05-27 01:35:18.1179102014-05-27 01:35:18.117910<AA2014-05-27 01:34:31.6564272014-05-27 01:34:31.656427<AA2014-05-27 01:34:31.6532542014-05-27 01:34:31.653254; AA2014-05-27 01:34:31.6511472014-05-27 01:34:31.651147; AA2014-05-27 01:34:31.6489802014-05-27 01:34:31.648980<AA2014-05-27 01:34:31.6468992014-05-27 01:34:31.646899<AA2014-05-27 01:34:31.6448212014-05-27 01:34:31.644821; AA2014-05-27 01:34:31.6364882014-05-27 01:34:31.636488<AA2014-05-27 01:26:20.5523252014-05-27 01:26:20.552325< AA2014-05-27 01:26:20.5500292014-05-27 01:26:20.550029;  AA2014-05-27 01:26:20.5475002014-05-27 01:26:20.547500;  AA2014-05-27 01:26:20.5456182014-05-27 01:26:20.545618< AA2014-05-27 01:26:20.5435872014-05-27 01:26:20.543587< AA2014-05-27 01:26:20.5414952014-05-27 01:26:20.541495; AA2014-05-27 01:26:20.5338232014-05-27 01:26:20.533823<AA2014-05-27 01:24:34.8789212014-05-27 01:24:34.878921<AA2014-05-27 01:24:34.8763532014-05-27 01:24:34.876353; AA2014-05-27 01:24:34.8743512014-05-27 01:24:34.874351; AA2014-05-27 01:24:34.8723192014-05-27 01:24:34.872319<AA2014-05-27 01:24:34.8702422014-05-27 01:24:34.870242<AA2014-05-27 01:24:34.8680762014-05-27 01:24:34.868076; AA2014-05-27 01:24:34.8633062014-05-27 01:24:34.863306 #9rmJE}w[UOg?a9#" !                 #4X{oRFuic]L@:4#"!             >~>>AAadmin2014-05-27 01:24:34.8328972014-05-27 01:24:34.832897?AAeditor2014-05-27 01:24:34.8305912014-05-27 01:24:34.830591?AAwriter2014-05-27 01:24:34.8238812014-05-27 01:24:34.823881    36  u  Mq6i+6i+eindexindex_storytime_sites_on_selected_root_page_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_selected_root_page_id" ON "storytime_sites" ("selected_root_page_id")i++ tablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime, "selected_root_page_id" integer)>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) //Etablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar(255), "created_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id"))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")Y//atablestorytime_actionsstorytime_actionsCREATE TABLE "storytime_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "guid" varchar(255), "created_at" datetime, "updated_at" datetime)Q++Ytablestorytime_mediastorytime_media CREATE TABLE "storytime_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar(255), "user_id" integer, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_media_on_user_idstorytime_media CREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id") ++Otablestorytime_pagesstorytime_pages CREATE TABLE "storytime_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "slug" varchar(255), "content" text, "published" boolean, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_pages_on_user_idstorytime_pages CREATE INDEX "index_storytime_pages_on_user_id" ON "storytime_pages" ("user_id")c 77etablestorytime_permissionsstorytime_permissions CREATE TABLE "storytime_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_id" integer, "action_id" integer, "created_at" datetime, "updated_at" datetime)* ]7Mindexindex_storytime_permissions_on_action_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_action_id" ON "storytime_permissions" ("action_id")$Y7Eindexindex_storytime_permissions_on_role_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_role_id" ON "storytime_permissions" ("role_id")!++ytablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "content" text, "excerpt" text, "published" boolean, "post_type" varchar(255), "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id") .\ t 1 nAS19indexindex_storytime_versions_on_user_idstorytime_versions CREATE INDEX "index_storytime_versions_on_user_id" ON "storytime_versions" ("user_id")11Ktablestorytime_versionsstorytime_versionsCREATE TABLE "storytime_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "versionable_id" integer, "versionable_type" varchar(255), "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_users_on_role_idstorytime_usersCREATE INDEX "index_storytime_users_on_role_id" ON "storytime_users" ("role_id"):g+oindexindex_storytime_us =//indexunique_schema_migrationsschema_migrations#CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrations"CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)i++ tablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime, "selected_root_page_id" integer)6i+eindexindex_storytime_sites_on_selected_root_page_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_selected_root_page_id" ON "storytime_sites" ("selected_root_page_id")W11Ytablestorytime_taggingsstorytime_taggingsCREATE TABLE "storytime_taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)S19indexindex_storytime_taggings_on_post_idstorytime_taggingsCREATE INDEX "index_storytime_taggings_on_post_id" ON "storytime_taggings" ("post_id")Q15indexindex_storytime_taggings_on_tag_idstorytime_taggingsCREATE INDEX "index_storytime_taggings_on_tag_id" ON "storytime_taggings" ("tag_id");))1tablestorytime_tagsstorytime_tagsCREATE TABLE "storytime_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)/++tablestorytime_usersstorytime_usersCREATE TABLE "storytime_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "role_id" integer) I+3indexindex_storytime_users_on_emailstorytime_usersCREATE UNIQUE INDEX "index_storytime_users_on_email" ON "storytime_users" ("email"):g+oindexindex_storytime_users_on_reset_password_tokenstorytime_usersCREATE UNIQUE INDEX "index_storytime_users_on_reset_password_token" ON "storytime_users" ("reset_password_token") M+-indexindex_storytime_users_on_role_idstorytime_usersCREATE INDEX "index_storytime_users_on_role_id" ON "storytime_users" ("role_id")11Ktablestorytime_versionsstorytime_versionsCREATE TABLE "storytime_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "versionable_id" integer, "versionable_type" varchar(255), "created_at" datetime, "updated_at" datetime)S19indexindex_storytime_versions_on_user_idstorytime_versions CREATE INDEX "index_storytime_versions_on_user_id" ON "storytime_versions" ("user_id")/1Kindexversionable_indexstorytime_versions!CREATE INDEX "versionable_index" ON "storytime_versions" ("versionable_type", "versionable_id")           p^L:()20140521191728 )20140521191048 )20140521190606 )20140516141252 )20140514200304 )20140514200234)20140513162745)20140513161233)20140511200849)20140509191309)20140509150223)20140501174341)20140501171949)20140521191744 |iVC0 )20140521191728)20140521191048 )20140521190606 )20140516141252 )20140514200304 )20140514200234 )20140513162745)20140513161233)20140511200849)20140509191309)20140509150223)20140501174341)20140501171949) 20140521191744