Sync with --pgweb.

[ccbs] / sql / various / various-7.sql

diff --git a/sql/various/various-7.sql b/sql/various/various-7.sql
index 94d3a3c20b0c8aadb244c03b4d2052f2c583144e..7d6c5ad6949b008c24eb54b761f927be017e24f1 100644 (file)
--- 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Ã\83Â¥ende' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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Ã\83Â¥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,