-- Adminer 4.8.1 MySQL 10.5.15-MariaDB-0+deb11u1 dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP DATABASE IF EXISTS `AQCM05_db`;
CREATE DATABASE `AQCM05_db` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `AQCM05_db`;

CREATE TABLE `cfg_BME680` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_BME680_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `aqcm_BME680_HRo` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_BME680_Po` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_BME680_QNH` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `aqcm_BME680_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_BME680_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_BME680_I2C` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0x76',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_BME680` (`idx`, `aqcm_BME680_To`, `aqcm_BME680_HRo`, `aqcm_BME680_Po`, `aqcm_BME680_QNH`, `aqcm_BME680_Tmoy`, `aqcm_BME680_HRmoy`, `aqcm_BME680_I2C`) VALUES
(1,	'-3.78',	'9.82',	'0.00',	'1047',	'ON',	'OFF',	'0x76');

CREATE TABLE `cfg_BMP390` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_BMP390_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `aqcm_BMP390_Po` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_BMP390_QNH` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `aqcm_BMP390_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_BMP390` (`idx`, `aqcm_BMP390_To`, `aqcm_BMP390_Po`, `aqcm_BMP390_QNH`, `aqcm_BMP390_Tmoy`) VALUES
(1,	'-1.45',	'0.45',	'1047',	'OFF');

CREATE TABLE `cfg_BUZ_2` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_BUZ_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_BUZ_ALARM_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `aqcm_BUZ_RESTART_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_BUZ_SCHEDULE_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_BUZ_SCHEDULER_2` varchar(1008) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[BLOB]',
  `aqcm_TRIG_BUZ_2_0` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '700',
  `aqcm_TRIG_BUZ_2_1` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1000',
  `aqcm_TRIG_BUZ_2_2` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1400',
  `aqcm_TRIG_BUZ_2_3` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2000',
  `aqcm_TRIG_BUZ_2_4` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2500',
  `aqcm_BUZ_PERIOD_2` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '10',
  `aqcm_BUZ_SILENCE_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_BUZ_DUREE_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '050',
  `aqcm_BUZ_FIRST_LEVEL_2` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_BUZ_2` (`idx`, `aqcm_BUZ_2`, `aqcm_BUZ_ALARM_2`, `aqcm_BUZ_RESTART_2`, `aqcm_BUZ_SCHEDULE_2`, `aqcm_BUZ_SCHEDULER_2`, `aqcm_TRIG_BUZ_2_0`, `aqcm_TRIG_BUZ_2_1`, `aqcm_TRIG_BUZ_2_2`, `aqcm_TRIG_BUZ_2_3`, `aqcm_TRIG_BUZ_2_4`, `aqcm_BUZ_PERIOD_2`, `aqcm_BUZ_SILENCE_2`, `aqcm_BUZ_DUREE_2`, `aqcm_BUZ_FIRST_LEVEL_2`) VALUES
(1,	'ON',	'ON',	'ON',	'ON',	'[BLOB]',	'800',	'1150',	'1500',	'2000',	'2500',	'5',	'ON',	'050',	'2');

CREATE TABLE `cfg_CAPTEURS` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_CAPTEUR_CO2` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SCD41',
  `aqcm_CAPTEUR_P` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'BME680',
  `aqcm_CAPTEUR_COV` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SGP41',
  `aqcm_CAPTEUR_PM` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'sans',
  `aqcm_CAPTEUR_HCHO` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'sans',
  `aqcm_CAPTEUR_LUX` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'VEML7700',
  `aqcm_CAPTEUR_SPL` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'I2S',
  `aqcm_CAPTEUR_NOX` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SGP41',
  `aqcm_CAPTEUR_T_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'sans',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_CAPTEURS` (`idx`, `aqcm_CAPTEUR_CO2`, `aqcm_CAPTEUR_P`, `aqcm_CAPTEUR_COV`, `aqcm_CAPTEUR_PM`, `aqcm_CAPTEUR_HCHO`, `aqcm_CAPTEUR_LUX`, `aqcm_CAPTEUR_SPL`, `aqcm_CAPTEUR_NOX`, `aqcm_CAPTEUR_T_HR`) VALUES
(1,	'SCD41',	'BME680',	'SGP41',	'sans',	'sans',	'VEML7700',	'I2S',	'SGP41',	'SHT85');

