[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 136/323: SQL upgrate : drop trigger before up
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 136/323: SQL upgrate : drop trigger before update |
Date: |
Wed, 14 Mar 2018 17:38:38 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit d6868e472b01cf207616d0e33baa6dd662fd719b
Author: Dany De Bontridder <address@hidden>
Date: Wed Feb 7 10:10:03 2018 +0100
SQL upgrate : drop trigger before update
---
include/sql/patch/upgrade125.sql | 7 ++++---
1 file changed, 4 insertions(+), 3 deletions(-)
diff --git a/include/sql/patch/upgrade125.sql b/include/sql/patch/upgrade125.sql
index 5cfe93f..0e20a89 100644
--- a/include/sql/patch/upgrade125.sql
+++ b/include/sql/patch/upgrade125.sql
@@ -4,6 +4,9 @@ set search_path to public,comptaproc;
alter table action_gestion drop ag_ref_ag_id;
+drop trigger t_tmp_pcm_alphanum_ins_upd on tmp_pcmn ;
+drop trigger t_tmp_pcmn_ins on tmp_pcmn ;
+
create sequence tmp_pcmn_id_seq;
ALTER TABLE tmp_pcmn ADD COLUMN id bigint;
update tmp_pcmn set id=nextval('tmp_pcmn_id_seq');
@@ -13,8 +16,6 @@ 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';
@@ -110,4 +111,4 @@ alter table version alter v_date set default now();
alter table version add primary key (val);
insert into version (val,v_description) values (126,'Add filter for search,
inactive tag or ledger, type of operation, security');
-commit;
\ No newline at end of file
+commit;
- [Noalyss-commit] [noalyss] 127/323: Esthetic, (continued)
- [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, 2018/03/14
- [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 <=
- [Noalyss-commit] [noalyss] 139/323: Bug : ANC ND VAT not computed, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 141/323: Set version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 144/323: merge rel6919.9, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 140/323: Bug : ANC ND VAT not computed, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 142/323: set version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 149/323: Fix : duplicate id (exercice), Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 143/323: set version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 148/323: Fix : ajax_history : history of accounting , exercice was not set, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 150/323: Fix : PRINTJRN export CSV $Jrn used before created, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 153/323: FIX : PRINTJRN, ledger PDF, Dany De Bontridder, 2018/03/14