Update the DDR Europe parser to add song ordering information. Update the CC SQL...

[ccbs] / sql / cc04 / cc2-04.sql

diff --git a/sql/cc04/cc2-04.sql b/sql/cc04/cc2-04.sql
index acf86a1fc18b7f9d9cbefa606f7190a63f5b8b37..e50ba53022323a57d26f132c5d95f2a6b1637b44 100644 (file)
--- a/sql/cc04/cc2-04.sql
+++ b/sql/cc04/cc2-04.sql
@@ -40,24 +40,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Bush'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    4327);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    4251);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    't',
    5910);
@@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Ylini'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    5476);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    6242);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7977);
@@ -96,24 +102,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Stream'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6224);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    6659);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    7572);
@@ -124,24 +133,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6530);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    6702);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7631);
@@ -152,24 +164,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7561);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7616);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    't',
    6839);
@@ -199,24 +214,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Dabi'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    3973);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    3845);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6484);
@@ -227,24 +245,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Olemann'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    7827);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    6329);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8032);
@@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Smiph'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    7830);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    6336);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    7544);
@@ -283,24 +307,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8058);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    7672);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8167);
@@ -311,24 +338,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8651);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    8426);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    8392);
@@ -358,24 +388,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Raazu'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
    'f',
    5012);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    4014);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    6940);
@@ -386,24 +419,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Draconia'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
    'f',
    5541);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    0);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7524);
@@ -414,24 +450,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Havok'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
    'f',
    4355);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    6284);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    't',
    4399);
@@ -442,24 +481,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
    'f',
    5953);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    8076);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    7735);
@@ -470,24 +512,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
    'f',
    6044);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    8303);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
+   2,
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    't',
    8625);
@@ -517,17 +562,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Raazu'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7286);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7657);
@@ -538,17 +585,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Stream'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7814);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7986);
@@ -559,17 +608,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Olemann'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7747);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    7721);
@@ -580,17 +631,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8215);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8053);
@@ -601,17 +654,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8529);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8570);
@@ -622,17 +677,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8478);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8174);
@@ -643,17 +700,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    7
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8743);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8447);
@@ -664,17 +723,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    8
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8695);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8440);
@@ -685,17 +746,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    9
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8798);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8500);
@@ -725,17 +788,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Stream'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    7698);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    7874);
@@ -746,17 +811,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8241);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8574);
@@ -767,17 +834,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8139);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8403);
@@ -788,17 +857,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8661);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8456);
@@ -809,17 +880,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8272);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8353);
@@ -830,17 +903,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    6
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8783);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8673);
@@ -851,17 +926,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    7
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    'f',
    8633);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8584);
@@ -891,17 +968,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    5706);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8583);
@@ -912,17 +991,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='T|na'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    5726);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8056);
@@ -933,17 +1014,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    5553);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8525);
@@ -954,17 +1037,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    5822);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8460);
@@ -975,17 +1060,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
    'f',
    5922);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8725);
@@ -1015,17 +1102,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snofox'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6450);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8236);
@@ -1036,17 +1125,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6742);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8728);
@@ -1057,17 +1148,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6605);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8534);
@@ -1078,17 +1171,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    4
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6689);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8828);
@@ -1118,17 +1213,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7343);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8871);
@@ -1139,17 +1236,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7152);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8718);
@@ -1160,17 +1259,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6908);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    9276);
@@ -1200,17 +1301,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='Snute'),
    1
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    8662);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8776);
@@ -1221,17 +1324,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V
    (SELECT player FROM players WHERE nick='OJK'),
    2
 );
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   0,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    8676);
-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
+   1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8831);