diff --git a/sql/upgrades/161.sql b/sql/upgrades/161.sql index c2c95c07..c3f34227 100644 --- a/sql/upgrades/161.sql +++ b/sql/upgrades/161.sql @@ -1,17 +1,21 @@ -- SWH DB schema upgrade -- from_version: 160 -- to_version: 161 -- description: Make revision.extra_headers not null -- latest schema version insert into dbversion(version, release, description) values(161, now(), 'Work Still In Progress'); update revision set extra_headers = ARRAY[]::bytea[][] 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 column extra_headers set not null; + validate constraint revision_extra_headers_not_null;