From ee311bd827d6b2c1918b0d50f5c88eda2565e270 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:01:32 +0800 Subject: [PATCH] sql/events.sql --- sql/events.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/events.sql b/sql/events.sql index f3c1ad58..7998e173 100644 --- a/sql/events.sql +++ b/sql/events.sql @@ -38,6 +38,8 @@ ALTER TABLE Events CHANGE COLUMN action action varchar(64) default NULL; ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_when, person_table); +ALTER TABLE Events ADD INDEX lookup_person_id (person_id); + -- #Keep for later use.. -- ALTER TABLE Events CHANGE COLUMN person_name person_name VARCHAR(128) NOT NULL ; -- 2.39.2