From ccfa3006e81443969058b30f8f4ab80489c62d27 Mon Sep 17 00:00:00 2001 From: edward Date: Thu, 15 Feb 2018 13:25:17 +0800 Subject: [PATCH] sql/core_ip_access.sql --- sql/core_ip_access.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/core_ip_access.sql b/sql/core_ip_access.sql index ba8d0d9d..9474e3db 100644 --- a/sql/core_ip_access.sql +++ b/sql/core_ip_access.sql @@ -10,7 +10,7 @@ ALTER TABLE core_ip_access ADD COLUMN status INT(2) NOT NULL DEFAULT 0; -- (-1 b 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(254) NOT NULL DEFAULT ''; 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 expire_dt DATE NOT NULL DEFAULT '0000-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; -- 2.39.2