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

--
-- Struktura tabulky `ost_filter`
--

CREATE TABLE IF NOT EXISTS `ost_filter` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `execorder` int(10) unsigned NOT NULL DEFAULT '99',
  `isactive` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `status` int(11) unsigned NOT NULL DEFAULT '0',
  `match_all_rules` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `stop_onmatch` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `target` enum('Any','Web','Email','API') NOT NULL DEFAULT 'Any',
  `email_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `target` (`target`),
  KEY `email_id` (`email_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `ost_filter`
--

INSERT INTO `ost_filter` (`id`, `execorder`, `isactive`, `status`, `match_all_rules`, `stop_onmatch`, `target`, `email_id`, `name`, `notes`, `created`, `updated`) VALUES
(1, 99, 1, 0, 0, 0, 'Email', 0, 'SYSTEM BAN LIST', 'Internal list for email banning. Do not remove', '2017-03-17 08:14:23', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_filter_action`
--

CREATE TABLE IF NOT EXISTS `ost_filter_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `filter_id` int(10) unsigned NOT NULL,
  `sort` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(24) NOT NULL,
  `configuration` text,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `filter_id` (`filter_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `ost_filter_action`
--

INSERT INTO `ost_filter_action` (`id`, `filter_id`, `sort`, `type`, `configuration`, `updated`) VALUES
(1, 1, 1, 'reject', '[]', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_filter_rule`
--

CREATE TABLE IF NOT EXISTS `ost_filter_rule` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `filter_id` int(10) unsigned NOT NULL DEFAULT '0',
  `what` varchar(32) NOT NULL,
  `how` enum('equal','not_equal','contains','dn_contain','starts','ends','match','not_match') NOT NULL,
  `val` varchar(255) NOT NULL,
  `isactive` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `notes` tinytext NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `filter` (`filter_id`,`what`,`how`,`val`),
  KEY `filter_id` (`filter_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `ost_filter_rule`
--

INSERT INTO `ost_filter_rule` (`id`, `filter_id`, `what`, `how`, `val`, `isactive`, `notes`, `created`, `updated`) VALUES
(1, 1, 'email', 'equal', 'test@example.com', 1, '', '2017-03-17 08:14:23', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_form`
--

CREATE TABLE IF NOT EXISTS `ost_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned DEFAULT NULL,
  `type` varchar(8) NOT NULL DEFAULT 'G',
  `flags` int(10) unsigned NOT NULL DEFAULT '1',
  `title` varchar(255) NOT NULL,
  `instructions` varchar(512) DEFAULT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Vypisuji data pro tabulku `ost_form`
--

INSERT INTO `ost_form` (`id`, `pid`, `type`, `flags`, `title`, `instructions`, `name`, `notes`, `created`, `updated`) VALUES
(1, NULL, 'U', 1, 'Contact Information', NULL, '', NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(2, NULL, 'T', 1, 'Ticket Details', 'Please Describe Your Issue', '', 'This form will be attached to every ticket, regardless of its source.\nYou can add any fields to this form and they will be available to all\ntickets, and will be searchable with advanced search and filterable.', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(3, NULL, 'C', 1, 'Company Information', 'Details available in email templates', '', NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(4, NULL, 'O', 1, 'Organization Information', 'Details on user organization', '', NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(5, NULL, 'A', 1, 'Task Details', 'Popište prosím Váš problém', '', 'This form is used to create a task.', '2017-03-17 08:14:23', '2017-03-17 09:36:23'),
(6, NULL, 'L1', 1, 'Ticket Status Properties', 'Properties that can be set on a ticket status.', '', NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_form_entry`
--

CREATE TABLE IF NOT EXISTS `ost_form_entry` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) unsigned NOT NULL,
  `object_id` int(11) unsigned DEFAULT NULL,
  `object_type` char(1) NOT NULL DEFAULT 'T',
  `sort` int(11) unsigned NOT NULL DEFAULT '1',
  `extra` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `entry_lookup` (`object_type`,`object_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;

--
-- Vypisuji data pro tabulku `ost_form_entry`
--

INSERT INTO `ost_form_entry` (`id`, `form_id`, `object_id`, `object_type`, `sort`, `extra`, `created`, `updated`) VALUES
(1, 4, 1, 'O', 1, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(2, 3, NULL, 'C', 1, NULL, '2017-03-17 08:14:24', '2017-03-17 08:14:24'),
(3, 1, 1, 'U', 1, NULL, '2017-03-17 08:14:24', '2017-03-17 08:14:24'),
(7, 1, 3, 'U', 1, NULL, '2017-03-17 08:44:51', '2017-03-17 08:44:51'),
(11, 1, 4, 'U', 1, NULL, '2017-03-17 14:51:32', '2017-03-17 14:51:32'),
(13, 1, 5, 'U', 1, NULL, '2017-03-22 18:11:25', '2017-03-22 18:11:25'),
(15, 1, 6, 'U', 1, NULL, '2017-03-27 09:36:53', '2017-03-27 09:36:53'),
(16, 2, 8, 'T', 1, NULL, '2017-03-27 09:36:53', '2017-03-27 09:36:53'),
(17, 1, 7, 'U', 1, NULL, '2017-03-27 20:35:03', '2017-03-27 20:35:03'),
(18, 2, 9, 'T', 1, NULL, '2017-03-27 20:35:03', '2017-03-27 20:35:03'),
(19, 2, 10, 'T', 1, NULL, '2017-03-27 20:35:03', '2017-03-27 20:35:03'),
(20, 2, 11, 'T', 1, NULL, '2017-04-03 11:05:01', '2017-04-03 11:05:01'),
(21, 1, 8, 'U', 1, NULL, '2017-04-05 11:45:02', '2017-04-05 11:45:02'),
(22, 2, 12, 'T', 1, NULL, '2017-04-05 11:45:02', '2017-04-05 11:45:02'),
(23, 2, 13, 'T', 1, NULL, '2017-04-05 14:05:02', '2017-04-05 14:05:02'),
(24, 1, 9, 'U', 1, NULL, '2017-04-05 14:15:01', '2017-04-05 14:15:01'),
(25, 2, 14, 'T', 1, NULL, '2017-04-05 14:15:01', '2017-04-05 14:15:01'),
(26, 1, 10, 'U', 1, NULL, '2017-04-05 15:40:02', '2017-04-05 15:40:02'),
(27, 2, 15, 'T', 1, NULL, '2017-04-05 15:40:02', '2017-04-05 15:40:02'),
(28, 1, 11, 'U', 1, NULL, '2017-04-06 10:10:02', '2017-04-06 10:10:02'),
(29, 2, 16, 'T', 1, NULL, '2017-04-06 10:10:02', '2017-04-06 10:10:02'),
(30, 2, 17, 'T', 1, NULL, '2017-04-06 14:55:02', '2017-04-06 14:55:02'),
(31, 2, 18, 'T', 1, NULL, '2017-04-18 16:55:31', '2017-04-18 16:55:31'),
(32, 2, 19, 'T', 1, NULL, '2017-04-19 11:35:02', '2017-04-19 11:35:02'),
(33, 2, 20, 'T', 1, NULL, '2017-04-19 15:15:01', '2017-04-19 15:15:01'),
(34, 2, 21, 'T', 1, NULL, '2017-04-20 10:45:01', '2017-04-20 10:45:01'),
(35, 2, 22, 'T', 1, NULL, '2017-04-25 15:35:02', '2017-04-25 15:35:02'),
(36, 1, 12, 'U', 1, NULL, '2017-04-29 10:35:01', '2017-04-29 10:35:01'),
(37, 2, 23, 'T', 1, NULL, '2017-04-29 10:35:01', '2017-04-29 10:35:01'),
(38, 2, 24, 'T', 1, NULL, '2017-05-03 15:40:02', '2017-05-03 15:40:02'),
(39, 1, 13, 'U', 1, NULL, '2017-05-03 15:40:02', '2017-05-03 15:40:02'),
(40, 1, 14, 'U', 1, NULL, '2017-05-31 15:30:02', '2017-05-31 15:30:02'),
(41, 2, 25, 'T', 1, NULL, '2017-05-31 15:30:02', '2017-05-31 15:30:02'),
(42, 1, 15, 'U', 1, NULL, '2017-06-05 19:35:02', '2017-06-05 19:35:02'),
(43, 2, 26, 'T', 1, NULL, '2017-06-05 19:35:02', '2017-06-05 19:35:02'),
(44, 2, 27, 'T', 1, NULL, '2017-06-08 09:25:01', '2017-06-08 09:25:01'),
(45, 2, 28, 'T', 1, NULL, '2017-06-08 14:05:02', '2017-06-08 14:05:02'),
(46, 2, 29, 'T', 1, NULL, '2017-06-12 12:35:02', '2017-06-12 12:35:02'),
(47, 2, 30, 'T', 1, NULL, '2017-06-12 13:35:01', '2017-06-12 13:35:01'),
(48, 1, 16, 'U', 1, NULL, '2017-06-13 11:25:02', '2017-06-13 11:25:02'),
(49, 2, 31, 'T', 1, NULL, '2017-06-13 11:25:02', '2017-06-13 11:25:02'),
(50, 2, 32, 'T', 1, NULL, '2017-06-15 12:40:01', '2017-06-15 12:40:01'),
(51, 2, 33, 'T', 1, NULL, '2017-06-16 14:50:02', '2017-06-16 14:50:02'),
(52, 2, 34, 'T', 1, NULL, '2017-06-16 15:50:02', '2017-06-16 15:50:02'),
(53, 2, 35, 'T', 1, NULL, '2017-06-23 09:45:02', '2017-06-23 09:45:02'),
(54, 2, 36, 'T', 1, NULL, '2017-06-23 12:30:02', '2017-06-23 12:30:02'),
(55, 1, 17, 'U', 1, NULL, '2017-06-28 12:05:02', '2017-06-28 12:05:02'),
(56, 2, 37, 'T', 1, NULL, '2017-06-28 12:05:02', '2017-06-28 12:05:02'),
(57, 2, 38, 'T', 1, NULL, '2017-07-03 14:15:01', '2017-07-03 14:15:01'),
(58, 1, 18, 'U', 1, NULL, '2017-07-07 11:50:03', '2017-07-07 11:50:03'),
(59, 2, 39, 'T', 1, NULL, '2017-07-07 11:50:03', '2017-07-07 11:50:03'),
(60, 2, 40, 'T', 1, NULL, '2017-07-10 08:15:02', '2017-07-10 08:15:02'),
(61, 2, 41, 'T', 1, NULL, '2017-07-10 14:30:02', '2017-07-10 14:30:02'),
(62, 1, 19, 'U', 1, NULL, '2017-07-11 08:40:01', '2017-07-11 08:40:01'),
(63, 2, 42, 'T', 1, NULL, '2017-07-11 08:40:01', '2017-07-11 08:40:01'),
(64, 1, 20, 'U', 1, NULL, '2017-07-11 11:25:01', '2017-07-11 11:25:01'),
(65, 2, 43, 'T', 1, NULL, '2017-07-11 11:25:02', '2017-07-11 11:25:02'),
(66, 2, 44, 'T', 1, NULL, '2017-07-12 15:05:01', '2017-07-12 15:05:01'),
(67, 1, 21, 'U', 1, NULL, '2017-07-13 08:15:02', '2017-07-13 08:15:02'),
(68, 2, 45, 'T', 1, NULL, '2017-07-13 08:15:02', '2017-07-13 08:15:02'),
(69, 1, 22, 'U', 1, NULL, '2017-07-13 09:25:01', '2017-07-13 09:25:01'),
(70, 2, 46, 'T', 1, NULL, '2017-07-13 09:25:01', '2017-07-13 09:25:01'),
(71, 1, 23, 'U', 1, NULL, '2017-07-13 11:15:01', '2017-07-13 11:15:01'),
(72, 2, 47, 'T', 1, NULL, '2017-07-13 11:15:01', '2017-07-13 11:15:01'),
(73, 2, 48, 'T', 1, NULL, '2017-07-13 12:15:02', '2017-07-13 12:15:02'),
(74, 2, 49, 'T', 1, NULL, '2017-07-14 11:30:01', '2017-07-14 11:30:01'),
(75, 2, 50, 'T', 1, NULL, '2017-07-18 14:35:02', '2017-07-18 14:35:02'),
(76, 1, 24, 'U', 1, NULL, '2017-07-19 10:30:02', '2017-07-19 10:30:02'),
(77, 2, 51, 'T', 1, NULL, '2017-07-19 10:30:02', '2017-07-19 10:30:02'),
(78, 1, 25, 'U', 1, NULL, '2017-07-19 10:40:02', '2017-07-19 10:40:02'),
(79, 2, 52, 'T', 1, NULL, '2017-07-19 10:40:02', '2017-07-19 10:40:02'),
(80, 1, 26, 'U', 1, NULL, '2017-07-21 15:20:02', '2017-07-21 15:20:02'),
(81, 2, 53, 'T', 1, NULL, '2017-07-21 15:20:02', '2017-07-21 15:20:02'),
(82, 1, 27, 'U', 1, NULL, '2017-07-24 12:45:02', '2017-07-24 12:45:02'),
(83, 2, 54, 'T', 1, NULL, '2017-07-24 12:45:02', '2017-07-24 12:45:02'),
(84, 1, 28, 'U', 1, NULL, '2017-07-24 12:45:02', '2017-07-24 12:45:02'),
(85, 2, 55, 'T', 1, NULL, '2017-07-25 15:09:29', '2017-07-25 15:09:29'),
(86, 2, 56, 'T', 1, NULL, '2017-07-27 12:50:02', '2017-07-27 12:50:02'),
(87, 1, 29, 'U', 1, NULL, '2017-07-27 16:45:02', '2017-07-27 16:45:02'),
(88, 2, 57, 'T', 1, NULL, '2017-07-27 16:45:02', '2017-07-27 16:45:02'),
(89, 2, 58, 'T', 1, NULL, '2017-07-31 10:15:02', '2017-07-31 10:15:02'),
(90, 1, 30, 'U', 1, NULL, '2017-07-31 12:15:02', '2017-07-31 12:15:02'),
(91, 2, 59, 'T', 1, NULL, '2017-07-31 12:15:02', '2017-07-31 12:15:02'),
(92, 1, 31, 'U', 1, NULL, '2017-08-02 11:05:01', '2017-08-02 11:05:01'),
(93, 2, 60, 'T', 1, NULL, '2017-08-02 11:05:01', '2017-08-02 11:05:01'),
(94, 1, 32, 'U', 1, NULL, '2017-08-02 11:50:01', '2017-08-02 11:50:01'),
(95, 2, 61, 'T', 1, NULL, '2017-08-02 11:50:01', '2017-08-02 11:50:01'),
(96, 1, 33, 'U', 1, NULL, '2017-08-02 13:50:01', '2017-08-02 13:50:01'),
(97, 2, 62, 'T', 1, NULL, '2017-08-02 13:50:01', '2017-08-02 13:50:01'),
(98, 2, 63, 'T', 1, NULL, '2017-08-02 15:25:02', '2017-08-02 15:25:02'),
(99, 2, 64, 'T', 1, NULL, '2017-08-03 13:05:02', '2017-08-03 13:05:02'),
(100, 2, 65, 'T', 1, NULL, '2017-08-03 16:00:02', '2017-08-03 16:00:02'),
(101, 2, 66, 'T', 1, NULL, '2017-08-04 12:45:02', '2017-08-04 12:45:02'),
(102, 2, 67, 'T', 1, NULL, '2017-08-07 08:10:02', '2017-08-07 08:10:02'),
(103, 2, 68, 'T', 1, NULL, '2017-08-07 13:30:02', '2017-08-07 13:30:02'),
(104, 1, 34, 'U', 1, NULL, '2017-08-08 12:35:01', '2017-08-08 12:35:01'),
(105, 2, 69, 'T', 1, NULL, '2017-08-08 12:35:01', '2017-08-08 12:35:01'),
(106, 1, 35, 'U', 1, NULL, '2017-08-08 16:50:02', '2017-08-08 16:50:02'),
(107, 2, 70, 'T', 1, NULL, '2017-08-08 16:50:02', '2017-08-08 16:50:02'),
(108, 1, 36, 'U', 1, NULL, '2017-08-10 12:50:01', '2017-08-10 12:50:01'),
(109, 2, 71, 'T', 1, NULL, '2017-08-10 12:50:01', '2017-08-10 12:50:01'),
(110, 2, 72, 'T', 1, NULL, '2017-08-10 14:25:02', '2017-08-10 14:25:02'),
(111, 2, 73, 'T', 1, NULL, '2017-08-10 14:30:02', '2017-08-10 14:30:02'),
(112, 1, 37, 'U', 1, NULL, '2017-08-10 15:20:02', '2017-08-10 15:20:02'),
(113, 2, 74, 'T', 1, NULL, '2017-08-10 15:20:02', '2017-08-10 15:20:02'),
(114, 1, 38, 'U', 1, NULL, '2017-08-10 15:30:01', '2017-08-10 15:30:01'),
(115, 2, 75, 'T', 1, NULL, '2017-08-10 15:30:01', '2017-08-10 15:30:01');

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

--
-- Struktura tabulky `ost_form_entry_values`
--

CREATE TABLE IF NOT EXISTS `ost_form_entry_values` (
  `entry_id` int(11) unsigned NOT NULL,
  `field_id` int(11) unsigned NOT NULL,
  `value` text,
  `value_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`entry_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Vypisuji data pro tabulku `ost_form_entry_values`
--

INSERT INTO `ost_form_entry_values` (`entry_id`, `field_id`, `value`, `value_id`) VALUES
(1, 28, '420 Desoto Street\nAlexandria, LA 71301', NULL),
(1, 29, '3182903674', NULL),
(1, 30, 'http://osticket.com', NULL),
(1, 31, 'Not only do we develop the software, we also use it to manage support for osTicket. Let us help you quickly implement and leverage the full potential of osTicket''s features and functionality. Contact us for professional support or visit our website for documentation and community support.', NULL),
(2, 23, 'Naturhouse', NULL),
(2, 24, NULL, NULL),
(2, 25, NULL, NULL),
(2, 26, NULL, NULL),
(3, 3, NULL, NULL),
(3, 4, NULL, NULL),
(7, 3, NULL, NULL),
(7, 4, NULL, NULL),
(11, 3, NULL, NULL),
(11, 4, NULL, NULL),
(13, 3, NULL, NULL),
(13, 4, NULL, NULL),
(15, 3, NULL, NULL),
(15, 4, NULL, NULL),
(16, 20, 'chyby programu', NULL),
(16, 22, 'Normal', 2),
(17, 3, NULL, NULL),
(17, 4, NULL, NULL),
(18, 20, 'historie diet', NULL),
(18, 22, 'Normal', 2),
(19, 20, 'Test', NULL),
(19, 22, 'Normal', 2),
(20, 20, 'URGENTNÍ  !!! nelze se připojit k databázi', NULL),
(20, 22, 'Normal', 2),
(21, 3, NULL, NULL),
(21, 4, NULL, NULL),
(22, 20, 'Břeclav', NULL),
(22, 22, 'Normal', 2),
(23, 20, 'Břeclav', NULL),
(23, 22, 'Normal', 2),
(24, 3, NULL, NULL),
(24, 4, NULL, NULL),
(25, 20, 'postřehy z programu', NULL),
(25, 22, 'Normal', 2),
(26, 3, NULL, NULL),
(26, 4, NULL, NULL),
(27, 20, 'Nový SW', NULL),
(27, 22, 'Normal', 2),
(28, 3, NULL, NULL),
(28, 4, NULL, NULL),
(29, 20, 'SW', NULL),
(29, 22, 'Normal', 2),
(30, 20, 'SW', NULL),
(30, 22, 'Normal', 2),
(31, 20, 'Aktualizace dietologického SW -Jičín', NULL),
(31, 22, 'Normal', 2),
(32, 20, 'software', NULL),
(32, 22, 'Normal', 2),
(33, 20, 'Nový SW', NULL),
(33, 22, 'Normal', 2),
(34, 20, 'ukládání dat a vážení', NULL),
(34, 22, 'Normal', 2),
(35, 20, 'Nový SW', NULL),
(35, 22, 'Normal', 2),
(36, 3, NULL, NULL),
(36, 4, NULL, NULL),
(37, 20, 'Chyby', NULL),
(37, 22, 'Normal', 2),
(38, 20, 'cvičení', NULL),
(38, 22, 'Normal', 2),
(39, 3, NULL, NULL),
(39, 4, NULL, NULL),
(40, 3, NULL, NULL),
(40, 4, NULL, NULL),
(41, 20, 'error pobočka Rakovník', NULL),
(41, 22, 'Normal', 2),
(42, 3, NULL, NULL),
(42, 4, NULL, NULL),
(43, 20, 'printscreen SW Mělník', NULL),
(43, 22, 'Normal', 2),
(44, 20, 'urgent afill', NULL),
(44, 22, 'Normal', 2),
(45, 20, 'error Endrštová', NULL),
(45, 22, 'Normal', 2),
(46, 20, 'chyba', NULL),
(46, 22, 'Normal', 2),
(47, 20, 'Fwd: urgent afill', NULL),
(47, 22, 'Normal', 2),
(48, 3, NULL, NULL),
(48, 4, NULL, NULL),
(49, 20, 'nelze nový klient přidat', NULL),
(49, 22, 'Normal', 2),
(50, 20, 'Re: poznámka k tisku denního záznamu', NULL),
(50, 22, 'Normal', 2),
(51, 20, 'chyba programu', NULL),
(51, 22, 'Normal', 2),
(52, 20, 'error rakovník ', NULL),
(52, 22, 'Normal', 2),
(53, 20, 'RE: chyba programu', NULL),
(53, 22, 'Normal', 2),
(54, 20, 'chyba ukladaní', NULL),
(54, 22, 'Normal', 2),
(55, 3, NULL, NULL),
(55, 4, NULL, NULL),
(56, 20, 'program neodpovídá', NULL),
(56, 22, 'Normal', 2),
(57, 20, 'chyba kalendáře', NULL),
(57, 22, 'Normal', 2),
(58, 3, NULL, NULL),
(58, 4, NULL, NULL),
(59, 20, 'Nový program - NICAAM', NULL),
(59, 22, 'Normal', 2),
(60, 20, 'chyba programu', NULL),
(60, 22, 'Normal', 2),
(61, 20, 'program - chyba zadávaní slevy', NULL),
(61, 22, 'Normal', 2),
(62, 3, NULL, NULL),
(62, 4, NULL, NULL),
(63, 20, 'nový systém', NULL),
(63, 22, 'Normal', 2),
(64, 3, NULL, NULL),
(64, 4, NULL, NULL),
(65, 20, 'NICAAM - problematické instalace na pokladně', NULL),
(65, 22, 'Normal', 2),
(66, 20, 'Nový systém', NULL),
(66, 22, 'Normal', 2),
(67, 3, NULL, NULL),
(67, 4, NULL, NULL),
(68, 20, 'dotaz', NULL),
(68, 22, 'Normal', 2),
(69, 3, NULL, NULL),
(69, 4, NULL, NULL),
(70, 20, 'Tisk TANITY', NULL),
(70, 22, 'Normal', 2),
(71, 3, NULL, NULL),
(71, 4, NULL, NULL),
(72, 20, 'postřehy k funkčnosti programu', NULL),
(72, 22, 'Normal', 2),
(73, 20, 'nový systém-nelze najít klientku', NULL),
(73, 22, 'Normal', 2),
(74, 20, 'Fwd: postřehy k funkčnosti programu', NULL),
(74, 22, 'Normal', 2),
(75, 20, 'instalace SW', NULL),
(75, 22, 'Normal', 2),
(76, 3, NULL, NULL),
(76, 4, NULL, NULL),
(77, 20, '(bez predmetu)', NULL),
(77, 22, 'Normal', 2),
(78, 3, NULL, NULL),
(78, 4, NULL, NULL),
(79, 20, 'NICAM Anděl', NULL),
(79, 22, 'Normal', 2),
(80, 3, NULL, NULL),
(80, 4, NULL, NULL),
(81, 20, 'Otevření nového dietologického programu', NULL),
(81, 22, 'Normal', 2),
(82, 3, NULL, NULL),
(82, 4, NULL, NULL),
(83, 20, 'uživatelská nefunkčnost sw', NULL),
(83, 22, 'Normal', 2),
(84, 3, NULL, NULL),
(84, 4, NULL, NULL),
(85, 20, 'zjištění typu zdroje z affilu', NULL),
(85, 22, 'Normal', 2),
(86, 20, 'nejdou uložit úkoly, +neuložená data u klientky', NULL),
(86, 22, 'Normal', 2),
(87, 3, NULL, NULL),
(87, 4, NULL, NULL),
(88, 20, 'postřehy k novému programu z Krnova', NULL),
(88, 22, 'Normal', 2),
(89, 20, 'nový systém', NULL),
(89, 22, 'Normal', 2),
(90, 3, NULL, NULL),
(90, 4, NULL, NULL),
(91, 20, 'program', NULL),
(91, 22, 'Normal', 2),
(92, 3, NULL, NULL),
(92, 4, NULL, NULL),
(93, 20, ' Nový program', NULL),
(93, 22, 'Normal', 2),
(94, 3, NULL, NULL),
(94, 4, NULL, NULL),
(95, 20, 'Problémy s novým SW', NULL),
(95, 22, 'Normal', 2),
(96, 3, NULL, NULL),
(96, 4, NULL, NULL),
(97, 20, 'Tisk výsledků tanit', NULL),
(97, 22, 'Normal', 2),
(98, 20, 'Dotaz na zadávání úkolů', NULL),
(98, 22, 'Normal', 2),
(99, 20, 'kalendář', NULL),
(99, 22, 'Normal', 2),
(100, 20, 'program', NULL),
(100, 22, 'Normal', 2),
(101, 20, ' Rokycany - problém výpočtů po vážení', NULL),
(101, 22, 'Normal', 2),
(102, 20, 'program', NULL),
(102, 22, 'Normal', 2),
(103, 20, 'tanita', NULL),
(103, 22, 'Normal', 2),
(104, 3, NULL, NULL),
(104, 4, NULL, NULL),
(105, 20, 'Nový program', NULL),
(105, 22, 'Normal', 2),
(106, 3, NULL, NULL),
(106, 4, NULL, NULL),
(107, 20, 'Připomínky k novému programu Iva Bednaříková NH Brno, Orlí', NULL),
(107, 22, 'Normal', 2),
(108, 3, NULL, NULL),
(108, 4, NULL, NULL),
(109, 20, 'Fwd: připomínky k novému programu', NULL),
(109, 22, 'Normal', 2),
(110, 20, 'Dotazy', NULL),
(110, 22, 'Normal', 2),
(111, 20, 'Reklamace kontaktů z affilu', NULL),
(111, 22, 'Normal', 2),
(112, 3, NULL, NULL),
(112, 4, NULL, NULL),
(113, 20, 'Nový dietologický program', NULL),
(113, 22, 'Normal', 2),
(114, 3, NULL, NULL),
(114, 4, NULL, NULL),
(115, 20, 'Dotaz ohledně ceny', NULL),
(115, 22, 'Normal', 2);

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

--
-- Struktura tabulky `ost_form_field`
--

CREATE TABLE IF NOT EXISTS `ost_form_field` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) unsigned NOT NULL,
  `flags` int(10) unsigned DEFAULT '1',
  `type` varchar(255) NOT NULL DEFAULT 'text',
  `label` varchar(255) NOT NULL,
  `name` varchar(64) NOT NULL,
  `configuration` text,
  `sort` int(11) unsigned NOT NULL,
  `hint` varchar(512) DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;

--
-- Vypisuji data pro tabulku `ost_form_field`
--

INSERT INTO `ost_form_field` (`id`, `form_id`, `flags`, `type`, `label`, `name`, `configuration`, `sort`, `hint`, `created`, `updated`) VALUES
(1, 1, 489379, 'text', 'Email Address', 'email', '{"size":40,"length":64,"validator":"email"}', 1, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(2, 1, 489379, 'text', 'Full Name', 'name', '{"size":40,"length":64}', 2, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(3, 1, 13057, 'phone', 'Phone Number', 'phone', NULL, 3, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(4, 1, 12289, 'memo', 'Internal Notes', 'notes', '{"rows":4,"cols":40}', 4, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(20, 2, 489249, 'text', 'Issue Summary', 'subject', '{"size":40,"length":50}', 1, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(21, 2, 480547, 'thread', 'Issue Details', 'message', NULL, 2, 'Details on the reason(s) for opening the ticket.', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(22, 2, 274609, 'priority', 'Priority Level', 'priority', NULL, 3, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(23, 3, 291233, 'text', 'Company Name', 'name', '{"size":40,"length":64}', 1, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(24, 3, 12545, 'text', 'Website', 'website', '{"size":40,"length":64}', 2, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(25, 3, 12545, 'phone', 'Phone Number', 'phone', '{"ext":false}', 3, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(26, 3, 12545, 'memo', 'Address', 'address', '{"rows":2,"cols":40,"html":false,"length":100}', 4, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(27, 4, 489379, 'text', 'Name', 'name', '{"size":40,"length":64}', 1, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(28, 4, 13057, 'memo', 'Address', 'address', '{"rows":2,"cols":40,"length":100,"html":false}', 2, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(29, 4, 13057, 'phone', 'Phone', 'phone', NULL, 3, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(30, 4, 13057, 'text', 'Website', 'website', '{"size":40,"length":0}', 4, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(31, 4, 12289, 'memo', 'Internal Notes', 'notes', '{"rows":4,"cols":40}', 5, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(32, 5, 290977, 'text', 'Název', 'title', '{"size":40,"length":50}', 1, NULL, '2017-03-17 08:14:23', '2017-03-17 09:36:23'),
(33, 5, 282867, 'thread', 'Popis', 'description', NULL, 2, 'Details on the reason(s) for creating the task.', '2017-03-17 08:14:23', '2017-03-17 09:36:23'),
(34, 6, 487665, 'state', 'State', 'state', '{"prompt":"State of a ticket"}', 1, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(35, 6, 471073, 'memo', 'Description', 'description', '{"rows":2,"cols":40,"html":false,"length":100}', 3, NULL, '2017-03-17 08:14:23', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_group`
--

CREATE TABLE IF NOT EXISTS `ost_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) unsigned NOT NULL,
  `flags` int(11) unsigned NOT NULL DEFAULT '1',
  `name` varchar(120) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `ost_help_topic`
--

CREATE TABLE IF NOT EXISTS `ost_help_topic` (
  `topic_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `topic_pid` int(10) unsigned NOT NULL DEFAULT '0',
  `isactive` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `ispublic` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `noautoresp` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `flags` int(10) unsigned DEFAULT '0',
  `status_id` int(10) unsigned NOT NULL DEFAULT '0',
  `priority_id` int(10) unsigned NOT NULL DEFAULT '0',
  `dept_id` int(10) unsigned NOT NULL DEFAULT '0',
  `staff_id` int(10) unsigned NOT NULL DEFAULT '0',
  `team_id` int(10) unsigned NOT NULL DEFAULT '0',
  `sla_id` int(10) unsigned NOT NULL DEFAULT '0',
  `page_id` int(10) unsigned NOT NULL DEFAULT '0',
  `sequence_id` int(10) unsigned NOT NULL DEFAULT '0',
  `sort` int(10) unsigned NOT NULL DEFAULT '0',
  `topic` varchar(32) NOT NULL DEFAULT '',
  `number_format` varchar(32) DEFAULT NULL,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`topic_id`),
  UNIQUE KEY `topic` (`topic`,`topic_pid`),
  KEY `topic_pid` (`topic_pid`),
  KEY `priority_id` (`priority_id`),
  KEY `dept_id` (`dept_id`),
  KEY `staff_id` (`staff_id`,`team_id`),
  KEY `sla_id` (`sla_id`),
  KEY `page_id` (`page_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Vypisuji data pro tabulku `ost_help_topic`
--

INSERT INTO `ost_help_topic` (`topic_id`, `topic_pid`, `isactive`, `ispublic`, `noautoresp`, `flags`, `status_id`, `priority_id`, `dept_id`, `staff_id`, `team_id`, `sla_id`, `page_id`, `sequence_id`, `sort`, `topic`, `number_format`, `notes`, `created`, `updated`) VALUES
(1, 0, 1, 1, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 'General Inquiry', NULL, 'Questions about products or services', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(2, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Feedback', NULL, 'Tickets that primarily concern the sales and billing departments', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(10, 0, 1, 1, 0, 0, 0, 2, 3, 0, 0, 0, 0, 0, 0, 'Report a Problem', NULL, 'Product, service, or equipment related issues', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(11, 10, 1, 1, 0, 0, 0, 3, 0, 0, 0, 1, 0, 0, 1, 'Access Issue', NULL, 'Report an inability access a physical or virtual asset', '2017-03-17 08:14:23', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_help_topic_form`
--

CREATE TABLE IF NOT EXISTS `ost_help_topic_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) unsigned NOT NULL DEFAULT '0',
  `form_id` int(10) unsigned NOT NULL DEFAULT '0',
  `sort` int(10) unsigned NOT NULL DEFAULT '1',
  `extra` text,
  PRIMARY KEY (`id`),
  KEY `topic-form` (`topic_id`,`form_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Vypisuji data pro tabulku `ost_help_topic_form`
--

INSERT INTO `ost_help_topic_form` (`id`, `topic_id`, `form_id`, `sort`, `extra`) VALUES
(1, 1, 2, 1, '{"disable":[]}'),
(2, 2, 2, 1, '{"disable":[]}'),
(3, 10, 2, 1, '{"disable":[]}'),
(4, 11, 2, 1, '{"disable":[]}');

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

--
-- Struktura tabulky `ost_list`
--

CREATE TABLE IF NOT EXISTS `ost_list` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `name_plural` varchar(255) DEFAULT NULL,
  `sort_mode` enum('Alpha','-Alpha','SortCol') NOT NULL DEFAULT 'Alpha',
  `masks` int(11) unsigned NOT NULL DEFAULT '0',
  `type` varchar(16) DEFAULT NULL,
  `configuration` text NOT NULL,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `ost_list`
--

INSERT INTO `ost_list` (`id`, `name`, `name_plural`, `sort_mode`, `masks`, `type`, `configuration`, `notes`, `created`, `updated`) VALUES
(1, 'Ticket Status', 'Ticket Statuses', 'SortCol', 13, 'ticket-status', '{"handler":"TicketStatusList"}', 'Ticket statuses', '2017-03-17 08:14:23', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_list_items`
--

CREATE TABLE IF NOT EXISTS `ost_list_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `list_id` int(11) DEFAULT NULL,
  `status` int(11) unsigned NOT NULL DEFAULT '1',
  `value` varchar(255) NOT NULL,
  `extra` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT '1',
  `properties` text,
  PRIMARY KEY (`id`),
  KEY `list_item_lookup` (`list_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `ost_lock`
--

CREATE TABLE IF NOT EXISTS `ost_lock` (
  `lock_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int(10) unsigned NOT NULL DEFAULT '0',
  `expire` datetime DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`lock_id`),
  KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=66 ;

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

--
-- Struktura tabulky `ost_note`
--

CREATE TABLE IF NOT EXISTS `ost_note` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) unsigned DEFAULT NULL,
  `staff_id` int(11) unsigned NOT NULL DEFAULT '0',
  `ext_id` varchar(10) DEFAULT NULL,
  `body` text,
  `status` int(11) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ext_id` (`ext_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `ost_organization`
--

CREATE TABLE IF NOT EXISTS `ost_organization` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '',
  `manager` varchar(16) NOT NULL DEFAULT '',
  `status` int(11) unsigned NOT NULL DEFAULT '0',
  `domain` varchar(256) NOT NULL DEFAULT '',
  `extra` text,
  `created` timestamp NULL DEFAULT NULL,
  `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `ost_organization`
--

INSERT INTO `ost_organization` (`id`, `name`, `manager`, `status`, `domain`, `extra`, `created`, `updated`) VALUES
(1, 'osTicket', '', 8, '', NULL, '2017-03-17 07:14:23', NULL);

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

--
-- Struktura tabulky `ost_organization__cdata`
--

CREATE TABLE IF NOT EXISTS `ost_organization__cdata` (
  `org_id` int(11) unsigned NOT NULL DEFAULT '0',
  `name` mediumtext,
  `address` mediumtext,
  `phone` mediumtext,
  `website` mediumtext,
  `notes` mediumtext,
  PRIMARY KEY (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Vypisuji data pro tabulku `ost_organization__cdata`
--

INSERT INTO `ost_organization__cdata` (`org_id`, `name`, `address`, `phone`, `website`, `notes`) VALUES
(1, NULL, '420 Desoto Street\nAlexandria, LA 71301', '3182903674', 'http://osticket.com', 'Not only do we develop the software, we also use it to manage support for osTicket. Let us help you quickly implement and leverage the full potential of osTicket''s features and functionality. Contact us for professional support or visit our website for documentation and community support.');

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

--
-- Struktura tabulky `ost_plugin`
--

CREATE TABLE IF NOT EXISTS `ost_plugin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `install_path` varchar(60) NOT NULL,
  `isphar` tinyint(1) NOT NULL DEFAULT '0',
  `isactive` tinyint(1) NOT NULL DEFAULT '0',
  `version` varchar(64) DEFAULT NULL,
  `installed` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `ost_queue`
--

CREATE TABLE IF NOT EXISTS `ost_queue` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned NOT NULL DEFAULT '0',
  `flags` int(11) unsigned NOT NULL DEFAULT '0',
  `staff_id` int(11) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) DEFAULT NULL,
  `config` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `ost_role`
--

CREATE TABLE IF NOT EXISTS `ost_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `flags` int(10) unsigned NOT NULL DEFAULT '1',
  `name` varchar(64) DEFAULT NULL,
  `permissions` text,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Vypisuji data pro tabulku `ost_role`
--

INSERT INTO `ost_role` (`id`, `flags`, `name`, `permissions`, `notes`, `created`, `updated`) VALUES
(1, 1, 'All Access', '{"ticket.create":1,"ticket.edit":1,"ticket.assign":1,"ticket.transfer":1,"ticket.reply":1,"ticket.close":1,"ticket.delete":1,"thread.edit":1,"task.create":1,"task.edit":1,"task.assign":1,"task.transfer":1,"task.reply":1,"task.close":1,"task.delete":1,"canned.manage":1}', 'Role with unlimited access', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(2, 1, 'Expanded Access', '{"ticket.create":1,"ticket.edit":1,"ticket.assign":1,"ticket.transfer":1,"ticket.reply":1,"ticket.close":1,"task.create":1,"task.edit":1,"task.assign":1,"task.transfer":1,"task.reply":1,"task.close":1,"canned.manage":1}', 'Role with expanded access', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(3, 1, 'Limited Access', '{"ticket.create":1,"ticket.assign":1,"ticket.transfer":1,"task.assign":1,"task.transfer":1,"task.reply":1}', 'Role with limited access', '2017-03-17 08:14:23', '2017-03-17 08:14:23'),
(4, 1, 'View only', NULL, 'Simple role with no permissions', '2017-03-17 08:14:23', '2017-03-17 08:14:23');

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

--
-- Struktura tabulky `ost_sequence`
--

CREATE TABLE IF NOT EXISTS `ost_sequence` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  `flags` int(10) unsigned DEFAULT NULL,
  `next` bigint(20) unsigned NOT NULL DEFAULT '1',
  `increment` int(11) DEFAULT '1',
  `padding` char(1) DEFAULT '0',
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Vypisuji data pro tabulku `ost_sequence`
--

INSERT INTO `ost_sequence` (`id`, `name`, `flags`, `next`, `increment`, `padding`, `updated`) VALUES
(1, 'General Tickets', 1, 1, 1, '0', '0000-00-00 00:00:00'),
(2, 'Tasks Sequence', 1, 1, 1, '0', '0000-00-00 00:00:00');

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

--
-- Struktura tabulky `ost_session`
--

CREATE TABLE IF NOT EXISTS `ost_session` (
  `session_id` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
  `session_data` blob,
  `session_expire` datetime DEFAULT NULL,
  `session_updated` datetime DEFAULT NULL,
  `user_id` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT 'osTicket staff/client ID',
  `user_ip` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_agent` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `updated` (`session_updated`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Vypisuji data pro tabulku `ost_session`
--

INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('0ik8n24meg3p98kjintvssbdr7', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2265633435643765373932353763316666646633363836366436373232313633333730626237616262223b733a343a2274696d65223b693a313439353039353231343b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-05-19 10:13:34', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('0jp8at4plrvcip4r7prjdc8to0', 0x[encoded data, 10924 characters], '2017-07-11 16:40:21', NULL, '0', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('0u8hlpme86c4i3rakqp4pniut5', 0x[encoded data, 10924 characters], '2017-06-22 14:03:41', NULL, '0', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('1clcm5igmj1e1airkotdi7l6o4', 0x[encoded data, 10708 characters], '2017-07-25 15:04:15', NULL, '2', '109.81.209.231', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('1gsukok7vbn2nrh0hhkvl1ttc4', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2262316537396234373636643737636331653330633161396466306532633666323663323031663530223b733a343a2274696d65223b693a313439373334313433393b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3235223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b613a323a7b733a323a226964223b693a313b733a333a226b6579223b733a31313a226c6f63616c3a68616a656b223b7d7d3a746f6b656e7c613a313a7b733a353a227374616666223b733a37363a2237353637306666623663373463306435613238633935343433653531666262343a313439373334313433383a3863326239303061303566343031373262626237663463633662353838636435223b7d6366673a636f72657c613a313a7b733a31313a2264625f74696d657a6f6e65223b733a31333a224575726f70652f4265726c696e223b7d6c61737463726f6e63616c6c7c693a313439373334313433393b, '2017-06-14 10:10:39', NULL, '0', '89.103.145.80', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('1hur08r9k7dqib2ai5mfnrg063', 0x[encoded data, 10924 characters], '2017-06-06 10:41:36', NULL, '0', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0');
INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('1i3clkg0nk7rh3a5flr30i3hm2', 0x[encoded data, 10932 characters], '2017-03-29 18:19:18', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0'),
('1o0vqga8kkcft5s5as8afa98r4', 0x[encoded data, 10940 characters], '2017-03-20 22:38:47', NULL, '1', '77.87.240.6', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36'),
('1s9qdcntouubv9htf2lrksljv0', 0x[encoded data, 17088 characters], '2017-04-19 16:56:58', NULL, '2', '89.177.23.91', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0'),
('1vv5uc7oc1ssqn7s6583aua6q4', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2231333864303339396539393436343330336336616433393338323436636263336230316666336531223b733a343a2274696d65223b693a313439373337363835373b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3136223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-06-14 20:00:57', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36');
INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('26rfrnalae3qqer05egaqbfmr0', 0x[encoded data, 10930 characters], '2017-04-11 15:18:32', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0'),
('291b8fmarb5ml6d3lfcb59l081', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2231656132383662353531323266336331363961653436333437613536636431386664383135376135223b733a343a2274696d65223b693a313439383736323733323b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3332223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-06-30 20:58:52', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('2bk2cjadh3ca6ajnnkd3nbehm3', 0x[encoded data, 10924 characters], '2017-03-31 17:32:16', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0'),
('2c6s30osno4847c1pivgph2515', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2262363965373634643438653739646336633934353035663666613932343634663036613365623937223b733a343a2274696d65223b693a313439393935383430373b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3434223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b613a323a7b733a323a226964223b693a313b733a333a226b6579223b733a31313a226c6f63616c3a68616a656b223b7d7d3a746f6b656e7c613a313a7b733a353a227374616666223b733a37363a2232396365363163386536333130303231353562323938666662636233663764383a313439393935383430363a6166633733393533343362343834343439323332393038373030323164343361223b7d6366673a636f72657c613a313a7b733a31313a2264625f74696d657a6f6e65223b733a31333a224575726f70652f4265726c696e223b7d6c61737463726f6e63616c6c7c693a313439393935383430373b, '2017-07-14 17:06:47', NULL, '0', '85.70.147.56', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('2h00rtu9e2r3qgpjg2s54f6k83', 0x[encoded data, 10964 characters], '2017-07-21 22:19:01', NULL, '1', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('2qekg0h6d4m0fufgrtm1ih9pu5', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2239366139383763336539353237646231393730363131383765363161626234333035376331653037223b733a343a2274696d65223b693a313530313837313735363b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3537223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-08-05 20:35:56', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('33stgv3ghnm5l6l9l3n8h2id65', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2239333964333335613835353362326439613063623833306533613131636537643636396639373739223b733a343a2274696d65223b693a313439363338363234343b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3235223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-06-03 08:50:44', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('3duh7jt1gu12fnn91mpihi2rt4', 0x[encoded data, 10708 characters], '2017-06-15 21:16:19', NULL, '1', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36');
INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('3r1ofm37vnu81h1tm1c32s8pf2', 0x[encoded data, 10930 characters], '2017-04-14 10:27:15', NULL, '2', '89.177.23.91', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0'),
('430mff8tbeg0p3prpmhapka1k6', 0x[encoded data, 10972 characters], '2017-08-01 11:14:50', NULL, '1', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('43jf6qfoa3vhghb0lmn74tmte3', 0x[encoded data, 10972 characters], '2017-04-21 19:55:07', NULL, '1', '147.32.216.253', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36'),
('4mgih0gdffjhm8h1g4c3kl7b50', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2263346430343036633063663331323238353665383262313433396239666562383733343839313164223b733a343a2274696d65223b693a313439393838343837343b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-07-13 20:41:14', NULL, '0', '82.202.120.247', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('4qlr3l8ak783uduf72dovta9e4', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2230646431646138303431666434643936323763626539333536613036633339643564663531656265223b733a343a2274696d65223b693a313439363734343534393b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a31343a222f7363702f696e6465782e706870223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-06-07 12:22:29', NULL, '0', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0'),
('52c5gifht2t648o1gsfs4cp083', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2231623230356463373365363931393036663730373537633662356162303661666533663031383737223b733a343a2274696d65223b693a313439343934303531313b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-05-17 15:15:11', NULL, '0', '147.32.216.170', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('5djs5fe9dmls13ll19nrg1pnr2', 0x[encoded data, 11058 characters], '2017-08-08 15:15:39', NULL, '0', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0');
INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('5kj9ig9bt4a7jclaqaf04phv20', 0x[encoded data, 10924 characters], '2017-06-28 09:57:26', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('5lq9q5baa2hg526kq7rpg084e3', 0x[encoded data, 10708 characters], '2017-06-30 16:42:11', NULL, '1', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('637k2k0qreds24387rbhmnr3s0', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2232316563333261323234643633626265656666613839346532393638633661363031663361303335223b733a343a2274696d65223b693a313439393736303536333b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-07-12 10:09:23', NULL, '0', '82.202.120.247', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('6b2misn82spin4kmkmoetoplr7', 0x[encoded data, 10948 characters], '2017-07-26 12:51:38', NULL, '1', '46.135.99.32', 'Mozilla/5.0 (Linux; Android 7.1.2; Nexus 5X Build/N2G47Z) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36'),
('6col4tgbqi8icisdo42fvrpum4', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2235316164353764346337623164313262626562316131366433393330613939646336396439376366223b733a343a2274696d65223b693a313530313236373638333b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3433223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-07-29 20:48:03', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('6mubb80uqjrgaompiuljl3q2j1', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2264636139353463316538346361666333316163363864336139633363396662666237656235323462223b733a343a2274696d65223b693a313439363132383132333b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-05-31 09:08:43', NULL, '0', '147.32.209.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('6o81jfe8fhgs39go903l3fijm7', 0x[encoded data, 10964 characters], '2017-06-13 14:18:33', NULL, '1', '147.32.218.26', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36');
INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('7mmva9u6qgbm28d3rpbp7n6gp5', 0x[encoded data, 10720 characters], '2017-08-09 09:07:18', NULL, '1', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('7slulebf3g5srinrj94kmn2oi6', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2237636230333564646361326239306665633732626138306564313265373430353339366432383166223b733a343a2274696d65223b693a313439393834303437373b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3430223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b613a323a7b733a323a226964223b693a313b733a333a226b6579223b733a31313a226c6f63616c3a68616a656b223b7d7d3a746f6b656e7c613a313a7b733a353a227374616666223b733a37363a2263666161613139623530636464376531333539653637303864363965306131633a313439393834303437353a3235393562643164303235336333613530393239646464646530386165313062223b7d6366673a636f72657c613a313a7b733a31313a2264625f74696d657a6f6e65223b733a31333a224575726f70652f4265726c696e223b7d6c61737463726f6e63616c6c7c693a313439393834303437373b, '2017-07-13 08:21:17', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('89thh50p5b3mlci5s006gbif46', 0x[encoded data, 10924 characters], '2017-07-18 15:14:01', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('8dd1iaqms1r16dq3nusgakrtk2', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2237313339373034656632366561646136316661616239366662636532643135646339323835323731223b733a343a2274696d65223b693a313439393737303936363b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3338223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b613a323a7b733a323a226964223b693a313b733a333a226b6579223b733a31313a226c6f63616c3a68616a656b223b7d7d3a746f6b656e7c613a313a7b733a353a227374616666223b733a37363a2236626566626535643538313331386664633330323262613833393131393763343a313439393737303936343a6538346134393338636562623935396364636439393230343962316462323539223b7d6366673a636f72657c613a313a7b733a31313a2264625f74696d657a6f6e65223b733a31333a224575726f70652f4265726c696e223b7d6c61737463726f6e63616c6c7c693a313439393737303936363b, '2017-07-12 13:02:46', NULL, '0', '147.32.219.165', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'),
('8dild5juhe9uhhgdgr6k8ubtn0', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2263356263376165303463626230393935653363316530616130616630383263646164663161626566223b733a343a2274696d65223b693a313439363531373335313b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-06-04 21:15:51', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('8n22pfv0g9rdmeb2ospebcd5r3', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2236646463663434356166313437653135643537333563393463363037386535386166626466333633223b733a343a2274696d65223b693a313439373337363835373b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32383a222f7363702f7469636b6574732e7068703f7374617475733d6f70656e223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-06-14 20:00:57', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('8ut2li2tqoj866vm21r35968e7', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2264363833316333383133666533303465613632653539316534356564363237373835386638353463223b733a343a2274696d65223b693a313439343138313439363b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3234223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-05-08 20:24:56', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.96 Safari/537.36'),
('95u67vb5e98v6t4au1laqsj342', 0x[encoded data, 15474 characters], '2017-03-23 17:10:07', NULL, '1', '77.87.240.6', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36'),
('976v61puev7o36jhlb5laecoh7', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2237663063633365646362396132623338303331383761373263666335663664313839336137616436223b733a343a2274696d65223b693a313439363030353331363b7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3136223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-05-29 23:01:56', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36');
INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('9eae487tffjqf2s3jrs3bhepa0', 0x[encoded data, 10948 characters], '2017-07-14 16:58:25', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('9h5sndt2tjmembfcngbju0u991', 0x[encoded data, 11498 characters], '2017-04-05 17:50:28', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0'),
('9mjb48ov4n9smfjdf9ue6qjnt3', 0x[encoded data, 10954 characters], '2017-03-30 09:25:21', NULL, '1', '77.87.240.6', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36'),
('a6d826m8bujqeaqgdgs5rqsc37', 0x[encoded data, 10924 characters], '2017-07-01 10:05:33', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('aakt4130s57fsseek930osiib4', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2265393339323164343064356362326665393436626334336465623839333134366538303837313938223b733a343a2274696d65223b693a313530313434313332373b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-07-31 21:02:07', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36');
INSERT INTO `ost_session` (`session_id`, `session_data`, `session_expire`, `session_updated`, `user_id`, `user_ip`, `user_agent`) VALUES
('adg58b9vg2th6rgqioc99jh2s7', 0x[encoded data, 10946 characters], '2017-03-23 16:14:58', NULL, '0', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0'),
('aud4tdum9jbtupecjumneio0k7', 0x[encoded data, 10984 characters], '2017-05-06 14:23:40', NULL, '2', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0'),
('b5l4q4nhmuj34l6f8lu56t3403', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2263326634303366343339393334653165303165646332323666356232313938343831363564363736223b733a343a2274696d65223b693a313530303938383233323b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-07-26 15:10:32', NULL, '0', '82.202.120.247', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('b77d2fokc0tqrobirbk2hv1nu4', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2237376131363064646563636231633438383364383266643631363664316537383664313937633164223b733a343a2274696d65223b693a313439343235393639373b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-05-09 18:08:17', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.96 Safari/537.36'),
('baeqkju32gac3evjmnof2fn2b4', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2239313637393066663638353763386139363666303630363633383462653739333563623564376534223b733a343a2274696d65223b693a313439343531313731303b7d5f617574687c613a313a7b733a353a227374616666223b4e3b7d, '2017-05-12 16:08:30', NULL, '0', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),
('bbj5ljudh8uglkue1n38v5mog4', 0x[encoded data, 10948 characters], '2017-07-12 09:47:39', NULL, '0', '77.48.51.122', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('bd9nvdtu5hf8dcl4rlo8pum1k5', 0x637372667c613a323a7b733a353a22746f6b656e223b733a34303a2237636438353961363361633934663636636334626135646361356230363134636333343865333066223b733a343a2274696d65223b693a313530303938353832303b7d5f617574687c613a313a7b733a353a227374616666223b613a323a7b733a323a226964223b693a333b733a333a226b6579223b733a31313a226c6f63616c3a616c656e61223b7d7d5f73746166667c613a313a7b733a343a2261757468223b613a323a7b733a343a2264657374223b733a32323a222f7363702f7469636b6574732e7068703f69643d3533223b733a333a226d7367223b733a32373a225679c5be61646f76c3a16e6f2070c59969686cc3a1c5a1656ec3ad223b7d7d3a746f6b656e7c613a313a7b733a353a227374616666223b733a37363a2263363465326337626663383438313437353566653537366639363834323930353a313530303938353830393a6435616635353735396164393637393861663661663537376337316165313439223b7d6366673a636f72657c613a313a7b733a31313a2264625f74696d657a6f6e65223b733a31333a224575726f70652f4265726c696e223b7d6c61737463726f6e63616c6c7c693a313530303938353832303b, '2017-07-26 14:30:20', NULL, '0', '82.202.120.247', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0'),
('bjephclho3q6avlfl7ud1vb4m5', 0x[encoded data, 10936 characters], '2017-08-11 10:17:44', NULL, '1', '94.143.173.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36');
