-- --------------------------------------------------------
-- Host:                         10.3.12.40
-- Server Version:               8.0.12 - MySQL Community Server - GPL
-- Server Betriebssystem:        Win64
-- HeidiSQL Version:             9.5.0.5196
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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' */;

-- Exportiere Daten aus Tabelle db_am1_klein.buecher: ~0 rows (ungefähr)
DELETE FROM `buecher`;
/*!40000 ALTER TABLE `buecher` DISABLE KEYS */;
INSERT INTO `buecher` (`ISBN`, `Buchtitel`) VALUES
	('3-221-41121-2', 'Learning Englisch 5'),
	('3-221-41122-2', 'Learning Englisch 6'),
	('3-221-41123-2', 'Learning Englisch 7'),
	('3-412-02312-3', 'Grammatik'),
	('3-513-22312-4', 'Mein Deutschbuch'),
	('5-789-31521-2', 'Uebungsheft Mathemax 7'),
	('7-231-24552-3', 'Mathematik heute 5'),
	('7-231-24553-3', 'Mathematik heute 6'),
	('7-231-24554-8', 'Mathematik heute 7');
/*!40000 ALTER TABLE `buecher` ENABLE KEYS */;

-- Exportiere Daten aus Tabelle db_am1_klein.klassen: ~0 rows (ungefähr)
DELETE FROM `klassen`;
/*!40000 ALTER TABLE `klassen` DISABLE KEYS */;
INSERT INTO `klassen` (`Klassenname`, `Klassenlehrer`) VALUES
	('5a', 'Albrecht'),
	('5b', 'Brescher'),
	('6a', 'Hingsen'),
	('6b', 'Ingold'),
	('7a', 'Laurach'),
	('7b', 'Schmidt'),
	('7c', 'Lempel');
/*!40000 ALTER TABLE `klassen` ENABLE KEYS */;

-- Exportiere Daten aus Tabelle db_am1_klein.leihgabe: ~0 rows (ungefähr)
DELETE FROM `leihgabe`;
/*!40000 ALTER TABLE `leihgabe` DISABLE KEYS */;
INSERT INTO `leihgabe` (`Schuelernummer`, `Leihnummer`, `ISBN`) VALUES
	(13, 45, '3-221-41121-2'),
	(14, 48, '3-221-41121-2'),
	(15, 52, '3-221-41121-2'),
	(16, 55, '3-221-41121-2'),
	(17, 59, '3-221-41121-2'),
	(18, 62, '3-221-41121-2'),
	(7, 26, '3-221-41122-2'),
	(8, 29, '3-221-41122-2'),
	(9, 33, '3-221-41122-2'),
	(10, 36, '3-221-41122-2'),
	(11, 40, '3-221-41122-2'),
	(12, 43, '3-221-41122-2'),
	(1, 3, '3-221-41123-2'),
	(2, 6, '3-221-41123-2'),
	(3, 10, '3-221-41123-2'),
	(4, 14, '3-221-41123-2'),
	(5, 18, '3-221-41123-2'),
	(6, 21, '3-221-41123-2'),
	(1, 1, '3-412-02312-3'),
	(3, 8, '3-412-02312-3'),
	(5, 16, '3-412-02312-3'),
	(7, 23, '3-412-02312-3'),
	(9, 30, '3-412-02312-3'),
	(11, 37, '3-412-02312-3'),
	(13, 44, '3-412-02312-3'),
	(15, 51, '3-412-02312-3'),
	(17, 58, '3-412-02312-3'),
	(1, 2, '3-513-22312-4'),
	(2, 5, '3-513-22312-4'),
	(3, 9, '3-513-22312-4'),
	(4, 13, '3-513-22312-4'),
	(5, 17, '3-513-22312-4'),
	(6, 20, '3-513-22312-4'),
	(7, 25, '3-513-22312-4'),
	(8, 28, '3-513-22312-4'),
	(9, 32, '3-513-22312-4'),
	(10, 35, '3-513-22312-4'),
	(11, 39, '3-513-22312-4'),
	(12, 42, '3-513-22312-4'),
	(13, 47, '3-513-22312-4'),
	(14, 50, '3-513-22312-4'),
	(15, 54, '3-513-22312-4'),
	(16, 57, '3-513-22312-4'),
	(17, 61, '3-513-22312-4'),
	(18, 64, '3-513-22312-4'),
	(3, 12, '5-789-31521-2'),
	(13, 46, '7-231-24552-3'),
	(14, 49, '7-231-24552-3'),
	(15, 53, '7-231-24552-3'),
	(16, 56, '7-231-24552-3'),
	(17, 60, '7-231-24552-3'),
	(18, 63, '7-231-24552-3'),
	(7, 24, '7-231-24553-3'),
	(8, 27, '7-231-24553-3'),
	(9, 31, '7-231-24553-3'),
	(10, 34, '7-231-24553-3'),
	(11, 38, '7-231-24553-3'),
	(12, 41, '7-231-24553-3'),
	(1, 4, '7-231-24554-8'),
	(2, 7, '7-231-24554-8'),
	(3, 11, '7-231-24554-8'),
	(4, 15, '7-231-24554-8'),
	(5, 19, '7-231-24554-8'),
	(6, 22, '7-231-24554-8');
