alter table snapshot add column signatures text[];
update snapshot set signatures = '{"prov"}' where signed = true;
---- create above / drop below ----
alter table snapshot drop column signatures;