-- EventMedia — join table za galeriju događaja (paritet sa RealEstate,
-- CarListing, StoreProduct). sortOrder kontroliše redosled fotografija
-- u admin Gore/Dole kontrolama i public detail prikazu.

CREATE TABLE "EventMedia" (
  "id"        TEXT NOT NULL,
  "eventId"   TEXT NOT NULL,
  "mediaId"   TEXT NOT NULL,
  "sortOrder" INTEGER NOT NULL DEFAULT 0,
  CONSTRAINT "EventMedia_pkey" PRIMARY KEY ("id")
);

ALTER TABLE "EventMedia"
  ADD CONSTRAINT "EventMedia_eventId_fkey"
  FOREIGN KEY ("eventId") REFERENCES "Event"("id")
  ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE "EventMedia"
  ADD CONSTRAINT "EventMedia_mediaId_fkey"
  FOREIGN KEY ("mediaId") REFERENCES "Media"("id")
  ON DELETE CASCADE ON UPDATE CASCADE;

CREATE UNIQUE INDEX "EventMedia_eventId_mediaId_key"
  ON "EventMedia"("eventId", "mediaId");

CREATE INDEX "EventMedia_eventId_idx"
  ON "EventMedia"("eventId");