From 3d84a2ac489366bb877211d29c3bf531c2d8a089 Mon Sep 17 00:00:00 2001 From: tangpeng Date: Tue, 28 Feb 2017 09:35:00 +0800 Subject: Add Rule Management Standalone Change-Id: I469fa41ea70f4f7b7740716287e46201f5faa484 Issue-ID:HOLMES-47 Signed-off-by: tangpeng --- .../mysql/openo-holmes_rulemgt-createobj.sql | 58 ++++++++++++++++++++++ 1 file changed, 58 insertions(+) create mode 100644 rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql (limited to 'rulemgt-standalone/src/main/assembly/dbscripts/mysql') diff --git a/rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql b/rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql new file mode 100644 index 0000000..c8ba2bd --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql @@ -0,0 +1,58 @@ +-- +-- Copyright 2017 ZTE Corporation. +-- +-- 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 holmes; +delete from user where User='holmes'; +FLUSH PRIVILEGES; + +/******************create new database and user***************************/ +create database holmes CHARACTER SET utf8; + +GRANT ALL PRIVILEGES ON holmes.* TO 'holmes'@'%' IDENTIFIED BY 'holmes' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'holmes'@'%' IDENTIFIED BY 'holmes' WITH GRANT OPTION; + +GRANT ALL PRIVILEGES ON catalog.* TO 'holmes'@'localhost' IDENTIFIED BY 'holmes' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'holmes'@'localhost' IDENTIFIED BY 'holmes' WITH GRANT OPTION; +FLUSH PRIVILEGES; + +use holmes; +set Names 'utf8'; +/******************delete old table and create new***************************/ +use holmes; +DROP TABLE IF EXISTS aplus_rule; +CREATE TABLE aplus_rule ( + rid varchar(30) NOT NULL, + name varchar(150) NOT NULL, + description varchar(4000) DEFAULT NULL, + enable int(1) NOT NULL, + templateID int(10) NOT NULL, + engineType varchar(20) NOT NULL, + creator varchar(20) NOT NULL, + createTime datetime NOT NULL, + updator varchar(20) DEFAULT NULL, + updateTime datetime DEFAULT NULL, + params varchar(4000) DEFAULT NULL, + content varchar(4000) NOT NULL, + vendor varchar(100) NOT NULL, + package varchar(255) NULL, + PRIMARY KEY (rid), + UNIQUE KEY name (name), + KEY IDX_APLUS_RULE_ENABLE (enable), + KEY IDX_APLUS_RULE_TEMPLATEID (templateID), + KEY IDX_APLUS_RULE_ENGINETYPE (engineType) +) + -- cgit 1.2.3-korg