<commit_before>/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : demo

Target Server Type    : MYSQL
Target Server Version : 50528
File Encoding         : 65001

Date: 2015-07-02 23:49:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_account
-- ----------------------------
DROP TABLE IF EXISTS `t_account`;
CREATE TABLE `t_account` (
  `id` mediumint(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `nick_name` varchar(50) NOT NULL DEFAULT '' COMMENT '手机号码',
  `password` varchar(50) NOT NULL,
  `mobile` varchar(50) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(50) DEFAULT NULL,
  `user_type` int(2) NOT NULL DEFAULT '0' COMMENT '用户类型 0:普通用户,1:会员用户,2:管理员用户',
  `login_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `disabled` int(2) NOT NULL DEFAULT '0' COMMENT '是否可用(0:可用 1:不可用)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of t_account
-- ----------------------------
INSERT INTO `t_account` VALUES ('1', 'demo', 'demo', '<PASSWORD>0<PASSWORD>', '13000000000', '<EMAIL>', '2', '2015-05-31 16:30:38', '0');
INSERT INTO `t_account` VALUES ('2', 'user', 'user1', '<PASSWORD>', '13000000000', '<EMAIL>', '0', '2015-06-04 21:47:49', '1');
INSERT INTO `t_account` VALUES ('3', 'test', 'test', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-05-31 21:14:47', '0');
INSERT INTO `t_account` VALUES ('5', 'test1', '1111', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-05-31 21:19:20', '0');
INSERT INTO `t_account` VALUES ('6', 'abcd', 'qwer', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000001', '<EMAIL>', '0', '2015-06-04 21:48:45', '0');
INSERT INTO `t_account` VALUES ('8', '111111', '111111', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-06-28 00:29:34', '0');
INSERT INTO `t_account` VALUES ('9', '1231', '1233', 'e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-06-28 00:34:33', '0');

-- ----------------------------
-- Table structure for t_account_role
-- ----------------------------
DROP TABLE IF EXISTS `t_account_role`;
CREATE TABLE `t_account_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_USER_ROL_REFERENCE_ROLE` (`role_id`) USING BTREE,
  KEY `FK_USER_ROL_REFERENCE_USERS` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='用户-角色关联表';

-- ----------------------------
-- Records of t_account_role
-- ----------------------------
INSERT INTO `t_account_role` VALUES ('1', '1', '1');
INSERT INTO `t_account_role` VALUES ('37', '2', '1');
INSERT INTO `t_account_role` VALUES ('38', '2', '2');
INSERT INTO `t_account_role` VALUES ('39', '2', '4');
INSERT INTO `t_account_role` VALUES ('40', '9', '5');
INSERT INTO `t_account_role` VALUES ('41', '9', '6');

-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(200) NOT NULL DEFAULT '' COMMENT '显示内容',
  `value` int(10) NOT NULL DEFAULT '0' COMMENT '值',
  `target_column` varchar(10) DEFAULT '' COMMENT '对应字段',
  `descrption` varchar(100) DEFAULT '' COMMENT '描述',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `remark` varchar(100) DEFAULT '' COMMENT '备注',
  `disabled` int(2) NOT NULL DEFAULT '0' COMMENT '是否启用:0启用,1不启用',
  PRIMARY KEY (`id`),
  KEY `target_column` (`target_column`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='字典表';

-- ----------------------------
-- Records of t_dict
-- ----------------------------
INSERT INTO `t_dict` VALUES ('1', '普通用户', '0', 'user_type', '用户类型', '0', ' ', '0');
INSERT INTO `t_dict` VALUES ('2', '会员用户', '1', 'user_type', '用户类型', '0', ' ', '0');
INSERT INTO `t_dict` VALUES ('3', '管理员用户', '2', 'user_type', '用户类型', '0', '', '0');

-- ----------------------------
-- Table structure for t_resources
-- ----------------------------
DROP TABLE IF EXISTS `t_resources`;
CREATE TABLE `t_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL COMMENT '父节点id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `type` int(2) DEFAULT '0' COMMENT '类型:0:菜单,1:按钮',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `url` varchar(200) DEFAULT ' ',
  `permission` varchar(50) NOT NULL DEFAULT ' ' COMMENT '菜单编码',
  `icon` varchar(100) DEFAULT ' ',
  `disabled` tinyint(10) NOT NULL DEFAULT '0',
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='资源表';

-- ----------------------------
-- Records of t_resources
-- ----------------------------
INSERT INTO `t_resources` VALUES ('1', '0', '系统管理', '0', '1', '', 'sys:manager', 'icon-cogs', '0', '');
INSERT INTO `t_resources` VALUES ('2', '1', '角色管理', '0', '3', '/role/list', 'sys:role:list', ' icon-user', '0', '');
INSERT INTO `t_resources` VALUES ('3', '1', '用户管理', '0', '2', '/user/list', 'sys:user:list', 'icon-hamburg-user', '0', '');
INSERT INTO `t_resources` VALUES ('4', '2', '添加', '1', null, '', 'sys:role:add', '', '0', '角色添加1');
INSERT INTO `t_resources` VALUES ('5', '2', '删除', '1', null, '', 'sys:role:delete', '', '0', '角色删除');
INSERT INTO `t_resources` VALUES ('6', '2', '修改', '1', null, '', 'sys:role:update', '', '0', '角色修改');
INSERT INTO `t_resources` VALUES ('7', '3', '添加', '1', null, '', 'sys:user:add', '', '0', '用户添加');
INSERT INTO `t_resources` VALUES ('8', '3', '删除', '1', null, '', 'sys:user:delete', '', '0', '用户删除');
INSERT INTO `t_resources` VALUES ('10', '11', '数据源监控', '0', '6', '/monitoring', 'monitoring:data', 'icon-hamburg-database', '0', '');
INSERT INTO `t_resources` VALUES ('11', '0', '系统监控', '0', '5', '', 'monitoring:system', 'icon-bar-chart', '0', '');
INSERT INTO `t_resources` VALUES ('12', '3', '修改', '1', null, '', 'sys:user:update', '', '0', '用户修改');
INSERT INTO `t_resources` VALUES ('13', '24', '添加', '1', null, '', 'sys:perm:add', '', '0', '菜单添加');
INSERT INTO `t_resources` VALUES ('14', '24', '修改', '1', null, '', 'sys:perm:update', '', '0', '菜单修改');
INSERT INTO `t_resources` VALUES ('15', '24', '删除', '1', null, '', 'sys:perm:delete', '', '0', '菜单删除');
INSERT INTO `t_resources` VALUES ('16', '2', '查看', '1', null, '', 'sys:role:view', '', '0', '角色查看');
INSERT INTO `t_resources` VALUES ('17', '3', '查看', '1', null, '', 'sys:user:view', '', '0', '用户查看');
INSERT INTO `t_resources` VALUES ('19', '3', '查看用户角色', '1', null, '', 'sys:user:roleView', '', '0', '查看用户角色');
INSERT INTO `t_resources` VALUES ('22', '2', '查看角色权限', '1', null, '', 'sys:role:permView', '', '0', '查看角色拥有的权限');
INSERT INTO `t_resources` VALUES ('23', '11', '定时任务管理', '0', '9', '', 'monitoring:task', 'icon-hamburg-full-time', '0', '定时任务管理，支持集群');
INSERT INTO `t_resources` VALUES ('24', '1', '菜单管理', '0', '4', '/resources/list', 'sys:perm:manager', 'icon-hamburg-old-versions', '0', '');
INSERT INTO `t_resources` VALUES ('25', '1', '字典管理', '0', '6', '', 'sys:dictionaries', 'icon-hamburg-address', '0', '数据字典管理');
INSERT INTO `t_resources` VALUES ('28', '1', 'a', '0', null, '', '11', '', '1', '');

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `role_code` varchar(20) NOT NULL,
  `description` text,
  `sort` int(6) DEFAULT '99',
  `disabled` int(2) NOT NULL DEFAULT '0' COMMENT '是否启用:0启用,1弃用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of t_role<commit_msg>更新SQL脚本<commit_after>/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : demo

Target Server Type    : MYSQL
Target Server Version : 50528
File Encoding         : 65001

Date: 2015-07-03 22:44:11
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_account
-- ----------------------------
DROP TABLE IF EXISTS `t_account`;
CREATE TABLE `t_account` (
  `id` mediumint(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `nick_name` varchar(50) NOT NULL DEFAULT '' COMMENT '手机号码',
  `password` varchar(50) NOT NULL,
  `mobile` varchar(50) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(50) DEFAULT NULL,
  `user_type` int(2) NOT NULL DEFAULT '0' COMMENT '用户类型 0:普通用户,1:会员用户,2:管理员用户',
  `login_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `disabled` int(2) NOT NULL DEFAULT '0' COMMENT '是否可用(0:可用 1:不可用)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of t_account
-- ----------------------------
INSERT INTO `t_account` VALUES ('1', 'demo', 'demo', '<PASSWORD>', '13000000000', '<EMAIL>', '2', '2015-05-31 16:30:38', '0');
INSERT INTO `t_account` VALUES ('2', 'user', 'user1', '<PASSWORD>', '13000000000', '<EMAIL>', '0', '2015-06-04 21:47:49', '1');
INSERT INTO `t_account` VALUES ('3', 'test', 'test', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-05-31 21:14:47', '0');
INSERT INTO `t_account` VALUES ('5', 'test1', '1111', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-05-31 21:19:20', '0');
INSERT INTO `t_account` VALUES ('6', 'abcd', 'qwer', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000001', '<EMAIL>', '0', '2015-06-04 21:48:45', '0');
INSERT INTO `t_account` VALUES ('8', '111111', '111111', 'MD5:e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-06-28 00:29:34', '0');
INSERT INTO `t_account` VALUES ('9', '1231', '1233', 'e10adc3949ba59abbe56e057f20f883e', '13000000000', '<EMAIL>', '0', '2015-06-28 00:34:33', '0');

-- ----------------------------
-- Table structure for t_account_role
-- ----------------------------
DROP TABLE IF EXISTS `t_account_role`;
CREATE TABLE `t_account_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_USER_ROL_REFERENCE_ROLE` (`role_id`) USING BTREE,
  KEY `FK_USER_ROL_REFERENCE_USERS` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='用户-角色关联表';

-- ----------------------------
-- Records of t_account_role
-- ----------------------------
INSERT INTO `t_account_role` VALUES ('1', '1', '1');
INSERT INTO `t_account_role` VALUES ('37', '2', '1');
INSERT INTO `t_account_role` VALUES ('38', '2', '2');
INSERT INTO `t_account_role` VALUES ('39', '2', '4');
INSERT INTO `t_account_role` VALUES ('40', '9', '5');
INSERT INTO `t_account_role` VALUES ('41', '9', '6');

-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(200) NOT NULL DEFAULT '' COMMENT '显示内容',
  `value` int(10) NOT NULL DEFAULT '0' COMMENT '值',
  `target_column` varchar(10) DEFAULT '' COMMENT '对应字段',
  `descrption` varchar(100) DEFAULT '' COMMENT '描述',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `remark` varchar(100) DEFAULT '' COMMENT '备注',
  `disabled` int(2) NOT NULL DEFAULT '0' COMMENT '是否启用:0启用,1不启用',
  PRIMARY KEY (`id`),
  KEY `target_column` (`target_column`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='字典表';

-- ----------------------------
-- Records of t_dict
-- ----------------------------
INSERT INTO `t_dict` VALUES ('1', '普通用户', '0', 'user_type', '用户类型1', '1', 's', '0');
INSERT INTO `t_dict` VALUES ('2', '会员用户', '1', 'user_type', '用户类型', '2', ' ', '0');
INSERT INTO `t_dict` VALUES ('3', '管理员用户', '2', 'user_type', '用户类型', '3', '', '0');
INSERT INTO `t_dict` VALUES ('4', 's', '1', 's', 's', '1', 's', '0');

-- ----------------------------
-- Table structure for t_resources
-- ----------------------------
DROP TABLE IF EXISTS `t_resources`;
CREATE TABLE `t_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL COMMENT '父节点id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `type` int(2) DEFAULT '0' COMMENT '类型:0:菜单,1:按钮',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `url` varchar(200) DEFAULT ' ',
  `permission` varchar(50) NOT NULL DEFAULT ' ' COMMENT '菜单编码',
  `icon` varchar(100) DEFAULT ' ',
  `disabled` tinyint(10) NOT NULL DEFAULT '0',
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='资源表';

-- ----------------------------
-- Records of t_resources
-- ----------------------------
INSERT INTO `t_resources` VALUES ('1', '0', '系统管理', '0', '1', '', 'sys:manager', 'icon-cogs', '0', '');
INSERT INTO `t_resources` VALUES ('2', '1', '角色管理', '0', '3', '/role/list', 'sys:role:list', ' icon-user', '0', '');
INSERT INTO `t_resources` VALUES ('3', '1', '用户管理', '0', '2', '/user/list', 'sys:user:list', 'icon-hamburg-user', '0', '');
INSERT INTO `t_resources` VALUES ('4', '2', '添加', '1', null, '', 'sys:role:add', '', '0', '角色添加1');
INSERT INTO `t_resources` VALUES ('5', '2', '删除', '1', null, '', 'sys:role:delete', '', '0', '角色删除');
INSERT INTO `t_resources` VALUES ('6', '2', '修改', '1', null, '', 'sys:role:update', '', '0', '角色修改');
INSERT INTO `t_resources` VALUES ('7', '3', '添加', '1', null, '', 'sys:user:add', '', '0', '用户添加');
INSERT INTO `t_resources` VALUES ('8', '3', '删除', '1', null, '', 'sys:user:delete', '', '0', '用户删除');
INSERT INTO `t_resources` VALUES ('10', '11', '数据源监控', '0', '6', '/monitoring', 'monitoring:data', 'icon-hamburg-database', '0', '');
INSERT INTO `t_resources` VALUES ('11', '0', '系统监控', '0', '5', '', 'monitoring:system', 'icon-bar-chart', '0', '');
INSERT INTO `t_resources` VALUES ('12', '3', '修改', '1', null, '', 'sys:user:update', '', '0', '用户修改');
INSERT INTO `t_resources` VALUES ('13', '24', '添加', '1', null, '', 'sys:perm:add', '', '0', '菜单添加');
INSERT INTO `t_resources` VALUES ('14', '24', '修改', '1', null, '', 'sys:perm:update', '', '0', '菜单修改');
INSERT INTO `t_resources` VALUES ('15', '24', '删除', '1', null, '', 'sys:perm:delete', '', '0', '菜单删除');
INSERT INTO `t_resources` VALUES ('16', '2', '查看', '1', null, '', 'sys:role:view', '', '0', '角色查看');
INSERT INTO `t_resources` VALUES ('17', '3', '查看', '1', null, '', 'sys:user:view', '', '0', '用户查看');
INSERT INTO `t_resources` VALUES ('19', '3', '查看用户角色', '1', null, '', 'sys:user:roleView', '', '0', '查看用户角色');
INSERT INTO `t_resources` VALUES ('22', '2', '查看角色权限', '1', null, '', 'sys:role:permView', '', '0', '查看角色拥有的权限');
INSERT INTO `t_resources` VALUES ('23', '11', '定时任务管理', '0', '9', '', 'monitoring:task', 'icon-hamburg-full-time', '0', '定时任务管理，支持集群');
INSERT INTO `t_resources` VALUES ('24', '1', '菜单管理', '0', '4', '/resources/list', 'sys:perm:manager', 'icon-hamburg-old-versions', '0', '');
INSERT INTO `t_resources` VALUES ('25', '1', '字典管理', '0', '6', '/dict/list', 'sys:dictionaries', 'icon-hamburg-address', '0', '数据字典管理');
INSERT INTO `t_resources` VALUES ('28', '1', 'a', '0', null, '', '11', '', '1', '');
INSERT INTO `t_resources` VALUES ('29', '25', '添加数据字典', '1', '2', '', 'sys:dict:add', '', '0', '添加数据字典');
INSERT INTO `t_resources` VALUES ('30', '25', '数据字典修改', '1', '3', '', 'sys:dict:update', '', '0', '数据字典修改');

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `role_code` varchar(20) NOT NULL,
  `description` text,
  `sort` int(6) DEFAULT '99',
  `disabled` int(2) NOT NULL DEFAULT '0' COMMENT '是否启用:0启用,1弃用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of t_role
{'fraction_non_alphanumeric': 0.27931782945736433, 'fraction_numerical': 0.07590697674418605, 'mean_word_length': 3.6959813628421667, 'pattern_counts': {'":': 0, '<': 22, '<?xml version=': 0, '>': 22, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 14, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4970717', 'n_tokens_mistral': 6959, 'n_tokens_neox': 6359, 'n_words': 1645}