Schema Changes: 2.8.4
Upgrade: 2.8.3 → 2.8.4
This release applied 1 migration(s) to the database schema.
| ID | Type | Description |
|---|---|---|
data |
authority.control set authority field remove sf e |
Migration Details
941 — authority.control set authority field remove sf e
Type: data
View SQL
UPDATE authority.control_set_authority_field SET sf_list = REGEXP_REPLACE( sf_list, 'e', '', 'i') WHERE tag = '100' AND control_set = 1 AND sf_list ILIKE '%e%';
UPDATE authority.control_set_authority_field SET sf_list = REGEXP_REPLACE( sf_list, 'e', '', 'i') WHERE tag = '110' AND control_set = 1 AND sf_list ILIKE '%e%';