On Saturday 08 July 2006 4:27 pm, Tony Lambregts wrote: > This patch is meant to start a discussion more than anything else. We > currently have no way of sorting test results in a reasonable order. If we > sort by testedRating the order is not what we want. IE: Bronze, Garbage, > Gold, Platinum and Silver. > > It might be better in the long run to replace testedRating in testResults > with ratingId. That however is a fairly big project. > > (You need to run the table/testRating.sql script in mysql to test this > patch out.) > > Change Log: Sort test results by rating in distributions > > Files Changed: include/distributions.php > > New File: tables/testRating.sql
I think this change makes sense. It allows us to get away with not having to monkey with the existing table although I wonder if we changed to using an enum and put the highest rating first in the enum, would that also work? That might be nearly as easy to do. Chris
