CREATE EXTENSION IF NOT EXISTS supabase_vault WITH SCHEMA vault;

DO $$
DECLARE
  v_jobid bigint;
  v_token text;
  v_url text := 'https://gbulkysms.lovable.app/api/public/hooks/run-scheduled';
BEGIN
  SELECT decrypted_secret INTO v_token
  FROM vault.decrypted_secrets
  WHERE name = 'gatavase_cron_http_token'
  LIMIT 1;

  FOR v_jobid IN SELECT jobid FROM cron.job WHERE command ILIKE '%run-scheduled%' LOOP
    PERFORM cron.unschedule(v_jobid);
  END LOOP;

  PERFORM cron.schedule(
    'run-scheduled-campaigns',
    '* * * * *',
    format($cron$
      SELECT net.http_post(
        url := %L,
        headers := jsonb_build_object('Content-Type','application/json','x-cron-secret', %L),
        body := '{}'::jsonb
      );
    $cron$, v_url, COALESCE(v_token, ''))
  );
END $$;