/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50162
Source Host : localhost:3306
Source Database : qx
Target Server Type : MYSQL
Target Server Version : 50162
File Encoding : 65001
Date: 2016-10-26 16:45:20
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`id` varchar(100) NOT NULL,
`menuname` varchar(100) NOT NULL,
`pid` varchar(100) NOT NULL,
`code` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('028495d9297a40b699dc08e8df1eafd6', '用户列表', '1', 'user/list');
INSERT INTO `menu` VALUES ('0d1f1839f450460d8b3953e20ecb1315', '删除用户', '1', 'user/delete');
INSERT INTO `menu` VALUES ('1', '用户管理', '0', 'user');
INSERT INTO `menu` VALUES ('2f383f896a084fcea139be2a74af3d02', '修改用户', '1', 'user/update');
INSERT INTO `menu` VALUES ('427f3dbcb06347cdb1ec6c26b25edd47', '添加用户', '1', 'user/add');
INSERT INTO `menu` VALUES ('564128256fe64c70860507cfa0c3b855', '修改角色', 'b1dd4a57891f4fc2b4936a94b961bb81', 'role/update');
INSERT INTO `menu` VALUES ('59cd4b2b12ec465aade099d05bc7f9b2', '用户角色分配', 'f0cc106045914915a68a289e88d2ab2c', 'userRole/update');
INSERT INTO `menu` VALUES ('5a9086f484234226a5014e1a7bfe5e3f', '添加权限', 'a25898e9cce94a36922254ce71bbb423', 'menu/add');
INSERT INTO `menu` VALUES ('6c059653dc7e4bffa2f13b9ce2824f60', '角色权限分配', 'b9c7562ef9654361b6b5a83d4fa0fb78', 'roleMenu/update');
INSERT INTO `menu` VALUES ('89b105fd83a34d23a18fb0184fb827b7', '删除角色', 'b1dd4a57891f4fc2b4936a94b961bb81', 'role/delete');
INSERT INTO `menu` VALUES ('89e84292f0c84a689d2a1e642ab6aee3', '角色列表', 'b1dd4a57891f4fc2b4936a94b961bb81', 'role/list');
INSERT INTO `menu` VALUES ('9538549cd2a84a04ac45de250f011eff', '用户角色列表', 'f0cc106045914915a68a289e88d2ab2c', 'userRole/list');
INSERT INTO `menu` VALUES ('993793c63b4e435ab1801f9d93e49e02', '修改权限', 'a25898e9cce94a36922254ce71bbb423', 'menu/update');
INSERT INTO `menu` VALUES ('9a6c50d8e4c9416fa6e28b43fd8bab33', '权限列表', 'a25898e9cce94a36922254ce71bbb423', 'menu/list');
INSERT INTO `menu` VALUES ('a25898e9cce94a36922254ce71bbb423', '权限管理', '0', 'menu');
INSERT INTO `menu` VALUES ('b1dd4a57891f4fc2b4936a94b961bb81', '角色管理', '0', 'role');
INSERT INTO `menu` VALUES ('b6f4f6f842bf49749aae864083890444', '删除权限', 'a25898e9cce94a36922254ce71bbb423', 'menu/delete');
INSERT INTO `menu` VALUES ('b9c7562ef9654361b6b5a83d4fa0fb78', '权限分配', '0', 'roleMenu');
INSERT INTO `menu` VALUES ('f0cc106045914915a68a289e88d2ab2c', '角色分配', '0', 'userRole');
INSERT INTO `menu` VALUES ('f335a62912e34c7f8283a2bde51a764e', '角色权限列表', 'b9c7562ef9654361b6b5a83d4fa0fb78', 'roleMenu/list');
INSERT INTO `menu` VALUES ('f37ad7d173a049dfbf53d4c3825bed4d', '添加角色', 'b1dd4a57891f4fc2b4936a94b961bb81', 'role/add');
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` varchar(100) NOT NULL,
`rolename` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '管理�?);
INSERT INTO `role` VALUES ('437dc6a5f31045ff978b673c395c4fd1', '普通用�?);
INSERT INTO `role` VALUES ('582c48fc3e9747b3ac5fee065e21837b', '超级管理�?);
-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu` (
`id` varchar(100) NOT NULL,
`menid` varchar(100) NOT NULL,
`roleid` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `menid` (`menid`),
KEY `roleid` (`roleid`),
CONSTRAINT `role_menu_ibfk_1` FOREIGN KEY (`menid`) REFERENCES `menu` (`id`),
CONSTRAINT `role_menu_ibfk_2` FOREIGN KEY (`roleid`) REFERENCES `role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of role_menu
-- ----------------------------
INSERT INTO `role_menu` VALUES ('025de6b196114b82a3b4721caf9c78b8', 'b6f4f6f842bf49749aae864083890444', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('094df563be3e438fafae066473c07640', '9a6c50d8e4c9416fa6e28b43fd8bab33', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('0eb34ed0fcae4e409a100f2045d7f55a', 'f37ad7d173a049dfbf53d4c3825bed4d', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('284f08b5632344ae9e0096b280f6201c', '9a6c50d8e4c9416fa6e28b43fd8bab33', '1');
INSERT INTO `role_menu` VALUES ('2bb3fddc912844a8b9d96ec750d157ee', 'f335a62912e34c7f8283a2bde51a764e', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('39cb7e1f4fb74e67ab34ac70f426d980', '1', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('41b855ff88884755a9eb610779e57068', '89e84292f0c84a689d2a1e642ab6aee3', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('48e186d59d8740fc9e00e4e6d2cedd78', '1', '1');
INSERT INTO `role_menu` VALUES ('5335a986b1334c619af0a77179b46ad7', '2f383f896a084fcea139be2a74af3d02', '1');
INSERT INTO `role_menu` VALUES ('54000a6bc22649f4a536692c15ef8d0c', '9538549cd2a84a04ac45de250f011eff', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('6409d43261d64097a9af94ab30f983b6', '5a9086f484234226a5014e1a7bfe5e3f', '1');
INSERT INTO `role_menu` VALUES ('69657412cb144ddbbf1da960565b74ba', '0d1f1839f450460d8b3953e20ecb1315', '1');
INSERT INTO `role_menu` VALUES ('6ee3cfcf23304781bb70e89556e48367', 'b1dd4a57891f4fc2b4936a94b961bb81', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('6fefd3cb78a547d8885d8e073ff62bcf', 'a25898e9cce94a36922254ce71bbb423', '1');
INSERT INTO `role_menu` VALUES ('718df2f114504eb5a31218b92c1719d0', 'a25898e9cce94a36922254ce71bbb423', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('75527fede5c14dd6bd2856a1c08548c3', '028495d9297a40b699dc08e8df1eafd6', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('7fe909d6720746c09522f47ed7c156c4', '6c059653dc7e4bffa2f13b9ce2824f60', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('822c66442f504adda545ee16ccb728cb', 'b9c7562ef9654361b6b5a83d4fa0fb78', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('8e82c71c4c8b42b784902a162269d460', '2f383f896a084fcea139be2a74af3d02', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('93145e131f204c39afd85a32d58dae8d', '5a9086f484234226a5014e1a7bfe5e3f', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('a334371eb9e64ee0b9111dd3aa02244b', '59cd4b2b12ec465aade099d05bc7f9b2', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('bf47cfd7e7dc4a249dd3e0f9a62c67aa', '89b105fd83a34d23a18fb0184fb827b7', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('d07c8f9acd2c4073a61dc84ae2b139ff', '564128256fe64c70860507cfa0c3b855', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('d3606abc18bf47b391f32954f8a3f341', '993793c63b4e435ab1801f9d93e49e02', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('d8066134cfe449578fef1361ac002476', '028495d9297a40b699dc08e8df1eafd6', '1');
INSERT INTO `role_menu` VALUES ('d9cea80eeeb34585b6f1e6c4ffb30db0', '427f3dbcb06347cdb1ec6c26b25edd47', '1');
INSERT INTO `role_menu` VALUES ('db3a4dcb5502418a8e8ef9d389885770', 'f0cc106045914915a68a289e88d2ab2c', '582c48fc3e9747b3ac5fee065e21837b');
INSERT INTO `role_menu` VALUES ('dff8027209ee4
- 1
- 2
- 3
- 4
- 5
- 6
前往页