[Phpcompta-dev] r4702 - in phpcompta/trunk: html/admin/sql/patch include

[phpcompta-dev]

Author: danydb
Date: 2012-01-09 21:48:49 +0100 (Mon, 09 Jan 2012)
New Revision: 4702

Added:
   phpcompta/trunk/html/admin/sql/patch/upgrade100.sql
Modified:
   phpcompta/trunk/include/constant.php
Log:
SQL patch add ad_extra


Added: phpcompta/trunk/html/admin/sql/patch/upgrade100.sql
===================================================================
--- phpcompta/trunk/html/admin/sql/patch/upgrade100.sql                         
(rev 0)
+++ phpcompta/trunk/html/admin/sql/patch/upgrade100.sql 2012-01-09 20:48:49 UTC 
(rev 4702)
@@ -0,0 +1,22 @@
+begin;
+alter table attr_def add ad_extra text ;
+
+insert into attr_def (ad_id,ad_text,ad_type,ad_size) values (33,'Date 
Fin','date',8);
+
+ALTER TABLE fiche_detail DROP CONSTRAINT "$2";
+
+ALTER TABLE fiche_detail
+  ADD CONSTRAINT fiche_detail_attr_def_fk FOREIGN KEY (ad_id)
+      REFERENCES attr_def (ad_id) MATCH SIMPLE
+      ON UPDATE cascade ON DELETE cascade;
+
+ALTER TABLE jnt_fic_attr DROP CONSTRAINT "$2";
+
+ALTER TABLE jnt_fic_attr
+  ADD CONSTRAINT jnt_fic_attr_attr_def_fk FOREIGN KEY (ad_id)
+      REFERENCES attr_def (ad_id) MATCH SIMPLE
+      ON UPDATE cascade ON DELETE cascade;
+
+update version set val=100;
+
+commit;
\ No newline at end of file

Modified: phpcompta/trunk/include/constant.php
===================================================================
--- phpcompta/trunk/include/constant.php        2012-01-09 20:43:48 UTC (rev 
4701)
+++ phpcompta/trunk/include/constant.php        2012-01-09 20:48:49 UTC (rev 
4702)
@@ -31,8 +31,8 @@
 
 global $g_captcha,$g_failed,$g_succeed;
 $g_captcha=false;
-$g_failed="<span style=\"font-size:18px;color:red\">&#x2716;</span>";          
                                                                                
                                                                                
-$g_succeed="<span style=\"font-size:18px;color:green\">&#x2713;</span>";  
+$g_failed="<span style=\"font-size:18px;color:red\">&#x2716;</span>";
+$g_succeed="<span style=\"font-size:18px;color:green\">&#x2713;</span>";
 /*set to none for production */
 /* uncomment for production */
 // $version_phpcompta=4620;
@@ -42,9 +42,11 @@
 $version_phpcompta=SVNINFO;
 define ("DEBUG",false);
 
+/* $version_phpcompta=4601;
+define ("DEBUG",true); */
 
+define ("DBVERSION",101);
 
-define ("DBVERSION",100);
 define ("DBVERSIONREPO",14);
 define ('NOTFOUND','--not found--');