spec/dummy/db/development.sqlite3 in cmor_files-0.0.40.pre vs spec/dummy/db/development.sqlite3 in cmor_files-0.0.41.pre
- old
+ new
@@ -1,11 +1,12 @@
-SQLite format 3 @ -
-
)20190612112033)20190612112032)20190612112010
- )20190612112033)20190612112032) 20190612112010
O##AAenvironmentdevelopment2019-06-12 11:20:33.1668412019-06-12 11:20:33.166841
- # environment
-
O i x//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrationsN55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G[5 indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataB55'tableactive_storage_blobsactive_storage_blobsCREATE TABLE "active_storage_blobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "filename" varchar NOT NULL, "content_type" varchar, "metadata" text, "byte_size" bigint NOT NULL, "checksum" varchar NOT NULL, "created_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)
E O5?indexindex_active_storage_blobs_on_keyactive_storage_blobsCREATE UNIQUE INDEX "index_active_storage_blobs_on_key" ON "active_storage_blobs" ("key")AA5tableactive_storage_attachmentsactive_storage_attachmentsCREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" integer NOT NULL, "blob_id" integer NOT NULL, "created_at" datetime NOT NULL, CONSTRAINT "fk_rails_c3b3935057"
+SQLite format 3 @
.
w ;!
+T w 5;;tablecmor_files_file_detailscmor_files_file_details
CREATE TABLE "cmor_files_file_details" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "folder_id" integer, "asset_id" integer, "title" varchar, "description" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)11-tablecmor_files_folderscmor_files_foldersCREATE TABLE "cmor_files_folders" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "published_at" datetime, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)c
+cA/indexindex_active_storage_attachments_uniquenessactive_storage_attachmentsCREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id")8 cAYindexindex_active_storage_attachments_on_blob_idactive_storage_attachments
+CREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id")AA5tableactive_storage_attachmentsactive_storage_attachments CREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" integer NOT NULL, "blob_id" integer NOT NULL, "created_at" datetime NOT NULL, CONSTRAINT "fk_rails_c3b3935057"
FOREIGN KEY ("blob_id")
REFERENCES "active_storage_blobs" ("id")
-)8 cAYindexindex_active_storage_attachments_on_blob_idactive_storage_attachmentsCREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id")
-
-
5;;tablecmor_files_file_detailscmor_files_file_detailsCREATE TABLE "cmor_files_file_details" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "folder_id" integer, "asset_id" integer, "title" varchar, "description" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)c
-cA/indexindex_active_storage_attachments_uniquenessactive_storage_attachments
CREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id")11-tablecmor_files_folderscmor_files_foldersCREATE TABLE "cmor_files_folders" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "published_at" datetime, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
+)O5?indexindex_active_storage_blobs_on_keyactive_storage_blobsCREATE UNIQUE INDEX "index_active_storage_blobs_on_key" ON "active_storage_blobs" ("key")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)B55'tableactive_storage_blobsactive_storage_blobsCREATE TABLE "active_storage_blobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "filename" varchar NOT NULL, "content_type" varchar, "metadata" text, "byte_size" bigint NOT NULL, "checksum" varchar NOT NULL, "created_at" datetime NOT NULL)N55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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
)20200119054053)20200119054052)20200119054027
+ )20200119054053)20200119054052) 20200119054027
O##AAenvironmentdevelopment2020-01-19 05:40:52.9103452020-01-19 05:40:52.910345
+ # environment
+
+
+
\ No newline at end of file