From 714a1b78f7a00ea71534c7aebde097fafc560d77 Mon Sep 17 00:00:00 2001 From: tangpeng Date: Fri, 3 Mar 2017 15:41:57 +0800 Subject: Modify sql scripts Change-Id: I927f848c26580e3ed7abc1fd88d4908ff1139075 Issue-ID: HOLMES-47 Signed-off-by: tangpeng --- .../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