[AIRAVATA-2242] SQL migration script for 0.17 release

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.17
• Assignee: Marcus Christie
• Reporter: Marcus Christie
• Created: 29/Nov/16 20:05
• Updated: 06/Jan/17 21:19
• Resolved: 06/Jan/17 21:19

Description

Migration script:

-- 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
	);

Issue Links

• is superceded by: AIRAVATA-2291 Database Migration Dev to Master