spec/dummy/db/test.sqlite3 in magic_addresses-0.0.1 vs spec/dummy/db/test.sqlite3 in magic_addresses-0.0.2

- old
+ new

@@ -1,6 +1,6 @@ -SQLite format 3@ P,'P-%* +SQLite format 3@  ,' -%* Z /uG,#\ ))Utablemgca_countriesmgca_countriesCREATE TABLE "mgca_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "iso_code" varchar(2), "dial_code" varchar, "fsm_state" varchar DEFAULT 'new', "created_at" datetime, "updated_at" datetime)7e9]indexindex_mgca_city_translations_on_mgca_city_idmgca_city_translationsCREATE INDEX "index_mgca_city_translations_on_mgca_city_id" ON "mgca_city_translations" ("mgca_city_id")%Y9Eindexindex_mgca_city_translations_on_localemgca_city_translationsCREATE INDEX "index_mgca_city_translations_on_locale" ON "mgca_city_translations" ("locale")99Stablemgca_city_translationsmgca_city_translationsCREATE TABLE "mgca_city_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_city_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)G#!indexindex_mgca_cities_on_state_idmgca_citiesCREATE INDEX "index_mgca_cities_on_state_id" ON "mgca_cities" ("state_id") K#)indexindex_mgca_cities_on_country_idmgca_citiesCREATE INDEX "index_mgca_cities_on_country_id" ON "mgca_cities" ("country_id") ##wtablemgca_citiesmgca_cities CREATE TABLE "mgca_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "short_name" varchar, "fsm_state" varchar DEFAULT 'new', "state_id" integer, "country_id" integer, "created_at" datetime, "updated_at" datetime) Y)Eindexindex_mgca_addresses_on_subdistrict_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_subdistrict_id" ON "mgca_addresses" ("subdistrict_id") M)-indexindex_mgca_addresses_on_state_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_state_id" ON "mgca_addresses" ("state_id")7 k)gindexindex_mgca_addresses_on_owner_type_and_owner_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_owner_type_and_owner_id" ON "mgca_addresses" ("owner_type", "owner_id")S)9indexindex_mgca_addresses_on_district_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_district_id" ON "mgca_addresses" ("district_id")Q)5indexindex_mgca_addresses_on_country_idmgca_addressesCREATE INDEX "index_mgca_addresses_on_country_id" ON "mgca_addresses" ("country_id")K))indexindex_mgca_addresses_on_city_idmgca_addressesCREATE INDEX "index_mgca_addresses_on_city_id" ON "mgca_addresses" ("city_id")))]tablemgca_addressesmgca_addressesCREATE TABLE "mgca_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "fetch_address" text, "street_default" varchar, "street_number" varchar, "street_additional" varchar, "zipcode" integer, "default" boolean, "longitude" float, "latitude" float, "subdistrict_id" integer, "district_id" integer, "city_id" integer, "state_id" integer, "country_id" integer, "owner_id" integer, "owner_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Lq?uindexindex_mgca_address_translations_on_mgca_address_idmgca_address_translationsCREATE INDEX "index_mgca_address_translations_on_mgca_address_id" ON "mgca_address_translations" ("mgca_address_id")1_?Qindexindex_mgca_address_translations_on_localemgca_address_translationsCREATE INDEX "index_mgca_address_translations_on_locale" ON "mgca_address_translations" ("locale")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/??mtablemgca_address_translationsmgca_address_translationsCREATE TABLE "mgca_address_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_address_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "street_name    @@ -30,7 +30,7 @@         -  wo v 9 Pw(=//indexunique_schema_migrationsschema_migrations,CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l'//tableschema_migrationsschema_migrations+CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)##Otablemgca_statesmgca_states!CREATE TABLE "mgca_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "short_name" varchar, "fsm_state" varchar DEFAULT 'new', "country_id" integer, "created_at" datetime, "updated_at" datetime)K#)indexindex_mgca_states_on_country_idmgca_states"CREATE INDEX "index_mgca_states_on_country_id" ON "mgca_states" ("country_id")8 GGotablemgca_subdistrict_translationsmgca_subdistrict_translations#CREATE TABLE "mgca_subdistrict_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_subdistrict_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)A!gGaindexindex_mgca_subdistrict_translations_on_localemgca_subdistrict_translations$CREATE INDEX "index_mgca_subdistrict_translations_on_locale" ON "mgca_subdistrict_translations" ("locale")i"Gindexindex_mgca_subdistrict_translations_on_mgca_subdistrict_idmgca_subdistrict_translations%CREATE INDEX "index_mgca_subdistrict_translations_on_mgca_subdistrict_id" ON "mgca_subdistrict_translations" ("mgca_subdistrict_id")*#//tablemgca_subdistrictsmgca_subdistricts&CREATE TABLE "mgca_subdistricts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "short_name" varchar, "fsm_state" varchar DEFAULT 'new', "district_id" integer, "city_id" integer, "created_at" datetime, "updated_at" datetime)$Q/5indexindex_mgca_subdistricts_on_city_idmgca_subdistricts'CREATE INDEX "index_mgca_subdistricts_on_city_id" ON "mgca_subdistricts" ("city_id") %Y/Eindexindex_mgca_subdistricts_on_district_idmgca_subdistricts(CREATE INDEX "index_mgca_subdistricts_on_district_id" ON "mgca_subdistricts" ("district_id")-&9tableusersusers)CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) )20150213105831)20150223223200 -)20150213105831) 20150223223200 +  wo v 9 Pw(=//indexunique_schema_migrationsschema_migrations,CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l'//tableschema_migrationsschema_migrations+CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)##Otablemgca_statesmgca_states!CREATE TABLE "mgca_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "short_name" varchar, "fsm_state" varchar DEFAULT 'new', "country_id" integer, "created_at" datetime, "updated_at" datetime)K#)indexindex_mgca_states_on_country_idmgca_states"CREATE INDEX "index_mgca_states_on_country_id" ON "mgca_states" ("country_id")8 GGotablemgca_subdistrict_translationsmgca_subdistrict_translations#CREATE TABLE "mgca_subdistrict_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_subdistrict_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)A!gGaindexindex_mgca_subdistrict_translations_on_localemgca_subdistrict_translations$CREATE INDEX "index_mgca_subdistrict_translations_on_locale" ON "mgca_subdistrict_translations" ("locale")i"Gindexindex_mgca_subdistrict_translations_on_mgca_subdistrict_idmgca_subdistrict_translations%CREATE INDEX "index_mgca_subdistrict_translations_on_mgca_subdistrict_id" ON "mgca_subdistrict_translations" ("mgca_subdistrict_id")*#//tablemgca_subdistrictsmgca_subdistricts&CREATE TABLE "mgca_subdistricts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "short_name" varchar, "fsm_state" varchar DEFAULT 'new', "district_id" integer, "city_id" integer, "created_at" datetime, "updated_at" datetime)$Q/5indexindex_mgca_subdistricts_on_city_idmgca_subdistricts'CREATE INDEX "index_mgca_subdistricts_on_city_id" ON "mgca_subdistricts" ("city_id") %Y/Eindexindex_mgca_subdistricts_on_district_idmgca_subdistricts(CREATE INDEX "index_mgca_subdistricts_on_district_id" ON "mgca_subdistricts" ("district_id")-&9tableusersusers)CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) )20150213105831)20150225220219 +)20150213105831) 20150225220219 \ No newline at end of file