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/12/02 21:26:38 UTC
[airavata] branch master updated: AIRAVATA-3280 Widen FILE_PATH
column
This is an automated email from the ASF dual-hosted git repository.
machristie pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/master by this push:
new 5202ce2 AIRAVATA-3280 Widen FILE_PATH column
5202ce2 is described below
commit 5202ce21c7fcb536b48e7f11e4a793ae823287fe
Author: Marcus Christie <ma...@iu.edu>
AuthorDate: Mon Dec 2 16:25:32 2019 -0500
AIRAVATA-3280 Widen FILE_PATH column
---
.../registry/registry-core/src/main/resources/replicacatalog-derby.sql | 2 +-
.../registry/registry-core/src/main/resources/replicacatalog-mysql.sql | 2 +-
.../0.18-0.19/DeltaScripts/replicaCatalog_schema_delta.sql | 3 +++
3 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/modules/registry/registry-core/src/main/resources/replicacatalog-derby.sql b/modules/registry/registry-core/src/main/resources/replicacatalog-derby.sql
index eb287c7..d215179 100644
--- a/modules/registry/registry-core/src/main/resources/replicacatalog-derby.sql
+++ b/modules/registry/registry-core/src/main/resources/replicacatalog-derby.sql
@@ -46,7 +46,7 @@ CREATE TABLE DATA_REPLICA_LOCATION
REPLICA_NAME VARCHAR (255),
REPLICA_DESCRIPTION VARCHAR (255),
STORAGE_RESOURCE_ID VARCHAR (255),
- FILE_PATH VARCHAR (4096),
+ FILE_PATH VARCHAR (1024),
CREATION_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
LAST_MODIFIED_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
VALID_UNTIL_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
diff --git a/modules/registry/registry-core/src/main/resources/replicacatalog-mysql.sql b/modules/registry/registry-core/src/main/resources/replicacatalog-mysql.sql
index a123e65..c389070 100644
--- a/modules/registry/registry-core/src/main/resources/replicacatalog-mysql.sql
+++ b/modules/registry/registry-core/src/main/resources/replicacatalog-mysql.sql
@@ -42,7 +42,7 @@ CREATE TABLE DATA_REPLICA_LOCATION
REPLICA_NAME VARCHAR (255),
REPLICA_DESCRIPTION VARCHAR (255),
STORAGE_RESOURCE_ID VARCHAR (255),
- FILE_PATH VARCHAR (255),
+ FILE_PATH VARCHAR (1024),
CREATION_TIME TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
LAST_MODIFIED_TIME TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
VALID_UNTIL_TIME TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
diff --git a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/replicaCatalog_schema_delta.sql b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/replicaCatalog_schema_delta.sql
index 0645e1c..b075d32 100644
--- a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/replicaCatalog_schema_delta.sql
+++ b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/replicaCatalog_schema_delta.sql
@@ -41,3 +41,6 @@ ALTER TABLE `DATA_PRODUCT` CHANGE `PRODUCT_TYPE` `PRODUCT_TYPE` varchar(10) DEFA
ALTER TABLE `DATA_REPLICA_LOCATION` CHANGE `REPLICA_LOCATION_CATEGORY` `REPLICA_LOCATION_CATEGORY` varchar(26) DEFAULT NULL;
ALTER TABLE `DATA_REPLICA_LOCATION` CHANGE `REPLICA_PERSISTENT_TYPE` `REPLICA_PERSISTENT_TYPE` varchar(10) DEFAULT NULL;
set FOREIGN_KEY_CHECKS=1;
+
+-- AIRAVATA-3280: Widen FILE_PATH to accommodate longer file paths
+ALTER TABLE `DATA_REPLICA_LOCATION` MODIFY COLUMN `FILE_PATH` VARCHAR(1024);