From 6f9756cf49e2e2802916ef251732a9377ddd756b Mon Sep 17 00:00:00 2001 From: emkael Date: Fri, 24 Aug 2018 12:53:41 +0200 Subject: Alowingg players to not be displayed by name in the rankings --- docs/db-structure.sql | 25 ++++++++++++++++++++++++- 1 file changed, 24 insertions(+), 1 deletion(-) (limited to 'docs') 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 -- @@ -80,6 +91,12 @@ ALTER TABLE `rankings` 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; -- cgit v1.2.3