167.sql
No OneTemporary
Actions

Size

591 B

Subscribers

None

167.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 166
	-- to_version: 167
	-- description: Make origin_visit_status.type not null

	insert into dbversion(version, release, description)
	values(167, now(), 'Work In Progress');

	-- (blocking) Data migrated, all values populated now, so we can add the constraint
	-- alter table origin_visit_status alter column type set not null;

	-- (unblocking) functionally equivalent constraint
	alter table origin_visit_status
	add constraint type_not_null check (type is not null) not valid;

	alter table origin_visit_status validate constraint type_not_null;