-- MySQL dump 10.11
--
-- Host: 172.16.8.68    Database: rt341
-- ------------------------------------------------------
-- Server version	4.1.11-Debian_4sarge2-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ABacoTickets`
--

DROP TABLE IF EXISTS `ABacoTickets`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ABacoTickets` (
  `id` int(11) NOT NULL auto_increment,
  `EffectiveId` int(11) NOT NULL default '0',
  `Queue` int(11) NOT NULL default '0',
  `Type` varchar(16) default NULL,
  `IssueStatement` int(11) NOT NULL default '0',
  `Resolution` int(11) NOT NULL default '0',
  `Owner` int(11) NOT NULL default '0',
  `Subject` varchar(200) default '[no subject]',
  `InitialPriority` int(11) NOT NULL default '0',
  `FinalPriority` int(11) NOT NULL default '0',
  `Priority` int(11) NOT NULL default '0',
  `TimeEstimated` int(11) NOT NULL default '0',
  `TimeWorked` int(11) NOT NULL default '0',
  `Status` varchar(10) default NULL,
  `TimeLeft` int(11) NOT NULL default '0',
  `Told` datetime default NULL,
  `Starts` datetime default NULL,
  `Started` datetime default NULL,
  `Due` datetime default NULL,
  `Resolved` datetime default NULL,
  `LastUpdatedBy` int(11) NOT NULL default '0',
  `LastUpdated` datetime default NULL,
  `Creator` int(11) NOT NULL default '0',
  `Created` datetime default NULL,
  `Disabled` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `Tickets1` (`Queue`,`Status`),
  KEY `Tickets2` (`Owner`),
  KEY `Tickets4` (`id`,`Status`),
  KEY `Tickets5` (`id`,`EffectiveId`),
  KEY `Tickets6` (`EffectiveId`,`Type`),
  KEY `Status` (`Status`),
  KEY `tck_id_effid` (`EffectiveId`,`id`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `ABacoTickets`
--

LOCK TABLES `ABacoTickets` WRITE;
/*!40000 ALTER TABLE `ABacoTickets` DISABLE KEYS */;
INSERT INTO `ABacoTickets` VALUES (748421,748421,44,'ticket',0,0,10,'UK080884_MLRNetworks_802021 dated 31/10/08',0,0,0,0,2,'new',0,NULL,'1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',922284,'2008-11-27 12:57:07',922284,'2008-11-27 12:57:06',0),(823599,823599,11,'ticket',0,0,10,'Отсутствует: Customer Satisfaction survey',0,10,0,0,1,'resolved',0,NULL,'1970-01-01 00:00:00','1970-01-01 00:00:00','2009-05-15 11:30:26','2009-05-13 12:51:50',3176885,'2009-05-13 12:51:50',3572511,'2009-05-13 11:30:26',0);
/*!40000 ALTER TABLE `ABacoTickets` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-05-20 10:50:32