test/dummy_app/db/test.sqlite3 in active_snapshot-0.2.0 vs test/dummy_app/db/test.sqlite3 in active_snapshot-0.2.1
- old
+ new
@@ -1,41 +1,42 @@
-SQLite format 3 @ & & .0:
;
[
4
-
-' +k 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_usersnapshots
CREATE INDEX "index_snapshots_on_user" ON "snapshots" ("user_type", "user_id")} G !indexindex_snapshots_on_identifiersnapshots CREATE 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)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-03-06 10:31:20.3113002021-03-06 10:31:20.311300
- # environment
< AA2021-03-06 10:35:09.0367652021-03-06 10:35:09.036765
)
snapshots
)snapshot_items posts
+SQLite format 3 @ 2 2 .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
+
0 APostv2--- {}
-2021-03-06 10:35:09.0935210 APostv1--- {}
-2021-03-06 10:35:09.059827
+2021-08-19 23:29:21.1133750 APostv1--- {}
+2021-08-19 23:29:21.092194
Post Post
v2 v1
-
m _A Post---
+
w +A Post---
id: 1
a: 2
b: 4
created_at: !ruby/object:ActiveSupport::TimeWithZone
- utc: 2021-03-06 10:35:09.036765000 Z
- zone: &1 !ruby/object:ActiveSupport::TimeZone
+ utc: &1 2021-08-19 23:29:21.079132000 Z
+ zone: &2 !ruby/object:ActiveSupport::TimeZone
name: Etc/UTC
- time: 2021-03-06 10:35:09.036765000 Z
+ time: 2021-08-19 23:29:21.079132000 Z
updated_at: !ruby/object:ActiveSupport::TimeWithZone
- utc: 2021-03-06 10:35:09.036765000 Z
- zone: *1
- time: 2021-03-06 10:35:09.036765000 Z
-2021-03-06 10:35:09.099915 _A Post---
+ utc: *1
+ zone: *2
+ time: 2021-08-19 23:29:21.079132000 Z
+2021-08-19 23:29:21.117615v +A Post---
id: 1
a: 1
b: 3
created_at: !ruby/object:ActiveSupport::TimeWithZone
- utc: 2021-03-06 10:35:09.036765000 Z
- zone: &1 !ruby/object:ActiveSupport::TimeZone
+ utc: &1 2021-08-19 23:29:21.079132000 Z
+ zone: &2 !ruby/object:ActiveSupport::TimeZone
name: Etc/UTC
- time: 2021-03-06 10:35:09.036765000 Z
+ time: 2021-08-19 23:29:21.079132000 Z
updated_at: !ruby/object:ActiveSupport::TimeWithZone
- utc: 2021-03-06 10:35:09.036765000 Z
- zone: *1
- time: 2021-03-06 10:35:09.036765000 Z
-2021-03-06 10:35:09.084857
+ utc: *1
+ zone: *2
+ time: 2021-08-19 23:29:21.079132000 Z
+2021-08-19 23:29:21.107905
Post Post
\ No newline at end of file