airi/apps/server/drizzle/0004_bouncy_devos.sql
2026-03-28 02:25:44 +08:00

11 lines
No EOL
441 B
SQL

CREATE TABLE "flux_audit_log" (
"id" text PRIMARY KEY NOT NULL,
"user_id" text NOT NULL,
"type" text NOT NULL,
"amount" integer NOT NULL,
"description" text NOT NULL,
"metadata" jsonb,
"created_at" timestamp DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "flux_audit_log" ADD CONSTRAINT "flux_audit_log_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;