mirror of
https://github.com/ZoneMinder/zoneminder.git
synced 2025-12-23 22:37:53 -05:00
8b30f67bcd
git-svn-id: http://svn.zoneminder.com/svn/zm/trunk@1705 e3e1d417-86f3-4887-817a-d78f3d33393f
9 lines
308 B
SQL
9 lines
308 B
SQL
--
|
|
-- 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;
|