Files
backend/database/migrations/074_backfill_annual_renewal_from_created.sql
Alireza HassaniandCursor 4db9c7709d Default annual renewal to business created date.
Backfill null renewals from created_at and use now when create omits the date.

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-08-26 10:33:26 +03:30

6 lines
150 B
SQL

-- Default annual renewal to business created date when unset.
UPDATE businesses
SET annual_renewal_at = created_at
WHERE annual_renewal_at IS NULL;