-- #migration
-- Mise à jour des emails et passage en vrais comptes (is_test=0)

UPDATE users SET
  email     = 's.fauquant+admin@gmail.com',
  firstname = 'Sébastien', lastname = 'Fauquant',
  is_test   = 0
WHERE id = 'u_admin_sf';

UPDATE users SET
  email     = 's.fauquant+essentiel@gmail.com',
  firstname = 'Sébastien', lastname = 'Fauquant',
  is_test   = 0
WHERE id = 'u_client_essentiel';

UPDATE users SET
  email     = 's.fauquant+premium@gmail.com',
  firstname = 'Sébastien', lastname = 'Fauquant',
  is_test   = 0
WHERE id = 'u_client_premium';

UPDATE users SET
  email     = 's.fauquant+prospect@gmail.com',
  firstname = 'Sébastien', lastname = 'Fauquant',
  is_test   = 0
WHERE id = 'u_prospect_01';

-- Supprimer le compte Sophie Arnaud (compte de démonstration inutile)
DELETE FROM users WHERE id = 'u_resp_01';