CREATE TABLE `cfg_CTRL_AFF` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_CTRL_AFF_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_CTRL_AFF_TEMPO_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '5',
  `aqcm_CTRL_AFF_TEMPO_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '40',
  `aqcm_CTRL_AFF_TEMPO_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '40',
  `aqcm_CTRL_AFF_TEMPO_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '40',
  `aqcm_CTRL_AFF_TEMPO_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '60',
  `aqcm_CTRL_AFF_SPL_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_CTRL_AFF_SPL_MOY` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '40.0',
  `aqcm_CTRL_AFF_SPL_MAX` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '60.0',
  `aqcm_CTRL_AFF_ALLWAYS_ON` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_CTRL_AFF_SCHEDULED` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_CTRL_AFF_MODE` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'IAQ',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_CTRL_AFF` (`idx`, `aqcm_CTRL_AFF_FF`, `aqcm_CTRL_AFF_TEMPO_1`, `aqcm_CTRL_AFF_TEMPO_2`, `aqcm_CTRL_AFF_TEMPO_3`, `aqcm_CTRL_AFF_TEMPO_4`, `aqcm_CTRL_AFF_TEMPO_5`, `aqcm_CTRL_AFF_SPL_EN`, `aqcm_CTRL_AFF_SPL_MOY`, `aqcm_CTRL_AFF_SPL_MAX`, `aqcm_CTRL_AFF_ALLWAYS_ON`, `aqcm_CTRL_AFF_SCHEDULED`, `aqcm_CTRL_AFF_MODE`) VALUES
(1,	'OFF',	'5',	'30',	'30',	'60',	'100',	'ON',	'45.0',	'65.0',	'OFF',	'OFF',	'IAQ');

CREATE TABLE `cfg_ILI9341` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_ILI9341_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_ILI9341_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_ILI9341_TAU` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '55',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_ILI9341` (`idx`, `aqcm_ILI9341_EN`, `aqcm_ILI9341_To`, `aqcm_ILI9341_TAU`) VALUES
(1,	'OFF',	'0.30',	'200');

CREATE TABLE `cfg_LCD_2` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_LCD_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_LCD_ALARM_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `aqcm_LCD_RESTART_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_LCD_SCHEDULE_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_LCD_SCHEDULER_2` varchar(1008) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[BLOB]',
  `aqcm_TRIG_LCD_2_0` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '700',
  `aqcm_TRIG_LCD_2_1` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1000',
  `aqcm_TRIG_LCD_2_2` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1400',
  `aqcm_TRIG_LCD_2_3` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2000',
  `aqcm_TRIG_LCD_2_4` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2500',
  `aqcm_LCD_PERIOD_2` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '10',
  `aqcm_LCD_DUREE_2` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '05',
  `aqcm_LCD_FLASHES_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_LCD_FIRST_LEVEL_2` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_LCD_2` (`idx`, `aqcm_LCD_2`, `aqcm_LCD_ALARM_2`, `aqcm_LCD_RESTART_2`, `aqcm_LCD_SCHEDULE_2`, `aqcm_LCD_SCHEDULER_2`, `aqcm_TRIG_LCD_2_0`, `aqcm_TRIG_LCD_2_1`, `aqcm_TRIG_LCD_2_2`, `aqcm_TRIG_LCD_2_3`, `aqcm_TRIG_LCD_2_4`, `aqcm_LCD_PERIOD_2`, `aqcm_LCD_DUREE_2`, `aqcm_LCD_FLASHES_2`, `aqcm_LCD_FIRST_LEVEL_2`) VALUES
(1,	'ON',	'ON',	'ON',	'ON',	'[BLOB]',	'600',	'800',	'1150',	'1500',	'2000',	'5',	'05',	'ON',	'1');

