You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by ma...@apache.org on 2019/02/05 18:56:42 UTC
[airavata] branch develop updated: AIRAVATA-2938 Fixing UNIQUE
constraint
This is an automated email from the ASF dual-hosted git repository.
machristie pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/develop by this push:
new 94d4b8c AIRAVATA-2938 Fixing UNIQUE constraint
94d4b8c is described below
commit 94d4b8c984064bcc0a80d0cd39e96071a1e6b7d8
Author: Marcus Christie <ma...@apache.org>
AuthorDate: Tue Feb 5 13:56:29 2019 -0500
AIRAVATA-2938 Fixing UNIQUE constraint
---
modules/registry-refactoring/src/main/resources/expcatalog-derby.sql | 2 +-
modules/registry-refactoring/src/main/resources/expcatalog-mysql.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/modules/registry-refactoring/src/main/resources/expcatalog-derby.sql b/modules/registry-refactoring/src/main/resources/expcatalog-derby.sql
index 06217be..ebb4a58 100644
--- a/modules/registry-refactoring/src/main/resources/expcatalog-derby.sql
+++ b/modules/registry-refactoring/src/main/resources/expcatalog-derby.sql
@@ -65,7 +65,7 @@ CREATE TABLE USERS
GATEWAY_ID VARCHAR(255) NOT NULL,
PRIMARY KEY (GATEWAY_ID, USER_NAME),
FOREIGN KEY (GATEWAY_ID) REFERENCES GATEWAY(GATEWAY_ID) ON DELETE CASCADE,
- UNIQUE KEY (AIRAVATA_INTERNAL_USER_ID)
+ UNIQUE (AIRAVATA_INTERNAL_USER_ID)
);
CREATE TABLE GATEWAY_WORKER
diff --git a/modules/registry-refactoring/src/main/resources/expcatalog-mysql.sql b/modules/registry-refactoring/src/main/resources/expcatalog-mysql.sql
index fa9c5ba..068daeb 100644
--- a/modules/registry-refactoring/src/main/resources/expcatalog-mysql.sql
+++ b/modules/registry-refactoring/src/main/resources/expcatalog-mysql.sql
@@ -65,7 +65,7 @@ CREATE TABLE USERS
GATEWAY_ID VARCHAR(255) NOT NULL,
PRIMARY KEY (GATEWAY_ID, USER_NAME),
FOREIGN KEY (GATEWAY_ID) REFERENCES GATEWAY(GATEWAY_ID) ON DELETE CASCADE,
- UNIQUE KEY (AIRAVATA_INTERNAL_USER_ID)
+ UNIQUE (AIRAVATA_INTERNAL_USER_ID)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE GATEWAY_WORKER