Schema Changes: 2.11.3
Upgrade: 2.11.2 → 2.11.3
This release applied 3 migration(s) to the database schema.
| ID | Type | Description |
|---|---|---|
data |
fix full overlay vmp |
|
schema |
actor usr usrname unaccent idx |
|
data |
coust view perms stripe |
Migration Details
1012 — fix full overlay vmp
Type: data
View SQL
UPDATE vandelay.merge_profile
SET preserve_spec = '901c',
replace_spec = NULL
WHERE id = 2
AND name = oils_i18n_gettext(2, 'Full Overlay', 'vmp', 'name')
AND preserve_spec IS NULL
AND add_spec IS NULL
AND strip_spec IS NULL
AND replace_spec = '901c';
1013 — actor usr usrname unaccent idx
Type: schema
View SQL
CREATE INDEX actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname));
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;