spec/dummy/db/development.sqlite3 in introspective_admin-0.0.2 vs spec/dummy/db/development.sqlite3 in introspective_admin-0.0.3

- old
+ new

@@ -1,8 +1,9 @@ -SQLite format 3@ C-B 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")] +SQLite format 3@ 1C^1- +B 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" ("vers7G6% >p^L:(tbP>)20150909225019)20150820190524)20150727214950)20150701234930)20150701234929)20150623170133)20150617232522)20150617232521)20150617232519)20150609201823)20150601213542)20150601212924 )20150601200533 )20150601200526 )20150507191529 +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" ("vers8zjY >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  @@ -10,17 +11,17 @@         - I%c  -6 @ Il//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=/l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sl//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)]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)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")f7indexindex_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") ##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)}A##indexindex_admin_users_on_emailadmin_users CREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email")*_#_indexindex_admin_users_on_reset_password_tokenadmin_users -CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")117tablechat_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)0c1Yindexindex_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") S19indexindex_chat_message_users_on_user_idchat_message_users CREATE INDEX "index_chat_message_users_on_user_id" ON "chat_message_users" ("user_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) -"M'-indexindex_chat_messages_on_author_idchat_messagesCREATE INDEX "index_chat_messages_on_author_id" ON "chat_messages" ("author_id")#I'%indexindex_chat_messages_on_chat_idchat_messagesCREATE INDEX "index_chat_messages_on_chat_id" ON "chat_messages" ("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)x%C!indexindex_chat_users_on_chat_idchat_usersCREATE INDEX "index_chat_users_on_chat_id" ON "chat_users" ("chat_id")  + { `=j`````` Il//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=/l0Zc1Yindexindex_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")Y117tablechat_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)*X_#_indexindex_admin_users_on_reset_password_tokenadmin_users +CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")}WA##indexindex_admin_users_on_emailadmin_users CREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email") V##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)fU7indexindex_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")*T]7Mindexindex_active_admin_comments_on_namespaceactive_admin_comments CREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")YS}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")]R77Ytableactive_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_tokenusers9CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")5 indexindex_users_on_emailusersCCREATE 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")SGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token")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, "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)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)   - +  - { o C L r]kEaSinj(#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)r);indexindex_companies_on_namecompaniesCREATE UNIQUE INDEX "index_companies_on_name" ON "companies" ("name")4*Ktablejobsjobs1CREATE TABLE "jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u+!!5tablelocatableslocatables$CREATE TABLE "locax&C!indexindex_chat_users_on_user_idchat_usersCREATE INDEX "index_chat_users_on_user_id" ON "chat_users" ("user_id")3'EtablechatschatsCREATE TABLE "chats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creator_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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)r);indexindex_companies_on_namecompaniesCREATE UNIQUE INDEX "index_companies_on_name" ON "companies" ("name")4*Ktablejobsjobs1CREATE TABLE "jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u+!!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)?,s!windexindex_locatables_on_locatable_type_and_locatable_idlocatables%CREATE INDEX "index_locatables_on_locatable_type_and_locatable_id" ON "locatables" ("locatable_type", "locatable_id")`---stablelocation_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)R.m-indexindex_location_beacons_unique_company_identifierlocation_beacons'CREATE UNIQUE INDEX "index_location_beacons_unique_company_identifier" ON "location_beacons" ("company_id", "uuid", "major", "minor")/%%_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) 0O%1indexindex_location_gps_on_location_idlocation_gps)CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")p1/tablelocationslocations!CREATE TABLE "locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "kind" varchar, "parent_location_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P2{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")3WAindexindex_locations_on_parent_location_idlocations#CREATE INDEX "index_locations_on_parent_location_id" ON "locations" ("parent_location_id")l4%%tableproject_jobsproject_jobs2CREATE TABLE "project_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "job_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)}5E%indexindex_project_jobs_on_job_idproject_jobs3CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id")06c%eindexindex_project_jobs_on_project_id_and_job_idproject_jobs4CREATE UNIQUE INDEX "index_project_jobs_on_project_id_and_job_id" ON "project_jobs" ("project_id", "job_id")    + L 1 @ + + 7gg(MtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT Pm{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")pl/tablelocationslocations!CREATE TABLE "locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "kind" varchar, "parent_location_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 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--stablelocation_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, "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)4eKtablejobsjobs1CREATE 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")x`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")0Zc1Yindexindex_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")           @@ -36,20 +37,19 @@ -,*  /     432 - BB8# i -  R t 7M%-indexindex_project_jobs_on_project_idproject_jobs5CREATE INDEX "index_project_jobs_on_project_id" ON "project_jobs" ("project_id")o81tableprojectsprojects/CREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "owner_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "default_password" varchar)s9Aindexindex_projects_on_owner_idprojects0CREATE INDEX "index_projects_on_owner_id" ON "projects" ("owner_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);aSindexindex_roles_on_ownable_type_and_ownable_idrolesCREATE INDEX "index_roles_on_ownable_type_and_ownable_id" ON "roles" ("ownable_type", "ownable_id")I<yindexindex_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")R=!!otableteam_usersteam_users>CREATE TABLE "team_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "team_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)x>C!indexindex_team_users_on_team_idteam_users?CREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id")"?[!Uindexindex_team_users_on_user_id_and_team_idteam_users@CREATE UNIQUE INDEX "index_team_users_on_user_id_and_team_id" ON "team_users" ("user_id", "team_id")x@C!indexindex_team_users_on_user_idteam_usersACREATE INDEX "index_team_users_on_user_id" ON "team_users" ("user_id")YAtableteamsteams;CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "project_id" integer, "creator_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mB?indexindex_teams_on_creator_idteams<CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")mC?indexindex_teams_on_project_idteams=CREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")=D))5tableuser_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 NOT NULL, "updated_at" datetime NOT NULL)UE)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")FS)9indexindex_user_locations_on_location_iduser_locations-CREATE INDEX "index_user_locations_on_location_id" ON "user_locations" ("location_id")GK))indexindex_user_locations_on_user_iduser_locations.CREATE INDEX "index_user_locations_on_user_id" ON "user_locations" ("user_id")  -C7 \ L  ]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)Y}7 indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_comments CREATE INDEX "index_active_admin_commen0c1Yindexindex_chat_message_users_on_chat_message_idchat_message_user);indexindex_companies_on_namecompaniesCREATE UNIQUE INDEX "index_companies_on_name" ON "companies" ("name")4*Ktablejobsjobs1CREATE TABLE "jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u+!!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)?,s!windexindex_locatables_on_locatable_type_and_locatable_idlocatables%CREATE INDEX "index_locatables_on_locatable_type_and_locatable_id" ON "locatables" ("locatable_type", "locatable_id")`---stablelocation_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)R.m-indexindex_location_beacons_unique_company_identifierlocation_beacons'CREATE UNIQUE INDEX "index_location_beacons_unique_company_identifier" ON "location_beacons" ("company_id", "uuid", "major", "minor")/%%_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) 0O%1indexindex_location_gps_on_location_idlocation_gps)CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")p1/tablelocationslocations!CREATE TABLE "locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "kind" varchar, "parent_location_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P2{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")3WAindexindex_locations_on_parent_location_idlocations#CREATE INDEX "index_locations_on_parent_location_id" ON "locations" ("parent_location_id")l4%%tableproject_jobsproject_jobs2CREATE TABLE "project_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "job_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)}5E%indexindex_project_jobs_on_job_idproject_jobs3CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id")06c%eindexindex_project_jobs_on_project_id_and_job_idproject_jobs4CREATE UNIQUE INDEX "index_project_jobs_on_project_id_and_job_id" ON "project_jobs" ("project_id", "job_id") 7M%-indexindex_project_jobs_on_project_idproject_jobs5CREATE INDEX "index_project_jobs_on_project_id" ON "project_jobs" ("project_id")o81tableprojectsprojects/CREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "owner_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "default_password" varchar) -86+  +:86+ ) #^I'%indexindex_chat_messages_on_chat_idchat_messagesCREATE INDEX "index_chat_messages_on_chat_id" ON "chat_messages" ("chat_id") +bEM'-indexindex_chat_messages_on_author_idchat_messagesCREATE kO%1indexindex_location_gps_on_location_idlocation_gps)CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")`h--stablelocation_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, "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)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")x`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)S19indexindex_chat_message_users_on_user_idchat_message_users CREATE INDEX "index_chat_message_users_on_user_id" ON "chat_message_users" ("user_id")A##indexindex_admin_users_on_ePm{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")pl/tablelocationslocations!CREATE TABLE "locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "kind" varchar, "parent_location_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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")4eKtablejobsjobs1CREATE 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") gp3w C M +b jk//]tableuser_project_jobsuser_project_jobsCREATE 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)K))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")=))5tableuser_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 nWAindexindex_locations_on_parent_location_idlocations#CREATE INDEX "index_locations_on_parent_location_id" ON "locations" ("parent_location_id")Pm{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")pl/tablelocationslocations!CREATE TABLE "locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "kind" varchar, "parent_location_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)"z[!Uindexindex_team_users_on_user_id_and_team_idteam_users@CREATE UNIQUE INDEX "index_team_users_on_user_id_and_team_id" ON "team_users" ("user_id", "team_id")xyC!indexindex_team_users_on_team_idteam_users?CREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id")Rx!!otableteam_usersteam_users>CREATE TABLE "team_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "team_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Iwyindexindex_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")vaSindexindex_roles_on_ownable_type_and_ownable_idrolesCREATE INDEX "index_roles_on_ownable_type_and_ownable_id" ON "roles" ("ownable_type", "ownable_id")gu-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)stAindexindex_projects_on_owner_idprojects0CREATE INDEX "index_projects_on_owner_id" ON "projects" ("owner_id")os1tableprojectsprojects/CREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "owner_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "default_password" varchar) rM%-indexindex_project_jobs_on_project_idproject_jobs5CREATE INDEX "index_project_jobs_on_project_id" ON "project_jobs" ("project_id")0qc%eindexindex_project_jobs_on_project_id_and_job_idproject_jobs4CREATE UNIQUE INDEX "index_project_jobs_on_project_id_and_job_id" ON "project_jobs" ("project_id", "job_id")}pE%indexindex_project_jobs_on_job_idproject_jobs3CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id")lo%%tableproject_jobsproject_jobs2CREATE TABLE "project_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "job_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  kO%1indexindex_location_gps_on_location_idlocation_gps)CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")  +  + <;    -@?> - -? + p  -/ - e Q DQ XO%xNSGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token")I<yindexindex_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")R=!!otableteam_usersteam_users>CREATE TABLE "team_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "team_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)x>C!indexindex_team_users_on_team_idteam_users?CREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id")"?[!Uindexindex_team_users_on_user_id_and_team_idteam_users@CREATE UNIQUE INDEX "index_team_users_on_user_id_and_team_id" ON "team_users" ("user_id", "team_id")x@C!indexindex_team_users_on_user_idteam_usersACREATE INDEX "index_team_users_on_user_id" ON "team_users" ("user_id")YAtableteamsteams;CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "project_id" integer, "creator_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mB?indexindex_teams_on_creator_idteams<CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")mC?indexindex_teams_on_project_idteams=CREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")=D))5tableuser_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 NOQSGindexindex_users_on_reset_password_tokenusers9CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")eP5 indexindex_users_on_emailusersCCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")H//]tableuser_project_jobsuser_project_jobsCREATE 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)IO/1indexindex_user_project_jobs_on_job_iduser_project_jobs+CREATE INDEX "index_user_project_jobs_on_job_id" ON "user_project_jobs" ("job_id")JW/Aindexindex_user_project_jobs_on_project_iduser_project_jobs6CREATE INDEX "index_user_project_jobs_on_project_id" ON "user_project_jobs" ("project_id")hK/'indexindex_user_project_jobs_on_user_id_and_project_id_and_job_iduser_project_jobs8CREATE 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")LQ/5indexindex_user_project_jobs_on_user_iduser_project_jobs:CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id")MtableusersusersCREATE 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)NSGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token") OO?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token") - +@?> z8  + o9Mxz SGindexindex_users_on_reset_password_tokenusersCCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusers9CREATE 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") SGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token")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, "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)Q/5indexindex_user_project_jobs_on_user_iduser_project_jobs7CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id")h/'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")W/Aindexindex_user_project_jobs_on_project_iduser_project_jobs6CREATE INDEX "index_user_project_jobs_on_project_id" ON "user_project_jobs" ("project_id")O/1indexindex_user_project_jobs_on_job_iduser_project_jobs+CREATE INDEX "index_user_project_jobs_on_job_id" ON "user_project_jobs" ("job_id")//]tableuser_project_jobsuser_project_jobsCREATE 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)K))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")=))5tableuser_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 NOT NULL, "updated_at" datetime 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")Y|tableteamsteams;CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "project_id" integer, "creator_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)x{C!indexindex_team_users_on_user_idteam_usersACREATE INDEX "index_team_users_on_user_id" ON "team_users" ("user_id") +9 \ No newline at end of file