<?xml version="1.0" encoding="utf-8"?>
<!--
- phpMyAdmin XML Dump
- version 4.5.4.1deb2ubuntu2.1
- https://www.phpmyadmin.net
-
- Servidor: localhost
- Tiempo de generación: 29-04-2021 a las 16:24:28
- Versión del servidor: 5.7.33-0ubuntu0.16.04.1
- Versión de PHP: 7.1.33-34+ubuntu16.04.1+deb.sury.org+1
-->
<pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
<!--
- Structure schemas
-->
<pma:structure_schemas>
<pma:database name="hesk" collation="utf8_general_ci" charset="utf8">
<pma:table name="hesk_tickets">
CREATE TABLE `hesk_tickets` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`trackid` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`category` smallint(5) unsigned NOT NULL DEFAULT '1',
`priority` enum('0','1','2','3') COLLATE utf8_unicode_ci NOT NULL DEFAULT '3',
`subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`message_html` mediumtext COLLATE utf8_unicode_ci,
`dt` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
`lastchange` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`firstreply` timestamp NULL DEFAULT NULL,
`closedat` timestamp NULL DEFAULT NULL,
`articles` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ip` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`language` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` tinyint(3) unsigned NOT NULL DEFAULT '0',
`openedby` mediumint(8) DEFAULT '0',
`firstreplyby` smallint(5) unsigned DEFAULT NULL,
`closedby` mediumint(8) DEFAULT NULL,
`replies` smallint(5) unsigned NOT NULL DEFAULT '0',
`staffreplies` smallint(5) unsigned NOT NULL DEFAULT '0',
`owner` smallint(5) unsigned NOT NULL DEFAULT '0',
`assignedby` mediumint(9) DEFAULT NULL,
`time_worked` time NOT NULL DEFAULT '00:00:00',
`lastreplier` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`replierid` smallint(5) unsigned DEFAULT NULL,
`archive` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`locked` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`attachments` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`merged` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`history` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom1` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom2` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom3` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom4` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom5` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom6` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom7` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom8` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom9` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom10` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom11` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom12` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom13` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom14` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom15` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom16` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom17` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom18` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom19` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom20` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`parent` mediumint(8) DEFAULT NULL,
`custom21` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom22` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom23` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom24` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom25` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom26` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom27` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom28` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom29` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom30` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom31` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom32` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom33` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom34` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom35` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom36` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom37` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom38` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom39` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom40` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom41` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom42` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom43` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom44` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom45` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom46` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom47` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom48` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom49` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`custom50` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`latitude` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'E-0',
`longitude` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'E-0',
`html` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`user_agent` text COLLATE utf8_unicode_ci,
`screen_resolution_width` int(11) DEFAULT NULL,
`screen_resolution_height` int(11) DEFAULT NULL,
`due_date` datetime DEFAULT NULL,
`overdue_email_sent` enum('0','1') COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `trackid` (`trackid`),
KEY `archive` (`archive`),
KEY `categories` (`category`),
KEY `owner` (`owner`),
KEY `openedby` (`openedby`,`firstreplyby`,`closedby`),
KEY `dt` (`dt`),
KEY `statuses` (`status`),
KEY `assignedby` (`assignedby`)
) ENGINE=MyISAM AUTO_INCREMENT=5393 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
</pma:table>
</pma:database>
</pma:structure_schemas>
</pma_xml_export>