huludao/sql-script/20240722.sql at 89c2173e0fc7acbd67dfd99463a18010f4865512

Fork: 0
NFDev / huludao
Find file
Newer
Older
huludao / sql-script / 20240722.sql
新烽开发者 on 23 Jul 10 KB 视频监控管理，视频摄像头31路视频可播放，目前随机选择相机，播放的都是同一路相机的视频。问题解决
Raw Blame History
ALTER TABLE huludao_main.camera_info ADD del_flag char(1) NULL COMMENT '删除标志（0代表存在 2代表删除）';
INSERT INTO huludao_main.camera_info
(id, device_code, device_name, site_id, channel_id, stream_id, status_online, camera_type, x, y, del_flag)
VALUES(40, '6K0685FPAZ41D12', '茨山河-碧桂园', NULL, '6', 1, 0, 0, NULL, NULL, '0');
INSERT INTO huludao_main.camera_info
(id, device_code, device_name, site_id, channel_id, stream_id, status_online, camera_type, x, y, del_flag)
VALUES(41, '6K0685FPAZ41D12', '五里河华商空调大厦', NULL, '14', 1, 0, 0, NULL, NULL, '0');
INSERT INTO huludao_main.camera_info
(id, device_code, device_name, site_id, channel_id, stream_id, status_online, camera_type, x, y, del_flag)
VALUES(44, '6K0685FPAZ41D12', '海航路沈山框构桥', NULL, '28', 1, 0, 0, NULL, NULL, '0');
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河泰康桥西侧', site_id='48', channel_id='0', stream_id=1, status_online=0, camera_type=1, x='120.8556253364', y='40.7378522542', del_flag='0'
WHERE id=1;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河泰康桥东侧', site_id='47', channel_id='1', stream_id=1, status_online=0, camera_type=0, x='120.8617451038', y='40.7378533947', del_flag='0'
WHERE id=2;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河龙城花苑', site_id='0', channel_id='2', stream_id=1, status_online=0, camera_type=0, x='120.8497592079', y='40.7170042151', del_flag='0'
WHERE id=3;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河化工桥西侧', site_id='0', channel_id='3', stream_id=1, status_online=0, camera_type=0, x='120.8091583492', y='40.7576357273', del_flag='0'
WHERE id=4;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河化肥桥与化工桥', site_id='15', channel_id='4', stream_id=1, status_online=0, camera_type=0, x='120.8177238293', y='40.7521669988', del_flag='0'
WHERE id=5;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河化机桥西侧', site_id='0', channel_id='5', stream_id=1, status_online=0, camera_type=0, x='120.8320179244', y='40.7518414779', del_flag='0'
WHERE id=6;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='永昌路铁路桥-易涝点', site_id='0', channel_id='6', stream_id=1, status_online=0, camera_type=0, x='120.8711676340', y='40.7583329753', del_flag='2'
WHERE id=7;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河新华大街东侧', site_id='49', channel_id='7', stream_id=1, status_online=0, camera_type=0, x='120.8424401490', y='40.7426141243', del_flag='0'
WHERE id=8;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='龙湾大街-大润发', site_id='8', channel_id='8', stream_id=1, status_online=0, camera_type=0, x='120.8643325260', y='40.7320770952', del_flag='0'
WHERE id=9;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='渤海街铁北路-易涝点', site_id='3', channel_id='9', stream_id=1, status_online=0, camera_type=0, x='120.8567313382', y='40.7658535499', del_flag='0'
WHERE id=10;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='望海街-易涝点', site_id='5', channel_id='10', stream_id=1, status_online=0, camera_type=0, x='120.9480676730', y='40.7138504052', del_flag='0'
WHERE id=11;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='新华大街-金秋宾馆', site_id='4', channel_id='11', stream_id=1, status_online=0, camera_type=0, x='120.8439596546', y='40.7495700479', del_flag='0'
WHERE id=12;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='连山大街-新兴医院', site_id='7', channel_id='12', stream_id=1, status_online=0, camera_type=0, x='120.8755650223', y='40.7661528666', del_flag='0'
WHERE id=13;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='锦葫路-公铁桥', site_id='11', channel_id='13', stream_id=1, status_online=0, camera_type=1, x='120.8530734077', y='40.7438474183', del_flag='0'
WHERE id=14;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河光明苑', site_id='0', channel_id='14', stream_id=1, status_online=0, camera_type=1, x='120.8531859706', y='40.7182507738', del_flag='2'
WHERE id=15;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河茨山南桥', site_id='0', channel_id='15', stream_id=1, status_online=0, camera_type=1, x='120.8947132857', y='40.7265700096', del_flag='0'
WHERE id=16;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='连山河小刘台子', site_id='0', channel_id='16', stream_id=1, status_online=0, camera_type=1, x='120.8387006332', y='40.7784094487', del_flag='2'
WHERE id=17;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='新兰花-易涝点', site_id='6', channel_id='17', stream_id=1, status_online=0, camera_type=1, x='120.9497914140', y='40.7199383163', del_flag='0'
WHERE id=18;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河海翔路桥西侧', site_id='0', channel_id='18', stream_id=1, status_online=0, camera_type=1, x='120.8458711829', y='40.7408626515', del_flag='0'
WHERE id=19;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='化工桥-易涝点', site_id='2', channel_id='19', stream_id=1, status_online=0, camera_type=0, x='120.8218234528', y='40.7492211269', del_flag='0'
WHERE id=20;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='连山河佟家屯处', site_id=NULL, channel_id='20', stream_id=1, status_online=0, camera_type=0, x='120.8315622990', y='40.7807204503', del_flag='2'
WHERE id=21;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河新华大街西侧', site_id='50', channel_id='21', stream_id=1, status_online=0, camera_type=0, x='120.8386773196', y='40.7458016012', del_flag='0'
WHERE id=22;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河帝泊湾处', site_id=NULL, channel_id='22', stream_id=1, status_online=0, camera_type=0, x='120.8580394284', y='40.7185377974', del_flag='0'
WHERE id=23;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河印象江南处', site_id=NULL, channel_id='23', stream_id=1, status_online=0, camera_type=0, x='120.8706997402', y='40.7190337766', del_flag='0'
WHERE id=24;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河齐白线西侧', site_id=NULL, channel_id='24', stream_id=1, status_online=0, camera_type=0, x='120.8890283269', y='40.7198241851', del_flag='0'
WHERE id=25;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='海航路锦葫路立交桥', site_id='9', channel_id='25', stream_id=1, status_online=0, camera_type=0, x='120.8584847114', y='40.7419586441', del_flag='0'
WHERE id=26;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='龙程北街铁路桥', site_id='13', channel_id='26', stream_id=1, status_online=0, camera_type=0, x='120.8862101081', y='40.7414096998', del_flag='0'
WHERE id=27;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河帝泊湾处', site_id=NULL, channel_id='27', stream_id=1, status_online=0, camera_type=0, x='120.8634704024', y='40.7173974589', del_flag='0'
WHERE id=28;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河虹京名成售楼处', site_id=NULL, channel_id='28', stream_id=1, status_online=0, camera_type=0, x='120.8794186966', y='40.7210980512', del_flag='2'
WHERE id=29;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河湿地公园处', site_id=NULL, channel_id='29', stream_id=1, status_online=0, camera_type=0, x='120.8301071279', y='40.7139256613', del_flag='2'
WHERE id=30;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河化机桥东侧', site_id=NULL, channel_id='30', stream_id=1, status_online=0, camera_type=0, x='120.8359191766', y='40.7466369066', del_flag='0'
WHERE id=31;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='茨山河百莲花园处', site_id=NULL, channel_id='20', stream_id=1, status_online=0, camera_type=0, x='120.8337674793', y='40.7144517971', del_flag='0'
WHERE id=32;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='武装部-易涝点', site_id='1', channel_id='16', stream_id=1, status_online=0, camera_type=0, x='120.8685116739', y='40.7161339816', del_flag='0'
WHERE id=33;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='五里河玉皇桥西侧', site_id='46', channel_id='29', stream_id=1, status_online=0, camera_type=0, x='120.8663192876', y='40.7352461541', del_flag='0'
WHERE id=34;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='LSHSP4锦东石材城处', site_id=NULL, channel_id='34', stream_id=1, status_online=0, camera_type=0, x='120.8805300806', y='40.7641501757', del_flag='2'
WHERE id=35;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='NVR-1D12-36', site_id=NULL, channel_id='35', stream_id=1, status_online=0, camera_type=0, x=NULL, y=NULL, del_flag='2'
WHERE id=36;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='NVR-1D12-37', site_id=NULL, channel_id='36', stream_id=1, status_online=0, camera_type=0, x=NULL, y=NULL, del_flag='2'
WHERE id=37;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='NVR-1D12-38', site_id=NULL, channel_id='37', stream_id=1, status_online=0, camera_type=0, x=NULL, y=NULL, del_flag='2'
WHERE id=38;
UPDATE huludao_main.camera_info
SET device_code='6K0685FPAZ41D12', device_name='NVR-1D12-39', site_id=NULL, channel_id='38', stream_id=1, status_online=0, camera_type=0, x=NULL, y=NULL, del_flag='2'
WHERE id=39;