test/dummy/db/test.sqlite3 in rails_db-2.4.3 vs test/dummy/db/test.sqlite3 in rails_db-2.4.4
- old
+ new
@@ -1,9 +1,9 @@
-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
+SQLite format 3 @ .v
8!P
+F@wI 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") utableprojectsprojects
+CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description_214636" varchar, "description_881927" varchar, "description_377910" varchar, "description_787561" varchar, "description_397939" varchar, "description_427609" varchar, "description_70125" varchar, "description_68088" varchar, "description_211155" varchar, "description_915979" varchar, "description_198834" varchar, "description_669085" varchar, "description_771" varchar, "description_519606" varchar, "description_500107" varchar, "description_277668" varchar, "description_706655" varchar, "description_617984" varchar, "description_312370" varchar, "description_239866" varchar, "amount_777579" integer, "amount_886090" integer, "amount_11955" integer, "amount_494653" integer, "amount_666834" integer, "amount_297923" integer, "amount_458470" integer, "amount_339355" integer, "amount_539001" integer, "amount_209067" integer, "amount_74088" integer, "amount_736364" integer, "amount_685429" integer, "amount_506310" integer, "amount_440103" integer, "amount_418280" integer, "amount_60289" integer, "amount_433505" integer, "amount_160749" integer, "amount_723751" 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
@@ -11,15 +11,12 @@
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
+)20151014184243 )20151015145740)20151027192250)20151027223149)20151028191429)20151121125538)20170126124628)20180528134358) 20210626083314
0
8!P
+F@wI ; ; 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 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") utableprojectsprojects
+CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description_214636" varchar, "description_881927" varchar, "description_377910" varchar, "description_787561" varchar, "description_397939" varchar, "description_427609" varchar, "description_70125" varchar, "description_68088" varchar, "description_211155" varchar, "description_915979" varchar, "description_198834" varchar, "description_669085" varchar, "description_771" varchar, "description_519606" varchar, "description_500107" varchar, "description_277668" varchar, "description_706655" varchar, "description_617984" varchar, "description_312370" varchar, "description_239866" varchar, "amount_777579" integer, "amount_886090" integer, "amount_11955" integer, "amount_494653" integer, "amount_666834" integer, "amount_297923" integer, "amount_458470" integer, "amount_339355" integer, "amount_539001" integer, "amount_209067" integer, "amount_74088" integer, "amount_736364" integer, "amount_685429" integer, "amount_506310" integer, "amount_440103" integer, "amount_418280" integer, "amount_60289" integer, "amount_433505" integer, "amount_160749" integer, "amount_723751" 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_sha1eb07e8bd50a1efed4dd9e6703b0cb4e782fa7a332024-06-07 20:31:53.5877412024-06-07 20:31:53.587743H#AAenvironmenttest2024-06-07 20:31:53.5867652024-06-07 20:31:53.586769
+ #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
Eindexindex_projects_on_deleted_atprojectsCREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at")
\ No newline at end of file