Database Migration

Create migration scripts for Neon PostgreSQL following project conventions.

Instructions

1. Read current schema:

   • prisma/schema.sql for table definitions
   • src/lib/db.ts for TypeScript interfaces

2. Create migration script in scripts/ directory:

   • Filename: <action>-<description>.mjs (e.g., add-views-column.mjs)
   • Use existing pattern from scripts/add-summary-column.mjs

3. Migration script template: