mirror of
https://github.com/fabro-sh/fabro.git
synced 2026-09-11 22:53:00 +00:00
7 lines
187 B
SQL
7 lines
187 B
SQL
CREATE TABLE blobs (
|
|
hash TEXT PRIMARY KEY NOT NULL,
|
|
data BLOB NOT NULL,
|
|
CHECK (length(hash) = 64),
|
|
CHECK (hash = lower(hash)),
|
|
CHECK (hash NOT GLOB '*[^0-9a-f]*')
|
|
);
|