Add Rule Management Standalone

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

12 files changed, 667 insertions, 0 deletions

diff --git a/rulemgt-standalone/linux64-assembly.xml b/rulemgt-standalone/linux64-assembly.xml
new file mode 100644
index 0000000..4bb9c11
--- /dev/null
+++ b/rulemgt-standalone/linux64-assembly.xml
@@ -0,0 +1,31 @@
+<!--
+
+    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.
+
+-->
+<assembly xmlns="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xsi:schemaLocation="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2 http://maven.apache.org/xsd/assembly-1.1.2.xsd">
+    <id>linux64</id>
+    <formats>
+        <format>zip</format>
+    </formats>
+    <includeBaseDirectory>false</includeBaseDirectory>
+    <fileSets>
+        <fileSet>
+            <directory>target/assembly/linux64</directory>
+            <outputDirectory></outputDirectory>
+        </fileSet>
+    </fileSets>
+</assembly>
diff --git a/rulemgt-standalone/pom.xml b/rulemgt-standalone/pom.xml
new file mode 100644
index 0000000..ea4b985
--- /dev/null
+++ b/rulemgt-standalone/pom.xml
@@ -0,0 +1,174 @@
+<?xml version="1.0"?>
+<!--
+
+    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.
+
+-->
+<project xmlns="http://maven.apache.org/POM/4.0.0"
+  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+  <parent>
+    <groupId>org.openo.holmes.rule-management</groupId>
+    <artifactId>holmes-rulemgt-parent</artifactId>
+    <version>1.1.0-SNAPSHOT</version>
+  </parent>
+
+  <artifactId>holmes-rulemgt-standalone</artifactId>
+  <modelVersion>4.0.0</modelVersion>
+  <name>holmes-rulemgt/holmes-rulemgt-standalone</name>
+  <packaging>pom</packaging>
+
+  <build>
+    <plugins>
+      <plugin>
+        <artifactId>maven-resources-plugin</artifactId>
+        <executions>
+          <execution>
+            <id>copy-resources-${linux64id}</id>
+            <phase>process-resources</phase>
+            <goals>
+              <goal>copy-resources</goal>
+            </goals>
+            <configuration>
+              <outputDirectory>${linux64outputdir}</outputDirectory>
+              <resources>
+                <resource>
+                  <directory>src/main/assembly/</directory>
+                  <filtering>false</filtering>
+                  <includes>
+                    <include>**/*</include>
+                  </includes>
+                  <excludes>
+                    <exclude>**/*.bat</exclude>
+                  </excludes>
+                </resource>
+              </resources>
+              <overwrite>true</overwrite>
+            </configuration>
+          </execution>
+          <execution>
+            <id>copy-resources-${win64id}</id>
+            <phase>process-resources</phase>
+            <goals>
+              <goal>copy-resources</goal>
+            </goals>
+            <configuration>
+              <outputDirectory>${win64outputdir}</outputDirectory>
+              <resources>
+                <resource>
+                  <directory>src/main/assembly/</directory>
+                  <filtering>false</filtering>
+                  <includes>
+                    <include>**/*</include>
+                  </includes>
+                  <excludes>
+                    <exclude>**/*.sh</exclude>
+                  </excludes>
+                </resource>
+              </resources>
+              <overwrite>true</overwrite>
+            </configuration>
+          </execution>
+        </executions>
+      </plugin>
+      <plugin>
+        <groupId>org.apache.maven.plugins</groupId>
+        <artifactId>maven-dependency-plugin</artifactId>
+        <executions>
+          <execution>
+            <id>copy-jar-${linux64id}</id>
+            <goals>
+              <goal>copy</goal>
+            </goals>
+            <phase>prepare-package</phase>
+            <configuration>
+              <artifactItems>
+                <artifactItem>
+                  <groupId>org.openo.holmes.rule-management</groupId>
+                  <artifactId>holmes-rulemgt</artifactId>
+                  <type>jar</type>
+                  <overWrite>true</overWrite>
+                  <outputDirectory>${linux64outputdir}</outputDirectory>
+                  <destFileName>holmes-rulemgt.jar</destFileName>
+                </artifactItem>
+              </artifactItems>
+            </configuration>
+          </execution>
+          <execution>
+            <id>copy-jar-${win64id}</id>
+            <goals>
+              <goal>copy</goal>
+            </goals>
+            <phase>prepare-package</phase>
+            <configuration>
+              <artifactItems>
+                <artifactItem>
+                  <groupId>org.openo.holmes.rule-management</groupId>
+                  <artifactId>holmes-rulemgt</artifactId>
+                  <type>jar</type>
+                  <overWrite>true</overWrite>
+                  <outputDirectory>${win64outputdir}</outputDirectory>
+                  <destFileName>holmes-rulemgt.jar</destFileName>
+                </artifactItem>
+              </artifactItems>
+            </configuration>
+          </execution>
+        </executions>
+      </plugin>
+      <plugin>
+        <groupId>org.apache.maven.plugins</groupId>
+        <artifactId>maven-assembly-plugin</artifactId>
+        <executions>
+          <execution>
+            <id>linux64</id>
+            <configuration>
+              <descriptors>
+                <descriptor>linux64-assembly.xml</descriptor>
+              </descriptors>
+              <appendAssemblyId>true</appendAssemblyId>
+              <outputDirectory>target/version</outputDirectory>
+            </configuration>
+            <phase>package</phase>
+            <goals>
+              <goal>attached</goal>
+            </goals>
+          </execution>
+          <execution>
+            <id>win64</id>
+            <configuration>
+              <descriptors>
+                <descriptor>win64-assembly.xml</descriptor>
+              </descriptors>
+              <appendAssemblyId>true</appendAssemblyId>
+              <outputDirectory>target/version</outputDirectory>
+            </configuration>
+            <phase>package</phase>
+            <goals>
+              <goal>attached</goal>
+            </goals>
+          </execution>
+        </executions>
+      </plugin>
+    </plugins>
+  </build>
+
+  <dependencies>
+    <dependency>
+      <groupId>org.openo.holmes.rule-management</groupId>
+      <artifactId>holmes-rulemgt</artifactId>
+      <version>${project.version}</version>
+    </dependency>
+  </dependencies>
+</project>
diff --git a/rulemgt-standalone/src/main/assembly/bin/find_kill_process.bat b/rulemgt-standalone/src/main/assembly/bin/find_kill_process.bat
new file mode 100644
index 0000000..6c61d50
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/bin/find_kill_process.bat
@@ -0,0 +1,24 @@
+@REM

