test/dummy_app/db/test.sqlite3 in active_snapshot-0.2.1 vs test/dummy_app/db/test.sqlite3 in active_snapshot-0.2.2
- old
+ new
@@ -1,42 +1,42 @@
-SQLite format 3 @ 2 2 .S`
;
[
4
+SQLite format 3 @ X X .S`
;
[
4
uy< E)=indexindex_snapshot_items_on_itemsnapshot_itemsCREATE INDEX "index_snapshot_items_on_item" ON "snapshot_items" ("item_type", "item_id")S)9indexindex_snapshot_items_on_snapshot_idsnapshot_itemsCREATE INDEX "index_snapshot_items_on_snapshot_id" ON "snapshot_items" ("snapshot_id")&))tablesnapshot_itemssnapshot_itemsCREATE TABLE "snapshot_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "snapshot_id" integer NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "object" text NOT NULL, "created_at" datetime NOT NULL, "child_group_name" varchar){; )indexindex_snapshots_on_usersnapshotsCREATE INDEX "index_snapshots_on_user" ON "snapshots" ("user_type", "user_id")}
G !indexindex_snapshots_on_identifiersnapshotsCREATE INDEX "index_snapshots_on_identifier" ON "snapshots" ("identifier"){ ; )indexindex_snapshots_on_itemsnapshots
CREATE INDEX "index_snapshots_on_item" ON "snapshots" ("item_type", "item_id") tablesnapshotssnapshots CREATE TABLE "snapshots" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "identifier" varchar NOT NULL, "user_type" varchar, "user_id" integer, "metadata" text, "created_at" datetime NOT NULL)d
9indexindex_notes_on_post_idnotes CREATE INDEX "index_notes_on_post_id" ON "notes" ("post_id")F ktablenotesnotes
CREATE TABLE "notes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar, "post_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)p? indexindex_comments_on_post_idcomments CREATE INDEX "index_comments_on_post_id" ON "comments" ("post_id")R wtablecommentscommentsCREATE TABLE "comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "content" varchar, "post_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=YtablepostspostsCREATE TABLE "posts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "a" integer, "b" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)T55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G[5 indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax// tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations
)20210306100122)20210128155312
)20210306100122) 20210128155312
H#AAenvironmenttest2021-08-19 23:28:07.5896592021-08-19 23:28:07.589659
- # environment
< AA2021-08-19 23:29:21.0791322021-08-19 23:29:21.079132
)snapshot_items
snapshots snapshot_items posts
+ # environment
< AA2021-08-27 20:46:45.3377182021-08-27 20:46:45.337718
)snapshot_items
snapshots snapshot_items posts
0 APostv2--- {}
-2021-08-19 23:29:21.1133750 APostv1--- {}
-2021-08-19 23:29:21.092194
+2021-08-27 20:46:45.3695890 APostv1--- {}
+2021-08-27 20:46:45.350182
Post Post
v2 v1
w +A Post---
id: 1
a: 2
b: 4
created_at: !ruby/object:ActiveSupport::TimeWithZone
- utc: &1 2021-08-19 23:29:21.079132000 Z
+ utc: &1 2021-08-27 20:46:45.337718000 Z
zone: &2 !ruby/object:ActiveSupport::TimeZone
name: Etc/UTC
- time: 2021-08-19 23:29:21.079132000 Z
+ time: 2021-08-27 20:46:45.337718000 Z
updated_at: !ruby/object:ActiveSupport::TimeWithZone
utc: *1
zone: *2
- time: 2021-08-19 23:29:21.079132000 Z
-2021-08-19 23:29:21.117615v +A Post---
+ time: 2021-08-27 20:46:45.337718000 Z
+2021-08-27 20:46:45.372362v +A Post---
id: 1
a: 1
b: 3
created_at: !ruby/object:ActiveSupport::TimeWithZone
- utc: &1 2021-08-19 23:29:21.079132000 Z
+ utc: &1 2021-08-27 20:46:45.337718000 Z
zone: &2 !ruby/object:ActiveSupport::TimeZone
name: Etc/UTC
- time: 2021-08-19 23:29:21.079132000 Z
+ time: 2021-08-27 20:46:45.337718000 Z
updated_at: !ruby/object:ActiveSupport::TimeWithZone
utc: *1
zone: *2
- time: 2021-08-19 23:29:21.079132000 Z
-2021-08-19 23:29:21.107905
+ time: 2021-08-27 20:46:45.337718000 Z
+2021-08-27 20:46:45.366180
Post Post
\ No newline at end of file