Isaac Connor
c8802623e4
Install all sql instead of naming individual files
2023-03-22 13:28:27 -04:00
Isaac Connor
5d63d4f375
Rough in User_Preferences table in db
2023-03-21 10:03:57 -04:00
Isaac Connor
fa9a0e45b7
Add CpuUserPercent and CpuSystemPercent to System_Stats
2023-03-01 13:42:21 -05:00
Isaac Connor
75f0ee82e5
Add Name, Email, Phone to Users
2023-02-28 14:01:28 -05:00
Isaac Connor
defba5d53e
Add Name, Email, Phone to Users
2023-02-28 14:01:22 -05:00
Isaac Connor
dc2df16328
Add column Decoder to Monitors
2023-02-26 15:52:13 -05:00
Isaac Connor
b0413f330e
Merge branch 'map'
2023-02-25 12:44:28 -05:00
Isaac Connor
25a7159393
Allow ServerId to be NULL, which is the case in a non-multi-server install
2023-02-18 18:02:15 -05:00
Isaac Connor
0879252d13
Add Server Stats table and insert into it in zmstats.pl
2023-02-18 18:02:15 -05:00
Isaac Connor
d9862bb18e
Remove FOREIGN KEYS on Events table for performance/reliability
2023-02-02 10:40:57 -05:00
Isaac Connor
4f59644f49
Default API to enabled for admin user
2023-01-31 10:07:16 -05:00
baudneo
7590cf8691
SQL: Add base and provide upgrade file
...
Signed-off-by: baudneo <86508179+baudneo@users.noreply.github.com>
2023-01-09 17:57:25 -07:00
Isaac Connor
7a122f7367
Add SectionLengthWarn to Monitors table
2023-01-07 12:34:30 -05:00
Isaac Connor
873213559d
Fix logic inversion
2022-12-24 09:18:04 -05:00
Isaac Connor
5d87ffeac2
Fix missing `
2022-12-24 09:16:49 -05:00
Isaac Connor
5fc37c050a
Add Latitude and Longitude to Servers and Events
2022-12-22 10:00:23 -05:00
Isaac Connor
8fe28a5cc2
Fix errors due to '
2022-12-15 16:03:48 -05:00
Isaac Connor
2f7551769a
Add 1.37.28 db update file to rename Snapshot_Events to Snapshots_Events
2022-12-14 08:29:51 -05:00
Isaac Connor
83b6ae37a9
Deal with missing monitors by dropping the foreign key and adding it back after creating Monitor Permissions
2022-11-19 07:47:09 -05:00
Isaac Connor
6f8ce1343f
Fix Monitor Permission updating. If monitors are specified, they default to View even if MOnitors is set to None.
2022-11-15 15:00:27 -05:00
Isaac Connor
f37786bb2a
Remove quotes from line inserting values into Monitor_Permissions
2022-11-03 16:57:16 -04:00
Isaac Connor
12d5748c1c
Fi test for Groups_Permissions_GroupId_UserId_idx
2022-11-03 11:14:23 -04:00
Isaac Connor
20f01b6953
Remove command to drop Groups_Permissions
2022-11-03 09:30:07 -04:00
Isaac Connor
5106d2aaa4
Move db updates for Groups and Monitor Permissions into place, and bump version it gets picked up
2022-11-03 07:49:44 -04:00
Isaac Connor
6265a1ca41
Move from MonitorIds to Monitor_Permissions and Group_Permissions.
2022-11-02 13:25:43 -04:00
Isaac Connor
7ff928dcf8
Make the primary index on Groups_Permissions a unique index to ensure that the GroupId/UserId mapping is unique. Add Monitor_Permissions
2022-11-02 13:24:26 -04:00
Isaac Connor
893b86ee96
Make the primary index on Monitors_Permissions a unique index to ensure that the MOnitorId/UserId mapping is unique.
2022-11-02 13:24:26 -04:00
Isaac Connor
76f804dadd
Add Permission enum to Groups_Permissions
2022-11-02 12:37:16 -04:00
Isaac Connor
3775be599e
Add Groups_Permissions table
2022-11-02 12:36:42 -04:00
Isaac Connor
cd4a9fbb98
Merge ../ZoneMinder.connortechnology
2022-10-31 18:01:04 -04:00
Isaac Connor
1c38e79c1b
Add Reports table. Also set ENGINE for other tables that were hard coded to InnoDb. Fixes #3615
2022-10-31 09:29:50 -04:00
Isaac Connor
f0a1a1b0ee
Merge branch 'master' into add_event_data
2022-10-27 17:08:12 -04:00
Isaac Connor
a25436369f
Add db update to create Event_Data table
2022-10-27 14:17:24 -04:00
Isaac Connor
ac55528f8f
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
Isaac Connor
196ae7cf89
Add UpdatedOn field to Monitor_Status
2022-10-12 19:12:36 -04:00
Isaac Connor
d1cd7d3f91
Merge branch 'master' into add_janus_rtsp_user
2022-09-14 18:34:07 -04:00
Isaac Connor
f5ad68143c
Add Janus_RTSP_USer to Monitors
2022-09-12 10:33:51 -04:00
Isaac Connor
e24432ee4d
Merge branch 'master' into reports
2022-08-30 19:40:14 +02:00
Isaac Connor
85e897f211
move generic update script to version specific
2022-08-25 20:33:58 -04:00
Isaac Connor
29750a56e7
Merge branch 'master' into add_mqtt
2022-08-25 18:37:54 -04:00
Jonathan Bennett
d41792ae00
Adds Janus options Profile-ID Override and Use RTSP Restream to work around camera issues
2022-08-09 00:54:41 -05:00
Isaac Connor
5405ebdaa8
Replace the Event index with an eventId,ZoneId index, which mysql will actually use to speed up the subquery for AlarmedZone
2022-08-05 10:53:25 -04:00
Isaac Connor
b4000ef0c7
Add Reports table creation
2022-08-04 09:34:06 -04:00
Doug Nazar
a34db8bc38
Don't hardcode db in upgrade script.
2022-07-27 12:25:57 -04:00
Isaac Connor
a3395df49f
Rename ONVIF_Alarm_Txt to ONVIF_Alarm_Text
2022-07-23 16:07:45 -04:00
Isaac Connor
d2d5b6e489
Add ONVIF_Alarm_text to zm_create.sql
2022-07-23 16:07:13 -04:00
ovargasp
981769b9db
Allows users to set an specific "Onvif alarm text" for each monitor ( #3535 )
...
* Allows users to set an specific "Onvif alarm text" for each monitor
With this personalization the cameras that use strings different to "MotionAlarm"
such as Dahua, will be able to process their Onvif alarms. To make it easier, the change
sets a default "Alarm Text" value for it to work out of the box and then allows to
modify it according to the particular necessities of each brand. It consists of
a new column on table Monitors, changes on Monitors.h, Monitors.cpp and a change
on UI to manage the value of Alarm Text per camera.
Updated es_la.php language file.
Co-authored-by: ovargasp <ovargasp@hoitmail.com>
2022-07-20 12:51:13 -05:00
Isaac Connor
a617a70620
Add UserId to MontageLayouts
2022-07-12 17:33:34 -04:00
Isaac Connor
b298b46b5e
Add UserId to MontageLayouts
2022-07-12 17:30:25 -04:00
Isaac Connor
223a46393e
Add AnalysisImage to Monitor
2022-06-15 11:34:20 -04:00
Isaac Connor
61fc107808
Fix Analysis remaining turned on for Monitor and NoDect
2022-05-17 14:03:04 -04:00
Isaac Connor
997c1197cf
Implement decoding=Keyframes + OnDemand
2022-05-10 14:25:34 -04:00
Isaac Connor
e297bfcfd4
Add System to Config table
2022-05-04 12:58:14 -04:00
Isaac Connor
1852694a50
Add webm to output containers
2022-04-29 18:39:54 -04:00
Isaac Connor
32109697d2
Add update for add Decoding to Monitors
2022-03-28 16:22:18 -04:00
Isaac Connor
a6193bba0e
Fill in Protocol of HikVision control
2022-03-28 14:40:21 -04:00
Isaac Connor
08332c9be5
add update file for MQTT columns
2022-03-21 16:09:29 -04:00
Isaac Connor
d8a2d712b5
Put back MQTT_Enabled in Monitors
2022-03-21 16:09:29 -04:00
Isaac Connor
b23842021c
Add MQTT_Subscriptions to Monitors
2022-03-21 16:08:13 -04:00
Isaac Connor
69856f2b8c
Delete zm_update-1.37.multistream.sql asit has been merged to 1.37.12
2022-03-04 12:09:41 -05:00
Isaac Connor
7ef9824736
Handle NoDect case
2022-02-28 09:11:48 -05:00
Isaac Connor
3b9d13eb8e
rename to 1.37.12 and add missing updates for other functions
2022-02-27 14:16:40 -05:00
Isaac Connor
10e39b3b13
:wqMerge branch 'master' into replace_function_concept
2022-02-02 17:08:01 -05:00
Isaac Connor
e69095a9b4
Fix == to =
2022-02-01 17:22:23 -05:00
Isaac Connor
23bfbcd6ce
Merge branch 'master' into multistream
2022-01-26 10:13:20 -05:00
Jonathan Bennett
ec9403fb6f
Adds Amcrest On-camera Motion Detection
2022-01-25 22:38:00 -06:00
Isaac Connor
35efb111ac
Add Private to Config
2022-01-22 12:30:59 -05:00
Jonathan Bennett
fb832e7d1b
Adds janus_enable_audio, a switch to try to enable audio in live stream viewing.
2022-01-19 00:14:52 -06:00
Isaac Connor
3835087c9d
Merge branch 'master' into multistream
2022-01-18 20:16:08 -05:00
Isaac Connor
71c7b324e9
Update new Capturing, Analysing, Recording based on Function.
2022-01-11 12:01:07 -05:00
Jonathan Bennett
3a9c16aeea
First working Janus build
2022-01-10 23:22:37 -06:00
Isaac Connor
fd3a70172d
Merge branch 'master' into multistream
2022-01-10 17:51:50 -05:00
Isaac Connor
701045393c
fix typo
2022-01-10 09:07:59 -05:00
Jonathan Bennett
1333d8c751
Adds ONVIF Motion Detection Support
2022-01-06 16:45:15 -06:00
Isaac Connor
aefed4e174
Merge branch 'master' into multistream
2022-01-05 18:03:44 -05:00
Isaac Connor
6bd04de5f6
Merge branch 'master' into multistream
2021-12-31 17:53:36 -05:00
Isaac Connor
f9f8764507
Change Event->Cause to a TEXT instead of varchar(32) because we now inclue Alarmed Zone name and could include other info as well.
...
Fixes #3403
2021-12-28 12:33:03 -05:00
makers-mark
9733cdb576
Update zm_update-1.35.25.sql
2021-12-13 21:07:35 -05:00
Isaac Connor
e2df6e5074
Add ExecuteInterval to Filters
2021-12-13 15:00:03 -05:00
Isaac Connor
072d181f79
Fix AlarmStartCommand => EventStartCommand
2021-11-29 13:49:07 -05:00
Isaac Connor
ea6a84ae66
Fix AlarmEndCommand => EventEndCommand
2021-11-29 13:49:07 -05:00
Isaac Connor
d51eb63947
Add EventStartCommand and EventEndCommand to monitors table
2021-11-26 19:21:24 -05:00
Isaac Connor
0a30c55042
install manufacturers.sql and models.sql
2021-11-18 11:09:49 -05:00
Isaac Connor
f63c124988
include manufacturers and models
2021-11-18 09:55:39 -05:00
Isaac Connor
18610fd601
Add an update script that includes manufacturers and models
2021-11-18 09:55:19 -05:00
Isaac Connor
f48511acba
Add NULL for ModelId column when adding MonitorPresets.
2021-11-16 09:19:42 -05:00
Isaac Connor
6cbc4c0a7a
Update MonirorPresets to link to Amcrest cams
2021-11-15 16:30:39 -05:00
Isaac Connor
4e9a56624d
Use UPSERTS and add some more models
2021-11-15 16:30:17 -05:00
Isaac Connor
e63222d733
Add IGNORE so it does UPSERT
2021-11-15 16:30:03 -05:00
Isaac Connor
d00430f799
Add ModelId to MonitorPresets
2021-11-15 09:47:11 -05:00
Isaac Connor
dc756ad670
add back update for Manufacturers and Models
2021-11-10 19:20:39 -05:00
Isaac Connor
9d71f1192a
merge manufacturer update into existing zm_update-1.37.2 and then move it to .in
2021-11-10 19:18:16 -05:00
Isaac Connor
1fd99424bb
Merge branch 'master' into add_manufacturer_model_to_monitors
2021-11-05 10:13:41 -04:00
Isaac Connor
4351f51929
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
Isaac Connor
c81f3d9c61
add Capturing, Analysing, AnalysisSource, Recording, RecordingSource to Monitors
2021-10-16 20:37:16 -04:00
Isaac Connor
64ab429519
Correct definition of Importance. Want less importance to have a hgiher value. Make not null.
2021-10-13 16:05:49 -04:00
Isaac Connor
9cf4e89254
add update to 1.37.3
2021-09-27 11:03:16 -04:00
Isaac Connor
227e5794fa
Merge branch 'master' into add_manufacturer_model_to_monitors
2021-09-08 18:32:46 -04:00
Isaac Connor
89d7685b14
Change Montage Layouts to reset width when choosing Freeform. Use full width instead of slightly less. I think at some point I fixed our layout so that we can use 25% instead of 24.5% etc.
2021-08-19 15:42:39 -04:00
Isaac Connor
cb4e17e49a
Merge branch 'release-1.36'
2021-08-09 10:27:24 -04:00