From dacd00695ee7152dc4b714bd978f4747735acdb3 Mon Sep 17 00:00:00 2001 From: edward Date: Mon, 15 Jan 2018 15:40:45 +0800 Subject: [PATCH] sql/core_ip_access.sql --- sql/core_ip_access.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/sql/core_ip_access.sql b/sql/core_ip_access.sql index aba62458..116cbe1d 100644 --- a/sql/core_ip_access.sql +++ b/sql/core_ip_access.sql @@ -8,6 +8,7 @@ ALTER TABLE core_ip_access ADD COLUMN ip VARCHAR(32) NOT NULL DEFAULT ''; ALTER TABLE core_ip_access ADD COLUMN created_dt DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'; ALTER TABLE core_ip_access ADD COLUMN status INT(2) NOT NULL DEFAULT 0; -- (-1 blocked, 0 new, 1 approved) ALTER TABLE core_ip_access ADD COLUMN authorized_by INT(11) NOT NULL DEFAULT 0; -ALTER TABLE core_ip_access ADD COLUMN authorized_key VARCHAR(256) NOT NULL DEFAULT ''; +ALTER TABLE core_ip_access ADD COLUMN authorized_key VARCHAR(254) NOT NULL DEFAULT ''; +ALTER TABLE core_ip_access ADD COLUMN email VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_ip_access ADD INDEX ip_status_lookup(ip, status); \ No newline at end of file -- 2.39.2