QQQ offers a fixed list (a possible-value source of an enum) in a form but
accepts any value in a write: through the API a project could be saved with
a status that is not on the list. Found by a live check in a host
application.
- CmsValueListCheck: a pre-insert and pre-update customizer on every table
with a value-list field; a record with another value gets an error and is
not written, and an update is checked only for the fields it names.
- Changelog: check constraints on the same columns (as kof22 has for
media_type and blog_post_version; the project status check is new), and
kof22's checks on media_type.max_file_size_mb and the focal point of a
project's image. They are part of the not yet released
1.0.0-constraints-<feature> changesets.
- Reference DDL regenerated.
Tests: 37, Checkstyle 0, guardrails and coverage checks pass.
Co-Authored-By: Claude Fable 5.2 <noreply@anthropic.com>