major error in german zipcode-table and zipcodes-table in general

I'm using zipcodes.de.mysql which is shipped by the location module
I was wondered why all my locations entered were not shown on the map (or on the false place)
So I investigated the problem and read the comments at this mysql-file
but as I saw the comments do not fit in any way to the data provided

But the major problem is that the the long and lat cols are shifted!

INSERT INTO zipcodes VALUES ('81927','München','BY','11.637324','48.160068',1,1,'de');

compared with the table scheme:

CREATE TABLE zipcodes (
  zip varchar(16) NOT NULL default '0',
  city varchar(30) NOT NULL default '',
  state varchar(30) NOT NULL default '',
  latitude decimal(10,6) NOT NULL default '0.000000',
  longitude decimal(10,6) NOT NULL default '0.000000',
  timezone tinyint(2) NOT NULL default '0',
  dst tinyint(1) NOT NULL default '0',
  country char(2) default '',
  PRIMARY KEY (zip),
  KEY pc (country, zip),
  KEY zip (zip),
  KEY latitude (latitude),
  KEY longitude (longitude),
  KEY country (country)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

this means 48.160068 is the value for the longitude which is not correct because this is the latitude!
compared this with the coordinates provided by wikipedia:
(see right box) http://en.wikipedia.org/wiki/Munich

I hope someone is able to regenerate this table in a proper way...

btw: phpmyadmin tells a lot of errors if you look at the table definitons
index set more than once to a specific column and this column is a primary key at the same time (I'm talking about zip)