Importing rankings compatible with baza2.csv format

2 files changed, 6 insertions, 1 deletions

diff --git a/bin/rankings-csv-import.sh b/bin/rankings-csv-import.sh
index 54ce6bc..9eddd82 100755
--- a/bin/rankings-csv-import.sh
+++ b/bin/rankings-csv-import.sh
@@ -7,7 +7,7 @@ REPLACE
 INTO TABLE temp_rankings
 FIELDS TERMINATED BY ',';
 INSERT INTO rankings (
-       SELECT pid, \`date\`, place, score, region, flags, rank, club, 0
+       SELECT pid, \`date\`, place, score, region, gender, flags, rank, club, 0
        FROM temp_rankings
        JOIN players
             ON players.id = temp_rankings.pid
diff --git a/docs/convert-to-baza2.csv.sql b/docs/convert-to-baza2.csv.sql
index 1b62172..c6a5f22 100644
--- a/docs/convert-to-baza2.csv.sql
+++ b/docs/convert-to-baza2.csv.sql
@@ -3,3 +3,8 @@ ALTER TABLE `players`
       AFTER `region`;
 UPDATE `players` SET `gender` = 'K', `flags` = SUBSTRING(`flags` FROM 2) WHERE flags LIKE 'K%';
 UPDATE `players` SET `gender` = 'M' WHERE gender = '';
+ALTER TABLE `rankings`
+      ADD COLUMN `gender` varchar(1) COLLATE utf8_unicode_520_ci NOT NULL
+      AFTER `region`;
+UPDATE `rankings` SET `gender` = 'K', `flags` = SUBSTRING(`flags` FROM 2) WHERE flags LIKE 'K%';
+UPDATE `rankings` SET `gender` = 'M' WHERE gender = '';