SQLite format 3@ QF^Q.v@ 5({ VaSindexindex_roles_on_ownable_type_and_ownable_idrolesCREATE INDEX "index_roles_on_ownable_type_and_ownable_id" ON "roles" ("ownable_type", "ownable_id")g-tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "ownable_id" integer, "ownable_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)sEtableusersusersCREATE 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, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "unlock_token" varchar, "locked_at" datetime, "authentication_token" varchar)f 7indexindex_active_admin_comments_on_resource_type_and_resource_idactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_resource_type_and_resource_id" ON "active_admin_comments" ("resource_type", "resource_id")Y }7 indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_comments CREATE INDEX "index_active_admin_comments_on_author_type_and_author_id" ON "active_admin_comments" ("author_type", "author_id")* ]7Mindexindex_active_admin_comments_on_namespaceactive_admin_comments CREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")] 77Ytableactive_admin_commentsactive_admin_comments CREATE TABLE "active_admin_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "namespace" varchar, "body" text, "resource_id" varchar NOT NULL, "resource_type" varchar NOT NULL, "author_id" integer, "author_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)* _#_indexindex_admin_users_on_reset_password_tokenadmin_users CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")}A##indexindex_admin_users_on_emailadmin_users CREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email") ##Ytableadmin_usersadmin_usersCREATE TABLE "admin_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, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)SGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token")r;indexindex_companies_on_namecompaniesCREATE UNIQUE INDEX "index_companies_on_name" ON "companies" ("name")j#tablecompaniescompaniesCREATE TABLE "companies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(256) NOT NULL, "short_name" varchar(10) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("versygX >p^L:(tbP>)20150909225019)20150820190524)20150727214950)20150701234930)20150701234929)20150623170133)20150617232522)20150617232521)20150617232519)20150609201823)20150601213542)20150601212924 )20150601200533 )20150601200526 )20150507191529 )20150505181640 )20150505181636)20150505181635)20150415222005)20150414213154)20150406213646)20141002220722)20141002211057)20141002211055)20141002205024 &|iVC0 r_L9&)20150909225019)20150820190524)20150727214950)20150701234930)20150701234929)20150623170133)20150617232522)20150617232521)20150617232519)20150609201823)20150601213542)20150601212924)20150601200533 )20150601200526 )20150507191529 )20150505181640 )20150505181636 )20150505181635)20150415222005)20150414213154)20150406213646)20141002220722)20141002211057)20141002211055) 20141002205024   admin_users   W!5nj!!tablechat_userschat_usersCREATE TABLE "chat_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_id" integer, "user_id" integer, "departed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|I'%indexindex_chat_messages_on_chat_idchat_messagesCREATE INDEX "index_chat_messages_ 8--Gtablelocation_beaconslocation_beacons'CREATE TABLE "location_beacons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "company_id" integer NOT NULL, "mac_address" varchar(12), "uuid" varchar(32) NOT NULL, "major" integer NOT NULL, "minor" integer NOT NULL, "last_known_battery_level" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULLXQ/5indexindex_user_project_jobs_on_user_iduser_project_jobs;CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id") xtableteamsteamsCREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")p?indexindex_teams_on_creator_idteams=CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")G}[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataFN|55?tablear_internal_metadataar_internal_metadataECREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL) g9ADgRh I   T%'tt@%rsr%%'tr@%%'tableproject_jobsproject_joY_}7 indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_comments CREATE INDEX "index_active_admin_comments_on_author_type_and_author_id" ON "active_admin_comments" ("author_type", "author_id")c^77etableactive_admin_commentsactive_admin_comments CREATE TABLE "active_admin_comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "namespace" varchar, "body" text, "resource_id" varchar NOT NULL, "resource_type" varchar NOT NULL, "author_id" integer, "author_type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)]SGindexindex_users_on_reset_password_tokenusersDCREATE 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") [O?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")ZSGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token").Y;tableusersusersCREATE 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(6), "remember_created_at" datetime(6), "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime(6), "last_sign_in_at" datetime(6), "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "unlock_token" varchar, "locked_at" datetime(6), "authentication_token" varchar, "confirmation_token" varchar, "confirmed_at" datetime(6), "confirmation_sent_at" datetime(6), "unconfirmed_email" varchar, "first_name" varchar, "last_name" varchar)Q/5indexindex_user_project_jobs_on_user_iduser_project_jobs;CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id")hW/'indexindex_user_progS19indexindex_chat_message_users_on_user_idchat_message_users CREATE INDEX "index_chat_message_users_on_user_id" ON "chat_message_users" ("user_id")0fc1Yindexindex_chat_message_users_on_chat_message_idchat_message_usersCREATE INDEX "index_chat_message_users_on_chat_message_id" ON "chat_message_users" ("chat_message_id")e11Itablechat_message_userschat_message_usersCREATE TABLE "chat_message_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_message_id" integer, "user_id" integer, "read_at" datetime(6), "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)*d_#_indexindex_admin_users_on_reset_password_tokenadmin_users CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")}cA##indexindex_admin_users_on_emailadmin_users CREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email")b##}tableadmin_usersadmin_usersCREATE TABLE "admin_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(6), "remember_created_at" datetime(6), "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime(6), "last_sign_in_at" datetime(6), "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)fa7indexindex_active_admin_comments_on_resource_type_and_resource_idactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_resource_type_and_resource_id" ON "active_admin_comments" ("resource_type", "resource_id")*`]7Mindexindex_active_admin_comments_on_namespaceactive_admin_comments CREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")           LY u{CXBY }l T dmd{r!!Atablelocatableslocatables%CREATE TABLE "locatables" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "locatable_id" integer, "locatable_type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)po/tablecompaniescompaniesCREATE TABLE "companies" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(256) NOT NULL, "short_name" varchar(10) NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) 1##}tableadmin_usersadmin_usersCREATE TAB t--Gtablelocation_beaconslocation_beacons'CREATE TABLE "location_beacons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "company_id" integer NOT NULL, "mac_address" varchar(12), "uuid" varchar(32) NOT NULL, "major" integer NOT NULL, "minor" integer NOT NULL, "last_known_battery_level" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)?ss!windexindex_locatables_on_locatable_type_and_locatable_idlocatables&CREATE INDEX "index_locatables_on_locatable_type_and_locatable_id" ON "locatables" ("locatable_type", "locatable_id")rp;indexindex_companies_on_namecompaniesCREATE UNIQUE INDEX "index_companies_on_name" ON "companies" ("name")9nQtablechatschatsCREATE TABLE "chats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "creator_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)xmC!indexindex_chat_users_on_user_idchat_usersCREATE INDEX "index_chat_users_on_user_id" ON "chat_users" ("user_id")xlC!indexindex_chat_users_on_chat_idchat_usersCREATE INDEX "index_chat_users_on_chat_id" ON "chat_users" ("chat_id")sk!!1tablechat_userschat_usersCREATE TABLE "chat_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_id" integer, "user_id" integer, "departed_at" datetime(6), "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)jI'%indexindex_chat_messages_on_chat_idchat_messagesCREATE INDEX "index_chat_messages_on_chat_id" ON "chat_messages" ("chat_id") iM'-indexindex_chat_messages_on_author_idchat_messagesCREATE INDEX "index_chat_messages_on_author_id" ON "chat_messages" ("author_id")sh''%tablechat_messageschat_messagesCREATE TABLE "chat_messages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_id" integer, "author_id" integer, "message" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)S19indexindex_chat_message_users_on_user_idchat_message_users CREATE INDEX "index_chat_message_users_on_user_id" ON "chat_message_users" ("user_id").c1Yindexindex_chat_message_users_on_chat_message_idchat_messagPy{indexindex_locations_on_parent_location_id_and_kind_and_namelocations"CREATE UNIQUE INDEX "index_locations_on_parent_location_id_and_kind_and_name" ON "locations" ("parent_location_id", "kind", "name")xotablelocationslocations!CREATE TABLE "locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "kind" varchar, "parent_location_id" integer, "unreflected_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) wO%1indexindex_location_gps_on_location_idlocation_gps+CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")v%%ktablelocation_gpslocation_gps)CREATE TABLE "location_gps" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "lat" float NOT NULL, "lng" float NOT NULL, "alt" float DEFAULT 0.0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)Rum-indexindex_location_beacons_unique_company_identifierlocation_beacons(CREATE UNIQUE INDEX "index_location_beacons_unique_company_identifier" ON "location_beacons" ("company_id", "uuid", "major", "minor"):qWtablejobsjobs2CREATE TABLE "jobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)                   #"!  %  '   )    .-,  0     543     :987   =<  IE#-ls iEZ  d xC!indexindex_team_users_on_team_idteam_usersACREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id")X!!{tableteam_usersteam_users?CREATE TABLE "team_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "team_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)Iyindexindex_roles_on_user_id_and_ownable_type_and_ownable_idrolesCREATE UNIQUE INDEX "index_roles_on_user_id_and_ownable_type_and_ownable_id" ON "roles" ("user_id", "ownable_type", "ownable_id")aSindexindex_roles_on_ownable_type_and_ownable_idrolesCREATE INDEX "index_roles_on_ownable_type_and_ownable_id" ON "roles" ("ownable_type", "ownable_id")m9tablerolesrolesCREATE TABLE "roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "ownable_id" integer, "ownable_type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)sAindexindex_projects_on_owner_idprojects1CREATE INDEX "index_projects_on_owner_id" ON "projects" ("owner_id")u=tableprojectsprojects0CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "owner_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "default_password" varchar) M%-indexindex_project_jobs_on_project_idproject_jobs6CREATE INDEX "index_project_jobs_on_project_id" ON "project_jobs" ("project_id")0~c%eindexindex_project_jobs_on_project_id_and_job_idproject_jobs5CREATE UNIQUE INDEX "index_project_jobs_on_project_id_and_job_id" ON "project_jobs" ("project_id", "job_id")}}E%indexindex_project_jobs_on_job_idproject_jobs4CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id")r|%%'tableproject_jobsproject_jobs3CREATE TABLE "project_jobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "job_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) {O1indexindex_locations_on_unreflected_idlocations$CREATE INDEX "index_locations_on_unreflected_id" ON "locations" ("unreflected_id")zWAindexindex_locations_on_parent_location_idlocations#CREATE INDEX "index_locations_on_parent_location_id" ON "locations" ("parent_location_id"){indexindex_locations_on_parent_location_id_and_kind_and_namelocations"CREATE UNIQUE INDEX "index_locations_on_parent_location_id_andK))indexindex_user_locations_on_user_iduser_locations/CREATE INDEX "index_user_locations_on_user_id" ON "user_locations" ("user_id")S)9indexindex_user_locations_on_location_iduser_locations.CREATE INDEX "index_user_locations_on_location_id" ON "user_locations" ("location_id")U )indexindex_user_locations_on_detectable_type_and_detectable_iduser_locations-CREATE INDEX "index_user_locations_on_detectable_type_and_detectable_id" ON "user_locations" ("detectable_type", "detectable_id")C ))Atableuser_locationsuser_locations,CREATE TABLE "user_locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "location_id" integer, "detectable_id" integer, "detectable_type" varchar, "lat" float, "lng" float, "alt" float, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)m ?indexindex_teams_on_project_idteams>CREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")m ?indexindex_teams_on_creator_idteams=CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")_ tableteamsteams