aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V8.5__AddCloudOwner.sql
blob: 92502e2696fe3e0762c2f6d39ab45e1749c69041 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
use catalogdb;


ALTER TABLE cloud_sites
    ADD COLUMN IF NOT EXISTS CLOUD_OWNER varchar(255);


CREATE TABLE IF NOT EXISTS `network_technology_reference` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `NETWORK_TECHNOLOGY` varchar(200) NOT NULL ,
  `CLOUD_OWNER` varchar(200) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;