spec/dummy/db/test.sqlite3 in has_vcards-1.0.0.rc0 vs spec/dummy/db/test.sqlite3 in has_vcards-1.0.0
- old
+ new
@@ -1,9 +1,9 @@
-SQLite format 3 @ -)
+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)
! =//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_vcardsCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")\ /indexindex_has_vcards_vcards_on_reference_id_and_reference_typehas_vcards_vcardsCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")
k pk 0)20120119091225)20140617113710)20120813065226)20140619102041)20140619101337)20121113120000)20140619121756)20140620151641
- c ci| 0 )20120119091225)20140617113710)20120813065226)20140619102041)20140619101337)20121113120000)20140619121756) 20140620151641
+!!OtablesomethingssomethingsCREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))O/1indexindex_has_vcards_vcards_on_activehas_vcards_vcardsCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")\ /indexindex_has_vcards_vcards_on_reference_id_and_reference_typehas_vcards_vcardsCREATE 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
\ No newline at end of file