INSERT INTO v_users(
  user_uuid, domain_uuid, username, password, salt,
  contact_uuid, user_status, api_key, user_enabled,
  add_user, add_date)
VALUES (
  '78e61f59-ad42-4eb8-b1f4-4d10d10a08f9', -- user_uuid
  '2d171c4c-b237-49ca-9d76-9cffc1618fa7', -- domain_uuid
  'my_user', md5('lE5hdwZz926qk6hp1jC71Tr7' || 'password'),
  'lE5hdwZz926qk6hp1jC71Tr7',
  NULL,NULL,NULL,'true','my_user',NOW());

INSERT INTO v_group_users(
  group_user_uuid, domain_uuid, group_name, group_uuid, user_uuid
)
VALUES (
  'eeaeac99-c089-49e9-aef2-4eee290e3e63', -- PK
  '2d171c4c-b237-49ca-9d76-9cffc1618fa7', -- domain_uuid
  'superadmin',
  (SELECT group_uuid FROM v_groups WHERE group_name = 'superadmin'),
  '78e61f59-ad42-4eb8-b1f4-4d10d10a08f9' -- user_uuid
);

-- delete user
DELETE FROM v_users WHERE user_uuid = '78e61f59-ad42-4eb8-b1f4-4d10d10a08f9'
DELETE FROM v_group_users WHERE user_uuid = '78e61f59-ad42-4eb8-b1f4-4d10d10a08f9'