[Phpcompta-dev] r549 - in trunk: . rapport_avance/sql

[phpcompta-dev]

Author: danydb
Date: 2013-10-23 21:19:57 +0200 (Wed, 23 Oct 2013)
New Revision: 549

Modified:
   trunk/
   trunk/rapport_avance/sql/upgrade4.sql
Log:
Merged revisions 548 via svnmerge from 
svn+ssh://address@hidden/svn_extension/tag/rel700

........
  r548 | danydb | 2013-10-23 21:19:05 +0200 (mer., 23 oct. 2013) | 2 lines
  
  rapav: Correct script upgrade 
........



Property changes on: trunk
___________________________________________________________________
Name: svnmerge-integrated
   - /tag/rel700:1-546
   + /tag/rel700:1-548

Modified: trunk/rapport_avance/sql/upgrade4.sql
===================================================================
--- trunk/rapport_avance/sql/upgrade4.sql       2013-10-23 19:19:05 UTC (rev 
548)
+++ trunk/rapport_avance/sql/upgrade4.sql       2013-10-23 19:19:57 UTC (rev 
549)
@@ -3,7 +3,7 @@
 ALTER TABLE rapport_advanced.formulaire_param_detail   ADD COLUMN jrn_def_id 
bigint;
 COMMENT ON COLUMN rapport_advanced.formulaire_param_detail.jrn_def_id IS 'FK 
to jrn_def, if null then all the ledgers are concerned';
 
-CREATE FUNCTION formulaire_param_detail_jrn_def_id_ins_upd() RETURNS trigger
+CREATE FUNCTION rapport_advanced.formulaire_param_detail_jrn_def_id_ins_upd() 
RETURNS trigger
     AS $$
 declare
        jrn_def_id integer;
@@ -13,7 +13,8 @@
                NEW.jrn_def_id := jrn_def_id;
        end if;
        return NEW;
-end;$$;
+end;
+$$
 language plpgsql;
 
 CREATE INDEX fki_jrn_def_id ON rapport_advanced.formulaire_param_detail USING 
btree (jrn_def_id);



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