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                     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)    )20151111133333)20150225220219)20150213105831)20151118102658 )20151111133333)20150225220219)20150213105831) 20151118102658