[Noalyss-commit] [noalyss] 131/323: upgrade SQL : syntax on FK

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 8d6ae4d20ccee12159747c42060ecc69ac6e8a8b
Author: Dany De Bontridder <address@hidden>
Date:   Tue Feb 6 21:42:31 2018 +0100

    upgrade SQL : syntax on FK
---
 include/sql/patch/upgrade125.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/include/sql/patch/upgrade125.sql b/include/sql/patch/upgrade125.sql
index 060db92..5cfe93f 100644
--- a/include/sql/patch/upgrade125.sql
+++ b/include/sql/patch/upgrade125.sql
@@ -31,7 +31,7 @@ insert into bilan (b_name,b_file_template,b_file_form,b_type) 
values ('ASBL','do
 alter table jnt_letter drop jl_amount_deb;
 
 ALTER TABLE operation_analytique ADD COLUMN f_id bigint;
-ALTER TABLE operation_analytique  ADD CONSTRAINT 
operation_analytique_fiche_id_fk FOREIGN KEY (f_id)       REFERENCES fiche 
(f_id) MATCH SIMPLE       ON UPDATE cascade ON cascade;
+ALTER TABLE operation_analytique  ADD CONSTRAINT 
operation_analytique_fiche_id_fk FOREIGN KEY (f_id)       REFERENCES fiche 
(f_id) MATCH SIMPLE       ON UPDATE cascade ON delete cascade;
 COMMENT ON COLUMN operation_analytique.f_id IS 'FK to fiche.f_id , used only 
with ODS';
 
 drop FUNCTION comptaproc.table_analytic_account(text,text);