aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V5.2__AddServiceTypeColumnToNorthBoundRequest.sql
blob: 1ead94cd9cf61cdeaa2ab50489d30430af4a0009 (plain) 
1
2
3
4
5
6
7

use catalogdb;

ALTER  TABLE northbound_request_ref_lookup ADD COLUMN SERVICE_TYPE varchar(200) NULL;
ALTER TABLE northbound_request_ref_lookup
 DROP INDEX UK_northbound_request_ref_lookup;
ALTER TABLE northbound_request_ref_lookup                                                                                                                                                                                                                                                               
ADD UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC, `MACRO_ACTION` ASC, `CLOUD_OWNER` ASC, `SERVICE_TYPE` ASC);