Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Files
F9343196
077.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
1 KB
Subscribers
None
077.sql
View Options
-- SWH DB schema upgrade
-- from_version: 76
-- to_version: 77
-- description: Add content provenance information cache tables
insert
into
dbversion
(
version
,
release
,
description
)
values
(
77
,
now
(),
'Work In Progress'
);
CREATE
TABLE
cache_content_revision
(
content
sha1_git
NOT
NULL
,
revision
sha1_git
NOT
NULL
,
"path"
unix_path
NOT
NULL
);
CREATE
TABLE
cache_revision_origin
(
revision
sha1_git
NOT
NULL
,
origin
bigint
NOT
NULL
,
visit
bigint
NOT
NULL
);
ALTER
TABLE
cache_content_revision
ADD
CONSTRAINT
cache_content_revision_pkey
PRIMARY
KEY
(
content
,
revision
,
path
);
ALTER
TABLE
cache_revision_origin
ADD
CONSTRAINT
cache_revision_origin_pkey
PRIMARY
KEY
(
revision
,
origin
,
visit
);
ALTER
TABLE
cache_content_revision
ADD
CONSTRAINT
cache_content_revision_content_fkey
FOREIGN
KEY
(
content
)
REFERENCES
content
(
sha1_git
);
ALTER
TABLE
cache_content_revision
ADD
CONSTRAINT
cache_content_revision_revision_fkey
FOREIGN
KEY
(
revision
)
REFERENCES
revision
(
id
);
ALTER
TABLE
cache_revision_origin
ADD
CONSTRAINT
cache_revision_origin_origin_fkey
FOREIGN
KEY
(
origin
,
visit
)
REFERENCES
origin_visit
(
origin
,
visit
);
ALTER
TABLE
cache_revision_origin
ADD
CONSTRAINT
cache_revision_origin_revision_fkey
FOREIGN
KEY
(
revision
)
REFERENCES
revision
(
id
);
CREATE
INDEX
cache_content_revision_content_idx
ON
cache_content_revision
USING
btree
(
content
);
CREATE
INDEX
cache_content_revision_revision_idx
ON
cache_content_revision
USING
btree
(
revision
);
CREATE
INDEX
cache_revision_origin_revision_idx
ON
cache_revision_origin
USING
btree
(
revision
);
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Fri, Jul 4, 1:21 PM (6 d, 4 h ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3282300
Attached To
rDSTO Storage manager
Event Timeline
Log In to Comment