DROP TABLE IF EXISTS energy_value_log;CREATE TABLE energy_value_log id int6 NOT NULL AUTO_INCREMENT COMMENT 主键id device_id int6 NOT NULL COMMENT 设备id get_time datetime0 NULL DEFAULT NULL COMMENT

ALTER TABLE energy_value_log ADD INDEX idx_device_id (device_id), ADD INDEX idx_type (type), ADD INDEX idx_year (year), ADD INDEX idx_month (month), ADD INDEX idx_day (day), ADD INDEX idx_hour (hour);