spec/dummy/db/test.sqlite3 in storytime-1.1.1 vs spec/dummy/db/test.sqlite3 in storytime-1.2.0

- old
+ new

@@ -1,31 +1,63 @@ +SQLite format 3@ 7($7- 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_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 RR8+Apost-63"Storytime::Post2015-02-04 21:42:04.1735778+Apost-62!Storytime::Post2015-02-04 21:42:04.160; !+Asnow-crash#Storytime::Post2015-02-04 21:42:07.171879  cXxA,!storytime_actions<"s}!7storytime_permissionsh 1storytime_comments ++storytime_media  /friendly_id_slugs users\+storytime_rolesl3storytime_autosaves+storytime_posts$storytime_sites%+storytime_sites(/storytime_actions1storytime_versions$ ++post-63Storytime::Post+post-62Storytime::Po!+snow-crashStorytime::Post ++post-63Storytime::Post+post-62Storytime::Po!+snow-crashStorytime::Post +"!# ++Storytime::Post+Storytime::Post+Storytime::Post BE ZXAAAManage Email Subscriptionsd29d762015-02-04 21:42:14.2285312015-02-04 21:42:14.228531TW5AAManage Text Snippets5qg25i2015-02-04 21:42:14.2261182015-02-04 21:42:14.226118LV%AAManage Users1f7d472015-02-04 21:42:14.2237282015-02-04 21:42:14.223728TU5AAManage Site Settings47342a2015-02-04 21:42:14.2211902015-02-04 21:42:14.221190WT;AAPublish Own Posts/Pages5030ed2015-02-04 21:42:14.2186452015-02-04 21:42:14.218645aSOAAManage Other People's Posts/Pagesd8a1b12015-02-04 21:42:14.2160872015-02-04 21:42:14.216087 !+AA<p>The Deliverator bewe+AATo Sherlock Holmes she was always the woman.$Storytime::Post2015-02-04 21:42:08.8894722015-02-04 21:42:08.889472 ++Storytime::Post$ nI!AAComment #6J2015-02-04 21:41:58.7450442015-02-04 21:41:58.745044G!AAComment #5L2015-02-04 21:41:58.7427882015-02-04 21:41:58.742788 + +JL J +AAsuccess-kid.jpg\2015-02-04 21:42:14.5976572015-02-04 21:42:14.597657 +\ @@ =hAAl2015-02-04 21:42:14.2541362015-02-04 21:42:14.254136=gAAl2015-02-04 21:42:14.2520662015-02-04 21:42:14.252066=fAAk2015-02-04 21:42:14.2501802015-02-04 21:42:14.250180=eAAl2015-02-04 21:42:14.2481582015-02-04 21:42:14.248158=dAAl2015-02-04 21:42:14.2463112015-02-04 21:42:14.246311=cAAl2015-02-04 21:42:14.2441222015-02-04 21:42:14.244122=bAAk2015-02-04 21:42:14.2419002015-02-04 21:42:14.241900=aAAl2015-02-04 21:42:14.2398732015-02-04 21:42:14.239873=`AAk2015-02-04 21:42:14.2379282015-02-04 21:42:14.237928=_AAj2015-02-04 21:42:14.2355492015-02-04 21:42:14.235549 +hgfedcba`_ +lhlgkfleldlckblak`j_ 7 f f["3q_AAATStorytime::BlogPostPost #63post-63Post #97. It was a dark and stormy night. The End.Post #97. It was a dark and stormy night.2015-02-04 21:42:04.167459f2015-02-04 21:42:04.1695672015-02-04 21:42:04.169567[!3q_AAASStorytime::BlogPostPost #62post-62Post #96. It was a dark and stormy night. The End.Post #96. It was a dark and stormy night.2015-02-04 21:42:04.153004f2015-02-04 21:42:04.1555192015-02-04 21:42:04.1555193q_AAARStoF$35q_AAWStorytime::BlogPostA Scandal in BohemiaPost #95. It was a dark and stormy night. The End.Post #98. It was a dark and stormy night.f2015-02-04 21:42:07.6772932015-02-04 21:42:07.677293 +T"S!W$ ~>>lAAadmin2015-02-04 21:42:14.2135432015-02-04 21:42:14.213543?kAAeditor2015-02-04 21:42:14.2113862015-02-04 21:42:14.211386?jAAwriter2015-02-04 21:42:14.2090402015-02-04 21:42:14.209040 JJX[ +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_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")++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") hJ! 'AASite Title 142015-02-04 21:41:58.5291462015-02-04 21:41:58.529146J( 'AASite Title 442015-02-04 21:42:14.2562252015-02-04 21:42:14.256225 !'9 + =  sn#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 in%=//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)";;[tablestorytime_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, "site_id" integer)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!5 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) +!(    + +  ~"q+AAPost #97. It was a dark and stormy night. The End."Storytime::Post2015-02-04 21:42:04.1711372015-02-04 21:42:04.171137~!q+AAPost #96. It was a dark and stormy night. The End.!Storytime::Post2015-02-04 21:42:04.15734# !+AA<p>The Deliverator bex$e+AATo Sherlock Holmes she was always the woman.$Storytime::Post2015-02-04 21:42:07.6791332015-02-04 21:42:07.679133 +"$ ++Storytime::Post""+Storytime::Post!!+Storytime::Post$$ q )!T3AA'user150@example.com$2a$04$juOjuvuDlxjJjayTNBQjhudkiPxIba.o0xuqbO1qeR1rtRbm47pMe2015-02-04 21:42:04.1655282015-02-04 21:42:04.165528user name 150!S3AA'user149@example.com$2a$04$IdH5Mm6IXAHZVGiVcz9bA.6hHWOOR9xc0lCXF82XoCRUA/4RU1...2015-02-04 21:42:04.1510452015-02-04 21:42:04.151045user name 149![3AA'user208@example.com$2a$04$v8jZ.1s.xXZ5Uvg3DPH8uOY20D5TnYmFY/G3xy2MR/m82TABVpDYi2015-02-04 21:42:13.5820722015-02-04 21:42:13.582072user name 208h\3 AAAA'user209@example.com$2a$04$aEPrHtmEr1vic1m4qJDb..X1rzcdmFVBRwbwFS8o0lT9N6t1xHnXO2015-02-04 21:42:14.4025892015-02-04 21:42:14.402589127.0.0.1127.0.0.12015-02-04 21:42:14.3582692015-02-04 21:42:14.402939juser name 209 +3user150@example.comT3user149@example.comS3user208@example.com[3user209@example.com\ +TS[\ +TS[j\ p^L:()20150122200805)20141111164439)20141021073356)20141020213343)20140916183056)20140813130534 )20140813014447 )20140521191744 )20140521191728 +)20140521191048 )20140521190606)20140516141252)20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341)20150129215308 +|iVC0 +)20150122200805)20141111164439)20141021073356)20141020213343)20140916183056)20140813130534)20140813014447 )20140521191744 )20140521191728 )20140521191048 +)20140521190606 )20140516141252)20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341) 20150129215308 \ No newline at end of file