SQLite format 3@ (~.$R                   < = l #D " V  M==-tableauthz_business_processesauthz_business_processes CREATE TABLE "authz_business_processes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar, "name" varchar, "description" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)aLSgindexauthz_bphca_controller_action_indexauthz_business_process_has_controller_actions CREATE INDEX "authz_bphca_controller_action_index" ON "authz_business_process_has_controller_actions" ("authz_controller_action_id")^KQgindexauthz_bphca_business_process_indexauthz_business_process_has_controller_actionsCREATE INDEX "authz_bphca_business_process_index" ON "authz_business_process_has_controller_actions" ("authz_business_process_id")`Jggtableauthz_business_process_has_controller_actionsauthz_business_process_has_controller_actionsCREATE TABLE "authz_business_process_has_controller_actions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "authz_controller_action_id" integer, "authz_business_process_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)HU3=indexindex_announcement_cities_on_city_idannouncement_citiesCREATE INDEX "index_announcement_cities_on_city_id" ON "announcement_cities" ("city_id")4Ge3]indexindex_announcement_cities_on_announcement_idannouncement_citiesCREATE INDEX "index_announcement_cities_on_announcement_id" ON "announcement_cities" ("announcement_id")uF33tableannouncement_citiesannouncement_citiesCREATE TABLE "announcement_cities" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "announcement_id" integer, "city_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) UPE/5indexauthz_role_grants_role_indexauthz_role_grants CREATE INDEX "authz_role_grants_role_index" ON "authz_role_grants" ("authz_role_id")~N==tableauthz_controller_actionsauthz_controller_actions CREATE TABLE "authz_controller_actions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "controller" varchar, "action" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G%[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata(N$55?tablear_internal_metadataar_internal_metadata'CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)A#U/indexsqlite_autoindex_schema_migrations_1schema_migrations&x"//tableschema_migrationsschema_migrations%CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY) s!QK/Uindexauthz_role_grants_rolable_indexauthz_role_grantsCREATE INDEX "authz_role_grants_rolable_index" ON "authz_role_grants" ("rolable_type", "rolable_id")BI''CtableannouncementsannouncementsCREATE TABLE "announcements" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/ROOMtableauthz_role_has_business_processesauthz_role_has_business_processesCREATE TABLE "authz_role_has_business_processes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "authz_business_process_id" integer, "authz_role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)#O//utableauthz_role_grantsauthz_role_grants CREATE TABLE "authz_role_grants" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "authz_role_id" integer NOT NULL, "rolable_type" varchar NOT NULL, "rolable_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)  _ c _r 5 _~9=V33Gtableauthz_scoping_rulesauthz_scoping_rulesCREATE TABLE "authz_scoping_rules" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "scopable" varchar, "authz_role_id" integer NOT NULL, "keyword" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)XU3=indexindex_authz_scoping_rules_on_keywordauthz_scoping_rulesCREATE INDEX "index_authz_scoping_rules_on_keyword" ON "authz_scoping_rules" ("keyword").Wa3Uindexindex_authz_scoping_rules_on_authz_role_idauthz_scoping_rulesCREATE INDEX "index_authz_scoping_rules_on_authz_role_id" ON "authz_scoping_rules" ("authz_role_id")*{eSGindexindex_users_on_reset_password_tokenusers$CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")ed5 indexindex_users_on_emailusers#CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")Wc tableusersusers"CREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)lb= indexindex_reports_on_user_idreports!CREATE INDEX "index_reports_on_user_id" ON "reports" ("user_id"){aG!indexindex_reports_on_clearance_idreports CREATE INDEX "index_reports_on_clearance_id" ON "reports" ("clearance_id")l`= indexindex_reports_on_city_idreportsCREATE INDEX "index_reports_on_city_id" ON "reports" ("city_id")_[tablereportsreportsCREATE TABLE "reports" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "clearance_id" integer, "city_id" integer, "title" varchar, "body" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l^= indexindex_ratings_on_user_idratingsCREATE INDEX "index_ratings_on_user_id" ON "ratings" ("user_id")r]Aindexindex_ratings_on_report_idratingsCREATE INDEX "index_ratings_on_report_id" ON "ratings" ("report_id")\\tableratingsratingsCREATE TABLE "ratings" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "report_id" integer, "user_id" integer, "score" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)M[!!etableclearancesclearancesCREATE TABLE "clearances" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "level" integer, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)0Z;tablecitiescitiesCREATE TABLE "cities" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)YW3Aindexindex_authz_scoping_rules_on_scopableauthz_scoping_rulesCREATE INDEX "index_authz_scoping_rules_on_scopable" ON "authz_scoping_rules" ("scopable")fU##tableauthz_rolesauthz_rolesCREATE TABLE "authz_roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar, "name" varchar, "description" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) T7OGindexauthz_rhbp_role_indexauthz_role_has_business_processesCREATE INDEX "authz_rhbp_role_index" ON "authz_role_has_business_processes" ("authz_role_id")DSOOwindexauthz_rhbp_business_process_indexauthz_role_has_business_processesCREATE INDEX "authz_rhbp_business_process_index" ON "authz_role_has_business_processes" ("authz_business_process_id")               p^L:()20181129220317 )20181130053841 )20181129080058 )20181129131405 )20181129091325 )20181129024103)20190102030242)20181128063016)20190104075934)20190103083513)20181128042315)20181128052541)20181129002252)20190104080155 |VC0 i)20181129220317)20181130053841 )20181129080058 )20181129131405 )20181129091325 )20181129024103 )20190102030242)20181128063016)20190104075934)20190103083513)20181128042315)20181128052541)20181129002252) 20190104080155 QH#AAenvironmenttest2019-01-25 08:46:03.0990892019-01-28 04:16:29.731883 # environment