X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fvarious-7.sql;fp=sql%2Fvarious%2Fvarious-7.sql;h=94d3a3c20b0c8aadb244c03b4d2052f2c583144e;hp=7d6c5ad6949b008c24eb54b761f927be017e24f1;hb=f77426158d4ef1b9b4a344de2d6cf6ef0c398734;hpb=e5f210a4894f541c6b2d2b9cdddea887ebea1fb3 diff --git a/sql/various/various-7.sql b/sql/various/various-7.sql index 7d6c5ad..94d3a3c 100644 --- a/sql/various/various-7.sql +++ b/sql/various/various-7.sql @@ -1,7 +1,7 @@ begin; INSERT INTO tournaments (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( - (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 'Trondheimsturnering', (SELECT country FROM countries WHERE countryname='Norway'), 'Megazone Trondheim', @@ -11,49 +11,49 @@ INSERT INTO tournaments ); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sesse' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, (SELECT player FROM players WHERE nick='Sesse'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dashiva' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dashiva' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, (SELECT player FROM players WHERE nick='Dashiva'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'wa-ho' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'wa-ho' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, (SELECT player FROM players WHERE nick='wa-ho'), NULL); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Sesse'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Sesse'), 0, @@ -61,7 +61,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8077); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Sesse'), 1, @@ -69,13 +69,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7932); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='wa-ho'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='wa-ho'), 0, @@ -83,7 +83,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5917); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='wa-ho'), 1, @@ -91,13 +91,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7153); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Dashiva'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Dashiva'), 0, @@ -105,7 +105,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7602); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Dashiva'), 1, @@ -114,34 +114,34 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 6799); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Dashiva'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Dashiva'), 0, @@ -149,7 +149,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5967); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Dashiva'), 1, @@ -157,7 +157,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7615); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Dashiva'), 2, @@ -165,13 +165,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6418); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='wa-ho'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='wa-ho'), 0, @@ -179,7 +179,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5070); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='wa-ho'), 1, @@ -187,7 +187,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6425); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='wa-ho'), 2, @@ -195,13 +195,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6733); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Sesse'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Sesse'), 0, @@ -209,7 +209,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6047); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Sesse'), 1, @@ -217,7 +217,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7820); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Sesse'), 2,