SQLite format 3 @ .- ( $ .- - I *? 5lJF M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id")++Wtablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "type" varchar(255), "title" varchar(255), "slug" varchar(255), "content" text, "excerpt" text, "published_at" datetime, "featured_media_id" integer, "featured" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "secondary_media_id" integer)$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")c77etablestorytime_permissionsstorytime_permissionsCREATE 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_media_on_user_idstorytime_mediaCREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id")Q ++Ytablestorytime_mediastorytime_mediaCREATE TABLE "storytime_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar(255), "user_id" integer, "created_at" datetime, "updated_at" datetime)S19indexindex_storytime_comments_on_user_idstorytime_comments CREATE INDEX "index_storytime_comments_on_user_id" ON "storytime_comments" ("user_id")S19indexindex_storytime_comments_on_post_idstorytime_commentsCREATE INDEX "index_storytime_comments_on_post_id" ON "storytime_comments" ("post_id")h 11{tablestorytime_commentsstorytime_commentsCREATE TABLE "storytime_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime) /3Mindexautosavable_indexstorytime_autosaves CREATE INDEX "autosavable_index" ON "storytime_autosaves" ("autosavable_type", "autosavable_id") 33'tablestorytime_autosavesstorytime_autosaves CREATE TABLE "storytime_autosaves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "autosavable_id" integer, "autosavable_type" varchar(255), "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 OO 8 + Apage-9 Storytime::Post2014-12-03 19:29:53.1446008 + Apage-8 Storytime::Post2014-12-03 19:29:53.130139 + Apost-17 Storytime::Post2014-12-03 19:29:54.753189 BrX* ' Q storytime_versio /friendly_id_slugs +storytime_posts users&/storytime_actions1storytime_comments(+storytime_rolesT3storytime_autosaves&+storytime_sites0 1storytime_versions storytime_snippet1storytime_snippets?+storytime_media<7storytime_permissions + page-9Storytime::Post + page-8Storytime::Post + post-17Storytime::Post +page-9Storytime::Post +page-8Storytime::Post +post-17Storytime::Post +Storytime::Post +Storytime::Post +Storytime::Post BE ZX AAAManage Email Subscriptionsd29d762014-11-13 20:50:46.9315272014-11-13 20:50:46.931527T0 5AAManage Text Snippets5qg25i2014-12-03 19:30:00.2385272014-12-03 19:30:00.238527L/ %AAManage Users1f7d472014-12-03 19:30:00.2356522014-12-03 19:30:00.235652T. 5AAManage Site Settings47342a2014-12-03 19:30:00.2329282014-12-03 19:30:00.232928W- ;AAPublish Own Posts/Pages5030ed2014-12-03 19:30:00.2300422014-12-03 19:30:00.230042a, OAAManage Other People's Posts/Pagesd8a1b12014-12-03 19:30:00.2269312014-12-03 19:30:00.226931 % !+AA
The Deliverator bex& e+AATo Sherlock Holmes she was always the woman. Storytime::Post2014-12-03 19:29:51.2215792014-12-03 19:29:51.221579 +Storytime::Post & j K!AAComment #6 2014-12-03 19:29:54.7619602014-12-03 19:29:54.761960I' !AAComment #5 2014-12-03 19:29:54.7594732014-12-03 19:29:54.759473 ( ' ( ' M+AAsuccess-kid.jpg%2014-12-03 19:29:57.7755842014-12-03 19:29:57.775584 %< ~=z9 =h AAl 2014-11-13 20:50:46.9534212014-11-13 20:50:> AAT2014-12-03 19:30:00.2579282014-12-03 19:30:00.257928> AAS2014-12-03 19:30:00.2560542014-12-03 19:30:00.256054> AAT2014-12-03 19:30:00.2540272014-12-03 19:30:00.254027> AAT2014-12-03 19:30:00.2521232014-12-03 19:30:00.252123> AAT2014-12-03 19:30:00.2501552014-12-03 19:30:00.250155> AAS2014-12-03 19:30:00.2483072014-12-03 19:30:00.248307> AAT2014-12-03 19:30:00.2465012014-12-03 19:30:00.246501> AAS2014-12-03 19:30:00.2445792014-12-03 19:30:00.244579> AAR2014-12-03 19:30:00.2426162014-12-03 19:30:00.242616 h T S T T T S T S R r r \ 3Z X& V+ +q_A AA Storytime::PagePage #9page-9Post #22. It was a dark and stormy night. The End.Post #23. It was a dark and stormy night.2014-12-03 19:29:53.136607f2014-12-03 19:29:53.1391552014-12-03 19:29:53.139155V* +q_A AA Storytime::PagePage #8page-8Post #21. It was a dark and stormy night. The End.Post #22. It was a dark and stormy night.2014-12-03 19:29:53.123507f2014-12-03 19:29:53.1256862014-12-03 19:29:53.\, 3q_A AA Storytime::BlogPostPost #17post-17Post #27. It was a dark and stormy night. The End.Post #28. It was a dark and stormy night.2014-12-03 19:29:54.747056f2014-12-03 19:29:54.7490002014-12-03 19:29:54.749000 |; >T AAadmin2014-12-03 19:30:00.2238422014-12-03 19:30:00.223842?S AAeditor2014-12-03 19:30:00.2212182014-12-03 19:30:00.221218?R AAwriter2014-12-03 19:30:00.2181282014-12-03 19:30:00.218128 J JX[ A 7 q? //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 NUL//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) 33'tablestorytime_autosavesstorytime_autosaves CREATE TABLE "storytime_autosaves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "autosavable_id" integer, "autosavable_type" varchar(255), "created_at" datetime, "updated_at" datetime) /3Mindexautosavable_indexstorytime_autosaves CREATE INDEX "autosavable_index" ON "storytime_autosaves" ("autosavable_type", "autosavable_id")h 11{tablestorytime_commentsstorytime_commentsCREATE TABLE "storytime_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)S19indexindex_storytime_comments_on_post_idstorytime_commentsCREATE INDEX "index_storytime_comments_on_post_id" ON "storytime_comments" ("post_id")S19indexindex_storytime_comments_on_user_idstorytime_comments CREATE INDEX "index_storytime_comments_on_user_id" ON "storytime_comments" ("user_id")Q ++Ytablestorytime_mediastorytime_mediaCREATE 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_mediaCREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id")c77etablestorytime_permissionsstorytime_permissionsCREATE 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")++Wtablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "type" varchar(255), "title" varchar(255), "slug" varchar(255), "content" text, "excerpt" text, "published_at" datetime, "featured_media_id" integer, "featured" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "secondary_media_id" integer)M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id") f J, ' AASite Title 242014-12-03 19:29:54.6164752014-12-03 19:29:54.616475J0 ' AASite Title 342014-12-03 19:30:00.2649602014-12-03 19:30:00.264960 4:9 =s #M-indexindex_users_on_storytime_role_idusers&CREATE INDEX "index_users_on_storytime_role_id" ON "users" ("storytime_role_id")"SGindexindex_users_on_reset_password_tokenusers%CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e!5in%=//indexunique_schema_migrationsschema_migrations(CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)B++;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, "root_post_id" integer, "created_at" datetime, "updated_at" datetime)W+Aindexindex_storytime_sites_on_root_post_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_root_post_id" ON "storytime_sites" ("root_post_id")W11Ytablestorytime_snippetsstorytime_snippetsCREATE TABLE "storytime_snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime);;5tablestorytime_subscriptionsstorytime_subscriptionsCREATE TABLE "storytime_subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "subscribed" boolean DEFAULT 't', "token" varchar(255), "created_at" datetime, "updated_at" datetime)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)11Ktablestorytime_versionsstorytime_versions CREATE 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"): Stableusersusers#CREATE TABLE "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, "storytime_role_id" integer, "storytime_name" varchar(255))e!5indexindex_users_on_emailusers$CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")"SGindexindex_users_on_reset_password_tokenusers%CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")#M-indexindex_users_on_storytime_role_idusers&CREATE INDEX "index_users_on_storytime_role_id" ON "users" ("storytime_role_id")q$//tableschema_migrationsschema_migrations'CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) , 0 . g? UAAsnippet-8Snippet #8. Fortune favors the bold.2014-12-03 19:30:00.3805942014-12-03 19:30:00.380594g> UAAsnippet-7Snippet #7. Fortune favors the bold.2014-12-03 19:30:00.3789632014-12-03 19:30:00.378963 iUAAsnippet-6Snippet #6. Fortune favors the bold.2014-12-03 19:30:00.3770072014-12-03 19:30:00.377007 ~zz + q +AAPost #22. It was a dark and stormy night. The End. Storytime::Post2014-12-03 19:29:53.1408662014-12-03 19:29:53.140866* q +AAPost #21. It was a dark and stormy night. The End. Storytime::Post2014-12-03 19:29:53.1274722014-12-03 19:29:53.127472, q +AAPost #27. It was a dark and stormy night. The End. Storytime::Post2014-12-03 19:29:54.7506212014-12-03 19:29:54.750621 +Storytime::Post +Storytime::Post +Storytime::Post r , 3 1 AA %user43@example.com$2a$04$XTna.zi1WJ/KkNHde6CP3.LO6saDUWHMBfZI8zwpwD2n..0wBxYoC2014-12-03 19:29:53.1342872014-12-03 19:29:53.134287user name 43 1 AA %user61@example.com$2a$04$Xj6KsVvq1h5OEuDH2J/M8OaJdhbuJJ70RvZxz6ll6jB6ooXBe85oy2014-12-03 19:29:54.7573552014-12-03 19:29:54.757355user name 61% 1 AA %user69@example.com$2a$04$FwopTev17BOcJil32rJSeOzJCKNlOhv/nB8RTC5iMt6GYT9HAcISu2014-12-03 19:29:57.7693062014-12-03 19:29:57.769306user name i& 3 AAAA'user143@example.com$2a$04$J5.gZ6JbW.sJXpYaXEQeJu56/Q0Msr.PaO5GfuJb8MNFCUtom90c22014-12-03 19:30:00.3017182014-12-03 19:30:00.301718127.0.0.1127.0.0.12014-12-03 19:30:00.2628612014-12-03 19:30:00.302501Tuser name 143 1user43@example.com1user61@example.com 1user69@example.com3user143@example.com& % & %T& p^L:( )20141111164439)20141021073356)20141020213343)20140916183056)20140813130534 )20140813014447)20140521191744)20140521191728 )20140521191048 )20140521190606)20140516141252)20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341)20141111215653 |iVC0 )20141111164439)20141021073356)20141020213343)20140916183056)20140813130534)20140813014447 )20140521191744)20140521191728)20140521191048 )20140521190606 )20140516141252)20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341) 20141111215653