adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.14.2__AddCloudOwnerColumnToNorthBoundRequest.sql


1
2
3
4
5
6
7

use catalogdb;

ALTER  TABLE northbound_request_ref_lookup ADD COLUMN CLOUD_OWNER varchar(200) NOT 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);