From 18f27fb526c772ed7baacda4382b5e3075911db2 Mon Sep 17 00:00:00 2001 From: Richard Millet Date: Wed, 13 Apr 2016 10:15:37 -0700 Subject: [PATCH] CSPACE-6937: Fixed name of unique constraint for persons_common's short ID column. --- 3rdparty/nuxeo/nuxeo-server/6.0-HF21/config/vcsconfig.sql.txt | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/3rdparty/nuxeo/nuxeo-server/6.0-HF21/config/vcsconfig.sql.txt b/3rdparty/nuxeo/nuxeo-server/6.0-HF21/config/vcsconfig.sql.txt index 577a639d9..57f78f8fc 100644 --- a/3rdparty/nuxeo/nuxeo-server/6.0-HF21/config/vcsconfig.sql.txt +++ b/3rdparty/nuxeo/nuxeo-server/6.0-HF21/config/vcsconfig.sql.txt @@ -22,10 +22,10 @@ ALTER TABLE vocabularies_common add CONSTRAINT shortid_unique UNIQUE (shortident LOG.INFO Adding a unique constraint to the shortidentifier column of the persons_common table #TEST: -SELECT constraint_name FROM information_schema.constraint_column_usage WHERE table_name = 'persons_common' AND constraint_name = 'shortid_unique'; +SELECT constraint_name FROM information_schema.constraint_column_usage WHERE table_name = 'persons_common' AND constraint_name = 'persons_shortid_unique'; #IF: emptyResult -ALTER TABLE persons_common add CONSTRAINT shortid_unique UNIQUE (shortidentifier); +ALTER TABLE persons_common add CONSTRAINT persons_shortid_unique UNIQUE (shortidentifier); # -- 2.47.3