Add SO Populate Activity BB Data in Catalog DB
[so.git] / adapters / mso-catalog-db-adapter / src / main / resources / db / migration / V4.14.2__AddCloudOwnerColumnToNorthBoundRequest.sql
1 use catalogdb;
2
3 ALTER  TABLE northbound_request_ref_lookup ADD COLUMN CLOUD_OWNER varchar(200) NOT NULL;
4 ALTER TABLE northbound_request_ref_lookup
5  DROP INDEX UK_northbound_request_ref_lookup;
6 ALTER TABLE northbound_request_ref_lookup                                                                                                                                                                                                                                                               
7 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);