When ranking submissions, give a background color to submissions that have been ranked.
BEGIN;
INSERT INTO Track(id, name) VALUES(1, "Default Track");
INSERT INTO Judge(id, name) VALUES(1, "Default Judge");
INSERT INTO Prize(id, name) VALUES(1, "Default Prize");
INSERT INTO Submission(id, name, trackId, location, active) VALUES(1, "Hack 1", 1, 1, 1);
INSERT INTO Submission(id, name, trackId, location, active) VALUES(2, "Hack 2", 1, 2, 1);
INSERT INTO Submission(id, name, trackId, location, active) VALUES(3, "Hack 3", 1, 3, 1);
INSERT INTO Submission(id, name, trackId, location, active) VALUES(4, "Hack 4", 1, 4, 1);
INSERT INTO Submission(id, name, trackId, location, active) VALUES(5, "Hack 5", 1, 5, 1);
INSERT INTO Assignment(id, judgeId, priority, type, active) VALUES(1, 1, 1, 2, 1);
INSERT INTO RankingAssignment(id, assignmentId, prizeId) VALUES(1, 1, 1);
INSERT INTO Ranking(rankingAssignmentId, submissionId) VALUES(1, 1);
INSERT INTO Ranking(rankingAssignmentId, submissionId) VALUES(1, 2);
INSERT INTO Ranking(rankingAssignmentId, submissionId) VALUES(1, 3);
INSERT INTO Ranking(rankingAssignmentId, submissionId) VALUES(1, 4);
INSERT INTO Ranking(rankingAssignmentId, submissionId) VALUES(1, 5);
UPDATE Status SET phase=2;
COMMIT;