[vz-users] Web-Frontend Darstellung

[Michael Wulz]

Am 03.09.14 08:13, schrieb Andreas Götz:
> Wenn er kwh liefert (nicht kw?!) dann wäre electric meter korrekt (=CounterInterpreter intern).
hab ich gesetzt...

Datenbank anbei

lg


> 
> Wenn uns nix einfällt schick mir einfach mal eine Kopie der DB...
> 
> Viele Grüße, Andreas


-------------- next part --------------
-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb2+deb7u1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 03. Sep 2014 um 06:47
-- Server Version: 5.5.38
-- PHP-Version: 5.4.4-14+deb7u14

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `volkszaehler`
--

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

--
-- Tabellenstruktur für Tabelle `aggregate`
--

CREATE TABLE IF NOT EXISTS `aggregate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_id` int(11) DEFAULT NULL,
  `type` smallint(6) NOT NULL,
  `timestamp` bigint(20) NOT NULL,
  `value` double NOT NULL,
  `count` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ts_uniq` (`channel_id`,`type`,`timestamp`),
  KEY `IDX_B77949FF72F5A1AA` (`channel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `data`
--

CREATE TABLE IF NOT EXISTS `data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_id` int(11) DEFAULT NULL,
  `timestamp` bigint(20) NOT NULL,
  `value` double NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ts_uniq` (`channel_id`,`timestamp`),
  KEY `IDX_ADF3F36372F5A1AA` (`channel_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=747 ;

--
-- Daten für Tabelle `data`
--

