1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
--- PostreSQL
CREATE TABLE w1sensors (
device text NOT NULL,
type text,
abbrv1 text,
name1 text,
units1 text,
abbrv2 text,
name2 text,
units2 text,
params text,
id serial
);
INSERT INTO w1sensors VALUES ('21351B0100204F91', 'DS1921', 'IBTN-H', 'iButton Temp', '°C', NULL, NULL, NULL, NULL, 27);
INSERT INTO w1sensors VALUES ('105EE02301080039', 'DS1820', 'STMP1', 'Soil Temperature', '°C', NULL, NULL, NULL, NULL, 11);
INSERT INTO w1sensors VALUES ('286DA467000000AD', 'DS1820', 'GHT', 'Greenhouse Temperature', '°C', NULL, NULL, NULL, NULL, 12);
INSERT INTO w1sensors VALUES ('12FC6B34000000A9', 'TAI8570', 'OPRS', 'Pressure', 'hPa', 'OTMP1', 'House Temperature', '°C', NULL, 13);
INSERT INTO w1sensors VALUES ('26378851000000AB', 'TAI8540', 'OHUM', 'Humidity', '%', 'OTMP0', 'Outside Temperature', '°C', NULL, 14);
INSERT INTO w1sensors VALUES ('1D9BB10500000089', 'TAI8575', 'RGC0', 'Counter0', 'tips', 'RGC1', 'Counter1', 'tips', NULL, 15);
INSERT INTO w1sensors VALUES ('10A942C10008009B', 'DS1820', 'OTMP2', 'Garage Temperature', '°C', NULL, NULL, NULL, NULL, 16);
INSERT INTO w1sensors VALUES ('261755B600000060', 'DS2438', 'SOLAR', 'Solar (Vsens)', 'mV', 'VTMP', 'Temperature GHT2', '°C', NULL, 17);
INSERT INTO w1sensors VALUES ('1FEDCB0300000000', 'DS2409', 'MAIN', '1D9BB10500000089', NULL, 'AUX', '10A942C10008009B', NULL, NULL, 20);
INSERT INTO w1sensors VALUES ('1F1CE7030000009C', 'DS2409', 'MAIN', '105EE02301080039', NULL, NULL, NULL, NULL, NULL, 22);
INSERT INTO w1sensors VALUES ('1F1CE7030000009C', 'DS2409', 'MAIN', '286DA467000000AD', NULL, NULL, NULL, NULL, NULL, 23);
INSERT INTO w1sensors VALUES ('1F1CE7030000009C', 'DS2409', 'MAIN', '261755B600000060', NULL, NULL, NULL, NULL, NULL, 24);
INSERT INTO w1sensors VALUES ('1F1CE7030000009C', 'DS2409', 'MAIN', '1093AEC100080042', NULL, NULL, NULL, NULL, NULL, 25);
INSERT INTO w1sensors VALUES ('1F1CE7030000009C', 'DS2409', 'MAIN', '10E3EA23010800C9', NULL, NULL, NULL, NULL, NULL, 26);
INSERT INTO w1sensors VALUES ('1093AEC100080042', 'DS1820', 'ITMP2', 'Propagator2 Temperature', '°C', NULL, NULL, NULL, NULL, 18);
INSERT INTO w1sensors VALUES ('10E3EA23010800C9', 'DS1820', 'ITMP1', 'Propagator1 Temperature', '°C', NULL, NULL, NULL, NULL, 19);
INSERT INTO w1sensors VALUES ('2113DD1800000046', 'DS1921', 'IBTN-G', 'iButton Temp', '°C', NULL, NULL, NULL, NULL, 30);
INSERT INTO w1sensors VALUES ('1FF9E60300000093', 'DS2409', 'MAIN', '26378851000000AB', NULL, 'AUX', '109F7724010800F1', NULL, NULL, 21);
INSERT INTO w1sensors VALUES ('109F7724010800F1', 'DS1820', 'CFRAME1', 'Cold Frame Temperature', '°C', NULL, NULL, NULL, NULL, 33);
|
