CREATE TABLE `_sbb_preislis` ( `Kundennumm` varchar(20) collate latin1_german2_ci NOT NULL default '', `Artikelnum` varchar(35) collate latin1_german2_ci NOT NULL default '', `Preisstaff` varchar(10) collate latin1_german2_ci NOT NULL default '', `Anzahl` decimal(13,3) NOT NULL default '0.000', `Preis1` decimal(13,3) NOT NULL default '0.000', KEY `Artikelnum` (`Artikelnum`), KEY `Preisstaff` (`Preisstaff`), KEY `Anzahl` (`Anzahl`), KEY `Preis1` (`Preis1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci; INSERT INTO `_sbb_preislis` VALUES ('', 'FL11003007', '2', 1.000, 2.340); INSERT INTO `_sbb_preislis` VALUES ('12103', 'FL11003007', '2', 1.000, 2.200); INSERT INTO `_sbb_preislis` VALUES ('', 'FL11003110', '2', 1.000, 2.780); INSERT INTO `_sbb_preislis` VALUES ('', 'FL11003117', '2', 1.000, 2.780); INSERT INTO `_sbb_preislis` VALUES ('', 'FL11003185', '2', 1.000, 2.780); INSERT INTO `_sbb_preislis` VALUES ('', 'FL11003271', '2', 1.000, 2.780); INSERT INTO `_sbb_preislis` VALUES ('', 'FL11003410', '2', 1.000, 2.780); INSERT INTO `_sbb_preislis` VALUES ('', 'FL11003901', '2', 1.000, 2.780);