-- Adds individual arrival tracking for every guest in the tablet check-in kiosk.
-- Run this once after upgrade-006-document-categories.sql.

ALTER TABLE guests
  ADD COLUMN arrived TINYINT(1) NOT NULL DEFAULT 0 AFTER dining_charge,
  ADD COLUMN arrived_at DATETIME NULL AFTER arrived,
  ADD COLUMN checked_in_by BIGINT UNSIGNED NULL AFTER arrived_at,
  ADD INDEX idx_guest_arrival (arrived, arrived_at),
  ADD CONSTRAINT fk_guest_checked_in_by FOREIGN KEY (checked_in_by) REFERENCES users(id) ON DELETE SET NULL;