DROP TABLE IF EXISTS `C`;
CREATE TABLE `C` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `int_nokey` int(11) NOT NULL,
  `int_key` int(11) NOT NULL,
  `date_key` date NOT NULL,
  `date_nokey` date NOT NULL,
  `time_key` time NOT NULL,
  `time_nokey` time NOT NULL,
  `datetime_key` datetime NOT NULL,
  `datetime_nokey` datetime NOT NULL,
  `varchar_key` varchar(1) NOT NULL,
  `varchar_nokey` varchar(1) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `int_key` (`int_key`),
  KEY `date_key` (`date_key`),
  KEY `time_key` (`time_key`),
  KEY `datetime_key` (`datetime_key`),
  KEY `varchar_key` (`varchar_key`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `C`
--

LOCK TABLES `C` WRITE;
/*!40000 ALTER TABLE `C` DISABLE KEYS */;
INSERT INTO `C` VALUES (1,0,8,'0000-00-00','0000-00-00','00:16:10','00:16:10','2008-09-03 14:25:40','2008-09-03 14:25:40','h','h'),(2,7,1,'2008-05-01','2008-05-01','00:00:00','00:00:00','2001-01-13 00:00:00','2001-01-13 00:00:00','',''),(3,0,2,'2002-02-04','2002-02-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','x','x'),(4,2,2,'0000-00-00','0000-00-00','16:29:24','16:29:24','2000-10-16 01:39:08','2000-10-16 01:39:08','w','w'),(5,1,0,'0000-00-00','0000-00-00','09:23:32','09:23:32','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'),(6,3,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-12-02 00:00:00','2007-12-02 00:00:00','o','o'),(7,3,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','2008-09-11 00:00:00','2008-09-11 00:00:00','',''),(8,0,6,'0000-00-00','0000-00-00','13:59:04','13:59:04','0000-00-00 00:00:00','0000-00-00 00:00:00','s','s'),(9,7,9,'2005-02-05','2005-02-05','09:01:06','09:01:06','0000-00-00 00:00:00','0000-00-00 00:00:00','d','d'),(10,5,2,'2005-12-12','2005-12-12','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','n','n'),(11,0,1,'2001-02-27','2001-02-27','21:06:46','21:06:46','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'),(12,2,2,'2001-09-05','2001-09-05','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(13,6,7,'0000-00-00','0000-00-00','14:45:34','14:45:34','2003-07-28 02:34:08','2003-07-28 02:34:08','w','w'),(14,1,4,'2000-10-11','2000-10-11','15:04:12','15:04:12','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'),(15,0,8,'2006-04-10','2006-04-10','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','x','x'),(16,0,9,'2005-03-26','2005-03-26','15:55:23','15:55:23','2004-03-17 00:32:27','2004-03-17 00:32:27','p','p'),(17,1,0,'2003-02-03','2003-02-03','16:30:00','16:30:00','2004-12-27 19:20:00','2004-12-27 19:20:00','d','d'),(18,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','h','h'),(19,0,4,'0000-00-00','0000-00-00','14:13:26','14:13:26','2008-11-09 05:53:48','2008-11-09 05:53:48','o','o'),(20,0,0,'2004-01-20','2004-01-20','00:00:00','00:00:00','2009-10-11 06:58:04','2009-10-11 06:58:04','k','k');
/*!40000 ALTER TABLE `C` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `BB`
--

DROP TABLE IF EXISTS `BB`;
CREATE TABLE `BB` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `int_nokey` int(11) NOT NULL,
  `int_key` int(11) NOT NULL,
  `date_key` date NOT NULL,
  `date_nokey` date NOT NULL,
  `time_key` time NOT NULL,
  `time_nokey` time NOT NULL,
  `datetime_key` datetime NOT NULL,
  `datetime_nokey` datetime NOT NULL,
  `varchar_key` varchar(1) NOT NULL,
  `varchar_nokey` varchar(1) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `int_key` (`int_key`),
  KEY `date_key` (`date_key`),
  KEY `time_key` (`time_key`),
  KEY `datetime_key` (`datetime_key`),
  KEY `varchar_key` (`varchar_key`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BB`
--

LOCK TABLES `BB` WRITE;
/*!40000 ALTER TABLE `BB` DISABLE KEYS */;
INSERT INTO `BB` VALUES (10,0,8,'2005-03-23','2005-03-23','19:39:13','19:39:13','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'),(11,8,5,'2000-11-14','2000-11-14','03:43:53','03:43:53','0000-00-00 00:00:00','0000-00-00 00:00:00','b','b');
/*!40000 ALTER TABLE `BB` ENABLE KEYS */;
UNLOCK TABLES;