update-1.6.0.sql 1.1 KB

1234567891011121314151617181920212223242526272829303132
  1. use 4dkankan_v4;
  2. DELETE FROM sys_menu WHERE rec_status = 'I';
  3. DELETE from sys_menu WHERE id = 225;
  4. DELETE from sys_menu WHERE id = 99;
  5. DELETE from sys_menu WHERE id = 104;
  6. DELETE from sys_menu WHERE id = 16;
  7. DELETE from sys_menu WHERE id = 23;
  8. DELETE from sys_menu WHERE id = 21;
  9. DELETE from sys_menu WHERE id = 96;
  10. DELETE from sys_menu WHERE id = 247;
  11. DELETE from sys_menu WHERE id = 18;
  12. DELETE from sys_menu WHERE id = 24;
  13. DELETE from sys_menu WHERE id = 20;
  14. CREATE TEMPORARY TABLE temp_menu AS
  15. SELECT id from sys_menu WHERE rec_status = 'A';
  16. DELETE from sys_menu WHERE parent_id not in (SELECT id from temp_menu);
  17. DROP TEMPORARY TABLE temp_menu;
  18. CREATE TEMPORARY TABLE temp_menu AS
  19. SELECT id from sys_menu WHERE rec_status = 'A';
  20. DELETE from sys_menu WHERE parent_id not in (SELECT id from temp_menu);
  21. DROP TEMPORARY TABLE temp_menu;
  22. CREATE TEMPORARY TABLE temp_menu AS
  23. SELECT id from sys_menu WHERE rec_status = 'A';
  24. DELETE from sys_menu WHERE parent_id not in (SELECT id from temp_menu);
  25. DROP TEMPORARY TABLE temp_menu;
  26. DELETE from sys_role_menu WHERE menu_id not in (SELECT id from sys_menu WHERE rec_status = 'A');