2 -- Copyright 2017 ZTE Corporation.
4 -- Licensed under the Apache License, Version 2.0 (the "License");
5 -- you may not use this file except in compliance with the License.
6 -- You may obtain a copy of the License at
8 -- http://www.apache.org/licenses/LICENSE-2.0
10 -- Unless required by applicable law or agreed to in writing, software
11 -- distributed under the License is distributed on an "AS IS" BASIS,
12 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 -- See the License for the specific language governing permissions and
14 -- limitations under the License.
19 DROP TABLE IF EXISTS NFVO_CPINST;
20 CREATE TABLE NFVO_CPINST (
21 `CPINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
22 `CPDID` varchar(255) NOT NULL,
23 `CPINSTANCENAME` varchar(255) NOT NULL,
24 `OWNERTYPE` integer NOT NULL,
25 `OWNERID` varchar(255) NOT NULL,
26 `RELATEDTYPE` integer NOT NULL,
27 `RELATEDVL` varchar(255) NULL,
28 `RELATEDCP` varchar(255) NULL,
29 `RELATEDPORT` varchar(255) NULL,
30 `STATUS` varchar(255) NOT NULL
33 DROP TABLE IF EXISTS NFVO_FPINST;
34 CREATE TABLE NFVO_FPINST (
35 `FPID` varchar(255) NOT NULL,
36 `FPINSTID` varchar(255) NOT NULL PRIMARY KEY,
37 `FPNAME` varchar(255) NOT NULL,
38 `NSINSTID` varchar(255) NOT NULL,
39 `VNFFGINSTID` varchar(255) NOT NULL,
40 `SYMMETRIC` integer NULL,
41 `POLICYINFO` longtext NOT NULL,
42 `FORWORDERPATHS` varchar(255) NULL,
43 `STATUS` varchar(255) NOT NULL,
44 `SDNCONTROLLERID` varchar(255) NOT NULL,
45 `SFCID` varchar(255) NOT NULL,
46 `FLOWCLASSIFIERS` varchar(255) NOT NULL,
47 `PORTPAIRGROUPS` longtext NOT NULL
50 DROP TABLE IF EXISTS NFVO_JOB;
51 CREATE TABLE NFVO_JOB (
52 `JOBID` varchar(255) NOT NULL PRIMARY KEY,
53 `JOBTYPE` varchar (255) NOT NULL,
54 `JOBACTION` varchar(255) NOT NULL,
55 `RESID` varchar(255) NOT NULL,
56 `STATUS` integer NULL,
57 `STARTTIME` varchar(255) NULL,
58 `ENDTIME` varchar(255) NULL,
59 `PROGRESS` integer NULL,
60 `USER` varchar(255) NULL,
61 `PARENTJOBID` varchar(255) NULL,
62 `RESNAME` varchar(255) NULL
65 DROP TABLE IF EXISTS NFVO_JOB_STATUS;
66 CREATE TABLE NFVO_JOB_STATUS (
67 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
68 `INDEXID` integer NOT NULL,
69 `JOBID` varchar(255) NOT NULL,
70 `STATUS` varchar(255) NOT NULL,
71 `PROGRESS` integer NULL,
72 `DESCP` longtext NOT NULL,
73 `ERRCODE` varchar(255) NULL,
74 `ADDTIME` varchar(255) NULL
77 DROP TABLE IF EXISTS NFVO_NFINST;
78 CREATE TABLE NFVO_NFINST (
79 `NFINSTID` varchar(200) NOT NULL PRIMARY KEY,
80 `M_NFINSTID` varchar(200) NULL,
81 `NFNAME` varchar(100) NULL,
82 `TEMPLATEID` varchar(200) NULL,
83 `VNFID` varchar(200) NULL,
84 `PACKAGEID` varchar(200) NULL,
85 `VNFMINSTID` varchar(200) NULL,
86 `NSINSTID` varchar(200) NULL,
87 `STATUS` varchar(20) NULL,
88 `FLAVOURID` varchar(200) NULL,
89 `VNFLEVEL` varchar(200) NULL,
90 `LOCATION` varchar(200) NULL,
92 `MAXCPU` integer NULL,
93 `MAXRAM` integer NULL,
95 `MAXSHD` integer NULL,
96 `MAXNET` integer NULL,
97 `VERSION` varchar(255) NULL,
98 `VENDOR` varchar(255) NULL,
99 `VNFDMODEL` longtext NULL,
100 `INPUTPARAMS` longtext NULL,
101 `SCALEPARAMS` longtext NULL,
102 `CREATETIME` varchar(200) NULL,
103 `LASTUPTIME` varchar(200) NULL,
104 `EXTENSION` longtext NULL
107 DROP TABLE IF EXISTS NFVO_NFPACKAGE;
108 CREATE TABLE NFVO_NFPACKAGE (
109 `UUID` varchar(255) NOT NULL PRIMARY KEY,
110 `NFPACKAGEID` varchar(200) NOT NULL,
111 `VNFDID` varchar(255) NOT NULL,
112 `VENDOR` varchar(255) NOT NULL,
113 `VNFDVERSION` varchar(255) NOT NULL,
114 `VNFVERSION` varchar(255) NOT NULL,
115 `VNFDMODEL` longtext NULL,
116 `VNFDPATH` varchar(300) NULL
119 DROP TABLE IF EXISTS NFVO_NSPACKAGE;
120 CREATE TABLE NFVO_NSPACKAGE (
121 `ID` varchar(200) NOT NULL PRIMARY KEY,
122 `NSDID` varchar(200) NOT NULL,
123 `NAME` varchar(200) NOT NULL,
124 `VENDOR` varchar(200) NULL,
125 `DESCRIPTION` varchar(200) NULL,
126 `VERSION` varchar(200) NULL,
127 `NSDMODEL` longtext NULL,
128 `NSDPATH` varchar(300) NULL
131 DROP TABLE IF EXISTS NFVO_NSINST;
132 CREATE TABLE NFVO_NSINST (
133 `ID` varchar(200) NOT NULL PRIMARY KEY,
134 `NAME` varchar(200) NOT NULL,
135 `NSPACKAGEID` varchar(200) NULL,
136 `NSDID` varchar(200) NOT NULL,
137 `DESCRIPTION` varchar(255) NULL,
138 `SDNCONTROLLERID` varchar(200) NULL,
139 `FLAVOURID` varchar(200) NULL,
140 `NSLEVEL` varchar(200) NULL,
141 `STATUS` varchar(200) NULL,
142 `NSDMODEL` longtext NULL,
143 `INPUTPARAMS` longtext NULL,
144 `SCALEPARAMS` longtext NULL,
145 `CREATETIME` varchar(200) NULL,
146 `LASTUPTIME` varchar(200) NULL,
147 `GLOBALCUSTOMERID` varchar(50) NULL,
148 `SERVICETYPE` varchar(50) NULL
151 DROP TABLE IF EXISTS NFVO_PORTINST;
152 CREATE TABLE NFVO_PORTINST (
153 `PORTID` varchar(255) NOT NULL PRIMARY KEY,
154 `NETWORKID` varchar(255) NOT NULL,
155 `SUBNETWORKID` varchar(255) NOT NULL,
156 `VIMID` varchar(255) NOT NULL,
157 `RESOURCEID` varchar(255) NOT NULL,
158 `NAME` varchar(255) NOT NULL,
159 `INSTID` varchar(255) NOT NULL,
160 `CPINSTANCEID` varchar(255) NOT NULL,
161 `BANDWIDTH` varchar(255) NOT NULL,
162 `OPERATIONALSTATE` varchar(255) NOT NULL,
163 `IPADDRESS` varchar(255) NOT NULL,
164 `MACADDRESS` varchar(255) NOT NULL,
165 `FLOATIPADDRESS` varchar(255) NOT NULL,
166 `SERVICEIPADDRESS` varchar(255) NOT NULL,
167 `TYPEVIRTUALNIC` varchar(255) NOT NULL,
168 `SFCENCAPSULATION` varchar(255) NOT NULL,
169 `DIRECTION` varchar (255) NOT NULL,
170 `TENANT` varchar(255) NOT NULL
173 DROP TABLE IF EXISTS NFVO_VLINST;
174 CREATE TABLE NFVO_VLINST (
175 `VLINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
176 `VLDID` varchar(255) NOT NULL,
177 `VLINSTANCENAME` varchar(255) NULL,
178 `OWNERTYPE` integer NOT NULL,
179 `OWNERID` varchar(255) NOT NULL,
180 `RELATEDNETWORKID` varchar(255) NULL,
181 `RELATEDSUBNETWORKID` varchar(255) NULL,
182 `VLTYPE` integer NOT NULL,
183 `VIMID` varchar(255) NOT NULL,
184 `TENANT` varchar(255) NOT NULL,
185 `STATUS` varchar(255) NOT NULL
188 DROP TABLE IF EXISTS NFVO_VMINST;
189 CREATE TABLE NFVO_VMINST (
190 `VMID` varchar(255) NOT NULL PRIMARY KEY,
191 `VIMID` varchar (255) NOT NULL,
192 `RESOURCEID` varchar(255) NOT NULL,
193 `INSTTYPE` integer NULL,
194 `INSTID` varchar(255) NULL,
195 `VMNAME` varchar(255) NOT NULL,
196 `OPERATIONALSTATE` integer NOT NULL,
197 `ZONEID` varchar(255) NULL,
198 `TENANT` varchar(255) NULL,
199 `HOSTID` varchar(255) NOT NULL,
200 `DETAILINFO` varchar(255) NULL
203 DROP TABLE IF EXISTS NFVO_VNFCINST;
204 CREATE TABLE NFVO_VNFCINST (
205 `VNFCINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
206 `VDUID` varchar(255) NOT NULL,
207 `NFINSTID` varchar(255) NOT NULL,
208 `VMID` varchar(255) NOT NULL,
209 `STATUS` varchar(255) NOT NULL
212 DROP TABLE IF EXISTS NFVO_VNFFGINST;
213 CREATE TABLE NFVO_VNFFGINST (
214 `VNFFGDID` varchar(255) NOT NULL,
215 `VNFFGINSTID` varchar(255) NOT NULL PRIMARY KEY,
216 `NSINSTID` varchar(255) NOT NULL,
217 `DESC` varchar(255) NULL,
218 `VENDOR` varchar(255) NULL,
219 `VERSION` varchar(255) NULL,
220 `ENDPOINTNUMBER` integer NOT NULL,
221 `VLLIST` varchar(1024) NOT NULL,
222 `CPLIST` varchar(1024) NOT NULL,
223 `VNFLIST` varchar(1024) NOT NULL,
224 `FPLIST` varchar(1024) NOT NULL,
225 `STATUS` varchar(255) NOT NULL
228 DROP TABLE IF EXISTS NFVO_NFPACKAGEFILE;
229 CREATE TABLE NFVO_NFPACKAGEFILE (
230 `ID` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
231 `NFPACKAGEID` varchar(50) NOT NULL,
232 `FILENAME` varchar(100) NOT NULL,
233 `FILETYPE` varchar(2) NOT NULL,
234 `IMAGEID` varchar(50) NOT NULL,
235 `VIMID` varchar(50) NOT NULL,
236 `VIMUSER` varchar(50) NOT NULL,
237 `TENANT` varchar(50) NOT NULL,
238 `PURPOSE` varchar(1000) NOT NULL,
239 `STATUS` varchar(10) NOT NULL
242 SET FOREIGN_KEY_CHECKS = 0;
243 DROP TABLE IF EXISTS t_lcm_servicebaseinfo;
244 SET FOREIGN_KEY_CHECKS = 1;
245 CREATE TABLE t_lcm_servicebaseinfo (
246 serviceId VARCHAR(255) NOT NULL,
247 serviceName VARCHAR(255) NOT NULL,
248 serviceType VARCHAR(20) NOT NULL,
249 description VARCHAR(255) NULL,
250 activeStatus VARCHAR(20) NOT NULL,
251 status VARCHAR(20) NOT NULL,
252 creator VARCHAR(50) NOT NULL,
253 createTime BIGINT NOT NULL,
254 CONSTRAINT t_lcm_servicebaseinfo PRIMARY KEY(serviceId)
256 DROP TABLE IF EXISTS t_lcm_defPackage_mapping;
257 CREATE TABLE t_lcm_defPackage_mapping (
258 serviceId VARCHAR(255) NOT NULL,
259 serviceDefId VARCHAR(255) NOT NULL,
260 templateId VARCHAR(255) NOT NULL,
261 templateName VARCHAR(255) NOT NULL,
262 CONSTRAINT t_lcm_defPackage_mapping PRIMARY KEY(serviceId),
263 CONSTRAINT t_lcm_defPackage_mapping FOREIGN KEY (serviceId) REFERENCES t_lcm_servicebaseinfo (serviceId)
265 DROP TABLE IF EXISTS t_lcm_inputParam_mapping;
266 CREATE TABLE t_lcm_inputParam_mapping (
267 serviceId VARCHAR(255) NOT NULL,
268 inputKey VARCHAR(255) NOT NULL,
269 inputValue mediumtext NULL,
270 CONSTRAINT t_lcm_inputParam_mapping PRIMARY KEY(serviceId,inputKey),
271 CONSTRAINT t_lcm_inputParam_mapping FOREIGN KEY (serviceId) REFERENCES t_lcm_servicebaseinfo (serviceId)
274 DROP TABLE IF EXISTS NFVO_WF_PLAN;
275 CREATE TABLE NFVO_WF_PLAN (
276 `DEPLOYEDID` varchar(255) NOT NULL PRIMARY KEY,
277 `PROCESSID` varchar(255) NOT NULL,
278 `STATUS` varchar(255) NOT NULL,
279 `MESSAGE` varchar(1024) NULL,
280 `PLANNAME` varchar(255) NOT NULL