spec/dummy/db/test.sqlite3 in works_cited-0.1.4 vs spec/dummy/db/test.sqlite3 in works_cited-0.1.5
- old
+ new
@@ -1,5 +1,5 @@
-SQLite format 3 @ \ \ .?Ù
a 0Þ/ 7Li€[ T
55Ktablear_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_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations
`
+SQLite format 3 @ a a .?Ù
a 0Þ/ 7Li€[ T
55Ktablear_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_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations
`
=indexindex_works_cited_contributors_on_works_cited_citation_idworks_cited_contributorsCREATE INDEX "index_works_cited_contributors_on_works_cited_citation_id" ON "works_cited_contributors" ("works_cited_citation_id")2 ==wtableworks_cited_contributorsworks_cited_contributors
CREATE TABLE "works_cited_contributors" ("id" integer NOT NULL PRIMARY KEY, "works_cited_citation_id" integer NOT NULL, "contributor_role" varchar DEFAULT NULL, "first" varchar DEFAULT NULL, "middle" varchar DEFAULT NULL, "last" varchar DEFAULT NULL, "suffix" varchar DEFAULT NULL, "handle" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_c1c75d62eb"
FOREIGN KEY ("works_cited_citation_id")
REFERENCES "works_cited_citations" ("id")
)3W7eindexindex_works_cited_citations_on_recordworks_cited_citations CREATE INDEX "index_works_cited_citations_on_record" ON "works_cited_citations" ("record_type", "record_id")`77_tableworks_cited_citationsworks_cited_citationsCREATE TABLE "works_cited_citations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "citation_type" varchar, "media" varchar, "title" varchar, "container_title" varchar, "publisher" varchar, "city" varchar, "edition" varchar, "volume" varchar, "number" varchar, "series" varchar, "year" varchar, "pages" varchar, "url" varchar, "online_database" varchar, "doi" varchar, "published_at" datetime, "accessed_at" datetime, "record_type" varchar NOT NULL, "record_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")x
OtableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "admin" boolean DEFAULT 0, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)JotablethingsthingsCREATE TABLE "things" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MqtabledoodadsdoodadsCREATE TABLE "doodads" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
\ No newline at end of file