CREATE TABLE `cfg_LIVE` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `temps` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `CO2` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  `CO2_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `P_mer` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1013.25',
  `COV_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `COV_IAQq` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `NOX_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000.0',
  `PM25` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `PM10` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `HCHO` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `LUX` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000000',
  `SPL` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000.0',
  `SCD30_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SCD30_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SCD30_CO2` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  `SCD30_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SCD41_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `SCD41_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `SCD41_CO2` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  `SCD41_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `BME680_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `BME680_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `BME680_P` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000.00',
  `BME680_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `BME680_IAQq` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SPS30_PM25` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SPS30_PM10` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `WZS_HCHO` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SFA30_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SFA30_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SFA30_HCHO` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SGP40_COV_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SGP40_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SGP40_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SGP41_COV_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SGP41_NOX_IAQ` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SGP41_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SGP41_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `BMP390_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `BMP390_P` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000.00',
  `VEML7700_ALS` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000000',
  `I2S_MICRO` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000.0',
  `SHT85_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `SHT85_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `SHT35_T` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `SHT35_HR` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_LIVE` (`idx`, `temps`, `T`, `HR`, `CO2`, `CO2_IAQ`, `P_mer`, `COV_IAQ`, `COV_IAQq`, `NOX_IAQ`, `PM25`, `PM10`, `HCHO`, `LUX`, `SPL`, `SCD30_T`, `SCD30_HR`, `SCD30_CO2`, `SCD30_IAQ`, `SCD41_T`, `SCD41_HR`, `SCD41_CO2`, `SCD41_IAQ`, `BME680_T`, `BME680_HR`, `BME680_P`, `BME680_IAQ`, `BME680_IAQq`, `SPS30_PM25`, `SPS30_PM10`, `WZS_HCHO`, `SFA30_T`, `SFA30_HR`, `SFA30_HCHO`, `SGP40_COV_IAQ`, `SGP40_T`, `SGP40_HR`, `SGP41_COV_IAQ`, `SGP41_NOX_IAQ`, `SGP41_T`, `SGP41_HR`, `BMP390_T`, `BMP390_P`, `VEML7700_ALS`, `I2S_MICRO`, `SHT85_T`, `SHT85_HR`, `SHT35_T`, `SHT35_HR`) VALUES
(1,	'1738169795',	'21.27',	'37.4',	' 680',	'1',	'1008.42',	'47',	'0',	'2',	'2.5',	'10',	'10',	'2',	'27',	'0.00',	'0.0',	' 400',	'1',	'21.30',	'37.2',	' 680',	'1',	'21.28',	'37.5',	'892.00',	'0',	'0',	'0.0',	'0.0',	'0.0',	'0.00',	'0.0',	'0.0',	'0',	'0.00',	'0.0',	'47',	'2.00',	'21.27',	'37.4',	'0.00',	'0.00',	'2',	'27',	'21.23',	'38.4',	'0.00',	'0.0');

CREATE TABLE `cfg_RECALC` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `recalc_CO2_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '600',
  `recalc_CO2_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '800',
  `recalc_CO2_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1150',
  `recalc_CO2_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1500',
  `recalc_CO2_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2000',
  `recalc_CO2_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2500',
  `recalc_CO2_TRIG_LOW` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '800',
  `recalc_CO2_TRIG_HIGH` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1500',
  `recalc_SPL_TRIG_MOY` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '40.0',
  `recalc_SPL_TRIG_MAX` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '60.0',
  `recalc_PRES_MODE` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SPL(PHP)',
  `recalc_PRES_SCHEDULER` varchar(1008) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[BLOB]',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_RECALC` (`idx`, `recalc_CO2_TRIG_0`, `recalc_CO2_TRIG_1`, `recalc_CO2_TRIG_2`, `recalc_CO2_TRIG_3`, `recalc_CO2_TRIG_4`, `recalc_CO2_TRIG_5`, `recalc_CO2_TRIG_LOW`, `recalc_CO2_TRIG_HIGH`, `recalc_SPL_TRIG_MOY`, `recalc_SPL_TRIG_MAX`, `recalc_PRES_MODE`, `recalc_PRES_SCHEDULER`) VALUES
(1,	'600',	'800',	'1150',	'1500',	'2000',	'2500',	'800',	'1500',	'40.0',	'60.0',	'SPL(PHP)',	'[BLOB]');

