CREATE TABLE stock (
  pindex INTEGER, 
  serialkey INTEGER default 0, 
  article TEXT default '',
  supplier TEXT default '',
  count INTEGER default 0 
);

CREATE TABLE supplier (
  pindex INTEGER,
  lastname TEXT default '',
  firstname TEXT default '', 
  company TEXT default '',
  street TEXT default '', 
  city TEXT default '' 
);

CREATE TABLE customer (
  pindex INTEGER,
  lastname TEXT default '',
  firstname TEXT default '',
  street TEXT default '', 
  city TEXT default ''
);

INSERT INTO customer  (pindex, lastname, firstname, street, city)
VALUES (1, 'Meier','Philipe','Langer Weg 4','Dresden');


INSERT INTO customer  (pindex, lastname, firstname, street, city)
VALUES (3, 'Schulze','Berta','Blumenweg 5','Drübeck');

INSERT INTO customer  (pindex, lastname, firstname, street, city)
VALUES (4, 'Brandt','Willi','Feuerwehrstraße 112','Bonn');


INSERT INTO customer  (pindex, lastname, firstname, street, city)
VALUES (9, 'Schulz','Berta','Langer 15','Wernigerode');


INSERT INTO customer  (pindex, lastname, firstname, street, city)
VALUES (13, 'Schulze','Anton','Marktstraße 4','Halberstadt');
 