test/dummy/db/test.sqlite3 in rails_db-2.4.1 vs test/dummy/db/test.sqlite3 in rails_db-2.4.2

- old
+ new

@@ -1,16 +1,22 @@ -SQLite format 3@ - -      -  !08! ++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)  /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, "descriptio yEindexindex_payments_on_project_idpayments CREATE INDEX "index_payments_on_project_id" ON "payments" ("project_id")Notablepaymentspayments CREATE TABLE "payments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal, "project_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) - n_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) -  - - 4l4u*mlm?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_usersCREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")  - - - p^L:()20180528134358)20170126124628)20151121125538 )20151028191429 )20151027223149 )20151027192250 +SQLite format 3@ .f 8 ! P +C=tFAU/indexsqlite_autoindex_schema_migrations_1schema_migrationsa7indexindex_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_users CREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y +Eindexindex_projects_on_deleted_atprojects CREATE 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      +   +  +  + +  + + + 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 HHl#]AAschema_sha1435b916cd0980f6986e43360de54a86fa2ce09b62021-06-26 08:39:35.6547522021-06-26 08:39:35.654752H#AAenvironmenttest2021-06-26 08:39:35.6509782021-06-26 08:39:35.650978 -#schema_sha1# environment |\A\3T55Ktablear_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[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataAU/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") +|iVC0 +)20180528134358)20170126124628)20151121125538)20151028191429 )20151027223149 )20151027192250 )20151015145740 +)20151014184243 )20151014183823)20151014152932)20151014074655)20151014074454)20151013204027)20151013203757)20151013203739) 20210626083314 0 8 ! P +C=tF88[5indexsqlite_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_migrationsa7indexindex_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_users CREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y +Eindexindex_projects_on_deleted_atprojects CREATE 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) HHl#]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[5indexsqlite_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_users CREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)y +Eindexindex_projects_on_deleted_atprojects CREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at") \ No newline at end of file