[Noalyss-commit] [noalyss] branch devel updated: upgrade.sql -> upgrade191.sql

[dwm]

This is an automated email from the git hooks/post-receive script.

sparkyx pushed a commit to branch devel
in repository noalyss.

The following commit(s) were added to refs/heads/devel by this push:
     new 187ca5886 upgrade.sql -> upgrade191.sql
     new f8baa9b30 merge
187ca5886 is described below

commit 187ca58864c9fbf52c30aec335773bcc4d728976
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Wed Jan 17 19:02:31 2024 +0100

    upgrade.sql -> upgrade191.sql
---
 include/constant.php                               |  2 +-
 .../sql/patch/upgrade191.sql                       |  9 ++++---
 sql/upgrade.sql                                    | 28 ----------------------
 3 files changed, 7 insertions(+), 32 deletions(-)

diff --git a/include/constant.php b/include/constant.php
index 5ac2b51c3..05c93f435 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -123,7 +123,7 @@ if (!defined("NOALYSS_PACKAGE_REPOSITORY")) {
 if (!defined("SYSINFO_DISPLAY")) {
     define("SYSINFO_DISPLAY", TRUE);
 }
-define("DBVERSION", 191);
+define("DBVERSION", 192);
 define("MONO_DATABASE", 25);
 define("DBVERSIONREPO", 20);
 define('NOTFOUND', '--not found--');
diff --git a/sql/upgrade.sql b/include/sql/patch/upgrade191.sql
similarity index 82%
copy from sql/upgrade.sql
copy to include/sql/patch/upgrade191.sql
index 118d757f2..e167e013c 100644
--- a/sql/upgrade.sql
+++ b/include/sql/patch/upgrade191.sql
@@ -1,3 +1,5 @@
+begin;
+
 CREATE OR REPLACE FUNCTION comptaproc.get_follow_up_tree(action_gestion_id 
integer)
     RETURNS SETOF integer
 
@@ -23,6 +25,7 @@ begin
         end loop;
     return;
 end;
-$function$
-;
-        
\ No newline at end of file
+$function$;
+
+insert into version (val,v_description) values (192,'2323 : tree for depending 
event');
+commit;
\ No newline at end of file
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 118d757f2..e69de29bb 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1,28 +0,0 @@
-CREATE OR REPLACE FUNCTION comptaproc.get_follow_up_tree(action_gestion_id 
integer)
-    RETURNS SETOF integer
-
-    LANGUAGE plpgsql
-AS $function$
-declare
-    i int;
-    x int;
-    e int;
-begin
-    for x in select aga_least
-             from action_gestion_related
-             where
-                 aga_greatest = action_gestion_id
-        loop
-            return next x;
-
-            for e in select *  from  comptaproc.get_follow_up_tree(x)
-                loop
-                    return next e;
-                end loop;
-
-        end loop;
-    return;
-end;
-$function$
-;
-        
\ No newline at end of file