CREATE TABLE `cfg_SCD30` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SCD30_ABC_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD30_ABC` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD30_ABC_TIME` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '07',
  `aqcm_SCD30_To_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD30_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SCD30_QNH_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD30_QNH` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `aqcm_SCD30_CO2_REF_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD30_CO2_REF` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  `aqcm_SCD30_RESET_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD30_ABC_START` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `aqcm_SCD30_Tf` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SCD30_HRf` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SCD30_CO2f` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `aqcm_SCD30_Af` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1.00',
  `aqcm_SCD30_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SCD30_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SCD30_READ_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD30_I2C_BUS` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '5',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SCD30` (`idx`, `aqcm_SCD30_ABC_FF`, `aqcm_SCD30_ABC`, `aqcm_SCD30_ABC_TIME`, `aqcm_SCD30_To_FF`, `aqcm_SCD30_To`, `aqcm_SCD30_QNH_FF`, `aqcm_SCD30_QNH`, `aqcm_SCD30_CO2_REF_FF`, `aqcm_SCD30_CO2_REF`, `aqcm_SCD30_RESET_FF`, `aqcm_SCD30_ABC_START`, `aqcm_SCD30_Tf`, `aqcm_SCD30_HRf`, `aqcm_SCD30_CO2f`, `aqcm_SCD30_Af`, `aqcm_SCD30_Tmoy`, `aqcm_SCD30_HRmoy`, `aqcm_SCD30_READ_FF`, `aqcm_SCD30_I2C_BUS`) VALUES
(1,	'OFF',	'OFF',	'08',	'OFF',	'5.00',	'OFF',	'1047',	'OFF',	'400',	'OFF',	'1713773103',	'1.35',	'-0.90',	'-20',	'1.00',	'OFF',	'OFF',	'OFF',	'8');

CREATE TABLE `cfg_SCD30_READ` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `SCD30_READ_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `SCD30_READ_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SCD30_READ_QNH` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `SCD30_READ_ASC` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `SCD30_READ_FW` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0x00 - 0x00',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SCD30_READ` (`idx`, `SCD30_READ_FF`, `SCD30_READ_To`, `SCD30_READ_QNH`, `SCD30_READ_ASC`, `SCD30_READ_FW`) VALUES
(1,	'OFF',	'5.00',	'1047',	'OFF',	'0x03-0x42');

CREATE TABLE `cfg_SCD41` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SCD41_ABC_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_ABC` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_ABC_TIME` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '07',
  `aqcm_SCD41_To_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SCD41_QNH_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_QNH` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `aqcm_SCD41_CO2_REF_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_CO2_REF` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  `aqcm_SCD41_RESET_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_FACTORY_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_PERSIST_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_ABC_START` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `aqcm_SCD41_Tf` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SCD41_HRf` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SCD41_CO2f` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `aqcm_SCD41_Af` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1.00',
  `aqcm_SCD41_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SCD41_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SCD41_READ_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SCD41_I2C_BUS` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '5',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SCD41` (`idx`, `aqcm_SCD41_ABC_FF`, `aqcm_SCD41_ABC`, `aqcm_SCD41_ABC_TIME`, `aqcm_SCD41_To_FF`, `aqcm_SCD41_To`, `aqcm_SCD41_QNH_FF`, `aqcm_SCD41_QNH`, `aqcm_SCD41_CO2_REF_FF`, `aqcm_SCD41_CO2_REF`, `aqcm_SCD41_RESET_FF`, `aqcm_SCD41_FACTORY_FF`, `aqcm_SCD41_PERSIST_FF`, `aqcm_SCD41_ABC_START`, `aqcm_SCD41_Tf`, `aqcm_SCD41_HRf`, `aqcm_SCD41_CO2f`, `aqcm_SCD41_Af`, `aqcm_SCD41_Tmoy`, `aqcm_SCD41_HRmoy`, `aqcm_SCD41_READ_FF`, `aqcm_SCD41_I2C_BUS`) VALUES
(1,	'OFF',	'OFF',	'08',	'OFF',	'6.00',	'OFF',	'1047',	'OFF',	'400',	'OFF',	'OFF',	'OFF',	'1713773107',	'0.27',	'4.12',	'0000',	'1.000',	'OFF',	'OFF',	'OFF',	'8');

CREATE TABLE `cfg_SCD41_READ` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `SCD41_READ_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `SCD41_READ_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `SCD41_READ_QNH` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `SCD41_READ_ASC` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `SCD41_READ_FW` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'A1234567890B',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SCD41_READ` (`idx`, `SCD41_READ_FF`, `SCD41_READ_To`, `SCD41_READ_QNH`, `SCD41_READ_ASC`, `SCD41_READ_FW`) VALUES
(1,	'OFF',	'6.00',	'1047',	'OFF',	'84b11b073ba8');

