INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1000, '68601c20-a822-11e5-b3c5-93a3651cb9d0', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1001, '747808f0-a829-11e5-b0a0-31a1b0d598a5', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1002, '2f77d1e0-a870-11e5-be1b-91685ef0f43e', 'valve', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1003, '14eb6130-a8ec-11e5-8540-fb8bee45a545', 'group', 'aggregator');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1004, '22b89db0-a8ec-11e5-a30a-796c6a5cc460', 'group', 'aggregator');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1005, '4da1ffd0-a8ec-11e5-be09-6175560db652', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1006, '2718d1c0-a8ed-11e5-b18c-c388741abdf5', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1007, '3991bd40-a8ed-11e5-aebb-e5c1ce445b22', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1008, '454a5d80-a8ed-11e5-993c-d9834ff4784a', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1009, '51940780-a8ed-11e5-bebc-a96332cd91f2', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1010, '6f2cac50-a8ee-11e5-a18e-0b1e5d920698', 'group', 'aggregator');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1011, '7cdd5050-a8ee-11e5-a5d6-9b8d1cd28c6f', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1012, '9bbd1c20-a8ee-11e5-82ab-079b3d8ffc8e', 'temperature', 'channel');
INSERT INTO `entities` (`id`, `uuid`, `type`, `class`) VALUES(1013, 'b2b3f3f0-a8ee-11e5-a0a6-75cd8e59d2f9', 'temperature', 'channel');



INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(91, 1000, 'title', 'heizkreis2_T_ist_HK');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(92, 1000, 'color', '#cc0000');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(93, 1000, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(94, 1000, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(95, 1000, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(96, 1001, 'title', 'T_vorlauf_misch_HK');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(97, 1001, 'public', '1');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(98, 1001, 'color', '#ff6666');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(99, 1001, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(100, 1001, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(101, 1001, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(102, 1002, 'title', 'Mischer');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(103, 1002, 'public', '1');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(104, 1002, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(105, 1002, 'style', 'points');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(106, 1002, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(107, 1002, 'yaxis', '1');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(108, 1003, 'title', 'Heizung');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(109, 1003, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(110, 1003, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(111, 1003, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(112, 1003, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(113, 1004, 'title', 'Heizkreis 2');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(114, 1004, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(115, 1004, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(116, 1004, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(117, 1004, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(118, 1005, 'title', 'T_soll_HK');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(119, 1005, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(120, 1005, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(121, 1005, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(122, 1005, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(123, 1006, 'title', 'T_aussen');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(124, 1006, 'color', '#ffcc00');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(125, 1006, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(126, 1006, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(127, 1006, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(128, 1007, 'title', 'T_vorlauf_soll');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(129, 1007, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(130, 1007, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(131, 1007, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(132, 1007, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(133, 1008, 'title', 'T_vorlauf_ist');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(134, 1008, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(135, 1008, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(136, 1008, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(137, 1008, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(138, 1009, 'title', 'T_ruecklauf');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(139, 1009, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(140, 1009, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(141, 1009, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(142, 1009, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(143, 1010, 'title', 'Warmwasser');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(144, 1010, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(145, 1010, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(146, 1010, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(147, 1010, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(148, 1011, 'title', 'T_soll');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(149, 1011, 'color', '#000033');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(150, 1011, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(151, 1011, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(152, 1011, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(153, 1012, 'title', 'T_ist');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(154, 1012, 'color', '#000033');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(155, 1012, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(156, 1012, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(157, 1012, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(158, 1013, 'title', 'T_speicher');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(159, 1013, 'color', 'aqua');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(160, 1013, 'style', 'lines');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(161, 1013, 'fillstyle', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(162, 1013, 'yaxis', 'auto');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(163, 1011, 'active', '1');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(164, 1011, 'public', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(165, 1012, 'active', '1');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(166, 1012, 'public', '0');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(167, 1006, 'active', '1');
INSERT INTO `properties` (`id`, `entity_id`, `pkey`, `value`) VALUES(168, 1006, 'public', '0');

