airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chath...@apache.org
Subject [08/11] airavata git commit: updating the credential-store-mysql.sql
Date Thu, 18 Feb 2016 15:47:07 GMT
updating the credential-store-mysql.sql


Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/7a345e54
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/7a345e54
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/7a345e54

Branch: refs/heads/master
Commit: 7a345e547487b0cf78eb1805f25bb053ad49a840
Parents: d8df3d0
Author: scnakandala <supun.nakandala@gmail.com>
Authored: Tue Feb 16 16:25:34 2016 -0500
Committer: scnakandala <supun.nakandala@gmail.com>
Committed: Tue Feb 16 16:25:34 2016 -0500

----------------------------------------------------------------------
 .../scripts/credential-store-mysql.sql          | 28 +++++++++-----------
 1 file changed, 12 insertions(+), 16 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/airavata/blob/7a345e54/modules/credential-store/credential-store-service/scripts/credential-store-mysql.sql
----------------------------------------------------------------------
diff --git a/modules/credential-store/credential-store-service/scripts/credential-store-mysql.sql
b/modules/credential-store/credential-store-service/scripts/credential-store-mysql.sql
index 50d5e0f..b0e4fb9 100644
--- a/modules/credential-store/credential-store-service/scripts/credential-store-mysql.sql
+++ b/modules/credential-store/credential-store-service/scripts/credential-store-mysql.sql
@@ -20,23 +20,19 @@
  */
 CREATE TABLE COMMUNITY_USER
 (
-	GATEWAY_NAME VARCHAR(256) NOT NULL,
-	COMMUNITY_USER_NAME VARCHAR(256) NOT NULL,
-	COMMUNITY_USER_EMAIL VARCHAR(256) NOT NULL,
-        PRIMARY KEY (GATEWAY_NAME, COMMUNITY_USER_NAME)
+        GATEWAY_ID VARCHAR(256) NOT NULL,
+        COMMUNITY_USER_NAME VARCHAR(256) NOT NULL,
+        TOKEN_ID VARCHAR(256) NOT NULL,
+        COMMUNITY_USER_EMAIL VARCHAR(256) NOT NULL,
+        PRIMARY KEY (GATEWAY_ID, COMMUNITY_USER_NAME, TOKEN_ID)
 );
 
-
 CREATE TABLE CREDENTIALS
 (
-	GATEWAY_NAME VARCHAR(256) NOT NULL,
-	COMMUNITY_USER_NAME VARCHAR(256) NOT NULL,
-	CREDENTIAL TEXT NOT NULL,
-	PRIVATE_KEY TEXT NOT NULL,
-	NOT_BEFORE VARCHAR(256) NOT NULL,
-	NOT_AFTER VARCHAR(256) NOT NULL,
-	LIFETIME MEDIUMINT NOT NULL,
-	REQUESTING_PORTAL_USER_NAME VARCHAR(256) NOT NULL,
-	REQUESTED_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
-    PRIMARY KEY (GATEWAY_NAME, COMMUNITY_USER_NAME)
-);
+        GATEWAY_ID VARCHAR(256) NOT NULL,
+        TOKEN_ID VARCHAR(256) NOT NULL,
+        CREDENTIAL BLOB NOT NULL,
+        PORTAL_USER_ID VARCHAR(256) NOT NULL,
+        TIME_PERSISTED TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
+        PRIMARY KEY (GATEWAY_ID, TOKEN_ID)
+);
\ No newline at end of file


Mime
View raw message