airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From machris...@apache.org
Subject [airavata] branch staging updated: Recent tables that are new to staging and not yet on master
Date Fri, 18 Jan 2019 19:46:58 GMT
This is an automated email from the ASF dual-hosted git repository.

machristie pushed a commit to branch staging
in repository https://gitbox.apache.org/repos/asf/airavata.git


The following commit(s) were added to refs/heads/staging by this push:
     new 3f67957  Recent tables that are new to staging and not yet on master
3f67957 is described below

commit 3f67957ac8cfa63ec4abe0ccddb2aebd51b292b1
Author: Marcus Christie <machristie@apache.org>
AuthorDate: Fri Jan 18 14:46:28 2019 -0500

    Recent tables that are new to staging and not yet on master
---
 .../DeltaScripts/profile_service_schema_delta.sql  | 51 ++++++++++++++++++++++
 .../DeltaScripts/sharingCatalog_schema_delta.sql   |  7 +++
 2 files changed, 58 insertions(+)

diff --git a/modules/registry/release-migration-scripts/0.16-0.17/DeltaScripts/profile_service_schema_delta.sql
b/modules/registry/release-migration-scripts/0.16-0.17/DeltaScripts/profile_service_schema_delta.sql
new file mode 100644
index 0000000..1d407bc
--- /dev/null
+++ b/modules/registry/release-migration-scripts/0.16-0.17/DeltaScripts/profile_service_schema_delta.sql
@@ -0,0 +1,51 @@
+--
+--
+-- Licensed to the Apache Software Foundation (ASF) under one
+-- or more contributor license agreements.  See the NOTICE file
+-- distributed with this work for additional information
+-- regarding copyright ownership.  The ASF licenses this file
+-- to you under the Apache License, Version 2.0 (the
+-- "License"); you may not use this file except in compliance
+-- with the License.  You may obtain a copy of the License at
+--
+--   http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing,
+-- software distributed under the License is distributed on an
+-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+-- KIND, either express or implied.  See the License for the
+-- specific language governing permissions and limitations
+-- under the License.
+--
+
+-- NOTE: the following is only needed if you previously installed Airavata from
+-- the master branch and have a profile service database
+CREATE TABLE IF NOT EXISTS `CUSTOMIZED_DASHBOARD` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `ENABLED_APPLICATION` varchar(255) DEFAULT NULL,
+ `ENABLED_COMPUTE_RESOURCE` varchar(255) DEFAULT NULL,
+ `ENABLED_CPU_COUNT` varchar(255) DEFAULT NULL,
+ `ENABLED_CREATION_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `ENABLED_ERRORS` varchar(255) DEFAULT NULL,
+ `ENABLED_EXPERIMENT_ID` varchar(255) DEFAULT NULL,
+ `ENABLED_INPUTS` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_CREATION_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_ID` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_NAME` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_STATUS` varchar(255) DEFAULT NULL,
+ `ENABLED_LAST_MODIFIED_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_NAME` varchar(255) DEFAULT NULL,
+ `ENABLED_NODE_COUNT` varchar(255) DEFAULT NULL,
+ `ENABLED_NOTIFICATIONS_TO` varchar(255) DEFAULT NULL,
+ `ENABLED_OUTPUTS` varchar(255) DEFAULT NULL,
+ `ENABLED_OWNER` varchar(255) DEFAULT NULL,
+ `ENABLED_PROJECT` varchar(255) DEFAULT NULL,
+ `ENABLED_QUEUE` varchar(255) DEFAULT NULL,
+ `ENABLED_STORAGE_DIR` varchar(255) DEFAULT NULL,
+ `ENABLED_WALL_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_WORKING_DIR` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`),
+ CONSTRAINT `CUSTOMIZED_DASHBOARD_ibfk_1` FOREIGN KEY (`AIRAVATA_INTERNAL_USER_ID`) REFERENCES
`USER_PROFILE` (`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
diff --git a/modules/registry/release-migration-scripts/0.16-0.17/DeltaScripts/sharingCatalog_schema_delta.sql
b/modules/registry/release-migration-scripts/0.16-0.17/DeltaScripts/sharingCatalog_schema_delta.sql
index b8b9838..8012989 100644
--- a/modules/registry/release-migration-scripts/0.16-0.17/DeltaScripts/sharingCatalog_schema_delta.sql
+++ b/modules/registry/release-migration-scripts/0.16-0.17/DeltaScripts/sharingCatalog_schema_delta.sql
@@ -29,3 +29,10 @@ ALTER TABLE `SHARING` ADD CONSTRAINT `SHARING_PERMISSION_TYPE_ID_DOMAIN_ID_FK`
F
 ALTER TABLE `SHARING` ADD CONSTRAINT `SHARING_ENTITY_ID_DOMAIN_ID_FK` FOREIGN KEY (ENTITY_ID,
DOMAIN_ID) REFERENCES ENTITY(ENTITY_ID, DOMAIN_ID) ON DELETE CASCADE ON UPDATE NO ACTION;
 ALTER TABLE `SHARING` ADD CONSTRAINT `SHARING_INHERITED_PARENT_ID_DOMAIN_ID_FK` FOREIGN KEY
(INHERITED_PARENT_ID, DOMAIN_ID) REFERENCES ENTITY(ENTITY_ID, DOMAIN_ID) ON DELETE CASCADE
ON UPDATE NO ACTION;
 ALTER TABLE `SHARING` ADD CONSTRAINT `SHARING_GROUP_ID_DOMAIN_ID_FK` FOREIGN KEY (GROUP_ID,
DOMAIN_ID) REFERENCES USER_GROUP(GROUP_ID, DOMAIN_ID) ON DELETE CASCADE ON UPDATE NO ACTION;
+
+CREATE TABLE IF NOT EXISTS `GROUP_ADMIN` (
+ `ADMIN_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `GROUP_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`ADMIN_ID`,`DOMAIN_ID`,`GROUP_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Mime
View raw message