-- use mysql;
-- insert into user values ('%',        'xml2html',password('xml2html'), 'y','Y','y','y','y','y','y','y','y','y','y','y','y','y');
-- insert into user values ('localhost','xml2html',password('xml2html'), 'y','Y','y','y','y','y','y','y','y','y','y','y','y','y');

drop database if exists xml2html;
create database xml2html;

use xml2html;

create table person (p_id int not null auto_increment, p_vorname varchar(20), p_nachname varchar(20), p_alter int, primary key(p_id));
insert into person values(0,"gustav","krause", 34);
insert into person values(0,"egon","hahn", 45);
insert into person values(0,"karl","lehmann", 35);
insert into person values(0,"juergen","hartmann", 65);
insert into person values(0,"richard","maier", 33);
insert into person values(0,"karl","krause", 50);

create table kind (k_id int not null auto_increment, k_vorname varchar(20), k_nachname varchar(20), k_alter int, k_ort varchar (20), primary key(k_id));
insert into kind values(0,"franz","maier", 35, "hamburg");
insert into kind values(0,"petra", "lehmann", 5, "berlin");
insert into kind values(0,"thomas", "hahn", 12, "muenchen");
insert into kind values(0, "britta", "lehmann", 16, "berlin");
insert into kind values(0,"andreas", "krause", 45, "muenchen");


create table adresse (a_id int not null auto_increment, p_id int, strasse varchar(20), hausnr int, ort varchar (20), primary key(a_id));
insert into adresse values(0, 1, "hauptstrasse", 2, "wedel");
insert into adresse values(0, 2, "nebenweg", 23, "hamburg");
insert into adresse values(0, 3, "marienstrasse", 124, "muenchen");
insert into adresse values(0, 5, "nordtor", 11, "muenchen");