create table `customer` (
  `PINDEX`  integer not null,
  `CNR`  integer default 0 not null unique,
  `lastname` varchar(50) default '',
  `firstname` varchar(50) default '',
  `street` varchar(50) default '',
  `birthday` varchar(10) default '',

   constraint `PK_Customer` primary key(`pindex`)
  );


  create table sequence(
    id INT not null
  );
   
 insert into sequence values(30);




Insert into customer(pindex,  cnr, lastname, firstname, street,  birthday)
Values(11, 12345, 'Meier', 'Hans', 'Friedrichstrasse 55', '2018-03-14');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(12, 54321,'Schulze', 'Susanne', 'Langgasse 4a', '2011-03-07');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(13, 234, 'Brandter', 'Torsten', 'Marktstrasse 5', '2018-03-07');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(14,42, 'Dent', 'Arthur', 'Magarethea Weg 12', '1996-08-07');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(15, 142, 'Braun', 'Werner', 'Nasa 1969', '1969-07-20');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(16, 145, 'Brandt', 'Willi', 'Kastanieallee 12a', '1971-02-10');

Insert into customer(pindex,  cnr, lastname, firstname, street,  birthday)
Values(17, 345, 'Schmitt', 'Dorethea', 'Martkstrasse 3', '2001-12-24');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(18, 11, 'Schwarzenau', 'Paul', 'Kreuzerweg 12a', '2001-04-17');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(19, 55, 'Gisin', 'Nicola', 'Springerallee 1', '1999-12-24');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(20, 123, 'Genius', 'Chantal', 'Hallenser Strasse 3', '1991-02-10');

Insert into customer(pindex,  cnr, lastname, firstname, street,  birthday)
Values(21, 77, 'Schoen', 'Jaqueline', 'Einkaufsallee 123', '1991-02-11');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(22, 14, 'Schwarz', 'Hans-Georg', 'Lange Strasse 3', '1985-06-27');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(23, 35, 'Maurer', 'Fritz', 'Handwerkerweg 5', '1979-02-29');

Insert into customer(pindex, cnr, lastname, firstname, street,  birthday)
Values(24, 113, 'Bosch', 'Hieronymus', 'Kunstweg 42', '1998-05-11');

Insert into customer(pindex,  cnr, lastname, firstname, street,  birthday)
Values(25, 57, 'Brandtner', 'Andrea', 'Rosenweg 2', '2001-02-03');