At the moment we don't have all checks covered. It would be nice to have various other sorts of checks. The following come to mind. 1. Uniqueness checks. Currently I can see a uniqueness check for keywords but nothing else. Is it because these are enforced by MySQL and referentials aren't? If so we can probably forget about a lot of this at least until we have database independence. At least versions doesn't appear to have a primary key specified. 2. Check that 1 <= votes <= (votes allowed for this product for this bug). 3. MIME type valid. 4. Using the referential information, check the types of primary and foreign key are identical. 5. Compound referential checks, for milestones, components and versions are present, but should probably be moved to being configured by data, like CrossCheck. I don't think at least products/defaultmilestone is currently checked either. 6. Milestone URL is a valid URL.
We also should have existence checks - each product should have at least one component, each product should have at least one milestone, etc.
Moving to new Bugzilla product ...
Reassigning all of my "future" targetted bugs to indicate that I'm not presently working on them, and someone else could feel free to work on them.
Reassigning all of my "future" targetted bugs to indicate that I'm not presently working on them, and someone else could feel free to work on them. (sorry for the spam if you got this twice, it didn't take right the first time)
I really wish this was split into multiple bugs and then this one was closed.
I'm not even sure this is needed at all.
WONTFIX per comment 6. File one bug per sanitycheck ID with use case and rationale. Gerv