CREATE TABLE `cfg_SFA30` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SFA30_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SFA30_HRo` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SFA30_A` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1.00',
  `aqcm_SFA30_B` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000',
  `aqcm_SFA30_RESET_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SFA30_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SFA30_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SFA30` (`idx`, `aqcm_SFA30_To`, `aqcm_SFA30_HRo`, `aqcm_SFA30_A`, `aqcm_SFA30_B`, `aqcm_SFA30_RESET_FF`, `aqcm_SFA30_Tmoy`, `aqcm_SFA30_HRmoy`) VALUES
(1,	'-4.73',	'1.27',	'1.00',	'0.00',	'OFF',	'OFF',	'OFF');

CREATE TABLE `cfg_SGP40` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SGP40_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `aqcm_SGP40_HRo` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SGP40_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SGP40_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SGP40` (`idx`, `aqcm_SGP40_To`, `aqcm_SGP40_HRo`, `aqcm_SGP40_Tmoy`, `aqcm_SGP40_HRmoy`) VALUES
(1,	'-3.60',	'1.70',	'OFF',	'OFF');

CREATE TABLE `cfg_SGP41` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SGP41_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  `aqcm_SGP41_HRo` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SGP41_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SGP41_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SGP41` (`idx`, `aqcm_SGP41_To`, `aqcm_SGP41_HRo`, `aqcm_SGP41_Tmoy`, `aqcm_SGP41_HRmoy`) VALUES
(1,	'-3.19',	'4.42',	'ON',	'ON');

CREATE TABLE `cfg_SHT35` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SHT35_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SHT35_HRo` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SHT35_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SHT35_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SHT35_SN` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0x00000000',
  `aqcm_SHT35_UNIQUE` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SHT35_HR_DYN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SHT35` (`idx`, `aqcm_SHT35_To`, `aqcm_SHT35_HRo`, `aqcm_SHT35_Tmoy`, `aqcm_SHT35_HRmoy`, `aqcm_SHT35_SN`, `aqcm_SHT35_UNIQUE`, `aqcm_SHT35_HR_DYN`) VALUES
(1,	'0.00',	'0.00',	'ON',	'ON',	'0x00000000',	'OFF',	'OFF');

CREATE TABLE `cfg_SHT85` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SHT85_To` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SHT85_HRo` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  `aqcm_SHT85_Tmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SHT85_HRmoy` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ON',
  `aqcm_SHT85_SN` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0x00000000',
  `aqcm_SHT85_UNIQUE` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SHT85_HR_DYN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SHT85` (`idx`, `aqcm_SHT85_To`, `aqcm_SHT85_HRo`, `aqcm_SHT85_Tmoy`, `aqcm_SHT85_HRmoy`, `aqcm_SHT85_SN`, `aqcm_SHT85_UNIQUE`, `aqcm_SHT85_HR_DYN`) VALUES
(1,	'0.00',	'0.00',	'OFF',	'OFF',	'0x1187f509',	'OFF',	'OFF');

CREATE TABLE `cfg_SPS30` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_SPS30_RESET_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SPS30_CLEAN_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SPS30_CLEAN_INTERVALLE` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '604800',
  `aqcm_SPS30_CLEAN_INTERVALLE_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SPS30_READ_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SPS30` (`idx`, `aqcm_SPS30_RESET_FF`, `aqcm_SPS30_CLEAN_FF`, `aqcm_SPS30_CLEAN_INTERVALLE`, `aqcm_SPS30_CLEAN_INTERVALLE_FF`, `aqcm_SPS30_READ_FF`) VALUES
(1,	'OFF',	'OFF',	'604800',	'OFF',	'OFF');

CREATE TABLE `cfg_SPS30_READ` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `SPS30_READ_FF` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `SPS30_READ_CLEAN_INTERVALLE` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '00000000',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_SPS30_READ` (`idx`, `SPS30_READ_FF`, `SPS30_READ_CLEAN_INTERVALLE`) VALUES
(1,	'OFF',	'604800');

CREATE TABLE `cfg_TRIG_CO2` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_CO2_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '700',
  `aqcm_CO2_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1000',
  `aqcm_CO2_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1300',
  `aqcm_CO2_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1700',
  `aqcm_CO2_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2000',
  `aqcm_CO2_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '3000',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_CO2` (`idx`, `aqcm_CO2_TRIG_0`, `aqcm_CO2_TRIG_1`, `aqcm_CO2_TRIG_2`, `aqcm_CO2_TRIG_3`, `aqcm_CO2_TRIG_4`, `aqcm_CO2_TRIG_5`) VALUES
