[Phpcompta-dev] r548 - tag/rel700/rapport_avance/sql

[phpcompta-dev]

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

Modified:
   tag/rel700/rapport_avance/sql/upgrade4.sql
Log:
rapav: Correct script upgrade 


Modified: tag/rel700/rapport_avance/sql/upgrade4.sql
===================================================================
--- tag/rel700/rapport_avance/sql/upgrade4.sql  2013-10-23 19:14:48 UTC (rev 
547)
+++ tag/rel700/rapport_avance/sql/upgrade4.sql  2013-10-23 19:19:05 UTC (rev 
548)
@@ -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