mirror of
https://github.com/fabro-sh/fabro.git
synced 2026-10-29 06:36:51 +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]*')
|
|
);
|