workFlow/zz-resource/db-scripts/rollback-upms-data-script.sql

-- ----------------------------
-- 该脚本用于删除自动生成的用户权限管理数据。在搭建初始环境的时候，不要执行该脚本。
-- 再次重新生成项目的时候，如果您在生成器中新增了用户权限相关的数据，而之前已经搭建好的数据库中，也存在了
-- 您自己手动插入的权限数据时，可以通过执行该脚本，将现有数据库表中，生成器生成的权限数据删除，删除之后，可以再执行新生成的数据库脚本数据。
-- 请仅在下面的数据库链接中执行该脚本。
-- 主数据源 [localhost:3306/workFlow]
-- ----------------------------

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 全部菜单数据
-- ----------------------------
BEGIN;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230815608833;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997440;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107351;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107352;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107353;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107354;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107355;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107356;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997441;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107365;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107366;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107367;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107368;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420056;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420057;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997442;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107375;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107376;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107377;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107378;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107379;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107380;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107381;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107382;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107383;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107384;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997443;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107395;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107396;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107397;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107398;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107399;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997444;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107407;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107408;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107409;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107410;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107411;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997445;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107419;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107420;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107421;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107422;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107423;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107424;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107425;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107426;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997446;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107437;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107438;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107439;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107440;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107441;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997447;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107449;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573942230823997448;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107453;
DELETE FROM `work_sys_menu` WHERE menu_id = 1573943037204107454;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575318269655519232;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420150;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420151;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420152;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420153;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420154;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420155;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420156;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420157;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420158;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575318269659713536;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420168;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420169;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420170;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420171;
DELETE FROM `work_sys_menu` WHERE menu_id = 1575330043381420172;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_menu` WHERE menu_id = 1392786950682841088;
DELETE FROM `work_sys_menu` WHERE menu_id = 1392786549942259712;
DELETE FROM `work_sys_menu` WHERE menu_id = 1392786476428693504;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_menu` WHERE menu_id = 1418057714138877952;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418059005175009280;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418057835631087616;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058049951633408;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058115667988480;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058170542067712;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058289182150656;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058515099947008;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058602723151872;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058744037642240;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058844164067328;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418058907674218496;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418059167532322816;
DELETE FROM `work_sys_menu` WHERE menu_id = 1418059283920064512;
DELETE FROM `work_sys_menu` WHERE menu_id = 1423161217970606080;
COMMIT;

-- ----------------------------
-- 全部权限字数据
-- ----------------------------
BEGIN;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107400;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107405;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420161;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107363;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107390;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107412;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107392;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107427;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107430;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107385;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420166;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420064;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107413;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107455;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107444;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107446;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420063;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107359;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107369;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420174;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107447;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107414;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107357;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420163;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107434;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107415;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420176;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107373;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420173;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107386;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107433;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420164;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107429;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420162;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107457;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107450;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107358;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107417;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107404;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107393;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107443;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107360;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420160;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107362;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107442;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107403;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107432;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107361;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107401;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107445;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420175;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107371;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107428;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107387;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107388;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107372;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107431;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107435;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420177;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420159;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107389;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1575330043381420165;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107391;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107402;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107416;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107451;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107370;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1573943037204107456;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1400639252747784192;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1400639030462255104;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1400638885750378496;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1400638673195634688;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418046729906819072;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418048134759583744;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418048872671875072;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418050031436435456;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418057020824621056;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1423636498195943424;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418046848794365952;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418046986677915648;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418047095188754432;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418047182946177024;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418048205177753600;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418050797706416128;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418048335343783936;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418049164754817024;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418049287106859008;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418049398776008704;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418050322282057728;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1418057346877231104;
DELETE FROM `work_sys_perm_code` WHERE perm_code_id = 1423637544578322432;
COMMIT;

