CREATE TABLE student(
pindex INTEGER, 
mnr INTEGER default 0, 
fb TEXT default '',
lastname TEXT default '',
firstname TEXT default '',
street TEXT default '', 
city TEXT default ''
);


INSERT INTO student  (pindex, mnr, fb, lastname, firstname, street, city)
VALUES (1,12345,'AI', 'Meier','Philipe','Langer Weg 4','Dresden');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (3, 23456,'AI', 'Schulze','Anton','Marktstraße 4','Halberstadt');

INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (4,23444,'AI', 'Thus','Anna','Feuerwehrstraße 112','Bonn');

INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (6,33333,'AI', 'Boll','Timo','Rosenweg 5a','Bonn');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (8,12323,'AI', 'Ovtcharow','Sarah','Friedrichstraße 55','Bonn');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (9,36777,'VW', 'Gemein','Rolf','Eßkamp 12','Oldenburg');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (21,32444,'AI', 'Wittig','Ute','Markstraße 4','Seesen');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (5,32555,'W', 'Meyer','Torsten','Alexandraweg 14','Darmstadt');




INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (18,13323,'AI', 'Brüderle','Jörg','Ostseestrand 15','Kiel');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (29,36557,'VW', 'Rauschke','Stefan','Kastanienallee 112','Hannover');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (41,32554,'W', 'Wittig','Anna','Harzstraße 5','Braunlage');


INSERT INTO student  (pindex, mnr, fb,lastname, firstname, street, city)
VALUES (42,32665,'VW', 'Meier','Torsten','Alexanderstraße 114','Magdeburg');
