[Phpcompta-dev] r4627 - phpcompta/trunk/sql

[phpcompta-dev]

Author: danydb
Date: 2011-12-19 11:03:59 +0100 (Mon, 19 Dec 2011)
New Revision: 4627

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:

Update jrnx: remove comment if it is the comment in jrn table 

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2011-12-19 09:55:42 UTC (rev 4626)
+++ phpcompta/trunk/sql/upgrade.sql     2011-12-19 10:03:59 UTC (rev 4627)
@@ -1,28 +1 @@
-CREATE OR REPLACE FUNCTION comptaproc.get_menu_dependency(profile_menu_id int)
-  RETURNS SETOF int AS
-$BODY$
-declare
-       i int;
-       x int;
-       e int;
-begin
-       for x in select pm_id,me_code
-                       from profile_menu
-                       where me_code_dep in (select me_code from profile_menu 
where pm_id=profile_menu_id)
-                       and p_id = (select p_id from profile_menu where 
pm_id=profile_menu_id)
-       loop
-               return next x;
-
-       for e in select *  from comptaproc.get_menu_dependency_pm(x)
-               loop
-                       return next e;
-               end loop;
-
-       end loop;
-       return;
-end;
-$BODY$
-LANGUAGE plpgsql;
-
-delete from profile_menu where p_id=2 and me_code_dep='DIVPARM';
-delete from profile_menu where p_id=2 and me_code_dep='MOD';
+update jrnx set j_text = null from jrn where jr_grpt_id=j_grpt and 
j_text=jr_comment;