+@REM Copyright 2017 ZTE Corporation.

+@REM

+@REM Licensed under the Apache License, Version 2.0 (the "License");

+@REM you may not use this file except in compliance with the License.

+@REM You may obtain a copy of the License at

+@REM

+@REM     http://www.apache.org/licenses/LICENSE-2.0

+@REM

+@REM Unless required by applicable law or agreed to in writing, software

+@REM distributed under the License is distributed on an "AS IS" BASIS,

+@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

+@REM See the License for the specific language governing permissions and

+@REM limitations under the License.

+@REM

+

+echo %1 | findstr %2 >NUL

+echo ERRORLEVEL=%ERRORLEVEL%

+IF ERRORLEVEL 1 goto findend

+for /f "tokens=1" %%a in (%1) do (  

+    echo kill %1

+    taskkill /F /pid %%a

+)

+:findend
\ No newline at end of file
diff --git a/rulemgt-standalone/src/main/assembly/bin/initDB.bat b/rulemgt-standalone/src/main/assembly/bin/initDB.bat
new file mode 100644
index 0000000..f6d83af
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/bin/initDB.bat
@@ -0,0 +1,34 @@
+@REM
+@REM Copyright 2017 ZTE Corporation.
+@REM
+@REM Licensed under the Apache License, Version 2.0 (the "License");
+@REM you may not use this file except in compliance with the License.
+@REM You may obtain a copy of the License at
+@REM
+@REM     http://www.apache.org/licenses/LICENSE-2.0
+@REM
+@REM Unless required by applicable law or agreed to in writing, software
+@REM distributed under the License is distributed on an "AS IS" BASIS,
+@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+@REM See the License for the specific language governing permissions and
+@REM limitations under the License.
+@REM
+
+@echo off
+set HOME=%~dp0
+set user=%1
+set password=%2
+set port=%3
+set host=%4
+echo start init holmes rulemgt db
+echo HOME=%HOME%
+set main_path=%HOME%..\
+cd /d %main_path%
+mysql -u%user% -p%password% -P%port% -h%host% < %main_path%\dbscripts\mysql\openo-holmes_rulemgt-createobj.sql
+set "err=%errorlevel%"
+if "%err%"=="0" (
+   echo init rulemgt db success
+  ) else (
+    echo failed init rulemgt db
+    pause
+  )
\ No newline at end of file
diff --git a/rulemgt-standalone/src/main/assembly/bin/initDB.sh b/rulemgt-standalone/src/main/assembly/bin/initDB.sh
new file mode 100644
index 0000000..f49123d
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/bin/initDB.sh
@@ -0,0 +1,34 @@
+#!/bin/bash
+#
+# 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.
+#
+
+DIRNAME=`dirname $0`
+HOME=`cd $DIRNAME/; pwd`
+user=$1
+password=$2
+port=$3
+host=$4
+echo "start init holmes rulemgt db"
+main_path=$HOME/../
+mysql -u$user -p$password -P$port -h$host <$main_path/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql
+sql_result=$?
+if [ $sql_result != 0 ] ; then
+   echo "failed to init rulemgt database!"
+   exit 1
+fi
+echo "init rulemgt success!"
+exit 0
+
diff --git a/rulemgt-standalone/src/main/assembly/bin/run.bat b/rulemgt-standalone/src/main/assembly/bin/run.bat
new file mode 100644
index 0000000..6553c82
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/bin/run.bat
@@ -0,0 +1,41 @@
+@REM

