springboot+beetl+beetlsql

/* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50546 Source Host : localhost:3306 Source Database : beetl_demo Target Server Type : MYSQL Target Server Version : 50546 File Encoding : 65001 Date: 2018-02-07 15:39:09 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for permission -- ---------------------------- DROP TABLE IF EXISTS `permission`; CREATE TABLE `permission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `permission_name` varchar(255) DEFAULT NULL COMMENT '权限名称', `url` varchar(255) DEFAULT NULL COMMENT '资源路径', `permission` varchar(255) DEFAULT NULL COMMENT '权限字符串', `parentId` int(11) DEFAULT NULL COMMENT '父编号', `resourceType` varchar(255) DEFAULT NULL COMMENT '资源类型', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of permission -- ---------------------------- -- ---------------------------- -- Table structure for role -- ---------------------------- DROP TABLE IF EXISTS `role`; CREATE TABLE `role` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role_name` varchar(50) DEFAULT NULL COMMENT '角色名称', `role_desc` varchar(255) DEFAULT NULL COMMENT '角色描述', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of role -- ---------------------------- INSERT INTO `role` VALUES ('1', '管理员', '管理员描述001'); INSERT INTO `role` VALUES ('2', '普通用户', '普通用户'); INSERT INTO `role` VALUES ('8', 'Vip', 'Vip专用'); INSERT INTO `role` VALUES ('10', '角色1', '描述11'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `age` int(4) DEFAULT NULL, `userName` varchar(64) DEFAULT NULL COMMENT '用户名称', `roleId` int(11) DEFAULT NULL COMMENT '用户角色', `create_date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('1', 'xwf', '1', '徐文飞', '10', '2018-02-06 11:34:34'); INSERT INTO `user` VALUES ('2', '姓名', '1', '用户名', '2', '2018-02-07 09:09:26'); INSERT INTO `user` VALUES ('6', '徐文飞22', '1133', '徐文飞22', '6', '2018-02-07 09:11:13'); INSERT INTO `user` VALUES ('11', '张立杰', '33', '张立杰001', '7', '2018-02-07 11:24:07'); INSERT INTO `user` VALUES ('13', '张立杰', '23', '123', '8', '2018-02-07 14:00:18');