spec/dummy/db/test.sqlite3 in magic_addresses-0.0.12 vs spec/dummy/db/test.sqlite3 in magic_addresses-0.0.13

- old
+ new

@@ -1,36 +1,39 @@ -SQLite format 3@ G,'G-%* - -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   +SQLite format 3@ h/*h-* = +F 'b;2%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_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_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") 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)9AtablecompaniescompaniesCREATE TABLE "companies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime           +         -   \\cw  -- - u  0 9X /??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)1_?Qindexindex_mgca_address_translations_on_localemgca_address_translationsCREATE INDEX "index_mgca_address_translations_on_locale" ON "mgca_address_translations" ("locale")Lq?uindexindex_mgca_address_translations_on_mgca_address_idmgca_address_translationsCREATE INDEX "index_mgca_address_translations_on_mgca_address_id" ON "mgca_address_translations" (/??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)1_?Qindexindex_mgca_address_translations_on_localemgca_address_translationsCREATE INDEX "index_mgca_address_translations_on_locale" ON "mgca_address_translations" ("locale")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")))]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)K))indexindex_mgca_addresses_on_city_idmgca_addressesCREATE INDEX "index_mgca_addresses_on_city_id" ON "mgca_addresses" ("city_id")Q)5indexindex_mgca_addresses_on_country_idmgca_addressesCREATE INDEX "index_mgca_addresses_on_country_id" ON "mgca_addresses" ("country_id")S)9indexindex_mgca_addresses_on_district_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_district_id" ON "mgca_addresses" ("district_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") -M)-indexindex_mgca_addresses_on_state_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_state_id" ON "mgca_addresses" ("state_id") Y)Eindexindex_mgca_addresses_on_subdistrict_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_subdistrict_id" ON "mgca_addresses" ("subdistrict_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) K#)indexindex_mgca_cities_on_country_idmgca_citiesCREATE INDEX "index_mgca_cities_on_country_id" ON "mgca_cities" ("country_id")G#!indexindex_mgca_cities_on_state_idmgca_citiesCREATE INDEX "index_mgca_cities_on_state_id" ON "mgca_cities" ("state_id")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)%Y9Eindexindex_mgca_city_translations_on_localemgca_city_translationsCREATE INDEX "index_mgca_city_translations_on_locale" ON "mgca_city_translations" ("locale") - ]mL  -J  p? ]$Q/5indexindex_mgca_subdistricts_on_city_idmgca_subdistricts'CREATE INDEX "index_mgca_subdistricts_on_city_id" ON "mgca_subdis1_?Qindexindex_mgca_country_translations_on_localemgca_country_translationsCREATE INDEX "index_mgca_country_translations_on_locale" ON "mgca_country_translations" ("locale")Lq?uindexindex_mgca_country_translations_on_mgca_country_idmgca_country_translationsCREATE INDEX "index_mgca_country_translations_on_mgca_country_id" ON "mgca_country_translations" ("mgca_country_id"),AActablemgca_district_translationsmgca_district_translationsCREATE TABLE "mgca_district_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_district_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)5aAUindexindex_mgca_district_translations_on_localemgca_district_translationsCREATE INDEX "index_mgca_district_translations_on_locale" ON "mgca_district_translations" ("locale")SuA}indexindex_mgca_district_translations_on_mgca_district_idmgca_district_translationsCREATE INDEX "index_mgca_district_tr7e9]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") ))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)(??_tablemgca_country_translationsmgca_country_translationsCREATE TABLE "mgca_country_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_country_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)1_?Qindexindex_mgca_country_translations_on_localemgca_country_translationsCREATE INDEX "index_mgca_country_translations_on_locale" ON "mgca_country_translations" ("locale")Lq?uindexindex_mgca_country_translations_on_mgca_country_idmgca_country_translationsCREATE INDEX "index_mgca_country_translations_on_mgca_country_id" ON "mgca_country_translations" ("mgca_country_id"),AActablemgca_district_translationsmgca_district_translationsCREATE TABLE "mgca_district_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_district_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)5aAUindexindex_mgca_district_translations_on_localemgca_district_translationsCREATE INDEX "index_mgca_district_translations_on_locale" ON "mgca_district_translations" ("locale")SuA}indexindex_mgca_district_translations_on_mgca_district_idmgca_district_translationsCREATE INDEX "index_mgca_district_translations_on_mgca_district_id" ON "mgca_district_translations" ("mgca_district_id") -))Otablemgca_districtsmgca_districtsCREATE TABLE "mgca_districts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "short_name" varchar, "fsm_state" varchar DEFAULT 'new', "city_id" integer, "created_at" datetime, "updated_at" datetime)K))indexindex_mgca_districts_on_city_idmgca_districtsCREATE INDEX "index_mgca_districts_on_city_id" ON "mgca_districts" ("city_id") ;;Wtablemgca_state_translationsmgca_state_translationsCREATE TABLE "mgca_state_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_state_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar))[;Iindexindex_mgca_state_translations_on_localemgca_state_translationsCREATE INDEX "index_mgca_state_translations_on_locale" ON "mgca_state_translations" ("locale")>i;eindexindex_mgca_state_translations_on_mgca_state_idmgca_state_translations CREATE INDEX "index_mgca_state_translations_on_mgca_state_id" ON "mgca_state_translations" ("mgca_state_id") + 22@r& w + + 0 ]x F9AtablecompaniescompaniesCREATE TABLE "companies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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" varchar)1_?Qindexindex_mgca_address_translations_on_localemgca_address_translationsCREATE INDEX "index_mgca_address_translations_on_locale" ON "mgca_address_translations" ("locale")Lq?uinde9AtablecompaniescompaniesCREATE TABLE "companies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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" varchar)1_?Qindexindex_mgca_address_translations_on_localemgca_address_translationsCREATE INDEX "index_mgca_address_translations_on_locale" ON "mgca_address_translations" ("locale")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")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')K))indexindex_mgca_addresses_on_city_idmgca_addressesCREATE INDEX "index_mgca_addresses_on_city_id" ON "mgca_addresses" ("city_id")Q)5indexindex_mgca_addresses_on_country_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_country_id" ON "mgca_addresses" ("country_id") S)9indexindex_mgca_addresses_on_district_idmgca_addresses +CREATE INDEX "index_mgca_addresses_on_district_id" ON "mgca_addresses" ("district_id") +M)-indexindex_mgca_addresses_on_state_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_state_id" ON "mgca_addresses" ("state_id") Y)Eindexindex_mgca_addresses_on_subdistrict_idmgca_addresses CREATE INDEX "index_mgca_addresses_on_subdistrict_id" ON "mgca_addresses" ("subdistrict_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) W/Aindexindex_mgca_addressibles_on_address_idmgca_addressiblesCREATE INDEX "index_mgca_addressibles_on_address_id" ON "mgca_addressibles" ("address_id")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")##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)K#)indexindex_mgca_cities_on_country_idmgca_citiesCREATE INDEX "index_mgca_cities_on_country_id" ON "mgca_cities" ("country_id")  Ih  + o ER PD@"K#)indexindex_mgca_states_on_country_idmgca_states%CREATE INDEX "index_mgca_states_on_country_id" ON "mgca_states" ("country_id")!##Otablemgca ))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)(??_tablemgca_country_translationsmgca_country_translationsCREATE TABLE "mgca_country_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_country_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)1_?Qindexindex_mgca_country_translations_on_localemgca_country_translationsCREATE INDEX "index_mgca_country_translations_on_locale" ON "mgca_country_translations" G#!indexindex_mgca_cities_on_state_idmgca_citiesCREATE INDEX "index_mgca_cities_on_state_id" ON "mgca_cities" ("state_id")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)%Y9Eindexindex_mgca_city_translations_on_localemgca_city_translationsCREATE INDEX "index_mgca_city_translations_on_locale" ON "mgca_city_translations" ("locale")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") ))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)(??_tablemgca_country_translationsmgca_country_translationsCREATE TABLE "mgca_country_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_country_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)1_?Qindexindex_mgca_country_translations_on_localemgca_country_translationsCREATE INDEX "index_mgca_country_translations_on_locale" ON "mgca_country_translations" ("locale")Lq?uindexindex_mgca_country_translations_on_mgca_country_idmgca_country_translationsCREATE INDEX "index_mgca_country_translations_on_mgca_country_id" ON "mgca_country_translations" ("mgca_country_id"),AActablemgca_district_translationsmgca_district_translationsCREATE TABLE "mgca_district_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_district_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)5aAUindexindex_mgca_district_translations_on_localemgca_district_translationsCREATE INDEX "index_mgca_district_translations_on_locale" ON "mgca_district_translations" ("locale")SuA}indexindex_mgca_district_translations_on_mgca_district_idmgca_district_translationsCREATE INDEX "index_mgca_district_translations_on_mgca_district_id" ON "mgca_district_translations" ("mgca_district_id") +))Otablemgca_districtsmgca_districtsCREATE TABLE "mgca_districts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default_name" varchar, "short_name" varchar, "fsm_state" varchar DEFAULT 'new', "city_id" integer, "created_at" datetime, "updated_at" datetime)K))indexindex_mgca_districts_on_city_idmgca_districts CREATE INDEX "index_mgca_districts_on_city_id" ON "mgca_districts" ("city_id") ;;Wtablemgca_state_translationsmgca_state_translations!CREATE TABLE "mgca_state_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "mgca_state_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)  +              -  +   + +Y ` # U ++=//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)-)9tableusersusers-CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) (Y/Eindexindex_mgca_subdistricts_on_district_idmgca_subdistricts,CREATE INDEX "index_mgca_subdistricts_on_district_id" ON "mgca_subdistricts" ("district_id")'Q/5indexindex_mgca_subdistricts_on_city_idmgca_subdistricts+CREATE INDEX "index_mgca_subdistricts_on_city_id" ON "mgca_subdistricts" ("city_id"))[;Iindexindex_mgca_state_translations_on_localemgca_state_translations"CREATE INDEX "index_mgca_state_translations_on_locale" ON "mgca_state_translations" ("locale")> i;eindexindex_mgca_state_translations_on_mgca_state_idmgca_state_translations#CREATE INDEX "index_mgca_state_translations_on_mgca_state_id" ON "mgca_state_translations" ("mgca_state_id")!##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)  -  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 +  )20151111133333)20150225220219)20150213105831)20151118102658 +)20151111133333)20150225220219)20150213105831) 20151118102658 \ No newline at end of file