(1,	'600',	'800',	'1150',	'1500',	'2000',	'2500');

CREATE TABLE `cfg_TRIG_COV` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_COV_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '50',
  `aqcm_COV_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '100',
  `aqcm_COV_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '150',
  `aqcm_COV_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200',
  `aqcm_COV_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '300',
  `aqcm_COV_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_COV` (`idx`, `aqcm_COV_TRIG_0`, `aqcm_COV_TRIG_1`, `aqcm_COV_TRIG_2`, `aqcm_COV_TRIG_3`, `aqcm_COV_TRIG_4`, `aqcm_COV_TRIG_5`) VALUES
(1,	'100',	'150',	'200',	'250',	'300',	'400');

CREATE TABLE `cfg_TRIG_HCHO` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_HCHO_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '10',
  `aqcm_HCHO_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '30',
  `aqcm_HCHO_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '50',
  `aqcm_HCHO_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '100',
  `aqcm_HCHO_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200',
  `aqcm_HCHO_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '300',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_HCHO` (`idx`, `aqcm_HCHO_TRIG_0`, `aqcm_HCHO_TRIG_1`, `aqcm_HCHO_TRIG_2`, `aqcm_HCHO_TRIG_3`, `aqcm_HCHO_TRIG_4`, `aqcm_HCHO_TRIG_5`) VALUES
(1,	'10',	'20',	'30',	'50',	'100',	'200');

CREATE TABLE `cfg_TRIG_HR` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_HR_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '20.0',
  `aqcm_HR_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '30.0',
  `aqcm_HR_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '40.0',
  `aqcm_HR_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '60.0',
  `aqcm_HR_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '70.0',
  `aqcm_HR_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '80.0',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_HR` (`idx`, `aqcm_HR_TRIG_0`, `aqcm_HR_TRIG_1`, `aqcm_HR_TRIG_2`, `aqcm_HR_TRIG_3`, `aqcm_HR_TRIG_4`, `aqcm_HR_TRIG_5`) VALUES
(1,	'20.0',	'30.0',	'40.0',	'60.0',	'70.0',	'80.0');

CREATE TABLE `cfg_TRIG_LUX` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_LUX_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '100',
  `aqcm_LUX_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200',
  `aqcm_LUX_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '500',
  `aqcm_LUX_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1000',
  `aqcm_LUX_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2000',
  `aqcm_LUX_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '5000',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_LUX` (`idx`, `aqcm_LUX_TRIG_0`, `aqcm_LUX_TRIG_1`, `aqcm_LUX_TRIG_2`, `aqcm_LUX_TRIG_3`, `aqcm_LUX_TRIG_4`, `aqcm_LUX_TRIG_5`) VALUES
(1,	'50',	'100',	'200',	'500',	'1000',	'2000');

CREATE TABLE `cfg_TRIG_NOX` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_NOX_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '50',
  `aqcm_NOX_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '100',
  `aqcm_NOX_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '150',
  `aqcm_NOX_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200',
  `aqcm_NOX_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '300',
  `aqcm_NOX_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_NOX` (`idx`, `aqcm_NOX_TRIG_0`, `aqcm_NOX_TRIG_1`, `aqcm_NOX_TRIG_2`, `aqcm_NOX_TRIG_3`, `aqcm_NOX_TRIG_4`, `aqcm_NOX_TRIG_5`) VALUES
(1,	'5',	'10',	'30',	'40',	'50',	'60');

CREATE TABLE `cfg_TRIG_PM25` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_PM25_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '10',
  `aqcm_PM25_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '30',
  `aqcm_PM25_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '50',
  `aqcm_PM25_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '100',
  `aqcm_PM25_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200',
  `aqcm_PM25_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '300',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_PM25` (`idx`, `aqcm_PM25_TRIG_0`, `aqcm_PM25_TRIG_1`, `aqcm_PM25_TRIG_2`, `aqcm_PM25_TRIG_3`, `aqcm_PM25_TRIG_4`, `aqcm_PM25_TRIG_5`) VALUES
(1,	'10',	'25',	'50',	'100',	'200',	'500');