INSERT INTO `data` (`id`, `channel_id`, `timestamp`, `value`) VALUES
(17, 1, 1409654139931, 4347),
(18, 1, 1409654239606, 4347),
(19, 1, 1409654339191, 4347),
(20, 1, 1409654438821, 4347),
(21, 1, 1409654538580, 4347),
(22, 1, 1409654638267, 4347),
(23, 1, 1409654737877, 4347),
(24, 1, 1409654837467, 4347),
(25, 1, 1409654937143, 4347),
(26, 1, 1409655036794, 4347),
(27, 1, 1409655136413, 4347),
(28, 1, 1409655236108, 4347),
(29, 1, 1409655335736, 4347),
(30, 1, 1409655435369, 4347),
(31, 1, 1409655535044, 4347),
(32, 1, 1409655634698, 4347),
(33, 1, 1409655734315, 4347),
(34, 1, 1409655834000, 4347),
(35, 1, 1409655933638, 4347),
(36, 1, 1409656033310, 4347.1),
(37, 1, 1409656132956, 4347.1),
(38, 1, 1409656232600, 4347.1),
(39, 1, 1409656332216, 4347.1),
(40, 1, 1409656431854, 4347.1),
(41, 1, 1409656531458, 4347.1),
(42, 1, 1409656631072, 4347.1),
(43, 1, 1409656730767, 4347.1),
(44, 1, 1409656830403, 4347.1),
(45, 1, 1409656930018, 4347.1),
(46, 1, 1409657029703, 4347.1),
(47, 1, 1409657129354, 4347.1),
(48, 1, 1409657228943, 4347.1),
(49, 1, 1409657328559, 4347.1),
(50, 1, 1409657428254, 4347.1),
(51, 1, 1409657527970, 4347.1),
(52, 1, 1409657627615, 4347.1),
(53, 1, 1409657727249, 4347.1),
(54, 1, 1409657826845, 4347.1),
(55, 1, 1409657926471, 4347.1),
(56, 1, 1409658026188, 4347.1),
(57, 1, 1409658125831, 4347.1),
(58, 1, 1409658225517, 4347.2),
(59, 1, 1409658325141, 4347.2),
(60, 1, 1409658424776, 4347.2),
(61, 1, 1409658524463, 4347.2),
(62, 1, 1409658624108, 4347.2),
(63, 1, 1409658723734, 4347.2),
(64, 1, 1409658823417, 4347.2),
(65, 1, 1409658923069, 4347.2),
(66, 1, 1409659022679, 4347.2),
(67, 1, 1409659122415, 4347.2),
(68, 1, 1409659222013, 4347.2),
(69, 1, 1409659321635, 4347.2),
(70, 1, 1409659421369, 4347.2),
(71, 1, 1409659520997, 4347.2),
(72, 1, 1409659620630, 4347.2),
(73, 1, 1409659720276, 4347.2),
(74, 1, 1409659819915, 4347.2),
(75, 1, 1409659919507, 4347.2),
(76, 1, 1409660019121, 4347.2),
(77, 1, 1409660118756, 4347.2),
(78, 1, 1409660218331, 4347.2),
(79, 1, 1409660317918, 4347.2),
(80, 1, 1409660417562, 4347.2),
(81, 1, 1409660517238, 4347.2),
(82, 1, 1409660616887, 4347.3),
(83, 1, 1409660716569, 4347.3),
(84, 1, 1409660816194, 4347.3),
(85, 1, 1409660915843, 4347.3),
(86, 1, 1409661015454, 4347.3),
(87, 1, 1409661115090, 4347.3),
(88, 1, 1409661214687, 4347.3),
(89, 1, 1409661314270, 4347.3),
(90, 1, 1409661413856, 4347.3),
(91, 1, 1409661513431, 4347.3),
(92, 1, 1409661613056, 4347.3),
(93, 1, 1409661712697, 4347.3),
(94, 1, 1409661812327, 4347.3),
(95, 1, 1409661912013, 4347.3),
(96, 1, 1409662011657, 4347.3),
(97, 1, 1409662111273, 4347.3),
(98, 1, 1409662210968, 4347.3),
(99, 1, 1409662310600, 4347.3),
(100, 1, 1409662410280, 4347.3),
(101, 1, 1409662509915, 4347.3),
(102, 1, 1409662609550, 4347.3),
(103, 1, 1409662709224, 4347.3),
(104, 1, 1409662808861, 4347.3),
(105, 1, 1409662908497, 4347.3),
(106, 1, 1409663008141, 4347.3),
(107, 1, 1409663107815, 4347.4),
(108, 1, 1409663207496, 4347.4),
(109, 1, 1409663307086, 4347.4),
(110, 1, 1409663406772, 4347.4),
(111, 1, 1409663506416, 4347.4),
(112, 1, 1409663606033, 4347.4),
(113, 1, 1409663705718, 4347.4),
(114, 1, 1409663805373, 4347.4),
(115, 1, 1409663904989, 4347.4),
(116, 1, 1409664004674, 4347.4),
(117, 1, 1409664104309, 4347.4),
(118, 1, 1409664203943, 4347.4),
(119, 1, 1409664303569, 4347.4),
(120, 1, 1409664403251, 4347.4),
(121, 1, 1409664502940, 4347.4),
(122, 1, 1409664602577, 4347.4),
(123, 1, 1409664702210, 4347.4),
(124, 1, 1409664801842, 4347.4),
(125, 1, 1409664901570, 4347.4),
(126, 1, 1409665001269, 4347.4),
(127, 1, 1409665100891, 4347.4),
(128, 1, 1409665200476, 4347.4),
(129, 1, 1409665300123, 4347.4),
(130, 1, 1409665399687, 4347.4),
(131, 1, 1409665499372, 4347.5),
(132, 1, 1409665598965, 4347.5),
(133, 1, 1409665698562, 4347.5),
(134, 1, 1409665798178, 4347.5),
(135, 1, 1409665897919, 4347.5),
(136, 1, 1409665997549, 4347.5),
(137, 1, 1409666097233, 4347.5),
(138, 1, 1409666196860, 4347.5),
(139, 1, 1409666296475, 4347.5),
(140, 1, 1409666396050, 4347.5),
(141, 1, 1409666495765, 4347.5),
(142, 1, 1409666595466, 4347.5),
(143, 1, 1409666695136, 4347.5),
(144, 1, 1409666794781, 4347.5),
(145, 1, 1409666894377, 4347.5),
(146, 1, 1409666993981, 4347.5),
(147, 1, 1409667093713, 4347.5),
(148, 1, 1409667193352, 4347.5),
(149, 1, 1409667293038, 4347.5),
(150, 1, 1409667392763, 4347.5),
(151, 1, 1409667492404, 4347.5),
(152, 1, 1409667592083, 4347.5),
(153, 1, 1409667691781, 4347.5),
(154, 1, 1409667791423, 4347.6),
(155, 1, 1409667891039, 4347.6),
(156, 1, 1409667990683, 4347.6),
(157, 1, 1409668090250, 4347.6),
(158, 1, 1409668189895, 4347.6),
(159, 1, 1409668289527, 4347.6),
(160, 1, 1409668389125, 4347.6),
(161, 1, 1409668488711, 4347.6),
(162, 1, 1409668588376, 4347.6),
(163, 1, 1409668687961, 4347.6),
(164, 1, 1409668787538, 4347.6),
(165, 1, 1409668887172, 4347.6),
(166, 1, 1409668986807, 4347.6),
(167, 1, 1409669086404, 4347.6),
(168, 1, 1409669186028, 4347.6),
(169, 1, 1409669285713, 4347.6),
(170, 1, 1409669385338, 4347.6),
(171, 1, 1409669484952, 4347.6),
(172, 1, 1409669584559, 4347.6),
(173, 1, 1409669684209, 4347.6),
(174, 1, 1409669783831, 4347.6),
(175, 1, 1409669883524, 4347.6),
(176, 1, 1409669983150, 4347.6),
(177, 1, 1409670082755, 4347.7),
(178, 1, 1409670182430, 4347.7),
(179, 1, 1409670282005, 4347.7),
(180, 1, 1409670381630, 4347.7),
(181, 1, 1409670481267, 4347.7),
(182, 1, 1409670580900, 4347.7),
(183, 1, 1409670680587, 4347.7),
(184, 1, 1409670780211, 4347.7),
(185, 1, 1409670879848, 4347.7),
(186, 1, 1409670979492, 4347.7),
(187, 1, 1409671079170, 4347.7),
(188, 1, 1409671178803, 4347.7),
(189, 1, 1409671278488, 4347.7),
(190, 1, 1409671378133, 4347.7),
(191, 1, 1409671477698, 4347.7),
(192, 1, 1409671577333, 4347.7),
(193, 1, 1409671677018, 4347.7),
(194, 1, 1409671776704, 4347.7),
(195, 1, 1409671876389, 4347.7),
(196, 1, 1409671976067, 4347.7),
(197, 1, 1409672075650, 4347.7),
(198, 1, 1409672175236, 4347.7),
(199, 1, 1409672274891, 4347.7),
(200, 1, 1409672374507, 4347.7),
(201, 1, 1409672474194, 4347.7),
(202, 1, 1409672573836, 4347.8),
(203, 1, 1409672673503, 4347.8),
(204, 1, 1409672773186, 4347.8),
(205, 1, 1409672872779, 4347.8),
(206, 1, 1409672972378, 4347.8),
(207, 1, 1409673071953, 4347.8),
(208, 1, 1409673171528, 4347.8),
(209, 1, 1409673271163, 4347.8),
(210, 1, 1409673370790, 4347.8),
(211, 1, 1409673470424, 4347.8),
(212, 1, 1409673570109, 4347.8),
(213, 1, 1409673669757, 4347.8),
(214, 1, 1409673769380, 4347.8),
(215, 1, 1409673869065, 4347.8),
(216, 1, 1409673968700, 4347.8),
(217, 1, 1409674068275, 4347.8),
(218, 1, 1409674167917, 4347.8),
(219, 1, 1409674267561, 4347.8),
(220, 1, 1409674367181, 4347.8),
(221, 1, 1409674466867, 4347.8),
(222, 1, 1409674566512, 4347.8),
(223, 1, 1409674666137, 4347.8),
(224, 1, 1409674765862, 4347.8),
(225, 1, 1409674865469, 4347.9),
(226, 1, 1409674965053, 4347.9),
(227, 1, 1409675064638, 4347.9),
(228, 1, 1409675164303, 4347.9),
(229, 1, 1409675263889, 4347.9),
(230, 1, 1409675363465, 4347.9),
(231, 1, 1409675463099, 4347.9),
(232, 1, 1409675562793, 4347.9),
(233, 1, 1409675662422, 4347.9),
(234, 1, 1409675761995, 4347.9),
(235, 1, 1409675861641, 4347.9),
(236, 1, 1409675961266, 4347.9),
(237, 1, 1409676060880, 4347.9),
(238, 1, 1409676160587, 4347.9),
(239, 1, 1409676260235, 4347.9),
(240, 1, 1409676360212, 4347.9),
(241, 1, 1409676459841, 4347.9),
(242, 1, 1409676559517, 4347.9),
(243, 1, 1409676659103, 4347.9),
(244, 1, 1409676758787, 4347.9),
(245, 1, 1409676858474, 4347.9),
(246, 1, 1409676958122, 4347.9),
(247, 1, 1409677057758, 4347.9),
(248, 1, 1409677157428, 4348),
(249, 1, 1409677257055, 4348),
(250, 1, 1409677356689, 4348),
(251, 1, 1409677456375, 4348),
(252, 1, 1409677556024, 4348),
(253, 1, 1409677655615, 4348),
(254, 1, 1409677755230, 4348),
(255, 1, 1409677854955, 4348),
(256, 1, 1409677954600, 4348),
(257, 1, 1409678054276, 4348),
(258, 1, 1409678153927, 4348),
(259, 1, 1409678253517, 4348),
(260, 1, 1409678353091, 4348),
(261, 1, 1409678452683, 4348),
(262, 1, 1409678552303, 4348),
(263, 1, 1409678651929, 4348),
(264, 1, 1409678751563, 4348),
(265, 1, 1409678851309, 4348),
(266, 1, 1409678950897, 4348),
(267, 1, 1409679050519, 4348),
(268, 1, 1409679150204, 4348),
(269, 1, 1409679249829, 4348),
(270, 1, 1409679349415, 4348.1),
(271, 1, 1409679449050, 4348.1),
(272, 1, 1409679548700, 4348.1),
(273, 1, 1409679648320, 4348.1),
(274, 1, 1409679748056, 4348.1),
(275, 1, 1409679847732, 4348.1),
(276, 1, 1409679947416, 4348.1),
(277, 1, 1409680047051, 4348.1),
(278, 1, 1409680146690, 4348.1),
(279, 1, 1409680246322, 4348.1),
(280, 1, 1409680346007, 4348.1),
(281, 1, 1409680445632, 4348.1),
(282, 1, 1409680545218, 4348.1),
(283, 1, 1409680644853, 4348.1),
(284, 1, 1409680744513, 4348.1),
(285, 1, 1409680844274, 4348.1),
(286, 1, 1409680943909, 4348.1),
(287, 1, 1409681043560, 4348.1),
(288, 1, 1409681143219, 4348.1),
(289, 1, 1409681242924, 4348.1),
(290, 1, 1409681342630, 4348.1),
(291, 1, 1409681442196, 4348.2),
(292, 1, 1409681541780, 4348.2),
(293, 1, 1409681641435, 4348.2),
(294, 1, 1409681741089, 4348.2),
(295, 1, 1409681840756, 4348.2),
(296, 1, 1409681940392, 4348.2),
(297, 1, 1409682040026, 4348.2),
(298, 1, 1409682139721, 4348.2),
(299, 1, 1409682239359, 4348.2),
(300, 1, 1409682338982, 4348.2),
(301, 1, 1409682438657, 4348.2),
(302, 1, 1409682538294, 4348.3),
(303, 1, 1409682637933, 4348.3),
(304, 1, 1409682737573, 4348.3),
(305, 1, 1409682837252, 4348.3),
(306, 1, 1409682936823, 4348.3),
(307, 1, 1409683036469, 4348.3),
(308, 1, 1409683136114, 4348.3),
(309, 1, 1409683235729, 4348.3),
(310, 1, 1409683335414, 4348.3),
(311, 1, 1409683435155, 4348.3),
(312, 1, 1409683534785, 4348.3),
(313, 1, 1409683634471, 4348.3),
(314, 1, 1409683734098, 4348.3),
(315, 1, 1409683833731, 4348.3),
(316, 1, 1409683933417, 4348.3),
(317, 1, 1409684033057, 4348.3),
(318, 1, 1409684132687, 4348.4),
(319, 1, 1409684232343, 4348.4),
(320, 1, 1409684331998, 4348.4),
(321, 1, 1409684431643, 4348.4),
(322, 1, 1409684531229, 4348.4),
(323, 1, 1409684630853, 4348.4),
(324, 1, 1409684730459, 4348.4),
(325, 1, 1409684830044, 4348.4),
(326, 1, 1409684929659, 4348.4),
(327, 1, 1409685029216, 4348.4),
(328, 1, 1409685128801, 4348.4),
(329, 1, 1409685228415, 4348.4),
(330, 1, 1409685328090, 4348.4),
(331, 1, 1409685427731, 4348.4),
(332, 1, 1409685527331, 4348.4),
(333, 1, 1409685626906, 4348.4),
(334, 1, 1409685726481, 4348.4),
(335, 1, 1409685826107, 4348.4),
(336, 1, 1409685925742, 4348.5),
(337, 1, 1409686025377, 4348.5),
(338, 1, 1409686125022, 4348.5),
(339, 1, 1409686224690, 4348.5),
(340, 1, 1409686324333, 4348.5),
(341, 1, 1409686424018, 4348.5),
(342, 1, 1409686523662, 4348.5),
(343, 1, 1409686623280, 4348.5),
(344, 1, 1409686722916, 4348.5),
(345, 1, 1409686822520, 4348.5),
(346, 1, 1409686922134, 4348.5),
(347, 1, 1409687021820, 4348.5),
(348, 1, 1409687121475, 4348.5),
(349, 1, 1409687221181, 4348.5),
(350, 1, 1409687320865, 4348.5),
(351, 1, 1409687420504, 4348.5),
(352, 1, 1409687520137, 4348.5),
(353, 1, 1409687619822, 4348.5),
(354, 1, 1409687719446, 4348.5),
(355, 1, 1409687819088, 4348.5),
(356, 1, 1409687918767, 4348.5),
(357, 1, 1409688018407, 4348.6),
(358, 1, 1409688118037, 4348.6),
(359, 1, 1409688217723, 4348.6),
(360, 1, 1409688317351, 4348.6),
(361, 1, 1409688417043, 4348.6),
(362, 1, 1409688516668, 4348.6),
(363, 1, 1409688616309, 4348.6),
(364, 1, 1409688715938, 4348.6),
(365, 1, 1409688815683, 4348.6),
(366, 1, 1409688915351, 4348.6),
(367, 1, 1409689014935, 4348.6),
(368, 1, 1409689114570, 4348.6),
(369, 1, 1409689214206, 4348.6),
(370, 1, 1409689313841, 4348.6),
(371, 1, 1409689413526, 4348.6),
(372, 1, 1409689513163, 4348.6),
(373, 1, 1409689612795, 4348.6),
(374, 1, 1409689712472, 4348.6),
(375, 1, 1409689812108, 4348.6),
(376, 1, 1409689911746, 4348.7),
(377, 1, 1409690011428, 4348.7),
(378, 1, 1409690111074, 4348.7),
(379, 1, 1409690210697, 4348.7),
(380, 1, 1409690310383, 4348.7),
(381, 1, 1409690410010, 4348.7),
(382, 1, 1409690509593, 4348.7),
(383, 1, 1409690609233, 4348.7),
(384, 1, 1409690708884, 4348.7),
(385, 1, 1409690808460, 4348.7),
(386, 1, 1409690908075, 4348.7),
(387, 1, 1409691007730, 4348.7),
(388, 1, 1409691107305, 4348.7),
(389, 1, 1409691206896, 4348.7),
(390, 1, 1409691306516, 4348.7),
(391, 1, 1409691406201, 4348.7),
(392, 1, 1409691505849, 4348.7),
(393, 1, 1409691605412, 4348.7),
(394, 1, 1409691705047, 4348.7),
(395, 1, 1409691804702, 4348.8),
(396, 1, 1409691904298, 4348.8),
(397, 1, 1409692003913, 4348.8),
(398, 1, 1409692103628, 4348.8),
(399, 1, 1409692203212, 4348.8),
(400, 1, 1409692302799, 4348.8),
(401, 1, 1409692402384, 4348.8),
(402, 1, 1409692502019, 4348.8),
(403, 1, 1409692601658, 4348.8),
(404, 1, 1409692701290, 4348.8),
(405, 1, 1409692800975, 4348.8),
(406, 1, 1409692900702, 4348.8),
(407, 1, 1409693000286, 4348.8),
(408, 1, 1409693099921, 4348.8),
(409, 1, 1409693199561, 4348.8),
(410, 1, 1409693299191, 4348.8),
(411, 1, 1409693398876, 4348.8),
(412, 1, 1409693498512, 4348.8),
(413, 1, 1409693598146, 4348.9),
(414, 1, 1409693697832, 4348.9),
(415, 1, 1409693797466, 4348.9),
(416, 1, 1409693897093, 4348.9),
(417, 1, 1409693996728, 4348.9),
(418, 1, 1409694096405, 4348.9),
(419, 1, 1409694196047, 4348.9),
(420, 1, 1409694295724, 4348.9),
(421, 1, 1409694395379, 4348.9),
(422, 1, 1409694495064, 4348.9),
(423, 1, 1409694594679, 4348.9),
(424, 1, 1409694694335, 4348.9),
(425, 1, 1409694793949, 4348.9),
(426, 1, 1409694893638, 4348.9),
(427, 1, 1409694993262, 4348.9),
(428, 1, 1409695092904, 4348.9),
(429, 1, 1409695192581, 4348.9),
(430, 1, 1409695292220, 4348.9),
(431, 1, 1409695391851, 4349),
(432, 1, 1409695491537, 4349),
(433, 1, 1409695591165, 4349),
(434, 1, 1409695690806, 4349),
(435, 1, 1409695790543, 4349),
(436, 1, 1409695890167, 4349),
(437, 1, 1409695989754, 4349),
(438, 1, 1409696089438, 4349),
(439, 1, 1409696189074, 4349),
(440, 1, 1409696288659, 4349),
(441, 1, 1409696388334, 4349),
(442, 1, 1409696487936, 4349),
(443, 1, 1409696587526, 4349),
(444, 1, 1409696687190, 4349),
(445, 1, 1409696786876, 4349),
(446, 1, 1409696886570, 4349),
(447, 1, 1409696986297, 4349),
(448, 1, 1409697085972, 4349),
(449, 1, 1409697185607, 4349.1),
(450, 1, 1409697285241, 4349.1),
(451, 1, 1409697384879, 4349.1),
(452, 1, 1409697484511, 4349.1),
(453, 1, 1409697584199, 4349.1),
(454, 1, 1409697683824, 4349.1),
(455, 1, 1409697783458, 4349.1),
(456, 1, 1409697883103, 4349.1),
(457, 1, 1409697982690, 4349.1),
(458, 1, 1409698082284, 4349.1),
(459, 1, 1409698181899, 4349.1),
(460, 1, 1409698281593, 4349.1),
(461, 1, 1409698381263, 4349.2),
(462, 1, 1409698480945, 4349.2),
(463, 1, 1409698580600, 4349.2),
(464, 1, 1409698680185, 4349.2),
(465, 1, 1409698779760, 4349.2),
(466, 1, 1409698879335, 4349.2),
(467, 1, 1409698978960, 4349.2),
(468, 1, 1409699078602, 4349.2),
(469, 1, 1409699178231, 4349.2),
(470, 1, 1409699277928, 4349.2),
(471, 1, 1409699377554, 4349.2),
(472, 1, 1409699477186, 4349.2),
(473, 1, 1409699576864, 4349.2),
(474, 1, 1409699676499, 4349.2),
(475, 1, 1409699776093, 4349.2),
(476, 1, 1409699875768, 4349.2),
(477, 1, 1409699975368, 4349.2),
(478, 1, 1409700074995, 4349.2),
(479, 1, 1409700174674, 4349.2),
(480, 1, 1409700274300, 4349.3),
(481, 1, 1409700373934, 4349.3),
(482, 1, 1409700473621, 4349.3),
(483, 1, 1409700573271, 4349.3),
(484, 1, 1409700672891, 4349.3),
(485, 1, 1409700772575, 4349.3),
(486, 1, 1409700872201, 4349.3),
(487, 1, 1409700971837, 4349.3),
(488, 1, 1409701071532, 4349.3),
(489, 1, 1409701171254, 4349.3),
(490, 1, 1409701270891, 4349.3),
(491, 1, 1409701370547, 4349.3),
(492, 1, 1409701470423, 4349.3),
(493, 1, 1409701570213, 4349.3),
(494, 1, 1409701669872, 4349.3),
(495, 1, 1409701769589, 4349.3),
(496, 1, 1409701869253, 4349.3),
(497, 1, 1409701968818, 4349.3),
(498, 1, 1409702068464, 4349.3),
(499, 1, 1409702168099, 4349.4),
(500, 1, 1409702267724, 4349.4),
(501, 1, 1409702367409, 4349.4),
(502, 1, 1409702467050, 4349.4),
(503, 1, 1409702566682, 4349.4),
(504, 1, 1409702666336, 4349.4),
(505, 1, 1409702765930, 4349.4),
(506, 1, 1409702865606, 4349.4),
(507, 1, 1409702965312, 4349.4),
(508, 1, 1409703064962, 4349.4),
(509, 1, 1409703164581, 4349.4),
(510, 1, 1409703264266, 4349.4),
(511, 1, 1409703363919, 4349.4),
(512, 1, 1409703463577, 4349.4),
(513, 1, 1409703563225, 4349.4),
(514, 1, 1409703662898, 4349.4),
(515, 1, 1409703762483, 4349.4),
(516, 1, 1409703862228, 4349.4),
(517, 1, 1409703961896, 4349.4),
(518, 1, 1409704061510, 4349.4),
(519, 1, 1409704161124, 4349.4),
(520, 1, 1409704260751, 4349.4),
(521, 1, 1409704360384, 4349.5),
(522, 1, 1409704460070, 4349.5),
(523, 1, 1409704559707, 4349.5),
(524, 1, 1409704659340, 4349.5),
(525, 1, 1409704759025, 4349.5),
(526, 1, 1409704858661, 4349.5),
(527, 1, 1409704958286, 4349.5),
(528, 1, 1409705057931, 4349.5),
(529, 1, 1409705157610, 4349.5),
(530, 1, 1409705257243, 4349.5),
(531, 1, 1409705356926, 4349.5),
(532, 1, 1409705456652, 4349.5),
(533, 1, 1409705556238, 4349.5),
(534, 1, 1409705655883, 4349.5),
(535, 1, 1409705755523, 4349.5),
(536, 1, 1409705855143, 4349.5),
(537, 1, 1409705954779, 4349.5),
(538, 1, 1409706054364, 4349.5),
(539, 1, 1409706153999, 4349.5),
(540, 1, 1409706253681, 4349.6),
(541, 1, 1409706353408, 4349.6),
(542, 1, 1409706453045, 4349.6),
(543, 1, 1409706552730, 4349.6),
(544, 1, 1409706652366, 4349.6),
(545, 1, 1409706751940, 4349.6),
(546, 1, 1409706851587, 4349.6),
(547, 1, 1409706951220, 4349.6),
(548, 1, 1409707050816, 4349.6),
(549, 1, 1409707150433, 4349.6),
(550, 1, 1409707250157, 4349.6),
(551, 1, 1409707349752, 4349.6),
(552, 1, 1409707449387, 4349.6),
(553, 1, 1409707549042, 4349.6),
(554, 1, 1409707648628, 4349.6),
(555, 1, 1409707748283, 4349.6),
(556, 1, 1409707847859, 4349.6),
(557, 1, 1409707947504, 4349.6),
(558, 1, 1409708047138, 4349.6),
(559, 1, 1409708146764, 4349.6),
(560, 1, 1409708246419, 4349.7),
(561, 1, 1409708346106, 4349.7),
(562, 1, 1409708445791, 4349.7),
(563, 1, 1409708545415, 4349.7),
(564, 1, 1409708645061, 4349.7),
(565, 1, 1409708744675, 4349.7),
(566, 1, 1409708844340, 4349.7),
(567, 1, 1409708944021, 4349.7),
(568, 1, 1409709043680, 4349.7),
(569, 1, 1409709143306, 4349.7),
(570, 1, 1409709242943, 4349.7),
(571, 1, 1409709342528, 4349.7),
(572, 1, 1409709442152, 4349.7),
(573, 1, 1409709541787, 4349.7),
(574, 1, 1409709641403, 4349.7),
(575, 1, 1409709741077, 4349.7),
(576, 1, 1409709840855, 4349.7),
(577, 1, 1409709940478, 4349.7),
(578, 1, 1409710040153, 4349.7),
(579, 1, 1409710139841, 4349.7),
(580, 1, 1409710239474, 4349.8),
(581, 1, 1409710339109, 4349.8),
(582, 1, 1409710438748, 4349.8),
(583, 1, 1409710538379, 4349.8),
(584, 1, 1409710638064, 4349.8),
(585, 1, 1409710737692, 4349.8),
(586, 1, 1409710837335, 4349.8),
(587, 1, 1409710937010, 4349.8),
(588, 1, 1409711036650, 4349.8),
(589, 1, 1409711136247, 4349.8),
(590, 1, 1409711235866, 4349.8),
(591, 1, 1409711335492, 4349.8),
(592, 1, 1409711435138, 4349.8),
(593, 1, 1409711534827, 4349.8),
(594, 1, 1409711634462, 4349.8),
(595, 1, 1409711734052, 4349.8),
(596, 1, 1409711833668, 4349.9),
(597, 1, 1409711933393, 4349.9),
(598, 1, 1409712033038, 4349.9),
(599, 1, 1409712132715, 4349.9),
(600, 1, 1409712232357, 4349.9),
(601, 1, 1409712331954, 4349.9),
(602, 1, 1409712431569, 4349.9),
(603, 1, 1409712531306, 4349.9),
(604, 1, 1409712630941, 4349.9),
(605, 1, 1409712730625, 4349.9),
(606, 1, 1409712830251, 4349.9),
(607, 1, 1409712929855, 4349.9),
(608, 1, 1409713029471, 4349.9),
(609, 1, 1409713129197, 4349.9),
(610, 1, 1409713228781, 4349.9),
(611, 1, 1409713328426, 4349.9),
(612, 1, 1409713428103, 4349.9),
(613, 1, 1409713527787, 4349.9),
(614, 1, 1409713627542, 4349.9),
(615, 1, 1409713727228, 4349.9),
(616, 1, 1409713826843, 4349.9),
(617, 1, 1409713926532, 4349.9),
(618, 1, 1409714026172, 4350),
(619, 1, 1409714125790, 4350),
(620, 1, 1409714225474, 4350),
(621, 1, 1409714325113, 4350),
(622, 1, 1409714424804, 4350),
(623, 1, 1409714524430, 4350),
(624, 1, 1409714624055, 4350),
(625, 1, 1409714723697, 4350),
(626, 1, 1409714823376, 4350),
(627, 1, 1409714923025, 4350),
(628, 1, 1409715022645, 4350),
(629, 1, 1409715122331, 4350),
(630, 1, 1409715221967, 4350),
(631, 1, 1409715321542, 4350),
(632, 1, 1409715421198, 4350),
(633, 1, 1409715520812, 4350.1),
(634, 1, 1409715620448, 4350.1),
(635, 1, 1409715720135, 4350.1),
(636, 1, 1409715819768, 4350.1),
(637, 1, 1409715919403, 4350.1),
(638, 1, 1409716019089, 4350.1),
(639, 1, 1409716118715, 4350.1),
(640, 1, 1409716218349, 4350.1),
(641, 1, 1409716318035, 4350.1),
(642, 1, 1409716417681, 4350.1),
(643, 1, 1409716517305, 4350.1),
(644, 1, 1409716616980, 4350.1),
(645, 1, 1409716716616, 4350.1),
(646, 1, 1409716816231, 4350.1),
(647, 1, 1409716915846, 4350.1),
(648, 1, 1409717015489, 4350.1),
(649, 1, 1409717115106, 4350.1),
(650, 1, 1409717214732, 4350.1),
(651, 1, 1409717314318, 4350.1),
(652, 1, 1409717413961, 4350.1),
(653, 1, 1409717513592, 4350.1),
(654, 1, 1409717613222, 4350.1),
(655, 1, 1409717712915, 4350.2),
(656, 1, 1409717812545, 4350.2),
(657, 1, 1409717912188, 4350.2),
(658, 1, 1409718011853, 4350.2),
(659, 1, 1409718111488, 4350.2),
(660, 1, 1409718211124, 4350.2),
(661, 1, 1409718310769, 4350.2),
(662, 1, 1409718410536, 4350.2),
(663, 1, 1409718510120, 4350.2),
(664, 1, 1409718609765, 4350.2),
(665, 1, 1409718709399, 4350.2),
(666, 1, 1409718809025, 4350.2),
(667, 1, 1409718908661, 4350.2),
(668, 1, 1409719008261, 4350.2),
(669, 1, 1409719107882, 4350.2),
(670, 1, 1409719207568, 4350.2),
(671, 1, 1409719307218, 4350.2),
(672, 1, 1409719406827, 4350.2),
(673, 1, 1409719506512, 4350.3),
(674, 1, 1409719606244, 4350.3),
(675, 1, 1409719705843, 4350.3),
(676, 1, 1409719805478, 4350.3),
(677, 1, 1409719905120, 4350.3),
(678, 1, 1409720004729, 4350.3),
(679, 1, 1409720104464, 4350.3),
(680, 1, 1409720204146, 4350.3),
(681, 1, 1409720303784, 4350.3),
(682, 1, 1409720403469, 4350.3),
(683, 1, 1409720503124, 4350.3),
(684, 1, 1409720602779, 4350.3),
(685, 1, 1409720702365, 4350.3),
(686, 1, 1409720801975, 4350.3),
(687, 1, 1409720901557, 4350.4),
(688, 1, 1409721001141, 4350.4),
(689, 1, 1409721100806, 4350.4),
(690, 1, 1409721200381, 4350.4),
(691, 1, 1409721299968, 4350.4),
(692, 1, 1409721399602, 4350.4),
(693, 1, 1409721499287, 4350.4),
(694, 1, 1409721598926, 4350.4),
(695, 1, 1409721698518, 4350.4),
(696, 1, 1409721798145, 4350.4),
(697, 1, 1409721897778, 4350.4),
(698, 1, 1409721997412, 4350.4),
(699, 1, 1409722097090, 4350.4),
(700, 1, 1409722196739, 4350.4),
(701, 1, 1409722296329, 4350.4),
(702, 1, 1409722395944, 4350.4),
(703, 1, 1409722495670, 4350.4),
(704, 1, 1409722595314, 4350.4),
(705, 1, 1409722694990, 4350.5),
(706, 1, 1409722794632, 4350.5),
(707, 1, 1409722894241, 4350.5),
(708, 1, 1409722993916, 4350.5),
(709, 1, 1409723093581, 4350.5),
(710, 1, 1409723193206, 4350.5),
(711, 1, 1409723292892, 4350.5),
(712, 1, 1409723392537, 4350.5),
(713, 1, 1409723492132, 4350.5),
(714, 1, 1409723591749, 4350.5),
(715, 1, 1409723691473, 4350.5),
(716, 1, 1409723791058, 4350.5),
(717, 1, 1409723890703, 4350.5),
(718, 1, 1409723990378, 4350.5),
(719, 1, 1409724090064, 4350.5),
(720, 1, 1409724189809, 4350.5),
(721, 1, 1409724289475, 4350.5),
(722, 1, 1409724389121, 4350.5),
(723, 1, 1409724488805, 4350.6),
(724, 1, 1409724588530, 4350.6),
(725, 1, 1409724688115, 4350.6),
(726, 1, 1409724787751, 4350.6),
(727, 1, 1409724887407, 4350.6),
(728, 1, 1409724987021, 4350.6),
(729, 1, 1409725086706, 4350.6),
(730, 1, 1409725186332, 4350.6),
(731, 1, 1409725285967, 4350.6),
(732, 1, 1409725385652, 4350.6),
(733, 1, 1409725485301, 4350.6),
(734, 1, 1409725584922, 4350.6),
(735, 1, 1409725684608, 4350.6),
(736, 1, 1409725784235, 4350.6),
(737, 1, 1409725883838, 4350.6),
(738, 1, 1409725983523, 4350.6),
(739, 1, 1409726083203, 4350.6),
(740, 1, 1409726182823, 4350.6),
(741, 1, 1409726282509, 4350.6),
(742, 1, 1409726382145, 4350.6),
(743, 1, 1409726481778, 4350.6),
(744, 1, 1409726581464, 4350.7),
(745, 1, 1409726681096, 4350.7),
(746, 1, 1409726780726, 4350.7);

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

