ZoneMinder
/
zoneminder
mirror of https://github.com/ZoneMinder/zoneminder.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
zoneminder/db
History
Isaac Connor e6ace6fcf4 feat: add AUDIT logging level for tracking administrative changes 
Add a new AUDIT logging level (-5) between PANIC (-4) and NOLOG (shifted
to -6) across C++, PHP, and Perl loggers. AUDIT entries use code 'AUD'
and syslog priority LOG_NOTICE. They record who changed what, from where,
for monitors, filters, users, config, roles, groups, zones, states,
servers, storage, events, snapshots, control caps, and login/logout.

AUDIT entries have their own retention period (ZM_LOG_AUDIT_DATABASE_LIMIT,
default 1 year) separate from regular log pruning. The log pruning in
zmstats.pl and zmaudit.pl now excludes AUDIT rows from regular pruning
and prunes them independently.

Critical safety: the C++ termination logic is changed from
'if (level <= FATAL)' to 'if (level == FATAL || level == PANIC)' to
prevent AUDIT-level log calls from killing the process.

Includes db migration zm_update-1.39.1.sql to shift any stored NOLOG
config values from -5 to -6.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
 		2026-02-23 18:19:20 -05:00
..
CMakeLists.txt Reload triggers for 1.37.77 2026-01-24 11:24:56 -05:00
Object_Types.sql Add Object_Types table and perl code to use it. 2024-03-29 18:42:46 -04:00
User_Preferences.sql Fix typo 2023-03-22 13:28:35 -04:00
manufacturers.sql Add Ubiquiti to Manufacturers 2023-04-22 13:33:18 -04:00
models.sql Use UPSERTS and add some more models 2021-11-15 16:30:17 -05:00
monitors_dbupdate.sql Allows users to set an specific "Onvif alarm text" for each monitor (#3535) 2022-07-20 12:51:13 -05:00
test.monitor.sql Update test.monitor.sql 2013-12-24 11:07:27 +00:00
triggers.sql Remove events_insert_trigger 2026-01-24 11:16:07 -05:00
zm_create.sql.in feat: store zone coordinates as percentages for resolution independence 2026-02-23 18:19:20 -05:00
zm_update-0.0.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.7.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.8.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.9.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.10.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.11.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.12.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.13.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.15.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-0.9.16.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.17.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.17.2.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.18.0.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.18.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.19.0.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.19.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.19.2.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.19.3.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.19.4.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.19.5.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.20.0.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.20.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.21.0.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.21.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.21.2.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.21.3.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.21.4.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.22.0.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.22.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.22.2.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.22.3.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.23.0.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.23.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.23.2.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.23.3.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.24.0.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.24.1.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.24.2.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.24.3.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.24.4.sql Migrate svn to git 2013-03-17 00:45:21 +01:00
zm_update-1.26.0.sql check for existence of the columns beefore trying to add them 2014-10-22 10:31:23 -04:00
zm_update-1.26.1.sql Modify zmupdate for 1.26.1 and 1.26.2 releases 2013-09-07 15:08:09 -05:00
zm_update-1.26.2.sql Modify zmupdate for 1.26.1 and 1.26.2 releases 2013-09-07 15:08:09 -05:00
zm_update-1.26.3.sql exclude zm_update-1.26.3.sql since it has already been added 2013-09-10 13:14:16 -05:00
zm_update-1.26.5.sql Change default alarm blend percent to 6 and make upgrades smooth by copying the existing blend percent to the alarm one 2014-01-05 08:59:09 +02:00
zm_update-1.27.0.sql I don't know why this never has the right # of coumns, so let's be specific 2014-07-09 11:44:07 -04:00
zm_update-1.28.0.sql Zoneminder 1.28.0 Release 2014-10-18 15:23:13 -05:00
zm_update-1.28.1.sql alter the type of Device in the Monitors table to tinytext, which matches the MonitorPresets table, and increases the length to 255 2014-12-10 16:56:22 -05:00
zm_update-1.28.99.sql Change SQL to add Controls for ONVIF camera, Foscam 9831W and 8918W to specify columns so that if other columns are present the sql still executes. Fixes #3260 2021-05-28 10:24:13 -04:00
zm_update-1.28.100.sql Add analysis fps paramter to monitors 2015-07-22 21:38:35 +02:00
zm_update-1.28.101.sql Merge branch 'add_analysis_interval' of https://github.com/manupap1/ZoneMinder into manupap1-add_analysis_interval 2015-08-18 20:20:53 -05:00
zm_update-1.28.102.sql Fix message if Exif already exists 2015-09-17 15:16:05 -04:00
zm_update-1.28.103.sql Added SQL changes to zm_create.sql.in 2015-08-17 15:05:17 +02:00
zm_update-1.28.104.sql Merge branch 'add_analysis_interval' of https://github.com/manupap1/ZoneMinder into manupap1-add_analysis_interval 2015-08-18 20:20:53 -05:00
zm_update-1.28.105.sql bump version to 1.28.106 2015-08-29 07:53:08 -05:00
zm_update-1.28.106.sql bump version to 1.28.106 2015-08-29 07:53:08 -05:00
zm_update-1.28.107.sql Monitor->Frames, since we are updating Frames 2015-11-11 16:43:57 -05:00
zm_update-1.28.108.sql Stray semicolon causes SQL error 2015-10-24 17:58:20 -04:00
zm_update-1.28.109.sql Corrected update version comment to 1.28.109 2016-01-22 10:46:46 -06:00
zm_update-1.28.110.sql Corrected update version comment to 1.28.110 2016-01-22 10:48:47 -06:00
zm_update-1.29.0.sql Bump version to 1.29.0 2016-01-01 10:15:36 -06:00
zm_update-1.30.0.sql bump project to 1.30.0 2016-05-31 19:41:17 -05:00
zm_update-1.30.1.sql add a db update script to update the Messages column to a TEXT type. 2016-12-12 21:55:32 -05:00
zm_update-1.30.2.sql Merge branch 'sanitize_image_path' of https://github.com/knnniggett/ZoneMinder into storageareas_sanitize 2017-01-25 17:14:30 -05:00
zm_update-1.30.3.sql bump 1.30.3 release 2017-05-02 13:25:56 -05:00
zm_update-1.30.4.sql 1.30.4 release 2017-05-09 09:54:48 -05:00
zm_update-1.31.0.sql do some output to tell use what we are doing during update process 2018-01-19 16:32:48 -05:00
zm_update-1.31.1.sql do some output to tell use what we are doing during update process 2018-01-19 16:32:48 -05:00
zm_update-1.31.2.sql do some output to tell use what we are doing during update process 2018-01-19 16:32:48 -05:00
zm_update-1.31.3.sql do some output to tell use what we are doing during update process 2018-01-19 16:32:48 -05:00
zm_update-1.31.4.sql add Manufacturers and Models Tables 2017-08-25 15:35:17 -04:00
zm_update-1.31.5.sql escape the word Groups 2020-11-23 19:31:21 -05:00
zm_update-1.31.6.sql wip nvsocket 2017-10-03 13:28:56 -07:00
zm_update-1.31.7.sql escape the word Groups 2020-11-23 19:33:53 -05:00
zm_update-1.31.8.sql make DiskSpace be a bigint 2017-10-11 14:07:01 -04:00
zm_update-1.31.9.sql fix typo 2017-10-16 08:30:28 -07:00
zm_update-1.31.10.sql add Monitor status, capturrFPS and AnalysisFPS to processes 2017-10-24 16:08:31 -07:00
zm_update-1.31.11.sql lots more debugging. re-add status update command on failure 2017-11-22 01:18:07 -05:00
zm_update-1.31.12.sql add position clearing to other Layouts 2017-11-01 11:56:18 -04:00
zm_update-1.31.13.sql After adding SaveJPEGs to Events, need to populate them with SaveJPegs from MOnitors 2020-09-24 13:43:05 -04:00
zm_update-1.31.14.sql make zmwatch.pl update columns in the Monitors table for Event And DiskSpace counts 2017-11-22 17:03:37 -08:00
zm_update-1.31.15.sql need the update file 2017-11-26 15:08:12 -05:00
zm_update-1.31.16.sql ned to actually remove the MonitorIds column 2017-12-09 14:05:18 -05:00
zm_update-1.31.17.sql fix triggers 2018-02-18 11:01:33 -05:00
zm_update-1.31.18.sql Fix Update DiskSpace Filter adding 2018-01-01 13:19:16 -05:00
zm_update-1.31.19.sql Fix Storage DiskSpace updating when Event.DiskSpace IS NULL 2018-01-08 15:42:28 -05:00
zm_update-1.31.20.sql Update all the event counts in the Monitors so that Triggers can be acurate 2018-01-10 14:40:42 -05:00
zm_update-1.31.21.sql Fix Zone Triggers, bump version 2018-01-16 11:49:17 -05:00
zm_update-1.31.22.sql Fix Zone Triggers, bump version 2018-01-16 11:49:17 -05:00
zm_update-1.31.23.sql handle case where zmstats and zmstats.pl both exist 2018-01-22 14:05:38 -05:00
zm_update-1.31.24.sql Fix Day=>Wek 2018-01-19 13:29:45 -05:00
zm_update-1.31.25.sql add update 2018-01-19 12:17:42 -05:00
zm_update-1.31.26.sql update triggers to use coalesce 2018-01-19 13:03:47 -05:00
zm_update-1.31.27.sql ad update to update events_update_trigger to dix totaldiskspace 2018-01-23 18:43:59 +01:00
zm_update-1.31.28.sql Fix commas 2018-01-24 12:16:18 -05:00
zm_update-1.31.29.sql Rename column Id OF Monitor_Statuses to simplify JOINS. 2018-01-26 13:39:37 -05:00
zm_update-1.31.30.sql.in use make macros in zm_update-1.31.30.sql.in 2018-04-19 07:43:43 -05:00
zm_update-1.31.31.sql make DiskSpace in storage table be int instead of unsigned. Event deletions can make it go negative and then the delete fails. 2018-02-01 11:32:55 -05:00
zm_update-1.31.32.sql Allow Method in Monitors to be NULL 2018-02-02 10:31:55 -05:00
zm_update-1.31.33.sql use COALESCE to ensure integer values 2018-02-03 11:01:33 -05:00
zm_update-1.31.34.sql fix typo 2018-02-05 22:59:37 -05:00
zm_update-1.31.35.sql add update triggers for all the event tables so that diskspace counts work 2018-02-05 15:46:39 -05:00
zm_update-1.31.36.sql add missing ; 2018-02-18 11:29:22 -05:00
zm_update-1.31.37.sql fix DiskSpace summing when Nulls are present 2018-02-07 08:02:49 -05:00
zm_update-1.31.38.sql split out codec and encoder, allowing one to specify which encoder to use 2018-02-28 07:17:16 -08:00
zm_update-1.31.39.sql refix triggers updating EventCounts. remove unsigned from eventcounts and diskspace totals. 2018-02-20 22:48:34 -05:00
zm_update-1.31.40.sql Merge branch 'storageareas' into zma_to_thread 2018-08-11 10:08:30 -04:00
zm_update-1.31.41.sql Convert event_id to a 64bit unsigned int 2018-04-12 13:40:11 -07:00
zm_update-1.31.42.sql Add SignalCheckPoints to Monitors 2018-04-19 10:09:32 -04:00
zm_update-1.31.43.sql Remove zm from alter statement 2018-08-28 10:37:02 -04:00
zm_update-1.31.44.sql implement capturing bandwidth 2018-04-24 14:11:27 -04:00
zm_update-1.31.45.sql repeat the update that adds Refresh to Monitors. Bump version. 2018-07-31 10:27:34 -04:00
zm_update-1.31.46.sql Stats.EventId must be a bigint too 2018-08-21 12:50:33 -04:00
zm_update-1.31.47.sql Merge branch 'master' into server_path_prefix 2018-11-22 10:04:33 -05:00
zm_update-1.32.0.sql bump sql to 1.32.0 2018-09-12 07:27:45 -05:00
zm_update-1.32.1.sql bump version to 1.32.1 2018-10-02 07:37:55 -05:00
zm_update-1.32.2.sql bump verion to 1.32.2 2018-10-13 13:36:15 -05:00
zm_update-1.32.3.sql fix missing bits. Implement UrlToIndex in Monitor and fix use of Url(). Implement PathToApi as well 2018-11-29 14:26:30 -05:00
zm_update-1.33.0.sql fix commas 2018-12-12 09:17:14 -05:00
zm_update-1.33.1.sql add WebSite type to enum (#2382) 2019-01-03 17:06:44 -05:00
zm_update-1.33.2.sql add missing db update script 2019-02-13 20:38:13 -05:00
zm_update-1.33.3.sql rename eventserver to eventnotification 2019-02-27 09:27:50 -05:00
zm_update-1.33.4.sql spacing updates. Use MP4 instead of H264/H265 in viewing codec dropdown 2019-03-19 12:16:31 -04:00
zm_update-1.33.5.sql Update Controls INSERTS to match new column count. Add a db update script to update the Controls table with the new CanReboot column 2019-04-02 09:05:52 -04:00
zm_update-1.33.6.sql Change MonitorIds from TinyText to TEXT. Fixes #2569 2019-04-07 17:23:39 -04:00
zm_update-1.33.7.sql Use GREATEST function prevent negative values in event counts 2019-04-24 10:38:08 -04:00
zm_update-1.33.8.sql Add a few missing GREATESTs in the triggers. 2019-04-30 17:29:18 -04:00
zm_update-1.33.9.sql fix update script 2019-05-13 14:48:26 -04:00
zm_update-1.33.10.sql End continuous events on alarm (#2644) 2019-06-24 11:29:00 -04:00
zm_update-1.33.11.sql add DecoderHWAccel fields to Monitors 2019-06-25 15:29:46 -04:00
zm_update-1.33.12.sql Add primary keys to Logs and Stats tables (#2653) 2019-07-07 08:26:06 -04:00
zm_update-1.33.13.sql Remove incorrect comment 2024-04-08 09:50:12 -04:00
zm_update-1.33.14.sql Add update script for SecondaryStorageArea capability in Events and Filters 2019-07-24 10:53:23 -04:00
zm_update-1.33.15.sql Change Orientation Enum to use strings instead of numbers as values. Sync them up with what we use in C code 2019-11-29 13:47:45 -05:00
zm_update-1.33.16.sql TEXT fields cannot have default values 2019-12-19 09:25:22 -05:00
zm_update-1.34.0.sql bump version for release to 1.34.0 2020-01-15 17:31:06 -05:00
zm_update-1.34.1.sql bump version to 1.34.1 for release 2020-01-24 17:01:47 -05:00
zm_update-1.34.2.sql release 1.34.2 2020-02-04 16:47:33 -05:00
zm_update-1.34.3.sql bump version to 1.34.3 2020-02-19 13:50:27 -05:00
zm_update-1.34.4.sql bump version for release 1.34.4 2020-02-24 14:44:19 -05:00
zm_update-1.34.5.sql Bump version to 1.34.5 for release 2020-02-25 20:46:59 -05:00
zm_update-1.34.6.sql Bump version for 1.34.6 2020-03-06 14:52:38 -05:00
zm_update-1.34.7.sql bump version to 1.34.7 2020-03-26 15:34:36 -04:00
zm_update-1.34.20.sql Add db update to drop default value for LabelFormat. Fixes #2896 2020-08-11 14:14:16 -04:00
zm_update-1.35.0.sql Add EmailTo,EmailSubject,EmailBody fields to Filter 2020-01-22 13:52:05 -05:00
zm_update-1.35.1.sql add Enabled to Storage 2020-03-04 10:15:44 -05:00
zm_update-1.35.2.sql Update zm_update-1.35.2.sql 2020-04-23 18:01:01 -04:00
zm_update-1.35.3.sql Add a db update to alter Frames.Id to a bigint 2020-05-05 18:04:24 -04:00
zm_update-1.35.4.sql Rename Config* to ONVIF_* 2020-05-12 15:46:07 -04:00
zm_update-1.35.5.sql Merge branch 'master' into add_user_to_filters 2020-06-05 17:08:14 -04:00
zm_update-1.35.6.sql bump version to 1.35.6 to pick a db fix from 1.34.20 2020-08-23 11:53:43 -04:00
zm_update-1.35.7.sql Add Latitude and Longitude to Monitors and monitor edit as well as using the geolocation api to auto-populate them 2020-09-24 09:01:30 -04:00
zm_update-1.35.8.sql Bump to 1.35.8. Change table engine to InnoDb for Monitor_Status. 2020-09-30 09:39:31 -04:00
zm_update-1.35.9.sql add Sessions table 2020-10-02 14:49:59 -04:00
zm_update-1.35.10.sql Add AutoUnarchive column to Filters 2020-10-12 10:53:19 -04:00
zm_update-1.35.11.sql Improved testing for existence of foreign keys, better descriptive output of steps. 2020-11-03 12:30:27 -05:00
zm_update-1.35.12.sql Add Locking to filters, bump db to 1.35.12. 2020-10-28 12:55:32 -04:00
zm_update-1.35.13.sql Use rename commands that work on mysql 5.7 2020-11-04 18:11:24 -05:00
zm_update-1.35.14.sql Fix logic ordering in 1.35.14 updated that moves columns from Monitors table to Monitor_Status 2021-10-20 13:14:04 -04:00
zm_update-1.35.15.sql Update stock PurgeWhenFull and UpdateDiskSpace filters to add EndTime terms. Add FOREIGN KEYS to Groups_Monitors and Groups.ParentId 2020-12-03 13:11:24 -05:00
zm_update-1.35.16.sql Add update script to add DecodeEnabled 2020-12-10 14:39:14 -05:00
zm_update-1.35.17.sql redo update from 1.31.40 2021-01-27 09:58:55 -05:00
zm_update-1.35.18.sql add RTSPServer column to Monitors 2021-02-02 23:19:52 -05:00
zm_update-1.35.19.sql Add RTSPStreamName to Monitors table. Bump version to 1.35.19 2021-03-01 16:46:48 -05:00
zm_update-1.35.20.sql WIP, rabbit hole too deep 2021-03-03 09:55:57 -05:00
zm_update-1.35.21.sql Rough in the ui for Snapshots 2021-03-12 09:28:05 -05:00
zm_update-1.35.22.sql Add MaxImageBufferCount and udpate values as appropriate in update script 2021-03-26 14:32:06 -04:00
zm_update-1.35.23.sql copy onvif.pm which isn't actually onvif to FoscamCGI.pm We will later replace onvif.pm with an Actual onvif implementation. 2021-03-30 18:32:42 -04:00
zm_update-1.35.24.sql.in Fixup event summary column population, update triggers 2021-04-09 16:46:36 -04:00
zm_update-1.35.25.sql Update zm_update-1.35.25.sql 2021-12-13 21:07:35 -05:00
zm_update-1.35.26.sql Implement Snapshots user permission 2021-04-12 15:59:31 -04:00
zm_update-1.35.27.sql Cleanup 2021-04-23 14:52:29 -04:00
zm_update-1.35.28.sql Change encoder to a text field. enums will be too much of a hassle 2021-05-05 14:09:22 -04:00
zm_update-1.35.29.sql Fix merge. 2021-07-07 09:45:53 -04:00
zm_update-1.36.6.sql Rename zm_update-1.35.29.sql zm_update-1.36.6.sql so that it gets picked up. 2021-07-05 10:35:26 -04:00
zm_update-1.36.20.sql Add UserId to MontageLayouts 2022-07-12 17:33:34 -04:00
zm_update-1.37.1.sql move db update script so it gets used. Bump version to 1.37.1 for db update 2021-07-05 09:32:39 -04:00
zm_update-1.37.2.sql Correct definition of Importance. Want less importance to have a hgiher value. Make not null. 2021-10-13 16:05:49 -04:00
zm_update-1.37.3.sql Merge branch 'master' into multistream 2021-12-31 17:53:36 -05:00
zm_update-1.37.4.sql.in Add an update script that includes manufacturers and models 2021-11-18 09:55:19 -05:00
zm_update-1.37.5.sql Fix AlarmStartCommand => EventStartCommand 2021-11-29 13:49:07 -05:00
zm_update-1.37.6.sql Add ExecuteInterval to Filters 2021-12-13 15:00:03 -05:00
zm_update-1.37.7.sql fix typo 2022-01-10 09:07:59 -05:00
zm_update-1.37.8.sql First working Janus build 2022-01-10 23:22:37 -06:00
zm_update-1.37.9.sql Adds janus_enable_audio, a switch to try to enable audio in live stream viewing. 2022-01-19 00:14:52 -06:00
zm_update-1.37.10.sql Add Private to Config 2022-01-22 12:30:59 -05:00
zm_update-1.37.11.sql Adds Amcrest On-camera Motion Detection 2022-01-25 22:38:00 -06:00
zm_update-1.37.12.sql Fix Analysis remaining turned on for Monitor and NoDect 2022-05-17 14:03:04 -04:00
zm_update-1.37.13.sql Add update for add Decoding to Monitors 2022-03-28 16:22:18 -04:00
zm_update-1.37.14.sql Add webm to output containers 2022-04-29 18:39:54 -04:00
zm_update-1.37.15.sql Add System to Config table 2022-05-04 12:58:14 -04:00
zm_update-1.37.16.sql Implement decoding=Keyframes + OnDemand 2022-05-10 14:25:34 -04:00
zm_update-1.37.17.sql Add AnalysisImage to Monitor 2022-06-15 11:34:20 -04:00
zm_update-1.37.18.sql Add UserId to MontageLayouts 2022-07-12 17:33:34 -04:00
zm_update-1.37.19.sql Correct casing of ONVIF_Alarm_Text 2023-07-11 18:24:58 -04:00
zm_update-1.37.20.sql Adds Janus options Profile-ID Override and Use RTSP Restream to work around camera issues 2022-08-09 00:54:41 -05:00
zm_update-1.37.21.sql move generic update script to version specific 2022-08-25 20:33:58 -04:00
zm_update-1.37.22.sql Add Janus_RTSP_USer to Monitors 2022-09-12 10:33:51 -04:00
zm_update-1.37.23.sql Merge branch 'master' into add_janus_rtsp_user 2022-09-14 18:34:07 -04:00
zm_update-1.37.25.sql Untested change to use TIMESTAMP instead of DATETIME for Monitor_Status/UpdatedOn. This is for mysql 5.5. 2022-10-27 10:56:11 -04:00
zm_update-1.37.26.sql Add db update to create Event_Data table 2022-10-27 14:17:24 -04:00
zm_update-1.37.27.sql Handle Users no longer having MOnitorIds column 2025-01-04 12:51:53 -05:00
zm_update-1.37.28.sql Fix logic inversion 2022-12-24 09:18:04 -05:00
zm_update-1.37.29.sql Add SectionLengthWarn to Monitors table 2023-01-07 12:34:30 -05:00
zm_update-1.37.30.sql SQL: Add base and provide upgrade file 2023-01-09 17:57:25 -07:00
zm_update-1.37.31.sql Remove FOREIGN KEYS on Events table for performance/reliability 2023-02-02 10:40:57 -05:00
zm_update-1.37.32.sql Allow ServerId to be NULL, which is the case in a non-multi-server install 2023-02-18 18:02:15 -05:00
zm_update-1.37.34.sql Merge branch 'map' 2023-02-25 12:44:28 -05:00
zm_update-1.37.35.sql Add column Decoder to Monitors 2023-02-26 15:52:13 -05:00
zm_update-1.37.36.sql Add Name, Email, Phone to Users 2023-02-28 14:01:22 -05:00
zm_update-1.37.37.sql Add CpuUserPercent and CpuSystemPercent to System_Stats 2023-03-01 13:42:21 -05:00
zm_update-1.37.38.sql Redo the update for User_Preferences. Sourcing User_Preferences.sql drops the table, losing contents. 2023-11-01 11:43:00 -04:00
zm_update-1.37.39.sql Add Deleted column to Monitors 2023-04-19 18:25:45 -04:00
zm_update-1.37.40.sql Add the ability to send a single summary email instead of individual emails per event 2023-04-24 17:53:16 -04:00
zm_update-1.37.41.sql Use syntax that works on mysql <8 2023-07-13 13:19:07 -04:00
zm_update-1.37.42.sql Adds RTSP2Web support for live view 2023-07-29 23:46:31 -05:00
zm_update-1.37.43.sql Add db update to correct column type of Longitude in Events and Servers table 2023-08-25 12:49:14 -04:00
zm_update-1.37.44.sql feat(tags): Filter option for No Tag 2025-03-06 12:23:01 -05:00
zm_update-1.37.45.sql Deprecate cURL monitor type 2023-09-21 12:08:27 -04:00
zm_update-1.37.46.sql Bump version to 1.37.46 to pickup montage layout updates 2023-10-24 12:26:15 -04:00
zm_update-1.37.47.sql Redo the update for User_Preferences. Sourcing User_Preferences.sql drops the table, losing contents. 2023-11-01 11:43:00 -04:00
zm_update-1.37.48.sql Introduce a Create permission for Monitors, so that a given user may Edit existing monitors, but not create new ones. 2024-01-02 12:18:09 -05:00
zm_update-1.37.49.sql Bump version for increase Phone column to 64 2024-01-11 10:16:08 -05:00
zm_update-1.37.50.sql Add 6,7,8,9,10 wide montage layouts. 2024-01-16 11:52:28 -05:00
zm_update-1.37.51.sql Add db update for SOAP_wsa_compl. Bump version as a result 2024-02-13 17:38:11 -05:00
zm_update-1.37.52.sql Add CpuUserPercent, CpuNicePercent, CpuSystemPercent, CpuIdlePercent, CpuUsagePercent to Servers table 2024-02-22 16:06:03 -05:00
zm_update-1.37.53.sql Add EventCloseMode to Monitors 2024-02-22 16:13:34 -05:00
zm_update-1.37.54.sql Don't specify zm as the db 2024-02-27 09:24:14 -05:00
zm_update-1.37.55.sql Add remaining CpuUsage stats to Server_Stats 2024-02-26 13:54:48 -05:00
zm_update-1.37.56.sql Add StartupDelay to Monitors 2024-03-18 12:55:19 -04:00
zm_update-1.37.57.sql Make Name a varchar because the unique clause fails for text 2024-04-08 20:16:33 -04:00
zm_update-1.37.58.sql Make Name a varchar because the unique clause fails for text 2024-04-08 20:16:33 -04:00
zm_update-1.37.59.sql Also check for Snapshots_Events in case both exist. 2024-04-25 09:46:57 -04:00
zm_update-1.37.60.sql Bump version to 1.37.60 for new gridstack montage 2024-05-08 13:00:40 -04:00
zm_update-1.37.62.sql Add db updates for WallClockTimestamps for 1.37.62 2024-07-07 09:03:31 -04:00
zm_update-1.37.63.sql Add EmailServer to filter to override server set in options 2024-07-10 17:14:36 -04:00
zm_update-1.37.66.sql Add db update scripts and bump version for them 2025-02-26 12:40:52 -05:00
zm_update-1.37.67.sql Add Go2RTCEnabled to Monitors 2025-06-26 14:23:00 -04:00
zm_update-1.37.68.sql Add MaxScoreFrameId to the events table and automatically update it during event creation so we don't have to look it up later. Finding the frame with the max score is actually a very heavy query, so lets not do it. 2025-07-15 16:17:36 -04:00
zm_update-1.37.69.sql.in Remove updating the Storage table in triggers. Do those updates manually because there is frequently too much contention around the Storage table and filters get locked on it. 2025-08-07 14:08:45 -04:00
zm_update-1.37.70.sql Convert OutputCodec from int to varchar OutputCodecName. ffmpeg has different values for codec_id for different versions of ffmpeg. So just use the codec name instead. 2025-08-20 15:59:02 -04:00
zm_update-1.37.71.sql Set DefaultPlayer to '' 2025-09-24 09:53:11 -04:00
zm_update-1.37.72.sql Change DefaultScale from smallint to char(6) 2025-10-10 09:54:38 -04:00
zm_update-1.37.73.sql Bump version in order to update telemetry endpoint 2025-10-21 06:58:48 -04:00
zm_update-1.37.74.sql.in Apply new triggers that only update summary tables if there is a DiskSpace change. 2025-12-11 18:31:30 -05:00
zm_update-1.37.75.sql Add index on UpdatedOn column of Monitor_Status table 2025-12-16 11:15:40 -05:00
zm_update-1.37.76.sql Merge branch 'master' into copilot/fix-orphaned-monitorid-field 2026-01-06 17:03:05 -05:00
zm_update-1.37.77.sql.in Reload triggers for 1.37.77 2026-01-24 11:24:56 -05:00
zm_update-1.37.78.sql feat: add User Roles feature for reusable permission templates 2026-01-29 13:34:27 -05:00
zm_update-1.37.79.sql refactor: rename RTSP2WebStream to StreamChannel 2026-01-31 19:37:08 -05:00
zm_update-1.37.80.sql db: add RTSP_User migration (renamed from Janus_RTSP_User) 2026-02-01 15:21:48 -05:00
zm_update-1.37.81.sql feat: store zone coordinates as percentages for resolution independence 2026-02-23 18:19:20 -05:00
zm_update-1.38.1.sql Increase ONVIF_Options column width to 255 characters 2026-02-02 13:35:57 -05:00
zm_update-1.39.1.sql feat: add AUDIT logging level for tracking administrative changes 2026-02-23 18:19:20 -05:00