CREATE TABLE IF NOT EXISTS personalizations (
  id VARCHAR(50) NOT NULL PRIMARY KEY,
  created_at DATETIME NOT NULL,
  updated_at DATETIME NULL,
  status VARCHAR(50) NOT NULL DEFAULT 'new',
  product_handle VARCHAR(255) NULL,
  product_title VARCHAR(255) NULL,
  variant_id VARCHAR(100) NULL,
  custom_text VARCHAR(255) NULL,
  font_choice VARCHAR(100) NULL,
  notes TEXT NULL,
  approval_checked TINYINT(1) NOT NULL DEFAULT 0,
  image_file VARCHAR(255) NULL,
  image_url VARCHAR(500) NULL,
  proof_url VARCHAR(500) NULL,
  internal_notes TEXT NULL
);
