SQLite format 3@ 7%(7.8 2  j @; c11gtablepartners_get_paidspartners_get_paidsCREATE TABLE "partners_get_paids" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "enter_invoice_number" integer, "you_will_receive_this_when_question_mark" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)`55ctablecode_change_requestscode_change_requestsCREATE TABLE "code_change_requests" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "text" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)==Qtablebanal_business_testcasesbanal_business_testcasesCREATE TABLE "banal_business_testcases" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "org_id" varchar, "name" varchar, "metainfo" text, "link" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) CC9tablewit_ai_parse_model_exampleswit_ai_parse_model_examples CREATE TABLE "wit_ai_parse_model_examples" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "wit_ai_parse_model_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "entity_name" varchar, "entity_value" varchar, "parsable_resource" varchar, "parsable_resource_query" varchar, "parsable_resource_text" text, "parsable_resource_entity_value_start_index" integer, "parsable_resource_entity_value_end_index" integer, "wit_ai_server_response" text, CONSTRAINT "fk_rails_a80a19e570" FOREIGN KEY ("wit_ai_parse_model_id") REFERENCES "wit_ai_parse_models" ("id") )g Cindexindex_wit_ai_parse_model_examples_on_wit_ai_parse_model_idwit_ai_parse_model_examples CREATE INDEX "index_wit_ai_parse_model_examples_on_wit_ai_parse_model_id" ON "wit_ai_parse_model_examples" ("wit_ai_parse_model_id")v %%/tablefile_systemsfile_systemsCREATE TABLE "file_systems" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar, "machine_readable_identifier" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) 33=tablewit_ai_parse_modelswit_ai_parse_models CREATE TABLE "wit_ai_parse_models" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "wit_ai_client_token" varchar, "wit_ai_server_token" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)P ''_tableezii_os_filesezii_os_files CREATE TABLE "ezii_os_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "file_path" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G//=tableezii_integrationsezii_integrations CREATE TABLE "ezii_integrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)E##QtabledirectoriesdirectoriesCREATE TABLE "directories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "path" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)ZtableunzipsunzipsCREATE TABLE "unzips" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "zip_file_path" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "target_dir_path" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=MtablesearchessearchesCREATE TABLE "searches" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "query" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)T55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrat p^L:(tbP>,)20190912173916)20190912173649)20190912113509)20190829174432)20190828105156)20190828104427)20190827180754)20190827180753)20190827180752)20190827180751)20190827180750)20190827063427)20190827060151)20190825142553)20190822174951 )20190822154127 )20190819023312 )20190819011820 )20190819000225 )20190818230840)20190818230758)20190818215411)20190818215339)20190818210143)20190818174938)20190818172012)20190818164950)20190818163044  |iVC0 r_L9& )20190912173916)20190912173649)20190912113509)20190829174432)20190828105156)20190828104427)20190827180754)20190827180753)20190827180752)20190827180751)20190827180750)20190827063427)20190827060151)20190825142553)20190822174951)20190822154127 )20190819023312 )20190819011820 )20190819000225 )20190818230840 )20190818230758)20190818215411)20190818215339)20190818210143)20190818174938)20190818172012)20190818164950) 20190818163044 O##AAenvironmentdevelopment2019-09-06 11:14:54.6382652019-09-06 11:14:54.638265 # environment  3wit_ai_parse_models)cookie_changes%file_systems wit_ai_pa tasks    zMMAAPTQMSJ4IVZ562F3Z4MCJYPVBF6NFGHOXL5MC25PEJICJGXQVLQVXD2C5DNJKPVXI2019-09-12 11:41:51.7652252019-09-12 11:41:51.765225zMMAAPTQMSJ4IVZ562F3Z4MCJYPVBF6NFGHOXL5MC25PEJICJGXQVLQVXD2C5DNJKPVXI2019-09-06 11:14:54.6995122019-09-06 11:14:54.699512   Pp(PFAAGithubgithub2019-09-12 11:41:51.7919772019-09-12 11:41:51.791977HAADropboxdropbox2019-09-12 11:41:51.7891072019-09-12 11:41:51.789107DAALocallocal2019-09-12 11:41:51.7856762019-09-12 11:41:51.785676FAAGithubgithub2019-09-06 11:14:54.7145412019-09-06 11:14:54.714541HAADropboxdropbox2019-09-06 11:14:54.7109412019-09-06 11:14:54.710941DAALocallocal2019-09-06 11:14:54.7074972019-09-06 11:14:54.707497      C# 2  j @; c11gtablepartners_get_paidspartners_get_paidsCREATE TABLE "partners_get_paids" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "enter_invoice_number" integer, "you_will_receive_this_when_question_mark" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)`55ctablecode_change_requestscode_change_requestsCREATE TABLE "code_change_requests" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "text" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)==Qtablebanal_business_testcasesbanal_business_testcasesCREATE TABLE "banal_business_testcases" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "org_id" varchar, "name" varchar, "metainfo" text, "link" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) CC9tablewit_ai_parse_model_exampleswit_ai_parse_model_examples CREATE TABLE "wit_ai_parse_model_examples" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "wit_ai_parse_model_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "entity_name" varchar, "entity_value" varchar, "parsable_resource" varchar, "parsable_resource_query" varchar, "parsable_resource_text" text, "parsable_resource_entity_value_start_index" integer, "parsable_resource_entity_value_end_index" integer, "wit_ai_server_response" text, CONSTRAINT "fk_rails_a80a19e570" FOREIGN KEY ("wit_ai_parse_model_id") REFERENCES "wit_ai_parse_models" ("id") )v %%/tablefile_systemsfile_systemsCREATE TABLE "file_systems" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar, "machine_readable_identifier" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)g Cindexindex_wit_ai_parse_model_examples_on_wit_ai_parse_model_idwit_ai_parse_model_examples CREATE INDEX "index_wit_ai_parse_model_examples_on_wit_ai_parse_model_id" ON "wit_ai_parse_model_examples" ("wit_ai_parse_model_id") 33=tablewit_ai_parse_modelswit_ai_parse_models CREATE TABLE "wit_ai_parse_models" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "wit_ai_client_token" varchar, "wit_ai_server_token" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)P ''_tableezii_os_filesezii_os_files CREATE TABLE "ezii_os_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "file_path" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G//=tableezii_integrationsezii_integrations CREATE TABLE "ezii_integrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)E##QtabledirectoriesdirectoriesCREATE TABLE "directories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "path" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)ZtableunzipsunzipsCREATE TABLE "unzips" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "zip_file_path" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "target_dir_path" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=MtablesearchessearchesCREATE TABLE "searches" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "query" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)T55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations  V `j{]  ! P:"//#tablebanal_brainstormsbanal_brainstorms%CREATE TABLE "banal_brainstorms" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "idea" text, "main_category" varchar, "priority" varchar, "status" varchar, "comments" text, "idea_owner" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)UKindexindex_apis_on_rftrolling_foreign_keyapisCREATE UNIQUE INDEX "index_apis_on_rftrolling_foreign_key" ON "apis" ("rftrolling_foreign_key")`7indexindex_apis_on_code_idapisCREATE INDEX "index_apis_on_code_id" ON "apis" ("code_id")AetableapisapisCREATE TABLE "apis" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "rfc" text, "rftrolling_foreign_key" integer, "code_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_76b30827dd" FOREIGN KEY ("code_id") REFERENCES "codes" ("id") )vEindexindex_codes_on_code_links_idcodesCREATE INDEX "index_codes_on_code_links_id" ON "codes" ("code_links_id")StablecodescodesCREATE TABLE "codes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "github_link" varchar, "gist_link" varchar, "code_links_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_70fdfe9320" FOREIGN KEY ("code_links_id") REFERENCES "code_links" ("id") )W!Aindexindex_code_links_on_code_link_type_idcode_linksCREATE INDEX "index_code_links_on_code_link_type_id" ON "code_links" ("code_link_type_id")d!!tablecode_linkscode_linksCREATE TABLE "code_links" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "link" text, "code_link_type_id" integer NOT NULL, "description" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_35b5f93263" FOREIGN KEY ("code_link_type_id") REFERENCES "code_link_types" ("id") ) M+-indexindex_code_link_types_on_type_idcode_link_typesCREATE INDEX "index_code_link_types_on_type_id" ON "code_link_types" ("type_id")M++Qtablecode_link_typescode_link_typesCREATE TABLE "code_link_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type_description" text, "type_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_b16ddae096" FOREIGN KEY ("type_id") REFERENCES "types" ("id") )#%tabletypestypesCREATE TABLE "types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)w77 tablebasecamp_integrationsbasecamp_integrationsCREATE TABLE "basecamp_integrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar, "code" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)N!))Wtablebanal_projectsbanal_projects$CREATE TABLE "banal_projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)k 5tabletaskstasks#CREATE TABLE "tasks" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "reward" integer, "title" varchar, "briefing" text, "cta_copy" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)e))tablecookie_changescookie_changes"CREATE TABLE "cookie_changes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "identifier" varchar, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)#[/Iindexindex_code_link_batches_on_code_link_idcode_link_batches!CREATE INDEX "index_code_link_batches_on_code_link_id" ON "code_link_batches" ("code_link_id")`//otablecode_link_batchescode_link_batches CREATE TABLE "code_link_batches" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar, "code_link_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_5ab5ad56fa" FOREIGN KEY ("code_link_id") REFERENCES "code_links" ("id") )              }]P 5 ( n X }o)[AAerb_dummy_data notice = "test" @code_links = [] 2019-09-09 12:16:28.7780912019-09-09 12:16:28.778091h)MAAerb_dummy_datanotice = "test" @code_links = []2019-09-09 12:14:41.2455402019-09-09 12:14:41.2455402 )_AAerb_dummy_dataTurbolinks.clearCache() Turbolinks.visit("http://localhost:3000/cookie_changes/12", {"action":"replace"})2019-09-09 12:14:27.0858632019-09-09 12:14:27.085863_ );AAerb_dummy_data @code_links = [] 2019-09-09 12:14:21.6075682019-09-09 12:14:21.607568_ );AAerb_dummy_data @code_links = [] 2019-09-06 21:24:01.3342152019-09-06 21:24:01.334215W )+AAerb_dummy_datanotice = "test"2019-09-06 21:15:33.0214692019-09-06 21:15:33.021469W )+AAerb_dummy_datanotice = "test"2019-09-06 21:14:42.2520092019-09-06 21:14:42.2520091)]AAerb_dummy_dataTurbolinks.clearCache() Turbolinks.visit("http://localhost:3000/cookie_changes/7", {"action":"replace"})2019-09-06 21:14:33.5149512019-09-06 21:14:33.514951_);AAerb_dummy_data @code_links = [] 2019-09-06 21:14:30.7672112019-09-06 21:14:30.767211W)+AAerb_dummy_datanotice = "test"2019-09-06 20:45:00.6965572019-09-06 20:45:00.696557_);AAerb_dummy_data @code_links = [] 2019-09-06 20:44:53.5772922019-09-06 20:44:53.577292W)+AAerb_dummy_datanotice = "self"2019-09-06 20:42:44.9451052019-09-06 20:42:44.9451051)]AAerb_dummy_dataTurbolinks.clearCache() Turbolinks.visit("http://localhost:3000/cookie_changes/2", {"action":"replace"})2019-09-06 20:42:37.4194202019-09-06 20:42:37.419420_);AAerb_dummy_data @code_links = [] 2019-09-06 20:42:35.0823312019-09-06 20:42:35.082331@AAlevel22019-09-06 11:15:06.6104582019-09-06 11:15:06.610458    {7AA2Uncover 50 president names of housing communities across NorwayEach uncovered president must be at least 5 minutes of car travel time away from all previously uncovered ones. You'll be presented a map with PDF documents about housing communities which are already located on a map. Then you need to find the names of the presidents in the PDF documents. Bonus: Find the name in a second PDF document, to verify it's spelling and validity.Show geographical map2019-09-12 11:41:51.7995492019-09-12 11:41:51.799549