This is an automated email from the ASF dual-hosted git repository. liubao pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/servicecomb-samples.git
commit 1bdcbdeb841c83ee6c0694511ab8738301447954 Author: liubao <[email protected]> AuthorDate: Fri Mar 8 16:15:25 2019 +0800 spell --- porter_lightweight/user-service/.gitignore | 1 - .../samples/porter/user/service/UserServiceImpl.java | 2 +- .../src/main/resources/config/create_db_user.sql | 20 ++++++++++---------- 3 files changed, 11 insertions(+), 12 deletions(-) diff --git a/porter_lightweight/user-service/.gitignore b/porter_lightweight/user-service/.gitignore deleted file mode 100644 index b83d222..0000000 --- a/porter_lightweight/user-service/.gitignore +++ /dev/null @@ -1 +0,0 @@ -/target/ diff --git a/porter_lightweight/user-service/src/main/java/org/apache/servicecomb/samples/porter/user/service/UserServiceImpl.java b/porter_lightweight/user-service/src/main/java/org/apache/servicecomb/samples/porter/user/service/UserServiceImpl.java index 2d49b46..5f69582 100644 --- a/porter_lightweight/user-service/src/main/java/org/apache/servicecomb/samples/porter/user/service/UserServiceImpl.java +++ b/porter_lightweight/user-service/src/main/java/org/apache/servicecomb/samples/porter/user/service/UserServiceImpl.java @@ -83,7 +83,7 @@ public class UserServiceImpl implements UserService { } private boolean validatePassword(String plain, String encrypt) { - // 简单加密校验，开发者可以结合业务场景自行修改 + // simple password encryption, please change it in product environment if necessary. e.g. add salts for each encryption. try { MessageDigest messageDigest = MessageDigest.getInstance("SHA-256"); messageDigest.update(plain.getBytes("UTF-8")); diff --git a/porter_lightweight/user-service/src/main/resources/config/create_db_user.sql b/porter_lightweight/user-service/src/main/resources/config/create_db_user.sql index 3505f3d..a07c5d9 100644 --- a/porter_lightweight/user-service/src/main/resources/config/create_db_user.sql +++ b/porter_lightweight/user-service/src/main/resources/config/create_db_user.sql @@ -22,10 +22,10 @@ USE porter_user_db; DROP TABLE IF EXISTS T_USER; CREATE TABLE `T_USER` ( - `ID` INTEGER(8) NOT NULL AUTO_INCREMENT COMMENT '用户ID', - `USER_NAME` VARCHAR(64) NOT NULL COMMENT '用户名称', - `PASSWORD` VARCHAR(64) NOT NULL COMMENT '用户密码', - `ROLE_NAME` VARCHAR(64) NOT NULL COMMENT '角色名称', + `ID` INTEGER(8) NOT NULL AUTO_INCREMENT COMMENT 'user id', + `USER_NAME` VARCHAR(64) NOT NULL COMMENT 'user name', + `PASSWORD` VARCHAR(64) NOT NULL COMMENT 'user password', + `ROLE_NAME` VARCHAR(64) NOT NULL COMMENT 'user role', PRIMARY KEY (`ID`) ); @@ -36,11 +36,11 @@ insert into T_USER(USER_NAME, PASSWORD, ROLE_NAME) values("guest", "n4bQgYhMfWWa DROP TABLE IF EXISTS T_SESSION; CREATE TABLE `T_SESSION` ( - `ID` INTEGER(8) NOT NULL AUTO_INCREMENT COMMENT '唯一标识', - `SESSION_ID` VARCHAR(64) NOT NULL COMMENT '临时会话ID', - `USER_NAME` VARCHAR(64) NOT NULL COMMENT '用户名称', - `ROLE_NAME` VARCHAR(64) NOT NULL COMMENT '角色名称', - `CREATION_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', - `ACTIVE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最近活跃时间', + `ID` INTEGER(8) NOT NULL AUTO_INCREMENT COMMENT 'id', + `SESSION_ID` VARCHAR(64) NOT NULL COMMENT 'session id', + `USER_NAME` VARCHAR(64) NOT NULL COMMENT 'user name', + `ROLE_NAME` VARCHAR(64) NOT NULL COMMENT 'user role', + `CREATION_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'creation time', + `ACTIVE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'last active time', PRIMARY KEY (`ID`) );
