X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;h=d7d461fa205aa7eb8a54e97f5b9c912721132932;hp=19eeb0e98ae55e5d70a941f8327fd0a2409e6640;hb=fc928636e25aef2346993efdbccf9badc4f7bcdd;hpb=2d910edbb4c30563120490a2a45a6aa5544672e4

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 19eeb0e..d7d461f 100644
--- 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
+);