MediaSite-Recorder-Monitor

TODO: Documentation and GitBook for Setup TODO: JDoc for various Classes and Methods as needed.

Mediasite Docs: mediasite.sdsu.edu/mediasite/api/v1/$metadata

Auth Docs: https://github.com/pac4j/jax-rs-pac4j

DDL

CREATE TABLE users (
  PK         INT PRIMARY KEY AUTO_INCREMENT,
  email      TEXT,
  first_name TEXT,
  last_name  TEXT,
  password   TEXT,
  notify     TINYINT(1)
);
CREATE TABLE preferences (
  setting VARCHAR(32) PRIMARY KEY NOT NULL,
  value   TEXT
);
CREATE TABLE recorders (
  id                       VARCHAR(64) PRIMARY KEY NOT NULL,
  name                     TEXT,
  description              TEXT,
  serial_number            TEXT,
  version                  TEXT,
  last_version_update_date TEXT,
  physical_address         TEXT,
  image_version            TEXT,
  last_seen                TIMESTAMP  DEFAULT NOW(),
  status                   INT
);