-- Additive migration: demo appointment requests from the public page.
-- Idempotent — safe to re-run.

USE jqc_features;

CREATE TABLE IF NOT EXISTS demo_request (
  id             INT AUTO_INCREMENT PRIMARY KEY,
  name           VARCHAR(120) NOT NULL,
  company        VARCHAR(160) NULL,
  email          VARCHAR(200) NOT NULL,
  phone          VARCHAR(40) NULL,
  preferred_date DATE NOT NULL,
  preferred_time VARCHAR(5) NOT NULL,          -- 'HH:MM', local business hours
  message        TEXT NULL,
  status         VARCHAR(16) NOT NULL DEFAULT 'new',  -- new/scheduled/done/cancelled
  source_ip      VARCHAR(45) NULL,
  created_at     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY idx_demo_slot (preferred_date, preferred_time),
  KEY idx_demo_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;