Fix showing of newly created rounds again.

[ccbs] / sql / ccbs.sql

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 19eeb0e98ae55e5d70a941f8327fd0a2409e6640..d7d461fa205aa7eb8a54e97f5b9c912721132932 100644 (file)
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -152,3 +152,7 @@ CREATE TABLE scores (
        FOREIGN KEY (tournament, round, parallel, player) REFERENCES roundparticipation (tournament, round, parallel, player),
        PRIMARY KEY (tournament, round, parallel, player, songnumber)
 );
+
+CREATE TABLE randomsongsused (
+       song INTEGER NOT NULL PRIMARY KEY REFERENCES songs
+);