-- Insertar usuarios en auth.users
-- UUIDs fijos para los usuarios Chad que se pueden reutilizar en otros seeders

-- Chad PM
INSERT INTO auth.users (
  instance_id,
  id,
  aud,
  role,
  email,
  encrypted_password,
  email_confirmed_at,
  raw_app_meta_data,
  raw_user_meta_data,
  created_at,
  updated_at,
  confirmation_token,
  email_change,
  email_change_token_new,
  recovery_token
) VALUES (
  '00000000-0000-0000-0000-000000000000',
  'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', -- UUID fijo para Chad PM
  'authenticated',
  'authenticated',
  'chad.pm@example.com',
  crypt('asdf1234', gen_salt('bf')),
  now(),
  '{"provider":"email","providers":["email"]}',
  '{"full_name":"Chad PM","name":"Chad PM"}',
  now(),
  now(),
  '',
  '',
  '',
  ''
);

INSERT INTO auth.identities (
  provider_id,
  user_id,
  identity_data,
  provider,
  last_sign_in_at,
  created_at,
  updated_at
) VALUES (
  'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11',
  'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11',
  jsonb_build_object('sub', 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11'),
  'email',
  now(),
  now(),
  now()
);

-- Chad Sales
INSERT INTO auth.users (
  instance_id,
  id,
  aud,
  role,
  email,
  encrypted_password,
  email_confirmed_at,
  raw_app_meta_data,
  raw_user_meta_data,
  created_at,
  updated_at,
  confirmation_token,
  email_change,
  email_change_token_new,
  recovery_token
) VALUES (
  '00000000-0000-0000-0000-000000000000',
  'b1ffcd99-9c0b-4ef8-bb6d-6bb9bd380a22', -- UUID fijo para Chad Sales
  'authenticated',
  'authenticated',
  'chad.sales@example.com',
  crypt('asdf1234', gen_salt('bf')),
  now(),
  '{"provider":"email","providers":["email"]}',
  '{"full_name":"Chad Sales","name":"Chad Sales"}',
  now(),
  now(),
  '',
  '',
  '',
  ''
);

INSERT INTO auth.identities (
  provider_id,
  user_id,
  identity_data,
  provider,
  last_sign_in_at,
  created_at,
  updated_at
) VALUES (
  'b1ffcd99-9c0b-4ef8-bb6d-6bb9bd380a22',
  'b1ffcd99-9c0b-4ef8-bb6d-6bb9bd380a22',
  jsonb_build_object('sub', 'b1ffcd99-9c0b-4ef8-bb6d-6bb9bd380a22'),
  'email',
  now(),
  now(),
  now()
);

-- Chad Executive
INSERT INTO auth.users (
  instance_id,
  id,
  aud,
  role,
  email,
  encrypted_password,
  email_confirmed_at,
  raw_app_meta_data,
  raw_user_meta_data,
  created_at,
  updated_at,
  confirmation_token,
  email_change,
  email_change_token_new,
  recovery_token
) VALUES (
  '00000000-0000-0000-0000-000000000000',
  'c2ffde99-9c0b-4ef8-bb6d-6bb9bd380a33', -- UUID fijo para Chad Executive
  'authenticated',
  'authenticated',
  'chad.executive@example.com',
  crypt('asdf1234', gen_salt('bf')),
  now(),
  '{"provider":"email","providers":["email"]}',
  '{"full_name":"Chad Executive","name":"Chad Executive"}',
  now(),
  now(),
  '',
  '',
  '',
  ''
);

INSERT INTO auth.identities (
  provider_id,
  user_id,
  identity_data,
  provider,
  last_sign_in_at,
  created_at,
  updated_at
) VALUES (
  'c2ffde99-9c0b-4ef8-bb6d-6bb9bd380a33',
  'c2ffde99-9c0b-4ef8-bb6d-6bb9bd380a33',
  jsonb_build_object('sub', 'c2ffde99-9c0b-4ef8-bb6d-6bb9bd380a33'),
  'email',
  now(),
  now(),
  now()
);

-- Chad AC
INSERT INTO auth.users (
  instance_id,
  id,
  aud,
  role,
  email,
  encrypted_password,
  email_confirmed_at,
  raw_app_meta_data,
  raw_user_meta_data,
  created_at,
  updated_at,
  confirmation_token,
  email_change,
  email_change_token_new,
  recovery_token
) VALUES (
  '00000000-0000-0000-0000-000000000000',
  'a6bbc299-9c0b-4ef8-bb6d-6bb9bd380a77', -- UUID fijo para Chad account manager
  'authenticated',
  'authenticated',
  'chad.accountmanager@example.com',
  crypt('asdf1234', gen_salt('bf')),
  now(),
  '{"provider":"email","providers":["email"]}',
  '{"full_name":"Chad Account Manager","name":"Chad account manager"}',
  now(),
  now(),
  '',
  '',
  '',
  ''
);

INSERT INTO auth.identities (
  provider_id,
  user_id,
  identity_data,
  provider,
  last_sign_in_at,
  created_at,
  updated_at
) VALUES (
  'a6bbc299-9c0b-4ef8-bb6d-6bb9bd380a77',
  'a6bbc299-9c0b-4ef8-bb6d-6bb9bd380a77',
  jsonb_build_object('sub', 'a6bbc299-9c0b-4ef8-bb6d-6bb9bd380a77'),
  'email',
  now(),
  now(),
  now()
);