Ok, removing the trigger makes it easier to keep things sane. How do you intend to keep the other values up-to-date? Maybe it makes sense to rename them, so that it's clear that they are caches only, and might not be correct? Unless you find a way of making sure they are up to date, of course. Also, for the bug values, will it include private bugs as well?
Ok, removing the trigger makes it easier to keep things sane. How do you intend to keep the other values up-to-date? Maybe it makes sense to rename them, so that it's clear that they are caches only, and might not be correct? Unless you find a way of making sure they are up to date, of course. Also, for the bug values, will it include private bugs as well?
The comments should be added to comments.sql.