spec/dummy/db/test.sqlite3 in has_vcards-1.1.1 vs spec/dummy/db/test.sqlite3 in has_vcards-1.1.2
- old
+ new
@@ -1,9 +1,14 @@
-SQLite format 3 @ -'
-
d dd +55ytablehas_vcards_addresseshas_vcards_addressesCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=5)indexaddresses_vcard_id_indexhas_vcards_addressesCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")==1tablehas_vcards_phone_numbershas_vcards_phone_numbersCREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
-
Ns=yindexindex_has_vcards_phone_numbers_on_phone_number_typehas_vcards_phone_numbersCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")E=9indexphone_numbers_vcard_id_indexhas_vcards_phone_numbers CREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")^//ktablehas_vcards_vcardshas_vcards_vcards
-CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
+SQLite format 3 @ -
+
s! ==!tablehas_vcards_phone_numbershas_vcards_phone_numbersCREATE TABL ==!tablehas_vcards_phone_numbershas_vcards_phone_numbersCREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar, "phone_number_type" varchar, "vcard_id" integer, "created_at" datetime, "updated_at" datetime)=5)indexaddresses_vcard_id_indexhas_vcards_addressesCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)
+557tablehas_vcards_addresseshas_vcards_addressesCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar, "extended_address" varchar, "street_address" varchar, "locality" varchar, "region" varchar, "postal_code" varchar, "country_name" varchar, "vcard_id" integer, "address_type" varchar, "created_at" datetime, "updated_at" datetime)
/ F 8// tablehas_vcards_vcardshas_vcards_vcards
+CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar, "nickname" varchar, "family_name" varchar, "given_name" varchar, "additional_name" varchar, "honorific_prefix" varchar, "honorific_suffix" varchar, "active" boolean DEFAULT 't', "type" varchar, "reference_id" integer, "reference_type" varchar, "created_at" datetime, "updated_at" datetime)E=9indexphone_numbers_vcard_id_indexhas_vcards_phone_numbers CREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")Ns=yindexindex_has_vcards_phone_numbers_on_phone_number_typehas_vcards_phone_numbersCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")
+
-
! =//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q //tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
-!!OtablesomethingssomethingsCREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))O/1indexindex_has_vcards_vcards_on_activehas_vcards_vcards CREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")\ /indexindex_has_vcards_vcards_on_reference_id_and_reference_typehas_vcards_vcards CREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")
k }k )201211131200000)20140619121756)20120813065226)20140619102041)20140619101337)20140617113710)20120119091225)20140620151641
- c vc| )20121113120000 0)20140619121756)20120813065226)20140619102041)20140619101337)20140617113710)20120119091225) 20140620151641
+
l =//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l //tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)}
+!!EtablesomethingssomethingsCREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar)\ /indexindex_has_vcards_vcards_on_reference_id_and_reference_typehas_vcards_vcards CREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")O/1indexindex_has_vcards_vcards_on_activehas_vcards_vcards CREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")
+Y p^Y
+0 )20140619121756)20120813065226)20140617113710)20140619102041)20121113120000)20140619101337)20120119091225)20140620151641)20141107181915
+
+P Pi|V 0
+)20140619121756 )20120813065226)20140617113710)20140619102041)20121113120000)20140619101337)20120119091225)20140620151641) 20141107181915
\ No newline at end of file