spec/dummy/db/test.sqlite3 in storytime-0.0.4 vs spec/dummy/db/test.sqlite3 in storytime-1.0.0

- old
+ new

@@ -1,30 +1,34 @@ -SQLite format 3@ $ -% I - ;=W>`++wtablestorytime_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, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime)>++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")r++tablestorytime_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)$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_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_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) -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_comments -CREATE INDEX "index_storytime_comments_on_post_id" ON "storytime_comments" ("post_id")h11{tablestorytime_commentsstorytime_comments CREATE TABLE "storytime_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "post_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 LL9"+Apost-43Storytime::Post2014-09-03 15:09:23.3229849!+Apost-42Storytime::Post2014-09-03 15:09:23.304501<+Apost-41Storytime::Post2014-09-03 15:09:23.284442 -@4t\Xstorytime_versionsXstorytime_posts}"storyti+storytime_sites -users7storytime_permissions -1storytime_comments0+storytime_media9/storytime_actionsP+storytime_roles1storytime_versions /friendly_id_slugs+storytime_posts -+post-43Storytime::Post+post-42Storytime::Postpost-41Storytime::Post -+post-43Storytime::Post+post-42Storytime::Postpost-41Storytime::Post - -+Storytime::Post+Storytime::PostStorytime::Post BLP%AAManage Users1f7d472014-09-03 15:15:03.0675672014-09-03 15:15:03.067567TO5AAManage Site Settings47342a2014-09-03 15:15:03.0642202014-09-03 15:15:03.064220WN;AAPublish Own Posts/Pages5030ed2014-09-03 15:15:03.0612932014-09-03 15:15:03.061293aMOAAManage Other People's Posts/Pagesd8a1b12014-09-03 15:15:03.0577942014-09-03 15:15:03.057794 hL#AAComment #142014-09-03 15:09:09.7458322014-09-03 15:09:09.745832J/#AAComment #132014-09-03 15:09:09.7427042014-09-03 15:09:09.742704 -0/ -0/ K9+AAsuccess-kid.jpg2014-09-03 15:15:03.3886302014-09-03 15:15:03.388630 -9 ~=z9 v 5 r>AAAb2014-09-03 14:39:36.5571182014-09-03 14:39:36.557118>@AAb2014-09-03 14:39:36.5526612014-09-03 14:39:36.552661>?AAb2014-09-03 14:39:36.5492852014-09-03 14:39:36.549285>>AAa2014-09-03 14:39:36.5461382014-09-03 14:39:36.546138>=AAb2014-09-03 14:39:36.5410582014-09-03 14:39:36.541058><AAa2014-09-03 14:39:36.5358642014-09-03 14:39:36.535864>;AA`2014-09-03 14:39:36.5312902014-09-03 14:39:36.531290>AAP2014-09-03 15:15:03.0978032014-09-03 15:15:03.097803>AAO2014-09-03 15:15:03.0881182014-09-03 15:15:03.088118>AAM2014-09-03 15:15:03.0829952014-09-03 15:15:03.082995>AAM2014-09-03 15:15:03.0802992014-09-03 15:15:03.080299>AAN2014-09-03 15:15:03.0775202014-09-03 15:15:03.077520>AAN2014-09-03 15:15:03.0750292014-09-03 15:15:03.075029> AAN2014-09-03 15:15:03.0726262014-09-03 15:15:03.072626 -A@?>=<;POMMNNN -bAb@b?a>b=a<`; B c c[" 3q_AAAStorytime::BlogPostPost #43post-43Post #50. It was a dark and stormy night. The End.Post #55. It was a dark and stormy night.2014-09-03 15:09:23.313478f2014-09-03 15:09:23.3161712014-09-03 15:09:23.316171[! 3q_AAAStorytime::BlogPostPost #42post-42Post #49. It was a dark and stormy night. The End.Post #54. It was a dark and stormy night.2014-09-03 15:09:23.292294f2014-09-03 15:09:23.2949822014-09-03 15:09:23.294982 3q_AAAStorytime::BlogPostPost #41post-41Post #48. It was a dark and stormy night. The End.Post #53. It was a dark and stormy night.2014-09-03 15:09:23.274457f2014-09-03 15:09:23.2775232014-09-03 15:09:23.277523 - |;><AAadmin2014-09-03 15:15:03.0538302014-09-03 15:15:03.053830?;AAeditor2014-09-03 15:15:03.0508102014-09-03 15:15:03.050810?:AAwriter2014-09-03 15:15:03.0479712014-09-03 15:15:03.047971 dLK$ %AASite Title 72014-09-03 15:09:07.0195422014-09-03 15:09:07.01954LK1 %AASite Title 42014-09-03 15:15:03.1004842014-09-03 15:15:03.100484 -  _Jb> ) -_ 3 U q > b9 //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_slug //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)h11{tablestorytime_commentsstorytime_comments CREATE 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_comments -CREATE 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_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")c 77etablestorytime_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")r++tablestorytime_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) M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id")  x&9 - =  sxQ73M-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")e5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email"):StableusersusersCREATE 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_i!=//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)`++wtablestorytime_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, "header" text, "footer" text, "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_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_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_versionsCREATE INDEX "index_storytime_versions_on_user_id" ON "storytime_versions" ("user_id")/1Kindexversionable_indexstorytime_versionsCREATE INDEX "versionable_index" ON "storytime_versions" ("versionable_type", "versionable_id"):StableusersusersCREATE 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))e5 indexindex_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) +SQLite format 3@ g'#g-% I + *? 5lh>++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")r++tablestorytime_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)$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_comments CREATE INDEX "index_storytime_comments_on_post_id" ON "storytime_comments" ("post_id")h +11{tablestorytime_commentsstorytime_comments CREATE 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 UU87+Apage-8Storytime::Post2014-10-22 13:34:04.0442677+Apage-7Storytime::Post2014-10-22 13:34:04.0226059+Apage-6Storytime::Post2014-10-22 13:34:03.987911 $ XCzc* 7storytime_permissions +storytime_media  1storytime_commentss +3storytime_autosaves+storytime_posts usersF /friendly_id_slugs1storytime_versionsstorytime_snipp1storytime_snippets+storytime_roles]+storytime_sites"/storytime_actions ++page-8Storytime::Post+page-7Storytime::Postpage-6Storytime::Post ++page-8Storytime::Post+page-7Storytime::Postpage-6Storytime::Post + ++Storytime::Post+Storytime::PostStorytime::Post BET5AAManage Text Snippets5qg25i2014-10-22 13:36:59.9748222014-10-22 13:36:59.974822L%AAManage Users1f7d472014-10-22 13:36:59.9701232014-10-22 13:36:59.970123T5AAManage Site Settings47342a2014-10-22 13:36:59.9657782014-10-22 13:36:59.965778W;AAPublish Own Posts/Pages5030ed2014-10-22 13:36:59.9613322014-10-22 13:36:59.961332aOAAManage Other People's Posts/Pagesd8a1b12014-10-22 13:36:59.9579292014-10-22 13:36:59.957929 we+AATo Sherlock Holmes she wV#+AA<p><br></p>Storytime::Post2014-10-22 13:33:53.0398902014-10-22 13:33:53.039890 ++Storytime::Post nI!AAComment #222014-10-22 13:33:41.6560442014-10-22 13:33:41.656044G!AAComment #142014-10-22 13:33:41.6525902014-10-22 13:33:41.652590 + +24 L+AAsuccess-kid.jpgE2014-10-22 13:34:12.9275702014-10-22 13:34:12.927570 +E @@ =AA]2014-10-22 13:37:00.0064572014-10-22 13:37:00.006457=AA\2014-10-22 13:37:00.0024602014-10-22 13:37:00.002460=AA]2014-10-22 13:36:59.9984832014-10-22 13:36:59.998483=AA]2014-10-22 13:36:59.9956972014-10-22 13:36:59.995697=AA]2014-10-22 13:36:59.9934492014-10-22 13:36:59.993449=AA\2014-10-22 13:36:59.9911022014-10-22 13:36:59.991102=AA]2014-10-22 13:36:59.9884142014-10-22 13:36:59.988414=AA\2014-10-22 13:36:59.9854522014-10-22 13:36:59.985452=AA[2014-10-22 13:36:59.9823742014-10-22 13:36:59.982374 + +]\]]]\]\[ R { {Z 3q_AAA;ST +q_AAA@Storytime::PagePage #8page-8Post #78. It was a dark and stormy night. The End.Post #84. It was a dark and stormy night.2014-10-22 13:34:04.032423f2014-10-22 13:34:04.0362182014-10-22 13:34:04.036218T +q_AAA?Storytime::PagePage #7page-7Post #77. It was a dark and stormy night. The End.Post #83. It was a dark and stormy night.2014-10-22 13:34:04.000979f2014-10-22 13:34:04.0073062014-10-22 13:34:04.007306+q_AAA>Storytime::PagePage #6page-6Post #76. It was a dark and stormy night. The End.Post #82. It was a dark and stormy night.2014-10-22 13:34:03.970614f2014-10-22 13:34:03.9754552014-10-22 13:34:03.975455 +@?> ~>>]AAadmin2014-10-22 13:36:59.9542472014-10-22 13:36:59.954247?\AAeditor2014-10-22 13:36:59.9508322014-10-22 13:36:59.950832?[AAwriter2014-10-22 13:36:59.9471482014-10-22 13:36:59.947148 fLK %AASite Title 82014-10-22 13:33:41.4426972014-10-22 13:33:41.44269LK" %AASite Title 42014-10-22 13:37:00.0220442014-10-22 13:37:00.022044 WBZ69 +S + Q 7 h>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id>++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") //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_comments CREATE 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_comments CREATE 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")r++tablestorytime_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) @ +- + 1 & /1Kindexversionable_indexstorytime_versions!CREATE INDEX "versionable_index" ON "storytime_versions" ("versionable_type", "versionable_id")S19indexindex_storytime_versions_on_user_idstorytime_versions CREATE INDEX "index_storyti$=//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)"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 5 indexindex_users_on_emailusers#CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id")>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)`++wtablestorytime_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, "header" text, "footer" text, "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)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_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"):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)) +" .gUAAsnippet-7Snippet #7. Fortune favors the bold.2014-10-22 13:37:04.0289922014-10-22 13:37:04.028992gUAAsnippet-6Snippet #6. Fortune favors the bold.2014-10-22 13:37:04.0248512014-10-22 13:37:04.024851iUAAsnippet-5Snippet #5. Fortune favors the bold.2014-10-22 13:37:04.0204262014-10-22 13:37:04.020426   -  zz"q+AAPost #50. It was a dark and stormy night. The End.Storytime::Post2014-09-03 15:09:23.3188922014-09-03 15:09:23.318892!q+AAPost #49. It was a dark and stormy night. The End.Storytime::Post2014-09-03 15:09:23.2972992014-09-03 15:09:23.297299q+AAPost #48. It was a dark and stormy night. The End.Storytime::Post2014-09-03 15:09:23.2800662014-09-03 15:09:23.280066 - -+Storytime::Post+Storytime::PostStorytime::Post v $!3AA'user116@example.com$2a$04$qzaDqAZkVwCM/UmxlhRUy.VIl93WQXVoMUYlaMkT0HpAgwdGKdO1m2014-09-03 15:09:23.3108782014-09-03 15:09:23.310878user name 116!3AA'user115@example.com$2a$04$RGyndxKspZHgg5KQ1SPLUu5BGdPbkd7uqdR29DNQt2g4ndijqO7P62014-09-03 15:09:23.2897162014-09-03 15:09:23.289716user name 115!3#/AA#user7@example.com$2a$04$o4jBZJF8Rgll2Kb0akXMLexTmMsyUM2i3oSXm0lIRNmCt3hWDFYAi2014-09-03 15:15:01.9797472014-09-03 15:15:01.979747user name 7e$/ AAAA#user8@example.com$2a$04$rvR9vjoHBPeKFOycYBtrnOmGmfkbjp1SsJ4VocedBWQgaxtZWuAn.2014-09-03 15:15:03.1712282014-09-03 15:15:03.171228127.0.0.1127.0.0.12014-09-03 15:15:03.1065292014-09-03 15:15:03.171762user name 8 -3user116@example.com3user115@example.com3/user7@example.com/user8@example.com - - )20140530185250)20140813130534 -)20140530185250) 20140813130534 +  ~q+AAPost #78. It was a dark and stormy night. The End.Storytime::Post2014-10-22 13:34:04.0390952014-10-22 13:34:04.039095~q+AAPost #77. It was a dark and stormy night. The End.Storytime::Post2014-10-22 13:34:04.0146932014-10-22 13:34:04.014693q+AAPost #76. It was a dark and stormy night. The End.Storytime::Post2014-10-22 13:34:03.9802462014-10-22 13:34:03.980246 + ++Storytime::Post+Storytime::PostStorytime::Post q )!@3AA'user150@example.com$2a$04$Nh52mHyEsASaUqdo23DVzOM1trFVaugKWmjXVayWxu8yTQ4gOwtSu2014-10-22 13:34:04.0291772014-10-22 13:34:04.029177user name 150!?3AA'user149@example.com$2a$04$E1oGPngQIy2BkJkoU8jlU.IWMQFmG5Zw3PPzVuU9vTylipMP7MMDy2014-10-22 13:34:03.9959352014-10-22 13:34:03.995935user name 149!E3AA'user165@example.com$2a$04$beDypquNIAYOf3WUlS2GYu8ETkWs6AUZg8CBgdBMLtKiaIg8J/tsi2014-10-22 13:34:12.9189402014-10-22 13:34:12.918940user name 165hDdF/ AAAA#user4@example.com$2a$04$kpSZ4mTv5W7.IvPcF6TWM.GeB26HNNC0THyCz9nBPv0nOZ17S8qYy2014-10-22 13:37:03.5043452014-10-22 13:37:03.504345127.0.0.1127.0.0.12014-10-22 13:37:00.0168072014-10-22 13:37:03.506961]user name 4 +3user150@example.com@3user149@example.com?3user165@example.comE/user4@example.comF +@?EF +@?E]F p^L:()20140916183056)20140813130534)20140813014447 )20140521191744 )20140521191728 )20140521191048 +)20140521190606 )20140516141252)20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341)20140530185250)20141021073356 +|iVC0 +)20140916183056)20140813130534)20140813014447)20140521191744 )20140521191728 )20140521191048 )20140521190606 +)20140516141252 )20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341)20140530185250) 20141021073356 \ No newline at end of file