text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : local_mysql
  Source Server Version : 50625
  Source Host           : 127.0.0.1:3306
  Source Database       : test_hz_security
  
  Target Server Type    : MYSQL
  Target Server Version : 50625
  File Encoding         : 65001
  
  Date: 2018-07-31 22:57:06
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for hibernate_sequence
  -- ----------------------------
  DROP TABLE IF EXISTS `hibernate_sequence`;
  CREATE TABLE `hibernate_sequence` (
    `next_val` bigint(20) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of hibernate_sequence
  -- ----------------------------
  INSERT INTO `hibernate_sequence` VALUES ('1');
  INSERT INTO `hibernate_sequence` VALUES ('1');
  INSERT INTO `hibernate_sequence` VALUES ('1');
  
  -- ----------------------------
  -- Table structure for sys_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_permission`;
  CREATE TABLE `sys_permission` (
    `id` int(11) NOT NULL,
    `available` bit(1) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `parent_id` bigint(20) DEFAULT NULL,
    `parent_ids` varchar(255) DEFAULT NULL,
    `resource_type` enum('menu','button') DEFAULT NULL,
    `url` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of sys_permission
  -- ----------------------------
  INSERT INTO `sys_permission` VALUES ('1', '\0', '首页', '0', '0/', 'menu', '/');
  INSERT INTO `sys_permission` VALUES ('2', '\0', '管理首页', '1', '0/1', 'menu', '/admin');
  
  -- ----------------------------
  -- Table structure for sys_role
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role`;
  CREATE TABLE `sys_role` (
    `id` int(11) NOT NULL,
    `available` bit(1) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `role` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of sys_role
  -- ----------------------------
  INSERT INTO `sys_role` VALUES ('1', '\0', '管理员', 'ROLE_ADMIN');
  INSERT INTO `sys_role` VALUES ('2', '\0', '用户', 'ROLE_USER');
  
  -- ----------------------------
  -- Table structure for sys_role_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role_permission`;
  CREATE TABLE `sys_role_permission` (
    `permission_id` int(11) NOT NULL,
    `role_id` int(11) NOT NULL,
    KEY `FK9q28ewrhntqeipl1t04kh1be7` (`role_id`),
    KEY `FKomxrs8a388bknvhjokh440waq` (`permission_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of sys_role_permission
  -- ----------------------------
  INSERT INTO `sys_role_permission` VALUES ('1', '1');
  INSERT INTO `sys_role_permission` VALUES ('2', '1');
  INSERT INTO `sys_role_permission` VALUES ('1', '2');
  
  -- ----------------------------
  -- Table structure for sys_user_role
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_user_role`;
  CREATE TABLE `sys_user_role` (
    `role_id` int(11) NOT NULL,
    `uid` bigint(20) NOT NULL,
    KEY `FKgkmyslkrfeyn9ukmolvek8b8f` (`uid`),
    KEY `FKhh52n8vd4ny9ff4x9fb8v65qx` (`role_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of sys_user_role
  -- ----------------------------
  INSERT INTO `sys_user_role` VALUES ('1', '1');
  INSERT INTO `sys_user_role` VALUES ('2', '2');
  
  -- ----------------------------
  -- Table structure for user_info
  -- ----------------------------
  DROP TABLE IF EXISTS `user_info`;
  CREATE TABLE `user_info` (
    `uid` bigint(20) NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    `password` varchar(255) DEFAULT NULL,
    `state` tinyint(4) NOT NULL,
    `username` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`uid`),
    UNIQUE KEY `UK_f2ksd6h8hsjtd57ipfq9myr64` (`username`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of user_info
  -- ----------------------------
  INSERT INTO `user_info` VALUES ('1', '管理员', 'E10ADC3949BA59ABBE56E057F20F883E', '0', 'admin');
  INSERT INTO `user_info` VALUES ('2', '用户1', 'E10ADC3949BA59ABBE56E057F20F883E', '0', 'user');
  