CREATE TABLE `steuern_kanton` ( `kantonID` varchar(2) NOT NULL, -- approx 5 float fields PRIMARY KEY (`kantonID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `bezirk` ( `bezirkID` int(4) NOT NULL, `bezirknamede` varchar(40) NOT NULL, `bezirknamefr` varchar(40) NOT NULL, `bezirknameit` varchar(40) NOT NULL, `bezirknamera` varchar(40) NOT NULL, `kantonID` varchar(2) NOT NULL, PRIMARY KEY (`bezirkID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `gemeinde` ( `gemeindeID` int(4) NOT NULL, `gemeindename` varchar(40) default NULL, `aggloID` int(4) default NULL, `bezirkID` int(4) NOT NULL, PRIMARY KEY (`gemeindeID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `plz4` ( `plz4` int(4) NOT NULL, `plz2` int(2) NOT NULL, `plzname` varchar(40) NOT NULL, `gemeindeID` int(4) NOT NULL, PRIMARY KEY (`plz4`,`plz2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `steuern` ( `id` int(2) NOT NULL auto_increment, `gemeindeID` int(4) default NULL, `name` varchar(40) NOT NULL, -- approx 20 float fields PRIMARY KEY (`id`), UNIQUE KEY `gemeindeID` (`gemeindeID`) ) ENGINE=MyISAM -- AUTO_INCREMENT= DEFAULT CHARSET=latin1