1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

-- rss-kakapo: the blocklist and the allowlist, edited with
-- `rss-kakapo block|allow`.
--
-- Entries are stored normalised (see logic.NormaliseFeedUrl and
-- logic.NormaliseMoniker), so that a lookup is an exact match.
--
--   blocked_feeds.url: a feed whose site opted out; lower case, no scheme.
--   allowed_requesters.moniker: who may request feeds when restrict_requests
--     is on; user@host, lower case, no leading @.
CREATE TABLE blocked_feeds
(
    url      TEXT PRIMARY KEY,
    added_at DATETIME NOT NULL
);

CREATE TABLE allowed_requesters
(
    moniker  TEXT PRIMARY KEY,
    added_at DATETIME NOT NULL
);