From 5502655ef09b09e7c93fe594acb889aa249dd938 Mon Sep 17 00:00:00 2001 From: Richard Millet Date: Tue, 12 Apr 2016 09:56:54 -0700 Subject: [PATCH] CSPACE-6937: Adding constraint to persons_common's short id column. --- .../nuxeo-server/6.0-HF21/config/vcsconfig.sql.txt | 12 ++++++++++++ .../main/resources/collectionspace-client.properties | 4 ++-- 2 files changed, 14 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 080809451..577a639d9 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 @@ -16,6 +16,18 @@ SELECT constraint_name FROM information_schema.constraint_column_usage WHERE tab #IF: emptyResult ALTER TABLE vocabularies_common add CONSTRAINT shortid_unique UNIQUE (shortidentifier); +# +# Add a unique constraint to the shortidentifier column of the persons_common table. +# +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'; + +#IF: emptyResult +ALTER TABLE persons_common add CONSTRAINT shortid_unique UNIQUE (shortidentifier); + + # # Add a unique constraint to the report 'name' column of the reports_common table. # diff --git a/services/client/src/main/resources/collectionspace-client.properties b/services/client/src/main/resources/collectionspace-client.properties index 75cb8b86d..d077dd6be 100644 --- a/services/client/src/main/resources/collectionspace-client.properties +++ b/services/client/src/main/resources/collectionspace-client.properties @@ -9,8 +9,8 @@ cspace.url=http://localhost:8180/cspace-services/ cspace.ssl=false cspace.auth=true # default user -cspace.user=admin@core.collectionspace.org -#cspace.user=admin@testsci.collectionspace.org +#cspace.user=admin@core.collectionspace.org +cspace.user=admin@testsci.collectionspace.org cspace.password=Administrator # default tenant cspace.tenant=1 -- 2.47.3