-- MySQL dump 10.9
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version	4.1.11-standard-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `immissionen`
--

DROP TABLE IF EXISTS `immissionen`;
CREATE TABLE `immissionen` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(18) NOT NULL default '',
  `lage` varchar(14) NOT NULL default '',
  `o3` varchar(5) NOT NULL default '',
  `no2` varchar(5) NOT NULL default '',
  `so2` varchar(5) NOT NULL default '',
  `bearbeitet` varchar(14) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `immissionen`
--


/*!40000 ALTER TABLE `immissionen` DISABLE KEYS */;
LOCK TABLES `immissionen` WRITE;
INSERT INTO `immissionen` VALUES (1,'Bern','Stadt/Strasse','96','32','-99','20050510103136'),(2,'Lausanne','Stadt/Strasse','71','39','-99','20050510103136'),(3,'Zürich','Stadt/Park','82','24','3','20050510103136'),(4,'Lugano','Stadt/Park','89','26','3','20050510103136'),(5,'Basel','Agglomeration','106','9','0','20050510103136'),(6,'Dübendorf','Agglomeration','86','20','-99','20050510103136'),(7,'Sion','Land/Autobahn','104','23','-99','20050510103136'),(8,'Härkingen','Land/Autobahn','96','26','0','20050510103136'),(9,'Payern','Land','111','8','0','20050510103136'),(10,'Tänikon','Land','96','6','-99','20050510103136'),(11,'Magadino','Land','120','12','-99','20050510103136'),(12,'Lägeren','Land/Wald','110','6','-99','20050510103136'),(13,'Chaumont','Land/Jura','106','3','0','20050510103136'),(14,'Rigi (Seebodenalp)','Land/Voralpen','102','4','0','20050510103136'),(15,'Davos','Alpen/Wald','97','2','-99','20050510103136'),(16,'Jungfraujoch','Alpen','89','-99','-99','20050510103136');
UNLOCK TABLES;
/*!40000 ALTER TABLE `immissionen` ENABLE KEYS */;

--
-- Table structure for table `nabel`
--

DROP TABLE IF EXISTS `nabel`;
CREATE TABLE `nabel` (
  `nabel_id` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `O3` char(4) default NULL,
  `NO2` char(4) default NULL,
  `SO2` char(4) default NULL,
  `pm10` char(4) default NULL,
  `inserttime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`nabel_id`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Immissions-Werte BUWAL/NABEL';

--
-- Dumping data for table `nabel`
--


/*!40000 ALTER TABLE `nabel` DISABLE KEYS */;
LOCK TABLES `nabel` WRITE;
INSERT INTO `nabel` VALUES (1,'2004-07-06','26','47',NULL,'27','2004-07-07 15:10:33'),(2,'2004-07-06','51','33',NULL,'28','2004-07-07 15:10:33'),(3,'2004-07-06','44','30','2','21','2004-07-07 12:06:29'),(4,'2004-07-06','172','24','3','35','2004-07-07 12:06:29'),(5,'2004-07-06','86','12','<1','20','2004-07-07 12:06:29'),(6,'2004-07-06','51','27',NULL,'20','2004-07-07 15:10:33'),(7,'2004-07-06','77','28',NULL,'20','2004-07-07 15:10:33'),(8,'2004-07-06','63','36','2','20','2004-07-07 12:06:29'),(9,'2004-07-06','74','8','<1','20','2004-07-07 12:06:29'),(10,'2004-07-06','62','7',NULL,'16','2004-07-07 15:10:33'),(11,'2004-07-06','153','18',NULL,'39','2004-07-07 15:10:33'),(12,'2004-07-06','74','3',NULL,NULL,'2004-07-07 15:10:49'),(13,'2004-07-06','74','4','<1','12','2004-07-07 12:06:29'),(14,'2004-07-06','47','5','<1','10','2004-07-07 12:06:29'),(15,'2004-07-06','81','4',NULL,NULL,'2004-07-07 15:10:49'),(16,'2004-07-06','79',NULL,NULL,NULL,'2004-07-07 15:10:49'),(16,'2004-07-07','85',NULL,NULL,NULL,'2004-07-07 15:45:06');
UNLOCK TABLES;
/*!40000 ALTER TABLE `nabel` ENABLE KEYS */;


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;