spec/dummy/db/test.sqlite3 in magic_addresses-0.0.23 vs spec/dummy/db/test.sqlite3 in magic_addresses-0.0.24
- old
+ new
@@ -1,5 +1,5 @@
-SQLite format 3 @ h / * h -æ ö *ûö=
+SQLite format 3 @ = / * = -æ ö *ûö=
F » 'b;›Õº2±’ ê %Y9Eindexindex_mgca_city_translations_on_localemgca_city_translationsCREATE INDEX "index_mgca_city_translations_on_locale" ON "mgca_city_translations" ("locale")‚99ƒStablemgca_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_citiesCREATE 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)Cq/sindexindex_mgca_addressibles_on_owner_type_and_owner_idmgca_addressiblesCREATE INDEX "index_mgca_addressibles_on_owner_type_and_owner_id" ON "mgca_addressibles" ("owner_type", "owner_id")
W/Aindexindex_mgca_addressibles_on_address_idmgca_addressiblesCREATE INDEX "index_mgca_addressibles_on_address_id" ON "mgca_addressibles" ("address_id")‚$//ƒwtablemgca_addressiblesmgca_addressibles
CREATE TABLE "mgca_addressibles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default" boolean, "name" varchar, "owner_id" integer, "owner_type" varchar, "address_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Y)Eindexindex_mgca_addresses_on_subdistrict_idmgca_addressesCREATE INDEX "index_mgca_addresses_on_subdistrict_id" ON "mgca_addresses" ("subdistrict_id")
M)-indexindex_mgca_addresses_on_state_idmgca_addressesCREATE INDEX "index_mgca_addresses_on_state_id" ON "mgca_addresses" ("state_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_addresses CREATE 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")ƒt))‡#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, "longitude" float, "latitude" float, "subdistrict_id" integer, "district_id" integer, "city_id" integer, "state_id" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "status" varchar DEFAULT 'new')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")‚/??ƒ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" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)9‚AtablecompaniescompaniesCREATE TABLE "companies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime
\ No newline at end of file