69db95f8d4
Update SQL Queries on Startup
2022-12-17 00:07:23 +00:00
e9892cfb6e
Sync with framework.sql ( 03879103) - added missing table, columns and ordered to match
2021-09-13 19:22:49 +00:00
0387910328
change utf8mb4 to utf8 for Jetson Nano
2021-06-08 12:04:00 -07:00
8609ce959e
Fix Google App ID designation, add Name to LoginTokens
...
+ Show Last Login for LoginTokens in Settings window
2021-04-04 10:35:09 -07:00
2cb3d8c9a2
Add Alternate Logins section in Settings, Minor Cleanup
...
+ Login Token API Endpoints for : get single, get all, delete by loginId
+ framework.sql update
+ update auto table creation for existing installations
+ fail message specific to alternateLogin can be passed to UI
+ add type column to LoginTokens table, default is "google" because its the only one (first of many to come)
2021-04-03 21:46:58 -07:00
b57f82290f
Update framework.sql
2021-04-03 09:47:20 -07:00
666fc8f48a
Remove unused presettype sql enum
2020-10-12 18:15:00 -05:00
20d7efd6c2
Update postgresql schema to match expectations
...
Fixes cron.js not working due to missing "time" field in "Events Counts"
Change "Presets" "type" field to varchar(50) instead of enum.
2020-10-12 17:54:37 -05:00
e6eddc8aa4
SQL Files : Add "archived" to Videos and "accounType" to Users
2020-08-05 20:46:18 -07:00
86c1689df2
update framework.sql for postgres, move framework.pgsql into postgres folder
...
+ remove default_data.sql
2020-08-05 17:20:11 -07:00
ef759fad29
update Postgres framework.sql file
2020-08-05 11:41:23 -07:00
08a7bbaae9
Merge branch 'pgsqlsupport' into 'rebuild-sql-queries'
...
Add framework.pgsql
See merge request Shinobi-Systems/Shinobi!215
2020-07-15 06:28:24 +00:00
c311aefec4
Add framework.pgsql
2020-07-09 13:52:49 -07:00
e81736ffd5
Merge branch 'SQL_Updates' into 'dev'
...
Add indexes to database tables
See merge request Shinobi-Systems/Shinobi!206
2020-06-19 16:44:34 +00:00
ded730197c
Fix Event Counts table (missing time column)
2020-06-18 20:22:44 -07:00
efc1374d0d
Update tables.sql
2020-06-18 16:29:40 +00:00
6c7ef92a38
Update tables.sql to include indexes on Events, Logs, and Videos tables
2020-06-17 16:45:16 +00:00
44b7868d6a
Fix duplicated column in sql framework
2020-06-14 10:01:59 -07:00
aa7c6f387a
update syntax for Event Counts table creation
2020-06-04 13:06:13 -07:00
41d25a58ab
fix missing cloud timelapse frames table insertion
2020-06-04 12:59:25 -07:00
664a30ee32
add Event Counting engine 0.1
2020-05-23 22:12:42 -07:00
bcdb54d02b
Modify JPEG-Based Timelapse Method and add basic GUI
...
+Bug fixes for UI
2019-03-23 18:25:58 -07:00
afdc0cf568
Audio Detector, Detect Object in Region, and API Methods for Scheduling System
...
- Audio Detector measures decibels (dB). Section can be found under Motion Detection.
- Regions can now be used with Object detection alone, find the option the Object Detection section.
- Scheduling System will allow automatically activating Monitor States based on time. GUI will be posted in the next commit.
+ Update Installers
+ Update framework.sql
+ `npm test` will run the test
+ Minor Bug Fixes
2018-12-29 11:32:12 -08:00
040b9368eb
Fix cron `Files` table bug
2018-09-28 09:13:03 -07:00
d56ecc8eb1
add missing Files table to SQL insert
2018-09-20 09:46:49 -07:00
fab0839cd2
Minor bug fixes and additional table for "Cloud Videos"
...
- fixed Superuser editing a user caused user settings to be destroyed
- added Cloud Videos table for Amazon S3 and future Cloud Based Storage
- Added error handler for Discord message bot
2018-07-24 22:24:14 -07:00
c940294f00
Shinobi Pro Lands on Gitlab
2018-06-09 16:34:06 -07:00
Moe
makechangesinproduction
Johnny Casey
Dave Hayes
Mike Hurley