35 lines
803 B
SQL
35 lines
803 B
SQL
-- 已上线
|
|
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
|
|
);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|