2 drop table if exists ACTIVATE_OPERATIONAL_ENV_PER_DISTRIBUTIONID_STATUS;
4 drop table if exists ACTIVATE_OPERATIONAL_ENV_SERVICE_MODEL_DISTRIBUTION_STATUS;
6 drop table if exists INFRA_ACTIVE_REQUESTS;
8 drop table if exists OPERATION_STATUS;
10 drop table if exists RESOURCE_OPERATION_STATUS;
12 drop table if exists SITE_STATUS;
14 drop table if exists WATCHDOG_DISTRIBUTIONID_STATUS;
16 drop table if exists WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS;
18 drop table if exists WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP;
20 create table ACTIVATE_OPERATIONAL_ENV_PER_DISTRIBUTIONID_STATUS (
21 DISTRIBUTION_ID varchar(45) not null,
22 OPERATIONAL_ENV_ID varchar(45),
23 SERVICE_MODEL_VERSION_ID varchar(45),
24 DISTRIBUTION_ID_STATUS varchar(45),
25 DISTRIBUTION_ID_ERROR_REASON varchar(250),
26 REQUEST_ID varchar(45),
29 primary key (DISTRIBUTION_ID)
32 create table ACTIVATE_OPERATIONAL_ENV_SERVICE_MODEL_DISTRIBUTION_STATUS (
33 OPERATIONAL_ENV_ID varchar(45) not null,
34 SERVICE_MODEL_VERSION_ID varchar(45) not null,
35 REQUEST_ID varchar(45) not null,
36 SERVICE_MOD_VER_FINAL_DISTR_STATUS varchar(45),
37 RECOVERY_ACTION varchar(30),
38 RETRY_COUNT_LEFT integer,
39 WORKLOAD_CONTEXT varchar(80),
42 primary key (OPERATIONAL_ENV_ID, SERVICE_MODEL_VERSION_ID, REQUEST_ID)
45 create table INFRA_ACTIVE_REQUESTS (
46 REQUEST_ID varchar(45) not null,
47 CLIENT_REQUEST_ID varchar(45),
48 ACTION varchar(45) not null,
49 REQUEST_STATUS varchar(20),
50 STATUS_MESSAGE varchar(2000),
57 VNF_TYPE varchar(200),
58 SERVICE_TYPE varchar(45),
59 AIC_NODE_CLLI varchar(11),
60 TENANT_ID varchar(45),
61 PROV_STATUS varchar(20),
64 REQUEST_BODY longtext,
65 RESPONSE_BODY longtext,
66 LAST_MODIFIED_BY varchar(50),
68 REQUEST_TYPE varchar(20),
69 VOLUME_GROUP_ID varchar(45),
70 VOLUME_GROUP_NAME varchar(45),
71 VF_MODULE_ID varchar(45),
72 VF_MODULE_NAME varchar(200),
73 VF_MODULE_MODEL_NAME varchar(200),
74 AAI_SERVICE_ID varchar(50),
75 AIC_CLOUD_REGION varchar(200),
76 CALLBACK_URL varchar(200),
77 CORRELATOR varchar(80),
78 SERVICE_INSTANCE_ID varchar(45),
79 SERVICE_INSTANCE_NAME varchar(80),
80 REQUEST_SCOPE varchar(45),
81 REQUEST_ACTION varchar(45) not null,
82 NETWORK_ID varchar(45),
83 NETWORK_NAME varchar(80),
84 NETWORK_TYPE varchar(80),
85 REQUESTOR_ID varchar(80),
86 CONFIGURATION_ID varchar(45),
87 CONFIGURATION_NAME varchar(200),
88 OPERATIONAL_ENV_ID varchar(45),
89 OPERATIONAL_ENV_NAME varchar(200),
90 primary key (REQUEST_ID)
93 create table OPERATION_STATUS (
94 SERVICE_ID varchar(255) not null,
95 OPERATION_ID varchar(256) not null,
96 SERVICE_NAME varchar(256),
97 OPERATION_TYPE varchar(256),
100 OPERATION_CONTENT varchar(256),
101 PROGRESS varchar(256),
103 OPERATE_AT datetime default CURRENT_TIMESTAMP,
104 FINISHED_AT datetime,
105 primary key (SERVICE_ID, OPERATION_ID)
108 create table RESOURCE_OPERATION_STATUS (
109 SERVICE_ID varchar(255) not null,
110 OPERATION_ID varchar(256) not null,
111 RESOURCE_TEMPLATE_UUID varchar(255) not null,
112 OPER_TYPE varchar(256),
113 RESOURCE_INSTANCE_ID varchar(256),
116 PROGRESS varchar(256),
117 ERROR_CODE varchar(256),
118 STATUS_DESCRIPOTION varchar(256),
119 primary key (SERVICE_ID, OPERATION_ID, RESOURCE_TEMPLATE_UUID)
122 create table SITE_STATUS (
123 SITE_NAME varchar(255) not null,
125 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
126 primary key (SITE_NAME)
129 create table WATCHDOG_DISTRIBUTIONID_STATUS (
130 DISTRIBUTION_ID varchar(45) not null,
131 DISTRIBUTION_ID_STATUS varchar(45),
132 CREATE_TIME datetime,
133 MODIFY_TIME datetime,
134 primary key (DISTRIBUTION_ID)
137 create table WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS (
138 DISTRIBUTION_ID varchar(45) not null,
139 COMPONENT_NAME varchar(45) not null,
140 COMPONENT_DISTRIBUTION_STATUS varchar(45),
141 CREATE_TIME datetime,
142 MODIFY_TIME datetime,
143 primary key (DISTRIBUTION_ID, COMPONENT_NAME)
146 create table WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP (
147 DISTRIBUTION_ID varchar(45) not null,
148 SERVICE_MODEL_VERSION_ID varchar(45) not null,
149 CREATE_TIME datetime,
150 primary key (DISTRIBUTION_ID, SERVICE_MODEL_VERSION_ID)
153 alter table INFRA_ACTIVE_REQUESTS
154 add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak unique (CLIENT_REQUEST_ID);