text: 
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for ly_res_user
  -- ----------------------------
  DROP TABLE IF EXISTS `ly_res_user`;
  CREATE TABLE `ly_res_user` (
    `resId` int(11) NOT NULL,
    `userId` int(11) NOT NULL,
    PRIMARY KEY (`userId`,`resId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of ly_res_user
  -- ----------------------------
  INSERT INTO `ly_res_user` VALUES ('1', '3');
  INSERT INTO `ly_res_user` VALUES ('2', '3');
  INSERT INTO `ly_res_user` VALUES ('3', '3');
  INSERT INTO `ly_res_user` VALUES ('4', '3');
  INSERT INTO `ly_res_user` VALUES ('5', '3');
  INSERT INTO `ly_res_user` VALUES ('6', '3');
  INSERT INTO `ly_res_user` VALUES ('7', '3');
  INSERT INTO `ly_res_user` VALUES ('8', '3');
  INSERT INTO `ly_res_user` VALUES ('9', '3');
  INSERT INTO `ly_res_user` VALUES ('10', '3');
  INSERT INTO `ly_res_user` VALUES ('11', '3');
  INSERT INTO `ly_res_user` VALUES ('25', '3');
  INSERT INTO `ly_res_user` VALUES ('26', '3');
  INSERT INTO `ly_res_user` VALUES ('27', '3');
  INSERT INTO `ly_res_user` VALUES ('28', '3');
  INSERT INTO `ly_res_user` VALUES ('29', '3');
  INSERT INTO `ly_res_user` VALUES ('30', '3');
  INSERT INTO `ly_res_user` VALUES ('31', '3');
  INSERT INTO `ly_res_user` VALUES ('32', '3');
  INSERT INTO `ly_res_user` VALUES ('33', '3');
  INSERT INTO `ly_res_user` VALUES ('34', '3');
  INSERT INTO `ly_res_user` VALUES ('35', '3');
  
  -- ----------------------------
  -- Table structure for ly_resources
  -- ----------------------------
  DROP TABLE IF EXISTS `ly_resources`;
  CREATE TABLE `ly_resources` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) DEFAULT NULL,
    `parentId` int(11) DEFAULT NULL,
    `resKey` varchar(50) DEFAULT NULL,
    `type` varchar(40) DEFAULT NULL,
    `resUrl` varchar(200) DEFAULT NULL,
    `level` int(4) DEFAULT NULL,
    `icon` varchar(100) DEFAULT NULL,
    `ishide` int(3) DEFAULT '0',
    `description` varchar(200) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of ly_resources
  -- ----------------------------
  INSERT INTO `ly_resources` VALUES ('1', '系统基础管理', '0', 'system', '0', 'system', '1', 'fa-desktop', '0', '系统基础管理');
  INSERT INTO `ly_resources` VALUES ('2', '用户管理', '1', 'account', '1', '/user/list.shtml', '2', null, '0', null);
  INSERT INTO `ly_resources` VALUES ('3', '角色管理', '1', 'role', '1', '/role/list.shtml', '7', 'fa-list', '0', '组管理');
  INSERT INTO `ly_resources` VALUES ('4', '菜单管理', '1', 'ly_resources', '1', '/resources/list.shtml', '12', 'fa-list-alt', '0', '菜单管理');
  INSERT INTO `ly_resources` VALUES ('5', '新增用户', '2', 'account_add', '2', '/user/addUI.shtml', '3', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;addAccount&quot;&nbsp;class=&quot;btn&nbsp;btn-primary&nbsp;marR10&quot;&gt;新增&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('6', '修改用户', '2', 'account_edit', '2', '/user/editUI.shtml', '4', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;editAccount&quot;&nbsp;class=&quot;btn&nbsp;btn-info&nbsp;marR10&quot;&gt;编辑&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('7', '删除用户', '2', 'account_delete', '2', '/user/deleteById.shtml', '5', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;delAccount&quot;&nbsp;class=&quot;btn&nbsp;btn-danger&nbsp;marR10&quot;&gt;删除&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('8', '新增角色', '3', 'role_add', '2', '/role/addUI.shtml', '8', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;addRole&quot;&nbsp;class=&quot;btn&nbsp;btn-primary&nbsp;marR10&quot;&gt;新增&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('9', '修改角色', '3', 'role_edit', '2', '/role/editUI.shtml', '9', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;editRole&quot;&nbsp;class=&quot;btn&nbsp;btn-info&nbsp;marR10&quot;&gt;编辑&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('10', '删除角色', '3', 'role_delete', '2', '/role/delete.shtml', '10', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;delRole&quot;&nbsp;class=&quot;btn&nbsp;btn-danger&nbsp;marR10&quot;&gt;删除&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('11', '分配权限', '3', 'role_perss', '2', '/resources/permissions.shtml', '11', '无', '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;permissions&quot;&nbsp;class=&quot;btn&nbsp;btn&nbsp;btn-grey&nbsp;marR10&quot;&gt;分配权限&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('25', '登陆信息管理', '0', 'ly_login', '0', 'ly_login', '18', 'fa-calendar', '0', '登陆信息管理');
  INSERT INTO `ly_resources` VALUES ('26', '用户登录记录', '25', 'ly_log_list', '1', '/userlogin/listUI.shtml', '19', null, '0', '用户登录记录');
  INSERT INTO `ly_resources` VALUES ('27', '操作日志管理', '0', 'ly_log', '0', 'ly_log', '20', 'fa-picture-o', '1', '操作日志管理');
  INSERT INTO `ly_resources` VALUES ('28', '日志查询', '27', 'ly_log', '1', '/log/list.shtml', '21', null, '0', null);
  INSERT INTO `ly_resources` VALUES ('29', '新增菜单资源', '4', 'ly_resources_add', '2', '/resources/addUI.shtml', '13', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;addFun&quot;&nbsp;class=&quot;btn&nbsp;btn-primary&nbsp;marR10&quot;&gt;新增&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('30', '修改菜单资源', '4', 'ly_resources_edit', '2', '/resources/editUI.shtml', '14', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;editFun&quot;&nbsp;class=&quot;btn&nbsp;btn-info&nbsp;marR10&quot;&gt;编辑&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('31', '删除菜单资源', '4', 'ly_resources_delete', '2', '/resources/delete.shtml', '15', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;delFun&quot;&nbsp;class=&quot;btn&nbsp;btn-danger&nbsp;marR10&quot;&gt;删除&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('32', '系统监控管理', '0', 'monitor', '0', 'monitor', '16', 'fa-tag', '0', '系统监控管理');
  INSERT INTO `ly_resources` VALUES ('33', '实时监控', '32', 'sysmonitor', '1', '/monitor/monitor.shtml', '17', null, '0', '实时监控');
  INSERT INTO `ly_resources` VALUES ('34', '分配权限', '2', 'permissions', '2', '/resources/permissions.shtml', '6', null, '0', '&lt;button&nbsp;type=&quot;button&quot;&nbsp;id=&quot;permissions&quot;&nbsp;class=&quot;btn&nbsp;btn&nbsp;btn-grey&nbsp;marR10&quot;&gt;分配权限&lt;/button&gt;');
  INSERT INTO `ly_resources` VALUES ('35', '告警列表', '32', 'monitor_warn', '1', '/monitor/list.shtml', null, null, '0', '告警列表');
  
  -- ----------------------------
  -- Table structure for ly_role
  -- ----------------------------
  DROP TABLE IF EXISTS `ly_role`;
  CREATE TABLE `ly_role` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `state` varchar(3) DEFAULT NULL,
    `name` varchar(50) DEFAULT NULL,
    `roleKey` varchar(50) DEFAULT NULL,
    `description` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of ly_role
  -- ----------------------------
  INSERT INTO `ly_role` VALUES ('1', '0', '管理员', 'admin', '管理员');
  INSERT INTO `ly_role` VALUES ('2', '0', '普通角色', 'simple', '普通角色');
  INSERT INTO `ly_role` VALUES ('3', '0', '超级管理员', 'SUPER', '超级管理员');
  
  -- ----------------------------
  -- Table structure for ly_user
  -- ----------------------------
  DROP TABLE IF EXISTS `ly_user`;
  CREATE TABLE `ly_user` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `userName` varchar(20) DEFAULT NULL,
    `accountName` varchar(20) DEFAULT NULL,
    `password` varchar(100) DEFAULT NULL,
    `credentialsSalt` varchar(100) DEFAULT NULL,
    `description` varchar(100) DEFAULT NULL,
    `locked` varchar(3) DEFAULT '0',
    `createTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `deletestatus` int(1) DEFAULT '0' COMMENT '逻辑删除状态0:存在1:删除',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of ly_user
  -- ----------------------------
  INSERT INTO `ly_user` VALUES ('1', '蓝缘', 'simple', '78e21a6eb88529eab722793a448ed394', '4157c3feef4a6ed91b2c28cf4392f2d1', '0', '1', '2015-05-17 22:23:15', '0');
  INSERT INTO `ly_user` VALUES ('2', '超级管理员', 'ROOT', '78e21a6eb88529eab722793a448ed394', '4157c3feef4a6ed91b2c28cf4392f2d1', '0000', '1', '2015-05-23 17:39:37', '0');
  INSERT INTO `ly_user` VALUES ('3', '管理员', 'admin', '78e21a6eb88529eab722793a448ed394', '4157c3feef4a6ed91b2c28cf4392f2d1', '3434', '1', '2015-05-23 17:39:39', '0');
  
  -- ----------------------------
  -- Table structure for ly_user_role
  -- ----------------------------
  DROP TABLE IF EXISTS `ly_user_role`;
  CREATE TABLE `ly_user_role` (
    `userId` int(11) NOT NULL,
    `roleId` int(11) NOT NULL,
    PRIMARY KEY (`userId`,`roleId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of ly_user_role
  -- ----------------------------
  INSERT INTO `ly_user_role` VALUES ('1', '2');
  INSERT INTO `ly_user_role` VALUES ('2', '3');
  INSERT INTO `ly_user_role` VALUES ('3', '1');
  