text: -- nomis users
  INSERT INTO users (user_id, username, email, verified, source)
  VALUES ('A04C70EE-51C9-4852-8D0D-130DA5C85C42', 'ITAG_USER', 'itag_user@digital.justice.gov.uk', true, 'nomis'),
         ('A04C70EE-51C9-4852-8D0D-130DA5C85C43', 'RESET_USER', 'reset_user@digital.justice.gov.uk', true, 'nomis'),
         ('0181F647-C7D4-41E7-9271-288EC7C01F90', 'DM_USER', 'dm_user@digital.justice.gov.uk', false, 'nomis'),
         ('151DD6BC-88EE-4246-AA18-45924819C9F5', 'EXPIRED_TEST_USER', 'expired_test_user@digital.justice.gov.uk', true, 'nomis'),
         ('86192295-8652-40BB-B03F-4D56BB93C1D7', 'RESET_TEST_USER', 'reset_test@digital.justice.gov.uk', true, 'nomis'),
         ('F566EEC3-32DD-4CA4-B477-56AEC62917A1', 'CA_USER_TEST', 'ca_user@digital.justice.gov.uk', true, 'nomis'),
         ('F566EEC3-32DD-4CA4-B477-56AEC62917A2', 'CA_USER_B_TEST', 'ca_user@digital.justice.gov.uk', true, 'nomis'),
         ('846D7318-921C-4537-8E24-58306CED881B', 'PPL_USER', 'ppl_user@digital.justice.gov.uk', true, 'nomis'),
         ('326A07B4-6C2F-4CF9-A904-84262EB5C4FF', 'DM_USER_TEST', 'dm_user_test@digital.justice.gov.uk', true, 'nomis'),
         ('7969D655-03F6-464E-A318-9D3C8B53787A', 'EXPIRED_TEST2_USER', 'expired_test2_user@digital.justice.gov.uk', true, 'nomis'),
         ('FCFC15C1-6EE5-4EB2-8312-A1302AE3CFD1', 'ITAG_USER_ADM', 'itag_user_adm@digital.justice.gov.uk', true, 'nomis'),
         ('E94B2E26-DC8A-4020-9533-A509807F68DF', 'EXPIRED_TEST3_USER', 'expired_test3_user@digital.justice.gov.uk', true, 'nomis'),
         ('C0279EE3-76BF-487F-833C-AA47C5DF22F8', 'CA_USER', 'ca_user@digital.justice.gov.uk', true, 'nomis'),
         ('6A3F0216-BBAB-49CD-BD6E-AC09C1762EE4', 'LOCKED_USER', 'locked@somewhere.com', true, 'nomis'),
         ('6A3F0216-BBAB-49CD-BD6E-AC09C1762EE5', 'LOCKED_NOMIS_USER', 'lockednomisuser@somewhere.com', true, 'nomis'),
         ('79CDC23C-510F-4CE2-8C98-AC251296EC39', 'RO_DEMO', 'ro_user@some.justice.gov.uk', false, 'nomis'),
         ('AB8DA2CA-3E79-42D3-883E-CEE6C3F693CA', 'RO_USER_TEST', 'ro_user_test@digital.justice.gov.uk', true, 'nomis'),
         ('5C72B180-5211-454D-9605-CF29573B946F', 'UOF_REVIEWER_USER', 'uof_reviewer@digital.justice.gov.uk', true, 'nomis'),
         ('98FBF8D7-4164-47B3-826F-ECD3BB643005', 'RCTL_USER', 'rctl_user@digital.justice.gov.uk', true, 'nomis'),
         ('AAABF8D7-4164-47B3-826F-ECD3BB64300F', 'PF_RO_USER', 'pf_ro_user@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65E7BFED', 'UOF_COORDINATOR_USER', 'uof_coordinator@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65E7BFEE', 'LICENCE_READONLY_TEST', 'licence_readonly_test@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65E8BFEF', 'RO_USER_READONLY_TEST', 'ro_user_readonly_test@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65E8BFED', 'CA_RO_DM_USER', 'ca_ro_dm_user_test@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-667B-8711-DA7EB4432CED', 'SOC_PRISON_LOCAL', 'soc_prison_local@digital.justice.gov.uk', true, 'nomis'),
         ('4115C3DF-317B-4007-BF58-F2ECA1BBEED4', 'PCMS_ANALYST_USER', 'pcms_analyst_user@digital.justice.gov.uk', true, 'nomis'),
         ('68599FE3-522D-4210-8296-D1469C35B93E', 'PCMS_AO_USER', 'pcms_ao_user@digital.justice.gov.uk', true, 'nomis'),
         ('26E3087B-FA89-4D8B-914C-D72B287E4289', 'PCMS_GLOBAL_ADMIN_USER', 'pcms_global_admin_user@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65E7BFEF', 'PRISON_COLLATOR_LOCAL', 'prison_collator_local@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3C4E2', 'PRISON_ANALYST_LOCAL', 'prison_analyst_local@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3C4E3', 'PPUD_USER', 'ppud.user.test@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65E7BAAA', 'CALCULATE_RELEASE_DATES_LOCAL', 'calculate_release_dates_local@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CAAB', 'CVL_OMU_LOCAL', 'cvl_omu_local@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CAAC', 'PCMS_AUDIT_USER', 'pcms_audit_user@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CAAD', 'HWPV_CLAIM_ENTRY_BAND_2', 'prisonvisitsbooking@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CAAE', 'HWPV_CLAIM_PAYMENT_BAND_3', 'prisonvisitsbooking@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CAAF', 'HWPV_CASEWORK_MANAGER_BAND_5', 'prisonvisitsbooking@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CABA', 'HWPV_BAND_9', 'prisonvisitsbooking@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CABB', 'HWPV_SSCL_USER', 'prisonvisitsbooking@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CABC', 'HWPV_ALL_USER', 'prisonvisitsbooking@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CABD', 'PT_OMU_LOCAL', 'pt_omu_local@digital.justice.gov.uk', true, 'nomis'),
         ('C3B15C4B-ADF5-493B-9424-DBCC65B3CABE', 'MMP_USER', 'mmp_user@digital.justice.gov.uk', true, 'nomis'),
         ('2D787EC4-556F-4D13-818A-45D6843B9A8D', 'SLM_MAILROOM_USER_LOCAL', 'send_legal_mail_mailroom_user_local@digital.justice.gov.uk', true, 'nomis'),
         ('F770E655-B59C-427F-8DBB-0EE5FD00B895', 'SLM_ADMIN_LOCAL', 'send_legal_mail_admin_local@digital.justice.gov.uk', true, 'nomis');
  
  INSERT INTO users (user_id, username, email, verified, last_logged_in, source)
  VALUES ('A2B6E3C0-2CE4-4148-9DFB-42E94BC78D02', 'NOMIS_DELETE', 'locked@somewhere.com', true, '2018-02-04 13:23:19.0000000', 'nomis');
  
  -- auth users
  INSERT INTO users (user_id, username, password, password_expiry, email, first_name, last_name, verified, enabled, locked, source, last_logged_in)
  VALUES ('f3daec63-ee2f-467c-a6ee-92c3008193bd', 'AUTH_USER_LAST_LOGIN', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_user_last_login@digital.justice.gov.uk', 'Auth_Last', 'Login', false, true, false, 'auth', '2019-01-01 12:05:10'),
  ('f3daec63-ee2f-467c-a6ee-92c3008193ff', 'AUTH_USER_LAST_LOGIN2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_user_last_login2@digital.justice.gov.uk', 'Auth_Last', 'Login', true, true, false, 'auth', '2021-04-05 12:05:10');
  
  INSERT INTO users (user_id, username, password, password_expiry, email, first_name, last_name, verified, enabled, locked, source)
  VALUES ('608955AE-52ED-44CC-884C-011597A77949', 'AUTH_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_user@digital.justice.gov.uk', 'Auth', 'Only', true, true, false, 'auth'),
         ('C36E5A30-53C7-4F6F-9591-0547A2E4897C', 'AUTH_NO_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Auth', 'NoEmail', true, true, false, 'auth'),
         ('0E7AFB2E-A326-4AB6-920C-0A7098F5031F', 'AUTH_LOCKED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Auth', 'Locked', true, true, true, 'auth'),
         ('D9291E62-FCDF-42E4-B31E-2E93AD5BC46A', 'AUTH_NO_ROLES_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'authnoroles@digital.justice.gov.uk', 'NoRoles', 'User', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA02A', 'AUTH_RO_USER_TEST', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user_test@digital.justice.gov.uk', 'Ryan-Auth', 'Orton', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA02B', 'AUTH_RO_USER_TEST2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user_test2@digital.justice.gov.uk', 'Ryan-Auth', 'Orton2', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA02C', 'AUTH_RO_USER_TEST3', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user_test3@digital.justice.gov.uk', 'Ryan-Auth', 'Orton3', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA44A', 'AUTH_RO_USER_TEST4', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user_test4@digital.justice.gov.uk', 'Ryan-Auth', 'Orton4', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA44B', 'AUTH_RO_USER_TEST5', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user_test5@digital.justice.gov.uk', 'Ryan-Auth', 'Orton5', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA02F', 'AUTH_RO_USER_TEST6', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user_test6@digital.justice.gov.uk', 'Ryan-Auth', 'Orton6', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA030', 'AUTH_RO_USER_TEST7', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user_test7@digital.justice.gov.uk', 'Ryan-Auth', 'Orton6', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA02D', 'AUTH_ADD_ROLE_TEST', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_add_role@digital.justice.gov.uk', 'Add', 'RoleTest', true, true, false, 'auth'),
         ('90F930E1-2195-4AFD-92CE-0EB5672DA02E', 'AUTH_ADD_ROLE_TEST2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_add_role2@digital.justice.gov.uk', 'Add', 'RoleTest2', true, true, false, 'auth'),
         ('D9873CB3-24BD-4CFF-9CFE-1E64CE6BBCC4', 'AUTH_LOCKED2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_locked2@digital.justice.gov.uk', 'Auth', 'Locked2', true, true, true, 'auth'),
         ('5E3850B9-9D6E-49D7-B8E7-42874D6CEEA8', 'AUTH_RO_VARY_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user@digital.justice.gov.uk', 'Ryan-Auth-Vary', 'Orton', true, true, false, 'auth'),
         ('AD7D37E2-DBAD-4B98-AF8D-429E822A6BDC', 'AUTH_DISABLED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_disabled@digital.justice.gov.uk', 'Auth', 'Disabled', true, false, false, 'auth'),
         ('7CA04ED7-8275-45B2-AFB4-4FF51432D1EA', 'AUTH_RO_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user@digital.justice.gov.uk', 'Ryan-Auth', 'Orton', true, true, false, 'auth'),
         ('7CA04ED7-8275-45B2-AFB4-4FF51432D1EB', 'AUTH_RO_USER1@DIGITAL.JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user1@digital.justice.gov.uk', 'Ryan-Auth', 'Orton', true, true, false, 'auth'),
         ('7CA04ED7-8275-45B2-AFB4-4FF51432D1EC', 'AUTH_RO_USER2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_ro_user2@digital.justice.gov.uk', 'Ryan-Auth', 'Orton', true, true, false, 'auth'),
         ('1F650F15-0993-4DB7-9A32-5B930FF86035', 'AUTH_GROUP_MANAGER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_group_manager@digital.justice.gov.uk', 'Group', 'Manager', true, true, false, 'auth'),
         ('1F650F15-0993-4DB7-9A32-5B930FF86036', 'AUTH_GROUP_MANAGER2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_group_manager2@digital.justice.gov.uk', 'Group', 'Manager2', true, true, false, 'auth'),
         ('1F650F15-0993-4DB7-9A32-5B930FF86037', 'AUTH_DEVELOPER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_developer@digital.justice.gov.uk', 'Auth', 'Developer', true, true, false, 'auth'),
         ('FC494152-F9AD-48A0-A87C-9ADC8BD75255', 'AUTH_STATUS', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Auth', 'Status', true, false, false, 'auth'),
         ('FC494152-F9AD-48A0-A87C-9ADC8BD75266', 'AUTH_STATUS2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Auth', 'Status2', true, false, false, 'auth'),
         ('FC494152-F9AD-48A0-A87C-9ADC8BD75277', 'AUTH_STATUS3', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Auth', 'Status3', true, false, false, 'auth'),
         ('FC494152-F9AD-48A0-A87C-9ADC8BD75288', 'AUTH_STATUS4', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Auth', 'Status4', true, false, false, 'auth'),
         ('FC494152-F9AD-48A0-A87C-9ADC8BD75299', 'AUTH_STATUS5', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Auth', 'Status5', true, false, false, 'auth'),
         ('9E84F1E4-59C8-4B10-927A-9CF9E9A30791', 'AUTH_EXPIRED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '2013-01-28 13:23:19.0000000', 'auth_test2@digital.justice.gov.uk', 'Auth', 'Expired', true, true, false, 'auth'),
         ('9E84F1E4-59C8-4B10-927A-9CF9E9A30792', 'AUTH_MFA_EXPIRED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '2013-01-28 13:23:19.0000000', 'auth_test3@digital.justice.gov.uk', 'Auth', 'Expired', true, true, false, 'auth'),
         ('5105A589-75B3-4CA0-9433-B96228C1C8F3', 'AUTH_ADM', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_test2@digital.justice.gov.uk', 'Auth', 'Adm', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2A3E', 'AUTH_TEST', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_test@digital.justice.gov.uk', 'Auth', 'Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2B3F', 'AUTH_CHANGE_TEST', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_test@digital.justice.gov.uk', 'Auth', 'Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2C3F', 'AUTH_CHANGE2_TEST', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_test@digital.justice.gov.uk', 'Auth', 'Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D3F', 'AUTH_CHANGE_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_test@digital.justice.gov.uk', 'Auth', 'Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E23-D6E8E10A2D3F', 'AUTH_CHANGE_EMAIL@JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_change_email@justice.gov.uk', 'User', 'Email Test', true, true, false, 'auth'),
         ('2E285CCD-DCFC-4497-9E22-D6E8E10A2A3F', 'AUTH_CMD_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'cmd_user@digital.justice.gov.uk', 'Cmd', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFB-4497-9E22-D6E8E10A2A3F', 'AUTH_CMD_MIGRATED_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'cmd_user@digital.justice.gov.uk', 'Cmd', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4597-9E23-D6E8E10A2D3F', 'AUTH_VERIFY_EMAIL@JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_verify_email@justice.gov.uk', 'Verify', 'Email Test', false, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E24-D6E8E10A2D3F', 'AUTH_USER_EMAIL@JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_user_email@justice.gov.uk', 'User', 'Email Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E25-D6E8E10A2D3F', 'AUTH_USER_EMAIL_TEST@JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_user_email_test@justice.gov.uk', 'User', 'Email Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E26-D6E8E10A2D3F', 'AUTH_USER_EMAIL2_TEST@JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_user_email2_test@justice.gov.uk', 'User', 'Email Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E27-D6E8E10A2D3F', 'AUTH_USER_EMAIL3_TEST@JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_user_email3_test@justice.gov.uk', 'User', 'Email Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E28-D6E8E10A2D3F', 'AUTH_BULK_AMEND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_change@justice.gov.uk', 'User', 'Change Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E29-D6E8E10A2D3F', 'AUTH_BULK_AMEND_EMAIL@DIGITAL.JUSTICE.GOV.UK', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_bulk_amend_email@digital.justice.gov.uk', 'User', 'Change Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E30-D6E8E10A2D3F', 'AUTH_CHANGE_TO_USERNAME', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_change@justice.gov.uk', 'User', 'Change Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D4F', 'AUTH_CHANGE_EMAIL2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'Auth', 'Test', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D5F', 'AUTH_CHANGE_EMAIL_VERIFIED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'Auth', 'Email', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D6F', 'AUTH_CHANGE_EMAIL_GSI', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'Auth', 'Email', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D7F', 'AUTH_CHANGE_EMAIL_INVALID', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'Auth', 'Email', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D8F', 'AUTH_CHANGE_EMAIL_INCOMPLETE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'Auth', 'Email', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D40', 'AUTH_CHANGE_MOBILE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_mobile@digital.justice.gov.uk', 'Auth', 'Mobile', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D41', 'AUTH_CHANGE_MOBILE2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_mobile@digital.justice.gov.uk', 'Auth', 'Mobile', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D42', 'AUTH_CHANGE_MOBILE_ADD', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_mobile@digital.justice.gov.uk', 'Auth', 'Mobile', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D43', 'AUTH_CHANGE_MOBILE3', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_mobile@digital.justice.gov.uk', 'Auth', 'Mobile', true, true, false, 'auth'),
         ('67A789DE-7D29-4863-B9C2-F2CE715DC4BC', 'AUTH_NEW_USER', null, '3013-01-28 13:23:19.0000000', 'a@b.com', 'Auth', 'New-User', false, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2A3F', 'AUTH_MFA_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa', 'User', true, true, false, 'auth'),
         ('2E285CCF-DCFD-4497-9E22-D6E8E10A2A3F', 'AUTH_MFA_NOEMAIL_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'Mfa No Email', 'User', true, true, false, 'auth'),
         ('2E285CCE-DCFD-4497-9E22-D6E8E10A2A3F', 'AUTH_MFA_TOKEN_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2A4F', 'AUTH_MFA_EXPIRED_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2A5F', 'AUTH_MFA_LOCKED_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa Locked', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2A6F', 'AUTH_MFA_LOCKED2_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa Locked', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E21-D6E8E10A2A9F', 'AUTH_MFA_LOCKED3_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa Locked', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E21-D6E8E10A2A10', 'AUTH_MFA_LOCKED4_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa Locked', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E21-D6E8E10A2A11', 'AUTH_MFA_LOCKED5_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa Locked', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E21-D6E8E10A2A12', 'AUTH_MFA_LOCKED6_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa Locked', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-E6E8E10A2A6F', 'AUTH_MFA_CHANGE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'mfa_user@digital.justice.gov.uk', 'Mfa Locked', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-F6E8E10A2A6F', 'AUTH_MFA_CHANGE_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'Mfa', 'User', true, true, false, 'auth'),
         ('C6C9C675-32C0-4f58-936B-07744f0E4317', 'AUTH_REGISTERS_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'registers_maintainer@digital.justice.gov.uk', 'Registers', 'Maintainer', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A60', 'AUTH_SECOND_EMAIL_ADD', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A61', 'AUTH_SECOND_EMAIL_UPDATE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A62', 'AUTH_SECOND_EMAIL_VERIFY', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A63', 'AUTH_SECOND_EMAIL_VERIFY2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A64', 'AUTH_SECOND_EMAIL_ALREADY', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A65', 'AUTH_SECOND_EMAIL_CHANGE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A66', 'AUTH_MFA_PREF_NO_EMAIL_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', null, 'email', 'User', false, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A67', 'AUTH_MFA_PREF_EMAIL_AND_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A68', 'AUTH_CREATE_USER_VALID', null, '2020-01-28 13:23:19.0000000', 'create_user@digital.justice.gov.uk', 'email', 'User', false, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A69', 'AUTH_CREATE_USER_VALID2', null, '2020-01-28 13:23:19.0000000', 'create_user@digital.justice.gov.uk', 'email', 'User', false, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A6A', 'AUTH_CREATE_USER_EXPIRED', null, '2020-01-28 13:23:19.0000000', 'auth_email@digital.justice.gov.uk', 'email', 'User', false, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-A9E8E10A2A6B', 'AUTH_CREATE_USER_INVALID', null, '2020-01-28 13:23:19.0000000', 'auth_invalid_token@digital.justice.gov.uk', 'email', 'User', false, true, false, 'auth'),
         ('6c76f1fa-3393-11ea-978f-2e728ce88125', 'AUTH_VIDEO_LINK_COURT_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'vlb_court_user@digital.justice.gov.uk', 'VLB Court', 'User', true, true, false, 'auth'),
         ('C6C9C675-32C0-4f58-936B-07744f0E4318', 'MAKE_RECALL_DECISION_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'making-recall-decisions-tech@digital.justice.gov.uk', 'Making Recall Decisions', 'User', true, true, false, 'auth'),
         ('9f6f8681-c273-48e5-bf6c-29a2d4fe159d', 'NOMIS_ENABLED_AUTH_DISABLED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'nomis_auth_user@digital.justice.gov.uk', 'nomis_enabled', 'Auth Disabled', true, false, false, 'auth'),
         ('8351b5de-2c38-4c0a-bcad-8ee78de6b5af', 'NOMIS_LOCKED_AUTH_DISABLED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'nomis_auth_user@digital.justice.gov.uk', 'nomis locked', 'Auth Disabled', true, false, false, 'auth'),
         ('f83c7a90-50c2-4b1b-b5ab-59206f731202', 'DELIUS_ENABLED_AUTH_DISABLED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'delius_auth_user@digital.justice.gov.uk', 'nomis_disabled', 'Auth Disabled', true, false, false, 'auth'),
         ('f83c7a90-50c2-4b1b-b5ab-59206f731203', 'DELIUS_ENABLED_AUTH_DISABLED_LOCKED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'delius_auth_user@digital.justice.gov.uk', 'delius enabled', 'Auth Disabled Locked', true, false, true, 'auth'),
         ('730f3b3c-2758-4a92-b341-f2489dcbc6a0', 'ALLOCATIONS', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'allocations@digital.justice.gov.uk', 'Allocations', 'User', true, true, false, 'delius'),
         ('edec977d-b743-4744-a8a8-1da84ee40c6b', 'WMT_DATA_ADMIN', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'wmt_data_admin@digital.justice.gov.uk', 'Wmt Data', 'Admin', true, true, false, 'delius'),
         ('9274ec5b-19fd-49ce-ae3c-a6f5d77a3388', 'WMT_MANAGER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'wmt_manager@digital.justice.gov.uk', 'Wmt', 'Manager', true, true, false, 'delius'),
         ('f47742d4-18ba-4332-9519-86b2c94ab99c', 'WMT_STAFF', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'wmt_staff@digital.justice.gov.uk', 'Wmt', 'Staff', true, true, false, 'delius'),
         ('7fa0d669-6875-4d6b-86a5-3cf42c1c0015', 'WMT_SYSTEM_ADMIN', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'wmt_system_admin@digital.justice.gov.uk', 'Wmt System', 'Admin', true, true, false, 'delius');
  
  INSERT INTO users (user_id, username, password, last_logged_in, first_name, last_name, verified, enabled, locked, source)
  VALUES ('7B59A818-BC14-43F3-A1C3-93004E173B2A', 'AUTH_DELETE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '2018-01-02 13:23:19.0000000', 'Auth', 'Delete', true, false, false, 'auth'),
         ('DA28D339-85FA-42C1-9CFA-AC67055A51A5', 'AUTH_INACTIVE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '2019-02-03 13:23:19.0000000', 'Auth', 'Inactive', false, true, false, 'auth'),
         ('7112EC3B-88C1-48C3-BCC3-F82874E3F2C3', 'AUTH_DELETEALL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '2018-02-03 13:23:19.0000000', 'Auth', 'DeleteAll', true, false, false, 'auth');
  
  INSERT INTO users (user_id, username, password, password_expiry, email, first_name, last_name, verified, enabled, locked, source)
  VALUES ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D50', 'AUTH_CHANGE_MOBILE_VERIFIED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_mnbile@digital.justice.gov.uk', 'Auth', 'Mobile', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D51', 'AUTH_CHANGE_MOBILE_UPDATE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_mobile@digital.justice.gov.uk', 'Auth', 'Mobile', true, true, false, 'auth'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D52', 'AUTH_UNVERIFIED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Unverified', false, true, false, 'auth');
  
  INSERT INTO users (user_id, username, password, password_expiry, email, first_name, last_name, verified, enabled, locked, source, mfa_preference)
  VALUES ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D60', 'AUTH_MFA_PREF_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.email@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D61', 'AUTH_MFA_PREF_EMAIL2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.email@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D62', 'AUTH_MFA_PREF_EMAIL3', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.email@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D63', 'AUTH_MFA_PREF_EMAIL4', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.email@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D64', 'AUTH_MFA_PREF_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D65', 'AUTH_MFA_PREF_TEXT2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D66', 'AUTH_MFA_PREF_TEXT3', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D67', 'AUTH_MFA_PREF_TEXT4', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2A11', 'AUTH_MFA_PREF_TEXT5', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D68', 'AUTH_MFA_LOCKED_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D69', 'AUTH_MFA_LOCKED2_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E23-D6E8E10A2D69', 'AUTH_MFA_LOCKED3_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E23-D6E8E10A2D01', 'AUTH_MFA_LOCKED4_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E23-D6E8E10A2D02', 'AUTH_MFA_LOCKED5_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCF-DCFD-4498-9E22-D6E8E10A2D6A', 'AUTH_MFA_NOTEXT_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Mfa No Text', 'User', false, true, false, 'auth','TEXT'),
         ('2E285CCF-DCFD-4499-9E22-D6E8E10A2D6B', 'AUTH_MFA_PREF_TEXT_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.text@digital.justice.gov.uk', 'Mfa No Text', 'User', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D6C', 'AUTH_MFA_SHORT_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'bob@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D6D', 'AUTH_MFA_NON_VERIFIED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'bob@digital.justice.gov.uk', 'Auth', 'Mfa', false, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D6E', 'AUTH_MFA_PREF_EMAIL5', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.email@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E21-D6E8E10A2D6F', 'AUTH_MFA_PREF_EMAIL6', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.email@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D70', 'AUTH_UNVERIFIED_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', false, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D71', 'AUTH_MFA_PREF_2ND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D72', 'AUTH_MFA_PREF_2ND_EMAIL2', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D73', 'AUTH_MFA_PREF_2ND_EMAIL3', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D74', 'AUTH_MFA_PREF_2ND_EMAIL4', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D75', 'AUTH_MFA_LOCKED_2ND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D76', 'AUTH_MFA_LOCKED2_2ND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E21-D6E8E10A2D76', 'AUTH_MFA_LOCKED3_2ND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E20-D6E8E10A2D76', 'AUTH_MFA_LOCKED4_2ND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E19-D6E8E10A2D76', 'AUTH_MFA_LOCKED5_2ND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D77', 'AUTH_MFA_PREF_2ND_EMAIL_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D80', 'AUTH_PREF_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.pref.text@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D81', 'AUTH_PREF_2ND_EMAIL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.pref.secondemail@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D83', 'AUTH_PREF_EMAIL_TEXT', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.pref.secondemail@digital.justice.gov.uk', 'Auth', 'Mfa', true, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D82', 'AUTH_NO_PREF', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth.no.pref@digital.justice.gov.uk', 'Auth', 'Mfa', false, true, false, 'auth', 'TEXT'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D78', 'AUTH_USER_LINK_EXPIRED', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', false, true, false, 'auth', 'SECONDARY_EMAIL'),
         ('2E285CCD-DCFD-4497-9E22-D6E8E10A2D79', 'AUTH_USER_2ND_EMAIL_LINK_EXP', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', '3013-01-28 13:23:19.0000000', 'auth_unverified@digital.justice.gov.uk', 'Auth', 'Mfa', false, true, false, 'auth', 'SECONDARY_EMAIL');
  
  -- delius users
  INSERT INTO users (user_id, username, email, last_logged_in, first_name, last_name, verified, enabled, locked, source)
  VALUES ('7B59A818-BC14-43F3-A1C3-93004E173B2B', 'DELIUS_EMAIL', 'delius_user@digital.justice.gov.uk', '3013-01-02 13:23:19.0000000', 'Delius', 'Smith', true, true, false, 'delius'),
         ('7B59A818-BC14-43F3-A1C3-93004E173B22', 'DELIUS_PASSWORD_RESET', 'delius_locked@digital.justice.gov.uk', '3013-01-02 13:23:19.0000000', 'Delius', 'Smith', true, true, false, 'delius'),
         ('7B59A818-BC14-43F3-A1C3-93004E173B23', 'DELIUS_SECOND_EMAIL_UPDATE', 'delius_email@digital.justice.gov.uk', '3013-01-02 13:23:19.0000000', 'Delius', 'Smith', true, true, false, 'delius');
  
  INSERT INTO users (user_id, username, password, password_expiry, email, first_name, last_name, verified, enabled, locked, source)
  VALUES ('7B59A818-BC14-43F3-A1C3-93004E173B2C','DELIUS_EMAIL_RESET', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy','3013-01-02 13:23:19.0000000', 'delius_email@digital.justice.gov.uk',  'Delius', 'Smith', true, true, false, 'delius');
  
  -- oauth user (police user used by pathfinder)
  INSERT INTO users (user_id, username, password, email, first_name, last_name, verified, locked, enabled, master, create_datetime, password_expiry, last_logged_in, source, mfa_preference)
  VALUES ('ABD94E71-0047-43F1-842B-7BD7E0EB5B09', 'TEST_PF_POLICE_1', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', 'test.pf.police@digital.justice.gov.uk', 'Bobby', 'London', true, false, true, false, '2020-05-01 15:07:34.5466667', '2040-04-26 16:17:28.4953990', '2019-05-18 14:16:21.7349800', 'auth', 'EMAIL');
  
  insert into group_assignable_role (role_id, group_id, automatic) values ((select role_id from roles where role_code = 'PF_POLICE'),
                                                                           (select group_id from groups where group_code = 'PF_LONDON'), true);
  
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'TEST_PF_POLICE_1' and role_code = 'PF_POLICE';
  
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_DEVELOPER' and role_code = 'MAINTAIN_EMAIL_DOMAINS';
  
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_PF_POLICE_1' and group_code = 'PF_LONDON';
  
  
  -- Local police accounts for manage-soc-cases
  INSERT INTO users (user_id, username, password, email, first_name, last_name, verified, locked, enabled, master, password_expiry, source, mfa_preference)
  VALUES ('ABCF4E74-0056-43D1-454B-8BD7E0ED5B10', 'SOC_POLICE_LOCAL_NE', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', 'soc.ne@digital.justice.gov.uk', 'Bobby', 'Gateshead', true, false, true, false, '2040-04-26 16:17:28.0000000', 'auth', 'EMAIL');
  
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'SOC_POLICE_LOCAL_NE' and group_code = 'SOC_NORTH_EAST';
  
  INSERT INTO users (user_id, username, password, email, first_name, last_name, verified, locked, enabled, master, password_expiry, source, mfa_preference)
  VALUES ('ABCF4F85-0057-43E1-454C-87D345DD510A', 'SOC_POLICE_LOCAL_NW', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', 'soc.nw@digital.justice.gov.uk', 'Bobby', 'Chester', true, false, true, false, '2040-04-26 16:17:28.0000000', 'auth', 'EMAIL');
  
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'SOC_POLICE_LOCAL_NW' and group_code = 'SOC_NORTH_WEST';
  
  -- Auth user for Artemis
  INSERT INTO users (user_id, username, password, email, first_name, last_name, verified, locked, enabled, master, create_datetime, password_expiry, last_logged_in, source, mfa_preference)
  VALUES
      ('ABD94E71-0047-43F1-842B-5BEF234AEB09', 'AUTH_INTEL_LOCAL', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', 'auth.intel@digital.justice.gov.uk', 'Intel', 'Local', true, false, true, false, '2020-05-01 15:07:34.5466667', '2040-04-26 16:17:28.4953990', '2020-05-18 14:16:21.7349800', 'auth', 'EMAIL');
  
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_INTEL_LOCAL' and role_code = 'ARTEMIS_USER';
  
  -- Auth user for pecs journey price calculation service
  INSERT INTO users (user_id, username, password, email, first_name, last_name, verified, locked, enabled, master, create_datetime, password_expiry, last_logged_in, source, mfa_preference)
  VALUES
      ('ABD94E71-0047-43F1-842B-5BEF234AEB10', 'JPC_USER', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', 'auth.intel@digital.justice.gov.uk', 'JPC', 'User', true, false, true, false, '2020-05-01 15:07:34.5466667', '2040-04-26 16:17:28.4953990', '2020-05-18 14:16:21.7349800', 'auth', 'EMAIL');
  
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'JPC_USER' and role_code = 'PECS_JPC';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'JPC_USER' and role_code = 'PECS_MAINTAIN_PRICE';
  
  -- auth user for interventions service provider journeys
  INSERT INTO users (user_id, username, password, email, first_name, last_name, verified, locked, enabled, master, create_datetime, password_expiry, last_logged_in, source, mfa_preference)
  VALUES ('6C4036B7-E87D-44FB-864F-5A06C1C492F3', 'TEST_INTERVENTIONS_SP_1', '{bcrypt}$2a$10$Fmcp2KUKRW53US3EJfsxkOh.ekZhqz5.Baheb9E98QLwEFLb9csxy', 'test.interventions.sp.1@digital.justice.gov.uk', 'Robin', 'Croswell', true, false, true, false, '2021-03-05 11:48:34.2723638', '2040-04-26 16:17:28.4953990', '2040-03-05 11:48:34.2723638', 'auth', 'EMAIL');
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'TEST_INTERVENTIONS_SP_1' and role_code = 'CRS_PROVIDER';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_INTERVENTIONS_SP_1' and group_code = 'INT_SP_HARMONY_LIVING';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_INTERVENTIONS_SP_1' and group_code = 'INT_CR_0001';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_INTERVENTIONS_SP_1' and group_code = 'INT_CR_0002';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_INTERVENTIONS_SP_1' and group_code = 'INT_CR_0003';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_INTERVENTIONS_SP_1' and group_code = 'INT_CR_0004';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_INTERVENTIONS_SP_1' and group_code = 'INT_CR_0005';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'TEST_INTERVENTIONS_SP_1' and group_code = 'INT_CR_0006';
  
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'reset', 'RESET', '2018-12-10 08:55:45.0000000', user_id from users where username = 'LOCKED_USER';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'reset2', 'RESET', '2018-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_DELETEALL';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'reset3', 'RESET', '3031-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_CREATE_USER_VALID';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'reset4', 'RESET', '3031-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_CREATE_USER_VALID2';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'reset5', 'RESET', '2018-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_CREATE_USER_EXPIRED';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'expired1', 'VERIFIED', '2018-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_USER_LINK_EXPIRED';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'expired2', 'SECONDARY', '2018-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_USER_2ND_EMAIL_LINK_EXP';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'verified', 'VERIFIED', '2018-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_DELETEALL';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'mfa_expired', 'MFA', '2018-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_MFA_EXPIRED_USER';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'mfa_token', 'MFA', '3031-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_MFA_TOKEN_USER';
  INSERT INTO user_token (token, token_type, token_expiry, user_id) SELECT 'mfa_code', 'MFA_CODE', '3031-12-10 08:55:45.0000000', user_id from users where username = 'AUTH_MFA_TOKEN_USER';
  
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_ADM' and role_code = 'OAUTH_ADMIN';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_ADM' and role_code = 'MAINTAIN_ACCESS_ROLES';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_ADM' and role_code = 'MAINTAIN_OAUTH_USERS';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_ADM' and role_code = 'ROLES_ADMIN';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_ADM' and role_code = 'AUDIT_VIEWER';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER' and role_code = 'LICENCE_RO';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER2' and role_code = 'LICENCE_RO';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER' and role_code = 'GLOBAL_SEARCH';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER2' and role_code = 'GLOBAL_SEARCH';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_VARY_USER' and role_code = 'LICENCE_RO';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_VARY_USER' and role_code = 'GLOBAL_SEARCH';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_VARY_USER' and role_code = 'LICENCE_VARY';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER_TEST' and role_code = 'LICENCE_RO';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER_TEST' and role_code = 'GLOBAL_SEARCH';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER_TEST2' and role_code = 'GLOBAL_SEARCH';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER_TEST6' and role_code = 'LICENCE_RO';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_RO_USER_TEST6' and role_code = 'GLOBAL_SEARCH';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_GROUP_MANAGER' and role_code = 'AUTH_GROUP_MANAGER';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_GROUP_MANAGER2' and role_code = 'AUTH_GROUP_MANAGER';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_DEVELOPER' and role_code = 'OAUTH_VIEW_ONLY_CLIENT';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_DEVELOPER' and role_code = 'MAINTAIN_EMAIL_DOMAINS';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_DELETEALL' and role_code = 'LICENCE_RO';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_DELETEALL' and role_code = 'LICENCE_RO';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_CMD_MIGRATED_USER' and role_code = 'CMD_MIGRATED_MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_REGISTERS_USER' and role_code = 'HMPPS_REGISTERS_MAINTAINER';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_USER' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_NOEMAIL_USER' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_NOTEXT_USER' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_TEXT_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_LOCKED_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_LOCKED2_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_LOCKED_TEXT' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_LOCKED2_TEXT' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_EXPIRED' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_CHANGE' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_CHANGE_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_EMAIL2' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_EMAIL3' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_EMAIL4' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_EMAIL5' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_TEXT' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_TEXT2' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_TEXT3' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_TEXT4' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_TEXT5' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_SHORT_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_NON_VERIFIED' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_2ND_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_2ND_EMAIL2' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_2ND_EMAIL3' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_2ND_EMAIL4' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_PREF_2ND_EMAIL_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_LOCKED2_2ND_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_MFA_LOCKED_2ND_EMAIL' and role_code = 'MFA';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'AUTH_VIDEO_LINK_COURT_USER' and role_code = 'VIDEO_LINK_COURT_USER';
  INSERT INTO user_role (role_id, user_id) SELECT role_id, user_id from roles, users where username = 'MAKE_RECALL_DECISION_USER' and role_code = 'MAKE_RECALL_DECISION';
  
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_VARY_USER' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_VARY_USER' and group_code = 'SITE_1_GROUP_2';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER2' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST' and group_code = 'SITE_2_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST2' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST2' and group_code = 'SITE_2_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST3' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST3' and group_code = 'GC_DEL_4';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST5' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST6' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST6' and group_code = 'SITE_2_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST7' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_RO_USER_TEST7' and group_code = 'GC_DEL_4';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_GROUP_MANAGER' and group_code = 'SITE_1_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_GROUP_MANAGER' and group_code = 'SITE_1_GROUP_2';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_DELETEALL' and group_code = 'SITE_3_GROUP_1';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_GROUP_MANAGER2' and group_code = 'PF_LONDON';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_CHANGE_TEST' and group_code = 'GC_DEL_2';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_CHANGE_TEST' and group_code = 'GC_DEL_2';
  INSERT INTO user_group (group_id, user_id) SELECT group_id, user_id from groups, users where username = 'AUTH_STATUS5' and group_code = 'SITE_1_GROUP_1';
  
  INSERT INTO group_assignable_role (role_id, group_id, automatic) SELECT role_id, group_id, 'true' FROM groups g, roles r WHERE r.role_code = 'GLOBAL_SEARCH' AND g.group_code = 'SITE_1_GROUP_1';
  INSERT INTO group_assignable_role (role_id, group_id, automatic) SELECT role_id, group_id, 'true' FROM groups g, roles r WHERE r.role_code = 'LICENCE_RO' AND g.group_code = 'SITE_1_GROUP_1';
  INSERT INTO group_assignable_role (role_id, group_id, automatic) SELECT role_id, group_id, 'false' FROM groups g, roles r WHERE r.role_code = 'LICENCE_VARY' AND g.group_code = 'SITE_1_GROUP_1';
  INSERT INTO group_assignable_role (role_id, group_id, automatic) SELECT role_id, group_id, 'true' FROM groups g, roles r WHERE r.role_code = 'GLOBAL_SEARCH' AND g.group_code = 'SITE_1_GROUP_2';
  INSERT INTO group_assignable_role (role_id, group_id, automatic) SELECT role_id, group_id, 'true' FROM groups g, roles r WHERE r.role_code = 'LICENCE_RO' AND g.group_code = 'SITE_1_GROUP_2';
  
  INSERT INTO user_contact (user_id, type, details) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com' FROM users where username = 'AUTH_ADM';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_EMAIL5';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_SECOND_EMAIL_UPDATE';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'bob@gmail.com', false FROM users where username = 'AUTH_SECOND_EMAIL_VERIFY';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'bob@gmail.com', false FROM users where username = 'AUTH_SECOND_EMAIL_VERIFY2';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_SECOND_EMAIL_ALREADY';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_SECOND_EMAIL_CHANGE';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_TEXT5';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_2ND_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_2ND_EMAIL2';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_2ND_EMAIL3';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_2ND_EMAIL4';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_LOCKED_2ND_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_LOCKED2_2ND_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_LOCKED3_2ND_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_LOCKED4_2ND_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_LOCKED5_2ND_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_MFA_PREF_EMAIL_AND_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', false FROM users where username = 'AUTH_USER_2ND_EMAIL_LINK_EXP';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_CHANGE_MOBILE_VERIFIED';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', false FROM users where username = 'AUTH_CHANGE_MOBILE_UPDATE';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', false FROM users where username = 'AUTH_UNVERIFIED';
  
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_EMAIL2';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_EMAIL3';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_EMAIL4';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_TEXT2';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_TEXT3';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_TEXT4';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_TEXT5';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_LOCKED_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_LOCKED2_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_LOCKED3_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_LOCKED4_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_LOCKED5_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', false FROM users where username = 'AUTH_MFA_SHORT_EMAIL';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', false FROM users where username = 'AUTH_MFA_UNVERIFIED';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_EMAIL5';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', false FROM users where username = 'AUTH_UNVERIFIED_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_2ND_EMAIL2';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_MFA_PREF_EMAIL_AND_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_PREF_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'MOBILE_PHONE', '07700900321', true FROM users where username = 'AUTH_PREF_EMAIL_TEXT';
  INSERT INTO user_contact (user_id, type, details, verified) SELECT user_id, 'SECONDARY_EMAIL', 'john@smith.com', true FROM users where username = 'AUTH_PREF_2ND_EMAIL';
  
  INSERT INTO user_retries (username, retry_count)
  VALUES ('LOCKED_USER', 5),
         ('LOCKED_NOMIS_USER', 3),
         ('AUTH_DELETEALL', 3),
         ('NOMIS_DELETE', 1);
  