CREATE TABLE IF NOT EXISTS "unifi_controllers" (
  "id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
  "org_id" text NOT NULL,
  "site_id" uuid,
  "base_url" text NOT NULL,
  "role" text NOT NULL,
  "region" text,
  "created_at" timestamp DEFAULT now() NOT NULL,
  "updated_at" timestamp DEFAULT now() NOT NULL
);

ALTER TABLE "unifi_controllers" ADD CONSTRAINT "unifi_controllers_site_id_fk" FOREIGN KEY ("site_id") REFERENCES "public"."sites"("id");