spec/dummy/db/development.sqlite3 in introspective_admin-0.1.0 vs spec/dummy/db/development.sqlite3 in introspective_admin-0.9.0
- old
+ new
@@ -1,28 +1,28 @@
-SQLite format 3 @ F . @ 5({
V 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)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 @ Q F ^ Q .v @ 5({
V 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)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 ^ K 9
> 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 y g X
> 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_messages CREATE INDEX "index_chat_messages_on_chat_id" ON "chat_messages" ("chat_id") M'-indexindex_chat_messages_on_author_idchat_messages CREATE 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_users CREATE 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}[5 indexsqlite_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)
+)20150505181636 )20150505181635)20150415222005)20150414213154)20150406213646)20141002220722)20141002211057)20141002211055) 20141002205024
admin_users
+
W!5n 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_messages CREATE INDEX "index_chat_messages_
+8--Gtablelocation_beaconslocation_beacons'CREATE TABLE "location_beacons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "company_id" integer NOT NULL, "mac_address" varchar(12), "uuid" varchar(32) NOT NULL, "major" integer NOT NULL, "minor" integer NOT NULL, "last_known_battery_level" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULLXQ/5indexindex_user_project_jobs_on_user_iduser_project_jobs;CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id") x tableteamsteams<CREATE TABLE "teams" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "project_id" integer, "creator_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) 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") C!indexindex_team_users_on_team_idteam_usersACREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id") !hW/'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") VW/Aindexindex_user_project_jobs_on_project_iduser_project_jobs9CREATE INDEX "index_user_project_jobs_on_project_id" ON "user_project_jobs" ("project_id")UO/1indexindex_user_project_jobs_on_job_iduser_project_jobs8CREATE INDEX "index_user_project_jobs_on_job_id" ON "user_project_jobs" ("job_id") T//itableuser_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(6) NOT NULL, "updated_at" datetime(6) 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") )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") '))Atableuser_locationsuser_locations,CREATE TABLE "user_locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "location_id" integer, "detectable_id" integer, "detectable_type" varchar, "lat" float, "lng" float, "alt" float, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) ?indexindex_teams_on_project_idteams>CREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id") p?indexindex_teams_on_creator_idteams=CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")G}[5 indexsqlite_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)
g 9AD gRh I
+ T%'tt@%rs r%%'tr@%%'tableproject_jobsproject_joY_}7 indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_comments CREATE INDEX "index_active_admin_comments_on_author_type_and_author_id" ON "active_admin_comments" ("author_type", "author_id")c^77etableactive_admin_commentsactive_admin_comments CREATE TABLE "active_admin_comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "namespace" varchar, "body" text, "resource_id" varchar NOT NULL, "resource_type" varchar NOT NULL, "author_id" integer, "author_type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)]SGindexindex_users_on_reset_password_tokenusersDCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e\5 indexindex_users_on_emailusers*CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") [O?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")ZSGindexindex_users_on_authentication_tokenusersCREATE UNIQUE INDEX "index_users_on_authentication_token" ON "users" ("authentication_token").Y;tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime(6), "remember_created_at" datetime(6), "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime(6), "last_sign_in_at" datetime(6), "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "unlock_token" varchar, "locked_at" datetime(6), "authentication_token" varchar, "confirmation_token" varchar, "confirmed_at" datetime(6), "confirmation_sent_at" datetime(6), "unconfirmed_email" varchar, "first_name" varchar, "last_name" varchar) Q/5indexindex_user_project_jobs_on_user_iduser_project_jobs;CREATE INDEX "index_user_project_jobs_on_user_id" ON "user_project_jobs" ("user_id")hW/'indexindex_user_progS19indexindex_chat_message_users_on_user_idchat_message_users CREATE INDEX "index_chat_message_users_on_user_id" ON "chat_message_users" ("user_id")0fc1Yindexindex_chat_message_users_on_chat_message_idchat_message_users CREATE INDEX "index_chat_message_users_on_chat_message_id" ON "chat_message_users" ("chat_message_id")e11Itablechat_message_userschat_message_users CREATE TABLE "chat_message_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_message_id" integer, "user_id" integer, "read_at" datetime(6), "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)*d_#_indexindex_admin_users_on_reset_password_tokenadmin_users
+CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")}cA##indexindex_admin_users_on_emailadmin_users CREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email")b##}tableadmin_usersadmin_usersCREATE TABLE "admin_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime(6), "remember_created_at" datetime(6), "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime(6), "last_sign_in_at" datetime(6), "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)fa7indexindex_active_admin_comments_on_resource_type_and_resource_idactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_resource_type_and_resource_id" ON "active_admin_comments" ("resource_type", "resource_id")*`]7Mindexindex_active_admin_comments_on_namespaceactive_admin_comments
CREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")
-
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_messages CREATE INDEX "index_chat_messages_on_chat_id" ON "chat_messages" ("chat_id")
-=M'-indexindex_chat_messages_on_author_idchat_messages CREATE 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_users CREATE INDEX "index_chat_message_users_on_chat_message_id" ON "chat_message_users" ("chat_message_id") 6117tablechat_message_userschat_message_users CREATE 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")
+
L Y u{ CXB Y }l
T
+ d m d {r!!Atablelocatableslocatables%CREATE TABLE "locatables" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "locatable_id" integer, "locatable_type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)po /tablecompaniescompaniesCREATE TABLE "companies" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(256) NOT NULL, "short_name" varchar(10) NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) 1##}tableadmin_usersadmin_usersCREATE TAB
+t--Gtablelocation_beaconslocation_beacons'CREATE TABLE "location_beacons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "company_id" integer NOT NULL, "mac_address" varchar(12), "uuid" varchar(32) NOT NULL, "major" integer NOT NULL, "minor" integer NOT NULL, "last_known_battery_level" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)?ss!windexindex_locatables_on_locatable_type_and_locatable_idlocatables&CREATE INDEX "index_locatables_on_locatable_type_and_locatable_id" ON "locatables" ("locatable_type", "locatable_id")rp; indexindex_companies_on_namecompaniesCREATE UNIQUE INDEX "index_companies_on_name" ON "companies" ("name")9nQtablechatschatsCREATE TABLE "chats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "creator_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)xmC!indexindex_chat_users_on_user_idchat_usersCREATE INDEX "index_chat_users_on_user_id" ON "chat_users" ("user_id")xlC!indexindex_chat_users_on_chat_idchat_usersCREATE INDEX "index_chat_users_on_chat_id" ON "chat_users" ("chat_id")sk!!1tablechat_userschat_usersCREATE TABLE "chat_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_id" integer, "user_id" integer, "departed_at" datetime(6), "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)jI'%indexindex_chat_messages_on_chat_idchat_messages CREATE INDEX "index_chat_messages_on_chat_id" ON "chat_messages" ("chat_id")
+iM'-indexindex_chat_messages_on_author_idchat_messages CREATE INDEX "index_chat_messages_on_author_id" ON "chat_messages" ("author_id")sh''%tablechat_messageschat_messagesCREATE TABLE "chat_messages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "chat_id" integer, "author_id" integer, "message" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) S19indexindex_chat_message_users_on_user_idchat_message_users CREATE INDEX "index_chat_message_users_on_user_id" ON "chat_message_users" ("user_id") .c1Yindexindex_chat_message_users_on_chat_message_idchat_messagPy{ indexindex_locations_on_parent_location_id_and_kind_and_namelocations"CREATE UNIQUE INDEX "index_locations_on_parent_location_id_and_kind_and_name" ON "locations" ("parent_location_id", "kind", "name")x otablelocationslocations!CREATE TABLE "locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "kind" varchar, "parent_location_id" integer, "unreflected_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) wO%1indexindex_location_gps_on_location_idlocation_gps+CREATE INDEX "index_location_gps_on_location_id" ON "location_gps" ("location_id")v%%ktablelocation_gpslocation_gps)CREATE TABLE "location_gps" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "location_id" integer, "lat" float NOT NULL, "lng" float NOT NULL, "alt" float DEFAULT 0.0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)Rum-indexindex_location_beacons_unique_company_identifierlocation_beacons(CREATE UNIQUE INDEX "index_location_beacons_unique_company_identifier" ON "location_beacons" ("company_id", "uuid", "major", "minor"):qWtablejobsjobs2CREATE TABLE "jobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
-
z
- \
,_h m d 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) OO 1indexindex_locations_on_unreflected_idlocations$CREATE INDEX "index_locations_on_unreflected_id" ON "locations" ("unreflected_id")NW Aindexindex_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")
-L 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) $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)sUA indexindex_projects_on_owner_idprojects1CREATE INDEX "index_projects_on_owner_id" ON "projects" ("owner_id")oT 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)
+
+
@@ -45,11 +45,14 @@
: 9 8 7
- = <
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")
+ = <
I E #-ls i EZ
+
+d xC!indexindex_team_users_on_team_idteam_usersACREATE INDEX "index_team_users_on_team_id" ON "team_users" ("team_id")X!!{tableteam_usersteam_users?CREATE TABLE "team_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "team_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)Iyindexindex_roles_on_user_id_and_ownable_type_and_ownable_idrolesCREATE UNIQUE INDEX "index_roles_on_user_id_and_ownable_type_and_ownable_id" ON "roles" ("user_id", "ownable_type", "ownable_id") aSindexindex_roles_on_ownable_type_and_ownable_idrolesCREATE INDEX "index_roles_on_ownable_type_and_ownable_id" ON "roles" ("ownable_type", "ownable_id")m9tablerolesrolesCREATE TABLE "roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "ownable_id" integer, "ownable_type" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)sA indexindex_projects_on_owner_idprojects1CREATE INDEX "index_projects_on_owner_id" ON "projects" ("owner_id")u =tableprojectsprojects0CREATE TABLE "projects" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "owner_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "default_password" varchar) M%-indexindex_project_jobs_on_project_idproject_jobs6CREATE INDEX "index_project_jobs_on_project_id" ON "project_jobs" ("project_id")0~c%eindexindex_project_jobs_on_project_id_and_job_idproject_jobs5CREATE UNIQUE INDEX "index_project_jobs_on_project_id_and_job_id" ON "project_jobs" ("project_id", "job_id")}}E% indexindex_project_jobs_on_job_idproject_jobs4CREATE INDEX "index_project_jobs_on_job_id" ON "project_jobs" ("job_id")r|%%'tableproject_jobsproject_jobs3CREATE TABLE "project_jobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "job_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) {O 1indexindex_locations_on_unreflected_idlocations$CREATE INDEX "index_locations_on_unreflected_id" ON "locations" ("unreflected_id")zW Aindexindex_locations_on_parent_location_idlocations#CREATE INDEX "index_locations_on_parent_location_id" ON "locations" ("parent_location_id") { indexindex_locations_on_parent_location_id_and_kind_and_namelocations"CREATE UNIQUE INDEX "index_locations_on_parent_location_id_andK))indexindex_user_locations_on_user_iduser_locations/CREATE INDEX "index_user_locations_on_user_id" ON "user_locations" ("user_id")S)9indexindex_user_locations_on_location_iduser_locations.CREATE INDEX "index_user_locations_on_location_id" ON "user_locations" ("location_id")U
)indexindex_user_locations_on_detectable_type_and_detectable_iduser_locations-CREATE INDEX "index_user_locations_on_detectable_type_and_detectable_id" ON "user_locations" ("detectable_type", "detectable_id")C ))Atableuser_locationsuser_locations,CREATE TABLE "user_locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "location_id" integer, "detectable_id" integer, "detectable_type" varchar, "lat" float, "lng" float, "alt" float, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)m ?indexindex_teams_on_project_idteams>CREATE INDEX "index_teams_on_project_id" ON "teams" ("project_id")m
+?indexindex_teams_on_creator_idteams=CREATE INDEX "index_teams_on_creator_id" ON "teams" ("creator_id")_ tableteamsteams<CREATE TABLE "teams" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "project_id" integer, "creator_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)xC!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")
B A ?
- *
O##AAenvironmentdevelopment2019-03-27 19:26:49.7785882019-03-27 19:26:49.778588
+ *
O##AAenvironmentdevelopment2019-03-27 19:26:49.7785882019-03-27 19:26:49.778588
# environment
\ No newline at end of file