-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 02, 2025 at 09:34 AM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.3.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `externi_partneri`
--

-- --------------------------------------------------------

--
-- Table structure for table `akce`
--

CREATE TABLE `akce` (
  `id` int(11) NOT NULL,
  `nazev` varchar(63) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `popis` varchar(1023) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `termin` date DEFAULT NULL,
  `spravce_akce` varchar(15) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'login',
  `editoval_kdo` varchar(15) COLLATE utf8_czech_ci NOT NULL COMMENT 'login',
  `editoval_kdy` datetime DEFAULT NULL,
  `odstraneno` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1=akce odstraněna'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `akce`
--

INSERT INTO `akce` (`id`, `nazev`, `popis`, `termin`, `spravce_akce`, `editoval_kdo`, `editoval_kdy`, `odstraneno`) VALUES
(1, 'AAAA', 'popis AAAA', '2025-02-19', 'machdavi', 'machdavi', '2025-02-18 10:07:50', 0),
(2, 'UCEEB CONNECT', 'další z řady networkingových setkání, tentokrát na téma: Energetické komunity', '2025-04-23', 'valente3', 'valente3', '2025-03-25 08:33:22', 0),
(3, 'UCEEB Voucher Infoday', 'Dvojakce:\r\nUCEEB Voucher InfoDay+Využití umělé inteligence pro navázání spolupráce s výzkumem\r\nOd 14h', '2025-03-25', 'kuzmimic', 'svoboj77', '2025-03-07 08:36:11', 0);

-- --------------------------------------------------------

--
-- Table structure for table `akce_ucastnici`
--

CREATE TABLE `akce_ucastnici` (
  `id_akce` int(11) NOT NULL COMMENT 'CK, id v tab.''externi_partneri_firmy'' db.''obecne',
  `id_ucastnika` int(11) NOT NULL COMMENT 'CK, id v tab.''externi_partneri_kontakty'' db.''obecne''',
  `id_firmy` int(11) DEFAULT NULL COMMENT 'CK, id firmy v tab.''externi_partneri_firmy'' db.obecne',
  `prijal` tinyint(4) NOT NULL DEFAULT 0,
  `zucastnilSe` tinyint(4) NOT NULL DEFAULT 0,
  `vystupSetkani` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT 'nedefinovan',
  `poznamka` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `editoval_kdo` varchar(15) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `editoval_kdy` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `akce_ucastnici`
--

INSERT INTO `akce_ucastnici` (`id_akce`, `id_ucastnika`, `id_firmy`, `prijal`, `zucastnilSe`, `vystupSetkani`, `poznamka`, `editoval_kdo`, `editoval_kdy`) VALUES
(1, 31, 31, 0, 0, 'nedefinovan', '', 'jararobe', '2025-02-18 10:15:35'),
(1, 91, 91, 0, 0, 'nedefinovan', 'sdsd', 'machdavi', '2025-02-18 10:08:42'),
(1, 194, 197, 1, 1, 'vedena_diskuze', ' nic', 'jararobe', '2025-05-20 09:22:26'),
(1, 367, 383, 1, 0, 'nedefinovan', '', 'machdavi', '2025-02-18 10:08:35'),
(1, 637, 810, 0, 0, 'nedefinovan', '', 'jararobe', '2025-02-18 10:40:23'),
(1, 638, 810, 0, 0, 'nedefinovan', '', 'jararobe', '2025-02-18 10:40:32'),
(2, 262, 642, 0, 0, 'nedefinovan', 'chybná e-mail adresa/kontakt - nelze pozvat', 'valente3', '2025-03-25 08:52:37'),
(2, 461, 721, 0, 0, 'nedefinovan', '', 'virabohd', '2025-03-13 15:33:07'),
(2, 487, 239, 0, 0, 'nedefinovan', '', 'virabohd', '2025-03-13 15:28:46'),
(2, 856, 468, 0, 0, 'nedefinovan', '', 'haberjos', '2025-03-04 09:50:50'),
(2, 876, 871, 0, 0, 'nedefinovan', '', 'baumetom', '2025-03-13 15:20:57'),
(3, 65, 65, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:14:34'),
(3, 163, 163, 1, 1, 'nedefinovan', '', 'svoboj77', '2025-03-18 08:34:07'),
(3, 185, 187, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:18:18'),
(3, 389, 581, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 08:38:13'),
(3, 667, 504, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 08:37:16'),
(3, 714, 856, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 08:36:27'),
(3, 861, 355, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 08:41:35'),
(3, 862, 454, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 08:49:06'),
(3, 863, 1000, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 08:58:44'),
(3, 864, 1001, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 13:18:18'),
(3, 865, 1002, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:17:27'),
(3, 866, 1003, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:17:06'),
(3, 867, 236, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:16:51'),
(3, 868, 1004, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:16:40'),
(3, 869, 1005, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:16:28'),
(3, 870, 1006, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:16:03'),
(3, 871, 1007, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:15:43'),
(3, 872, 1008, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:15:33'),
(3, 873, 44, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:13:44'),
(3, 874, 416, 0, 0, 'nedefinovan', '', 'svoboj77', '2025-03-07 14:15:11');

-- --------------------------------------------------------

--
-- Table structure for table `externi_partneri_kategorie`
--

CREATE TABLE `externi_partneri_kategorie` (
  `id_firmy` int(11) NOT NULL COMMENT 'CK, id firmy v tab.externi_partneri_firmy',
  `kategorie_hlavni_vedlejsi` tinyint(4) NOT NULL COMMENT '0=kategorie hlavní;1=kategorie vedlejší',
  `id_kategorie` int(11) NOT NULL COMMENT 'CK, id v tab. kategoorie_hlavni nebo kategorie_vedlejsi'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Spojovací tab.Obsahuje kategorie,do nichž jsou firmy zařazen';

--
-- Dumping data for table `externi_partneri_kategorie`
--

INSERT INTO `externi_partneri_kategorie` (`id_firmy`, `kategorie_hlavni_vedlejsi`, `id_kategorie`) VALUES
(48, 0, 1),
(48, 1, 39),
(195, 0, 1),
(195, 0, 4),
(195, 1, 36),
(195, 1, 81),
(197, 0, 1),
(197, 0, 3),
(197, 0, 4),
(197, 0, 5),
(197, 0, 6),
(198, 0, 4),
(198, 1, 80),
(198, 1, 82),
(199, 0, 1),
(199, 1, 44),
(201, 0, 3),
(201, 1, 53),
(202, 0, 1),
(202, 1, 48),
(203, 0, 6),
(203, 1, 76),
(216, 0, 1),
(216, 1, 39),
(217, 0, 1),
(217, 0, 3),
(217, 1, 47),
(217, 1, 57),
(217, 1, 63),
(221, 0, 1),
(221, 0, 3),
(221, 0, 4),
(221, 0, 5),
(221, 0, 6),
(635, 0, 1),
(635, 0, 5),
(635, 1, 43),
(635, 1, 98),
(636, 0, 1),
(636, 0, 6),
(636, 1, 37),
(636, 1, 69),
(637, 0, 1),
(637, 1, 37),
(637, 1, 40),
(637, 1, 43),
(638, 0, 1),
(638, 1, 38),
(640, 0, 1),
(640, 0, 3),
(640, 0, 4),
(640, 0, 5),
(640, 1, 36),
(640, 1, 39),
(640, 1, 40),
(640, 1, 44),
(640, 1, 46),
(640, 1, 47),
(640, 1, 60),
(640, 1, 80),
(640, 1, 95),
(641, 0, 4),
(641, 0, 5),
(641, 0, 6),
(641, 1, 67),
(641, 1, 68),
(641, 1, 72),
(641, 1, 73),
(641, 1, 76),
(641, 1, 79),
(641, 1, 81),
(641, 1, 83),
(641, 1, 93),
(641, 1, 98),
(641, 1, 100),
(645, 0, 1),
(645, 0, 4),
(645, 1, 41),
(645, 1, 42),
(645, 1, 43),
(645, 1, 83),
(681, 0, 1),
(681, 0, 6),
(681, 1, 39),
(681, 1, 42),
(681, 1, 66),
(681, 1, 67),
(681, 1, 68),
(681, 1, 69),
(681, 1, 70),
(681, 1, 71),
(681, 1, 72),
(681, 1, 73),
(681, 1, 74),
(681, 1, 75),
(681, 1, 76),
(681, 1, 77),
(681, 1, 78),
(681, 1, 79),
(682, 0, 3),
(682, 1, 57),
(683, 0, 6),
(704, 0, 4),
(704, 0, 6),
(704, 1, 79),
(704, 1, 93),
(704, 1, 94),
(708, 0, 1),
(708, 0, 4),
(708, 1, 42),
(708, 1, 83),
(708, 1, 84),
(708, 1, 90),
(710, 0, 6),
(710, 1, 76),
(710, 1, 79),
(736, 0, 3),
(736, 0, 4),
(736, 1, 62),
(736, 1, 81),
(736, 1, 83),
(736, 1, 84),
(736, 1, 90),
(758, 0, 1),
(758, 0, 6),
(758, 1, 37),
(758, 1, 71),
(758, 1, 73),
(758, 1, 76),
(763, 0, 1),
(763, 0, 3),
(763, 0, 4),
(763, 0, 5),
(763, 0, 6),
(763, 1, 36),
(763, 1, 55),
(763, 1, 67),
(763, 1, 80),
(763, 1, 95),
(783, 0, 4),
(784, 0, 1),
(784, 0, 5),
(784, 1, 36),
(784, 1, 97),
(784, 1, 98),
(798, 0, 4),
(798, 0, 5),
(798, 1, 83),
(798, 1, 85),
(798, 1, 90),
(805, 0, 1),
(805, 1, 47),
(805, 1, 50),
(816, 0, 1),
(816, 1, 45),
(818, 0, 1),
(818, 1, 43),
(825, 0, 1),
(825, 1, 36),
(825, 1, 42),
(827, 0, 1),
(827, 1, 36),
(833, 0, 3),
(833, 1, 51),
(838, 0, 1),
(838, 0, 3),
(838, 1, 46),
(838, 1, 57),
(839, 0, 4),
(839, 1, 84),
(853, 0, 4),
(853, 1, 80),
(855, 0, 4),
(855, 1, 84),
(855, 1, 85),
(855, 1, 90),
(856, 0, 1),
(856, 0, 3),
(856, 1, 47),
(856, 1, 63),
(858, 0, 3),
(858, 1, 57),
(864, 0, 1),
(864, 1, 36),
(866, 0, 3),
(866, 1, 63),
(873, 0, 3),
(873, 1, 51),
(873, 1, 58),
(883, 0, 3),
(883, 1, 51),
(887, 0, 1),
(887, 0, 4),
(887, 1, 36),
(887, 1, 44),
(887, 1, 80),
(887, 1, 83),
(887, 1, 85),
(887, 1, 88),
(887, 1, 90),
(899, 0, 4),
(899, 1, 82),
(899, 1, 89),
(899, 1, 91),
(902, 0, 3),
(902, 1, 51),
(902, 1, 61),
(932, 0, 4),
(932, 1, 80),
(933, 0, 4),
(933, 1, 80),
(934, 0, 1),
(934, 0, 4),
(934, 1, 36),
(934, 1, 80),
(936, 0, 1),
(936, 0, 3),
(936, 0, 4),
(936, 1, 36),
(936, 1, 55),
(936, 1, 80),
(945, 0, 4),
(945, 1, 80),
(953, 0, 1),
(953, 0, 6),
(953, 1, 37),
(953, 1, 39),
(953, 1, 40),
(953, 1, 42),
(964, 0, 1),
(964, 1, 50),
(968, 0, 1),
(968, 1, 45),
(988, 0, 4),
(988, 0, 6),
(988, 1, 79),
(988, 1, 81),
(988, 1, 87),
(988, 1, 93),
(996, 0, 6),
(997, 0, 1),
(1032, 0, 4),
(1032, 1, 81),
(1033, 0, 1),
(1033, 1, 39),
(1033, 1, 50),
(1035, 0, 4),
(1035, 1, 80),
(1036, 0, 1),
(1036, 1, 39),
(1037, 0, 1),
(1037, 1, 50),
(1038, 0, 4),
(1038, 0, 6),
(1038, 1, 79),
(1038, 1, 93),
(1038, 1, 94),
(1040, 0, 4),
(1040, 1, 81),
(1041, 0, 4),
(1041, 1, 82),
(1041, 1, 88),
(1042, 0, 1),
(1042, 1, 36),
(1043, 0, 1),
(1044, 0, 1),
(1044, 1, 39),
(1045, 0, 4),
(1045, 1, 80),
(1046, 0, 4),
(1046, 1, 82),
(1046, 1, 88),
(1046, 1, 89),
(1046, 1, 91),
(1047, 0, 3),
(1047, 1, 58);

-- --------------------------------------------------------

--
-- Table structure for table `externi_partneri_skupiny`
--

CREATE TABLE `externi_partneri_skupiny` (
  `id_firmy` int(11) NOT NULL,
  `id_skupiny` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='“Spojovací tab.Obsahuje skupiny,do nichž jsou firmy zařaze';

--
-- Dumping data for table `externi_partneri_skupiny`
--

INSERT INTO `externi_partneri_skupiny` (`id_firmy`, `id_skupiny`) VALUES
(1, 3),
(2, 3),
(3, 17),
(4, 3),
(6, 11),
(7, 3),
(8, 2),
(9, 2),
(10, 3),
(11, 17),
(12, 11),
(13, 11),
(14, 17),
(15, 2),
(16, 17),
(17, 10),
(18, 17),
(19, 17),
(20, 17),
(21, 17),
(22, 2),
(23, 6),
(24, 13),
(25, 6),
(26, 17),
(27, 1),
(27, 6),
(28, 3),
(29, 17),
(30, 11),
(31, 1),
(32, 6),
(33, 6),
(34, 17),
(35, 12),
(36, 3),
(37, 2),
(38, 17),
(39, 17),
(40, 2),
(41, 17),
(42, 17),
(43, 17),
(44, 16),
(45, 2),
(46, 17),
(47, 3),
(48, 3),
(49, 3),
(50, 3),
(51, 3),
(52, 17),
(53, 17),
(54, 3),
(55, 2),
(56, 2),
(57, 3),
(58, 3),
(59, 16),
(60, 2),
(61, 2),
(62, 2),
(64, 17),
(65, 17),
(66, 2),
(67, 17),
(68, 1),
(69, 10),
(70, 2),
(71, 17),
(72, 17),
(73, 8),
(73, 10),
(74, 10),
(76, 17),
(77, 1),
(78, 17),
(79, 17),
(81, 17),
(82, 2),
(83, 11),
(84, 3),
(85, 10),
(86, 2),
(87, 3),
(88, 15),
(89, 6),
(89, 17),
(90, 17),
(91, 3),
(93, 17),
(94, 2),
(95, 17),
(97, 11),
(99, 17),
(100, 17),
(101, 4),
(102, 3),
(103, 16),
(104, 16),
(105, 16),
(106, 16),
(107, 17),
(108, 3),
(109, 1),
(110, 3),
(111, 3),
(111, 9),
(112, 11),
(113, 17),
(114, 2),
(115, 11),
(116, 17),
(117, 17),
(119, 11),
(120, 16),
(122, 17),
(123, 17),
(124, 17),
(125, 17),
(126, 17),
(127, 17),
(128, 17),
(129, 17),
(130, 2),
(131, 17),
(132, 6),
(132, 8),
(133, 17),
(134, 6),
(134, 8),
(135, 6),
(135, 8),
(136, 2),
(137, 2),
(138, 1),
(139, 16),
(140, 2),
(141, 8),
(142, 2),
(143, 11),
(144, 11),
(145, 11),
(146, 11),
(147, 3),
(148, 16),
(149, 2),
(150, 17),
(151, 17),
(152, 17),
(153, 17),
(154, 11),
(155, 2),
(156, 11),
(157, 17),
(158, 17),
(159, 17),
(160, 17),
(162, 17),
(163, 16),
(164, 1),
(165, 2),
(166, 3),
(167, 1),
(168, 8),
(169, 1),
(170, 15),
(171, 2),
(172, 17),
(173, 10),
(175, 6),
(176, 2),
(177, 11),
(179, 1),
(180, 17),
(181, 17),
(182, 17),
(183, 16),
(184, 6),
(187, 17),
(190, 2),
(191, 17),
(192, 8),
(193, 15),
(194, 4),
(196, 6),
(197, 12),
(198, 1),
(198, 8),
(199, 12),
(200, 11),
(203, 6),
(204, 16),
(205, 2),
(206, 13),
(207, 12),
(209, 1),
(210, 6),
(211, 17),
(212, 3),
(212, 8),
(212, 11),
(213, 11),
(214, 17),
(215, 6),
(216, 13),
(217, 1),
(218, 2),
(219, 6),
(220, 3),
(221, 17),
(222, 2),
(223, 16),
(224, 17),
(225, 16),
(226, 2),
(228, 16),
(229, 1),
(230, 12),
(232, 1),
(233, 11),
(234, 9),
(234, 11),
(235, 16),
(236, 2),
(237, 11),
(238, 11),
(239, 6),
(240, 6),
(241, 2),
(242, 3),
(243, 13),
(244, 17),
(245, 1),
(246, 11),
(247, 2),
(248, 2),
(249, 13),
(250, 2),
(251, 3),
(253, 11),
(254, 3),
(255, 3),
(256, 11),
(257, 2),
(258, 16),
(259, 16),
(260, 13),
(261, 16),
(262, 3),
(263, 16),
(264, 16),
(265, 16),
(266, 2),
(267, 17),
(268, 6),
(269, 1),
(270, 6),
(271, 2),
(272, 2),
(273, 11),
(274, 6),
(275, 6),
(275, 8),
(276, 10),
(277, 13),
(278, 1),
(279, 16),
(280, 3),
(281, 8),
(282, 11),
(283, 3),
(283, 9),
(285, 16),
(286, 2),
(287, 2),
(288, 10),
(289, 1),
(293, 16),
(294, 11),
(295, 13),
(296, 3),
(297, 10),
(298, 16),
(299, 12),
(301, 17),
(302, 16),
(303, 8),
(305, 8),
(306, 1),
(306, 8),
(307, 12),
(308, 4),
(309, 6),
(310, 11),
(311, 2),
(313, 3),
(314, 2),
(315, 11),
(316, 11),
(318, 6),
(319, 6),
(320, 11),
(320, 16),
(321, 1),
(322, 3),
(322, 8),
(323, 3),
(324, 1),
(324, 8),
(325, 3),
(326, 6),
(327, 3),
(328, 2),
(329, 2),
(331, 6),
(331, 9),
(332, 16),
(333, 3),
(333, 9),
(334, 11),
(335, 11),
(336, 10),
(337, 1),
(339, 2),
(340, 2),
(341, 16),
(342, 6),
(343, 10),
(344, 16),
(345, 1),
(346, 6),
(347, 16),
(348, 10),
(349, 1),
(350, 1),
(351, 2),
(352, 2),
(353, 10),
(354, 11),
(355, 2),
(356, 11),
(356, 16),
(357, 12),
(358, 3),
(359, 6),
(360, 10),
(361, 6),
(362, 4),
(363, 6),
(364, 13),
(367, 3),
(368, 2),
(369, 11),
(370, 2),
(372, 2),
(373, 11),
(374, 17),
(375, 17),
(376, 1),
(377, 16),
(379, 16),
(380, 11),
(381, 3),
(382, 3),
(383, 3),
(384, 2),
(385, 8),
(386, 3),
(387, 2),
(388, 2),
(389, 6),
(390, 11),
(391, 16),
(392, 11),
(393, 16),
(395, 3),
(396, 6),
(397, 4),
(398, 3),
(399, 2),
(400, 3),
(401, 6),
(402, 13),
(404, 10),
(405, 6),
(406, 13),
(407, 3),
(408, 1),
(410, 2),
(411, 2),
(412, 11),
(413, 6),
(414, 11),
(415, 3),
(416, 3),
(417, 17),
(418, 3),
(419, 3),
(420, 2),
(421, 3),
(422, 6),
(423, 2),
(424, 17),
(425, 12),
(426, 6),
(427, 1),
(428, 2),
(429, 3),
(430, 4),
(431, 16),
(432, 2),
(433, 3),
(434, 16),
(435, 16),
(437, 8),
(437, 11),
(438, 2),
(439, 3),
(440, 17),
(441, 11),
(442, 6),
(443, 2),
(444, 2),
(446, 10),
(447, 9),
(447, 16),
(448, 3),
(449, 17),
(450, 4),
(451, 4),
(452, 6),
(453, 11),
(454, 1),
(455, 8),
(455, 13),
(456, 3),
(456, 8),
(457, 2),
(458, 6),
(459, 16),
(460, 3),
(461, 6),
(462, 2),
(463, 3),
(465, 1),
(466, 1),
(466, 8),
(467, 3),
(468, 17),
(469, 6),
(470, 16),
(471, 8),
(471, 11),
(472, 6),
(473, 4),
(474, 2),
(475, 2),
(476, 17),
(477, 2),
(478, 17),
(479, 11),
(480, 1),
(481, 17),
(482, 11),
(484, 16),
(485, 11),
(487, 3),
(488, 17),
(489, 6),
(490, 16),
(491, 1),
(492, 17),
(493, 17),
(494, 1),
(495, 2),
(496, 4),
(497, 15),
(498, 11),
(499, 8),
(499, 10),
(500, 17),
(501, 17),
(502, 1),
(503, 3),
(504, 3),
(505, 2),
(506, 17),
(507, 3),
(508, 8),
(509, 11),
(510, 3),
(510, 8),
(511, 2),
(512, 1),
(512, 8),
(513, 6),
(515, 12),
(516, 12),
(517, 16),
(518, 10),
(520, 6),
(521, 1),
(522, 8),
(523, 6),
(524, 16),
(525, 8),
(526, 17),
(527, 17),
(528, 11),
(529, 12),
(530, 2),
(531, 11),
(532, 16),
(533, 16),
(534, 6),
(535, 13),
(536, 2),
(537, 12),
(538, 6),
(539, 11),
(540, 13),
(541, 3),
(542, 2),
(543, 2),
(544, 3),
(545, 11),
(546, 6),
(547, 16),
(548, 2),
(549, 4),
(550, 6),
(551, 16),
(552, 11),
(554, 6),
(555, 17),
(556, 8),
(556, 11),
(557, 11),
(558, 3),
(558, 8),
(559, 11),
(560, 17),
(561, 2),
(563, 2),
(564, 10),
(566, 11),
(567, 11),
(568, 2),
(569, 11),
(570, 8),
(571, 10),
(572, 6),
(573, 2),
(574, 1),
(575, 1),
(576, 2),
(577, 6),
(578, 17),
(579, 6),
(580, 10),
(581, 3),
(583, 6),
(584, 6),
(585, 6),
(586, 1),
(587, 6),
(588, 3),
(589, 6),
(591, 1),
(592, 3),
(593, 17),
(594, 11),
(595, 6),
(596, 11),
(597, 2),
(599, 11),
(600, 17),
(601, 2),
(602, 10),
(603, 1),
(603, 8),
(605, 16),
(607, 17),
(608, 17),
(609, 2),
(610, 6),
(611, 3),
(612, 13),
(613, 3),
(614, 11),
(615, 1),
(616, 10),
(617, 4),
(617, 8),
(618, 6),
(619, 11),
(620, 2),
(621, 1),
(622, 1),
(622, 8),
(624, 3),
(625, 6),
(626, 1),
(627, 3),
(628, 2),
(629, 1),
(630, 3),
(630, 8),
(631, 8),
(632, 3),
(632, 8),
(633, 17),
(634, 2),
(635, 17),
(636, 3),
(637, 3),
(638, 17),
(639, 8),
(639, 13),
(641, 4),
(641, 6),
(641, 8),
(642, 6),
(643, 11),
(644, 11),
(645, 6),
(646, 6),
(647, 17),
(648, 11),
(649, 17),
(650, 17),
(653, 3),
(654, 11),
(655, 17),
(656, 2),
(656, 8),
(657, 16),
(658, 16),
(659, 16),
(660, 2),
(661, 8),
(661, 11),
(662, 2),
(663, 2),
(664, 2),
(665, 11),
(666, 3),
(667, 2),
(668, 17),
(669, 6),
(670, 16),
(671, 4),
(672, 2),
(673, 11),
(674, 8),
(675, 17),
(676, 17),
(677, 1),
(678, 17),
(679, 1),
(680, 13),
(681, 6),
(682, 1),
(683, 6),
(684, 11),
(685, 17),
(686, 11),
(687, 6),
(688, 3),
(688, 8),
(689, 11),
(690, 17),
(691, 17),
(692, 11),
(693, 8),
(693, 11),
(694, 3),
(695, 11),
(696, 8),
(696, 11),
(697, 17),
(698, 17),
(699, 17),
(700, 13),
(701, 6),
(702, 17),
(703, 17),
(704, 11),
(705, 16),
(707, 11),
(708, 1),
(708, 8),
(709, 1),
(710, 6),
(711, 2),
(712, 13),
(713, 11),
(714, 1),
(715, 2),
(716, 8),
(716, 13),
(717, 4),
(718, 11),
(719, 17),
(720, 1),
(720, 8),
(721, 6),
(722, 17),
(723, 11),
(724, 1),
(725, 17),
(726, 17),
(727, 17),
(728, 11),
(729, 1),
(729, 8),
(730, 17),
(731, 17),
(732, 11),
(734, 1),
(734, 8),
(735, 17),
(736, 16),
(737, 13),
(738, 13),
(739, 4),
(739, 8),
(740, 3),
(740, 8),
(741, 17),
(742, 11),
(744, 16),
(745, 16),
(747, 1),
(747, 8),
(748, 16),
(749, 3),
(750, 11),
(751, 6),
(752, 3),
(753, 17),
(754, 1),
(755, 11),
(756, 13),
(757, 3),
(758, 6),
(759, 6),
(760, 1),
(762, 2),
(763, 1),
(764, 3),
(765, 11),
(766, 17),
(767, 2),
(768, 16),
(769, 6),
(769, 12),
(770, 6),
(771, 6),
(772, 6),
(773, 6),
(774, 6),
(775, 17),
(776, 17),
(777, 6),
(777, 8),
(778, 1),
(779, 2),
(781, 2),
(782, 2),
(783, 6),
(784, 2),
(785, 11),
(786, 6),
(787, 13),
(789, 9),
(790, 2),
(791, 17),
(792, 17),
(793, 17),
(795, 3),
(795, 9),
(796, 17),
(797, 6),
(798, 17),
(799, 6),
(800, 16),
(801, 2),
(802, 10),
(804, 2),
(805, 3),
(806, 17),
(807, 17),
(808, 17),
(809, 3),
(809, 8),
(810, 3),
(811, 3),
(812, 2),
(813, 2),
(814, 6),
(815, 2),
(816, 17),
(817, 8),
(818, 2),
(819, 8),
(819, 11),
(820, 3),
(820, 8),
(821, 2),
(822, 17),
(823, 3),
(824, 6),
(825, 2),
(826, 3),
(827, 6),
(830, 11),
(831, 1),
(832, 1),
(833, 2),
(834, 3),
(835, 2),
(836, 6),
(837, 6),
(840, 3),
(840, 9),
(841, 6),
(842, 1),
(842, 2),
(842, 8),
(843, 17),
(844, 3),
(845, 17),
(846, 17),
(848, 6),
(849, 6),
(850, 4),
(850, 6),
(851, 17),
(853, 17),
(854, 3),
(855, 1),
(856, 11),
(857, 3),
(858, 11),
(859, 2),
(860, 3),
(862, 17),
(863, 17),
(864, 6),
(865, 3),
(866, 13),
(867, 4),
(868, 6),
(868, 8),
(869, 6),
(870, 11),
(871, 17),
(872, 8),
(872, 11),
(873, 16),
(875, 17),
(876, 6),
(877, 3),
(878, 6),
(879, 17),
(880, 6),
(881, 4),
(882, 6),
(883, 11),
(884, 3),
(885, 2),
(886, 8),
(886, 13),
(887, 4),
(888, 17),
(889, 12),
(890, 6),
(892, 6),
(893, 6),
(894, 11),
(895, 17),
(896, 17),
(897, 12),
(898, 17),
(899, 1),
(899, 8),
(900, 3),
(901, 16),
(902, 17),
(903, 1),
(904, 1),
(904, 8),
(986, 11),
(988, 16),
(989, 8),
(990, 16),
(991, 6),
(993, 15),
(994, 1),
(994, 2),
(995, 1),
(996, 6),
(997, 1),
(999, 1),
(1000, 9),
(1000, 16),
(1001, 2),
(1002, 3),
(1003, 16),
(1004, 11),
(1005, 2),
(1006, 16),
(1007, 8),
(1008, 15),
(1013, 16),
(1014, 1),
(1015, 16),
(1016, 8),
(1017, 2),
(1018, 11),
(1019, 11),
(1020, 11),
(1021, 11),
(1022, 11),
(1023, 1),
(1023, 2),
(1023, 3),
(1024, 1),
(1024, 2),
(1024, 3),
(1025, 1),
(1025, 2),
(1025, 3),
(1026, 1),
(1026, 2),
(1026, 3),
(1027, 1),
(1027, 2),
(1027, 3),
(1028, 1),
(1028, 2),
(1028, 3),
(1029, 1),
(1029, 2),
(1029, 3),
(1030, 11),
(1031, 11),
(1032, 11),
(1033, 4),
(1034, 1),
(1035, 6),
(1036, 8),
(1037, 3),
(1038, 8),
(1038, 13),
(1039, 16),
(1040, 16),
(1041, 1),
(1041, 2),
(1041, 16),
(1042, 6),
(1043, 2),
(1044, 2),
(1045, 1),
(1046, 16),
(1047, 2),
(1048, 1),
(1049, 17),
(1050, 17),
(1051, 17),
(1052, 3),
(1053, 6),
(1054, 8),
(1054, 10),
(1054, 12),
(1055, 1);

-- --------------------------------------------------------

--
-- Table structure for table `jednani_s_partnery`
--

CREATE TABLE `jednani_s_partnery` (
  `id` int(11) NOT NULL,
  `id_firmy` int(11) NOT NULL DEFAULT 0 COMMENT 'CK, id firmy v tab.externi_partneri_firmy db.obecne',
  `kdo_jednal` varchar(63) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'kdo z UCEEB jednal (vypsané celé jméno) ',
  `kdo_jednal_id` varchar(15) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'CK. Kdo z UCEEB jednal- (login z tab dataldap db.obecne)',
  `s_kym` varchar(63) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 's kým z externí firmy bylo jednáno (vypsané celé jméno)',
  `s_kym_id` int(11) NOT NULL COMMENT 'CK. S kým z externí firmy bylo jednáno (id z tab externi_partneri_kontakty db.obecne)',
  `predmet_jednani` varchar(127) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `obsah_jednani` varchar(1023) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `datum_jednani` date DEFAULT NULL,
  `upravil_kdo` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'login osoby, která záznam uložila',
  `upravil_kdy` date DEFAULT NULL COMMENT 'datum kdy byl záznam upraven'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `jednani_s_partnery`
--

INSERT INTO `jednani_s_partnery` (`id`, `id_firmy`, `kdo_jednal`, `kdo_jednal_id`, `s_kym`, `s_kym_id`, `predmet_jednani`, `obsah_jednani`, `datum_jednani`, `upravil_kdo`, `upravil_kdy`) VALUES
(1, 1, 'Rybová Barbora', 'koutsbar', 'Testovací uživatel', 1, 'Test jednání', 'test', '2022-01-01', '', NULL),
(3, 198, 'Lupíšek Antonín', 'lupisant', 'Stanislav Klika', 195, 'prezentována naaše nabídka a možnosti spolupráce', 'preznetováno na obchodní poradě 16.6.\r\nbudou chtít rámcovou smlouvu o spolupráci', '2022-06-13', 'lupisant', '2022-06-16'),
(4, 199, 'Lupíšek Antonín', 'lupisant', 'Mgr. Jan Holeček', 196, '', 'Bavili jsme se o možnosti podání projektu na metodiku pro instalici OZE na budovy v Praze. \r\nNějakou obecnou chystají, ale dalo by se to zkonkrétnit. ', '2022-06-14', 'lupisant', '2022-06-16'),
(5, 198, 'Lupíšek Antonín', 'lupisant', '', 0, 'Připravujeme s nimi nabídku do tendru DG Reform', '', '2022-06-30', 'lupisant', '2022-07-01'),
(6, 216, 'Adamovský Daniel', 'adamodan', 'Jan Toman', 225, '', 'diskuze nad možnostmi spolupráce - projekty ZŠ Strupčice a MŠ Brozany nad Ohří', '2022-07-13', 'adamodan', '2022-07-13'),
(7, 634, 'Dostál Jiří', 'dostaji4', 'Marián Belyuš', 247, '', 'LoI na projekt flexibility budov', '2022-07-19', 'dostaji4', '2022-08-04'),
(8, 638, 'Dostál Jiří', 'dostaji4', 'Ing. Petr Matiášek', 254, '', 'Energetická optimalizace sladovny Plzeňský Prazdroj', '2022-07-21', 'dostaji4', '2022-08-04'),
(9, 640, 'Lupíšek Antonín', 'lupisant', 'Marek Horák', 259, 'Jednání o nabídce', 'Hodinová sazba 1680', '2022-08-10', 'lupisant', '2022-08-10'),
(10, 481, 'Adamovský Daniel', 'adamodan', '', 0, '', 'poptávka pravidelných měření', '2022-08-11', 'adamodan', '2022-08-11'),
(11, 641, 'Kuzmic Michal', 'kuzmimic', 'Luděk Fráně', 261, '', 'První jednání na UCEEB.', '2022-06-28', 'kuzmimic', '2022-08-22'),
(12, 100, 'Maierova Lenka', 'maierlen', 'Ing. Martin Novák, Ph.D.', 361, '', 'případná spolupráce na TACR, měření vlivu světelného znečištění na hmyz', '0000-00-00', 'maierlen', '2022-09-08'),
(13, 514, 'Adamovský Daniel', 'adamodan', 'Michal Bregant', 450, '', 'poptávají nastavení úspor energie', '2022-10-31', 'adamodan', '2023-01-24'),
(14, 581, 'Adamovský Daniel', 'adamodan', 'Josef Just', 389, 'nová poptávka', '', '2023-03-16', 'adamodan', '2023-03-21'),
(15, 741, 'Adamovský Daniel', 'adamodan', 'Michal Bernart', 493, 'poptávka energetické koncepce', '', '2023-03-16', 'adamodan', '2023-03-23'),
(17, 70, 'Dobiášová Lucie', 'dobialuc', 'MgA. Přemysl Kokeš', 70, 'měření v rámci projektu OPPIK', '', '0000-00-00', 'adamodan', '2023-03-23'),
(18, 645, 'Hejtmánková Barbora', 'kmonibar', 'Mgr. Jiří Novotný', 265, 'CÉRKA', 'Koordinace studentské spolupráce', '0000-00-00', 'kmonibar', '2023-03-23'),
(19, 15, 'Včelák Jan', 'vcelakj1', 'Petr Šenfeldr', 15, 'PLURAL Projekt, Timberguard projekt', 'Reseni Demonstracni instalace ConexWall Kasava, Reseni mozne pilotni instalace Radio senzoru v projektu TimberGuard', '2023-03-27', 'vcelakj1', '2023-03-24'),
(22, 15, 'Divis Jakub', 'divisja4', 'Petr Šenfeldr', 15, 'projektová schůzka', 'projektová schůzka', '2023-04-25', 'divisja4', '2023-04-12'),
(24, 66, 'Pavlu Tereza', 'pavluter', 'Petra Kaldová', 66, 'Konference', 'Konference, workshop', '2023-04-27', 'pavluter', '2023-04-21'),
(25, 15, 'Veselka Jakub', 'veselj30', 'Petr Šenfeldr', 15, 'A4T', '', '2023-04-25', 'veselj30', '2023-04-25'),
(26, 160, 'Wolf Petr', 'wolfp1', '', 160, '', '', '2023-05-02', 'wolfp1', '2023-05-02'),
(28, 173, 'Kuzmic Michal', 'kuzmimic', 'Prof. Annemie Wyckmans (Mrs.)', 208, 'Plán spolupráce', '', '2023-06-29', 'kuzmimic', '2023-05-04'),
(29, 39, 'Malik Zdenko', 'malikzd1', 'Jorge Corker', 39, '', '', '2023-05-08', 'malikzd1', '2023-05-05'),
(30, 39, 'Malik Zdenko', 'malikzd1', 'Jorge Corker', 39, 'Instalace Dema', '', '2023-05-14', 'malikzd1', '2023-05-11'),
(31, 710, 'Petreje Marek', ' petrema1', 'Petr Švagr', 449, 'HDV a urbanismus', '', '0000-00-00', ' petrema1', '2023-05-15'),
(32, 493, 'Kny Martin', 'knymarti', 'Ing. Pavla Pechová, Ph.D.', 543, 'měření tepelného komfortu ve vlakové soupravě', '', '2023-05-22', 'knymarti', '2023-05-20'),
(33, 296, 'Adamovský Daniel', 'adamodan', 'Jan Rohlík', 559, 'poptávka měření', 'poptávka měření výkonů atypické skladby', '2023-06-07', 'adamodan', '2023-06-08'),
(35, 207, 'Volf Martin', 'volfmar3', 'Milan Hladík', 584, 'kontinuální jednání Q1-Q2/23', 'dostupné bydlení', '2023-08-01', 'volfmar3', '2023-08-02'),
(36, 383, 'Šulc Vladimír', 'sulcvlad', 'Luděk Špidla', 366, 'Tepelne cerpadlo', 'Konstrukce tepelneho cerpadla', '2023-08-10', 'sulcvlad', '2023-08-02'),
(37, 133, 'Kuzmic Michal', 'kuzmimic', 'Francesco  Reda', 133, '', '', '2023-09-24', 'kuzmimic', '2023-08-05'),
(39, 423, 'Vlach Tomas', 'vlachto1', '', 0, '', '', '2023-08-21', 'vlachto1', '2023-08-17'),
(40, 423, 'Vlach Tomas', 'vlachto1', '', 0, '', '', '2023-08-25', 'vlachto1', '2023-08-17'),
(41, 786, 'Kuzmic Michal', 'kuzmimic', 'Monika Volfová', 575, 'zakázka', '', '2023-10-06', 'kuzmimic', '2023-09-11'),
(42, 197, 'Železná Julie', 'hodkojul', 'Mgr. Eva Kaiserová,', 194, 'OTO LCA', 'Seznámení s architekturou DSS a definice postupu činností do konce roku 2023', '2023-09-12', 'hodkojul', '2023-09-11'),
(44, 15, 'Divis Jakub', 'divisja4', 'Petr Šenfeldr', 15, '', '', '2023-10-04', 'divisja4', '2023-09-13'),
(45, 15, 'Veselka Jakub', 'veselj30', 'Petr Šenfeldr', 15, 'Schůze v rámci projektu A4T', '', '2023-10-05', 'veselj30', '2023-09-13'),
(46, 800, 'Hejtmánek Petr', 'hejtmpet', 'Jan Kroupa', 606, 'exkurze ve výrobě', 'požární bezpečnost balkonů', '2023-10-06', 'hejtmpet', '2023-10-03'),
(48, 786, 'Novotný Kamil', 'novotk15', '', 0, 'MEK Horní Slavkov', 'Obsah koncepce + další práce + obhlídka in-situ', '2023-10-13', 'novotk15', '2023-10-12'),
(49, 173, 'Kuzmic Michal', 'kuzmimic', 'Prof. Annemie Wyckmans (Mrs.)', 208, 'eera et al, sparcs', '', '2023-11-06', 'kuzmimic', '2023-10-16'),
(51, 534, 'Dostál Jiří', 'dostaji4', '', 0, 'Optimalizace sladovny', 'Prezentace výsledků energetické analýzy a opravných opatření', '2023-10-18', 'dostaji4', '2023-10-17'),
(53, 405, 'Kuzmic Michal', 'kuzmimic', '', 0, '', '', '2023-10-23', 'kuzmimic', '2023-10-23'),
(54, 160, 'Wolf Petr', 'wolfp1', '', 160, '', '', '0000-00-00', 'wolfp1', '2023-10-24'),
(55, 429, 'Kuzmic Michal', 'kuzmimic', '', 0, '', '', '2023-10-26', 'kuzmimic', '2023-10-26'),
(56, 70, 'Šourek Bořivoj', 'sourebor', 'MgA. Přemysl Kokeš', 70, 'Budoucí spolupráce po skončení projektu', '', '2023-10-30', 'sourebor', '2023-10-30'),
(57, 758, 'Hejtmánková Barbora', 'kmonibar', 'Miroslav Douša', 537, 'Workshop', 'Rozbor veřejných prostranství', '2023-11-05', 'kmonibar', '2023-10-30'),
(58, 56, 'Železná Julie', 'hodkojul', 'Ing. Petr Zahradník ', 56, 'Výroční schůze', 'Výroční schůze CZGBC', '2023-11-03', 'hodkojul', '2023-11-02'),
(59, 15, 'Preclík Miroslav', 'preclmir', 'Petr Šenfeldr', 15, 'Schůze v rámci projektu A4T', '', '2023-10-18', 'preclmir', '2023-11-06'),
(60, 578, 'Klepacova Kateřina', 'salkokat', '', 0, 'certifikace SBToolCZ', '', '2023-11-24', 'salkokat', '2023-11-21'),
(61, 56, 'Lupíšek Antonín', 'lupisant', 'Ing. Petr Zahradník ', 56, 'Zero Carbon Roadmap', 'Konzultace k dekarbonizaci', '2023-11-30', 'lupisant', '2023-11-29'),
(62, 504, 'Adamovský Daniel', 'adamodan', 'Pavla Skalická', 667, '', 'diskuze měření distribučních prvků', '2023-11-07', 'adamodan', '2024-01-04'),
(63, 44, 'Adamovský Daniel', 'adamodan', 'Ing. Ladislav Ravas', 555, '', 'diskuze spolupráce na vývoji větrání akustické budky', '2024-01-16', 'adamodan', '2024-01-04'),
(64, 738, 'Železná Julie', 'hodkojul', 'Aleš Růžička', 488, 'Jednání k projektu', 'Závěry první etapy projektu.', '2024-01-31', 'hodkojul', '2024-01-30'),
(65, 856, 'Adamovský Daniel', 'adamodan', 'Dalimil Petrilák', 714, '', 'diskuze o spolupráci - inovační voucher', '2024-02-12', 'adamodan', '2024-02-21'),
(66, 844, 'Kuzmič Michal', 'kuzmimic', 'Zuzana Vondrová', 686, 'Workshop v Jiříkově na téma Dekarbonizační plán', '', '2024-02-28', 'kuzmimic', '2024-02-27'),
(67, 443, 'Zahrádková Petra', 'zahrap10', '', 0, '', '', '0000-00-00', 'zahrap10', '2024-03-22'),
(68, 56, 'Lupíšek Antonín', 'lupisant', 'Simona Kalvoda', 598, 'Jednání předsednictva CZGBC', '', '2024-04-03', 'lupisant', '2024-04-02'),
(69, 870, 'Adamovský Daniel', 'adamodan', 'Tomáš Bařina', 742, '', 'Odvětrávání výrobní haly lakovny.\r\nVelký poteniál pro úspory energie a energetický managemnt (od minulých majitelů je energetika výroby velmi zanedbaná)', '2024-04-09', 'adamodan', '2024-04-10'),
(70, 798, 'Železná Julie', 'hodkojul', 'Roman Voráč', 603, 'Předání výsledků zakázky', '', '2024-04-19', 'hodkojul', '2024-04-16'),
(71, 49, 'Wolf Petr', 'wolfp1', 'Ing. CYRIL SVOZIL', 49, '', '', '2024-04-17', 'wolfp1', '2024-04-17'),
(72, 729, 'Lupíšek Antonín', 'lupisant', 'Richard Beber', 464, 'Prezentace UCEEB a dekarbonizační roadmapy, odborná exkurze', '', '2024-05-24', 'lupisant', '2024-05-12'),
(74, 53, 'Volf Martin', 'volfmar3', 'Ing. Pavel Klapálek, Ph.D.', 760, 'Výstavba environmentálního centra s využitím SBToolCZ', 'Konzultace možnosti využití metodiky SBToolCZ', '2024-05-29', 'volfmar3', '2024-05-28'),
(75, 481, 'Adamovský Daniel', 'adamodan', 'Ing.Arch. Muamer Kurtović', 762, '', 'aktualizace nabídky pravidelných měření', '2024-05-30', 'adamodan', '2024-05-30'),
(76, 473, 'Lupíšek Antonín', 'lupisant', 'Marta Gellová', 763, 'Mezirezortní jednání k šetrným budovám', 'Jednání se zástupci MŽP, MPO, MMR, MF a oborových asociací', '2024-06-07', 'lupisant', '2024-06-06'),
(78, 55, 'Petreje Marek', 'petrema1', 'Jan Otýs ', 55, 'recyklát pro substrát ReCihli', '', '2024-06-26', 'petrema1', '2024-06-16'),
(80, 481, 'Svobodová Alžběta', 'svoboal4', 'Ing.Arch. Muamer Kurtović', 762, '', '', '2024-06-29', 'svoboal4', '2024-06-28'),
(81, 911, 'Adamovský Daniel', 'adamodan', 'Ing. Richard Záruba', 777, 'problémy s vlhkostí v 4 nových bytech', '', '2024-07-08', 'adamodan', '2024-07-08'),
(82, 900, 'Martínek Vladislav', 'martivl6', 'Michal Hrabí', 765, 'TAČR projekty', 'témata potenciální spolupráce', '2024-07-25', 'martivl6', '2024-07-23'),
(83, 920, 'Adamovský Daniel', 'adamodan', 'Ing. Michal Novák', 784, 'poptávka CFD analýzy datového sálu', '', '2024-07-01', 'adamodan', '2024-08-01'),
(84, 918, 'Pavlů Tereza', 'pavluter', 'Zuzana Špuntová', 782, 'PDA Objektu v Bratislavě', '', '2024-08-03', 'pavluter', '2024-08-02'),
(85, 915, 'Richter Jan', 'richtja7', 'Miroslav Netolický', 780, 'Průzkum obytného podkroví', '', '2024-08-06', 'richtja7', '2024-08-05'),
(87, 918, 'Pavlů Tereza', 'pavluter', 'Zuzana Špuntová', 782, 'Předdemoliční audit ', 'Specifikace zadání na PDA s magistrátem Bratislava', '2024-09-17', 'pavluter', '2024-09-13'),
(89, 918, 'Pavlů Tereza', 'pavluter', 'Zuzana Špuntová', 782, 'PDA Bratislava', 'Možnosti využití recyklovaného kameniva do betonu.', '2024-09-23', 'pavluter', '2024-09-20'),
(91, 728, 'Pavlů Tereza', 'pavluter', 'Jan Otýs', 531, 'Betonáž', 'Ověření směsí vyvíjených pro OP TAK Recybase v provozu', '2024-10-22', 'pavluter', '2024-10-19'),
(92, 221, 'Šourek Bořivoj', 'sourebor', 'Ing. Vít Kosina', 235, 'Tuláčkův statek', 'Posouzeníé možností vytápění', '0000-00-00', 'sourebor', '2024-11-13'),
(93, 481, 'Svobodová Alžběta', 'svoboal4', 'Ing.Arch. Muamer Kurtović', 762, '', '', '2024-12-11', 'svoboal4', '2024-12-10'),
(94, 537, 'Železná Julie', 'hodkojul', 'Petr Uhlíř', 500, 'Jednání komise k LCA databázi MŽP', 'Jednání komise k LCA databázi MŽP', '2024-12-11', 'hodkojul', '2024-12-10'),
(95, 537, 'Železná Julie', 'hodkojul', 'Petr Uhlíř', 500, 'Databáze LCA', 'Ujasnění požadavků na kalkulační nástroj', '2025-01-16', 'hodkojul', '2025-01-16'),
(96, 211, 'Železná Julie', 'hodkojul', 'Ing. arch. LUKÁŠ JANÁČ', 218, 'LCA projektu FIVE', 'Představení předběžného postupu prací', '2025-01-23', 'hodkojul', '2025-01-17'),
(97, 800, 'Vančura Tomáš', 'vancuto4', 'Jan Kroupa', 606, 'Zkouška', '', '2025-01-29', 'vancuto4', '2025-01-27'),
(98, 301, 'Pavlů Tereza', 'pavluter', '', 0, '', '', '2025-01-28', 'pavluter', '2025-01-27'),
(99, 972, 'Matuška Tomáš', 'matustom', 'Tomáš Strnádek', 833, 'Plzeň', 'Formulace a upřesnění objednávky na simulace, vyjasnění potřebných podkladů, prohlídka budovy M. ', '2025-01-24', 'matustom', '2025-01-29'),
(100, 86, 'Jára Robert', 'jararobe', 'Mgr. Renata Vildomcová', 843, '+ Lupíšek + Flanderka', 'Další výhled spolupráce, kontaktní osobou je Ondřej Flandera\r\nhlavní témata spolupráce: \r\n- aktuální chlazení bytových jednotek \r\n- testování zelených střech + konzultace \r\n- čistění šedivých vod \r\n\r\n- ', '2025-02-18', 'jararobe', '2025-02-25'),
(101, 214, 'Šourek Bořivoj', 'sourebor', 'prof. RNDr. Václav Snášel, CSc.', 294, '', '', '2025-02-27', 'sourebor', '2025-02-26'),
(102, 55, 'Vlasatá Barbora', 'vlasabar', 'Jan Otýs', 531, '', '', '2025-03-19', 'vlasabar', '2025-02-28'),
(103, 988, 'Petreje Marek', 'petrema1', 'Zbyněk Ptáček', 848, '', '', '2025-03-18', 'petrema1', '2025-03-03'),
(104, 197, 'Mózer Vladimír', 'mozervla', 'Mgr. Zdeněk Veselý', 193, '', '', '2025-02-09', 'mozervla', '2025-03-03'),
(105, 998, 'Adamovský Daniel', 'adamodan', 'Tomáš Najman', 859, '', 'byli jsme poptáni o měření účinnosti lokální větrací jednotky', '2025-02-25', 'adamodan', '2025-03-06'),
(107, 214, 'Šourek Bořivoj', 'sourebor', 'prof. RNDr. Václav Snášel, CSc.', 294, '', '', '2025-05-01', 'sourebor', '2025-04-30'),
(109, 45, 'Jára Robert', 'jararobe', 'Oldřich ČEVORA', 902, 'Licence TICO', 'Smlouva o využití výsledků z projektu TICO', '2025-05-21', 'jararobe', '2025-05-20'),
(110, 1053, 'Wolf Petr', 'wolfp1', '', 0, '', 'místní šetření pro zakázku Technicko-ekonoomické studie (ino voucher JČ kraj)', '2025-06-02', 'civinjan', '2025-05-30'),
(111, 1054, 'Wolf Petr', 'wolfp1', '', 0, '', 'místní šetření pro vypracování technicko-ekonomické studie', '2025-05-26', 'civinjan', '2025-05-30');

-- --------------------------------------------------------

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `id` int(11) NOT NULL,
  `login` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `datum_cas` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Logy uživatelů, kteří se přihlásili na hlavní stranu app.';

--
-- Dumping data for table `log`
--

INSERT INTO `log` (`id`, `login`, `datum_cas`) VALUES
(4, 'tester', '2022-09-08 14:01:05'),
(7, 'machdavi', '2022-09-08 16:09:41'),
(102, 'knymarti', '2022-09-09 12:03:51'),
(103, 'machdavi', '2022-09-09 12:10:24'),
(125, 'spickma2', '2022-09-09 16:15:30'),
(129, 'spickma2', '2022-09-12 16:21:20'),
(140, 'machdavi', '2022-09-13 12:59:02'),
(142, 'malikzd1', '2022-09-13 13:21:51'),
(159, 'spickma2', '2022-09-13 16:17:40'),
(163, 'spickma2', '2022-09-14 13:59:43'),
(166, 'kuzmimic', '2022-09-16 14:32:32'),
(175, 'spickma2', '2022-09-20 13:58:13'),
(177, 'spickma2', '2022-09-21 09:42:34'),
(186, 'stanekam', '2022-09-22 15:14:40'),
(191, 'stanknic', '2022-09-22 16:57:10'),
(193, 'stanknic', '2022-09-25 12:18:03'),
(216, 'spickma2', '2022-09-27 13:52:35'),
(225, 'stanknic', '2022-09-27 19:33:31'),
(226, 'stanknic', '2022-09-28 20:34:46'),
(231, 'mascujak', '2022-09-30 11:20:23'),
(235, 'kuzmimic', '2022-09-30 14:20:58'),
(236, 'spickma2', '2022-10-03 13:57:17'),
(237, 'dytrijak', '2022-10-03 14:19:52'),
(239, 'adamodan', '2022-10-03 19:58:53'),
(242, 'vanzujan', '2022-10-05 09:41:59'),
(244, 'lupisant', '2022-10-10 09:09:59'),
(251, 'novacjir', '2022-10-11 13:12:57'),
(254, 'wawerrob', '2022-10-11 13:24:05'),
(255, 'rutovmar', '2022-10-13 12:25:08'),
(257, 'stanekam', '2022-10-13 15:10:44'),
(259, 'spickma2', '2022-10-14 09:13:14'),
(262, 'jararobe', '2022-10-17 13:01:11'),
(264, 'dytrijak', '2022-10-18 12:50:07'),
(265, 'hejtmpet', '2022-10-19 23:17:05'),
(267, 'spickma2', '2022-10-21 09:40:22'),
(271, 'wolfp1', '2022-10-24 11:20:29'),
(273, 'vodicale', '2022-10-24 14:05:18'),
(274, 'wolfp1', '2022-10-31 13:33:36'),
(276, 'matustom', '2022-10-31 14:30:33'),
(278, 'dytrijak', '2022-10-31 14:40:25'),
(281, 'spickma2', '2022-11-01 10:38:02'),
(282, 'civinjan', '2022-11-01 13:11:03'),
(288, 'spickma2', '2022-11-03 13:16:00'),
(292, 'hejtmpet', '2022-11-03 15:03:20'),
(294, 'adamodan', '2022-11-04 15:07:45'),
(296, 'spickma2', '2022-11-07 11:18:37'),
(297, 'adamodan', '2022-11-07 12:09:41'),
(299, 'novacjir', '2022-11-08 13:55:35'),
(301, 'divisja4', '2022-11-08 15:52:34'),
(302, 'pestaja2', '2022-11-09 15:17:06'),
(304, 'matustom', '2022-11-10 15:39:43'),
(307, 'spickma2', '2022-11-10 15:50:04'),
(310, 'jararobe', '2022-11-11 16:01:38'),
(313, 'dytrijak', '2022-11-14 18:50:13'),
(318, 'pospika4', '2022-11-15 12:49:13'),
(319, 'wawerrob', '2022-11-15 22:14:38'),
(321, 'lupisant', '2022-11-16 21:50:28'),
(323, 'simcijan', '2022-11-19 21:09:59'),
(325, 'jararobe', '2022-11-21 10:21:43'),
(333, 'simcijan', '2022-11-23 16:20:57'),
(334, 'hejtmpet', '2022-11-24 10:37:52'),
(337, 'jararobe', '2022-11-24 12:02:20'),
(339, 'dytrijak', '2022-11-29 11:08:30'),
(340, 'matustom', '2022-11-29 11:12:14'),
(342, 'hejtmpet', '2022-11-29 19:07:50'),
(347, 'amlerevz', '2022-11-30 12:58:36'),
(350, 'reistkri', '2022-11-30 14:33:48'),
(353, 'wawerrob', '2022-12-02 12:44:25'),
(355, 'lupisant', '2022-12-02 17:20:58'),
(357, 'kuzmimic', '2022-12-02 20:12:56'),
(360, 'dytrijak', '2022-12-08 09:04:17'),
(361, 'machdavi', '2022-12-08 15:43:26'),
(363, 'janovvit', '2022-12-09 13:28:08'),
(369, 'mascujak', '2022-12-12 12:59:36'),
(371, 'lupisant', '2022-12-12 20:00:26'),
(372, 'matustom', '2022-12-13 19:12:48'),
(376, 'vanzujan', '2022-12-16 14:47:50'),
(389, 'snehomic', '2022-12-20 14:59:37'),
(394, 'wawerrob', '2022-12-20 22:13:28'),
(396, 'pestaja2', '2022-12-22 12:44:55'),
(406, 'maierlen', '2022-12-24 11:16:27'),
(408, 'kuzmimic', '2023-01-02 09:32:21'),
(416, 'janovvit', '2023-01-03 09:24:25'),
(418, 'simcijan', '2023-01-09 11:23:30'),
(419, 'dytrijak', '2023-01-10 12:21:10'),
(433, 'jararobe', '2023-01-12 17:18:22'),
(437, 'hodkojul', '2023-01-12 22:05:30'),
(443, 'hodkojul', '2023-01-13 09:30:28'),
(444, 'spaleja1', '2023-01-16 09:10:54'),
(448, 'knymarti', '2023-01-17 10:38:40'),
(450, 'matustom', '2023-01-17 17:40:30'),
(455, 'hodkojul', '2023-01-18 13:41:43'),
(456, 'tester4', '2023-01-18 13:53:30'),
(460, 'jararobe', '2023-01-19 12:36:29'),
(462, 'adamodan', '2023-01-24 08:38:48'),
(465, 'novacjir', '2023-01-24 14:23:14'),
(468, 'lupisant', '2023-01-25 17:39:54'),
(469, 'machdavi', '2023-01-26 10:08:51'),
(471, 'hodkojul', '2023-01-26 16:26:08'),
(472, 'matustom', '2023-01-31 16:20:19'),
(474, 'mascujak', '2023-02-01 11:38:50'),
(476, 'lupisant', '2023-02-03 15:59:32'),
(479, 'salkokat', '2023-02-06 09:52:01'),
(481, 'lupisant', '2023-02-06 09:54:37'),
(482, 'novacjir', '2023-02-06 14:12:55'),
(487, 'spickma2', '2023-02-07 15:31:56'),
(489, 'pestaja2', '2023-02-07 16:21:42'),
(494, 'hodkojul', '2023-02-09 15:36:46'),
(495, 'volfmar3', '2023-02-16 09:23:21'),
(500, 'dytrijak', '2023-02-16 10:16:28'),
(505, 'mascujak', '2023-02-17 10:14:18'),
(507, 'pospika4', '2023-02-20 13:44:16'),
(510, 'hodkojul', '2023-02-20 17:20:21'),
(514, 'pospika4', '2023-02-21 14:43:37'),
(519, 'pospika4', '2023-02-22 12:56:13'),
(521, 'adamodan', '2023-02-24 12:01:25'),
(523, 'postajan', '2023-02-27 11:41:42'),
(531, 'vanzujan', '2023-02-28 17:22:56'),
(532, 'amlerevz', '2023-02-28 17:23:56'),
(533, 'amlerevz', '2023-03-01 19:39:14'),
(534, 'wawerrob', '2023-03-02 09:48:12'),
(547, 'adamodan', '2023-03-02 14:41:22'),
(551, 'spickma2', '2023-03-02 15:18:29'),
(552, 'hejtmpet', '2023-03-02 22:22:24'),
(553, 'adamodan', '2023-03-03 08:00:50'),
(554, 'knymarti', '2023-03-03 13:42:45'),
(556, 'postajan', '2023-03-07 13:53:54'),
(557, 'dytrijak', '2023-03-09 10:57:59'),
(561, 'hodkojul', '2023-03-13 10:24:41'),
(562, 'mackoja3', '2023-03-13 11:18:17'),
(564, 'sykorma6', '2023-03-14 14:12:24'),
(565, 'vodicale', '2023-03-15 09:49:17'),
(566, 'spickma2', '2023-03-15 14:28:41'),
(568, 'mackoja3', '2023-03-16 08:59:42'),
(570, 'hodkojul', '2023-03-16 10:22:28'),
(571, 'dytrijak', '2023-03-16 11:36:29'),
(575, 'spickma2', '2023-03-16 14:42:27'),
(576, 'divisja4', '2023-03-16 14:49:36'),
(578, 'spickma2', '2023-03-17 08:40:44'),
(581, 'spickma2', '2023-03-20 13:57:41'),
(584, 'adamodan', '2023-03-21 14:30:23'),
(586, 'wolfp1', '2023-03-21 15:31:25'),
(588, 'sourebor', '2023-03-22 09:34:34'),
(590, 'adamodan', '2023-03-22 15:15:34'),
(593, 'adamodan', '2023-03-23 08:18:39'),
(594, 'machdavi', '2023-03-23 10:25:08'),
(598, 'spickma2', '2023-03-23 14:10:14'),
(600, 'pestaja2', '2023-03-24 16:38:50'),
(602, 'hodkojul', '2023-03-28 13:37:20'),
(607, 'knymarti', '2023-03-30 08:29:09'),
(608, 'jararobe', '2023-03-30 11:25:31'),
(610, 'lupisant', '2023-03-31 17:32:08'),
(615, 'spickma2', '2023-04-04 13:48:53'),
(622, 'hejtmpet', '2023-04-04 23:01:07'),
(623, 'machdavi', '2023-04-05 13:49:33'),
(629, 'dytrijak', '2023-04-05 16:09:53'),
(630, 'hejtmpet', '2023-04-05 22:53:51'),
(631, 'vlachto1', '2023-04-06 08:54:35'),
(635, 'wolfp1', '2023-04-07 14:28:21'),
(636, 'pospika4', '2023-04-11 12:26:56'),
(646, 'spickma2', '2023-04-11 14:13:25'),
(656, 'jararobe', '2023-04-12 13:07:23'),
(660, 'kuklipe1', '2023-04-12 13:43:56'),
(679, 'spickma2', '2023-04-12 15:53:56'),
(687, 'kuzmimic', '2023-04-13 10:29:38'),
(690, 'spickma2', '2023-04-13 15:25:48'),
(701, 'spickma2', '2023-04-14 12:46:01'),
(703, 'mascujak', '2023-04-17 09:27:09'),
(705, 'snehomic', '2023-04-17 10:44:19'),
(707, 'wawerrob', '2023-04-18 22:22:07'),
(709, 'hejtmpet', '2023-04-19 22:45:37'),
(715, 'spickma2', '2023-04-24 14:57:47'),
(717, 'kuzmimic', '2023-04-25 10:46:26'),
(719, 'postajan', '2023-04-26 12:25:10'),
(720, 'pavluter', '2023-05-03 14:05:31'),
(722, 'mydlipet', '2023-05-04 12:59:28'),
(725, 'pavluter', '2023-05-05 14:28:44'),
(726, 'matustom', '2023-05-07 09:05:08'),
(728, 'dytrijak', '2023-05-07 11:54:04'),
(730, 'spickma2', '2023-05-09 08:38:42'),
(731, 'mascujak', '2023-05-10 12:37:29'),
(733, 'lupisant', '2023-05-12 14:53:38'),
(734, 'volfmar3', '2023-05-12 16:35:11'),
(740, 'knymarti', '2023-05-15 08:32:33'),
(744, 'zahrap10', '2023-05-15 10:09:03'),
(752, 'novacjir', '2023-05-15 12:30:02'),
(756, 'divisja4', '2023-05-15 12:57:33'),
(758, 'kuzmimic', '2023-05-16 17:08:53'),
(759, 'mackoja3', '2023-05-18 13:48:45'),
(760, 'spickma2', '2023-05-18 15:52:56'),
(761, 'adamodan', '2023-05-19 12:51:43'),
(768, 'kuzmimic', '2023-05-23 11:24:15'),
(770, 'postajan', '2023-05-23 13:42:40'),
(771, 'hejtmpet', '2023-05-23 23:54:54'),
(778, 'lupisant', '2023-05-24 05:33:15'),
(779, 'hejtmpet', '2023-05-24 11:20:27'),
(787, 'spickma2', '2023-05-24 13:20:42'),
(789, 'adamodan', '2023-05-25 16:50:56'),
(795, 'spickma2', '2023-05-26 14:34:04'),
(796, 'hejtmpet', '2023-05-27 09:30:58'),
(798, 'spickma2', '2023-05-29 09:22:49'),
(801, 'tomeska1', '2023-05-30 17:24:27'),
(811, 'spickma2', '2023-06-01 14:50:59'),
(813, 'dytrijak', '2023-06-01 16:22:42'),
(816, 'spickma2', '2023-06-05 14:15:34'),
(818, 'knymarti', '2023-06-08 08:06:38'),
(819, 'adamodan', '2023-06-08 12:23:43'),
(821, 'hodkojul', '2023-06-09 15:23:06'),
(827, 'holecste', '2023-06-12 10:37:12'),
(828, 'hodkojul', '2023-06-12 11:01:26'),
(836, 'spickma2', '2023-06-15 16:23:33'),
(838, 'matustom', '2023-06-15 17:41:08'),
(839, 'hejtmpet', '2023-06-19 12:59:50'),
(841, 'hodkojul', '2023-06-20 11:08:28'),
(842, 'dytrijak', '2023-06-21 16:24:26'),
(843, 'hejtmpet', '2023-06-21 21:50:56'),
(849, 'dytrijak', '2023-06-22 16:06:57'),
(850, 'stanekam', '2023-06-22 16:40:54'),
(853, 'amlerevz', '2023-06-23 10:40:19'),
(857, 'dytrijak', '2023-06-23 12:27:09'),
(864, 'reistkri', '2023-06-26 10:31:30'),
(866, 'spickma2', '2023-06-26 13:30:07'),
(867, 'stanekam', '2023-06-27 17:02:33'),
(871, 'matustom', '2023-06-28 13:29:04'),
(873, 'zahrap10', '2023-07-04 11:07:02'),
(879, 'volfmar3', '2023-07-04 13:46:18'),
(883, 'hodkojul', '2023-07-04 13:50:08'),
(886, 'mackoja3', '2023-07-10 10:14:31'),
(888, 'janovvit', '2023-07-10 10:34:12'),
(890, 'dytrijak', '2023-07-10 10:57:45'),
(893, 'kuzmimic', '2023-07-11 15:39:39'),
(895, 'jararobe', '2023-07-13 09:53:38'),
(901, 'sourebor', '2023-07-13 11:45:47'),
(903, 'matustom', '2023-07-13 12:46:07'),
(906, 'dytrijak', '2023-07-13 16:42:42'),
(908, 'mascujak', '2023-07-14 12:00:22'),
(917, 'wolfp1', '2023-07-17 11:08:57'),
(918, 'stanekam', '2023-07-17 13:18:12'),
(920, 'jararobe', '2023-07-17 17:20:39'),
(922, 'postajan', '2023-07-18 15:06:36'),
(933, 'jararobe', '2023-07-20 10:32:24'),
(934, 'kuzmimic', '2023-07-20 10:35:08'),
(936, 'lupisant', '2023-07-20 13:50:06'),
(938, 'jararobe', '2023-07-21 10:25:35'),
(940, 'spickma2', '2023-07-21 14:35:12'),
(942, 'postajan', '2023-07-26 08:15:48'),
(945, 'hodkojul', '2023-07-26 16:55:31'),
(951, 'spickma2', '2023-07-27 14:25:06'),
(953, 'spickma2', '2023-07-31 14:12:19'),
(957, 'mackoja3', '2023-08-01 10:01:55'),
(960, 'volfmar3', '2023-08-02 16:33:21'),
(962, 'postajan', '2023-08-04 13:10:41'),
(969, 'wawerrob', '2023-08-08 10:16:47'),
(974, 'volfmar3', '2023-08-10 11:32:09'),
(976, 'volfmar3', '2023-08-11 00:13:16'),
(977, 'novacjir', '2023-08-14 09:37:16'),
(981, 'tomeska1', '2023-08-14 16:23:18'),
(983, 'stoladan', '2023-08-16 20:41:29'),
(984, 'hodkojul', '2023-08-16 21:25:43'),
(987, 'postajan', '2023-08-22 13:53:17'),
(990, 'adamodan', '2023-08-22 14:29:12'),
(1000, 'tomeska1', '2023-08-23 15:28:33'),
(1002, 'spickma2', '2023-08-23 15:55:59'),
(1004, 'mascujak', '2023-08-24 11:19:31'),
(1013, 'spickma2', '2023-08-25 13:55:59'),
(1016, 'lupisant', '2023-08-29 15:36:01'),
(1019, 'dytrijak', '2023-08-29 15:41:27'),
(1021, 'dytrijak', '2023-08-30 15:50:45'),
(1023, 'matustom', '2023-09-03 09:34:25'),
(1025, 'wawerrob', '2023-09-05 10:50:00'),
(1026, 'amlerevz', '2023-09-05 13:44:04'),
(1028, 'machdavi', '2023-09-05 14:11:42'),
(1031, 'spickma2', '2023-09-05 15:22:45'),
(1032, 'jararobe', '2023-09-06 12:26:22'),
(1033, 'belchwoj', '2023-09-07 16:25:45'),
(1034, 'kmonibar', '2023-09-08 12:44:10'),
(1038, 'hodkojul', '2023-09-11 21:36:48'),
(1040, 'civinjan', '2023-09-15 22:46:21'),
(1044, 'postajan', '2023-09-19 12:57:40'),
(1048, 'divisja4', '2023-09-22 12:01:04'),
(1052, 'wawerrob', '2023-09-26 14:49:09'),
(1055, 'spickma2', '2023-09-27 11:21:30'),
(1057, 'knymarti', '2023-09-27 11:24:59'),
(1058, 'hejtmpet', '2023-10-03 06:44:54'),
(1060, 'novacjir', '2023-10-03 14:46:43'),
(1068, 'wawerrob', '2023-10-04 09:42:59'),
(1070, 'postajan', '2023-10-10 14:10:55'),
(1071, 'hejtmpet', '2023-10-12 09:50:57'),
(1073, 'spickma2', '2023-10-12 12:21:19'),
(1079, 'novotk15', '2023-10-13 12:23:13'),
(1081, 'spickma2', '2023-10-13 13:06:41'),
(1116, 'spickma2', '2023-10-17 10:47:18'),
(1128, 'machdavi', '2023-10-17 14:24:13'),
(1130, 'mascujak', '2023-10-17 16:59:49'),
(1133, 'vlasabar', '2023-10-20 11:40:35'),
(1134, 'solosvia', '2023-10-24 13:15:14'),
(1135, 'buresmi4', '2023-10-24 17:30:17'),
(1138, 'pestaja2', '2023-10-25 11:06:52'),
(1142, 'knymarti', '2023-10-25 20:45:32'),
(1144, 'stanekam', '2023-10-27 13:15:04'),
(1147, 'holecste', '2023-10-30 09:48:12'),
(1172, 'spickma2', '2023-10-31 11:54:06'),
(1173, 'machdavi', '2023-10-31 12:15:48'),
(1174, 'dytrijak', '2023-11-03 10:11:44'),
(1176, 'matustom', '2023-11-03 10:11:53'),
(1178, 'jararobe', '2023-11-03 10:12:08'),
(1181, 'spickma2', '2023-11-03 11:12:05'),
(1191, 'amlerevz', '2023-11-03 22:49:59'),
(1195, 'novacjir', '2023-11-08 11:27:22'),
(1197, 'wawerrob', '2023-11-09 09:42:35'),
(1198, 'stanekam', '2023-11-09 10:20:17'),
(1199, 'noskoson', '2023-11-09 16:49:06'),
(1205, 'jararobe', '2023-11-09 21:42:34'),
(1210, 'machdavi', '2023-11-10 10:45:42'),
(1212, 'spickma2', '2023-11-10 10:57:00'),
(1213, 'repkajak', '2023-11-10 11:14:08'),
(1216, 'sourebor', '2023-11-13 10:36:24'),
(1224, 'mascujak', '2023-11-13 13:08:07'),
(1236, 'wawerrob', '2023-11-15 22:26:36'),
(1238, 'postajan', '2023-11-20 10:43:10'),
(1242, 'spickma2', '2023-11-23 15:05:31'),
(1243, 'repkajak', '2023-11-27 09:31:27'),
(1246, 'lupisant', '2023-11-27 13:59:57'),
(1256, 'spickma2', '2023-11-28 11:16:58'),
(1258, 'dytrijak', '2023-11-28 15:49:01'),
(1260, 'mascujak', '2023-11-29 14:09:16'),
(1262, 'postajan', '2023-11-30 09:54:25'),
(1267, 'divisja4', '2023-12-04 12:56:51'),
(1269, 'spickma2', '2023-12-04 12:57:40'),
(1271, 'machdavi', '2023-12-04 13:52:35'),
(1272, 'pavluter', '2023-12-04 14:12:23'),
(1274, 'mascujak', '2023-12-04 14:52:28'),
(1276, 'divisja4', '2023-12-08 09:00:06'),
(1280, 'spickma2', '2023-12-11 13:04:25'),
(1281, 'malikzd1', '2023-12-11 20:17:35'),
(1285, 'matustom', '2023-12-12 11:47:06'),
(1286, 'amlerevz', '2023-12-13 12:38:51'),
(1288, 'postajan', '2023-12-14 12:54:33'),
(1296, 'dytrijak', '2023-12-14 14:45:46'),
(1299, 'lupisant', '2023-12-21 00:22:50'),
(1300, 'mackoja3', '2024-01-03 11:26:32'),
(1303, 'jararobe', '2024-01-04 10:11:13'),
(1304, 'kuzmimic', '2024-01-04 11:43:14'),
(1311, 'postajan', '2024-01-04 13:49:14'),
(1316, 'adamodan', '2024-01-04 14:01:28'),
(1318, 'postajan', '2024-01-05 13:49:43'),
(1319, 'postajan', '2024-01-08 10:17:20'),
(1326, 'postajan', '2024-01-10 15:16:28'),
(1328, 'matustom', '2024-01-10 16:22:09'),
(1331, 'pestaja2', '2024-01-11 11:48:32'),
(1333, 'novacjir', '2024-01-12 09:09:33'),
(1334, 'houskkat', '2024-01-12 14:27:22'),
(1336, 'spickma2', '2024-01-15 08:35:58'),
(1339, 'postajan', '2024-01-15 09:22:41'),
(1340, 'stanekam', '2024-01-15 15:29:21'),
(1341, 'machdavi', '2024-01-16 15:49:57'),
(1343, 'mascujak', '2024-01-16 19:08:46'),
(1345, 'wawerrob', '2024-01-17 15:05:38'),
(1346, 'divisja4', '2024-01-18 16:15:03'),
(1353, 'zelenva2', '2024-01-21 14:13:35'),
(1355, 'knymarti', '2024-01-22 19:32:10'),
(1358, 'spickma2', '2024-01-23 13:21:18'),
(1364, 'jararobe', '2024-01-24 00:17:31'),
(1365, 'stanekam', '2024-01-24 10:38:51'),
(1372, 'adamodan', '2024-01-24 14:08:18'),
(1374, 'spickma2', '2024-01-24 15:19:37'),
(1375, 'matustom', '2024-01-24 20:10:29'),
(1376, 'novacjir', '2024-01-24 20:39:00'),
(1385, 'civinjan', '2024-01-25 09:12:17'),
(1392, 'novacjir', '2024-01-25 12:38:11'),
(1394, 'adamodan', '2024-01-25 13:22:47'),
(1398, 'matustom', '2024-01-26 06:55:01'),
(1399, 'adamodan', '2024-01-26 09:53:26'),
(1400, 'mackoja3', '2024-01-29 13:55:28'),
(1402, 'postajan', '2024-01-31 11:09:23'),
(1413, 'hodkojul', '2024-01-31 16:21:57'),
(1414, 'mackoja3', '2024-02-01 15:12:58'),
(1415, 'reistkri', '2024-02-01 22:16:38'),
(1432, 'jararobe', '2024-02-02 20:36:36'),
(1433, 'mackoja3', '2024-02-05 11:40:41'),
(1435, 'adamodan', '2024-02-05 14:43:22'),
(1436, 'jararobe', '2024-02-06 16:56:49'),
(1441, 'spickma2', '2024-02-07 11:48:52'),
(1443, 'dytrijak', '2024-02-07 14:26:54'),
(1444, 'jararobe', '2024-02-07 15:59:08'),
(1447, 'kuzmimic', '2024-02-07 17:32:27'),
(1482, 'spickma2', '2024-02-09 12:51:14'),
(1484, 'jararobe', '2024-02-09 15:46:31'),
(1488, 'vlasabar', '2024-02-13 10:52:17'),
(1489, 'postajan', '2024-02-13 11:28:33'),
(1518, 'jararobe', '2024-02-13 18:45:41'),
(1524, 'spickma2', '2024-02-15 12:14:30'),
(1531, 'jararobe', '2024-02-18 21:01:09'),
(1532, 'divisja4', '2024-02-19 10:44:18'),
(1539, 'spickma2', '2024-02-20 14:28:40'),
(1548, 'hodkojul', '2024-02-20 16:22:12'),
(1550, 'adamodan', '2024-02-21 16:28:00'),
(1552, 'kuzmimic', '2024-02-22 14:17:05'),
(1555, 'adamodan', '2024-02-27 17:05:35'),
(1558, 'jararobe', '2024-02-28 10:31:41'),
(1566, 'lupisant', '2024-02-28 19:05:42'),
(1568, 'vedrazuz', '2024-02-28 20:39:31'),
(1570, 'stanekam', '2024-02-29 09:42:35'),
(1572, 'hejtmpet', '2024-03-04 13:11:33'),
(1576, 'jararobe', '2024-03-13 12:50:31'),
(1582, 'jararobe', '2024-03-14 16:18:22'),
(1591, 'pospika4', '2024-03-18 10:07:38'),
(1592, 'sojkokat', '2024-03-18 14:34:32'),
(1596, 'spickma2', '2024-03-19 13:04:34'),
(1610, 'spickma2', '2024-03-20 12:07:12'),
(1612, 'postajan', '2024-03-21 11:21:40'),
(1617, 'hodkojul', '2024-03-22 12:40:53'),
(1619, 'jararobe', '2024-03-25 09:03:52'),
(1620, 'volfmar3', '2024-03-25 11:48:00'),
(1627, 'machdavi', '2024-03-27 17:53:49'),
(1628, 'knymarti', '2024-03-28 13:58:05'),
(1636, 'mackoja3', '2024-04-02 10:25:24'),
(1637, 'spickma2', '2024-04-02 14:31:39'),
(1643, 'mlejnzuz', '2024-04-05 10:07:21'),
(1649, 'spickma2', '2024-04-05 16:00:20'),
(1652, 'spickma2', '2024-04-09 11:34:48'),
(1657, 'mascujak', '2024-04-10 09:30:22'),
(1658, 'mackoja3', '2024-04-10 13:47:18'),
(1659, 'adamodan', '2024-04-10 15:22:35'),
(1663, 'hodkojul', '2024-04-10 19:45:57'),
(1670, 'mlejnzuz', '2024-04-11 14:03:03'),
(1675, 'mlejnzuz', '2024-04-12 12:53:24'),
(1677, 'hodkojul', '2024-04-12 14:04:19'),
(1678, 'kuzmimic', '2024-04-16 16:51:24'),
(1680, 'novacjir', '2024-04-16 21:04:15'),
(1681, 'tencajir', '2024-04-16 23:33:48'),
(1683, 'lupisant', '2024-04-17 14:17:36'),
(1685, 'hejtmpet', '2024-04-18 14:10:33'),
(1686, 'mascujak', '2024-04-22 09:33:24'),
(1688, 'spickma2', '2024-04-22 11:50:27'),
(1691, 'starason', '2024-04-22 16:26:40'),
(1702, 'holecste', '2024-04-23 08:56:39'),
(1704, 'hodkojul', '2024-04-23 12:43:00'),
(1706, 'lupisant', '2024-04-25 13:25:23'),
(1711, 'spickma2', '2024-04-26 10:23:47'),
(1712, 'stoladan', '2024-04-26 10:27:22'),
(1714, 'novacjir', '2024-04-26 11:28:41'),
(1715, 'mlejnzuz', '2024-04-29 09:55:32'),
(1718, 'lupisant', '2024-05-03 11:03:52'),
(1719, 'hejtmpet', '2024-05-05 08:39:21'),
(1722, 'mascujak', '2024-05-09 14:27:23'),
(1723, 'hejtmpet', '2024-05-13 22:23:55'),
(1724, 'zuzansch', '2024-05-15 10:24:28'),
(1726, 'jararobe', '2024-05-16 14:54:11'),
(1729, 'jararobe', '2024-05-20 10:59:19'),
(1737, 'jararobe', '2024-05-21 18:32:05'),
(1739, 'hodkojul', '2024-05-22 11:07:26'),
(1740, 'adamodan', '2024-05-22 16:57:36'),
(1748, 'jararobe', '2024-05-23 10:01:25'),
(1751, 'postajan', '2024-05-23 12:42:36'),
(1752, 'adamodan', '2024-05-23 14:42:31'),
(1753, 'zuzansch', '2024-05-24 14:09:13'),
(1754, 'dytrijak', '2024-05-24 14:19:26'),
(1755, 'volfmar3', '2024-05-26 20:34:49'),
(1761, 'jararobe', '2024-05-27 10:50:30'),
(1767, 'mlejnzuz', '2024-05-27 14:29:07'),
(1768, 'postajan', '2024-05-27 14:32:57'),
(1771, 'mascujak', '2024-05-28 13:54:27'),
(1773, 'volfmar3', '2024-05-28 22:16:12'),
(1787, 'jararobe', '2024-05-30 11:50:28'),
(1789, 'adamodan', '2024-05-30 14:27:48'),
(1793, 'dytrijak', '2024-05-30 16:32:46'),
(1794, 'vedrazuz', '2024-06-04 13:48:52'),
(1796, 'lupisant', '2024-06-05 10:33:31'),
(1798, 'lupisant', '2024-06-06 12:57:55'),
(1800, 'machdavi', '2024-06-06 15:30:11'),
(1812, 'danickar', '2024-06-06 16:10:27'),
(1813, 'stanekam', '2024-06-06 17:57:59'),
(1814, 'dytrijak', '2024-06-11 16:15:11'),
(1819, 'lupisant', '2024-06-12 15:30:48'),
(1821, 'wawerrob', '2024-06-14 12:07:31'),
(1823, 'mackoja3', '2024-06-17 10:53:10'),
(1824, 'stanekam', '2024-06-17 12:58:23'),
(1825, 'wawerrob', '2024-06-17 13:04:54'),
(1826, 'mackoja3', '2024-06-18 11:32:19'),
(1828, 'novacjir', '2024-06-18 13:24:23'),
(1829, 'stanekam', '2024-06-18 17:20:25'),
(1831, 'hejtmpet', '2024-06-18 21:17:28'),
(1833, 'mlejnzuz', '2024-06-21 15:52:14'),
(1834, 'kuzmimic', '2024-06-25 13:41:31'),
(1838, 'machdavi', '2024-06-25 13:55:13'),
(1840, 'adamodan', '2024-06-26 13:10:47'),
(1841, 'machdavi', '2024-06-27 16:07:01'),
(1842, 'jararobe', '2024-07-01 16:24:59'),
(1844, 'pospika4', '2024-07-02 08:43:27'),
(1846, 'mlejnzuz', '2024-07-02 13:32:48'),
(1860, 'jararobe', '2024-07-03 13:47:15'),
(1862, 'divisja4', '2024-07-03 14:22:53'),
(1870, 'jararobe', '2024-07-04 10:00:13'),
(1873, 'pestaja2', '2024-07-04 11:36:38'),
(1883, 'hodkojul', '2024-07-04 22:02:12'),
(1885, 'adamodan', '2024-07-08 11:25:41'),
(1888, 'vlasabar', '2024-07-09 09:13:08'),
(1889, 'adamodan', '2024-07-09 09:53:11'),
(1894, 'zuzansch', '2024-07-09 10:39:30'),
(1895, 'zuzansch', '2024-07-10 13:55:10'),
(1898, 'adamodan', '2024-07-11 09:45:49'),
(1899, 'hejtmpet', '2024-07-11 22:51:50'),
(1900, 'mlejnzuz', '2024-07-12 13:49:05'),
(1970, 'stoladan', '2024-07-22 16:56:50'),
(2039, 'stoladan', '2024-07-23 12:07:44'),
(2092, 'kuzmimic', '2024-07-25 14:13:38'),
(2130, 'stoladan', '2024-07-25 15:51:15'),
(2208, 'stoladan', '2024-07-26 13:02:19'),
(2210, 'tobiamic', '2024-07-27 00:32:04'),
(2211, 'richtja7', '2024-07-29 08:33:15'),
(2213, 'pospika4', '2024-07-29 13:27:53'),
(2214, 'adamodan', '2024-07-30 22:06:42'),
(2215, 'jararobe', '2024-08-01 09:46:10'),
(2218, 'adamodan', '2024-08-01 22:40:01'),
(2220, 'matustom', '2024-08-09 11:07:55'),
(2223, 'hejtmpet', '2024-08-16 22:08:21'),
(2225, 'houskkat', '2024-08-19 14:06:01'),
(2226, 'mydlipet', '2024-08-20 11:38:30'),
(2227, 'mlejnzuz', '2024-08-20 12:58:02'),
(2229, 'hodkojul', '2024-08-21 13:49:04'),
(2230, 'pestaja2', '2024-08-23 15:21:14'),
(2231, 'dytrijak', '2024-08-27 17:09:08'),
(2235, 'haberjos', '2024-08-28 13:47:45'),
(2247, 'adamodan', '2024-08-28 13:55:46'),
(2248, 'svoboj77', '2024-08-28 14:45:34'),
(2254, 'novacjir', '2024-08-29 14:40:22'),
(2258, 'postajan', '2024-09-03 15:02:59'),
(2266, 'pestaja2', '2024-09-04 15:40:01'),
(2276, 'vlasabar', '2024-09-05 13:58:20'),
(2279, 'postajan', '2024-09-06 15:15:21'),
(2280, 'dytrijak', '2024-09-09 14:19:38'),
(2299, 'lupisant', '2024-09-10 17:28:04'),
(2301, 'matustom', '2024-09-13 11:10:14'),
(2302, 'civinjan', '2024-09-24 10:25:23'),
(2304, 'janovvit', '2024-09-24 13:11:00'),
(2306, 'dytrijak', '2024-09-25 20:11:00'),
(2315, 'jararobe', '2024-10-01 09:56:22'),
(2317, 'postajan', '2024-10-04 14:18:46'),
(2319, 'wolfp1', '2024-10-10 10:24:14'),
(2321, 'kuzmimic', '2024-10-10 15:33:54'),
(2323, 'hodkojul', '2024-10-11 11:04:10'),
(2324, 'mackoja3', '2024-10-14 10:18:18'),
(2325, 'houskkat', '2024-10-16 09:32:44'),
(2327, 'adamodan', '2024-10-16 13:34:17'),
(2334, 'volfmar3', '2024-10-18 13:18:15'),
(2336, 'stoladan', '2024-10-18 13:21:54'),
(2338, 'wawerrob', '2024-10-18 15:47:28'),
(2339, 'zahrap10', '2024-10-21 15:28:09'),
(2341, 'stanekam', '2024-10-23 09:18:52'),
(2344, 'civinjan', '2024-10-24 14:36:27'),
(2347, 'matustom', '2024-10-26 22:31:31'),
(2349, 'lupisant', '2024-10-29 16:51:32'),
(2354, 'novotk15', '2024-11-01 16:37:30'),
(2355, 'adamodan', '2024-11-03 21:00:28'),
(2356, 'mlejnzuz', '2024-11-04 11:39:03'),
(2357, 'vlasabar', '2024-11-04 14:05:48'),
(2358, 'adamodan', '2024-11-04 20:38:35'),
(2359, 'volfmar3', '2024-11-07 13:22:18'),
(2360, 'volfmar3', '2024-11-11 11:53:25'),
(2364, 'adamodan', '2024-11-12 13:06:22'),
(2367, 'lupisant', '2024-11-13 16:32:16'),
(2369, 'hodkojul', '2024-11-19 11:18:40'),
(2371, 'lupisant', '2024-11-20 13:35:10'),
(2372, 'pospika4', '2024-11-21 07:47:33'),
(2373, 'jararobe', '2024-11-21 09:04:11'),
(2382, 'mlejnzuz', '2024-11-22 10:56:34'),
(2383, 'richtja7', '2024-11-22 12:27:49'),
(2387, 'jararobe', '2024-11-25 09:31:04'),
(2388, 'vlasabar', '2024-11-25 11:06:11'),
(2390, 'civinjan', '2024-11-27 13:44:47'),
(2392, 'jararobe', '2024-11-28 10:39:38'),
(2398, 'hodkojul', '2024-11-28 16:46:25'),
(2422, 'civinjan', '2024-11-28 22:36:43'),
(2423, 'kuzmimic', '2024-12-02 18:27:16'),
(2425, 'hejtmpet', '2024-12-02 23:18:09'),
(2426, 'hanakar1', '2024-12-03 13:59:52'),
(2427, 'stanekam', '2024-12-05 13:40:08'),
(2430, 'novacjir', '2024-12-09 11:26:43'),
(2431, 'hejtmpet', '2024-12-09 22:26:59'),
(2432, 'richtja7', '2024-12-10 11:27:18'),
(2433, 'wawerrob', '2024-12-10 13:08:52'),
(2443, 'mlejnzuz', '2024-12-11 09:47:13'),
(2445, 'richtja7', '2024-12-12 12:41:51'),
(2447, 'kuzmimic', '2024-12-16 12:14:52'),
(2449, 'adamodan', '2024-12-16 23:12:57'),
(2450, 'mascujak', '2024-12-19 13:22:14'),
(2452, 'kuzmimic', '2024-12-20 15:32:59'),
(2453, 'matustom', '2025-01-02 18:54:02'),
(2456, 'wawerrob', '2025-01-07 11:09:52'),
(2457, 'svoboj77', '2025-01-08 11:56:31'),
(2458, 'rutovmar', '2025-01-08 12:37:39'),
(2463, 'postajan', '2025-01-10 10:07:40'),
(2464, 'kuzmimic', '2025-01-10 10:48:11'),
(2467, 'adamodan', '2025-01-10 14:39:37'),
(2469, 'svoboj77', '2025-01-13 09:12:11'),
(2472, 'jararobe', '2025-01-13 18:33:25'),
(2475, 'jararobe', '2025-01-14 11:16:09'),
(2477, 'svoboj77', '2025-01-14 12:48:06'),
(2479, 'mascujak', '2025-01-14 14:11:10'),
(2480, 'zamprlib', '2025-01-14 15:34:05'),
(2481, 'mruzkire', '2025-01-15 14:51:34'),
(2482, 'novacjir', '2025-01-15 15:05:19'),
(2484, 'jararobe', '2025-01-15 21:43:36'),
(2488, 'jararobe', '2025-01-16 10:09:49'),
(2492, 'dytrijak', '2025-01-16 13:43:47'),
(2493, 'hejtmpet', '2025-01-16 21:43:09'),
(2497, 'kozubale', '2025-01-17 09:55:45'),
(2498, 'wolfp1', '2025-01-17 12:07:49'),
(2499, 'repkajak', '2025-01-17 14:27:09'),
(2501, 'novacjir', '2025-01-20 13:59:43'),
(2503, 'lupisant', '2025-01-22 19:07:23'),
(2505, 'hodkojul', '2025-01-24 07:28:44'),
(2506, 'jararobe', '2025-01-27 14:14:18'),
(2555, 'vlasabar', '2025-01-27 15:19:06'),
(2589, 'kozubale', '2025-01-27 15:40:13'),
(2610, 'svoboj77', '2025-01-27 16:15:54'),
(2780, 'svoboj77', '2025-01-28 11:22:13'),
(2997, 'kozubale', '2025-01-28 13:40:10'),
(2999, 'zamprlib', '2025-01-29 07:55:17'),
(3000, 'matustom', '2025-01-29 08:58:36'),
(3007, 'svoboj77', '2025-01-29 14:54:56'),
(3009, 'dytrijak', '2025-01-30 10:07:28'),
(3012, 'mascujak', '2025-01-30 10:52:32'),
(3013, 'jararobe', '2025-01-31 11:19:58'),
(3016, 'adamodan', '2025-02-03 20:38:14'),
(3017, 'richtja7', '2025-02-05 14:13:49'),
(3018, 'mackoja3', '2025-02-06 08:34:18'),
(3020, 'hodkojul', '2025-02-06 13:31:40'),
(3021, 'richtja7', '2025-02-06 15:56:54'),
(3022, 'vcelakj1', '2025-02-07 10:38:05'),
(3024, 'lupisant', '2025-02-10 20:28:00'),
(3027, 'jararobe', '2025-02-11 08:25:26'),
(3039, 'kozubale', '2025-02-11 09:06:56'),
(3041, 'dytrijak', '2025-02-13 10:17:55'),
(3048, 'bobkole1', '2025-02-14 09:37:27'),
(3065, 'janovvit', '2025-02-14 09:56:10'),
(3066, 'svoboj77', '2025-02-14 13:34:51'),
(3081, 'jararobe', '2025-02-18 10:53:21'),
(3087, 'svoboj77', '2025-02-18 10:54:48'),
(3088, 'machdavi', '2025-02-18 16:34:02'),
(3091, 'pospika4', '2025-02-20 14:18:53'),
(3095, 'lupisant', '2025-02-21 10:26:38'),
(3098, 'jararobe', '2025-02-21 10:38:01'),
(3121, 'machdavi', '2025-02-21 12:36:28'),
(3122, 'pospika4', '2025-02-21 12:51:20'),
(3129, 'svoboj77', '2025-02-21 14:41:03'),
(3130, 'valente3', '2025-02-24 08:35:31'),
(3131, 'machdavi', '2025-02-24 08:58:58'),
(3133, 'svoboj77', '2025-02-24 09:59:57'),
(3134, 'divisja4', '2025-02-24 14:49:07'),
(3140, 'jararobe', '2025-02-25 13:49:11'),
(3141, 'adamodan', '2025-02-25 18:12:39'),
(3142, 'hejtmpet', '2025-02-25 21:44:53'),
(3144, 'jararobe', '2025-02-27 13:13:40'),
(3145, 'valente3', '2025-02-27 13:14:04'),
(3149, 'kuzmimic', '2025-02-27 13:23:14'),
(3150, 'hejtmpet', '2025-02-28 08:22:55'),
(3152, 'dytrijak', '2025-02-28 08:28:00'),
(3153, 'zahrap10', '2025-02-28 09:05:49'),
(3157, 'jararobe', '2025-02-28 10:34:51'),
(3167, 'jararobe', '2025-03-03 10:51:12'),
(3169, 'pestaja2', '2025-03-03 13:13:04'),
(3171, 'hejtmpet', '2025-03-03 13:13:46'),
(3173, 'petrema1', '2025-03-03 13:27:09'),
(3174, 'machdavi', '2025-03-03 13:34:21'),
(3191, 'svoboj77', '2025-03-03 16:15:14'),
(3192, 'wawerrob', '2025-03-04 09:41:03'),
(3195, 'civinjan', '2025-03-04 09:51:54'),
(3198, 'snehomic', '2025-03-04 10:40:14'),
(3202, 'lupisant', '2025-03-04 23:51:58'),
(3206, 'svoboj77', '2025-03-05 11:42:57'),
(3208, 'jararobe', '2025-03-05 13:54:28'),
(3210, 'kuzmimic', '2025-03-06 08:55:02'),
(3211, 'pestaja2', '2025-03-06 09:13:06'),
(3222, 'volfmar3', '2025-03-06 11:46:19'),
(3224, 'adamodan', '2025-03-06 12:28:41'),
(3225, 'valente3', '2025-03-06 13:26:24'),
(3227, 'svoboj77', '2025-03-06 13:59:26'),
(3253, 'svoboj77', '2025-03-07 16:03:38'),
(3283, 'kuzmimic', '2025-03-10 09:49:05'),
(3284, 'svoboj77', '2025-03-10 10:49:54'),
(3286, 'civinjan', '2025-03-10 10:51:34'),
(3287, 'mruzkire', '2025-03-10 13:19:10'),
(3288, 'vlasabar', '2025-03-11 08:40:51'),
(3289, 'valente3', '2025-03-11 13:53:59'),
(3290, 'svoboj77', '2025-03-11 15:10:36'),
(3292, 'jararobe', '2025-03-13 08:28:38'),
(3293, 'valente3', '2025-03-13 13:04:38'),
(3294, 'adamodan', '2025-03-13 13:05:55'),
(3295, 'svoboj77', '2025-03-13 14:41:00'),
(3302, 'machdavi', '2025-03-13 15:41:27'),
(3331, 'jararobe', '2025-03-14 10:34:17'),
(3335, 'svoboj77', '2025-03-14 11:38:52'),
(3336, 'kuzmimic', '2025-03-14 13:34:10'),
(3342, 'jararobe', '2025-03-15 12:48:42'),
(3343, 'kuzmimic', '2025-03-17 09:03:34'),
(3356, 'svoboj77', '2025-03-17 10:02:26'),
(3358, 'volfmar3', '2025-03-17 17:01:24'),
(3375, 'svoboj77', '2025-03-18 10:08:34'),
(3378, 'svoboj77', '2025-03-19 14:45:29'),
(3381, 'mackoja3', '2025-03-20 10:28:51'),
(3383, 'svoboj77', '2025-03-20 12:00:22'),
(3388, 'svoboj77', '2025-03-21 09:24:24'),
(3390, 'pospika4', '2025-03-24 10:04:31'),
(3392, 'rutovmar', '2025-03-24 10:13:49'),
(3393, 'valente3', '2025-03-24 12:36:32'),
(3408, 'civinjan', '2025-03-25 08:46:23'),
(3410, 'valente3', '2025-03-25 08:46:38'),
(3419, 'kozubale', '2025-03-25 09:54:39'),
(3422, 'pospika4', '2025-03-25 13:06:38'),
(3423, 'svoboj77', '2025-03-25 15:07:39'),
(3425, 'pospika4', '2025-03-26 10:19:59'),
(3448, 'mlejnzuz', '2025-03-26 13:10:21'),
(3450, 'pospika4', '2025-03-27 10:26:38'),
(3453, 'dytrijak', '2025-03-27 13:54:57'),
(3456, 'svoboj77', '2025-03-27 16:36:05'),
(3457, 'volfmar3', '2025-03-29 10:42:34'),
(3462, 'hodkojul', '2025-03-31 13:44:36'),
(3464, 'lupisant', '2025-03-31 15:14:43'),
(3465, 'novacjir', '2025-03-31 16:42:17'),
(3467, 'hodkojul', '2025-04-01 13:53:39'),
(3470, 'lupisant', '2025-04-02 19:00:09'),
(3473, 'lupisant', '2025-04-03 09:53:38'),
(3474, 'valente3', '2025-04-07 14:24:18'),
(3476, 'lupisant', '2025-04-07 18:06:51'),
(3477, 'mackoja3', '2025-04-08 09:06:58'),
(3481, 'dytrijak', '2025-04-10 13:24:47'),
(3482, 'mlejnzuz', '2025-04-11 08:26:31'),
(3486, 'lupisant', '2025-04-11 18:00:44'),
(3491, 'dytrijak', '2025-04-14 20:40:34'),
(3493, 'snehomic', '2025-04-15 11:15:43'),
(3497, 'civinjan', '2025-04-16 15:55:57'),
(3499, 'civinjan', '2025-04-17 08:55:14'),
(3501, 'pestaja2', '2025-04-23 08:52:29'),
(3504, 'bobkole1', '2025-04-24 08:02:55'),
(3506, 'mascujak', '2025-04-24 09:56:42'),
(3509, 'kuzmimic', '2025-04-28 09:49:53'),
(3523, 'svoboj77', '2025-04-28 19:38:18'),
(3524, 'salkokat', '2025-04-29 14:21:18'),
(3525, 'adamodan', '2025-04-29 15:21:35'),
(3528, 'machdavi', '2025-04-29 16:23:06'),
(3531, 'svoboj77', '2025-04-30 15:39:50'),
(3534, 'matustom', '2025-05-06 13:47:20'),
(3536, 'volfmar3', '2025-05-07 15:06:21'),
(3537, 'matustom', '2025-05-09 14:40:33'),
(3539, 'dytrijak', '2025-05-12 10:06:00'),
(3543, 'klauster', '2025-05-13 10:04:59'),
(3549, 'svoboj77', '2025-05-13 20:49:18'),
(3556, 'reistkri', '2025-05-20 09:22:35'),
(3565, 'machdavi', '2025-05-20 12:45:58'),
(3572, 'vlachto1', '2025-05-20 13:24:44'),
(3574, 'jararobe', '2025-05-20 15:25:26'),
(3582, 'svoboj77', '2025-05-20 16:40:10'),
(3584, 'jararobe', '2025-05-21 10:37:42'),
(3588, 'reistkri', '2025-05-21 10:44:48'),
(3589, 'mruzkire', '2025-05-21 10:52:21'),
(3594, 'zahrap10', '2025-05-22 08:29:46'),
(3596, 'lupisant', '2025-05-22 17:20:31'),
(3599, 'stoladan', '2025-05-23 11:52:06'),
(3603, 'klauster', '2025-05-23 11:56:52'),
(3605, 'lupisant', '2025-05-26 12:57:43'),
(3609, 'dytrijak', '2025-05-26 14:44:51'),
(3613, 'machdavi', '2025-05-26 14:47:23'),
(3619, 'pospika4', '2025-05-27 13:55:42'),
(3627, 'machdavi', '2025-05-27 14:31:14'),
(3628, 'stanekam', '2025-05-29 13:17:12'),
(3645, 'machdavi', '2025-05-30 11:52:54'),
(3655, 'civinjan', '2025-05-30 13:00:23'),
(3657, 'hejtmpet', '2025-05-30 15:00:42'),
(3668, 'kuzmimic', '2025-05-30 15:31:57'),
(3669, 'svoboj77', '2025-05-30 15:35:56'),
(3686, 'machdavi', '2025-06-02 09:16:40');

-- --------------------------------------------------------

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `login` varchar(63) COLLATE utf8_czech_ci NOT NULL,
  `id_role` int(11) NOT NULL COMMENT '1=účetní; 2=projektové odd.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`login`, `id_role`) VALUES
('civinjan', 3),
('holecste', 2),
('kuklipe1', 3),
('kuzmimic', 3),
('machdavi', 3),
('reistkri', 2),
('rutovmar', 2),
('stoladan', 2),
('svoboj77', 3),
('valente3', 3),
('zuzansch', 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `akce`
--
ALTER TABLE `akce`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `akce_ucastnici`
--
ALTER TABLE `akce_ucastnici`
  ADD PRIMARY KEY (`id_akce`,`id_ucastnika`);

--
-- Indexes for table `externi_partneri_kategorie`
--
ALTER TABLE `externi_partneri_kategorie`
  ADD PRIMARY KEY (`id_firmy`,`kategorie_hlavni_vedlejsi`,`id_kategorie`);

--
-- Indexes for table `externi_partneri_skupiny`
--
ALTER TABLE `externi_partneri_skupiny`
  ADD PRIMARY KEY (`id_firmy`,`id_skupiny`);

--
-- Indexes for table `jednani_s_partnery`
--
ALTER TABLE `jednani_s_partnery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`login`,`id_role`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `akce`
--
ALTER TABLE `akce`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `jednani_s_partnery`
--
ALTER TABLE `jednani_s_partnery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3687;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
