· 8 years ago · Feb 19, 2018, 08:32 AM
1-- Adminer 4.6.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `menu`;
9CREATE TABLE `menu` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `parent_id` int(11) DEFAULT NULL,
12 `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
13 `module` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
14 `presenter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
15 `action` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
16 `description` longtext COLLATE utf8_unicode_ci,
17 `external_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
18 `external` tinyint(1) NOT NULL,
19 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
20 `lft` int(11) NOT NULL,
21 `rgt` int(11) NOT NULL,
22 `lvl` int(11) NOT NULL,
23 `root` int(11) DEFAULT NULL,
24 `tree` int(11) DEFAULT NULL,
25 `updated` datetime DEFAULT NULL,
26 `created` datetime NOT NULL,
27 PRIMARY KEY (`id`),
28 KEY `IDX_7D053A93727ACA70` (`parent_id`),
29 CONSTRAINT `FK_7D053A93727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `menu` (`id`) ON DELETE SET NULL
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
31
32INSERT INTO `menu` (`id`, `parent_id`, `title`, `module`, `presenter`, `action`, `description`, `external_link`, `external`, `type`, `lft`, `rgt`, `lvl`, `root`, `tree`, `updated`, `created`) VALUES
33(1, NULL, 'Menu', NULL, NULL, NULL, NULL, NULL, 0, 'default', 1, 44, 0, 1, 1, NULL, '2018-02-16 13:30:50'),
34(2, 21, '⌂', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 14, 15, 3, 1, 1, '2018-02-19 09:21:41', '2018-02-16 13:30:50'),
35(3, 19, 'Služby', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 32, 33, 3, 1, 1, '2018-02-19 09:19:50', '2018-02-16 13:30:50'),
36(4, 20, 'O nás', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 40, 41, 3, 1, 1, '2018-02-19 09:20:11', '2018-02-16 13:30:50'),
37(5, 1, 'Kontakt', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 20, 35, 1, 1, 1, '2018-02-19 09:20:41', '2018-02-16 13:30:50'),
38(6, 21, 'Anežka', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 16, 17, 3, 1, 1, '2018-02-19 09:22:55', '2018-02-16 13:30:50'),
39(7, 21, 'Daniel', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 10, 11, 3, 1, 1, '2018-02-19 09:22:59', '2018-02-16 13:30:50'),
40(8, 1, 'Michaela', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 8, 19, 1, 1, 1, '2018-02-19 09:21:48', '2018-02-16 13:30:50'),
41(9, 19, 'Miluše', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 22, 23, 3, 1, 1, '2018-02-19 09:23:10', '2018-02-16 13:30:50'),
42(10, 19, 'Renáta', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 26, 27, 3, 1, 1, '2018-02-19 09:23:18', '2018-02-16 13:30:50'),
43(11, 19, 'Oldřich', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 24, 25, 3, 1, 1, '2018-02-19 09:23:14', '2018-02-16 13:30:50'),
44(12, 19, 'Jaroslav', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 28, 29, 3, 1, 1, '2018-02-19 09:23:22', '2018-02-16 13:30:50'),
45(13, 19, 'Natálie', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 30, 31, 3, 1, 1, '2018-02-19 09:23:26', '2018-02-16 13:30:50'),
46(14, 20, 'Matěj', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 38, 39, 3, 1, 1, '2018-02-19 09:23:31', '2018-02-16 13:30:50'),
47(15, 1, 'LudvÃk', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 36, 43, 1, 1, 1, '2018-02-19 09:20:58', '2018-02-16 13:30:50'),
48(16, 21, 'Peter', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 12, 13, 3, 1, 1, '2018-02-19 09:23:03', '2018-02-16 13:30:50'),
49(17, 22, 'Bohumil', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 4, 5, 3, 1, 1, '2018-02-19 09:22:24', '2018-02-16 13:30:50'),
50(18, 1, 'Renáta', NULL, 'Homepage', NULL, NULL, NULL, 0, 'default', 2, 7, 1, 1, 1, '2018-02-19 09:22:30', '2018-02-16 13:30:50'),
51(19, 5, 'looooooooooooooool', NULL, NULL, NULL, NULL, NULL, 0, 'section', 21, 34, 2, 1, 1, '2018-02-19 09:20:44', '2018-02-19 09:19:17'),
52(20, 15, 'htsjjs', NULL, NULL, NULL, NULL, NULL, 0, 'section', 37, 42, 2, 1, 1, '2018-02-19 09:21:02', '2018-02-19 09:19:59'),
53(21, 8, 'ccccc', NULL, NULL, NULL, NULL, NULL, 0, 'section', 9, 18, 2, 1, 1, '2018-02-19 09:21:53', '2018-02-19 09:21:31'),
54(22, 18, 'nnnnn', NULL, NULL, NULL, NULL, NULL, 0, 'section', 3, 6, 2, 1, 1, '2018-02-19 09:22:35', '2018-02-19 09:22:04');
55
56-- 2018-02-19 08:31:26