+@REM Copyright 2017 ZTE Corporation.

+@REM

+@REM Licensed under the Apache License, Version 2.0 (the "License");

+@REM you may not use this file except in compliance with the License.

+@REM You may obtain a copy of the License at

+@REM

+@REM     http://www.apache.org/licenses/LICENSE-2.0

+@REM

+@REM Unless required by applicable law or agreed to in writing, software

+@REM distributed under the License is distributed on an "AS IS" BASIS,

+@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

+@REM See the License for the specific language governing permissions and

+@REM limitations under the License.

+@REM

+

+@echo off

+title holmes-rulemgt-service

+

+set RUNHOME=%~dp0

+echo ### RUNHOME: %RUNHOME%

+echo ### Starting rulemgt-service

+set main_path=%RUNHOME%..\

+cd /d %main_path%

+set JAVA="%JAVA_HOME%\bin\java.exe"

+set port=8312

+set jvm_opts=-Xms50m -Xmx128m

+rem set jvm_opts=%jvm_opts% -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=%port%,server=y,suspend=n

+set class_path=%main_path%;%main_path%holmes-rulemgt.jar

+echo ### jvm_opts: %jvm_opts%

+echo ### class_path: %class_path%

+

+%JAVA% -classpath %class_path% %jvm_opts% org.openo.holmes.rulemgt.RuleActiveApp server %main_path%conf/rulemgt.yml

+

+IF ERRORLEVEL 1 goto showerror

+exit

+:showerror

+echo WARNING: Error occurred during startup or Server abnormally stopped by way of killing the process,Please check!

+echo After checking, press any key to close 

+pause

+exit
\ No newline at end of file
diff --git a/rulemgt-standalone/src/main/assembly/bin/run.sh b/rulemgt-standalone/src/main/assembly/bin/run.sh
new file mode 100644
index 0000000..0519cc2
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/bin/run.sh
@@ -0,0 +1,35 @@
+#
+# 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.
+#
+
+DIRNAME=`dirname $0`
+RUNHOME=`cd $DIRNAME/; pwd`
+echo @RUNHOME@ $RUNHOME
+
+echo @JAVA_HOME@ $JAVA_HOME
+JAVA="$JAVA_HOME/bin/java"
+echo @JAVA@ $JAVA
+main_path=$RUNHOME/../
+cd $main_path
+JAVA_OPTS="-Xms50m -Xmx128m"
+port=8312
+#JAVA_OPTS="$JAVA_OPTS -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=$port,server=y,suspend=n"
+echo @JAVA_OPTS@ $JAVA_OPTS
+
+class_path="$main_path/:$main_path/holmes-rulemgt.jar"
+echo @class_path@ $class_path
+
+"$JAVA" $JAVA_OPTS -classpath "$class_path" org.openo.holmes.rulemgt.RuleActiveApp server "$main_path/conf/rulemgt.yml"
+
diff --git a/rulemgt-standalone/src/main/assembly/bin/stop.bat b/rulemgt-standalone/src/main/assembly/bin/stop.bat
new file mode 100644
index 0000000..ca7b4ff
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/bin/stop.bat
@@ -0,0 +1,34 @@
+@REM

