Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/170.sql
- This file was copied from sql/upgrades/169.sql.
-- SWH DB schema upgrade | -- SWH DB schema upgrade | ||||
-- from_version: 168 | -- from_version: 169 | ||||
-- to_version: 169 | -- to_version: 170 | ||||
-- description: add raw_extrinsic_metadata.id | -- description: add raw_extrinsic_metadata.id | ||||
insert into dbversion(version, release, description) | insert into dbversion(version, release, description) | ||||
values(169, now(), 'Work In Progress'); | values(170, now(), 'Work In Progress'); | ||||
-- 1. add the 'id' column | -- 1. add the 'id' column | ||||
alter table raw_extrinsic_metadata | alter table raw_extrinsic_metadata | ||||
add column id sha1_git; | add column id sha1_git; | ||||
-- 2. restart swh-storage, so that it starts writing the id (but does not read it) | -- 2. restart swh-storage, so that it starts writing the id (but does not read it) | ||||
Show All 11 Lines |