gui.do
Barazo AppView backend
barazo.forum
1-- Align with lexicon v0.3.0: content union, publishedAt, site field
2-- Topics: rename created_at → published_at, drop content_format, add site
3ALTER TABLE "topics" RENAME COLUMN "created_at" TO "published_at";--> statement-breakpoint
4ALTER TABLE "topics" DROP COLUMN IF EXISTS "content_format";--> statement-breakpoint
5ALTER TABLE "topics" ADD COLUMN "site" text;--> statement-breakpoint
6DROP INDEX IF EXISTS "topics_created_at_idx";--> statement-breakpoint
7CREATE INDEX "topics_published_at_idx" ON "topics" USING btree ("published_at");--> statement-breakpoint
8-- Replies: drop content_format only (replies keep created_at)
9ALTER TABLE "replies" DROP COLUMN IF EXISTS "content_format";