ALTER TABLE "User"
ADD COLUMN IF NOT EXISTS "coins" INTEGER NOT NULL DEFAULT 0;

ALTER TABLE "User"
ADD COLUMN IF NOT EXISTS "freeCoinsClaimed" BOOLEAN NOT NULL DEFAULT false;

ALTER TABLE "User"
ADD COLUMN IF NOT EXISTS "isActive" BOOLEAN NOT NULL DEFAULT true;

CREATE TABLE IF NOT EXISTS "CoinSettings" (
    "id" SERIAL NOT NULL,
    "action" TEXT NOT NULL,
    "cost" INTEGER NOT NULL,
    "updatedAt" TIMESTAMP(3) NOT NULL,
    CONSTRAINT "CoinSettings_pkey" PRIMARY KEY ("id")
);

CREATE UNIQUE INDEX IF NOT EXISTS "CoinSettings_action_key" ON "CoinSettings"("action");