--
-- Tabellenstruktur für Tabelle `entities`
--

CREATE TABLE IF NOT EXISTS `entities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_50EC64E5D17F50A6` (`uuid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `entities`
--

INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES
(1, 'a02ea060-1e18-11e4-a178-5be9227ad291', 'electric meter', 'channel');

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

--
-- Tabellenstruktur für Tabelle `entities_in_aggregator`
--

CREATE TABLE IF NOT EXISTS `entities_in_aggregator` (
  `parent_id` int(11) NOT NULL,
  `child_id` int(11) NOT NULL,
  PRIMARY KEY (`parent_id`,`child_id`),
  KEY `IDX_2BD88468727ACA70` (`parent_id`),
  KEY `IDX_2BD88468DD62C21B` (`child_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Tabellenstruktur für Tabelle `properties`
--

CREATE TABLE IF NOT EXISTS `properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) DEFAULT NULL,
  `pkey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_keys` (`entity_id`,`pkey`),
  KEY `IDX_87C331C781257D5D` (`entity_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Daten für Tabelle `properties`
--

INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES
(1, 1, 'title', 'Strom-Michael'),
(2, 1, 'resolution', '1'),
(3, 1, 'public', '1'),
(4, 1, 'color', 'red'),
(5, 1, 'style', 'steps'),
(6, 1, 'fillstyle', '0'),
(7, 1, 'yaxis', 'auto');

--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `aggregate`
--
ALTER TABLE `aggregate`
  ADD CONSTRAINT `FK_B77949FF72F5A1AA` FOREIGN KEY (`channel_id`) REFERENCES `entities` (`id`);

--
-- Constraints der Tabelle `data`
--
ALTER TABLE `data`
  ADD CONSTRAINT `FK_ADF3F36372F5A1AA` FOREIGN KEY (`channel_id`) REFERENCES `entities` (`id`);

--
-- Constraints der Tabelle `entities_in_aggregator`
--
ALTER TABLE `entities_in_aggregator`
  ADD CONSTRAINT `FK_2BD88468727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `entities` (`id`),
  ADD CONSTRAINT `FK_2BD88468DD62C21B` FOREIGN KEY (`child_id`) REFERENCES `entities` (`id`);

--
-- Constraints der Tabelle `properties`
--
ALTER TABLE `properties`
  ADD CONSTRAINT `FK_87C331C781257D5D` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;