From 19a9bbbb5b44cce3411fd1452096b270d6441b13 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sat, 9 Nov 2019 11:18:04 +0100
Subject: Converting players database to baza2.csv format

---
 docs/convert-to-baza2.csv.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 docs/convert-to-baza2.csv.sql

(limited to 'docs')

diff --git a/docs/convert-to-baza2.csv.sql b/docs/convert-to-baza2.csv.sql
new file mode 100644
index 0000000..1b62172
--- /dev/null
+++ b/docs/convert-to-baza2.csv.sql
@@ -0,0 +1,5 @@
+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 = '';
-- 
cgit v1.2.3