Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Files
F9344411
131.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
401 B
Subscribers
None
131.sql
View Options
-- SWH DB schema upgrade
-- from_version: 130
-- to_version: 131
-- description: Use sha1 instead of bigint as FK from origin_visit to snapshot (part 1: add new column)
insert
into
dbversion
(
version
,
release
,
description
)
values
(
131
,
now
(),
'Work In Progress'
);
alter
table
origin_visit
add
column
snapshot
sha1_git
;
comment
on
column
origin_visit
.
snapshot
is
'Origin snapshot at visit time'
;
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Fri, Jul 4, 2:25 PM (2 d, 2 h ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3290048
Attached To
rDSTO Storage manager
Event Timeline
Log In to Comment