Schema Changes: 2.10.10

Upgrade: 2.10.9 → 2.10.10

This release applied 1 migration(s) to the database schema.

ID Type Description

1018

data

coust view perms stripe

Migration Details

1018 — coust view perms stripe

Type: data

View SQL
UPDATE config.org_unit_setting_type
    SET view_perm = (SELECT id FROM permission.perm_list
        WHERE code = 'VIEW_CREDIT_CARD_PROCESSING' LIMIT 1)
    WHERE name LIKE 'credit.processor.stripe%' AND view_perm IS NULL;

UPDATE config.org_unit_setting_type
    SET update_perm = (SELECT id FROM permission.perm_list
        WHERE code = 'ADMIN_CREDIT_CARD_PROCESSING' LIMIT 1)
    WHERE name LIKE 'credit.processor.stripe%' AND update_perm IS NULL;