huahuibao/sql.txt

shish 2019.11.25
ALTER TABLE xhAuth CHANGE front_url frontUrl VARCHAR(30) NOT NULL DEFAULT '' COMMENT '前端路由';
ALTER TABLE xhAuth CHANGE back_url backUrl VARCHAR(30) NOT NULL DEFAULT '' COMMENT '后端路由';

shish 2019.11.24
ALTER TABLE xhAdminRoleAuth ADD endId TINYINT NOT NULL DEFAULT 0 COMMENT '业务端id' AFTER roleId;
ALTER TABLE xhMerchant ADD setDeadline INT NOT NULL DEFAULT 0 COMMENT '套餐到期时间' AFTER `setId`;
ALTER TABLE xhMerchant ADD setId TINYINT NOT NULL DEFAULT 0 COMMENT '套餐id' AFTER `wxRefreshToken`;

shish 2019.11.23
DROP TABLE IF EXISTS xhAuth;
CREATE TABLE xhAuth(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
endId TINYINT NOT NULL DEFAULT 0 COMMENT '业务端，零售1',
parentId INT NOT NULL DEFAULT 0 COMMENT '权限父id',
authName VARCHAR(30) NOT NULL DEFAULT '' COMMENT '权限名称',
front_url VARCHAR(30) NOT NULL DEFAULT '' COMMENT '前端路由',
back_url VARCHAR(30) NOT NULL DEFAULT '' COMMENT '后端路由',
`addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间'
)COMMENT='各业务端的权限';
DROP TABLE IF EXISTS xhSetAuth;
CREATE TABLE xhSetAuth(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
setId TINYINT NOT NULL DEFAULT 0 COMMENT '套餐id',
endId TINYINT NOT NULL DEFAULT 0 COMMENT '业务端id',
auth VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '权限',
`addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间'
)COMMENT='套餐在各业务端的权限';
CREATE TABLE xhAdminRoleAuth(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
roleId INT NOT NULL DEFAULT 0 COMMENT '角色id',
auth VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '权限',
`addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间'
)COMMENT='员工角色权限'


shish 2019.11.23
jwt的过期时间要设置得短点

shish 2019.11.22
!!注意要将成积分移到成长值里

shish 2019.11.22
ALTER TABLE xhUserAsset ADD growth INT NOT NULL DEFAULT 0 COMMENT '成长值' AFTER `point`;