Add holmes sql script

Change-Id: I707d410fe4f1389f8002a4526f53d15484125377
Issue-Id:HOLMES-47
Signed-off-by: tangpeng <tang.peng5@zte.com.cn>

diff --git a/engine-d-standalone/src/main/assembly/conf/engine-d.yml b/engine-d-standalone/src/main/assembly/conf/engine-d.yml
index 247ac4b..5fce4b8 100644 (file)
--- a/engine-d-standalone/src/main/assembly/conf/engine-d.yml
+++ b/engine-d-standalone/src/main/assembly/conf/engine-d.yml
@@ -67,6 +67,6 @@ database:
 mqConfig:\r
   brokerIp: 127.0.0.1\r
   brokerPort: 61616\r
-  mqServiceName: activemq\r
-  mqServiceVersion: v1\r
+  brokerUsername: activemq\r
+  brokerPassword: v1\r
 \r

diff --git a/engine-d-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_engine_d-createobj.sql b/engine-d-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_engine_d-createobj.sql
index 4f5294a..73d51ee 100644 (file)
--- a/engine-d-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_engine_d-createobj.sql
+++ b/engine-d-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_engine_d-createobj.sql
@@ -13,5 +13,48 @@
 -- See the License for the specific language governing permissions and\r
 -- limitations under the License.\r
 --\r
+/******************drop old database and user***************************/\r
+use mysql;\r
+drop database IF  EXISTS holmes;\r
+delete from user where User='holmes';\r
+FLUSH PRIVILEGES;\r
 \r
+/******************create new database and user***************************/\r
+create database holmes CHARACTER SET utf8;\r
+\r
+GRANT ALL PRIVILEGES ON holmes.* TO 'holmes'@'%' IDENTIFIED BY 'holmes' WITH GRANT OPTION;\r
+GRANT ALL PRIVILEGES ON mysql.* TO 'holmes'@'%' IDENTIFIED BY 'holmes' WITH GRANT OPTION;\r
+\r
+GRANT ALL PRIVILEGES ON catalog.* TO 'holmes'@'localhost' IDENTIFIED BY 'holmes' WITH GRANT OPTION;\r
+GRANT ALL PRIVILEGES ON mysql.* TO 'holmes'@'localhost' IDENTIFIED BY 'holmes' WITH GRANT OPTION;\r
+FLUSH PRIVILEGES;\r
+\r
+use holmes;\r
+set Names 'utf8';\r
+/******************delete old table and create new***************************/\r
+use holmes;\r
+DROP TABLE IF EXISTS aplus_rule;\r
+CREATE TABLE aplus_rule (\r
+  rid varchar(30) NOT NULL,\r
+  name varchar(150) CHARACTER NOT NULL,\r
+  description varchar(4000) CHARACTER SET  DEFAULT NULL,\r
+  enable int(1) NOT NULL,\r
+  templateID int(10) NOT NULL,\r
+  engineID varchar(20) CHARACTER  NOT NULL,\r
+  engineType varchar(20) CHARACTER  NOT NULL,\r
+  creator varchar(20) CHARACTER  NOT NULL,\r
+  createTime datetime NOT NULL,\r
+  updator varchar(20) CHARACTER  DEFAULT NULL,\r
+  updateTime datetime DEFAULT NULL,\r
+  params varchar(4000) CHARACTER  DEFAULT NULL,\r
+  content varchar(4000) CHARACTER  NOT NULL,\r
+  vendor varchar(100) CHARACTER  NOT NULL,\r
+  package varchar(255) DEFAULT NULL,\r
+  PRIMARY KEY (rid),\r
+  UNIQUE KEY name (name),\r
+  KEY IDX_APLUS_RULE_ENABLE (enable),\r
+  KEY IDX_APLUS_RULE_TEMPLATEID (templateID),\r
+  KEY IDX_APLUS_RULE_ENGINEID (engineID),\r
+  KEY IDX_APLUS_RULE_ENGINETYPE (engineType)\r
+)\r
 \r