diff --git a/sql/upgrades/161.sql b/sql/upgrades/161.sql index cfffc6ed..c2c95c07 100644 --- a/sql/upgrades/161.sql +++ b/sql/upgrades/161.sql @@ -1,17 +1,17 @@ -- 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[][] + set extra_headers = ARRAY[]::bytea[][] where extra_headers is null; alter table revision alter column extra_headers set not null;