-- --------------------------------------------------------
-- 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 database structure for denis_adreses
CREATE DATABASE IF NOT EXISTS `denis_adreses` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `denis_adreses`;

-- Dumping structure for table denis_adreses.denis_address_index_copy
CREATE TABLE IF NOT EXISTS `denis_address_index_copy` (
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses indeksa ID',
  `number` smallint(5) unsigned NOT NULL COMMENT 'Adreses indekss',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Adreses indeksi';

-- Dumping data for table denis_adreses.denis_address_index_copy: ~694 rows (approximately)
INSERT INTO `denis_address_index_copy` (`id`, `number`) VALUES
	(1, 1001),
	(2, 1002),
	(3, 1003),
	(4, 1004),
	(5, 1005),
	(6, 1006),
	(7, 1007),
	(8, 1009),
	(9, 1010),
	(10, 1011),
	(11, 1012),
	(12, 1013),
	(13, 1014),
	(14, 1015),
	(15, 1016),
	(16, 1019),
	(17, 1021),
	(18, 1023),
	(19, 1024),
	(20, 1026),
	(21, 1029),
	(22, 1030),
	(23, 1034),
	(24, 1035),
	(25, 1038),
	(26, 1039),
	(27, 1044),
	(28, 1045),
	(29, 1046),
	(30, 1048),
	(31, 1050),
	(32, 1053),
	(33, 1055),
	(34, 1057),
	(35, 1058),
	(36, 1063),
	(37, 1064),
	(38, 1067),
	(39, 1069),
	(40, 1073),
	(41, 1076),
	(42, 1079),
	(43, 1082),
	(44, 1083),
	(45, 1084),
	(46, 2008),
	(47, 2010),
	(48, 2011),
	(49, 2012),
	(50, 2015),
	(51, 2016),
	(52, 2101),
	(53, 2103),
	(54, 2105),
	(55, 2107),
	(56, 2108),
	(57, 2111),
	(58, 2112),
	(59, 2113),
	(60, 2114),
	(61, 2117),
	(62, 2118),
	(63, 2119),
	(64, 2121),
	(65, 2123),
	(66, 2124),
	(67, 2125),
	(68, 2127),
	(69, 2128),
	(70, 2130),
	(71, 2133),
	(72, 2135),
	(73, 2136),
	(74, 2137),
	(75, 2140),
	(76, 2141),
	(77, 2142),
	(78, 2144),
	(79, 2145),
	(80, 2150),
	(81, 2151),
	(82, 2152),
	(83, 2154),
	(84, 2160),
	(85, 2161),
	(86, 2162),
	(87, 2163),
	(88, 2164),
	(89, 2166),
	(90, 2167),
	(91, 2169),
	(92, 2170),
	(93, 3001),
	(94, 3002),
	(95, 3003),
	(96, 3004),
	(97, 3007),
	(98, 3008),
	(99, 3011),
	(100, 3014),
	(101, 3016),
	(102, 3017),
	(103, 3018),
	(104, 3020),
	(105, 3021),
	(106, 3022),
	(107, 3023),
	(108, 3026),
	(109, 3028),
	(110, 3031),
	(111, 3034),
	(112, 3036),
	(113, 3037),
	(114, 3040),
	(115, 3042),
	(116, 3043),
	(117, 3045),
	(118, 3101),
	(119, 3104),
	(120, 3110),
	(121, 3113),
	(122, 3118),
	(123, 3119),
	(124, 3120),
	(125, 3122),
	(126, 3123),
	(127, 3124),
	(128, 3128),
	(129, 3129),
	(130, 3131),
	(131, 3132),
	(132, 3133),
	(133, 3134),
	(134, 3135),
	(135, 3137),
	(136, 3139),
	(137, 3140),
	(138, 3142),
	(139, 3145),
	(140, 3146),
	(141, 3147),
	(142, 3148),
	(143, 3201),
	(144, 3251),
	(145, 3253),
	(146, 3257),
	(147, 3258),
	(148, 3260),
	(149, 3261),
	(150, 3262),
	(151, 3264),
	(152, 3270),
	(153, 3275),
	(154, 3280),
	(155, 3281),
	(156, 3283),
	(157, 3284),
	(158, 3285),
	(159, 3287),
	(160, 3291),
	(161, 3292),
	(162, 3294),
	(163, 3297),
	(164, 3298),
	(165, 3301),
	(166, 3306),
	(167, 3307),
	(168, 3309),
	(169, 3310),
	(170, 3312),
	(171, 3313),
	(172, 3314),
	(173, 3317),
	(174, 3319),
	(175, 3320),
	(176, 3321),
	(177, 3322),
	(178, 3323),
	(179, 3324),
	(180, 3325),
	(181, 3326),
	(182, 3328),
	(183, 3329),
	(184, 3330),
	(185, 3332),
	(186, 3333),
	(187, 3401),
	(188, 3402),
	(189, 3405),
	(190, 3407),
	(191, 3411),
	(192, 3414),
	(193, 3416),
	(194, 3430),
	(195, 3431),
	(196, 3433),
	(197, 3434),
	(198, 3435),
	(199, 3436),
	(200, 3438),
	(201, 3440),
	(202, 3441),
	(203, 3442),
	(204, 3443),
	(205, 3444),
	(206, 3445),
	(207, 3446),
	(208, 3447),
	(209, 3452),
	(210, 3453),
	(211, 3455),
	(212, 3456),
	(213, 3457),
	(214, 3461),
	(215, 3463),
	(216, 3466),
	(217, 3473),
	(218, 3474),
	(219, 3475),
	(220, 3476),
	(221, 3477),
	(222, 3480),
	(223, 3482),
	(224, 3484),
	(225, 3485),
	(226, 3486),
	(227, 3487),
	(228, 3601),
	(229, 3602),
	(230, 3604),
	(231, 3612),
	(232, 3613),
	(233, 3614),
	(234, 3615),
	(235, 3617),
	(236, 3619),
	(237, 3620),
	(238, 3621),
	(239, 3623),
	(240, 3624),
	(241, 3626),
	(242, 3627),
	(243, 3701),
	(244, 3708),
	(245, 3709),
	(246, 3710),
	(247, 3711),
	(248, 3713),
	(249, 3714),
	(250, 3716),
	(251, 3717),
	(252, 3718),
	(253, 3719),
	(254, 3721),
	(255, 3722),
	(256, 3723),
	(257, 3724),
	(258, 3725),
	(259, 3729),
	(260, 3730),
	(261, 3731),
	(262, 3732),
	(263, 3801),
	(264, 3851),
	(265, 3852),
	(266, 3853),
	(267, 3861),
	(268, 3862),
	(269, 3871),
	(270, 3873),
	(271, 3875),
	(272, 3876),
	(273, 3880),
	(274, 3882),
	(275, 3883),
	(276, 3890),
	(277, 3891),
	(278, 3892),
	(279, 3893),
	(280, 3894),
	(281, 3895),
	(282, 3896),
	(283, 3897),
	(284, 3898),
	(285, 3899),
	(286, 3901),
	(287, 3905),
	(288, 3906),
	(289, 3907),
	(290, 3908),
	(291, 3910),
	(292, 3913),
	(293, 3914),
	(294, 3915),
	(295, 3917),
	(296, 3918),
	(297, 3921),
	(298, 3924),
	(299, 3925),
	(300, 3926),
	(301, 3927),
	(302, 3929),
	(303, 3930),
	(304, 3931),
	(305, 3932),
	(306, 3933),
	(307, 3936),
	(308, 4001),
	(309, 4004),
	(310, 4010),
	(311, 4011),
	(312, 4012),
	(313, 4013),
	(314, 4020),
	(315, 4022),
	(316, 4023),
	(317, 4025),
	(318, 4033),
	(319, 4035),
	(320, 4043),
	(321, 4050),
	(322, 4052),
	(323, 4054),
	(324, 4061),
	(325, 4063),
	(326, 4064),
	(327, 4068),
	(328, 4101),
	(329, 4108),
	(330, 4110),
	(331, 4112),
	(332, 4113),
	(333, 4116),
	(334, 4118),
	(335, 4119),
	(336, 4122),
	(337, 4123),
	(338, 4125),
	(339, 4126),
	(340, 4128),
	(341, 4129),
	(342, 4131),
	(343, 4132),
	(344, 4133),
	(345, 4136),
	(346, 4139),
	(347, 4141),
	(348, 4143),
	(349, 4144),
	(350, 4146),
	(351, 4151),
	(352, 4152),
	(353, 4154),
	(354, 4201),
	(355, 4206),
	(356, 4208),
	(357, 4210),
	(358, 4211),
	(359, 4213),
	(360, 4215),
	(361, 4216),
	(362, 4219),
	(363, 4220),
	(364, 4222),
	(365, 4223),
	(366, 4224),
	(367, 4227),
	(368, 4228),
	(369, 4232),
	(370, 4234),
	(371, 4240),
	(372, 4241),
	(373, 4242),
	(374, 4244),
	(375, 4245),
	(376, 4247),
	(377, 4248),
	(378, 4301),
	(379, 4332),
	(380, 4333),
	(381, 4335),
	(382, 4336),
	(383, 4337),
	(384, 4339),
	(385, 4340),
	(386, 4341),
	(387, 4342),
	(388, 4344),
	(389, 4345),
	(390, 4348),
	(391, 4350),
	(392, 4351),
	(393, 4352),
	(394, 4354),
	(395, 4355),
	(396, 4358),
	(397, 4359),
	(398, 4401),
	(399, 4405),
	(400, 4406),
	(401, 4409),
	(402, 4410),
	(403, 4412),
	(404, 4415),
	(405, 4416),
	(406, 4417),
	(407, 4420),
	(408, 4421),
	(409, 4424),
	(410, 4425),
	(411, 4426),
	(412, 4428),
	(413, 4429),
	(414, 4501),
	(415, 4561),
	(416, 4562),
	(417, 4566),
	(418, 4567),
	(419, 4570),
	(420, 4571),
	(421, 4572),
	(422, 4573),
	(423, 4574),
	(424, 4576),
	(425, 4577),
	(426, 4580),
	(427, 4582),
	(428, 4583),
	(429, 4584),
	(430, 4585),
	(431, 4586),
	(432, 4587),
	(433, 4590),
	(434, 4591),
	(435, 4592),
	(436, 4594),
	(437, 4595),
	(438, 4601),
	(439, 4604),
	(440, 4611),
	(441, 4612),
	(442, 4614),
	(443, 4615),
	(444, 4616),
	(445, 4617),
	(446, 4618),
	(447, 4619),
	(448, 4621),
	(449, 4622),
	(450, 4623),
	(451, 4625),
	(452, 4626),
	(453, 4627),
	(454, 4628),
	(455, 4630),
	(456, 4631),
	(457, 4633),
	(458, 4634),
	(459, 4635),
	(460, 4636),
	(461, 4638),
	(462, 4640),
	(463, 4641),
	(464, 4642),
	(465, 4643),
	(466, 4645),
	(467, 4647),
	(468, 4648),
	(469, 4649),
	(470, 4650),
	(471, 4652),
	(472, 4701),
	(473, 4706),
	(474, 4707),
	(475, 4708),
	(476, 4711),
	(477, 4712),
	(478, 4713),
	(479, 4715),
	(480, 4716),
	(481, 4718),
	(482, 4723),
	(483, 4724),
	(484, 4726),
	(485, 4727),
	(486, 4728),
	(487, 4729),
	(488, 4730),
	(489, 4731),
	(490, 4733),
	(491, 4735),
	(492, 4801),
	(493, 4824),
	(494, 4825),
	(495, 4826),
	(496, 4830),
	(497, 4833),
	(498, 4834),
	(499, 4835),
	(500, 4836),
	(501, 4837),
	(502, 4838),
	(503, 4840),
	(504, 4841),
	(505, 4844),
	(506, 4846),
	(507, 4847),
	(508, 4852),
	(509, 4853),
	(510, 4855),
	(511, 4860),
	(512, 4862),
	(513, 4863),
	(514, 4865),
	(515, 4870),
	(516, 4871),
	(517, 4873),
	(518, 4880),
	(519, 4884),
	(520, 5001),
	(521, 5011),
	(522, 5012),
	(523, 5015),
	(524, 5016),
	(525, 5020),
	(526, 5022),
	(527, 5033),
	(528, 5041),
	(529, 5044),
	(530, 5045),
	(531, 5047),
	(532, 5052),
	(533, 5060),
	(534, 5062),
	(535, 5064),
	(536, 5065),
	(537, 5070),
	(538, 5071),
	(539, 5101),
	(540, 5106),
	(541, 5108),
	(542, 5109),
	(543, 5110),
	(544, 5111),
	(545, 5112),
	(546, 5113),
	(547, 5115),
	(548, 5118),
	(549, 5120),
	(550, 5123),
	(551, 5124),
	(552, 5125),
	(553, 5128),
	(554, 5129),
	(555, 5130),
	(556, 5133),
	(557, 5134),
	(558, 5135),
	(559, 5201),
	(560, 5202),
	(561, 5204),
	(562, 5208),
	(563, 5209),
	(564, 5210),
	(565, 5211),
	(566, 5212),
	(567, 5214),
	(568, 5215),
	(569, 5216),
	(570, 5217),
	(571, 5218),
	(572, 5220),
	(573, 5221),
	(574, 5222),
	(575, 5223),
	(576, 5224),
	(577, 5226),
	(578, 5228),
	(579, 5229),
	(580, 5230),
	(581, 5232),
	(582, 5236),
	(583, 5237),
	(584, 5238),
	(585, 5239),
	(586, 5301),
	(587, 5304),
	(588, 5305),
	(589, 5311),
	(590, 5312),
	(591, 5315),
	(592, 5316),
	(593, 5318),
	(594, 5320),
	(595, 5323),
	(596, 5325),
	(597, 5326),
	(598, 5327),
	(599, 5328),
	(600, 5329),
	(601, 5330),
	(602, 5331),
	(603, 5333),
	(604, 5334),
	(605, 5335),
	(606, 5337),
	(607, 5401),
	(608, 5404),
	(609, 5410),
	(610, 5412),
	(611, 5413),
	(612, 5414),
	(613, 5415),
	(614, 5417),
	(615, 5418),
	(616, 5422),
	(617, 5438),
	(618, 5439),
	(619, 5440),
	(620, 5441),
	(621, 5442),
	(622, 5443),
	(623, 5444),
	(624, 5447),
	(625, 5449),
	(626, 5450),
	(627, 5451),
	(628, 5456),
	(629, 5458),
	(630, 5459),
	(631, 5460),
	(632, 5461),
	(633, 5462),
	(634, 5463),
	(635, 5465),
	(636, 5469),
	(637, 5470),
	(638, 5471),
	(639, 5473),
	(640, 5474),
	(641, 5477),
	(642, 5481),
	(643, 5601),
	(644, 5651),
	(645, 5652),
	(646, 5653),
	(647, 5655),
	(648, 5656),
	(649, 5660),
	(650, 5662),
	(651, 5664),
	(652, 5666),
	(653, 5668),
	(654, 5671),
	(655, 5674),
	(656, 5676),
	(657, 5677),
	(658, 5680),
	(659, 5681),
	(660, 5685),
	(661, 5687),
	(662, 5692),
	(663, 5695),
	(664, 5696),
	(665, 5697),
	(666, 5698),
	(667, 5701),
	(668, 5704),
	(669, 5705),
	(670, 5706),
	(671, 5707),
	(672, 5709),
	(673, 5711),
	(674, 5716),
	(675, 5717),
	(676, 5719),
	(677, 5722),
	(678, 5725),
	(679, 5726),
	(680, 5729),
	(681, 5730),
	(682, 5732),
	(683, 5733),
	(684, 5735),
	(685, 5736),
	(686, 5737),
	(687, 5739),
	(688, 5740),
	(689, 5742),
	(690, 5745),
	(691, 5748),
	(692, 5750),
	(693, 5751),
	(694, 5752);

-- Dumping structure for table denis_adreses.denis_address_level_copy
CREATE TABLE IF NOT EXISTS `denis_address_level_copy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Adreses līmeņa ID',
  `name` varchar(10) NOT NULL COMMENT 'Adreses līmenis',
  `fname` varchar(50) DEFAULT '' COMMENT 'Adreses līmeņa pilnais nosaukums',
  `sname` varchar(5) DEFAULT '' COMMENT 'Adreses līmeņa īsais nosaukums',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Adreses līmenis';

-- Dumping data for table denis_adreses.denis_address_level_copy: ~9 rows (approximately)
INSERT INTO `denis_address_level_copy` (`id`, `name`, `fname`, `sname`) VALUES
	(1, 'Valsts', 'Valsts', '\r'),
	(2, 'Novads', 'Novads', 'nov.\r'),
	(3, 'Vlasts pil', 'Vlasts pilseta', '\r'),
	(4, 'Pilseta', 'Pilseta', '\r'),
	(5, 'Pagasts', 'Pagasts', 'pag.\r'),
	(6, 'Ciems', 'Ciems/mezciems', '\r'),
	(7, 'Iela', 'iela', '\r'),
	(8, 'Ēka', 'Ekas nr./ Nosaukums, korpuss ', '\r'),
	(9, 'Telpa', 'Telpu grupa (dzīvoklis);', NULL);

-- Dumping structure for table denis_adreses.denis_address_name_copy
CREATE TABLE IF NOT EXISTS `denis_address_name_copy` (
  `id_address_name` int(10) unsigned NOT NULL COMMENT 'Piesaistītās adreses ID',
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses ID',
  `name` varchar(20) NOT NULL COMMENT 'Nosaukums',
  `id_address_level` int(10) unsigned NOT NULL COMMENT 'Adreses līmeņa ID',
  `id_address_index` int(10) unsigned DEFAULT 0 COMMENT 'Pasta indeksa ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id_level` (`id_address_level`,`id_address_name`) USING BTREE,
  KEY `FK_address_name_address_name` (`id_address_name`) USING BTREE,
  KEY `FK_address_name_address_index` (`id_address_index`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Adreses';

-- Dumping data for table denis_adreses.denis_address_name_copy: ~106 rows (approximately)
INSERT INTO `denis_address_name_copy` (`id_address_name`, `id`, `name`, `id_address_level`, `id_address_index`) VALUES
	(100000000, 100000000, 'Latvija', 1, 0),
	(100016542, 100015034, 'Audriņu pag', 5, 0),
	(100000000, 100016542, 'Rēzeknes nov.', 2, 0),
	(100015034, 100173021, 'Audriņi', 6, 0),
	(100015034, 100173038, 'Asači', 6, 0),
	(100015034, 100173046, 'Aļhovka', 6, 0),
	(100173021, 100380878, 'Krasuhas iela', 7, 0),
	(100173021, 100380886, 'Lidicas iela', 7, 0),
	(100173021, 100380894, 'Piemiņas iela', 7, 0),
	(100173021, 100380900, 'Rēzeknes iela', 7, 0),
	(100173021, 100380917, 'Saules iela', 7, 0),
	(100173021, 100427945, 'Dārzu iela', 7, 0),
	(100173021, 100499500, 'Liepu aleja', 7, 0),
	(100380886, 101328260, 'Lidicas iela 16', 8, 440),
	(100380886, 101328277, 'Lidicas iela 3', 8, 440),
	(100380886, 101328285, 'Lidicas iela 5', 8, 440),
	(100380886, 101328293, 'Lidicas iela 8', 8, 440),
	(100380886, 101328308, 'Lidicas iela 9', 8, 440),
	(100380894, 101328316, 'Piemiņas iela 1', 8, 440),
	(100380894, 101328324, 'Piemiņas iela 10', 8, 440),
	(100380894, 101328332, 'Piemiņas iela 13', 8, 440),
	(100380894, 101328340, 'Piemiņas iela 17', 8, 440),
	(100380894, 101328357, 'Piemiņas iela 17A', 8, 440),
	(100380894, 101328381, 'Piemiņas iela 3', 8, 440),
	(100380894, 101328398, 'Piemiņas iela 8', 8, 440),
	(100380917, 101328404, 'Saules iela 1', 8, 440),
	(100380878, 102139213, 'Krasuhas iela 2', 8, 440),
	(100380878, 102139221, 'Krasuhas iela 2A', 8, 440),
	(100380878, 102139238, 'Krasuhas iela 4', 8, 440),
	(100380886, 102139246, 'Lidicas iela 1', 8, 440),
	(100380886, 102139254, 'Lidicas iela 10', 8, 440),
	(100380886, 102139262, 'Lidicas iela 11', 8, 440),
	(100380886, 102139270, 'Lidicas iela 14', 8, 440),
	(100380886, 102139287, 'Lidicas iela 1A', 8, 440),
	(100380886, 102139295, 'Lidicas iela 2', 8, 440),
	(100380886, 102139301, 'Lidicas iela 4', 8, 440),
	(100380886, 102139318, 'Lidicas iela 6', 8, 440),
	(100380886, 102139326, 'Lidicas iela 7', 8, 440),
	(100380894, 102139334, 'Piemiņas iela 12', 8, 440),
	(100380894, 102139342, 'Piemiņas iela 14', 8, 440),
	(100380894, 102139350, 'Piemiņas iela 16', 8, 440),
	(100380894, 102139383, 'Piemiņas iela 2', 8, 440),
	(100380894, 102139463, 'Piemiņas iela 5', 8, 440),
	(100380894, 102139471, 'Piemiņas iela 7', 8, 440),
	(100380900, 102139488, 'Rēzeknes iela 1', 8, 440),
	(100380900, 102139496, 'Rēzeknes iela 2', 8, 440),
	(100380900, 102139502, 'Rēzeknes iela 3', 8, 440),
	(100380917, 102139510, 'Saules iela 3', 8, 440),
	(100380917, 102139527, 'Saules iela 5', 8, 440),
	(100380894, 102596325, 'Piemiņas iela 11', 8, 440),
	(100380900, 102621353, 'Rēzeknes iela 4', 8, 440),
	(100380886, 102680013, 'Lidicas iela 13', 8, 440),
	(100380894, 103169908, 'Piemiņas iela 4', 8, 440),
	(100427945, 103454018, 'Dārzu iela 12', 8, 440),
	(100173038, 103454050, '"Smilšu kalns"', 8, 440),
	(100173038, 103454067, '"Kravcovu mājas"', 8, 440),
	(100173038, 103454075, '"Filipovka"', 8, 440),
	(100173038, 103454091, '"Asteres"', 8, 440),
	(100173038, 103454106, '"Ivuška"', 8, 440),
	(100173046, 103454114, '"Kārkliņi"', 8, 440),
	(100173046, 103454862, '"Matisiņš"', 8, 440),
	(100380894, 103456070, 'Piemiņas iela 15', 8, 440),
	(100427945, 103456095, 'Dārzu iela 1', 8, 440),
	(100427945, 103456101, 'Dārzu iela 5', 8, 440),
	(100380886, 103456118, 'Lidicas iela 15', 8, 440),
	(100380886, 104239486, 'Lidicas iela 12', 8, 440),
	(100427945, 104239494, 'Dārzu iela 3', 8, 440),
	(100427945, 104239500, 'Dārzu iela 4', 8, 440),
	(100173038, 104239525, '"Pūciņa"', 8, 440),
	(100173038, 104239533, '"Kristīne"', 8, 440),
	(100173038, 104239541, '"Ģimeņu viensēta"', 8, 440),
	(100173038, 104239558, '"Māliņi"', 8, 440),
	(100173046, 104239566, '"Aļhovka"', 8, 440),
	(100380878, 105549746, 'Krasuhas iela 1B', 8, 440),
	(100380886, 105686613, 'Lidicas iela 17', 8, 440),
	(100380894, 105837698, 'Piemiņas iela 9A', 8, 440),
	(100499500, 105837704, 'Liepu aleja 1', 8, 440),
	(100380878, 105837712, 'Krasuhas iela 3', 8, 440),
	(100427945, 105837753, 'Dārzu iela 2', 8, 440),
	(100173046, 105837962, '"Marina"', 8, 440),
	(100380886, 106048760, 'Lidicas iela 2B', 8, 440),
	(100380894, 106048777, 'Piemiņas iela 6', 8, 440),
	(100380878, 106251597, 'Krasuhas iela 1', 8, 440),
	(100380886, 106434312, 'Lidicas iela 16A', 8, 440),
	(100380894, 106550615, 'Piemiņas iela 9', 8, 440),
	(100499500, 106705248, 'Liepu aleja 2', 8, 440),
	(100499500, 106705256, 'Liepu aleja 6', 8, 440),
	(100499500, 106705264, 'Liepu aleja 4', 8, 440),
	(100380917, 106705272, 'Saules iela 2', 8, 440),
	(100427945, 106718537, 'Dārzu iela 12A', 8, 440),
	(100173046, 106735135, '"Saulīte"', 8, 440),
	(100173046, 106869318, '"Mazulīte"', 8, 440),
	(100173046, 106875973, '"Stirāni"', 8, 440),
	(100173046, 106877300, '"Višenka"', 8, 440),
	(100380894, 106976781, 'Piemiņas iela 2A', 8, 440),
	(100380900, 106976798, 'Rēzeknes iela 4A', 8, 440),
	(100380900, 106976804, 'Rēzeknes iela 3A', 8, 440),
	(100380900, 106976812, 'Rēzeknes iela 2A', 8, 440),
	(100380900, 106976820, 'Rēzeknes iela 1A', 8, 440),
	(100380878, 106985604, 'Krasuhas iela 6', 8, 440),
	(100380878, 106985612, 'Krasuhas iela 6A', 8, 440),
	(100173046, 106987624, '"Samtenes"', 8, 440),
	(100427945, 107006493, 'Dārzu iela 2A', 8, 440),
	(100173046, 107011421, '"Vispa"', 8, 440),
	(100173046, 107012118, '"Alkšņi"', 8, 440),
	(100173038, 107013642, '"Skujiņas"', 8, 440);

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