summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorshentao <shentao@chinamobile.com>2017-11-15 19:21:15 +0800
committershentao <shentao@chinamobile.com>2017-11-15 19:21:22 +0800
commit919401afdaa375b8f3006186224c987841427123 (patch)
tree8b252ce24815e0576522f3e25b218555eb7c5816
parentd1274a88d001119c155a8dd4ed47c018553da9f0 (diff)
Change database name for usecase-ui server
Change-Id: I3ff33b6364c2cf8eade1e6f7439dd176556e20f3 Issue-Id: USECASEUI-54 Signed-off-by: shentao <shentao@chinamobile.com>
-rw-r--r--server/src/main/resources/application.properties2
-rw-r--r--standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql12
-rw-r--r--standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql2
3 files changed, 8 insertions, 8 deletions
diff --git a/server/src/main/resources/application.properties b/server/src/main/resources/application.properties
index 3ffb4da7..c3470659 100644
--- a/server/src/main/resources/application.properties
+++ b/server/src/main/resources/application.properties
@@ -22,7 +22,7 @@ spring.http.multipart.max-request-size=128MB
## App DB Properties
spring.datasource.url=jdbc:mysql://localhost:3306/uui
spring.datasource.username=root
-spring.datasource.password=
+spring.datasource.password=root
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect
spring.database.driver.classname=com.mysql.jdbc.Driver
spring.jpa.show-sql=false
diff --git a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql
index 31ab5b5e..004a717a 100644
--- a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql
+++ b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql
@@ -16,16 +16,16 @@
/******************drop old database and user***************************/
use mysql;
-drop database IF EXISTS usercaseui;
+drop database IF EXISTS uui;
delete from user where User='usecaseui';
FLUSH PRIVILEGES;
/******************create new database and user***************************/
-create database usercaseui CHARACTER SET utf8;
+create database uui CHARACTER SET utf8;
-GRANT ALL PRIVILEGES ON usercaseui.* TO 'usercaseui'@'%' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON mysql.* TO 'usercaseui'@'%' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON uui.* TO 'uui'@'%' IDENTIFIED BY 'uui' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'uui'@'%' IDENTIFIED BY 'uui' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON usercaseui.* TO 'usercaseui'@'localhost' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON mysql.* TO 'usercaseui'@'localhost' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON uui.* TO 'uui'@'localhost' IDENTIFIED BY 'uui' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'uui'@'localhost' IDENTIFIED BY 'uui' WITH GRANT OPTION;
FLUSH PRIVILEGES; \ No newline at end of file
diff --git a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql
index fc1e08a3..1acf5833 100644
--- a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql
+++ b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql
@@ -14,7 +14,7 @@
-- limitations under the License.
--
-use usercaseui;
+use uui;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------