[AppDB] Fix Bug links

[Tony Lambregts]

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

[Chris Morgan]

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