Schema Changes: 3.11.3

↑ Changelog

Upgrade: 3.11.2 → 3.11.3

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

ID	Type	Description
1399	schema	copy template fine level constaint
1400	data	stat cat entry grids persist cwst

Type

Description

1399

schema

copy template fine level constaint

1400

data

stat cat entry grids persist cwst

Migration Details

1399 — copy template fine level constaint

Type: schema

View SQL

ALTER TABLE asset.copy_template DROP CONSTRAINT valid_fine_level;
ALTER TABLE asset.copy_template ADD CONSTRAINT valid_fine_level
      CHECK (fine_level IS NULL OR fine_level IN (1,2,3));

1400 — stat cat entry grids persist cwst

Type: data

View SQL

INSERT into config.workstation_setting_type (name, grp, datatype, label)
VALUES (
    'eg.grid.admin.local.actor.stat_cat_entry', 'gui', 'object',
    oils_i18n_gettext(
        'eg.grid.admin.local.actor.stat_cat_entry',
        'Grid Config: admin.local.actor.stat_cat_entry',
        'cwst', 'label'
    )
), (
    'eg.grid.admin.local.asset.stat_cat_entry', 'gui', 'object',
    oils_i18n_gettext(
        'eg.grid.admin.local.asset.stat_cat_entry',
        'Grid Config: admin.local.asset.stat_cat_entry',
        'cwst', 'label'
    )
);