[Noalyss-commit] [noalyss] 89/119: upgrade db 146

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 5a9c4eeab92597bb4e86704c292f6762cd4affcb
Author: Dany De Bontridder <danydb@noalyss.eu>
AuthorDate: Mon Oct 12 18:37:42 2020 +0200

    upgrade db 146
---
 include/constant.php                                | 2 +-
 sql/upgrade.sql => include/sql/patch/upgrade146.sql | 5 +++++
 sql/upgrade.sql                                     | 2 --
 3 files changed, 6 insertions(+), 3 deletions(-)

diff --git a/include/constant.php b/include/constant.php
index 7382a81..8168e6b 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -107,7 +107,7 @@ if ( !defined ("NOALYSS_PACKAGE_REPOSITORY")) {
 if ( ! defined ("SYSINFO_DISPLAY")) {
     define ("SYSINFO_DISPLAY",TRUE);
 }
-define ("DBVERSION",146);
+define ("DBVERSION",147);
 define ("MONO_DATABASE",25);
 define ("DBVERSIONREPO",18);
 define ('NOTFOUND','--not found--');
diff --git a/sql/upgrade.sql b/include/sql/patch/upgrade146.sql
similarity index 69%
copy from sql/upgrade.sql
copy to include/sql/patch/upgrade146.sql
index 847dce7..25ffcf0 100644
--- a/sql/upgrade.sql
+++ b/include/sql/patch/upgrade146.sql
@@ -1,2 +1,7 @@
+begin;
+
 ALTER TABLE public.action_person drop CONSTRAINT action_gestion_ag_id_fk2 ;
 ALTER TABLE public.action_person ADD CONSTRAINT action_gestion_ag_id_fk2 
FOREIGN KEY (ag_id) REFERENCES action_gestion(ag_id) on delete cascade on 
update cascade;
+
+insert into version (val,v_description) values (147,'Cascade delete on 
action_gestion');
+commit;
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 847dce7..e69de29 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1,2 +0,0 @@
-ALTER TABLE public.action_person drop CONSTRAINT action_gestion_ag_id_fk2 ;
-ALTER TABLE public.action_person ADD CONSTRAINT action_gestion_ag_id_fk2 
FOREIGN KEY (ag_id) REFERENCES action_gestion(ag_id) on delete cascade on 
update cascade;