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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
|
#*******************************************************************************
# Copyright 2016-2017 Huawei Technologies Co., Ltd.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#*******************************************************************************
/******************drop old database and user***************************/
use mysql;
drop database IF EXISTS resmanagementdb;
delete from user where User='resmanagement';
FLUSH PRIVILEGES;
/******************create new database and user***************************/
create database resmanagementdb CHARACTER SET utf8;
GRANT ALL PRIVILEGES ON resmanagementdb.* TO 'resmanagement'@'%' IDENTIFIED BY 'resmanagement' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON mysql.* TO 'resmanagement'@'%' IDENTIFIED BY 'resmanagement' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON resmanagementdb.* TO 'resmanagement'@'localhost' IDENTIFIED BY 'resmanagement' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON mysql.* TO 'resmanagement'@'localhost' IDENTIFIED BY 'resmanagement' WITH GRANT OPTION;
FLUSH PRIVILEGES;
use resmanagementdb;
set Names 'utf8';
/******************drop old table and create new***************************/
DROP TABLE IF EXISTS host;
CREATE TABLE host (
ID VARCHAR(128) NOT NULL,
NAME VARCHAR(256) NULL,
CPU VARCHAR(256) NULL,
MEMORY VARCHAR(256) NULL,
DISK VARCHAR(256) NULL,
VIM_ID VARCHAR(256) NULL,
VIM_NAME VARCHAR(256) NULL,
CONSTRAINT host PRIMARY KEY(ID)
);
DROP TABLE IF EXISTS location;
CREATE TABLE location (
ID VARCHAR(128) NOT NULL,
COUNTRY VARCHAR(256) NULL,
LOCATION VARCHAR(256) NULL,
LATITUDE VARCHAR(256) NULL,
LONGITUDE VARCHAR(256) NULL,
DESCRIPTION VARCHAR(256) NULL,
CONSTRAINT location PRIMARY KEY(ID)
);
DROP TABLE IF EXISTS network;
CREATE TABLE network (
ID VARCHAR(128) NOT NULL,
NAME VARCHAR(256) NULL,
TENANT_ID VARCHAR(256) NULL,
VIM_ID VARCHAR(256) NULL,
VIM_NAME VARCHAR(256) NULL,
STATUS VARCHAR(256) NULL,
PHYSICAL_NETWORK VARCHAR(256) NULL,
NETWORK_TYPE VARCHAR(256) NULL,
SEGMENTATION_ID VARCHAR(256) NULL,
CONSTRAINT network PRIMARY KEY(ID)
);
DROP TABLE IF EXISTS port;
CREATE TABLE port (
ID VARCHAR(128) NOT NULL,
NAME VARCHAR(256) NULL,
NWTWORK_ID VARCHAR(256) NULL,
STATUS VARCHAR(256) NULL,
TENANT_ID VARCHAR(256) NULL,
VIM_ID VARCHAR(256) NULL,
VIM_NAME VARCHAR(256) NULL,
CONSTRAINT port PRIMARY KEY(ID)
);
DROP TABLE IF EXISTS site;
CREATE TABLE site (
ID VARCHAR(128) NOT NULL,
NAME VARCHAR(256) NULL,
LOCATION VARCHAR(256) NULL,
COUNTRY VARCHAR(256) NULL,
VIM_ID VARCHAR(256) NULL,
VIM_NAME VARCHAR(256) NULL,
STATUS VARCHAR(256) NULL,
TOTAL_CPU VARCHAR(256) NULL,
TOTAL_MEMORY VARCHAR(256) NULL,
TOTAL_DISK VARCHAR(256) NULL,
USED_CPU VARCHAR(256) NULL,
USED_MEMORY VARCHAR(256) NULL,
USED_DISK VARCHAR(256) NULL,
CONSTRAINT site PRIMARY KEY(ID)
);
DROP TABLE IF EXISTS vim;
CREATE TABLE vim (
ID VARCHAR(128) NOT NULL,
CONSTRAINT vim PRIMARY KEY(ID)
);
DROP TABLE IF EXISTS vl;
CREATE TABLE vl (
ID VARCHAR(128) NOT NULL,
NAME VARCHAR(256) NULL,
BACKEND_ID VARCHAR(256) NULL,
IS_PUBLIC VARCHAR(256) NULL,
DC_NAME VARCHAR(256) NULL,
VIM_ID VARCHAR(256) NULL,
VIM_NAME VARCHAR(256) NULL,
PHYSICIAL_NET VARCHAR(256) NULL,
NS_ID VARCHAR(256) NULL,
NS_NAME VARCHAR(256) NULL,
DESCRIPTION VARCHAR(256) NULL,
NETWORK_TYPE VARCHAR(256) NULL,
SEGMENTATION VARCHAR(256) NULL,
MTU VARCHAR(256) NULL,
VLAN_TRANSPARENT VARCHAR(256) NULL,
ROUTER_EXTERNAL VARCHAR(256) NULL,
RESOURCE_PROVIDER_TYPE VARCHAR(256) NULL,
RESOURCE_PROVIDER_ID VARCHAR(256) NULL,
CONSTRAINT vl PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS vnf;
CREATE TABLE vnf (
ID VARCHAR(128) NOT NULL,
VNF_INSTANCE_ID VARCHAR(256) NULL,
VNF_INSTANCE_NAME VARCHAR(256) NULL,
NS_ID VARCHAR(256) NULL,
NS_NAME VARCHAR(256) NULL,
VNFM_ID VARCHAR(256) NULL,
VNFM_NAME VARCHAR(256) NULL,
VNF_PACKAGE_NAME VARCHAR(256) NULL,
VNF_DESCRIPTOR_NAME VARCHAR(256) NULL,
VIM_ID VARCHAR(256) NULL,
VIM_NAME VARCHAR(256) NULL,
VIM_TENANT VARCHAR(256) NULL,
JOB_ID VARCHAR(256) NULL,
VNF_STATUS VARCHAR(256) NULL,
VNF_TYPE VARCHAR(256) NULL,
MAX_VM INT NULL,
MAX_CPU INT NULL,
MAX_DISK INT NULL,
MAX_RAM INT NULL,
MAX_SHD INT NULL,
MAX_NET INT NULL,
NAME VARCHAR(256) NULL,
CONSTRAINT vnf PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS vm;
CREATE TABLE vm (
VM_ID VARCHAR(128) NOT NULL,
VM_NAME VARCHAR(256) NULL,
VM_STATUS VARCHAR(256) NULL,
VNF_INSTANCE_ID VARCHAR(256) NULL,
CONSTRAINT vm PRIMARY KEY (VM_ID)
);
DROP TABLE IF EXISTS vnfinfo;
CREATE TABLE vnfinfo (
VNF_INSTANCE_ID VARCHAR(128) NOT NULL,
NS_ID VARCHAR(256) NULL,
VNFM_ID VARCHAR(256) NULL,
CONSTRAINT vnfinfo PRIMARY KEY (VNF_INSTANCE_ID)
);
DROP TABLE IF EXISTS ns;
CREATE TABLE ns (
ID VARCHAR(256) NOT NULL,
NAME VARCHAR(256) NULL,
NSD_ID VARCHAR(256) NULL,
DESCRIPTION VARCHAR(1024) NULL,
STATUS VARCHAR(256) NULL,
CTEATE_TIME VARCHAR(256) NULL,
LAST_UPDATE VARCHAR(256) NULL,
CONSTRAINT ns PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS vnfstatus;
CREATE TABLE vnfstatus (
VNF_INSTANCE_ID VARCHAR(128) NOT NULL,
JOB_ID VARCHAR(256) NULL,
NS_ID VARCHAR(256) NULL,
VNFM_ID VARCHAR(256) NULL,
RESPONSE_DESCRIPTOR VARCHAR(1024) NULL,
STATUS VARCHAR(256) NULL,
PROGRESS VARCHAR(256) NULL,
STATUS_DESCRIPTION VARCHAR(256) NULL,
ERROR_CODE VARCHAR(256) NULL,
RESPONSE_ID VARCHAR(256) NULL,
RESPONSE_HISTORY_LIST VARCHAR(1024) NULL,
ADD_VM VARCHAR(1024) NULL,
DEL_VM VARCHAR(1024) NULL,
CONSTRAINT vnfstatus PRIMARY KEY (VNF_INSTANCE_ID)
);
|
