-- ------------ update on 2020.06.15  增加伪静态规则管理功能 ------------------

-- 设置 的4级隐藏菜单

UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='12' and `status`='1');

UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='22' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='48' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='49' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='50' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='51' and `status`='1');

UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='18' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='19' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='21' and `status`='1');

UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='27' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='28' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='29' and `status`='1');

UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='24' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='25' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='26' and `status`='1');

UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='30' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='31' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='32' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='33' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='34' and `status`='1');

-- 模块 的4级隐藏菜单

UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='52' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='53' and `status`='1');
UPDATE `yzn_menu` SET `status`='0' WHERE (`id`='54' and `status`='1');



-- ------------ update on 2020.06.17  增加api日志功能 ------------------

-- ----------------------------
-- Table structure for yzn_apilog
-- ----------------------------
DROP TABLE IF EXISTS `yzn_apilog`;
CREATE TABLE `yzn_apilog` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `url` text NOT NULL COMMENT '接口地址',
  `app_route` varchar(100) NOT NULL DEFAULT '' COMMENT 'app路由定位',
  `request_param` text NOT NULL COMMENT '请求参数',
  `request_method` varchar(20) NOT NULL DEFAULT '' COMMENT '请求方法',
  `request_content_type` varchar(40) DEFAULT '' COMMENT '请求类型',
  `request_ip` varchar(50) DEFAULT '' COMMENT 'IP地址',
  `http_user_agent` text COMMENT 'User-Agent',
  `response_text` text COMMENT '响应结果',
  `response_content_type` varchar(40) DEFAULT '' COMMENT '响应类型',
  `response_code` varchar(8) DEFAULT '' COMMENT 'HTTP状态码',
  `is_success` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否成功',
  `uid` int(11) DEFAULT '0' COMMENT '用户ID',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='API调用日志';


-- 添加菜单节点

INSERT INTO `yzn_menu` (`title`, `icon`, `parentid`, `app`, `controller`, `action`, `parameter`, `status`, `tip`, `is_dev`, `listorder`) VALUES ('API日志', 'icon-createtask', '15', 'admin', 'apilog', 'index', '', '1', '', '0', '0');

SELECT id INTO @parentid FROM yzn_menu where parentid = '15' order by id desc limit 1;
INSERT INTO `yzn_menu` (`title`, `icon`, `parentid`, `app`, `controller`, `action`, `parameter`, `status`, `tip`, `is_dev`, `listorder`) VALUES ('删除日志', '', @parentid, 'admin', 'apilog', 'delete', '', '0', '', '0', '0');
INSERT INTO `yzn_menu` (`title`, `icon`, `parentid`, `app`, `controller`, `action`, `parameter`, `status`, `tip`, `is_dev`, `listorder`) VALUES ('删除一个月前日志', '', @parentid, 'admin', 'apilog', 'deletelog', '', '0', '', '0', '0');




-- ------------ update on 2020.06.18  增加管理员表头像字段 ------------------

ALTER TABLE `yzn_admin`
ADD COLUMN `avatar`  varchar(255) NOT NULL DEFAULT '' COMMENT '头像' AFTER `nickname`;