-- Migration 0002: Add admin subscription warning timestamp fields to users table
-- Applied: 2026-04-24
-- Purpose: Track per-stage throttle timestamps for admin subscription reminders (Task #119)

ALTER TABLE "users" ADD COLUMN IF NOT EXISTS "admin_warning_7days_at" timestamp;
ALTER TABLE "users" ADD COLUMN IF NOT EXISTS "admin_warning_day_zero_at" timestamp;
ALTER TABLE "users" ADD COLUMN IF NOT EXISTS "admin_warning_1day_at" timestamp;
ALTER TABLE "users" ADD COLUMN IF NOT EXISTS "admin_warning_3days_after_at" timestamp;