From 42bfe1195b453feec3018b15f8a99b5f2f9f4339 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Thu, 7 Sep 2017 14:44:00 +0200
Subject: Connecting players' ranks and clubs with specific ranking edition

---
 docs/db-structure.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'docs/db-structure.sql')

diff --git a/docs/db-structure.sql b/docs/db-structure.sql
index 56c0f0a..35fdc52 100644
--- a/docs/db-structure.sql
+++ b/docs/db-structure.sql
@@ -37,7 +37,9 @@ CREATE TABLE `rankings` (
   `place` int(11) NOT NULL,
   `score` decimal(8,4) NOT NULL,
   `region` varchar(2) COLLATE utf8_unicode_520_ci NOT NULL,
-  `flags` varchar(2) COLLATE utf8_unicode_520_ci NOT NULL
+  `flags` varchar(2) COLLATE utf8_unicode_520_ci NOT NULL,
+  `rank` decimal(3,1) NOT NULL,
+  `club` varchar(100) COLLATE utf8_unicode_520_ci NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_520_ci;
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3

