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