1 -- Copyright 2017 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 `PACKAGEID` varchar(200),
22 `FLAVOURID` varchar(200),
23 `LOCATION` varchar(200),
24 `VERSION` varchar(255),
25 `VENDOR` varchar(255),
26 `NETYPE` varchar(255),
28 `INPUTPARAMS` longtext,
29 `CREATETIME` varchar(200),
30 `LASTUPTIME` varchar(200),
31 `VNFINSTANCEDESC` varchar(200),
32 `VNFDID` varchar(200),
33 `VNFSOFTWAREVER` varchar(200),
34 `VNFCONFIGURABLEPROPERTIES` longtext,
35 `LOCALIZATIONLANGUAGE` varchar(255)
39 `JOBID` varchar(255) NOT NULL PRIMARY KEY,
40 `JOBTYPE` varchar(255) NOT NULL,
41 `JOBACTION` varchar(255) NOT NULL,
42 `RESID` varchar(255) NOT NULL,
44 `STARTTIME` varchar(255),
45 `ENDTIME` varchar(255),
48 `PARENTJOBID` varchar(255),
49 `RESNAME` varchar(255)
52 CREATE TABLE `JOB_STATUS` (
53 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
54 `INDEXID` integer NOT NULL,
55 `JOBID` varchar(255) NOT NULL,
56 `STATUS` varchar(255) NOT NULL,
58 `DESCP` longtext NOT NULL,
59 `ERRCODE` varchar(255),
60 `ADDTIME` varchar(255)
63 CREATE TABLE `NFVOREGINFO` (
64 `NFVOID` varchar(255) NOT NULL PRIMARY KEY,
65 `VNFMINSTID` varchar(255) NOT NULL,
66 `URL` varchar(255) NOT NULL,
67 `USERNAME` varchar(255),
68 `PASSWD` varchar(255),
69 `AUTHTYPE` integer NOT NULL,
70 `CLIENTCERT` varchar(255),
71 `SERVERCERT` varchar(255),
72 `REGTIME` varchar(255) NOT NULL
75 CREATE TABLE `STORAGEINST` (
76 `STORAGEID` varchar(255) NOT NULL PRIMARY KEY,
77 `VIMID` varchar(255) NOT NULL,
78 `RESOURCEID` varchar(255) NOT NULL,
79 `INSTTYPE` integer NOT NULL,
80 `INSTID` varchar(255) NOT NULL,
82 `STORAGETYPE` varchar(255) NOT NULL,
83 `SIZE` varchar(255) NOT NULL,
85 `ISPREDEFINED` integer,
86 `CREATETIME` varchar(200),
90 CREATE TABLE `VMINST` (
91 `VMID` varchar(255) NOT NULL PRIMARY KEY,
92 `VIMID` varchar(255) NOT NULL,
93 `TENANT` varchar(255),
94 `RESOURCEID` varchar(255) NOT NULL,
95 `VMNAME` varchar(255) NOT NULL,
96 `NICARRAY` varchar(255) NOT NULL,
97 `METADATA` varchar(255) NOT NULL,
98 `VOLUMEARRAY` varchar(255) NOT NULL,
99 `SERVERGROUP` varchar(255) NOT NULL,
100 `AVAILABILITYZONE` varchar(255) NOT NULL,
101 `FLAVORID` varchar(255) NOT NULL,
102 `SECURITYGROUPS` varchar(255) NOT NULL,
103 `OPERATIONALSTATE` varchar(255),
104 `INSTTYPE` integer NOT NULL,
105 `ISPREDEFINED` integer,
106 `CREATETIME` varchar(200),
107 `INSTID` varchar(255) NOT NULL,
108 `NODEID` varchar(255)
111 CREATE TABLE `VNFCINST` (
112 `VNFCINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
113 `VDUID` varchar(255) NOT NULL,
114 `VDUTYPE` varchar(255) NOT NULL,
115 `NFINSTID` varchar(255) NOT NULL,
116 `VMID` varchar(255) NOT NULL,
117 `ISPREDEFINED` integer
120 CREATE TABLE `FLAVOURINST` (
121 `FLAVOURID` varchar(255) NOT NULL PRIMARY KEY,
122 `VIMID` varchar(255) NOT NULL,
123 `RESOURCEID` varchar(255) NOT NULL,
124 `NAME` varchar(255) NOT NULL,
125 `TENANT` varchar(255),
132 `EXTRASPECS` varchar(255) NOT NULL,
133 `INSTID` varchar(255) NOT NULL,
134 `CREATETIME` varchar(200),
135 `ISPREDEFINED` integer
138 CREATE TABLE `NETWORKINST` (
139 `NETWORKID` varchar(255) NOT NULL PRIMARY KEY,
140 `VIMID` varchar(255) NOT NULL,
141 `RESOURCEID` varchar(255) NOT NULL,
142 `INSTTYPE` integer NOT NULL,
143 `INSTID` varchar(255) NOT NULL,
144 `NAME` varchar(255) NOT NULL,
145 `TENANT` varchar(255),
146 `ISPREDEFINED` integer,
148 `VENDOR` varchar(255),
151 `NETWORKTYPE` varchar(255),
152 `SEGMENTID` varchar(255),
153 `NETWORKQOS` varchar(255),
154 `CREATETIME` varchar(200),
155 `PHYNETWORK` varchar(255),
158 `ROUTEREXTERNAL` integer,
159 `NODEID` varchar(255)
162 CREATE TABLE `SUBNETWORKINST` (
163 `SUBNETWORKID` varchar(255) NOT NULL PRIMARY KEY,
164 `VIMID` varchar(255) NOT NULL,
165 `RESOURCEID` varchar(255) NOT NULL,
166 `NETWORKID` varchar(255) NOT NULL,
167 `INSTTYPE` integer NOT NULL,
168 `INSTID` varchar(255) NOT NULL,
169 `NAME` varchar(255) NOT NULL,
171 `GATEWAYIP` varchar(255),
172 `ISDHCPENABLED` integer,
173 `CIDR` varchar(255) NOT NULL,
174 `VDSNAME` varchar(255),
175 `OPERATIONALSTATE` varchar(255),
176 `TENANT` varchar(255),
177 `ISPREDEFINED` integer,
178 `CREATETIME` varchar(200),
179 `DNSNAMESERVERS` longtext NOT NULL,
180 `HOSTROUTES` longtext NOT NULL,
181 `ALLOCATIONPOOLS` longtext NOT NULL
184 CREATE TABLE `VLINST` (
185 `VLINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
186 `VLDID` varchar(255) NOT NULL,
187 `VLINSTANCENAME` varchar(255),
188 `OWNERTYPE` integer NOT NULL,
189 `OWNERID` varchar(255) NOT NULL,
190 `RELATEDNETWORKID` varchar(255),
191 `RELATEDSUBNETWORKID` varchar(255),
192 `VLTYPE` integer NOT NULL,
193 `VIMID` varchar(255) NOT NULL,
194 `TENANT` varchar(50) NOT NULL
197 CREATE TABLE `PORTINST` (
198 `PORTID` varchar(255) NOT NULL PRIMARY KEY,
199 `NETWORKID` varchar(255) NOT NULL,
200 `SUBNETWORKID` varchar(255),
201 `VIMID` varchar(255) NOT NULL,
202 `RESOURCEID` varchar(255) NOT NULL,
204 `INSTTYPE` integer NOT NULL,
205 `INSTID` varchar(255) NOT NULL,
206 `CPINSTANCEID` varchar(255),
207 `BANDWIDTH` varchar(255),
208 `OPERATIONALSTATE` varchar(255),
209 `IPADDRESS` varchar(255) NOT NULL,
210 `MACADDRESS` varchar(255) NOT NULL,
211 `NICORDER` varchar(255) NOT NULL,
212 `FLOATIPADDRESS` varchar(255),
213 `SERVICEIPADDRESS` varchar(255),
214 `TYPEVIRTUALNIC` varchar(255),
215 `SFCENCAPSULATION` varchar(255),
216 `DIRECTION` varchar(255),
217 `TENANT` varchar(255),
218 `INTERFACENAME` varchar(255),
220 `CREATETIME` varchar(200),
221 `SECURITYGROUPS` varchar(255) NOT NULL,
222 `ISPREDEFINED` integer,
223 `NODEID` varchar(255)
226 CREATE TABLE `CPINST` (
227 `CPINSTANCEID` varchar(255) NOT NULL PRIMARY KEY,
228 `CPDID` varchar(255) NOT NULL,
229 `CPINSTANCENAME` varchar(255) NOT NULL,
230 `VLINSTANCEID` varchar(255) NOT NULL,
231 `OWNERTYPE` integer NOT NULL,
232 `OWNERID` varchar(255) NOT NULL,
233 `RELATEDTYPE` integer NOT NULL,
234 `RELATEDVL` varchar(255),
235 `RELATEDCP` varchar(255),
236 `RELATEDPORT` varchar(255)
239 CREATE TABLE `VNF_REG` (
240 `ID` varchar(200) NOT NULL PRIMARY KEY,
241 `IP` varchar(200) NOT NULL,
242 `PORT` varchar(200) NOT NULL,
243 `USERNAME` varchar(255) NOT NULL,
244 `PASSWORD` varchar(255) NOT NULL