Pull in changes from --baby.

[ccbs] / sql / ccbs.sql

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 22c99bc55b8994de07692621f33f23fcbcccbe52..756f54c4e5c35f09eb092e7b29ee7908a396e303 100644 (file)
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -68,6 +68,8 @@ CREATE TABLE songratings (
 );
 CREATE INDEX songratings_feetrating ON songratings ( feetrating );
 
 );
 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,
 CREATE TABLE players (
        player SERIAL PRIMARY KEY,
        nick VARCHAR NOT NULL,