java权限表结构_代码片段： springboot2.0-权限相关表结构.sql

-- ----------------------------

-- Table structure for sys_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_permission`;

CREATE TABLE `sys_permission` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`url` varchar(255) DEFAULT NULL,

`name` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sys_permission

-- ----------------------------

INSERT INTO `sys_permission` VALUES ('1', '/sys/user/list', '用户列表');

INSERT INTO `sys_permission` VALUES ('2', '/sys/user/add', '用户追加');

-- ----------------------------

-- Table structure for sys_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sys_role

-- ----------------------------

INSERT INTO `sys_role` VALUES ('1', '超级管理员');

INSERT INTO `sys_role` VALUES ('2', '管理员');

-- ----------------------------

-- Table structure for sys_role_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_role_permission`;

CREATE TABLE `sys_role_permission` (

`rid` int(11) NOT NULL,

`pid` int(11) NOT NULL,

PRIMARY KEY (`rid`,`pid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sys_role_permission

-- ----------------------------

INSERT INTO `sys_role_permission` VALUES ('1', '1');

INSERT INTO `sys_role_permission` VALUES ('1', '2');

INSERT INTO `sys_role_permission` VALUES ('2', '1');

-- ----------------------------

-- Table structure for sys_user

-- ----------------------------

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user` (

`id` varchar(20) NOT NULL,

`login_name` varchar(20) DEFAULT NULL,

`password` varchar(50) DEFAULT NULL,

`name` varchar(30) DEFAULT NULL,

`phone` varchar(20) DEFAULT NULL,

`photo` varchar(255) DEFAULT NULL,

`sex` tinyint(1) DEFAULT NULL,

`status` tinyint(1) DEFAULT NULL,

`last_login_time` datetime DEFAULT NULL,

`last_ip_path` varchar(20) DEFAULT NULL,

`create_time` datetime DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sys_user

-- ----------------------------

INSERT INTO `sys_user` VALUES ('nSY2fmkiX1', 'admin', '0beaaac0103fe04443eea552880f21a8', '超级管理员', '17739072380', null, '1', '1', '2018-07-05 16:18:37', '127.0.0.1', '2018-06-15 19:50:38');

INSERT INTO `sys_user` VALUES ('nSY2fmkiX2', 'admin1', '0beaaac0103fe04443eea552880f21a8', '超级管理员', '17739072380', '', '1', '1', '2018-07-05 16:02:11', '127.0.0.1', '2018-06-15 19:50:38');

-- ----------------------------

-- Table structure for sys_user_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_user_role`;

CREATE TABLE `sys_user_role` (

`user_id` varchar(20) NOT NULL,

`rid` int(11) NOT NULL,

PRIMARY KEY (`user_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sys_user_role

-- ----------------------------

INSERT INTO `sys_user_role` VALUES ('nSY2fmkiX1', '1');

INSERT INTO `sys_user_role` VALUES ('nSY2fmkiX2', '2');