From 714a1b78f7a00ea71534c7aebde097fafc560d77 Mon Sep 17 00:00:00 2001
From: tangpeng <tang.peng5@zte.com.cn>
Date: Fri, 3 Mar 2017 15:41:57 +0800
Subject: Modify sql scripts

Change-Id: I927f848c26580e3ed7abc1fd88d4908ff1139075
Issue-ID: HOLMES-47
Signed-off-by: tangpeng <tang.peng5@zte.com.cn>
---
 .../mysql/openo-holmes_rulemgt-createobj.sql       | 26 +++++++++++-----------
 1 file changed, 13 insertions(+), 13 deletions(-)

(limited to 'rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql')

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
index 4d6b296..609ec51 100644
--- 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
@@ -13,26 +13,26 @@
 -- 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';
+/******************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;
+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 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;
+GRANT ALL PRIVILEGES ON holmes.* 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';
+use holmes;
+set Names 'utf8';
 /******************DELETE OLD TABLE AND CREATE NEW***************************/
-USE HOLMES;
+use holmes;
 DROP TABLE IF EXISTS APLUS_RULE;
 CREATE TABLE APLUS_RULE (
   RID VARCHAR(30) NOT NULL,
@@ -56,5 +56,5 @@ CREATE TABLE APLUS_RULE (
   KEY IDX_APLUS_RULE_TEMPLATEID (TEMPLATEID),
   KEY IDX_APLUS_RULE_ENGINEID (ENGINEID),
   KEY IDX_APLUS_RULE_ENGINETYPE (ENGINETYPE)
-)
+);
 
-- 
cgit 1.2.3-korg