CREATE TABLE `cfg_TRIG_SPL` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_SPL_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '35',
  `aqcm_SPL_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '65',
  `aqcm_SPL_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '75',
  `aqcm_SPL_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '90',
  `aqcm_SPL_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '105',
  `aqcm_SPL_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '120',
  `aqcm_SPL_TRIG_MOY` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '38.0',
  `aqcm_SPL_TRIG_MAX` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '45.0',
  `aqcm_SPL_TRIG_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_SPL_TRIG_ET_OU` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OU',
  `aqcm_SPL_TRIG_MODE_BIQUO` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SPL(PHP)',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_SPL` (`idx`, `aqcm_SPL_TRIG_0`, `aqcm_SPL_TRIG_1`, `aqcm_SPL_TRIG_2`, `aqcm_SPL_TRIG_3`, `aqcm_SPL_TRIG_4`, `aqcm_SPL_TRIG_5`, `aqcm_SPL_TRIG_MOY`, `aqcm_SPL_TRIG_MAX`, `aqcm_SPL_TRIG_EN`, `aqcm_SPL_TRIG_ET_OU`, `aqcm_SPL_TRIG_MODE_BIQUO`) VALUES
(1,	'50',	'60',	'70',	'80',	'90',	'100',	'40.0',	'60.0',	'ON',	'OU',	'SPL(PHP)');

CREATE TABLE `cfg_TRIG_T` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_T_TRIG_0` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '15.0',
  `aqcm_T_TRIG_1` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '17.0',
  `aqcm_T_TRIG_2` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '19.0',
  `aqcm_T_TRIG_3` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '23.0',
  `aqcm_T_TRIG_4` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '25.0',
  `aqcm_T_TRIG_5` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '27.0',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_TRIG_T` (`idx`, `aqcm_T_TRIG_0`, `aqcm_T_TRIG_1`, `aqcm_T_TRIG_2`, `aqcm_T_TRIG_3`, `aqcm_T_TRIG_4`, `aqcm_T_TRIG_5`) VALUES
(1,	'15.0',	'17.0',	'19.0',	'22.0',	'24.0',	'26.0');

