spec/dummy/db/test.sqlite3 in audited_views-0.0.3 vs spec/dummy/db/test.sqlite3 in audited_views-0.0.4
- old
+ new
@@ -1,11 +1,12 @@
-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-24 20:04:17.8318802017-05-24 20:04:17.831880
- # 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
+SQLite format 3 @
+ .
7 ;!
!
+f #7 q
Aindexindex_audits_on_created_atauditsCREATE INDEX "index_audits_on_created_at" ON "audits" ("created_at")wEindexindex_audits_on_request_uuidaudits
CREATE INDEX "index_audits_on_request_uuid" ON "audits" ("request_uuid")[! indexuser_indexauditsCREATE INDEX "user_index" ON "audits" ("user_id", "user_type")s
+--indexassociated_indexauditsCREATE INDEX "associated_index" ON "audits" ("associated_id", "associated_type")o +'indexauditable_indexaudits
+CREATE INDEX "auditable_index" ON "audits" ("auditable_id", "auditable_type")%%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)>[tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)}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)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
)20170507191539)20170507023113)20170507023018
+ )20170507191539)20170507023113) 20170507023018
H#AAenvironmenttest2018-06-21 02:14:15.1012292018-06-21 02:14:15.101229
+ # environment
+
+
+
+
+
\ No newline at end of file