Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P230
(An Untitled Masterwork)
Active
Public
Actions
Authored by
seirl
on Feb 28 2018, 7:18 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Subscribers
None
CREATE
DOMAIN
sha1
AS
bytea
CHECK
(
length
(
value
)
=
20
);
CREATE
TABLE
content
(
id
sha1
PRIMARY
KEY
,
-- SHA1 checksum
length
integer
);
CREATE
TABLE
chunk
(
id
sha1
PRIMARY
KEY
,
-- SHA1 checksum
length
integer
);
CREATE
TYPE
chunking_hash
as
enum
(
'rabin'
,
'buzhash'
);
CREATE
TABLE
chunking_method
(
id
serial
PRIMARY
KEY
,
hash
chunking_hash
,
min_block_size
integer
,
average_block_size
integer
,
hash_window_size
integer
,
);
CREATE
TABLE
chunked_content
(
content_id
sha1
REFERENCES
content
(
id
),
chunk_id
sha1
REFERENCES
chunk
(
id
),
method_id
integer
REFERENCES
chunking_method
(
id
),
position
integer
);
CREATE
INDEX
ON
chunked_content
(
content_id
);
CREATE
INDEX
ON
chunked_content
(
method_id
);
CREATE
UNIQUE
INDEX
ON
chunked_content
(
content_id
,
chunk_id
,
method_id
,
position
);
Event Timeline
seirl
created this paste.
Feb 28 2018, 7:18 PM
2018-02-28 19:18:42 (UTC+1)
Log In to Comment