Fix old SQL creation script

diff --git a/galette/install/scripts/upgrade-to-0.63-mysql.sql b/galette/install/scripts/upgrade-to-0.63-mysql.sql
index 316160a001514563ceda1b9c3dad2b4c22b24557..e2a968ab8e51b7415a97a25c82c0912e578c3db3 100644 (file)
--- a/galette/install/scripts/upgrade-to-0.63-mysql.sql
+++ b/galette/install/scripts/upgrade-to-0.63-mysql.sql
@@ -42,7 +42,7 @@ CREATE TABLE galette_dynamic_fields (
     field_id int(10) NOT NULL default '0',
     field_form varchar(10) NOT NULL,
     val_index int(10) NOT NULL default '0',
-    field_val text DEFAULT '',
+    field_val text,
     KEY  (item_id)
 ) ENGINE=MyISAM;
 
@@ -60,9 +60,9 @@ ALTER TABLE galette_logs ADD action_log text;
 ALTER TABLE galette_logs ADD sql_log text;
 
 -- Change table cotisations to store date_fin_cotis instead of duration;
-ALTER TABLE galette_cotisations ADD date_enreg date NOT NULL default '0000-00-00';
-ALTER TABLE galette_cotisations ADD date_debut_cotis date NOT NULL default '0000-00-00';
-ALTER TABLE galette_cotisations ADD date_fin_cotis date NOT NULL default '0000-00-00';
+ALTER TABLE galette_cotisations ADD date_enreg date NOT NULL default '1901-01-01';
+ALTER TABLE galette_cotisations ADD date_debut_cotis date NOT NULL default '1901-01-01';
+ALTER TABLE galette_cotisations ADD date_fin_cotis date NOT NULL default '1901-01-01';
 UPDATE galette_cotisations
     SET date_enreg=date_cotis,
         date_debut_cotis=date_cotis,
@@ -89,7 +89,7 @@ CREATE TABLE galette_l10n (
 DROP TABLE IF EXISTS galette_transactions;
 CREATE TABLE galette_transactions (
   trans_id int(10) unsigned NOT NULL auto_increment,
-  trans_date date NOT NULL default '0000-00-00',
+  trans_date date NOT NULL default '1901-01-01',
   trans_amount float default '0',
   trans_desc varchar(30) NOT NULL default '',
   id_adh int(10) unsigned default NULL,

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;