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

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

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 全部菜单数据
-- ----------------------------
BEGIN;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838847082497;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276800;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722849;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722850;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722851;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722852;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722853;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276801;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722855;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722856;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722857;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722858;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722859;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722860;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276802;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722862;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722863;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722864;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722865;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722866;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722867;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722868;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722869;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722870;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276803;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722872;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722873;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722874;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722875;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722876;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722877;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722878;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722879;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722880;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276804;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722882;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722883;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722884;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722885;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722886;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276805;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722888;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722889;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722890;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722891;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276808;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722895;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722896;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722897;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722898;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722899;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276809;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722901;
DELETE FROM `sys_menu` WHERE menu_id = 1831990838851276810;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722903;
DELETE FROM `sys_menu` WHERE menu_id = 1831990886091722904;

-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `sys_menu` WHERE menu_id = 1687821642446671872;
DELETE FROM `sys_menu` WHERE menu_id = 1688105082400280576;
DELETE FROM `sys_menu` WHERE menu_id = 1687821728979357696;

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

-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `sys_menu` WHERE menu_id = 1534897180643430400;
DELETE FROM `sys_menu` WHERE menu_id = 1517063268609298432;
DELETE FROM `sys_menu` WHERE menu_id = 1516291375656603648;
DELETE FROM `sys_menu` WHERE menu_id = 1515858207237476352;
DELETE FROM `sys_menu` WHERE menu_id = 1515858116057501696;
DELETE FROM `sys_menu` WHERE menu_id = 1515857992501694464;

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

SET FOREIGN_KEY_CHECKS = 1;