forked from rexometer/custom_image
-
Notifications
You must be signed in to change notification settings - Fork 0
/
input.txt
21 lines (21 loc) · 1.15 KB
/
input.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
DELETE FROM input WHERE userid = '1';
INSERT INTO `input` (`id`, `userid`, `name`, `description`, `nodeid`, `processList`, `time`, `value`) VALUES
(1, 1, 'powerL1', '', '3phase', '1:1', NULL, NULL),
(2, 1, 'powerL2', '', '3phase', '1:2', NULL, NULL),
(3, 1, 'powerL3', '', '3phase', '1:3,11:1,11:2,1:5,4:6', NULL, NULL),
(4, 1, 'power4', '', '3phase', '1:4', NULL, NULL),
(13, 1, 'Vrms', '', '3phase', '1:8', NULL, NULL),
(14, 1, 'temp1', '', '3phase', '', NULL, NULL),
(15, 1, 'temp2', '', '3phase', '', NULL, NULL),
(16, 1, 'temp3', '', '3phase', '', NULL, NULL),
(17, 1, 'temp4', '', '3phase', '', NULL, NULL),
(18, 1, 'temp5', '', '3phase', '', NULL, NULL),
(19, 1, 'temp6', '', '3phase', '', NULL, NULL),
(20, 1, 'pulse', '', '3phase', '', NULL, NULL),
(21, 1, 'rssi', '', '3phase', '1:14,3:115,1:15', NULL, NULL),
(22, 1, 'temperature', '', 'emonth5', '1:9', NULL, NULL),
(23, 1, 'external temperature', '', 'emonth5', '', NULL, NULL),
(24, 1, 'humidity', '', 'emonth5', '1:10', NULL, NULL),
(25, 1, 'battery', '', 'emonth5', '1:11', NULL, NULL),
(26, 1, 'pulsecount', '', 'emonth5', '1:12,34:13', NULL, NULL),
(27, 1, 'rssi', '', 'emonth5', '3:115,1:16', NULL, NULL);