java权限表_权限管理表-小例子

/*

Navicat MySQL Data Transfer

Source Server         : localhost

Source Server Version : 50151

Source Host           : localhost:3306

Source Database       : tpay

Target Server Type    : MYSQL

Target Server Version : 50151

File Encoding         : 65001

Date: 2012-02-16 17:39:36

*/

SET FOREIGN_KEY_CHECKS=0;

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

-- Table structure for `t_adm_resource`

权限表

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

DROP TABLE IF EXISTS `t_adm_resource`;

CREATE TABLE `t_adm_resource` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`name` varchar(40) NOT NULL COMMENT '资源名称',

`url` varchar(200) NOT NULL,

`level` int(11) NOT NULL COMMENT '1=菜单级，2=按钮级',

`memu_resource_id` int(11) DEFAULT NULL COMMENT '如果是菜单级，它的父级菜单ID是它自己的ID',

`menu_type` int(11) DEFAULT NULL COMMENT '如果是菜单类型，则有父级菜单,对应左侧菜单栏父级菜单',

`rorder` int(11) DEFAULT NULL COMMENT '菜单的排列顺序',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- Records of t_adm_resource

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

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

-- Table structure for `t_adm_resource_roller`

权限角色关联表

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

DROP TABLE IF EXISTS `t_adm_resource_roller`;

CREATE TABLE `t_adm_resource_roller` (

`id` bigint(20) NOT NULL,

`resource_id` bigint(20) NOT NULL,

`roller_id` bigint(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- Records of t_adm_resource_roller

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

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

-- Table structure for `t_adm_roller`

角色表

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

DROP TABLE IF EXISTS `t_adm_roller`;

CREATE TABLE `t_adm_roller` (

`id` bigint(20) NOT NULL,

`name` varchar(40) NOT NULL,

`desc` varchar(200) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- Records of t_adm_roller

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

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

-- Table structure for `t_adm_roller_manager`

角色用户关联表

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

DROP TABLE IF EXISTS `t_adm_roller_manager`;

CREATE TABLE `t_adm_roller_manager` (

`id` bigint(20) NOT NULL,

`roller_id` bigint(20) NOT NULL,

`user_id` bigint(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- Records of t_adm_roller_manager

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