Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Duis pulvinar. Pellentesque sapien. In enim a arcu imperdiet malesuada. Etiam sapien elit, consequat eget, tristique non, venenatis quis, ante. Fusce nibh. Duis bibendum, lectus ut viverra rhoncus, dolor nunc faucibus libero, eget facilisis enim ipsum id lacus. Integer rutrum, orci vestibulum ullamcorper ultricies, lacus quam ultricies odio, vitae placerat pede sem sit amet enim. Praesent dapibus. Nunc auctor. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Nullam eget nisl. Phasellus faucibus molestie nisl. Aliquam erat volutpat. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam id dolor.
In laoreet, magna id viverra tincidunt, sem odio bibendum justo, vel imperdiet sapien wisi sed libero. Nullam sit amet magna in magna gravida vehicula. Vestibulum erat nulla, ullamcorper nec, rutrum non, nonummy ac, erat. Praesent in mauris eu tortor porttitor accumsan. Vivamus luctus egestas leo. Nulla est. Aliquam erat volutpat. Integer pellentesque quam vel velit. Fusce dui leo, imperdiet in, aliquam sit amet, feugiat eu, orci. Nunc auctor. Vivamus luctus egestas leo. Morbi imperdiet, mauris ac auctor dictum, nisl ligula egestas nulla, et sollicitudin sem purus in lacus. Nullam dapibus fermentum ipsum. Phasellus rhoncus. Fusce wisi.
', 'cs'), (2, 2, 'Článek 2', 'clanek-2', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Duis pulvinar. Pellentesque sapien. In enim a arcu imperdiet malesuada. Etiam sapien elit, consequat eget, tristique non, venenatis quis, ante. Fusce nibh. Duis bibendum, lectus ut viverra rhoncus, dolor nunc faucibus libero, eget facilisis enim ipsum id lacus. Integer rutrum, orci vestibulum ullamcorper ultricies, lacus quam ultricies odio, vitae placerat pede sem sit amet enim. Praesent dapibus. Nunc auctor. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Nullam eget nisl. Phasellus faucibus molestie nisl. Aliquam erat volutpat. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam id dolor.
In laoreet, magna id viverra tincidunt, sem odio bibendum justo, vel imperdiet sapien wisi sed libero. Nullam sit amet magna in magna gravida vehicula. Vestibulum erat nulla, ullamcorper nec, rutrum non, nonummy ac, erat. Praesent in mauris eu tortor porttitor accumsan. Vivamus luctus egestas leo. Nulla est. Aliquam erat volutpat. Integer pellentesque quam vel velit. Fusce dui leo, imperdiet in, aliquam sit amet, feugiat eu, orci. Nunc auctor. Vivamus luctus egestas leo. Morbi imperdiet, mauris ac auctor dictum, nisl ligula egestas nulla, et sollicitudin sem purus in lacus. Nullam dapibus fermentum ipsum. Phasellus rhoncus. Fusce wisi.
', 'cs'), (3, 3, 'Článek 3', 'clanek-3', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Duis pulvinar. Pellentesque sapien. In enim a arcu imperdiet malesuada. Etiam sapien elit, consequat eget, tristique non, venenatis quis, ante. Fusce nibh. Duis bibendum, lectus ut viverra rhoncus, dolor nunc faucibus libero, eget facilisis enim ipsum id lacus. Integer rutrum, orci vestibulum ullamcorper ultricies, lacus quam ultricies odio, vitae placerat pede sem sit amet enim. Praesent dapibus. Nunc auctor. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Nullam eget nisl. Phasellus faucibus molestie nisl. Aliquam erat volutpat. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam id dolor.
In laoreet, magna id viverra tincidunt, sem odio bibendum justo, vel imperdiet sapien wisi sed libero. Nullam sit amet magna in magna gravida vehicula. Vestibulum erat nulla, ullamcorper nec, rutrum non, nonummy ac, erat. Praesent in mauris eu tortor porttitor accumsan. Vivamus luctus egestas leo. Nulla est. Aliquam erat volutpat. Integer pellentesque quam vel velit. Fusce dui leo, imperdiet in, aliquam sit amet, feugiat eu, orci. Nunc auctor. Vivamus luctus egestas leo. Morbi imperdiet, mauris ac auctor dictum, nisl ligula egestas nulla, et sollicitudin sem purus in lacus. Nullam dapibus fermentum ipsum. Phasellus rhoncus. Fusce wisi.
', 'cs'), (4, 4, 'Článek 4', 'clanek-4', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Duis pulvinar. Pellentesque sapien. In enim a arcu imperdiet malesuada. Etiam sapien elit, consequat eget, tristique non, venenatis quis, ante. Fusce nibh. Duis bibendum, lectus ut viverra rhoncus, dolor nunc faucibus libero, eget facilisis enim ipsum id lacus. Integer rutrum, orci vestibulum ullamcorper ultricies, lacus quam ultricies odio, vitae placerat pede sem sit amet enim. Praesent dapibus. Nunc auctor. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Nullam eget nisl. Phasellus faucibus molestie nisl. Aliquam erat volutpat. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam id dolor.
In laoreet, magna id viverra tincidunt, sem odio bibendum justo, vel imperdiet sapien wisi sed libero. Nullam sit amet magna in magna gravida vehicula. Vestibulum erat nulla, ullamcorper nec, rutrum non, nonummy ac, erat. Praesent in mauris eu tortor porttitor accumsan. Vivamus luctus egestas leo. Nulla est. Aliquam erat volutpat. Integer pellentesque quam vel velit. Fusce dui leo, imperdiet in, aliquam sit amet, feugiat eu, orci. Nunc auctor. Vivamus luctus egestas leo. Morbi imperdiet, mauris ac auctor dictum, nisl ligula egestas nulla, et sollicitudin sem purus in lacus. Nullam dapibus fermentum ipsum. Phasellus rhoncus. Fusce wisi.
', 'cs'), (5, 5, 'Informace o zpracování osobních údajů', 'informace-o-zpracovani-osobnich-udaju', 'I.
Obchodní společnost Variables s.r.o., se sídlem: Osvětimany 202, 687 42 Osvětimany,
IČ: 08026351 (dále jako „Variables s.r.o.“) v souvislosti s poskytovanými službami zpracovává osobní údaje zákazníků a zájemců o poskytnutí služeb (dále společně označování jako „zákazníci“).
Variables s.r.o. tímto nakládá s informacemi v souladu s nařízením Evropského parlamentu a Rady (EU) 2016/679 ze dne 27. dubna 2016 o ochraně fyzických osob v souvislosti se zpracováním osobních údajů a o volném pohybu těchto údajů a o zrušení směrnice 96/46/ES (dále jen jako „nařízení“), jakož i v souladu se zákonem č. 101/2000 Sb., o ochraně osobních údajů, ve znění pozdějších předpisů (dále jako „zákon“).
II. Subjekt a správce údajů, zdroj osobních údajů
Zákazník je ve smyslu nařízení subjektem údajů, zatímco Variables s.r.o. správcem osobních údajů zákazníka.
Variables s.r.o. zpracovává osobní údaje zákazníků získané převážně od zákazníků, případně také osobní údaje zákazníků, které jsou přístupné ve veřejně dostupných rejstřících, seznamech, registrech či z jiných veřejně dostupných zdrojů.
III. Kategorie zpracovávaných osobních údajů
Variables s.r.o. zpracovává následující kategorie osobních údajů:
Identifikační a kontaktní údaje zákazníka, zejména pak jméno, příjmení, rodné číslo, identifikační číslo, adresu bydliště či sídla, číslo účtu, emailovou adresu a telefonický kontakt.
Údaje o veškerých službách poskytovaných zákazníkovi, údaje z veškeré komunikace mezi a Variables s.r.o., zejména tedy údaje z komunikace telefonické, emailové, stejně jako údaje z chatu a sms.
Údaje o transakcích mezi Variables s.r.o. a zákazníkem, údaje o bankovním spojení zákazníka.
IV. Účely a právní důvod zpracování údajů
Variables s.r.o. osobní údaje zákazníka zpracovává k následujícím účelům a z následujících důvodů:
Zpracování osobních údajů zákazníka je nezbytné k uzavření a plnění smlouvy mezi Variables s.r.o. a zákazníkem, jakož i k poskytnutí služby samotné.
Zpracování osobních údajů zákazníka je nezbytné pro účely splnění právních povinností, kterými je Variables s.r.o. vázána. Variables s.r.o. má zejména povinnosti vůči orgánům státní správy, které jsou jí uloženy platnými právními předpisy, jakož i povinnosti prevenční a povinnosti směřující k obezřetnosti při uzavírání smlouvy.
Zpracování osobních údajů zákazníka je nezbytné pro účely ochrany oprávněných zájmů Variables s.r.o.. Oprávněným zájmem Variables s.r.o. může být zejména uplatnění práv z mezi stranami uzavřené smlouvy či v souvislosti s poskytovanou službou obchodní nebo jiné sdělení zákazníkovi.
V. Právní důvod poskytnutí osobních údajů, důsledky jejich neposkytnutí
Poskytnutí uvedených osobních údajů a jejich zpracování ze strany Variables s.r.o. výše uvedené účely je zákonným požadavkem a zákazník je proto povinný tyto osobní údaje Variables s.r.o. poskytnout.
Ke zpracování výše uvedených osobních údajů k uvedeným účelům není třeba udělení souhlasu ze strany zákazníka. Pro účely řádného a správného výkonu práv a povinností Variables s.r.o., jak před uzavřením smlouvy, tak v průběhu trvání smluvního vztahu i po jeho zániku, je nezbytná plná a jednoznačná identifikace zákazníka, která je spojena s poskytnutím osobních údajů zákazníka.
V případě, jestliže si zákazník nepřeje být příjemcem e-mailových obchodních či jiných sdělení od Variables s.r.o., je zákazník oprávněn vyjádřit se zasíláním těchto sdělení nesouhlas, a to prostřednictvím emailu Variables s.r.o. při první e-mailové komunikaci či kdykoli po ní.
VI. Příjemci osobních údajů
Variables s.r.o. poskytuje osobní údaje zákazníka příjemcům a třetím stranám, kterými jsou orgány veřejné moci, fyzické či právnické osoby (zejm. osoby poskytující zaměstnavateli účetní služby a osoby poskytující zaměstnavateli datová úložiště), agentura, dopravce nebo jiný subjekt. Variables s.r.o. takto poskytuje údaje bez souhlasu zákazníka pouze v souvislosti s výše vymezenými účely zpracování osobních údajů a z výše uvedených důvodů zpracování.
Jakékoli poskytování osobních údajů zákazníka jakýmkoli dalším příjemcům, z jiných než výše uvedených důvodů, je možné pouze na základě souhlasu, který zákazník Variables s.r.o. předem udělí.
VII. Práva zákazníka
Zákazník má právo požadovat od Variables s.r.o. přístup k jeho osobním údajům, které Variables s.r.o. má k dispozici, stejně tak jako jejich opravu či výmaz, popřípadě omezení zpracování těchto údajů.
Zákazník má taktéž právo vznést námitku proti zpracování, avšak pouze tehdy, nebude-li tím ohrožen nebo znemožněn výkon práv a povinností plynoucích ze smlouvy uzavřené mezi Variables s.r.o. a zákazníkem, jakož i z právních předpisů.
Zákazník je oprávněn podat stížnost u Úřadu pro ochranu osobních údajů.
VIII. Uchovávání osobních údajů
Osobní údaje zákazníka budou uloženy po dobu trvání smluvního vztahu mezi Variables s.r.o. a zákazníkem a po skončení smluvního vztahu po dobu trvání oprávněných zájmů Variables s.r.o.. V dalších případech budou osobní údaje uchovány pak po dobu trvání lhůt pro archivaci daných zvláštními právními předpisy, zejména zákonem o archivnictví.
Totožnost a kontaktní údaje správce se shodují s údaji o správci výše uvedenými.
', 'cs'); -- -------------------------------------------------------- -- -- Struktura tabulky `file` -- CREATE TABLE `file` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `extension` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `mime` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL, `filesize` int(11) NOT NULL, `origin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `file_translation` -- CREATE TABLE `file_translation` ( `id` int(11) NOT NULL, `translatable` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `image` -- CREATE TABLE `image` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `width` int(11) NOT NULL, `height` int(11) NOT NULL, `type` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL, `extension` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `filesize` int(11) NOT NULL, `origin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `image` -- INSERT INTO `image` (`id`, `name`, `width`, `height`, `type`, `extension`, `filesize`, `origin`, `created_at`, `updated_at`) VALUES (1, 'vr4gsc26qa3foq', 1536, 1536, 'image/jpeg', 'jpg', 274889, 'https://hero.digilabs.cz/media/profile-photos/hladik.jpg', '2021-02-12 14:11:13', '2021-02-12 14:11:13'), (2, 'mhk8pxkhqa3foq', 600, 600, 'image/jpeg', 'jpg', 9978, 'https://hero.digilabs.cz/media/profile-photos/cervenka.jpg', '2021-02-12 14:11:14', '2021-02-12 14:11:14'), (4, '6ve56zc24lvlmoq', 4032, 3024, 'image/jpeg', 'jpg', 1923500, '/tmp/php7aNEMD', '2021-02-16 15:35:45', '2021-02-16 15:35:45'), (5, 'yacmdyzns8nmoq', 1226, 1830, 'image/png', 'png', 1994301, '/tmp/phpsfLxXv', '2021-02-16 16:05:16', '2021-02-16 16:05:16'), (6, 'b2g702fuv4omoq', 4032, 3024, 'image/jpeg', 'jpg', 2876033, '/tmp/php0gXcKK', '2021-02-16 16:24:31', '2021-02-16 16:24:31'), (7, 'ubkqlwvv3v4omoq', 2336, 3500, 'image/jpeg', 'jpg', 4621912, '/tmp/phpSJ4SGu', '2021-02-16 16:24:31', '2021-02-16 16:24:31'), (8, 'lwgeagwd41zomoq', 3500, 2336, 'image/jpeg', 'jpg', 4285195, '/tmp/phpmBvHwj', '2021-02-16 16:42:37', '2021-02-16 16:42:37'), (9, '4emw53vmqzomoq', 3500, 2336, 'image/jpeg', 'jpg', 3847955, '/tmp/phpRxwemK', '2021-02-16 16:43:02', '2021-02-16 16:43:02'), (10, 'yv2tbwcz511pmoq', 1600, 1257, 'image/jpeg', 'jpg', 216688, '/tmp/phpoCVOQu', '2021-02-16 16:43:49', '2021-02-16 16:43:49'), (11, '7vfn39hbu4qmoq', 4032, 3024, 'image/jpeg', 'jpg', 2876033, '/tmp/php0gXcKK', '2021-02-16 17:07:42', '2021-02-16 17:07:42'), (12, 'vmlqsovw3u4qmoq', 2336, 3500, 'image/jpeg', 'jpg', 4621912, '/tmp/phpSJ4SGu', '2021-02-16 17:07:42', '2021-02-16 17:07:42'); -- -------------------------------------------------------- -- -- Struktura tabulky `image_translation` -- CREATE TABLE `image_translation` ( `id` int(11) NOT NULL, `translatable` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `image_translation` -- INSERT INTO `image_translation` (`id`, `translatable`, `title`, `locale`) VALUES (2, 4, '', 'cs'), (3, 5, '', 'cs'), (4, 6, '', 'cs'), (5, 7, '', 'cs'), (6, 11, '', 'cs'), (7, 12, '', 'cs'); -- -------------------------------------------------------- -- -- Struktura tabulky `language` -- CREATE TABLE `language` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `full_locale` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `country_code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `currency_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `published` tinyint(1) NOT NULL, `main` tinyint(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `language` -- INSERT INTO `language` (`id`, `title`, `locale`, `full_locale`, `country_code`, `currency_code`, `published`, `main`, `created_at`, `updated_at`) VALUES (1, 'Čeština', 'cs', 'cs_CZ', 'cz', 'CZK', 1, 1, '2021-02-12 14:06:10', '2021-02-12 14:06:10'); -- -------------------------------------------------------- -- -- Struktura tabulky `mail_template` -- CREATE TABLE `mail_template` ( `id` int(11) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `discr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `mail_template` -- INSERT INTO `mail_template` (`id`, `created_at`, `updated_at`, `discr`) VALUES (1, '2021-02-12 14:06:10', '2021-02-12 14:06:10', 'DefaultMailTemplate'), (2, '2021-02-12 14:06:10', '2021-02-12 14:06:10', 'UserCreatedMailTemplate'), (3, '2021-02-12 14:06:10', '2021-02-12 14:06:10', 'UserResetPasswordMailTemplate'); -- -------------------------------------------------------- -- -- Struktura tabulky `mail_template_translation` -- CREATE TABLE `mail_template_translation` ( `id` int(11) NOT NULL, `translatable` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `menu` -- CREATE TABLE `menu` ( `id` int(11) NOT NULL, `language` int(11) DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `published` tinyint(1) NOT NULL, `main` tinyint(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `menu` -- INSERT INTO `menu` (`id`, `language`, `title`, `published`, `main`, `created_at`, `updated_at`) VALUES (1, 1, 'Hlavní menu', 1, 1, '2021-02-12 14:06:10', '2021-02-12 14:06:10'), (2, 1, 'Ostatní informace', 1, 0, '2021-02-16 17:15:55', '2021-02-16 17:15:55'); -- -------------------------------------------------------- -- -- Struktura tabulky `menu_page` -- CREATE TABLE `menu_page` ( `id` int(11) NOT NULL, `menu` int(11) DEFAULT NULL, `page` int(11) DEFAULT NULL, `parent` int(11) DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `target` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `classes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `menu_page` -- INSERT INTO `menu_page` (`id`, `menu`, `page`, `parent`, `title`, `target`, `classes`, `created_at`, `updated_at`) VALUES (14, 1, 1, NULL, 'Úvod', '', '', '2021-02-17 10:54:31', '2021-02-17 10:54:31'), (15, 1, 4, NULL, '', '', '', '2021-02-17 10:54:31', '2021-02-17 10:54:31'), (16, 1, 2, NULL, '', '', '', '2021-02-17 10:54:31', '2021-02-17 10:54:31'), (17, 1, 5, NULL, '', '', '', '2021-02-17 10:54:31', '2021-02-17 10:54:31'), (25, 2, 1, NULL, '', '', '', '2021-02-17 11:05:06', '2021-02-17 11:05:06'), (26, 2, 4, NULL, '', '', '', '2021-02-17 11:05:06', '2021-02-17 11:05:06'), (27, 2, 2, NULL, '', '', '', '2021-02-17 11:05:06', '2021-02-17 11:05:06'), (28, 2, 5, NULL, '', '', '', '2021-02-17 11:05:06', '2021-02-17 11:05:06'), (29, 2, 6, NULL, '', '', '', '2021-02-17 11:05:06', '2021-02-17 11:05:06'); -- -------------------------------------------------------- -- -- Struktura tabulky `message` -- CREATE TABLE `message` ( `id` int(11) NOT NULL, `recipient` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longblob NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sent` tinyint(1) NOT NULL, `sent_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `discr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `message` -- INSERT INTO `message` (`id`, `recipient`, `content`, `title`, `sent`, `sent_at`, `created_at`, `updated_at`, `discr`) VALUES (1, 'hladik@digilabs.cz', 0x425a6834314159265359174666e60003e45f8010207b77fffffff7df2abffffffa600a3c0bee36bb5515726ee583a0002850db05020c93253d41327935369a2640000c991a34321a69a068d006a7a204f44d4da8ca7aa0d0000d000000003101c34d304321a69919308069a00c268d326001034126a24426a6ca6a7b4a7e8a7a8f498269a0f51a19320cd2001a0f2870d34c10c869a6464c201a680309a34c980040d04890100486a6a7b531a234d49e498993206866a68006351f7cedbd9e4fa3a7e7af1be67bc1c90ecd50e641608971286544584c5cedc0bc8838291608891458a91122a205632978c62cb46228884a430260c148a2145b236d32cb454498b282c560a2c24c2483fb756d3d81ff62af7e4346542658f142d27e0a936d6c3f1f6512dee40ea9a98698435303f761268616c91aafe7575fd7d5dfdf62c3d5f66d490b757451d67b26a598aa2459d65677e8afeb2d759d2b42db8223ed481684401e6997c719131346de19cebf06e227d122f6c781d1b5a77c39f4e052c0e4e99501cab783dcc38f06de689f52003a38de51c6d944be725488040cc9965b74e808ce2693d0325090aef43dc4b4e7a6c68ef021e5fb075abac07ef2b1a1602baf1e0a34b6e1445c7131c19148f1c4040d35f08c37f89b599ceb33e8b3d6f332a3519956637c103baf100d534c949d0a623bb3b10227b7a39c17fdf6cbb23730c5246a23ea6914007de3f56c0a047063a5d2adbd12b2c81c357af0da9abd0741283d39451149376d024188815880cb933e31035aa570cef2ed2841768aa4c89b1939344366ed3a5cc946a75ce4140ca22550696092c0198138aab4180c56b75d944f4cd64de766990dcc5591557b474d12d1423d305591dac47b43b968792a8d10fa0631804f4c52fc6bec4bf3b3221ea60fa895ae48fa7e5f06b3080a4d4999e157e2129cdb89792a18a692364d2a8c2ff71ef2092b39b58a7eb99a107ca509d16c83c0824e86cae98ae6a41822bf1b562468a547bb99c48d958d081526eabf23c0a3199714662ad4d923d825bb5c3c3ca1f747147398e9b3c5e45c6e332815414d385ca94c896232b291599184ac10447cd3ace64b05298625cc11ecacddac388935912da65dd5862ed75cd7bf873ee727d5afe1c573beba69c163c389efc33c29be9591c14a82b4457205d2638350d5909f23834a3e02a4824972a84badd456517bd8a9236e09052ccf622529226c28f08fd230e6bf3d75817439de921b318f6ab25be7d678f573f35cf2b3bfd541f4b17c0c164267c53ba4f2f1cc06d1e88d05ad2c939ce5c704f78ade9a9eef8e80f8ce960f75222717251d76a4c2771b2113a452507b8f9fb7e638e3c23e1d9a4c1edd39d93152171a52637e344868c94bc56a285cf05cb1be780d195e073a1b066db6d010541fae1d69adf7606c91e27e3f59114dd377b222574bba99dab95cf0fca79d6fb96a2c06d6bc1a1ae28e1990a62e1ae3385a51086737e2e83fbe93b355ad36dc5626d301893c249b66fe6a794dd722b8d542310f00838c2fb959241e648f905fc046c1092944fe50e45cfd3ba31067da3fa92e1f22ba454ccb32bf58b5523459068ae814ee49635d55cb2d101f5d7f0f83984ccafbe224b17432a5a320a401714c0909ff33f50be2114b9f441fdde933e0bf6a482675a6b5eec7abbf97c692b5060c1345c44030c0f49748a2fea58d424548671909de05a3c07e6024280eb9268e0ed1a5608b954282ae6c4568e02ed23bb2c2f720def0fb1ea9cf6d89a4490781d7fd894ed78159b67f81624924dbd1f40b913d108c78e47c37ad925d3d07164c3b09f6122acfc272d9216e24776cce7e5ca3c7edaf604da47bd853afde545348e7ed3fc9051237199db464fbf0955b640bcef007ded25b2186989fc8c852c999e24546ac26ae8b8d8db7c7e8cc58cadcd6675142af36b26681349f8ef30e2718c664372242081351bcb775b84c456604cebd3303dffaf038a7b94718fd9b7a4d011f3869ed3b4f6fe8135de3b8762f88580130f4e7e7d123d826d2f361762dcaa274e9321601d4c6d08f2c96a90311d234aa484afd823bf4025aaf679c1340a94212a52f5e00d95d04322c7d32f1e1fecbcd4bb901999ccea3ee7e4b99a461e725eb7135e47275f6242fbefc85d624f230127da7419f3c5682b87577ea97b902c56290669406f18f0d414fda10bb97a046c5f6723c3bb149741c736b215f63bcc919073211de75666f86297d2ca004861f2c8c8aa63630f57a3a47211c8c28d5318225222aa7c4212a1d3654fbd2c12472c37165164ad60b9514f9903651903629c4324ce7af9a7b73a19c5aa225d3de8ebcef69f55861ef830c5b14756a0791404774c28650b5788b5b08663c1db89eadcaee80c03089b47e56d3e932f32f818545d66a1af7d40083459d306650fd6e4a562202314c5e2394c252521a0844306863a06e969f8973b922a5c4c1b1852aa043112ac0b25dd60d0168242585308250306039b13960b507d50a08037f0ecfb58236d2a73b9d24e55e0192e7e9608ba44adb3625e9f162acf1ba42925e2c200df146969ea9066ec2ebd908a19e690b88131b11aee22e782ca6699f8be38013d93df3069e0781dc42254058292ec77d0dd774b90783292f691a57900c2005bd801408dbdc604b897539d1c11700ea2a0ab6cfef04b5ceab71c0f854e5a14e84e16485c01a28a6db41403506ba15215056ac090f9b4eebd075dd8769977e585410c265ac179a47af2509503c8445f4c2d610a8500935c8936e4c3947a823c4c034a54059a309bc0259041dd2c865e289671008e746f44c2df66a524d4d5b016390d824d9596a78405b367ab8c70a23166465b8f2993a8fcbaa3561ff103189933a28933bb2c99e7c0638ec342a64c9993422a9b9a6992729a81174c6b60d4f26d9c0f24ba02692b0606c8159481e182804cb0367035a81d086da51c128c815c7a0cf292e4c649a48b8e49672b6864f9401b316bb48e3d21f12442cd9f030111c027243c0300992e90db6119233262ede2fff75185d21b14ec1f71c38740a69555cd3d1d4a5239d238010cd1851b49b4c6d969299bd77a3bf4f248d2e0d28206936936134043f5939b8b6d3a2ba30e0b9cb94705085805936c7cff76f39210c809371145800a13ff177245385090174666e60, 'New account has been created ', 0, NULL, '2021-02-12 14:11:16', '2021-02-12 14:11:16', 'MailMessage'), (2, 'cervenka@digilabs.cz', 0x425a6834314159265359e2be5f2c0003e75f8010207b77fffffff7df2abffffffa600a3c1edf78da9ef566f526f72f7014053d99b5b46b46d84c328c94f5194d1e24d889e8803401a6834d0c8c9a681a3401a9e8402136a329ea8340d001ea3200d320000c4070d34c10c869a6464c201a680309a34c980040d049a8892629a653c49ea7935323f527a9ea7a83d47a868031000681ea08942048f53d29a353d36a1a13da48d3219180689fa5310c81a0122426404c822a7e1a694f54fd53da936a1e518d4311900d34d1a6f547db385eeedf8fb3e2aeb7e67707821ddae1cc82c112e250ca88b098b9c302f241c148b04448a2c5488915102b19978c62cb46228884a430260c148a2145b236d32cb454498b282c560a2c24c2483fafa380f487fb8abe5c8d19a1338ea85a4fbd5270577cfc3d34359db4373944c5132887c622e112b1594a7ef97fbe7ddcdc75161c8eb34567da934416dcacd5b3169b22ce92ab7f44deb2cc94a557da68631d4560952200f6265b0c244c4d1baef1ca95f56e227be45f6b6c6fdd59dafe9c2f1f80c5d22803956cf6750734e9b9481e24006f5f68c2fc31816945520010322638ebcfac21281acb3144a9215dc2ce2692967aa90dc04316d43b7768f1fbc70353402ed39a6a33c360aa2df7984e88a479a0020a497c827bbcb4b6ad6d9a702b92f2aa31609d1273d0081df78806435496527d511ddbf84113d7afc60b7d5965db1b17e0923708f9da45001f41fe5d41408dec6cda52dc89152b068a304b44f3546bd951cce4100859bb4024188815c80a992ee030316d919af26f710306f70db62a0b46972aa34e36b39928d0eb9c82818c44ae0695e92bc197938b9560bc62ad7feb289e69b49ca776f487231564555ef1d944b4508f641bea76609df0ed399b5bc8949c2421002d9ea5f9dfce858879d83e7256c923e6f7fc9acd8650149d626a3a55b129d1ad2bccdc6a62a7030d5d24a21e248df3a63bcce6b10ec966b65aa0725a11374345f898a81686a5e8afa7c842a9aa8b3deea3d92221c97133362e58ef28a65e50c05b17b3241f984aad6fe9e70f847147398f82ceaed5c751a140aa0a6f61734a6496211055106093588081136b41982cdcac050484dc3b3063188288ad6496d32eeac3176bb66df877f4f0f1fcbb7af15b9fba9a7058efe273bf29d7a49744cd4a82b5457205ce436e8297444b7b6e75678b890492e550965b28ba3066a15246b9a3d4d28d422318a26a28c11b383faad96dac0ba9d2f78877f18e2acadf46d3ddf1f473dcf2b3a7d141f2317db60b2134e29b89e5e3980e01f1c682d6ba0aa92736364f115ca9addde5983e53a543db4889c589475d69309d86c844e914941ed3df7fb8e38b00f86e692ffb75e75661845d59498dd898c7e8c90e34d34099de996375301632971ce7ea19535e0f0f541fae4d2ba5b64ce090e56bfeb122bb24ef74046c967572c2ec6c793e72caeb6c5b86006ba59f47e97a3864429838697c9f846010ca4d7b9eec70b72495e7db8ac4fa8029277c9368decd5729e56b11a6460370f6389206d2c77c7a04cc28ad69e10eb991b8f1e89bc10dc4fc575fd8e4a5c6455977cc2d148d5621a2b2053b12585db958aacd01f35df87ab984cc6dae024b07431a56310a401614c0909fd27c05d622963df07daf399eabe092099d69ad3bf0e3cfbbd892ad060c1345844030bcee2c9145fd8d020a10ce5213ac259b987f50188803d5255bf12cda18dd21101125a31b706c2ef239e37dac41bad0fb1e89cf76e2691241f49d7fe48253ada0556d9f68b024926de6f78bb49e68461d589ebad525c379c99807613ec245ccfc2d5d14758a71690edf3f253bbdebf902d14dd02ee3dc5e365395aa8d06614c593efacae6d902f3b401fc9a4b3430c703ec3114b166581170d544d59161b1b6f87bb21612af3591bcdf71579b5933409a4fa6d30a9c230990dc8908204d46b2d5dd60988ba604cbf967901f5fcf81c93d4a38c7f7ebd86808fd219fc7fe07f1fa1f70a17dc3f2300ee5dc2c40a073d3d38c8f609b4bd18598b7972274e4622bc3a98da11a62b448188e234ae24256ed11dd9812d17b3d209a054a1095296bb606cbb310c8a9f2f96df796aa9782037cdfb1d63a673bdc33a65f555db29679cd92fef28fbf1d83c62cde3215de6f32e982cc560e3e1a25ed40b0582418a501ac61b680a7f2042e6ba846e2db9c8f1e7824b79cb26b115b71e0628c43a108f038e470ebd9276a6402c43b2cda6911441f0710d90e637b7333aa852b5297b6e20a2dc5edbdeb8aa6cc741d54c16b2249750a4f3c033a1704a921ac8adefe7c8f13cb1d79305e1e54fa37f1c27c2a30fe705f83628e3a01e65011ce6143185a3c05a544330d9d791e5a976a80bc2f89b47e35cfe531f616bcbee1759a069cee0028df9deceb4db4f91b97a8aa0ad9127b03780bb96302a14811212e0d6b9fccc4ed297988c09081752882599a9bc01825dd64c85a0909614c20940820386272bd680f8c28200d7a767d8c11bb3b8e96381395db062ba77304c54ae1a482f636c1bedab151aaf760500d7a933c2dc0a193a8baf7211432c9217202636234d4458f158cccf2f89f2bc09ee4f5c81a779e2732112a02bd49763b666ab9cbb4a0ba92a4f84faa88156a1cfc4241b4fde7b9fb9fbdfc1c0e5f03ea52089391f44c96ba55721b1e953d6a14f126fb242e00d1452ac0c81a035bd5215055ba0487d1a765d475d987798f8637dc0861630c031b29cdbcd16e0da2531cf2c3011b8ba45ac7635255876c79047c45e19d2e01648be6ef0962107396232d144b2880474a379a615fa342926a6ab78b031124d974b43c602b933cb946d4460cc4c751e332770fcf8c68c3ef40c6262ba0812ba565934d3618e3b0d4a9964d09a9154e469a4b6f128862c23a0701b648750dabc2165700c8d10706a132c9a026541b3634b80de86da51b251882b0f319e725dac649a48b0e49652ae662fb600dcc5a6e91cb807e44885933d4bc446c13921de1784c9700ddb84628c898bbf93ffdc4bec90d8a750facdb6de29a5c2aaf34ea9a948e948d808666c28da4da6370c2ad8d77ebba63d5d8a678845a1422c8b2038027e8bc9d4d2930a72da58abd7b9962840a80547467a3a38ce244b805e4228b001427fe2ee48a70a121c57cbe58, 'New account has been created ', 0, NULL, '2021-02-12 14:11:16', '2021-02-12 14:11:16', 'MailMessage'), (3, 'barnet@digilabs.cz', 0x425a68343141592653599ea128730003e45f8010207b77fffffff7df2abffffffa600a3c1edf78daf688bebdb76f3d7de6f980e9db1d120a0a0a8649929e932653c14f14f54fd141e89a003d4347a8647a4fd534d0fd51ea340d4f534269a68991935001a0034000000006806a9ed11a8d5069a1a0321a034c401a61001a01a0d024d4489a8d4fd46a9b694d947921a6d43d41ea3400189a003469b50452891b26a68d01ea3469a01a0680000d0000009122310048c9323d3446a690d0c0ca1a6478a0680d36a3f09b9edf17cbd9f2575bf4be00e5876f0439d058225c4a19511613173740bc8838291608891458a91122a205632978c62cb46228884a430260c148a2145b236d32cb454498b282c560a2c24c2483fbf978cf387fd8abef64346542658f761693cca938eb88fcbcf432c5b42f33c24c893c21e908b561258562493da7fde3bda34ca389eafbf0aa1a69df1ea7b2577cf324f92d8ceec16f5d96ae6b1a1a5c111f4e0816d1007ad32b861226268d7c329dff16e227c2456986e70d693adba75586d02953cac052254d62a0314b0bf071e8580304f548e9e8a5c58f9116e008159325376ccf0e7b8ccfb0417312115ccc51307becb9075f0430b2e0d48dad1f34d066300236e29505945e132d279cba582d08e1700b107a6f8972bee1a99cebe28d9ebb19951a3b956e3ea040f8ec201a4ca4a6684a28f453ce089edcba415fbb2cbb6372d8248d447d8d22e007de3f4ec0a047063add1677e7565a83857eedb85d6e774133bd3ca23122726009067207090197a73e41036aa56b3c0bc65082f18aa4c89c4c9cbb21c5bf4d1cc9468764e417063112bc1a5649581962717aa41618a94f4d944f1cda4ef1dba486f62ac8aabdc3b28968a11ec84cece84875874cd4f0ccc614f74444031af0c9e8cfaa060879183e42570c91f1fc3edf098405258991e157ac4a736ea5ea1bb8b2692344d23f41f3dec92bdfb99de3c53f55c332264a6b540f61c9f335562c6ca42d8fc8918a2bf2e64299f05157bba0f75c062949cd5e4d5b65d854a178b43e62d92cc62f5895cd7578f553d238a3a0c7659ef78971ce66502a829a6172a53225881045544581a15c0209e168b305a265602427144c3762c8ee10d5b5912da65dd5862ed76cdbc9ae7ecf37cfb7af15ccfe34d382c75c2b036b966c85c6432a1405265a29612c78c36884640fcec364cc68892092932a834d69a8c978b349151066d060a92934903bb93490b02d5230dac6fdb5817639de8438b18eed64b7d1b4f7fd5f5f9ee7d0ceaf2d07ccc5f7183690afe0bc45ecea530d47d13809371e822125db3c17791d8cb257af940254683816a04b19c29d178300d38440660d030522d0e3a5c42be8da3f2eeaabdbf7e6c9939e41e76b09a1fd0890dfd326e59942e505c687c40350579497f00ae3a66787ab865fbb64b68ab3a4cecdbda5fb410495447e79842875064ae88d351faf17d71aaf2445005d854d836d9d6a159085ca16cef6d12382cbdec94c1fba477ca9e1bb5cfc577000c49f092749d9d52e278dc8ae34a1110c4621755aaa869978a86b8f5893848acb25d0b24e6f584a020ec23812dfe65548bcc4a32ff60b3523658866aa814ea49617e8aa516680d7d94fc7e2ee09995b7c44962ee32ba91905d0054530242788e606e043c443d2e1d692b0ec3b492030b8a19b4c75eaed729260f0804230d085021c0741a48652cd428a2937d91ce89dc701fa8090a03d324d9a709a2c1172a85055cd515a3617a08e78dab520d2b0fccf44e7aea4d22483f79cbcc7f427756d02ab6cfc058924936f47d42ee27a211872c4f8ef44975f51c99807693ed245ecfc672d5216c247c9ab3a7abcf1e3f85fda13691ef617767bcbc5348f0f03d0417246c332a66c9f3b4af6d902f2ac01f0692c0d51019e27bcc852c999e245e35413554546c6dbe3f4662c254e8b23acb8bde4d62ccc2693f1de61c4e3184c86e44841026a3696cefa84c45f30267667901eef6d8e49e7b17b963f6dde733045d0afe26b6d8c3ea4550c9691980a81668b98729a8310b72026816a5e89ddc0c4560ea636847c98ad12062380d2bc90957cc239e604b45ebf9609a0575c42575d5bf706cbf310c8a1f5f86f908a0570200d03430ac6e4d675095d9f914f791cc758bd3371920e315e0d22c504e2e6188605bacd719831b370576106b3594285902c4986fa029fe7085cd7211a95d5c8f0e7824b81c726b115753bcc518874211de75e46d6c12fa997004861fae4625e98d8c38f01c08ed2be96aec2089488bd4f88425717a9ff34aa923baba8b08a252582e5453f5206b4640d8a6e192673cdcf39677d9bb82245c3bd1cb2ad27d54187c20b60d8a3af403c8b811ce61718c2d1e02d2821986ee9c4f4ec5fb202c1689b47e54cfeb31f595b16bc5d8681a73bc00833595d66630fd4e4a542202304c5e0394c25256302a148304720dd26be8343a643334220a219e777021944ab02c977591b02d0484b0a6104a060c0736272b2d01f5c28200dba76fb98235cef3a54ea272bf60c574f3b04552254d5b12f3f9315f3c2a90a4978b08036c119d27a24193a0bb35422e32c9217102636234d8454f058cccf2f17c6c04f54f6c81a763c0e64225702b292ed75ccd973977170b92574faa7cae40a940e7e0120de7ed3ec7f3bfa1fb1c0e5ed3f629055b67df825ae755bce17a94e6a14efa6ac90b8034514db682e03406b82ba15c2a5f0243e8d3aae4765587a0c7bf1b5e086132940acd23d58a84a978790894b3b528215c5c04bba13243930ee8f48478960ceebc05922d3760962107396232b1725944023a5cde69853edd0ba4d4d52c2c0c449365f2d0f080a64cf4f18dee460cc4c761e332778fcbae3461fe903189933a28933bb2c99e7c26392c362a64c9993622a9bda6924e535022a98c350d0f26d9b9e497009a4a8163540a8a40ed650099406cdcd2f03821b6946e94620aa3cc679497731926922a392594a9998bee803562d3591c7a83cc910b267c4b088dc27243b058264ba835d44628c898bd1c5ffeeb2d5486c53a07f137df80a695eaa67cbad4a474ba3702199b0b9b22c454d97306ecf764e9c9eb486ba032514322c8a0a808fea976efac3a477cdcc92f35c9cc818480242d53fdbf7761c610c809379145800a13ff1772453850909ea128730, 'New account has been created ', 0, NULL, '2021-02-12 14:11:16', '2021-02-12 14:11:16', 'MailMessage'), (4, 'homolova@digilabs.cz', 0x425a683431415926535957512db80003e05f8010207b77fffffff7df2abffffffa600a3c0be3b6bb5052b69cb83a00686890505040c8240827a69aa7e46a6d486c827a83d27a08f51806a611ea3401a9929e4d32654dea647a906800c8c801a1a000032641c34d304321a69919308069a00c268d326001034126a244269a65279aa7ea650fd51e9001b51a06803d4d001a0f2870d34c10c869a6464c201a680309a34c980040d048901010091931a134d46932626348d3d46c9034346351f6cdcf7f93e3ecf8abdd7e77c41be1dfaa1d282c112e250ca88b098b9ba05e441c148b04448a2c5488915102b194bc63165a3114442521813060a4510a2d91b69965a2a24c594162b05161261241fdbb769e70ffb157c321a32a132c7b70b49e6549b6b98fc7cf44b7d581db3530d3086a607eec24d0c2d92355fceaeef2f6fafc2c638342cc9863b68f39b720e94d93df49f6354ebfd15f8d55b4553c76a844864c21a58803c932f8e3226268d9dd9cebf06e227be45ed8ee37ecb4ef873e1814d47b55dc814a5ba93589fa618f46357ed803c34dd6ae9aedab9ded28a830e2ddb6efe5de56f5795f918c64d925f74d378defcb6635e819373d87c59c943f2bc09c4d02897ece916614871a5ef25ced3490e658061ac4f209f4b23771d56c92678369776479b133623c6081cfa48068378948a3bc307161e8044f6f47382fedcf3e98dc618a48d823eb6914007da3f0da0a046f62d776adf9d9db085193e7aadc75cab1a4b04f78985c4deb4120ce40f4101dbb73e71035aa56c9e25da5082ed154991399937e88737469d2e64a353cd3905032889541a5824b006604e2aad060315addd6513ee9ac9c0efd321d0c559155794eca25a2847b20ab23ad88f58762d0f52a8d10f78c63009e98a5fa57d482623ef687f78a31493fe7ebf4d4f5991560362f21973c9b74190ece512f154324d246c4d23e7da64412557ee6b24fd33199932535b503a0e5f2c6ab7262d49f70cc115f8b990b53dea307c1d8744110e4a84f70cbb392fd4a0abaacc62f212dcd6eeff543ec1ce0eb31d967b9e45c70332815414d385ca94c8962267766782309582088fdb3ace64b05298625cc11e559bb587112714149c352944827293792cb5d2bcb8fd797ae71dcfdf0e1cc90f49aefa71c32f44676755b637aeae517bf49e3e07272e834f578f7ebc6472a8ab2ecaf05f82cced59cf1726cdf84524f1c678b2d6b446c713227cab4ee9f1ca263767134808beef42c111b6ee0cf4ede363ca872f5a81c685133210884831507ac9f373cc06d1e31a0b5af4caa9274e392712b826a7afaf603bf194607b60aaeb2065ae38380f20440a43c160ca338e29740a7a750fc2f7d1f2f2e6d8e9d170687a89c10e9448fcfb6e7635f60db236d7821200f80b70130da14cd441414931f78e4e94699ca06bc959fed310752c476ac4d138a1d5428af12c7e8caa88d29a0400b0d8a9aa93cd02a20925a049ec54265832632b3d132bb9c7e362ce2cb3e3c5b403927849369d3df7b59f82a329a108e51a87586ce744073894941f1953e617f211b8212528fa03acc8fab7a31067b87f625c3e65748a9916657d82d148d8b20d15d029dc92c6baab965a203d95fcfe0e61332bedc44962e8654b46414802e2981213fb0fde2ea1149173ea91f8bd267c15524133a135a76e3c39f4fc692b5060c1345c44030c0ea2e914599a0414219c242768168e61fd0048501dd24d1ab59a5608b954282ae7322b46b27515e8cb0bdc835bc3f33d539ecd84d22483da7432255b40aadb3fc8b024926de6f70bf13a4a688465cb33e1b6c92e1bce4cc43ce4fce48ab3f39cb6a42dc246dd8cecf0e98e7fe2bd213691e4c29e6f79514d23b7119348d46655a327d76955b640bc2f007e0d25a2186589ef3e43314f366991162842b89ac1180d8db7c7e8d0594addab038142af36b26681349f76e987138c63321b91210409a8db2daeb70988acc099d1a6607bbd981d09ed28e31fbb6751a023e50d3a4f8bfd9fe850be71f498035e716004c3d19f96f91ea13697930bb16d2a89d38190b00e2c6d08f1c96a90311c069549095fa4476e804b55eaf2826815284254a5ebb81b2ba086458faa5dfbbf22ee5ad200ba2eb8a4762663e917965df639515ce616245bc483ae4b01ac14f23012eb3799f3c5682b871edd52f9102c56290649406d8c776a0a7eb085d8ba046c2fb1c8eeecc525bce59b590afb0ed324641cc84769c7336e18a5f4b28012187cd2322a98d8c396f1c08e92fe0d5318225222aa7c8212a1553fea95d24755f60b18b2526d0b9514f9503651903629b86499cf374cdf38b376a8927a1c51d19ded3e16187e10618b628e3a81e25108ec9850ca16af116b610cc773b723c3695da80c03089b47eb6d3f7197917c0c2a2f31a86b5ecb00123459d6acca1fa5c94ac44046298bb872984a4a4302a148304720dd26cff4d27a92199a4882886555021889560592eeb0680b41212c2984128106039b13960b507c6141006de7d3ee608d9a54e7738139577064b9fa18233c1227e386d6c4bae4c569e58242925dec200c7146969ea9066ec2f36c4228679a42e404c6c46bb445cee59654348ef7cb0027b13db9834f03b8ec2112a02c14974bbe86d5d92ea282e84a93e13e8a2056b07677048374fda7b1fcefe97f6b81cbed3daa4156d9f2e096b9d5741c8fb2a7868538a6c6485c01a28a6db41403506b7aa42a0ad58121f369dd741e6bb0eb32edcb0a82184cb582f348f4e4a12a078888be985ac2150a0126ba8936e4c3aa3c023bcc034a54059a309bc0259041d92c865e289671008e746f44c2df76a524d4d5b016390d824d9596a77405b3678728dd4462cc8cb68f2993a8fc78c6ac3f240c6264ce8a24ceecb2679f218e7b0d0a9932664d08aa7434d324e535022e98d6c0d4f16d9b8f14b784d2560c0d88159481e182804cb0366e35a81bd0db4a37251902b8f419e325d4c649a48b8e49672b6864faa00d8c5aec91cb8079d22166cf818088dc13921e01804c9700d9b04648cc98baf93ffdc4c2e90d8a760fbcddbb78a62ab6ae69d1c54a473a46e0219a30c964588a9a2e60dd9eec9d3cfd521b34832514322c8a134043f493a7c1b69d15c70e0b9e1ca382842c02c9b63f47d9c0df0864049d0451600284ffc5dc914e142415d44b6e0, 'New account has been created ', 0, NULL, '2021-02-12 14:11:16', '2021-02-12 14:11:16', 'MailMessage'); -- -------------------------------------------------------- -- -- Struktura tabulky `metadata` -- CREATE TABLE `metadata` ( `id` int(11) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `metadata_translation` -- CREATE TABLE `metadata_translation` ( `id` int(11) NOT NULL, `translatable` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `keywords` text COLLATE utf8mb4_unicode_ci NOT NULL, `robots` enum('all','follow, index','nofollow, index','follow, noindex','nofollow, noindex') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all', `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `module` -- CREATE TABLE `module` ( `id` int(11) NOT NULL, `language` int(11) DEFAULT NULL, `image` int(11) DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ordering` int(11) NOT NULL, `published` tinyint(1) NOT NULL, `locked_config` tinyint(1) NOT NULL, `all_user_groups` tinyint(1) NOT NULL, `for_all_languages` tinyint(1) NOT NULL, `for_all_routes` tinyint(1) NOT NULL, `template` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `routes` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:simple_array)', `config` json NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `discr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `module` -- INSERT INTO `module` (`id`, `language`, `image`, `title`, `position`, `ordering`, `published`, `locked_config`, `all_user_groups`, `for_all_languages`, `for_all_routes`, `template`, `routes`, `config`, `created_at`, `updated_at`, `discr`) VALUES (1, 1, NULL, 'Hlavní menu - desktop', 'header', 1, 1, 0, 1, 1, 1, 'header-desktop', NULL, '{\"menu\": 1}', '2021-02-12 14:39:24', '2021-02-12 15:08:00', 'ModuleMenu'), (2, 1, NULL, 'Hlavní menu - mobile', 'header', 2, 1, 0, 1, 1, 1, 'header-mobile', NULL, '{\"menu\": 1}', '2021-02-12 15:08:04', '2021-02-12 15:08:20', 'ModuleMenu'), (3, 1, NULL, 'Homepage - úvod', 'homepage', 3, 1, 0, 1, 1, 1, 'homepage--intro', NULL, '{\"schema\": 1}', '2021-02-16 15:48:10', '2021-02-16 15:50:47', 'ModuleSchema'), (4, 1, NULL, 'Homepage - obsah', 'homepage', 4, 1, 0, 1, 1, 1, 'hompage--content', NULL, '{\"schema\": 2}', '2021-02-16 16:25:54', '2021-02-16 16:26:02', 'ModuleSchema'), (5, 1, NULL, 'Homepage - články', 'homepage', 5, 1, 0, 1, 1, 1, 'homepage', NULL, '{\"limit\": \"12\", \"category\": 1, \"renderBlankModule\": 0}', '2021-02-16 16:44:30', '2021-02-16 17:01:13', 'ModuleArticleCategory'), (6, 1, NULL, 'Homepage - obsah2', 'homepage', 6, 1, 0, 1, 1, 1, 'hompage--content', NULL, '{\"schema\": 3}', '2021-02-16 17:08:24', '2021-02-16 17:08:32', 'ModuleSchema'), (7, 1, NULL, 'Ostatní informace', 'footer', 7, 1, 0, 1, 1, 1, 'footer', NULL, '{\"menu\": 2}', '2021-02-16 17:16:29', '2021-02-16 17:28:13', 'ModuleMenu'), (8, 1, NULL, 'Detail článku - nejnovější články', 'article_sidebar', 8, 1, 0, 1, 1, 1, 'article--sidebar', NULL, '{\"limit\": \"4\", \"category\": 1, \"renderBlankModule\": 0}', '2021-02-17 09:55:39', '2021-02-17 10:00:18', 'ModuleArticleCategory'); -- -------------------------------------------------------- -- -- Struktura tabulky `module_user_group` -- CREATE TABLE `module_user_group` ( `module` int(11) NOT NULL, `user_group` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `notification` -- CREATE TABLE `notification` ( `id` int(11) NOT NULL, `user` int(11) DEFAULT NULL, `image` int(11) DEFAULT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `route` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `route_params` json NOT NULL, `hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `seen` tinyint(1) NOT NULL, `sent` tinyint(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `page` -- CREATE TABLE `page` ( `id` int(11) NOT NULL, `metadata` int(11) DEFAULT NULL, `image` int(11) DEFAULT NULL, `language` int(11) DEFAULT NULL, `article` int(11) DEFAULT NULL, `article_category` int(11) DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `published` tinyint(1) NOT NULL, `automatic` tinyint(1) NOT NULL, `for_all_user_groups` tinyint(1) NOT NULL, `template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `config` json NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `discr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `schema` int(11) DEFAULT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `page` -- INSERT INTO `page` (`id`, `metadata`, `image`, `language`, `article`, `article_category`, `title`, `alias`, `published`, `automatic`, `for_all_user_groups`, `template`, `config`, `created_at`, `updated_at`, `discr`, `schema`, `url`) VALUES (1, NULL, NULL, 1, NULL, NULL, 'Úvodní stránka', 'uvodni-stranka', 1, 0, 1, NULL, '[]', '2021-02-12 14:06:10', '2021-02-12 14:06:10', 'PageHomepage', NULL, NULL), (2, NULL, NULL, 1, NULL, 1, 'Články', 'clanky', 1, 1, 1, NULL, '[]', '2021-02-16 16:40:59', '2021-02-16 16:40:59', 'PageArticleCategory', NULL, NULL), (4, NULL, NULL, 1, NULL, NULL, 'O mně', 'f554ba00ced6772826a0ee9795645f70', 1, 0, 1, NULL, '[]', '2021-02-17 10:49:44', '2021-02-17 10:49:44', 'PageUrl', NULL, '/#o-mne'), (5, NULL, NULL, 1, NULL, NULL, 'Značka', 'dae1040f6f3f70da8e8fb52930d20ec2', 1, 0, 1, NULL, '[]', '2021-02-17 10:54:17', '2021-02-17 10:54:17', 'PageUrl', NULL, '/#znacka'), (6, NULL, NULL, 1, 5, NULL, 'GPDR', 'gpdr', 1, 0, 1, 'legacy', '[]', '2021-02-17 11:04:13', '2021-02-17 11:04:28', 'PageArticleAlias', NULL, NULL); -- -------------------------------------------------------- -- -- Struktura tabulky `page_parameter` -- CREATE TABLE `page_parameter` ( `id` int(11) NOT NULL, `page_id` int(11) NOT NULL, `parameter_id` int(11) NOT NULL, `image` int(11) DEFAULT NULL, `bool_value` tinyint(1) DEFAULT NULL, `number_value` decimal(14,4) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `page_parameter_parameter_option` -- CREATE TABLE `page_parameter_parameter_option` ( `page_parameter_id` int(11) NOT NULL, `parameter_option_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `page_parameter_translation` -- CREATE TABLE `page_parameter_translation` ( `id` int(11) NOT NULL, `translatable` int(11) NOT NULL, `string_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `page_user_group` -- CREATE TABLE `page_user_group` ( `page_id` int(11) NOT NULL, `user_group_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `parameter` -- CREATE TABLE `parameter` ( `id` int(11) NOT NULL, `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ext_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `families` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:simple_array)', `public` tinyint(1) NOT NULL, `significant` tinyint(1) NOT NULL, `ordering` int(11) NOT NULL, `config` json NOT NULL, `discr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `is_color` tinyint(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `parameter_option` -- CREATE TABLE `parameter_option` ( `id` int(11) NOT NULL, `parameter` int(11) DEFAULT NULL, `position` int(11) DEFAULT NULL, `ext_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attr1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `parameter_option_translation` -- CREATE TABLE `parameter_option_translation` ( `id` int(11) NOT NULL, `translatable` int(11) NOT NULL, `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `parameter_translation` -- CREATE TABLE `parameter_translation` ( `id` int(11) NOT NULL, `translatable` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `prefix` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `suffix` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `redirection` -- CREATE TABLE `redirection` ( `id` int(11) NOT NULL, `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `target` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `published` tinyint(1) NOT NULL, `regular` tinyint(1) NOT NULL, `replacement` tinyint(1) NOT NULL, `permanent` tinyint(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `schema` -- CREATE TABLE `schema` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `published` tinyint(1) NOT NULL, `lockable` tinyint(1) NOT NULL, `locked` tinyint(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `schema` -- INSERT INTO `schema` (`id`, `title`, `published`, `lockable`, `locked`, `created_at`, `updated_at`) VALUES (1, 'Homepage - úvod', 1, 0, 0, '2021-02-12 15:15:56', '2021-02-17 08:50:04'), (2, 'O mně', 1, 0, 0, '2021-02-16 16:22:59', '2021-02-17 10:52:13'), (3, 'Značka', 1, 0, 0, '2021-02-16 17:07:42', '2021-02-17 10:54:50'); -- -------------------------------------------------------- -- -- Struktura tabulky `schema_block` -- CREATE TABLE `schema_block` ( `id` int(11) NOT NULL, `parent` int(11) DEFAULT NULL, `image` int(11) DEFAULT NULL, `ordering` int(11) NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `classes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `config` json NOT NULL, `published` tinyint(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `schema` int(11) DEFAULT NULL, `discr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci, `href` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `custom_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `schema_block` -- INSERT INTO `schema_block` (`id`, `parent`, `image`, `ordering`, `alias`, `classes`, `config`, `published`, `created_at`, `updated_at`, `schema`, `discr`, `content`, `href`, `custom_type`) VALUES (1, NULL, NULL, 0, '', '', '[]', 1, '2021-02-16 15:24:16', '2021-02-16 15:24:16', 1, 'SchemaBlockHeading', 'Alexandra Mynářová', NULL, NULL), (2, NULL, NULL, 2, '', '', '[]', 1, '2021-02-16 15:24:16', '2021-02-16 15:24:16', 1, 'SchemaBlockLink', 'Zjistit více', '', NULL), (3, NULL, NULL, 1, '', '', '[]', 1, '2021-02-16 15:24:16', '2021-02-16 15:24:16', 1, 'SchemaBlockEditor', 'adasdadasd
', NULL, NULL), (4, NULL, 4, 3, '', '', '[]', 1, '2021-02-16 15:24:35', '2021-02-16 15:24:35', 1, 'SchemaBlockImage', NULL, NULL, NULL), (5, NULL, 5, 4, '', '', '[]', 1, '2021-02-16 16:05:16', '2021-02-16 16:05:16', 1, 'SchemaBlockImage', NULL, NULL, NULL), (6, NULL, NULL, 0, '', '', '[]', 1, '2021-02-16 16:24:31', '2021-02-16 16:24:31', 2, 'SchemaBlockGroup', NULL, NULL, NULL), (7, NULL, NULL, 3, '', '', '[]', 1, '2021-02-16 16:24:31', '2021-02-16 16:24:31', 2, 'SchemaBlockGroup', NULL, NULL, NULL), (8, 6, 6, 2, '', '', '[]', 1, '2021-02-16 16:24:31', '2021-02-16 16:24:31', 2, 'SchemaBlockImage', NULL, NULL, NULL), (9, 7, 7, 5, '', '', '[]', 1, '2021-02-16 16:24:31', '2021-02-16 16:24:31', 2, 'SchemaBlockImage', NULL, NULL, NULL), (10, 6, NULL, 1, '', '', '[]', 1, '2021-02-16 16:24:31', '2021-02-16 16:24:31', 2, 'SchemaBlockEditor', '
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
', NULL, NULL), (11, 7, NULL, 4, '', '', '[]', 1, '2021-02-16 16:24:31', '2021-02-16 16:24:31', 2, 'SchemaBlockEditor', '
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
', NULL, NULL), (12, 14, NULL, 1, '', '', '[]', 1, '2021-02-16 17:07:42', '2021-02-16 17:07:42', 3, 'SchemaBlockEditor', '
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
', NULL, NULL), (13, 15, NULL, 4, '', '', '[]', 1, '2021-02-16 17:07:42', '2021-02-16 17:07:42', 3, 'SchemaBlockEditor', '
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd asdasdasdasd
', NULL, NULL), (14, NULL, NULL, 0, '', '', '[]', 1, '2021-02-16 17:07:42', '2021-02-16 17:07:42', 3, 'SchemaBlockGroup', NULL, NULL, NULL), (15, NULL, NULL, 3, '', '', '[]', 1, '2021-02-16 17:07:42', '2021-02-16 17:07:42', 3, 'SchemaBlockGroup', NULL, NULL, NULL), (16, 14, 11, 2, '', '', '[]', 1, '2021-02-16 17:07:42', '2021-02-16 17:07:42', 3, 'SchemaBlockImage', NULL, NULL, NULL), (17, 15, 12, 5, '', '', '[]', 1, '2021-02-16 17:07:42', '2021-02-16 17:07:42', 3, 'SchemaBlockImage', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Struktura tabulky `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `billing_address` int(11) DEFAULT NULL, `user_group` int(11) DEFAULT NULL, `image` int(11) DEFAULT NULL, `language` int(11) DEFAULT NULL, `transport_address` int(11) DEFAULT NULL, `email` varchar(96) COLLATE utf8mb4_unicode_ci NOT NULL, `password_hash` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `first_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(96) COLLATE utf8mb4_unicode_ci NOT NULL, `note` text COLLATE utf8mb4_unicode_ci NOT NULL, `active_at` datetime DEFAULT NULL, `logged_in` tinyint(1) NOT NULL, `blocked` tinyint(1) NOT NULL, `role` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, `admin_language` enum('','en','cs','sk') COLLATE utf8mb4_unicode_ci DEFAULT '', `data` json DEFAULT NULL, `notify` tinyint(1) NOT NULL, `reset_token` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `birthdate` date DEFAULT NULL, `config` json NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `user` -- INSERT INTO `user` (`id`, `billing_address`, `user_group`, `image`, `language`, `transport_address`, `email`, `password_hash`, `first_name`, `last_name`, `note`, `active_at`, `logged_in`, `blocked`, `role`, `admin_language`, `data`, `notify`, `reset_token`, `created_at`, `updated_at`, `birthdate`, `config`) VALUES (1, NULL, NULL, 1, NULL, NULL, 'hladik@digilabs.cz', '$2y$10$.DGhGNm8QtYRYeqbhdr9OuYbtDgALUmJN0q0kfdODJWBsIJxvndDa', 'Petr', 'Hladík', '', NULL, 0, 0, 'Root', '', '[]', 1, 'c91e34d49c777e6a5815b61a42a6a2f0', '2021-02-12 14:11:13', '2021-02-12 14:11:13', NULL, 'null'), (2, NULL, NULL, 2, NULL, NULL, 'cervenka@digilabs.cz', '$2y$10$7K3MlxNrJEvYvyPxT/AXkuaqyzcyYOJR9Y6ZQkjVhbnIQZkWvzb7O', 'Ondřej', 'Červenka', '', '2021-02-17 11:13:32', 0, 0, 'Root', '', '[]', 0, '572d83b04af891388f680f1c45d77413', '2021-02-12 14:11:14', '2021-02-12 14:11:14', NULL, 'null'); -- -------------------------------------------------------- -- -- Struktura tabulky `user_group` -- CREATE TABLE `user_group` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `main_public` tinyint(1) NOT NULL, `main_registered` tinyint(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Vypisuji data pro tabulku `user_group` -- INSERT INTO `user_group` (`id`, `title`, `main_public`, `main_registered`, `created_at`, `updated_at`) VALUES (1, 'Výchozí skupina', 1, 1, '2021-02-12 14:06:10', '2021-02-12 14:06:10'); -- -- Klíče pro exportované tabulky -- -- -- Klíče pro tabulku `address` -- ALTER TABLE `address` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `article` -- ALTER TABLE `article` ADD PRIMARY KEY (`id`), ADD KEY `IDX_23A0E664F143414` (`metadata`); -- -- Klíče pro tabulku `article_category` -- ALTER TABLE `article_category` ADD PRIMARY KEY (`id`), ADD KEY `IDX_53A4EDAA3D8E604F` (`parent`), ADD KEY `IDX_53A4EDAA4F143414` (`metadata`); -- -- Klíče pro tabulku `article_category_assignment` -- ALTER TABLE `article_category_assignment` ADD PRIMARY KEY (`id`), ADD KEY `IDX_E0A1F70A23A0E66` (`article`), ADD KEY `IDX_E0A1F70A64C19C1` (`category`); -- -- Klíče pro tabulku `article_category_image` -- ALTER TABLE `article_category_image` ADD PRIMARY KEY (`id`), ADD KEY `IDX_8B35C79E53A4EDAA` (`article_category`), ADD KEY `IDX_8B35C79EC53D045F` (`image`); -- -- Klíče pro tabulku `article_category_translation` -- ALTER TABLE `article_category_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_translation` (`translatable`,`locale`), ADD KEY `IDX_7FD89250CD39B6E8` (`translatable`); -- -- Klíče pro tabulku `article_category_user_group` -- ALTER TABLE `article_category_user_group` ADD PRIMARY KEY (`article_category`,`user_group`), ADD KEY `IDX_5F660C2D53A4EDAA` (`article_category`), ADD KEY `IDX_5F660C2D8F02BF9D` (`user_group`); -- -- Klíče pro tabulku `article_file` -- ALTER TABLE `article_file` ADD PRIMARY KEY (`id`), ADD KEY `IDX_3CDDB11123A0E66` (`article`), ADD KEY `IDX_3CDDB1118C9F3610` (`file`); -- -- Klíče pro tabulku `article_image` -- ALTER TABLE `article_image` ADD PRIMARY KEY (`id`), ADD KEY `IDX_B28A764E23A0E66` (`article`), ADD KEY `IDX_B28A764EC53D045F` (`image`); -- -- Klíče pro tabulku `article_parameter` -- ALTER TABLE `article_parameter` ADD PRIMARY KEY (`id`), ADD KEY `IDX_F0A2C1347294869C` (`article_id`), ADD KEY `IDX_F0A2C1347C56DBD6` (`parameter_id`), ADD KEY `IDX_F0A2C134C53D045F` (`image`); -- -- Klíče pro tabulku `article_parameter_parameter_option` -- ALTER TABLE `article_parameter_parameter_option` ADD PRIMARY KEY (`article_parameter_id`,`parameter_option_id`), ADD KEY `IDX_86F05A31AF1AAC47` (`article_parameter_id`), ADD KEY `IDX_86F05A315E90B0DD` (`parameter_option_id`); -- -- Klíče pro tabulku `article_parameter_translation` -- ALTER TABLE `article_parameter_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_translation` (`translatable`,`locale`), ADD KEY `IDX_A687102CCD39B6E8` (`translatable`); -- -- Klíče pro tabulku `article_translation` -- ALTER TABLE `article_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `translation` (`translatable`,`locale`), ADD KEY `IDX_2EEA2F08CD39B6E8` (`translatable`); -- -- Klíče pro tabulku `file` -- ALTER TABLE `file` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `file_translation` -- ALTER TABLE `file_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `translation` (`translatable`,`locale`), ADD KEY `IDX_96D2BB0DCD39B6E8` (`translatable`); -- -- Klíče pro tabulku `image` -- ALTER TABLE `image` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `image_translation` -- ALTER TABLE `image_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `translation` (`translatable`,`locale`), ADD KEY `IDX_7BBF0EE1CD39B6E8` (`translatable`); -- -- Klíče pro tabulku `language` -- ALTER TABLE `language` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `locale` (`locale`); -- -- Klíče pro tabulku `mail_template` -- ALTER TABLE `mail_template` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `mail_template_translation` -- ALTER TABLE `mail_template_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_translation` (`translatable`,`locale`), ADD KEY `IDX_B15D51EBCD39B6E8` (`translatable`); -- -- Klíče pro tabulku `menu` -- ALTER TABLE `menu` ADD PRIMARY KEY (`id`), ADD KEY `IDX_7D053A93D4DB71B5` (`language`); -- -- Klíče pro tabulku `menu_page` -- ALTER TABLE `menu_page` ADD PRIMARY KEY (`id`), ADD KEY `IDX_DC45466E7D053A93` (`menu`), ADD KEY `IDX_DC45466E140AB620` (`page`), ADD KEY `IDX_DC45466E3D8E604F` (`parent`); -- -- Klíče pro tabulku `message` -- ALTER TABLE `message` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `metadata` -- ALTER TABLE `metadata` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `metadata_translation` -- ALTER TABLE `metadata_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_translation` (`translatable`,`locale`), ADD KEY `IDX_5217F4C8CD39B6E8` (`translatable`); -- -- Klíče pro tabulku `module` -- ALTER TABLE `module` ADD PRIMARY KEY (`id`), ADD KEY `IDX_C242628D4DB71B5` (`language`), ADD KEY `IDX_C242628C53D045F` (`image`); -- -- Klíče pro tabulku `module_user_group` -- ALTER TABLE `module_user_group` ADD PRIMARY KEY (`module`,`user_group`), ADD KEY `IDX_1AE79400C242628` (`module`), ADD KEY `IDX_1AE794008F02BF9D` (`user_group`); -- -- Klíče pro tabulku `notification` -- ALTER TABLE `notification` ADD PRIMARY KEY (`id`), ADD KEY `IDX_BF5476CA8D93D649` (`user`), ADD KEY `IDX_BF5476CAC53D045F` (`image`); -- -- Klíče pro tabulku `page` -- ALTER TABLE `page` ADD PRIMARY KEY (`id`), ADD KEY `IDX_140AB6204F143414` (`metadata`), ADD KEY `IDX_140AB620C53D045F` (`image`), ADD KEY `IDX_140AB620D4DB71B5` (`language`), ADD KEY `IDX_140AB62023A0E66` (`article`), ADD KEY `IDX_140AB62053A4EDAA` (`article_category`), ADD KEY `IDX_140AB62032C890E0` (`schema`); -- -- Klíče pro tabulku `page_parameter` -- ALTER TABLE `page_parameter` ADD PRIMARY KEY (`id`), ADD KEY `IDX_11792EDFC4663E4` (`page_id`), ADD KEY `IDX_11792EDF7C56DBD6` (`parameter_id`), ADD KEY `IDX_11792EDFC53D045F` (`image`); -- -- Klíče pro tabulku `page_parameter_parameter_option` -- ALTER TABLE `page_parameter_parameter_option` ADD PRIMARY KEY (`page_parameter_id`,`parameter_option_id`), ADD KEY `IDX_9D0EE64EC24A7798` (`page_parameter_id`), ADD KEY `IDX_9D0EE64E5E90B0DD` (`parameter_option_id`); -- -- Klíče pro tabulku `page_parameter_translation` -- ALTER TABLE `page_parameter_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_translation` (`translatable`,`locale`), ADD KEY `IDX_A1F101BDCD39B6E8` (`translatable`); -- -- Klíče pro tabulku `page_user_group` -- ALTER TABLE `page_user_group` ADD PRIMARY KEY (`page_id`,`user_group_id`), ADD KEY `IDX_84E28E03C4663E4` (`page_id`), ADD KEY `IDX_84E28E031ED93D47` (`user_group_id`); -- -- Klíče pro tabulku `parameter` -- ALTER TABLE `parameter` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `parameter_option` -- ALTER TABLE `parameter_option` ADD PRIMARY KEY (`id`), ADD KEY `IDX_BEF80A412A979110` (`parameter`); -- -- Klíče pro tabulku `parameter_option_translation` -- ALTER TABLE `parameter_option_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_translation` (`translatable`,`locale`), ADD KEY `IDX_208083E8CD39B6E8` (`translatable`); -- -- Klíče pro tabulku `parameter_translation` -- ALTER TABLE `parameter_translation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_translation` (`translatable`,`locale`), ADD KEY `IDX_CAFDAF54CD39B6E8` (`translatable`); -- -- Klíče pro tabulku `redirection` -- ALTER TABLE `redirection` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `schema` -- ALTER TABLE `schema` ADD PRIMARY KEY (`id`); -- -- Klíče pro tabulku `schema_block` -- ALTER TABLE `schema_block` ADD PRIMARY KEY (`id`), ADD KEY `IDX_EB3DCD1B32C890E0` (`schema`), ADD KEY `IDX_EB3DCD1B3D8E604F` (`parent`), ADD KEY `IDX_EB3DCD1BC53D045F` (`image`); -- -- Klíče pro tabulku `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_email` (`email`), ADD KEY `IDX_8D93D6496660E456` (`billing_address`), ADD KEY `IDX_8D93D6498F02BF9D` (`user_group`), ADD KEY `IDX_8D93D649C53D045F` (`image`), ADD KEY `IDX_8D93D649D4DB71B5` (`language`), ADD KEY `IDX_8D93D6499999AF70` (`transport_address`); -- -- Klíče pro tabulku `user_group` -- ALTER TABLE `user_group` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT pro tabulky -- -- -- AUTO_INCREMENT pro tabulku `address` -- ALTER TABLE `address` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `article` -- ALTER TABLE `article` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT pro tabulku `article_category` -- ALTER TABLE `article_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT pro tabulku `article_category_assignment` -- ALTER TABLE `article_category_assignment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT pro tabulku `article_category_image` -- ALTER TABLE `article_category_image` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `article_category_translation` -- ALTER TABLE `article_category_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT pro tabulku `article_file` -- ALTER TABLE `article_file` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `article_image` -- ALTER TABLE `article_image` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT pro tabulku `article_parameter` -- ALTER TABLE `article_parameter` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `article_parameter_translation` -- ALTER TABLE `article_parameter_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `article_translation` -- ALTER TABLE `article_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT pro tabulku `file` -- ALTER TABLE `file` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `file_translation` -- ALTER TABLE `file_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `image` -- ALTER TABLE `image` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT pro tabulku `image_translation` -- ALTER TABLE `image_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT pro tabulku `language` -- ALTER TABLE `language` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT pro tabulku `mail_template` -- ALTER TABLE `mail_template` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT pro tabulku `mail_template_translation` -- ALTER TABLE `mail_template_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `menu` -- ALTER TABLE `menu` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT pro tabulku `menu_page` -- ALTER TABLE `menu_page` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT pro tabulku `message` -- ALTER TABLE `message` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT pro tabulku `metadata` -- ALTER TABLE `metadata` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `metadata_translation` -- ALTER TABLE `metadata_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `module` -- ALTER TABLE `module` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT pro tabulku `notification` -- ALTER TABLE `notification` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `page` -- ALTER TABLE `page` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT pro tabulku `page_parameter` -- ALTER TABLE `page_parameter` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `page_parameter_translation` -- ALTER TABLE `page_parameter_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `parameter` -- ALTER TABLE `parameter` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `parameter_option` -- ALTER TABLE `parameter_option` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `parameter_option_translation` -- ALTER TABLE `parameter_option_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `parameter_translation` -- ALTER TABLE `parameter_translation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `redirection` -- ALTER TABLE `redirection` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pro tabulku `schema` -- ALTER TABLE `schema` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT pro tabulku `schema_block` -- ALTER TABLE `schema_block` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT pro tabulku `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT pro tabulku `user_group` -- ALTER TABLE `user_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Omezení pro exportované tabulky -- -- -- Omezení pro tabulku `article` -- ALTER TABLE `article` ADD CONSTRAINT `FK_23A0E664F143414` FOREIGN KEY (`metadata`) REFERENCES `metadata` (`id`); -- -- Omezení pro tabulku `article_category` -- ALTER TABLE `article_category` ADD CONSTRAINT `FK_53A4EDAA3D8E604F` FOREIGN KEY (`parent`) REFERENCES `article_category` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_53A4EDAA4F143414` FOREIGN KEY (`metadata`) REFERENCES `metadata` (`id`); -- -- Omezení pro tabulku `article_category_assignment` -- ALTER TABLE `article_category_assignment` ADD CONSTRAINT `FK_E0A1F70A23A0E66` FOREIGN KEY (`article`) REFERENCES `article` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_E0A1F70A64C19C1` FOREIGN KEY (`category`) REFERENCES `article_category` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_category_image` -- ALTER TABLE `article_category_image` ADD CONSTRAINT `FK_8B35C79E53A4EDAA` FOREIGN KEY (`article_category`) REFERENCES `article_category` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_8B35C79EC53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_category_translation` -- ALTER TABLE `article_category_translation` ADD CONSTRAINT `FK_7FD89250CD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `article_category` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_category_user_group` -- ALTER TABLE `article_category_user_group` ADD CONSTRAINT `FK_5F660C2D53A4EDAA` FOREIGN KEY (`article_category`) REFERENCES `article_category` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_5F660C2D8F02BF9D` FOREIGN KEY (`user_group`) REFERENCES `user_group` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_file` -- ALTER TABLE `article_file` ADD CONSTRAINT `FK_3CDDB11123A0E66` FOREIGN KEY (`article`) REFERENCES `article` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_3CDDB1118C9F3610` FOREIGN KEY (`file`) REFERENCES `file` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_image` -- ALTER TABLE `article_image` ADD CONSTRAINT `FK_B28A764E23A0E66` FOREIGN KEY (`article`) REFERENCES `article` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_B28A764EC53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_parameter` -- ALTER TABLE `article_parameter` ADD CONSTRAINT `FK_F0A2C1347294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_F0A2C1347C56DBD6` FOREIGN KEY (`parameter_id`) REFERENCES `parameter` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_F0A2C134C53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE SET NULL; -- -- Omezení pro tabulku `article_parameter_parameter_option` -- ALTER TABLE `article_parameter_parameter_option` ADD CONSTRAINT `FK_86F05A315E90B0DD` FOREIGN KEY (`parameter_option_id`) REFERENCES `parameter_option` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_86F05A31AF1AAC47` FOREIGN KEY (`article_parameter_id`) REFERENCES `article_parameter` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_parameter_translation` -- ALTER TABLE `article_parameter_translation` ADD CONSTRAINT `FK_A687102CCD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `article_parameter` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `article_translation` -- ALTER TABLE `article_translation` ADD CONSTRAINT `FK_2EEA2F08CD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `article` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `file_translation` -- ALTER TABLE `file_translation` ADD CONSTRAINT `FK_96D2BB0DCD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `file` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `image_translation` -- ALTER TABLE `image_translation` ADD CONSTRAINT `FK_7BBF0EE1CD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `image` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `mail_template_translation` -- ALTER TABLE `mail_template_translation` ADD CONSTRAINT `FK_B15D51EBCD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `mail_template` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `menu` -- ALTER TABLE `menu` ADD CONSTRAINT `FK_7D053A93D4DB71B5` FOREIGN KEY (`language`) REFERENCES `language` (`id`); -- -- Omezení pro tabulku `menu_page` -- ALTER TABLE `menu_page` ADD CONSTRAINT `FK_DC45466E140AB620` FOREIGN KEY (`page`) REFERENCES `page` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_DC45466E3D8E604F` FOREIGN KEY (`parent`) REFERENCES `menu_page` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_DC45466E7D053A93` FOREIGN KEY (`menu`) REFERENCES `menu` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `metadata_translation` -- ALTER TABLE `metadata_translation` ADD CONSTRAINT `FK_5217F4C8CD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `metadata` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `module` -- ALTER TABLE `module` ADD CONSTRAINT `FK_C242628C53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_C242628D4DB71B5` FOREIGN KEY (`language`) REFERENCES `language` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `module_user_group` -- ALTER TABLE `module_user_group` ADD CONSTRAINT `FK_1AE794008F02BF9D` FOREIGN KEY (`user_group`) REFERENCES `user_group` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_1AE79400C242628` FOREIGN KEY (`module`) REFERENCES `module` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `notification` -- ALTER TABLE `notification` ADD CONSTRAINT `FK_BF5476CA8D93D649` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_BF5476CAC53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE SET NULL; -- -- Omezení pro tabulku `page` -- ALTER TABLE `page` ADD CONSTRAINT `FK_140AB62023A0E66` FOREIGN KEY (`article`) REFERENCES `article` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_140AB62032C890E0` FOREIGN KEY (`schema`) REFERENCES `schema` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_140AB6204F143414` FOREIGN KEY (`metadata`) REFERENCES `metadata` (`id`), ADD CONSTRAINT `FK_140AB62053A4EDAA` FOREIGN KEY (`article_category`) REFERENCES `article_category` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_140AB620C53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_140AB620D4DB71B5` FOREIGN KEY (`language`) REFERENCES `language` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `page_parameter` -- ALTER TABLE `page_parameter` ADD CONSTRAINT `FK_11792EDF7C56DBD6` FOREIGN KEY (`parameter_id`) REFERENCES `parameter` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_11792EDFC4663E4` FOREIGN KEY (`page_id`) REFERENCES `page` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_11792EDFC53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE SET NULL; -- -- Omezení pro tabulku `page_parameter_parameter_option` -- ALTER TABLE `page_parameter_parameter_option` ADD CONSTRAINT `FK_9D0EE64E5E90B0DD` FOREIGN KEY (`parameter_option_id`) REFERENCES `parameter_option` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_9D0EE64EC24A7798` FOREIGN KEY (`page_parameter_id`) REFERENCES `page_parameter` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `page_parameter_translation` -- ALTER TABLE `page_parameter_translation` ADD CONSTRAINT `FK_A1F101BDCD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `page_parameter` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `page_user_group` -- ALTER TABLE `page_user_group` ADD CONSTRAINT `FK_84E28E031ED93D47` FOREIGN KEY (`user_group_id`) REFERENCES `user_group` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_84E28E03C4663E4` FOREIGN KEY (`page_id`) REFERENCES `page` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `parameter_option` -- ALTER TABLE `parameter_option` ADD CONSTRAINT `FK_BEF80A412A979110` FOREIGN KEY (`parameter`) REFERENCES `parameter` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `parameter_option_translation` -- ALTER TABLE `parameter_option_translation` ADD CONSTRAINT `FK_208083E8CD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `parameter_option` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `parameter_translation` -- ALTER TABLE `parameter_translation` ADD CONSTRAINT `FK_CAFDAF54CD39B6E8` FOREIGN KEY (`translatable`) REFERENCES `parameter` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `schema_block` -- ALTER TABLE `schema_block` ADD CONSTRAINT `FK_EB3DCD1B32C890E0` FOREIGN KEY (`schema`) REFERENCES `schema` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_EB3DCD1B3D8E604F` FOREIGN KEY (`parent`) REFERENCES `schema_block` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_EB3DCD1BC53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE CASCADE; -- -- Omezení pro tabulku `user` -- ALTER TABLE `user` ADD CONSTRAINT `FK_8D93D6496660E456` FOREIGN KEY (`billing_address`) REFERENCES `address` (`id`), ADD CONSTRAINT `FK_8D93D6498F02BF9D` FOREIGN KEY (`user_group`) REFERENCES `user_group` (`id`), ADD CONSTRAINT `FK_8D93D6499999AF70` FOREIGN KEY (`transport_address`) REFERENCES `address` (`id`), ADD CONSTRAINT `FK_8D93D649C53D045F` FOREIGN KEY (`image`) REFERENCES `image` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_8D93D649D4DB71B5` FOREIGN KEY (`language`) REFERENCES `language` (`id`) ON DELETE SET NULL; 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 */;