Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/161.sql
-- SWH DB schema upgrade | -- SWH DB schema upgrade | ||||
-- from_version: 160 | -- from_version: 160 | ||||
-- to_version: 161 | -- to_version: 161 | ||||
-- description: Make revision.extra_headers not null | -- description: Make revision.extra_headers not null | ||||
-- latest schema version | -- latest schema version | ||||
insert into dbversion(version, release, description) | insert into dbversion(version, release, description) | ||||
values(161, now(), 'Work Still In Progress'); | values(161, now(), 'Work Still In Progress'); | ||||
update revision | update revision | ||||
set extra_headers = ARRAY[]::bytea[][] | set extra_headers = ARRAY[]::bytea[][] | ||||
where extra_headers is null; | where extra_headers is null; | ||||
alter table revision | |||||
add constraint revision_extra_headers_not_null | |||||
check (extra_headers is not null) | |||||
not valid; | |||||
alter table revision | alter table revision | ||||
alter column extra_headers set not null; | validate constraint revision_extra_headers_not_null; |