-- 添加信道扫描表 TB_channel_scan 20240605
-- tb_on_send_message_record
---TB_setting 添加新参数
INSERT INTO `TB_setting`( `title`, `name`, `value`, `sort`, `created_at`, `updated_at`) VALUES ('录音文件保留时间(单位为 天)', 'record_save', '180', 1, '1662361259', '1662361259');

--  后台菜单中英文优化 TB_admin_menu 20250109

ALTER TABLE TB_admin_menu ADD title_en varchar(50) not null comment '菜单英文名';

UPDATE `TB_admin_menu` SET `title_en` = 'Information Center' WHERE `id` = 1;
UPDATE `TB_admin_menu` SET `title_en` = 'Back-stage Management' WHERE `id` = 2;
UPDATE `TB_admin_menu` SET `title_en` = 'User Management' WHERE `id` = 3;
UPDATE `TB_admin_menu` SET `title_en` = 'Role Management' WHERE `id` = 4;
UPDATE `TB_admin_menu` SET `title_en` = 'Rights Management' WHERE `id` = 5;
UPDATE `TB_admin_menu` SET `title_en` = 'Menu Management' WHERE `id` = 6;
UPDATE `TB_admin_menu` SET `title_en` = 'Log Management' WHERE `id` = 7;
UPDATE `TB_admin_menu` SET `title_en` = 'Site Management' WHERE `id` = 8;
UPDATE `TB_admin_menu` SET `title_en` = 'Department Management' WHERE `id` = 10;
UPDATE `TB_admin_menu` SET `title_en` = 'Data Management' WHERE `id` = 11;
UPDATE `TB_admin_menu` SET `title_en` = 'Relay Station Management' WHERE `id` = 12;
UPDATE `TB_admin_menu` SET `title_en` = 'Group Management' WHERE `id` = 13;
UPDATE `TB_admin_menu` SET `title_en` = 'Adjacent Station Management' WHERE `id` = 14;
UPDATE `TB_admin_menu` SET `title_en` = 'Online Conversation' WHERE `id` = 15;
UPDATE `TB_admin_menu` SET `title_en` = 'Online Site Sessions' WHERE `id` = 16;
UPDATE `TB_admin_menu` SET `title_en` = 'In-line Equipment' WHERE `id` = 17;
UPDATE `TB_admin_menu` SET `title_en` = 'Call Topology' WHERE `id` = 18;
UPDATE `TB_admin_menu` SET `title_en` = 'Equipment Management' WHERE `id` = 19;
UPDATE `TB_admin_menu` SET `title_en` = 'Visual Dispatch' WHERE `id` = 20;
UPDATE `TB_admin_menu` SET `title_en` = 'Map' WHERE `id` = 21;
UPDATE `TB_admin_menu` SET `title_en` = 'Electronic Fence' WHERE `id` = 22;
UPDATE `TB_admin_menu` SET `title_en` = 'System Log' WHERE `id` = 23;
UPDATE `TB_admin_menu` SET `title_en` = 'Log Query' WHERE `id` = 24;
UPDATE `TB_admin_menu` SET `title_en` = 'Recording' WHERE `id` = 25;
UPDATE `TB_admin_menu` SET `title_en` = 'Recording Parameter Setting Management' WHERE `id` = 26;
UPDATE `TB_admin_menu` SET `title_en` = 'Dispatch Management' WHERE `id` = 27;
UPDATE `TB_admin_menu` SET `title_en` = 'GPS Subscription' WHERE `id` = 31;
UPDATE `TB_admin_menu` SET `title_en` = 'Dynamic Grouping' WHERE `id` = 30;
UPDATE `TB_admin_menu` SET `title_en` = 'Configuration Management' WHERE `id` = 32;
UPDATE `TB_admin_menu` SET `title_en` = 'Core Library Configuration Management' WHERE `id` = 33;
UPDATE `TB_admin_menu` SET `title_en` = 'Regional Management' WHERE `id` = 34;
UPDATE `TB_admin_menu` SET `title_en` = 'Police Officer Equipment Management' WHERE `id` = 35;
UPDATE `TB_admin_menu` SET `title_en` = 'Site Related Configuration' WHERE `id` = 36;
UPDATE `TB_admin_menu` SET `title_en` = 'Device In Group' WHERE `id` = 37;
UPDATE `TB_admin_menu` SET `title_en` = 'Department Site Relationship Management' WHERE `id` = 38;
UPDATE `TB_admin_menu` SET `title_en` = 'Fire alarm equipment management' WHERE `id` = 39;
UPDATE `TB_admin_menu` SET `title_en` = 'Background SMS recording' WHERE `id` = 40;
UPDATE `TB_admin_menu` SET `title_en` = 'APP version configuration' WHERE `id` = 42;
UPDATE `TB_admin_menu` SET `title_en` = 'Firmware version management' WHERE `id` = 43;
UPDATE `TB_admin_menu` SET `title_en` = 'Record Download' WHERE `id` = 45;


#20250317
ALTER TABLE TB_UserInfo ADD `F_IPAddress` varchar(22) not null comment '用户完整ip地址';

#20250319
ALTER TABLE TB_message ADD `receiver_id` int(0) not null comment '接收者id ---- 单呼';
#20250325
ALTER TABLE TB_SiteInfo ADD `TS_is_ad_hoc` tinyint(4) not null comment '是否为自组网（ip互联类型）';