Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/156.sql
Show All 38 Lines | alter table object_metadata | ||||
drop column origin_id; | drop column origin_id; | ||||
alter table object_metadata | alter table object_metadata | ||||
rename column origin_url to id; | rename column origin_url to id; | ||||
comment on column object_metadata.id is 'the SWHID or origin URL for which the metadata was found'; | comment on column object_metadata.id is 'the SWHID or origin URL for which the metadata was found'; | ||||
create unique index object_metadata_content_authority_date_fetcher | create unique index object_metadata_content_authority_date_fetcher | ||||
on object_metadata(id, authority_id, discovery_date, fetcher_id); | on object_metadata(id, authority_id, discovery_date, fetcher_id); | ||||
-- Add context columns | |||||
alter table object_metadata | |||||
add column origin text; | |||||
alter table object_metadata | |||||
add column visit bigint; | |||||
alter table object_metadata | |||||
add column snapshot swhid; | |||||
alter table object_metadata | |||||
add column release swhid; | |||||
alter table object_metadata | |||||
add column revision swhid; | |||||
alter table object_metadata | |||||
add column path bytea; | |||||
alter table object_metadata | |||||
add column directory swhid; |