v4.30.0
What's Changed
- Track Program by @slominskir in #54
- Hide archived groups from selection by @slominskir in #53
Oracle Migration Notes
alter table dtm_owner.event_type rename column multi_hall_yn to affected_hall_yn;
alter table dtm_owner.event_type add affected_research_yn varchar2(1 char) default 'N' not null;
alter table dtm_owner.event_type add constraint event_type_ck3 check (affected_research_yn in ('Y', 'N'));
alter table dtm_owner.incident add research_yn varchar2(1 char) default 'Y' not null;
alter table dtm_owner.incident add constraint incident_ck2 check (research_yn in ('Y', 'N'));
alter table dtm_owner.incident_aud add research_yn varchar2(1 char) default 'Y' not null;
alter table dtm_owner.incident_aud add constraint incident_aud_ck2 check (research_yn in ('Y', 'N'));
create or replace view dtm_owner.workgroup as
(
select group_id as workgroup_id, name, archived_yn from srm_owner.responsible_group
);
Full Changelog: v4.29.0...v4.30.0