1 /* Copyright © 2017 AT&T, Amdocs, Bell Canada
3 * Licensed under the Apache License, Version 2.0 (the "License");
4 * you may not use this file except in compliance with the License.
5 * You may obtain a copy of the License at
7 * http://www.apache.org/licenses/LICENSE-2.0
9 * Unless required by applicable law or agreed to in writing, software
10 * distributed under the License is distributed on an "AS IS" BASIS,
11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12 * See the License for the specific language governing permissions and
13 * limitations under the License.
17 drop table if exists INFRA_ACTIVE_REQUESTS;
19 drop table if exists SITE_STATUS;
21 create table INFRA_ACTIVE_REQUESTS (
22 REQUEST_ID varchar(45) not null,
23 CLIENT_REQUEST_ID varchar(45),
24 ACTION varchar(45) not null,
25 REQUEST_STATUS varchar(20),
26 STATUS_MESSAGE varchar(2000),
33 VNF_TYPE varchar(200),
34 SERVICE_TYPE varchar(45),
35 AIC_NODE_CLLI varchar(11),
36 TENANT_ID varchar(45),
37 PROV_STATUS varchar(20),
40 REQUEST_BODY longtext,
41 RESPONSE_BODY longtext,
42 LAST_MODIFIED_BY varchar(50),
44 REQUEST_TYPE varchar(20),
45 VOLUME_GROUP_ID varchar(45),
46 VOLUME_GROUP_NAME varchar(45),
47 VF_MODULE_ID varchar(45),
48 VF_MODULE_NAME varchar(200),
49 VF_MODULE_MODEL_NAME varchar(200),
50 AAI_SERVICE_ID varchar(50),
51 AIC_CLOUD_REGION varchar(11),
52 CALLBACK_URL varchar(200),
53 CORRELATOR varchar(80),
54 SERVICE_INSTANCE_ID varchar(45),
55 SERVICE_INSTANCE_NAME varchar(80),
56 REQUEST_SCOPE varchar(20),
57 REQUEST_ACTION varchar(45) not null,
58 NETWORK_ID varchar(45),
59 NETWORK_NAME varchar(80),
60 NETWORK_TYPE varchar(80),
61 REQUESTOR_ID varchar(80),
62 primary key (REQUEST_ID)
65 create table SITE_STATUS (
66 SITE_NAME varchar(255) not null,
68 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
69 primary key (SITE_NAME)
71 create table OPERATION_STATUS (
72 SERVICE_ID varchar(255) not null,
73 OPERATION_ID varchar(255) not null,
74 SERVICE_NAME varchar(255),
75 OPERATION_TYPE varchar(255),
78 OPERATION_CONTENT varchar(255),
79 PROGRESS varchar(255),
83 primary key (SERVICE_ID,OPERATION_ID)
85 create table RESOURCE_OPERATION_STATUS (
86 SERVICE_ID varchar(255) not null,
87 OPERATION_ID varchar(255) not null,
88 RESOURCE_TEMPLATE_UUID varchar(255) not null,
89 OPER_TYPE varchar(255),
90 RESOURCE_INSTANCE_ID varchar(255),
93 PROGRESS varchar(255),
94 ERROR_CODE varchar(255) ,
95 STATUS_DESCRIPOTION varchar(255) ,
96 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
98 alter table INFRA_ACTIVE_REQUESTS
99 add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak unique (CLIENT_REQUEST_ID);