-- 已上线
INSERT INTO iot_protocol (id, protocol_code, protocol_name, protocol_file_url, protocol_type, jar_sign, create_time, update_time, protocol_status, del_flag) VALUES (19, 'HTTP', 'HTTP协议', '', 0, 'HTTP协议', '2024-07-11 15:52:30', '2024-07-11 15:53:05', 1, 0);
delete from iot_protocol where id  < 18;


delete from  sys_role_menu where menu_id in (
                                             2169
    ,2170
    ,2171
    ,2172
    ,3269
    );
delete
from sys_role_menu
where menu_id in (
                  2168, 3047, 3048, 3261, 3271, 3046
    );
delete from sys_menu where parent_id in (
                                         2168, 3047, 3048, 3261, 3271, 3046
    );

delete
from sys_menu
where menu_id in (
                  2168, 3047, 3048, 3261, 3271, 3046
    );