-- ---------------------------- -- 该脚本用于删除自动生成的租户管理的权限管理数据。在搭建初始环境的时候，不要执行该脚本。 -- 请仅在租户运营管理系统所在的数据库中执行该脚本。 -- 再次重新生成项目的时候，如果您在生成器中新增了用户权限相关的数据，而之前已经搭建好的数据库中，也存在了 -- 您自己手动插入的权限数据时，可以通过执行该脚本，将现有数据库表中，生成器生成的权限数据删除，删除之后，可以再执行新生成的数据库脚本数据。 -- 数据库链接在橙单生成器中配置信息： -- 应用名称：租户管理后台应用 / TenantAdmin -- 链接名称：租户管理数据库 / TENANT_ADMIN -- 主机信息：localhost:3306 -- 数据库名：apelet_admin -- 用户信息：root / 123456 -- ---------------------------- SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- 租户运营管理系统的菜单数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069603512321; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706632; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024514; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024515; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024516; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024517; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024518; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024519; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706633; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024528; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024529; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024530; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024531; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688181068030545940; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688181068030545941; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706634; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024538; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024539; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024540; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024541; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024542; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024543; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024544; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024545; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024546; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024547; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706635; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024558; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024559; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024560; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024561; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024562; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024563; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024564; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024565; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024566; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706636; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024576; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024577; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024578; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024579; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024580; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706637; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024588; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024589; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024590; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024591; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024592; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706638; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024600; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024601; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024602; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024603; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024604; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024605; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024606; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024607; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706639; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024618; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024619; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024620; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024621; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024622; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706640; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024630; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706641; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024634; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024635; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706642; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706643; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024641; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024642; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024643; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024644; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913465024645; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706644; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218823; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218824; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218825; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218826; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218827; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706645; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218835; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218836; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218837; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218838; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218839; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218840; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218841; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218842; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218843; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218844; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218845; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218846; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218847; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218859; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218860; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218861; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218862; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218866; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218867; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218868; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218869; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706646; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218874; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218875; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218876; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218877; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706647; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218884; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218885; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218886; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218887; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706648; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218894; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218895; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218896; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218897; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218898; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218899; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218900; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687340069607706649; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218910; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218911; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218912; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218913; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687343913469218914; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688176736715411456; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688181068030546164; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688181068030546165; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688181068030546166; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688181068030546167; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688181068030546168; -- ---------------------------- -- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu` WHERE menu_id = 1687821642446671872; DELETE FROM `xy_sys_menu` WHERE menu_id = 1688105082400280576; DELETE FROM `xy_sys_menu` WHERE menu_id = 1687821728979357696; -- ---------------------------- -- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu` WHERE menu_id = 1634009076981567488; DELETE FROM `xy_sys_menu` WHERE menu_id = 1392786950682841088; DELETE FROM `xy_sys_menu` WHERE menu_id = 1392786549942259712; DELETE FROM `xy_sys_menu` WHERE menu_id = 1392786476428693504; -- ---------------------------- -- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu` WHERE menu_id = 1534897180643430400; DELETE FROM `xy_sys_menu` WHERE menu_id = 1517063268609298432; DELETE FROM `xy_sys_menu` WHERE menu_id = 1516291375656603648; DELETE FROM `xy_sys_menu` WHERE menu_id = 1515858207237476352; DELETE FROM `xy_sys_menu` WHERE menu_id = 1515858116057501696; DELETE FROM `xy_sys_menu` WHERE menu_id = 1515857992501694464; -- ---------------------------- -- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu` WHERE menu_id = 1418057714138877952; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418059005175009280; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418057835631087616; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058049951633408; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058115667988480; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058170542067712; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058289182150656; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058515099947008; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058602723151872; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058744037642240; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058844164067328; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418058907674218496; DELETE FROM `xy_sys_menu` WHERE menu_id = 1639626065007611904; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418059167532322816; DELETE FROM `xy_sys_menu` WHERE menu_id = 1418059283920064512; DELETE FROM `xy_sys_menu` WHERE menu_id = 1423161217970606080; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu` WHERE menu_id = 1664443545030754313; DELETE FROM `xy_sys_menu` WHERE menu_id = 1662476315904704535; DELETE FROM `xy_sys_menu` WHERE menu_id = 1662476512349126727; DELETE FROM `xy_sys_menu` WHERE menu_id = 1662476752909238348; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu` WHERE menu_id = 1670044638834065417; DELETE FROM `xy_sys_menu` WHERE menu_id = 1670044840911437855; DELETE FROM `xy_sys_menu` WHERE menu_id = 1670045007127511081; DELETE FROM `xy_sys_menu` WHERE menu_id = 1670045135494184969; COMMIT; -- ---------------------------- -- 租户运营管理系统的菜单和权限字关系数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024514 AND perm_code_id = 1687343913465024521; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024515 AND perm_code_id = 1687343913465024522; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024516 AND perm_code_id = 1687343913465024523; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024517 AND perm_code_id = 1687343913465024524; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024518 AND perm_code_id = 1687343913465024525; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024519 AND perm_code_id = 1687343913465024526; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024528 AND perm_code_id = 1687343913465024533; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024529 AND perm_code_id = 1687343913465024534; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024530 AND perm_code_id = 1687343913465024535; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024531 AND perm_code_id = 1687343913465024536; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181068030545940 AND perm_code_id = 1688181068030545947; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181068030545941 AND perm_code_id = 1688181068030545948; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024540 AND perm_code_id = 1687343913465024549; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024545 AND perm_code_id = 1687343913465024550; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024541 AND perm_code_id = 1687343913465024551; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024542 AND perm_code_id = 1687343913465024552; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024543 AND perm_code_id = 1687343913465024553; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024546 AND perm_code_id = 1687343913465024555; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024547 AND perm_code_id = 1687343913465024556; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024544 AND perm_code_id = 1687343913465024554; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024560 AND perm_code_id = 1687343913465024568; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024564 AND perm_code_id = 1687343913465024569; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024561 AND perm_code_id = 1687343913465024570; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024562 AND perm_code_id = 1687343913465024571; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024563 AND perm_code_id = 1687343913465024572; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024565 AND perm_code_id = 1687343913465024573; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024566 AND perm_code_id = 1687343913465024574; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024576 AND perm_code_id = 1687343913465024582; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024577 AND perm_code_id = 1687343913465024583; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024578 AND perm_code_id = 1687343913465024584; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024579 AND perm_code_id = 1687343913465024585; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024580 AND perm_code_id = 1687343913465024586; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024588 AND perm_code_id = 1687343913465024594; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024589 AND perm_code_id = 1687343913465024595; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024590 AND perm_code_id = 1687343913465024596; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024591 AND perm_code_id = 1687343913465024597; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024592 AND perm_code_id = 1687343913465024598; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024600 AND perm_code_id = 1687343913465024609; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024601 AND perm_code_id = 1687343913465024610; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024602 AND perm_code_id = 1687343913465024611; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024603 AND perm_code_id = 1687343913465024612; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024604 AND perm_code_id = 1687343913465024613; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024605 AND perm_code_id = 1687343913465024614; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024606 AND perm_code_id = 1687343913465024615; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024607 AND perm_code_id = 1687343913465024616; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706639 AND perm_code_id = 1687343913465024624; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706639 AND perm_code_id = 1687343913465024625; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706639 AND perm_code_id = 1687343913465024626; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706639 AND perm_code_id = 1687343913465024627; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706639 AND perm_code_id = 1687343913465024628; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024618 AND perm_code_id = 1687343913465024624; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024619 AND perm_code_id = 1687343913465024625; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024620 AND perm_code_id = 1687343913465024626; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024621 AND perm_code_id = 1687343913465024627; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024622 AND perm_code_id = 1687343913465024628; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024630 AND perm_code_id = 1687343913465024632; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024634 AND perm_code_id = 1687343913465024637; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024635 AND perm_code_id = 1687343913465024638; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024641 AND perm_code_id = 1687343913469218817; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024643 AND perm_code_id = 1687343913469218819; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024642 AND perm_code_id = 1687343913469218818; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024644 AND perm_code_id = 1687343913469218820; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913465024645 AND perm_code_id = 1687343913469218821; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218823 AND perm_code_id = 1687343913469218829; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218825 AND perm_code_id = 1687343913469218831; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218824 AND perm_code_id = 1687343913469218830; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218826 AND perm_code_id = 1687343913469218832; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218827 AND perm_code_id = 1687343913469218833; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218838 AND perm_code_id = 1687343913469218849; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218842 AND perm_code_id = 1687343913469218850; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218845 AND perm_code_id = 1687343913469218851; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218839 AND perm_code_id = 1687343913469218852; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218840 AND perm_code_id = 1687343913469218853; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218841 AND perm_code_id = 1687343913469218854; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218843 AND perm_code_id = 1687343913469218855; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218844 AND perm_code_id = 1687343913469218856; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218846 AND perm_code_id = 1687343913469218857; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218847 AND perm_code_id = 1687343913469218858; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218860 AND perm_code_id = 1687343913469218863; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218861 AND perm_code_id = 1687343913469218864; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218862 AND perm_code_id = 1687343913469218865; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218867 AND perm_code_id = 1687343913469218870; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218868 AND perm_code_id = 1687343913469218871; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218869 AND perm_code_id = 1687343913469218872; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218874 AND perm_code_id = 1687343913469218879; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218876 AND perm_code_id = 1687343913469218881; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218875 AND perm_code_id = 1687343913469218880; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218877 AND perm_code_id = 1687343913469218882; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218884 AND perm_code_id = 1687343913469218889; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218885 AND perm_code_id = 1687343913469218890; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218886 AND perm_code_id = 1687343913469218891; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218887 AND perm_code_id = 1687343913469218892; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218894 AND perm_code_id = 1687343913469218902; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218895 AND perm_code_id = 1687343913469218903; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218896 AND perm_code_id = 1687343913469218904; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218897 AND perm_code_id = 1687343913469218905; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218898 AND perm_code_id = 1687343913469218906; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218899 AND perm_code_id = 1687343913469218907; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218900 AND perm_code_id = 1687343913469218908; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706649 AND perm_code_id = 1687343913469218916; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706649 AND perm_code_id = 1687343913469218917; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706649 AND perm_code_id = 1687343913469218918; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706649 AND perm_code_id = 1687343913469218919; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687340069607706649 AND perm_code_id = 1687343913469218920; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218910 AND perm_code_id = 1687343913469218916; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218911 AND perm_code_id = 1687343913469218917; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218912 AND perm_code_id = 1687343913469218918; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218913 AND perm_code_id = 1687343913469218919; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687343913469218914 AND perm_code_id = 1687343913469218920; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181068030546165 AND perm_code_id = 1688181068030546170; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181068030546166 AND perm_code_id = 1688181068030546171; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181068030546167 AND perm_code_id = 1688181068030546172; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688181068030546168 AND perm_code_id = 1688181068030546173; -- ---------------------------- -- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1687821728979357696 AND perm_code_id = 1696168620435968000; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1688105082400280576 AND perm_code_id = 1696168739763916800; -- ---------------------------- -- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1392786549942259712 AND perm_code_id = 1400638885750378496; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1392786950682841088 AND perm_code_id = 1400639252747784192; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1634009076981567488 AND perm_code_id = 1639622659975155712; -- ---------------------------- -- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1515858116057501696 AND perm_code_id = 1554726081183879168; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1515858116057501696 AND perm_code_id = 1554726340651913216; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1515858207237476352 AND perm_code_id = 1554726466460061696; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1515858207237476352 AND perm_code_id = 1554726553307320320; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1516291375656603648 AND perm_code_id = 1554726716440580096; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1516291375656603648 AND perm_code_id = 1554726790662983680; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1517063268609298432 AND perm_code_id = 1554726893167579136; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1517063268609298432 AND perm_code_id = 1554727015674810368; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1534897180643430400 AND perm_code_id = 1554727289671913472; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1534897180643430400 AND perm_code_id = 1554727372329062400; -- ---------------------------- -- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418057835631087616 AND perm_code_id = 1418046848794365952; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058049951633408 AND perm_code_id = 1418046986677915648; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058115667988480 AND perm_code_id = 1418047095188754432; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058170542067712 AND perm_code_id = 1418047182946177024; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058289182150656 AND perm_code_id = 1418048205177753600; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058602723151872 AND perm_code_id = 1418048335343783936; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058744037642240 AND perm_code_id = 1418049164754817024; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058844164067328 AND perm_code_id = 1418049287106859008; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058907674218496 AND perm_code_id = 1418049398776008704; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1639626065007611904 AND perm_code_id = 1639625791975198720; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418059167532322816 AND perm_code_id = 1418050322282057728; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418058515099947008 AND perm_code_id = 1418050797706416128; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1418059283920064512 AND perm_code_id = 1418057346877231104; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423636498195943424; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423637544578322432; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1662476315904704535 AND perm_code_id = 1662475013351014402; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1662476315904704535 AND perm_code_id = 1662475206364495917; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1662476512349126727 AND perm_code_id = 1662475367882948662; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1662476512349126727 AND perm_code_id = 1662475562930667569; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1662476752909238348 AND perm_code_id = 1662475689648980063; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1662476752909238348 AND perm_code_id = 1662475832217567270; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1670044840911437855 AND perm_code_id = 1670429659038220298; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1670044840911437855 AND perm_code_id = 1670429910209921095; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1670045007127511081 AND perm_code_id = 1670430118444531740; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1670045007127511081 AND perm_code_id = 1670430282261463077; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1670045135494184969 AND perm_code_id = 1670430413509623884; DELETE FROM `xy_sys_menu_perm_code` WHERE menu_id = 1670045135494184969 AND perm_code_id = 1670430593952776203; COMMIT; -- ---------------------------- -- 租户运营管理系统的权限字数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218888; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1761749152527552513; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218857; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218904; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024526; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218849; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218828; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024608; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218831; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024574; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024594; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218848; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024636; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024625; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1693877443275788288; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181068030545947; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024522; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218852; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218855; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218882; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024520; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024571; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024596; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181068030546172; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218864; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1761744616396165120; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218850; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181068030546169; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024572; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218889; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024570; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024610; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218854; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218915; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024631; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024598; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218821; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1761749152527552512; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218918; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024624; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024523; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024568; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024525; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024623; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218906; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024584; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218919; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024613; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024535; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218920; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024612; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024616; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181068030546173; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218870; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024573; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218907; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1693877443271593984; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024554; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024583; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218905; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024597; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024533; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218892; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218903; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024637; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024581; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024586; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1761748252421525504; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024569; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218830; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024553; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024593; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024555; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024611; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024548; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218901; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181068030545948; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218832; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218817; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024627; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218816; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218865; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024532; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218820; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218851; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181068030546170; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218856; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218891; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024628; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024595; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024615; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1761744616404553728; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024536; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218916; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218908; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024549; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024614; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218880; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024638; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024521; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218853; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218917; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024585; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218863; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024556; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218878; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024524; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024582; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024626; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218829; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1688181068030546171; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024534; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024609; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024550; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024551; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218871; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218879; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218833; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024567; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218819; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218890; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218902; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218818; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218872; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024552; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1761748252425719808; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913465024632; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218881; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1687343913469218858; -- ---------------------------- -- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1696168267019718656; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1696168620435968000; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1696168739763916800; -- ---------------------------- -- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1639622363244924928; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1639622659975155712; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1400639252747784192; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1400639030462255104; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1400638885750378496; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1400638673195634688; -- ---------------------------- -- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554727372329062400; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554727289671913472; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554727015674810368; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726893167579136; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726790662983680; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726716440580096; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726553307320320; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726466460061696; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726340651913216; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1554726081183879168; -- ---------------------------- -- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418046729906819072; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048134759583744; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048872671875072; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418050031436435456; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418057020824621056; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1423636498195943424; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418046848794365952; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418046986677915648; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418047095188754432; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418047182946177024; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048205177753600; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418050797706416128; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418048335343783936; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418049164754817024; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418049287106859008; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418049398776008704; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1639625791975198720; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418050322282057728; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1418057346877231104; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1423637544578322432; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1662475013351014402; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1662475206364495917; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1662475367882948662; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1662475562930667569; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1662475689648980063; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1662475832217567270; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1670429659038220298; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1670429910209921095; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1670430118444531740; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1670430282261463077; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1670430413509623884; DELETE FROM `xy_sys_perm_code` WHERE perm_code_id = 1670430593952776203; COMMIT; -- ---------------------------- -- 租户运营管理系统的权限资源模块数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069616095233; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069616095232; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069586735111; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069582540800; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069871947776; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687340069830004736; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1761748046544113664; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1762318923526574080; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915723; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915735; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1688181067959242866; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915745; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915753; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915761; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915767; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915792; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915793; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915803; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915805; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915808; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915815; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915824; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915830; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915836; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915842; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915848; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915870; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915871; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1687343913397915872; -- ---------------------------- -- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_module` WHERE module_id = 1696167234029752320; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1696167285498056704; -- ---------------------------- -- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626463740268544; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626237478539264; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626192725315584; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400626018774945792; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625906245963776; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625585851469824; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625338886656000; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625224646397952; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1413404952566435840; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1400625106979393536; -- ---------------------------- -- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710378980577280; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710446135578624; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710477739659264; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710511973568512; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710548925386752; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1554710587806584832; -- ---------------------------- -- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418028920103505920; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418038955105849344; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418029566533832704; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418029615040958464; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418030256765276160; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418031999276290048; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418051228918616064; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418051634793025536; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1418054414190514176; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1423635643371622400; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_module` WHERE module_id = 1662469830688636976; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1662469967418753033; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1662470021810487368; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1662470082195882057; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1668066310027739145; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670412504703959049; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670412719003533317; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670412799748079638; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670412864587825161; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670422331786264654; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670422373565726725; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670422449839145022; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670424169101131791; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670424400324722720; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670424439415635997; DELETE FROM `xy_sys_perm_module` WHERE module_id = 1670424639966281754; COMMIT; -- ---------------------------- -- 租户运营管理系统的权限资源数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069884530688; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069884530697; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069884530707; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069884530709; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069884530710; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069897113600; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069897113603; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069897113606; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069897113608; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242777; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242778; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242779; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242780; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242781; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242782; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069842587648; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069842587663; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069842587679; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069842587681; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069842587682; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069859364864; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069859364870; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069859364876; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069859364878; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069867753472; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069771284495; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687340069771284494; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915694; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915695; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915696; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761748046552502272; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761748046552502273; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761748046552502274; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761748046552502276; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761749152540135424; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761749152540135426; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761749152540135429; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761749152540135432; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761749152540135436; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761749152540135437; DELETE FROM `xy_sys_perm` WHERE perm_id = 1761749152540135438; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762318923530768384; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762318923530768385; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762318923530768386; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762318923530768388; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762319238103568384; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762319238103568387; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762319238103568391; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762319238103568393; DELETE FROM `xy_sys_perm` WHERE perm_id = 1762319238103568394; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915724; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915725; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915726; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915727; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915728; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915729; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915730; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915731; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915732; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915733; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915734; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915736; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915737; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915738; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915739; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915740; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915741; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915742; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915743; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915744; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242867; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242868; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242869; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242870; DELETE FROM `xy_sys_perm` WHERE perm_id = 1688181067959242871; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915746; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915747; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915748; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915749; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915750; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915751; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915752; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915754; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915755; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915756; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915757; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915758; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915759; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915760; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915762; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915763; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915764; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915765; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915766; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915768; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915769; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915770; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915771; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915772; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915773; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915774; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915775; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915794; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915795; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915796; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915797; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915798; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915799; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915800; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915801; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915802; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915804; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915806; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915807; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915809; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915810; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915811; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915812; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915813; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915814; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915816; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915817; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915818; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915819; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915820; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915821; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915822; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915823; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915825; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915826; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915827; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915828; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915829; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915831; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915832; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915833; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915834; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915835; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915837; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915838; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915839; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915840; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915841; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915843; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915844; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915845; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915846; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915847; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915849; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915850; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915851; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915852; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915853; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915854; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915855; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915856; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915857; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915858; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915859; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915860; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915861; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915862; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915863; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915864; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915865; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915866; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915867; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915868; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915869; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915873; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915874; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915875; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915876; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915877; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915878; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915879; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915880; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915881; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915882; DELETE FROM `xy_sys_perm` WHERE perm_id = 1687343913397915883; -- ---------------------------- -- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167456139120640; DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167558614355968; DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167638708785152; DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167688499367936; DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167785131937792; DELETE FROM `xy_sys_perm` WHERE perm_id = 1696167901570011136; -- ---------------------------- -- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637970863624193; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637970863624192; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637895328403456; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637858414333952; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637822737584128; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637775962705920; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400637740705386496; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636656679129088; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636610403373056; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636571165659136; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636535371468800; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636501900922880; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636338838966272; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636301480300544; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636258107002880; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636217728438272; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636182936686592; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400636031752998912; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635963469729792; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635896461529088; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635827347787776; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635757332271104; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635661106548736; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635581532213248; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635527698321408; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635426808532992; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635378506928128; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635341274091520; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635267726970880; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400635131969933312; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634735549485056; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634693472227328; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634651944423424; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634613151305728; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634559896227840; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634354593435648; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634280308117504; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634100498305024; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400634012745076736; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633922085195776; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633798403559424; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633713376628736; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633612201627648; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633568027217920; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633529678696448; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633437093629952; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400633375525441536; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400632511620452352; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400632438635368448; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400632326538399744; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400632216169484288; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400632108514283520; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400627109692444672; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400626963806162944; DELETE FROM `xy_sys_perm` WHERE perm_id = 1400626748101496832; DELETE FROM `xy_sys_perm` WHERE perm_id = 1639621697092980736; DELETE FROM `xy_sys_perm` WHERE perm_id = 1639621809328361472; DELETE FROM `xy_sys_perm` WHERE perm_id = 1639621889154355200; DELETE FROM `xy_sys_perm` WHERE perm_id = 1639621941444743168; DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405352866615296; DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405313788284928; DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405224021790720; DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405166471745536; DELETE FROM `xy_sys_perm` WHERE perm_id = 1413405061278601216; -- ---------------------------- -- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm` WHERE perm_id = 1554719953398009856; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720095681384448; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554719885425119232; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554719652452503552; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721025319505920; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720307367907328; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720171346628608; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720240657502208; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720039972638720; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554719744387452928; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720458106998784; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720603116670976; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720524880318464; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718811645546496; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718940217741312; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718738668851200; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718534498521088; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554719078365532160; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718884211200000; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718632628457472; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721183985831936; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721309169029120; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554720870532911104; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721246254469120; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721109998309376; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554717789288140800; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554717978610634752; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554717427672027136; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718073343184896; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554718132738723840; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554717855218405376; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554717622459699200; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721637834690560; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721712493301760; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721583023525888; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721479340331008; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721677357617152; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554721528308830208; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723330630619136; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723478400143360; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723275840425984; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723401271087104; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723557882204160; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723557882204161; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722654299099136; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722766639337472; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722515568300032; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722702600704000; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554722594861617152; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724461742133248; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724561985998848; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724415441211392; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724697793368064; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554724517337632768; DELETE FROM `xy_sys_perm` WHERE perm_id = 1555064589178114048; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723744721670144; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723874053033984; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723681328959488; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723827257184256; DELETE FROM `xy_sys_perm` WHERE perm_id = 1554723926486028288; -- ---------------------------- -- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030338508066816; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030386436378624; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030437971791872; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030477918343168; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418030533757112320; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031006660694016; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031078391681024; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031120481521664; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031174604820480; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031219706171392; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031304779239424; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031515207471104; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031648351457280; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031712788549632; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418031801271586816; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032222232907776; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032258429751296; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032300414734336; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032344064856064; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418032382409183232; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418033804987076608; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418033889183535104; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418034243434450944; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418035997727264768; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040510253109248; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040574245605376; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040574245605377; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418040574245605378; DELETE FROM `xy_sys_perm` WHERE perm_id = 1639625448801439744; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051334564745215; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051334564745216; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051485324808192; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418051693639110656; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054128097038336; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054519798894592; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054618176294912; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418054792965525504; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418055060981551104; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418056212146032640; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418056212146032641; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418079603167072256; DELETE FROM `xy_sys_perm` WHERE perm_id = 1418079670594703360; DELETE FROM `xy_sys_perm` WHERE perm_id = 1423635764486344704; DELETE FROM `xy_sys_perm` WHERE perm_id = 1423635851312631808; DELETE FROM `xy_sys_perm` WHERE perm_id = 1423636091033882624; DELETE FROM `xy_sys_perm` WHERE perm_id = 1423984506028691456; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm` WHERE perm_id = 1662470468411588617; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662470598057525257; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662470669847232528; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662470722594799675; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662470785198981129; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662470914807169094; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471004997287954; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471279174746138; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471350532440081; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471444262551557; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471513070108677; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471562634199045; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471718809108513; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471862275276897; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662471950909308982; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472047915171894; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472111404351570; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472185295405127; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472339599654923; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472404607172614; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472530021056549; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472687034826823; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472786741821440; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662472886201352282; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662473085590175759; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662473258219339781; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662473314003583019; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662473376695844918; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662473429950922771; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662473479947026460; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662474326688923659; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662474399225217035; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662474474538139702; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662474539965087750; DELETE FROM `xy_sys_perm` WHERE perm_id = 1662474608852336650; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414186783440950; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414293666889732; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414385153048630; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414453289517136; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414512127213639; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414575461203977; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414635532025867; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670414693094654024; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670415371066146821; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670415830359212072; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670415880158183452; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670415965172531216; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670416037301977142; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670417778139463703; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670418149415059510; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670420141759791174; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670420229664014433; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670420286530387986; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670420838664372319; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670421336574394438; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425153089044498; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425504072597584; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425539862593562; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425591561584711; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425635467558983; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425745605787659; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425812391690258; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425930415210587; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670425970353373216; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670426264311169121; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670426359916134454; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670426488303779851; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670426552342413399; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670426630507462722; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427157802778652; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427220083998774; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427468311298127; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427547352957014; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427712725975115; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427766396289061; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427796213596233; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427862609428554; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670427908130209859; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428014732640298; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428062841307156; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428104079704153; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428142314979356; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428190125850712; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428271570845701; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428315401322521; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428345898106934; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428392391966790; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428437807890432; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428587716509716; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428643253288999; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428676740612127; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428723112837159; DELETE FROM `xy_sys_perm` WHERE perm_id = 1670428758764421130; COMMIT; -- ---------------------------- -- 租户运营管理系统的权限字和权限资源关系数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1761749152527552513 AND perm_id = 1761749152540135424; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1761749152527552513 AND perm_id = 1761749152540135426; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1761749152527552513 AND perm_id = 1761749152540135429; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1761749152527552513 AND perm_id = 1761749152540135432; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1761749152527552513 AND perm_id = 1761749152540135436; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1761749152527552513 AND perm_id = 1761749152540135437; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1761749152527552513 AND perm_id = 1761749152540135438; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024521 AND perm_id = 1687340069859364864; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024521 AND perm_id = 1687340069859364870; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024522 AND perm_id = 1687340069842587648; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024522 AND perm_id = 1687340069897113600; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024522 AND perm_id = 1687343913397915739; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024522 AND perm_id = 1687343913397915727; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024523 AND perm_id = 1687340069859364876; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024523 AND perm_id = 1687340069842587663; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024523 AND perm_id = 1687340069859364878; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024523 AND perm_id = 1687340069897113600; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024523 AND perm_id = 1687343913397915739; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024523 AND perm_id = 1687343913397915727; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024524 AND perm_id = 1687340069842587679; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024525 AND perm_id = 1687340069867753472; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024526 AND perm_id = 1687343913397915696; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024526 AND perm_id = 1687343913397915695; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024526 AND perm_id = 1687343913397915694; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024533 AND perm_id = 1687340069897113600; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024533 AND perm_id = 1687340069897113603; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024534 AND perm_id = 1687340069884530688; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024535 AND perm_id = 1687340069897113606; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024535 AND perm_id = 1687340069884530697; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024535 AND perm_id = 1687340069897113608; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024536 AND perm_id = 1687340069884530707; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545947 AND perm_id = 1688181067959242777; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545947 AND perm_id = 1688181067959242781; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545947 AND perm_id = 1688181067959242778; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545947 AND perm_id = 1688181067959242779; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545947 AND perm_id = 1688181067959242780; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545947 AND perm_id = 1688181067959242782; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545948 AND perm_id = 1688181067959242780; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030545948 AND perm_id = 1688181067959242782; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024549 AND perm_id = 1687343913397915727; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024551 AND perm_id = 1687343913397915724; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024551 AND perm_id = 1687343913397915749; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024552 AND perm_id = 1687343913397915728; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024552 AND perm_id = 1687343913397915725; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024552 AND perm_id = 1687343913397915749; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024554 AND perm_id = 1687343913397915734; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024554 AND perm_id = 1687343913397915733; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024553 AND perm_id = 1687343913397915726; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024550 AND perm_id = 1687343913397915731; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024555 AND perm_id = 1687343913397915729; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024555 AND perm_id = 1687343913397915732; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024556 AND perm_id = 1687343913397915730; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024568 AND perm_id = 1687343913397915739; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024570 AND perm_id = 1687343913397915736; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024571 AND perm_id = 1687343913397915740; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024571 AND perm_id = 1687343913397915737; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024572 AND perm_id = 1687343913397915738; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024569 AND perm_id = 1687343913397915743; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024573 AND perm_id = 1687343913397915741; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024573 AND perm_id = 1687343913397915744; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024574 AND perm_id = 1687343913397915742; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024582 AND perm_id = 1687343913397915749; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024583 AND perm_id = 1687343913397915746; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024583 AND perm_id = 1687343913397915757; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024584 AND perm_id = 1687343913397915750; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024584 AND perm_id = 1687343913397915748; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024585 AND perm_id = 1687343913397915747; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024584 AND perm_id = 1687343913397915757; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024586 AND perm_id = 1687343913397915751; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024586 AND perm_id = 1687343913397915752; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024594 AND perm_id = 1687343913397915757; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024595 AND perm_id = 1687343913397915754; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024595 AND perm_id = 1687343913397915766; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024596 AND perm_id = 1687343913397915758; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024596 AND perm_id = 1687343913397915755; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024596 AND perm_id = 1687343913397915766; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024597 AND perm_id = 1687343913397915756; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024598 AND perm_id = 1687343913397915759; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024598 AND perm_id = 1687343913397915760; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024609 AND perm_id = 1687343913397915765; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024609 AND perm_id = 1687343913397915766; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024609 AND perm_id = 1687343913397915771; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024610 AND perm_id = 1687343913397915762; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024611 AND perm_id = 1687343913397915763; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024612 AND perm_id = 1687343913397915764; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024613 AND perm_id = 1687343913397915768; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024614 AND perm_id = 1687343913397915772; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024614 AND perm_id = 1687343913397915769; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024615 AND perm_id = 1687343913397915770; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024616 AND perm_id = 1687343913397915773; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024616 AND perm_id = 1687343913397915774; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024616 AND perm_id = 1687343913397915775; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915794; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915795; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915796; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915797; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915798; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915799; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915800; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915801; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024624 AND perm_id = 1687343913397915802; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024632 AND perm_id = 1687343913397915804; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024637 AND perm_id = 1687343913397915806; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913465024638 AND perm_id = 1687343913397915807; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218817 AND perm_id = 1687343913397915812; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218818 AND perm_id = 1687343913397915809; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218818 AND perm_id = 1687343913397915813; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218819 AND perm_id = 1687343913397915810; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218819 AND perm_id = 1687343913397915813; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218820 AND perm_id = 1687343913397915811; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218821 AND perm_id = 1687343913397915814; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218829 AND perm_id = 1687343913397915819; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218830 AND perm_id = 1687343913397915816; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218830 AND perm_id = 1687343913397915819; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218831 AND perm_id = 1687343913397915820; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218831 AND perm_id = 1687343913397915817; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218831 AND perm_id = 1687343913397915819; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218832 AND perm_id = 1687343913397915818; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218833 AND perm_id = 1687343913397915821; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218833 AND perm_id = 1687343913397915822; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218833 AND perm_id = 1687343913397915823; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218849 AND perm_id = 1687343913397915852; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218852 AND perm_id = 1687343913397915849; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218852 AND perm_id = 1687343913397915852; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218853 AND perm_id = 1687343913397915853; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218853 AND perm_id = 1687343913397915850; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218853 AND perm_id = 1687343913397915828; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218854 AND perm_id = 1687343913397915851; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218850 AND perm_id = 1687343913397915856; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218851 AND perm_id = 1687343913397915868; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218855 AND perm_id = 1687343913397915854; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218855 AND perm_id = 1687343913397915857; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218856 AND perm_id = 1687343913397915855; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218857 AND perm_id = 1687343913397915866; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218857 AND perm_id = 1687343913397915869; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218858 AND perm_id = 1687343913397915867; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218863 AND perm_id = 1687343913397915860; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218864 AND perm_id = 1687343913397915858; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218864 AND perm_id = 1687343913397915861; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218865 AND perm_id = 1687343913397915859; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218870 AND perm_id = 1687343913397915864; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218871 AND perm_id = 1687343913397915862; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218871 AND perm_id = 1687343913397915865; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218872 AND perm_id = 1687343913397915863; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218879 AND perm_id = 1687343913397915828; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218880 AND perm_id = 1687343913397915825; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218880 AND perm_id = 1687343913397915834; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218881 AND perm_id = 1687343913397915829; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218881 AND perm_id = 1687343913397915827; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218881 AND perm_id = 1687343913397915834; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218882 AND perm_id = 1687343913397915826; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218889 AND perm_id = 1687343913397915834; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218890 AND perm_id = 1687343913397915831; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218890 AND perm_id = 1687343913397915841; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218891 AND perm_id = 1687343913397915835; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218891 AND perm_id = 1687343913397915832; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218891 AND perm_id = 1687343913397915841; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218892 AND perm_id = 1687343913397915833; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218902 AND perm_id = 1687343913397915840; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218902 AND perm_id = 1687343913397915841; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218902 AND perm_id = 1687343913397915846; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218903 AND perm_id = 1687343913397915837; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218904 AND perm_id = 1687343913397915838; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218905 AND perm_id = 1687343913397915839; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218906 AND perm_id = 1687343913397915843; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218907 AND perm_id = 1687343913397915847; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218907 AND perm_id = 1687343913397915844; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218908 AND perm_id = 1687343913397915845; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915873; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915874; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915875; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915876; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915877; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915878; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915879; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915880; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915881; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915882; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913469218916 AND perm_id = 1687343913397915883; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030546170 AND perm_id = 1688181067959242870; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030546171 AND perm_id = 1688181067959242867; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030546172 AND perm_id = 1688181067959242871; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030546172 AND perm_id = 1688181067959242868; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181068030546173 AND perm_id = 1688181067959242869; -- ---------------------------- -- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167456139120640; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167456139120640; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167558614355968; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167558614355968; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167638708785152; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167638708785152; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167688499367936; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167688499367936; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167785131937792; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167785131937792; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167901570011136; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167901570011136; -- ---------------------------- -- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1639622659975155712 AND perm_id = 1400626748101496832; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1639622659975155712 AND perm_id = 1639621697092980736; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1639622659975155712 AND perm_id = 1639621809328361472; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1639622659975155712 AND perm_id = 1639621889154355200; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1639622659975155712 AND perm_id = 1639621941444743168; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400626748101496832; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400626963806162944; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400627109692444672; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632108514283520; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632216169484288; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632326538399744; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632438635368448; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400638885750378496 AND perm_id = 1400632511620452352; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400626748101496832; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400626963806162944; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400627109692444672; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400632108514283520; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400632216169484288; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633375525441536; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633437093629952; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633529678696448; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633568027217920; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633612201627648; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633713376628736; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633798403559424; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633922085195776; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634012745076736; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634100498305024; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634280308117504; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634354593435648; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634559896227840; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634613151305728; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634651944423424; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634693472227328; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634735549485056; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635131969933312; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635267726970880; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635341274091520; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635378506928128; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635426808532992; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635527698321408; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635581532213248; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635661106548736; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635757332271104; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635827347787776; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635896461529088; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635963469729792; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636031752998912; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636182936686592; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636217728438272; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636258107002880; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636301480300544; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636338838966272; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636501900922880; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636535371468800; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636571165659136; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636610403373056; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636656679129088; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637740705386496; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637775962705920; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637822737584128; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637858414333952; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637895328403456; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624193; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405352866615296; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405313788284928; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405224021790720; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405166471745536; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405061278601216; -- ---------------------------- -- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726340651913216 AND perm_id = 1554717427672027136; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726340651913216 AND perm_id = 1554717622459699200; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726340651913216 AND perm_id = 1554717789288140800; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726340651913216 AND perm_id = 1554717855218405376; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726340651913216 AND perm_id = 1554717978610634752; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726340651913216 AND perm_id = 1554718073343184896; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726340651913216 AND perm_id = 1554718132738723840; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554718534498521088; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554718632628457472; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554718738668851200; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554718811645546496; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554718884211200000; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554718940217741312; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554719078365532160; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554719652452503552; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554719744387452928; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554719885425119232; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554719953398009856; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720039972638720; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720095681384448; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720171346628608; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720240657502208; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720307367907328; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720458106998784; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720524880318464; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720603116670976; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554720870532911104; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554721025319505920; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554721109998309376; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554721183985831936; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554721246254469120; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726553307320320 AND perm_id = 1554721309169029120; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726790662983680 AND perm_id = 1554721479340331008; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726790662983680 AND perm_id = 1554721528308830208; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726790662983680 AND perm_id = 1554721583023525888; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726790662983680 AND perm_id = 1554721637834690560; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726790662983680 AND perm_id = 1554721677357617152; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554726790662983680 AND perm_id = 1554721712493301760; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722515568300032; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722594861617152; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722654299099136; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722702600704000; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722766639337472; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723275840425984; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723330630619136; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723401271087104; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723478400143360; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723557882204160; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723557882204161; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723681328959488; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723744721670144; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723827257184256; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723874053033984; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723926486028288; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724415441211392; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724461742133248; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724517337632768; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724561985998848; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724697793368064; -- ---------------------------- -- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051334564745215; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400633375525441536; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635131969933312; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635661106548736; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400636501900922880; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400637740705386496; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1413405061278601216; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418026612762349580; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637775962705920; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418026612762349572; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418026612762349572; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418046848794365952 AND perm_id = 1418030338508066816; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418046986677915648 AND perm_id = 1418030386436378624; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030437971791872; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418047182946177024 AND perm_id = 1418030477918343168; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030533757112320; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048205177753600 AND perm_id = 1418031006660694016; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031078391681024; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031120481521664; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031174604820480; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031219706171392; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031304779239424; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031515207471104; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031648351457280; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031712788549632; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031801271586816; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032222232907776; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032258429751296; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032300414734336; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032344064856064; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032382409183232; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418033804987076608; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418033889183535104; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418034243434450944; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418034243434450944; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418035997727264768; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418035997727264768; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040510253109248; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040574245605377; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040574245605378; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049398776008704 AND perm_id = 1418040574245605376; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1639625791975198720 AND perm_id = 1639625448801439744; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051334564745216; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051485324808192; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418051693639110656; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054128097038336; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054618176294912; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054618176294912; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418055060981551104; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418056212146032640; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079603167072256; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079603167072256; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079670594703360; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079670594703360; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418079670594703360; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1687340069859364864; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418034243434450944; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054618176294912; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635764486344704; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635851312631808; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423636091033882624; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1761749152540135429; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1761749152540135426; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1761749152540135424; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135429; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135426; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135424; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135437; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135436; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1761749152540135432; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1761749152540135437; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1761749152540135437; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1761749152540135436; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475206364495917 AND perm_id = 1662470468411588617; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475206364495917 AND perm_id = 1662470598057525257; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475206364495917 AND perm_id = 1662470669847232528; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475206364495917 AND perm_id = 1662470722594799675; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475206364495917 AND perm_id = 1662470785198981129; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475206364495917 AND perm_id = 1662470914807169094; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475206364495917 AND perm_id = 1662471004997287954; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471279174746138; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471350532440081; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471444262551557; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471513070108677; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471562634199045; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471718809108513; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471862275276897; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662471950909308982; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472047915171894; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472111404351570; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472185295405127; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472339599654923; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472404607172614; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472530021056549; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472687034826823; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472786741821440; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662472886201352282; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662473085590175759; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662473258219339781; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662473314003583019; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662473376695844918; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662473429950922771; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475562930667569 AND perm_id = 1662473479947026460; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475832217567270 AND perm_id = 1662474326688923659; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475832217567270 AND perm_id = 1662474399225217035; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475832217567270 AND perm_id = 1662474474538139702; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475832217567270 AND perm_id = 1662474539965087750; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1662475832217567270 AND perm_id = 1662474608852336650; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414186783440950; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414293666889732; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414385153048630; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414453289517136; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414512127213639; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414575461203977; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414635532025867; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670429910209921095 AND perm_id = 1670414693094654024; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430282261463077 AND perm_id = 1670415371066146821; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430282261463077 AND perm_id = 1670415830359212072; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430282261463077 AND perm_id = 1670415880158183452; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430282261463077 AND perm_id = 1670415965172531216; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430282261463077 AND perm_id = 1670416037301977142; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670417778139463703; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670418149415059510; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670420141759791174; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670420229664014433; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670420286530387986; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670420838664372319; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670421336574394438; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425153089044498; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425504072597584; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425539862593562; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425591561584711; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425635467558983; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425745605787659; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425812391690258; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425930415210587; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670425970353373216; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670426264311169121; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670426359916134454; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670426488303779851; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670426552342413399; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670426630507462722; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427157802778652; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427220083998774; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427468311298127; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427547352957014; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427712725975115; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427766396289061; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427796213596233; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427862609428554; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670427908130209859; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428014732640298; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428062841307156; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428104079704153; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428142314979356; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428190125850712; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428271570845701; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428315401322521; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428345898106934; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428392391966790; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428437807890432; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428587716509716; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428643253288999; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428676740612127; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428723112837159; DELETE FROM `xy_sys_perm_code_perm` WHERE perm_code_id = 1670430593952776203 AND perm_id = 1670428758764421130; COMMIT; -- ---------------------------- -- 租户运营管理系统的白名单权限资源数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/login/getLoginInfo'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysRole/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysRole/listDictByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysUser/list'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysMenu/listMenuDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysPost/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysPost/listDictByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysPost/list'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysDept/listSysDeptPostWithRelation'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysDept/listAllChildDeptIdByParentIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/globalDict/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/globalDict/listDictByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/globalDict/listAll'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysDept/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysDept/listDictByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/sysDept/listDictByParentId'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/login/doLogout'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/mobile/mobileEntry/downloadImage'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/login/changePassword'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/login/changeHeadImage'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/upms/login/downloadHeadImage'; -- ---------------------------- -- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/online/onlineDblink/testConnection'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/online/onlineOperation/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/online/onlineOperation/getColumnRuleCode'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/online/onlineDict/listAllGlobalDict'; -- ---------------------------- -- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDblink/testConnection'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDblink/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDict/listAllGlobalDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDict/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDict/listDictData'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDataset/listDictByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDataset/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportPageGroup/listAll'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDatasetGroup/listAll'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportPage/view'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportDataset/listByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportPrint/listAll'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/reportPrint/print'; -- ---------------------------- -- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowCategory/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowEntry/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowEntry/listAll'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowEntry/viewDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOnlineOperation/startWithBusinessKey'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOnlineOperation/listFlowEntryForm'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOnlineOperation/viewCopyBusinessData'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOnlineOperation/viewDraftData'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewDraftData'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/countRuntimeTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewInitialTaskInfo'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewRuntimeTaskInfo'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewHistoricTaskInfo'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewInitialHistoricTaskInfo'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewTaskUserInfo'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/submitConsign'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/listMultiSignAssignees'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/listFlowTaskComment'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewProcessBpmn'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewHighlightFlowData'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/cancelWorkOrder'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/remindRuntimeTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/listRejectCandidateUserTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/rejectToStartUserTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/rejectRuntimeTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/revokeHistoricTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/freeJumpTo'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/viewCopyBusinessData'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowOperation/listAllUserTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowMessage/getMessageCount'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowMessage/listRemindingTask'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/flow/flowMessage/listCopyMessage'; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDblink/testConnection'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDblink/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDict/listAllGlobalDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDict/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDict/listDictData'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDataset/listDictByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDataset/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDatasetGroup/listAll'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportDataset/listByIds'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportPageGroup/listAll'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportPage/view'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/report/tenantReportPrint/listAll'; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/online/tenantOnlineDblink/testConnection'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/online/tenantOnlineOperation/listDict'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/online/tenantOnlineDict/listAllGlobalDict'; -- ---------------------------- -- 以下记录用于通用扩展，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/commonext/bizwidget/list'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/commonext/bizwidget/view'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/commonext/util/uploadImage'; DELETE FROM `xy_sys_perm_whitelist` WHERE perm_url = '/tenantadmin/commonext/util/downloadImage'; COMMIT; -- ---------------------------- -- 下面的数据为租户运营系统的权限数据 -- ---------------------------- -- ---------------------------- -- 租户运营系统的租户菜单数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069599318017; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706624; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915886; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915887; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915888; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915889; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915890; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706625; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915898; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915899; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915900; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915901; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688181067959243029; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688181067959243030; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706626; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915908; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915909; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915910; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915911; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915912; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915913; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915914; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915915; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915916; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706627; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915926; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915927; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915928; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915929; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915930; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915931; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915932; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915933; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915934; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706628; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915944; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915945; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915946; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915947; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706629; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915954; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915955; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915956; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915957; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915958; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706630; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915966; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687340069607706631; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915970; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687343913397915971; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688176777144307712; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688181067959243107; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688181067959243108; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688181067959243109; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688181067959243110; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688181067959243111; -- ---------------------------- -- 以下记录用于租户业务移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687821642446671872; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1688105082400280576; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1687821728979357696; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1534897180643430400; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1517063268609298432; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1515857992501694464; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1392786950682841088; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1392786476428693504; -- ---------------------------- -- 以下记录用于租户业务工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418057714138877952; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418059005175009280; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418057835631087616; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058049951633408; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058115667988480; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058170542067712; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058289182150656; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058515099947008; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058602723151872; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058744037642240; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058844164067328; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418058907674218496; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1639626065007611904; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418059167532322816; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1418059283920064512; DELETE FROM `xy_sys_tenant_menu` WHERE menu_id = 1423161217970606080; COMMIT; -- ---------------------------- -- 租户运营系统的租户菜单和租户权限字关系数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915886 AND perm_code_id = 1687343913397915892; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915887 AND perm_code_id = 1687343913397915893; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915888 AND perm_code_id = 1687343913397915894; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915889 AND perm_code_id = 1687343913397915895; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915890 AND perm_code_id = 1687343913397915896; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915898 AND perm_code_id = 1687343913397915903; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915899 AND perm_code_id = 1687343913397915904; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915900 AND perm_code_id = 1687343913397915905; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915901 AND perm_code_id = 1687343913397915906; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1688181067959243029 AND perm_code_id = 1688181067959243036; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1688181067959243030 AND perm_code_id = 1688181067959243037; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915910 AND perm_code_id = 1687343913397915918; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915914 AND perm_code_id = 1687343913397915919; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915911 AND perm_code_id = 1687343913397915920; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915912 AND perm_code_id = 1687343913397915921; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915913 AND perm_code_id = 1687343913397915922; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915915 AND perm_code_id = 1687343913397915923; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915916 AND perm_code_id = 1687343913397915924; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915928 AND perm_code_id = 1687343913397915936; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915932 AND perm_code_id = 1687343913397915937; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915929 AND perm_code_id = 1687343913397915938; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915930 AND perm_code_id = 1687343913397915939; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915931 AND perm_code_id = 1687343913397915940; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915933 AND perm_code_id = 1687343913397915941; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915934 AND perm_code_id = 1687343913397915942; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915944 AND perm_code_id = 1687343913397915949; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915945 AND perm_code_id = 1687343913397915950; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915946 AND perm_code_id = 1687343913397915951; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915947 AND perm_code_id = 1687343913397915952; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915960; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915961; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915962; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915963; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687340069607706629 AND perm_code_id = 1687343913397915964; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915954 AND perm_code_id = 1687343913397915960; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915955 AND perm_code_id = 1687343913397915961; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915956 AND perm_code_id = 1687343913397915962; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915957 AND perm_code_id = 1687343913397915963; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915958 AND perm_code_id = 1687343913397915964; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915966 AND perm_code_id = 1687343913397915968; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915970 AND perm_code_id = 1687343913397915973; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687343913397915971 AND perm_code_id = 1687343913397915974; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1688181067959243108 AND perm_code_id = 1688181067959243113; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1688181067959243109 AND perm_code_id = 1688181067959243114; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1688181067959243110 AND perm_code_id = 1688181067959243115; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1688181067959243111 AND perm_code_id = 1688181067959243116; -- ---------------------------- -- 以下记录用于租户业务移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1687821728979357696 AND perm_code_id = 1696168620435968000; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1688105082400280576 AND perm_code_id = 1696168739763916800; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1517063268609298432 AND perm_code_id = 1554726893167579136; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1517063268609298432 AND perm_code_id = 1554727015674810368; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1534897180643430400 AND perm_code_id = 1554727289671913472; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1534897180643430400 AND perm_code_id = 1554727372329062400; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1392786950682841088 AND perm_code_id = 1400639252747784192; -- ---------------------------- -- 以下记录用于租户业务工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418057835631087616 AND perm_code_id = 1418046848794365952; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058049951633408 AND perm_code_id = 1418046986677915648; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058115667988480 AND perm_code_id = 1418047095188754432; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058170542067712 AND perm_code_id = 1418047182946177024; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058289182150656 AND perm_code_id = 1418048205177753600; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058602723151872 AND perm_code_id = 1418048335343783936; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058744037642240 AND perm_code_id = 1418049164754817024; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058844164067328 AND perm_code_id = 1418049287106859008; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058907674218496 AND perm_code_id = 1418049398776008704; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1639626065007611904 AND perm_code_id = 1639625791975198720; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418059167532322816 AND perm_code_id = 1418050322282057728; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418058515099947008 AND perm_code_id = 1418050797706416128; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1418059283920064512 AND perm_code_id = 1418057346877231104; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423636498195943424; DELETE FROM `xy_sys_tenant_menu_perm_code` WHERE menu_id = 1423161217970606080 AND perm_code_id = 1423637544578322432; COMMIT; -- ---------------------------- -- 租户运营系统的租户权限字数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915948; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915937; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915922; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915923; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915917; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915942; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1688181067959243037; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915972; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915961; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915963; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1688181067959243036; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915893; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915902; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1688181067959243113; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915964; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915891; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915939; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1688181067959243115; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915906; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1688181067959243112; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915918; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915940; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915938; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915974; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915967; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915892; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915952; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915924; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915960; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915894; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915936; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915896; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915959; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915951; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915895; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915949; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915962; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1688181067959243114; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915904; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915919; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915920; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915905; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1688181067959243116; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915935; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915921; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915941; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915950; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915968; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915903; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1687343913397915973; -- ---------------------------- -- 以下记录用于租户业务移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1696168267019718656; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1696168620435968000; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1696168739763916800; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1554727372329062400; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1554727289671913472; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1554727015674810368; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1554726893167579136; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1400639252747784192; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1400639030462255104; -- ---------------------------- -- 以下记录用于租户业务工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418046729906819072; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418048134759583744; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418048872671875072; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418050031436435456; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418057020824621056; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1423636498195943424; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418046848794365952; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418046986677915648; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418047095188754432; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418047182946177024; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418048205177753600; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418050797706416128; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418048335343783936; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418049164754817024; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418049287106859008; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418049398776008704; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1639625791975198720; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418050322282057728; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1418057346877231104; DELETE FROM `xy_sys_tenant_perm_code` WHERE perm_code_id = 1423637544578322432; COMMIT; -- ---------------------------- -- 租户运营系统的租户权限资源模块数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687340069616095233; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687340069616095232; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687340069586735111; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687340069729341440; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687340069679009792; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687343913397915697; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687343913397915707; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1688181067959242832; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687343913397915717; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687343913397915776; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687343913397915777; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687343913397915787; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1687343913397915789; -- ---------------------------- -- 以下记录用于租户业务移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1696167234029752320; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1696167285498056704; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1554710378980577280; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1554710548925386752; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1554710587806584832; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1400626463740268544; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1400626237478539264; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1400626192725315584; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1400626018774945792; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1400625906245963776; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1400625338886656000; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1413404952566435840; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1400625106979393536; -- ---------------------------- -- 以下记录用于租户业务工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418028920103505920; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418038955105849344; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418029566533832704; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418029615040958464; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418030256765276160; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418031999276290048; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418051228918616064; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418051634793025536; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1418054414190514176; DELETE FROM `xy_sys_tenant_perm_module` WHERE module_id = 1423635643371622400; COMMIT; -- ---------------------------- -- 租户运营系统的租户权限资源数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069746118656; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069746118666; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069746118677; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069746118679; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069746118680; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069758701568; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069758701571; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069758701574; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069758701576; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242761; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242762; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242763; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242764; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242765; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242766; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069695787008; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069695787024; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069695787041; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069695787043; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069695787044; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069716758528; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069716758534; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069716758540; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069716758542; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069725147136; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069632872465; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687340069632872464; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915698; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915699; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915700; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915701; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915702; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915703; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915704; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915705; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915706; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915708; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915709; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915710; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915711; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915712; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915713; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915714; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915715; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915716; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242833; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242834; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242835; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242836; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1688181067959242837; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915718; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915719; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915720; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915721; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915722; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915781; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915782; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915783; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915784; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915785; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915786; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915788; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915790; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1687343913397915791; -- ---------------------------- -- 以下记录用于租户业务移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1696167456139120640; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1696167558614355968; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1696167638708785152; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1696167688499367936; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1696167785131937792; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1696167901570011136; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723330630619136; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723478400143360; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723275840425984; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723401271087104; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723557882204160; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723557882204161; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554722654299099136; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554722766639337472; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554722515568300032; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554722702600704000; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554722594861617152; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554724461742133248; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554724561985998848; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554724415441211392; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554724697793368064; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554724517337632768; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1555064589178114048; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723744721670144; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723874053033984; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723681328959488; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723827257184256; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1554723926486028288; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400637970863624193; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400637970863624192; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400637895328403456; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400637858414333952; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400637822737584128; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400637775962705920; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400637740705386496; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636656679129088; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636610403373056; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636571165659136; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636535371468800; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636501900922880; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636338838966272; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636301480300544; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636258107002880; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636217728438272; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636182936686592; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400636031752998912; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635963469729792; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635896461529088; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635827347787776; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635757332271104; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635661106548736; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635581532213248; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635527698321408; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635426808532992; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635378506928128; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635341274091520; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635267726970880; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400635131969933312; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634735549485056; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634693472227328; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634651944423424; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634613151305728; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634559896227840; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634354593435648; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634280308117504; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634100498305024; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400634012745076736; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633922085195776; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633798403559424; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633713376628736; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633612201627648; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633568027217920; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633529678696448; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633437093629952; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1400633375525441536; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1413405352866615296; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1413405313788284928; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1413405224021790720; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1413405166471745536; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1413405061278601216; -- ---------------------------- -- 以下记录用于租户业务工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418030338508066816; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418030386436378624; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418030437971791872; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418030477918343168; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418030533757112320; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031006660694016; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031078391681024; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031120481521664; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031174604820480; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031219706171392; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031304779239424; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031515207471104; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031648351457280; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031712788549632; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418031801271586816; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418032222232907776; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418032258429751296; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418032300414734336; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418032344064856064; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418032382409183232; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418033804987076608; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418033889183535104; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418034243434450944; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418035997727264768; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418040510253109248; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418040574245605376; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418040574245605377; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418040574245605378; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1639625448801439744; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418051334564745215; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418051334564745216; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418051485324808192; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418051693639110656; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418054128097038336; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418054519798894592; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418054618176294912; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418054792965525504; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418055060981551104; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418056212146032640; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418056212146032641; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418079603167072256; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1418079670594703360; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1423635764486344704; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1423635851312631808; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1423636091033882624; DELETE FROM `xy_sys_tenant_perm` WHERE perm_id = 1423984506028691456; COMMIT; -- ---------------------------- -- 租户运营系统的租户权限字和权限资源关系数据 -- ---------------------------- BEGIN; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915892 AND perm_id = 1687340069716758528; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915892 AND perm_id = 1687340069716758534; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687340069695787008; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687340069758701568; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687343913397915711; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915893 AND perm_id = 1687343913397915701; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069716758540; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069695787024; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069716758542; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687340069758701568; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687343913397915711; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915894 AND perm_id = 1687343913397915701; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915895 AND perm_id = 1687340069695787041; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915896 AND perm_id = 1687340069725147136; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915903 AND perm_id = 1687340069758701568; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915903 AND perm_id = 1687340069758701571; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915904 AND perm_id = 1687340069746118656; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915905 AND perm_id = 1687340069758701574; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915905 AND perm_id = 1687340069746118666; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915905 AND perm_id = 1687340069758701576; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915906 AND perm_id = 1687340069746118677; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242761; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242765; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242762; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242763; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242764; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243036 AND perm_id = 1688181067959242766; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243037 AND perm_id = 1688181067959242764; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243037 AND perm_id = 1688181067959242766; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915918 AND perm_id = 1687343913397915701; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915920 AND perm_id = 1687343913397915698; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915920 AND perm_id = 1687343913397915721; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915921 AND perm_id = 1687343913397915702; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915921 AND perm_id = 1687343913397915699; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915921 AND perm_id = 1687343913397915721; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915922 AND perm_id = 1687343913397915700; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915919 AND perm_id = 1687343913397915705; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915923 AND perm_id = 1687343913397915703; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915923 AND perm_id = 1687343913397915706; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915924 AND perm_id = 1687343913397915704; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915936 AND perm_id = 1687343913397915711; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915938 AND perm_id = 1687343913397915708; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915939 AND perm_id = 1687343913397915712; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915939 AND perm_id = 1687343913397915709; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915940 AND perm_id = 1687343913397915710; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915937 AND perm_id = 1687343913397915715; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915941 AND perm_id = 1687343913397915713; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915941 AND perm_id = 1687343913397915716; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915942 AND perm_id = 1687343913397915714; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915949 AND perm_id = 1687343913397915721; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915950 AND perm_id = 1687343913397915718; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915951 AND perm_id = 1687343913397915722; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915951 AND perm_id = 1687343913397915720; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915952 AND perm_id = 1687343913397915719; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915781; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915782; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915783; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915784; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915785; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915960 AND perm_id = 1687343913397915786; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915968 AND perm_id = 1687343913397915788; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915973 AND perm_id = 1687343913397915790; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1687343913397915974 AND perm_id = 1687343913397915791; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243113 AND perm_id = 1688181067959242836; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243114 AND perm_id = 1688181067959242833; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243115 AND perm_id = 1688181067959242837; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243115 AND perm_id = 1688181067959242834; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1688181067959243116 AND perm_id = 1688181067959242835; -- ---------------------------- -- 以下记录用于租户业务移动端，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167456139120640; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167456139120640; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167558614355968; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167558614355968; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167638708785152; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167638708785152; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167688499367936; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167688499367936; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167785131937792; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167785131937792; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168620435968000 AND perm_id = 1696167901570011136; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1696168739763916800 AND perm_id = 1696167901570011136; -- ---------------------------- -- 以下记录用于租户业务报表打印，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722515568300032; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722594861617152; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722654299099136; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722702600704000; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554722766639337472; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723275840425984; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723330630619136; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723401271087104; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723478400143360; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723557882204160; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727015674810368 AND perm_id = 1554723557882204161; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723681328959488; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723744721670144; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723827257184256; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723874053033984; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554723926486028288; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724415441211392; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724461742133248; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724517337632768; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724561985998848; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1554727372329062400 AND perm_id = 1554724697793368064; -- ---------------------------- -- 以下记录用于租户业务在线表单，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633375525441536; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633437093629952; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633529678696448; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633568027217920; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633612201627648; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633713376628736; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633798403559424; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400633922085195776; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634012745076736; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634100498305024; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634280308117504; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634354593435648; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634559896227840; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634613151305728; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634651944423424; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634693472227328; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400634735549485056; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635131969933312; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635267726970880; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635341274091520; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635378506928128; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635426808532992; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635527698321408; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635581532213248; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635661106548736; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635757332271104; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635827347787776; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635896461529088; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400635963469729792; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636031752998912; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636182936686592; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636217728438272; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636258107002880; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636301480300544; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636338838966272; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636501900922880; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636535371468800; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636571165659136; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636610403373056; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400636656679129088; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637740705386496; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637775962705920; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637822737584128; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637858414333952; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637895328403456; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624193; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405352866615296; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405313788284928; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405224021790720; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405166471745536; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1400639252747784192 AND perm_id = 1413405061278601216; -- ---------------------------- -- 以下记录用于租户业务工作流，这里的注释，是为了便于老用户进行手动数据补偿。 -- ---------------------------- DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051334564745215; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400633375525441536; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635131969933312; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400635661106548736; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400636501900922880; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1400637740705386496; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1413405061278601216; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418026612762349580; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637775962705920; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1400637970863624192; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418026612762349572; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418026612762349572; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418046848794365952 AND perm_id = 1418030338508066816; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418046986677915648 AND perm_id = 1418030386436378624; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030437971791872; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418047182946177024 AND perm_id = 1418030477918343168; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418047095188754432 AND perm_id = 1418030533757112320; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048205177753600 AND perm_id = 1418031006660694016; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031078391681024; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031120481521664; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031174604820480; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031219706171392; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031304779239424; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031515207471104; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031648351457280; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031712788549632; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418031801271586816; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032222232907776; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032258429751296; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032300414734336; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032344064856064; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418032382409183232; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418033804987076608; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418033889183535104; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418034243434450944; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418034243434450944; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418035997727264768; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418035997727264768; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040510253109248; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040574245605377; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049287106859008 AND perm_id = 1418040574245605378; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049398776008704 AND perm_id = 1418040574245605376; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1639625791975198720 AND perm_id = 1639625448801439744; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051334564745216; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418051485324808192; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418051693639110656; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054128097038336; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054618176294912; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054618176294912; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418049164754817024 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418055060981551104; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418056212146032640; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079603167072256; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079603167072256; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050322282057728 AND perm_id = 1418079670594703360; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418050797706416128 AND perm_id = 1418079670594703360; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418057346877231104 AND perm_id = 1418079670594703360; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1418048335343783936 AND perm_id = 1687340069859364864; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418034243434450944; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054519798894592; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054618176294912; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1418054792965525504; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635764486344704; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423635851312631808; DELETE FROM `xy_sys_tenant_perm_code_perm` WHERE perm_code_id = 1423637544578322432 AND perm_id = 1423636091033882624; COMMIT; SET FOREIGN_KEY_CHECKS = 1;