/*
Navicat MySQL Data Transfer
Source Server : 本地MySql
Source Server Version : 50712
Source Host : localhost:3306
Source Database : sstest
Target Server Type : MYSQL
Target Server Version : 50712
File Encoding : 65001
Date: 2016-08-23 11:26:34
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for xt_auth
-- ----------------------------
DROP TABLE IF EXISTS `xt_auth`;
CREATE TABLE `xt_auth` (
`auth_id` varchar(32) NOT NULL,
`auth_name` varchar(20) NOT NULL COMMENT '权限名称',
`auth_code` varchar(20) NOT NULL COMMENT '权限编码',
PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of xt_auth
-- ----------------------------
INSERT INTO `xt_auth` VALUES ('a01', 'admin', 'ROLE_ADMIN');
INSERT INTO `xt_auth` VALUES ('a02', 'user', 'ROLE_USER');
-- ----------------------------
-- Table structure for xt_auth_role
-- ----------------------------
DROP TABLE IF EXISTS `xt_auth_role`;
CREATE TABLE `xt_auth_role` (
`auth_role_id` varchar(32) NOT NULL,
`auth_role_auth_id` varchar(32) NOT NULL COMMENT '角色id',
`auth_role_role_id` varchar(32) NOT NULL COMMENT '权限id',
PRIMARY KEY (`auth_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of xt_auth_role
-- ----------------------------
INSERT INTO `xt_auth_role` VALUES ('ar01', 'a01', 'r01');
INSERT INTO `xt_auth_role` VALUES ('ar02', 'a02', 'r01');
INSERT INTO `xt_auth_role` VALUES ('ar03', 'a02', 'r02');
-- ----------------------------
-- Table structure for xt_role
-- ----------------------------
DROP TABLE IF EXISTS `xt_role`;
CREATE TABLE `xt_role` (
`role_id` varchar(32) NOT NULL,
`role_name` varchar(20) NOT NULL COMMENT '角色名称',
`role_code` varchar(20) NOT NULL COMMENT '角色code',
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of xt_role
-- ----------------------------
INSERT INTO `xt_role` VALUES ('r01', 'USER', 'T01');
INSERT INTO `xt_role` VALUES ('r02', 'ADMIN', 'T01');
-- ----------------------------
-- Table structure for xt_user
-- ----------------------------
DROP TABLE IF EXISTS `xt_user`;
CREATE TABLE `xt_user` (
`user_id` varchar(32) NOT NULL,
`user_name` varchar(100) NOT NULL COMMENT '用户名称',
`user_pwd` varchar(32) NOT NULL COMMENT '密码',
`user_role_id` varchar(32) NOT NULL COMMENT '用户的角色',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业用户';
-- ----------------------------
-- Records of xt_user
-- ----------------------------
INSERT INTO `xt_user` VALUES ('59ed7835d65141b1871baa3b35a83e3', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'r01');
INSERT INTO `xt_user` VALUES ('59ed7835d65141b1871baa3b35a83e37', 'user', 'e10adc3949ba59abbe56e057f20f883e', 'r02');
