-- v1.1版本新增sql

-- 2021/10/21新增
ALTER TABLE `eb_chat_service_record` ADD `delete_time` INT(10) NULL DEFAULT NULL COMMENT '删除字段' AFTER `update_time`;
-- 2021/11/16新增
ALTER TABLE `eb_chat_user_label` ADD `sort` INT(10) NOT NULL DEFAULT '0' COMMENT '排序' AFTER `cate_id`;
-- 2021/11/18新增
CREATE TABLE `eb_qrcode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '二维码名称',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '地址',
  `user_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '用户ids',
  `appid` varchar(35) NOT NULL DEFAULT '' COMMENT 'APPID',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='二维码';
-- 新增配置
INSERT INTO `eb_system_config` (`id`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(null, 'qq_map_key', 'text', 'input', 1, '', 0, '', 100, 0, '""', '腾讯地图开放平台KEY', '腾讯地图开放平台KEY,申请地址:https://lbs.qq.com/dev/console/application/mine', 0, 1),
(null, 'kefu_icon_url3', 'upload', '', 69, '', 1, '', 0, 0, '""', '客服图标地址自定义', '客服图标地址自定义', 0, 2),
(null, 'kefu_icon_url2', 'upload', '', 69, '', 1, '', 0, 0, '"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADQAAAA0CAYAAADFeBvrAAAAAXNSR0IArs4c6QAADEZJREFUaEOtWmuMVdUV/va5Z+YOr5m2FxudARRELIxx6EMQGxMGozTWmliBxirWHwajbTAtNFpK69QWmMFBLIpEmybio0aIiTWpsaiZ0aiU0VSRSmVahxTaaJVBy8Awcx97Nfu99znnwgxwfzCXc89jf3ut9a1vrXUYzuBn0m/pAuJoBaEFoAsZMI2A+ogwAUTiSQMMOAJQHwP2EdjuuCbq6ruT/eNMLYOd7o2aNlELcSxlhCUEmswIIBDEX/khgngIE/+IY/r/7jcGxuggI7atJhc/0buC7T6dNZ0yoEmbaE6Zo4MRzZc3kQAkGrl4A4gJeOKYAOUBNIDM+fIkeR7rrmG4q/eu2p5TATZqQJM20/RyCWsZYbG62CzEfRfHBCBlFGEhlmEZA1AtOwArrci2I1+76sOfsH+OBtiIAc3vorh3D9pBWE6catRupt2KOCkLaRDOxRQ8s/DM66VHaheVbspKINo06dL83d2trDwSYCMC1PQQFSplbAdRq91tExPWAlyCkIdNnIi/Ap10Jw1GG9K6pTzHXJNxvdqCrhj5xR+sYv0nA3VSQFMeouZiGc8LxrKL8gPeixfNZAn38QjBWigjnhLxxRQr6riS1uqLI3bt3rvz758I1AkBNT5AV3LCs4wp2vV337qUt0jlUmqXDTh1nY4hdQMdM1mW09f75+nrhdUjxgYisOv//vO6l6qBqgpIWKZUxk4imuAYSm2ZYTVDCo7lQlr2gblrwp33XTGIL7MyEZOGNQyoXG5eNUtlApIxU0KPdDM/kC0bpQnBd7cwjozLOUq3VvMZ0lrOuaPvcjafqT3rY/HYOVkxlQIk2ew97CASGd9Zw7iTWnhIxaGLuZwjyUGTh4iJILkypshD5y3nouJ6d39lHD81KEQRoq4vXz7mqiT7pQA1bqJOqtAKeSP9MEPFNtObRWqLBaxm6Fr/FsadH0Pp/KPuE+Yss1nJFKHXt2HvPeNX+vEUABJJk8rYK/OMZhjf1OqYyyWWkr3jmnhtnAXMV+16mdNCsjDxqQ9bpeFvXsSiEmpys97/WZ1NvgGgxgdoG3FanAx85Sqe2ZP5RecaRw56cTr+0+SgLSFdyX2313s5y7eML5MsyzJs33vPhCXGSvZ8oc0qZdrlM1fwAM/N7C7ZHU+6SQgok8m0S5t49BVCkIQDqzqC8TcvjuO5u1ePldrPAmp6gLqI8/kuv2iKDuLIW7gWo+YGSoyq3Z5RAC6fyjDzLIaJ4xjG54HPBwmfHgPe/Q/H6/sr+PiI52ZBovafYdzQd/UEa0oUrPtvbRNaLSBZApT5uy5XuIANA14bVruJ7+cRI1w7M8LtcyPMOCs6UTKXv73RV8GWN8t46wBPlRXhOpIJPaH3dKzHuWj2O78cv1te23R/pRPACiUplV8b8WhdIdBk2v+0QJ3UQHjwOzFmN54cSBLpH/eU0fZCEcdLYW6zu23FqlYWKUrX1ovYhvfa6ldqQHQAxCdn1zPhjoRJkTD7HIatS2LU5zNz9EktJU7oO8Sx9IkhHD7quZiXxFNFod7PBAMffO/ehilMls0V3mtiwOQfebJJfgEtm2IOMla23Rijoe7UwRjEH/yX46bHjmOw6IrFpOu5ksMwo1cRiw2owQzWtJGWgVceERe7JBgKzLBY0wqYCM//IMZFZ4/ezaqZ7em3S/j1C8OaqU6QYI0ST1fBt7Gm+yubI8IdPm1m1zOhpPn+7AhrFsYjcqmRnsSJsOh3Q9j3UcXWSJFVHlmJ11hIgOfIsehhNmkDf5kRv8KoABeMJkj9wsxJk+dujnHxOWfOOgb0kz1FtL9YTJOScXsTP35+cjLtFTa5s9IH0NSkWg7EolYKJuM31gOv354PNn6oRChxYEKCHMSufz4IfGlcOs4+GyTU1wG5yP32yQDHgvsHgwrXVxqWCDzW9RLqfgHoEAMVrIW0rgokh/RV59PfPI/h8e8puSc++z7huOHJEobLhM3frcH86Tl5vMwJNzw2jD0fcdz0jRirF9baax5+rYiHXi1hWgF45taxGFfrQF2yZgBDmsYDBaFzjlXfRpIZIUysn025rzwMUK1pQ2VWnD5NMobrmhk6r3GAHtlZRmdXWeawRRfHWKt/29/P8a0tQzLIG+oIu1aOs4Cu2TKI/Z+qnPf4LWPw9XPVJojPtx88igP9qkfhi2E/HNx3ExIixliRnZsAZKjRqgBvV8wDFkyP8OgiB6ivn2Ppk8MYLAFbFtXi0vPU4iqcsOzpYby5n2PZZTF+vMBZ6PFdJdz352E0N0bYessY5GNnoQUbjuLQQLKxkiFovaJQyy4J6BARLwg2cQWZ63w6KneV5IVnRfjTrW5xYvEiViocqMmlY6VYJtR6CzaWyDo+OEyYt25AhrDv9r4YTUo0lTMBxtEvAPWB+NSkZewNEqWx8enXfpjHOfWnn1ADZgHwWm8ZP3pqMAQjvcl0Y522k5Suq1nxNwLbz85dX3qZga6wWThRYnsM4vkz8NPWGMvmndk8JJ51y++P4a//EvGoPibhB/pSLV73/4Ku0its6n3lzSB+hyyzvZuomymRmlWECbrdcVs+k46Tuz7S/3fvK+HOPxxPNyVN2Wrd0Ot1+MUmYw+z89YXl4FISh+/hyYBJXpohiikJifC1TMjbLyuVnVHT/Nz5DjhpkeP4sBh0dw3MezawkG/ISFOPfa7jU1bTxcQFXt9MIGlbAfTNRH93HDzJTmsuiokiNFi++wYx7Ktx9D7saBq7Wqm6LOjGU+xyP65OtN1WAm5uGaGPDqtY/gACJNtRvarUVvza/62oxHtjgCuaY7wq6vzGHcKJcS/D3Msf+oYPvzU9MZ9C6lnqjjyOq1GJfjilLGDb60rTJEYzu8odhLnunWVaFpYV9Rb5zU1TKBGjKGpAVg+vxZXN+cCKVPNWv1HOR55dRjPvl1EpWLYyi+5M6YbZi0akO8pEdiGXe0FVeDNaC+2VIi/q0wYWsLvAKXbwMmJHDD5C8DCWTEuOz+HmWfnpFZLxtgzPUVs3DEk5U2yOSI3wLa1/BLC7zp57GfaX5Sb3dPxRVWCi8/0dUNdIMw3Gc13P0udXl87ayG+VFF7TqhhwI1za7ByYZ1c/MaXhrH1DaGmMxogHjHZ5/udnFQnVxeDDN1vtU90TRJppY7iHF6pqDaW1/FP9uTs736PQXznKrjC67nMF60zcuhcMgarnzuOF/eUgzSQRUYm84t7hs3M7JImjtncnWsmhm0saaW1g9vsqDE59DXskxxo6Wyd2lEzkiTCRY2R1GrviITpBXQ6v4U97PQ9fT2nCYNF23vaC+lGo/i5ed3Q9BLRXpAYOYZjE6XznE+HjJg1wAr1oLmfHSBLn0zPZ417+81MZ3XTG9ctAqCUYzWzdrY3ZLeCpeutGeoEVVa48aIbNfp+LwdQ+v5+jPkNfTni99tQifGJnUZ49KtIIZlQw3rMnBNF0Ya/tBeqN+vFiWKc8vGbQzuI89YgHmSCC3061SkyPTOf6quOZDKsqu8vjWelWPZIh4F1jRlbuKq7LRwmZ2qWr6ylAvjxHnA+zUwTUu8TiCsFEXgvVWT7fFb+CsEYJeOkln+N39bSjVCgb3yUn/PKuvrUELmqCJt173AzZ6WdTL/W4oBlTAsSA7B02Zyxy8m3TTRTWlb150v6VQFdEQzELJr3Rkchc3hcFZDYo4vWDF1ZqZSeBcGbs+rixBRVWo1LS5mkFozwXTy4+Ei/iGGuD6zsvWajXgNgAwR2/a71hdEPjc3aWu4daK5Q9Dwn4X6Jga8X5D6YsMOZ1GFGCWRM8yyAxKapxfTFiK6tZhmz3hNayJw0Zy0VBkvHthMZoggHu9VykNp1J2JtwjR1jaFtTeFuUxKFHdA1PpdfnBUzZo2jAiTZr43iwxhoJ2C5UDSZ0sXMkoIcpmKu+tslihLUpoQbBaAUAZvqxk68O8lmSSCjBmQu+Frb0PQSL64FSL685BKschM7K03VM9kx5sRwSDbi5SXGalb5SbMaCP/4iFwu60YtbYNzUCl2COOFg139OpmRBIlXyyx5BOLUuRhj6GYcd+1cr7TZaD+nDMg86Ku/ONoCVl4KTkuIIGdM/qswoVrQbmUSj2nIsOgg49hGLHpClACjBXFGLJT10Lmr/3dBiVErOFpAdCFjmAZO9RDvCqlyeYCBHQF4Hxj2RZztRhx37fpNwxl7RfP/HDNocuIwOs8AAAAASUVORK5CYII="', '客服图标地址圆形', '客服图标地址圆形', 0, 0),
(null, 'kefu_icon_url1', 'upload', '', 69, '', 1, '', 0, 0, '"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADQAAAA0CAYAAADFeBvrAAAAAXNSR0IArs4c6QAADEZJREFUaEOtWmuMVdUV/va5Z+YOr5m2FxudARRELIxx6EMQGxMGozTWmliBxirWHwajbTAtNFpK69QWmMFBLIpEmybio0aIiTWpsaiZ0aiU0VSRSmVahxTaaJVBy8Awcx97Nfu99znnwgxwfzCXc89jf3ut9a1vrXUYzuBn0m/pAuJoBaEFoAsZMI2A+ogwAUTiSQMMOAJQHwP2EdjuuCbq6ruT/eNMLYOd7o2aNlELcSxlhCUEmswIIBDEX/khgngIE/+IY/r/7jcGxuggI7atJhc/0buC7T6dNZ0yoEmbaE6Zo4MRzZc3kQAkGrl4A4gJeOKYAOUBNIDM+fIkeR7rrmG4q/eu2p5TATZqQJM20/RyCWsZYbG62CzEfRfHBCBlFGEhlmEZA1AtOwArrci2I1+76sOfsH+OBtiIAc3vorh3D9pBWE6catRupt2KOCkLaRDOxRQ8s/DM66VHaheVbspKINo06dL83d2trDwSYCMC1PQQFSplbAdRq91tExPWAlyCkIdNnIi/Ap10Jw1GG9K6pTzHXJNxvdqCrhj5xR+sYv0nA3VSQFMeouZiGc8LxrKL8gPeixfNZAn38QjBWigjnhLxxRQr6riS1uqLI3bt3rvz758I1AkBNT5AV3LCs4wp2vV337qUt0jlUmqXDTh1nY4hdQMdM1mW09f75+nrhdUjxgYisOv//vO6l6qBqgpIWKZUxk4imuAYSm2ZYTVDCo7lQlr2gblrwp33XTGIL7MyEZOGNQyoXG5eNUtlApIxU0KPdDM/kC0bpQnBd7cwjozLOUq3VvMZ0lrOuaPvcjafqT3rY/HYOVkxlQIk2ew97CASGd9Zw7iTWnhIxaGLuZwjyUGTh4iJILkypshD5y3nouJ6d39lHD81KEQRoq4vXz7mqiT7pQA1bqJOqtAKeSP9MEPFNtObRWqLBaxm6Fr/FsadH0Pp/KPuE+Yss1nJFKHXt2HvPeNX+vEUABJJk8rYK/OMZhjf1OqYyyWWkr3jmnhtnAXMV+16mdNCsjDxqQ9bpeFvXsSiEmpys97/WZ1NvgGgxgdoG3FanAx85Sqe2ZP5RecaRw56cTr+0+SgLSFdyX2313s5y7eML5MsyzJs33vPhCXGSvZ8oc0qZdrlM1fwAM/N7C7ZHU+6SQgok8m0S5t49BVCkIQDqzqC8TcvjuO5u1ePldrPAmp6gLqI8/kuv2iKDuLIW7gWo+YGSoyq3Z5RAC6fyjDzLIaJ4xjG54HPBwmfHgPe/Q/H6/sr+PiI52ZBovafYdzQd/UEa0oUrPtvbRNaLSBZApT5uy5XuIANA14bVruJ7+cRI1w7M8LtcyPMOCs6UTKXv73RV8GWN8t46wBPlRXhOpIJPaH3dKzHuWj2O78cv1te23R/pRPACiUplV8b8WhdIdBk2v+0QJ3UQHjwOzFmN54cSBLpH/eU0fZCEcdLYW6zu23FqlYWKUrX1ovYhvfa6ldqQHQAxCdn1zPhjoRJkTD7HIatS2LU5zNz9EktJU7oO8Sx9IkhHD7quZiXxFNFod7PBAMffO/ehilMls0V3mtiwOQfebJJfgEtm2IOMla23Rijoe7UwRjEH/yX46bHjmOw6IrFpOu5ksMwo1cRiw2owQzWtJGWgVceERe7JBgKzLBY0wqYCM//IMZFZ4/ezaqZ7em3S/j1C8OaqU6QYI0ST1fBt7Gm+yubI8IdPm1m1zOhpPn+7AhrFsYjcqmRnsSJsOh3Q9j3UcXWSJFVHlmJ11hIgOfIsehhNmkDf5kRv8KoABeMJkj9wsxJk+dujnHxOWfOOgb0kz1FtL9YTJOScXsTP35+cjLtFTa5s9IH0NSkWg7EolYKJuM31gOv354PNn6oRChxYEKCHMSufz4IfGlcOs4+GyTU1wG5yP32yQDHgvsHgwrXVxqWCDzW9RLqfgHoEAMVrIW0rgokh/RV59PfPI/h8e8puSc++z7huOHJEobLhM3frcH86Tl5vMwJNzw2jD0fcdz0jRirF9baax5+rYiHXi1hWgF45taxGFfrQF2yZgBDmsYDBaFzjlXfRpIZIUysn025rzwMUK1pQ2VWnD5NMobrmhk6r3GAHtlZRmdXWeawRRfHWKt/29/P8a0tQzLIG+oIu1aOs4Cu2TKI/Z+qnPf4LWPw9XPVJojPtx88igP9qkfhi2E/HNx3ExIixliRnZsAZKjRqgBvV8wDFkyP8OgiB6ivn2Ppk8MYLAFbFtXi0vPU4iqcsOzpYby5n2PZZTF+vMBZ6PFdJdz352E0N0bYessY5GNnoQUbjuLQQLKxkiFovaJQyy4J6BARLwg2cQWZ63w6KneV5IVnRfjTrW5xYvEiViocqMmlY6VYJtR6CzaWyDo+OEyYt25AhrDv9r4YTUo0lTMBxtEvAPWB+NSkZewNEqWx8enXfpjHOfWnn1ADZgHwWm8ZP3pqMAQjvcl0Y522k5Suq1nxNwLbz85dX3qZga6wWThRYnsM4vkz8NPWGMvmndk8JJ51y++P4a//EvGoPibhB/pSLV73/4Ku0its6n3lzSB+hyyzvZuomymRmlWECbrdcVs+k46Tuz7S/3fvK+HOPxxPNyVN2Wrd0Ot1+MUmYw+z89YXl4FISh+/hyYBJXpohiikJifC1TMjbLyuVnVHT/Nz5DjhpkeP4sBh0dw3MezawkG/ISFOPfa7jU1bTxcQFXt9MIGlbAfTNRH93HDzJTmsuiokiNFi++wYx7Ktx9D7saBq7Wqm6LOjGU+xyP65OtN1WAm5uGaGPDqtY/gACJNtRvarUVvza/62oxHtjgCuaY7wq6vzGHcKJcS/D3Msf+oYPvzU9MZ9C6lnqjjyOq1GJfjilLGDb60rTJEYzu8odhLnunWVaFpYV9Rb5zU1TKBGjKGpAVg+vxZXN+cCKVPNWv1HOR55dRjPvl1EpWLYyi+5M6YbZi0akO8pEdiGXe0FVeDNaC+2VIi/q0wYWsLvAKXbwMmJHDD5C8DCWTEuOz+HmWfnpFZLxtgzPUVs3DEk5U2yOSI3wLa1/BLC7zp57GfaX5Sb3dPxRVWCi8/0dUNdIMw3Gc13P0udXl87ayG+VFF7TqhhwI1za7ByYZ1c/MaXhrH1DaGmMxogHjHZ5/udnFQnVxeDDN1vtU90TRJppY7iHF6pqDaW1/FP9uTs736PQXznKrjC67nMF60zcuhcMgarnzuOF/eUgzSQRUYm84t7hs3M7JImjtncnWsmhm0saaW1g9vsqDE59DXskxxo6Wyd2lEzkiTCRY2R1GrviITpBXQ6v4U97PQ9fT2nCYNF23vaC+lGo/i5ed3Q9BLRXpAYOYZjE6XznE+HjJg1wAr1oLmfHSBLn0zPZ417+81MZ3XTG9ctAqCUYzWzdrY3ZLeCpeutGeoEVVa48aIbNfp+LwdQ+v5+jPkNfTni99tQifGJnUZ49KtIIZlQw3rMnBNF0Ya/tBeqN+vFiWKc8vGbQzuI89YgHmSCC3061SkyPTOf6quOZDKsqu8vjWelWPZIh4F1jRlbuKq7LRwmZ2qWr6ylAvjxHnA+zUwTUu8TiCsFEXgvVWT7fFb+CsEYJeOkln+N39bSjVCgb3yUn/PKuvrUELmqCJt173AzZ6WdTL/W4oBlTAsSA7B02Zyxy8m3TTRTWlb150v6VQFdEQzELJr3Rkchc3hcFZDYo4vWDF1ZqZSeBcGbs+rixBRVWo1LS5mkFozwXTy4+Ei/iGGuD6zsvWajXgNgAwR2/a71hdEPjc3aWu4daK5Q9Dwn4X6Jga8X5D6YsMOZ1GFGCWRM8yyAxKapxfTFiK6tZhmz3hNayJw0Zy0VBkvHthMZoggHu9VykNp1J2JtwjR1jaFtTeFuUxKFHdA1PpdfnBUzZo2jAiTZr43iwxhoJ2C5UDSZ0sXMkoIcpmKu+tslihLUpoQbBaAUAZvqxk68O8lmSSCjBmQu+Frb0PQSL64FSL685BKschM7K03VM9kx5sRwSDbi5SXGalb5SbMaCP/4iFwu60YtbYNzUCl2COOFg139OpmRBIlXyyx5BOLUuRhj6GYcd+1cr7TZaD+nDMg86Ku/ONoCVl4KTkuIIGdM/qswoVrQbmUSj2nIsOgg49hGLHpClACjBXFGLJT10Lmr/3dBiVErOFpAdCFjmAZO9RDvCqlyeYCBHQF4Hxj2RZztRhx37fpNwxl7RfP/HDNocuIwOs8AAAAASUVORK5CYII="', '客服图标地址', '客服图标地址', 0, 0),
(null, 'kefu_icon_type', 'radio', '', 69, '0=>默认图标\n1=>悬浮球\n2=>自定义', 0, '', 0, 0, '"1"', '客服图标', '客服图标', 0, 2);
-- 新增菜单
INSERT INTO `eb_system_menus` (`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `api_url`, `methods`, `params`, `sort`, `is_show`, `is_show_path`, `access`, `menu_path`, `path`, `auth_type`, `header`, `is_header`, `unique_auth`, `is_del`) VALUES
(null, 12, '', 'APP在线升级', 'admin', '', '', '', '', '[]', 0, 1, 0, 1, '/admin/setting/app/version', '12', 1, '', 0, 'setting-app-version', 0),
(null, 165, '', '站点统计', 'admin', '', '', '', '', '[]', 0, 1, 0, 1, '/admin/kefu/statistics', '165', 1, '', 0, 'admin-kefu-statistics', 0),
(null, 165, '', '客服二维码', 'admin', '', '', '', '', '[]', 0, 1, 0, 1, '/admin/kefu/qrcode', '165', 1, '', 0, 'admin-kefu-qrcode', 0),
(null, 165, '', '聊天记录', 'admin', '', '', '', '', '[]', 0, 1, 0, 1, '/admin/kefu/record', '165', 1, '', 0, 'admin-kefu-record', 0),
(null, 1096, '', '设置客服图标', 'admin', '', '', '/api/admin/setting/config/kefu', 'GET', '[]', 0, 0, 1, 1, '', '12/656/1096', 2, '', 0, 'adminapi-setting-set_kf_icon', 0),
(null, 656, '', '客服图标', 'admin', '', '', '', '', '[]', 0, 1, 0, 1, '/admin/setting/system_group_data/kf_icon', '12/656', 1, '', 0, 'setting-system-group_data-kf_icon', 0),
(null, 1094, '', '客服图标', 'admin', '', '', '', '', '[]', 0, 1, 0, 1, '/admin/setting/system_group_data/kf_icon', '12/656/1094', 1, '', 0, 'setting-system-group_data-kf_icon', 0),
(null, 47, '', '系统日志管理员搜索条件', 'admin', '', '', 'api/admin/system/log/search_admin', 'GET', '[]', 0, 0, 0, 1, '', '25/65/47', 2, '', 0, '', 0),
(null, 585, '', '用户标签搜索列表', 'admin', '', '', 'api/admin/user/user_label', 'GET', '[]', 0, 0, 0, 1, '', '9/10/585', 2, '', 0, '', 0),
(null, 47, '', '系统日志', 'admin', '', '', 'api/admin/system/log', 'GET', '[]', 0, 0, 0, 1, '', '25/65/47', 2, '', 0, '', 0),
(null, 1103, '', '保存APP升级', 'admin', '', '', 'api/admin/setting/verison/save/<id>', 'POST', '[]', 0, 0, 0, 1, '', '12/1103', 2, '', 0, '', 0),
(null, 1103, '', '获取创建APP升级包表单', 'admin', '', '', 'api/admin/setting/verison/<id>', 'GET', '[]', 0, 0, 0, 1, '', '12/1103', 2, '', 0, '', 0),
(null, 1103, '', '删除APP升级包', 'admin', '', '', 'api/admin/setting/verison/<id>', 'DELETE', '[]', 0, 0, 0, 1, '', '12/1103', 2, '', 0, '', 0),
(null, 1103, '', '获取APP升级包列表', 'admin', '', '', 'api/admin/setting/verison', 'GET', '[]', 0, 0, 0, 1, '', '12/1103', 2, '', 0, '', 0),
(null, 1102, '', '站点统计', 'admin', '', '', 'api/admin/chat/statistics', 'GET', '[]', 0, 0, 0, 1, '', '165/1102', 2, '', 0, '', 0),
(null, 678, '', '删除自动回复', 'admin', '', '', 'api/admin/chat/reply/<id>', 'DELETE', '[]', 0, 0, 0, 1, '', '165/678', 2, '', 0, '', 0),
(null, 678, '', '保存自动回复', 'admin', '', '', 'api/admin/chat/reply/<id>', 'POST', '[]', 0, 0, 0, 1, '', '165/678', 2, '', 0, '', 0),
(null, 678, '', '获取自动回复表单', 'admin', '', '', 'api/admin/chat/reply/<id>', 'GET', '[]', 0, 0, 0, 1, '', '165/678', 2, '', 0, '', 0),
(null, 678, '', '自动回复列表', 'admin', '', '', 'api/admin/chat/reply', 'GET', '[]', 0, 0, 0, 1, '', '165/678', 2, '', 0, '', 0),
(null, 1101, '', '删除随机客服二维码', 'admin', '', '', 'api/admin/chat/qrcode/<id>', 'DELETE', '[]', 0, 0, 0, 1, '', '165/1101', 2, '', 0, '', 0),
(null, 1101, '', '保存随机客服二维码', 'admin', '', '', 'api/admin/chat/qrcode/<id>', 'POST', '[]', 0, 0, 0, 1, '', '165/1101', 2, '', 0, '', 0),
(null, 1101, '', '获取随机客服二维码表单', 'admin', '', '', 'api/admin/chat/qrcode/<id>', 'GET', '[]', 0, 0, 0, 1, '', '165/1101', 2, '', 0, '', 0),
(null, 1101, '', '获取随机客服二维码', 'admin', '', '', 'api/admin/chat/qrcode', 'GET', '[]', 0, 0, 0, 1, '', '165/1101', 2, '', 0, '', 0),
(null, 1100, '', '获取所有客服', 'admin', '', '', 'api/admin/chat/record_kefu', 'GET', '[]', 0, 0, 0, 1, '', '165/1100', 2, '', 0, '', 0),
(null, 1100, '', '查看所有聊天记录', 'admin', '', '', 'api/admin/chat/record', 'GET', '[]', 0, 0, 0, 1, '', '165/1100', 2, '', 0, '', 0),
(null, 1096, '', '保存客服图标上传配置', 'admin', '', '', 'api/admin/setting/config/kefu', 'POST', '[]', 0, 0, 0, 1, '', '12/656/1096', 2, '', 0, '', 0),
(null, 1008, '', '标签分类移动排序', 'admin', '', '', 'api/admin/user/label/move_cate', 'POST', '[]', 0, 0, 0, 1, '', '9/1008', 2, '', 0, '', 0),
(null, 1008, '', '标签移动排序', 'admin', '', '', 'api/admin/user/label/move', 'POST', '[]', 0, 1, 0, 1, '', '9/1008', 2, '', 0, '', 0);

-- 新增app在线升级表
CREATE TABLE `eb_app_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '更新摘要',
  `version_num` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '版本号',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '下载地址',
  `info` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '更新详细内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  `delete_time` timestamp NULL DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='app在线升级';

CREATE TABLE `eb_site_statistics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '网站来源',
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '来源网址',
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
  `region` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '地区',
  `province` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '省份',
  `browser` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '浏览器',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='站点统计';

-- 2021/12/17
CREATE TABLE `eb_chat_service_group` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '组名',
 `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
 `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='客服分组';

ALTER TABLE `eb_chat_service` ADD `group_id` INT(10) NOT NULL DEFAULT '0' COMMENT '分组id' AFTER `user_id`;

-- 2022/1/18

ALTER TABLE `eb_system_config` CHANGE `value` `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认值';
UPDATE `eb_system_config` SET `value` = '"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHIAAAAoCAYAAAAiyK7sAAAAAXNSR0IArs4c6QAAE45JREFUeF7tXAmUVdWV3ff9qX4VIDNSoEQhIBGzxIGoZXeLoMEBwSmKA47RRCOKQxw6KmqDA9pAqwgkdsc2Igg4BCSNaNQYgahgKwiBxiCoJchc1PiHd7PufO77r8qC7s5KuqkFRfH/f3c4wz77nHNvMezj10H/wnujGI4Ax9EIeSXAKxlYJThvY4Zk4gfO1X85wOQL6jX1IwMTb4g/4jXxAfueeFc9rj6rxlGvqefF03Zw+Zp6Xn3IPBed08xvVqDGVmOqB9W61Xrt/Hofbn6m9iOXJTdgnzcLMOP4e9bzB6yWcVYNhmrGeXXI+fJMIvHKkn9q/+m+qMRIolXP9n6Kd22sD38SgJ3NeTjACNZXnL8xrgVjhSx3rgWmdUzHMYKyiidKLxWYVpYex26mROhCKVordnpjTL7S7fx6ldawzPPkdbtuM7+nWLNLYnTGqLVhsrj9M7YK4C+l0uknloxr+3WrFGPW9E0f/s6TvE1NDrcA/FYe8jZxArOeRwZ1FhkRmt6w8yyjfLUSal2+B2oPMQIzCosKMOqRRLFU+NLIDFJYz9LIQYyDrtPYgfEyX5kONZwh+mhCkaJkXLtO4e28Fpw9Wl7W8bG3xrHab9LRN3pkz0n8HA4+FSHvpmDHSs1BWQTyDBIq6HEe6DbhoJVCqfK4iDIpZFmhqzEpdKtVOVj0YDjGmygsO8NsBoYjzxsYdvuLCQMW4QnkR41c6tg3chMqpLcy8YdvCRi7btmDnV9sSZnNKpJzznpMxj0Av5dxLod0k/oCV/FNRzwbv0j8MGIn8SuqQCtYujFvo378Ko2Z2sTM/NRrma90E9cosnjzyzc0FFvjjQqdxmylSGpMLpQQw6TQGlFgHH8wKMcEbjDc94cHO97PGAVkp9pYRfZ8gWd5NZ7hYXi+9cAo1EjhCJJg4pS2PO2FFhJpbLIWSTzbkIpQkR0KpVLZ+nlpoJaAqOft/HZOvR0tJEqg/DhuxtXKkTozYxriRUgRF75OlKXXJdbjUMDsqXTMEqQx+7KGyjTZ88mct3+5dzYn0a3TZUtvZg1R7yxRpPDEnlMwm4f8fOvm5qkIg6R47ylAfz4KfY7nEAgUnmyCfiSWmTgUjZkGftVGLaFVjJMguT8/+WAME46PeUYpvoFYIZYw7FIuQA0kyqhLmTKJsVbmvoEEAZuz9MFOF0Q9s0SRlVP4vQj5OCssAy0WFhwLEwvxyEkULnSwlL5jhW6e0YJthlR4wiIxykCy9kc/zTBz0DAgIcOFBUswYpCilGErouLBpPFc7cVy/5Z9Nhf7HSyrOSJQ73EM8h4lbSQsBQjGLXuk033UKz1FCmJTZJiLkEtEK/EymptFvIHGGwpjXs4XTQsieWPUK/z5S2OkNRDKdEkcos/b9CMiNJs3WnKp4r+NeXHGYSCRaQO1KYkexBKVSM67l/t3iBRFBCZIy3nLHnEEyMpfpBg781jPuGCnEbgim6TepUNThD2SOGc+YImDofbNMzUpcC0ofyNawDaeNcMUI3E2GicN3KpZaAHBLzIYA6RxyqCPF089phyJk5ZJG+LkihuUXBl5i5hvXqcIRnmKsn2OgLEtZdnOfUxqYhUpIJULSI1Yd3QQW8mgymkmJsZVZRxjjFizFxMcaJTEWatkIpwoBFkG6YiY2peBc0V2vDy2BB5pocAYUWlRwcortgJFcmJC3HyDaKkCRXPaCMSrPY5b9kgXCbFSTqJiU5/Dpwh1eY1AqIUnyxXi8iL1mrVi7cFycPFNMlKajhCYNDDVTHmtFN6juawTeKz32fG1cZC81oUDE0bd3sx7sfOX5KWlz9Pw4pMyV1KIxtbmy4TN5KIMtUG2rLeoAMn1dp/MH+Cc/0zFBStxUkdUC41CKY07NueJxj0dF8pTwIFt1Bhba4E9TS610Fjq6qeRfMvYgzc/LU6YqgzJV52SYsiVHigutVLPafcU/9jqkcjmXBoShVy/kEELE3R+N17c81L+NhxRw1N68Y1Kk6YADyx9qMs9SpFT+EqEkLVTk/PQDTnWRjzPWqXDdTsRqWeecHCAsVUBjq4EEoEaNeQcKzdzPLGkiDfWk3hpYZNCoilOR2OkgUkHP815j3ndwSAxIq9EF7f/mAoShUnSDPD2r2VpFaCrVlICMTBrg4kwnMiarC5iqkUMWLVsYtcjmOhiFEKsp7BorVlTa1r6cgqOBPBIKnJABphwSoAzDwtcwIv56c1PQ9z5mwK+rtUKpXml+XwkX6OpES2ul8YrZ9V0T7RU6LocJHWgHRAp99LOjNITra36nk9h20thtP0ZhZo1O1hVxtTc837erNaQyKT7sO5T+M2c4zFrKV6sI4vz8sgoCyMCYwxJxjH7ggSO6eGJr1mFrtsa4pxnC2jI+SSEwppjkcoD+3UBTu+fwOS3CxYJS+GKo3MFcPyhSSxcVVDDceDkfgkUihy7Gjj2NHJ8ts0IjiMAQ9syjhpZO1H7v7Iqg9+uyWPj9lD+P6qERAD0aB9g0/aizTkv/7sMFq3MY/OuomXHRholCEHGpCSMwrVjsY75GoMMAnYLq5zCn+McF8V5pAdVJSU6ysj8OuTVRzPcPTjRoidG35y2rICJb4et7kfePyyFXh0Yrng+r8MBIQTE6n98YhLDj0ji9KkN1sonnJVGYx7Yuofj/KOTGP1vDfhyVyiVMPLIBG48OYNb5zTiw8+L+E73ALOuqcC85TlsqRGfUY4o/v78dzmp69O/m8RdZ2Zx88w6vL+hgEGHJjH9ijby/1/vUsoXHyyGwLqvig5aiQJ9r1cbMHNZw/Fye5vAiILETHbgZP4mOD9JvqxhTVVsCIMzpqRJBa10eDCsjfitqwIc0qF13mgUuqOe47gn8oLgSiiL9iNHDUzgqkHOOLq3Y2gsADvrbd5gbWPt1yHGzM0hwYA3bijDjN/nMWuFEqAYd8KINBrywKOvNWHs0DReX13EBxuF5yjjHH1cEldWpTFyaj0ePqcMXdoybNimFCKU8a3OAbq0YRgycY/2TuCyE9P40eAyDJ+0B/eMyOL4Pknk1JDyS3htU57j5PG7rWJj+5EayktDRgwKul7tWwJa14Kjr+0nkkBr8Nh1N2jHPj5GtEkDq8ck5WKnvxdiwR9DzL0ogUyS4c5FBeyoB6afnZTKGvV8AQMrGW4/SX1+8LQmbNrl51UGFXp3ZOjXVWwGuOSYpIRMCate/1Ipancjx7INIU7pl8Bdp6Zw5lMNmHReBm+uLeKIHgGqDk2gQwVDOsGQK3AsXlPA7S82OaLHgHYZ4PjeSdwxLIPznqrDsAEpXF6VxhlTajHvugo8sySHFz/IEagFKtsz/H2/JMZ+P4sLn9yjoFgbf1XfJB44rwJDxu+2yNBSP7K0u0O6SxpxSOhZxw6cwvcwDnU8w8RB75iET6VpehL1TLGwTlngw+uVYiYvCfHr1UUsvCyJshTDjfML2F4P/OqCpGSuZz9bxFGVwL1D1eeHzMjhsx1x9VvHUAf2ZJh5SRqjn8th+ecK4xZfl8Edv85j+RciRil9ZJLAnCvLsHFHiF0NwLEHB7h7QRP+4dsJDOyZQH2O474FOWyuMdDnso52GY5pl5TjtU/yWPanAjZs41h4YwW6tmX4xxcbUQw5Fq1SRjRsQBKnHJ6S8768IofhR6ZxWGWArTW2E4Dn3s3JmDzu3HIMnaA80pGZ5qtcBlu9ooxepnjeMWDUCmitAedt1cAOm5Vi1Tf7nnXllvuRH12fQIfs3kFrU4Hj8MfyflFBG5eZv32WY+7oNJZuDHHPb0RsVCteeXsZrpmVw7LPQvu8yHSeviiDuiaOoYclMWZOE17/oxL+naemMfCgAPM/LuDQzgEO6cxw/cxGCbedyoEZo7PYUccx5vkG9O7CcNPQMhzSOcCkxY246/QsXng/h5eW5/DFzhDHfCuBIw9OYsTAFF54L4dZy5rw0A/KZQxesCKHG75fhvkrctiyO8TdI8txyoMaWveqH6nRmJYDKWNmbI+FVlrcbq7OZ1Vt+nHN9CPHDWa44qiW0w6zNPPvvJVF/HSh8qi4Omf7LPDvo9Lo3y3AqGebcFyvQJId8XXWgIRU4tZa5QVP/i6Pz3eqA1U3DU5jQHeGH85swi1DUrj42BSyKYZ8keM/Pw+xYXuIP20NMe/DHBpyDNMvLpNx+qbZDfjF6Cz6dkvgP1blMWlxE2oaOA6vDHDDkAyOOzSJCa82Ys77ObnmqZeWY8n6Ap5bksPEC7NSkfNXNGHMqVnM/zCHrTUhbh9ejtMe3u2RHdXNaWU/UhcMvFqveD5g6yTZYcBJFFoNPCkhR3pszlW9FhJVQIcssPjyBLpUtM4rRZXntKfz+ErDkfeUttyfn5/CQR2YVN6lv8pJhVYeoDzy8kFJvLY2RPVuFZOe+6CA6t0c3+sVYNqFGfzzGzn06RJg7ZYQq78K0amC4dFzMzju4TrcdkpaKu6R1wQD5TiwHZNe2rdbgF4dA2zeHTrSQkLOO/9VwNe7i6gTodVTZBMmXliO/t0T0mP7dU9g2huN2FnHMXZYFmc8KhRJO0sEBZvtx2qJRPuvNr/FW6z7ZJV+qOFMB8DFi5J+HDkV11I/sn9n4OlzEujRrmVl7mzguGx2AZ9sMUcSY4rIjOGwLsDmPRy//0kGl8/MYcUXYrUK4lfdoaB16YaiPnKpGN6Ca8sku1zxRYjlG4t4+aM8ttdxpBPAklsrsGhNASf3S+KiX9Rj0w41nljtLUMzOG1AEquqHZM1yJFNASf0SeHECTUyB5UoxYGpo5VHLvwoh7uGl2P9liJm/LYRj4+uwDtr86ip5/jRkDKMnCTIzn+vH2nio9l/ADZTFgTA8RiNiYb6ejCnY6YXpA17aqYfmE0C132P4dpjA8la6ZeAttkfh3j83SK21ZF3iFX686vJVt2mFLn8C5X3CWMSirxWKPIzlYeaL8Fst+mKUd+ugWSoG3dwZBLAL0eXoX/3AFc/24Dv9kjI9OLtdUJxHDcPzUjPvGNeo2uI66J+z/YMC8e2RdX43ajLuUaBgNZMikHE5u21IQb0TGLzrhC9uwZ48vVG5ArAqOPTuPBxlbK0qlpkOQLxSLs7B8kJURAQJbp8iPWu864/GW3rkBwyNh2xCijtR1akGAb1BHoewDDmhEDmd9e8WMCKakeapOercyka0U3hmnQ7hPf9NIObXs65UxMceOK8NKa+k8eazarLsqcReH9TERcfk8SgXgEG9RLpD3Dvq01on2X4YVUKhRASYu9b0ISrqtKY+nYTFn1SkMZx89A0Bh6cwKz3RHphC8dyXZ0qAtw2rAxV42skrBovfnVsW5Sngdtm1WNXPUeHcsM1OTZtC3HpiRn0PTCBH/+rONno9y2NE+1NP5IW0WWJTgziiuYtU/+SVlQE0w0dlnCjsxmlFjfuxNMSeHJpARt37ls/cuVtGUx5u4BLjxUpS2kxQLy0ZkuI61/IYcaoDFZvDvHupwVJbM49MoWrq5KY/k4Or3xcxKn9Exh/VgabdoT4wYwGHQu5hNazB6ZsSc6tnyGdBA7rnkDVhBrUGmgFcNeZZfjlO034SldyzP6vHZzBWUdl0LUdw8/m1GPxSpd7ev1Q42lxbDamEGM4jS2aixcqJ/H7OcPdcXmkgwGajsR3vP8S/cgz+gcSQk1FxxCzKFwZYyIblj+KOnAhdASjIg3k8kDBXFsAw7e7MJSlgFVfmpKcI3zZJMeJfVN4a01eerWdn5zEo/AuEKBHB4bPd4SobdDFXpPQRVBvb/uRYj8BbWOJxnJdEz5lXJwiJ4HP9Pl0tcfzskgr5pv6kS62EsZGD1WVXC0wEO+8Oerlfj/RL/DTWK6UqvdFWmx/6/3IgLFaRhvL0ivlUQ+MkzBScmzBP6zrd+Jb7kfG9uMiJ9M8GlTSGtrfj7ThKdKPLDnqIRRpDl+B825UsP4hXNJC0SzOQlhcvLThkZT5tGOULM7Ehv39yFb1IxlD/OErIXNxHDJkmMvFcUiPpLiYGM0ro94UPf6h3vevG8i0wfN8WjckZ3/IMYtoP9J0MrxGawzcy/np8RNyWt0ZoTNQ/+yRg+uSNl9Lybt3JFNjecxhZhrHDVFsXT+yheOQhjTZA8re+U9HECn5oXHPpC82zYk0YG1bRnqpq9/+v70fqV3FKHDv+pEY954+PWfk7TmUkrG8vDObc33vwx7QbYm1quEMg1NxVies++9HSrnQTpGSlr7eoDVhFGEcpdl+JGNz/vBQK64MSIgVl3i+xDMAP1/pxNy2+uZ+ZClc6EUb0yH9Tj+PirlSF0EFy1oNsbbQ64zMCcBvFcWt66/5fmRcPzJgwRzWtWPrLvFYeUev1dGk1Cb4fj5ZkkcayRPqb2JvaezUzIgcKVGG61d23HHBmNNt/wfvR6r9B+Lb3l+ro3HOXnTl6OZi2/77kfQEnTlRr4DCNB4oQfQPbDkD1ZImRyopf1CHybAlYNj3i65UmebqOef8VlE0MIF5//1IpziHHBpFaKVHM3THI/TxSoI4fvgSdzvwP3v1nCpUVIByDeEN4BjJwQe4wgHtr7knDCPziJCGW0uM9t+PdHmjSp9WBQwvJf43fhkEVab5Wf56lnw4AsDR4LwSTP5qlkrhsZqU6Yqi3wF3kERKZjGkxs7ZTG4Yl4tqKPLzVol7f4X3IxlqWcirAVbNGaoTjC8vssQry/fx17P8GdYeG88wAMoTAAAAAElFTkSuQmCC"' WHERE `menu_name` = 'kefu_icon_url1';