Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64)
- --
- -- Host: localhost Database: s21617
- -- ------------------------------------------------------
- -- Server version 10.1.26-MariaDB-0+deb9u1
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `Autor`
- --
- DROP TABLE IF EXISTS `Autor`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Autor` (
- `Id` INT(11) NOT NULL AUTO_INCREMENT,
- `Nazwisko` VARCHAR(45) NOT NULL,
- `Imie` VARCHAR(20) DEFAULT NULL,
- PRIMARY KEY (`Id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `Autor`
- --
- LOCK TABLES `Autor` WRITE;
- /*!40000 ALTER TABLE `Autor` DISABLE KEYS */;
- INSERT INTO `Autor` VALUES (1,'Bengtsson','Anna'),(2,'Cieślar','Anna'),(3,'Moyes','Jojo'),(4,'Gill','Paul'),(5,'Rutkowski','Dominik'),(6,'Dutka','Wojciech'),(7,'Wysocki','Michał'),(8,'Gische','Wikotria'),(9,'Knedler','Magda'),(10,'Urbaniak','Michał'),(11,'Droga','Katarzyna'),(12,'Edugyan','Esi'),(13,'Ponińska','Dorota'),(14,'Ryan','Donald'),(15,'Szostak','Wit'),(16,'Oz','Amos'),(17,'Dutka','Wojciech'),(18,'Fryczkowska','Anna'),(19,'Salazar','Noelle'),(32,'Test','Test');
- /*!40000 ALTER TABLE `Autor` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `Czytelnik`
- --
- DROP TABLE IF EXISTS `Czytelnik`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Czytelnik` (
- `Nrkarty` INT(11) NOT NULL AUTO_INCREMENT,
- `Nazwisko` VARCHAR(45) NOT NULL,
- `Imie` VARCHAR(20) DEFAULT NULL,
- PRIMARY KEY (`Nrkarty`)
- ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `Czytelnik`
- --
- LOCK TABLES `Czytelnik` WRITE;
- /*!40000 ALTER TABLE `Czytelnik` DISABLE KEYS */;
- INSERT INTO `Czytelnik` VALUES (1,'Andrzejuk','Joanna'),(2,'Borko','Filip'),(3,'Charkiewicz','Michał'),(4,'Charyton','Przemysław'),(5,'Chojnacka','Milena'),(6,'Ciećko','Grzegorz'),(7,'Ciepiela','Kamil'),(8,'Czeczot','Piotr'),(9,'Daczkowski','Dariusz'),(10,'Dawidziuk','Angelika'),(11,'Deptuła','Kamil'),(12,'Dzierzgowska','Emilia'),(13,'Grajewski','Krzysztof'),(14,'Jachimko','Ewa'),(15,'Jadeszko','Julia'),(16,'Kowalewska','Joanna'),(17,'Kret','Dagmara'),(18,'Krzeszowska','Karolina'),(19,'Krzewski','Adam'),(20,'Kulikowska','Adrianna');
- /*!40000 ALTER TABLE `Czytelnik` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `Egzemplarz`
- --
- DROP TABLE IF EXISTS `Egzemplarz`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Egzemplarz` (
- `Nrinw` INT(11) NOT NULL,
- `Wydanie_idwyd` INT(11) DEFAULT NULL,
- PRIMARY KEY (`Nrinw`),
- KEY `Wydanie_idwyd` (`Wydanie_idwyd`),
- CONSTRAINT `Egzemplarz_ibfk_1` FOREIGN KEY (`Wydanie_idwyd`) REFERENCES `Wydanie` (`Idwyd`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `Egzemplarz`
- --
- LOCK TABLES `Egzemplarz` WRITE;
- /*!40000 ALTER TABLE `Egzemplarz` DISABLE KEYS */;
- INSERT INTO `Egzemplarz` VALUES (1,1),(2,2),(3,3),(4,5),(5,6),(6,7),(7,8),(8,9),(9,10),(10,11),(11,12),(12,13),(13,14),(14,15),(15,16),(16,17),(17,18),(18,19),(19,20),(20,20);
- /*!40000 ALTER TABLE `Egzemplarz` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `Ksiazka`
- --
- DROP TABLE IF EXISTS `Ksiazka`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Ksiazka` (
- `Isbn` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `Tytul` VARCHAR(45) DEFAULT NULL,
- `Gatunek` VARCHAR(45) DEFAULT NULL,
- PRIMARY KEY (`Isbn`)
- ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `Ksiazka`
- --
- LOCK TABLES `Ksiazka` WRITE;
- /*!40000 ALTER TABLE `Ksiazka` DISABLE KEYS */;
- INSERT INTO `Ksiazka` VALUES (1,'Życie Sus','dramat'),(2,'Berdo','przyroda'),(3,'Światło w środku nocy','dramat'),(4,'Kobieta mojego męża','obyczajowa'),(5,'Złe dzieci','historyczna'),(6,'Kurier z Teheranu','reportaż'),(7,'Baku, Moskwa, Warszawa','psychologiczna'),(8,'Niespokojne lata','historyczna'),(9,'Szepty z wyspy samotności','historyczna'),(10,'Lista nieobecności','psychologiczna'),(11,'Wojna, miłość i medycyna','obyczajowa'),(12,'Washington Black','przygodowa'),(13,'Romantyczni','historyczna'),(14,'Taki właśnie jest grudzień','psychologiczna'),(15,'Cudze słowa','romans'),(16,'Mój Michael','proza'),(17,'Bractwo mandylionu','historyczna'),(18,'Cyrkówka Marianna','historyczna'),(19,'Dziewczyny w przestworzach','obyczajowa'),(20,'Biblioteka szaleńca','historyczna'),(35,'Test','Test'),(36,'Test1','Test');
- /*!40000 ALTER TABLE `Ksiazka` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!50003 SET @saved_cs_client = @@character_set_client */ ;
- /*!50003 SET @saved_cs_results = @@character_set_results */ ;
- /*!50003 SET @saved_col_connection = @@collation_connection */ ;
- /*!50003 SET character_set_client = utf8mb4 */ ;
- /*!50003 SET character_set_results = utf8mb4 */ ;
- /*!50003 SET collation_connection = utf8mb4_general_ci */ ;
- /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
- /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
- DELIMITER ;;
- /*!50003 CREATE*/ /*!50017 DEFINER=`s21617`@`localhost`*/ /*!50003 trigger ksiazka_deleted after delete on Ksiazka for each row begin insert into Ksiazkadeleted(Isbn, Tytul, Gatunek) values(old.Isbn, old.Tytul, old.Gatunek); end */;;
- DELIMITER ;
- /*!50003 SET sql_mode = @saved_sql_mode */ ;
- /*!50003 SET character_set_client = @saved_cs_client */ ;
- /*!50003 SET character_set_results = @saved_cs_results */ ;
- /*!50003 SET collation_connection = @saved_col_connection */ ;
- --
- -- Table structure for table `Ksiazkadeleted`
- --
- DROP TABLE IF EXISTS `Ksiazkadeleted`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Ksiazkadeleted` (
- `Isbn` BIGINT(20) NOT NULL,
- `Tytul` VARCHAR(45) DEFAULT NULL,
- `Gatunek` VARCHAR(45) DEFAULT NULL,
- PRIMARY KEY (`Isbn`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `Ksiazkadeleted`
- --
- LOCK TABLES `Ksiazkadeleted` WRITE;
- /*!40000 ALTER TABLE `Ksiazkadeleted` DISABLE KEYS */;
- INSERT INTO `Ksiazkadeleted` VALUES (33,'Test','Test'),(34,'Test','Test');
- /*!40000 ALTER TABLE `Ksiazkadeleted` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `KsiazkiAutorzy`
- --
- DROP TABLE IF EXISTS `KsiazkiAutorzy`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `KsiazkiAutorzy` (
- `Ksiazka_isbn` BIGINT(20) NOT NULL,
- `Autor_id` INT(11) NOT NULL,
- PRIMARY KEY (`Ksiazka_isbn`,`Autor_id`),
- KEY `Autor_id` (`Autor_id`),
- CONSTRAINT `fk_autor` FOREIGN KEY (`Autor_id`) REFERENCES `Autor` (`Id`),
- CONSTRAINT `fk_ksiazka` FOREIGN KEY (`Ksiazka_isbn`) REFERENCES `Ksiazka` (`Isbn`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `KsiazkiAutorzy`
- --
- LOCK TABLES `KsiazkiAutorzy` WRITE;
- /*!40000 ALTER TABLE `KsiazkiAutorzy` DISABLE KEYS */;
- INSERT INTO `KsiazkiAutorzy` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12),(13,13),(14,14),(15,15),(16,16),(17,17),(18,18),(19,19);
- /*!40000 ALTER TABLE `KsiazkiAutorzy` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `Wydanie`
- --
- DROP TABLE IF EXISTS `Wydanie`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Wydanie` (
- `Idwyd` INT(11) NOT NULL AUTO_INCREMENT,
- `Wydawnictwo` VARCHAR(45) NOT NULL,
- `Cena` DECIMAL(5,2) DEFAULT NULL,
- `Rok` YEAR(4) DEFAULT NULL,
- `Ksiazka_isbn` BIGINT(20) DEFAULT NULL,
- PRIMARY KEY (`Idwyd`),
- KEY `Ksiazka_isbn` (`Ksiazka_isbn`),
- CONSTRAINT `Wydanie_ibfk_1` FOREIGN KEY (`Ksiazka_isbn`) REFERENCES `Ksiazka` (`Isbn`)
- ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `Wydanie`
- --
- LOCK TABLES `Wydanie` WRITE;
- /*!40000 ALTER TABLE `Wydanie` DISABLE KEYS */;
- INSERT INTO `Wydanie` VALUES (1,'ABE Dom Wydawniczy',55.00,2005,1),(2,'Zmiana1',44.00,2010,2),(3,'Adam Oficyna Wydawniczo-Poligraficzna',35.00,2019,3),(4,'Akademia Sztuk Pięknych w Katowicach',55.00,2017,4),(5,'Albus Wydawnictwo',55.00,2015,5),(6,'Alma-Press',57.00,2019,6),(7,'Alatheia',89.00,2020,7),(8,'Arcana Wydawnictwo',23.00,2019,8),(9,'Debit Wydawnictwo',67.00,2020,9),(10,'DiG Wydawnictwo',23.00,2016,5),(11,'Dwie Siostry',45.00,2020,11),(12,'Egmont Polska',66.00,2017,12),(13,'Enset Wydawnictwo',45.00,2017,13),(14,'Ezop Wydawnictwo',34.00,2020,14),(15,'Foks Wydawnictwo',55.00,2021,15),(16,'Gdańskie Wydawnictwo Oświatowe',65.00,2017,16),(17,'Karakter',23.00,2015,17),(18,'Latarnik Instytut Wydawniczy',75.00,2018,18),(19,'Kurtiak i Ley Wydawnictwo Artystyczne',35.00,2016,19),(20,'Multico',23.00,2011,20),(64,'Test1',50.00,2001,36);
- /*!40000 ALTER TABLE `Wydanie` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `Wypozyczenia`
- --
- DROP TABLE IF EXISTS `Wypozyczenia`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Wypozyczenia` (
- `Wypozyczenie` DATE DEFAULT NULL,
- `Zwrot` DATE DEFAULT NULL,
- `Nrkarty` INT(11) DEFAULT NULL,
- `Egzemplarz_nrinw` INT(11) DEFAULT NULL,
- `Id` INT(11) NOT NULL AUTO_INCREMENT,
- PRIMARY KEY (`Id`),
- KEY `Nrkarty` (`Nrkarty`),
- KEY `Egzemplarz_nrinw` (`Egzemplarz_nrinw`),
- CONSTRAINT `Wypozyczenia_ibfk_1` FOREIGN KEY (`Nrkarty`) REFERENCES `Czytelnik` (`Nrkarty`),
- CONSTRAINT `Wypozyczenia_ibfk_2` FOREIGN KEY (`Egzemplarz_nrinw`) REFERENCES `Egzemplarz` (`Nrinw`)
- ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `Wypozyczenia`
- --
- LOCK TABLES `Wypozyczenia` WRITE;
- /*!40000 ALTER TABLE `Wypozyczenia` DISABLE KEYS */;
- INSERT INTO `Wypozyczenia` VALUES ('2020-09-20','2021-01-10',1,1,1),('2021-01-10','0000-00-00',2,2,2),('2020-12-30','2021-01-05',3,3,3),('2021-01-03','0000-00-00',4,4,4),('2021-01-05','0000-00-00',5,5,5),('2020-12-15','2020-12-30',6,6,6),('2021-01-03','0000-00-00',7,7,7),('2020-09-15','0000-00-00',8,8,8),('2020-11-30','2020-12-31',9,9,9),('2020-09-25','2021-01-10',10,10,10),('2020-12-30','2021-01-11',11,11,11),('2020-11-30','2020-12-15',12,12,12),('2020-11-23','2020-12-19',13,13,13),('2021-01-10','0000-00-00',14,14,14),('2020-12-23','0000-00-00',15,15,15),('2020-12-14','2020-12-31',16,16,16),('2021-01-02','0000-00-00',17,17,17),('2020-12-23','2020-12-30',18,18,18),('2020-12-01','2020-12-28',19,19,19),('2012-01-12','0000-00-00',20,5,20);
- /*!40000 ALTER TABLE `Wypozyczenia` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2021-01-22 13:25:27
Add Comment
Please, Sign In to add comment