INSERT INTO `medidores` (`id`, `user_id`, `nome`, `cpf`, `telefone`, `concessionaria_id`, `codigo_instalacao`, `producao_fv`, `leitura_medidor_anterior`, `data_troca_medidor`, `residuo`, `leitura_ultima_conta`, `constante_ultima_conta`, `dia_leitura`, `constante`, `saldo_conta`, `saldo_medicao`, `created_at`, `updated_at`) VALUES
(3, 1, 'Sergio', '08173597707', '21-991416859', 2, '420501550', 1, 24963, '2019-09-03', 2400, 24933, 80, 30, 80, 0, 0, '2019-11-26 17:30:49', '2019-11-26 17:30:49');

INSERT INTO `addresses` (`id`, `medidor_id`, `endereco`, `numero`, `complemento`, `city_id`, `state_id`, `country_id`, `cep`, `created_at`, `updated_at`) VALUES
(3, 3, 'Rua Domingos Mondim', '41', 'apt 101', 3294, 19, 33, '21920-060', '2019-11-26 17:30:49', '2019-11-26 17:30:49');

INSERT INTO `historicos` (`id`, `medidor_id`, `data`, `consumo`, `created_at`, `updated_at`) VALUES
(1, 3, '2019-09-01', 15360, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(2, 3, '2019-08-01', 17920, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(3, 3, '2019-07-01', 16480, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(4, 3, '2019-06-01', 17280, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(5, 3, '2019-05-01', 18080, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(6, 3, '2019-04-01', 20240, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(7, 3, '2019-03-01', 18800, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(8, 3, '2019-02-01', 18320, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(9, 3, '2019-01-01', 22320, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(10, 3, '2018-12-01', 21280, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(11, 3, '2018-11-01', 18160, '2019-11-26 17:30:49', '2019-11-26 17:30:49'),
(12, 3, '2018-10-01', 18240, '2019-11-26 17:30:49', '2019-11-26 17:30:49');