ddkLswZX

1#xxx
2# Version 1.0
3
4CREATE DATABASE zeugnisverwaltung;
5USE zeugnisverwaltung;
6
7CREATE TABLE IF NOT EXISTS schueler (
8id INT(10) NOT NULL AUTO_INCREMENT,
9name CHAR(24) NOT NULL,
10vorname CHAR(24) NOT NULL,
11straße CHAR(40),
12plz INT(5),
13PRIMARY KEY (id)
14);
15
16CREATE TABLE IF NOT EXISTS noten (
17notenid INT(10) NOT NULL AUTO_INCREMENT,
18schueler_id INT(10) NOT NULL,
19fach CHAR(24) NOT NULL,
20note INT(24) NOT NULL,
21PRIMARY KEY (notenid),
22FOREIGN KEY (schueler_id) REFERENCES schueler(id)
23);