[hadoop-submarine] branch master updated: SUBMARINE-234. Add submarine-data.sql to the doc for database.

[zh...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

zhouquan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hadoop-submarine.git


The following commit(s) were added to refs/heads/master by this push:
     new aa669fd  SUBMARINE-234. Add submarine-data.sql to the doc for database.
aa669fd is described below

commit aa669fd3deef0222d366b187724e553cf4fa40fa
Author: Zac Zhou <zh...@apache.org>
AuthorDate: Sat Oct 12 12:46:17 2019 +0800

    SUBMARINE-234. Add submarine-data.sql to the doc for database.
    
    ### What is this PR for?
    To setup a workbench development environment, the file of submarine-data.sql needs to be executed. But the document doesn't mention it.
    
    ### What type of PR is it?
    Documentation
    
    ### What is the Jira issue?
    https://issues.apache.org/jira/browse/SUBMARINE-234
    
    ### How should this be tested?
    https://travis-ci.org/yuanzac/hadoop-submarine/builds/596887093
    
    ### Screenshots (if appropriate)
    
    ### Questions:
    * Does the licenses files need update? No
    * Is there breaking changes for older versions? No
    * Does this needs documentation? Yes
    
    Author: Zac Zhou <zh...@apache.org>
    
    Closes #43 from yuanzac/topic/SUBMARINE-234 and squashes the following commits:
    
    2df1ad3 [Zac Zhou] SUBMARINE-234. Add submarine-data.sql to the doc for database.
---
 docs/database/README.md | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

diff --git a/docs/database/README.md b/docs/database/README.md
index 68fc592..0c95562 100644
--- a/docs/database/README.md
+++ b/docs/database/README.md
@@ -79,6 +79,12 @@ If you need to store Chinese character data in mysql, you need to execute the fo
 ## Create Submarine Database
 
 ### Create development database
+Copy the files, submarine.sql and submarine-data.sql to the mysql docker.
+
+```
+docker cp ${SUBMARINE_HOME}/docs/database/submarine.sql ${DOCKER_ID}:/
+docker cp ${SUBMARINE_HOME}/docs/database/submarine-data.sql ${DOCKER_ID}:/
+```
 
 Development database for development environment.
 
@@ -89,7 +95,8 @@ mysql> CREATE USER 'submarine'@'%' IDENTIFIED BY 'password';
 mysql> GRANT ALL PRIVILEGES ON * . * TO 'submarine'@'%';
 mysql> CREATE DATABASE submarineDB CHARACTER SET utf8 COLLATE utf8_general_ci;
 mysql> use submarineDB;
-mysql> source ./docs/database/submarine.sql;
+mysql> source /submarine.sql;
+mysql> source /submarine-data.sql;
 mysql> quit
 ```
 
@@ -107,7 +114,7 @@ mysql> CREATE USER 'submarine_test'@'%' IDENTIFIED BY 'password_test';
 mysql> GRANT ALL PRIVILEGES ON * . * TO 'submarine_test'@'%';
 mysql> CREATE DATABASE `submarineDB_test` CHARACTER SET utf8 COLLATE utf8_general_ci;
 mysql> use `submarineDB_test`;
-mysql> source ./docs/database/submarine.sql;
+mysql> source /submarine.sql;
 mysql> quit
 ```