-- Sales CRM napredne mogućnosti: AI scoring, Win/Loss razlozi.

-- Enum za razloge gubitka
CREATE TYPE "LossReason" AS ENUM ('PRICE', 'COMPETITION', 'TIMING', 'UNRESPONSIVE', 'NOT_FIT', 'OTHER');

-- Conversation: loss razlozi + AI score
ALTER TABLE "Conversation" ADD COLUMN "lossReason" "LossReason";
ALTER TABLE "Conversation" ADD COLUMN "lossNote" TEXT;
ALTER TABLE "Conversation" ADD COLUMN "aiScore" INTEGER;
ALTER TABLE "Conversation" ADD COLUMN "aiScoreReason" TEXT;
ALTER TABLE "Conversation" ADD COLUMN "aiScoreAt" TIMESTAMP(3);

CREATE INDEX "Conversation_aiScore_idx" ON "Conversation"("aiScore");
CREATE INDEX "Conversation_lossReason_idx" ON "Conversation"("lossReason");