Something went wrong. Try again.
A community based topic aggregation platform built on atproto
Something went wrong. Try again.
692 B · 13 lines
SQL
at main
1234567891011121314-- +goose Up-- Optional self-asserted origin instance for a community (hostname only, e.g.-- lemmy.world). Native communities carry their own instance domain; bridged-- communities (Tidepool) carry the platform they were bridged FROM, which the-- DNS handle (comicstrips.lemmy-world.tdpl.io) cannot express losslessly.-- Clients render !name@origin. The community consumer validates the value-- against BridgeTrust / the verified handle before it lands here; NULL means-- the record carried none (or it was dropped) and readers fall back to the-- handle-derived display form.ALTER TABLE communities ADD COLUMN origin TEXT;
-- +goose DownALTER TABLE communities DROP COLUMN origin;