-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- https://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 08. März 2007 um 19:44
-- Server Version: 4.1.13
-- PHP-Version: 4.4.0

SET AUTOCOMMIT=0;
START TRANSACTION;

-- 
-- Datenbank: `wetter`
-- 

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `lastids`
-- 

CREATE TABLE `lastids` (
  `stationid` tinyint(3) unsigned NOT NULL default '0',
  `id_PS` int(10) unsigned default NULL,
  `id_RS` int(10) unsigned default NULL,
  `id_THS` int(10) unsigned default NULL,
  `id_WS` int(10) unsigned default NULL,
  `id_LS` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `light`
-- 

CREATE TABLE `light` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `stationid` tinyint(3) unsigned NOT NULL default '1',
  `sensid` tinyint(3) unsigned default NULL,
  `sunshine` tinyint(4) default NULL,
  `sundur` smallint(5) unsigned default NULL,
  `lux` smallint(5) unsigned default NULL,
  `factor` smallint(5) unsigned default NULL,
  `ok` char(1) default NULL,
  KEY `id` (`id`),
  KEY `dataindex` (`stationid`,`sensid`,`datetime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `pressure`
-- 

CREATE TABLE `pressure` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `stationid` tinyint(3) unsigned NOT NULL default '1',
  `sensid` tinyint(3) unsigned default NULL,
  `P` smallint(4) default NULL,
  `ok` char(1) default NULL,
  KEY `id` (`id`),
  KEY `dataindex` (`stationid`,`sensid`,`datetime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `rain`
-- 

CREATE TABLE `rain` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `stationid` tinyint(3) unsigned NOT NULL default '1',
  `sensid` tinyint(3) unsigned default NULL,
  `counter` smallint(4) unsigned default NULL,
  `diff` int(10) unsigned default NULL,
  `ok` char(1) default NULL,
  KEY `id` (`id`),
  KEY `dataindex` (`stationid`,`sensid`,`datetime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `sensor_descr`
-- 

CREATE TABLE `sensor_descr` (
  `stationid` tinyint(3) unsigned NOT NULL default '1',
  `sensid` tinyint(3) unsigned NOT NULL default '0',
  `type` enum('th','wind','rain','light','pressure') NOT NULL default 'th',
  `name` varchar(80) default NULL,
  KEY `sensid` (`sensid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `station_descr`
-- 

CREATE TABLE `station_descr` (
  `stationid` tinyint(3) unsigned NOT NULL default '0',
  `name` varchar(80) default NULL,
  `descr` varchar(80) default NULL,
  `manufacturer` varchar(80) default NULL,
  `model` varchar(80) default NULL,
  `location` varchar(80) default NULL,
  `rainbycount` smallint(5) unsigned NOT NULL default '0',
  `altitude` smallint(6) default '-1',
  KEY `stationid` (`stationid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `th_sensors`
-- 

CREATE TABLE `th_sensors` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `stationid` tinyint(3) unsigned NOT NULL default '1',
  `sensid` tinyint(3) unsigned default NULL,
  `T` float(5,1) default NULL,
  `H` tinyint(2) unsigned default NULL,
  `ok` char(1) default NULL,
  KEY `id` (`id`),
  KEY `dataindex` (`stationid`,`sensid`,`datetime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `wind`
-- 

CREATE TABLE `wind` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `stationid` tinyint(3) unsigned NOT NULL default '1',
  `sensid` tinyint(3) unsigned default NULL,
  `speed` float(5,1) default NULL,
  `angle` smallint(3) unsigned default NULL,
  `range` float(4,1) default NULL,
  `ok` char(1) default NULL,
  KEY `id` (`id`),
  KEY `dataindex` (`stationid`,`sensid`,`datetime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

COMMIT;