-- MySQL dump 10.16 Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: jeedom -- ------------------------------------------------------ -- Server version 10.1.41-MariaDB-0+deb9u1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Dumping data for table `conso_abo` -- LOCK TABLES `conso_abo` WRITE; /*!40000 ALTER TABLE `conso_abo` DISABLE KEYS */; INSERT INTO `conso_abo` VALUES (14,'2014-11-01','2015-07-31',8.71,1,'electricity'),(11,'2018-08-01','2019-07-31',9.78,1,'electricity'),(12,'2019-08-01','2020-07-31',10.45,1,'electricity'),(13,'2014-08-01','2014-10-31',9.13,1,'electricity'),(15,'2015-08-01','2016-07-31',8.49,1,'electricity'),(16,'2016-08-01','2017-07-31',7.77,1,'electricity'),(17,'2017-08-01','2018-01-31',9.12,1,'electricity'),(18,'2018-02-01','2018-07-31',9.51,1,'electricity'),(19,'2019-01-01','2020-12-31',5.357,1,'water'),(20,'2019-01-01','2020-12-31',2.44,4,'water'),(21,'2018-01-01','2018-12-31',5.302,1,'water'),(22,'2018-01-01','2018-12-31',2.42,4,'water'),(23,'2017-01-01','2017-12-31',5.231,1,'water'),(24,'2017-01-01','2017-12-31',2.436,4,'water'),(27,'2020-01-01','2020-12-31',16.69,1,'gaz'); /*!40000 ALTER TABLE `conso_abo` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `conso_price` -- LOCK TABLES `conso_price` WRITE; /*!40000 ALTER TABLE `conso_price` DISABLE KEYS */; INSERT INTO `conso_price` VALUES (7,0.0674,0.105,'2015-01-16','2015-07-16',NULL,0,'electricity'),(4,0.0777,0.1097,'2019-06-01','2019-07-31',NULL,0,'electricity'),(5,0.0778,0.1103,'2019-08-01','2020-07-31',NULL,0,'electricity'),(8,0.0637,0.1042,'2015-08-01','2016-01-15',NULL,0,'electricity'),(9,0.0638,0.1043,'2016-01-16','2016-07-31',NULL,0,'electricity'),(10,0.0738,0.0979,'2016-08-01','2017-07-31',NULL,0,'electricity'),(11,0.0699,0.1143,'2014-08-01','2014-10-31',NULL,0,'electricity'),(12,0.0654,0.107,'2014-11-01','2015-01-15',NULL,0,'electricity'),(13,0.0688,0.1073,'2015-07-17','2015-07-31',NULL,0,'electricity'),(15,0.0723,0.1007,'2017-08-01','2018-01-31',NULL,0,'electricity'),(16,0.0716,0.1007,'2018-02-01','2018-07-31',NULL,0,'electricity'),(17,0.0703,0.0995,'2018-08-01','2019-05-31',NULL,0,'electricity'),(18,0.385,0.385,'2018-01-01','2020-07-31',NULL,0,'water'),(19,0.521,0.521,'2018-07-01','2020-07-31',NULL,0,'water'),(20,0.515,0.515,'2017-07-01','2018-06-30',NULL,0,'water'),(21,0.049,0.049,'2017-06-15','2020-07-31',NULL,0,'water'),(22,0.5,0.5,'2016-07-01','2019-06-30',NULL,0,'water'),(23,0.2947,0.2947,'2016-06-14','2017-12-31',NULL,0,'water'),(27,0.497,0.497,'2016-06-14','2016-06-30',NULL,0,'water'),(28,0.054,0.054,'2016-06-14','2017-06-14',NULL,0,'water'),(29,11.49,0.0887,'2020-01-01','2020-12-31',NULL,0,'gaz'),(31,0.0778,0.1103,'2019-08-01','2020-12-31',NULL,0,'electprod'),(32,851,851,'2020-01-01','2020-12-31',NULL,0,'oil'); /*!40000 ALTER TABLE `conso_price` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `conso_taxe` -- LOCK TABLES `conso_taxe` WRITE; /*!40000 ALTER TABLE `conso_taxe` DISABLE KEYS */; INSERT INTO `conso_taxe` VALUES (1,'Taxe sur la consommation finale d\'Electricité (TCFE)',0.0096,3,'2018-09-11','2018-12-31',1,0,1,'electricity'),(3,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',21.16,1,'2018-10-10','2019-07-31',0,1,0,'electricity'),(4,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',3.86,1,'2019-08-01','2019-09-13',0,1,0,'electricity'),(5,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',24.52,1,'2019-09-14','2020-09-13',0,1,0,'electricity'),(6,'Taxe sur la consommation finale d\'Electricité (TCFE)',0.0097,3,'2019-01-01','2020-07-31',1,0,1,'electricity'),(7,'Taxe sur la consommation finale d\'Electricité (TCFE)',0.00951,3,'2014-01-16','2015-01-15',1,0,1,'electricity'),(8,'Contribution au service Public d\'Electricite (CSPE)',0.01672,3,'2014-01-16','2015-01-15',1,0,1,'electricity'),(9,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',18.05,1,'2014-01-16','2015-01-15',0,1,0,'electricity'),(10,'Taxe sur la consommation finale d\'Electricité (TCFE)',0.00957,3,'2015-01-16','2018-09-10',1,0,1,'electricity'),(11,'Contribution au service Public d\'Electricite (CSPE)',0.01972,3,'2015-01-16','2016-01-15',1,0,1,'electricity'),(12,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',18.02,1,'2015-01-16','2016-01-15',0,1,0,'electricity'),(13,'Contribution au service Public d\'Electricite (CSPE)',0.0225,3,'2016-01-16','2020-12-01',1,0,1,'electricity'),(14,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',18.09,1,'2016-01-16','2017-01-15',0,1,0,'electricity'),(15,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',21.42,1,'2017-01-16','2018-01-15',0,1,0,'electricity'),(16,'Contribution Tarifaire d \'Acheminement Electricité (CTA)',16.51,1,'2018-01-18','2018-10-09',0,1,0,'electricity'),(17,'Consommation (part Saur - collecte)',0.4129,4,'2019-01-01','2020-12-31',1,0,1,'water'),(18,'Consommation (part Saur - traitement)',0.8455,4,'2019-01-01','2020-12-31',1,0,1,'water'),(19,'Consommation (part collectivité)',0.41,4,'2017-03-01','2020-12-31',1,0,1,'water'),(21,'Modernisation des réseaux de collecte',0.15,4,'2018-07-01','2020-06-30',1,0,1,'water'),(22,'Consommation (part Saur - collecte)',0.41,4,'2017-03-01','2017-06-14',1,0,1,'water'),(23,'Consommation (part Saur - traitement)',0.8396,4,'2017-03-01','2017-06-14',1,0,1,'water'),(24,'Consommation(part Lyonnaise des Eaux Suez)',0.4627,4,'2016-06-14','2016-06-30',1,0,1,'water'),(25,'Consommation(part Lyonnaise des Eaux Suez)',0.4624,4,'2016-07-01','2016-12-31',1,0,1,'water'),(26,'Consommation(part Lyonnaise des Eaux Suez)',0.4668,4,'2017-01-01','2017-02-28',1,0,1,'water'),(27,'Consommation (part collectivité)',1.25,4,'2016-06-14','2017-02-28',1,0,1,'water'),(28,'Consommation (part Saur - collecte)',0.409,4,'2018-06-09','2018-12-31',1,0,1,'water'),(29,'Consommation (part Saur - traitement)',0.8375,4,'2018-06-09','2018-12-31',1,0,1,'water'),(30,'Taxe Intérieure de Consommation sur le Gaz Naturel (TICGN)',0.00434,3,'2020-01-01','2020-12-31',1,0,1,'gaz'),(31,'Contribution Tarifaire d\'Acheminement Gaz',5.37,1,'2020-01-01','2020-12-31',0,1,0,'gaz'),(32,'Lutte contre la pollution',0.3,1,'2016-07-01','2020-06-30',1,0,1,'water'),(33,'Modernisation des réseaux de collecte',0.18,4,'2016-07-01','2018-06-30',1,0,1,'water'); /*!40000 ALTER TABLE `conso_taxe` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `conso_tva` -- LOCK TABLES `conso_tva` WRITE; /*!40000 ALTER TABLE `conso_tva` DISABLE KEYS */; INSERT INTO `conso_tva` VALUES (1,5.5,'2002-01-01','2020-12-31',0),(2,19.6,'2011-01-01','2013-12-31',0),(3,20,'2014-01-01','2020-12-31',1),(4,10,'2015-01-01','2020-12-31',0); /*!40000 ALTER TABLE `conso_tva` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-04-04 12:25:26