CREATE TABLE "invite_event_dept_quotas" (
	"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
	"tenant_id" uuid NOT NULL,
	"event_id" uuid NOT NULL,
	"department_id" uuid NOT NULL,
	"quota" integer DEFAULT 0 NOT NULL,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "invite_events" ADD COLUMN "invite_deadline" date;--> statement-breakpoint
ALTER TABLE "invite_event_dept_quotas" ADD CONSTRAINT "invite_event_dept_quotas_event_id_invite_events_id_fk" FOREIGN KEY ("event_id") REFERENCES "public"."invite_events"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
CREATE UNIQUE INDEX "invite_event_dept_quotas_uniq" ON "invite_event_dept_quotas" USING btree ("event_id","department_id");