SQLite format 3@ *& -!)%  p^L:()20141008195345)20140922150155)20140922143128)20140922142755)20140922142154)20140922142000 )20140922141033 )20140927184139 )20140907162406 )20140907161904 )20140907161816)20140907161809)20140907161640)20140907161629)20140907161617)20140907131441)20140907031459)20140906224816)20140906224643 {hUB/ )20141008195345)20140922150155)20140922143128)20140922142755)20140922142154)20140922142000)20140922141033 )20140927184139 )20140907162406 )20140907161904 )20140907161816 )20140907161809)20140907161640)20140907161629)20140907161617)20140907131441)20140907031459)20140906224816)20140906224643   countries users'address_types D'D`5AA%%AAantonioams@gmail.com$2a$10$t8vHjhng48Yt.qiZJ0ZVkOYavSMkqaTZv2ileIo./ibcXnLGynIzm2014-11-05 18:40:33.1805112014-11-05 18:40:33.180511192.168.33.1192.168.33.12014-11-05 18:40:33.1576142014-11-05 18:40:33.183011V1AAAAadmin@vizir.com.br$2a$10$8xIClgKZTmPuQSW9ySp/C.jX98AtT/LJkZ7PNOLpMN0DjJoZD7U3O2014-09-27 19:06:15.8570282014-09-27 19:06:15.85702810.0.2.210.0.2.22014-09-27 19:06:04.7188862014-09-27 19:06:15.865279 Kq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")VtablepeoplepeopleCREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "email" varchar(255), "bio" text, "birthday" date, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) k~[tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime)e5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") 5antonioams@gmail.com1admin@vizir.com.br   7z+++tableckeditor_assetsckeditor_assets CREATE TABLE "ckeditor_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "data_file_name" varchar(255) NOT NULL, "data_content_type" varchar(255), "data_file_size" integer, "assetable_id" integer, "assetable_type" varchar(30), "type" varchar(30), "width" integer, "height" integer, "created_at" datetime, "updated_at" datetime)! C+aindexidx_ckeditor_assetable_typeckeditor_assets CREATE INDEX "idx_ckeditor_assetable_type" ON "ckeditor_assets" ("assetable_type", "type", "assetable_id") 9+Gindexidx_ckeditor_assetableckeditor_assetsCREATE INDEX "idx_ckeditor_assetable" ON "ckeditor_assets" ("assetable_type", "assetable_id")4 CtablephotosphotosCREATE TABLE "photos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_file_name" varchar(255), "image_content_type" varchar(255), "image_file_size" integer, "image_updated_at" datetime, "title" varchar(255), "person_id" integer, "created_at" datetime, "updated_at" datetime)     AA0n ?indexindex_photos_on_person_idphotosCREATE INDEX "index_photos_on_person_id" ON "photos" ("person_id")8 ?tablecountriescountriesCREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "created_at" datetime, "updated_at" datetime, "flag_file_name" varchar(255), "flag_content_type" varchar(255), "flag_file_size" integer, "flag_updated_at" datetime)NwtablestatesstatesCREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "country_id" integer, "created_at" datetime, "updated_at" datetime)qAindexindex_states_on_country_idstatesCREATE INDEX "index_states_on_country_id" ON "states" ("country_id")MutablecitiescitiesCREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "country_id" integer, "created_at" datetime, "updated_at" datetime) | AA+!ABrasilBR2014-09-27 19:08:44.6143042014-09-28 00:29:57.632346brasil-flag.jpgimage/jpeg2014-09-28 00:29:56.994998      <<k= indexindex_cities_on_state_idcitiesCREATE INDEX "index_cities_on_state_id" ON "cities" ("state_id")qAindexindex_cities_on_country_idcitiesCREATE INDEX "index_cities_on_country_id" ON "cities" ("country_id")8''/tableaddress_typesaddress_typesCREATE TABLE "address_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)2##+tablephone_typesphone_typesCREATE TABLE "phone_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)uEtablephonesphonesCREATE TABLE "phones" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255), "phone_type_id" integer, "phoneable_id" integer, "phoneable_type" varchar(255), "created_at" datetime, "updated_at" datetime)zG!indexindex_phones_on_phone_type_idphonesCREATE INDEX "index_phones_on_phone_type_id" ON "phones" ("phone_type_id") }b}I-AAParent's address2014-09-27 19:03:29.9351172014-09-27 19:03:29.935117E%AABorn address2014-09-27 19:03:29.8816242014-09-27 19:03:29.881624Q=AAChildhood living address2014-09-27 19:03:29.8072122014-09-27 19:03:29.807212K1AAOld living address2014-09-27 19:03:29.7299652014-09-27 19:03:29.729965O9AACurrent living address2014-09-27 19:03:29.5531942014-09-27 19:03:29.553194     yqftableaddressesaddressesCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "address" varchar(255), "number" varchar(255), "complement" varchar(255), "zipcode" varchar(255), "city_id" integer, "state_id" integer, "country_id" integer, "address_type_id" integer, "person_id" integer, "created_at" datetime, "updated_at" datetime)tAindexindex_addresses_on_city_idaddressesCREATE INDEX "index_addresses_on_city_id" ON "addresses" ("city_id")wCindexindex_addresses_on_state_idaddresses CREATE INDEX "index_addresses_on_state_id" ON "addresses" ("state_id")}G!indexindex_addresses_on_country_idaddresses!CREATE INDEX "index_addresses_on_country_id" ON "addresses" ("country_id") Q5indexindex_addresses_on_address_type_idaddresses"CREATE INDEX "index_addresses_on_address_type_id" ON "addresses" ("address_type_id")       >gbtablecommentscomments&CREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "comment" varchar(255), "post_id" integer, "created_at" datetime, "updated_at" datetime, "approved" boolean DEFAULT 'true')zEindexindex_addresses_on_person_idaddresses#CREATE INDEX "index_addresses_on_person_id" ON "addresses" ("person_id")Xtablepostsposts$CREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "text" text, "status" integer DEFAULT 1, "cover_file_name" varchar(255), "cover_content_type" varchar(255), "cover_file_size" integer, "cover_updated_at" datetime, "created_at" datetime, "updated_at" datetime, "user_id" integer)    #`!!!mtableposts_tagsposts_tags*CREATE TABLE "posts_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "tag_id" integer):!!?tablepost_filespost_files'CREATE TABLE "post_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "file_file_name" varchar(255), "file_content_type" varchar(255), "file_file_size" integer, "file_updated_at" datetime, "post_id" integer, "created_at" datetime, "updated_at" datetime) tabletagstags(CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)