/*
Navicat MySQL Data Transfer

The Source Server: local library
The Source Server Version: 80012
The Source Host: localhost: 3306
The Source Database: shiro

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

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

The SET FOREIGN_KEY_CHECKS=0;

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- Table structure for house
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
DROP TABLE IF the EXISTS ` house `;
The CREATE TABLE ` house ` (
NOT NULL AUTO_INCREMENT ` id ` int (8),
` no ` varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'number',
` name ` varchar (225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'village name,
` houseid ` varchar (36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'building date,
` danyuanno ` varchar (64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'units',
` houseno ` varchar (64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'number',
` owner ` varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'owners',
` type ` varchar (64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'state',
` createtime ` datetime DEFAULT NULL COMMENT 'time',
The PRIMARY KEY (` id `)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='housing information;

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- Records of house
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
INSERT INTO ` house ` VALUES (' 2 ', '123456', 'the wahaha is',' 4545 ', '554', '545', 'Wang Zi INTO', 'full', '2018-10-02 21:51:05');
INSERT INTO ` house ` VALUES (' 3 ', '201812', 'lele kindergartens',' 16 ', '5', '502', 'claim to be the king', 'full', '2018-10-03 23:11:21');
INSERT INTO ` house ` VALUES (' 4 ', '55', '544', '454', '555', '545', '5454', 'full', '2018-10-03 23:18:51');
INSERT INTO ` house ` VALUES (' 5 ', '55', '544', '454', '555', '545', '5454', 'full', '2018-10-03 23:18:53');
INSERT INTO ` house ` VALUES (' 6 ', '55', '544', '454', '555', '545', '5454', 'full', '2018-10-03 23:18:54');
INSERT INTO ` house ` VALUES (' 7 ', '4554566', 'nothing', '4', '4', '4', '5', 'full', '2018-10-04 10:14:37');
INSERT INTO ` house ` VALUES (' 8 ', '545', 'LKL', '54545', '5454', '45', '454', 'full', '2018-10-04 10:17:04');
INSERT INTO ` house ` VALUES (' 9 ', '4545', '454', '454', '45212', '211', '963', 'full', '2018-10-04 10:48:44');

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- Table structure for life
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
DROP TABLE IF the EXISTS ` life `;
The CREATE TABLE ` life ` (
` id ` int (11), NOT NULL AUTO_INCREMENT,
` no ` varchar (255) the DEFAULT NULL COMMENT 'number',
` property_fee ` float (64, 0) DEFAULT NULL COMMENT 'property costs,
` electric_fee ` float (64, 0) DEFAULT NULL COMMENT 'electricity'
` water_fee ` float (64, 0) DEFAULT NULL COMMENT 'water',
` owner ` varchar (84) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'owners',
` create_time ` datetime DEFAULT NULL COMMENT 'creation time,
` update_time ` datetime DEFAULT NULL COMMENT 'update time,
The 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 the EXISTS ` resources `;
The CREATE TABLE ` resources ` (
` id ` int (11), NOT NULL AUTO_INCREMENT,
` name ` varchar (255) the DEFAULT NULL COMMENT 'resource name,
` resUrl ` varchar (255) the DEFAULT NULL COMMENT 'resource url,
` type ` int (11) the DEFAULT NULL COMMENT 'menu resource type 1:2: button,
` parentId ` int (11) the DEFAULT NULL COMMENT 'parent resources',
` sort ` int (11) the DEFAULT NULL COMMENT 'sorting,
The PRIMARY KEY (` id `)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- Records of resources
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
INSERT INTO ` resources ` VALUES (' 1 ', 'system Settings','/system ', '0', '0', '1');
INSERT INTO ` resources ` VALUES (' 2 ', 'user management', '/usersPage', '1', '1', '2');
INSERT INTO ` resources ` VALUES (' 3 ', 'role management', '/rolesPage', '1', '1', '3');
INSERT INTO ` resources ` VALUES (' 4 ', 'resource management', '/resourcesPage', '1', '1', '4');
INSERT INTO ` resources ` VALUES (' 5 ', 'add user', '/users/add', '2', '2', '5');
INSERT INTO ` resources ` VALUES (' 6 ', 'delete users','/users/delete ', '2', '2', '6');
INSERT INTO ` resources ` VALUES (' 7 ', 'adding roles','/roles/add ', '2', '3', '7');
INSERT INTO ` resources ` VALUES (' 8 ', 'delete characters','/roles/delete ', '2', '3', '8');
INSERT INTO ` resources ` VALUES (' 9 ', 'added resources','/resources/add ', '2', '4', '9');
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull