-- ═══════════════════════════════════════════════════════════════
-- 2026_06_26_004_seed_test_accounts.sql
-- Comptes de test — skippé automatiquement hors dev par migrate.php
-- ═══════════════════════════════════════════════════════════════

-- (protection gérée par migrate.php via le tag #dev-only ci-dessous)
-- #dev-only

DELETE FROM actions WHERE user_id IN ('u_admin_sf','u_client_essentiel','u_client_premium','u_prospect_01');
DELETE FROM users   WHERE id      IN ('u_admin_sf','u_resp_01','u_client_essentiel','u_client_premium','u_prospect_01');

INSERT INTO users (id, email, firstname, lastname, role, offre, is_test, active) VALUES
  ('u_admin_sf',         's.fauquant+admin@gmail.com',     'Sébastien', 'Fauquant', 'admin',            NULL,        0, 1),
  ('u_client_essentiel', 's.fauquant+essentiel@gmail.com', 'Sébastien', 'Fauquant', 'client_essentiel', 'essentiel', 0, 1),
  ('u_client_premium',   's.fauquant+premium@gmail.com',   'Sébastien', 'Fauquant', 'client_premium',   'premium',   0, 1),
  ('u_prospect_01',      's.fauquant+prospect@gmail.com',  'Sébastien', 'Fauquant', 'prospect',         NULL,        0, 1);

INSERT INTO actions (id, user_id, card_id, status) VALUES
  ('act_test_001', 'u_client_essentiel', 'C-001', 'en_cours'),
  ('act_test_002', 'u_client_essentiel', 'C-005', 'en_cours'),
  ('act_test_003', 'u_client_essentiel', 'C-012', 'realisee'),
  ('act_test_004', 'u_client_premium',   'C-003', 'en_cours'),
  ('act_test_005', 'u_client_premium',   'C-008', 'en_cours'),
  ('act_test_006', 'u_client_premium',   'C-015', 'realisee'),
  ('act_test_007', 'u_prospect_01',      'C-001', 'en_cours'),
  ('act_test_008', 'u_prospect_01',      'C-002', 'en_cours'),
  ('act_test_009', 'u_prospect_01',      'C-004', 'en_cours');