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