-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.32-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 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 structure for table m.metter_data
CREATE TABLE IF NOT EXISTS `metter_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Ieraksta ID',
  `number` int(10) unsigned NOT NULL COMMENT 'Skaitītaja Numurs',
  `obis` int(10) unsigned DEFAULT 180 COMMENT 'OBIS',
  `date` date NOT NULL COMMENT 'Datums',
  `value` decimal(12,0) NOT NULL DEFAULT 0 COMMENT 'Rādījums',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Skaitītāju mērījumi';

-- Dumping data for table m.metter_data: ~252 rows (approximately)
INSERT INTO `metter_data` (`id`, `number`, `obis`, `date`, `value`) VALUES
	(1, 10498, 180, '2004-08-01', 26675),
	(2, 32687084, 180, '2004-08-01', 9086),
	(3, 32469776, 180, '2004-08-01', 16897),
	(4, 32778874, 180, '2004-08-01', 10997),
	(5, 4547010, 180, '2004-08-01', 1912),
	(6, 110081, 180, '2004-08-01', 51621),
	(7, 50028590, 180, '2004-08-01', 6134),
	(8, 97125, 180, '2004-08-01', 45052),
	(9, 10392, 180, '2004-08-01', 35115),
	(10, 23860702, 180, '2004-08-01', 948),
	(11, 32996418, 180, '2004-08-01', 16747),
	(12, 291044, 180, '2004-08-01', 4126),
	(13, 7950242, 180, '2004-08-01', 44239),
	(14, 556043, 180, '2004-08-01', 21454),
	(15, 3639101, 180, '2004-08-01', 1979),
	(16, 50028646, 180, '2004-08-01', 1569),
	(17, 96397, 180, '2004-08-01', 48065),
	(18, 32778527, 180, '2004-08-01', 12535),
	(19, 3493235, 180, '2004-08-01', 7420),
	(20, 32647524, 180, '2004-08-01', 18208),
	(21, 32719941, 180, '2004-08-01', 19406),
	(22, 45723523, 180, '2004-08-01', 309703),
	(23, 62553772, 180, '2004-08-01', 286700),
	(24, 29446616, 180, '2006-10-01', 5408),
	(25, 29446699, 180, '2006-10-01', 5336),
	(26, 29376219, 180, '2006-10-01', 5808),
	(27, 29376210, 180, '2006-10-01', 949),
	(28, 32778874, 180, '2006-10-01', 24974),
	(29, 50050895, 180, '2006-10-01', 12912),
	(30, 50088638, 180, '2006-10-01', 5424),
	(31, 32687084, 180, '2006-10-01', 18772),
	(32, 32469776, 180, '2006-10-01', 29697),
	(33, 32719941, 180, '2006-10-01', 42785),
	(34, 29376213, 180, '2006-10-01', 5363),
	(35, 50028590, 180, '2006-10-01', 23733),
	(36, 251280, 180, '2006-10-01', 8449),
	(37, 50028646, 180, '2006-10-01', 5911),
	(38, 29376264, 180, '2006-10-01', 4060),
	(39, 32778527, 180, '2006-10-01', 22986),
	(40, 29376231, 180, '2006-10-01', 1952),
	(41, 184611011, 180, '2006-10-01', 5864),
	(42, 29292026, 180, '2006-10-01', 4771),
	(43, 29292023, 180, '2006-10-01', 1012),
	(44, 32735797, 180, '2006-10-01', 38117),
	(45, 32647524, 180, '2006-10-01', 30297),
	(46, 32996418, 180, '2006-10-01', 37597),
	(47, 29292035, 180, '2006-10-01', 9282),
	(48, 29375625, 180, '2006-10-01', 7021),
	(49, 29446613, 180, '2006-10-01', 5629),
	(50, 29376263, 180, '2006-10-01', 4187),
	(51, 50121054, 180, '2006-10-01', 46),
	(52, 29446616, 180, '2008-12-17', 20258),
	(53, 29446699, 180, '2008-12-17', 22121),
	(54, 29376219, 180, '2008-12-17', 9780),
	(55, 29376210, 180, '2008-12-17', 4397),
	(56, 32778874, 180, '2008-12-17', 40093),
	(57, 50050895, 180, '2008-12-17', 26703),
	(58, 50088638, 180, '2008-12-17', 13775),
	(59, 32687084, 180, '2008-12-17', 28696),
	(60, 32469776, 180, '2008-12-17', 44575),
	(61, 32719941, 180, '2008-12-17', 73643),
	(62, 29376213, 180, '2008-12-17', 22926),
	(63, 50028590, 180, '2008-12-17', 42116),
	(64, 251280, 180, '2008-12-17', 22776),
	(65, 50028646, 180, '2008-12-17', 10895),
	(66, 29376264, 180, '2008-12-17', 17225),
	(67, 32778527, 180, '2008-12-17', 36581),
	(68, 29376231, 180, '2008-12-17', 4402),
	(69, 29292037, 180, '2008-12-17', 18559),
	(70, 29292026, 180, '2008-12-17', 16248),
	(71, 29292023, 180, '2008-12-17', 3764),
	(72, 32735797, 180, '2008-12-17', 55988),
	(73, 32647524, 180, '2008-12-17', 46068),
	(74, 32996418, 180, '2008-12-17', 59366),
	(75, 29292035, 180, '2008-12-17', 26880),
	(76, 29375625, 180, '2008-12-17', 23833),
	(77, 29446613, 180, '2008-12-17', 25460),
	(78, 29376263, 180, '2008-12-17', 16607),
	(79, 50121054, 180, '2008-12-17', 1326),
	(80, 50152351, 180, '2008-12-17', 2102),
	(81, 50156373, 180, '2008-12-17', 1175),
	(82, 50161280, 180, '2008-12-17', 557),
	(83, 50158093, 180, '2008-12-17', 1795),
	(84, 557538, 180, '2008-12-17', 488),
	(85, 580689, 180, '2008-12-17', 137),
	(86, 568796, 180, '2008-12-17', 200),
	(87, 568693, 180, '2008-12-17', 88),
	(88, 50028987, 180, '2011-03-28', 1931),
	(89, 29446699, 180, '2011-03-28', 35970),
	(90, 50089149, 180, '2011-03-28', 187),
	(91, 29376210, 180, '2011-03-28', 8285),
	(92, 32778874, 180, '2011-03-28', 57273),
	(93, 50050895, 180, '2011-03-28', 41791),
	(94, 50088638, 180, '2011-03-28', 23507),
	(95, 32687084, 180, '2011-03-28', 39218),
	(96, 32469776, 180, '2011-03-28', 62441),
	(97, 32719941, 180, '2011-03-28', 110570),
	(98, 29376213, 180, '2011-03-28', 40643),
	(99, 50028590, 180, '2011-03-28', 60780),
	(100, 251280, 180, '2011-03-28', 25876),
	(101, 50028646, 180, '2011-03-28', 16488),
	(102, 29376264, 180, '2011-03-28', 31286),
	(103, 32778527, 180, '2011-03-28', 49174),
	(104, 29376231, 180, '2011-03-28', 5794),
	(105, 29292037, 180, '2011-03-28', 29404),
	(106, 29292026, 180, '2011-03-28', 28119),
	(107, 29292023, 180, '2011-03-28', 6891),
	(108, 32735797, 180, '2011-03-28', 77438),
	(109, 32647524, 180, '2011-03-28', 61903),
	(110, 32996418, 180, '2011-03-28', 67189),
	(111, 32735197, 180, '2011-03-28', 8100),
	(112, 29375625, 180, '2011-03-28', 38983),
	(113, 29446613, 180, '2011-03-28', 46535),
	(114, 29376263, 180, '2011-03-28', 20051),
	(115, 50121054, 180, '2011-03-28', 2628),
	(116, 50152351, 180, '2011-03-28', 5523),
	(117, 50156373, 180, '2011-03-28', 3645),
	(118, 50161280, 180, '2011-03-28', 2674),
	(119, 50158093, 180, '2011-03-28', 6131),
	(120, 557538, 180, '2011-03-28', 4232),
	(121, 580689, 180, '2011-03-28', 3715),
	(122, 568796, 180, '2011-03-28', 3169),
	(123, 568693, 180, '2011-03-28', 3136),
	(124, 50135314, 180, '2011-03-28', 2318),
	(125, 32414204, 180, '2011-03-28', 3587),
	(126, 83543477, 180, '2011-03-28', 2191),
	(127, 10498, 180, '2004-07-01', 26267),
	(128, 32687084, 180, '2004-07-01', 8716),
	(129, 32469776, 180, '2004-07-01', 16441),
	(130, 32778874, 180, '2004-07-01', 10751),
	(131, 4547010, 180, '2004-07-01', 1217),
	(132, 110081, 180, '2004-07-01', 50878),
	(133, 50028590, 180, '2004-07-01', 5471),
	(134, 97125, 180, '2004-07-01', 44345),
	(135, 10392, 180, '2004-07-01', 34402),
	(136, 23860702, 180, '2004-07-01', 471),
	(137, 32996418, 180, '2004-07-01', 15961),
	(138, 291044, 180, '2004-07-01', 3468),
	(139, 7950242, 180, '2004-07-01', 43681),
	(140, 556043, 180, '2004-07-01', 20675),
	(141, 3639101, 180, '2004-07-01', 1430),
	(142, 50028646, 180, '2004-07-01', 1412),
	(143, 96397, 180, '2004-07-01', 47513),
	(144, 32778527, 180, '2004-07-01', 12200),
	(145, 3493235, 180, '2004-07-01', 7212),
	(146, 32647524, 180, '2004-07-01', 17720),
	(147, 32719941, 180, '2004-07-01', 18441),
	(148, 45723523, 180, '2004-07-01', 306566),
	(149, 62553772, 180, '2004-07-01', 283700),
	(150, 29446616, 180, '2006-11-01', 6033),
	(151, 29446699, 180, '2006-11-01', 5947),
	(152, 29376219, 180, '2006-11-01', 5904),
	(153, 29376210, 180, '2006-11-01', 1061),
	(154, 32778874, 180, '2006-11-01', 25492),
	(155, 50050895, 180, '2006-11-01', 13409),
	(156, 50088638, 180, '2006-11-01', 5675),
	(157, 32687084, 180, '2006-11-01', 19139),
	(158, 32469776, 180, '2006-11-01', 30138),
	(159, 32719941, 180, '2006-11-01', 43675),
	(160, 29376213, 180, '2006-11-01', 6008),
	(161, 50028590, 180, '2006-11-01', 24392),
	(162, 251280, 180, '2006-11-01', 9073),
	(163, 50028646, 180, '2006-11-01', 6088),
	(164, 29376264, 180, '2006-11-01', 4507),
	(165, 32778527, 180, '2006-11-01', 23516),
	(166, 29376231, 180, '2006-11-01', 2222),
	(167, 184611011, 180, '2006-11-01', 6352),
	(168, 29292026, 180, '2006-11-01', 5194),
	(169, 29292023, 180, '2006-11-01', 1105),
	(170, 32735797, 180, '2006-11-01', 38691),
	(171, 32647524, 180, '2006-11-01', 30874),
	(172, 32996418, 180, '2006-11-01', 38421),
	(173, 29292035, 180, '2006-11-01', 9968),
	(174, 29375625, 180, '2006-11-01', 7536),
	(175, 29446613, 180, '2006-11-01', 6332),
	(176, 29376263, 180, '2006-11-01', 4717),
	(177, 50121054, 180, '2006-11-01', 90),
	(178, 29446616, 180, '2009-02-01', 20697),
	(179, 29446699, 180, '2009-02-01', 22981),
	(180, 29376219, 180, '2009-02-01', 10042),
	(181, 29376210, 180, '2009-02-01', 4600),
	(182, 32778874, 180, '2009-02-01', 40926),
	(183, 50050895, 180, '2009-02-01', 27444),
	(184, 50088638, 180, '2009-02-01', 14240),
	(185, 32687084, 180, '2009-02-01', 29208),
	(186, 32469776, 180, '2009-02-01', 45437),
	(187, 32719941, 180, '2009-02-01', 75461),
	(188, 29376213, 180, '2009-02-01', 23849),
	(189, 50028590, 180, '2009-02-01', 43095),
	(190, 251280, 180, '2009-02-01', 22996),
	(191, 50028646, 180, '2009-02-01', 11196),
	(192, 29376264, 180, '2009-02-01', 17950),
	(193, 32778527, 180, '2009-02-01', 37240),
	(194, 29376231, 180, '2009-02-01', 4447),
	(195, 29292037, 180, '2009-02-01', 19240),
	(196, 29292026, 180, '2009-02-01', 16845),
	(197, 29292023, 180, '2009-02-01', 3896),
	(198, 32735797, 180, '2009-02-01', 57103),
	(199, 32647524, 180, '2009-02-01', 46878),
	(200, 32996418, 180, '2009-02-01', 59874),
	(201, 29292035, 180, '2009-02-01', 27665),
	(202, 29375625, 180, '2009-02-01', 24553),
	(203, 29446613, 180, '2009-02-01', 26544),
	(204, 29376263, 180, '2009-02-01', 16792),
	(205, 50121054, 180, '2009-02-01', 1387),
	(206, 50152351, 180, '2009-02-01', 2277),
	(207, 50156373, 180, '2009-02-01', 1277),
	(208, 50161280, 180, '2009-02-01', 664),
	(209, 50158093, 180, '2009-02-01', 2006),
	(210, 557538, 180, '2009-02-01', 721),
	(211, 580689, 180, '2009-02-01', 316),
	(212, 568796, 180, '2009-02-01', 351),
	(213, 568693, 180, '2009-02-01', 151),
	(214, 50028987, 180, '2011-04-29', 2079),
	(215, 29446699, 180, '2011-04-29', 36087),
	(216, 50089149, 180, '2011-04-29', 366),
	(217, 29376210, 180, '2011-04-29', 8423),
	(218, 32778874, 180, '2011-04-29', 57910),
	(219, 50050895, 180, '2011-04-29', 42255),
	(220, 50088638, 180, '2011-04-29', 23903),
	(221, 32687084, 180, '2011-04-29', 39622),
	(222, 32469776, 180, '2011-04-29', 63093),
	(223, 32719941, 180, '2011-04-29', 111889),
	(224, 29376213, 180, '2011-04-29', 41294),
	(225, 50028590, 180, '2011-04-29', 61346),
	(226, 251280, 180, '2011-04-29', 25970),
	(227, 50028646, 180, '2011-04-29', 16690),
	(228, 29376264, 180, '2011-04-29', 31801),
	(229, 32778527, 180, '2011-04-29', 49652),
	(230, 29376231, 180, '2011-04-29', 5840),
	(231, 29292037, 180, '2011-04-29', 29820),
	(232, 29292026, 180, '2011-04-29', 28540),
	(233, 29292023, 180, '2011-04-29', 6988),
	(234, 32735797, 180, '2011-04-29', 78100),
	(235, 32647524, 180, '2011-04-29', 62364),
	(236, 32996418, 180, '2011-04-29', 67492),
	(237, 32735197, 180, '2011-04-29', 8733),
	(238, 29375625, 180, '2011-04-29', 39518),
	(239, 29446613, 180, '2011-04-29', 47190),
	(240, 29376263, 180, '2011-04-29', 20117),
	(241, 50121054, 180, '2011-04-29', 2672),
	(242, 50152351, 180, '2011-04-29', 5649),
	(243, 50156373, 180, '2011-04-29', 3793),
	(244, 50161280, 180, '2011-04-29', 2753),
	(245, 50158093, 180, '2011-04-29', 6298),
	(246, 557538, 180, '2011-04-29', 4373),
	(247, 580689, 180, '2011-04-29', 3851),
	(248, 568796, 180, '2011-04-29', 3275),
	(249, 568693, 180, '2011-04-29', 3330),
	(250, 50135314, 180, '2011-04-29', 2454),
	(251, 32414204, 180, '2011-04-29', 3850),
	(252, 83543477, 180, '2011-04-29', 2500);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