/*!40000 ALTER TABLE `leihgabe` ENABLE KEYS */;

-- Exportiere Daten aus Tabelle db_am1_klein.schueler: ~0 rows (ungefähr)
DELETE FROM `schueler`;
/*!40000 ALTER TABLE `schueler` DISABLE KEYS */;
INSERT INTO `schueler` (`Schuelernummer`, `Name`, `Vorname`, `Strasse`, `PLZ`, `Ort`, `Klassenname`) VALUES
	(1, 'Hilger', 'Simone', 'Seifenweg 5', '45300', 'Bankhofen', '7a'),
	(2, 'Kruschwitz', 'Tolga', 'Ingwerstrasse 53', '45300', 'Bankhofen', '7b'),
	(3, 'Kaplan', 'Heike', 'Kirchgasse 1', '45300', 'Bankhofen', '7c'),
	(4, 'Prinz', 'Jochen', 'Am Berg 12a', '45300', 'Bankhofen', '7b'),
	(5, 'Kaplan', 'Torsten', 'Kirchgasse 1', '45300', 'Bankhofen', '7c'),
	(6, 'Morman', 'Moriz', 'Ullinger Weg 2', '45300', 'Bankhofen', '7b'),
	(7, 'Abrasi', 'Tino', 'Falkenweg 9', '45300', 'Bankhofen', '6a'),
	(8, 'Zurren', 'Dina', 'Am Dorn 4', '45300', 'Bankhofen', '6b'),
	(9, 'Brentano', 'Luigi', 'Beim Italiener 3', '45300', 'Bankhofen', '6a'),
	(10, 'Engemann', 'Jasmin', 'Kuppersweg 8', '45300', 'Bankhofen', '6b'),
	(11, 'Chiong', 'Na Hu', 'Weiler 3', '45300', 'Bankhofen', '6a'),
	(12, 'Matras', 'Ingo', 'Trassenweg 7', '45300', 'Bankhofen', '6b'),
	(13, 'Thomas', 'Laura', 'Regener Strasse 6', '45300', 'Bankhofen', '5a'),
	(14, 'Meier', 'Konstantin', 'Am Weiher 2', '45300', 'Bankhofen', '5b'),
	(15, 'Weihershauser', 'Gerlinde', 'Hauptstrasse 4', '45300', 'Bankhofen', '5a'),
	(16, 'Onsberg', 'Karl-Heinz', 'Jupiterweg 7', '45300', 'Bankhofen', '5a'),
	(17, 'Jagoda', 'Else', 'Schulstrasse 3', '45300', 'Bankhofen', '5b'),
	(18, 'Liborius', 'Konrad', 'Steinweg 3', '45300', 'Bankhofen', '5b');
/*!40000 ALTER TABLE `schueler` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
