-- Adds a simple key-value settings table so business hours can be edited from the
-- operator console instead of hand-editing config.php. Existing hardcoded hours in
-- config.php still work as the fallback default if this table has no row yet.
CREATE TABLE IF NOT EXISTS chat_settings (
  setting_key VARCHAR(64) NOT NULL PRIMARY KEY,
  setting_value TEXT NULL,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
