malpercio.dev
WIP! A BB-style forum, on the ATmosphere!
We're still working... we'll be back soon when we have something to show off!
node
typescript
hono
htmx
atproto
1CREATE TABLE "roles" (
2 "id" bigserial PRIMARY KEY NOT NULL,
3 "did" text NOT NULL,
4 "rkey" text NOT NULL,
5 "cid" text NOT NULL,
6 "name" text NOT NULL,
7 "description" text,
8 "permissions" text[] DEFAULT '{}'::text[] NOT NULL,
9 "priority" integer NOT NULL,
10 "created_at" timestamp with time zone NOT NULL,
11 "indexed_at" timestamp with time zone NOT NULL
12);
13--> statement-breakpoint
14CREATE UNIQUE INDEX "roles_did_rkey_idx" ON "roles" USING btree ("did","rkey");--> statement-breakpoint
15CREATE INDEX "roles_did_idx" ON "roles" USING btree ("did");--> statement-breakpoint
16CREATE INDEX "roles_did_name_idx" ON "roles" USING btree ("did","name");