| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 | 
							- -- author:scott -- date:20190522-- for: 菜单根请求URL配置错误 ---------
 
- UPDATE `sys_permission` SET `id`='190c2b43bec6a5f7a4194a85db67d96a', `parent_id`='d7d6e2e4e2934f2c9385a623fd98c6f3', `name`='角色维护', `url`='/isystem/roleUserList', `component`='system/RoleUserList', `component_name`=NULL, `redirect`=NULL, `menu_type`='1', `perms`=NULL, `perms_type`=NULL, `sort_no`='1', `always_show`='0', `icon`=NULL, `is_route`='1', `is_leaf`='1', `hidden`='0', `description`=NULL, `create_by`='admin', `create_time`='2019-04-17 15:13:56', `update_by`=NULL, `update_time`=NULL, `del_flag`='0', `rule_flag`='0', `status`=NULL WHERE (`id`='190c2b43bec6a5f7a4194a85db67d96a');
 
- UPDATE `sys_permission` SET `id`='5c2f42277948043026b7a14692456828', `parent_id`='d7d6e2e4e2934f2c9385a623fd98c6f3', `name`='我的部门', `url`='/isystem/departUserList', `component`='system/DepartUserList', `component_name`=NULL, `redirect`=NULL, `menu_type`='1', `perms`=NULL, `perms_type`=NULL, `sort_no`='1', `always_show`='0', `icon`=NULL, `is_route`='1', `is_leaf`='1', `hidden`='0', `description`=NULL, `create_by`='admin', `create_time`='2019-04-17 15:12:24', `update_by`=NULL, `update_time`=NULL, `del_flag`='0', `rule_flag`='0', `status`=NULL WHERE (`id`='5c2f42277948043026b7a14692456828');
 
- -- author:scott -- date:20190522--  for: 菜单根请求URL配置错误 ----------
 
- -- author:scott -- date:20190524--  for: 字段长度不够 ----------
 
- ALTER TABLE `sys_log`
 
- MODIFY COLUMN `request_param`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求参数' AFTER `request_url`;
 
- -- author:scott -- date:20190524--  for:  字段长度不够  ----------
 
- -- author:taoyan -- date:20190529--  for: 分类字典
 
- INSERT INTO `sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`) VALUES ('ebb9d82ea16ad864071158e0c449d186', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '分类字典', '/isys/category', 'system/SysCategoryList', NULL, NULL, '1', NULL, '1', '5', '0', NULL, '1', '1', '0', NULL, 'admin', '2019-05-29 18:48:07', 'admin', '2019-05-29 18:48:27', '0', '0', '1');
 
- CREATE TABLE `sys_category` (
 
-   `id` varchar(36) NOT NULL,
 
-   `pid` varchar(36) DEFAULT NULL COMMENT '父级节点',
 
-   `name` varchar(100) DEFAULT NULL COMMENT '类型名称',
 
-   `code` varchar(100) DEFAULT NULL COMMENT '类型编码',
 
-   `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
 
-   `create_time` datetime DEFAULT NULL COMMENT '创建日期',
 
-   `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
 
-   `update_time` datetime DEFAULT NULL COMMENT '更新日期',
 
-   `sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
 
-   `has_child` varchar(3) DEFAULT NULL COMMENT '是否有子节点',
 
-   PRIMARY KEY (`id`)
 
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
- -- author:taoyan -- date:20190529--  for: 分类字典
 
- -- author:scott---date:20190531 -----for:字典表del_flag代码不规范问题
 
- update sys_dict set del_flag = 0 where del_flag=1;
 
- update sys_dict set del_flag = 1 where del_flag=2;
 
- delete from sys_dict_item where dict_id not in (select id from sys_dict);
 
- -- author:scott---date:20190531 -----for:字典表del_flag代码不规范问题
 
- -- author:taoyan -- date:20190611 --  for: 树形列表菜单新增字典
 
- INSERT INTO `sys_dict` (`id`, `dict_name`, `dict_code`, `description`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `type`) VALUES ('a7adbcd86c37f7dbc9b66945c82ef9e6', '1是0否', 'yn', '', '1', 'admin', '2019-05-22 19:29:29', NULL, NULL, '0');
 
- INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('51222413e5906cdaf160bb5c86fb827c', 'a7adbcd86c37f7dbc9b66945c82ef9e6', '是', '1', '', '1.00', '1', 'admin', '2019-05-22 19:29:45', NULL, NULL);
 
- INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('c5700a71ad08994d18ad1dacc37a71a9', 'a7adbcd86c37f7dbc9b66945c82ef9e6', '否', '0', '', '1.00', '1', 'admin', '2019-05-22 19:29:55', NULL, NULL);
 
- -- author:taoyan -- date:20190611 --  for: 树形列表菜单新增字典
 
- -- author:huangxutao -- date:20190618-- for: 字段长度不够 ----------
 
- ALTER TABLE `sys_sms_template` MODIFY COLUMN `template_content` longtext;
 
- -- author:huangxutao -- date:20190618-- for: 字段长度不够 ----------
 
- -- author:scott-- date:20190620-- for: 字段长度不够 ----------
 
- ALTER TABLE `sys_log`
 
- MODIFY COLUMN `request_param`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数' ;
 
- -- author:scott -- date:20190620-- for: 字段长度不够 ----------
 
- -- author:os_tangfeifan-- date:20190702-- for: 新增是否缓存菜单字段 修复菜单类型错误----------
 
- ALTER TABLE `sys_permission`
 
- ADD COLUMN `keep_alive` tinyint(1) COMMENT '是否缓存该页面:    1:是   0:不是' AFTER `is_leaf`;
 
- update `sys_permission` set `menu_type`='0' where `id`='d7d6e2e4e2934f2c9385a623fd98c6f3';
 
- -- author:os_tangfeifan -- date:2019702-- for: 新增是否缓存菜单字段 修复菜单类型错误----------
 
 
  |