query("CREATE DATABASE IF NOT EXISTS firma");
$con->select_db("firma");
$sql = "CREATE TABLE IF NOT EXISTS personen (
name VARCHAR(30) DEFAULT NULL,
vorname VARCHAR(25) DEFAULT NULL,
personalnummer INT(11) NOT NULL,
gehalt DOUBLE DEFAULT NULL,
geburtstag DATE DEFAULT NULL,
PRIMARY KEY (personalnummer)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8";
$con->query($sql);
$sql = "INSERT INTO personen (name, vorname, personalnummer, gehalt, geburtstag) VALUES
('Maier', 'Hans', 6714, 3500, '1962-03-15'),
('Schmitz', 'Peter', 81343, 3750, '1958-04-12'),
('Mertens', 'Julia', 2297, 3621.5, '1959-12-30')";
$con->query($sql);
$con->close();
?>