marians

CREATE TABLE `stations` (
  `id` varchar(9) COLLATE latin1_general_ci NOT NULL,
  `postalcode` varchar(5) COLLATE latin1_general_ci NOT NULL,
  `name` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `longitude` decimal(5,2) NOT NULL,
  `latitude` decimal(5,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='BfS Sensor Stations';

CREATE TABLE `values_2h` (