From 5cf29d9ff7f8c3c5f757cb8775acfab02415a15e Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 17 Jul 2017 10:17:12 +0800 Subject: [PATCH] sql/core_person.sql --- sql/core_person.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/core_person.sql b/sql/core_person.sql index 1ae3a385..f229ff73 100644 --- a/sql/core_person.sql +++ b/sql/core_person.sql @@ -22,7 +22,7 @@ ALTER TABLE core_person ADD COLUMN remarks text NOT NULL; ALTER TABLE core_person ADD COLUMN lang varchar(8) default 'en'; ALTER TABLE core_person ADD COLUMN country varchar(8) default ''; --- do not set SQL mode here - it needs to be done in the config +-- do not set SQL mode here - it needs to be done in the mysql config -- SET SQL_MODE='ALLOW_INVALID_DATES'; ALTER TABLE core_person ADD COLUMN birth_date DATE NOT NULL DEFAULT '0000-00-00'; -- 2.39.2