spec/dummy/db/test.sqlite3 in dirty_seed-0.1.8 vs spec/dummy/db/test.sqlite3 in dirty_seed-0.2.0
- old
+ new
@@ -1,37 +1,33 @@
-SQLite format 3 @ ' .?
+SQLite format 3 @ & .?
-
-L p^L
-)20200923100336 )20200923100335)20200923100334)20200923100332)20200923100331)20200923100330)20200923100329)20200923100328)20200923100317)20200923100337
-
-C |iVC )20200923100336
-)20200923100335 )20200923100334)20200923100332)20200923100331)20200923100330)20200923100329)20200923100328)20200923100317) 20200923100337
e Y0
-/Q}t [ [ p ? indexindex_julietts_on_aec p? indexindex_charlies_on_alfa_idcharliesCREATE INDEX "index_charlies_on_alfa_id" ON "charlies" ("alfa_id")2CtablekiloskilosCREATE TABLE "kilos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "encrypted_password" varchar, "reset_password_token" varchar, "reset_password_sent_at" varchar, "remember_created_at" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
-/ < Ktablefoxtrotsfoxtrots CREATE TABLE "foxtrots" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)%
+
^ p^ )20200923100335)20200923100334)20200923100332)20200923100331)20200923100330)20200923100329)20200923100328)20200923100317)20200923100336
+ V |iV )20200923100335 )20200923100334)20200923100332)20200923100331)20200923100330)20200923100329)20200923100328)20200923100317) 20200923100336
$ B
{
+$ QPv ? z C ( p? indexindex_charlies_on_alfa_idcharliesCREATE INDEX "index_charlies_on_alfa_id" ON "charlies" ("alfa_id") ~ < Ktablefoxtrotsfoxtrots CREATE TABLE "foxtrots" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)%
e[indexindex_echos_on_echoable_type_and_echoable_idechos CREATE INDEX "index_echos_on_echoable_type_and_echoable_id" ON "echos" ("echoable_type", "echoable_id")S tableechosechos
-CREATE TABLE "echos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "echoable_type" varchar, "echoable_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) utablecharliescharliesCREATE TABLE "charlies" ("id" integer NOT NULL PRIMARY KEY, "alfa_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_c22432acee"
+CREATE TABLE "echos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "echoable_type" varchar, "echoable_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)_tabledeltasdeltasCREATE TABLE "deltas" ("id" integer NOT NULL PRIMARY KEY, "bravo_id" integer NOT NULL, "zed_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_aa131d729d"
+FOREIGN KEY ("bravo_id")
+ REFERENCES "bravos" ("id")
+, CONSTRAINT "fk_rails_afc1a9c87d"
+FOREIGN KEY ("zed_id")
+ REFERENCES "charlies" ("id")
+)- -tablecharliescharliesCREATE TABLE "charlies" ("id" integer NOT NULL PRIMARY KEY, "alfa_id" integer NOT NULL, "a_json" json DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_c22432acee"
FOREIGN KEY ("alfa_id")
REFERENCES "alfas" ("id")
-)4CtablebravosbravosCREATE TABLE "bravos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "a_boolean" boolean DEFAULT 0 NOT NULL, "an_integer" integer NOT NULL, "a_decimal" decimal NOT NULL, "a_string" varchar NOT NULL, "a_unique_value" integer, "a_string_from_options" varchar, "an_integer_from_options" integer, "an_absent_value" varchar, "a_regex" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq),7tablealfasalfasCREATE TABLE "alfas" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "a_boolean" boolean, "an_integer" integer, "a_decimal" decimal, "a_string" varchar, "a_date" date, "a_time" time, "a_datetime" datetime, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
{
%
- Oc T 55Ktablear_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_metadata A U/ indexsqlite_autoindex_schema_migrations_1schema_migrationsx // tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)p ? indexindex_julietts_on_alfa_idjuliettsCREATE INDEX "index_julietts_on_alfa_id" ON "julietts" ("alfa_id")U }tablejuliettsjuliettsCREATE TABLE "julietts" ("id" integer NOT NULL PRIMARY KEY, "alfa_id" integer NOT NULL, "a_string" varchar DEFAULT NULL, "an_integer" integer DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_996fd14f94"
+)g)tablebravosbravosCREATE TABLE "bravos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "a_boolean" boolean DEFAULT 0 NOT NULL, "an_integer" integer NOT NULL, "a_decimal" decimal NOT NULL, "a_string" varchar NOT NULL, "a_unique_value" integer, "a_string_from_options" varchar, "an_integer_from_options" integer, "an_absent_value" varchar, "a_regex" varchar, "an_enum" integer, "a_json" json, "an_array" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq);UtablealfasalfasCREATE TABLE "alfas" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "a_boolean" boolean, "an_integer" integer, "a_decimal" decimal, "a_string" varchar, "a_date" date, "a_time" time, "a_datetime" datetime, "type" varchar, "encrypted_password" varchar, "reset_password_token" varchar, "reset_password_sent_at" varchar, "remember_created_at" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
H H l#]AAschema_sha17eb0d16b485970ee029ff41f92ca5c8535d7e5ad2020-11-27 21:22:27.1418202020-11-27 21:22:27.141820H#AAenvironmenttest2020-11-27 21:22:27.1389102020-11-27 21:22:27.138910
+ #schema_sha1# environment
} ,
,
+
+b } T T 55Ktablear_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_metadata A U/ indexsqlite_autoindex_schema_migrations_1schema_migrationsx // tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)p ? indexindex_julietts_on_alfa_idjuliettsCREATE INDEX "index_julietts_on_alfa_id" ON "julietts" ("alfa_id")U }tablejuliettsjuliettsCREATE TABLE "julietts" ("id" integer NOT NULL PRIMARY KEY, "alfa_id" integer NOT NULL, "a_string" varchar DEFAULT NULL, "an_integer" integer DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_996fd14f94"
FOREIGN KEY ("alfa_id")
REFERENCES "alfas" ("id")
-)k=
indexindex_indias_on_hotel_idindiasCREATE INDEX "index_indias_on_hotel_id" ON "indias" ("hotel_id")wtableindiasindiasCREATE TABLE "indias" ("id" integer NOT NULL PRIMARY KEY, "hotel_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_304a9d92d0"
+)k=
indexindex_indias_on_hotel_idindiasCREATE INDEX "index_indias_on_hotel_id" ON "indias" ("hotel_id")wtableindiasindiasCREATE TABLE "indias" ("id" integer NOT NULL PRIMARY KEY, "hotel_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_304a9d92d0"
FOREIGN KEY ("hotel_id")
REFERENCES "hotels" ("id")
-)k=
indexindex_hotels_on_india_idhotelsCREATE INDEX "index_hotels_on_india_id" ON "hotels" ("india_id")tablehotelshotels
CREATE TABLE "hotels" ("id" integer NOT NULL PRIMARY KEY, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "india_id" integer DEFAULT NULL, CONSTRAINT "fk_rails_2d98147578"
+)k=
indexindex_hotels_on_india_idhotelsCREATE INDEX "index_hotels_on_india_id" ON "hotels" ("india_id")tablehotelshotels
CREATE TABLE "hotels" ("id" integer NOT NULL PRIMARY KEY, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "india_id" integer DEFAULT NULL, CONSTRAINT "fk_rails_2d98147578"
FOREIGN KEY ("india_id")
REFERENCES "indias" ("id")
-)e9indexindex_deltas_on_zed_iddeltas CREATE INDEX "index_deltas_on_zed_id" ON "deltas" ("zed_id")k=
indexindex_deltas_on_bravo_iddeltasCREATE INDEX "index_deltas_on_bravo_id" ON "deltas" ("bravo_id")_tabledeltasdeltasCREATE TABLE "deltas" ("id" integer NOT NULL PRIMARY KEY, "bravo_id" integer NOT NULL, "zed_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_aa131d729d"
-FOREIGN KEY ("bravo_id")
- REFERENCES "bravos" ("id")
-, CONSTRAINT "fk_rails_afc1a9c87d"
-FOREIGN KEY ("zed_id")
- REFERENCES "charlies" ("id")
-)
H H l#]AAschema_sha18da89cf4033f562695944832d9ed75fccfe8ddec2020-11-24 16:00:33.3565642020-11-24 16:00:33.356564H#AAenvironmenttest2020-11-24 16:00:33.3528252020-11-24 16:00:33.352825
- #schema_sha1# environment
+)e9indexindex_deltas_on_zed_iddeltas CREATE INDEX "index_deltas_on_zed_id" ON "deltas" ("zed_id")k=
indexindex_deltas_on_bravo_iddeltasCREATE INDEX "index_deltas_on_bravo_id" ON "deltas" ("bravo_id")
\ No newline at end of file