CREATE TABLE `cfg_VMC_CO2` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `aqcm_VMC_CTRL` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_RELAYS_TYPE` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SR201',
  `aqcm_VMC_RELAYS_IP` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '192.168.1.100',
  `aqcm_VMC_TRIG_2_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '750',
  `aqcm_VMC_TRIG_2_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '850',
  `aqcm_VMC_TRIG_3_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1250',
  `aqcm_VMC_TRIG_3_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1350',
  `aqcm_VMC_CO2_TRIG_2_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '750',
  `aqcm_VMC_CO2_TRIG_2_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '850',
  `aqcm_VMC_CO2_TRIG_3_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1250',
  `aqcm_VMC_CO2_TRIG_3_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1350',
  `aqcm_VMC_COV_TRIG_2_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '190',
  `aqcm_VMC_COV_TRIG_2_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '210',
  `aqcm_VMC_COV_TRIG_3_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '340',
  `aqcm_VMC_COV_TRIG_3_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '360',
  `aqcm_VMC_NOX_TRIG_2_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '040',
  `aqcm_VMC_NOX_TRIG_2_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '050',
  `aqcm_VMC_NOX_TRIG_3_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '190',
  `aqcm_VMC_NOX_TRIG_3_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '210',
  `aqcm_VMC_HCO_TRIG_2_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '015',
  `aqcm_VMC_HCO_TRIG_2_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '025',
  `aqcm_VMC_HCO_TRIG_3_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '045',
  `aqcm_VMC_HCO_TRIG_3_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '055',
  `aqcm_VMC_PMX_TRIG_2_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '025',
  `aqcm_VMC_PMX_TRIG_2_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '035',
  `aqcm_VMC_PMX_TRIG_3_L` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '095',
  `aqcm_VMC_PMX_TRIG_3_H` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '105',
  `aqcm_VMC_CO2_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_COV_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_NOX_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_HCO_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_PMX_EN` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_2_CO2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_3_CO2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_2_COV` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_3_COV` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_2_NOX` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_3_NOX` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_2_HCO` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_3_HCO` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_2_PMX` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_3_PMX` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_2` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  `aqcm_VMC_Qout_3` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OFF',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx` (`idx`),
  KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_VMC_CO2` (`idx`, `aqcm_VMC_CTRL`, `aqcm_VMC_RELAYS_TYPE`, `aqcm_VMC_RELAYS_IP`, `aqcm_VMC_TRIG_2_L`, `aqcm_VMC_TRIG_2_H`, `aqcm_VMC_TRIG_3_L`, `aqcm_VMC_TRIG_3_H`, `aqcm_VMC_CO2_TRIG_2_L`, `aqcm_VMC_CO2_TRIG_2_H`, `aqcm_VMC_CO2_TRIG_3_L`, `aqcm_VMC_CO2_TRIG_3_H`, `aqcm_VMC_COV_TRIG_2_L`, `aqcm_VMC_COV_TRIG_2_H`, `aqcm_VMC_COV_TRIG_3_L`, `aqcm_VMC_COV_TRIG_3_H`, `aqcm_VMC_NOX_TRIG_2_L`, `aqcm_VMC_NOX_TRIG_2_H`, `aqcm_VMC_NOX_TRIG_3_L`, `aqcm_VMC_NOX_TRIG_3_H`, `aqcm_VMC_HCO_TRIG_2_L`, `aqcm_VMC_HCO_TRIG_2_H`, `aqcm_VMC_HCO_TRIG_3_L`, `aqcm_VMC_HCO_TRIG_3_H`, `aqcm_VMC_PMX_TRIG_2_L`, `aqcm_VMC_PMX_TRIG_2_H`, `aqcm_VMC_PMX_TRIG_3_L`, `aqcm_VMC_PMX_TRIG_3_H`, `aqcm_VMC_CO2_EN`, `aqcm_VMC_COV_EN`, `aqcm_VMC_NOX_EN`, `aqcm_VMC_HCO_EN`, `aqcm_VMC_PMX_EN`, `aqcm_VMC_Qout_2_CO2`, `aqcm_VMC_Qout_3_CO2`, `aqcm_VMC_Qout_2_COV`, `aqcm_VMC_Qout_3_COV`, `aqcm_VMC_Qout_2_NOX`, `aqcm_VMC_Qout_3_NOX`, `aqcm_VMC_Qout_2_HCO`, `aqcm_VMC_Qout_3_HCO`, `aqcm_VMC_Qout_2_PMX`, `aqcm_VMC_Qout_3_PMX`, `aqcm_VMC_Qout_2`, `aqcm_VMC_Qout_3`) VALUES
(1,	'OFF',	'SHE25',	'192.168.1.139',	'750',	'850',	'1250',	'1350',	'750',	'850',	'1250',	'1350',	'190',	'210',	'340',	'360',	'040',	'050',	'190',	'210',	'015',	'025',	'045',	'055',	'025',	'035',	'095',	'105',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF',	'OFF');

CREATE TABLE `cfg_WZS` (
  `idx` tinyint(4) NOT NULL AUTO_INCREMENT,
  `aqcm_WZS_A` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1.00',
  `aqcm_WZS_B` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `cfg_WZS` (`idx`, `aqcm_WZS_A`, `aqcm_WZS_B`) VALUES
(1,	'1.00',	'0.00');

CREATE TABLE `Mesures` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `periode` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `temps` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `annee` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1970',
  `mois` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '01',
  `jour` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '01',
  `heure` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '00:00:00',
  `Nb` int(11) NOT NULL DEFAULT 1,
  `T` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `HR` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `CO2` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400|400|400',
  `CO2_brut` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '700|700|700',
  `CO2_IAQ` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `P_mer` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1013.25|1013.25|1013.25',
  `COV_IAQ` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `COV_IAQq` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `PM25` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `PM10` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `HCHO` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `LUX` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0|0|0',
  `SPL` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `NOX_IAQ` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `CO2_BIQUO` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200|400|400',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


CREATE TABLE `Mesures_CO2` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `temps` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `SCD30_CO2` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  `SCD41_CO2` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


CREATE TABLE `ToSend` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `periode` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `temps` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `annee` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1970',
  `mois` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '01',
  `jour` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '01',
  `heure` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '00:00:00',
  `Nb` int(11) NOT NULL DEFAULT 1,
  `T` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `HR` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `CO2` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '400|400|400',
  `CO2_IAQ` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `P_mer` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1013.25|1013.25|1013.25',
  `COV_IAQ` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `COV_IAQq` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `PM25` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `PM10` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `HCHO` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `LUX` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0|0|0',
  `SPL` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `NOX_IAQ` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0|0.0|0.0',
  `CO2_BIQUO` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200|400|400',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idx_2` (`idx`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


-- 2025-01-29 16:56:39
