[
https://issues.apache.org/jira/browse/AIRAVATA-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie updated AIRAVATA-2242:
--------------------------------------
Description:
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
);
> 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
>
> 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
> );
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
