diff options
| author | emkael <emkael@tlen.pl> | 2017-09-07 14:44:00 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2017-09-07 14:44:00 +0200 |
| commit | 42bfe1195b453feec3018b15f8a99b5f2f9f4339 (patch) | |
| tree | 8c9d1e0058fd8a39db8f0b2ccafb158a498379bd /bin | |
| parent | 9653e31ca7ef40a408d176d338cd93a8076b3318 (diff) | |
Connecting players' ranks and clubs with specific ranking edition
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/import-rankings.sh | 2 |
1 files changed, 1 insertions, 1 deletions
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 |