DROP TABLE IF EXISTS `sound_meter_reading`;
CREATE TABLE `sound_meter_reading` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sensorID` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Sensor ID',
  `x` decimal(5,3) DEFAULT NULL,
  `y` decimal(5,3) DEFAULT NULL,
  `z` decimal(5,3) DEFAULT NULL,
  `ppv` decimal(5,3) DEFAULT NULL,
  `messageDate` datetime NOT NULL,
  `alert` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx-sound_meter_reading-sensorID` (`sensorID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

