[
https://issues.apache.org/jira/browse/AIRAVATA-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eroma updated AIRAVATA-2242:
----------------------------
Fix Version/s: 0.17
> SQL migration script for 0.17 release
> -------------------------------------
>
> Key: AIRAVATA-2242
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2242
> Project: Airavata
> Issue Type: Bug
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Fix For: 0.17
>
>
> Migration script:
> {code:sql}
> -- AIRAVATA-2232
> alter table CREDENTIALS add column CREDENTIAL_OWNER_TYPE VARCHAR(10) DEFAULT
> 'GATEWAY' NOT NULL;
> update
> master_credentialstore_gw77.CREDENTIALS
> set
> credential_owner_type = 'USER'
> where
> token_id in (
> select
> resource_cs_token
> from
> master_appcatalog_gw77.USER_COMPUTE_RESOURCE_PREFERENCE
> union
> select
> RESOURCE_CS_TOKEN
> from
> master_appcatalog_gw77.USER_STORAGE_PREFERENCE
> UNION
> select
> cs_token
> from
> master_appcatalog_gw77.USER_RESOURCE_PROFILE
> );
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
