Page MenuHomeSoftware Heritage

167.sql
No OneTemporary

-- 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;

File Metadata

Mime Type
text/plain
Expires
Thu, Jul 3, 11:44 AM (6 d, 3 h ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3348902

Event Timeline