[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 130/323: upgrade SQL : issue with trigger on
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 130/323: upgrade SQL : issue with trigger on tmp_pcmn |
Date: |
Wed, 14 Mar 2018 17:38:37 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 440bb578a4052856894f029f567cf6b9139e4791
Author: Dany De Bontridder <address@hidden>
Date: Tue Feb 6 21:39:13 2018 +0100
upgrade SQL : issue with trigger on tmp_pcmn
---
include/sql/patch/upgrade125.sql | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)
diff --git a/include/sql/patch/upgrade125.sql b/include/sql/patch/upgrade125.sql
index ac8dbf5..060db92 100644
--- a/include/sql/patch/upgrade125.sql
+++ b/include/sql/patch/upgrade125.sql
@@ -13,7 +13,8 @@ ALTER TABLE tmp_pcmn ALTER COLUMN id SET DEFAULT
nextval('tmp_pcmn_id_seq'::regc
ALTER TABLE tmp_pcmn ADD CONSTRAINT id_ux UNIQUE(id);
COMMENT ON COLUMN tmp_pcmn.id IS 'allow to identify the row, it is unique and
not null (pseudo pk)';
update tmp_pcmn set id=nextval('tmp_pcmn_id_seq');
-
+drop trigger t_tmp_pcm_alphanum_ins_upd on tmp_pcmn ;
+drop trigger t_tmp_pcmn_ins on tmp_pcmn ;
alter table tmp_pcmn add column pcm_direct_use varchar(1);
COMMENT ON COLUMN tmp_pcmn.pcm_direct_use IS 'Value are N or Y , N cannot be
used directly , not even through a card';
ALTER TABLE tmp_pcmn ALTER COLUMN pcm_direct_use SET DEFAULT 'Y';
@@ -22,6 +23,9 @@ update tmp_pcmn set pcm_direct_use='N' where length(pcm_val)
< 3 and not exists
ALTER TABLE tmp_pcmn ALTER COLUMN pcm_direct_use SET NOT NULL;
alter table tmp_pcmn add constraint pcm_direct_use_ck check (pcm_direct_use in
('Y','N'));
+create trigger t_tmp_pcm_alphanum_ins_upd before insert or update on
tmp_pcmn for each row execute procedure comptaproc.tmp_pcmn_alphanum_ins_upd();
+create trigger t_tmp_pcmn_ins before insert on tmp_pcmn for each row
execute procedure comptaproc.tmp_pcmn_ins();
+
insert into bilan (b_name,b_file_template,b_file_form,b_type) values
('ASBL','document/fr_be/bnb-asbl.rtf','document/fr_be/bnb-asbl.form','RTF');
alter table jnt_letter drop jl_amount_deb;
- [Noalyss-commit] [noalyss] 124/323: Fix : logo and new style by default, (continued)
- [Noalyss-commit] [noalyss] 124/323: Fix : logo and new style by default, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 125/323: fix : managetable correct position, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 114/323: New : code for progress bar, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 129/323: Small bug : new structure for table version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 126/323: fix : typo default theme Classic7, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 121/323: use icon_action::icon_magnify instead of icon, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 128/323: Improve CSS, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 109/323: update account_repository (to review), Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 131/323: upgrade SQL : syntax on FK, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 127/323: Esthetic, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 130/323: upgrade SQL : issue with trigger on tmp_pcmn,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 132/323: set version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 133/323: Fix bug for updating, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 123/323: SQL : patch for new version CSS : install new theme, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 113/323: indent, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 134/323: Bug : cannot update payment, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 135/323: CSS : cosmetic menu, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 138/323: CSS : reduce height menu, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 137/323: SQL upgrate : problem with sequence bilan, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 136/323: SQL upgrate : drop trigger before update, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 139/323: Bug : ANC ND VAT not computed, Dany De Bontridder, 2018/03/14