+@REM Copyright 2017 ZTE Corporation.

+@REM

+@REM Licensed under the Apache License, Version 2.0 (the "License");

+@REM you may not use this file except in compliance with the License.

+@REM You may obtain a copy of the License at

+@REM

+@REM     http://www.apache.org/licenses/LICENSE-2.0

+@REM

+@REM Unless required by applicable law or agreed to in writing, software

+@REM distributed under the License is distributed on an "AS IS" BASIS,

+@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

+@REM See the License for the specific language governing permissions and

+@REM limitations under the License.

+@REM

+

+@echo off

+title stopping engine-d-service

+

+set HOME=%~dp0

+set Main_Class="org.openo.holmes.rulemgt.RuleActiveApp"

+

+echo ================== engine-d-service info =============================================

+echo HOME=$HOME

+echo Main_Class=%Main_Class%

+echo ===============================================================================

+

+echo ### Stopping engine-d-service

+cd /d %HOME%

+

+for /f "delims=" %%i in ('"%JAVA_HOME%\bin\jcmd"') do (

+  call find_kill_process "%%i" %Main_Class%

+)

+exit
\ No newline at end of file
diff --git a/rulemgt-standalone/src/main/assembly/bin/stop.sh b/rulemgt-standalone/src/main/assembly/bin/stop.sh
new file mode 100644
index 0000000..f9e07a4
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/bin/stop.sh
@@ -0,0 +1,44 @@
+#!/bin/bash
+#
+# 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.
+#
+
+DIRNAME=`dirname $0`
+HOME=`cd $DIRNAME/; pwd`
+Main_Class="org.openo.holmes.rulemgt.RuleActiveApp"
+
+echo ================== engine-d-service info =============================================
+echo HOME=$HOME
+echo Main_Class=$Main_Class
+echo ===============================================================================
+cd $HOME; pwd
+
+echo @WORK_DIR@ $HOME
+
+function save_service_pid(){
+    service_pid=`ps -ef | grep $Main_Class | grep -v grep | awk '{print $2}'`
+    echo @service_pid@ $service_pid
+}
+
+function kill_service_process(){
+    ps -p $service_pid
+    if [ $? == 0 ]; then
+        kill -9 $service_pid
+    fi
+}
+
+save_service_pid;
+echo @C_CMD@ kill -9 $service_pid
+kill_service_process;
\ No newline at end of file
diff --git a/rulemgt-standalone/src/main/assembly/conf/rulemgt.yml b/rulemgt-standalone/src/main/assembly/conf/rulemgt.yml
new file mode 100644
index 0000000..91d6eb4
--- /dev/null
+++ b/rulemgt-standalone/src/main/assembly/conf/rulemgt.yml
@@ -0,0 +1,127 @@
+apidescription: ZTE Holmes rule Management rest API
+
+# use the simple server factory if you only want to run on a single port
+#server:
+#  type: simple
+#  connector:
+#    type: http
+#    port: 12003
+
+server:
+  type: simple
+  rootPath:  '/api/correlation-mgt/v1/*'
+  applicationContextPath: /
+  adminContextPath: /admin
+  connector:
+    type: http
+    port: 12004
+
+# Logging settings.
+logging:
+
+  # The default level of all loggers. Can be OFF, ERROR, WARN, INFO, DEBUG, TRACE, or ALL.
+  level: INFO
+
+  # Logger-specific levels.
+  loggers:
+
+    # Sets the level for 'com.example.app' to DEBUG.
+    com.example: DEBUG
+  
+  appenders:
+    - type: console
+      threshold: INFO
+      timeZone: UTC
+      logFormat: "%d{yyyy-MM-dd HH:mm:ss SSS} %-5p [%c][%t] - %m%n"
+    - type: file
+      threshold: INFO
+      logFormat: "%d{yyyy-MM-dd HH:mm:ss SSS} %-5p [%c][%t] - %m%n"
+      currentLogFilename: ../logs/fm-relation.log
+      archivedLogFilenamePattern: ../logs/zip/fm-relation-%d{yyyy-MM-dd}.log.gz
+      archivedFileCount: 7
+  #  - type: socketJson
+      threshold: INFO 
+  #    autoDiscover: false
+  #    logstashServiceName: logstash
+   #   logstashServiceVersion: v1
+
+#database
+database:
+  driverClass: com.mysql.jdbc.Driver
+  user: root
+  password: root
+  #url: jdbc:mysql://${db_ip}:${db_port}/mysql?useUnicode=relationtesttrue&characterEncoding=UTF8
+  url: jdbc:mysql://localhost:3306/relationtest?useUnicode=true&characterEncoding=UTF8
+  properties:
+    charSet: UTF-8
+  maxWaitForConnection: 1s
+  validationQuery: "/* MyService Health Check */ SELECT 1"
+  minSize: 8
+  maxSize: 100
+  checkConnectionWhileIdle: false
+  evictionInterval: 10s
+  minIdleTime: 1s
+  #dbServiceName: dbService
+ # dbServiceVersion: v1
+
+#mqConfig:
+#  brokerIp: 127.0.0.1
+#  brokerPort: 61616
+#  autoDiscover: false
+#  mqServiceName: activemq
+#  mqServiceVersion: v1
+#
+#cacheConfig:
+#  cacheServerIp: 10.74.156.206
+#  cacheServerPort: 27017
+#  autoDiscover: false
+#  cacheServiceName: mongodbService
+#  cacheServiceVersion: v1
+#  asNamespace: zenap
+#  type: mongodb
+#  userName: zenap
+#  password: zenap
+#
+# the micro service ip
+
+#msbClientConfig:
+ # msbSvrIp: 10.74.156.206
+ # msbSvrPort: 10081
+
+#kafkaClientConf:
+#  bootstrapServers: 10.74.151.190:9092
+#  autoDiscover: true
+#  kafkaServiceName: kafka
+#  kafkaServiceVersion: v1
+#  consumerConf:
+#    properties:
+#      value.deserializer: org.apache.kafka.common.serialization.StringDeserializer
+#  producerConf:
+#    properties:
+#      value.serializer: org.apache.kafka.common.serialization.StringSerializer
+#
+#zkConfig:
+#  connectString: 10.74.151.195:2181
+#  retryPolicy:
+#    type: boundedExponentialBackoff
+#    baseSleepTimeMs: 50
+#    maxSleepTimeMs: 500
+#    maxRetries: 3
+#  sessionTimeout: 60
+#  connectionTimeout: 15
+#    autoDiscover: true
+#  zkServiceName: zk
+#  zkServiceVersion: v1
+#
+#ftpServiceConfig:
+#  type: ftp
+#  pasv: false
+#  userName: uep
+#  userPassword: U_tywg_2008_ftp
+#  ftpServerAddress: 10.74.148.251
+#  ftpServerPort: 20021
+#  ftpsServerAddress: 10.74.148.251
+#  ftpsServerPort: 20021
+#  sftpServerAddress: 10.74.148.251
+#  sftpServerPort: 20021
+#
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)

+)

+

diff --git a/rulemgt-standalone/win64-assembly.xml b/rulemgt-standalone/win64-assembly.xml
new file mode 100644
index 0000000..daa3177
--- /dev/null
+++ b/rulemgt-standalone/win64-assembly.xml
@@ -0,0 +1,31 @@
+<!--
+
+    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.
+
+-->
+<assembly xmlns="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xsi:schemaLocation="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2 http://maven.apache.org/xsd/assembly-1.1.2.xsd">
+    <id>win64</id>
+    <formats>
+        <format>zip</format>
+    </formats>
+    <includeBaseDirectory>false</includeBaseDirectory>
+    <fileSets>
+        <fileSet>
+            <directory>target/assembly/win64</directory>
+            <outputDirectory></outputDirectory>
+        </fileSet>
+    </fileSets>
+</assembly>