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 2018/05/04 21:11:01 UTC
[airavata] branch group-based-auth updated: AIRAVATA-2758 Remove
NOT NULL constraint from COMPUTE_RESOURCE columns
This is an automated email from the ASF dual-hosted git repository.
machristie pushed a commit to branch group-based-auth
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/group-based-auth by this push:
new d8a510c AIRAVATA-2758 Remove NOT NULL constraint from COMPUTE_RESOURCE columns
d8a510c is described below
commit d8a510cc0f11b5065740ebda00af6f6e949cca6b
Author: Marcus Christie <ma...@apache.org>
AuthorDate: Fri May 4 17:10:30 2018 -0400
AIRAVATA-2758 Remove NOT NULL constraint from COMPUTE_RESOURCE columns
---
.../next/DeltaScripts/appCatalog_schema_delta.sql | 11 ++++++++++-
1 file changed, 10 insertions(+), 1 deletion(-)
diff --git a/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql b/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql
index 7625ba0..def5dcf 100644
--- a/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql
+++ b/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql
@@ -19,4 +19,13 @@
--
-- AIRAVATA-2768
-alter table APPLICATION_INPUT modify METADATA VARCHAR(4096);
\ No newline at end of file
+alter table APPLICATION_INPUT modify METADATA VARCHAR(4096);
+
+-- AIRAVATA-2758
+-- Note: this doesn't really represent a schema change, rather some legacy database instances improperly had created these columns as NOT NULL
+alter table COMPUTE_RESOURCE modify column CREATION_TIME TIMESTAMP DEFAULT NOW() null;
+alter table COMPUTE_RESOURCE modify column CPUS_PER_NODE int default 0 null;
+alter table COMPUTE_RESOURCE modify column DEFAULT_NODE_COUNT int default 0 null;
+alter table COMPUTE_RESOURCE modify column DEFAULT_CPU_COUNT int default 0 null;
+alter table COMPUTE_RESOURCE modify column DEFAULT_WALLTIME int default 0 null;
+alter table COMPUTE_RESOURCE modify column UPDATE_TIME timestamp default '0000-00-00 00:00:00' null;
\ No newline at end of file
--
To stop receiving notification emails like this one, please contact
machristie@apache.org.