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
48
49
50
51
52
53
54
55
56
57
|
drop table if exists INFRA_ACTIVE_REQUESTS;
drop table if exists SITE_STATUS;
create table INFRA_ACTIVE_REQUESTS (
REQUEST_ID varchar(45) not null,
CLIENT_REQUEST_ID varchar(45),
ACTION varchar(45) not null,
REQUEST_STATUS varchar(20),
STATUS_MESSAGE varchar(2000),
PROGRESS bigint,
START_TIME datetime,
END_TIME datetime,
SOURCE varchar(45),
VNF_ID varchar(45),
VNF_NAME varchar(80),
VNF_TYPE varchar(200),
SERVICE_TYPE varchar(45),
AIC_NODE_CLLI varchar(11),
TENANT_ID varchar(45),
PROV_STATUS varchar(20),
VNF_PARAMS longtext,
VNF_OUTPUTS longtext,
REQUEST_BODY longtext,
RESPONSE_BODY longtext,
LAST_MODIFIED_BY varchar(50),
MODIFY_TIME datetime,
REQUEST_TYPE varchar(20),
VOLUME_GROUP_ID varchar(45),
VOLUME_GROUP_NAME varchar(45),
VF_MODULE_ID varchar(45),
VF_MODULE_NAME varchar(200),
VF_MODULE_MODEL_NAME varchar(200),
AAI_SERVICE_ID varchar(50),
AIC_CLOUD_REGION varchar(11),
CALLBACK_URL varchar(200),
CORRELATOR varchar(80),
SERVICE_INSTANCE_ID varchar(45),
SERVICE_INSTANCE_NAME varchar(80),
REQUEST_SCOPE varchar(20),
REQUEST_ACTION varchar(45) not null,
NETWORK_ID varchar(45),
NETWORK_NAME varchar(80),
NETWORK_TYPE varchar(80),
primary key (REQUEST_ID)
);
create table SITE_STATUS (
SITE_NAME varchar(255) not null,
STATUS bit,
CREATION_TIMESTAMP datetime,
primary key (SITE_NAME)
);
alter table INFRA_ACTIVE_REQUESTS
add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak unique (CLIENT_REQUEST_ID);
|
