/usr/share/zoneminder/db/zm_update-0.9.8.sql is in zoneminder 1.25.0-4.
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 | --
-- This updates a 0.9.8 database to 0.9.9
--
update Monitors set Colours = Colours * 8;
optimize table Events;
alter table Events modify column Length numeric( 10, 2 ) not null default 0.00;
optimize table Frames;
alter table Frames add column Delta numeric( 8, 2 ) not null default 0.00 after TimeStamp;
|