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 --- docs/db-structure.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'docs') 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