airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scnakand...@apache.org
Subject [1/2] airavata git commit: Shorten columns so primary key is shorter
Date Wed, 05 Oct 2016 20:58:04 GMT
Repository: airavata
Updated Branches:
  refs/heads/develop a899b52cc -> 9f0445f81


Shorten columns so primary key is shorter

MySQL/MariaDB has a max key length of 767 bytes (at least in some
configurations) and causes an error if the key is longer than that.


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

Branch: refs/heads/develop
Commit: 879f0a77cea32b725303d0ddbbe74eea42cac0d4
Parents: 1f48ce3
Author: Marcus Christie <marc.christie@gmail.com>
Authored: Tue Oct 4 13:10:58 2016 -0400
Committer: Marcus Christie <marc.christie@gmail.com>
Committed: Tue Oct 4 13:10:58 2016 -0400

----------------------------------------------------------------------
 .../registry-core/src/main/resources/credstore-mysql.sql         | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/airavata/blob/879f0a77/modules/registry/registry-core/src/main/resources/credstore-mysql.sql
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/resources/credstore-mysql.sql b/modules/registry/registry-core/src/main/resources/credstore-mysql.sql
index 24e43e0..a0cf815 100644
--- a/modules/registry/registry-core/src/main/resources/credstore-mysql.sql
+++ b/modules/registry/registry-core/src/main/resources/credstore-mysql.sql
@@ -7,8 +7,8 @@ CREATE TABLE COMMUNITY_USER (
 );
 
 CREATE TABLE CREDENTIALS (
-  GATEWAY_ID     VARCHAR(256) NOT NULL,
-  TOKEN_ID       VARCHAR(256) NOT NULL,
+  GATEWAY_ID     VARCHAR(100) NOT NULL,
+  TOKEN_ID       VARCHAR(100) NOT NULL,
   CREDENTIAL     BLOB         NOT NULL,
   PORTAL_USER_ID VARCHAR(256) NOT NULL,
   TIME_PERSISTED TIMESTAMP DEFAULT CURRENT_TIMESTAMP,


Mime
View raw message