数据库

[qq_36848034]

/*
Navicat MySQL Data Transfer

Source Server : 本地库
Source Server Version : 80012
Source Host : localhost:3306
Source Database : shiro

Target Server Type : MYSQL
Target Server Version : 80012
File Encoding : 65001

Date: 2018-10-04 11:58:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编号',
`name` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '小区名称',
`houseid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '楼号',
`danyuanno` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单元',
`houseno` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '房屋编号',
`owner` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业主',
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态',
`createtime` datetime DEFAULT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='房源信息';

-- ----------------------------
-- Records of house
-- ----------------------------
INSERT INTO `house` VALUES ('2', '123456', '娃哈哈就', '4545', '554', '545', '王梓成', '客满', '2018-10-02 21:51:05');
INSERT INTO `house` VALUES ('3', '201812', '乐乐幼儿园', '16', '5', '502', '自称王', '客满', '2018-10-03 23:11:21');
INSERT INTO `house` VALUES ('4', '55', '544', '454', '555', '545', '5454', '客满', '2018-10-03 23:18:51');
INSERT INTO `house` VALUES ('5', '55', '544', '454', '555', '545', '5454', '客满', '2018-10-03 23:18:53');
INSERT INTO `house` VALUES ('6', '55', '544', '454', '555', '545', '5454', '客满', '2018-10-03 23:18:54');
INSERT INTO `house` VALUES ('7', '4554566', '四大皆空', '4', '4', '4', '5', '客满', '2018-10-04 10:14:37');
INSERT INTO `house` VALUES ('8', '545', 'lkl', '54545', '5454', '45', '454', '客满', '2018-10-04 10:17:04');
INSERT INTO `house` VALUES ('9', '4545', '454', '454', '45212', '211', '963', '客满', '2018-10-04 10:48:44');

-- ----------------------------
-- Table structure for life
-- ----------------------------
DROP TABLE IF EXISTS `life`;
CREATE TABLE `life` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`no` varchar(255) DEFAULT NULL COMMENT '房屋编号',
`property_fee` float(64,0) DEFAULT NULL COMMENT '物业费',
`electric_fee` float(64,0) DEFAULT NULL COMMENT '电费',
`water_fee` float(64,0) DEFAULT NULL COMMENT '水费',
`owner` varchar(84) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业主',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of life
-- ----------------------------
INSERT INTO `life` VALUES ('1', '5454', '30', '40', '50', 'kmk', '2018-10-04 10:15:12', '2018-10-04 10:15:15');
INSERT INTO `life` VALUES ('2', '4545', '30', '0', '0', '963', '2018-10-04 10:48:44', '2018-10-04 10:48:44');

-- ----------------------------
-- Table structure for resources
-- ----------------------------
DROP TABLE IF EXISTS `resources`;
CREATE TABLE `resources` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '资源名称',
`resUrl` varchar(255) DEFAULT NULL COMMENT '资源url',
`type` int(11) DEFAULT NULL COMMENT '资源类型 1:菜单 2：按钮',
`parentId` int(11) DEFAULT NULL COMMENT '父资源',
`sort` int(11) DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of resources
-- ----------------------------
INSERT INTO `resources` VALUES ('1', '系统设置', '/system', '0', '0', '1');
INSERT INTO `resources` VALUES ('2', '用户管理', '/usersPage', '1', '1', '2');
INSERT INTO `resources` VALUES ('3', '角色管理', '/rolesPage', '1', '1', '3');
INSERT INTO `resources` VALUES ('4', '资源管理', '/resourcesPage', '1', '1', '4');
INSERT INTO `resources` VALUES ('5', '添加用户', '/users/add', '2', '2', '5');
INSERT INTO `resources` VALUES ('6', '删除用户', '/users/delete', '2', '2', '6');
INSERT INTO `resources` VALUES ('7', '添加角色', '/roles/add', '2', '3', '7');
INSERT INTO `resources` VALUES ('8', '删除角色', '/roles/delete', '2', '3', '8');
INSERT INTO `resources` VALUES ('9', '添加资源', '/resources/add', '2', '4', '9');
INSERT INTO `resources` VALUES ('10', '删除资源', '/resources/delete', '2', '4', '10');
INSERT INTO `resources` VALUES ('11', '分配角色', '/users/saveUserRoles', '2', '2', '11');
INSERT INTO `resources` VALUES ('13', '分配权限', '/roles/saveRoleResources', '2', '3', '12');
INSERT INTO `resources` VALUES ('14', '房屋管理', '/housePage', '1', '5', '13');
INSERT INTO `resources` VALUES ('15', '添加房屋', '/house/addHouse', '2', '5', '14');
INSERT INTO `resources` VALUES ('16', '删除房源', '/house/deleteHouse', '2', '5', '15');
INSERT INTO `resources` VALUES ('17', '生活管理', '/lifePage', '1', '6', '16');
INSERT INTO `resources` VALUES ('18', '生活缴费', '/life/updateLife', '2', '6', '17');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`roleDesc` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '管理员');
INSERT INTO `role` VALUES ('2', '普通用户');
INSERT INTO `role` VALUES ('3', '超级管理员');

-- ----------------------------
-- Table structure for role_resources
-- ----------------------------
DROP TABLE IF EXISTS `role_resources`;
CREATE TABLE `role_resources` (
`roleId` int(11) NOT NULL,
`resourcesId` int(11) NOT NULL,
PRIMARY KEY (`roleId`,`resourcesId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_resources
-- ----------------------------
INSERT INTO `role_resources` VALUES ('1', '2');
INSERT INTO `role_resources` VALUES ('1', '3');
INSERT INTO `role_resources` VALUES ('1', '4');
INSERT INTO `role_resources` VALUES ('1', '5');
INSERT INTO `role_resources` VALUES ('1', '6');
INSERT INTO `role_resources` VALUES ('1', '7');
INSERT INTO `role_resources` VALUES ('1', '8');
INSERT INTO `role_resources` VALUES ('1', '9');
INSERT INTO `role_resources` VALUES ('1', '10');
INSERT INTO `role_resources` VALUES ('1', '11');
INSERT INTO `role_resources` VALUES ('1', '13');
INSERT INTO `role_resources` VALUES ('1', '14');
INSERT INTO `role_resources` VALUES ('1', '15');
INSERT INTO `role_resources` VALUES ('1', '16');
INSERT INTO `role_resources` VALUES ('2', '2');
INSERT INTO `role_resources` VALUES ('2', '3');
INSERT INTO `role_resources` VALUES ('2', '4');
INSERT INTO `role_resources` VALUES ('2', '9');
INSERT INTO `role_resources` VALUES ('3', '2');
INSERT INTO `role_resources` VALUES ('3', '3');
INSERT INTO `role_resources` VALUES ('3', '4');
INSERT INTO `role_resources` VALUES ('3', '5');
INSERT INTO `role_resources` VALUES ('3', '6');
INSERT INTO `role_resources` VALUES ('3', '7');
INSERT INTO `role_resources` VALUES ('3', '8');
INSERT INTO `role_resources` VALUES ('3', '9');
INSERT INTO `role_resources` VALUES ('3', '10');
INSERT INTO `role_resources` VALUES ('3', '11');
INSERT INTO `role_resources` VALUES ('3', '13');
INSERT INTO `role_resources` VALUES ('3', '14');
INSERT INTO `role_resources` VALUES ('3', '15');
INSERT INTO `role_resources` VALUES ('3', '16');
INSERT INTO `role_resources` VALUES ('3', '17');
INSERT INTO `role_resources` VALUES ('3', '18');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(33) DEFAULT NULL,
`password` varchar(33) DEFAULT NULL,
`enable` int(10) DEFAULT '1' COMMENT '是否启用',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', '3ef7164d1f6167cb9f2658c07d3c2f0a', '1');
INSERT INTO `user` VALUES ('2', 'user1', '90e66e36e3135a91d298177d4389851e', '1');
INSERT INTO `user` VALUES ('3', 'user2', '121', '0');
INSERT INTO `user` VALUES ('4', 'user3', 'user3', '1');
INSERT INTO `user` VALUES ('5', 'user4', 'user4', '1');
INSERT INTO `user` VALUES ('6', 'user5', 'user5', '1');
INSERT INTO `user` VALUES ('7', 'user6', 'user6', '1');
INSERT INTO `user` VALUES ('8', 'user7', 'user7', '1');
INSERT INTO `user` VALUES ('9', 'user8', 'user8', '1');
INSERT INTO `user` VALUES ('10', 'user9', 'user9', '1');
INSERT INTO `user` VALUES ('11', 'user10', 'user10', '1');
INSERT INTO `user` VALUES ('12', 'user11', 'user11', '1');
INSERT INTO `user` VALUES ('13', 'user12', 'user12', '1');
INSERT INTO `user` VALUES ('14', 'user13', 'user13', '1');
INSERT INTO `user` VALUES ('15', 'user14', 'user14', '1');
INSERT INTO `user` VALUES ('16', 'user15', 'user15', '1');
INSERT INTO `user` VALUES ('17', 'user16', 'user16', '1');
INSERT INTO `user` VALUES ('18', 'user17', 'user17', '1');
INSERT INTO `user` VALUES ('19', 'user18', 'user18', '1');
INSERT INTO `user` VALUES ('21', 'user20', 'user20', '1');

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`userId` int(11) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES ('23', '2');
INSERT INTO `user_role` VALUES ('2', '2');
INSERT INTO `user_role` VALUES ('1', '3');

-- ----------------------------
-- Procedure structure for init_shiro_demo
-- --------------------------

[卖水果的net]

楼仅仅是记录一下? 还是遇到什么问题了？

[Rotel-刘志东]

不说明情况，无语了。