[Phpcompta-dev] r5575 - in phpcompta/tags/rel670: html/admin/sql/patch include

[phpcompta-dev]

Author: danydb
Date: 2013-12-06 14:40:41 +0100 (Fri, 06 Dec 2013)
New Revision: 5575

Added:
   phpcompta/tags/rel670/html/admin/sql/patch/upgrade109.sql
Modified:
   phpcompta/tags/rel670/include/constant.php
Log:
Release

Added: phpcompta/tags/rel670/html/admin/sql/patch/upgrade109.sql
===================================================================
--- phpcompta/tags/rel670/html/admin/sql/patch/upgrade109.sql                   
        (rev 0)
+++ phpcompta/tags/rel670/html/admin/sql/patch/upgrade109.sql   2013-12-06 
13:40:41 UTC (rev 5575)
@@ -0,0 +1,32 @@
+begin;
+
+alter table jrn_def add jrn_def_description text;
+
+CREATE OR REPLACE FUNCTION comptaproc.t_jrn_def_description()
+ RETURNS trigger
+AS $function$
+    declare
+        str varchar(200);
+    BEGIN
+        str := substr(NEW.jrn_def_description,1,200);
+        NEW.jrn_def_description := str;
+
+        RETURN NEW;
+    END;
+$function$
+ LANGUAGE plpgsql
+;
+create  trigger jrn_def_description_ins_upd before insert or update on jrn_def 
for each row execute procedure comptaproc.t_jrn_def_description();
+
+update jrn_def set jrn_def_description='Concerne tous les achats, factures 
reçues, notes de crédit reçues et notes de frais' where jrn_def_id=3;
+update jrn_def set jrn_def_description='Concerne tous les mouvements 
financiers (comptes en banque, caisses, visa...)' where jrn_def_id=1;
+update jrn_def set jrn_def_description='Concerne toutes les opérations comme 
les amortissements, les comptes TVA, ...' where jrn_def_id=4;
+update jrn_def set jrn_def_description='Concerne toutes les ventes, notes de 
crédit envoyées' where jrn_def_id=2;
+
+alter table document add d_description text;
+
+update document set d_description = d_filename;
+
+update version set val=110;
+
+commit;
\ No newline at end of file

Modified: phpcompta/tags/rel670/include/constant.php
===================================================================
--- phpcompta/tags/rel670/include/constant.php  2013-12-06 13:38:08 UTC (rev 
5574)
+++ phpcompta/tags/rel670/include/constant.php  2013-12-06 13:40:41 UTC (rev 
5575)
@@ -71,7 +71,7 @@
 define 
("SITE_UPDATE_PLUGIN",'http://www.phpcompta.eu/plugin_last_version.txt');
 
 
-define ("DBVERSION",109);
+define ("DBVERSION",110);
 define ("MONO_DATABASE",25);
 define ("DBVERSIONREPO",14);
 define ('NOTFOUND','--not found--');



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu