2 drop table if exists INFRA_ACTIVE_REQUESTS;
4 drop table if exists SITE_STATUS;
6 create table INFRA_ACTIVE_REQUESTS (
7 REQUEST_ID varchar(45) not null,
8 CLIENT_REQUEST_ID varchar(45),
9 ACTION varchar(45) not null,
10 REQUEST_STATUS varchar(20),
11 STATUS_MESSAGE varchar(2000),
18 VNF_TYPE varchar(200),
19 SERVICE_TYPE varchar(45),
20 AIC_NODE_CLLI varchar(11),
21 TENANT_ID varchar(45),
22 PROV_STATUS varchar(20),
25 REQUEST_BODY longtext,
26 RESPONSE_BODY longtext,
27 LAST_MODIFIED_BY varchar(50),
29 REQUEST_TYPE varchar(20),
30 VOLUME_GROUP_ID varchar(45),
31 VOLUME_GROUP_NAME varchar(45),
32 VF_MODULE_ID varchar(45),
33 VF_MODULE_NAME varchar(200),
34 VF_MODULE_MODEL_NAME varchar(200),
35 AAI_SERVICE_ID varchar(50),
36 AIC_CLOUD_REGION varchar(11),
37 CALLBACK_URL varchar(200),
38 CORRELATOR varchar(80),
39 SERVICE_INSTANCE_ID varchar(45),
40 SERVICE_INSTANCE_NAME varchar(80),
41 REQUEST_SCOPE varchar(20),
42 REQUEST_ACTION varchar(45) not null,
43 NETWORK_ID varchar(45),
44 NETWORK_NAME varchar(80),
45 NETWORK_TYPE varchar(80),
46 REQUESTOR_ID varchar(80),
47 primary key (REQUEST_ID)
50 create table SITE_STATUS (
51 SITE_NAME varchar(255) not null,
53 CREATION_TIMESTAMP datetime,
54 primary key (SITE_NAME)
57 alter table INFRA_ACTIVE_REQUESTS
58 add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak unique (CLIENT_REQUEST_ID);