migrations/index/001_init.sql at main

auth dns over atproto

onis / migrations / index / 001_init.sql

at main 13 lines 359 B view raw

wrap content

 1-- Shared reverse index schema
 2
 3CREATE TABLE IF NOT EXISTS zone_index (
 4    zone            TEXT NOT NULL,
 5    did             TEXT NOT NULL,
 6    verified        INTEGER NOT NULL DEFAULT 0,
 7    first_seen      INTEGER NOT NULL,
 8    last_verified   INTEGER,
 9    PRIMARY KEY (zone, did)
10);
11
12CREATE INDEX IF NOT EXISTS idx_zone_index_did
13    ON zone_index(did);