



DELIMITER ??
DROP PROCEDURE IF EXISTS schema_change ??
CREATE PROCEDURE schema_change()
BEGIN


    -- 子系统表增加字段是否关联登记簿,用于显示当日布撤防数据
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'iot_alarm_subsystem'
                    AND column_name = 'in_book') THEN
        alter table iot_alarm_subsystem
            add in_book int default 0 null comment '是否关联登记簿,0否1是' after deleted;
    END IF;

    -- sys_user 表增加 signature_seal 签名印章字段
    IF NOT EXISTS(SELECT *
              FROM information_schema.columns
              WHERE table_schema = DATABASE()
                AND table_name = 'sys_user'
                AND column_name = 'signature_seal') THEN
    ALTER TABLE `sys_user`
        ADD COLUMN `signature_seal` varchar(255) DEFAULT NULL COMMENT '签名印章' AFTER `is_manage`;
    END IF;


END ??
DELIMITER ;
CALL schema_change();

-- 新增系统参数: 控制视频质量报警类型
delete from sys_config where config_key in ('SIGNAL_LOST_ALARM','OCCLUDE_ALARM','BRIGHTNESS_ALARM','COLOR_CAST_ALARM','SNOWFLAKE_ALARM','STRIPE_ALARM','CONTRAST_ALARM','BLURRY_ALARM');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 信号丢失 是否需要产生告警数据', 'SIGNAL_LOST_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 遮挡 是否需要产生告警数据', 'OCCLUDE_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 亮度 是否需要产生告警数据', 'BRIGHTNESS_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 偏色 是否需要产生告警数据', 'COLOR_CAST_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 雪花 是否需要产生告警数据', 'SNOWFLAKE_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 条纹 是否需要产生告警数据', 'STRIPE_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 对比度 是否需要产生告警数据', 'CONTRAST_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('视频质量: 模糊 是否需要产生告警数据', 'BLURRY_ALARM', '0', 'Y', null, now(), null, now(), '0:否,1:是');

