seiso.moe
1-- Per-DID database schema
2
3CREATE TABLE IF NOT EXISTS records (
4 rkey TEXT PRIMARY KEY,
5 domain TEXT NOT NULL,
6 record_type TEXT NOT NULL,
7 data TEXT NOT NULL, -- JSON-encoded full DnsRecord (domain + ttl + record)
8 created_at INTEGER NOT NULL,
9 updated_at INTEGER NOT NULL
10);
11
12CREATE TABLE IF NOT EXISTS zones (
13 rkey TEXT PRIMARY KEY,
14 domain TEXT NOT NULL UNIQUE,
15 created_at INTEGER NOT NULL
16);
17
18CREATE INDEX IF NOT EXISTS idx_records_domain
19 ON records(domain);
20
21CREATE INDEX IF NOT EXISTS idx_records_domain_type
22 ON records(domain, record_type);