-- Live updates: who of the staff is online, what they are looking at and whether they are typing a reply.

CREATE TABLE admin_presence (
  admin_id INT UNSIGNED NOT NULL PRIMARY KEY,
  last_seen DATETIME NOT NULL,
  page VARCHAR(190) NOT NULL DEFAULT '',
  ticket_id INT UNSIGNED NULL,
  typing TINYINT(1) NOT NULL DEFAULT 0,
  KEY ticket (ticket_id, last_seen)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE tickets ADD KEY updated (updated_at);