Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
448 B · 13 lines
1234567891011121314-- Merge network_lexicons metadata into the lexicons table.ALTER TABLE lexicons ADD COLUMN source TEXT NOT NULL DEFAULT 'manual';ALTER TABLE lexicons ADD COLUMN authority_did TEXT;ALTER TABLE lexicons ADD COLUMN last_fetched_at TIMESTAMPTZ;
UPDATE lexiconsSET source = 'network', authority_did = nl.authority_did, last_fetched_at = nl.last_fetched_atFROM network_lexicons nlWHERE lexicons.id = nl.nsid;
DROP TABLE network_lexicons;