--
-- Host: localhost    Database: Players
-- ------------------------------------------------------


--
-- Table structure for table `pairs`
--

CREATE TABLE `pairs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `id1` int DEFAULT NULL,
  `id2` int DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pairs`
--


--
-- Table structure for table `players`
--

CREATE TABLE `players` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cezar` int DEFAULT NULL,
  `nick` varchar(20) DEFAULT NULL,
  `first` varchar(20) DEFAULT NULL,
  `last` varchar(20) DEFAULT NULL,
  `pass` varchar(20) DEFAULT NULL,
  UNIQUE KEY `cezar` (`cezar`),
  UNIQUE KEY `nick` (`nick`,`first`,`last`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2640 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `players`
--

INSERT INTO `players` VALUES (1,15004,'tomek','Tomasz','Kręglewski','tomek'),(2,15003,'hania','Hanna','Kalotka-Kręglewska','hania'),(3,6543,'janek','Jan','Chodorowski','janek'),(4,6542,'irena','Irena','Chodorowska','irena'),(5,17017,'piotr','Piotr','Wróblewski','piotr'),(6,17018,'iwona','Iwona','Wróblewska','iwona'),(7,17654,'michał','Michał','Mańkowski','michał'),(8,19508,'magda','Magda','Mańkowska','magda'),(9,18861,'małgosiadm','Małgorzata','Dmowska','małgosiadm'),(10,18795,'małgosiama','Małgorzata','Maruszkin','małgosiama'),(11,19085,'zdzisław','Zdzisław','Pietruszewski','zdzisław'),(12,10119,'mira','Mirosława','Siwek','mira'),(13,6716,'ania','Anna','Kręglewska-Wnuk','ania'),(14,7000,'tomekWn','Tomasz','Wnuk','tomekWn'),(15,21769,'wojtek','Wojciech','Wnuk','wojtek');


