[Noalyss-commit] [noalyss] 137/323: SQL upgrate : problem with sequence bilan

[Dany De Bontridder]

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;