spec/dummy/db/development.sqlite3 in introspective_admin-0.0.8 vs spec/dummy/db/development.sqlite3 in introspective_admin-0.1.0

- old
+ new

@@ -1,59 +1,55 @@ -SQLite format 3@ DI- -@ 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@ 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" ("version" va*0" >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" ("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 +)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)   - mm/AAadmin@example.com$2a$10$vKcSaax7tJEiefNydN2c3uHM73e6b5xtACkr4hU4ARDeskY..nooq2016-04-21 05:53:16.0132662016-04-21 05:53:16.013266 -/ admin@example.com -  +     -  +  +  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]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_usersCCREATE INDEX "index_team_users_on_user_id" ON "team_users" ("user_id")"[[!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" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "team_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)IXyindexindex_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")WaSindexindex_roles_on_ownable_type_and_ownable_idrolesCREATE INDEX "index_roles_on_ownable_type_and_ownable_id" ON "roles" ("ownable_type", "ownable_id") SM%-indexindex_project_jobs_on_project_idproject_jobs6CREATE INDEX "index_project_jobs_on_project_id" ON "project_jobs" ("project_id")0Rc%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")}QE%indexindex_project_jobs_on_job_idproject_jobs4CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id")lP%%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 NOT NULL, "updated_at" datetime NOT NULL) OO1indexindex_locations_on_unreflected_idlocations$CREATE INDEX "index_locations_on_unreflected_id" ON "locations" ("unreflected_id")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") +Lctablelocationslocations!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 NOT NULL, "updated_at" datetime NOT NULL)$O%1indexindex_location_gps_ogV-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)sUAindexindex_projects_on_owner_idprojects1CREATE INDEX "index_projects_on_owner_id" ON "projects" ("owner_id")oT1tableprojectsprojects0CREATE 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) +    -  U 5({ VaSindexindex_roles_on_ownable_type_and_ownable_idrolesCaSindexindex_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 AtableusersusersCREATE 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)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" ("version" varchar NOT NULL) - A ' @#2NAh l - 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") -ctablelocationslocations!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 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")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")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) -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")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)xC!indexindex_chat_users_on_user_idchat_usersCREATE INDEX "index_chat_users_on_user_id" ON "chat_users" ("user_id")xC!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)3EtablechatschatsCREATE TABLE "chats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creator_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime 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")yaSindexindex_roles_on_ownable_type_and_ownable_idrolesCREATE INDEX "index_roles_on_ownable_type_and_ownable_id" ON&)R%m-indexindex_location_beacons_unique_company_identifi$--;tablelocation_beaconslocation_beacons'CREATE TABLE "location_beacons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "company_id" integer NOT NULL, "mac_aSindexindex_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)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)P!{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") O1indexindex_locations_on_unreflected_idlocations#CREATE INDEX "index_locations_on_unreflected_id" ON "locations" ("unreflected_id")WAindexindex_locations_on_parent_location_idlocations"CREATE INDEX "index_locations_on_parent_location_id" ON "locations" ("parent_location_id")   +   -  +   -  +   -   +#"!  +%  +'   -  -  -  C> S (O  0 T - -v -r3)02c%eindexindex_project_jobs_on_project_id_and_job_idproject_jobs6CREATE UNIQUE INDEX "index_project_jobs_on_project_id_and_job_id" ON "project_jobs" ("project_id", "job_id")}1E%indexindex_project_jobs_on_job_idproject_jobs5CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id") 0M%-indexindex_project_jobs_on_project_idproject_jobs4CREATE INDEX "index_project_jobs_on_project_id" ON "project_jobs" ("project_id")l/%%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 NOT NULL, "updated_at" datetime NOT NULL)4.Ktablejobsjobs2CREATE TABLE "jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)s-Aindexindex_projects_on_owner_idprojects1CREATE INDEX "index_projects_on_owner_id" ON "projects" ("owner_id") ytableprojectsprojects0CREATE 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)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")*S)9indexindex_user_locations_on_location_iduser_locations.CREATE INDEX "index_user_locations_on_location_id" ON "user_locations" ("location_id"))K))indexindex_user_locations_on_user_iduser_locations-CREATE INDEX "index_user_locations_on_user_id" ON "user_locations" ("user_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) 'O%1indexindex_location_gps_on_location_idlocation_gps+CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")&%%_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)m-indexindex_location_beacons_unique_company_identifierlocation_beacons(CREATE UNIQUE INDEX "index_location_beacons_uni;)m:?indexindex_teams_on_creator_idteams>CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")m9?indexindex_teams_on_project_idteams=CREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")Y8tableteamsteams<CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "project_id" integer, "creator_id" integer,o,1tableprojectsprojects0CREATE 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)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_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)?#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") -  +)    -  -   +.-,  +0     -  +543     -  +:987   -  G  } - -" Do{G ?O?indexindex_users_on_confirmation_tokenusersDCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")">[!Uindexindex_team_users_on_user_id_and_team_idteam_usersCCREATE UNIQUE INDEX "index_team_users_on_user_id_and_team_id" ON "team_users" ("user_id", "team_id")x=C!indexindex_team_users_on_team_idteam_usersBCREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id")x<C!indexindex_team_users_on_user_idteam_usersACREATE INDEX "index_team_users_on_user_id" ON "team_users" ("user_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)m:?indexindex_teams_on_creator_idteams>CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")m9?indexindex_teams_on_project_idteams=CREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")Y8tableteamsteams<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)h7/'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")6O/1indexindex_user_project_jobs_on_job_iduser_project_jobs:CREATE INDEX "index_user_project_jobs_on_job_id" ON "user_project_jobs" ("job_id")5W/Aindexindex_user_project_jobs_on_project_iduser_project_jobs9CREATE INDEX "index_user_project_jobs_on_project_id" ON "user_project_jobs" ("project_id")4Q/5indexindex_user_project_jobs_on_user_iduser_project_jobs8CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id")3//]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)02c%eindexindex_project_jobs_on_project_id_and_job_idproject_jobs6CREATE UNIQUE INDEX "index_project_jobs_on_project_id_and_job_id" ON "project_jobs" ("project_id", "job_id")}1E%indexindex_project_jobs_on_job_idproject_jobs5CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id") +=<  n' n  }f@}eO/1indexindex_user_project_jobs_on_job_iduser_project_jobs8CREATE INDEX "index_user_project_jobs_on_job_id" ON "user_project_jobs" ("job_id")I?indexindex_teams_el5 indexindex_users_on_emailusers*CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")fW/Aindexindex_user_project_jobs_on_project_iduser_project_jobs9CREATE INDEX "index_user_project_jobs_on_project_id" ON "user_project_jobs" ("project_id")bS)9indexindex_user_locations_on_location_iduser_locations.CREATE INDEX "index_user_locations_on_location_id" ON "user_locations" ("location_id")Ua)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")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<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_usersCCREATE INDEX "index_team_users_on_user_id" ON "team_users" ("user_id")   - - +BA? +* O##AAenvironmentdevelopment2019-03-27 19:26:49.7785882019-03-27 19:26:49.778588 +# environment \ No newline at end of file