INSERT INTO `projects` (
  `business_name`,
  `website_url`,
  `target_audience`,
  `content_intent`,
  `brand_positioning`,
  `tone_voice`,
  `brand_dos`,
  `brand_donts`,
  `pov_type`,
  `seo_philosophy`,
  `compliance_rules`,
  `brand_reference_style`,
  `cta_style`,
  `no_no_words`,
  `guideline_doc_url`,
  `created_at`,
  `updated_at`
)
SELECT
  'Crawl Demo Site',
  'https://example.com',
  'Website owners and growth teams',
  'Audit and fix technical SEO issues',
  'A modern marketing website optimized for search and conversions.',
  'professional',
  'Use clear, action-oriented language.',
  'Avoid unsupported claims and jargon.',
  'third_person',
  'Focus on crawlability, structure, and page performance.',
  'Follow all brand and compliance guidance.',
  'Use consistent heading levels and metadata.',
  'Add a strong call to action on each page.',
  'Avoid spammy terms and duplicate content.',
  'https://example.com/guidelines',
  NOW(),
  NOW()
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `projects` WHERE `website_url` = 'https://example.com'
);
