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 /docs | |
parent | 9653e31ca7ef40a408d176d338cd93a8076b3318 (diff) |
Connecting players' ranks and clubs with specific ranking edition
Diffstat (limited to 'docs')
-rw-r--r-- | docs/db-structure.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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; -- -------------------------------------------------------- |