XJmkdB5u

1-- MariaDB dump 10.17  Distrib 10.4.8-MariaDB, for Win64 (AMD64)
2--
3-- Host: localhost    Database: 3jt
4-- ------------------------------------------------------
5-- Server version	10.4.8-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `lista`
20--
21
22DROP TABLE IF EXISTS `lista`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `lista` (
26  `Numer` int(11) NOT NULL AUTO_INCREMENT,
27  `Nazwisko` char(30) DEFAULT NULL,
28  `Imie` char(30) DEFAULT NULL,
29  `Klasa` char(3) DEFAULT NULL,
30  `Miejscowosc` char(20) DEFAULT NULL,
31  `Waga` int(20) DEFAULT NULL,
32  `Wiek` int(3) DEFAULT NULL,
33  `Wzrost` int(20) DEFAULT NULL,
34  PRIMARY KEY (`Numer`)
35) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `lista`
40--
41
42LOCK TABLES `lista` WRITE;
43/*!40000 ALTER TABLE `lista` DISABLE KEYS */;
44INSERT INTO `lista` VALUES (1,'Jakub','Wrobel','2it','Sielce',47,16,177),(2,'Bartlomiej','Wrobel','2it','Sielce',49,16,179),(3,'Andrzej','Prochniak','1cgt','Kazimierz',80,15,190),(4,'Mateusz','Skowyrski','3cgt','Kazimierz',80,18,195),(5,'Dawid','Skowron','1dt','Oblasy',88,17,199),(6,'Sebastian','Kraszewski','4dt','Pulawy',110,21,210),(7,'Hubert','Majster','3jt','Sielce',80,17,182),(8,'Maja','Rzeznik','4dt','Pulawy',55,20,172),(9,'Gabriela','Wiejak','4dt','Pulawy',45,19,165),(10,'Szymon','Majka','3dt','Pulawy',80,19,180);
45/*!40000 ALTER TABLE `lista` ENABLE KEYS */;
46UNLOCK TABLES;
47/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
48
49/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
50/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
51/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
52/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
53/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
54/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
55/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
56
57-- Dump completed on 2019-12-03 23:34:51