Historisation des données des sondes Oregon

# SELECT COUNT(1) FROM `graph_conso` WHERE `ftimestamp` < ‘2018-09-30’

# create table graph_conso_2018_0101_3009 as SELECT * FROM graph_conso WHERE `ftimestamp` < ‘2018-09-30’

# delete FROM `graph_conso` WHERE `ftimestamp` < ‘2018-09-30’

CREATE UNIQUE INDEX idx_time ON `graph_conso_2018_0101_3009`(ftimestamp,ffeed(15))

CREATE UNIQUE INDEX idx_mesure ON `graph_conso_2018_0101_3009`(ffeed(15),ftimestamp)