-- Migration: adds canned response categories + operator online/away/offline status.
-- Safe to run against your existing windshi_main database — only adds columns, doesn't touch data.

ALTER TABLE canned_responses
  ADD COLUMN category VARCHAR(64) NOT NULL DEFAULT 'General' AFTER operator_id;

ALTER TABLE chat_operators
  ADD COLUMN status ENUM('online','away','offline') NOT NULL DEFAULT 'offline' AFTER active,
  ADD COLUMN last_active DATETIME NULL AFTER status;