edl21/edldata.sql

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

CREATE TABLE `DayData` (
  `TimeStamp` datetime NOT NULL,
  `zaehlerstand_in` float NOT NULL,
  `zaehlerstand_out` float NOT NULL,
  `active_in` float NOT NULL,
  `active_out` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Tabellenstruktur für Tabelle `EdlData`
--

CREATE TABLE `EdlData` (
  `TimeStamp` datetime NOT NULL,
  `Nearest5min` datetime NOT NULL,
  `zaehlerstand_in` float NOT NULL,
  `zaehlerstand_out` float NOT NULL,
  `active_in` float NOT NULL,
  `active_out` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Tabellenstruktur für Tabelle `EdlSnapshot`
--

CREATE TABLE `EdlSnapshot` (
  `TimeStamp` datetime NOT NULL,
  `Nearest5min` datetime NOT NULL,
  `zaehlerstand_in` float NOT NULL,
  `zaehlerstand_out` float NOT NULL,
  `active_in` float NOT NULL,
  `active_out` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indizes der exportierten Tabellen
--

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

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

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