dl5000/dl5000.sql

--
-- Tabellenstruktur für Tabelle `DayData`
--

CREATE TABLE `DayData` (
  `TimeStamp` datetime NOT NULL,
  `S1_Temp_Min` float NOT NULL,
  `S1_Temp_Max` float NOT NULL,
  `S2_Temp_Min` float NOT NULL,
  `S2_Temp_Max` float NOT NULL,
  `S3_Temp_Min` float NOT NULL,
  `S3_Temp_Max` float NOT NULL,
  `S4_Temp_Min` float NOT NULL,
  `S4_Temp_Max` float NOT NULL,
  `S5_Temp_Min` float NOT NULL,
  `S5_Temp_Max` float NOT NULL,
  `S6_Temp_Min` float NOT NULL,
  `S6_Temp_Max` float NOT NULL,
  `S7_Temp_Min` float NOT NULL,
  `S7_Temp_Max` float NOT NULL,
  `S8_Temp_Min` float NOT NULL,
  `S8_Temp_Max` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Tabellenstruktur für Tabelle `TempData`
--

CREATE TABLE `TempData` (
  `TimeStamp` datetime NOT NULL,
  `Nearest5min` datetime NOT NULL,
  `S1_Temp` float DEFAULT NULL,
  `S1_Humidity` float DEFAULT NULL,
  `S2_Temp` float DEFAULT NULL,
  `S2_Humidity` float DEFAULT NULL,
  `S3_Temp` float DEFAULT NULL,
  `S3_Humidity` float DEFAULT NULL,
  `S4_Temp` float DEFAULT NULL,
  `S4_Humidity` float DEFAULT NULL,
  `S5_Temp` float DEFAULT NULL,
  `S5_Humidity` float DEFAULT NULL,
  `S6_Temp` float DEFAULT NULL,
  `S6_Humidity` float DEFAULT NULL,
  `S7_Temp` float DEFAULT NULL,
  `S7_Humidity` float DEFAULT NULL,
  `S8_Temp` float DEFAULT NULL,
  `S8_Humidity` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Tabellenstruktur für Tabelle `TempSnapshot`
--

CREATE TABLE `TempSnapshot` (
  `TimeStamp` datetime NOT NULL,
  `Nearest5min` datetime NOT NULL,
  `S1_Temp` float DEFAULT NULL,
  `S1_Humidity` float DEFAULT NULL,
  `S2_Temp` float DEFAULT NULL,
  `S2_Humidity` float DEFAULT NULL,
  `S3_Temp` float DEFAULT NULL,
  `S3_Humidity` float DEFAULT NULL,
  `S4_Temp` float DEFAULT NULL,
  `S4_Humidity` float DEFAULT NULL,
  `S5_Temp` float DEFAULT NULL,
  `S5_Humidity` float DEFAULT NULL,
  `S6_Temp` float DEFAULT NULL,
  `S6_Humidity` float DEFAULT NULL,
  `S7_Temp` float DEFAULT NULL,
  `S7_Humidity` float DEFAULT NULL,
  `S8_Temp` float DEFAULT NULL,
  `S8_Humidity` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `DayData`
--
ALTER TABLE `DayData`
  ADD KEY `TimeStamp` (`TimeStamp`);

--
-- Indizes für die Tabelle `TempData`
--
ALTER TABLE `TempData`
  ADD UNIQUE KEY `TimeStamp` (`TimeStamp`);

--
-- Indizes für die Tabelle `TempSnapshot`
--
ALTER TABLE `TempSnapshot`
  ADD UNIQUE KEY `TimeStamp` (`TimeStamp`);
COMMIT;