SQLite format 3@ F. @ 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" ("vers^K9 >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  x ]  :g]]]]]>>j!!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_on_chat_id" ON "chat_messages" ("chat_id")M'-indexindex_chat_messages_on_author_idchat_messagesCREATE INDEX "index_chat_messages_on_author_id" ON "chat_messages" ("author_id")f''tablechat_messageschat_messagesCREATE TABLE "chat_messages" ("id" in tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_to9117tablechat_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*8_#_indexindex_admin_users_on_reset_password_tokenadmin_users CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")}7A##indexindex_admin_users_on_emailadmin_users CREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email") 6##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)f57indexindex_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")*4]7Mindexindex_active_admin_comments_on_namespaceactive_admin_comments CREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")Y3}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")]277Ytableactive_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)$SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")5 indexindex_users_on_emailusersDCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")&O?indexindex_users_on_confirmation_tokenusers*CREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")SGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token")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)            qj| k obleusers tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_tx@C!indexindex_chat_users_on_chat_idchat_usersCREATE INDEX "index_chat_users_on_chat_id" ON "chat_users" ("chat_id")j?!!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_on_chat_id" ON "chat_messages" ("chat_id") =M'-indexindex_chat_messages_on_author_idchat_messagesCREATE INDEX "index_chat_messages_on_author_id" ON "chat_messages" ("author_id")m<''tablechat_messageschat_messagesCREATE TABLE "chat_messages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_id" integer, "author_id" integer, "message" text, "created_at" datetime NOT NULL, "updated_at" datetime 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")0:c1Yindexindex_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")6117tablechat_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*8_#_indexindex_admin_users_on_reset_p KO%1indexindex_location_gps_on_location_idlocation_gps+CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")J%%_tablelocation_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 NOT NULL, "updated_at" datetime NOT NULL)RIm-indexindex_location_beacons_unique_company_identifierlocation_beacons(CREATE UNIQUE INDEX "index_location_beacons_unique_company_identifier" ON "location_beacons" ("company_id", "uuid", "major", "minor")H--;tablelocation_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 NOT NULL, "updated_at" datetime NOT NULL)?Gs!windexindex_locatables_on_locatable_type_and_locatable_idlocatables&CREATE INDEX "index_locatables_on_locatable_type_and_locatable_id" ON "locatables" ("locatable_type", "locatable_id")uF!!5tablelocatableslocatables%CREATE TABLE "locatables" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "locatable_id" integer, "locatable_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)4EKtablejobsjobs2CREATE TABLE "jobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)rD;indexindex_companies_on_namecompaniesCREATE UNIQUE INDEX "index_companies_on_name" ON "companies" ("name")jC#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)3BEtablechatschatsCREATE TABLE "chats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "creator_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)xAC!indexindex_chat_users_on_user_idchat_usersCREATE INDEX "index_chat_users_on_user_id" ON "chat_users" ("user_id")     z \  ,_hmd e--;tablelocation_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 NOT NULL, "updated_at" datetime NOT NULL)?Gs!windexindex_locatables_on_locatable_type_and_locatable_idlocatables&CREATE INDEX "index_locatables_on_locatable_type_and_locatable_id" ON "locatables" ("locatable_tm^?indexindex_teams_on_creator_idteams=CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")Y]tableteamsteamsCREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")a[!Uindexindex_team_users_on_user_id_and_team_idteam_usersBCREATE UNIQUE INDEX "index_team_users_on_user_id_and_team_id" ON "team_users" ("user_id", "team_id")xZC!indexindex_team_users_on_team_idteam_usersACREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id")RY!!otableteam_usersteam_users?CREATE TABLE "team_users" (mSGindexindex_users_on_reset_password_tokenusersDCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") kO?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")jSGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token")itableusersusersCREATE 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, "confirmation_token" varchar, "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar, "first_name" varchar, "last_name" varchar)hQ/5indexindex_user_project_jobs_on_user_iduser_project_jobs;CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id")hg/'indexindex_user_project_jobs_on_user_id_and_project_id_and_job_iduser_project_jobs:CREATE UNIQUE INDEX "index_user_project_jobs_on_user_id_and_project_id_and_job_id" ON "user_project_jobs" ("user_id", "project_id", "job_id")d//]tableuser_project_jobsuser_project_jobs7CREATE TABLE "user_project_jobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "project_id" integer NOT NULL, "job_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)cK))indexindex_user_locations_on_user_iduser_locations/CREATE INDEX "index_user_locations_on_user_id" ON "user_locations" ("user_id")Xtableteamsteams