/*
SQLyog Ultimate v8.71 
MySQL - 5.0.95 : Database - efnsop_es
*********************************************************************
*/




CREATE DATABASE /*!32312 IF NOT EXISTS*/`efnsop_es` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `efnsop_es`;

/*Table structure for table `ost_canned_attachment` */


CREATE TABLE `ost_canned_attachment` (
  `canned_id` int(10) unsigned NOT NULL,
  `file_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`canned_id`,`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_canned_attachment` */

/*Table structure for table `ost_canned_response` */


CREATE TABLE `ost_canned_response` (
  `canned_id` int(10) unsigned NOT NULL auto_increment,
  `dept_id` int(10) unsigned NOT NULL default '0',
  `isenabled` tinyint(1) unsigned NOT NULL default '1',
  `title` varchar(255) NOT NULL default '',
  `response` text NOT NULL,
  `notes` text NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`canned_id`),
  UNIQUE KEY `title_2` (`title`),
  KEY `dept_id` (`dept_id`),
  KEY `active` (`isenabled`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `ost_canned_response` */

insert  into `ost_canned_response`(`canned_id`,`dept_id`,`isenabled`,`title`,`response`,`notes`,`created`,`updated`) values (1,0,1,'Que es esta herramienta?','Es un sistema de tickets utilizado ampliamente como una alternativa atractiva a complejos sistemas de soporte al cliente, Simple, ligero, confiable, basado en la web y facil de configurar y usar .','','2014-08-20 07:48:03','2014-08-21 00:30:44'),(2,0,1,'Ejemplo (con variables)','\r\n%{ticket.name},\r\n\r\nTu ticket #%{ticket.number} creado el %{ticket.create_date} esta en el departamento %{ticket.dept.name} .\r\n\r\n','','2014-08-20 07:48:03','2014-08-20 07:48:03');

/*Table structure for table `ost_department` */


CREATE TABLE `ost_department` (
  `dept_id` int(11) unsigned NOT NULL auto_increment,
  `tpl_id` int(10) unsigned NOT NULL default '0',
  `email_id` int(10) unsigned NOT NULL default '0',
  `autoresp_email_id` int(10) unsigned NOT NULL default '0',
  `manager_id` int(10) unsigned NOT NULL default '0',
  `dept_name` varchar(32) NOT NULL default '',
  `dept_signature` text NOT NULL,
  `ispublic` tinyint(1) unsigned NOT NULL default '1',
  `ticket_auto_response` tinyint(1) NOT NULL default '1',
  `message_auto_response` tinyint(1) NOT NULL default '0',
  `can_append_signature` tinyint(1) NOT NULL default '1',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`dept_id`),
  UNIQUE KEY `dept_name` (`dept_name`),
  KEY `manager_id` (`manager_id`),
  KEY `autoresp_email_id` (`autoresp_email_id`),
  KEY `tpl_id` (`tpl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `ost_department` */

insert  into `ost_department`(`dept_id`,`tpl_id`,`email_id`,`autoresp_email_id`,`manager_id`,`dept_name`,`dept_signature`,`ispublic`,`ticket_auto_response`,`message_auto_response`,`can_append_signature`,`updated`,`created`) values (1,0,1,0,0,'Soporte','Dpto de Soporte',1,1,1,1,'2014-08-20 07:48:03','2014-08-20 07:48:03'),(2,0,1,0,0,'Facturacion','Dpto de Facturacion ',1,1,1,1,'2014-08-20 07:48:03','2014-08-20 07:48:03');

/*Table structure for table `ost_email_banlist` */


CREATE TABLE `ost_email_banlist` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `submitter` varchar(126) NOT NULL default '',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `ost_email_banlist` */

insert  into `ost_email_banlist`(`id`,`email`,`submitter`,`added`) values (1,'test@example.com','System','2014-08-20 07:48:03');

/*Table structure for table `ost_email_template` */


CREATE TABLE `ost_email_template` (
  `tpl_id` int(11) NOT NULL auto_increment,
  `cfg_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(32) NOT NULL default '',
  `notes` text,
  `ticket_autoresp_subj` varchar(255) NOT NULL default '',
  `ticket_autoresp_body` text NOT NULL,
  `ticket_notice_subj` varchar(255) NOT NULL,
  `ticket_notice_body` text NOT NULL,
  `ticket_alert_subj` varchar(255) NOT NULL default '',
  `ticket_alert_body` text NOT NULL,
  `message_autoresp_subj` varchar(255) NOT NULL default '',
  `message_autoresp_body` text NOT NULL,
  `message_alert_subj` varchar(255) NOT NULL default '',
  `message_alert_body` text NOT NULL,
  `note_alert_subj` varchar(255) NOT NULL,
  `note_alert_body` text NOT NULL,
  `assigned_alert_subj` varchar(255) NOT NULL default '',
  `assigned_alert_body` text NOT NULL,
  `ticket_overdue_subj` varchar(255) NOT NULL default '',
  `ticket_overdue_body` text NOT NULL,
  `ticket_overlimit_subj` varchar(255) NOT NULL default '',
  `ticket_overlimit_body` text NOT NULL,
  `ticket_reply_subj` varchar(255) NOT NULL default '',
  `ticket_reply_body` text NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tpl_id`),
  KEY `cfg_id` (`cfg_id`),
  FULLTEXT KEY `message_subj` (`ticket_reply_subj`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `ost_email_template` */

insert  into `ost_email_template`(`tpl_id`,`cfg_id`,`name`,`notes`,`ticket_autoresp_subj`,`ticket_autoresp_body`,`ticket_notice_subj`,`ticket_notice_body`,`ticket_alert_subj`,`ticket_alert_body`,`message_autoresp_subj`,`message_autoresp_body`,`message_alert_subj`,`message_alert_body`,`note_alert_subj`,`note_alert_body`,`assigned_alert_subj`,`assigned_alert_body`,`ticket_overdue_subj`,`ticket_overdue_body`,`ticket_overlimit_subj`,`ticket_overlimit_body`,`ticket_reply_subj`,`ticket_reply_body`,`created`,`updated`) values (1,1,'Plantilla por defecto','Plantillas por defecto','Ticket Abierto [#%ticket]','%name,\r\n\r\nLa consulta ha sido recibida y tiene asignado el siguiente ID #%ticket. Uno de nuestros representates respondera a tu solicitud entre 24 y 72 horas.\r\n\r\nPuedes consultar el progreso de tu ticket en linea desde este enlace: %url/view.php?e=%email&t=%ticket.\r\n\r\nSi deseas enviar comentarios o informacion adicional sobre este tema, por favor, no abras un ticket nuevo. Simplemente ingresa a traves del enlace anterior y actualiza el ticket.\r\n\r\n%signature','[#%ticket] %subject','%name,\r\n\r\nNuestro equipo de atencion al usuario ha respondido tu ticket, #%ticket con el siguiente mensaje.\r\n\r\n%message\r\n\r\nSi deseas hacernos llegar informacion adicional sobre este tema, por favor, no abras un ticket nuevo. Puedes actualizar o ver en linea el progreso de este ticket en: %url/view.php?e=%email&t=%ticket.\r\n\r\n%signature','Alerta de Ticket Nuevo','%staff,\r\n\r\nNuevo Ticket #%ticket creado.\r\n-------------------\r\nNombre: %name\r\nEmail: %email\r\nDpto: %dept\r\n\r\n%message\r\n-------------------\r\n\r\nPara ver o responder a este ticket, por favor ingresa al sistema de soporte.\r\n\r\n- Tu sistema de soporte amigable - potenciado por osTicket.','[#%ticket] Mensaje Recibido','%name,\r\n\r\nTu respuesta a la consulta de soporte #%ticket se ha recibido.\r\n\r\nPuedes ver el progreso de tu ticket en linea desde: %url/view.php?e=%email&t=%ticket.\r\n\r\n%signature','Alerta de Nuevo Mensaje','%staff,\r\n\r\nHa recibido un mensaje para el ticket #%ticket\r\n\r\n----------------------\r\nNombre: %name\r\nEmail: %email\r\nDpto: %dept\r\n\r\n%message\r\n-------------------\r\n\r\nPara ver o responder a este ticket, por favor ingresa al sistema de soporte .\r\n\r\n- Tu sistema de soporte amigable - potenciado por osTicket.','Alerta de nueva nota interna','%staff,\r\n\r\nNota interna recibida para el ticket #%ticket\r\n\r\n----------------------\r\nNombre: %name\r\n\r\n%note\r\n-------------------\r\n\r\nPara ver o responder a este ticket, por favor ingresa al sistema de soporte.\r\n\r\n- Tu sistema de soporte amigable - potenciado por osTicket.','Ticket #%ticket Asignado a ti','%assignee,\r\n\r\n%assigner te a asignado el ticket #%ticket a ti!\r\n\r\n%message\r\n\r\nPara ver o responder a este ticket, por favor ingresa al sistema de soporte .\r\n\r\n- Tu sistema de soporte amigable - potenciado por osTicket.','Alerta de ticket vencido','%staff,\r\n\r\nEl ticket, #%ticket asignado a ti o tu departamento se a vencido.\r\n\r\n%url/scp/tickets.php?id=%id\r\n\r\nTodos debemos trabajar duro para garantizar que todos los tickets se estan abordando de manera oportuna. Por favor, resuelve el problema asi no recibira otro mensaje como este.\r\n\r\n\r\n- Tu sistema de soporte amigable (aunque con un grado de paciencia) - potenciado por osTicket.','Ticket Denegado','%name\r\n\r\nNo se ha creado el ticket de ayuda . Has superado el numero maximo de tickets permitido.\r\n\r\nSe trata de un bloqueo temporal. Para poder abrir otro ticket, una de tus consultas pendientes debe estar cerrada. Para actualizar o agregar comentarios a un ticket abierto, simplemente ingresa a traves del siguiente enlace.\r\n\r\n%url/view.php?e=%email\r\n\r\nGracias.\r\n\r\nEl sistema de soporte','[#%ticket] %subject','%name,\r\n\r\nUn miembro del personal de atencion al Usuario ha respondido tu consulta con el ID, #%ticket on la siguiente respuesta:\r\n\r\n%response\r\n\r\nEsperamos que esta respuesta haya solucionado tu pregunta. Si no, por favor, accede a tu cuenta para responder o crear un ticket nuevo.\r\n\r\n%url/view.php?e=%email&t=%ticket\r\n\r\n%signature','2014-08-20 07:48:03','2017-08-07 15:32:31');

/*Table structure for table `ost_email_template_group` */


CREATE TABLE `ost_email_template_group` (
  `tpl_id` int(11) NOT NULL auto_increment,
  `isactive` tinyint(1) unsigned NOT NULL default '0',
  `name` varchar(32) NOT NULL default '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`tpl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `ost_email_template_group` */

insert  into `ost_email_template_group`(`tpl_id`,`isactive`,`name`,`notes`,`created`,`updated`) values (1,1,'Plantilla por defecto','Plantillas por defecto','2014-08-20 07:48:03','2017-08-07 17:38:55');

/*Table structure for table `ost_faq` */


CREATE TABLE `ost_faq` (
  `faq_id` int(10) unsigned NOT NULL auto_increment,
  `category_id` int(10) unsigned NOT NULL default '0',
  `ispublished` tinyint(1) unsigned NOT NULL default '0',
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  `keywords` tinytext,
  `notes` text,
  `created` date NOT NULL,
  `updated` date NOT NULL,
  PRIMARY KEY  (`faq_id`),
  UNIQUE KEY `question` (`question`),
  KEY `category_id` (`category_id`),
  KEY `ispublished` (`ispublished`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_faq` */

/*Table structure for table `ost_faq_attachment` */


CREATE TABLE `ost_faq_attachment` (
  `faq_id` int(10) unsigned NOT NULL,
  `file_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`faq_id`,`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_faq_attachment` */

/*Table structure for table `ost_faq_category` */


CREATE TABLE `ost_faq_category` (
  `category_id` int(10) unsigned NOT NULL auto_increment,
  `ispublic` tinyint(1) unsigned NOT NULL default '0',
  `name` varchar(125) default NULL,
  `description` text NOT NULL,
  `notes` tinytext NOT NULL,
  `created` date NOT NULL,
  `updated` date NOT NULL,
  PRIMARY KEY  (`category_id`),
  KEY `ispublic` (`ispublic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_faq_category` */

/*Table structure for table `ost_faq_topic` */


CREATE TABLE `ost_faq_topic` (
  `faq_id` int(10) unsigned NOT NULL,
  `topic_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`faq_id`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_file` */

/*Table structure for table `ost_file_chunk` */


CREATE TABLE `ost_file_chunk` (
  `file_id` int(11) NOT NULL,
  `chunk_id` int(11) NOT NULL,
  `filedata` longblob NOT NULL,
  PRIMARY KEY  (`file_id`,`chunk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_file_chunk` */

/*Table structure for table `ost_filter` */


CREATE TABLE `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',
  `match_all_rules` tinyint(1) unsigned NOT NULL default '0',
  `stop_onmatch` tinyint(1) unsigned NOT NULL default '0',
  `reject_ticket` tinyint(1) unsigned NOT NULL default '0',
  `use_replyto_email` tinyint(1) unsigned NOT NULL default '0',
  `disable_autoresponder` tinyint(1) unsigned NOT NULL default '0',
  `canned_response_id` int(11) unsigned NOT NULL default '0',
  `email_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',
  `target` enum('Any','Web','Email','API') NOT NULL default 'Any',
  `name` varchar(32) NOT NULL default '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `email_id` (`email_id`),
  KEY `target` (`target`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `ost_filter` */

insert  into `ost_filter`(`id`,`execorder`,`isactive`,`match_all_rules`,`stop_onmatch`,`reject_ticket`,`use_replyto_email`,`disable_autoresponder`,`canned_response_id`,`email_id`,`priority_id`,`dept_id`,`staff_id`,`team_id`,`sla_id`,`target`,`name`,`notes`,`created`,`updated`) values (1,99,1,0,1,1,1,1,0,0,0,0,0,0,0,'Any','SYSTEM BAN LIST','Internal list for email banning. Do not remove','0000-00-00 00:00:00','0000-00-00 00:00:00');

/*Table structure for table `ost_filter_rule` */


CREATE TABLE `ost_filter_rule` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `filter_id` int(10) unsigned NOT NULL default '0',
  `what` enum('name','email','subject','body','header') NOT NULL,
  `how` enum('equal','not_equal','contains','dn_contain','starts','ends') default 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=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `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,'','0000-00-00 00:00:00','0000-00-00 00:00:00');

/*Table structure for table `ost_group_dept_access` */


CREATE TABLE `ost_group_dept_access` (
  `group_id` int(10) unsigned NOT NULL default '0',
  `dept_id` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `group_dept` (`group_id`,`dept_id`),
  KEY `dept_id` (`dept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_group_dept_access` */

insert  into `ost_group_dept_access`(`group_id`,`dept_id`) values (1,1),(2,1),(3,1);

/*Table structure for table `ost_groups` */


CREATE TABLE `ost_groups` (
  `group_id` int(10) unsigned NOT NULL auto_increment,
  `group_enabled` tinyint(1) unsigned NOT NULL default '1',
  `group_name` varchar(50) NOT NULL default '',
  `dept_access` varchar(255) NOT NULL default '',
  `can_create_tickets` tinyint(1) unsigned NOT NULL default '1',
  `can_edit_tickets` tinyint(1) unsigned NOT NULL default '1',
  `can_delete_tickets` tinyint(1) unsigned NOT NULL default '0',
  `can_close_tickets` tinyint(1) unsigned NOT NULL default '0',
  `can_transfer_tickets` tinyint(1) unsigned NOT NULL default '1',
  `can_ban_emails` tinyint(1) unsigned NOT NULL default '0',
  `can_manage_kb` tinyint(1) unsigned NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`group_id`),
  KEY `group_active` (`group_enabled`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `ost_groups` */

insert  into `ost_groups`(`group_id`,`group_enabled`,`group_name`,`dept_access`,`can_create_tickets`,`can_edit_tickets`,`can_delete_tickets`,`can_close_tickets`,`can_transfer_tickets`,`can_ban_emails`,`can_manage_kb`,`created`,`updated`) values (1,1,'Administradores','1',1,1,1,1,1,1,1,'2014-08-20 07:48:03','2014-08-20 07:48:03'),(2,1,'Jefes de Departamento','1',1,1,0,1,1,1,1,'2014-08-20 07:48:03','2014-08-20 07:48:03'),(3,1,'Miembros del Staff','1',1,0,0,0,0,0,0,'2014-08-20 07:48:03','2014-08-20 07:48:03');

/*Table structure for table `ost_help_topic` */


CREATE TABLE `ost_help_topic` (
  `topic_id` int(11) unsigned NOT NULL auto_increment,
  `isactive` tinyint(1) unsigned NOT NULL default '1',
  `noautoresp` tinyint(3) unsigned NOT NULL default '0',
  `priority_id` tinyint(3) unsigned NOT NULL default '0',
  `dept_id` tinyint(3) unsigned NOT NULL default '0',
  `topic` varchar(32) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`topic_id`),
  UNIQUE KEY `topic` (`topic`),
  KEY `priority_id` (`priority_id`),
  KEY `dept_id` (`dept_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `ost_help_topic` */

insert  into `ost_help_topic`(`topic_id`,`isactive`,`noautoresp`,`priority_id`,`dept_id`,`topic`,`created`,`updated`) values (1,1,0,2,1,'Soporte','2014-08-20 07:48:03','2014-08-20 07:48:03'),(2,1,0,3,1,'Facturacion','2014-08-20 07:48:03','2014-08-20 07:48:03');

/*Table structure for table `ost_kb_premade` */


CREATE TABLE `ost_kb_premade` (
  `premade_id` int(10) unsigned NOT NULL auto_increment,
  `dept_id` int(10) unsigned NOT NULL default '0',
  `isenabled` tinyint(1) unsigned NOT NULL default '1',
  `title` varchar(125) NOT NULL default '',
  `answer` text NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`premade_id`),
  UNIQUE KEY `title_2` (`title`),
  KEY `dept_id` (`dept_id`),
  KEY `active` (`isenabled`),
  FULLTEXT KEY `title` (`title`,`answer`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `ost_kb_premade` */

insert  into `ost_kb_premade`(`premade_id`,`dept_id`,`isenabled`,`title`,`answer`,`created`,`updated`) values (1,0,1,'Que es esta herramienta?','Es un sistema de tickets utilizado ampliamente como una alternativa atractiva a complejos sistemas de soporte al cliente, Simple, ligero, confiable, basado en la web y facil de configurar y usar .','2014-08-20 07:48:03','2014-08-21 00:30:44'),(2,0,1,'Ejemplo (con variables)','\r\n%name,\r\n\r\nTu ticket #%ticket creado el %createdate esta en el departamento %dept .\r\n\r\n','2014-08-20 07:48:03','2014-08-20 07:48:03');

/*Table structure for table `ost_page` */


CREATE TABLE `ost_page` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `isactive` tinyint(1) unsigned NOT NULL default '0',
  `type` enum('landing','offline','thank-you','other') NOT NULL default 'other',
  `name` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `ost_page` */

insert  into `ost_page`(`id`,`isactive`,`type`,`name`,`body`,`notes`,`created`,`updated`) values (1,1,'offline','Offline','<div>\r\n<h1><span style=\"font-size: medium\">Support Ticket System Offline</span></h1>\r\n<p>Thank you for your interest in contacting us.</p>\r\n<p>Our helpdesk is offline at the moment, please check back at a later time.</p>\r\n</div>','Default offline page','2017-08-07 17:38:57','2017-08-07 17:38:57'),(2,1,'thank-you','Thank you','<div>%{ticket.name},<br />\r\n    \r\n<p>\r\nThank you for contacting us.</p><p> A support ticket request #%{ticket.number} has been created and a representative will be getting back to you shortly if necessary.</p>\r\n          \r\n<p>Support Team </p>\r\n</div>','Default \"thank you\" page displayed after the end-user creates a web ticket.','2017-08-07 17:38:57','2017-08-07 17:38:57'),(3,1,'landing','Landing','<h1>Welcome to the Support Center</h1>\r\n<p>In order to streamline support requests and better serve you, we utilize a support ticket system. Every support request is assigned a unique ticket number which you can use to track the progress and responses online. For your reference we provide complete archives and history of all your support requests. A valid email address is required to submit a ticket.\r\n</p>\r\n','Introduction text on the landing page.','2017-08-07 17:38:57','2017-08-07 17:38:57');

/*Table structure for table `ost_reports` */


CREATE TABLE `ost_reports` (
  `3d` tinyint(4) NOT NULL,
  `graphWidth` int(11) NOT NULL,
  `graphHeight` int(11) NOT NULL,
  `resolution` varchar(255) NOT NULL,
  `viewable` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `ost_reports` */

insert  into `ost_reports`(`3d`,`graphWidth`,`graphHeight`,`resolution`,`viewable`) values (1,400,240,'hours','managers');

/*Table structure for table `ost_sla` */


CREATE TABLE `ost_sla` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `isactive` tinyint(1) unsigned NOT NULL default '1',
  `enable_priority_escalation` tinyint(1) unsigned NOT NULL default '1',
  `disable_overdue_alerts` tinyint(1) unsigned NOT NULL default '0',
  `grace_period` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `ost_sla` */

insert  into `ost_sla`(`id`,`isactive`,`enable_priority_escalation`,`disable_overdue_alerts`,`grace_period`,`name`,`notes`,`created`,`updated`) values (1,1,1,0,48,'Default SLA',NULL,'2017-08-07 17:38:55','2017-08-07 17:38:55');

/*Table structure for table `ost_syslog` */


CREATE TABLE `ost_syslog` (
  `log_id` int(11) unsigned NOT NULL auto_increment,
  `log_type` enum('Depurar','Advertencia','Error') NOT NULL,
  `title` varchar(255) NOT NULL,
  `log` text NOT NULL,
  `logger` varchar(64) NOT NULL,
  `ip_address` varchar(16) NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`log_id`),
  KEY `log_type` (`log_type`)
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=utf8;

/*Data for the table `ost_syslog` */

insert  into `ost_syslog`(`log_id`,`log_type`,`title`,`log`,`logger`,`ip_address`,`created`,`updated`) values (81,'Error','DB Error #1064','[SELECT * FROM ost_ticket WHERE staff_id = <?=$rowtotalstaff[\'staff_id\']?> AND (7 >= TIMESTAMPDIFF(DAY,created,NOW()) AND 3 < TIMESTAMPDIFF(DAY,created,NOW())) AND status = \"open\"]\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'<?=$rowtotalstaff[\'staff_id\']?> AND (7 >= TIMESTAMPDIFF(DAY,created,NOW()) AND 3\' at line 1','','192.168.1.30','2017-08-07 16:50:50','2017-08-07 16:50:50'),(80,'Error','DB Error #1064','[SELECT * FROM ost_ticket WHERE staff_id <> \"0\" AND 3 >= TIMESTAMPDIFF(DAY,created,NOW()) AND status = \"open\" and staff_id = <?=$rowtotalstaff[\'staff_id\']?>]\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'<?=$rowtotalstaff[\'staff_id\']?>\' at line 1','','192.168.1.30','2017-08-07 16:50:50','2017-08-07 16:50:50'),(79,'Error','DB Error #1064','[SELECT * FROM ost_ticket WHERE staff_id = <?=$rowtotalstaff[\'staff_id\']?> AND status = \"open\"]\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'<?=$rowtotalstaff[\'staff_id\']?> AND status = \"open\"\' at line 1','','192.168.1.30','2017-08-07 16:50:50','2017-08-07 16:50:50'),(82,'Error','DB Error #1064','[SELECT * FROM ost_ticket WHERE staff_id = <?=$rowtotalstaff[\'staff_id\']?> AND (14 >= TIMESTAMPDIFF(DAY,created,NOW()) AND 7 < TIMESTAMPDIFF(DAY,created,NOW())) AND status = \"open\"]\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'<?=$rowtotalstaff[\'staff_id\']?> AND (14 >= TIMESTAMPDIFF(DAY,created,NOW()) AND \' at line 1','','192.168.1.30','2017-08-07 16:50:50','2017-08-07 16:50:50'),(83,'Error','DB Error #1064','[SELECT * FROM ost_ticket WHERE staff_id = <?=$rowtotalstaff[\'staff_id\']?> AND 14 < TIMESTAMPDIFF(DAY,created,NOW()) AND status = \"open\"]\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'<?=$rowtotalstaff[\'staff_id\']?> AND 14 < TIMESTAMPDIFF(DAY,created,NOW()) AND st\' at line 1','','192.168.1.30','2017-08-07 16:50:50','2017-08-07 16:50:50'),(84,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.197.190\nHora: Mar 29, 2021, 2:25 pm PET\n\nIntentos #2','','179.6.197.190','2021-03-29 14:25:43','2021-03-29 14:25:43'),(85,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez@effinet.com.pe\nIP: 179.6.197.190\nHora: Mar 29, 2021, 2:26 pm PET\n\nIntentos #4','','179.6.197.190','2021-03-29 14:26:33','2021-03-29 14:26:33'),(86,'Error','Excesivos intentos de conexi&oacute;n (Miembro del Staff)','&iquest;Excesivos intentos de conexión por un miembro del personal?\nNombre de usuario: soporte@effinet.com.pe\nIP: 179.6.197.190\nTIME: Mar 29, 2021, 2:26 pm PET\n\nIntentos #5\nTiempo de espera: 2 Minutos \n\n','','179.6.197.190','2021-03-29 14:26:43','2021-03-29 14:26:43'),(87,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.197.190\nHora: Mar 29, 2021, 3:32 pm PET\n\nIntentos #2','','179.6.197.190','2021-03-29 15:32:04','2021-03-29 15:32:04'),(88,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.197.190\nHora: Mar 29, 2021, 3:33 pm PET\n\nIntentos #4','','179.6.197.190','2021-03-29 15:33:08','2021-03-29 15:33:08'),(89,'Error','Excesivos intentos de conexi&oacute;n (Miembro del Staff)','&iquest;Excesivos intentos de conexión por un miembro del personal?\nNombre de usuario: ilopez\nIP: 179.6.197.190\nTIME: Mar 29, 2021, 3:33 pm PET\n\nIntentos #5\nTiempo de espera: 2 Minutos \n\n','','179.6.197.190','2021-03-29 15:33:17','2021-03-29 15:33:17'),(90,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.16.233\nHora: May 17, 2023, 11:50 am PET\n\nIntentos #2','','179.6.16.233','2023-05-17 11:50:54','2023-05-17 11:50:54'),(91,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.16.233\nHora: May 17, 2023, 11:51 am PET\n\nIntentos #4','','179.6.16.233','2023-05-17 11:51:25','2023-05-17 11:51:25'),(92,'Error','Error SMTP','No se puede enviar correo electr&oacute;nico a trav&eacute;s de 192.168.1.222:25 [glopez@effinet.com.pe]\n\nFailed to connect to 192.168.1.222:25 [SMTP: Invalid response code received from server (code: -1, response: )]\n','','179.6.16.233','2023-05-17 11:52:34','2023-05-17 11:52:34'),(93,'Error','Excesivos intentos de conexi&oacute;n (Miembro del Staff)','&iquest;Excesivos intentos de conexión por un miembro del personal?\nNombre de usuario: ilopez\nIP: 179.6.16.233\nTIME: May 17, 2023, 11:51 am PET\n\nIntentos #5\nTiempo de espera: 2 Minutos \n\n','','179.6.16.233','2023-05-17 11:52:34','2023-05-17 11:52:34'),(94,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.16.233\nHora: May 17, 2023, 11:53 am PET\n\nIntentos #2','','179.6.16.233','2023-05-17 11:53:35','2023-05-17 11:53:35'),(95,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.16.233\nHora: May 17, 2023, 11:53 am PET\n\nIntentos #4','','179.6.16.233','2023-05-17 11:53:35','2023-05-17 11:53:35'),(96,'Error','Error SMTP','No se puede enviar correo electr&oacute;nico a trav&eacute;s de 192.168.1.222:25 [glopez@effinet.com.pe]\n\nFailed to connect to 192.168.1.222:25 [SMTP: Invalid response code received from server (code: -1, response: )]\n','','179.6.16.233','2023-05-17 11:54:35','2023-05-17 11:54:35'),(97,'Error','Excesivos intentos de conexi&oacute;n (Miembro del Staff)','&iquest;Excesivos intentos de conexión por un miembro del personal?\nNombre de usuario: ilopez\nIP: 179.6.16.233\nTIME: May 17, 2023, 11:53 am PET\n\nIntentos #5\nTiempo de espera: 2 Minutos \n\n','','179.6.16.233','2023-05-17 11:54:35','2023-05-17 11:54:35'),(98,'','Intento de inicio de sesi&oacute;n fallido (Miembro del Staff)','Nombre de usuario: ilopez\nIP: 179.6.16.233\nHora: May 17, 2023, 11:55 am PET\n\nIntentos #2','','179.6.16.233','2023-05-17 11:55:35','2023-05-17 11:55:35');

/*Table structure for table `ost_team` */


CREATE TABLE `ost_team` (
  `team_id` int(10) unsigned NOT NULL auto_increment,
  `lead_id` int(10) unsigned NOT NULL default '0',
  `isenabled` tinyint(1) unsigned NOT NULL default '1',
  `noalerts` tinyint(1) unsigned NOT NULL default '0',
  `name` varchar(125) NOT NULL default '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY  (`team_id`),
  UNIQUE KEY `name` (`name`),
  KEY `isnabled` (`isenabled`),
  KEY `lead_id` (`lead_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `ost_team` */

insert  into `ost_team`(`team_id`,`lead_id`,`isenabled`,`noalerts`,`name`,`notes`,`created`,`updated`) values (1,0,1,0,'Level I Support','','2017-08-07 17:38:55','2017-08-07 17:38:55');

/*Table structure for table `ost_team_member` */


CREATE TABLE `ost_team_member` (
  `team_id` int(10) unsigned NOT NULL default '0',
  `staff_id` int(10) unsigned NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY  (`team_id`,`staff_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_team_member` */

/*Table structure for table `ost_ticket` */


CREATE TABLE `ost_ticket` (
  `ticket_id` int(11) unsigned NOT NULL auto_increment,
  `ticketID` int(11) unsigned NOT NULL default '0',
  `dept_id` int(10) unsigned NOT NULL default '1',
  `priority_id` int(10) unsigned NOT NULL default '2',
  `topic_id` int(10) unsigned NOT NULL default '0',
  `staff_id` int(10) unsigned NOT NULL default '0',
  `email` varchar(120) NOT NULL default '',
  `name` varchar(32) NOT NULL default '',
  `subject` varchar(64) NOT NULL default '[Sin Asunto]',
  `helptopic` varchar(255) default NULL,
  `phone` varchar(16) default NULL,
  `phone_ext` varchar(8) default NULL,
  `ip_address` varchar(16) NOT NULL default '',
  `status` enum('open','closed') NOT NULL default 'open',
  `source` enum('Web','Email','Telefono','Otro') NOT NULL default 'Otro',
  `isoverdue` tinyint(1) unsigned NOT NULL default '0',
  `isanswered` tinyint(1) unsigned NOT NULL default '0',
  `duedate` datetime default NULL,
  `reopened` datetime default NULL,
  `closed` datetime default NULL,
  `lastmessage` datetime default NULL,
  `lastresponse` datetime default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ticket_id`),
  UNIQUE KEY `email_extid` (`ticketID`,`email`),
  KEY `dept_id` (`dept_id`),
  KEY `staff_id` (`staff_id`),
  KEY `status` (`status`),
  KEY `priority_id` (`priority_id`),
  KEY `created` (`created`),
  KEY `closed` (`closed`),
  KEY `duedate` (`duedate`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket` */

insert  into `ost_ticket`(`ticket_id`,`ticketID`,`dept_id`,`priority_id`,`topic_id`,`staff_id`,`email`,`name`,`subject`,`helptopic`,`phone`,`phone_ext`,`ip_address`,`status`,`source`,`isoverdue`,`isanswered`,`duedate`,`reopened`,`closed`,`lastmessage`,`lastresponse`,`created`,`updated`) values (1,824498,1,2,0,1,'support@efnsop.com','Efn Support','Efn Instalado','Soporte Comercial',NULL,NULL,'','closed','Web',0,1,NULL,'2015-07-08 13:27:59','2015-07-08 16:36:46',NULL,'2015-07-08 16:36:46','2014-08-20 07:48:03','2015-07-08 16:36:46'),(18,432598,1,2,1,0,'jt@gmail.com','Julio Torres Zevallos','soporte','Soporte','3457823','101','192.168.1.125','open','Web',0,0,NULL,NULL,NULL,'2015-07-09 12:06:43',NULL,'2015-07-09 12:06:43','0000-00-00 00:00:00'),(4,875469,2,4,1,1,'mlopez@effinet.com.pe','test','urgencia','Soporte','3787878','333','192.168.1.50','closed','Email',0,1,NULL,NULL,'2015-07-08 16:57:27','2015-07-08 16:56:56','2015-07-08 16:57:27','2015-07-08 16:56:56','2015-07-08 16:57:27'),(21,886324,1,2,1,1,'g2squall@gmail.com','gabriel','prueba ticket','Soporte','44444444','223','192.168.1.30','open','',1,0,'2017-07-27 18:00:00',NULL,NULL,'2017-07-27 13:03:58','2017-07-27 13:03:58','2017-07-27 13:03:58','2017-07-27 18:00:32'),(32,321745,1,2,1,0,'jmunoz@effinet.com.pe','Joseph','sasdasd','Soporte','44444444','234','192.168.1.30','open','',1,1,'2017-08-07 20:45:00',NULL,NULL,'2017-08-07 14:47:37','2017-08-07 15:30:59','2017-08-07 14:47:37','2017-08-10 13:23:47'),(33,770733,1,2,1,1,'jmunoz@effinet.com.pe','Joseph','sdfsdf','Soporte','44444444','234','192.168.1.30','open','',1,1,'2017-08-07 18:30:00',NULL,NULL,'2017-08-07 14:49:55','2017-08-07 15:22:43','2017-08-07 14:49:55','2017-08-07 18:31:39'),(19,821237,2,2,0,1,'ray_thecure@hotmail.com','raymond','asterisk','','5830394','120','192.168.1.32','open','',0,0,NULL,NULL,NULL,'2015-10-05 18:10:26','2015-10-05 18:10:26','2015-10-05 18:10:26','2015-10-05 18:10:26'),(20,200694,1,2,1,0,'test@effinet.com.pe','Demo','falla telefono','Soporte','4338585','123','190.117.127.143','open','Web',0,0,NULL,NULL,NULL,'2016-03-04 11:33:58',NULL,'2016-03-04 11:33:58','0000-00-00 00:00:00'),(34,320008,1,2,1,1,'jmunoz@effinet.com.pe','Joseph','sdasdasd','Soporte','44444444','234','192.168.1.30','open','',1,1,'2017-08-07 17:45:00',NULL,NULL,'2017-08-07 14:50:59','2017-08-07 15:20:13','2017-08-07 14:50:59','2017-08-07 18:31:55'),(35,555515,1,2,1,1,'jmunoz@effinet.com.pe','Joseph','saed3e','Soporte','44444444','234','192.168.1.30','open','',1,1,'2017-08-07 17:45:00',NULL,NULL,'2017-08-07 14:51:40','2017-08-07 15:08:41','2017-08-07 14:51:40','2017-08-07 18:31:55'),(36,768965,1,3,1,1,'jmunoz@effinet.com.pe','Joseph','prueba','Soporte','44444444','234','192.168.1.30','open','',1,1,'2017-08-07 17:45:00',NULL,NULL,'2017-08-07 15:06:36','2017-08-07 15:07:29','2017-08-07 15:06:36','2017-08-07 18:31:55'),(31,836502,1,2,1,1,'jmunoz@effinet.com.pe','Joseph','sdasd','Soporte','44444444','234','192.168.1.30','open','',1,0,'2017-08-07 16:30:00',NULL,NULL,'2017-08-07 14:45:55','2017-08-07 14:45:55','2017-08-07 14:45:55','2017-08-07 16:31:47');

/*Table structure for table `ost_ticket_attachment` */


CREATE TABLE `ost_ticket_attachment` (
  `attach_id` int(11) unsigned NOT NULL auto_increment,
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `ref_id` int(11) unsigned NOT NULL default '0',
  `ref_type` enum('M','R') NOT NULL default 'M',
  `file_size` varchar(32) NOT NULL default '',
  `file_name` varchar(128) NOT NULL default '',
  `file_key` varchar(128) NOT NULL default '',
  `deleted` tinyint(1) unsigned NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime default NULL,
  PRIMARY KEY  (`attach_id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `ref_type` (`ref_type`),
  KEY `ref_id` (`ref_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_attachment` */

/*Table structure for table `ost_ticket_email_info` */


CREATE TABLE `ost_ticket_email_info` (
  `message_id` int(11) unsigned NOT NULL,
  `email_mid` varchar(255) NOT NULL,
  `headers` text,
  KEY `message_id` (`email_mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_email_info` */

insert  into `ost_ticket_email_info`(`message_id`,`email_mid`,`headers`) values (44,'<c3pFK4plzZX3yQLXuHuUKh2T@0678487f4b>',NULL),(45,'<9hFq0a16bYcikYrBjRiRAWOf@0678487f4b>',NULL),(46,'<9uCLYOXdnyu5amxgizW6um6G@0678487f4b>',NULL),(47,'<GrJo7SN8KSZkifScSSLkDQwQ@0678487f4b>',NULL),(48,'<8TMxnZX4Gzke5AADMj3eNxPs@0678487f4b>',NULL);

/*Table structure for table `ost_ticket_event` */


CREATE TABLE `ost_ticket_event` (
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `staff_id` int(11) unsigned NOT NULL,
  `team_id` int(11) unsigned NOT NULL,
  `dept_id` int(11) unsigned NOT NULL,
  `topic_id` int(11) unsigned NOT NULL,
  `state` enum('created','closed','reopened','assigned','transferred','overdue') NOT NULL,
  `staff` varchar(255) NOT NULL default 'SYSTEM',
  `annulled` tinyint(1) NOT NULL default '0',
  `timestamp` datetime NOT NULL,
  KEY `ticket_state` (`ticket_id`,`state`,`timestamp`),
  KEY `ticket_stats` (`timestamp`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_event` */

insert  into `ost_ticket_event`(`ticket_id`,`staff_id`,`team_id`,`dept_id`,`topic_id`,`state`,`staff`,`annulled`,`timestamp`) values (1,1,0,1,0,'closed','soporte',0,'2015-07-08 16:36:46'),(4,1,0,2,1,'closed','soporte',0,'2015-07-08 16:57:27'),(21,1,0,1,1,'overdue','SYSTEM',0,'2017-07-27 18:00:00'),(31,1,0,1,1,'overdue','SYSTEM',0,'2017-08-07 16:30:00'),(1,0,0,0,0,'created','SYSTEM',0,'2014-08-20 07:48:03'),(18,0,0,0,1,'created','SYSTEM',0,'2015-07-09 12:06:43'),(4,0,0,0,1,'created','SYSTEM',0,'2015-07-08 16:56:56'),(21,0,0,0,1,'created','SYSTEM',0,'2017-07-27 13:03:58'),(32,0,0,0,1,'created','SYSTEM',0,'2017-08-07 14:47:37'),(33,0,0,0,1,'created','SYSTEM',0,'2017-08-07 14:49:55'),(19,0,0,0,0,'created','SYSTEM',0,'2015-10-05 18:10:26'),(20,0,0,0,1,'created','SYSTEM',0,'2016-03-04 11:33:58'),(34,0,0,0,1,'created','SYSTEM',0,'2017-08-07 14:50:59'),(35,0,0,0,1,'created','SYSTEM',0,'2017-08-07 14:51:40'),(36,0,0,0,1,'created','SYSTEM',0,'2017-08-07 15:06:36'),(31,0,0,0,1,'created','SYSTEM',0,'2017-08-07 14:45:55'),(34,1,0,1,1,'overdue','SYSTEM',0,'2017-08-07 17:46:16'),(35,1,0,1,1,'overdue','SYSTEM',0,'2017-08-07 17:46:24'),(36,1,0,1,1,'overdue','SYSTEM',0,'2017-08-07 17:46:27');

/*Table structure for table `ost_ticket_lock` */


CREATE TABLE `ost_ticket_lock` (
  `lock_id` int(11) unsigned NOT NULL auto_increment,
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `staff_id` int(10) unsigned NOT NULL default '0',
  `expire` datetime default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`lock_id`),
  UNIQUE KEY `ticket_id` (`ticket_id`),
  KEY `staff_id` (`staff_id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_lock` */

/*Table structure for table `ost_ticket_message` */


CREATE TABLE `ost_ticket_message` (
  `msg_id` int(11) unsigned NOT NULL auto_increment,
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `messageId` varchar(255) default NULL,
  `message` text NOT NULL,
  `headers` text,
  `source` varchar(16) default NULL,
  `ip_address` varchar(16) default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime default NULL,
  PRIMARY KEY  (`msg_id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `msgId` (`messageId`),
  FULLTEXT KEY `message` (`message`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_message` */

insert  into `ost_ticket_message`(`msg_id`,`ticket_id`,`messageId`,`message`,`headers`,`source`,`ip_address`,`created`,`updated`) values (1,1,NULL,'EfnSop Instalado',NULL,'Web','','2014-08-20 07:48:03',NULL),(5,4,'','Ticket creado por el Staff','','Email','192.168.1.50','2015-07-08 16:56:56',NULL),(22,21,'','Ticket creado por el Staff','','Phone','192.168.1.30','2017-07-27 13:03:58',NULL),(33,32,'','Ticket creado por el Staff','','Phone','192.168.1.30','2017-08-07 14:47:37',NULL),(34,33,'','Ticket creado por el Staff','','Phone','192.168.1.30','2017-08-07 14:49:55',NULL),(19,18,'','soporte asterisk','','Web','192.168.1.125','2015-07-09 12:06:43',NULL),(20,19,'','Ticket creado por el Staff','','Phone','192.168.1.32','2015-10-05 18:10:26',NULL),(21,20,'','falla de los telefonos','','Web','190.117.127.143','2016-03-04 11:33:58',NULL),(35,34,'','Ticket creado por el Staff','','Phone','192.168.1.30','2017-08-07 14:50:59',NULL),(36,35,'','Ticket creado por el Staff','','Phone','192.168.1.30','2017-08-07 14:51:40',NULL),(37,36,'','Ticket creado por el Staff','','Phone','192.168.1.30','2017-08-07 15:06:36',NULL),(32,31,'','Ticket creado por el Staff','','Phone','192.168.1.30','2017-08-07 14:45:55',NULL);

/*Table structure for table `ost_ticket_note` */


CREATE TABLE `ost_ticket_note` (
  `note_id` int(11) unsigned NOT NULL auto_increment,
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `staff_id` int(10) unsigned NOT NULL default '0',
  `source` varchar(32) NOT NULL default '',
  `title` varchar(255) NOT NULL default 'Nota Interna Generica',
  `note` text NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`note_id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `staff_id` (`staff_id`),
  FULLTEXT KEY `note` (`note`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_note` */

insert  into `ost_ticket_note`(`note_id`,`ticket_id`,`staff_id`,`source`,`title`,`note`,`created`) values (1,1,1,'system','Ticket cerrado','Ticket de Francisco Florescerrado sin responder','2014-08-20 07:54:41'),(2,1,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','Verificar urgente','2015-07-08 13:27:59'),(3,1,1,'system','El estado del Ticket a cambiado a Cerrado','Soporte Effinet cerrar Al enviar ticket de ','2015-07-08 16:36:46'),(4,4,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','veamos','2015-07-08 16:56:56'),(5,4,1,'system','El estado del Ticket a cambiado a Cerrado','Soporte Effinet cerrar Al enviar ticket de ','2015-07-08 16:57:27'),(7,19,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','funcionamiento1','2015-10-05 18:10:26'),(8,21,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','2017-07-27 13:03:58'),(11,21,1,'system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','2017-07-27 18:00:32'),(28,33,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','2017-08-07 14:49:55'),(29,34,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','2017-08-07 14:50:59'),(30,35,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','2017-08-07 14:51:40'),(31,36,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','2017-08-07 15:06:36'),(32,36,1,'system','Prioridad Cambiada','La prioridad del tickets se a cambiado a \"Alta\" por Soporte Effinet','2017-08-07 15:07:05'),(33,31,1,'system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','2017-08-07 16:32:09'),(27,31,1,'Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','2017-08-07 14:45:55'),(34,33,1,'system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','2017-08-07 18:31:55'),(35,34,1,'system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','2017-08-07 18:31:55'),(36,35,1,'system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','2017-08-07 18:31:55'),(37,36,1,'system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','2017-08-07 18:31:56'),(38,32,1,'system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','2017-08-10 13:23:58');

/*Table structure for table `ost_ticket_priority` */


CREATE TABLE `ost_ticket_priority` (
  `priority_id` tinyint(4) NOT NULL auto_increment,
  `priority` varchar(60) NOT NULL default '',
  `priority_desc` varchar(30) NOT NULL default '',
  `priority_color` varchar(7) NOT NULL default '',
  `priority_urgency` tinyint(1) unsigned NOT NULL default '0',
  `ispublic` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`priority_id`),
  UNIQUE KEY `priority` (`priority`),
  KEY `priority_urgency` (`priority_urgency`),
  KEY `ispublic` (`ispublic`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_priority` */

insert  into `ost_ticket_priority`(`priority_id`,`priority`,`priority_desc`,`priority_color`,`priority_urgency`,`ispublic`) values (1,'low','Baja','#DDFFDD',4,1),(2,'normal','Normal','#FFFFF0',3,1),(3,'high','Alta','#FEE7E7',2,1),(4,'emergency','Urgente','#FEE7E7',1,0);

/*Table structure for table `ost_ticket_response` */


CREATE TABLE `ost_ticket_response` (
  `response_id` int(11) unsigned NOT NULL auto_increment,
  `msg_id` int(11) unsigned NOT NULL default '0',
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `staff_id` int(11) unsigned NOT NULL default '0',
  `staff_name` varchar(32) NOT NULL default '',
  `response` text NOT NULL,
  `ip_address` varchar(16) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`response_id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `msg_id` (`msg_id`),
  KEY `staff_id` (`staff_id`),
  FULLTEXT KEY `response` (`response`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_response` */

insert  into `ost_ticket_response`(`response_id`,`msg_id`,`ticket_id`,`staff_id`,`staff_name`,`response`,`ip_address`,`created`,`updated`) values (1,1,1,1,'Soporte Effinet','se termino correctamente','192.168.1.50','2015-07-08 16:36:46','0000-00-00 00:00:00'),(2,5,4,1,'Soporte Effinet','no lo se','192.168.1.50','2015-07-08 16:56:56','0000-00-00 00:00:00'),(3,5,4,1,'Soporte Effinet','ya se ha solucionado','192.168.1.50','2015-07-08 16:57:27','0000-00-00 00:00:00'),(4,20,19,1,'Soporte Effinet','funcionamiento','192.168.1.32','2015-10-05 18:10:26','0000-00-00 00:00:00'),(5,22,21,1,'Soporte Effinet','Es un sistema de tickets utilizado ampliamente como una alternativa atractiva a complejos sistemas de soporte al cliente, Simple, ligero, confiable, basado en la web y facil de configurar y usar .','192.168.1.30','2017-07-27 13:03:58','0000-00-00 00:00:00'),(16,34,33,1,'Soporte Effinet','sdfsdf','192.168.1.30','2017-08-07 14:49:55','0000-00-00 00:00:00'),(17,35,34,1,'Soporte Effinet','asdasd','192.168.1.30','2017-08-07 14:50:59','0000-00-00 00:00:00'),(18,36,35,1,'Soporte Effinet','asdcsd','192.168.1.30','2017-08-07 14:51:40','0000-00-00 00:00:00'),(19,37,36,1,'Soporte Effinet','sdasdasd','192.168.1.30','2017-08-07 15:06:36','0000-00-00 00:00:00'),(20,37,36,1,'Soporte Effinet','esta es una prueba','192.168.1.30','2017-08-07 15:07:29','0000-00-00 00:00:00'),(21,36,35,1,'Soporte Effinet','sadasdasd','192.168.1.30','2017-08-07 15:08:41','0000-00-00 00:00:00'),(15,32,31,1,'Soporte Effinet','asdasd','192.168.1.30','2017-08-07 14:45:55','0000-00-00 00:00:00'),(22,35,34,1,'Soporte Effinet','prueba link','192.168.1.30','2017-08-07 15:20:13','0000-00-00 00:00:00'),(23,34,33,1,'Soporte Effinet','\r\nfinal','192.168.1.30','2017-08-07 15:22:43','0000-00-00 00:00:00'),(24,33,32,1,'Soporte Effinet','prueba mensaje no editar','192.168.1.30','2017-08-07 15:30:59','0000-00-00 00:00:00');

/*Table structure for table `ost_ticket_rules` */


CREATE TABLE `ost_ticket_rules` (
  `id` tinyint(4) NOT NULL auto_increment,
  `isenabled` text character set utf8 NOT NULL,
  `Category` varchar(125) character set utf8 NOT NULL,
  `Criteria` text character set utf8 NOT NULL,
  `Action` text character set utf8 NOT NULL,
  `Department` text character set utf8 NOT NULL,
  `Staff` text character set utf8 NOT NULL,
  `updated` datetime NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `ost_ticket_rules` */

insert  into `ost_ticket_rules`(`id`,`isenabled`,`Category`,`Criteria`,`Action`,`Department`,`Staff`,`updated`,`created`) values (1,'on','subject','mlopez@effinet.com.pe','deptId','1','1','2015-07-09 05:50:22','2015-07-09 05:50:22'),(2,'on','subject','mlopez@effinet.com.pe','deptId','1','1','2015-07-09 08:53:04','2015-07-09 08:53:04');

/*Table structure for table `ost_ticket_thread` */


CREATE TABLE `ost_ticket_thread` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `pid` int(11) unsigned NOT NULL default '0',
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `staff_id` int(11) unsigned NOT NULL default '0',
  `thread_type` enum('M','R','N') NOT NULL,
  `poster` varchar(128) NOT NULL default '',
  `source` varchar(32) NOT NULL default '',
  `title` varchar(255) default NULL,
  `body` text NOT NULL,
  `ip_address` varchar(64) NOT NULL default '',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `staff_id` (`staff_id`),
  KEY `created` (`created`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

/*Data for the table `ost_ticket_thread` */

insert  into `ost_ticket_thread`(`id`,`pid`,`ticket_id`,`staff_id`,`thread_type`,`poster`,`source`,`title`,`body`,`ip_address`,`created`,`updated`) values (1,0,1,0,'M','','',NULL,'EfnSop Instalado','','2014-08-20 07:48:03','2017-08-07 17:38:55'),(2,0,4,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.50','2015-07-08 16:56:56','2017-08-07 17:38:55'),(3,0,21,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.30','2017-07-27 13:03:58','2017-08-07 17:38:55'),(4,0,32,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.30','2017-08-07 14:47:37','2017-08-07 17:38:55'),(5,0,33,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.30','2017-08-07 14:49:55','2017-08-07 17:38:55'),(6,0,18,0,'M','','',NULL,'soporte asterisk','192.168.1.125','2015-07-09 12:06:43','2017-08-07 17:38:55'),(7,0,19,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.32','2015-10-05 18:10:26','2017-08-07 17:38:55'),(8,0,20,0,'M','','',NULL,'falla de los telefonos','190.117.127.143','2016-03-04 11:33:58','2017-08-07 17:38:55'),(9,0,34,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.30','2017-08-07 14:50:59','2017-08-07 17:38:55'),(10,0,35,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.30','2017-08-07 14:51:40','2017-08-07 17:38:55'),(11,0,36,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.30','2017-08-07 15:06:36','2017-08-07 17:38:55'),(12,0,31,0,'M','','',NULL,'Ticket creado por el Staff','192.168.1.30','2017-08-07 14:45:55','2017-08-07 17:38:55'),(13,1,1,1,'R','Soporte Effinet','',NULL,'se termino correctamente','192.168.1.50','2015-07-08 16:36:46','0000-00-00 00:00:00'),(14,2,4,1,'R','Soporte Effinet','',NULL,'no lo se','192.168.1.50','2015-07-08 16:56:56','0000-00-00 00:00:00'),(15,2,4,1,'R','Soporte Effinet','',NULL,'ya se ha solucionado','192.168.1.50','2015-07-08 16:57:27','0000-00-00 00:00:00'),(16,7,19,1,'R','Soporte Effinet','',NULL,'funcionamiento','192.168.1.32','2015-10-05 18:10:26','0000-00-00 00:00:00'),(17,3,21,1,'R','Soporte Effinet','',NULL,'Es un sistema de tickets utilizado ampliamente como una alternativa atractiva a complejos sistemas de soporte al cliente, Simple, ligero, confiable, basado en la web y facil de configurar y usar .','192.168.1.30','2017-07-27 13:03:58','0000-00-00 00:00:00'),(18,5,33,1,'R','Soporte Effinet','',NULL,'sdfsdf','192.168.1.30','2017-08-07 14:49:55','0000-00-00 00:00:00'),(19,9,34,1,'R','Soporte Effinet','',NULL,'asdasd','192.168.1.30','2017-08-07 14:50:59','0000-00-00 00:00:00'),(20,10,35,1,'R','Soporte Effinet','',NULL,'asdcsd','192.168.1.30','2017-08-07 14:51:40','0000-00-00 00:00:00'),(21,11,36,1,'R','Soporte Effinet','',NULL,'sdasdasd','192.168.1.30','2017-08-07 15:06:36','0000-00-00 00:00:00'),(22,11,36,1,'R','Soporte Effinet','',NULL,'esta es una prueba','192.168.1.30','2017-08-07 15:07:29','0000-00-00 00:00:00'),(23,10,35,1,'R','Soporte Effinet','',NULL,'sadasdasd','192.168.1.30','2017-08-07 15:08:41','0000-00-00 00:00:00'),(24,12,31,1,'R','Soporte Effinet','',NULL,'asdasd','192.168.1.30','2017-08-07 14:45:55','0000-00-00 00:00:00'),(25,9,34,1,'R','Soporte Effinet','',NULL,'prueba link','192.168.1.30','2017-08-07 15:20:13','0000-00-00 00:00:00'),(26,5,33,1,'R','Soporte Effinet','',NULL,'\r\nfinal','192.168.1.30','2017-08-07 15:22:43','0000-00-00 00:00:00'),(27,4,32,1,'R','Soporte Effinet','',NULL,'prueba mensaje no editar','192.168.1.30','2017-08-07 15:30:59','0000-00-00 00:00:00'),(28,0,1,1,'N','Soporte Effinet','system','Ticket cerrado','Ticket de Francisco Florescerrado sin responder','','2014-08-20 07:54:41','2017-08-07 17:38:55'),(29,0,1,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','Verificar urgente','','2015-07-08 13:27:59','2017-08-07 17:38:55'),(30,0,1,1,'N','Soporte Effinet','system','El estado del Ticket a cambiado a Cerrado','Soporte Effinet cerrar Al enviar ticket de ','','2015-07-08 16:36:46','2017-08-07 17:38:55'),(31,0,4,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','veamos','','2015-07-08 16:56:56','2017-08-07 17:38:55'),(32,0,4,1,'N','Soporte Effinet','system','El estado del Ticket a cambiado a Cerrado','Soporte Effinet cerrar Al enviar ticket de ','','2015-07-08 16:57:27','2017-08-07 17:38:55'),(33,0,19,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','funcionamiento1','','2015-10-05 18:10:26','2017-08-07 17:38:55'),(34,0,21,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','','2017-07-27 13:03:58','2017-08-07 17:38:55'),(35,0,21,1,'N','Soporte Effinet','system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','','2017-07-27 18:00:32','2017-08-07 17:38:55'),(36,0,33,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','','2017-08-07 14:49:55','2017-08-07 17:38:55'),(37,0,34,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','','2017-08-07 14:50:59','2017-08-07 17:38:55'),(38,0,35,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','','2017-08-07 14:51:40','2017-08-07 17:38:55'),(39,0,36,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','','2017-08-07 15:06:36','2017-08-07 17:38:55'),(40,0,36,1,'N','Soporte Effinet','system','Prioridad Cambiada','La prioridad del tickets se a cambiado a \"Alta\" por Soporte Effinet','','2017-08-07 15:07:05','2017-08-07 17:38:55'),(41,0,31,1,'N','Soporte Effinet','system','Ticket marcado como vencido','Ticket marcado como vencido por el sistema.','','2017-08-07 16:32:09','2017-08-07 17:38:55'),(42,0,31,1,'N','Soporte Effinet','Soporte Effinet','Ticket asignado a Soporte Effinet','Ticket asignado','','2017-08-07 14:45:55','2017-08-07 17:38:55'),(43,0,37,0,'M','','Web','osTicket Upgraded','osTicket upgraded successfully! Please refer to the Release Notes (http://osticket.com/wiki/Release_Notes) for more information about changes and new features.\n\nBe sure to join osTicket forum (http://osticket.com/forums) and our mailing list (http://osticket.com/updates) , if you haven\'t done so already,  to stay up to date on announcements, security updates and alerts! Your contribution to osTicket community will be appreciated!\n\nThe osTicket team is committed to providing support to all users through our free online resources and a full range of commercial support packages and services. For more information, or to discuss your needs, please contact us today at http://osticket.com/support/. Any feedback will be appreciated!\n\nIf managing and upgrading this osTicket installation is daunting, you can try osTicket as a hosted service at http://www.supportsystem.com/ -- no upgrading ever, and we can import your data!  With SupportSystem\'s turnkey infrastructure, you get osTicket at its best, leaving you free to focus on your customers without the burden of making sure the application is stable, maintained, and secure.\n\n-\nosTicket Team\nhttp://osticket.com/\n','','2017-08-07 17:38:58','0000-00-00 00:00:00'),(44,0,34,0,'N','SYSTEM','','Ticket Marked Overdue','Ticket flagged as overdue by the system.','','2017-08-07 17:46:27','0000-00-00 00:00:00'),(45,0,35,0,'N','SYSTEM','','Ticket Marked Overdue','Ticket flagged as overdue by the system.','','2017-08-07 17:46:27','0000-00-00 00:00:00'),(46,0,36,0,'N','SYSTEM','','Ticket Marked Overdue','Ticket flagged as overdue by the system.','','2017-08-07 17:46:27','0000-00-00 00:00:00'),(47,0,35,0,'N','SYSTEM','','Ticket Marked Overdue','Ticket flagged as overdue by the system.','','2017-08-07 17:46:35','0000-00-00 00:00:00'),(48,0,36,0,'N','SYSTEM','','Ticket Marked Overdue','Ticket flagged as overdue by the system.','','2017-08-07 17:46:35','0000-00-00 00:00:00');

/*Table structure for table `ost_timezone` */


CREATE TABLE `ost_timezone` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `offset` float(3,1) NOT NULL default '0.0',
  `timezone` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

/*Data for the table `ost_timezone` */

insert  into `ost_timezone`(`id`,`offset`,`timezone`) values (1,-12.0,'Eniwetok, Kwajalein'),(2,-11.0,'Midway Island, Samoa'),(3,-10.0,'Hawaii'),(4,-9.0,'Alaska'),(5,-8.0,'Pacific Time (US & Canada)'),(6,-7.0,'Mountain Time (US & Canada)'),(7,-6.0,'Central Time (US & Canada), Mexico City'),(8,-5.0,'Eastern Time (US & Canada), Bogota, Lima'),(9,-4.0,'Atlantic Time (Canada), Caracas, La Paz'),(10,-3.5,'Newfoundland'),(11,-3.0,'Brazil, Buenos Aires, Georgetown'),(12,-2.0,'Mid-Atlantic'),(13,-1.0,'Azores, Cape Verde Islands'),(14,0.0,'Western Europe Time, London, Lisbon, Casablanca'),(15,1.0,'Brussels, Copenhagen, Madrid, Paris'),(16,2.0,'Kaliningrad, South Africa'),(17,3.0,'Baghdad, Riyadh, Moscow, St. Petersburg'),(18,3.5,'Tehran'),(19,4.0,'Abu Dhabi, Muscat, Baku, Tbilisi'),(20,4.5,'Kabul'),(21,5.0,'Ekaterinburg, Islamabad, Karachi, Tashkent'),(22,5.5,'Bombay, Calcutta, Madras, New Delhi'),(23,6.0,'Almaty, Dhaka, Colombo'),(24,7.0,'Bangkok, Hanoi, Jakarta'),(25,8.0,'Beijing, Perth, Singapore, Hong Kong'),(26,9.0,'Tokyo, Seoul, Osaka, Sapporo, Yakutsk'),(27,9.5,'Adelaide, Darwin'),(28,10.0,'Eastern Australia, Guam, Vladivostok'),(29,11.0,'Magadan, Solomon Islands, New Caledonia'),(30,12.0,'Auckland, Wellington, Fiji, Kamchatka');

