6 lines · 337 B
-- The platform-wide daily AI spend ceiling sums one meter's usage across every account for a day.
CREATE INDEX usage_days_meter_day ON usage_days (meter, day);

-- When the current subscription entered past_due (NULL otherwise); the server-side grace cap counts from it.
ALTER TABLE billing_customers ADD COLUMN past_due_since INTEGER;