From: Alan Knowles Date: Mon, 17 Jul 2017 02:17:12 +0000 (+0800) Subject: sql/core_person.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=5cf29d9ff7f8c3c5f757cb8775acfab02415a15e sql/core_person.sql --- 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';