-- MySQL dump 10.10 -- -- Host: localhost Database: hanzo_core -- ------------------------------------------------------ -- Server version 5.0.18-max /*!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 */; /*!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 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Dumping data for table `end_user_audit` -- -- WHERE: id<500 /*!40000 ALTER TABLE `end_user_audit` DISABLE KEYS */; LOCK TABLES `end_user_audit` WRITE; INSERT INTO `end_user_audit` VALUES (3,7,4,25,1000,'2005-04-18 22:03:23',1008,1,1,118,NULL,0),(6,1000,1,11,1000,'2005-04-18 22:04:11',1006,0,2,119,NULL,5),(7,7,7,25,1000,'2005-04-18 22:04:16',1008,0,2,666,NULL,0),(9,1000,1,97,1000,'2005-04-18 22:04:30',1006,0,2,111,NULL,8),(10,1000,1,108,1000,'2005-04-18 22:04:42',1006,1,1,110,NULL,0),(15,8,20,21,1000,'2005-04-18 22:05:05',1013,0,2,119,NULL,14),(16,8,20,21,1000,'2005-04-18 22:05:12',1013,1,1,119,NULL,0),(17,8,20,21,1000,'2005-04-18 22:05:12',1013,0,2,119,NULL,16),(18,8,13,21,1000,'2005-04-18 22:05:31',1013,1,1,119,NULL,0),(20,8,12,21,1000,'2005-04-18 22:05:37',1013,1,1,119,NULL,0),(23,7,2,25,1000,'2005-04-18 22:06:05',1008,0,2,118,NULL,22),(24,1000,1,25,1000,'2005-04-18 22:06:26',1006,1,1,118,NULL,0),(26,1000,1,108,1000,'2005-04-18 22:06:54',1006,1,1,110,NULL,0),(28,8,17,21,1000,'2005-04-18 22:07:09',1013,1,1,119,NULL,0),(29,8,17,21,1000,'2005-04-18 22:07:09',1013,0,2,119,NULL,28),(31,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(34,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(36,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(37,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(41,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(43,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(47,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(50,8,17,11,1000,'2005-04-18 22:07:43',1013,1,1,119,NULL,0),(52,1000,3,114,1000,'2005-04-18 22:07:56',1006,1,1,555,NULL,0),(53,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(55,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(57,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(60,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(62,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(63,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(65,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(67,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(69,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(70,1000,3,114,1000,'2005-04-18 22:08:06',1006,1,1,555,NULL,0),(72,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(73,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(76,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(77,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(79,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(80,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(82,1000,3,114,1000,'2005-04-18 22:08:07',1006,0,2,555,NULL,70),(85,1000,3,114,1000,'2005-04-18 22:08:07',1006,0,2,555,NULL,70),(87,1000,3,114,1000,'2005-04-18 22:08:07',1006,0,2,555,NULL,70),(90,1000,1,25,1000,'2005-04-18 22:08:14',1006,1,1,119,NULL,0),(91,1000,1,25,1000,'2005-04-18 22:08:16',1006,0,2,119,NULL,90),(92,8,13,10,1000,'2005-04-18 22:08:20',1013,1,1,119,NULL,0),(93,8,13,10,1000,'2005-04-18 22:08:20',1013,0,2,119,NULL,92),(95,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(99,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(100,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(105,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(107,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(108,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(109,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(110,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(112,1000,1,21,1000,'2005-04-18 22:09:01',1006,1,1,119,NULL,0),(113,1000,1,21,1000,'2005-04-18 22:09:01',1006,0,2,119,NULL,112),(117,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(120,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(121,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(122,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(123,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(124,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(125,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(1,1000,2,25,1000,'2005-04-18 22:02:17',1006,1,1,118,NULL,0),(2,1000,2,25,1000,'2005-04-18 22:02:17',1006,0,2,118,NULL,1),(4,7,4,25,1000,'2005-04-18 22:03:23',1008,0,2,118,NULL,3),(5,1000,1,11,1000,'2005-04-18 22:04:11',1006,1,1,119,NULL,0),(8,1000,1,97,1000,'2005-04-18 22:04:30',1006,1,1,111,NULL,0),(11,1000,1,108,1000,'2005-04-18 22:04:42',1006,0,2,110,NULL,10),(12,1000,1,108,1000,'2005-04-18 22:04:48',1006,1,1,110,NULL,0),(13,1000,1,108,1000,'2005-04-18 22:04:48',1006,0,2,110,NULL,12),(14,8,20,21,1000,'2005-04-18 22:05:05',1013,1,1,119,NULL,0),(19,8,13,21,1000,'2005-04-18 22:05:31',1013,0,2,119,NULL,18),(21,8,12,21,1000,'2005-04-18 22:05:37',1013,0,2,119,NULL,20),(22,7,2,25,1000,'2005-04-18 22:06:00',1008,1,1,118,NULL,0),(25,1000,1,25,1000,'2005-04-18 22:06:26',1006,0,2,118,NULL,24),(27,1000,1,108,1000,'2005-04-18 22:06:58',1006,0,2,110,NULL,26),(30,1000,3,114,1000,'2005-04-18 22:07:26',1006,1,1,555,NULL,0),(32,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(33,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(35,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(38,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(39,1000,3,114,1000,'2005-04-18 22:07:26',1006,0,2,555,NULL,30),(40,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(42,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(44,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(45,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(46,1000,3,114,1000,'2005-04-18 22:07:27',1006,0,2,555,NULL,30),(48,8,17,21,1000,'2005-04-18 22:07:34',1013,1,1,119,NULL,0),(49,8,17,21,1000,'2005-04-18 22:07:34',1013,0,2,119,NULL,48),(51,8,17,11,1000,'2005-04-18 22:07:43',1013,0,2,119,NULL,50),(54,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(56,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(58,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(59,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(61,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(64,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(66,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(68,1000,3,114,1000,'2005-04-18 22:07:58',1006,0,2,555,NULL,52),(71,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(74,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(75,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(78,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(81,1000,3,114,1000,'2005-04-18 22:08:06',1006,0,2,555,NULL,70),(83,1000,3,114,1000,'2005-04-18 22:08:07',1006,0,2,555,NULL,70),(84,1000,3,114,1000,'2005-04-18 22:08:07',1006,0,2,555,NULL,70),(86,1000,3,114,1000,'2005-04-18 22:08:07',1006,0,2,555,NULL,70),(88,1000,2,114,1000,'2005-04-18 22:08:12',1006,1,1,555,NULL,0),(89,1000,2,114,1000,'2005-04-18 22:08:14',1006,0,2,555,NULL,88),(94,1000,3,114,1000,'2005-04-18 22:08:27',1006,1,1,555,NULL,0),(96,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(97,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(98,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(101,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(102,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(103,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(104,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(106,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(111,1000,3,114,1000,'2005-04-18 22:08:30',1006,0,2,555,NULL,94),(116,1000,3,21,1000,'2005-04-18 22:09:22',1006,1,1,119,NULL,0),(118,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(119,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(126,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(127,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(128,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(129,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(130,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(133,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(134,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(135,8,20,25,1000,'2005-04-18 22:10:02',1013,1,1,119,NULL,0),(136,8,20,25,1000,'2005-04-18 22:10:02',1013,0,2,119,NULL,135),(138,8,12,11,1000,'2005-04-18 22:10:53',1013,0,2,119,NULL,137),(139,8,11,11,1000,'2005-04-18 22:13:24',1013,1,1,119,NULL,0),(140,8,11,11,1000,'2005-04-18 22:13:24',1013,0,2,119,NULL,139),(141,8,11,11,1000,'2005-04-18 22:13:24',1013,0,2,119,NULL,139),(142,8,12,25,1000,'2005-04-18 22:14:15',1013,1,1,119,NULL,0),(143,8,12,25,1000,'2005-04-18 22:14:15',1013,0,2,119,NULL,142),(145,8,15,25,1000,'2005-04-18 22:15:28',1013,0,2,119,NULL,144),(146,8,15,11,1000,'2005-04-18 22:16:08',1013,1,1,119,NULL,0),(148,8,15,25,1000,'2005-04-18 22:20:28',1013,1,1,119,NULL,0),(149,8,15,11,1000,'2005-04-18 22:20:28',1013,0,2,119,NULL,148),(152,8,15,25,1000,'2005-04-18 22:22:42',1013,1,1,119,NULL,0),(154,8,13,11,1000,'2005-04-18 22:28:52',1013,1,1,119,NULL,0),(156,8,17,11,1000,'2005-04-18 22:30:08',1013,1,1,119,NULL,0),(157,8,17,11,1000,'2005-04-18 22:30:08',1013,0,2,119,NULL,156),(159,8,12,11,1000,'2005-04-18 22:31:02',1013,0,2,119,NULL,158),(160,8,17,11,1000,'2005-04-18 22:31:48',1013,1,1,119,NULL,0),(161,8,17,11,1000,'2005-04-18 22:31:48',1013,0,2,119,NULL,160),(162,8,15,11,1000,'2005-04-18 22:32:41',1013,1,1,119,NULL,0),(164,8,11,11,1000,'2005-04-18 22:33:04',1013,1,1,119,NULL,0),(165,8,11,11,1000,'2005-04-18 22:33:04',1013,0,2,119,NULL,164),(166,8,17,11,1000,'2005-04-18 22:52:04',1013,1,1,119,NULL,0),(168,8,17,11,1000,'2005-04-18 22:53:03',1013,1,1,119,NULL,0),(169,8,17,11,1000,'2005-04-18 22:53:03',1013,0,2,119,NULL,168),(171,1000,1,11,1000,'2005-04-18 22:54:09',1006,0,2,119,NULL,170),(173,8,18,11,1000,'2005-04-18 22:56:15',1013,0,2,119,NULL,172),(174,8,19,11,1000,'2005-04-18 22:57:20',1013,1,1,119,NULL,0),(175,8,19,11,1000,'2005-04-18 22:57:20',1013,0,2,119,NULL,174),(177,8,20,11,1000,'2005-04-18 22:58:46',1013,0,2,119,NULL,176),(178,8,13,11,1000,'2005-04-18 22:59:40',1013,1,1,119,NULL,0),(183,8,17,11,1000,'2005-04-18 23:03:32',1013,0,2,119,NULL,182),(186,8,13,10,1000,'2005-04-18 23:07:36',1013,1,1,119,NULL,0),(187,8,13,10,1000,'2005-04-18 23:07:37',1013,0,2,119,NULL,186),(188,8,17,10,1000,'2005-04-18 23:08:37',1013,1,1,119,NULL,0),(189,8,17,10,1000,'2005-04-18 23:08:38',1013,0,2,119,NULL,188),(198,8,18,10,1000,'2005-04-18 23:15:55',1013,1,1,119,NULL,0),(200,8,18,10,1000,'2005-04-18 23:16:10',1013,1,1,119,NULL,0),(203,8,19,10,1000,'2005-04-18 23:27:07',1013,0,2,119,NULL,202),(205,8,20,1,1000,'2005-04-18 23:29:07',1013,0,2,119,NULL,204),(206,8,13,21,1000,'2005-04-18 23:29:18',1013,1,1,119,NULL,0),(208,8,17,21,1000,'2005-04-18 23:29:25',1013,1,1,119,NULL,0),(209,8,17,21,1000,'2005-04-18 23:29:25',1013,0,2,119,NULL,208),(210,8,17,21,1000,'2005-04-18 23:29:45',1013,1,1,119,NULL,0),(211,8,17,21,1000,'2005-04-18 23:29:45',1013,0,2,119,NULL,210),(212,8,12,21,1000,'2005-04-18 23:29:53',1013,1,1,119,NULL,0),(214,8,17,21,1000,'2005-04-18 23:30:09',1013,1,1,119,NULL,0),(215,8,17,21,1000,'2005-04-18 23:30:09',1013,0,2,119,NULL,214),(219,8,17,21,1000,'2005-04-18 23:30:21',1013,0,2,119,NULL,218),(223,8,17,21,1000,'2005-04-18 23:30:31',1013,0,2,119,NULL,222),(228,8,17,21,1000,'2005-04-18 23:31:12',1013,1,1,119,NULL,0),(229,8,17,21,1000,'2005-04-18 23:31:12',1013,0,2,119,NULL,228),(230,8,13,21,1000,'2005-04-18 23:31:23',1013,1,1,119,NULL,0),(231,8,13,21,1000,'2005-04-18 23:31:23',1013,0,2,119,NULL,230),(233,8,20,10,1000,'2005-04-18 23:31:47',1013,0,2,119,NULL,232),(240,8,20,116,1000,'2005-04-18 23:38:09',1013,1,1,119,NULL,0),(241,8,20,116,1000,'2005-04-18 23:38:09',1013,0,2,119,NULL,240),(242,8,20,116,1000,'2005-04-18 23:38:22',1013,1,1,119,NULL,0),(244,8,20,116,1000,'2005-04-18 23:38:22',1013,0,2,119,NULL,242),(245,8,20,116,1000,'2005-04-18 23:38:34',1013,1,1,119,NULL,0),(247,8,20,116,1000,'2005-04-18 23:38:41',1013,1,1,119,NULL,0),(248,8,20,116,1000,'2005-04-18 23:38:41',1013,0,2,119,NULL,247),(250,8,17,10,1000,'2005-04-18 23:39:23',1013,0,2,119,NULL,249),(252,1000,1,8,1000,'2005-04-18 23:39:35',1006,0,2,118,NULL,251),(253,8,18,10,1000,'2005-04-18 23:39:36',1013,1,1,119,NULL,0),(254,8,18,10,1000,'2005-04-18 23:39:36',1013,0,2,119,NULL,253),(258,8,20,10,1000,'2005-04-18 23:40:11',1013,0,2,119,NULL,257),(261,8,13,10,1000,'2005-04-18 23:44:20',1013,1,1,119,NULL,0),(264,8,18,10,1000,'2005-04-18 23:44:28',1013,0,2,119,NULL,263),(265,8,19,10,1000,'2005-04-18 23:44:33',1013,1,1,119,NULL,0),(266,8,19,10,1000,'2005-04-18 23:44:33',1013,0,2,119,NULL,265),(267,8,20,10,1000,'2005-04-18 23:44:40',1013,1,1,119,NULL,0),(270,8,20,10,1000,'2005-04-18 23:45:01',1013,0,2,119,NULL,269),(274,8,18,116,1000,'2005-04-18 23:46:15',1013,0,2,119,NULL,273),(275,8,19,116,1000,'2005-04-18 23:46:18',1013,1,1,119,NULL,0),(276,8,19,116,1000,'2005-04-18 23:46:18',1013,0,2,119,NULL,275),(277,8,20,116,1000,'2005-04-18 23:46:21',1013,1,1,119,NULL,0),(278,8,20,116,1000,'2005-04-18 23:46:21',1013,0,2,119,NULL,277),(281,8,13,116,1000,'2005-04-18 23:46:56',1013,1,1,119,NULL,0),(282,8,13,116,1000,'2005-04-18 23:46:56',1013,0,2,119,NULL,281),(283,8,13,116,1000,'2005-04-18 23:47:34',1013,1,1,119,NULL,0),(284,8,13,116,1000,'2005-04-18 23:47:34',1013,0,2,119,NULL,283),(285,1000,1,116,1000,'2005-04-18 23:47:42',1006,1,1,119,NULL,0),(286,1000,1,116,1000,'2005-04-18 23:47:42',1006,0,2,119,NULL,285),(287,8,13,116,1000,'2005-04-18 23:47:45',1013,1,1,119,NULL,0),(288,8,13,116,1000,'2005-04-18 23:47:45',1013,0,2,119,NULL,287),(289,8,17,116,1000,'2005-04-18 23:48:11',1013,1,1,119,NULL,0),(294,8,13,21,1000,'2005-04-18 23:49:07',1013,0,2,119,NULL,293),(295,8,17,21,1000,'2005-04-18 23:49:12',1013,1,1,119,NULL,0),(296,8,17,21,1000,'2005-04-18 23:49:12',1013,0,2,119,NULL,295),(297,8,13,21,1000,'2005-04-18 23:49:18',1013,1,1,119,NULL,0),(299,8,17,21,1000,'2005-04-18 23:49:23',1013,1,1,119,NULL,0),(300,8,17,21,1000,'2005-04-18 23:49:23',1013,0,2,119,NULL,299),(302,8,17,21,1000,'2005-04-18 23:49:32',1013,0,2,119,NULL,301),(303,8,13,21,1000,'2005-04-18 23:49:37',1013,1,1,119,NULL,0),(308,1000,1,118,1000,'2005-04-18 23:52:07',1006,0,2,123,NULL,307),(309,1000,8,118,1000,'2005-04-18 23:52:13',1006,1,1,123,NULL,0),(310,1000,8,118,1000,'2005-04-18 23:52:13',1006,0,2,123,NULL,309),(311,1000,8,118,1000,'2005-04-18 23:54:32',1006,1,1,123,NULL,0),(312,1000,8,118,1000,'2005-04-18 23:54:32',1006,0,2,123,NULL,311),(314,1000,8,118,1000,'2005-04-18 23:55:54',1006,0,2,123,NULL,313),(315,35,9,118,1000,'2005-04-18 23:56:07',1011,1,1,123,NULL,0),(318,35,10,118,1000,'2005-04-18 23:56:09',1011,0,2,123,NULL,317),(320,35,10,118,1000,'2005-04-18 23:56:13',1011,0,2,123,NULL,319),(322,8,17,21,1000,'2005-04-19 00:04:14',1013,0,2,119,NULL,321),(325,1000,1,115,1000,'2005-04-19 00:30:05',1006,1,1,555,NULL,0),(326,1000,1,115,1000,'2005-04-19 00:30:05',1006,0,2,555,NULL,325),(328,1000,8,115,1000,'2005-04-19 00:30:10',1006,0,2,127,NULL,327),(330,1000,1,115,1000,'2005-04-19 00:30:21',1006,0,2,127,NULL,329),(331,1000,8,115,1000,'2005-04-19 00:30:25',1006,1,1,126,NULL,0),(332,1000,8,115,1000,'2005-04-19 00:30:25',1006,0,2,126,NULL,331),(333,1000,3,115,1000,'2005-04-19 00:32:02',1006,1,1,126,NULL,0),(335,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(338,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(339,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(341,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(344,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(346,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(348,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(362,3,7,11,1000,'2005-04-19 15:00:01',1008,0,2,666,NULL,0),(365,3,6,16,1000,'2005-04-19 15:10:53',1008,0,2,101,NULL,364),(366,3,7,16,1000,'2005-04-19 15:11:11',1008,1,1,101,NULL,0),(369,3,2,16,1000,'2005-04-19 15:11:43',1008,0,2,101,NULL,368),(370,3,7,11,1000,'2005-04-19 15:13:01',1008,0,2,666,NULL,0),(372,3,7,11,1000,'2005-04-19 15:13:32',1008,1,1,119,NULL,0),(375,3,2,11,1000,'2005-04-19 15:14:20',1008,0,2,119,NULL,374),(131,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(132,1000,3,21,1000,'2005-04-18 22:09:22',1006,0,2,119,NULL,116),(137,8,12,11,1000,'2005-04-18 22:10:53',1013,1,1,119,NULL,0),(144,8,15,11,1000,'2005-04-18 22:15:28',1013,1,1,119,NULL,0),(147,8,15,109,1000,'2005-04-18 22:16:08',1013,0,2,119,NULL,146),(150,8,17,11,1000,'2005-04-18 22:20:35',1013,1,1,119,NULL,0),(151,8,17,11,1000,'2005-04-18 22:20:35',1013,0,2,119,NULL,150),(153,8,15,11,1000,'2005-04-18 22:22:42',1013,0,2,119,NULL,152),(155,8,13,11,1000,'2005-04-18 22:28:52',1013,0,2,119,NULL,154),(158,8,12,11,1000,'2005-04-18 22:31:02',1013,1,1,119,NULL,0),(163,8,15,21,1000,'2005-04-18 22:32:41',1013,0,2,119,NULL,162),(167,8,17,11,1000,'2005-04-18 22:52:04',1013,0,2,119,NULL,166),(170,1000,1,11,1000,'2005-04-18 22:54:09',1006,1,1,119,NULL,0),(172,8,18,11,1000,'2005-04-18 22:56:15',1013,1,1,119,NULL,0),(176,8,20,11,1000,'2005-04-18 22:58:46',1013,1,1,119,NULL,0),(179,8,13,11,1000,'2005-04-18 22:59:40',1013,0,2,119,NULL,178),(180,8,17,11,1000,'2005-04-18 23:02:25',1013,1,1,119,NULL,0),(181,8,17,11,1000,'2005-04-18 23:02:25',1013,0,2,119,NULL,180),(182,8,17,11,1000,'2005-04-18 23:03:32',1013,1,1,119,NULL,0),(184,8,17,11,1000,'2005-04-18 23:04:30',1013,1,1,119,NULL,0),(185,8,17,11,1000,'2005-04-18 23:04:30',1013,0,2,119,NULL,184),(190,8,17,10,1000,'2005-04-18 23:09:48',1013,1,1,119,NULL,0),(191,8,17,10,1000,'2005-04-18 23:09:48',1013,0,2,119,NULL,190),(192,8,13,10,1000,'2005-04-18 23:10:57',1013,1,1,119,NULL,0),(193,8,13,10,1000,'2005-04-18 23:10:57',1013,0,2,119,NULL,192),(194,8,18,10,1000,'2005-04-18 23:11:52',1013,1,1,119,NULL,0),(195,8,18,10,1000,'2005-04-18 23:11:52',1013,0,2,119,NULL,194),(196,8,13,10,1000,'2005-04-18 23:14:37',1013,1,1,119,NULL,0),(197,8,13,10,1000,'2005-04-18 23:14:37',1013,0,2,119,NULL,196),(199,8,18,10,1000,'2005-04-18 23:15:55',1013,0,2,119,NULL,198),(201,8,18,10,1000,'2005-04-18 23:16:10',1013,0,2,119,NULL,200),(202,8,19,10,1000,'2005-04-18 23:27:07',1013,1,1,119,NULL,0),(204,8,20,1,1000,'2005-04-18 23:29:07',1013,1,1,119,NULL,0),(207,8,13,21,1000,'2005-04-18 23:29:18',1013,0,2,119,NULL,206),(213,8,12,21,1000,'2005-04-18 23:29:53',1013,0,2,119,NULL,212),(216,8,20,10,1000,'2005-04-18 23:30:15',1013,1,1,119,NULL,0),(217,8,20,10,1000,'2005-04-18 23:30:15',1013,0,2,119,NULL,216),(218,8,17,21,1000,'2005-04-18 23:30:21',1013,1,1,119,NULL,0),(220,8,17,21,1000,'2005-04-18 23:30:26',1013,1,1,119,NULL,0),(221,8,17,21,1000,'2005-04-18 23:30:26',1013,0,2,119,NULL,220),(222,8,17,21,1000,'2005-04-18 23:30:31',1013,1,1,119,NULL,0),(224,8,12,21,1000,'2005-04-18 23:30:54',1013,1,1,119,NULL,0),(225,8,12,21,1000,'2005-04-18 23:30:54',1013,0,2,119,NULL,224),(226,8,17,21,1000,'2005-04-18 23:31:04',1013,1,1,119,NULL,0),(227,8,17,21,1000,'2005-04-18 23:31:04',1013,0,2,119,NULL,226),(232,8,20,10,1000,'2005-04-18 23:31:47',1013,1,1,119,NULL,0),(243,8,20,116,1000,'2005-04-18 23:38:22',1013,0,2,119,NULL,242),(246,8,20,116,1000,'2005-04-18 23:38:34',1013,0,2,119,NULL,245),(249,8,17,10,1000,'2005-04-18 23:39:23',1013,1,1,119,NULL,0),(251,1000,1,8,1000,'2005-04-18 23:39:35',1006,1,1,118,NULL,0),(255,8,19,10,1000,'2005-04-18 23:39:41',1013,1,1,119,NULL,0),(256,8,19,10,1000,'2005-04-18 23:39:41',1013,0,2,119,NULL,255),(257,8,20,10,1000,'2005-04-18 23:40:11',1013,1,1,119,NULL,0),(259,8,13,116,1000,'2005-04-18 23:43:07',1013,1,1,119,NULL,0),(260,8,13,116,1000,'2005-04-18 23:43:07',1013,0,2,119,NULL,259),(262,8,13,10,1000,'2005-04-18 23:44:20',1013,0,2,119,NULL,261),(263,8,18,10,1000,'2005-04-18 23:44:28',1013,1,1,119,NULL,0),(268,8,20,10,1000,'2005-04-18 23:44:40',1013,0,2,119,NULL,267),(269,8,20,10,1000,'2005-04-18 23:45:01',1013,1,1,119,NULL,0),(271,8,13,116,1000,'2005-04-18 23:45:58',1013,1,1,119,NULL,0),(272,8,13,116,1000,'2005-04-18 23:45:58',1013,0,2,119,NULL,271),(273,8,18,116,1000,'2005-04-18 23:46:15',1013,1,1,119,NULL,0),(279,8,20,116,1000,'2005-04-18 23:46:42',1013,1,1,119,NULL,0),(280,8,20,116,1000,'2005-04-18 23:46:42',1013,0,2,119,NULL,279),(377,3,2,16,1000,'2005-04-19 15:18:36',1008,0,2,101,NULL,376),(379,1000,2,16,1000,'2005-04-19 15:18:59',1006,0,2,101,NULL,378),(380,3,7,11,1000,'2005-04-19 16:00:01',1008,0,2,666,NULL,0),(381,3,7,16,1000,'2005-04-19 16:00:01',1008,0,2,666,NULL,0),(382,113,4,25,1000,'2005-04-19 18:24:16',1008,1,1,119,NULL,0),(384,113,7,25,1000,'2005-04-19 18:25:06',1008,0,2,666,NULL,0),(386,8,17,21,1000,'2005-04-19 23:53:05',1013,1,1,0,NULL,0),(388,8,12,21,1000,'2005-04-19 23:53:22',1013,1,1,0,NULL,0),(389,8,12,21,1000,'2005-04-19 23:53:22',1013,0,2,0,NULL,388),(392,8,17,21,1000,'2005-04-19 23:53:39',1013,1,1,0,NULL,0),(394,8,17,21,1000,'2005-04-20 00:43:01',1013,1,1,0,NULL,0),(395,8,17,21,1000,'2005-04-20 00:43:02',1013,0,2,0,NULL,394),(396,108,4,108,1000,'2005-04-20 02:03:57',1008,1,1,0,NULL,0),(397,108,4,108,1000,'2005-04-20 02:03:57',1008,0,2,0,NULL,396),(400,1000,8,4,1000,'2005-04-20 02:05:18',1006,1,1,0,NULL,0),(401,1000,8,4,1000,'2005-04-20 02:05:18',1006,0,2,0,NULL,400),(402,4,7,12,1000,'2005-04-20 12:00:01',1008,1,2,0,NULL,0),(405,74,7,12,1000,'2005-04-20 12:00:01',1008,1,2,0,NULL,0),(406,74,7,113,1000,'2005-04-20 12:00:01',1008,1,2,0,NULL,0),(408,113,7,25,1000,'2005-04-20 14:30:01',1008,1,2,0,NULL,0),(410,1000,1,23,1000,'2005-04-20 14:51:07',1006,1,2,552182240,NULL,409),(414,82,4,119,1000,'2005-04-20 15:32:06',1008,1,2,552182240,NULL,413),(418,74,4,119,1000,'2005-04-20 15:36:50',1008,1,2,552182240,NULL,417),(421,74,7,119,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(423,4,7,113,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(426,4,7,113,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(427,4,7,119,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(428,113,7,25,1000,'2005-04-20 19:30:01',1008,1,2,0,NULL,0),(429,1000,1,121,1000,'2005-04-20 19:40:18',1006,1,1,0,NULL,0),(430,1000,1,121,1000,'2005-04-20 19:40:18',1006,0,2,0,NULL,429),(432,8,20,121,1000,'2005-04-20 19:41:03',1013,0,2,0,NULL,431),(435,8,13,121,1000,'2005-04-20 19:41:32',1013,1,1,0,NULL,0),(436,8,13,121,1000,'2005-04-20 19:41:32',1013,0,2,0,NULL,435),(437,8,20,121,1000,'2005-04-20 19:48:27',1013,1,1,0,NULL,0),(440,8,20,121,1000,'2005-04-20 19:48:50',1013,0,2,0,NULL,439),(445,82,7,12,1000,'2005-04-21 12:00:01',1008,1,2,0,NULL,0),(447,74,7,12,1000,'2005-04-21 12:00:01',1008,1,2,0,NULL,0),(448,74,7,113,1000,'2005-04-21 12:00:02',1008,1,2,0,NULL,0),(449,4,7,12,1000,'2005-04-21 12:00:02',1008,1,2,0,NULL,0),(452,85,7,12,1000,'2005-04-21 12:00:02',1008,1,2,0,NULL,0),(454,74,7,12,1000,'2005-04-21 16:00:01',1008,1,2,0,NULL,0),(455,4,7,12,1000,'2005-04-22 12:00:01',1008,1,2,0,NULL,0),(456,74,7,12,1000,'2005-04-22 12:00:01',1008,1,2,0,NULL,0),(459,1000,1,14,1000,'2005-04-26 12:16:06',1006,1,1,552182240,NULL,0),(461,115,7,25,1000,'2005-04-26 19:18:35',1008,1,1,0,NULL,0),(468,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(476,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(477,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(487,1000,1,14,1000,'2005-04-27 12:10:03',1006,1,1,552182240,NULL,0),(490,74,7,12,1000,'2005-04-27 17:45:02',1008,1,2,0,NULL,0),(491,116,4,11,1000,'2005-04-27 19:10:31',1008,1,1,0,NULL,0),(494,116,4,9,1000,'2005-04-27 19:10:45',1008,1,2,552182240,NULL,493),(495,116,4,124,1000,'2005-04-27 19:11:55',1008,1,1,552182240,NULL,0),(496,116,4,124,1000,'2005-04-27 19:11:55',1008,1,2,552182240,NULL,495),(497,116,7,11,1000,'2005-04-27 19:14:00',1008,1,2,0,NULL,0),(498,116,7,9,1000,'2005-04-27 19:14:00',1008,1,2,0,NULL,0),(499,116,7,124,1000,'2005-04-27 19:14:00',1008,1,2,0,NULL,0),(290,8,17,116,1000,'2005-04-18 23:48:11',1013,0,2,119,NULL,289),(291,8,17,21,1000,'2005-04-18 23:49:02',1013,1,1,119,NULL,0),(292,8,17,21,1000,'2005-04-18 23:49:02',1013,0,2,119,NULL,291),(293,8,13,21,1000,'2005-04-18 23:49:07',1013,1,1,119,NULL,0),(298,8,13,21,1000,'2005-04-18 23:49:18',1013,0,2,119,NULL,297),(301,8,17,21,1000,'2005-04-18 23:49:32',1013,1,1,119,NULL,0),(304,8,13,21,1000,'2005-04-18 23:49:37',1013,0,2,119,NULL,303),(305,8,17,21,1000,'2005-04-18 23:49:42',1013,1,1,119,NULL,0),(306,8,17,21,1000,'2005-04-18 23:49:42',1013,0,2,119,NULL,305),(307,1000,1,118,1000,'2005-04-18 23:52:07',1006,1,1,123,NULL,0),(313,1000,8,118,1000,'2005-04-18 23:55:54',1006,1,1,123,NULL,0),(316,35,9,118,1000,'2005-04-18 23:56:07',1011,0,2,123,NULL,315),(317,35,10,118,1000,'2005-04-18 23:56:09',1011,1,1,123,NULL,0),(319,35,10,118,1000,'2005-04-18 23:56:13',1011,1,1,123,NULL,0),(321,8,17,21,1000,'2005-04-19 00:04:14',1013,1,1,119,NULL,0),(323,8,17,21,1000,'2005-04-19 00:04:26',1013,1,1,119,NULL,0),(324,8,17,21,1000,'2005-04-19 00:04:26',1013,0,2,119,NULL,323),(327,1000,8,115,1000,'2005-04-19 00:30:10',1006,1,1,127,NULL,0),(329,1000,1,115,1000,'2005-04-19 00:30:21',1006,1,1,127,NULL,0),(334,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(336,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(337,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(340,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(342,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(343,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(345,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(347,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(349,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(350,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(351,1000,3,115,1000,'2005-04-19 00:32:02',1006,0,2,126,NULL,333),(354,3,2,11,1000,'2005-04-19 14:43:45',1008,1,1,119,NULL,0),(355,3,2,11,1000,'2005-04-19 14:43:45',1008,0,2,119,NULL,354),(356,3,7,11,1000,'2005-04-19 14:46:02',1008,0,2,666,NULL,0),(357,3,7,16,1000,'2005-04-19 14:46:02',1008,0,2,666,NULL,0),(358,3,7,11,1000,'2005-04-19 14:46:54',1008,1,1,119,NULL,0),(359,3,6,11,1000,'2005-04-19 14:46:54',1008,0,2,119,NULL,358),(360,3,2,11,1000,'2005-04-19 14:58:00',1008,1,1,119,NULL,0),(361,3,2,11,1000,'2005-04-19 14:58:00',1008,0,2,119,NULL,360),(363,3,7,16,1000,'2005-04-19 15:00:01',1008,0,2,666,NULL,0),(364,3,7,16,1000,'2005-04-19 15:10:53',1008,1,1,101,NULL,0),(367,3,6,16,1000,'2005-04-19 15:11:11',1008,0,2,101,NULL,366),(368,3,2,16,1000,'2005-04-19 15:11:43',1008,1,1,101,NULL,0),(371,3,7,16,1000,'2005-04-19 15:13:01',1008,0,2,666,NULL,0),(373,3,6,11,1000,'2005-04-19 15:13:32',1008,0,2,119,NULL,372),(374,3,2,11,1000,'2005-04-19 15:14:20',1008,1,1,119,NULL,0),(376,3,2,16,1000,'2005-04-19 15:18:36',1008,1,1,101,NULL,0),(378,1000,2,16,1000,'2005-04-19 15:18:59',1006,1,1,101,NULL,0),(383,113,4,25,1000,'2005-04-19 18:24:16',1008,0,2,119,NULL,382),(385,113,7,25,1000,'2005-04-19 21:00:01',1008,0,2,666,NULL,0),(387,8,17,21,1000,'2005-04-19 23:53:05',1013,0,2,0,NULL,386),(390,8,17,21,1000,'2005-04-19 23:53:26',1013,1,1,0,NULL,0),(391,8,17,21,1000,'2005-04-19 23:53:26',1013,0,2,0,NULL,390),(393,8,17,21,1000,'2005-04-19 23:53:39',1013,0,2,0,NULL,392),(398,1000,8,108,1000,'2005-04-20 02:05:13',1006,1,1,0,NULL,0),(399,1000,8,108,1000,'2005-04-20 02:05:13',1006,0,2,0,NULL,398),(403,4,7,113,1000,'2005-04-20 12:00:01',1008,1,2,0,NULL,0),(404,4,7,119,1000,'2005-04-20 12:00:01',1008,1,2,0,NULL,0),(407,85,7,12,1000,'2005-04-20 12:10:02',1008,1,2,0,NULL,0),(409,1000,1,23,1000,'2005-04-20 14:51:07',1006,1,1,552182240,NULL,0),(411,1000,2,119,1000,'2005-04-20 15:30:59',1006,1,1,552182240,NULL,0),(412,1000,2,119,1000,'2005-04-20 15:30:59',1006,1,2,552182240,NULL,411),(413,82,4,119,1000,'2005-04-20 15:32:06',1008,1,1,552182240,NULL,0),(415,85,4,119,1000,'2005-04-20 15:33:44',1008,1,1,552182240,NULL,0),(416,85,4,119,1000,'2005-04-20 15:33:44',1008,1,2,552182240,NULL,415),(417,74,4,119,1000,'2005-04-20 15:36:50',1008,1,1,552182240,NULL,0),(419,74,7,12,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(420,74,7,113,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(422,4,7,12,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(424,4,7,119,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(425,4,7,12,1000,'2005-04-20 16:00:01',1008,1,2,0,NULL,0),(431,8,20,121,1000,'2005-04-20 19:41:03',1013,1,1,0,NULL,0),(433,8,17,121,1000,'2005-04-20 19:41:25',1013,1,1,0,NULL,0),(434,8,17,121,1000,'2005-04-20 19:41:25',1013,0,2,0,NULL,433),(438,8,20,121,1000,'2005-04-20 19:48:27',1013,0,2,0,NULL,437),(439,8,20,121,1000,'2005-04-20 19:48:50',1013,1,1,0,NULL,0),(446,82,7,119,1000,'2005-04-21 12:00:01',1008,1,2,0,NULL,0),(450,74,7,119,1000,'2005-04-21 12:00:02',1008,1,2,0,NULL,0),(451,4,7,113,1000,'2005-04-21 12:00:02',1008,1,2,0,NULL,0),(453,4,7,12,1000,'2005-04-21 16:00:01',1008,1,2,0,NULL,0),(457,82,7,12,1000,'2005-04-22 12:00:01',1008,1,2,0,NULL,0),(458,4,7,12,1000,'2005-04-25 12:00:01',1008,1,2,0,NULL,0),(460,1000,1,14,1000,'2005-04-26 12:16:06',1006,1,2,552182240,NULL,459),(462,115,6,25,1000,'2005-04-26 19:18:35',1008,1,2,0,NULL,461),(463,1000,3,11,1000,'2005-04-27 11:27:23',1006,1,1,0,NULL,0),(464,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(465,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(466,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(467,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(469,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(470,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(471,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(472,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(473,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(474,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(475,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(478,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(479,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(480,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(481,1000,3,11,1000,'2005-04-27 11:27:23',1006,0,2,0,NULL,463),(482,3,2,11,1000,'2005-04-27 11:29:13',1008,1,1,0,NULL,0),(483,3,2,11,1000,'2005-04-27 11:29:13',1008,1,2,0,NULL,482),(484,74,7,12,1000,'2005-04-27 12:00:01',1008,1,2,0,NULL,0),(485,82,7,12,1000,'2005-04-27 12:00:01',1008,1,2,0,NULL,0),(486,4,7,12,1000,'2005-04-27 12:00:01',1008,1,2,0,NULL,0),(488,1000,1,14,1000,'2005-04-27 12:10:03',1006,1,2,552182240,NULL,487),(489,4,7,12,1000,'2005-04-27 17:45:01',1008,1,2,0,NULL,0),(492,116,4,11,1000,'2005-04-27 19:10:31',1008,1,2,0,NULL,491),(493,116,4,9,1000,'2005-04-27 19:10:45',1008,1,1,552182240,NULL,0); UNLOCK TABLES; /*!40000 ALTER TABLE `end_user_audit` ENABLE KEYS */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; CREATE TABLE `end_user_audit` ( `id` int(11) NOT NULL auto_increment, `target_id` int(11) NOT NULL default '0', `end_user_operation_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `carrier_id` int(11) NOT NULL default '0', `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `target_type_id` int(11) NOT NULL default '0', `status` int(2) NOT NULL default '0', `interface_type` int(2) NOT NULL default '0', `interface_code` int(11) default NULL, `la_id` int(11) default NULL, `parent_id` int(11) default NULL, PRIMARY KEY (`id`), KEY `eua_carrier_id_target_id_timestamp` (`timestamp`,`carrier_id`,`target_id`), KEY `eua_user_id_timestamp` (`user_id`,`timestamp`), KEY `eua_timestamp` (`timestamp`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1; > -> > -> Explain plan on InnoDB > -> > -> > -> > -> +----+-------------+----------------+-------+---------------------- > -> +----+-------------+----------------+-------+------ > -> --- > -> -------------------+---------------+---------+------+--------+----- > -> -------------------+---------------+---------+------+--------+----- > -> -------------------+---------------+---------+------+--------+- > -> --- > -> ------------+ > -> > -> | id | select_type | table | type | possible_keys > -> | key | key_len | ref | rows | Extra | > -> > -> +----+-------------+----------------+-------+---------------------- > -> +----+-------------+----------------+-------+------ > -> --- > -> -------------------+---------------+---------+------+--------+----- > -> -------------------+---------------+---------+------+--------+----- > -> -------------------+---------------+---------+------+--------+- > -> --- > -> ------------+ > -> > -> | 1 | SIMPLE | end_user_audit | range | > -> eua_carrier_id_target_id_timestamp,eua_timestamp | eua_timestamp | > -> 8 | > -> NULL | 202752 | Using where; Using index | > -> > -> > -> > -> > -> > -> > -> Explain plan on NDB > -> > -> > -> > -> | id | select_type | table | type | possible_keys > -> | key | key_len | ref | rows | Extra > -> | > -> > -> +----+-------------+----------------+-------+---------------------- > -> +----+-------------+----------------+-------+------ > -> --- > -> -------------------+------------------------------------+---------+------ > -> +-- > -> ----+-------------+ > -> > -> | 1 | SIMPLE | end_user_audit | range | > -> eua_carrier_id_target_id_timestamp,eua_timestamp | > -> eua_carrier_id_target_id_timestamp | 8 | NULL | 10 | Using where > -> | > -> > -> +----+-------------+----------------+-------+---------------------- > -> +----+-------------+----------------+-------+------ > -> --- > -> -------------------+------------------------------------+---------+------ > -> +-- > -> ----+-------------+ > -> > -> > -> > -> > -> > -> Using FORCE INDEX > -> > -> > -> > -> select id from end_user_audit FORCE INDEX (eua_timestamp) where > -> timestamp > -> >='2005-12-18 02:00:00' and timestamp <'2006-01-01 00:00:00'; > -> > -> > -> > -> NDB explain plan > -> > -> +----+-------------+----------------+-------+---------------+------ > -> +----+-------------+----------------+-------+---------------+------ > -> --- > -> +---------+------+------+-------------+ > -> > -> | id | select_type | table | type | possible_keys | key > -> | key_len | ref | rows | Extra | > -> > -> +----+-------------+----------------+-------+---------------+------ > -> +----+-------------+----------------+-------+---------------+------ > -> --- > -> +---------+------+------+-------------+ > -> > -> | 1 | SIMPLE | end_user_audit | range | eua_timestamp | > -> eua_timestamp > -> | 8 | NULL | 10 | Using where | > -> > -> +----+-------------+----------------+-------+---------------+------ > -> +----+-------------+----------------+-------+---------------+------ > -> --- > -> +---------+------+------+-------------+ > -> > -> > -> > -> > -> > -> Here is what the table looks like. > -> > -> > -> > -> > -> > -> +-----------------------+----------+------+-----+---------------------+-- > -> --- > -> -----------+ > -> > -> | Field | Type | Null | Key | Default | > -> Extra | > -> > -> +-----------------------+----------+------+-----+---------------------+-- > -> --- > -> -----------+ > -> > -> | id | int(11) | NO | PRI | NULL | > -> auto_increment | > -> > -> | target_id | int(11) | NO | | 0 | > -> | > -> > -> | end_user_operation_id | int(11) | NO | | 0 | > -> | > -> > -> | user_id | int(11) | NO | MUL | 0 | > -> | > -> > -> | carrier_id | int(11) | NO | | 0 | > -> | > -> > -> | timestamp | datetime | NO | MUL | 0000-00-00 00:00:00 | > -> | > -> > -> | target_type_id | int(11) | NO | | 0 | > -> | > -> > -> | status | int(2) | NO | | 0 | > -> | > -> > -> | interface_type | int(2) | NO | | 0 | > -> | > -> > -> | interface_code | int(11) | YES | | NULL | > -> | > -> > -> | la_id | int(11) | YES | | NULL | > -> | > -> > -> | parent_id | int(11) | YES | | NULL | > -> | > -> > -> +-----------------------+----------+------+-----+---------------------+-- > -> --- > -> -----------+ > ->