From: edward <edward@roojs.com>
Date: Wed, 24 Aug 2016 08:21:36 +0000 (+0800)
Subject: sql/Person.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=6d0d7fba9a0d36c77dca0199fc8bc97ef0abb515

sql/Person.sql
---

diff --git a/sql/Person.sql b/sql/Person.sql
index 344e88a3..1ad4e551 100644
--- a/sql/Person.sql
+++ b/sql/Person.sql
@@ -22,7 +22,7 @@ ALTER TABLE Person ADD COLUMN   remarks text NOT NULL;
 ALTER TABLE Person ADD COLUMN   lang varchar(8) default 'en';
 ALTER TABLE Person ADD COLUMN   country varchar(8) default '';
 
-ALTER TABLE Person ADD COLUMN   birth_date DATE NOT NULL DEFAULT '1969-01-01';
+ALTER TABLE Person ADD COLUMN   birth_date DATE NOT NULL DEFAULT '0000-00-00';
 
 -- main contact details
 ALTER TABLE Person ADD COLUMN   email varchar(256)  NOT NULL DEFAULT '';