-- --------------------------------------------------------
-- 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_meter
CREATE TABLE IF NOT EXISTS `metter_meter` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Skaitītāja ID',
  `ch` char(1) DEFAULT '' COMMENT 'Burts',
  `number` decimal(12,0) unsigned NOT NULL COMMENT 'Skaitītaja Numurs',
  `len` tinyint(3) unsigned NOT NULL COMMENT 'Garums',
  `length` tinyint(3) unsigned NOT NULL COMMENT 'Zīmju skaits',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=275 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Skaitītāju dati';

-- Dumping data for table m.metter_meter: ~331 rows (approximately)
INSERT INTO `metter_meter` (`id`, `ch`, `number`, `len`, `length`) VALUES
	(1, '', 10498, 7, 5),
	(2, '', 32687084, 8, 6),
	(3, '', 32469776, 8, 6),
	(4, '', 32778874, 8, 6),
	(5, '', 4547010, 7, 4),
	(6, '', 110081, 7, 5),
	(7, '', 50028590, 8, 6),
	(8, '', 97125, 7, 5),
	(9, '', 10392, 7, 5),
	(10, '', 23860702, 8, 4),
	(11, '', 32996418, 8, 6),
	(12, '', 291044, 6, 4),
	(13, '', 7950242, 7, 5),
	(14, '', 556043, 7, 6),
	(15, '', 3639101, 7, 4),
	(16, '', 50028646, 8, 6),
	(17, '', 96397, 7, 5),
	(18, '', 32778527, 8, 6),
	(19, '', 3493235, 7, 4),
	(20, '', 32647524, 8, 6),
	(21, '', 32719941, 8, 6),
	(22, '', 45723523, 8, 6),
	(23, '', 62553772, 8, 7),
	(24, '', 29446616, 8, 6),
	(25, '', 29446699, 8, 6),
	(26, '', 29376219, 8, 6),
	(27, '', 29376210, 8, 6),
	(28, '', 32778874, 8, 6),
	(29, '', 50050895, 8, 6),
	(30, '', 50088638, 8, 6),
	(31, '', 32687084, 8, 6),
	(32, '', 32469776, 8, 6),
	(33, '', 32719941, 8, 6),
	(34, '', 32719941, 8, 6),
	(35, '', 29376213, 8, 6),
	(36, '', 50028590, 8, 6),
	(37, '', 251280, 6, 8),
	(38, '', 50028646, 8, 6),
	(39, '', 29376264, 8, 6),
	(40, '', 32778527, 8, 6),
	(41, '', 32778527, 8, 6),
	(42, '', 29376231, 8, 6),
	(43, '', 184611011, 9, 6),
	(44, '', 29292026, 8, 6),
	(45, '', 29292023, 8, 6),
	(46, '', 32735797, 8, 6),
	(47, '', 32647524, 8, 6),
	(48, '', 32996418, 8, 6),
	(49, '', 32996418, 8, 6),
	(50, '', 29292035, 8, 6),
	(51, '', 29375625, 8, 6),
	(52, '', 29446613, 8, 6),
	(53, '', 29376263, 8, 6),
	(54, '', 50121054, 8, 6),
	(55, '', 29446616, 8, 6),
	(56, '', 29446699, 8, 6),
	(57, '', 29376219, 8, 6),
	(58, '', 29376210, 8, 6),
	(59, '', 32778874, 8, 6),
	(60, '', 50050895, 8, 6),
	(61, '', 50088638, 8, 6),
	(62, '', 32687084, 8, 6),
	(63, '', 32469776, 8, 6),
	(64, '', 32719941, 8, 6),
	(65, '', 32719941, 8, 6),
	(66, '', 29376213, 8, 6),
	(67, '', 50028590, 8, 6),
	(68, '', 251280, 6, 8),
	(69, '', 50028646, 8, 6),
	(70, '', 29376264, 8, 6),
	(71, '', 32778527, 8, 6),
	(72, '', 32778527, 8, 6),
	(73, '', 29376231, 8, 6),
	(74, '', 29292037, 8, 6),
	(75, '', 29292026, 8, 6),
	(76, '', 29292023, 8, 6),
	(77, '', 32735797, 8, 6),
	(78, '', 32647524, 8, 6),
	(79, '', 32996418, 8, 6),
	(80, '', 32996418, 8, 6),
	(81, '', 29292035, 8, 6),
	(82, '', 29375625, 8, 6),
	(83, '', 29446613, 8, 6),
	(84, '', 29376263, 8, 6),
	(85, '', 50121054, 8, 6),
	(86, '', 50152351, 8, 6),
	(87, '', 50156373, 8, 6),
	(88, '', 50161280, 8, 6),
	(89, '', 50158093, 8, 6),
	(90, '', 557538, 6, 8),
	(91, '', 580689, 6, 8),
	(92, '', 568796, 6, 8),
	(93, '', 568693, 6, 8),
	(94, '', 50028987, 8, 6),
	(95, '', 29446699, 8, 6),
	(96, '', 50089149, 8, 6),
	(97, '', 29376210, 8, 6),
	(98, '', 32778874, 8, 6),
	(99, '', 50050895, 8, 6),
	(100, '', 50088638, 8, 6),
	(101, '', 32687084, 8, 6),
	(102, '', 32469776, 8, 6),
	(103, '', 32719941, 8, 6),
	(104, '', 32719941, 8, 6),
	(105, '', 29376213, 8, 6),
	(106, '', 50028590, 8, 6),
	(107, '', 251280, 6, 8),
	(108, '', 50028646, 8, 6),
	(109, '', 29376264, 8, 6),
	(110, '', 32778527, 8, 6),
	(111, '', 32778527, 8, 6),
	(112, '', 29376231, 8, 6),
	(113, '', 29292037, 8, 6),
	(114, '', 29292026, 8, 6),
	(115, '', 29292023, 8, 6),
	(116, '', 32735797, 8, 6),
	(117, '', 32647524, 8, 6),
	(118, '', 32996418, 8, 6),
	(119, '', 32996418, 8, 6),
	(120, '', 32735197, 8, 6),
	(121, '', 29375625, 8, 6),
	(122, '', 29446613, 8, 6),
	(123, '', 29376263, 8, 6),
	(124, '', 50121054, 8, 6),
	(125, '', 50152351, 8, 6),
	(126, '', 50156373, 8, 6),
	(127, '', 50161280, 8, 6),
	(128, '', 50158093, 8, 6),
	(129, '', 557538, 6, 8),
	(130, '', 580689, 6, 8),
	(131, '', 568796, 6, 8),
	(132, '', 568693, 6, 8),
	(133, '', 50135314, 8, 6),
	(134, '', 32414204, 8, 6),
	(135, '', 32414204, 8, 6),
	(136, '', 83543477, 8, 6),
	(137, '', 83543477, 8, 6),
	(138, '', 10498, 7, 5),
	(139, '', 32687084, 8, 6),
	(140, '', 32469776, 8, 6),
	(141, '', 32778874, 8, 6),
	(142, '', 4547010, 7, 4),
	(143, '', 110081, 7, 5),
	(144, '', 50028590, 8, 6),
	(145, '', 97125, 7, 5),
	(146, '', 10392, 7, 5),
	(147, '', 23860702, 8, 4),
	(148, '', 32996418, 8, 6),
	(149, '', 291044, 6, 4),
	(150, '', 7950242, 7, 5),
	(151, '', 556043, 7, 6),
	(152, '', 3639101, 7, 4),
	(153, '', 50028646, 8, 6),
	(154, '', 96397, 7, 5),
	(155, '', 32778527, 8, 6),
	(156, '', 3493235, 7, 4),
	(157, '', 32647524, 8, 6),
	(158, '', 32719941, 8, 6),
	(159, '', 45723523, 8, 6),
	(160, '', 62553772, 8, 7),
	(161, '', 29446616, 8, 6),
	(162, '', 29446699, 8, 6),
	(163, '', 29376219, 8, 6),
	(164, '', 29376210, 8, 6),
	(165, '', 32778874, 8, 6),
	(166, '', 50050895, 8, 6),
	(167, '', 50088638, 8, 6),
	(168, '', 32687084, 8, 6),
	(169, '', 32469776, 8, 6),
	(170, '', 32719941, 8, 6),
	(171, '', 32719941, 8, 6),
	(172, '', 29376213, 8, 6),
	(173, '', 50028590, 8, 6),
	(174, '', 251280, 6, 8),
	(175, '', 50028646, 8, 6),
	(176, '', 29376264, 8, 6),
	(177, '', 32778527, 8, 6),
	(178, '', 32778527, 8, 6),
	(179, '', 29376231, 8, 6),
	(180, '', 184611011, 9, 6),
	(181, '', 29292026, 8, 6),
	(182, '', 29292023, 8, 6),
	(183, '', 32735797, 8, 6),
	(184, '', 32647524, 8, 6),
	(185, '', 32996418, 8, 6),
	(186, '', 32996418, 8, 6),
	(187, '', 29292035, 8, 6),
	(188, '', 29375625, 8, 6),
	(189, '', 29446613, 8, 6),
	(190, '', 29376263, 8, 6),
	(191, '', 50121054, 8, 6),
	(192, '', 29446616, 8, 6),
	(193, '', 29446699, 8, 6),
	(194, '', 29376219, 8, 6),
	(195, '', 29376210, 8, 6),
	(196, '', 32778874, 8, 6),
	(197, '', 50050895, 8, 6),
	(198, '', 50088638, 8, 6),
	(199, '', 32687084, 8, 6),
	(200, '', 32469776, 8, 6),
	(201, '', 32719941, 8, 6),
	(202, '', 32719941, 8, 6),
	(203, '', 29376213, 8, 6),
	(204, '', 50028590, 8, 6),
	(205, '', 251280, 6, 8),
	(206, '', 50028646, 8, 6),
	(207, '', 29376264, 8, 6),
	(208, '', 32778527, 8, 6),
	(209, '', 32778527, 8, 6),
	(210, '', 29376231, 8, 6),
	(211, '', 29292037, 8, 6),
	(212, '', 29292026, 8, 6),
	(213, '', 29292023, 8, 6),
	(214, '', 32735797, 8, 6),
	(215, '', 32647524, 8, 6),
	(216, '', 32996418, 8, 6),
	(217, '', 32996418, 8, 6),
	(218, '', 29292035, 8, 6),
	(219, '', 29375625, 8, 6),
	(220, '', 29446613, 8, 6),
	(221, '', 29376263, 8, 6),
	(222, '', 50121054, 8, 6),
	(223, '', 50152351, 8, 6),
	(224, '', 50156373, 8, 6),
	(225, '', 50161280, 8, 6),
	(226, '', 50158093, 8, 6),
	(227, '', 557538, 6, 8),
	(228, '', 580689, 6, 8),
	(229, '', 568796, 6, 8),
	(230, '', 568693, 6, 8),
	(231, '', 50028987, 8, 6),
	(232, '', 29446699, 8, 6),
	(233, '', 50089149, 8, 6),
	(234, '', 29376210, 8, 6),
	(235, '', 32778874, 8, 6),
	(236, '', 50050895, 8, 6),
	(237, '', 50088638, 8, 6),
	(238, '', 32687084, 8, 6),
	(239, '', 32469776, 8, 6),
	(240, '', 32719941, 8, 6),
	(241, '', 32719941, 8, 6),
	(242, '', 29376213, 8, 6),
	(243, '', 50028590, 8, 6),
	(244, '', 251280, 6, 8),
	(245, '', 50028646, 8, 6),
	(246, '', 29376264, 8, 6),
	(247, '', 32778527, 8, 6),
	(248, '', 32778527, 8, 6),
	(249, '', 29376231, 8, 6),
	(250, '', 29292037, 8, 6),
	(251, '', 29292026, 8, 6),
	(252, '', 29292023, 8, 6),
	(253, '', 32735797, 8, 6),
	(254, '', 32647524, 8, 6),
	(255, '', 32996418, 8, 6),
	(256, '', 32996418, 8, 6),
	(257, '', 32735197, 8, 6),
	(258, '', 29375625, 8, 6),
	(259, '', 29446613, 8, 6),
	(260, '', 29376263, 8, 6),
	(261, '', 50121054, 8, 6),
	(262, '', 50152351, 8, 6),
	(263, '', 50156373, 8, 6),
	(264, '', 50161280, 8, 6),
	(265, '', 50158093, 8, 6),
	(266, '', 557538, 6, 8),
	(267, '', 580689, 6, 8),
	(268, '', 568796, 6, 8),
	(269, '', 568693, 6, 8),
	(270, '', 50135314, 8, 6),
	(271, '', 32414204, 8, 6),
	(272, '', 32414204, 8, 6),
	(273, '', 83543477, 8, 6),
	(274, '', 83543477, 8, 6),
	(275, '', 10498, 7, 5),
	(276, '', 32687084, 8, 6),
	(277, '', 32469776, 8, 6),
	(278, '', 32778874, 8, 6),
	(279, '', 4547010, 7, 4),
	(280, '', 110081, 7, 5),
	(281, '', 50028590, 8, 6),
	(282, '', 97125, 7, 5),
	(283, '', 10392, 7, 5),
	(284, '', 23860702, 8, 4),
	(285, '', 32996418, 8, 6),
	(286, '', 291044, 6, 4),
	(287, '', 7950242, 7, 5),
	(288, '', 556043, 7, 6),
	(289, '', 3639101, 7, 4),
	(290, '', 50028646, 8, 6),
	(291, '', 96397, 7, 5),
	(292, '', 32778527, 8, 6),
	(293, '', 3493235, 7, 4),
	(294, '', 32647524, 8, 6),
	(295, '', 32719941, 8, 6),
	(296, '', 45723523, 8, 6),
	(297, '', 62553772, 8, 7),
	(298, '', 29446616, 8, 6),
	(299, '', 29446699, 8, 6),
	(300, '', 29376219, 8, 6),
	(301, '', 29376210, 8, 6),
	(302, '', 50050895, 8, 6),
	(303, '', 50088638, 8, 6),
	(304, '', 29376213, 8, 6),
	(305, '', 251280, 6, 8),
	(306, '', 29376264, 8, 6),
	(307, '', 29376231, 8, 6),
	(308, '', 184611011, 9, 6),
	(309, '', 29292026, 8, 6),
	(310, '', 29292023, 8, 6),
	(311, '', 32735797, 8, 6),
	(312, '', 29292035, 8, 6),
	(313, '', 29375625, 8, 6),
	(314, '', 29446613, 8, 6),
	(315, '', 29376263, 8, 6),
	(316, '', 50121054, 8, 6),
	(317, '', 29292037, 8, 6),
	(318, '', 50152351, 8, 6),
	(319, '', 50156373, 8, 6),
	(320, '', 50161280, 8, 6),
	(321, '', 50158093, 8, 6),
	(322, '', 557538, 6, 8),
	(323, '', 580689, 6, 8),
	(324, '', 568796, 6, 8),
	(325, '', 568693, 6, 8),
	(326, '', 50028987, 8, 6),
	(327, '', 50089149, 8, 6),
	(328, '', 32735197, 8, 6),
	(329, '', 50135314, 8, 6),
	(330, '', 32414204, 8, 6),
	(331, '', 83543477, 8, 6);

/*!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) */;