0035_storage_enforcement.sql 561 B

12345678
  1. -- 0035_storage_enforcement — Sprint 4 Phase 4 (the deferred "block" lever).
  2. --
  3. -- Per-project storage enforcement mode. Default 'flag' = current behaviour
  4. -- (surface over-limit in the admin dashboard, never block a customer).
  5. -- 'block' = reject new writes (createTable / insertRow) while the project is
  6. -- over its effective cap. Off by default; an admin opts a specific project in.
  7. -- Lands on the control DB (Postgres). Additive ADD COLUMN with default.
  8. ALTER TABLE "projects" ADD COLUMN IF NOT EXISTS "storage_enforcement" text DEFAULT 'flag' NOT NULL;