spec/dummy/db/test.sqlite3 in storytime-1.0.5 vs spec/dummy/db/test.sqlite3 in storytime-1.0.6
- old
+ new
@@ -1,36 +1,52 @@
-SQLite format 3 @ ( ( $ ( - I
+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 9q + Apost-69 Storytime::Post2014-11-24 17:17:46.2454139p + Apost-68 Storytime::Post2014-11-24 17:17:46.232842 ;+ Apost-67 Storytime::Post2014-11-24 17:17:46.220734
BqX* '