forked from ZoneMinder/zoneminder
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathzm_update-1.23.3.sql
83 lines (72 loc) · 4.08 KB
/
zm_update-1.23.3.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
--
-- This updates a 1.23.3 database to 1.24.0
--
--
-- Add protocol column for monitors
--
alter table Monitors add column `Protocol` varchar(16) not null default '' after `Format`;
alter table MonitorPresets add column `Protocol` varchar(16) default NULL after `Format`;
update Monitors set Protocol = "http" where Type = "Remote";
update MonitorPresets set Protocol = "http" where Type = "Remote";
--
-- Add method column for monitors;
--
alter table Monitors add column `Method` varchar(16) not null default '' after `Protocol`;
alter table MonitorPresets add column `Method` varchar(16) default NULL after `Protocol`;
update Monitors set Method = "simple" where Type = "Remote" and ( select Value from Config where Name = "ZM_NETCAM_REGEXPS" ) = 0;
update Monitors set Method = "regexp" where Type = "Remote" and ( select Value from Config where Name = "ZM_NETCAM_REGEXPS" ) = 1;
update MonitorPresets set Method = "simple" where Type = "Remote" and ( select Value from Config where Name = "ZM_NETCAM_REGEXPS" ) = 0;
update MonitorPresets set Method = "regexp" where Type = "Remote" and ( select Value from Config where Name = "ZM_NETCAM_REGEXPS" ) = 1;
--
-- Add subpath for remote RTSP monitors (only for now at least)
--
alter table Monitors add column `SubPath` varchar(64) not null default '' after `Path`;
alter table MonitorPresets add column `SubPath` varchar(64) default NULL after `Path`;
--
-- Update Palette for new meaning as Colours for non-Local monitors
--
update Monitors set Palette = 3 where Type != 'Local' and Palette = 4;
update MonitorPresets set Palette = 3 where Type != 'Local' and Palette = 4;
--
-- Update Method for Local monitors
--
update Monitors set Method = "v4l1" where Type = 'Local';
--
-- Add monitor type for FFMPEG cameras
--
alter table Monitors modify column `Type` enum('Local','Remote','File','Ffmpeg') NOT NULL default 'Local';
alter table MonitorPresets modify column `Type` enum('Local','Remote','File','Ffmpeg') NOT NULL default 'Local';
--
-- Fix columns to fit V4L2 formats and palettes
--
alter table Monitors modify column `Format` int(10) unsigned NOT NULL default '0';
alter table Monitors modify column `Palette` int(10) unsigned NOT NULL default '0';
alter table MonitorPresets modify column `Channel` tinyint(3) unsigned default NULL;
alter table MonitorPresets modify column `Format` int(10) unsigned default NULL;
alter table MonitorPresets modify column `Palette` int(10) unsigned default NULL;
--
-- Add in new MPEG presets
--
insert into MonitorPresets values ('','Axis IP, mpeg4, unicast','Remote',NULL,NULL,NULL,'rtsp','rtpUni','<ip-address>',554,'/mpeg4/media.amp','/trackID=',NULL,NULL,3,NULL,0,NULL,NULL,NULL,100,100);
insert into MonitorPresets values ('','Axis IP, mpeg4, multicast','Remote',NULL,NULL,NULL,'rtsp','rtpMulti','<ip-address>',554,'/mpeg4/media.amp','/trackID=',NULL,NULL,3,NULL,0,NULL,NULL,NULL,100,100);
insert into MonitorPresets values ('','Axis IP, mpeg4, RTP/RTSP','Remote',NULL,NULL,NULL,'rtsp','rtpRtsp','<ip-address>',554,'/mpeg4/media.amp','/trackID=',NULL,NULL,3,NULL,0,NULL,NULL,NULL,100,100);
insert into MonitorPresets values ('','Axis IP, mpeg4, RTP/RTSP/HTTP','Remote',NULL,NULL,NULL,'rtsp','rtpRtspHttp','<ip-address>',554,'/mpeg4/media.amp','/trackID=',NULL,NULL,3,NULL,0,NULL,NULL,NULL,100,100);
insert into MonitorPresets values ('','ACTi IP, mpeg4, unicast','Remote',NULL,NULL,NULL,'rtsp','rtpUni','<ip-address>',7070,'','/track',NULL,NULL,3,NULL,0,NULL,NULL,NULL,100,100);
--
-- Get rid of never used columnn Learn State
--
alter table Events drop column LearnState;
--
-- Update for new event close mode
--
update Config set Value = "time" where Name = "ZM_EVENT_CLOSE_MODE" and ( select Value from ( select * from Config ) as TempConfig where Name = "ZM_FORCE_CLOSE_EVENTS" ) = 1;
update Config set Value = "idle" where Name = "ZM_EVENT_CLOSE_MODE" and ( select Value from ( select * from Config ) as TempConfig where Name = "ZM_FORCE_CLOSE_EVENTS" ) = 0;
--
-- These are optional, but we might as well do it now
--
optimize table Frames;
optimize table Events;
optimize table Filters;
optimize table Zones;
optimize table Monitors;
optimize table Stats;