test/dummy/db/test.sqlite3 in rails_db-2.4.0 vs test/dummy/db/test.sqlite3 in rails_db-2.4.1
- old
+ new
@@ -1,16 +1,16 @@
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") utableprojectsprojectsCREATE 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, "descrip
yEindexindex_payments_on_project_idpaymentsCREATE 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)
-
tion_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)
+
! 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") {tableprojectsprojectsCREATE 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_idpaymentsCREATE 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)
-
G lG = l 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, "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 1, "type" 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")
+
4 l4 u * m l 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_usersCREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")
-
p^L:( )20170126124628)20151121125538
)20151028191429)20151027223149)20151027192250
-)20151015145740 )20151014184243)20151014183823)20151014152932)20151014074655)20151014074454)20151013204027)20151013203757)20151013203739)20180528134358
- |iVC0
- )20170126124628)20151121125538)20151028191429
)20151027223149)20151027192250)20151015145740
-)20151014184243 )20151014183823)20151014152932)20151014074655)20151014074454)20151013204027)20151013203757)20151013203739) 20180528134358
H H l#]AAschema_sha1a506ec802250a88d9d822fa06a31446b1d4b106d2019-10-30 20:04:29.6942872019-10-30 20:04:29.694287H#AAenvironmenttest2019-10-30 20:04:29.6902852019-10-30 20:04:29.690285
+
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
H H l#]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\3 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")
\ No newline at end of file