X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;fp=sql%2Fccbs.sql;h=756f54c4e5c35f09eb092e7b29ee7908a396e303;hp=22c99bc55b8994de07692621f33f23fcbcccbe52;hb=416d3d469d9ce4c15a860f61e24aee79da12402d;hpb=bcb73c11262a6de77c9af117390127797629478b

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 22c99bc..756f54c 100644
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -68,6 +68,8 @@ CREATE TABLE songratings (
 );
 CREATE INDEX songratings_feetrating ON songratings ( feetrating );
 
+CREATE VIEW max_single_feetrating AS SELECT machine,song,MAX(feetrating) AS feetrating FROM songratings WHERE playmode='single' GROUP BY machine,song;
+
 CREATE TABLE players (
 	player SERIAL PRIMARY KEY,
 	nick VARCHAR NOT NULL,