-- Premium magazin polja — TL;DR, interne napomene, izvori (citation),
-- featured marker, autor titula i slika. Sva polja opciona, ne lome
-- postojeće članke.

ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "tldr" TEXT;
ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "internalNotes" TEXT;
ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "sourceUrls" TEXT[] DEFAULT ARRAY[]::TEXT[];
ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "isFeatured" BOOLEAN NOT NULL DEFAULT false;
ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "authorTitle" TEXT;
ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "authorImageUrl" TEXT;
ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "wordGoal" INTEGER NOT NULL DEFAULT 0;
ALTER TABLE "MagazineArticle" ADD COLUMN IF NOT EXISTS "reviewStatus" TEXT;

CREATE INDEX IF NOT EXISTS "MagazineArticle_isFeatured_idx" ON "MagazineArticle"("isFeatured");
CREATE INDEX IF NOT EXISTS "MagazineArticle_reviewStatus_idx" ON "MagazineArticle"("reviewStatus");

-- AnalyticsEntityType: dodaj MAGAZINE_ARTICLE da možemo da pratimo view/click
-- analytics i za članke (isti pattern kao za kompanije, evente itd.).
-- ADD VALUE je idempotent ali ne sme da bude u transakciji — Prisma migrate
-- runs each statement standalone.
ALTER TYPE "AnalyticsEntityType" ADD VALUE IF NOT EXISTS 'MAGAZINE_ARTICLE';