From 7590c7d461e3b6d235f42ba99dbae907e05bad87 Mon Sep 17 00:00:00 2001 From: remillet Date: Tue, 11 Sep 2018 16:51:16 -0700 Subject: [PATCH] Disable creation of relations_common unique constraint. --- .../nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt b/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt index 4144c65db..e9bb4bd72 100644 --- a/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt +++ b/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt @@ -31,10 +31,10 @@ ALTER TABLE batch_common add CONSTRAINT batchname_unique UNIQUE (name); # # Add constraint to the relations table to prevent duplicate relationships # -LOG.INFO Adding constraint to the relations table to prevent duplicate relationships +#LOG.INFO Adding constraint to the relations table to prevent duplicate relationships #TEST: -SELECT constraint_name FROM information_schema.constraint_column_usage WHERE table_name = 'relations_common' AND constraint_name = 'relations_unique'; +#SELECT constraint_name FROM information_schema.constraint_column_usage WHERE table_name = 'relations_common' AND constraint_name = 'relations_unique'; #IF: emptyResult -ALTER TABLE relations_common add CONSTRAINT relations_unique UNIQUE (subjectcsid, subjectrefname, relationshiptype, objectcsid, objectrefname); +#ALTER TABLE relations_common add CONSTRAINT relations_unique UNIQUE (subjectcsid, subjectrefname, relationshiptype, objectcsid, objectrefname); -- 2.47.3