query($sql);
$con->select_db("projektverwaltung");
$sql = "CREATE TABLE IF NOT EXISTS kunde (
ku_id INT(11) NOT NULL,
ku_name VARCHAR(30) DEFAULT NULL,
ku_ort VARCHAR(30) DEFAULT NULL,
PRIMARY KEY (ku_id)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8";
$con->query($sql);
$sql = "INSERT INTO kunde(ku_id, ku_name, ku_ort) VALUES
(1, 'Schmidt', 'Hamburg'),
(2, 'Weber', 'Frankfurt'),
(3, 'Murchel', 'Dortmund')";
$con->query($sql);
$sql = "CREATE TABLE IF NOT EXISTS projekt (
pr_id INT(11) NOT NULL,
pr_ku_id INT(11) DEFAULT NULL,
pr_bezeichnung VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (pr_id)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8";
$con->query($sql);
$sql = "INSERT INTO projekt(pr_id, pr_ku_id, pr_bezeichnung) VALUES
(1, 1, 'Alexanderstrasse'),
(2, 1, 'Peterstrasse'),
(3, 2, 'Jahnplatz'),
(4, 2, 'Lindenplatz'),
(5, 3, 'Nordbahnhof'),
(6, 3, 'Westbahnhof')";
$con->query($sql);
$sql = "CREATE TABLE IF NOT EXISTS person (
pe_id INT(11) NOT NULL,
pe_nachname VARCHAR(30) DEFAULT NULL,
pe_vorname VARCHAR(30) DEFAULT NULL,
PRIMARY KEY (pe_id)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8";
$con->query($sql);
$sql = "INSERT INTO person(pe_id, pe_nachname, pe_vorname) VALUES
(1, 'Mohr', 'Hans'),
(2, 'Berger', 'Stefan'),
(3, 'Suhren', 'Marion')";
$con->query($sql);
$sql = "CREATE TABLE IF NOT EXISTS projekt_person (
pr_id INT(11) NOT NULL,
pe_id INT(11) NOT NULL,
pp_datum DATE NOT NULL,
pp_zeit DOUBLE NOT NULL,
PRIMARY KEY (pr_id, pe_id, pp_datum)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8";
$con->query($sql);
$sql = "INSERT INTO projekt_person(pr_id, pe_id, pp_datum, pp_zeit) VALUES
(1, 1, '2019-12-01', 3.5),
(1, 3, '2019-12-01', 4),
(4, 1, '2019-12-01', 3),
(4, 2, '2019-12-01', 6.5),
(4, 2, '2019-12-02', 7.3),
(4, 3, '2019-12-01', 4)";
$con->query($sql);
$con->close();
?>