-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 12, 2014 at 10:13 AM
-- Server version: 5.1.69
-- PHP Version: 5.3.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `otrs`
--

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

--
-- Table structure for table `ticket`
--

CREATE TABLE IF NOT EXISTS `ticket` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `tn` VARCHAR(50) NOT NULL,
  `title` VARCHAR(255) DEFAULT NULL,
  `queue_id` INT(11) NOT NULL,
  `ticket_lock_id` SMALLINT(6) NOT NULL,
  `type_id` SMALLINT(6) DEFAULT NULL,
  `service_id` INT(11) DEFAULT NULL,
  `sla_id` INT(11) DEFAULT NULL,
  `user_id` INT(11) NOT NULL,
  `responsible_user_id` INT(11) NOT NULL,
  `ticket_priority_id` SMALLINT(6) NOT NULL,
  `ticket_state_id` SMALLINT(6) NOT NULL,
  `customer_id` VARCHAR(150) DEFAULT NULL,
  `customer_user_id` VARCHAR(250) DEFAULT NULL,
  `timeout` INT(11) NOT NULL,
  `until_time` INT(11) NOT NULL,
  `escalation_time` INT(11) NOT NULL,
  `escalation_update_time` INT(11) NOT NULL,
  `escalation_response_time` INT(11) NOT NULL,
  `escalation_solution_time` INT(11) NOT NULL,
  `valid_id` SMALLINT(6) NOT NULL,
  `archive_flag` SMALLINT(6) NOT NULL DEFAULT '0',
  `create_time_unix` BIGINT(20) NOT NULL,
  `create_time` datetime NOT NULL,
  `create_by` INT(11) NOT NULL,
  `change_time` datetime NOT NULL,
  `change_by` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ticket_tn` (`tn`),
  KEY `ticket_archive_flag` (`archive_flag`),
  KEY `ticket_create_time` (`create_time`),
  KEY `ticket_create_time_unix` (`create_time_unix`),
  KEY `ticket_customer_id` (`customer_id`),
  KEY `ticket_customer_user_id` (`customer_user_id`),
  KEY `ticket_escalation_response_time` (`escalation_response_time`),
  KEY `ticket_escalation_solution_time` (`escalation_solution_time`),
  KEY `ticket_escalation_time` (`escalation_time`),
  KEY `ticket_escalation_update_time` (`escalation_update_time`),
  KEY `ticket_queue_id` (`queue_id`),
  KEY `ticket_queue_view` (`ticket_state_id`,`ticket_lock_id`),
  KEY `ticket_responsible_user_id` (`responsible_user_id`),
  KEY `ticket_ticket_lock_id` (`ticket_lock_id`),
  KEY `ticket_ticket_priority_id` (`ticket_priority_id`),
  KEY `ticket_ticket_state_id` (`ticket_state_id`),
  KEY `ticket_timeout` (`timeout`),
  KEY `ticket_title` (`title`),
  KEY `ticket_type_id` (`type_id`),
  KEY `ticket_until_time` (`until_time`),
  KEY `ticket_user_id` (`user_id`),
  KEY `FK_ticket_service_id_id` (`service_id`),
  KEY `FK_ticket_sla_id_id` (`sla_id`),
  KEY `FK_ticket_create_by_id` (`create_by`),
  KEY `FK_ticket_change_by_id` (`change_by`),
  KEY `FK_ticket_valid_id_id` (`valid_id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `id_3` (`id`),
  KEY `id_4` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=128 ;

--
-- Dumping data for table `ticket`
--


INSERT INTO `ticket` (`id`, `tn`, `title`, `queue_id`, `ticket_lock_id`, `type_id`, `service_id`, `sla_id`, `user_id`, `responsible_user_id`, `ticket_priority_id`, `ticket_state_id`, `customer_id`, `customer_user_id`, `timeout`, `until_time`, `escalation_time`, `escalation_update_time`, `escalation_response_time`, `escalation_solution_time`, `valid_id`, `archive_flag`, `create_time_unix`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(1, '2010080210123456', 'Welcome to OTRS!', 6, 1, NULL, 4, 4, 3, 1, 3, 2, '2', 'OTP', 1385124286, 0, 0, 0, 0, 0, 1, 0, 1280750400, '2013-06-13 17:47:05', 1, '2013-11-22 13:46:19', 3);



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;