test/dummy/db/test.sqlite3 in rails_db-2.4.2 vs test/dummy/db/test.sqlite3 in rails_db-2.4.3
- old
+ new
@@ -1,22 +1,25 @@
-SQLite format 3 @ .f
8!P
-C=tF AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations a7indexindex_users_on_salaryusersCREATE INDEX "index_users_on_salary" ON "users" ("salary")Z3yindexindex_users_on_nameusersCREATE INDEX "index_users_on_name" ON "users" ("name")m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id");UtableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "salary" decimal, "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 1, "type" varchar, "country" varchar)
K))indexindex_projects_users_on_user_idprojects_usersCREATE INDEX "index_projects_users_on_user_id" ON "projects_users" ("user_id")Q)5indexindex_projects_users_on_project_idprojects_users
CREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")p))tableprojects_usersprojects_usersCREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y
-Eindexindex_projects_on_deleted_atprojectsCREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at") {tableprojectsprojects
-CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description_245592" varchar, "description_450580" varchar, "description_183349" varchar, "description_341325" varchar, "description_277196" varchar, "description_943405" varchar, "description_904897" varchar, "description_267877" varchar, "description_47807" varchar, "description_713494" varchar, "description_696562" varchar, "description_976508" varchar, "description_918800" varchar, "description_27002" varchar, "description_393763" varchar, "description_960166" varchar, "description_804457" varchar, "description_684568" varchar, "description_98716" varchar, "description_337791" varchar, "amount_584190" integer, "amount_898177" integer, "amount_599511" integer, "amount_308345" integer, "amount_572259" integer, "amount_562080" integer, "amount_684853" integer, "amount_77648" integer, "amount_377109" integer, "amount_246825" integer, "amount_91844" integer, "amount_787673" integer, "amount_158730" integer, "amount_331843" integer, "amount_540084" integer, "amount_780019" integer, "amount_745694" integer, "amount_715202" integer, "amount_887110" integer, "amount_607339" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)yEindexindex_payments_on_project_idpayments CREATE INDEX "index_payments_on_project_id" ON "payments" ("project_id")NotablepaymentspaymentsCREATE TABLE "payments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal, "project_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
++Qtablelegacy_accountslegacy_accountsCREATE TABLE "legacy_accounts" ("uuid" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)M+indexindex_contacts_on_name_and_emailcontactsCREATE INDEX "index_contacts_on_name_and_email" ON "contacts" ("name", "email")WtablecontactscontactsCREATE TABLE "contacts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)IetablecommentscommentsCREATE TABLE "comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "comment" text, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MmtableaccountsaccountsCREATE TABLE "accounts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "users_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT
+SQLite format 3 @ .v
8!L
+<6i; AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations a7indexindex_users_on_salaryusersCREATE INDEX "index_users_on_salary" ON "users" ("salary")Z3yindexindex_users_on_nameusersCREATE INDEX "index_users_on_name" ON "users" ("name")m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id")?]tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "salary" decimal(10), "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 1, "type" varchar, "country" varchar)
K))indexindex_projects_users_on_user_idprojects_usersCREATE INDEX "index_projects_users_on_user_id" ON "projects_users" ("user_id")Q)5indexindex_projects_users_on_project_idprojects_users
CREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")p))tableprojects_usersprojects_usersCREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y
+Eindexindex_projects_on_deleted_atprojectsCREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at") tableprojectsprojects
+CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description_524218" varchar, "description_582477" varchar, "description_910553" varchar, "description_181360" varchar, "description_637048" varchar, "description_920060" varchar, "description_125376" varchar, "description_72387" varchar, "description_457825" varchar, "description_858192" varchar, "description_292867" varchar, "description_986009" varchar, "description_293297" varchar, "description_733485" varchar, "description_248137" varchar, "description_273482" varchar, "description_520504" varchar, "description_785302" varchar, "description_224435" varchar, "description_235085" varchar, "amount_97144" integer, "amount_116203" integer, "amount_394760" integer, "amount_542072" integer, "amount_986307" integer, "amount_571123" integer, "amount_344510" integer, "amount_434757" integer, "amount_728495" integer, "amount_878167" integer, "amount_518288" integer, "amount_767100" integer, "amount_119368" integer, "amount_793397" integer, "amount_206014" integer, "amount_693084" integer, "amount_230674" integer, "amount_341979" integer, "amount_466015" integer, "amount_128321" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)yEindexindex_payments_on_project_idpayments CREATE INDEX "index_payments_on_project_id" ON "payments" ("project_id")RwtablepaymentspaymentsCREATE TABLE "payments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(10), "project_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
++Qtablelegacy_accountslegacy_accountsCREATE TABLE "legacy_accounts" ("uuid" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)M+indexindex_contacts_on_name_and_emailcontactsCREATE INDEX "index_contacts_on_name_and_email" ON "contacts" ("name", "email")WtablecontactscontactsCREATE TABLE "contacts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)IetablecommentscommentsCREATE TABLE "comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "comment" text, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MmtableaccountsaccountsCREATE TABLE "accounts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "users_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT
-
p^L:( )20180528134358)20170126124628)20151121125538
)20151028191429)20151027223149)20151027192250
-)20151015145740 )20151014184243)20151014183823)20151014152932)20151014074655)20151014074454)20151013204027)20151013203757)20151013203739)20210626083314
- |iVC0
- )20180528134358)20170126124628)20151121125538)20151028191429
)20151027223149)20151027192250)20151015145740
-)20151014184243 )20151014183823)20151014152932)20151014074655)20151014074454)20151013204027)20151013203757)20151013203739) 20210626083314
0
8!P
-C=tF 8 8 [5 indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata =//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations a7indexindex_users_on_salaryusersCREATE INDEX "index_users_on_salary" ON "users" ("salary")Z3yindexindex_users_on_nameusersCREATE INDEX "index_users_on_name" ON "users" ("name")m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id");UtableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "salary" decimal, "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 1, "type" varchar, "country" varchar)
K))indexindex_projects_users_on_user_idprojects_usersCREATE INDEX "index_projects_users_on_user_id" ON "projects_users" ("user_id")Q)5indexindex_projects_users_on_project_idprojects_users
CREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")p))tableprojects_usersprojects_usersCREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y
-Eindexindex_projects_on_deleted_atprojectsCREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at") {tableprojectsprojects
-CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description_245592" varchar, "description_450580" varchar, "description_183349" varchar, "description_341325" varchar, "description_277196" varchar, "description_943405" varchar, "description_904897" varchar, "description_267877" varchar, "description_47807" varchar, "description_713494" varchar, "description_696562" varchar, "description_976508" varchar, "description_918800" varchar, "description_27002" varchar, "description_393763" varchar, "description_960166" varchar, "description_804457" varchar, "description_684568" varchar, "description_98716" varchar, "description_337791" varchar, "amount_584190" integer, "amount_898177" integer, "amount_599511" integer, "amount_308345" integer, "amount_572259" integer, "amount_562080" integer, "amount_684853" integer, "amount_77648" integer, "amount_377109" integer, "amount_246825" integer, "amount_91844" integer, "amount_787673" integer, "amount_158730" integer, "amount_331843" integer, "amount_540084" integer, "amount_780019" integer, "amount_745694" integer, "amount_715202" integer, "amount_887110" integer, "amount_607339" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)yEindexindex_payments_on_project_idpayments CREATE INDEX "index_payments_on_project_id" ON "payments" ("project_id")NotablepaymentspaymentsCREATE TABLE "payments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal, "project_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
++Qtablelegacy_accountslegacy_accountsCREATE TABLE "legacy_accounts" ("uuid" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)M+indexindex_contacts_on_name_and_emailcontactsCREATE INDEX "index_contacts_on_name_and_email" ON "contacts" ("name", "email")WtablecontactscontactsCREATE TABLE "contacts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)IetablecommentscommentsCREATE TABLE "comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "comment" text, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MmtableaccountsaccountsCREATE TABLE "accounts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "users_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
H H l#]AAschema_sha1435b916cd0980f6986e43360de54a86fa2ce09b62023-05-12 09:44:09.5368222023-05-12 09:44:09.536822H#AAenvironmenttest2023-05-12 09:44:09.5332252023-05-12 09:44:09.533225
- #schema_sha1# environment
G
- G[5 indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataT55Ktablear_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)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)a7indexindex_users_on_salaryusersCREATE INDEX "index_users_on_salary" ON "users" ("salary")Z3yindexindex_users_on_nameusersCREATE INDEX "index_users_on_name" ON "users" ("name")m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id");UtableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "salary" decimal, "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 1, "type" varchar, "country" varchar)
K))indexindex_projects_users_on_user_idprojects_usersCREATE INDEX "index_projects_users_on_user_id" ON "projects_users" ("user_id")Q)5indexindex_projects_users_on_project_idprojects_users
CREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")p))tableprojects_usersprojects_usersCREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y
+
p^L:( )20151013203739)20151013203757)20151013204027
)20151014074454)20151014074655)20151014152932
+)20151014183823 )20151014184243)20151015145740)20151027192250)20151027223149)20151028191429)20151121125538)20170126124628)20180528134358)20210626083314
+
+0CVi| )20151013203739)20151013203757)20151013204027)20151014074454
)20151014074655)20151014152932)20151014183823
+)20151014184243 )20151015145740)20151027192250)20151027223149)20151028191429)20151121125538)20170126124628)20180528134358) 20210626083314
0
8!L
+<6i; v 3 x//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations a7indexindex_users_on_salaryusersCREATE INDEX "index_users_on_salary" ON "users" ("salary")Z3yindexindex_users_on_nameusersCREATE INDEX "index_users_on_name" ON "users" ("name")m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id")?]tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "salary" decimal(10), "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 1, "type" varchar, "country" varchar)
K))indexindex_projects_users_on_user_idprojects_usersCREATE INDEX "index_projects_users_on_user_id" ON "projects_users" ("user_id")Q)5indexindex_projects_users_on_project_idprojects_users
CREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")p))tableprojects_usersprojects_usersCREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y
+Eindexindex_projects_on_deleted_atprojectsCREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at") tableprojectsprojects
+CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description_524218" varchar, "description_582477" varchar, "description_910553" varchar, "description_181360" varchar, "description_637048" varchar, "description_920060" varchar, "description_125376" varchar, "description_72387" varchar, "description_457825" varchar, "description_858192" varchar, "description_292867" varchar, "description_986009" varchar, "description_293297" varchar, "description_733485" varchar, "description_248137" varchar, "description_273482" varchar, "description_520504" varchar, "description_785302" varchar, "description_224435" varchar, "description_235085" varchar, "amount_97144" integer, "amount_116203" integer, "amount_394760" integer, "amount_542072" integer, "amount_986307" integer, "amount_571123" integer, "amount_344510" integer, "amount_434757" integer, "amount_728495" integer, "amount_878167" integer, "amount_518288" integer, "amount_767100" integer, "amount_119368" integer, "amount_793397" integer, "amount_206014" integer, "amount_693084" integer, "amount_230674" integer, "amount_341979" integer, "amount_466015" integer, "amount_128321" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)yEindexindex_payments_on_project_idpayments CREATE INDEX "index_payments_on_project_id" ON "payments" ("project_id")RwtablepaymentspaymentsCREATE TABLE "payments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(10), "project_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
++Qtablelegacy_accountslegacy_accountsCREATE TABLE "legacy_accounts" ("uuid" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)M+indexindex_contacts_on_name_and_emailcontactsCREATE INDEX "index_contacts_on_name_and_email" ON "contacts" ("name", "email")WtablecontactscontactsCREATE TABLE "contacts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)IetablecommentscommentsCREATE TABLE "comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "comment" text, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MmtableaccountsaccountsCREATE TABLE "accounts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "users_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
H H l#]AAschema_sha129b9f7b5a14e08cdbc50055bbd896c514a644e242024-06-06 10:57:11.9045052024-06-06 10:57:11.904509H#AAenvironmenttest2024-06-06 10:57:11.9031672024-06-06 10:57:11.903172
+ #schema_sha1# environment
+
C
+
+
+v 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_metadata AU/ indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)a7indexindex_users_on_salaryusersCREATE INDEX "index_users_on_salary" ON "users" ("salary")Z3yindexindex_users_on_nameusersCREATE INDEX "index_users_on_name" ON "users" ("name")m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id")?]tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "salary" decimal(10), "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 1, "type" varchar, "country" varchar)
K))indexindex_projects_users_on_user_idprojects_usersCREATE INDEX "index_projects_users_on_user_id" ON "projects_users" ("user_id")Q)5indexindex_projects_users_on_project_idprojects_users
CREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")p))tableprojects_usersprojects_usersCREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y
Eindexindex_projects_on_deleted_atprojectsCREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at")
\ No newline at end of file