/*
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
-- ----------------------------