diff --git a/sql/schema.sql b/sql/schema.sql index 625afb0..677dffa 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -20,7 +20,7 @@ Criterion_Type VARCHAR PRIMARY KEY ); -INSERT INTO Criterion_Type VALUES ('Normal'),('Special'); +INSERT INTO Criterion_Type VALUES ('Normal'),('Special'),('Penalty'); CREATE TABLE Criterion ( Criterion VARCHAR PRIMARY KEY, @@ -110,7 +110,7 @@ SELECT DISTINCT Submission_id, 0 FROM Result ) - GROUP BY Submission_id + GROUP BY Submission_id; CREATE OR REPLACE VIEW Weighted_Penalty AS SELECT Submission_ID,