From: edward Date: Thu, 15 Feb 2018 05:13:03 +0000 (+0800) Subject: sql/core_ip_access.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c5a205e0a12d217ddf610c689a09eee0e0e5a9a1 sql/core_ip_access.sql --- diff --git a/sql/core_ip_access.sql b/sql/core_ip_access.sql index 384816b5..ba8d0d9d 100644 --- a/sql/core_ip_access.sql +++ b/sql/core_ip_access.sql @@ -12,5 +12,6 @@ ALTER TABLE core_ip_access ADD COLUMN authorized_key VARCHAR(254) NOT NULL DEFAU ALTER TABLE core_ip_access ADD COLUMN email VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_ip_access ADD COLUMN expire_dt DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'; 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