-- 
-- SENSOR_TYPES
--
INSERT INTO sensor_type VALUES(1, 'Temperature', '°C', 'Temperature sensor');
INSERT INTO sensor_type VALUES(2, 'Humidity', '%', 'Relative Humidity sensor');
INSERT INTO sensor_type VALUES(3, 'Light', 'Lx', 'Light sensor');
INSERT INTO sensor_type VALUES(4, 'Pressure', 'hPa', 'Atmospherics pressure sensor, corrected to sea level');
INSERT INTO sensor_type VALUES(5, 'Soil Moisture', '-', 'Soil Moisture sensor');
INSERT INTO sensor_type VALUES(6, 'Wind Direction', '°', 'Wind direction sensor, 0° is North wind, 90° is wind blowing from East to West, 180° South wind ...');
INSERT INTO sensor_type VALUES(7, 'Wind Velocity', 'm/s', 'Wind velocity sensor');
INSERT INTO sensor_type VALUES(8, 'WiFi RSSI', 'dBm', 'WiFi signal strenght');
INSERT INTO sensor_type VALUES(9, 'VOC', 'ppb', 'Total Volatile Organic Compound (TVOC) sensing from 0 to 1.187 parts per billion');
INSERT INTO sensor_type VALUES(10, 'CO2', 'ppm', 'eCO2 sensing from 400 to 8.192 parts per million');

-- 
-- PERSONS
--
INSERT INTO person (id, first_name, last_name, mail_recipient, description) VALUES(1, 'Your', 'Name', 'name@domain.org', NULL);


-- 
-- SENSORS
--
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 1, 1, 'LV_TEMP_01', 'Gardenhouse', 'ESP-12E + Dallas DS18B20. IP: 192.168.9.x', SYSDATE, NULL);
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 8, 1, 'LV_RSSI_01', 'Gardenhouse', 'ESP-12E in gardenhouse IP: 192.168.9.x', SYSDATE, NULL);
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 4, 1, 'LV_PRES_02', 'Greenhouse', 'ESP-12E + BMP180 in greenhouse. IP: 192.168.9.153', SYSDATE, NULL);
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 3, 1, 'LV_LIGH_01', 'Greenhouse BH1750', 'ESP-12E + BH1750 in greenhouse. IP: 192.168.9.153', SYSDATE, NULL);
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 2, 1, 'LV_HUM_02', 'Greenhouse Si7021', 'ESP-12E + Si7021  IP: 192.168.9.156', SYSDATE, NULL);
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 9, 1, 'LV_VOC_01', 'AQ CCS811', 'ESP-12E + CCS811  IP: 192.168.9.150', SYSDATE, NULL);
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 10, 1, 'LV_CO2_01', 'AQ CCS811', 'ESP-12E + CCS811 IP: 192.168.9.150', SYSDATE, NULL);
INSERT INTO sensor VALUES(seq_sensor.NEXTVAL, 8, 1, 'LV_RSSI_07', 'AQ Station', 'ESP-12E AQ IP: 192.168.9.150', SYSDATE, NULL);


-- 
-- ALERTS
--
INSERT INTO alert VALUES(seq_alert.NEXTVAL, 1, -5, 1, 'L', NULL, 'Warning, low temperature in gardenhouse !');
INSERT INTO alert VALUES(seq_alert.NEXTVAL, 1, 40, 1, 'H', NULL, 'Warning, high temperature in gardenhouse !');




-- 
-- RELAYS
--
-- 
INSERT INTO relay VALUES(seq_relay.NEXTVAL, 1, 'LV_RELAY_01', 'Workroom', 'Workroom 1', SYSDATE, NULL);
INSERT INTO relay VALUES(seq_relay.NEXTVAL, 1, 'LV_RELAY_02', 'Outdoor', 'Outdoor - basen or xmastree', SYSDATE, NULL);