INSERT INTO "VipTier" ("id", "key", "name", "minVolume", "cashbackBps", "rakebackBps", "perks", "sortOrder", "createdAt")
VALUES
  ('44444444-4444-4444-8444-444444444401', 'wood', 'Bois', 0, 10, 5, '{"support":"standard","levelBonusAmount":0}'::jsonb, 1, CURRENT_TIMESTAMP),
  ('11111111-1111-4111-8111-111111111111', 'bronze', 'Bronze', 500, 25, 10, '{"support":"standard","levelBonusAmount":25}'::jsonb, 2, CURRENT_TIMESTAMP),
  ('44444444-4444-4444-8444-444444444402', 'silver', 'Argent', 2500, 40, 20, '{"support":"standard","levelBonusAmount":75}'::jsonb, 3, CURRENT_TIMESTAMP),
  ('22222222-2222-4222-8222-222222222222', 'gold', 'Or', 10000, 75, 35, '{"support":"priority","levelBonusAmount":150}'::jsonb, 4, CURRENT_TIMESTAMP),
  ('44444444-4444-4444-8444-444444444403', 'platinum', 'Platine', 50000, 100, 50, '{"support":"priority","levelBonusAmount":350}'::jsonb, 5, CURRENT_TIMESTAMP),
  ('44444444-4444-4444-8444-444444444404', 'jade', 'Jade', 150000, 125, 65, '{"support":"priority","levelBonusAmount":750}'::jsonb, 6, CURRENT_TIMESTAMP),
  ('44444444-4444-4444-8444-444444444405', 'sapphire', 'Saphir', 400000, 150, 80, '{"support":"priority","manager":true,"levelBonusAmount":1500}'::jsonb, 7, CURRENT_TIMESTAMP),
  ('33333333-3333-4333-8333-333333333333', 'black', 'Rubis', 1000000, 200, 110, '{"support":"priority","manager":true,"levelBonusAmount":5000}'::jsonb, 8, CURRENT_TIMESTAMP)
ON CONFLICT ("key") DO UPDATE SET
  "name" = EXCLUDED."name",
  "minVolume" = EXCLUDED."minVolume",
  "cashbackBps" = EXCLUDED."cashbackBps",
  "rakebackBps" = EXCLUDED."rakebackBps",
  "perks" = EXCLUDED."perks",
  "sortOrder" = EXCLUDED."sortOrder";