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

/*!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 webshop
CREATE DATABASE IF NOT EXISTS `webshop` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `webshop`;

-- Dumping structure for table webshop.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'kategorijas identifikators',
  `name` varchar(50) NOT NULL COMMENT 'kategorijas nosaukums',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='kategoriju tabula.';

-- Dumping data for table webshop.categories: ~3 rows (approximately)
INSERT INTO `categories` (`id`, `name`) VALUES
	(1, 'Ziedi'),
	(2, 'Telpaugi'),
	(3, 'Eksotiskie augi');

-- Dumping structure for table webshop.namedays
CREATE TABLE IF NOT EXISTS `namedays` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unikāls ieraksta identifikators',
  `month` int(11) DEFAULT NULL COMMENT 'Mēneša numurs, kurā tiek svinēta vārda diena',
  `day` int(11) DEFAULT NULL COMMENT 'diena',
  `name` varchar(100) DEFAULT NULL COMMENT 'vārds, kam attiecīgajā dienā ir vārda diena',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1033 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table webshop.namedays: ~1,032 rows (approximately)
INSERT INTO `namedays` (`id`, `month`, `day`, `name`) VALUES
	(1, 1, 1, 'Laimnesis'),
	(2, 1, 1, 'Solvita'),
	(3, 1, 1, 'Solvija'),
	(4, 1, 2, 'Indulis'),
	(5, 1, 2, 'Ivo'),
	(6, 1, 2, 'Iva'),
	(7, 1, 2, 'Ivis'),
	(8, 1, 3, 'Miervaldis'),
	(9, 1, 3, 'Miervalda'),
	(10, 1, 3, 'Ringolds'),
	(11, 1, 4, 'Spodra'),
	(12, 1, 4, 'Ilva'),
	(13, 1, 4, 'Ilvita'),
	(14, 1, 5, 'Sīmanis'),
	(15, 1, 5, 'Zintis'),
	(16, 1, 6, 'Spulga'),
	(17, 1, 6, 'Arnita'),
	(18, 1, 7, 'Rota'),
	(19, 1, 7, 'Zigmārs'),
	(20, 1, 7, 'Juliāns'),
	(21, 1, 7, 'Digmārs'),
	(22, 1, 8, 'Gatis'),
	(23, 1, 8, 'Ivanda'),
	(24, 1, 9, 'Kaspars'),
	(25, 1, 9, 'Aksels'),
	(26, 1, 9, 'Alta'),
	(27, 1, 10, 'Tatjana'),
	(28, 1, 10, 'Dorisa'),
	(29, 1, 11, 'Smaida'),
	(30, 1, 11, 'Franciska'),
	(31, 1, 11, 'Francisks'),
	(32, 1, 12, 'Reinis'),
	(33, 1, 12, 'Reina'),
	(34, 1, 12, 'Reinholds'),
	(35, 1, 12, 'Renāts'),
	(36, 1, 13, 'Harijs'),
	(37, 1, 13, 'Ārijs'),
	(38, 1, 13, 'Āris'),
	(39, 1, 13, 'Aira'),
	(40, 1, 14, 'Roberts'),
	(41, 1, 14, 'Roberta'),
	(42, 1, 14, 'Raitis'),
	(43, 1, 14, 'Raits'),
	(44, 1, 15, 'Fēlikss'),
	(45, 1, 15, 'Felicita'),
	(46, 1, 16, 'Lidija'),
	(47, 1, 16, 'Lida'),
	(48, 1, 17, 'Tenis'),
	(49, 1, 17, 'Dravis'),
	(50, 1, 18, 'Antons'),
	(51, 1, 18, 'Antis'),
	(52, 1, 18, 'Antonijs'),
	(53, 1, 19, 'Andulis'),
	(54, 1, 19, 'Alnis'),
	(55, 1, 20, 'Oļģerts'),
	(56, 1, 20, 'Orests'),
	(57, 1, 20, 'Aļģirds'),
	(58, 1, 20, 'Aļģis'),
	(59, 1, 21, 'Agnese'),
	(60, 1, 21, 'Agnija'),
	(61, 1, 21, 'Agne'),
	(62, 1, 22, 'Austris'),
	(63, 1, 23, 'Grieta'),
	(64, 1, 23, 'Strauta'),
	(65, 1, 23, 'Rebeka'),
	(66, 1, 23, 'Grēta'),
	(67, 1, 24, 'Krišs'),
	(68, 1, 24, 'Ksenija'),
	(69, 1, 24, 'Eglons'),
	(70, 1, 24, 'Egle'),
	(71, 1, 25, 'Zigurds'),
	(72, 1, 25, 'Sigurds'),
	(73, 1, 25, 'Sigvards'),
	(74, 1, 26, 'Ansis'),
	(75, 1, 26, 'Agnis'),
	(76, 1, 26, 'Agneta'),
	(77, 1, 27, 'Ilze'),
	(78, 1, 27, 'Ildze'),
	(79, 1, 27, 'Izolde'),
	(80, 1, 28, 'Kārlis'),
	(81, 1, 28, 'Spodris'),
	(82, 1, 29, 'Aivars'),
	(83, 1, 29, 'Valērijs'),
	(84, 1, 29, 'Bille'),
	(85, 1, 30, 'Tīna'),
	(86, 1, 30, 'Valentīna'),
	(87, 1, 30, 'Pārsla'),
	(88, 1, 31, 'Tekla'),
	(89, 1, 31, 'Violeta'),
	(90, 2, 1, 'Brigita'),
	(91, 2, 1, 'Indra'),
	(92, 2, 1, 'Indars'),
	(93, 2, 1, 'Indris'),
	(94, 2, 2, 'Spīdola'),
	(95, 2, 2, 'Sonora'),
	(96, 2, 3, 'Aīda'),
	(97, 2, 3, 'Ida'),
	(98, 2, 3, 'Vida'),
	(99, 2, 4, 'Daila'),
	(100, 2, 4, 'Veronika'),
	(101, 2, 4, 'Dominiks'),
	(102, 2, 4, 'Dominika'),
	(103, 2, 5, 'Agate'),
	(104, 2, 5, 'Selga'),
	(105, 2, 5, 'Silga'),
	(106, 2, 5, 'Sinilga'),
	(107, 2, 6, 'Dace'),
	(108, 2, 6, 'Dārta'),
	(109, 2, 6, 'Dora'),
	(110, 2, 6, 'Daris'),
	(111, 2, 7, 'Nelda'),
	(112, 2, 7, 'Rihards'),
	(113, 2, 7, 'Ričards'),
	(114, 2, 7, 'Rišards'),
	(115, 2, 8, 'Aldona'),
	(116, 2, 8, 'Česlavs'),
	(117, 2, 9, 'Simona'),
	(118, 2, 9, 'Apolonija'),
	(119, 2, 10, 'Paulīne'),
	(120, 2, 10, 'Paula'),
	(121, 2, 10, 'Jasmīna'),
	(122, 2, 11, 'Laima'),
	(123, 2, 11, 'Laimdota'),
	(124, 2, 12, 'Karlīna'),
	(125, 2, 12, 'Līna'),
	(126, 2, 13, 'Malda'),
	(127, 2, 13, 'Melita'),
	(128, 2, 14, 'Valentīns'),
	(129, 2, 15, 'Alvils'),
	(130, 2, 15, 'Olafs'),
	(131, 2, 15, 'Aloizs'),
	(132, 2, 15, 'Olavs'),
	(133, 2, 16, 'Jūlija'),
	(134, 2, 16, 'Džuljeta'),
	(135, 2, 17, 'Donats'),
	(136, 2, 17, 'Konstance'),
	(137, 2, 18, 'Kora'),
	(138, 2, 18, 'Kintija'),
	(139, 2, 19, 'Zane'),
	(140, 2, 19, 'Zuzanna'),
	(141, 2, 20, 'Vitauts'),
	(142, 2, 20, 'Smuidra'),
	(143, 2, 20, 'Smuidris'),
	(144, 2, 21, 'Eleonora'),
	(145, 2, 21, 'Ariadne'),
	(146, 2, 22, 'Ārija'),
	(147, 2, 22, 'Rigonda'),
	(148, 2, 22, 'Adrians'),
	(149, 2, 22, 'Adriāna'),
	(150, 2, 22, 'Adrija'),
	(151, 2, 23, 'Haralds'),
	(152, 2, 23, 'Almants'),
	(153, 2, 24, 'Diāna'),
	(154, 2, 24, 'Dina'),
	(155, 2, 24, 'Dins'),
	(156, 2, 25, 'Alma'),
	(157, 2, 25, 'Annemarija'),
	(158, 2, 26, 'Evelīna'),
	(159, 2, 26, 'Aurēlija'),
	(160, 2, 26, 'Mētra'),
	(161, 2, 27, 'Līvija'),
	(162, 2, 27, 'Līva'),
	(163, 2, 27, 'Andra'),
	(164, 2, 28, 'Skaidrīte'),
	(165, 2, 28, 'Justs'),
	(166, 2, 28, 'Skaidra'),
	(167, 3, 1, 'Ivars'),
	(168, 3, 1, 'Ilgvars'),
	(169, 3, 2, 'Lavīze'),
	(170, 3, 2, 'Luīze'),
	(171, 3, 2, 'Laila'),
	(172, 3, 3, 'Tālis'),
	(173, 3, 3, 'Tālavs'),
	(174, 3, 3, 'Marts'),
	(175, 3, 4, 'Alise'),
	(176, 3, 4, 'Auce'),
	(177, 3, 4, 'Enija'),
	(178, 3, 5, 'Austra'),
	(179, 3, 5, 'Aurora'),
	(180, 3, 5, 'Aurika'),
	(181, 3, 6, 'Vents'),
	(182, 3, 6, 'Centis'),
	(183, 3, 6, 'Gotfrīds'),
	(184, 3, 7, 'Ella'),
	(185, 3, 7, 'Elmīra'),
	(186, 3, 8, 'Dagmāra'),
	(187, 3, 8, 'Marga'),
	(188, 3, 8, 'Margita'),
	(189, 3, 9, 'Ēvalds'),
	(190, 3, 10, 'Silvija'),
	(191, 3, 10, 'Laimrota'),
	(192, 3, 10, 'Liliāna'),
	(193, 3, 11, 'Konstantīns'),
	(194, 3, 11, 'Agita'),
	(195, 3, 12, 'Aija'),
	(196, 3, 12, 'Aiva'),
	(197, 3, 12, 'Aivis'),
	(198, 3, 13, 'Ernests'),
	(199, 3, 13, 'Balvis'),
	(200, 3, 14, 'Matilde'),
	(201, 3, 14, 'Ulrika'),
	(202, 3, 15, 'Amilda'),
	(203, 3, 15, 'Amalda'),
	(204, 3, 15, 'Imalda'),
	(205, 3, 16, 'Guntis'),
	(206, 3, 16, 'Guntars'),
	(207, 3, 16, 'Guntris'),
	(208, 3, 17, 'Ģertrūde'),
	(209, 3, 17, 'Gerda'),
	(210, 3, 17, 'Gerhards'),
	(211, 3, 18, 'Ilona'),
	(212, 3, 18, 'Adelīna'),
	(213, 3, 19, 'Jāzeps'),
	(214, 3, 19, 'Juzefa'),
	(215, 3, 20, 'Made'),
	(216, 3, 20, 'Irbe'),
	(217, 3, 21, 'Una'),
	(218, 3, 21, 'Unigunde'),
	(219, 3, 21, 'Dzelme'),
	(220, 3, 21, 'Benedikts'),
	(221, 3, 21, 'Benedikta'),
	(222, 3, 22, 'Tamāra'),
	(223, 3, 22, 'Dziedra'),
	(224, 3, 22, 'Gabriels'),
	(225, 3, 22, 'Gabriela'),
	(226, 3, 23, 'Mirdza'),
	(227, 3, 23, 'Žanete'),
	(228, 3, 23, 'Žanna'),
	(229, 3, 24, 'Kazimirs'),
	(230, 3, 24, 'Izidors'),
	(231, 3, 25, 'Māra'),
	(232, 3, 25, 'Mārīte'),
	(233, 3, 25, 'Marita'),
	(234, 3, 25, 'Mare'),
	(235, 3, 25, 'Ģedimins'),
	(236, 3, 26, 'Eiženija'),
	(237, 3, 26, 'Ženija'),
	(238, 3, 27, 'Gustavs'),
	(239, 3, 27, 'Gusts'),
	(240, 3, 27, 'Tālrīts'),
	(241, 3, 27, 'Saulis'),
	(242, 3, 28, 'Gunta'),
	(243, 3, 28, 'Ginta'),
	(244, 3, 28, 'Gunda'),
	(245, 3, 29, 'Aldonis'),
	(246, 3, 29, 'Agija'),
	(247, 3, 30, 'Nanija'),
	(248, 3, 30, 'Ilgmārs'),
	(249, 3, 31, 'Gvido'),
	(250, 3, 31, 'Atvars'),
	(251, 4, 1, 'Dagnis'),
	(252, 4, 1, 'Dagne'),
	(253, 4, 2, 'Irmgarde'),
	(254, 4, 3, 'Daira'),
	(255, 4, 3, 'Dairis'),
	(256, 4, 3, 'Daiva'),
	(257, 4, 3, 'Daivis'),
	(258, 4, 4, 'Valda'),
	(259, 4, 4, 'Herta'),
	(260, 4, 4, 'Ārvalda'),
	(261, 4, 4, 'Ārvalds'),
	(262, 4, 4, 'Ārvaldis'),
	(263, 4, 5, 'Vija'),
	(264, 4, 5, 'Vidaga'),
	(265, 4, 5, 'Aivija'),
	(266, 4, 6, 'Zinta'),
	(267, 4, 6, 'Vīlips'),
	(268, 4, 6, 'Filips'),
	(269, 4, 6, 'Dzinta'),
	(270, 4, 6, 'Dzintis'),
	(271, 4, 7, 'Zina'),
	(272, 4, 7, 'Zinaīda'),
	(273, 4, 7, 'Helmuts'),
	(274, 4, 8, 'Edgars'),
	(275, 4, 8, 'Danute'),
	(276, 4, 8, 'Dana'),
	(277, 4, 8, 'Dans'),
	(278, 4, 9, 'Valērija'),
	(279, 4, 9, 'Žubīte'),
	(280, 4, 9, 'Alla'),
	(281, 4, 10, 'Anita'),
	(282, 4, 10, 'Anitra'),
	(283, 4, 10, 'Zīle'),
	(284, 4, 10, 'Annika'),
	(285, 4, 11, 'Hermanis'),
	(286, 4, 11, 'Vilmārs'),
	(287, 4, 12, 'Jūlijs'),
	(288, 4, 12, 'Ainis'),
	(289, 4, 13, 'Egils'),
	(290, 4, 13, 'Egīls'),
	(291, 4, 13, 'Nauris'),
	(292, 4, 14, 'Strauja'),
	(293, 4, 14, 'Gudrīte'),
	(294, 4, 15, 'Aelita'),
	(295, 4, 15, 'Gastons'),
	(296, 4, 16, 'Mintauts'),
	(297, 4, 16, 'Alfs'),
	(298, 4, 16, 'Bernadeta'),
	(299, 4, 17, 'Rūdolfs'),
	(300, 4, 17, 'Viviāna'),
	(301, 4, 17, 'Rūdis'),
	(302, 4, 18, 'Laura'),
	(303, 4, 18, 'Jadviga'),
	(304, 4, 19, 'Vēsma'),
	(305, 4, 19, 'Fanija'),
	(306, 4, 20, 'Mirta'),
	(307, 4, 20, 'Ziedīte'),
	(308, 4, 20, 'Meija'),
	(309, 4, 21, 'Marģers'),
	(310, 4, 21, 'Anastasija'),
	(311, 4, 22, 'Armands'),
	(312, 4, 22, 'Armanda'),
	(313, 4, 23, 'Jurģis'),
	(314, 4, 23, 'Juris'),
	(315, 4, 23, 'Georgs'),
	(316, 4, 23, 'Jurgita'),
	(317, 4, 24, 'Visvaldis'),
	(318, 4, 24, 'Nameda'),
	(319, 4, 24, 'Ritvaldis'),
	(320, 4, 24, 'Ritums'),
	(321, 4, 25, 'Līksma'),
	(322, 4, 25, 'Bārbala'),
	(323, 4, 26, 'Alīna'),
	(324, 4, 26, 'Sandris'),
	(325, 4, 26, 'Rūsiņš'),
	(326, 4, 27, 'Tāle'),
	(327, 4, 27, 'Raimonda'),
	(328, 4, 27, 'Raina'),
	(329, 4, 27, 'Klementīne'),
	(330, 4, 28, 'Gundega'),
	(331, 4, 28, 'Terēze'),
	(332, 4, 29, 'Vilnis'),
	(333, 4, 29, 'Raimonds'),
	(334, 4, 29, 'Laine'),
	(335, 4, 30, 'Lilija'),
	(336, 4, 30, 'Liāna'),
	(337, 5, 1, 'Ziedonis'),
	(338, 5, 2, 'Zigmunds'),
	(339, 5, 2, 'Sigmunds'),
	(340, 5, 2, 'Zigismunds'),
	(341, 5, 3, 'Gints'),
	(342, 5, 3, 'Uvis'),
	(343, 5, 4, 'Vizbulīte'),
	(344, 5, 4, 'Viola'),
	(345, 5, 4, 'Vijolīte'),
	(346, 5, 5, 'Ģirts'),
	(347, 5, 5, 'Ģederts'),
	(348, 5, 6, 'Gaidis'),
	(349, 5, 6, 'Didzis'),
	(350, 5, 7, 'Henriete'),
	(351, 5, 7, 'Henrijs'),
	(352, 5, 7, 'Jete'),
	(353, 5, 7, 'Enriko'),
	(354, 5, 8, 'Staņislavs'),
	(355, 5, 8, 'Staņislava'),
	(356, 5, 8, 'Stefānija'),
	(357, 5, 9, 'Klāvs'),
	(358, 5, 9, 'Einārs'),
	(359, 5, 9, 'Ervīns'),
	(360, 5, 10, 'Maija'),
	(361, 5, 10, 'Paija'),
	(362, 5, 11, 'Milda'),
	(363, 5, 11, 'Karmena'),
	(364, 5, 11, 'Manfreds'),
	(365, 5, 12, 'Valija'),
	(366, 5, 12, 'Ināra'),
	(367, 5, 12, 'Ina'),
	(368, 5, 12, 'Inārs'),
	(369, 5, 13, 'Irēna'),
	(370, 5, 13, 'Irīna'),
	(371, 5, 13, 'Ira'),
	(372, 5, 13, 'Iraīda'),
	(373, 5, 14, 'Krišjānis'),
	(374, 5, 14, 'Elfa'),
	(375, 5, 14, 'Aivita'),
	(376, 5, 14, 'Elvita'),
	(377, 5, 15, 'Sofija'),
	(378, 5, 15, 'Taiga'),
	(379, 5, 15, 'Airita'),
	(380, 5, 15, 'Arita'),
	(381, 5, 16, 'Edvīns'),
	(382, 5, 16, 'Edijs'),
	(383, 5, 17, 'Herberts'),
	(384, 5, 17, 'Dailis'),
	(385, 5, 17, 'Umberts'),
	(386, 5, 18, 'Inese'),
	(387, 5, 18, 'Inesis'),
	(388, 5, 18, 'Ēriks'),
	(389, 5, 19, 'Lita'),
	(390, 5, 19, 'Sibilla'),
	(391, 5, 19, 'Teika'),
	(392, 5, 20, 'Venta'),
	(393, 5, 20, 'Salvis'),
	(394, 5, 20, 'Selva'),
	(395, 5, 21, 'Ernestīne'),
	(396, 5, 21, 'Ingmārs'),
	(397, 5, 21, 'Akvelīna'),
	(398, 5, 22, 'Emīlija. Visu neparasto un kalendāros neierakstīto vārdu diena'),
	(399, 5, 23, 'Leontīne'),
	(400, 5, 23, 'Leokādija'),
	(401, 5, 23, 'Lonija'),
	(402, 5, 23, 'Ligija'),
	(403, 5, 24, 'Ilvija'),
	(404, 5, 24, 'Marlēna'),
	(405, 5, 24, 'Ziedone'),
	(406, 5, 25, 'Anšlavs'),
	(407, 5, 25, 'Junora'),
	(408, 5, 26, 'Edvards'),
	(409, 5, 26, 'Edvarts'),
	(410, 5, 26, 'Eduards'),
	(411, 5, 26, 'Varis'),
	(412, 5, 27, 'Dzidra'),
	(413, 5, 27, 'Gunita'),
	(414, 5, 27, 'Loreta'),
	(415, 5, 27, 'Dzidris'),
	(416, 5, 28, 'Vilis'),
	(417, 5, 28, 'Vilhelms'),
	(418, 5, 29, 'Maksis'),
	(419, 5, 29, 'Maksims'),
	(420, 5, 29, 'Raivis'),
	(421, 5, 29, 'Raivo'),
	(422, 5, 30, 'Vitolds'),
	(423, 5, 30, 'Lolita'),
	(424, 5, 30, 'Letīcija'),
	(425, 5, 31, 'Alīda'),
	(426, 5, 31, 'Jūsma'),
	(427, 6, 1, 'Biruta'),
	(428, 6, 1, 'Mairita'),
	(429, 6, 1, 'Bernedīne'),
	(430, 6, 2, 'Lība'),
	(431, 6, 2, 'Emma'),
	(432, 6, 3, 'Inta'),
	(433, 6, 3, 'Ineta'),
	(434, 6, 3, 'Intra'),
	(435, 6, 4, 'Elfrīda'),
	(436, 6, 4, 'Sintija'),
	(437, 6, 4, 'Sindija'),
	(438, 6, 5, 'Igors'),
	(439, 6, 5, 'Margots'),
	(440, 6, 5, 'Ingvars'),
	(441, 6, 6, 'Ingrīda'),
	(442, 6, 6, 'Ardis'),
	(443, 6, 7, 'Gaida'),
	(444, 6, 7, 'Arnis'),
	(445, 6, 7, 'Arno'),
	(446, 6, 8, 'Frīdis'),
	(447, 6, 8, 'Frīda'),
	(448, 6, 8, 'Mundra'),
	(449, 6, 9, 'Ligita'),
	(450, 6, 9, 'Gita'),
	(451, 6, 10, 'Malva'),
	(452, 6, 10, 'Anatols'),
	(453, 6, 10, 'Anatolijs'),
	(454, 6, 11, 'Ingus'),
	(455, 6, 11, 'Mairis'),
	(456, 6, 11, 'Vidvuds'),
	(457, 6, 12, 'Nora'),
	(458, 6, 12, 'Lenora'),
	(459, 6, 12, 'Ija'),
	(460, 6, 13, 'Zigfrīds'),
	(461, 6, 13, 'Ainārs'),
	(462, 6, 13, 'Uva'),
	(463, 6, 14, 'Tija'),
	(464, 6, 14, 'Saiva'),
	(465, 6, 14, 'Sentis'),
	(466, 6, 14, 'Santis'),
	(467, 6, 14, 'Saivis'),
	(468, 6, 15, 'Baņuta'),
	(469, 6, 15, 'Žermēna'),
	(470, 6, 15, 'Vilija'),
	(471, 6, 15, 'Vits'),
	(472, 6, 16, 'Justīne'),
	(473, 6, 16, 'Juta'),
	(474, 6, 17, 'Artūrs'),
	(475, 6, 17, 'Artis'),
	(476, 6, 18, 'Alberts'),
	(477, 6, 18, 'Madis'),
	(478, 6, 19, 'Viktors'),
	(479, 6, 19, 'Nils'),
	(480, 6, 19, 'Mīla'),
	(481, 6, 20, 'Rasma'),
	(482, 6, 20, 'Rasa'),
	(483, 6, 20, 'Maira'),
	(484, 6, 21, 'Emīls'),
	(485, 6, 21, 'Egita'),
	(486, 6, 21, 'Monvīds'),
	(487, 6, 22, 'Ludmila'),
	(488, 6, 22, 'Laimdots'),
	(489, 6, 22, 'Laimiņš'),
	(490, 6, 23, 'Līga'),
	(491, 6, 24, 'Jānis'),
	(492, 6, 25, 'Milija'),
	(493, 6, 25, 'Maiga'),
	(494, 6, 26, 'Ausma'),
	(495, 6, 26, 'Inguna'),
	(496, 6, 26, 'Ingūna'),
	(497, 6, 26, 'Inguns'),
	(498, 6, 26, 'Ausmis'),
	(499, 6, 27, 'Malvīne'),
	(500, 6, 27, 'Malvis'),
	(501, 6, 28, 'Viesturs'),
	(502, 6, 28, 'Kitija'),
	(503, 6, 28, 'Viestards'),
	(504, 6, 28, 'Vestards'),
	(505, 6, 29, 'Pēteris'),
	(506, 6, 29, 'Pāvils'),
	(507, 6, 29, 'Pauls'),
	(508, 6, 29, 'Paulis'),
	(509, 6, 30, 'Tālivaldis'),
	(510, 6, 30, 'Mareks'),
	(511, 7, 1, 'Imants'),
	(512, 7, 1, 'Rimants'),
	(513, 7, 1, 'Ingars'),
	(514, 7, 1, 'Intars'),
	(515, 7, 2, 'Lauma'),
	(516, 7, 2, 'Ilvars'),
	(517, 7, 2, 'Halina'),
	(518, 7, 3, 'Benita'),
	(519, 7, 3, 'Everita'),
	(520, 7, 3, 'Verita'),
	(521, 7, 3, 'Emerita'),
	(522, 7, 4, 'Ulvis'),
	(523, 7, 4, 'Uldis'),
	(524, 7, 4, 'Sandis'),
	(525, 7, 4, 'Sandijs'),
	(526, 7, 5, 'Andžs'),
	(527, 7, 5, 'Andžejs'),
	(528, 7, 5, 'Edīte'),
	(529, 7, 5, 'Esmeralda'),
	(530, 7, 6, 'Anrijs'),
	(531, 7, 6, 'Arkādijs'),
	(532, 7, 7, 'Alda'),
	(533, 7, 7, 'Maruta'),
	(534, 7, 8, 'Antra'),
	(535, 7, 8, 'Adele'),
	(536, 7, 8, 'Ada'),
	(537, 7, 9, 'Zaiga'),
	(538, 7, 9, 'Asne'),
	(539, 7, 9, 'Asna'),
	(540, 7, 10, 'Lija'),
	(541, 7, 10, 'Olīvija'),
	(542, 7, 10, 'Olivers'),
	(543, 7, 10, 'Odrija'),
	(544, 7, 11, 'Leonora'),
	(545, 7, 11, 'Svens'),
	(546, 7, 12, 'Indriķis'),
	(547, 7, 12, 'Ints'),
	(548, 7, 12, 'Namejs'),
	(549, 7, 13, 'Margrieta'),
	(550, 7, 13, 'Margarita'),
	(551, 7, 14, 'Oskars'),
	(552, 7, 14, 'Ritvars'),
	(553, 7, 14, 'Anvars'),
	(554, 7, 15, 'Egons'),
	(555, 7, 15, 'Egmonts'),
	(556, 7, 15, 'Egija'),
	(557, 7, 15, 'Henriks'),
	(558, 7, 15, 'Heinrihs'),
	(559, 7, 16, 'Hermīne'),
	(560, 7, 16, 'Estere'),
	(561, 7, 16, 'Liepa'),
	(562, 7, 17, 'Aleksis'),
	(563, 7, 17, 'Aleksejs'),
	(564, 7, 17, 'Alekss'),
	(565, 7, 18, 'Rozālija'),
	(566, 7, 18, 'Roze'),
	(567, 7, 19, 'Jautrīte'),
	(568, 7, 19, 'Kamila'),
	(569, 7, 19, 'Digna'),
	(570, 7, 19, 'Sāra'),
	(571, 7, 20, 'Ritma'),
	(572, 7, 20, 'Ramona'),
	(573, 7, 21, 'Meldra'),
	(574, 7, 21, 'Meldris'),
	(575, 7, 21, 'Melisa'),
	(576, 7, 22, 'Marija'),
	(577, 7, 22, 'Marika'),
	(578, 7, 22, 'Marina'),
	(579, 7, 23, 'Magda'),
	(580, 7, 23, 'Magone'),
	(581, 7, 23, 'Mērija'),
	(582, 7, 23, 'Magdalēna'),
	(583, 7, 23, 'Madlēna'),
	(584, 7, 24, 'Kristīne'),
	(585, 7, 24, 'Kristīna'),
	(586, 7, 24, 'Krista'),
	(587, 7, 24, 'Kristiāna'),
	(588, 7, 24, 'Kristiāns'),
	(589, 7, 25, 'Jēkabs'),
	(590, 7, 25, 'Žaklīna'),
	(591, 7, 26, 'Anna'),
	(592, 7, 26, 'Ance'),
	(593, 7, 26, 'Annija'),
	(594, 7, 27, 'Marta'),
	(595, 7, 27, 'Dita'),
	(596, 7, 27, 'Dite'),
	(597, 7, 28, 'Cecīlija'),
	(598, 7, 28, 'Cilda'),
	(599, 7, 29, 'Edmunds'),
	(600, 7, 29, 'Edžus'),
	(601, 7, 29, 'Vidmants'),
	(602, 7, 30, 'Valters'),
	(603, 7, 30, 'Renārs'),
	(604, 7, 30, 'Regnārs'),
	(605, 7, 31, 'Rūta'),
	(606, 7, 31, 'Ruta'),
	(607, 7, 31, 'Angelika'),
	(608, 7, 31, 'Sigita'),
	(609, 8, 1, 'Albīns'),
	(610, 8, 1, 'Albīna'),
	(611, 8, 2, 'Normunds'),
	(612, 8, 2, 'Stefans'),
	(613, 8, 2, 'Eliass'),
	(614, 8, 3, 'Augusts'),
	(615, 8, 4, 'Romāns'),
	(616, 8, 4, 'Romualds'),
	(617, 8, 4, 'Romualda'),
	(618, 8, 5, 'Osvalds'),
	(619, 8, 5, 'Arvils'),
	(620, 8, 6, 'Askolds'),
	(621, 8, 6, 'Aisma'),
	(622, 8, 7, 'Alfrēds'),
	(623, 8, 7, 'Madars'),
	(624, 8, 7, 'Fredis'),
	(625, 8, 8, 'Mudīte'),
	(626, 8, 8, 'Vladislavs'),
	(627, 8, 8, 'Vladislava'),
	(628, 8, 9, 'Madara'),
	(629, 8, 9, 'Genoveva'),
	(630, 8, 9, 'Genovefa'),
	(631, 8, 10, 'Brencis'),
	(632, 8, 10, 'Audris'),
	(633, 8, 10, 'Inuta'),
	(634, 8, 10, 'Audra'),
	(635, 8, 11, 'Olga'),
	(636, 8, 11, 'Zita'),
	(637, 8, 11, 'Liega'),
	(638, 8, 11, 'Zigita'),
	(639, 8, 12, 'Vizma'),
	(640, 8, 12, 'Klāra'),
	(641, 8, 13, 'Elvīra'),
	(642, 8, 13, 'Velga'),
	(643, 8, 13, 'Rēzija'),
	(644, 8, 14, 'Zelma'),
	(645, 8, 14, 'Zemgus'),
	(646, 8, 14, 'Virma'),
	(647, 8, 15, 'Zenta'),
	(648, 8, 15, 'Dzelde'),
	(649, 8, 15, 'Zelda'),
	(650, 8, 16, 'Astra'),
	(651, 8, 16, 'Astrīda'),
	(652, 8, 17, 'Vineta'),
	(653, 8, 17, 'Oļegs'),
	(654, 8, 18, 'Liene'),
	(655, 8, 18, 'Helēna'),
	(656, 8, 18, 'Elena'),
	(657, 8, 18, 'Ellena'),
	(658, 8, 18, 'Liena'),
	(659, 8, 19, 'Melānija'),
	(660, 8, 19, 'Imanta'),
	(661, 8, 20, 'Bernhards'),
	(662, 8, 20, 'Boriss'),
	(663, 8, 20, 'Rojs'),
	(664, 8, 21, 'Janīna'),
	(665, 8, 21, 'Linda'),
	(666, 8, 22, 'Rudīte'),
	(667, 8, 22, 'Everts'),
	(668, 8, 23, 'Vitālijs'),
	(669, 8, 23, 'Ralfs'),
	(670, 8, 23, 'Valgudis'),
	(671, 8, 24, 'Bērtulis'),
	(672, 8, 24, 'Boļeslavs'),
	(673, 8, 25, 'Ludvigs'),
	(674, 8, 25, 'Ludis'),
	(675, 8, 25, 'Ivonna'),
	(676, 8, 25, 'Patrīcija'),
	(677, 8, 25, 'Patriks'),
	(678, 8, 26, 'Natālija'),
	(679, 8, 26, 'Tālija'),
	(680, 8, 26, 'Broņislavs'),
	(681, 8, 26, 'Broņislava'),
	(682, 8, 27, 'Žanis'),
	(683, 8, 27, 'Jorens'),
	(684, 8, 27, 'Alens'),
	(685, 8, 28, 'Auguste'),
	(686, 8, 28, 'Guste'),
	(687, 8, 29, 'Armīns'),
	(688, 8, 29, 'Vismants'),
	(689, 8, 29, 'Aiga'),
	(690, 8, 30, 'Alvis'),
	(691, 8, 30, 'Jolanta'),
	(692, 8, 30, 'Samanta'),
	(693, 8, 31, 'Vilma'),
	(694, 8, 31, 'Aigars'),
	(695, 9, 1, 'Ilmārs'),
	(696, 9, 1, 'Iluta'),
	(697, 9, 1, 'Austrums'),
	(698, 9, 2, 'Elīza'),
	(699, 9, 2, 'Lizete'),
	(700, 9, 2, 'Zete'),
	(701, 9, 3, 'Berta'),
	(702, 9, 3, 'Bella'),
	(703, 9, 4, 'Dzintra'),
	(704, 9, 4, 'Dzintara'),
	(705, 9, 4, 'Dzintars'),
	(706, 9, 5, 'Klaudija'),
	(707, 9, 5, 'Persijs'),
	(708, 9, 5, 'Vaida'),
	(709, 9, 6, 'Maigonis'),
	(710, 9, 6, 'Magnuss'),
	(711, 9, 6, 'Mariuss'),
	(712, 9, 7, 'Regīna'),
	(713, 9, 7, 'Ermīns'),
	(714, 9, 8, 'Ilga'),
	(715, 9, 9, 'Bruno'),
	(716, 9, 9, 'Telma'),
	(717, 9, 10, 'Jausma'),
	(718, 9, 10, 'Albertīne'),
	(719, 9, 11, 'Signe'),
	(720, 9, 11, 'Signija'),
	(721, 9, 12, 'Erna'),
	(722, 9, 12, 'Evita'),
	(723, 9, 12, 'Eva'),
	(724, 9, 13, 'Iza'),
	(725, 9, 13, 'Izabella'),
	(726, 9, 14, 'Sanita'),
	(727, 9, 14, 'Santa'),
	(728, 9, 14, 'Sanda'),
	(729, 9, 14, 'Sanija'),
	(730, 9, 14, 'Sandija'),
	(731, 9, 15, 'Sandra'),
	(732, 9, 15, 'Gunvaldis'),
	(733, 9, 15, 'Gunvaris'),
	(734, 9, 15, 'Sondra'),
	(735, 9, 16, 'Asja'),
	(736, 9, 16, 'Asnate'),
	(737, 9, 16, 'Dāgs'),
	(738, 9, 17, 'Vera'),
	(739, 9, 17, 'Vaira'),
	(740, 9, 17, 'Vairis'),
	(741, 9, 17, 'Vaiva'),
	(742, 9, 18, 'Liesma'),
	(743, 9, 18, 'Elita'),
	(744, 9, 18, 'Alita'),
	(745, 9, 19, 'Verners'),
	(746, 9, 19, 'Muntis'),
	(747, 9, 20, 'Guntra'),
	(748, 9, 20, 'Ginters'),
	(749, 9, 20, 'Marianna'),
	(750, 9, 21, 'Modris'),
	(751, 9, 21, 'Matīss'),
	(752, 9, 21, 'Mariss'),
	(753, 9, 22, 'Māris'),
	(754, 9, 22, 'Mārica'),
	(755, 9, 22, 'Maigurs'),
	(756, 9, 23, 'Vanda'),
	(757, 9, 23, 'Veneranda'),
	(758, 9, 23, 'Venija'),
	(759, 9, 23, 'Vanesa'),
	(760, 9, 24, 'Agris'),
	(761, 9, 24, 'Agrita'),
	(762, 9, 25, 'Rodrigo'),
	(763, 9, 25, 'Rauls'),
	(764, 9, 26, 'Gundars'),
	(765, 9, 26, 'Kurts'),
	(766, 9, 26, 'Knuts'),
	(767, 9, 27, 'Ādolfs'),
	(768, 9, 27, 'Ilgonis'),
	(769, 9, 28, 'Sergejs'),
	(770, 9, 28, 'Svetlana'),
	(771, 9, 28, 'Lana'),
	(772, 9, 29, 'Miķelis'),
	(773, 9, 29, 'Mikus'),
	(774, 9, 29, 'Miks'),
	(775, 9, 29, 'Mihails'),
	(776, 9, 29, 'Jumis'),
	(777, 9, 30, 'Elma'),
	(778, 9, 30, 'Menarda'),
	(779, 9, 30, 'Elna'),
	(780, 10, 1, 'Zanda'),
	(781, 10, 1, 'Lāsma'),
	(782, 10, 1, 'Zandis'),
	(783, 10, 2, 'Ilma'),
	(784, 10, 2, 'Skaidris'),
	(785, 10, 3, 'Elza'),
	(786, 10, 3, 'Ilizana'),
	(787, 10, 4, 'Modra'),
	(788, 10, 4, 'Francis'),
	(789, 10, 4, 'Dmitrijs'),
	(790, 10, 5, 'Amālija'),
	(791, 10, 5, 'Amēlija'),
	(792, 10, 6, 'Monika'),
	(793, 10, 6, 'Zilgma'),
	(794, 10, 6, 'Zilga'),
	(795, 10, 7, 'Daumants'),
	(796, 10, 7, 'Druvvaldis'),
	(797, 10, 8, 'Aina'),
	(798, 10, 8, 'Anete'),
	(799, 10, 9, 'Elga'),
	(800, 10, 9, 'Helga'),
	(801, 10, 9, 'Elgars'),
	(802, 10, 10, 'Arvīds'),
	(803, 10, 10, 'Arvis'),
	(804, 10, 10, 'Druvis'),
	(805, 10, 11, 'Monta'),
	(806, 10, 11, 'Tince'),
	(807, 10, 11, 'Silva'),
	(808, 10, 12, 'Valfrīds'),
	(809, 10, 12, 'Kira'),
	(810, 10, 13, 'Irma'),
	(811, 10, 13, 'Mirga'),
	(812, 10, 14, 'Vilhelmīne'),
	(813, 10, 14, 'Minna'),
	(814, 10, 15, 'Eda'),
	(815, 10, 15, 'Hedviga'),
	(816, 10, 15, 'Helvijs'),
	(817, 10, 16, 'Daiga'),
	(818, 10, 16, 'Dinija'),
	(819, 10, 16, 'Dinārs'),
	(820, 10, 17, 'Gaits'),
	(821, 10, 17, 'Karīna'),
	(822, 10, 17, 'Gaitis'),
	(823, 10, 18, 'Rolands'),
	(824, 10, 18, 'Rolanda'),
	(825, 10, 18, 'Ronalds'),
	(826, 10, 18, 'Erlends'),
	(827, 10, 18, 'Lūkass'),
	(828, 10, 19, 'Elīna'),
	(829, 10, 19, 'Drosma'),
	(830, 10, 19, 'Drosmis'),
	(831, 10, 20, 'Leonīds'),
	(832, 10, 20, 'Leonīda'),
	(833, 10, 21, 'Urzula'),
	(834, 10, 21, 'Severīns'),
	(835, 10, 22, 'Īrisa'),
	(836, 10, 22, 'Irīda'),
	(837, 10, 22, 'Airisa'),
	(838, 10, 23, 'Daina'),
	(839, 10, 23, 'Dainis'),
	(840, 10, 23, 'Dainida'),
	(841, 10, 24, 'Renāte'),
	(842, 10, 24, 'Modrīte'),
	(843, 10, 24, 'Mudrīte'),
	(844, 10, 25, 'Beāte'),
	(845, 10, 25, 'Beatrise'),
	(846, 10, 26, 'Amanda'),
	(847, 10, 26, 'Kaiva'),
	(848, 10, 26, 'Amanta'),
	(849, 10, 27, 'Lilita'),
	(850, 10, 27, 'Irita'),
	(851, 10, 27, 'Ita'),
	(852, 10, 28, 'Ņina'),
	(853, 10, 28, 'Ninona'),
	(854, 10, 28, 'Antoņina'),
	(855, 10, 28, 'Oksana'),
	(856, 10, 29, 'Laimonis'),
	(857, 10, 29, 'Elvijs'),
	(858, 10, 29, 'Elva'),
	(859, 10, 29, 'Elvis'),
	(860, 10, 29, 'Laimis'),
	(861, 10, 30, 'Nadīna'),
	(862, 10, 30, 'Ulla'),
	(863, 10, 30, 'Adīna'),
	(864, 10, 31, 'Valts'),
	(865, 10, 31, 'Rinalds'),
	(866, 10, 31, 'Rinalda'),
	(867, 11, 1, 'Ikars'),
	(868, 11, 2, 'Vivita'),
	(869, 11, 2, 'Dzīle'),
	(870, 11, 2, 'Viva'),
	(871, 11, 3, 'Ērika'),
	(872, 11, 3, 'Dagnija'),
	(873, 11, 4, 'Atis'),
	(874, 11, 4, 'Otomārs'),
	(875, 11, 4, 'Oto'),
	(876, 11, 5, 'Šarlote'),
	(877, 11, 5, 'Lote'),
	(878, 11, 6, 'Linards'),
	(879, 11, 6, 'Leons'),
	(880, 11, 6, 'Leo'),
	(881, 11, 6, 'Leonards'),
	(882, 11, 6, 'Leonarda'),
	(883, 11, 7, 'Helma'),
	(884, 11, 7, 'Lotārs'),
	(885, 11, 7, 'Pērle'),
	(886, 11, 8, 'Aleksandra'),
	(887, 11, 8, 'Agra'),
	(888, 11, 8, 'Aleksa'),
	(889, 11, 9, 'Teodors'),
	(890, 11, 10, 'Mārtiņš'),
	(891, 11, 10, 'Mārcis'),
	(892, 11, 10, 'Markuss'),
	(893, 11, 10, 'Marks'),
	(894, 11, 11, 'Ojārs'),
	(895, 11, 11, 'Rainers'),
	(896, 11, 11, 'Nellija'),
	(897, 11, 12, 'Kaija'),
	(898, 11, 12, 'Kornēlija'),
	(899, 11, 13, 'Eižens'),
	(900, 11, 13, 'Jevgeņijs'),
	(901, 11, 13, 'Jevgeņija'),
	(902, 11, 14, 'Fricis'),
	(903, 11, 14, 'Vikentijs'),
	(904, 11, 14, 'Vincents'),
	(905, 11, 15, 'Leopolds'),
	(906, 11, 15, 'Undīne'),
	(907, 11, 15, 'Unda'),
	(908, 11, 16, 'Banga'),
	(909, 11, 16, 'Glorija'),
	(910, 11, 17, 'Hugo'),
	(911, 11, 17, 'Uga'),
	(912, 11, 17, 'Uģis'),
	(913, 11, 18, 'Aleksandrs'),
	(914, 11, 18, 'Doloresa'),
	(915, 11, 18, 'Brīve'),
	(916, 11, 19, 'Elizabete'),
	(917, 11, 19, 'Liza'),
	(918, 11, 19, 'Līze'),
	(919, 11, 19, 'Betija'),
	(920, 11, 20, 'Anda'),
	(921, 11, 20, 'Andīna'),
	(922, 11, 20, 'Vigo'),
	(923, 11, 21, 'Zeltīte'),
	(924, 11, 21, 'Andis'),
	(925, 11, 22, 'Aldis'),
	(926, 11, 22, 'Alfons'),
	(927, 11, 22, 'Aldris'),
	(928, 11, 23, 'Zigrīda'),
	(929, 11, 23, 'Zigfrīda'),
	(930, 11, 23, 'Zigrīds'),
	(931, 11, 24, 'Velta'),
	(932, 11, 24, 'Velda'),
	(933, 11, 25, 'Katrīna'),
	(934, 11, 25, 'Kate'),
	(935, 11, 25, 'Kadrija'),
	(936, 11, 25, 'Trīne'),
	(937, 11, 25, 'Katrīne'),
	(938, 11, 26, 'Konrāds'),
	(939, 11, 26, 'Sebastians'),
	(940, 11, 27, 'Lauris'),
	(941, 11, 27, 'Norberts'),
	(942, 11, 28, 'Rita'),
	(943, 11, 28, 'Vita'),
	(944, 11, 28, 'Olita'),
	(945, 11, 29, 'Ignats'),
	(946, 11, 29, 'Virgīnija'),
	(947, 11, 30, 'Andrievs'),
	(948, 11, 30, 'Andrejs'),
	(949, 11, 30, 'Andris'),
	(950, 12, 1, 'Arnolds'),
	(951, 12, 1, 'Emanuels'),
	(952, 12, 2, 'Meta'),
	(953, 12, 2, 'Sniedze'),
	(954, 12, 3, 'Evija'),
	(955, 12, 3, 'Raita'),
	(956, 12, 3, 'Jogita'),
	(957, 12, 3, 'Ako'),
	(958, 12, 4, 'Baiba'),
	(959, 12, 4, 'Barbara'),
	(960, 12, 4, 'Barba'),
	(961, 12, 5, 'Sabīne'),
	(962, 12, 5, 'Sarma'),
	(963, 12, 5, 'Klaudijs'),
	(964, 12, 6, 'Nikolajs'),
	(965, 12, 6, 'Niklāvs'),
	(966, 12, 6, 'Niks'),
	(967, 12, 6, 'Nikola'),
	(968, 12, 7, 'Antonija'),
	(969, 12, 7, 'Anta'),
	(970, 12, 7, 'Dzirkstīte'),
	(971, 12, 8, 'Gunārs'),
	(972, 12, 8, 'Vladimirs'),
	(973, 12, 8, 'Gunis'),
	(974, 12, 9, 'Tabita'),
	(975, 12, 9, 'Sarmīte'),
	(976, 12, 10, 'Guna'),
	(977, 12, 10, 'Judīte'),
	(978, 12, 11, 'Voldemārs'),
	(979, 12, 11, 'Valdemārs'),
	(980, 12, 11, 'Valdis'),
	(981, 12, 12, 'Otīlija'),
	(982, 12, 12, 'Iveta'),
	(983, 12, 13, 'Lūcija'),
	(984, 12, 13, 'Veldze'),
	(985, 12, 14, 'Auseklis'),
	(986, 12, 14, 'Gaisma'),
	(987, 12, 15, 'Johanna'),
	(988, 12, 15, 'Hanna'),
	(989, 12, 15, 'Jana'),
	(990, 12, 16, 'Alvīne'),
	(991, 12, 17, 'Hilda'),
	(992, 12, 17, 'Teiksma'),
	(993, 12, 18, 'Kristaps'),
	(994, 12, 18, 'Kristofers'),
	(995, 12, 18, 'Krists'),
	(996, 12, 18, 'Klinta'),
	(997, 12, 18, 'Kristers'),
	(998, 12, 19, 'Lelde'),
	(999, 12, 19, 'Sarmis'),
	(1000, 12, 20, 'Arta'),
	(1001, 12, 20, 'Minjona'),
	(1002, 12, 21, 'Toms'),
	(1003, 12, 21, 'Tomass'),
	(1004, 12, 21, 'Saulcerīte'),
	(1005, 12, 22, 'Saulvedis'),
	(1006, 12, 22, 'Saule'),
	(1007, 12, 23, 'Viktorija'),
	(1008, 12, 23, 'Balva'),
	(1009, 12, 24, 'Ādams'),
	(1010, 12, 24, 'Ieva'),
	(1011, 12, 25, 'Stella'),
	(1012, 12, 25, 'Larisa'),
	(1013, 12, 26, 'Dainuvīte'),
	(1014, 12, 26, 'Gija'),
	(1015, 12, 26, 'Megija'),
	(1016, 12, 27, 'Elmārs'),
	(1017, 12, 27, 'Inita'),
	(1018, 12, 27, 'Helmārs'),
	(1019, 12, 28, 'Inga'),
	(1020, 12, 28, 'Ivita'),
	(1021, 12, 28, 'Irvita'),
	(1022, 12, 28, 'Ingeborga'),
	(1023, 12, 29, 'Solveiga'),
	(1024, 12, 29, 'Ilgona'),
	(1025, 12, 30, 'Dāvids'),
	(1026, 12, 30, 'Dāvis'),
	(1027, 12, 30, 'Dāniels'),
	(1028, 12, 30, 'Daniela'),
	(1029, 12, 30, 'Daniels'),
	(1030, 12, 31, 'Silvestrs'),
	(1031, 12, 31, 'Silvis'),
	(1032, 12, 31, 'Kalvis');

-- Dumping structure for table webshop.products
CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'produkta identifikators',
  `name` varchar(50) NOT NULL COMMENT 'produkta nosaukums',
  `description` text DEFAULT NULL COMMENT 'produkta apraksts',
  `price` int(11) NOT NULL COMMENT 'produkta cena',
  `category_id` int(11) NOT NULL COMMENT 'kategorijas identfikators',
  `image` varchar(50) DEFAULT NULL COMMENT 'produkta attēls',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='produktu tabula.';

-- Dumping data for table webshop.products: ~23 rows (approximately)
INSERT INTO `products` (`id`, `name`, `description`, `price`, `category_id`, `image`) VALUES
	(10, 'Rozes', 'Skaistas sarkanas rozes, kas simbolizē mīlestību un eleganci. Ideāli piemērotas dāvanām, svētkiem vai romantiskiem mirkļiem. Rozes vislabāk jūtas gaišā vietā un vāzē ar svaigu ūdeni. Ieteicams mainīt ūdeni ik pēc 2 dienām un nogriezt kātu galus, lai ziedi ilgāk saglabātos svaigi.', 5, 1, 'rozes.jpg'),
	(11, 'Tulpes', 'Krāsainas un pavasarīgas tulpes, kas piešķir telpai dzīvīgumu un svaigumu. Tulpes ir populāras gan svētkos, gan ikdienas dekorācijās. Tās ieteicams turēt vēsākā vietā, prom no tiešiem saules stariem. Regulāri papildiniet vāzi ar svaigu ūdeni, lai ziedi saglabātu savu skaistumu ilgāk.', 3, 1, 'tulpes.jpg'),
	(12, 'Lilijas', 'Elegantas baltas lilijas ar maigu un patīkamu aromātu. Lilijas simbolizē tīrību un mieru, tāpēc tās bieži izvēlas īpašiem dzīves notikumiem. Novietojiet ziedus vietā ar netiešu apgaismojumu un regulāri mainiet ūdeni. Noņemot putekšņlapas, ziedi ilgāk saglabās svaigu izskatu.', 4, 1, 'lilijas.jpg'),
	(13, 'Nelķes', 'Klasiskas un izturīgas nelķes dažādās krāsās. Tās ir lieliska izvēle gan pušķiem, gan interjera dekorēšanai. Nelķes ir viegli kopjamas un ilgi saglabā svaigumu. Turiet tās tīrā ūdenī un izvairieties no tiešiem saules stariem vai radiatoru tuvuma.', 2, 1, 'nelkes.jpg'),
	(14, 'Krizantēmas', 'Košas dzeltenas krizantēmas, kas simbolizē prieku un pozitīvu enerģiju. Šie ziedi ir iecienīti rudens sezonā un lieliski papildina mājas interjeru. Lai krizantēmas saglabātos ilgāk svaigas, ieteicams regulāri mainīt ūdeni un novietot tās vēsā vietā.', 3, 1, 'krizantemas.jpg'),
	(15, 'Narcises', 'Smaržīgas narcises ar spilgti dzelteniem ziediem, kas asociējas ar pavasari un jaunu sākumu. Narcises piešķir telpai svaigu un saulainu noskaņu. Tās vislabāk jūtas vēsākā vietā ar pietiekamu gaismu. Mainiet ūdeni regulāri un izvairieties no pārāk silta gaisa.', 3, 1, 'narcises.jpg'),
	(16, 'Monstera', 'Monstera ir populārs telpaugs ar lielām, dekoratīvām lapām, kas piešķir modernu un tropisku noskaņu jebkurai telpai. Augs labi aug gaišā vietā ar netiešu saules gaismu. Monsteru nepieciešams laistīt mēreni – tikai tad, kad augsnes virskārta kļuvusi sausa. Regulāri noslaukiet lapas no putekļiem, lai augs saglabātu veselīgu izskatu.', 50, 2, 'monstera.jpg'),
	(17, 'Alveja', 'Alveja jeb Aloe vera ir viegli kopjams un populārs telpaugs ar biezām, sulīgām lapām. Tā ir pazīstama ne tikai ar savu dekoratīvo izskatu, bet arī ar nomierinošajām īpašībām, ko bieži izmanto ādas kopšanā. Alveja vislabāk aug gaišā vietā ar daudz netiešas saules gaismas. Augu nepieciešams laistīt mēreni – tikai tad, kad augsne pilnībā izžuvusi. Pārmērīga laistīšana var kaitēt saknēm.', 30, 2, 'alveja.jpg'),
	(18, 'Meloņkoks', 'Meloņkoks jeb Carica papaya ir eksotisks un dekoratīvs telpaugs ar lielām, tropiska izskata lapām. Tas piešķir mājoklim spilgtu un siltu tropu atmosfēru. Meloņkoks vislabāk aug gaišā un siltā vietā ar daudz saules gaismas. Augu nepieciešams regulāri, bet mēreni laistīt, saglabājot augsni viegli mitru. Vēsākā laikā ieteicams samazināt laistīšanas biežumu un izvairīties no caurvēja.', 100, 3, 'melonkoks.jpg'),
	(19, 'Kokospalma', 'Kokospalma ir iespaidīgs tropu augs ar garām, spalvveida lapām, kas veido raksturīgu siluetu piekrastes ainavās. Dabā tā aug siltos, saulainos reģionos ar augstu mitrumu. Augam nepieciešama daudz gaismas un silta vide, tāpēc tas nav piemērots audzēšanai telpās vai aukstā klimatā. Ideāli piemērots tropu dārziem vai siltumnīcām.', 45, 3, 'kokospalma.jpg'),
	(20, 'Banānkoks', 'Banānkoks ir ātri augošs tropu augs ar lielām, dekoratīvām lapām, kas piešķir eksotisku noskaņu jebkuram dārzam. Tas ražo ēdamus augļus un vislabāk aug siltā, mitrā klimatā ar daudz saules gaismas. Regulāra laistīšana ir būtiska, jo augs slikti panes sausumu. Aukstākos apstākļos tas var pārtraukt augšanu.', 35, 3, 'banankoks.jpg'),
	(21, 'Ananass', 'Ananāss ir eksotisks augļu augs ar unikālu izskatu un saldu, aromātisku augli. Tas vislabāk aug siltā un mitrā klimatā ar labi drenētu augsni un daudz saules. Lai gan tas ir tropu augs, to var audzēt arī siltumnīcās. Nepieciešama mērena laistīšana un stabila temperatūra.', 20, 3, 'ananass.jpg'),
	(22, 'Bambuss', 'Bambuss ir ļoti ātri augošs un izturīgs augs, kas bieži tiek izmantots ainavu veidošanā un dzīvžogos. Tas veido blīvus, stiegrainus stumbrus un var radīt dabisku privātuma aizsegu. Augs labi pielāgojas dažādiem apstākļiem, taču vislabāk aug mitrā un saulainā vidē. Nepieciešama regulāra apgriešana, lai kontrolētu tā izplatību.', 22, 3, 'bambuss.jpg'),
	(23, 'Eikalipts', 'Eikalipts ir augsts un aromātisks koks ar sudrabaini zaļām lapām, kas izdala raksturīgu smaržu. Tas ir izcelsmes no Austrālijas un labi aug siltos, saulainos reģionos. Augs ir ātri augošs un izturīgs pret sausumu. Bieži tiek izmantots gan dekoratīvos stādījumos, gan ēterisko eļļu iegūšanai.', 40, 3, 'eikalipts.jpg'),
	(24, 'Olīvkoks', 'Olīvkoks ir klasisks Vidusjūras augs ar sudrabainām lapām un vērtīgiem augļiem. Tas simbolizē mieru un ilgmūžību un vislabāk aug sausā, saulainā klimatā. Augs ir izturīgs pret sausumu, bet prasa labi drenētu augsni. Regulāra apgriešana palīdz saglabāt skaistu formu un bagātīgu ražu.', 55, 3, 'olivkoks.jpg'),
	(25, 'Juka', 'Juka ir izturīgs tuksneša augs ar asām, dekoratīvām lapām, kas piešķir modernu un eksotisku izskatu dārzam. Tā labi aug sausos un karstos apstākļos un prasa ļoti maz kopšanas. Augs ir ideāls saulainām vietām ar nabadzīgu augsni. Pārmērīga laistīšana var kaitēt saknēm.', 20, 3, 'juka.jpg'),
	(26, 'Mango koks', 'Mango koks ir tropu augļu koks, kas ražo saldus, sulīgus un aromātiskus augļus. Tas vislabāk aug siltā klimatā ar daudz saules un regulāru mitrumu. Augs var kļūt ļoti liels un prasa pietiekami daudz vietas. Aukstums tam ir kaitīgs, tāpēc tas nav piemērots vēsām zonām.', 60, 3, 'mango.jpg'),
	(27, 'Avokado koks', 'Avokado koks ir eksotisks augļu koks ar krēmīgiem, barojošiem augļiem, kas ir ļoti populāri veselīgā uzturā. Tas aug siltā klimatā un prasa saulainu vietu ar labi drenētu augsni. Regulāra laistīšana palīdz nodrošināt labu augšanu, taču augs necieš pārlieku mitrumu. Ideāls dārziem vai siltumnīcām.', 50, 3, 'avokado.jpg'),
	(29, 'Sansevjēra', 'Sansevjēra ir ļoti izturīgs telpaugs ar vertikālām, stingrām lapām, kas labi pielāgojas dažādiem apgaismojuma apstākļiem. Tā ir ideāli piemērota iesācējiem, jo prasa minimālu kopšanu un retu laistīšanu. Augs palīdz uzlabot gaisa kvalitāti un var augt gan gaišās, gan vāji apgaismotās telpās.', 18, 2, 'sansevjera.jpg'),
	(30, 'Fikuss', 'Fikuss ir elegants telpaugs ar spīdīgām lapām, kas piešķir telpai dabisku un svaigu izskatu. Tas vislabāk aug gaišā vietā bez tiešiem saules stariem. Nepieciešama mērena laistīšana un stabila vide, jo fikuss slikti panes straujas izmaiņas.', 30, 2, 'fikuss.jpg'),
	(31, 'Filodendrs', 'Filodendrs ir populārs telpaugs ar dekoratīvām lapām un kāpelējošu augšanas veidu. Tas labi pielāgojas dažādiem apgaismojuma apstākļiem un ir viegli kopjams. Ideāli piemērots gan mājām, gan birojiem.', 27, 2, 'filodendrs.jpg'),
	(32, 'Spatifīla', 'Spatifīla ir elegants telpaugs ar zaļām lapām un baltiem ziediem, kas simbolizē tīrību un mieru. Tas labi aug ēnainās vai pusēnainās vietās un prasa regulāru, bet mērenu laistīšanu. Augs arī palīdz uzlabot iekštelpu gaisa kvalitāti.', 25, 2, 'spatifila.jpg'),
	(33, 'Kalateja', 'Kalateja ir dekoratīvs telpaugs ar rakstainām lapām, kas dienas laikā nedaudz kustas gaismas virzienā. Tā prasa augstu mitrumu un netiešu apgaismojumu. Augs ir ideāls tropiskai atmosfērai telpās.', 26, 2, 'kalateja.jpg');

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