From 42bfe1195b453feec3018b15f8a99b5f2f9f4339 Mon Sep 17 00:00:00 2001 From: emkael Date: Thu, 7 Sep 2017 14:44:00 +0200 Subject: Connecting players' ranks and clubs with specific ranking edition --- bin/import-rankings.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'bin') diff --git a/bin/import-rankings.sh b/bin/import-rankings.sh index d73af64..90ce6bc 100755 --- a/bin/import-rankings.sh +++ b/bin/import-rankings.sh @@ -7,7 +7,7 @@ REPLACE INTO TABLE temp_rankings FIELDS TERMINATED BY ','; INSERT INTO rankings ( - SELECT pid, \`date\`, place, score, region, flags + SELECT pid, \`date\`, place, score, region, flags, rank, club FROM temp_rankings JOIN players ON players.id = temp_rankings.pid -- cgit v1.2.3