[Noalyss-commit] [noalyss] 177/219: Repository add unique constraint for jnt_use_doc

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 0097ba431d2e63f1ab08bd9fa3cffcfa27daec17
Author: Dany De Bontridder <address@hidden>
Date:   Fri Dec 1 20:29:54 2017 +0100

    Repository add unique constraint for jnt_use_doc
---
 sql/upgrade.sql | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 859f932..f606086 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1,6 +1,13 @@
+
+
 alter table action_gestion drop ag_ref_ag_id;
---- repository insert into theme (the_name,the_filestyle) values ('Classic 
692','style-r692.css');
+/* --- repository 
+-- add style
+insert into theme (the_name,the_filestyle) values ('Classic 
692','style-r692.css');
 
+-- add constraint
+alter table jnt_use_dos add CONSTRAINT use_id_dos_id_uniq UNIQUE 
(use_id,dos_id);
+*/
 create sequence tmp_pcmn_id_seq;
 ALTER TABLE tmp_pcmn ADD COLUMN id bigint;
 update tmp_pcmn set id=nextval('tmp_pcmn_id_seq');