| CREATE TABLE IF NOT EXISTS "Stream" ( | |
| "id" uuid DEFAULT gen_random_uuid() NOT NULL, | |
| "chatId" uuid NOT NULL, | |
| "createdAt" timestamp NOT NULL, | |
| CONSTRAINT "Stream_id_pk" PRIMARY KEY("id") | |
| ); | |
| --> statement-breakpoint | |
| DO $$ BEGIN | |
| ALTER TABLE "Stream" ADD CONSTRAINT "Stream_chatId_Chat_id_fk" FOREIGN KEY ("chatId") REFERENCES "public"."Chat"("id") ON DELETE no action ON UPDATE no action; | |
| EXCEPTION | |
| WHEN duplicate_object THEN null; | |
| END $$; | |