Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung | |||
wetter:ws500:datenbankdefinitionen [08.03.2011 13:09. ] – django | wetter: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> | ||
+ | -- version 2.6.3-pl1 | ||
+ | -- https:// | ||
+ | -- | ||
+ | -- Host: localhost | ||
+ | -- Erstellungszeit: | ||
+ | -- Server Version: 4.1.13 | ||
+ | -- PHP-Version: | ||
+ | |||
+ | SET AUTOCOMMIT=0; | ||
+ | START TRANSACTION; | ||
+ | |||
+ | -- | ||
+ | -- Datenbank: `wetter` | ||
+ | -- | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Tabellenstruktur für Tabelle `lastids` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `lastids` ( | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `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 ' | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `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`, | ||
+ | ) 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 ' | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `sensid` tinyint(3) unsigned default NULL, | ||
+ | `P` smallint(4) default NULL, | ||
+ | `ok` char(1) default NULL, | ||
+ | KEY `id` (`id`), | ||
+ | KEY `dataindex` (`stationid`, | ||
+ | ) 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 ' | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `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`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Tabellenstruktur für Tabelle `sensor_descr` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `sensor_descr` ( | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `sensid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `type` enum(' | ||
+ | `name` varchar(80) default NULL, | ||
+ | KEY `sensid` (`sensid`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Tabellenstruktur für Tabelle `station_descr` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `station_descr` ( | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `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 ' | ||
+ | `altitude` smallint(6) default ' | ||
+ | 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 ' | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `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`, | ||
+ | ) 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 ' | ||
+ | `stationid` tinyint(3) unsigned NOT NULL default ' | ||
+ | `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`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | |||
+ | COMMIT; | ||
+ | </ | ||
+ | |||
+ | [[wetter: | ||