-- Kör denna i phpMyAdmin / cPanel MySQL

CREATE TABLE IF NOT EXISTS handlaggare_status (
  handlaggare_id VARCHAR(36) NOT NULL PRIMARY KEY,
  is_at_work      TINYINT(1)   NOT NULL DEFAULT 0,
  is_checked_in   TINYINT(1)   NOT NULL DEFAULT 1,
  work_location   VARCHAR(20)  NOT NULL DEFAULT 'office',
  today_log       JSON,
  status_date     DATE,
  updated_at      DATETIME     DEFAULT NOW() ON UPDATE NOW()
);