4dkankan-center-manage/doc/update-1.5.1.sql

use 4dkankan_v4;
INSERT into sys_role_menu (role_id,menu_id) VALUES (45,277);
INSERT into sys_role_menu (role_id,menu_id) VALUES (45,278);
INSERT into sys_role_menu (role_id,menu_id) VALUES (45,279);
INSERT into sys_role_menu (role_id,menu_id) VALUES (45,280);
INSERT into sys_role_menu (role_id,menu_id) VALUES (45,281);


INSERT into sys_role_menu (role_id,menu_id) VALUES (48,277);
INSERT into sys_role_menu (role_id,menu_id) VALUES (48,278);
INSERT into sys_role_menu (role_id,menu_id) VALUES (48,279);
INSERT into sys_role_menu (role_id,menu_id) VALUES (48,280);
INSERT into sys_role_menu (role_id,menu_id) VALUES (48,281);

DELETE FROM sys_menu WHERE rec_status = 'I';

DELETE from sys_menu WHERE id = 225;
DELETE from sys_menu WHERE id = 99;
DELETE from sys_menu WHERE id = 104;
DELETE from sys_menu WHERE id = 16;
DELETE from sys_menu WHERE id = 23;
DELETE from sys_menu WHERE id = 21;
DELETE from sys_menu WHERE id = 96;
DELETE from sys_menu WHERE id = 247;
DELETE from sys_menu WHERE id = 18;
DELETE from sys_menu WHERE id = 24;
DELETE from sys_menu WHERE id = 20;

CREATE TEMPORARY TABLE temp_menu AS
SELECT id from sys_menu WHERE rec_status = 'A';
DELETE from sys_menu  WHERE parent_id not in (SELECT id from temp_menu);
DROP TEMPORARY TABLE temp_menu;

CREATE TEMPORARY TABLE temp_menu AS
SELECT id from sys_menu WHERE rec_status = 'A';
DELETE from sys_menu  WHERE parent_id not in (SELECT id from temp_menu);
DROP TEMPORARY TABLE temp_menu;

CREATE TEMPORARY TABLE temp_menu AS
SELECT id from sys_menu WHERE rec_status = 'A';
DELETE from sys_menu  WHERE parent_id not in (SELECT id from temp_menu);
DROP TEMPORARY TABLE temp_menu;


DELETE from sys_role_menu WHERE menu_id not in (SELECT id from sys_menu WHERE rec_status = 'A');