qc_initv1.3.5.sql 439 B

1234567891011
  1. use `qc`;
  2. UPDATE `sys_permission` SET is_deleted = 'Y' WHERE permissionUrl LIKE '/console%' AND is_deleted='N';
  3. UPDATE sys_menu_permission SET is_deleted='Y'
  4. where permission_id in(
  5. select id from `sys_permission` WHERE permissionUrl LIKE '/console%') AND is_deleted='N';
  6. UPDATE sys_role_permission SET is_deleted='Y'
  7. where permission_id in(
  8. select id from `sys_permission` WHERE permissionUrl LIKE '/console%') AND is_deleted='N';