- Add `usage` enum to distinguish between serverless and pages domains
- Replace unique index on `domain` with unique index on
  `[domain, wildcard]` so that the wildcard and non-wildcard variants of
  a domain can coexist
- Rename `domain_type` to `scope` to be more semantic