spec/dummy/db/test.sqlite3 in audited_views-0.0.1 vs spec/dummy/db/test.sqlite3 in audited_views-0.0.2
- old
+ new
@@ -1,11 +1,11 @@
-SQLite format 3 @
- -
)20170507191539)20170507023018)20170507023113
- )20170507191539)20170507023018) 20170507023113
H#AAenvironmenttest2017-05-07 18:26:06.8185922017-05-07 18:26:06.818592
- # environment
h)}MtableproductsproductsCREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sku" varchar, "title" varchar, "price" decimal, "active" boolean, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)>[tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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_metadata
) )B %%tableauditsaudits
-CREATE TABLE "audits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "auditable_id" integer, "auditable_type" varchar, "associated_id" integer, "associated_type" varchar, "user_id" integer, "user_type" varchar, "username" varchar, "action" varchar, "audited_changes" text, "version" integer DEFAULT 0, "comment" varchar, "remote_address" varchar, "request_uuid" varchar, "created_at" datetime)o +'indexauditable_indexauditsCREATE INDEX "auditable_index" ON "audits" ("auditable_id", "auditable_type")s
---indexassociated_indexaudits
CREATE INDEX "associated_index" ON "audits" ("associated_id", "associated_type")[! indexuser_indexauditsCREATE INDEX "user_index" ON "audits" ("user_id", "user_type")wEindexindex_audits_on_request_uuidauditsCREATE INDEX "index_audits_on_request_uuid" ON "audits" ("request_uuid")q
Aindexindex_audits_on_created_atauditsCREATE INDEX "index_audits_on_created_at" ON "audits" ("created_at")
+SQLite format 3 @
+
-
+
-
-
+
U %%tableauditsauditsCREATE TABLE "audits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "auditable_id" integer, "auditable_type" varchar, "associated_id" integer, "associated_type" varchar, "user_id" integer, "user_type" varchar, "username" varchar, "action" varchar, "audited_changes" text, "version" integer DEFAULT 0, "comment" varchar, "remote_address" varchar, "request_uuid" varchar, "created_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)s--indexassociated_indexauditsCREATE INDEX "associated_index" ON "audits" ("associated_id", "associated_type")o+'indexauditable_indexauditsCREATE INDEX "auditable_index" ON "audits" ("auditable_id", "auditable_type")qAindexindex_audits_on_created_atauditsCREATE INDEX "index_audits_on_created_at" ON "audits" ("created_at")
+
i i?? wEindexindex_audits_on_request_uuidauditsCREATE INDEX "index_audits_on_request_uuid" ON "audits" ("request_uuid")[! indexuser_indexaudits CREATE INDEX "user_index" ON "audits" ("user_id", "user_type")}MtableproductsproductsCREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sku" varchar, "title" varchar, "price" decimal, "active" boolean, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)> [tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
)20170507023113)20170507023018)20170507191539
+ )20170507023113)20170507023018) 20170507191539
H#AAenvironmenttest2017-05-08 12:35:56.0791582017-05-08 12:35:56.079158
+ # environment
) ) x
+//tableschema_migrationsschema_migrations
CREATE 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_metadata
\ No newline at end of file