· 6 years ago · Oct 23, 2019, 12:22 PM
1-- MySQL dump 10.16 Distrib 10.1.38-MariaDB, for Win64 (AMD64)
2--
3-- Host: localhost Database: szkola
4-- ------------------------------------------------------
5-- Server version 10.1.38-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 utf8 */;
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 `godzina_lekcyjna`
20--
21
22DROP TABLE IF EXISTS `godzina_lekcyjna`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `godzina_lekcyjna` (
26 `ID_godzina_lekcyjna` bigint(20) NOT NULL,
27 `create_user` varchar(45) DEFAULT NULL,
28 `update_user` varchar(16) DEFAULT NULL,
29 `create_time` timestamp NULL DEFAULT NULL,
30 `update_time` timestamp NULL DEFAULT NULL,
31 PRIMARY KEY (`ID_godzina_lekcyjna`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `godzina_lekcyjna`
37--
38
39LOCK TABLES `godzina_lekcyjna` WRITE;
40/*!40000 ALTER TABLE `godzina_lekcyjna` DISABLE KEYS */;
41/*!40000 ALTER TABLE `godzina_lekcyjna` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `klasa`
46--
47
48DROP TABLE IF EXISTS `klasa`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `klasa` (
52 `ID_klasa` bigint(20) NOT NULL,
53 `nazwa` varchar(45) DEFAULT NULL,
54 `create_user` varchar(16) DEFAULT NULL,
55 `update_user` varchar(16) DEFAULT NULL,
56 `create_time` timestamp NULL DEFAULT NULL,
57 `update_time` timestamp NULL DEFAULT NULL,
58 `sala_ID_sala` bigint(20) NOT NULL,
59 `ID_dyzurny` bigint(20) DEFAULT NULL,
60 PRIMARY KEY (`ID_klasa`,`sala_ID_sala`),
61 KEY `fk_Klasa_Sala1` (`sala_ID_sala`),
62 CONSTRAINT `fk_Klasa_Sala1` FOREIGN KEY (`sala_ID_sala`) REFERENCES `sala` (`ID_sala`)
63) ENGINE=InnoDB DEFAULT CHARSET=utf8;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `klasa`
68--
69
70LOCK TABLES `klasa` WRITE;
71/*!40000 ALTER TABLE `klasa` DISABLE KEYS */;
72INSERT INTO `klasa` VALUES (1,'3i2','root@localhost',NULL,'2019-10-23 11:56:35',NULL,0,5);
73/*!40000 ALTER TABLE `klasa` ENABLE KEYS */;
74UNLOCK TABLES;
75/*!50003 SET @saved_cs_client = @@character_set_client */ ;
76/*!50003 SET @saved_cs_results = @@character_set_results */ ;
77/*!50003 SET @saved_col_connection = @@collation_connection */ ;
78/*!50003 SET character_set_client = cp852 */ ;
79/*!50003 SET character_set_results = cp852 */ ;
80/*!50003 SET collation_connection = cp852_general_ci */ ;
81/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
82/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
83DELIMITER ;;
84/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `szkola`.`klasa_before_insert`
85BEFORE INSERT ON `szkola`.`klasa`
86FOR EACH ROW
87begin
88set new.create_user = session_user();
89set new.create_time = current_timestamp();
90end */;;
91DELIMITER ;
92/*!50003 SET sql_mode = @saved_sql_mode */ ;
93/*!50003 SET character_set_client = @saved_cs_client */ ;
94/*!50003 SET character_set_results = @saved_cs_results */ ;
95/*!50003 SET collation_connection = @saved_col_connection */ ;
96/*!50003 SET @saved_cs_client = @@character_set_client */ ;
97/*!50003 SET @saved_cs_results = @@character_set_results */ ;
98/*!50003 SET @saved_col_connection = @@collation_connection */ ;
99/*!50003 SET character_set_client = cp852 */ ;
100/*!50003 SET character_set_results = cp852 */ ;
101/*!50003 SET collation_connection = cp852_general_ci */ ;
102/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
103/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
104DELIMITER ;;
105/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `szkola`.`klasa_before_update`
106BEFORE UPDATE ON `szkola`.`klasa`
107FOR EACH ROW
108begin
109set new.update_user = session_user();
110set new.update_time = now();
111end */;;
112DELIMITER ;
113/*!50003 SET sql_mode = @saved_sql_mode */ ;
114/*!50003 SET character_set_client = @saved_cs_client */ ;
115/*!50003 SET character_set_results = @saved_cs_results */ ;
116/*!50003 SET collation_connection = @saved_col_connection */ ;
117
118--
119-- Table structure for table `nauczyciel`
120--
121
122DROP TABLE IF EXISTS `nauczyciel`;
123/*!40101 SET @saved_cs_client = @@character_set_client */;
124/*!40101 SET character_set_client = utf8 */;
125CREATE TABLE `nauczyciel` (
126 `ID_nauczyciel` bigint(20) NOT NULL,
127 `imie` varchar(40) NOT NULL,
128 `nazwisko` varchar(40) NOT NULL,
129 PRIMARY KEY (`ID_nauczyciel`)
130) ENGINE=InnoDB DEFAULT CHARSET=utf8;
131/*!40101 SET character_set_client = @saved_cs_client */;
132
133--
134-- Dumping data for table `nauczyciel`
135--
136
137LOCK TABLES `nauczyciel` WRITE;
138/*!40000 ALTER TABLE `nauczyciel` DISABLE KEYS */;
139INSERT INTO `nauczyciel` VALUES (1,'Sor','Wielki');
140/*!40000 ALTER TABLE `nauczyciel` ENABLE KEYS */;
141UNLOCK TABLES;
142
143--
144-- Table structure for table `plan_lekcji`
145--
146
147DROP TABLE IF EXISTS `plan_lekcji`;
148/*!40101 SET @saved_cs_client = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `plan_lekcji` (
151 `ID_plan_lekcji` bigint(20) NOT NULL,
152 `data` date NOT NULL,
153 `create_user` varchar(16) DEFAULT NULL,
154 `update_user` varchar(16) DEFAULT NULL,
155 `create_time` timestamp NULL DEFAULT NULL,
156 `update_time` timestamp NULL DEFAULT NULL,
157 `przedmiot_ID_przedmiot` bigint(20) NOT NULL,
158 `klasa_ID_klasa` bigint(20) NOT NULL,
159 `godzina_lekcyjna_ID_godzina_lekcyjna` bigint(20) NOT NULL,
160 `nauczyciel_ID_nauczyciel` bigint(20) NOT NULL,
161 `sala_ID_sala` bigint(20) NOT NULL,
162 PRIMARY KEY (`ID_plan_lekcji`,`przedmiot_ID_przedmiot`,`klasa_ID_klasa`,`godzina_lekcyjna_ID_godzina_lekcyjna`,`nauczyciel_ID_nauczyciel`,`sala_ID_sala`),
163 KEY `fk_Plan lekcji_Godzina lekcyjna1` (`godzina_lekcyjna_ID_godzina_lekcyjna`),
164 KEY `fk_Plan lekcji_Klasa2` (`klasa_ID_klasa`),
165 KEY `fk_Plan lekcji_Nauczyciel1` (`nauczyciel_ID_nauczyciel`),
166 KEY `fk_Plan lekcji_Przedmiot2` (`przedmiot_ID_przedmiot`),
167 KEY `fk_Plan lekcji_Sala1` (`sala_ID_sala`),
168 CONSTRAINT `fk_Plan lekcji_Godzina lekcyjna1` FOREIGN KEY (`godzina_lekcyjna_ID_godzina_lekcyjna`) REFERENCES `godzina_lekcyjna` (`ID_godzina_lekcyjna`),
169 CONSTRAINT `fk_Plan lekcji_Klasa2` FOREIGN KEY (`klasa_ID_klasa`) REFERENCES `klasa` (`ID_klasa`),
170 CONSTRAINT `fk_Plan lekcji_Nauczyciel1` FOREIGN KEY (`nauczyciel_ID_nauczyciel`) REFERENCES `nauczyciel` (`ID_nauczyciel`),
171 CONSTRAINT `fk_Plan lekcji_Przedmiot2` FOREIGN KEY (`przedmiot_ID_przedmiot`) REFERENCES `przedmiot` (`ID_przedmiot`),
172 CONSTRAINT `fk_Plan lekcji_Sala1` FOREIGN KEY (`sala_ID_sala`) REFERENCES `sala` (`ID_sala`)
173) ENGINE=InnoDB DEFAULT CHARSET=utf8;
174/*!40101 SET character_set_client = @saved_cs_client */;
175
176--
177-- Dumping data for table `plan_lekcji`
178--
179
180LOCK TABLES `plan_lekcji` WRITE;
181/*!40000 ALTER TABLE `plan_lekcji` DISABLE KEYS */;
182/*!40000 ALTER TABLE `plan_lekcji` ENABLE KEYS */;
183UNLOCK TABLES;
184
185--
186-- Table structure for table `przedmiot`
187--
188
189DROP TABLE IF EXISTS `przedmiot`;
190/*!40101 SET @saved_cs_client = @@character_set_client */;
191/*!40101 SET character_set_client = utf8 */;
192CREATE TABLE `przedmiot` (
193 `ID_przedmiot` bigint(20) NOT NULL,
194 `nazwa` varchar(45) DEFAULT NULL,
195 `create_user` varchar(16) DEFAULT NULL,
196 `update_user` varchar(16) DEFAULT NULL,
197 `create_time` timestamp NULL DEFAULT NULL,
198 `update_time` timestamp NULL DEFAULT NULL,
199 PRIMARY KEY (`ID_przedmiot`)
200) ENGINE=InnoDB DEFAULT CHARSET=utf8;
201/*!40101 SET character_set_client = @saved_cs_client */;
202
203--
204-- Dumping data for table `przedmiot`
205--
206
207LOCK TABLES `przedmiot` WRITE;
208/*!40000 ALTER TABLE `przedmiot` DISABLE KEYS */;
209/*!40000 ALTER TABLE `przedmiot` ENABLE KEYS */;
210UNLOCK TABLES;
211/*!50003 SET @saved_cs_client = @@character_set_client */ ;
212/*!50003 SET @saved_cs_results = @@character_set_results */ ;
213/*!50003 SET @saved_col_connection = @@collation_connection */ ;
214/*!50003 SET character_set_client = cp852 */ ;
215/*!50003 SET character_set_results = cp852 */ ;
216/*!50003 SET collation_connection = cp852_general_ci */ ;
217/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
218/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
219DELIMITER ;;
220/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `szkola`.`przedmiot_before_insert`
221BEFORE INSERT ON `szkola`.`przedmiot`
222FOR EACH ROW
223begin
224set new.create_user = current_user();
225set new.create_time = current_timestamp();
226end */;;
227DELIMITER ;
228/*!50003 SET sql_mode = @saved_sql_mode */ ;
229/*!50003 SET character_set_client = @saved_cs_client */ ;
230/*!50003 SET character_set_results = @saved_cs_results */ ;
231/*!50003 SET collation_connection = @saved_col_connection */ ;
232/*!50003 SET @saved_cs_client = @@character_set_client */ ;
233/*!50003 SET @saved_cs_results = @@character_set_results */ ;
234/*!50003 SET @saved_col_connection = @@collation_connection */ ;
235/*!50003 SET character_set_client = cp852 */ ;
236/*!50003 SET character_set_results = cp852 */ ;
237/*!50003 SET collation_connection = cp852_general_ci */ ;
238/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
239/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
240DELIMITER ;;
241/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `szkola`.`przedmiot_before_update`
242BEFORE UPDATE ON `szkola`.`przedmiot`
243FOR EACH ROW
244begin
245set new.update_user = current_user();
246set new.update_time = current_timestamp();
247end */;;
248DELIMITER ;
249/*!50003 SET sql_mode = @saved_sql_mode */ ;
250/*!50003 SET character_set_client = @saved_cs_client */ ;
251/*!50003 SET character_set_results = @saved_cs_results */ ;
252/*!50003 SET collation_connection = @saved_col_connection */ ;
253
254--
255-- Table structure for table `przedmioty_nauczyciela`
256--
257
258DROP TABLE IF EXISTS `przedmioty_nauczyciela`;
259/*!40101 SET @saved_cs_client = @@character_set_client */;
260/*!40101 SET character_set_client = utf8 */;
261CREATE TABLE `przedmioty_nauczyciela` (
262 `ID_przedmioty_nauczyciela` bigint(20) NOT NULL,
263 `create_user` varchar(16) DEFAULT NULL,
264 `update_user` varchar(16) DEFAULT NULL,
265 `create_time` timestamp NULL DEFAULT NULL,
266 `update_time` timestamp NULL DEFAULT NULL,
267 `nauczyciel_ID_nauczyciel` bigint(20) NOT NULL,
268 `przedmiot_ID_przedmiot` bigint(20) NOT NULL,
269 PRIMARY KEY (`ID_przedmioty_nauczyciela`,`nauczyciel_ID_nauczyciel`,`przedmiot_ID_przedmiot`),
270 KEY `fk_Przedmioty Nauczyciela_Nauczyciel1` (`nauczyciel_ID_nauczyciel`),
271 KEY `fk_Przedmioty Nauczyciela_Przedmiot1` (`przedmiot_ID_przedmiot`),
272 CONSTRAINT `fk_Przedmioty Nauczyciela_Nauczyciel1` FOREIGN KEY (`nauczyciel_ID_nauczyciel`) REFERENCES `nauczyciel` (`ID_nauczyciel`),
273 CONSTRAINT `fk_Przedmioty Nauczyciela_Przedmiot1` FOREIGN KEY (`przedmiot_ID_przedmiot`) REFERENCES `przedmiot` (`ID_przedmiot`)
274) ENGINE=InnoDB DEFAULT CHARSET=utf8;
275/*!40101 SET character_set_client = @saved_cs_client */;
276
277--
278-- Dumping data for table `przedmioty_nauczyciela`
279--
280
281LOCK TABLES `przedmioty_nauczyciela` WRITE;
282/*!40000 ALTER TABLE `przedmioty_nauczyciela` DISABLE KEYS */;
283/*!40000 ALTER TABLE `przedmioty_nauczyciela` ENABLE KEYS */;
284UNLOCK TABLES;
285
286--
287-- Table structure for table `rejestr_ocen`
288--
289
290DROP TABLE IF EXISTS `rejestr_ocen`;
291/*!40101 SET @saved_cs_client = @@character_set_client */;
292/*!40101 SET character_set_client = utf8 */;
293CREATE TABLE `rejestr_ocen` (
294 `ID_rejestr_ocen` int(11) NOT NULL,
295 `ocena` varchar(45) DEFAULT NULL,
296 `data_wystawienia` date DEFAULT NULL,
297 `opis_oceny` varchar(45) DEFAULT NULL,
298 `przedmiot_ID_przedmiot` bigint(20) NOT NULL,
299 `uczen_ID_uczen` bigint(20) NOT NULL,
300 `uczen_klasa_ID_klasa` bigint(20) NOT NULL,
301 `nauczyciel_ID_nauczyciel` bigint(20) NOT NULL,
302 PRIMARY KEY (`ID_rejestr_ocen`,`przedmiot_ID_przedmiot`,`uczen_ID_uczen`,`uczen_klasa_ID_klasa`,`nauczyciel_ID_nauczyciel`),
303 KEY `fk_rejestr_ocen_przedmiot1` (`przedmiot_ID_przedmiot`),
304 KEY `fk_rejestr_ocen_uczen1` (`uczen_ID_uczen`,`uczen_klasa_ID_klasa`),
305 KEY `fk_rejestr_ocen_nauczyciel1` (`nauczyciel_ID_nauczyciel`),
306 CONSTRAINT `fk_rejestr_ocen_nauczyciel1` FOREIGN KEY (`nauczyciel_ID_nauczyciel`) REFERENCES `nauczyciel` (`ID_nauczyciel`) ON DELETE NO ACTION ON UPDATE NO ACTION,
307 CONSTRAINT `fk_rejestr_ocen_przedmiot1` FOREIGN KEY (`przedmiot_ID_przedmiot`) REFERENCES `przedmiot` (`ID_przedmiot`) ON DELETE NO ACTION ON UPDATE NO ACTION,
308 CONSTRAINT `fk_rejestr_ocen_uczen1` FOREIGN KEY (`uczen_ID_uczen`, `uczen_klasa_ID_klasa`) REFERENCES `uczen` (`ID_uczen`, `klasa_ID_klasa`) ON DELETE NO ACTION ON UPDATE NO ACTION
309) ENGINE=InnoDB DEFAULT CHARSET=latin1;
310/*!40101 SET character_set_client = @saved_cs_client */;
311
312--
313-- Dumping data for table `rejestr_ocen`
314--
315
316LOCK TABLES `rejestr_ocen` WRITE;
317/*!40000 ALTER TABLE `rejestr_ocen` DISABLE KEYS */;
318/*!40000 ALTER TABLE `rejestr_ocen` ENABLE KEYS */;
319UNLOCK TABLES;
320
321--
322-- Table structure for table `sala`
323--
324
325DROP TABLE IF EXISTS `sala`;
326/*!40101 SET @saved_cs_client = @@character_set_client */;
327/*!40101 SET character_set_client = utf8 */;
328CREATE TABLE `sala` (
329 `ID_sala` bigint(20) NOT NULL,
330 `numer_sali` varchar(45) DEFAULT NULL,
331 `create_user` varchar(16) DEFAULT NULL,
332 `update_user` varchar(16) DEFAULT NULL,
333 `create_time` timestamp NULL DEFAULT NULL,
334 `update_time` timestamp NULL DEFAULT NULL,
335 PRIMARY KEY (`ID_sala`)
336) ENGINE=InnoDB DEFAULT CHARSET=utf8;
337/*!40101 SET character_set_client = @saved_cs_client */;
338
339--
340-- Dumping data for table `sala`
341--
342
343LOCK TABLES `sala` WRITE;
344/*!40000 ALTER TABLE `sala` DISABLE KEYS */;
345INSERT INTO `sala` VALUES (0,'1','root@localhost',NULL,'2019-10-23 11:48:26',NULL),(1,'1','root@localhost',NULL,'2019-10-23 11:50:38',NULL),(2,'3','root@localhost',NULL,'2019-10-23 11:50:52',NULL);
346/*!40000 ALTER TABLE `sala` ENABLE KEYS */;
347UNLOCK TABLES;
348/*!50003 SET @saved_cs_client = @@character_set_client */ ;
349/*!50003 SET @saved_cs_results = @@character_set_results */ ;
350/*!50003 SET @saved_col_connection = @@collation_connection */ ;
351/*!50003 SET character_set_client = cp852 */ ;
352/*!50003 SET character_set_results = cp852 */ ;
353/*!50003 SET collation_connection = cp852_general_ci */ ;
354/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
355/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
356DELIMITER ;;
357/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `szkola`.`sala_before_insert`
358BEFORE INSERT ON `szkola`.`sala`
359FOR EACH ROW
360begin
361set new.create_user = session_user();
362set new.create_time = current_timestamp();
363end */;;
364DELIMITER ;
365/*!50003 SET sql_mode = @saved_sql_mode */ ;
366/*!50003 SET character_set_client = @saved_cs_client */ ;
367/*!50003 SET character_set_results = @saved_cs_results */ ;
368/*!50003 SET collation_connection = @saved_col_connection */ ;
369/*!50003 SET @saved_cs_client = @@character_set_client */ ;
370/*!50003 SET @saved_cs_results = @@character_set_results */ ;
371/*!50003 SET @saved_col_connection = @@collation_connection */ ;
372/*!50003 SET character_set_client = cp852 */ ;
373/*!50003 SET character_set_results = cp852 */ ;
374/*!50003 SET collation_connection = cp852_general_ci */ ;
375/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
376/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
377DELIMITER ;;
378/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `szkola`.`sala_before_update`
379BEFORE UPDATE ON `szkola`.`sala`
380FOR EACH ROW
381begin
382set new.update_user = session_user();
383set new.update_time = current_timestamp();
384end */;;
385DELIMITER ;
386/*!50003 SET sql_mode = @saved_sql_mode */ ;
387/*!50003 SET character_set_client = @saved_cs_client */ ;
388/*!50003 SET character_set_results = @saved_cs_results */ ;
389/*!50003 SET collation_connection = @saved_col_connection */ ;
390
391--
392-- Table structure for table `uczen`
393--
394
395DROP TABLE IF EXISTS `uczen`;
396/*!40101 SET @saved_cs_client = @@character_set_client */;
397/*!40101 SET character_set_client = utf8 */;
398CREATE TABLE `uczen` (
399 `ID_uczen` bigint(20) NOT NULL AUTO_INCREMENT,
400 `imie` varchar(40) NOT NULL,
401 `nazwisko` varchar(40) NOT NULL,
402 `wiek` varchar(40) DEFAULT NULL,
403 `create_time` timestamp NULL DEFAULT NULL,
404 `update_time` timestamp NULL DEFAULT NULL,
405 `create_user` varchar(16) DEFAULT NULL,
406 `update_user` varchar(16) DEFAULT NULL,
407 `klasa_ID_klasa` bigint(20) NOT NULL,
408 `srednia_ocena` float DEFAULT NULL,
409 PRIMARY KEY (`ID_uczen`,`klasa_ID_klasa`),
410 KEY `fk_Uczeń_Klasa2` (`klasa_ID_klasa`),
411 CONSTRAINT `fk_Uczeń_Klasa2` FOREIGN KEY (`klasa_ID_klasa`) REFERENCES `klasa` (`ID_klasa`)
412) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
413/*!40101 SET character_set_client = @saved_cs_client */;
414
415--
416-- Dumping data for table `uczen`
417--
418
419LOCK TABLES `uczen` WRITE;
420/*!40000 ALTER TABLE `uczen` DISABLE KEYS */;
421INSERT INTO `uczen` VALUES (18,'Wojciech','Ludwiczak','18',NULL,NULL,NULL,NULL,1,NULL);
422/*!40000 ALTER TABLE `uczen` ENABLE KEYS */;
423UNLOCK TABLES;
424
425--
426-- Table structure for table `user`
427--
428
429DROP TABLE IF EXISTS `user`;
430/*!40101 SET @saved_cs_client = @@character_set_client */;
431/*!40101 SET character_set_client = utf8 */;
432CREATE TABLE `user` (
433 `username` varchar(16) NOT NULL,
434 `email` varchar(255) DEFAULT NULL,
435 `password` varchar(32) NOT NULL,
436 `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
437 PRIMARY KEY (`username`)
438) ENGINE=InnoDB DEFAULT CHARSET=utf8;
439/*!40101 SET character_set_client = @saved_cs_client */;
440
441--
442-- Dumping data for table `user`
443--
444
445LOCK TABLES `user` WRITE;
446/*!40000 ALTER TABLE `user` DISABLE KEYS */;
447/*!40000 ALTER TABLE `user` ENABLE KEYS */;
448UNLOCK TABLES;
449/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
450
451/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
452/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
453/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
454/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
455/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
456/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
457/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
458
459-- Dump completed on 2019-10-23 14:17:00