-- Proširuje automobilsku ponudu bez menjanja ili brisanja postojećih oglasa.
ALTER TABLE "CarListing"
ADD COLUMN "variant" TEXT,
ADD COLUMN "bodyType" TEXT,
ADD COLUMN "condition" TEXT,
ADD COLUMN "powerKw" INTEGER,
ADD COLUMN "powerHp" INTEGER,
ADD COLUMN "engineDisplacementCc" INTEGER,
ADD COLUMN "engineCode" TEXT,
ADD COLUMN "cylinders" INTEGER,
ADD COLUMN "drivetrain" TEXT,
ADD COLUMN "doors" INTEGER,
ADD COLUMN "seats" INTEGER,
ADD COLUMN "color" TEXT,
ADD COLUMN "metallicColor" BOOLEAN NOT NULL DEFAULT false,
ADD COLUMN "emissionClass" TEXT,
ADD COLUMN "vin" TEXT,
ADD COLUMN "registeredUntil" TIMESTAMP(3),
ADD COLUMN "ownersCount" INTEGER,
ADD COLUMN "serviceHistory" BOOLEAN NOT NULL DEFAULT false,
ADD COLUMN "equipment" TEXT[] NOT NULL DEFAULT ARRAY[]::TEXT[];

CREATE INDEX "CarListing_bodyType_status_idx" ON "CarListing"("bodyType", "status");
CREATE INDEX "CarListing_condition_status_idx" ON "CarListing"("condition", "status");
CREATE INDEX "CarListing_drivetrain_status_idx" ON "CarListing"("drivetrain", "status");
CREATE INDEX "CarListing_vin_idx" ON "CarListing"("vin");