Files
CapaKraken/packages/db/prisma/migrations/20260330_vacation_deduction_snapshots.sql

9 lines
330 B
SQL

ALTER TABLE "vacations"
ADD COLUMN "deductedDays" DOUBLE PRECISION,
ADD COLUMN "holidayCountryCode" TEXT,
ADD COLUMN "holidayCountryName" TEXT,
ADD COLUMN "holidayFederalState" TEXT,
ADD COLUMN "holidayMetroCityName" TEXT,
ADD COLUMN "holidayCalendarDates" JSONB,
ADD COLUMN "holidayLegacyPublicHolidayDates" JSONB;