Details
Minor Description
The comment data for Roller tracks comments in up to 4 states and currently does so by using a combination of 3 boolean attributes (approved, pending, spam). This is a confusing way of tracking the state of a comment and is also less performant for database queries because the queries contain more criteria and it becomes harder to index the table.
A simple suggested improvement is to add a new 'status' column to the roller_comment table (similar to the one for weblogentry) and use that as a way to track the comment status. this is both easier to understand and more performant for queries against the comment table.