From dd99ab29a44e7ad15cc1e89139ada88000168eb5 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:07:10 +0800 Subject: [PATCH] sql/core_ip_access.sql --- sql/core_ip_access.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/sql/core_ip_access.sql b/sql/core_ip_access.sql index 3009f82e..fa1d8f79 100644 --- a/sql/core_ip_access.sql +++ b/sql/core_ip_access.sql @@ -15,4 +15,7 @@ ALTER TABLE core_ip_access CHANGE COLUMN expire_dt expire_dt DATE NOT NULL DEFAU ALTER TABLE core_ip_access ADD COLUMN user_agent VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_ip_access ADD COLUMN updated_by INT(11) NOT NULL DEFAULT 0; -ALTER TABLE core_ip_access ADD INDEX ip_status_lookup(ip, status); \ No newline at end of file +ALTER TABLE core_ip_access ADD INDEX ip_status_lookup(ip, status); + +ALTER TABLE core_ip_access ADD INDEX lookup_authorized_by (authorized_by); +ALTER TABLE core_ip_access ADD INDEX lookup_updated_by (updated_by); \ No newline at end of file -- 2.39.2