-- ----------------------------
-- 全部菜单和权限字关系数据
-- ----------------------------
BEGIN;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107351 AND perm_code_id = 1573943037204107358;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107352 AND perm_code_id = 1573943037204107359;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107353 AND perm_code_id = 1573943037204107360;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107354 AND perm_code_id = 1573943037204107361;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107355 AND perm_code_id = 1573943037204107362;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107356 AND perm_code_id = 1573943037204107363;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107365 AND perm_code_id = 1573943037204107370;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107366 AND perm_code_id = 1573943037204107371;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107367 AND perm_code_id = 1573943037204107372;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107368 AND perm_code_id = 1573943037204107373;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420056 AND perm_code_id = 1575330043381420063;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420057 AND perm_code_id = 1575330043381420064;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107377 AND perm_code_id = 1573943037204107386;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107382 AND perm_code_id = 1573943037204107387;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107378 AND perm_code_id = 1573943037204107388;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107379 AND perm_code_id = 1573943037204107389;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107380 AND perm_code_id = 1573943037204107390;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107383 AND perm_code_id = 1573943037204107392;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107384 AND perm_code_id = 1573943037204107393;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107381 AND perm_code_id = 1573943037204107391;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107395 AND perm_code_id = 1573943037204107401;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107397 AND perm_code_id = 1573943037204107403;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107396 AND perm_code_id = 1573943037204107402;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107398 AND perm_code_id = 1573943037204107404;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107399 AND perm_code_id = 1573943037204107405;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107407 AND perm_code_id = 1573943037204107413;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107408 AND perm_code_id = 1573943037204107414;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107409 AND perm_code_id = 1573943037204107415;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107410 AND perm_code_id = 1573943037204107416;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107411 AND perm_code_id = 1573943037204107417;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107419 AND perm_code_id = 1573943037204107428;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107420 AND perm_code_id = 1573943037204107429;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107421 AND perm_code_id = 1573943037204107430;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107422 AND perm_code_id = 1573943037204107431;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107423 AND perm_code_id = 1573943037204107432;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107424 AND perm_code_id = 1573943037204107433;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107425 AND perm_code_id = 1573943037204107434;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107426 AND perm_code_id = 1573943037204107435;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573942230823997446 AND perm_code_id = 1573943037204107443;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573942230823997446 AND perm_code_id = 1573943037204107444;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573942230823997446 AND perm_code_id = 1573943037204107445;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573942230823997446 AND perm_code_id = 1573943037204107446;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573942230823997446 AND perm_code_id = 1573943037204107447;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107437 AND perm_code_id = 1573943037204107443;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107438 AND perm_code_id = 1573943037204107444;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107439 AND perm_code_id = 1573943037204107445;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107440 AND perm_code_id = 1573943037204107446;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107441 AND perm_code_id = 1573943037204107447;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107449 AND perm_code_id = 1573943037204107451;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107453 AND perm_code_id = 1573943037204107456;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1573943037204107454 AND perm_code_id = 1573943037204107457;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420152 AND perm_code_id = 1575330043381420160;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420156 AND perm_code_id = 1575330043381420161;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420153 AND perm_code_id = 1575330043381420162;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420154 AND perm_code_id = 1575330043381420163;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420155 AND perm_code_id = 1575330043381420164;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420157 AND perm_code_id = 1575330043381420165;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420158 AND perm_code_id = 1575330043381420166;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420169 AND perm_code_id = 1575330043381420174;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420170 AND perm_code_id = 1575330043381420175;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420171 AND perm_code_id = 1575330043381420176;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1575330043381420172 AND perm_code_id = 1575330043381420177;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1392786549942259712 AND perm_code_id = 1400638885750378496;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1392786950682841088 AND perm_code_id = 1400639252747784192;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------

DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418057835631087616 AND perm_code_id = 1418046848794365952;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058049951633408 AND perm_code_id = 1418046986677915648;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058115667988480 AND perm_code_id = 1418047095188754432;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058170542067712 AND perm_code_id = 1418047182946177024;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058289182150656 AND perm_code_id = 1418048205177753600;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058602723151872 AND perm_code_id = 1418048335343783936;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058744037642240 AND perm_code_id = 1418049164754817024;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058844164067328 AND perm_code_id = 1418049287106859008;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058907674218496 AND perm_code_id = 1418049398776008704;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418059167532322816 AND perm_code_id = 1418050322282057728;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418058515099947008 AND perm_code_id = 1418050797706416128;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1418059283920064512 AND perm_code_id = 1418057346877231104;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423636498195943424;
DELETE FROM `work_sys_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423637544578322432;
COMMIT;

-- ----------------------------
-- 全部权限资源模块数据
-- ----------------------------
BEGIN;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573942230828191745;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573942230828191744;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573942230803025922;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107333;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573942230962409472;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573942230907883520;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107290;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1575330043377225772;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1575330043377225782;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107302;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107310;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107318;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107324;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107334;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107344;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1573943037204107346;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400626463740268544;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400626237478539264;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400626192725315584;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400626018774945792;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400625906245963776;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400625800033603584;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400625585851469824;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400625338886656000;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400625224646397952;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1413404952566435840;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1400625106979393536;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418028920103505920;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418038955105849344;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418029566533832704;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418029615040958464;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418030256765276160;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418031999276290048;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418051228918616064;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418051634793025536;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1418054414190514176;
DELETE FROM `work_sys_perm_module` WHERE module_id = 1423635643371622400;
COMMIT;

-- ----------------------------
-- 全部权限资源数据
-- ----------------------------
BEGIN;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230979186688;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230979186697;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230979186707;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230979186709;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230979186710;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230995963904;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230995963907;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230995963910;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230995963912;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225738;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225739;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225740;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225741;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225742;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225743;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230924660736;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230924660751;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230924660767;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230924660769;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230924660770;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230941437952;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230941437958;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230941437964;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230941437966;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230949826560;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230844968975;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573942230844968974;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107287;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107288;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107289;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107291;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107292;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107293;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107294;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107295;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107296;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107297;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107298;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107299;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107300;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107301;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225773;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225774;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225775;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225776;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225777;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225778;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225779;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225780;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225781;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225783;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225784;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225785;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225786;
DELETE FROM `work_sys_perm` WHERE perm_id = 1575330043377225787;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107303;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107304;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107305;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107306;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107307;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107308;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107309;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107311;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107312;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107313;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107314;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107315;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107316;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107317;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107319;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107320;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107321;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107322;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107323;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107325;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107326;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107327;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107328;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107329;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107330;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107331;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107332;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107335;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107336;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107337;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107338;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107339;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107340;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107341;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107342;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107343;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107345;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107347;
DELETE FROM `work_sys_perm` WHERE perm_id = 1573943037204107348;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm` WHERE perm_id = 1400637970863624193;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400637970863624192;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400637895328403456;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400637858414333952;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400637822737584128;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400637775962705920;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400637740705386496;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636656679129088;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636610403373056;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636571165659136;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636535371468800;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636501900922880;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636338838966272;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636301480300544;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636258107002880;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636217728438272;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636182936686592;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400636031752998912;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635963469729792;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635896461529088;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635827347787776;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635757332271104;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635661106548736;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635581532213248;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635527698321408;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635426808532992;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635378506928128;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635341274091520;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635267726970880;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400635131969933312;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634735549485056;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634693472227328;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634651944423424;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634613151305728;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634559896227840;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634354593435648;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634280308117504;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634100498305024;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400634012745076736;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633922085195776;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633798403559424;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633713376628736;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633612201627648;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633568027217920;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633529678696448;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633437093629952;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633375525441536;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633129688895488;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633077717274624;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400633026181861376;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400632978937221120;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400632924021198848;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400632511620452352;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400632438635368448;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400632326538399744;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400632216169484288;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400632108514283520;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400627109692444672;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400626963806162944;
DELETE FROM `work_sys_perm` WHERE perm_id = 1400626748101496832;
DELETE FROM `work_sys_perm` WHERE perm_id = 1413405352866615296;
DELETE FROM `work_sys_perm` WHERE perm_id = 1413405313788284928;
DELETE FROM `work_sys_perm` WHERE perm_id = 1413405224021790720;
DELETE FROM `work_sys_perm` WHERE perm_id = 1413405166471745536;
DELETE FROM `work_sys_perm` WHERE perm_id = 1413405061278601216;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm` WHERE perm_id = 1418030338508066816;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418030386436378624;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418030437971791872;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418030477918343168;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418030533757112320;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031006660694016;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031078391681024;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031120481521664;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031174604820480;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031219706171392;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031304779239424;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031515207471104;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031648351457280;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031712788549632;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418031801271586816;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418032222232907776;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418032258429751296;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418032300414734336;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418032344064856064;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418032382409183232;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418033804987076608;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418033889183535104;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418034243434450944;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418035997727264768;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418040510253109248;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418040574245605376;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418040574245605377;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418051334564745216;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418051485324808192;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418051693639110656;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418054128097038336;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418054519798894592;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418054618176294912;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418054792965525504;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418055060981551104;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418056212146032640;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418056212146032641;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418079603167072256;
DELETE FROM `work_sys_perm` WHERE perm_id = 1418079670594703360;
DELETE FROM `work_sys_perm` WHERE perm_id = 1423635764486344704;
DELETE FROM `work_sys_perm` WHERE perm_id = 1423635851312631808;
DELETE FROM `work_sys_perm` WHERE perm_id = 1423636091033882624;
DELETE FROM `work_sys_perm` WHERE perm_id = 1423984506028691456;
COMMIT;

-- ----------------------------
-- 全部权限字和权限资源关系数据
-- ----------------------------
BEGIN;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107358 AND perm_id = 1573942230941437952;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107358 AND perm_id = 1573942230941437958;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107359 AND perm_id = 1573942230924660736;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107359 AND perm_id = 1573942230995963904;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107359 AND perm_id = 1575330043377225776;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107359 AND perm_id = 1573943037204107294;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107360 AND perm_id = 1573942230941437964;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107360 AND perm_id = 1573942230924660751;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107360 AND perm_id = 1573942230941437966;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107360 AND perm_id = 1573942230995963904;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107360 AND perm_id = 1575330043377225776;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107360 AND perm_id = 1573943037204107294;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107361 AND perm_id = 1573942230924660767;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107362 AND perm_id = 1573942230949826560;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107363 AND perm_id = 1573943037204107289;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107363 AND perm_id = 1573943037204107288;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107363 AND perm_id = 1573943037204107287;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107370 AND perm_id = 1573942230995963904;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107370 AND perm_id = 1573942230995963907;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107371 AND perm_id = 1573942230979186688;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107372 AND perm_id = 1573942230995963910;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107372 AND perm_id = 1573942230979186697;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107372 AND perm_id = 1573942230995963912;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107373 AND perm_id = 1573942230979186707;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420063 AND perm_id = 1575330043377225738;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420063 AND perm_id = 1575330043377225742;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420063 AND perm_id = 1575330043377225739;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420063 AND perm_id = 1575330043377225740;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420063 AND perm_id = 1575330043377225741;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420063 AND perm_id = 1575330043377225743;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420064 AND perm_id = 1575330043377225741;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420064 AND perm_id = 1575330043377225743;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107386 AND perm_id = 1573943037204107294;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107388 AND perm_id = 1573943037204107291;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107388 AND perm_id = 1573943037204107306;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107389 AND perm_id = 1573943037204107295;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107389 AND perm_id = 1573943037204107292;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107389 AND perm_id = 1573943037204107306;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107391 AND perm_id = 1573943037204107301;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107391 AND perm_id = 1573943037204107300;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107390 AND perm_id = 1573943037204107293;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107387 AND perm_id = 1573943037204107298;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107392 AND perm_id = 1573943037204107296;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107392 AND perm_id = 1573943037204107299;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107393 AND perm_id = 1573943037204107297;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107401 AND perm_id = 1573943037204107306;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107402 AND perm_id = 1573943037204107303;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107402 AND perm_id = 1573943037204107314;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107403 AND perm_id = 1573943037204107307;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107403 AND perm_id = 1573943037204107305;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107403 AND perm_id = 1573943037204107314;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107404 AND perm_id = 1573943037204107304;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107405 AND perm_id = 1573943037204107308;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107405 AND perm_id = 1573943037204107309;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107413 AND perm_id = 1573943037204107314;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107414 AND perm_id = 1573943037204107311;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107414 AND perm_id = 1573943037204107323;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107415 AND perm_id = 1573943037204107315;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107415 AND perm_id = 1573943037204107312;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107415 AND perm_id = 1573943037204107323;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107416 AND perm_id = 1573943037204107313;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107417 AND perm_id = 1573943037204107316;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107417 AND perm_id = 1573943037204107317;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107428 AND perm_id = 1573943037204107322;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107428 AND perm_id = 1573943037204107323;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107428 AND perm_id = 1573943037204107328;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107429 AND perm_id = 1573943037204107319;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107430 AND perm_id = 1573943037204107320;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107431 AND perm_id = 1573943037204107321;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107432 AND perm_id = 1573943037204107325;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107433 AND perm_id = 1573943037204107329;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107433 AND perm_id = 1573943037204107326;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107434 AND perm_id = 1573943037204107327;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107435 AND perm_id = 1573943037204107330;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107435 AND perm_id = 1573943037204107331;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107435 AND perm_id = 1573943037204107332;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107335;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107336;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107337;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107338;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107339;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107340;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107341;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107342;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107443 AND perm_id = 1573943037204107343;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107451 AND perm_id = 1573943037204107345;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107456 AND perm_id = 1573943037204107347;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1573943037204107457 AND perm_id = 1573943037204107348;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420160 AND perm_id = 1575330043377225776;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420162 AND perm_id = 1575330043377225773;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420163 AND perm_id = 1575330043377225777;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420163 AND perm_id = 1575330043377225774;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420164 AND perm_id = 1575330043377225775;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420161 AND perm_id = 1575330043377225780;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420165 AND perm_id = 1575330043377225778;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420165 AND perm_id = 1575330043377225781;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420166 AND perm_id = 1575330043377225779;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420174 AND perm_id = 1575330043377225786;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420175 AND perm_id = 1575330043377225783;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420176 AND perm_id = 1575330043377225787;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420176 AND perm_id = 1575330043377225784;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1575330043381420177 AND perm_id = 1575330043377225785;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400626748101496832;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400626963806162944;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400627109692444672;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632108514283520;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632216169484288;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632326538399744;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632438635368448;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632511620452352;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400626748101496832;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400626963806162944;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400627109692444672;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400632108514283520;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400632216169484288;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400632924021198848;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400632978937221120;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633026181861376;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633077717274624;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633129688895488;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633375525441536;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633437093629952;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633529678696448;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633568027217920;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633612201627648;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633713376628736;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633798403559424;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633922085195776;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634012745076736;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634100498305024;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634280308117504;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634354593435648;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634559896227840;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634613151305728;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634651944423424;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634693472227328;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634735549485056;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635131969933312;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635267726970880;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635341274091520;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635378506928128;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635426808532992;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635527698321408;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635581532213248;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635661106548736;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635757332271104;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635827347787776;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635896461529088;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635963469729792;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636031752998912;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636182936686592;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636217728438272;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636258107002880;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636301480300544;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636338838966272;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636501900922880;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636535371468800;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636571165659136;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636610403373056;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636656679129088;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637740705386496;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637775962705920;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637822737584128;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637858414333952;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637895328403456;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624193;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624192;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405352866615296;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405313788284928;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405224021790720;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405166471745536;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405061278601216;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1400637970863624192;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1400637970863624192;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1400637970863624192;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400633375525441536;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635131969933312;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635661106548736;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400636501900922880;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400637740705386496;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1413405061278601216;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418026612762349580;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637775962705920;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637970863624192;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418026612762349572;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418026612762349572;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418046848794365952 AND perm_id = 1418030338508066816;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418046986677915648 AND perm_id = 1418030386436378624;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030437971791872;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418047182946177024 AND perm_id = 1418030477918343168;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030533757112320;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048205177753600 AND perm_id = 1418031006660694016;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031078391681024;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031120481521664;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031174604820480;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031219706171392;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031304779239424;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031515207471104;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031648351457280;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031712788549632;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031801271586816;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032222232907776;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032258429751296;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032300414734336;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032344064856064;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032382409183232;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418033804987076608;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418033889183535104;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418034243434450944;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418034243434450944;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418035997727264768;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418035997727264768;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040510253109248;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040574245605377;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049398776008704 AND perm_id = 1418040574245605376;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051334564745216;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051485324808192;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418051693639110656;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054128097038336;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418054519798894592;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054519798894592;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054519798894592;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418054519798894592;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054519798894592;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054618176294912;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054618176294912;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054792965525504;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054792965525504;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054792965525504;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418055060981551104;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418056212146032640;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079603167072256;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079603167072256;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079670594703360;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079670594703360;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418079670594703360;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1573942230941437952;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418034243434450944;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054519798894592;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054618176294912;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054792965525504;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635764486344704;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635851312631808;
DELETE FROM `work_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423636091033882624;

DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/getLoginInfo';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysRole/listDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysRole/listDictByIds';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysUser/list';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysMenu/listMenuDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/listDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/listDictByIds';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/list';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listSysDeptPostWithRelation';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listAllChildDeptIdByParentIds';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listDictByIds';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listAll';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDictByIds';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDictByParentId';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/doLogout';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/changePassword';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/changeHeadImage';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/upms/login/downloadHeadImage';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/online/onlineOperation/listDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/online/onlineOperation/getColumnRuleCode';

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowCategory/listDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowEntry/listDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowEntry/viewDict';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOnlineOperation/listFlowEntryForm';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOnlineOperation/viewCopyBusinessData';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOnlineOperation/viewDraftData';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewDraftData';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/countRuntimeTask';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewInitialTaskInfo';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewRuntimeTaskInfo';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewHistoricTaskInfo';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewInitialHistoricTaskInfo';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewTaskUserInfo';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/submitConsign';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/listMultiSignAssignees';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/listFlowTaskComment';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewProcessBpmn';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewHighlightFlowData';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/cancelWorkOrder';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/remindRuntimeTask';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/rejectToStartUserTask';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/listRejectCandidateUserTask';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/rejectRuntimeTask';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/revokeHistoricTask';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowOperation/viewCopyBusinessData';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowMessage/getMessageCount';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowMessage/listRemindingTask';
DELETE FROM `work_sys_perm_whitelist` WHERE perm_url = '/admin/flow/flowMessage/listCopyMessage';
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;