/usr/share/zoneminder/db/zm_update-1.22.1.sql is in zoneminder 1.26.5-1ubuntu3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | --
-- This updates a 1.22.1 database to 1.22.2
--
--
-- Add missing Zone Preset
--
replace into ZonePresets values (6,'Best, high sensitivity','Active','Percent','Blobs',20,NULL,8,NULL,3,3,6,NULL,5,NULL,1,NULL);
--
-- Remove redundant Zone columns
--
alter table Zones drop column LoX;
alter table Zones drop column HiX;
alter table Zones drop column LoY;
alter table Zones drop column HiY;
--
-- 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;
|