-- --------------------------------------------------------
-- 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 ricards_db_staskevics.address_index_ricards
CREATE TABLE IF NOT EXISTS `address_index_ricards` (
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses indeksa ID',
  `number` smallint(5) unsigned NOT NULL COMMENT 'Adreses indekss',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Adreses indeksi';

-- Dumping data for table ricards_db_staskevics.address_index_ricards: ~695 rows (approximately)
INSERT INTO `address_index_ricards` (`id`, `number`) VALUES
	(0, 0),
	(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 ricards_db_staskevics.address_level_ricards
CREATE TABLE IF NOT EXISTS `address_level_ricards` (
  `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`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Adreses līmenis';

-- Dumping data for table ricards_db_staskevics.address_level_ricards: ~9 rows (approximately)
INSERT INTO `address_level_ricards` (`id`, `name`, `fname`, `sname`) VALUES
	(1, 'Valsts', 'Valsts', '\r'),
	(2, 'Novads', 'Novads', 'nov.\r'),
	(3, 'Valsts pil', 'Valsts pilsēta', '\r'),
	(4, 'Pilsēta', 'Pilsēta', '\r'),
	(5, 'Pagasts', 'Pagasts', 'pag.\r'),
	(6, 'Ciems', 'Ciems/mazciems', '\r'),
	(7, 'Iela', 'Iela', '\r'),
	(8, 'Ēka', 'Ēkas nr./Nosaukums, korpuss', '\r'),
	(9, 'Telpa', 'Telpu grupa (dzīvoklis)', '\r');

-- Dumping structure for table ricards_db_staskevics.address_name_ricards
CREATE TABLE IF NOT EXISTS `address_name_ricards` (
  `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`),
  KEY `id_level` (`id_address_level`,`id_address_name`) USING BTREE,
  KEY `FK_address_name_address_name` (`id_address_name`),
  KEY `FK_address_name_address_index` (`id_address_index`),
  CONSTRAINT `FK_address_name_address_index` FOREIGN KEY (`id_address_index`) REFERENCES `address_index_ricards` (`id`),
  CONSTRAINT `FK_address_name_address_level` FOREIGN KEY (`id_address_level`) REFERENCES `address_level_ricards` (`id`),
  CONSTRAINT `FK_address_name_address_name` FOREIGN KEY (`id_address_name`) REFERENCES `address_name_ricards` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Adreses';

-- Dumping data for table ricards_db_staskevics.address_name_ricards: ~154 rows (approximately)
INSERT INTO `address_name_ricards` (`id_address_name`, `id`, `name`, `id_address_level`, `id_address_index`) VALUES
	(100000000, 100000000, 'Latvija', 1, 0),
	(100016333, 100014668, 'Piltenes ', 5, 237),
	(100016333, 100014676, 'Jūrkalnes ', 5, 237),
	(100016333, 100014684, 'Popes ', 5, 237),
	(100016333, 100014692, 'Puzes ', 5, 237),
	(100016333, 100014707, 'Tārgales ', 5, 237),
	(100016333, 100014715, 'Usmas ', 5, 237),
	(100016333, 100014723, 'Užavas ', 5, 237),
	(100016333, 100014731, 'Vārves ', 5, 237),
	(100016333, 100014748, 'Zlēku ', 5, 237),
	(100016333, 100015130, 'Ances ', 5, 237),
	(100016333, 100015147, 'Ugāles ', 5, 237),
	(100016333, 100015155, 'Ziru ', 5, 237),
	(100000000, 100016333, 'Ventspils ', 2, 0),
	(100014668, 101170688, 'Mauriņi', 8, 237),
	(100014668, 102051262, 'Amālnieki', 8, 237),
	(100014668, 102052297, 'Krievciemnieki', 8, 237),
	(100014668, 102052311, 'Krievciems', 8, 237),
	(100014668, 103141615, 'Bērzkaukši', 8, 237),
	(100014668, 103141697, 'Dēdes', 8, 237),
	(100014668, 103142022, 'Dzeņi', 8, 237),
	(100014668, 103142047, 'Dravnieki', 8, 237),
	(100014668, 103142432, 'Liepiņi', 8, 237),
	(100014668, 103142600, 'Jenoti', 8, 237),
	(100014668, 103142617, 'Irši', 8, 237),
	(100014668, 103142625, 'Brieži', 8, 237),
	(100014668, 103142633, 'Palejas', 8, 237),
	(100014668, 103142674, 'Gārzdes ceplis', 8, 237),
	(100014668, 103142690, 'Čunči', 8, 237),
	(100014668, 103142705, 'Eglītes', 8, 237),
	(100014668, 103142834, 'Kalnmaļi', 8, 237),
	(100014668, 103142996, 'Lieparāji', 8, 237),
	(100014668, 103143057, 'Jaunputniņi', 8, 237),
	(100014668, 103143178, 'Brasliņi', 8, 237),
	(100014668, 103143225, 'Lasnieki', 8, 237),
	(100014668, 103143266, 'Jorniņi', 8, 237),
	(100014668, 103143282, 'Alaudas', 8, 237),
	(100014668, 103143467, 'Niedriņi', 8, 237),
	(100014668, 103143475, 'Dižmārtiņi', 8, 237),
	(100014668, 103143563, 'Baloži', 8, 237),
	(100014668, 103143596, 'Druķēni', 8, 237),
	(100014668, 103144380, 'Mierlauki', 8, 237),
	(100014668, 103144403, 'Branči', 8, 237),
	(100014668, 103144411, 'Brenči', 8, 237),
	(100014668, 103144428, 'Danči', 8, 237),
	(100014668, 103144444, 'Lūši', 8, 237),
	(100014668, 103144452, 'Kalni', 8, 237),
	(100014668, 103144460, 'Dižbeltes', 8, 237),
	(100014668, 103144477, 'Bileskalni', 8, 237),
	(100014668, 103144485, 'Dzilnas', 8, 237),
	(100014668, 103144508, 'Jaunrobežnieki', 8, 237),
	(100014668, 103144516, 'Jaunsilnieki', 8, 237),
	(100014668, 103144532, 'Dūdiņi', 8, 237),
	(100014668, 103144540, 'Latlauki', 8, 237),
	(100014668, 103144565, 'Bērzi', 8, 237),
	(100014668, 103144573, 'Aizupes', 8, 237),
	(100014668, 103144604, 'Landzes baznīca', 8, 237),
	(100014668, 103144653, 'Pļaviņas', 8, 237),
	(100014668, 103144661, 'Mazķesteri', 8, 237),
	(100014668, 103144678, 'Pansionāts "Piltene"', 8, 237),
	(100014668, 103144686, 'Ābolkalni', 8, 237),
	(100014668, 103144717, 'Gaiļi', 8, 237),
	(100014668, 103144725, 'Bauļi', 8, 237),
	(100014668, 103144766, 'Klētnieki', 8, 237),
	(100014668, 103144774, 'Jaunzemji', 8, 237),
	(100014668, 103144782, 'Gārzdes skola', 8, 237),
	(100014668, 103144790, 'Ādģēri', 8, 237),
	(100014668, 103144821, 'Mazbraki', 8, 237),
	(100014668, 103144838, 'Muldas', 8, 237),
	(100014668, 103144846, 'Grīvas', 8, 237),
	(100014668, 103144854, 'Jaunarāji 2', 8, 237),
	(100014668, 103144862, 'Dīriķi', 8, 237),
	(100014668, 103144870, 'Mazgaisiņi', 8, 237),
	(100014668, 103144901, 'Dižgaisiņi', 8, 237),
	(100014668, 103144918, 'Muižarāji', 8, 237),
	(100014668, 103144926, 'Alkšņi', 8, 237),
	(100014668, 103144934, 'Kronnieki', 8, 237),
	(100014668, 103144967, 'Cīruļi', 8, 237),
	(100014668, 103144991, 'Jaunbirzes', 8, 237),
	(100014668, 103145044, 'Lejnieki', 8, 237),
	(100014668, 103145052, 'Liepnieki', 8, 237),
	(100014668, 103145157, 'Liepmalas', 8, 237),
	(100014668, 103145165, 'Brūveri', 8, 237),
	(100014668, 103145173, 'Klajumi', 8, 237),
	(100014668, 103145181, 'Gulbīši', 8, 237),
	(100014668, 103145198, 'Mežsargi', 8, 237),
	(100014668, 103145237, 'Jaunpīkas', 8, 237),
	(100014668, 103145245, 'Augstupes', 8, 237),
	(100014668, 103145253, 'Irbes', 8, 237),
	(100014668, 103145261, 'Dzērves', 8, 237),
	(100014668, 103145278, 'Citroni', 8, 237),
	(100014668, 103145286, 'Āboliņi', 8, 237),
	(100014668, 103145294, 'Novadnieki', 8, 237),
	(100014668, 103145300, 'Ozoli', 8, 237),
	(100014668, 103145317, 'Lodiņi', 8, 237),
	(100014668, 103145325, 'Ozollejas', 8, 237),
	(100014668, 103145333, 'Cepļābelnieki', 8, 237),
	(100014668, 103145341, 'Druviņas 2', 8, 237),
	(100014668, 103145358, 'Pīkas', 8, 237),
	(100014668, 103145405, 'Arāji', 8, 237),
	(100014668, 103145421, 'Auziņi', 8, 237),
	(100014668, 103145518, 'Dižābelnieki', 8, 237),
	(100014668, 103145526, 'Mazābelnieki', 8, 237),
	(100014668, 103145534, 'Krastnieki', 8, 237),
	(100014668, 103145550, 'Bolderkrogs', 8, 237),
	(100014668, 103145567, 'Ezerkalni', 8, 237),
	(100014668, 103145583, 'Mālarāji', 8, 237),
	(100014668, 103145591, 'Dzintari', 8, 237),
	(100014668, 103145614, 'Bāliņi', 8, 237),
	(100014668, 103145622, 'Kambarlauki', 8, 237),
	(100014668, 103146038, 'Dimzas', 8, 237),
	(100014668, 103146087, 'Pļavnieki', 8, 237),
	(100014668, 103146118, 'Burtnieki', 8, 237),
	(100014668, 103146134, 'Dangas', 8, 237),
	(100014668, 103146175, 'Lagzdienas Kalni', 8, 237),
	(100014668, 103146206, 'Klintnieki', 8, 237),
	(100014668, 103148757, 'Jaunzemes', 8, 237),
	(100014668, 104852280, 'Apses', 8, 237),
	(100014668, 104852297, 'Ceriņi', 8, 237),
	(100014668, 104852328, 'Gobas', 8, 237),
	(100014668, 104852498, 'Ķirškalni', 8, 237),
	(100014668, 104852504, 'Liepkalni', 8, 237),
	(100014668, 104852826, 'Obe', 8, 237),
	(100014668, 104853032, 'Jaunskaldnieki', 8, 237),
	(100014668, 105190144, 'Lagzdiene', 8, 237),
	(100014668, 105311380, 'Mazkraujmalas', 8, 237),
	(100014668, 105311397, 'Pīkas 1', 8, 237),
	(100014668, 105311403, 'Mazlīči', 8, 237),
	(100014668, 105311428, 'Austrumi', 8, 237),
	(100014668, 105381728, 'Dižakācijas', 8, 237),
	(100014668, 105381777, 'Jaunlauki', 8, 237),
	(100014668, 105381785, 'Jaungaisiņi', 8, 237),
	(100014668, 105418665, 'Grantiņi', 8, 237),
	(100014668, 105418681, 'Jāņi', 8, 237),
	(100014668, 105418698, 'Kalviņi', 8, 237),
	(100014668, 105439318, 'Landznieki', 8, 237),
	(100014668, 105439326, 'Mazklētnieki', 8, 237),
	(100014668, 105439334, 'Daces', 8, 237),
	(100014668, 105439342, 'Mazūsiņi', 8, 237),
	(100014668, 105572805, 'Dupēni', 8, 237),
	(100014668, 105578744, 'Egles', 8, 237),
	(100014668, 105996888, 'Butriki', 8, 237),
	(100014668, 106268362, 'Boitmaņi', 8, 237),
	(100014668, 106384786, 'Kausiņi', 8, 237),
	(100014668, 106384833, 'Kraujas', 8, 237),
	(100014668, 106442705, 'Mežamājas', 8, 237),
	(100014668, 106555753, 'Pīlādži', 8, 237),
	(100014668, 106576760, 'Pīlādžu sūkņu stacij', 8, 237),
	(100014668, 106611308, 'Pirmās Dižbeltes', 8, 237),
	(100014668, 106731683, 'Dižbraki', 8, 237),
	(100014668, 106750871, 'Dzīles', 8, 237),
	(100014668, 106801674, 'Kļavarāji', 8, 237),
	(100014668, 106995447, 'Lauklūši', 8, 237),
	(100014668, 107017096, 'Cērsupes', 8, 237);

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