diff options
author | MichaĆ Klichowicz <emkael@tlen.pl> | 2019-11-09 12:24:01 +0100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2019-11-09 12:24:01 +0100 |
commit | ee6a00f4af64ad679d67233e730a5fa0d308ce4b (patch) | |
tree | 44e8ed0e0a7f03e83a7a0bbf2c65bccdce76de77 /docs | |
parent | 7c1d49570f36bd334fd0a11f87a3d200bf5480df (diff) | |
parent | 3d772272a7bf0d582eeaa527197a08545e3399ae (diff) |
Merge pull request #17 from emkael/baza2.csv
Baza2.csv
Diffstat (limited to 'docs')
-rw-r--r-- | docs/convert-to-baza2.csv.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/docs/convert-to-baza2.csv.sql b/docs/convert-to-baza2.csv.sql new file mode 100644 index 0000000..c6a5f22 --- /dev/null +++ b/docs/convert-to-baza2.csv.sql @@ -0,0 +1,10 @@ +ALTER TABLE `players` + ADD COLUMN `gender` varchar(1) COLLATE utf8_unicode_520_ci NOT NULL + 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 = ''; |