From: Alan Knowles <alan@roojs.com>
Date: Mon, 17 Jul 2017 02:17:23 +0000 (+0800)
Subject: sql/core_person.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a0c944d9b22c886f7c2016b655bfa214295d06b6

sql/core_person.sql
---

diff --git a/sql/core_person.sql b/sql/core_person.sql
index f229ff73..79d11f74 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 mysql config
+-- do not set SQL mode here - it needs to be done in the mysql config (updatedatabase checks for this)
 -- SET SQL_MODE='ALLOW_INVALID_DATES';
 ALTER TABLE core_person ADD COLUMN   birth_date DATE NOT NULL DEFAULT '0000-00-00';