1 -- Copyright 2018 ZTE Corporation.
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 CREATE TABLE `NFINST` (
18 `NFINSTID` varchar(200) NOT NULL PRIMARY KEY,
19 `NFNAME` varchar(100),
20 `VNFMINSTID` varchar(255),
21 `PACKAGEID` varchar(200),
23 `FLAVOURID` varchar(200),
24 `LOCATION` varchar(200),
25 `VERSION` varchar(255),
26 `VENDOR` varchar(255),
27 `NETYPE` varchar(255),
29 `INPUTPARAMS` longtext,
30 `CREATETIME` varchar(200),
31 `LASTUPTIME` varchar(200),
32 `VNFINSTANCEDESC` varchar(200),
33 `VNFDID` varchar(200),
34 `VNFSOFTWAREVER` varchar(200),
35 `VNFCONFIGURABLEPROPERTIES` longtext,
36 `LOCALIZATIONLANGUAGE` varchar(255),
37 `OPERATIONSTATE` varchar(255),
43 `JOBID` varchar(255) NOT NULL PRIMARY KEY,
44 `JOBTYPE` varchar(255) NOT NULL,
45 `JOBACTION` varchar(255) NOT NULL,
46 `RESID` varchar(255) NOT NULL,
48 `STARTTIME` varchar(255),
49 `ENDTIME` varchar(255),
52 `PARENTJOBID` varchar(255),
53 `RESNAME` varchar(255)
56 CREATE TABLE `JOB_STATUS` (
57 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
58 `INDEXID` integer NOT NULL,
59 `JOBID` varchar(255) NOT NULL,
60 `STATUS` varchar(255) NOT NULL,
62 `DESCP` longtext NOT NULL,
63 `ERRCODE` varchar(255),
64 `ADDTIME` varchar(255)
67 CREATE TABLE `NFVOREGINFO` (
68 `NFVOID` varchar(255) NOT NULL PRIMARY KEY,
69 `VNFMINSTID` varchar(255) NOT NULL,
70 `URL` varchar(255) NOT NULL,
71 `USERNAME` varchar(255),
72 `PASSWD` varchar(255),
73 `AUTHTYPE` integer NOT NULL,
74 `CLIENTCERT` varchar(255),
75 `SERVERCERT` varchar(255),
76 `REGTIME` varchar(255) NOT NULL
79 CREATE TABLE `STORAGEINST` (
80 `STORAGEID` varchar(255) NOT NULL PRIMARY KEY,
81 `VIMID` varchar(255) NOT NULL,
82 `RESOURCEID` varchar(255) NOT NULL,
83 `INSTTYPE` integer NOT NULL,
84 `INSTID` varchar(255) NOT NULL,
86 `STORAGETYPE` varchar(255) NOT NULL,
87 `SIZE` varchar(255) NOT NULL,
89 `ISPREDEFINED` integer,
90 `CREATETIME` varchar(200),
94 CREATE TABLE `VMINST` (
95 `VMID` varchar(255) NOT NULL PRIMARY KEY,
96 `VIMID` varchar(255) NOT NULL,
97 `TENANT` varchar(255),
98 `RESOURCEID` varchar(255) NOT NULL,
99 `VMNAME` varchar(255) NOT NULL,
100 `NICARRAY` varchar(255) NOT NULL,
101 `METADATA` varchar(255) NOT NULL,
102 `VOLUMEARRAY` varchar(255) NOT NULL,
103 `SERVERGROUP` varchar(255) NOT NULL,
104 `AVAILABILITYZONE` varchar(255) NOT NULL,
105 `FLAVORID` varchar(255) NOT NULL,
106 `SECURITYGROUPS` varchar(255) NOT NULL,
107 `OPERATIONALSTATE` varchar(255),
108 `INSTTYPE` integer NOT NULL,
109 `ISPREDEFINED` integer,
110 `CREATETIME` varchar(200),
111 `INSTID` varchar(255) NOT NULL,
112 `NODEID` varchar(255)
115 CREATE TABLE `VNFCINST` (
116 `VNFCINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
117 `VDUID` varchar(255) NOT NULL,
118 `VDUTYPE` varchar(255) NOT NULL,
119 `NFINSTID` varchar(255) NOT NULL,
120 `VMID` varchar(255) NOT NULL,
121 `ISPREDEFINED` integer
124 CREATE TABLE `FLAVOURINST` (
125 `FLAVOURID` varchar(255) NOT NULL PRIMARY KEY,
126 `VIMID` varchar(255) NOT NULL,
127 `RESOURCEID` varchar(255) NOT NULL,
128 `NAME` varchar(255) NOT NULL,
129 `TENANT` varchar(255),
136 `EXTRASPECS` varchar(255) NOT NULL,
137 `INSTID` varchar(255) NOT NULL,
138 `CREATETIME` varchar(200),
139 `ISPREDEFINED` integer
142 CREATE TABLE `NETWORKINST` (
143 `NETWORKID` varchar(255) NOT NULL PRIMARY KEY,
144 `VIMID` varchar(255) NOT NULL,
145 `RESOURCEID` varchar(255) NOT NULL,
146 `INSTTYPE` integer NOT NULL,
147 `INSTID` varchar(255) NOT NULL,
148 `NAME` varchar(255) NOT NULL,
149 `TENANT` varchar(255),
150 `ISPREDEFINED` integer,
152 `VENDOR` varchar(255),
155 `NETWORKTYPE` varchar(255),
156 `SEGMENTID` varchar(255),
157 `NETWORKQOS` varchar(255),
158 `CREATETIME` varchar(200),
159 `PHYNETWORK` varchar(255),
162 `ROUTEREXTERNAL` integer,
163 `NODEID` varchar(255)
166 CREATE TABLE `SUBNETWORKINST` (
167 `SUBNETWORKID` varchar(255) NOT NULL PRIMARY KEY,
168 `VIMID` varchar(255) NOT NULL,
169 `RESOURCEID` varchar(255) NOT NULL,
170 `NETWORKID` varchar(255) NOT NULL,
171 `INSTTYPE` integer NOT NULL,
172 `INSTID` varchar(255) NOT NULL,
173 `NAME` varchar(255) NOT NULL,
175 `GATEWAYIP` varchar(255),
176 `ISDHCPENABLED` integer,
177 `CIDR` varchar(255) NOT NULL,
178 `VDSNAME` varchar(255),
179 `OPERATIONALSTATE` varchar(255),
180 `TENANT` varchar(255),
181 `ISPREDEFINED` integer,
182 `CREATETIME` varchar(200),
183 `DNSNAMESERVERS` longtext NOT NULL,
184 `HOSTROUTES` longtext NOT NULL,
185 `ALLOCATIONPOOLS` longtext NOT NULL
188 CREATE TABLE `VLINST` (
189 `VLINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
190 `VLDID` varchar(255) NOT NULL,
191 `VLINSTANCENAME` varchar(255),
192 `OWNERTYPE` integer NOT NULL,
193 `OWNERID` varchar(255) NOT NULL,
194 `RELATEDNETWORKID` varchar(255),
195 `RELATEDSUBNETWORKID` varchar(255),
196 `VLTYPE` integer NOT NULL,
197 `VIMID` varchar(255) NOT NULL,
198 `TENANT` varchar(50) NOT NULL
201 CREATE TABLE `PORTINST` (
202 `PORTID` varchar(255) NOT NULL PRIMARY KEY,
203 `NETWORKID` varchar(255) NOT NULL,
204 `SUBNETWORKID` varchar(255),
205 `VIMID` varchar(255) NOT NULL,
206 `RESOURCEID` varchar(255) NOT NULL,
208 `INSTTYPE` integer NOT NULL,
209 `INSTID` varchar(255) NOT NULL,
210 `CPINSTANCEID` varchar(255),
211 `BANDWIDTH` varchar(255),
212 `OPERATIONALSTATE` varchar(255),
213 `IPADDRESS` varchar(255) NOT NULL,
214 `MACADDRESS` varchar(255) NOT NULL,
215 `NICORDER` varchar(255) NOT NULL,
216 `FLOATIPADDRESS` varchar(255),
217 `SERVICEIPADDRESS` varchar(255),
218 `TYPEVIRTUALNIC` varchar(255),
219 `SFCENCAPSULATION` varchar(255),
220 `DIRECTION` varchar(255),
221 `TENANT` varchar(255),
222 `INTERFACENAME` varchar(255),
224 `CREATETIME` varchar(200),
225 `SECURITYGROUPS` varchar(255) NOT NULL,
226 `ISPREDEFINED` integer,
227 `NODEID` varchar(255)
230 CREATE TABLE `CPINST` (
231 `CPINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
232 `CPDID` varchar(255) NOT NULL,
233 `CPINSTANCENAME` varchar(255) NOT NULL,
234 `VLINSTANCEID` varchar(255) NOT NULL,
235 `OWNERTYPE` integer NOT NULL,
236 `OWNERID` varchar(255) NOT NULL,
237 `RELATEDTYPE` integer NOT NULL,
238 `RELATEDVL` varchar(255),
239 `RELATEDCP` varchar(255),
240 `RELATEDPORT` varchar(255)
243 CREATE TABLE `VNF_REG` (
244 `ID` varchar(200) NOT NULL PRIMARY KEY,
245 `IP` varchar(200) NOT NULL,
246 `PORT` varchar(200) NOT NULL,
247 `USERNAME` varchar(255) NOT NULL,
248 `PASSWORD` varchar(255) NOT NULL
251 CREATE TABLE `SUBSCRIPTION` (
252 `SUBSCRIPTIONID` varchar(200) NOT NULL PRIMARY KEY,
253 `CALLBACKURI` longtext NOT NULL,
255 `NOTIFICATIONTYPES` varchar(255),
256 `OPERATIONTYPES` longtext,
257 `OPERATIONSTATES` longtext,
258 `VNFINSTANCEFILTER` longtext,
259 `LINKS` longtext NOT NULL
262 CREATE TABLE `VNFLCMOPOCCS` (
263 `ID` varchar(255) NOT NULL PRIMARY KEY,
264 `OPERATIONSTATE` varchar(30) NOT NULL,
265 `STATEENTEREDTIME` varchar(30) NOT NULL,
266 `STARTTIME` varchar(30) NOT NULL,
267 `VNFINSTANCEID` varchar(255) NOT NULL,
268 `GRANTID` varchar(255),
269 `OPERATION` varchar(30) NOT NULL,
270 `ISAUTOMATICINVOCATION` varchar(5) NOT NULL,
271 `OPERATIONPARAMS` longtext NOT NULL,
272 `ISCANCELPENDING` varchar(5) NOT NULL,
273 `CANCELMODE` varchar(255),
275 `RESOURCECHANGES` longtext,
276 `CHANGEDINFO` longtext,
277 `CHANGEDEXTCONNECTIVITY` longtext,
278 `LINKS` longtext NOT NULL