diff options
author | emkael <emkael@tlen.pl> | 2018-08-24 12:53:41 +0200 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2018-08-24 12:54:15 +0200 |
commit | 6f9756cf49e2e2802916ef251732a9377ddd756b (patch) | |
tree | 66bf607583b9ed856341454b505b0c50d9487d24 /docs | |
parent | 83c732f6c67c05b641cd0d37d9e8718cbf061c65 (diff) |
Alowingg players to not be displayed by name in the rankings
Diffstat (limited to 'docs')
-rw-r--r-- | docs/db-structure.sql | 25 |
1 files changed, 24 insertions, 1 deletions
diff --git a/docs/db-structure.sql b/docs/db-structure.sql index 35fdc52..d794532 100644 --- a/docs/db-structure.sql +++ b/docs/db-structure.sql @@ -39,7 +39,8 @@ CREATE TABLE `rankings` ( `region` 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 + `club` varchar(100) COLLATE utf8_unicode_520_ci NOT NULL, + `hidden` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_520_ci; -- -------------------------------------------------------- @@ -58,6 +59,16 @@ CREATE TABLE `temp_rankings` ( `score` decimal(8,4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_520_ci; +-- -------------------------------------------------------- + +-- +-- Struktura tabeli dla tabeli `hidden_players` +-- + +CREATE TABLE `hidden_players` ( + `pid` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_520_ci; + -- -- Indeksy dla zrzutów tabel -- @@ -81,6 +92,12 @@ ALTER TABLE `temp_rankings` ADD PRIMARY KEY (`pid`,`date`); -- +-- Indexes for table `hidden_players` +-- +ALTER TABLE `hidden_players` + ADD PRIMARY KEY (`pid`); + +-- -- Ograniczenia dla zrzutów tabel -- @@ -95,3 +112,9 @@ ALTER TABLE `rankings` -- ALTER TABLE `temp_rankings` ADD CONSTRAINT `temp_rankings_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `players` (`id`) ON UPDATE CASCADE; + +-- +-- Ograniczenia dla tabeli `hidden_players` +-- +ALTER TABLE `hidden_players` + ADD CONSTRAINT `hidden_players_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; |