57 lines
4.1 KiB
Markdown
57 lines
4.1 KiB
Markdown
#### Redis
|
||
81.70.191.16:56379
|
||
密码：Rd@5Wk8#Nv3Yt6$Bm
|
||
数据库：1
|
||
|
||
帮我增加Redis的使用。
|
||
|
||
```sql
|
||
-- yitisheng.sys_user definition
|
||
|
||
CREATE TABLE `sys_user` (
|
||
`id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '主键id',
|
||
`username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '登录账号',
|
||
`realname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '真实姓名',
|
||
`password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '密码',
|
||
`salt` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'md5密码盐',
|
||
`avatar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '头像',
|
||
`birthday` datetime DEFAULT NULL COMMENT '生日',
|
||
`sex` tinyint(1) DEFAULT NULL COMMENT '性别(0-默认未知,1-男,2-女)',
|
||
`email` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '电子邮件',
|
||
`phone` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '电话',
|
||
`org_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '登录会话的机构编码',
|
||
`status` tinyint(1) DEFAULT NULL COMMENT '性别(1-正常,2-冻结)',
|
||
`del_flag` tinyint(1) DEFAULT NULL COMMENT '删除状态(0-正常,1-已删除)',
|
||
`third_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '第三方登录的唯一标识',
|
||
`third_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '第三方类型',
|
||
`activiti_sync` tinyint(1) DEFAULT NULL COMMENT '同步工作流引擎(1-同步,0-不同步)',
|
||
`work_no` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '工号，唯一键',
|
||
`telephone` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '座机号',
|
||
`create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`user_identity` tinyint(1) DEFAULT NULL COMMENT '身份（1普通成员 2上级）',
|
||
`depart_ids` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '负责部门',
|
||
`client_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '设备ID',
|
||
`login_tenant_id` int DEFAULT NULL COMMENT '上次登录选择租户ID',
|
||
`bpm_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '流程入职离职状态',
|
||
`wx_open_id` varchar(50) DEFAULT NULL COMMENT '微信openId',
|
||
`dy_open_id` varchar(50) DEFAULT NULL COMMENT '抖音openId',
|
||
`ip` varchar(255) DEFAULT NULL COMMENT '注册时ip地址',
|
||
`show_linediff` varchar(2) DEFAULT '0' COMMENT '是否显示历年线差',
|
||
`program_type` varchar(32) DEFAULT NULL COMMENT '所属程序',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `uniq_sys_user_work_no` (`work_no`) USING BTREE,
|
||
UNIQUE KEY `uniq_sys_user_username` (`username`) USING BTREE,
|
||
UNIQUE KEY `uniq_sys_user_email` (`email`) USING BTREE,
|
||
KEY `idx_su_status` (`status`) USING BTREE,
|
||
KEY `idx_su_del_flag` (`del_flag`) USING BTREE,
|
||
KEY `idx_su_del_username` (`username`,`del_flag`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='用户表';
|
||
```
|
||
|
||
增加modules/ 包，将目前calculation_major、history_major_enroll、school_major的相关代码及文件名均增加数据库表前缀(yx_这种)，然后将yx_模块代码移动到modules/yx/模块下。
|
||
|
||
增加sys_user表的常规代码至modules/system/。以及封装用户登录和信息的代码，将用户的登录状态储存至Redis中，同时代码中接口需要登录鉴权后才可以访问（个别可使用类似Java的shiroFilterFactoryBean过滤必须登录鉴权才可访问），在接口代码中可以获取当前用户的登录信息。
|