wetter:ws500:datenbankdefinitionen

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Nächste Überarbeitung		 Vorhergehende Überarbeitung
wetter:ws500:datenbankdefinitionen [15.02.2009 20:31. ] – angelegt djangowetter:ws500:datenbankdefinitionen [31.10.2023 18:31. ] (aktuell) – Externe Bearbeitung 127.0.0.1
Zeile 1: Zeile 1:
 +====== Definitionen für die MySQL-Datenbank ======
 +Die Datenbanktabellen haben folgendes Schema:
 +<code sql MySQL-Datenbankdefinitionen>-- 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;
 +</code>
 +
 +[[wetter:ws500:start|Inhaltsverzeichnis der WS500 Beschreibung]]