CREATE TABLE lists (
    did TEXT NOT NULL,
    rkey TEXT NOT NULL,
    uri TEXT NOT NULL UNIQUE,
    cid TEXT NOT NULL,
    name TEXT NOT NULL,
    description TEXT,
    purpose TEXT,
    created_at INTEGER NOT NULL,
    indexed_at INTEGER NOT NULL,
    record_json TEXT NOT NULL,
    PRIMARY KEY (did, rkey)
);

CREATE INDEX idx_lists_did ON lists(did, created_at DESC);