# func_boom

**Repository Path**: aismall/func_boom

## Basic Information

- **Project Name**: func_boom
- **Description**: 后端项目-boom
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-08-08
- **Last Updated**: 2026-01-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## func-boom

-- ----------------------------
-- Table structure for t_resource_module
-- ----------------------------
DROP TABLE IF EXISTS `t_resource_module`;
CREATE TABLE `t_resource_module`  (
`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`parent_id` int(20) NULL DEFAULT NULL COMMENT '父节点id',
`module_Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称',
`function_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '功能类型',
`sort` int(10) NULL DEFAULT NULL COMMENT '排序',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源模型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_resource_module
-- ----------------------------
INSERT INTO `t_resource_module` VALUES (1, 0, '系统管理', '1', 1, '2022-08-12 14:11:15', NULL);
INSERT INTO `t_resource_module` VALUES (2, 1, '用户管理', '2', 1, '2022-08-12 14:11:46', NULL);
INSERT INTO `t_resource_module` VALUES (3, 2, '用户中心', '3', 1, '2022-08-12 14:12:11', NULL);
INSERT INTO `t_resource_module` VALUES (4, 2, '权限树', '3', 2, '2022-08-12 14:12:26', NULL);
INSERT INTO `t_resource_module` VALUES (5, 1, '权限管理', '4', 2, '2022-08-12 14:12:58', NULL);
INSERT INTO `t_resource_module` VALUES (6, 5, '应用中心', '3', 1, '2022-08-12 14:13:29', NULL);
INSERT INTO `t_resource_module` VALUES (7, 0, '图片管理', '1', 1, '2022-08-12 14:13:51', NULL);
INSERT INTO `t_resource_module` VALUES (8, 7, '图片中心', '2', 1, '2022-08-12 14:14:18', NULL);

-- ----------------------------
-- Table structure for t_resource_role
-- ----------------------------
DROP TABLE IF EXISTS `t_resource_role`;
CREATE TABLE `t_resource_role`  (
`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`user_id` int(20) NULL DEFAULT NULL COMMENT '用户id',
`modules` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分配模块列表',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_resource_role
-- ----------------------------
INSERT INTO `t_resource_role` VALUES (1, 1, '1,2,3,4,5,6,7,8', '2022-08-12 14:14:37', '2022-08-12 17:11:22');

-- ----------------------------
-- Table structure for t_sys_user
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user`  (
`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`sex` int(1) NULL DEFAULT NULL COMMENT '性别',
`age` int(1) NULL DEFAULT NULL COMMENT '年龄',
`id_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
`company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',
`position` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_user 密码是admin88
-- ----------------------------
INSERT INTO `t_sys_user` VALUES (1, 'admin', '15688888888', 'RyqEzn+NPuayUlMgQJLiYg==', '123456789@qq.com', 1, 20, '300000202001010000', 'boom', 'java', '测试', '2022-08-12 13:54:44', NULL);