summaryrefslogtreecommitdiffstats
path: root/rulemgt-standalone/src
diff options
context:
space:
mode:
authortangpeng <tang.peng5@zte.com.cn>2017-03-03 15:41:57 +0800
committertangpeng <tang.peng5@zte.com.cn>2017-03-03 15:45:49 +0800
commit714a1b78f7a00ea71534c7aebde097fafc560d77 (patch)
tree2fe351f1911b181d4282044804c192f477d7e958 /rulemgt-standalone/src
parent9e49960fc851a0cdf51a3607b21984628d1e9d44 (diff)
Modify sql scripts
Change-Id: I927f848c26580e3ed7abc1fd88d4908ff1139075 Issue-ID: HOLMES-47 Signed-off-by: tangpeng <tang.peng5@zte.com.cn>
Diffstat (limited to 'rulemgt-standalone/src')
-rw-r--r--rulemgt-standalone/src/main/assembly/bin/initDB.sh5
-rw-r--r--rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql26
2 files changed, 18 insertions, 13 deletions
diff --git a/rulemgt-standalone/src/main/assembly/bin/initDB.sh b/rulemgt-standalone/src/main/assembly/bin/initDB.sh
index a58450b..905ad1b 100644
--- a/rulemgt-standalone/src/main/assembly/bin/initDB.sh
+++ b/rulemgt-standalone/src/main/assembly/bin/initDB.sh
@@ -24,8 +24,13 @@ host=$4
echo "start init holmes rulemgt db"
main_path=$HOME/../
cat $main_path/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql
+echo "user="$user
+echo "password"$password
+echo "port="$port
+echo "host="$host
mysql -u$user -p$password -P$port -h$host <$main_path/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql
sql_result=$?
+cat "sql_result="$sql_result
if [ $sql_result != 0 ] ; then
echo "failed to init rulemgt database!"
exit 1
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)
-)
+);