From 6f9756cf49e2e2802916ef251732a9377ddd756b Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
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/db-structure.sql')

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