-- 新增App菜单NFC查询
delete from sys_menu where id=1782245721165127683;
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1782245721165127683, 'NFC查询', 1726899481861873666, 3, '/nfcScan', null, null, 1, 0, 'M', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAR8AAADICAYAAADRG+VuAAAAAXNSR0IArs4c6QAAHuFJREFUeF7tnU2sHUV2x0/dd4cRE5HBNisMGiPGHllZkAVM4lVgIrGIIsXLLCINzgLm2exnQRSMFBZRNlmMn/OxsFfZRXKkrJAmMEgRErBgFI1QnmfEG4FZ4QeKJRjs97qiutf96Htvf9T/9DnV1fceb0B6Vaeq/1Xn1+ec6u7ryP5lpcAjV28+6wt/yk/oT2YT8/TsfILuVFYTzXYyfs+T23PO71HhfuvI7x1ODt/6YvvsXrZT3tCJuQ297qwu+8SV3RdmsJmBxiCjsTie6C3n6RfF5OC6gUhDYdymwQfXTKzHDDqOXjXgiEkaZSiAyLuDCwahKLnUGhl81KRtNhxSq0NPrzoqU6oBJmFDEjl/vaDD1wxCw2wGg09i3Y/t3HzToJNY9I7hnPcXbl86cz2vWa3/bAw+idb44asfnnJ+es3Ak0hwdBhPr1k9CBWtX3uDTz/9onqHNKvw9GZUY2s0mAJWC0orvcFHWW8Dj7LA4ub9XuEOn7M6kLiwKwYNPooah1Rr4qcfKQ5hpjUUsEK0hqoGnySqEtEcPFtv2jF6KsWFx/H02v6l05eFrZq5igIW+ShtBzvVUhI2pVkDkKraBh8FeY9fuXmZZg8P2r+xK1C4gyes/qOzigYfYV2tziMs6NDmLPpRWwGDj7C0klGPI/9vntx75NzWxG+93zVV7w7/yHv/913tRvd3R59M/PSvWuftDx4rHD1NRH9MRCeJXEHkvydxrRb9SKi4asPgI6irSNTj6G0q3A4d+v9Bp+am7hlPfh2f1L1FB/Q8qoef0uuO6Dzab6W989f3t89c6G3HDCwoYPAR3BACUc8/0gH9K3dKBp+au+scyK/PoyH+P4t++No19TT4CGp6fOemZ5nz9Fsi91NOtFMdz+DTov6UrhHRD1nrEzpZ7YctncFHXLpFg71SLu/+si94wmwMPi2LPPEnaeICgFgRUHj14vOLp59T3kYbZd4iH6Hl5qdc7r/pwL8oMQ2DT7uKbosueUcXuVpb6sVVrr6fwUdIz+M7ux/BTzOHdOuQ/kxoChb5RAjZpwhtn96IEBhoYvABxGpryqv3uH+gA7nTKYt8uhezl0Z26tUtMNDC4AOI1dSUXe8RqvWU8+rlWAI6KJpgHbU3zmdKb3BqP1b3kV1hg4+Anmz4HNAfCAx/ZMLgE6mmwSdSKN1mBh8BfVnf7BGu94TLMPjELWafus/+xdPmM3Eyd7YyITsl6m7AOukKTzLfo+1u62AL5l0dHCVpc1fQK76gG1KDugmd9xMKDx7C/+zEC5assYPBR0DLrOAjcD3rbsLgk8cKG3wE1sHgIyBiQhMGn4Ritwxl8BFYB4OPgIgJTRh8Eopt8NEV2+Cjq6+0dYOPtKI8exb58HRb6GXwERAxoQmDT0KxLfLRFdvgo6uvtHWDj7SiPHsW+fB0s8hHQLehTBh8hlJ+cVyDj8A6WOQjIGJCEwafhGJb2qUrtsFHV19p6wYfaUV59izy4elmaZeAbkOZMPgMpXxmadej//z+dz596ekv85CDNwuLfHi6DdXL4DOU8hnBJ4Dn63sPnfv2t+68M2YAGXzy2Myxs9h0+OTid4OlXQ/97MMT060HzoUNMzk8+Or2yz/4eezmya2dwSe3FWmfz6bD5/g/3Tzn/eRE8Dv3wPTjz158cneIFRwEPo/8y2/OHB7SmeoFb23R7lAi9BXe4NNXwbT9Nxk+D1/Z/UM32XqsVHxIACWHz/LFV0W4S8UHd14+ezvtVuw/msGnv4YpLWwqfKrZxrLeQ9z8k8En5Jm/8999KoR7TRstUHiM9R+DT0p09B9rE+ET/O+r4tiP2tRzrri9/5PT7/RXOM5CEvjEgKecri8OP/ni0pkP4qafRyuDTx7rEDuLTYRPWefp0ihlAKAOn7KyXmxNH+y68PLvQ4SAsXOra2fw6aNe+r6bBp+6Gmub6qkApAofJOKpihEufkz1H4NPeoD0GXGT4NNW5+kCkPYJtCp8YkO9OhHGdPxu8OmDgvR9Nwk+OfugGnz6XHTYjmOq/Rh80gOkz4ibAp+Qedx1xx5bfqwF0U6zCK0Cn77gcYX/5f6l73+MiDRkW4PPkOrjY28KfEpl0JrPsqJagYA4fPqC5+Dw7jtje9bH4IMDYMgemwafoDW39lOukwaAROHT9ABhzEYbW5G5ek0Gn5gVzqfNJsInqM85ea6umvQptBh8+pBVM69MseUNPilUlhtjU+EjASDJzEQEPjFPTzZtnbGDJ1yXwUcODCksbTJ8SgB1vW3QtA6SzwCJwIdb51kH8Bh8UuBCdoxNh0/fCEjKb3vDh1tJ5z7HE+pKQbycXsGwyEcWDtrW1g0+4eY/mUxuo1+F6FMDkqj/9IIPt87DBU81wpK4eKlNbvCRUjKNnXWCT/Xmz/EJLoAkDojY8OHWebiTXk7tuHY0trfBR0NVPZvrAp+6mz/nSLwPgPq8gsGGD7fOw6mWN40lWfzqs9UNPn3US993HeDTdvPnAqjrkxt1K8UZq7TDgs/xK79+3E/cU+i2kQRPOTY3hUPn3tbe4COppr6tdYBP182f4xcp/TqsMgs+J372v3+KfCIjDMQhZJfA5Tbl2Jbc4gYfSTX1bY0dPpp+wXlQmAM6Fnw4p1ucozl0HE6xTWqbG3yklExjZ8zw0fYLbv2H439Q5MMtMqPpFvcUbagXUg0+aaAhNcpY4cPxixCVeLe1i7yozfFzTv0Vgk9suFfdJKnAE8bkCCCxoQ0+EiqmszFW+By7+ps/56jEORnm1H/Q8kc0fDjURdMtDnGrheehvn5o8OG4xHB9xgqfvv6B/jgDWv9BIRcNH07U8/n2k/+JbDHOGGXEMxR4wvgGH2SVh287VvgE5bg1mVmBF/x1Cg7skDGi4MMJwdD6C2eMHMBj8BkeJugMxgyf3gACP9TH8cvYUksUfNCjdYR+pZicB5y4R3zoZu1qb5FPl0J5/X3s8OkDILQuyvkRiFj/74SPJvnKLclNt2IJq731DT7aCsvaXwf49Llpx8KhVJ1T743xzW743P9R+djlRy8MfW6hnEfMxcXOuW87g09fBdP2Xxf4zFN+3tsG6HM5aIAQc/LVCR/0eO/Byef/9elLT38Zu51Q+8EuKlzsXLjtDD5c5Ybpt07wCQpybuCc9AspjcTYb4UPetQWQ7vqdkPth75oZJViext8UqgsN8a6wScow/ElbX/tChJa4YMWmpGoh3OM16fAXP6GEfrBpZgtb/CJUSmfNrnCJwDkO9P/20Uyh1JVzhF8THRSXTXUZ7v8tRE+aC6JUhTNIYMI3DpPdWG6aMxxEYMPR7Xh+uQIn7KoiwKhqiKnMKztt20+2wwfsNCMgCGFSNU7QvVj2ehTmDEuYvCJUSmfNrnBZ9kf+gAITb9Qf0B9t61MUgsfyQHqthwa9XSFb23bum6sPotbez1Xbl4mR69C7uXobbpH21AfayyiQE7waUpluHuek36hdVTUf5sCk1r4oNVz5GlmFGx90q02kbiLa/AR8f9BjeQEH409qu1jaEmmqdRRCx+00Iy8w4WGhSiVy10dQ2c0323yGEu7BmUJPHgu8InZo5r7vyoc4gto4bnpGmrhgzx7gxZwEdvcqCdmUUvh0flb5AP7enYdcoAPkl0gYCjFRqMfNBNA5t9kewU+aEiFHK+jtlOJ3veNeIt8suNL64SGhg8KhhQ3YXQMNPqpq/uswAdJi1BaIhEJKka529CUMfTrW4A2+Bh8EAXQ6L/co+jP1KCAQFM8xJ/rbK/ABxEGiUxQ2iO2y4VHQsHqZkFFX95oBh/E9YZvO2Tkw3lLvE+JAAEEesNH/K0uUFmAD5oWIc/2IBFVEAE5QQvtUcqXC9oXPMGOwWd4oCAzGBI+5V6tPnsWO3dOhI76NFIDRQOKZV4swAcFBHLKhaZDiO0ZAMCHImeAA7/s1rRJDD6x7pNHu6Hh0wdAaEaA3pSRUgpqexlsC/BBAIGKoJXOhYVECSwJHot88gAKMosc4FMC6Ot7D51DfwMPyTjCOJpBBXLTX77ZL8AHAQSSFqGhH3KCFsRFoFluUjSyatvcFvkgrj9821zgwy0XINEJZwwEbsiNf3neR/BBjIQLQpwXIS8aUaFgQ4tqMa5i8IlRKZ82OcFnHjnjHwRDAIGWJZByBJp6Ved9BB9EAJS8SGSCFLw4ISUibKy7GHxilcqjXW7w4ZyAoTfpvidTbSuH+HctfLSiEwRqnKgESRU59mPcxeATo1I+bXKDDyc1QgMANLNBIiuk7lMNLo4iHwQ+SHSCwgdJ51Db6N0i1l0MPrFK5dEuR/hwongEEGh6hNR0kaiqmnkcwQcJnZCJIVBD4YDYRutUiJsYfBC1GtpO/Ek3mTxK3v8wtCgcPRr+OynoPZq4W/7AvycwysxErvBBAYH6CzdC6dIdiaqqEdsRfJD0BTmN0oJaEASZM7pQXYJX/54MPlP61fK8XEGv+IJudM23yeE80Q13QK8s9/dTet0Rne+y2/Z3R+6FTmhM/Ek/cRdjxprNtfA7VLhbveY1ofN+Qq9zbBTu4Ikvts/ucfrG9EEAgaZe3Aila94INFfgg5ALjSAQ+CBQQ1MuJETtEnv570PCh4huUeEvdDlkjvBxW3TJO7oI6n3LefoPf0hXwH5HzXONfMIEUV9E9jViGwEbAp9wjeWcZ5EP4sjoaRESnSDwySXlmuuX6EuGNZHPfY+6RQf0fGsU0nC3HyzymdI1IpqlWMx/ndfcZDdn+KCOjPgjahuqvwJvGLDhg6QvCNQ0IypkzhxHyAA+1ASR8nqyinz6g2d2Wc7TDicCyhk+s5sZ4MhIhBJsI8EAElUhcy5rxrPIB8kFtU66UEBoiThW+MycsaX+kwt83NQ948lf79D5lid6z9Gs6NwaHUXVlZYGyx0+WukRCjatg6WSITP4ICkMAh8EaprwQcLHMcOnrf4jCJ95jSnmX11heEpvENHJhu6rqVQ4BXPufEttCE6/coePZnqUg6+z4aNNw5g9rXlniBl/uU0OaVdlTrXOKAifd+mA4uCDRRytdtuAgUY/ucMnyIYc1CDpERIQaAUa2cEHgRpSS0IjqjWAT20tJAf4tB3fRwGkoVYU1beysGOAD1JD0YIP4jscn5yfdgEFLgQSSIiH2OVcKAcqsX0yi3zmxdilZ2xygA81p1xR0VTL0XxU/67ie8x6az/nU85hbL6D+GR5QgfDB6GsFtS0QseYzVfXJkf4LNd/MoHPykOSXYXyBb0nvr5WBD50OIbIR2uPcyAR4xdIKWQBPkh+iTyLg8AHgZrWXSFG5EzhE574rXPMo4hAEj6O3E6XVr4oPl148DGAY+JCsXnlX+xT2l1jxv593eCDpEccSMToyrE7i3y04IPYReCjBbUYkTOEz/z0qcmx7z8LIwifKJlW0r62I/bCP9/1hHbUoJGNxgCfnCKUGFmRE7ry2SRV+GhBQstujMhZwueAnm9xqFuO3CtUhHeoVt9n0nrC2eDD3U3zfgh8xhb5LMBHy5m17Grlw9ztMnDN5+hoveU06ZYraCdX+KCnVdx1KvuNIfLR2uM5Qc0Kzn138vDvdn3zXM+8rhLemWp6iG/lalNFPtRW84l5+11gncYEH626phZ8OHZh+CBH4jkIiLx4x93fuUQ+s/m3OHnd9THgM3urvEsr7/2N6IIz8I5WeD2j9jqA7/2MIfLJwXeQdI4NH60LRewiT1NyKutdztLn71nBJzzjA3yqggEf6JmaBV2bXyiNekUCLZo3rekY4IMc1iAn0Dmlc6ovlmpdKKey3gcuXX1zg8/96Ofvul7KDNeVEj5tUIyq+zQ94Rz5QbUxpV1a8NEKCDi+ng18kPQIgU/YcMgxfhdocj3tWplXZP0nJXw6UsLWj6K1RnPgUf0YIh/kqw3Ii9MIfLRKLAvvdiHUQvJAJD3S/C4JktKtDXxC+hXx+Yqk8Anitn/LZ34qV/0sbPdnVqNStuq65g4fpH6C+g0SUWnBZ+F7PsjFakUoqIjIMT4y53WCT7iWrvpPcvjEF8SbntpeWKKodG1pUXOHDwIIJBgIMiARFVJLgvyx8L/cv/T9j2dpl1aEopkeIdGaduqVXc2n6mxzZ2+s/ySHT89fj1iIYIBTsjFFPgggkOgE8fOgF5LOIcBc+IwqCglkUggRkdoMOmfN1Ctr+HQcvw8Bn5iILCICZZ+65Rz5oDdVKDoBfpYZzRYQYJZzZv10DgIJBD4oIBDbaFoXsfmPmmQPn5ZoYyj4VAD0F8hDkeFt/ZW6ELJYPSMv7U9qIBEEmnIhxWbENlK2qUZU3/xWO/BNHwQSCMlRQCC2NVOvhPAJTy8v/PNEn9b97ladP96v/zy9lLq8X/cR9rq2M2B4qm0P+v83zb/5TGqYV9v3mnv/ZE45aK6RD+rESMoVrh0BG2IbmXcVauo/l4zmmUhUhaZeKNxiHSoZfGInNNZ25a+WFpXv9gj/WukMoJn+aCACh3AdSMqFFpsR+HAjqiP4IFEEkg+igEAuOgiKpF6hPRJOxvqwwSdWqTza5QgfxIE5+xiJTqqpUcyKIdCs+vcRfJAIBY0gEEAgYAvCINAM7cPc71LxwZ2Xz96OETamjcEnRqV82uQGH8T3jlLH+8fVsaoicENv0Jxi8ywCLSePRihIeoQAAgUbOu/ZRbvi9v5PTr8Tu3Bd7Qw+XQrl9ffc4IPcnEslc0m5+kRUR/BBC1JI0RklO5p6IXArFw+Zf5frGHy6FMrr7znBB4lIuHsXBQQCNmT+y4HFAnwQAiMRChqdoJFJsP/1vYfOFVvTB5FtLgUggw+i+vBtc4EPCoWybHD75R/8HFER8WvNes9yOrcIH+AhpDBJJPVCBUBsh7lwFjL0kwCQwQdxheHb5gAf7n5F/QLNOjTrPcsZzQJ80AgFcVxtEWYAAp5VKl0gRHDugenHn7345C7XLQw+XOWG6Tc0fFBfOCoyM2qVSFoEBxRgsLKczi3AB3VgJD1CwYakddyieRVA3/7WnXc+fenpLznuYPDhqDZcnyHhg/pBVSWkFlP2Q06i0JQLudnXRVQr8EGKtyggENtBCDQEDH3QMUIftMC97DYGn+FAwhl5SPhw9yiSZZSaoL6AjoGArc7HVuCDhoRIDopSH4VbEB0tPiPRW9NGN/hwEDBcn6HhgwKI4wdhDAQOoT0SWaE1qzrbK/AJk4CeWATzUCRU40Y/sZCTAM8sVb1y8zI5ehVyJ0dv0z3ahvpYYxEFcoBP2KO/8999yvvJia6LQm7wpS201oNmGagf130JoxY+6MQRcdDIKlCfU4/pAhD3blK3UQw+Xe6T199zgE9slI74Vqly196vWw2k9ID6cBPYauEjZbzuItG0iBv9zCOSXz/uJ+6punlwFtXSrrwgwp1NLvApAfRVcexHknsUjUrQG7FUcFILH5Sc6OTRfDEsDBcWdWNxbRl8uO6eV7+c4NN0k+TuUTRwCOMjUQ+nltT08cFa+IQBULohlXIk3y23LTf9Wl5cZJ6xLmNpV6xSebTLDT5BlerJFBc8aNAwAw9Ys0VP0NpqSY3wQS8kRfSDFsWqWz2IVhTFCckXSkv7Bp88oBI7ixzhU96Q6dB9Ej6uHnst1XZousXJKJDDqGC/7QStET6ziAF8YhglNmqfEyJyFhHtY/BBFRu2fY7w6asIp5SBRj3oGF3BQit80PwRjX5Q+2GBNL7H03/h7ai9r4Yp+68bfDh+lCLq6QpGWuHDiX7Qmgon+ulT/9HY5Bb5aKiqZ3Od4IOWR0pV0agHrfXE2O+GD/jyGAoGrnholKW3le0hQ01tNWyvE3w4N++gKfLzVxwfjTlB64QPZ+CuXG95Q6G5ZNkfHUdjI8+iQ3vCWUtaFbvrAh8ueLrSoRX/BGu/sXDrhE8whIZcnLoMV0g0zdPYzQYfDVX1bK4DfNBHYbjpFqeeFOuTUfDhRD8xOV91e3GefM4lAjL46IFCw/LY4cO9UXNKFZyxYlO6KPjMU4vmVxWaNkhM3lftyxkjBwAZfDQQoWdzzPDhwKBUEk63lH0+Gj6pnkpGU7zqFh2qBmTw0QOFhuWxwqcPeGJToVLvFNlONHzCpDj5HxrqhYv+8uD3z7jJ1mPoxkMFRu03tTf4SCmZxs5Y4cO9MaMlkFmmwygyo5EVBB/upNCIhBNlcQSW2uoGHykl09gZK3xS+QUHPBz/g+HDCcfClkLrP0gBGo2upLe4wUdaUV17Y4VPUEXbLzjZTZgX8hXEcnVh+ISOnGM+9OHDUuimb51Utyca7klvbYOPtKK69sYMH02/4AYW3HIHCz4IfavbiBOhdAkyNHhmqag9ZKhLC2HrY4fPfM+1nz5z/IKTboW5xB6tLy8jCz4xF9+0X9D6TxvpucQV3ssGH2lBle2tA3yCRHUFaM4DvtxabujHgVyvtKvszK2+c6CxHG1xClxae9oiHy1ldeyuC3yWC9CpwcPx4+qKsiOfMiKJ/QL/8jbiTLwEULCF/l61zjaeWzX4aKorb3td4FP64Nf3HjoX/v8uFR/cefnsbUQxTv022Je4+feCT1tKFCMAF0B37v3eg6jIMfPhtjH4cJUbpt86waf0Qc6v7XLBE8bknG4tr3Zv+Mzv/PirF+VEOAAaZss2j2rwyW1F2uezbvDhqM8tmYSx+tR5xNKuqqE+FzN2ABl8ONt/uD6bDp9cggWRyKcM/bj1n9B/zAAy+AwHEs7ImwyfPkGCRJ1HJfKpFr+KremDnE3BOYbnjCPdx+AjraiuvU2FD/c5nrAanIeEu1ZRLPIpB+p6KLBrQhoX2TVm378bfPoqmLb/psGH805YdUW4R/hdqyoOnzICinktomlyYwOQwadrm+X1902CD/ddreqKSRWYl3eBCnykAOQemH782YtP7ua1dVdnY/DJfYUW57cp8OlTWC4V0wJPsK8Gn2C878WPpQht8DH45KhAn+JyuB5N8KjDpw+ApCvrmpvD4KOprrztTYl8+tR6tMGTBD5cAEk8QSm/bestGnxSKS0zzqbAh1v+SAGeZPAJAyEhYKqLl9nK9m6XlI6p7GwSfNCbf0rfU635LG+mmO8AjSndKq/PIp9U2JAZZ9PgMwNQxzeZtY7T21YsKXzKMDC8hVv3ICLnY2My27GfFYNPP/1S995E+LTd+Ifyu+TwKQF01x177PCQzlQ3XsqQT3LDG3wk1dS3tYnwaUq/hsw0BoFPub2qdaCxvloxX9Sbl8nRq5DbOHqb7tE21McaiyiwqfBZrr0O/SjLoPApxfB3Dx7P6eNg6A43+KCKDdt+k+FTpl+cD49Jr9rg8JG+oCHsGXyGUJ0/5ibDh6+afE+Dj4CmBh8BEROaMPgkFLtlKIOPwDoYfARETGjC4JNQbIOPrtgGH119pa0bfKQV5dmzyIen20Ivg4+AiAlNGHwSim2Rj67YBh9dfaWtG3ykFeXZs8iHp5tFPgK6DWXC4DOU8ovjGnwE1sEiHwERE5ow+CQU29IuXbENPrr6Sls3+EgryrNnkQ9PN0u7BHQbyoTBZyjlLe0SV94iH3FJVQ26LbrkHV3kDFK4gye+2D67x+lrfQw+4nvgxJXdF7xz12DDhX+eCncL7mcdeingp/S6IzrPMbJ/8bRlCxzhavqYkAJCPnL15rOFpzdhUwYfWDKRDlP6Fc+O39u/eOYJXl/rtayAwUdgT3Dh4wp6xRd0Q2AKZiJWgYk/SRP3RmzzxXYGH55u9b0MPgJqPnz1w1MTP/2IYerf6YD+ltHPujAVcFP3jCd/ndPdE731+cXTz3H6Wp9VBQw+Qrvi+M5NzzJlqRdLNnanKYWo5ySrv/PX97fPXGD1tU4rChh8hDbF8Z3dj4jcKdico0/o0P+1FZ5h5eAOfU65ZoN5em3/0unL8MDWoVYBg4/QxmAdt98f23na8Yd0RWgqZqZGgT7pVmnOjtllt5bBR0hPbtG5HH4GIO9vWAQktCAVMxLgIbJis/TKGHwEFWWnXt/M4V0q/N8YgOQWpc8zPQuzsJRLblHKiF/c4gYbPH519xp590JfCWZH8OTfm9mxhxBZct5/hSI8xcwrLi+NaikXaxlaO1nkI6jp/Mh9601W4bl5Hu86T+8LTnNtTRWOHnVEz0gBpxTKjth1tozBR1jXPoVn4amYOSEFLOoREnLJjMFHQVeB2o/CrMwkSwGr9bBki+lk8IlRCWxj0Q8oWMbNLerRWxyDj5K2Fv0oCZvQrPP+wu1LZ1ivYiSc5miHMvgoLZ1S8VlptmZ2RQF7lUJ9Uxh8FCU2ACmKq2jaTrcUxa2YNvgo6zyv//gfCx+/K896k83bk8ypVt/gk0Dp+asX/poBKIHYPYawiKeHeIyuBh+GaJwuloJxVEvYx47UE4o9H8rgk1hyqVcwEk97rYebOHrus+3Tb631RWZ4cQafARbF0rABRK8b0vnrBR2+Zr9GMcx6GHyG0X02qkFoIPENOgMJvziswSeDZZhBiPyPydOzVpRWWhDnr7uCfnE4OXzLIh0ljUGzBh9QMO3mMxAV9CxN/Pe8n3+W1ZE/ZVCKVd7veXJ7zvnZD/sZcGJ1S9/u/wHCVo98MIQUWQAAAABJRU5ErkJggg==', null, '何悦', '2023-08-25 10:45:13', '超级管理员', '2024-01-10 18:44:54', '');
-- 新增检查要点数据来源字段
delete from sys_dict_data where dict_type='point_data_source' and dict_label in ('录像缺失诊断', '录像质量诊断');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (1, '录像缺失诊断', '2', 'point_data_source', null, null, 'N', '0', null, now(), null, now(), '防区');
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (2, '录像质量诊断', '3', 'point_data_source', null, null, 'N', '0', null, now(), null, now(), '防区');

