ankaibeiProjectManagement/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;