[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 137/323: SQL upgrate : problem with sequence
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 137/323: SQL upgrate : problem with sequence bilan |
Date: |
Wed, 14 Mar 2018 17:38:38 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 34e12972aaa587d5d8504706bb81321a0c9f1fb5
Author: Dany De Bontridder <address@hidden>
Date: Wed Feb 7 10:15:28 2018 +0100
SQL upgrate : problem with sequence bilan
---
include/sql/patch/upgrade125.sql | 5 +++++
1 file changed, 5 insertions(+)
diff --git a/include/sql/patch/upgrade125.sql b/include/sql/patch/upgrade125.sql
index 0e20a89..fe2daf7 100644
--- a/include/sql/patch/upgrade125.sql
+++ b/include/sql/patch/upgrade125.sql
@@ -27,6 +27,11 @@ alter table tmp_pcmn add constraint pcm_direct_use_ck check
(pcm_direct_use in (
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();
+select nextval('bilan_b_id_seq');
+select nextval('bilan_b_id_seq');
+select nextval('bilan_b_id_seq');
+select nextval('bilan_b_id_seq');
+
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] 131/323: upgrade SQL : syntax on FK, (continued)
- [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, 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 <=
- [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
- [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