delete from sys_dict_type where dict_type='point_data_source';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('检查要点数据来源', 'point_data_source', '0', null, null, 'null', null, null);

-- 新增挂墙终端告警次数和频率 系统参数
delete from sys_config where config_key in('ALARM_DATA_TERMINAL_NOTICE_TIMES','ALARM_DATA_TERMINAL_NOTICE_FREQUENCY');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('挂墙终端单次告警提醒次数', 'ALARM_DATA_TERMINAL_NOTICE_TIMES', '1', 'Y', null, now(), null, now(), '次数');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('挂墙终端单次告警提醒间隔', 'ALARM_DATA_TERMINAL_NOTICE_FREQUENCY', '5', 'Y', null, now(), null, now(), '单位:分钟');

-- 停用app物联感知模块下除物联数据总览菜单的其他菜单, 并新增其他菜单
update  sys_menu set status=1 where parent_id='1749608698379771905' and id != '1764951130651414529';
-- 新增消防预警 环境监测 智能运维 菜单
delete from sys_menu where id in ('1787728646959206402','1788020750918815745','1788476228704907266');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1787728646959206402, '消防预警', 1749608698379771905, 10, '/iot/fireWarning', null, null, 1, 0, 'C', '0', '0', 'appiot:fireWarning', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAAAXNSR0IArs4c6QAACfdJREFUeF7tnd152zgQRSGXkE0LqmPtcpwU4biIJOXEqcMtJC5B3I+JlaUVShqCA2J+jp/8AICYizm8A0KidoW/bgq8//p8O178cCi3u5vy73Eiw6F8H/+/uSlPP+73T90myIXLDg22V2AEYyjlYRjKL0Cu/g3l8eXj/tPVdjRQVwBA1CU9P+BiME6HApQNV+v3pQBkI8nffX7+VHblYfXlgGS1hEsGAJAlalW2VYPj9fq7XXn6eb+/q5wO3RYoACALxKppqg3HcQ5AUrMay/sAyHLNxD1awfFnApRb4rWobQggtcoJ+r378jwImq1qcrMrdzwKXiXhxc4A0kjb5u7BfqTRyr0dFkAaybyFexynjos0WkQe87YRdiv3YMPeZv2mo+IgDTTeGpAxhJcPe9aywVoiagNRtyyvKLMaLOBkSABpoC+ANBC105AAoiz8+Hmrw1C+KQ97fTjORK5rVNECQCpEu9QFQJQF7TwcgCgvAIAoC9p5OABRXgAAURa083AAorwAAKIsaOfhAER5AQBEWdDOwwGI8gIAiLKgnYcDEOUF6HGKPobA90OUF/J1OABZqevxzSSLXsKw8pqXuo+gjG9F4Y0oOiIDSIWOx5cvjF3FbyapuI5Kl6E8juPwVpQ6NQFkgW6r30qy4FpNmnLavlhWALkimXso5uLDVcSgAMgZqUKCcRLrcb9C+XWeFwA50SYDGLPpQPk1KwuATGT55+vzN/ObbnFxUNFwKI88/XqrG4CUUnqdXVSk8DZdcJM/OqcGJG05JcUMUPK+mxfXEFKSHJJ0DoJrCME4bZYUlFSAdPsgYWVOmuuWEJI0gFBSKeGWDJIUgKR/fKvExnGY8YBxV8pjhncChwcEOJTpmAyX4ZWnoQEBjnZwHEeODklIQHhS1R6MN1cIvC8JBwhPqjaG43i5oJCEA6THaz87paS5y0Yst0IBwp6jPzPRIAkDCOcc/eGIuHEPAQhw2IFjnEmkN6y4BwQ4bMExPUyM8FvurgGJ+MTq+DXYsisPNlN/wawCPNlyDUjITfnrCxVCAFJK8b5pdwtIyNLq9Y4bKTbv+xGXgERKoLkT6XDxOS61fALy5XlYUAn7aDpJonCAOC613AESMXlGgqc/4xwxRq+llitAIj61+mVvJyVIREDm4vRg7a4AiZo4U/cYkyZqnKdOCSCKCoRNmpkNbNhYZ9xSMUWaDOXGQaImzal7RHcQby7iApCocJzuPY63wLDxvgboacMOIE2MWTbonHtkcJAxRi8n7OYBCXs3vXB4Fjbm6X3DyeEhgMhu9uqtzrlHFgfxUmbZByT4qfkceSkcxEmZZRqQiIkiuXNGjHvuRiDRQt26Fw5oG5CE7pGlxDrmqfXNullAQn6sRLgxzeIgHp5mmQUkZJIAyF8FjvUyyywg4b4tKIQjW4ll3UXMAhLtBXCXHuue3lZDuueFzbHlfYhJQMIlyAL3yOgglsssAFn42K+m+RL3yAiI5Q8w2gQk0uPdhe6RFRCrZRaA1FjCgj5L3QNAFoi7QVNzgITaf1S4R1ZArO5DAKThXajGPQCk4YJUDG0OkDDnH5XukRUQqxt1AKm4q0i61LpHZkAsbtTNARLigHCFewDI/klyA9qqDYAoK62x2Qz1oGKBvjjIFbFCfIJ3pXtkdpBzL7FYwJh6U1MO4h4QBTgyA6LhvtqEmALEfWkBIKvyE0CuyOcaECU4cJD93SrKlDvjIEqCrnmsezqFsdQcyrqfYBuGcqsU2mbD4CBRHUTRPbSy0ePjcgAJCoime2gA4rVUBZCIgBhzD69wjKkBIAEBwT00PO/3GAASDRDcQ48OALmupbfywJx7OP8mJg4SyUFwj+t3vIUtACQQILjHwuwXNAeQQICMiylY84tNft7rnBp7K03PiQIggQBZC8fYX8uFPB4KzukHIADyRgENQKK4B495BbfcSIstCFfFQaK4B4AIMgZABCJNmkTTixKLEkutxHL/5bKZXAAQAFEDJJp7UGIJqoeIi34p7NpNelSdcBAcRMVBAERwt1VqwjcKlYSsGabGQaLCQYklyKDIiz8XfhUgzj+QeCkNKLEosVaVWNFvIAACIOsACewelFiUWH8psKTEiu4eAAIg6wAJ7h4AAiDVgGRwDwABkHpAErgHgABIFSBZ3ANAAGQxIJngABAAAZArOcA5COcg4nOQbO6Bg+AgixwkzK/9Ctb92AQHwUFEDpLRPXAQwZ0kW2KcO0mP9D1zwbL/aYKD4CBXHSTbTWIqCIAAyHVAkhwKzqUCgADIRUAyuwd7EEExmi1BTvcgWfcePMUSwDE2yQxIttgpsYRQTJtlS5Kpg2R3D0osATBZAckW97lUYJPOJv2vTTpw/C8JgAAIgFzIAQABkLcKDOWx7MqDoPpM0QRAACRFotcGCSAAUps7KfoBCICkSPTaIAEEQGpzJ0U/AAGQFIleGySAAEht7qToByAAkiLRa4MEEACpzZ0U/QAEQFIkem2QAAIgtbmToh+AAEiKRK8NEkAApDZ3UvQDEABJkei1QQIIgNTmTpp+N7ty9+N+/2QlYDM/A53xVZtWksDaPCxBYgIQ4LCWov3nYwWS7oAAR/9ktDoDC5B0BQQ4rKamnXn1hqQbIMBhJwmtz6QnJF0AAQ7rKWlvfr0g2RwQ4LCXfF5m1AOSTQEBDi+paHeeW0OyGSDAYTfpvM1sS0g2AQQ4vKWg/fluBUlzQIDDfrJ5neEWkDQFBDi8pp6febeGpBkgwOEnybzPtCUkTQABDu8p53D+Q3l8+bj/pD1zdUCAQ3uJGE+sQANI1AB5//X5dijlYRjKrTggGqKAtgLKkKgAMsJxGMo37VgZDwWqFFCEZDUgwFG1hHRqrYASJKsB4ccnW68049cqoPF0axUguEft0tFvEwUUXARANlkpLtJFAQDpIjsX9aIAgHhZKebZRQEA6SI7F/WiAIB4WSnm2UUBAOkiOxf1ooAFQMaPl3jRi3nmUmA4lO9rP8C46jFvLrmJNqMCAJJx1YlZrACAiKWiYUYFACTjqhOzWAEAEUtFw4wKAEjGVSdmsQIAIpaKhhkVAJCMq07MYgUARCwVDTMqACAZV52YxQoAiFgqGmZUAEAyrjoxixUAELFUNMyoAIBkXHViFisAIGKpaJhRAQDJuOrELFYAQMRS0TCjAiYA+fUCugMvvc6YgOdiXvtNQC0tTQDCTyZoLWeccV4+7E3kpolJAEicxNaKBEAmSgKIVlrFGQdAACRONjeIBEAApEFaxRkSQAAkTjY3iARAAKRBWsUZEkAAJE42N4gEQACkQVrFGRJAACRONjeIBEAApEFaxRkSQAAkTjY3iARAAKRBWsUZEkAAJE42N4gEQACkQVrFGRJAACRONjeIBEAApEFaxRkSQOKsJZEEVuA/flfJFCkG0pcAAAAASUVORK5CYII=', null, '超级管理员', '2024-05-07 14:18:18', '超级管理员', '2024-05-09 16:44:57', '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1788020750918815745, '环境监测', 1749608698379771905, 20, '/iot/envMonitor', null, null, 1, 0, 'C', '0', '0', 'appiot:envMonitor', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAAAXNSR0IArs4c6QAACvVJREFUeF7tnUF22zgMQOXMBXKjtoeavtl1uuvrHKrpjXKB1vOk2I6TWgIIChJg/GxDUsIHv0hJFH0Y+IMABGYJHGADAQjME0AQegcEFgggCN0DAghCH4CAjQAjiI0btYoQQJAiiSZMGwEEsXGjVhECCFIk0YRpI4AgNm7UKkIAQYokmjBtBBDExo1aRQggSJFEE6aNAILYuFGrCAEEKZJowrQRQBAbN2oVIYAgRRJNmDYCCGLjRq0iBBCkSKIJ00YAQWzcqFWEAIIUSTRh2gggiI0btYoQQJAiiSZMGwEEsXGjVhECCFIk0YRpI4AgNm7UKkIAQYokmjBtBBDExo1aRQggSJFEE6aNAILYuFGrCAEEKZJowrQRQBAbN2oVIYAgRRJNmDYCCGLjRq0iBBCkSKIJ00YAQWzcqFWEAIIUSTRh2gggiI0btYoQQJAiiSZMGwEEsXGjVhECCFIk0YRpI4AgNm7UKkIAQYokmjBtBBDExo1aRQggSJFEE6aNAILYuFGrCAEEKZJowrQRuAtBHj8f/72Efxw+2FBQazUCh+Hn8DA8PX87PK3W5k4NpRbkJMaXndhxWA2B4/A0/DV8zSpLSkEQQ9Mzw5X5+vz98DrShzu92yeUThDkSNKzbp3mcXh6/u/wKVMEqQR5/Pv4YzgMHzMB5lzfEUgmSRpBGDnuSrU0060Ugjz+c/w4/B5+3FUXIZgUkuQQRDe1+jr1uYch/aPF1O78Hj4O46N2eSqMIGskWjl6pIC9Bo8sbajy9jB8iv74N/wIorgxR46g1ijuG8PnLrcgyZ6IBO3Hrqe1KEmC/OUWZBjCX4Fce1+CxqVR5Pn7IXQfDH1yY/4fPx+Ps/0gwRw2QR92PUXpXgRBOvEjSCfAnasjiHMCEMQZsHPzCOINmCmWM2Hf5hHEly/3IM58vZtHEGfCTLGcATs3jyDegItOsaaONf6NSzfm/q6W1UR9I40gCNJF4PK58PlTYXkN0/Lxxi/4An3yiiBd3UOufG9TrKvv5/0/FQ7wuSuCyH28q8Q9CDJJoVvh2sVqofJuKw4QxCulp3YzCyIts3BG9775XSRBEOcsZxQkmBiXDO2xrANBEOQNAcXyfGdi880jSDt6Fiu2M7tZQ7pSrnSYvmZ2WNwpcdlD2haICNJCa6as1AmUh3j5ZHj8a9yV8N07k/mnYwiiTMVrMQRpRva2QocckxBrbqYmnguCNGcbQZqRvRNEt6HEudLqUlyfDYJ0JvNGdQTpYNpwQ77JI1ZJkD3m+xHPqSXlCNJC66qslPiropvIMR5PEhZB2pONIO3MphpSZzzdbG+6rc3iOe20QYJ0IdlD2paUI0gLrVNZ1YvAjW+IpY447LTBhXReCGLogG9uPAMud198u/9y8uZp1ZvVvYfhp/Ypl9QRh42FPedQOi8EuTNBpIQPxqnM0ipfTSeSpnyaNjpTdbO6xGuv89LGyhRLS+o8vZIe6zZeqVXTNcWItDiqGaVtRIMgawBrbSPSYkXpatgyeijFuOBautKueV6t+ZHKS+fGCCIRFP6fShDF6DF1mF/DF8Xu569khBFAlE1xXp1pmq2OIF5kX58YhdlZsXeeL3bkeZaLN/0RH+9yk+4sxgVwoKdY1o7YIYb4REy6QrdM+zxSKp0fU6xO6qGmWEuyztxId8ihWrcljWp7Pd5lBOns+NrqWQWRrpwL8avEGOuLx9jx6RWCaHt4Z7mMghhHDbUYV9PP8XfHQ33/8T7dksRMsaoIcnpS1CzHaR8r7Rvza5zSG/0InQ9BOgWQqqcZQR6GT82PbxUvAOf4iCIGmF5ppoERJF7qg7xJlwy9+r90xW5oyrxWS9PppvPY8d3Hm1FO+AlvBGnoNbeKhhpBpGUmuli75JgEkc4jyOihkRlBdJ1mtlQoQcYdEpduiqVYV7iqS3P6SKMHgkgdYoX/34UgK17RFdO87hFqhbRdmpCEZgTppB1JkOmKuPyy8Fa0q3VYcWr1sktKqPtKBOkUQKoeUJCWadZ6cuimd6sdT8qL9v8IoiVlLBdOEOkG+TXO1Tqr+Eh3POaK0zhjqm5WQ5A1ad5oK5IgUrLfnP4Kv83R9LMJKzwA8EilxCzalPA9g1Dz1Tt9zNs8khh+ZKf5GB4y3Mwf70F8UUcZQVTTnCUUCz+NdrrKnn+LsPWXp8LKwWNeXzem1iMIIk0TNsAwd4jQciDIBj0jhCD6G/MNiFwOEV4OBNmgO+wtiGr0eJk+zf9c8/qcUsiBIOsn/o8WdxdEHj2mzqoSqZdXx9L43kNb60tceIplJXuqt7sgwpvz9wnWvO02IkkzalzHhyDGbGur7SmIlNy5LUZNW/vcBtL8laGW61blJIaMIJ2Z2FUQYXqlSe5FlpGD7j4lvRSMIJ2dvqX6XoJIV76epR1T21d/z98OTy1MMpWVOGouMnvGy5v0GfpSYqN8sbdn59EcW+KIIBqKC2VCjiBBFwZ2onapjiAuWF8b3UuQ8Qxmn0gFXRjonApT8whiwqavtKcgM5KkfNyqJ75uSQRZl+cfre0tyPmExkTf8820VxoRxIvsqd0ogjiHebfNI4hzahHEGbBz8wjiDTjQzx84h3qXzSOIc1oZQZwBOzePIN6AGUGcCfs2jyC+fEN8Uegc4l03jyDO6RU2auOdhDP/3ualb/lZatJJWPi+AkE6+XpXt/6uo/d5advPsFhR2skQSbTZ3ricNL3qWRG9VSjxBRH2VZpAsTZqq/6iPo40tcqSt/CCjCBVG0afdjJUZ5CCPgR+XzavWN7fK8mK6CyCSNMsn2TTqh+BJKN+CkFOowiS+HXXbVtOMnqMUNIIMkkib8GzbaI5WjuBRHKkEwRJ2vtjqBor7Hi/dTypRpAzHEaSrbvJKsdL+Tg+pSDTSDI+/v01fFFupbNKhmnERCD1NkZpBbmMJuctdEZZsv5J+2WNU5NMf4fh53S6D8NT9q8w0wuSqd/MnSvLaeJmEUEC5AZBAiRh5hQQJEBuECRAEhAkbhIQJG5uGEEC5AZBAiSBESRuEhAkbm4YQQLkBkECJIERJG4SECRubhhBAuQGQQIkgREkbhIQJG5uGEEC5AZBAiSBESRuEhAkbm4YQYTcnDYf8M3gcfgwuyr59NvoridwB4sKvfggyAJZ1c4cXpnZvt2U32t4Y0KQGcLF5DhTQJJ3/QFB5gSp+P17su/FvUePsX0EmR9BjlskINQxEOSPdCAIU6xXAkn2qtryooIgSzfplaZZjB43ewKCSI95z5tDbHnZ2vJYp+/Hn78fxo35+OMmnT4AAT0BRhA9K0oWJIAgBZNOyHoCCKJnRcmCBBCkYNIJWU8AQfSsKFmQAIIUTDoh6wkgiJ4VJQsSQJCCSSdkPQEE0bOiZEECCFIw6YSsJ4AgelaULEgAQQomnZD1BBBEz4qSBQkgSMGkE7KeAILoWVGyIAEEKZh0QtYTQBA9K0oWJIAgBZNOyHoCCKJnRcmCBBCkYNIJWU8AQfSsKFmQAIIUTDoh6wkgiJ4VJQsSQJCCSSdkPQEE0bOiZEECCFIw6YSsJ4AgelaULEgAQQomnZD1BBBEz4qSBQkgSMGkE7KeAILoWVGyIAEEKZh0QtYTQBA9K0oWJIAgBZNOyHoCCKJnRcmCBBCkYNIJWU8AQfSsKFmQAIIUTDoh6wkgiJ4VJQsSQJCCSSdkPQEE0bOiZEECCFIw6YSsJ4AgelaULEgAQQomnZD1BBBEz4qSBQkgSMGkE7KewP9gJ6wU3J4ltQAAAABJRU5ErkJggg==', null, '超级管理员', '2024-05-08 09:39:01', '超级管理员', '2024-05-09 16:40:12', '');
INSERT INTO sys_menu (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1788476228704907266, '智能运维', 1749608698379771905, 15, '/iot/smartopration', NULL, NULL, 1, 0, 'C', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAAAXNSR0IArs4c6QAAGoBJREFUeF7tXUt2FDkWldJeQDfd83INzDm9CsxKwENgEeBFFDXErASzij4HBpU173L3AiDVRxEZzshISe8+6UmhiJRHVKVC0vvc99NPqwr+/vb7v682u8vXRqsXWpkrpfRVBdNqUyjKAbO1wxmlt9qor5uNevjPm+uHolNwDKbnnMCz375/UFq9n3MObeyaOWC2yujPj++uP8w1y1kA0oAxl7iXOu58QCkOkL9//P5FK3WzVFG1ec/IAaPuSnuTYgCxeYY2l58aOGZUsFUMbbY7/fPl/978q8tZcv8VA0jzHLlFeU79m+3j2+e/lqC4CEAaOEqI8szG0Ob+8c3z29xUZwdIS8hzi/CM+y+Qk+QHyMfvBhdhX62wNXD8m9ZyDRwwO3NlNuqFMfoKz1Pzh1pZAYJ7D7PdaH1bw8LQGpRt6TT88/fvNztjPkELxplDrbwAAbyHUerhv2+vXy5dqG3+shwYdlfQC8l5vUg2gPzjt2+vjdafQmxr4JBVqrX11oHEXHyhPMlGq5e5oo9sAHn2+7dPyujXIaHt9I9fS9Wz16Y850JPH26pL0F6M4ZZ+QDy8dsfQeQHiLK5i924aJmitdnu1M+7BqR1QqIDwE7ddBtVtdlulP489Qb0MkG+MCsjQMLVK23M7V/vnt9Pxe5mRkvi1wgPbxg+Kd/SxZ4VAsQVXoUZkY8Ja1S+2mkKh07HBhEJsx7fXmcx9lk67ZOryz+4+cczIixrOUvtao/PjyzijLxIrD7hs/G3rAwg4bCsAURC5HX0QYZNoxy1AWQvMyoZy+VG61CZ85oFFTaNc9QGkL1uBBlRYN/NeanovNSGjz8c55sNICNZ9a7XvDoqETdwzKvNmUZ3g+T0vEcDyEQAliGX6rK7uCHXCmkmmbduIzhg5X2xu7jRG711ybsBJIKp7ZPz4UADyPnIulEawYEGkAimreETK/iBjiGkHNP1Q/3ozl2f+zabBpA1aLuDhgEANr429jK8jfmFdyBo3Gl/sZrS/WEyvVNffTH72tjZALISiQ7FhafNd8WuNzJbCxzXRr81sLYBZMFSPL42tYb7vvaexujPu82P+zWEZw0gCwNIfaAIMdDYu27vXDunl8L2BpCFSKoTlLp4Tx0Eq5Oc5YZhDSB1atTTrNZ3K+Syztc0gFQKENbtGpXSEJ7WMsKvBpDKlGs+j7FPsIu/j1K3R2kAqQQgQ/JNXzXDnfBoDWOn/9TKbO0ahl0IDFWZxguJdi3Fjsq/XI0xV6Puaqx8NYAwZJirKXmAhzWw2Q4vJeVUuGGTnwWNXOFgvrc4fCxuAGEpn2xjuXDqcG3qXDuQDx5wclwgimVlnxkITbEBJEqA6R9Rp9roEeYHRdDqJpek6/AmDSC0Joq3SAup6lAchCkiXmXmA2sNIIikhdqkhVTLAcaUXU/5SvdoaswrwvOFXA0gQspPdYMw2t3HcoHhoqe/cicGKPOABJFbrhtvqrr2h1LwlN+j842Zw4sUmsnEd3f5ml/SLr9m0gCSSwv2/caBo7wiZGaDs/u4kLOsR20AyagZUeDI5DWG8yLda0pDHrA/RGVZcHhZqd9YWPLSbn7RohxIGkAyAYQPDnmvkbY1vux9xL0i0u9xHMRVBiQNIBkAwgWH5GM+IqXVgScZ375wsZ2/3UbeqLgqcDF3PUuo1SqTdMTiHDFPQAn5ioWKr6wXGWbFC7nyggSRZ6tigfqEMHPcle+dEnA4lQ8YwwzmAYgdnQuSnf75MscRX0SmDSCgxlIXYI+7SX3bjqdAIAHTZgLeLXLk7jMejXnA3ACSIsHRt6XAwVOaNOJyWUbOrFj5XAZAN4BwpOVpyxFirOcoe8JwnlVrnyjIB2/GHwqXyRtAEgGCMPBQFHK/jUhNQdZr7M+LaLNVO/2nHXs4RGX/Pdd2eTkeyCbtiHxzedpVVLHg0CrSssH9BzWs3q3xFDDGv+OGQi4faQDhSGjSFhVYzDpH3DaMwwTtmNqor4/vrj8kkFjdpyjPlVA+0gASqQII4/qu+daMk9OcTD/SU0WyofhnuOGQCbUQObcQy6EGaOjDTcpjwWE9htE/bnOsBRRHATEgorSdaVLq4b9vr1+mzB8ZqwFkwmG0qsIFB9rvcdHmfIAxphvllchibMSz4imgfCrqSHQy7aME4qk31WOsF99zyIQQOWRQqs9nv3/7RN+owg9xx/MvoU8+fi2yioUmiRy3iwjhmIlpQi+lwLnHgfmWkLAjY3BkzeHJMgHy8buhiOS6dTSfifFM1FyX/jsWasUblAYQhoYgwuAmhhxwqJVXqBiieGoKV7UiedcAwpAKkntwEnM0XLNT5PTLIGkVTREljim3W+YgfbcQSymFeA/O4hQnKW/goHGMeGJu6NsAQvP9qYW49wByGTt4jFAZZK2mKWLpY7wI0u/ZexBp74GVJ2UWulaDAIAQxItwvXEDCMB4RKFRxiMMb9UqQCiOJlDYyiz5IvI6ew/yjAiHOJUrxMrFhAJxKnX4yirCpbq8ot4NSR0n9/c0f3kl3wYQQmJIeIXmCZCFK1CxGs6yG61eHO7DmjLi8M7IZqMeaj0nMp01Ii/U27ckHTBntEVS6vHtNbToifTFqYQB0z9aL9hEXfc5dFHmHioOTa62iMXneHykv7MOsajwClVo1HtIM3vwFvx7cH2qWj9QaEOEh1kNIAGTJemuaaF1+7PvJA84oaCMs9p1nVsf04DQjYZZDSAB7UCqV2h4RXoihYdqiEJzVumR/txt6txRjCg1aoyQvqS9/sBrKG7nCk+SIHJxECwZIp4ITfQRfkDeCukIalNnyEXzAAuzJPUJYueo0QIAEt65iyq1lLAQBtNjIb1w25itNurur3fP77lf5mqPGCXE+zeAeCSEMBh1rVR4hQKNUqYyYZU/ec91/SdFd2w1C8lDGkA83EeUDbFAkkALKQqSmJ5+f7gOyC4QDr/bBcPdTt2E10lcs8HClhiFj/mGDJGBokgDiA8g1HFOMP+QTPRDSkIqw/hjbe7RB3Lg8xZPmaW5f3zz/DZGoaW/ocJNZD2kAcQHkI/f/gi+yApYH9s1FV6h6ygh5UG8VP99XNWJt5YSN4Y0ODre//b9Q3j9h/Z4DSBegKQn6IjiInEwpTwkCPfgSM0REHq6oUDvStGV+jsddjaAOHmMJNeU0kF9kBYsfe0DVVpkvohCouNJAB+ZT6iNhPWX6COWjmrLvIgSIAk6mX8IWFok95BWVjp0kd8VEKNkiHJTvEH6kDI+UxpXDxAqSZQo71KeLke4gygNkgDHKD33G8qAUDJAaG0AmUgFFX6qcChlQDwdZSGpMXy/I2MjXjZ2fPQ7ykhRW04aQBycpkIIKYCkKq9UCPdUpdq/FYKsiCOKk0ofCoJQuwaQCXcQwVEukQIIGrZQ4Q81D0pBUoVv+3dXerCtIxLjUzSm/p46Rwl9iqWh2hxEwjKXYKxECOcHMb2dneQTuFYUq0DId+QciUJJCTn66Fg1QOgafHqJN9VDkXkEoeBSnhZR9Ng2DSA5QixqmwlgGUnli3hYZ6okqQBJVR6KRjRXi1V+5LtUGpsHcSXpFECA9QvSgwB9UApAAYRKkikPQJVAqe/RXI2iM+X3BpAcHoRaAQeUm7Q8QB+UYlA5CAWQfo4XX3x7zqgyLal8gKelaEz9PXWOpByVUqnFluXlIARA0NAhZGEp5UMUI7VCY8fowyT1/hgk2IZDCqCUB0JoTG1DAYSaYwOIQwJSsbV7FyymfIhikAAB8xw7z4vdxY1R+sqOi14cQYV4lPIhNKa2oXhEzbEBxCEBKn9APcjQtWWyPYQkffkaBWQ7PhVmxSogmX9kDD04c6a8HMWfBpAIgMxxNahLKRDhccGMKh/lPWpI0C0tFECo/AHhMdUHytNpu2rXQeZkCpeZVAiRw4sgY1KhC5fO2PYUkCnlnlMXFg0QyjXHCpT7HRJmWY+XelhqmBcVfg7tKMXj0hnTHpkrVSxpAPFwnrI8tVhIqlR7IC8dJIjCdeMJlLBjADH9BjEeDSAOTiPWjQwjKqjxD6QhitC3xTYhupQTScpr8h5d/iFQrm8exOdBBJgrYQWRPqwQtbn85H/KYNIL41aT3muYT8ELLMbdV+I97JRIIwfMtQHEo4F0OEEf+EeUW6oNIsjTsQ73Ytnfhruxhnux+DfC18UTiTAZ4SsSkcTIudok3RKDMKaWRJ0fasWIi/6mJn4gYSei2IgeIP3Q3DttUTVAuhhW6G6sGObEfkPF3bH9Ut/VBA4k/7BtqAQdNZRnCxAqhs21CEcpY+h39/aWlB7pb2sDh1T+0QBCyJ62xnXF3GNy6LnTik+3kNtXRo/FayGRfzSAEDynE3Vb8je3yCUHPPHKtHbv1JXpu5btNi5qpPKPBhBCV5BFuBrDrDFZ8iFXnQ/mjGmmQmM0/2gAAYwpEqrUGINPSUsHSv3AGGimwivOSn+rYkFe5PKPYLOKVtUBzPcl7N2lPSj1Qitz5V4EPLyTvtv8uP/fm389vR+CjDFXG+qAlJ0Xx6A1gACSpF12vck6QF7XJNeZFXR8qXZUaZ4bEjeAAJJBkr6ak3WAxFU0ySGnBhBANRAm1VzVAUhcRRMy9wAXB0+KHCYcYp/tQiG3MtK8yHw4Q4opnOR8oAQxjg0g3jtspwqx/FxkPhVPGxnxHjGK3AACygXdUt68CMhQwWZI5YqbnDcPElG2RFbWJY+3CurQqrtCvEes4WoehKk6dMm3niOnTNIW2Tyn9xjK35uWpOO6gVgU7mIUPvo8LW0C/LSoqNUD+sZ67tliHp23MDidMyLvmNwG4U3150F8RCBWaw1lX3/eNf8uXkRxO/kBx2pDyoqM0wAy4SDCNAnhIFYmVxvaOs9bsYNCXYHbHRFZN4A4tBDzInVvh/d6SOp2+/2HnD1NkkCG1jw655F+FKEBJFJyyFb4vuv0+6gipxj1GWqZ++glXQG5k6Q929CjjIdrAOFKaNS+tLASpkp+iq7zjDvKFVr4Joso6/CtlHdDxszFh8Um6WMBou6+5qQdB/qI8sTkl0SsN6xVN+S3Wj08vnl+S7YDGhwiBX9jqWtdpyOsAiAsyzuDUlE6gAN83JNM+ELN7dx/XwVArBARN/wk7EpAwgL2RFOlwpdzBwBF/2oAYglFziI8MWTmE4h4geFUhA0clFrL/b4qgFi2sMKVmTwJC8hTWc8MbDnVW0ZPqwMIP2wpG8ujazcu9YndDbsMVaxzlqsDyJCPsG5aL7BOwgfuievYPr59/mudarTeWa0SILEgUUZ/Rl+X5ahEVAm3JeUcFmdru1qAxIHELrqrO0mQsHIij5hbUp5N/8mOVw2QQ/n34gv8+EzHMpmtKZwtI15JCQOW1IjW4IgDswHEWmqtzMlFaD83Px+kL0iLK6nG32KYnm/0MlpTUt6FmTt1ozbmF2P0lda97PVOfdUbvZV+v14K5/MBxG8ysySjcSDpvclG61tUgBL5xh4ebD7Y8vFO61fdTY1aPWyU/ozOW0qhxv10PFcX75XRr+n+4w0S3Xd8iwoBkn7AxseOTmC7y9f8Z836OVEKJ5FvDHPn5h3+tZX4R0Nj1Sqez+XnStFYJ0D6+EI0WR4zIkmRHUCRCqmGOXK3sGMLj2UsdLyn3lOfUe4UGFy/1wsQZmjDJT5ZkPv52Uc3N4ZbBPDPlpt3YOAYj2e2ucIvifCSaxy4cue2rxggffyfaxuz7T0+FOCyGWvPBUe6QsqFNPRm0d6D2cJMnyedbpnn0o9xNa1V5QDpQZJ7BTkp5Erj/9HXnEM/QYU06s5Wi7DkuOdx6iKpv6R9KHKEQtEawWE5swCAlAHJ3N6Em5T7QD0OUQ40mVfIOlBseOMN80abQWPAMZSGrdeZ64m92QBiLcYeofTptK6huZc6oRYy+tIJN+Rg9on/uC1VnnWFVz4rbGm62F3c+EKbw7hx3tr1Hsh0Lj4P45vzyabOmZL32QAyhBOsJLMQSKzC5H18k4ANQKcvxKI8EbU2QX0/nblPfuN+fG1gcHSDxoEXMlCBRrMDxM6NlQMAypPKlOH7ucIuNNRxbp0H+eMFCtNSO+cw6cMFEB44eolwwSuhB1UApFaQzBJuMS5ac1excEvLCdN8yuYKr6bFBpe3cwGEPCvDBO+qAMJWxszMSi+hRooH9ABD767YHvVA7jANB1hn2D5+N1NKH99enxje03bH45DgKJiHjumpxoPYSfEX7/Ksk7BCvkgceD9jAsQd3+NK7kyeQePjBJhn/u4kvV+07FMMer/WHKXgqgBSA0iitqjbdQeNlVIpPKHW/yhPcjwNgMbrvjANWRdxfusBF6sY42FSA8ieMTGeRBt1l1IrZ4d4+7laRey2cWv1nlJ+5HcuQHz5G6pM/gVHevHQ6Wk9HoReaT/mTsdXo74c/V+md0X4TbWpzoMcW0bOHidaoD5mxOUb/Qqx7fNEkL6BrKexf3aV20YVRl91obXdnq76f3NW08NeBN+mH9oJ7PMkyOLglA1o6GrBYXbmymj9qQEkAGG+J+HvAkaFNp7mYJ05VhENeSiL5vvdGRoyLK6fD6eGJxQuUXQOpfP+MaDT/VjD966kPca7xvJz+K5aDxLvSTrbTG5yjA2pxtvw0XwFDXdShOnNJbR6sKf2kPATAUkKOKb0DSv8ZqNedN5T/bwbTpO6qmMx3jWFp713z/CHWFYOsXHK7A+5kPmdsuU4ZKkJHMNcw3MyW6P0Vhv1NXQpRRAktuLkqTZRnoOjZi46ShgZ1xwXARA78fhV7WNvEldNOe6DE5ZxDAFHiVxtcdrCHpZDX5dSafWS2juG0oZsXUH7kmi3GIAMxHKF13/XexPeFvD9iJM4npPQSyoOImyep5UBiSSNoWJB7iMPPv4uDiCWENxSImoVaDOp6bNCM3CxLXGGJ59TSfDxB2kgkQIHFR1IjRPD60UC5CnkEjzqOlUc100mNeYdIaEfJcHelWo/SCQT8sGwjedrlL7yVbOGdnOCw85hsQBJy0v8ahWzy3QKrrnCAQos/vuKT0EiDQ7UuIxpmKOsO+XhogGSlpc41MkTFtWcd3DChnCOcgBJDeCY23MMfF0FQCRCLp9A1gKOQeAUSLpihmfbTIzScj2H9eBG/7iVvl2TY0iOvFjsh5Q73zg20I2/yVH+jEvew1syXOcdnLTPlJTHyI9X7epHiAl3cHD0u3rHC4UxdOX4ZjUeJAYc1OITKmCqnxyCS+2TAxJZcByu/+mAV/G9vItP0gcl4YRBT4pFWHx8vQU/e5Gq1NLfIyCRBkeNBYwQXxfvQfjgoHe5cvqMiculFT2lv5AhOHdwrMKDoGFQr0TYJkYqfzpWyP0TDvtNgbWHDOO5h8JSWXCUu7YpxVi4vl20B+HkHWiewAOcTxynoLF3+NrWtVRnioJjYBNj+720osf2t2iAwMoMVpjg/mK5fUiAnh4O6nbY7h+TsT+XuBwvFEKKe44prxYGkkUDxHVmYCoPNEfAk/JkdAQ7cN0IIjliOXBYL9qfkjz5WxBIFgsQJJFGrSHSl6SShvrKCZCS4LDVquDmzoWAZLEAQfIPRNlYO3QLoASZc8w0SoJjvNFz6SBZLUDkk/JAyBCjsZ5vcgBkLnAMJC4ZJKsFCHLZMZqUjy9psLek2zPU3UutjksHUrEiDZC5wbF0kCwWIEjeEErQke8H4fr6wc5b8CAjCZBawAGBBKw08riZ3nqxAMFyB/fCoAQ4XKy3c7pUl1fdnU77mzq4nkYKILWBY6kgWSxALMOxEKnfKWqvvkFOsB0pvqBVe/I208vQJkiTAEg5cIQvbOh3QtvL8H6+HC+QBo2bIM/T/cfCTxQilaxYJqFJPqd/xHOlAqQkODraobt4Tz35UkCyaA+C7EblKPChbZ4durkBUhwcA8McIDm9FXOZIFk0QKx8cngRdPWdC76cAJkNHCsHyeIBYuUjuU0kFzjsPHMBpBw49u95+G5IWaEnqRIg42oQsn2culcJtfQ5wZELIEHQRSS8yHvnQYOUASToliFUzpx21QHEGTKBgo73JPQhKg5TfW2lPUiwv4i9Tgg4BtrKgoQ+xyMhH1cfVQFEwhryvEn8myIxApEGiFehM4NjFpBE0BQjo+k3VQEk/JAjr7I0XuXuF+vsIzX7P3u1jT178e76gwQT0T4kAeLlVYQicTzHlNYcnsTHp9whcFUexEUsdcVOjquCUOWWaCcKkG4RbnLeojA4JD3J9DIHlwFYDUC6ypLjeeAjJXPkFdTKeOoimoSSp/QhBRBXnhazsJniOaQ9yVS2Tl6BuWiKjIqEWD1AHBZuNLrzIfnfvn/wPoYZYR0lGSXRlxRAXGENt9IjCQ7ak7hzvS5fVBfvXS9guVbaY4xAqtyy5CB2UpQ3cN0w4l8Zn6+Kkcrg8fc5AcIJP3KAIxYkIf6eRCEzGMlsAIFWuB0EH79vYa6Q97ollThnXzkBgnqQnOCQBElKuV9ShtkAgm1H579KK0l86b6kAOLuh67ylQCHFEhcc0WNgKRcswEEC7P2pMyQfEkyEe1LCiBe4xPgY0lwpILEV8Keo4qZFSCwF+k4auwLrHfI1hJUIWtrJwWQrgjiK2hMwlbquQPXS1qSfAvvbjjsYBi2F/006r3zKPNMRjQrQFhe5Egq+5sJJSVVRV+ee6JGc0NL2ZTi912Gx+Mk9insi98C1I86R/VqoDc7QE7PBaSwev3fogCxnOB56GPelQIHHW7RMi091/GMsgMkVZA0+9bVggMQS3lf7VHvKW9x4FKZjZkuqfA9yXxzLeZBhoGgsu+6dD2KGi5AngzQ7vK1d5F1P5M5Q5WBGfApUG3ua3hxqogHGTNnk+3p5ih9rO6jGIAcGSF7m8rRgaZ+FXuzUQ//eXP9UAvBT7uuN+YXu5m0y5jsJd47/WfpTaQhnhQFyGDt/M8R1yK++eaRApD5Zr3ekYsDZGztdlq/ynE74ZLF1QBSl/RmA8jAhm5tQJlX3AvW6mKj3GwaQOR4KdHT7AAZE2HjUvvfw+2EEgQurY+/3j2/X9qc1zzfqgCyZkY32pbJgQaQZcqtzboQB/4PyzGSfHUbFdcAAAAASUVORK5CYII=', NULL, '超级管理员', '2024-05-09 15:49:39', '超级管理员', '2024-05-09 15:51:36', '');
-- 修改物联数据总览菜单排序
update sys_menu set order_num =25,menu_name='数据总览' where id='1764951130651414529';
-- 安全员默认赋予菜单权限
delete from sys_role_menu where menu_id in ('1787728646959206402','1788020750918815745','1788476228704907266');
insert into sys_role_menu (role_id, menu_id) VALUES ('122', '1787728646959206402');
insert into sys_role_menu (role_id, menu_id) VALUES ('122', '1788020750918815745');
insert into sys_role_menu (role_id, menu_id) VALUES ('122', '1788476228704907266');

-- 机构补充信息和GA38填写信息导出按钮
delete from sys_menu where id in ('01788377780888264705','01788377908143448066');
INSERT INTO sys_menu (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01788377780888264705, '导出机构补充信息', 103, 9, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dept:exportOrgExtend', '1', NULL, NULL, '超级管理员', '2024-05-09 09:17:44', '', NULL, '');
INSERT INTO sys_menu (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01788377908143448066, '导出安全防范设施建设达标信息', 103, 10, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dept:exportDefenseDetailExtend', '1', NULL, NULL, '超级管理员', '2024-05-09 09:18:14', '', NULL, '');

delete from sys_dict_data where dict_type='video_diagnosis_state' and dict_label in ('未知');
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '未知', '2', 'video_diagnosis_state', NULL, 'default', 'N', '0', '超级管理员', '2024-05-13 11:07:08', '', NULL, NULL);

-- 修改索引类型
-- 先删除重复的数据
DELETE
FROM
    mediator_video_integrity_check
WHERE
        id IN (
        SELECT * FROM (SELECT
                           c.id
                       FROM
                           mediator_video_integrity_check c
                               INNER JOIN ( SELECT equipment_code, channel_code FROM mediator_video_integrity_check GROUP BY equipment_code, channel_code HAVING COUNT(*)> 1 ) s ON c.equipment_code = s.equipment_code
                               AND c.channel_code = s.channel_code) t);

-- 在重建索引
ALTER TABLE `mediator_video_integrity_check`
DROP INDEX `idx_code`,
ADD UNIQUE INDEX `idx_code`(`channel_code`(191), `equipment_code`(191)) USING BTREE;

-- 修改字段命名
UPDATE sys_dict_data set dict_label ='红外探测器' WHERE dict_type ='sensor_device_type' and dict_label ='红外传感器';
UPDATE sys_dict_data set dict_label ='烟雾感应器' WHERE dict_type ='sensor_device_type' and dict_label ='烟雾传感器';
UPDATE sys_dict_data set dict_label ='门窗磁传感器' WHERE dict_type ='sensor_device_type' and dict_label ='门磁、窗磁传感器';
UPDATE sys_dict_data set dict_label ='燃气感应器' WHERE dict_type ='sensor_device_type' and dict_label ='燃气报警器';
