INSERT INTO article VALUES ('10100101','T-Shirt Motiv "Debian"','T-Shirt aus 100% Baumwolle, 180g stark, Aufdruck per Siebdruckverfahren','',0,0,'no comment',16); INSERT INTO article VALUES ('10100102','T-Shirt Motiv "GNU"','T-Shirt aus 100% Baumwolle, 180g stark, Aufdruck per Siebdruckverfahren','',0,0,'no comment',16); INSERT INTO article VALUES ('10100103','Kaffeetasse weiß, Motiv "GNU"','Porzellantasse, 0.2l, Aufdruck per Siebdruckverfahren','',0,0,'no comment',16); INSERT INTO offer VALUES ('1010010101','10100101','Größe XS',30.0,30.0,0.5,0.1,'no comment',25,14.95); INSERT INTO offer VALUES ('1010010102','10100101','Größe S' ,30.0,30.0,0.5,0.1,'no comment',25,14.95); INSERT INTO offer VALUES ('1010010103','10100101','Größe M' ,30.0,30.0,0.5,0.1,'no comment',25,14.95); INSERT INTO offer VALUES ('1010010104','10100101','Größe L' ,30.0,30.0,0.5,0.1,'no comment',25.5,14.95); INSERT INTO offer VALUES ('1010010105','10100101','Größe XL' ,30.0,30.0,0.5,0.1,'no comment',25.5,14.95); INSERT INTO offer VALUES ('1010010201','10100102','Größe XS',30.0,30.0,0.5,0.1,'no comment',25,14.95); INSERT INTO offer VALUES ('1010010202','10100102','Größe S' ,30.0,30.0,0.5,0.1,'no comment',25,14.95); INSERT INTO offer VALUES ('1010010203','10100102','Größe M' ,30.0,30.0,0.5,0.1,'no comment',25,14.95); INSERT INTO offer VALUES ('1010010204','10100102','Größe L' ,30.0,30.0,0.5,0.1,'no comment',25.5,14.95); INSERT INTO offer VALUES ('1010010205','10100102','Größe XL' ,30.0,30.0,0.5,0.1,'no comment',25.5,14.95); INSERT INTO offer VALUES ('1010010301','10100103','1 Tasse',30.0,30.0,0.5,0.1,'no comment',9.95,8.95); INSERT INTO offer VALUES ('1010010302','10100103','6 Tassen' ,30.0,30.0,0.5,0.1,'no comment',57.95,53.70); INSERT INTO offer VALUES ('1010010303','10100103','12 Tassen' ,30.0,30.0,0.5,0.1,'no comment',110.50,107.40); INSERT INTO spool VALUES ('1010010101',10,2); INSERT INTO spool VALUES ('1010010102',20,2); INSERT INTO spool VALUES ('1010010103',34,6); INSERT INTO spool VALUES ('1010010104',34,6); INSERT INTO spool VALUES ('1010010105',34,6); INSERT INTO spool VALUES ('1010010201',10,2); INSERT INTO spool VALUES ('1010010202',20,2); INSERT INTO spool VALUES ('1010010203',34,6); INSERT INTO spool VALUES ('1010010204',0,6); INSERT INTO spool VALUES ('1010010205',4,6); INSERT INTO spool VALUES ('1010010301',10,2); INSERT INTO spool VALUES ('1010010302',20,2); INSERT INTO spool VALUES ('1010010303',3,6); INSERT INTO customer VALUES (1,'','Martin','Schulze','','Am Zollbaum 7','26129','Oldenburg','Germany','','fips'); INSERT INTO customer VALUES (2,'','Juergen','Schulze','','Dorfmark 10','26389','Wilhelmshaven','Germany','','hurz'); INSERT INTO dispatch VALUES (1,1,'Fri 04 Dec 00:00:00 1998 CET'); INSERT INTO dispatch VALUES (2,2,'Thu 03 Dec 00:00:00 1998 CET'); INSERT INTO dispatch VALUES (3,2,'Sun 06 Dec 00:00:00 1998 CET'); INSERT INTO dispatchlist VALUES (1,'1010010101',1,25.0); INSERT INTO dispatchlist VALUES (1,'1010010102',1,25.0); INSERT INTO dispatchlist VALUES (1,'1010010103',1,25.0); INSERT INTO dispatchlist VALUES (2,'1010010101',2,25.0); INSERT INTO dispatchlist VALUES (2,'1010010103',1,25.0); INSERT INTO dispatchlist VALUES (3,'1010010103',4,25.0); INSERT INTO status VALUES (1,0,'web','Fri 04 Dec 00:00:00 1998 CET'); INSERT INTO status VALUES (2,0,'web','Thu 03 Dec 00:00:00 1998 CET'); INSERT INTO status VALUES (3,0,'web','Sun 06 Dec 00:00:00 1998 CET');