SQLite format 3@ &("&.$                    ` 8 W scb<koDOOwindexauthz_rhbp_business_process_indexauthz_role_has_business_processesCREATE INDEX "authz_rhbp_business_process_index" ON "authz_role_has_business_processes" ("authz_business_process_id")/OOMtableauthz_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)! K/Uindexauthz_role_grants_rolable_indexauthz_role_grantsCREATE INDEX "authz_role_grants_rolable_index" ON "authz_role_grants" ("rolable_type", "rolable_id") E/5indexauthz_role_grants_role_indexauthz_role_grants CREATE INDEX "authz_role_grants_role_index" ON "authz_role_grants" ("authz_role_id")# //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)~ ==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) ==-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)aSgindexauthz_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")^Qgindexauthz_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")`ggtableauthz_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)B''CtableannouncementsannouncementsCREATE TABLE "announcements" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)U3=indexindex_announcement_cities_on_city_idannouncement_citiesCREATE INDEX "index_announcement_cities_on_city_id" ON "announcement_cities" ("city_id")4e3]indexindex_announcement_cities_on_announcement_idannouncement_citiesCREATE INDEX "index_announcement_cities_on_announcement_id" ON "announcement_cities" ("announcement_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)u33tableannouncement_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)  y \hEdy? _ l= indexindex_reports_on_user_idreports!CREATE INDEX "index_reports_on_user_id" ON "reports" ("user_id"){G!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")rAindexindex_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)0;tablecitiescitiesCREATE TABLE "cities" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)W3Aindexindex_authz_scoping_rules_on_scopableauthz_scoping_rulesCREATE INDEX "index_authz_scoping_rules_on_scopable" ON "authz_scoping_rules" ("scopable")U3=indexindex_authz_scoping_rules_on_keywordauthz_scoping_rulesCREATE INDEX "index_authz_scoping_rules_on_keyword" ON "authz_scoping_rules" ("keyword").a3Uindexindex_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")33Gtableauthz_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)f##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) 7OGindexauthz_rhbp_role_indexauthz_role_has_business_processesCREATE INDEX "authz_rhbp_role_index" ON "authz_role_has_business_processes" ("authz_role_id") 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)G%[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata( x"//tableschema_migrationsschema_migrations%CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)A#U/indexsqlite_autoindex_schema_migrations_1schema_migrations&!SGindexindex_users_on_reset_password_tokenusers$CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusers#CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")W 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)               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-18 02:55:40.1868732019-01-18 02:55:40.190699 # environment