SQL: Converted changes.type to an ENUM

This is a very important column in a very important table, I hope I
didn't forget to update a piece of code somewhere...

1 files changed, 2 insertions, 3 deletions

diff --git a/lib/VNDB/Util/CommonHTML.pm b/lib/VNDB/Util/CommonHTML.pm
index 7e98159a..90c9db13 100644
--- a/lib/VNDB/Util/CommonHTML.pm
+++ b/lib/VNDB/Util/CommonHTML.pm
@@ -505,12 +505,11 @@ sub htmlHistory {
     ],
     row      => sub {
       my($s, $n, $i) = @_;
-      my $tc = [qw|v r p|]->[$i->{type}];
-      my $revurl = "/$tc$i->{iid}.$i->{rev}";
+      my $revurl = "/$i->{type}$i->{iid}.$i->{rev}";
 
       Tr $n % 2 ? ( class => 'odd' ) : ();
        td class => 'tc1_1';
-        a href => $revurl, "$tc$i->{iid}";
+        a href => $revurl, "$i->{type}$i->{iid}";
        end;
        td class => 'tc1_2';
         a href => $revurl, ".$i->{rev}";