2 CREATE TABLE IF NOT EXISTS `identity_services` (
3 `ID` varchar(50) NOT NULL,
4 `IDENTITY_URL` varchar(200) DEFAULT NULL,
5 `MSO_ID` varchar(255) DEFAULT NULL,
6 `MSO_PASS` varchar(255) DEFAULT NULL,
7 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
8 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
9 `TENANT_METADATA` tinyint(1) DEFAULT 0,
10 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
11 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
12 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
13 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
14 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
19 CREATE TABLE IF NOT EXISTS `cloudify_managers` (
20 `ID` varchar(50) NOT NULL,
21 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
22 `USERNAME` varchar(255) DEFAULT NULL,
23 `PASSWORD` varchar(255) DEFAULT NULL,
24 `VERSION` varchar(20) DEFAULT NULL,
25 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
26 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
27 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
32 CREATE TABLE IF NOT EXISTS `cloud_sites` (
33 `ID` varchar(50) NOT NULL,
34 `REGION_ID` varchar(11) DEFAULT NULL,
35 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
36 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
37 `CLLI` varchar(11) DEFAULT NULL,
38 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
39 `PLATFORM` varchar(50) DEFAULT NULL,
40 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
41 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
42 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
43 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
45 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
46 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)