· 6 years ago · Aug 05, 2019, 07:02 AM
1-- Adminer 4.7.2 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `agile_sensors`;
9CREATE TABLE `agile_sensors` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `asense_device_id` varchar(200) NOT NULL,
12 `group_id` int(4) DEFAULT '0',
13 `ac_type_id` int(15) DEFAULT '0',
14 `mqtt_id` varchar(512) NOT NULL,
15 `temp_off_set` int(2) NOT NULL,
16 `sensor_min_temp` float NOT NULL,
17 `sensor_max_temp` float NOT NULL,
18 `hvac_friendly_name` varchar(200) DEFAULT NULL,
19 `ac_type_serial_number` varchar(200) DEFAULT '0',
20 `location` varchar(200) DEFAULT NULL,
21 `device_type_id` int(15) NOT NULL,
22 `mac_id` varchar(200) NOT NULL,
23 `ip_address` varchar(200) NOT NULL,
24 `publish_time` int(15) NOT NULL,
25 `version` varchar(200) NOT NULL,
26 `sub_type_id` int(15) DEFAULT '0',
27 `ac_status_on_motion` int(2) DEFAULT '0',
28 `alert_enable` int(2) DEFAULT '1',
29 `ac_sensor_type` int(15) DEFAULT '0',
30 `ac_on_time` int(15) DEFAULT '0',
31 `ac_temperature_set_point` int(15) DEFAULT '0',
32 `ac_enabled_on_motion` int(2) DEFAULT '0',
33 `ac_fan_on_motion` int(2) DEFAULT '1',
34 `ac_swing_on_motion` int(2) DEFAULT '1',
35 `cfm` varchar(512) NOT NULL,
36 `configure_ac` int(2) DEFAULT '0',
37 `dev_no` int(2) DEFAULT '0',
38 `created` datetime DEFAULT NULL,
39 `modified` datetime DEFAULT NULL,
40 `plot_temp_graph` int(2) DEFAULT '1',
41 `remark` text,
42 `uuid` varchar(255) DEFAULT NULL,
43 `co2_temp` int(4) DEFAULT NULL,
44 `co2_offset` int(4) DEFAULT NULL,
45 `humidity` int(4) DEFAULT NULL,
46 `eco_mode` int(2) NOT NULL DEFAULT '0',
47 `active_minutes` int(2) NOT NULL DEFAULT '0',
48 `no_of_slots` int(2) NOT NULL DEFAULT '0',
49 `override` int(2) DEFAULT '0',
50 `soft_delete` int(2) DEFAULT '0',
51 PRIMARY KEY (`id`)
52) ENGINE=InnoDB DEFAULT CHARSET=latin1;
53
54INSERT INTO `agile_sensors` (`id`, `asense_device_id`, `group_id`, `ac_type_id`, `mqtt_id`, `temp_off_set`, `sensor_min_temp`, `sensor_max_temp`, `hvac_friendly_name`, `ac_type_serial_number`, `location`, `device_type_id`, `mac_id`, `ip_address`, `publish_time`, `version`, `sub_type_id`, `ac_status_on_motion`, `alert_enable`, `ac_sensor_type`, `ac_on_time`, `ac_temperature_set_point`, `ac_enabled_on_motion`, `ac_fan_on_motion`, `ac_swing_on_motion`, `cfm`, `configure_ac`, `dev_no`, `created`, `modified`, `plot_temp_graph`, `remark`, `uuid`, `co2_temp`, `co2_offset`, `humidity`, `eco_mode`, `active_minutes`, `no_of_slots`, `override`, `soft_delete`) VALUES
55(1, 'ESP32-ASENS-24', 1, 1, 'AGLESP32-ASENS-24', 0, -0.5, 2.5, 'BLUESTAR-BS100-ESP32-ASENS-24', '0', 'ESP32-ASENS-24', 3, 'C4:4F:33:1D:46:11', '192.168.1.102', 60, 'E32ASENS-V1-R1', 1, 0, 1, 0, NULL, NULL, 0, 1, 1, '', 1, 0, '2019-07-27 12:11:39', '2019-07-27 12:11:39', 1, 'Test', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0),
56(2, 'ESP32-HVAC-24', 4, 2, 'AGL:ESP32-HVAC-24', 0, -0.5, 2.5, 'PANASONIC-PAN121-ESP32-HVAC-24', '0', 'ESP32-HVAC-24', 3, 'C4:4F:33:1D:46:2D', '192.168.1.103', 60, 'HVAC32-V1-R1', 2, 0, 1, 0, NULL, NULL, 0, 1, 1, '', 1, 0, '2019-07-26 11:44:57', '2019-07-26 11:44:57', 1, 'Test', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0);
57
58-- 2019-08-05 06:58:37