Fix old SQL creation script

[galette.git] / tests / mysql_06.sql

diff --git a/tests/mysql_06.sql b/tests/mysql_06.sql
index ac910935df203ef2e2292df9c600f100a69cae50..fc5c730e20c16a3825f407c1ed09d55758da4168 100644 (file)
--- a/tests/mysql_06.sql
+++ b/tests/mysql_06.sql
@@ -24,7 +24,7 @@ CREATE TABLE adherents (
   prof_adh varchar(150) default NULL,
   login_adh varchar(20) NOT NULL default '',
   mdp_adh varchar(20) NOT NULL default '',
-  date_crea_adh date NOT NULL default '0000-00-00',
+  date_crea_adh date NOT NULL default '1901-01-01',
   activite_adh enum('0','1') NOT NULL default '0',
   bool_admin_adh enum('1') default NULL,
   bool_exempt_adh enum('1') default NULL,
@@ -41,7 +41,7 @@ CREATE TABLE cotisations (
   montant_cotis float unsigned default '0',
   info_cotis text,
   duree_mois_cotis tinyint(3) unsigned NOT NULL default '12',
-  date_cotis date NOT NULL default '0000-00-00',
+  date_cotis date NOT NULL default '1901-01-01',
   PRIMARY KEY  (id_cotis)
 ) ENGINE=MyISAM;