Set default value for CalendarCache.updatedAt

zomars · zomars · commit 5fd11f9faa79 · 2025-07-18T13:11:54.000-07:00
Added a default value of NOW() for the updatedAt column in the CalendarCache table to ensure existing and future rows have a valid timestamp. Updated the Prisma schema to reflect this change and provide compatibility for legacy data and raw inserts.
diff --git a/packages/prisma/migrations/20250715160635_add_calendar_cache_updated_at/migration.sql b/packages/prisma/migrations/20250715160635_add_calendar_cache_updated_at/migration.sql
@@ -5,4 +5,5 @@
 
 */
 -- AlterTable
-ALTER TABLE "CalendarCache" ADD COLUMN     "updatedAt" TIMESTAMP(3) NOT NULL;
+-- Add the column with a default value to safely handle existing rows
+ALTER TABLE "CalendarCache" ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL DEFAULT NOW();
diff --git a/packages/prisma/schema.prisma b/packages/prisma/schema.prisma
@@ -1715,7 +1715,8 @@ model CalendarCache {
   key          String
   value        Json
   expiresAt    DateTime
-  updatedAt    DateTime    @updatedAt
+  // Provide an initial value for legacy rows and future raw inserts
+  updatedAt    DateTime    @default(now()) @updatedAt
   credentialId Int
   userId       Int?
   credential   Credential? @relation(fields: [credentialId], references: [id], onDelete: Cascade)
