INSERT INTO rm_surveys (week_start, title, questions, credit_reward, is_active)
SELECT
  DATE '2026-03-23',
  'Social & Community',
  '[
    {
      "id": "follows_twitter",
      "type": "select",
      "options": ["Yes", "No but I will", "I do not use X"],
      "question": "Do you follow @SportsClawai on X/Twitter?"
    },
    {
      "id": "discord_interest",
      "type": "select",
      "options": ["Absolutely", "Maybe", "Not interested"],
      "question": "Would you join a Rainmaker Discord or group chat?"
    },
    {
      "id": "tail_picks",
      "type": "select",
      "options": ["Always", "Sometimes", "Never"],
      "question": "Do you tail picks from other bettors?"
    },
    {
      "id": "referral_reward",
      "type": "select",
      "options": ["Definitely", "Maybe", "No"],
      "question": "Would you refer friends for free forecast credits?"
    },
    {
      "id": "content_preference",
      "type": "select",
      "options": ["Quick picks", "Deep analysis articles", "Video breakdowns", "Live game alerts"],
      "question": "What content do you want more of?"
    }
  ]'::jsonb,
  3,
  TRUE
WHERE NOT EXISTS (
  SELECT 1
  FROM rm_surveys
  WHERE week_start = DATE '2026-03-23'
    AND is_active = TRUE
);
