/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50720 Source Host : localhost:3306 Source Database : mood-wall Target Server Type : MYSQL Target Server Version : 50720 File Encoding : 65001 Date: 2018-12-04 11:25:29 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for tb_data_dictionary -- ---------------------------- DROP TABLE IF EXISTS `tb_data_dictionary`; CREATE TABLE `tb_data_dictionary` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `rec_status` varchar(2) DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `code` varchar(24) DEFAULT NULL COMMENT '数据字典code', `data_key` varchar(255) DEFAULT NULL COMMENT '数据字典key', `data_value` varchar(255) DEFAULT NULL COMMENT '数据字典value', `description` varchar(255) DEFAULT NULL COMMENT '描述', `param1` varchar(255) DEFAULT NULL COMMENT '备用，参数1', `param2` varchar(255) DEFAULT NULL COMMENT '备用，参数2', `param3` varchar(255) DEFAULT NULL COMMENT '备用，参数3', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据字典表'; -- ---------------------------- -- Records of tb_data_dictionary -- ---------------------------- -- ---------------------------- -- Table structure for tb_resource -- ---------------------------- DROP TABLE IF EXISTS `tb_resource`; CREATE TABLE `tb_resource` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `description` varchar(255) DEFAULT NULL COMMENT '资源描述', `icon` varchar(10) DEFAULT NULL COMMENT '图标', `name` varchar(50) DEFAULT NULL COMMENT '资源名称', `url` varchar(255) DEFAULT NULL COMMENT '资源地址', `parent_id` bigint(20) DEFAULT NULL COMMENT '父资源id', `resource_type` enum('menu','button') DEFAULT NULL COMMENT '资源类型', `resource_key` varchar(255) DEFAULT NULL COMMENT '资源key', `rec_status` varchar(2) DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用', `sort` tinyint(4) DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`), KEY `FKf5ra2gn0xedeida2op8097sr5` (`parent_id`), CONSTRAINT `FKf5ra2gn0xedeida2op8097sr5` FOREIGN KEY (`parent_id`) REFERENCES `tb_resource` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='资源表'; -- ---------------------------- -- Records of tb_resource -- ---------------------------- INSERT INTO `tb_resource` VALUES ('1', '2018-05-10 17:18:36', '2018-05-10 17:22:42', null, '', '系统管理', 'javascript:void(0);', null, 'menu', 'system', 'A', '1'); INSERT INTO `tb_resource` VALUES ('2', '2018-05-11 10:05:41', '2018-12-04 11:22:02', null, '', '用户管理', '/admin/user/list', '1', 'menu', 'admin:user:list', 'A', '2'); INSERT INTO `tb_resource` VALUES ('3', '2018-05-14 09:38:43', '2018-05-14 09:38:46', null, '', '用户添加', '/admin/user/add', '2', 'button', 'admin:user:add', 'A', '3'); INSERT INTO `tb_resource` VALUES ('4', '2018-05-14 10:46:32', '2018-05-14 10:46:36', null, '', '用户编辑', '/admin/user/edit', '2', 'button', 'admin:user:edit', 'A', '4'); INSERT INTO `tb_resource` VALUES ('5', '2018-05-14 12:03:20', '2018-05-14 12:03:30', null, '', '用户重置密码', '/admin/user/resetPass', '2', 'button', 'admin:user:resetPass', 'A', '5'); INSERT INTO `tb_resource` VALUES ('6', '2018-05-14 14:08:16', '2018-05-14 14:08:20', null, '', '用户删除', '/admin/user/remove', '2', 'button', 'admin:user:remove', 'A', '6'); INSERT INTO `tb_resource` VALUES ('7', '2018-05-14 14:09:07', '2018-05-14 14:09:10', null, '', '角色管理', '/admin/role/list', '1', 'menu', 'admin:role:list', 'A', '7'); INSERT INTO `tb_resource` VALUES ('8', '2018-05-14 15:06:59', '2018-05-14 15:07:01', null, '', '角色添加', '/admin/role/add', '7', 'button', 'admin:role:add', 'A', '8'); INSERT INTO `tb_resource` VALUES ('9', '2018-05-14 15:06:59', '2018-05-14 15:07:01', null, '', '角色编辑', '/admin/role/edit', '7', 'button', 'admin:role:edit', 'A', '9'); INSERT INTO `tb_resource` VALUES ('10', '2018-05-14 15:08:06', '2018-05-14 15:08:08', null, '', '角色删除', '/admin/role/remove', '7', 'button', 'admin:role:remove', 'A', '10'); INSERT INTO `tb_resource` VALUES ('11', '2018-05-14 15:08:06', '2018-05-14 15:08:08', null, '', '资源管理', '/admin/resource/list', '1', 'menu', 'admin:resource:list', 'A', '11'); INSERT INTO `tb_resource` VALUES ('12', '2018-05-15 09:51:49', '2018-05-15 09:51:51', null, '', '资源添加', '/admin/resource/add', '11', 'button', 'admin:resource:add', 'A', '12'); INSERT INTO `tb_resource` VALUES ('13', '2018-05-15 09:51:49', '2018-05-15 09:51:51', null, '', '资源编辑', '/admin/resource/edit', '11', 'button', 'admin:resource:edit', 'A', '13'); INSERT INTO `tb_resource` VALUES ('14', '2018-05-15 09:51:49', '2018-12-04 11:20:29', null, '', '资源删除', '/admin/resource/remove', '11', 'button', 'admin:resource:remove', 'A', '14'); INSERT INTO `tb_resource` VALUES ('15', '2018-07-27 16:30:51', '2018-07-27 16:30:51', null, '', '数据字典管理', '/admin/dataDictionary/list', '1', 'menu', 'admin:dataDictionary:list', 'A', '40'); INSERT INTO `tb_resource` VALUES ('16', '2018-07-27 16:31:57', '2018-07-27 16:31:57', null, '', '数据字典添加', '/admin/dataDictionary/add', '15', 'button', 'admin:dataDictionary:add', 'A', '41'); INSERT INTO `tb_resource` VALUES ('17', '2018-07-27 16:35:59', '2018-07-27 16:35:59', null, '', '数据字典编辑', '/admin/dataDictionary/edit', '15', 'button', 'admin:dataDictionary:edit', 'A', '42'); INSERT INTO `tb_resource` VALUES ('18', '2018-07-27 16:36:56', '2018-07-27 16:36:56', null, '', '数据字典删除', '/admin/dataDictionary/remove', '15', 'button', 'admin:dataDictionary:remove', 'A', '43'); -- ---------------------------- -- Table structure for tb_role -- ---------------------------- DROP TABLE IF EXISTS `tb_role`; CREATE TABLE `tb_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `role_desc` varchar(255) DEFAULT NULL COMMENT '角色描述', `role_name` varchar(50) DEFAULT NULL COMMENT '角色名', `role_key` varchar(255) DEFAULT NULL COMMENT '角色key', `rec_status` varchar(2) DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色表'; -- ---------------------------- -- Records of tb_role -- ---------------------------- INSERT INTO `tb_role` VALUES ('1', '2018-05-11 10:02:27', '2018-12-04 10:50:43', '超级管理员', '超级管理员', 'administrator', 'A'); -- ---------------------------- -- Table structure for tb_role_resource -- ---------------------------- DROP TABLE IF EXISTS `tb_role_resource`; CREATE TABLE `tb_role_resource` ( `role_id` bigint(20) NOT NULL COMMENT '角色表id', `resource_id` bigint(20) NOT NULL COMMENT '资源表id', PRIMARY KEY (`role_id`,`resource_id`), KEY `FK868kc8iic48ilv5npa80ut6qo` (`resource_id`), CONSTRAINT `FK7ffc7h6obqxflhj1aq1mk20jk` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`id`), CONSTRAINT `FK868kc8iic48ilv5npa80ut6qo` FOREIGN KEY (`resource_id`) REFERENCES `tb_resource` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色资源关系表'; -- ---------------------------- -- Records of tb_role_resource -- ---------------------------- INSERT INTO `tb_role_resource` VALUES ('1', '1'); INSERT INTO `tb_role_resource` VALUES ('1', '2'); INSERT INTO `tb_role_resource` VALUES ('1', '3'); INSERT INTO `tb_role_resource` VALUES ('1', '4'); INSERT INTO `tb_role_resource` VALUES ('1', '5'); INSERT INTO `tb_role_resource` VALUES ('1', '6'); INSERT INTO `tb_role_resource` VALUES ('1', '7'); INSERT INTO `tb_role_resource` VALUES ('1', '8'); INSERT INTO `tb_role_resource` VALUES ('1', '9'); INSERT INTO `tb_role_resource` VALUES ('1', '10'); INSERT INTO `tb_role_resource` VALUES ('1', '11'); INSERT INTO `tb_role_resource` VALUES ('1', '12'); INSERT INTO `tb_role_resource` VALUES ('1', '13'); INSERT INTO `tb_role_resource` VALUES ('1', '14'); INSERT INTO `tb_role_resource` VALUES ('1', '15'); INSERT INTO `tb_role_resource` VALUES ('1', '16'); INSERT INTO `tb_role_resource` VALUES ('1', '17'); INSERT INTO `tb_role_resource` VALUES ('1', '18'); -- ---------------------------- -- Table structure for tb_user -- ---------------------------- DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `rec_status` varchar(2) DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `password` varchar(100) DEFAULT NULL COMMENT '登录密码', `real_name` varchar(50) DEFAULT NULL COMMENT '真实姓名', `user_name` varchar(50) DEFAULT NULL COMMENT '用户名', `avatar` varchar(255) DEFAULT NULL COMMENT '头像地址', `status` tinyint(4) DEFAULT NULL COMMENT '状态，0：激活，1：禁用', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表'; -- ---------------------------- -- Records of tb_user -- ---------------------------- INSERT INTO `tb_user` VALUES ('1', '2018-05-10 15:12:42', 'A', '2018-12-04 10:58:51', '8ca1e641c2bc5040', '超级管理员', 'admin', '/img/avater.jpg', '0'); -- ---------------------------- -- Table structure for tb_user_role -- ---------------------------- DROP TABLE IF EXISTS `tb_user_role`; CREATE TABLE `tb_user_role` ( `user_id` bigint(20) NOT NULL COMMENT '用户表id', `role_id` bigint(20) NOT NULL COMMENT '角色表id', PRIMARY KEY (`user_id`,`role_id`), KEY `FKea2ootw6b6bb0xt3ptl28bymv` (`role_id`), CONSTRAINT `FK7vn3h53d0tqdimm8cp45gc0kl` FOREIGN KEY (`user_id`) REFERENCES `tb_user` (`id`), CONSTRAINT `FKea2ootw6b6bb0xt3ptl28bymv` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色关系表'; -- ---------------------------- -- Records of tb_user_role -- ---------------------------- INSERT INTO `tb_user_role` VALUES ('1', '1');