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                    \\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")                   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