malpercio.dev / atbb
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
fork atom
atbb / apps / appview / drizzle / 0011_first_apocalypse.sql
at main 7 lines 389 B view raw
Malpercio feat: add SQLite as alternative database backend (#64)
f33475f9
1CREATE TABLE "role_permissions" ( 2 "role_id" bigint NOT NULL, 3 "permission" text NOT NULL, 4 CONSTRAINT "role_permissions_role_id_permission_pk" PRIMARY KEY("role_id","permission") 5); 6--> statement-breakpoint 7ALTER TABLE "role_permissions" ADD CONSTRAINT "role_permissions_role_id_roles_id_fk" FOREIGN KEY ("role_id") REFERENCES "public"."roles"("id") ON DELETE cascade ON UPDATE no action;