Isaac Connor
|
79b755047a
|
Add db update to correct column type of Longitude in Events and Servers table
|
2023-08-25 12:49:14 -04:00 |
Jonathan Bennett
|
5c9588c012
|
Adds RTSP2Web support for live view
|
2023-07-29 23:46:31 -05:00 |
|
Isaac Connor
|
b002ae18b5
|
Use syntax that works on mysql <8
|
2023-07-13 13:19:07 -04:00 |
|
Isaac Connor
|
bdb0768dfe
|
Bump to 1.37.41 to get a db update to correct the case of ONVIF_Alarm_Text
|
2023-07-12 17:48:20 -04:00 |
|
Isaac Connor
|
37c39386ee
|
Correct casing of ONVIF_Alarm_Text
|
2023-07-11 18:24:58 -04:00 |
|
Isaac Connor
|
7ebca529b5
|
Put back copying over generated .sql files. They don't get included with *.sql
|
2023-06-21 18:59:43 -04:00 |
|
Isaac Connor
|
d2fb365fa9
|
Add the ability to send a single summary email instead of individual emails per event
|
2023-04-24 17:53:16 -04:00 |
|
Isaac Connor
|
6aba77a6f0
|
Add Ubiquiti to Manufacturers
|
2023-04-22 13:33:18 -04:00 |
|
Isaac Connor
|
e15d1f7e5b
|
Add Deleted column to Monitors
|
2023-04-19 18:25:45 -04:00 |
|
Isaac Connor
|
8c923aa0be
|
Put back zm_create.sql
|
2023-04-10 15:48:20 -04:00 |
|
Isaac Connor
|
c30a40912e
|
Remove reference to MonitorIds column of users table. Fixes #3679
|
2023-03-23 11:20:30 -04:00 |
|
Isaac Connor
|
821bfa9625
|
Fix typo
|
2023-03-22 13:28:35 -04:00 |
|
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 |