2 -- Copyright 2016 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.
17 /******************drop old database and user***************************/
19 drop database IF EXISTS extsys;
20 delete from user where User='extsys';
23 /******************create new database and user***************************/
24 create database extsys CHARACTER SET utf8;
26 GRANT ALL PRIVILEGES ON extsys.* TO 'extsys'@'%' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
27 GRANT ALL PRIVILEGES ON mysql.* TO 'extsys'@'%' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
29 GRANT ALL PRIVILEGES ON extsys.* TO 'extsys'@'localhost' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
30 GRANT ALL PRIVILEGES ON mysql.* TO 'extsys'@'localhost' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
35 /******************drop old table and create new***************************/
36 DROP TABLE IF EXISTS extsys_base_table;
37 CREATE TABLE extsys_base_table (
38 ID VARCHAR(200) NOT NULL,
39 NAME VARCHAR(200) NULL,
40 TYPE VARCHAR(200) NULL,
41 VENDOR VARCHAR(100) NULL,
42 VERSION VARCHAR(100) NULL,
43 DESCRIPTION VARCHAR(100) NULL,
44 CREATETIME VARCHAR(200) NULL,
45 CATAGORY VARCHAR(200) NULL,
46 CONSTRAINT extsys_base_table PRIMARY KEY(ID)
48 DROP TABLE IF EXISTS extsys_ems_table;
49 CREATE TABLE extsys_ems_table (
50 EMSID VARCHAR(200) NOT NULL,
51 URL VARCHAR(100) NULL,
52 PRODUCTNAME VARCHAR(100) NULL,
53 USERNAME VARCHAR(100) NULL,
54 PASSWORD VARCHAR(100) NULL,
55 CONSTRAINT extsys_ems_table PRIMARY KEY(EMSID)
58 DROP TABLE IF EXISTS extsys_sdnc_table;
59 CREATE TABLE extsys_sdnc_table (
60 SDNCONTROLLERID VARCHAR(200) NOT NULL,
61 URL VARCHAR(100) NULL,
62 USERNAME VARCHAR(100) NULL,
63 PASSWORD VARCHAR(100) NULL,
64 PRODUCTNAME VARCHAR(100) NULL,
65 PROTOCOL VARCHAR(100) NULL,
66 CONSTRAINT extsys_sdnc_table PRIMARY KEY(SDNCONTROLLERID)
69 DROP TABLE IF EXISTS extsys_vim_table;
70 CREATE TABLE extsys_vim_table (
71 VIMID VARCHAR(200) NOT NULL,
72 URL VARCHAR(100) NULL,
73 USERNAME VARCHAR(100) NULL,
74 PASSWORD VARCHAR(100) NULL,
75 DOMAIN VARCHAR(100) NULL,
76 TENANT VARCHAR(100) NULL,
77 CONSTRAINT extsys_vim_table PRIMARY KEY(VIMID)
80 DROP TABLE IF EXISTS extsys_vnfm_table;
81 CREATE TABLE extsys_vnfm_table (
82 VNFMID VARCHAR(200) NOT NULL,
83 URL VARCHAR(200) NULL,
84 USERNAME VARCHAR(100) NULL,
85 PASSWORD VARCHAR(100) NULL,
86 VIMID VARCHAR(100) NULL,
87 CERTIFICATEURL VARCHAR(200) NULL,
88 CONSTRAINT extsys_vnfm_table PRIMARY KEY(VNFMID)