Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/sql/30-schema.sql
Show First 20 Lines • Show All 500 Lines • ▼ Show 20 Lines | ||||||||
-- The ExtID (typ. original VCS) <-> swhid relation table | -- The ExtID (typ. original VCS) <-> swhid relation table | |||||||
create table extid | create table extid | |||||||
( | ( | |||||||
extid_type text not null, | extid_type text not null, | |||||||
extid bytea not null, | extid bytea not null, | |||||||
target_type object_type not null, | target_type object_type not null, | |||||||
target sha1_git not null, | target sha1_git not null, | |||||||
extid_version bigint not null default 0 | extid_version bigint not null default 0, | |||||||
payload_type text, | ||||||||
payload sha1_git | ||||||||
); | ); | |||||||
comment on table extid is 'Correspondance SWH object (SWHID) <-> original revision id (vcs id)'; | comment on table extid is 'Correspondance SWH object (SWHID) <-> original revision id (vcs id)'; | |||||||
comment on column extid.extid_type is 'ExtID type'; | comment on column extid.extid_type is 'ExtID type'; | |||||||
comment on column extid.extid is 'Intrinsic identifier of the object (e.g. hg revision)'; | comment on column extid.extid is 'Intrinsic identifier of the object (e.g. hg revision)'; | |||||||
comment on column extid.target_type is 'Type of SWHID of the referenced SWH object'; | comment on column extid.target_type is 'Type of SWHID of the referenced SWH object'; | |||||||
comment on column extid.target is 'Value (hash) of SWHID of the refenced SWH object'; | comment on column extid.target is 'Value (hash) of SWHID of the refenced SWH object'; | |||||||
comment on column extid.extid_version is 'Version of the extid type for the given original object'; | comment on column extid.extid_version is 'Version of the extid type for the given original object'; | |||||||
comment on column extid.payload_type is 'The type of the payload object'; | ||||||||
vlorentzUnsubmitted Not Done Inline Actions
vlorentz: | ||||||||
Not Done Inline Actionsand this vlorentz: and this | ||||||||
comment on column extid.payload is 'Content object ID of data associated with the ExtID'; |