sunquan
/
apelet_tenant
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
0 Tags
64 MiB
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
apelet_tenant/zz-resource/db-scripts/rollback-upms-data-script.sql

839 lines
66 KiB
Raw Permalink Blame History

-- ----------------------------
-- 该脚本用于删除自动生成的用户权限管理数据。在搭建初始环境的时候，不要执行该脚本。
-- 再次重新生成项目的时候，如果您在生成器中新增了用户权限相关的数据，而之前已经搭建好的数据库中，也存在了
-- 您自己手动插入的权限数据时，可以通过执行该脚本，将现有数据库表中，生成器生成的权限数据删除，删除之后，可以再执行新生成的数据库脚本数据。
-- 数据库链接在橙单生成器中配置信息：
-- 应用名称：租户业务运营应用 / TenantOperation
-- 链接名称：权限管理数据库 / UPMS_ADMIN
-- 主机信息：localhost:3306
-- 数据库名：apelet
-- 用户信息：root / 123456
-- ----------------------------
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- 全部菜单和权限字关系数据
-- ----------------------------
BEGIN;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915886 AND perm_code_id = 1687343913397915892;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915887 AND perm_code_id = 1687343913397915893;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915888 AND perm_code_id = 1687343913397915894;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915889 AND perm_code_id = 1687343913397915895;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915890 AND perm_code_id = 1687343913397915896;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915898 AND perm_code_id = 1687343913397915903;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915899 AND perm_code_id = 1687343913397915904;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915900 AND perm_code_id = 1687343913397915905;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915901 AND perm_code_id = 1687343913397915906;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181067959243029 AND perm_code_id = 1688181067959243036;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181067959243030 AND perm_code_id = 1688181067959243037;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915910 AND perm_code_id = 1687343913397915918;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915914 AND perm_code_id = 1687343913397915919;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915911 AND perm_code_id = 1687343913397915920;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915912 AND perm_code_id = 1687343913397915921;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915913 AND perm_code_id = 1687343913397915922;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915915 AND perm_code_id = 1687343913397915923;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915916 AND perm_code_id = 1687343913397915924;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915928 AND perm_code_id = 1687343913397915936;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915932 AND perm_code_id = 1687343913397915937;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915929 AND perm_code_id = 1687343913397915938;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915930 AND perm_code_id = 1687343913397915939;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915931 AND perm_code_id = 1687343913397915940;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915933 AND perm_code_id = 1687343913397915941;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915934 AND perm_code_id = 1687343913397915942;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915944 AND perm_code_id = 1687343913397915949;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915945 AND perm_code_id = 1687343913397915950;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915946 AND perm_code_id = 1687343913397915951;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915947 AND perm_code_id = 1687343913397915952;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915960;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915961;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915962;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915963;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915964;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915954 AND perm_code_id = 1687343913397915960;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915955 AND perm_code_id = 1687343913397915961;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915956 AND perm_code_id = 1687343913397915962;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915957 AND perm_code_id = 1687343913397915963;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915958 AND perm_code_id = 1687343913397915964;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915966 AND perm_code_id = 1687343913397915968;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915970 AND perm_code_id = 1687343913397915973;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913397915971 AND perm_code_id = 1687343913397915974;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181067959243108 AND perm_code_id = 1688181067959243113;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181067959243109 AND perm_code_id = 1688181067959243114;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181067959243110 AND perm_code_id = 1688181067959243115;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181067959243111 AND perm_code_id = 1688181067959243116;
-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687821728979357696 AND perm_code_id = 1696168620435968000;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688105082400280576 AND perm_code_id = 1696168739763916800;
-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1392786950682841088 AND perm_code_id = 1400639252747784192;
-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1517063268609298432 AND perm_code_id = 1554726893167579136;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1517063268609298432 AND perm_code_id = 1554727015674810368;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1534897180643430400 AND perm_code_id = 1554727289671913472;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1534897180643430400 AND perm_code_id = 1554727372329062400;
-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418057835631087616 AND perm_code_id = 1418046848794365952;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058049951633408 AND perm_code_id = 1418046986677915648;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058115667988480 AND perm_code_id = 1418047095188754432;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058170542067712 AND perm_code_id = 1418047182946177024;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058289182150656 AND perm_code_id = 1418048205177753600;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058602723151872 AND perm_code_id = 1418048335343783936;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058744037642240 AND perm_code_id = 1418049164754817024;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058844164067328 AND perm_code_id = 1418049287106859008;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058907674218496 AND perm_code_id = 1418049398776008704;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1639626065007611904 AND perm_code_id = 1639625791975198720;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418059167532322816 AND perm_code_id = 1418050322282057728;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058515099947008 AND perm_code_id = 1418050797706416128;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418059283920064512 AND perm_code_id = 1418057346877231104;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423636498195943424;
DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423637544578322432;
COMMIT;
-- ----------------------------
-- 全部权限字数据
-- ----------------------------
BEGIN;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915948;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915937;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915922;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915923;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915917;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915942;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181067959243037;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915972;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915961;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915963;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181067959243036;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915893;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915902;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181067959243113;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915964;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915891;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915939;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181067959243115;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915906;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181067959243112;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915918;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915940;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915938;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915974;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915967;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915892;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915952;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915924;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915960;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915894;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915936;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915896;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915959;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915951;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915895;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915949;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915962;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181067959243114;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915904;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915919;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915920;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915905;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181067959243116;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915935;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915921;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915941;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915950;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915968;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915903;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913397915973;
-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1696168267019718656;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1696168620435968000;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1696168739763916800;
-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1400639252747784192;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1400639030462255104;
-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554727372329062400;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554727289671913472;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554727015674810368;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726893167579136;
-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418046729906819072;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048134759583744;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048872671875072;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418050031436435456;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418057020824621056;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1423636498195943424;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418046848794365952;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418046986677915648;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418047095188754432;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418047182946177024;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048205177753600;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418050797706416128;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048335343783936;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418049164754817024;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418049287106859008;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418049398776008704;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1639625791975198720;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418050322282057728;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418057346877231104;
DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1423637544578322432;
COMMIT;
-- ----------------------------
-- 全部权限资源模块数据
-- ----------------------------
BEGIN;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069616095233;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069616095232;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069586735111;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069582540800;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069729341440;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069679009792;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915697;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915707;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1688181067959242832;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915717;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915776;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915777;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915787;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915789;
-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1696167234029752320;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1696167285498056704;
-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626463740268544;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626237478539264;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626192725315584;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626018774945792;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625906245963776;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625338886656000;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1413404952566435840;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625106979393536;
-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710378980577280;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710548925386752;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710587806584832;
-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418028920103505920;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418038955105849344;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418029566533832704;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418029615040958464;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418030256765276160;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418031999276290048;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418051228918616064;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418051634793025536;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418054414190514176;
DELETE FROM `xy_sys_perm_module` WHERE module_id = 1423635643371622400;
COMMIT;
-- ----------------------------
-- 全部权限资源数据
-- ----------------------------
BEGIN;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069746118656;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069746118666;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069746118677;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069746118679;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069746118680;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069758701568;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069758701571;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069758701574;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069758701576;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242761;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242762;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242763;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242764;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242765;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242766;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069695787008;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069695787024;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069695787041;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069695787043;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069695787044;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069716758528;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069716758534;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069716758540;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069716758542;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069725147136;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069632872465;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069632872464;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915698;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915699;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915700;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915701;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915702;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915703;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915704;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915705;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915706;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915708;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915709;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915710;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915711;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915712;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915713;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915714;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915715;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915716;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242833;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242834;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242835;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242836;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242837;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915718;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915719;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915720;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915721;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915722;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915781;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915782;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915783;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915784;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915785;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915786;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915788;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915790;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915791;
-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167456139120640;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167558614355968;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167638708785152;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167688499367936;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167785131937792;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167901570011136;
-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637970863624193;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637970863624192;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637895328403456;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637858414333952;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637822737584128;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637775962705920;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637740705386496;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636656679129088;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636610403373056;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636571165659136;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636535371468800;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636501900922880;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636338838966272;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636301480300544;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636258107002880;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636217728438272;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636182936686592;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636031752998912;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635963469729792;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635896461529088;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635827347787776;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635757332271104;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635661106548736;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635581532213248;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635527698321408;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635426808532992;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635378506928128;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635341274091520;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635267726970880;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635131969933312;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634735549485056;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634693472227328;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634651944423424;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634613151305728;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634559896227840;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634354593435648;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634280308117504;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634100498305024;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634012745076736;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633922085195776;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633798403559424;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633713376628736;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633612201627648;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633568027217920;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633529678696448;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633437093629952;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633375525441536;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405352866615296;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405313788284928;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405224021790720;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405166471745536;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405061278601216;
-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723330630619136;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723478400143360;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723275840425984;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723401271087104;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723557882204160;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723557882204161;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722654299099136;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722766639337472;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722515568300032;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722702600704000;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722594861617152;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724461742133248;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724561985998848;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724415441211392;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724697793368064;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724517337632768;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1555064589178114048;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723744721670144;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723874053033984;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723681328959488;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723827257184256;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723926486028288;
-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030338508066816;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030386436378624;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030437971791872;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030477918343168;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030533757112320;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031006660694016;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031078391681024;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031120481521664;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031174604820480;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031219706171392;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031304779239424;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031515207471104;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031648351457280;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031712788549632;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031801271586816;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032222232907776;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032258429751296;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032300414734336;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032344064856064;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032382409183232;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418033804987076608;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418033889183535104;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418034243434450944;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418035997727264768;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040510253109248;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040574245605376;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040574245605377;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040574245605378;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1639625448801439744;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051334564745215;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051334564745216;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051485324808192;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051693639110656;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054128097038336;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054519798894592;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054618176294912;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054792965525504;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418055060981551104;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418056212146032640;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418056212146032641;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418079603167072256;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1418079670594703360;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1423635764486344704;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1423635851312631808;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1423636091033882624;
DELETE FROM `xy_sys_perm` WHERE perm_id = 1423984506028691456;
COMMIT;
-- ----------------------------
-- 全部权限字和权限资源关系数据
-- ----------------------------
BEGIN;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915892 AND perm_id = 1687340069716758528;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915892 AND perm_id = 1687340069716758534;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687340069695787008;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687340069758701568;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687343913397915711;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687343913397915701;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069716758540;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069695787024;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069716758542;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069758701568;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687343913397915711;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687343913397915701;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915895 AND perm_id = 1687340069695787041;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915896 AND perm_id = 1687340069725147136;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915903 AND perm_id = 1687340069758701568;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915903 AND perm_id = 1687340069758701571;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915904 AND perm_id = 1687340069746118656;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915905 AND perm_id = 1687340069758701574;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915905 AND perm_id = 1687340069746118666;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915905 AND perm_id = 1687340069758701576;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915906 AND perm_id = 1687340069746118677;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242761;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242765;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242762;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242763;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242764;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242766;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243037 AND perm_id = 1688181067959242764;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243037 AND perm_id = 1688181067959242766;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915918 AND perm_id = 1687343913397915701;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915920 AND perm_id = 1687343913397915698;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915920 AND perm_id = 1687343913397915721;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915921 AND perm_id = 1687343913397915702;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915921 AND perm_id = 1687343913397915699;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915921 AND perm_id = 1687343913397915721;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915922 AND perm_id = 1687343913397915700;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915919 AND perm_id = 1687343913397915705;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915923 AND perm_id = 1687343913397915703;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915923 AND perm_id = 1687343913397915706;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915924 AND perm_id = 1687343913397915704;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915936 AND perm_id = 1687343913397915711;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915938 AND perm_id = 1687343913397915708;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915939 AND perm_id = 1687343913397915712;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915939 AND perm_id = 1687343913397915709;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915940 AND perm_id = 1687343913397915710;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915937 AND perm_id = 1687343913397915715;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915941 AND perm_id = 1687343913397915713;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915941 AND perm_id = 1687343913397915716;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915942 AND perm_id = 1687343913397915714;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915949 AND perm_id = 1687343913397915721;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915950 AND perm_id = 1687343913397915718;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915951 AND perm_id = 1687343913397915722;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915951 AND perm_id = 1687343913397915720;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915952 AND perm_id = 1687343913397915719;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915781;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915782;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915783;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915784;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915785;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915786;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915968 AND perm_id = 1687343913397915788;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915973 AND perm_id = 1687343913397915790;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1687343913397915974 AND perm_id = 1687343913397915791;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243113 AND perm_id = 1688181067959242836;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243114 AND perm_id = 1688181067959242833;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243115 AND perm_id = 1688181067959242837;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243115 AND perm_id = 1688181067959242834;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1688181067959243116 AND perm_id = 1688181067959242835;
-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167456139120640;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167456139120640;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167558614355968;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167558614355968;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167638708785152;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167638708785152;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167688499367936;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167688499367936;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167785131937792;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167785131937792;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167901570011136;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167901570011136;
-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633375525441536;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633437093629952;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633529678696448;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633568027217920;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633612201627648;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633713376628736;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633798403559424;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633922085195776;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634012745076736;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634100498305024;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634280308117504;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634354593435648;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634559896227840;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634613151305728;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634651944423424;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634693472227328;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634735549485056;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635131969933312;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635267726970880;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635341274091520;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635378506928128;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635426808532992;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635527698321408;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635581532213248;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635661106548736;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635757332271104;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635827347787776;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635896461529088;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635963469729792;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636031752998912;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636182936686592;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636217728438272;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636258107002880;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636301480300544;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636338838966272;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636501900922880;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636535371468800;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636571165659136;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636610403373056;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636656679129088;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637740705386496;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637775962705920;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637822737584128;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637858414333952;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637895328403456;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624193;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624192;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405352866615296;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405313788284928;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405224021790720;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405166471745536;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405061278601216;
-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722515568300032;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722594861617152;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722654299099136;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722702600704000;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722766639337472;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723275840425984;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723330630619136;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723401271087104;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723478400143360;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723557882204160;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723557882204161;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723681328959488;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723744721670144;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723827257184256;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723874053033984;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723926486028288;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724415441211392;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724461742133248;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724517337632768;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724561985998848;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724697793368064;
-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051334564745215;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1400637970863624192;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1400637970863624192;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1400637970863624192;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400633375525441536;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635131969933312;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635661106548736;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400636501900922880;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400637740705386496;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1413405061278601216;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418026612762349580;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637775962705920;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637970863624192;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418026612762349572;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418026612762349572;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418046848794365952 AND perm_id = 1418030338508066816;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418046986677915648 AND perm_id = 1418030386436378624;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030437971791872;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418047182946177024 AND perm_id = 1418030477918343168;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030533757112320;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048205177753600 AND perm_id = 1418031006660694016;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031078391681024;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031120481521664;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031174604820480;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031219706171392;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031304779239424;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031515207471104;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031648351457280;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031712788549632;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031801271586816;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032222232907776;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032258429751296;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032300414734336;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032344064856064;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032382409183232;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418033804987076608;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418033889183535104;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418034243434450944;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418034243434450944;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418035997727264768;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418035997727264768;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040510253109248;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040574245605377;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040574245605378;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049398776008704 AND perm_id = 1418040574245605376;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1639625791975198720 AND perm_id = 1639625448801439744;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051334564745216;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051485324808192;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418051693639110656;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054128097038336;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418054519798894592;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054519798894592;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054519798894592;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418054519798894592;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054519798894592;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054618176294912;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054618176294912;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054792965525504;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054792965525504;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054792965525504;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418055060981551104;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418056212146032640;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079603167072256;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079603167072256;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079670594703360;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079670594703360;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418079670594703360;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1687340069716758528;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418034243434450944;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054519798894592;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054618176294912;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054792965525504;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635764486344704;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635851312631808;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423636091033882624;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1761749152540135429;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1761749152540135426;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1761749152540135424;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135429;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135426;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135424;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135437;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135436;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135432;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1761749152540135437;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1761749152540135437;
DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1761749152540135436;
COMMIT;
-- ----------------------------
-- 全部白名单权限资源数据
-- ----------------------------
BEGIN;
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/getUaaLogoutUrl';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/getLoginInfo';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysRole/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysRole/listDictByIds';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysUser/list';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysMenu/listMenuDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/listDictByIds';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/list';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listSysDeptPostWithRelation';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listAllChildDeptIdByParentIds';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listDictByIds';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listAll';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDictByIds';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDictByParentId';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/doLogout';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/mobile/mobileEntry/downloadImage';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/changePasswordByUaa';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/changeHeadImage';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/downloadHeadImage';
-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/online/onlineOperation/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/online/onlineOperation/getColumnRuleCode';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/online/onlineDict/listAllGlobalDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/online/onlineDict/list';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/online/onlineDblink/list';
-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowCategory/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowEntry/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowEntry/listAll';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowEntry/viewDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOnlineOperation/startWithBusinessKey';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOnlineOperation/listFlowEntryForm';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOnlineOperation/viewCopyBusinessData';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOnlineOperation/viewDraftData';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewDraftData';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/countRuntimeTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewInitialTaskInfo';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewRuntimeTaskInfo';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewHistoricTaskInfo';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewInitialHistoricTaskInfo';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewTaskUserInfo';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/submitConsign';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/listMultiSignAssignees';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/listFlowTaskComment';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewProcessBpmn';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewHighlightFlowData';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/cancelWorkOrder';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/remindRuntimeTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/listRejectCandidateUserTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/rejectToStartUserTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/rejectRuntimeTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/revokeHistoricTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/freeJumpTo';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewCopyBusinessData';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/listAllUserTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowMessage/getMessageCount';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowMessage/listRemindingTask';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowMessage/listCopyMessage';
-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDblink/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDict/listAllGlobalDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDict/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDict/listDictData';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDataset/listDictByIds';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDataset/listDict';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDataset/listByIds';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDataset/view';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportDatasetGroup/listAll';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportPageGroup/listAll';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportPage/view';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportPrint/listAll';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/report/reportPrint/print';
-- ----------------------------
-- 以下记录用于通用扩展，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/commonext/bizwidget/list';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/commonext/bizwidget/view';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/commonext/util/uploadImage';
DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/admin/commonext/util/downloadImage';
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;