[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 89/119: upgrade db 146
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 89/119: upgrade db 146 |
Date: |
Mon, 26 Oct 2020 18:27:32 -0400 (EDT) |
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;
- [Noalyss-commit] [noalyss] 51/119: Add group of tag to an action, (continued)
- [Noalyss-commit] [noalyss] 51/119: Add group of tag to an action, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 59/119: prevent divide by zero in formula, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 65/119: Rewriting of card attributes, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 69/119: Improve Input_Switch , do not echo but returns string, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 66/119: Multiple contact Search on selected attribute, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 77/119: fix upgrade145.sql , default value must be 1 for actif, sql wrong, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 78/119: Fix FollowUp : price Purchase or Sale, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 79/119: protect, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 86/119: Follow up cosmetic add title to anchor, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 87/119: Document Type : CFGACTION cannot add new document, fix order in dialog box, Fix= cannot delete action cause cascade on action_person, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 89/119: upgrade db 146,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 91/119: Follow-up correct link, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 97/119: Fix : generate document remove "extract", Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 105/119: Follow-Up Cosmetic, form before creating a new follow-up action, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 109/119: Remove select_dialog file, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 117/119: Follow-up export contact option with all the the card's attribute, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 94/119: typo : tag instead of étiquette, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 71/119: Search on active card for Contact Multiple, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 95/119: fix : select_box search doesn't work, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 12/119: Bug 1834 : duplicate , cannot confirm an duplicated operation because the $_GET is taken in priority, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 16/119: Predefined Operation rewriting, Dany De Bontridder, 2020/10/26