idv2_migrate.sql

INSERT INTO text_item (id, language_code,
                       section,
                       key,
                       value,
                       version, created_by, modified_by,
                       modified_date, created_date)
VALUES (${uuid_function}, 'en',
        'APPLICANT_IDV',
        'CONTACT_US',
        'Please contact us, if you are experiencing any issues submitting your identification',
        1, 'd75cb460-5c32-4a7f-aec2-721f2acfe20f', 'd75cb460-5c32-4a7f-aec2-721f2acfe20f',
        current_timestamp, current_timestamp),
       (${uuid_function}, 'en',
        'APPLICANT_IDV',
        'VERIFICATION_WAITING',
        'Just a minute while we finalise our checks...',
        1, 'd75cb460-5c32-4a7f-aec2-721f2acfe20f', 'd75cb460-5c32-4a7f-aec2-721f2acfe20f',
        current_timestamp, current_timestamp),
       (${uuid_function}, 'en',
        'APPLICANT_IDV',
        'NEED_RETRY_MSG',
        'We couldn''t verify your identity, please try again.',
        1, 'd75cb460-5c32-4a7f-aec2-721f2acfe20f', 'd75cb460-5c32-4a7f-aec2-721f2acfe20f',
        current_timestamp, current_timestamp),
       (${uuid_function}, 'en',
        'APPLICANT_IDV',
        'STATUS_IN_PROGRESS',
        'IN PROGRESS',
        1, 'd75cb460-5c32-4a7f-aec2-721f2acfe20f', 'd75cb460-5c32-4a7f-aec2-721f2acfe20f',
        current_timestamp, current_timestamp);

To be added:

-- Make IDV feature ON by default:
UPDATE cfg_feature SET enabled=true WHERE feature_key='ID_VERIFICATION';

To be added:

UPDATE text_item SET value='TRY AGAIN' WHERE section='APPLICANT_IDV' AND key='STATUS_NEED_RETRY';