moth11.net
backend for xcvr appview
1CREATE TABLE images (
2 uri TEXT PRIMARY KEY,
3 did TEXT NOT NULL,
4 signet_uri TEXT NOT NULL,
5 FOREIGN KEY (signet_uri) REFERENCES signets(uri) ON DELETE CASCADE,
6 blob_cid TEXT,
7 blob_mime TEXT,
8 alt TEXT,
9 height INTEGER,
10 width INTEGER,
11 nick TEXT NOT NULL,
12 color INTEGER CHECK (color BETWEEN 0 AND 16777215),
13 cid TEXT NOT NULL,
14 posted_at TIMESTAMPTZ NOT NULL DEFAULT now(),
15 indexed_at TIMESTAMPTZ NOT NULL DEFAULT now()
16);
17
18CREATE INDEX ON images (signet_uri);