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