-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 01, 2023 at 09:56 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 `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);

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

--
-- 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');

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

--
-- 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');

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

--
-- 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
('holecste', 2),
('reistkri', 2),
('rutovmar', 2),
('stoladan', 2),
('tomeska1', 2),
('vlasabar', 2);

--
-- Indexes for dumped tables
--

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

--
-- 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 `jednani_s_partnery`
--
ALTER TABLE `jednani_s_partnery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=802;
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 */;
