-- MySQL dump 10.11 -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 5.0.40-enterprise-gpl-log /*!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 */; -- -- Table structure for table `tc_a` -- DROP TABLE IF EXISTS `tc_a`; CREATE TABLE `tc_a` ( `id` double NOT NULL auto_increment, `state` char(2) default NULL, `clientcode` double default NULL, KEY `id` (`id`), KEY `clientcode` (`clientcode`) ) ENGINE=MyISAM AUTO_INCREMENT=513 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tc_a` -- LOCK TABLES `tc_a` WRITE; /*!40000 ALTER TABLE `tc_a` DISABLE KEYS */; INSERT INTO `tc_a` VALUES (1,'GA',26),(2,'GA',13),(3,'GA',88),(4,'GA',2),(5,'GA',45),(6,'GA',19),(7,'GA',61),(8,'GA',49),(9,'GA',62),(10,'GA',66),(11,'GA',41),(12,'GA',10),(13,'GA',25),(14,'GA',97),(15,'GA',11),(16,'GA',64),(17,'GA',88),(18,'GA',48),(19,'GA',75),(20,'GA',35),(21,'GA',47),(22,'GA',31),(23,'GA',13),(24,'GA',75),(25,'GA',36),(26,'FL',57),(27,'FL',75),(28,'FL',8),(29,'FL',12),(30,'FL',37),(31,'FL',50),(32,'FL',40),(33,'FL',50),(34,'FL',29),(35,'FL',98),(36,'FL',4),(37,'FL',25),(38,'FL',15),(39,'FL',0),(40,'FL',54),(41,'FL',71),(42,'FL',94),(43,'FL',59),(44,'FL',13),(45,'FL',90),(46,'FL',9),(47,'FL',75),(48,'FL',51),(49,'FL',30),(50,'FL',95),(51,'NC',88),(52,'NC',54),(53,'NC',8),(54,'NC',79),(55,'NC',69),(56,'NC',10),(57,'NC',42),(58,'NC',83),(59,'NC',89),(60,'NC',97),(61,'NC',20),(62,'NC',8),(63,'NC',80),(64,'NC',76),(65,'NC',41),(66,'NC',76),(67,'NC',57),(68,'NC',59),(69,'NC',23),(70,'NC',41),(71,'NC',35),(72,'NC',51),(73,'NC',50),(74,'NC',99),(75,'NC',44),(76,'CA',23),(77,'CA',84),(78,'CA',50),(79,'CA',99),(80,'CA',48),(81,'CA',41),(82,'CA',62),(83,'CA',88),(84,'CA',56),(85,'CA',16),(86,'CA',14),(87,'CA',21),(88,'CA',62),(89,'CA',46),(90,'CA',48),(91,'CA',3),(92,'CA',69),(93,'CA',36),(94,'CA',74),(95,'CA',65),(96,'CA',1),(97,'CA',10),(98,'CA',47),(99,'CA',6),(100,'CA',91),(101,'MI',37),(102,'MI',11),(103,'MI',47),(104,'MI',0),(105,'MI',59),(106,'MI',95),(107,'MI',1),(108,'MI',20),(109,'MI',96),(110,'MI',23),(111,'MI',25),(112,'MI',58),(113,'MI',16),(114,'MI',8),(115,'MI',90),(116,'MI',26),(117,'MI',62),(118,'MI',33),(119,'MI',78),(120,'MI',94),(121,'MI',34),(122,'MI',90),(123,'MI',49),(124,'MI',76),(125,'MI',31),(126,'ND',30),(127,'ND',58),(128,'ND',0),(129,'ND',26),(130,'ND',29),(131,'ND',70),(132,'ND',61),(133,'ND',95),(134,'ND',94),(135,'ND',87),(136,'ND',53),(137,'ND',5),(138,'ND',66),(139,'ND',16),(140,'ND',81),(141,'ND',60),(142,'ND',54),(143,'ND',94),(144,'ND',6),(145,'ND',49),(146,'ND',26),(147,'ND',84),(148,'ND',45),(149,'ND',73),(150,'ND',28),(151,'NY',24),(152,'NY',36),(153,'NY',8),(154,'NY',33),(155,'NY',40),(156,'NY',3),(157,'NY',93),(158,'NY',59),(159,'NY',14),(160,'NY',97),(161,'NY',41),(162,'NY',16),(163,'NY',55),(164,'NY',31),(165,'NY',88),(166,'NY',49),(167,'NY',80),(168,'NY',54),(169,'NY',32),(170,'NY',98),(171,'NY',95),(172,'NY',79),(173,'NY',12),(174,'NY',24),(175,'NY',86),(176,'NY',57),(177,'NY',29),(178,'NY',75),(179,'NY',89),(180,'NY',17),(181,'NY',22),(182,'NY',57),(183,'NY',22),(184,'NY',37),(185,'NY',19),(186,'NY',88),(187,'NY',80),(188,'NY',39),(189,'NY',54),(190,'NY',54),(191,'NY',8),(192,'NY',77),(193,'NY',63),(194,'NY',85),(195,'NY',36),(196,'NY',25),(197,'NY',19),(198,'NY',19),(199,'NY',39),(200,'NY',38),(201,'NY',76),(202,'NY',63),(203,'NY',88),(204,'NY',53),(205,'NY',3),(206,'NY',55),(207,'NY',65),(208,'NY',62),(209,'NY',16),(210,'NY',92),(211,'NY',15),(212,'NY',0),(213,'NY',52),(214,'NY',64),(215,'NY',64),(216,'NY',29),(217,'NY',53),(218,'NY',77),(219,'NY',28),(220,'NY',11),(221,'NY',71),(222,'NY',22),(223,'NY',97),(224,'NY',18),(225,'NY',1),(226,'NY',50),(227,'NY',48),(228,'NY',91),(229,'NY',10),(230,'NY',77),(231,'NY',56),(232,'NY',48),(233,'NY',75),(234,'NY',31),(235,'NY',30),(236,'NY',60),(237,'NY',8),(238,'NY',60),(239,'NY',76),(240,'NY',3),(241,'NY',88),(242,'NY',32),(243,'NY',97),(244,'NY',89),(245,'NY',54),(246,'NY',3),(247,'NY',54),(248,'NY',63),(249,'NY',53),(250,'NY',75),(251,'NY',18),(252,'NY',67),(253,'NY',79),(254,'NY',96),(255,'NY',43),(256,'NY',26),(257,'NY',3),(258,'NY',39),(259,'NY',86),(260,'NY',11),(261,'NY',99),(262,'NY',61),(263,'NY',11),(264,'NY',71),(265,'NY',21),(266,'NY',93),(267,'NY',2),(268,'NY',34),(269,'NY',63),(270,'NY',15),(271,'NY',87),(272,'NY',91),(273,'NY',93),(274,'NY',93),(275,'NY',88),(276,'NY',62),(277,'NY',45),(278,'NY',38),(279,'NY',56),(280,'NY',67),(281,'NY',66),(282,'NY',29),(283,'NY',47),(284,'NY',51),(285,'NY',15),(286,'NY',20),(287,'NY',56),(288,'NY',23),(289,'NY',46),(290,'NY',60),(291,'NY',62),(292,'NY',33),(293,'NY',79),(294,'NY',95),(295,'NY',41),(296,'NY',20),(297,'NY',77),(298,'NY',24),(299,'NY',91),(300,'NY',82),(301,'NY',38),(302,'NY',43),(303,'NY',1),(304,'NY',78),(305,'NY',88),(306,'NY',7),(307,'NY',70),(308,'NY',30),(309,'NY',39),(310,'NY',6),(311,'NY',13),(312,'NY',49),(313,'NY',5),(314,'NY',77),(315,'NY',72),(316,'NY',30),(317,'NY',32),(318,'NY',72),(319,'NY',66),(320,'NY',14),(321,'NY',72),(322,'NY',20),(323,'NY',83),(324,'NY',57),(325,'NY',35),(326,'NY',6),(327,'NY',25),(328,'NY',9),(329,'NY',70),(330,'NY',24),(331,'NY',12),(332,'NY',85),(333,'NY',93),(334,'NY',8),(335,'NY',62),(336,'NY',86),(337,'NY',47),(338,'NY',76),(339,'NY',38),(340,'NY',63),(341,'NY',2),(342,'NY',22),(343,'NY',3),(344,'NY',50),(345,'NY',41),(346,'NY',58),(347,'NY',67),(348,'NY',59),(349,'NY',95),(350,'NY',0),(351,'NY',13),(352,'NY',67),(353,'NY',95),(354,'NY',75),(355,'NY',93),(356,'NY',38),(357,'NY',10),(358,'NY',40),(359,'NY',68),(360,'NY',22),(361,'NY',6),(362,'NY',66),(363,'NY',11),(364,'NY',56),(365,'NY',51),(366,'NY',85),(367,'NY',72),(368,'NY',7),(369,'NY',20),(370,'NY',77),(371,'NY',25),(372,'NY',97),(373,'NY',11),(374,'NY',64),(375,'NY',87),(376,'NY',45),(377,'NY',64),(378,'NY',87),(379,'NY',41),(380,'NY',44),(381,'NY',97),(382,'NY',53),(383,'NY',75),(384,'NY',15),(385,'NY',54),(386,'NY',22),(387,'NY',51),(388,'NY',87),(389,'NY',82),(390,'NY',51),(391,'NY',11),(392,'NY',3),(393,'NY',82),(394,'NY',99),(395,'NY',51),(396,'NY',56),(397,'NY',31),(398,'NY',87),(399,'NY',42),(400,'NY',49),(401,'NY',21),(402,'NY',57),(403,'NY',24),(404,'NY',49),(405,'NY',75),(406,'NY',27),(407,'NY',10),(408,'NY',70),(409,'NY',21),(410,'NY',96),(411,'NY',17),(412,'NY',97),(413,'NY',34),(414,'NY',78),(415,'NY',91),(416,'NY',20),(417,'NY',28),(418,'NY',81),(419,'NY',19),(420,'NY',54),(421,'NY',14),(422,'NY',10),(423,'NY',7),(424,'NY',4),(425,'NY',1),(426,'NY',91),(427,'NY',55),(428,'NY',0),(429,'NY',37),(430,'NY',85),(431,'NY',15),(432,'NY',20),(433,'NY',55),(434,'NY',17),(435,'NY',20),(436,'NY',48),(437,'NY',81),(438,'NY',60),(439,'NY',58),(440,'NY',10),(441,'NY',77),(442,'NY',56),(443,'NY',51),(444,'NY',85),(445,'NY',74),(446,'NY',14),(447,'NY',50),(448,'NY',6),(449,'NY',83),(450,'NY',96),(451,'NY',31),(452,'NY',68),(453,'NY',49),(454,'NY',40),(455,'NY',54),(456,'NY',48),(457,'NY',82),(458,'NY',65),(459,'NY',80),(460,'NY',4),(461,'NY',80),(462,'NY',89),(463,'NY',4),(464,'NY',56),(465,'NY',70),(466,'NY',79),(467,'NY',86),(468,'NY',94),(469,'NY',14),(470,'NY',88),(471,'NY',97),(472,'NY',23),(473,'NY',25),(474,'NY',55),(475,'NY',1),(476,'NY',41),(477,'NY',2),(478,'NY',86),(479,'NY',27),(480,'NY',76),(481,'NY',98),(482,'NY',65),(483,'NY',29),(484,'NY',52),(485,'NY',73),(486,'NY',11),(487,'NY',35),(488,'NY',44),(489,'NY',16),(490,'NY',46),(491,'NY',82),(492,'NY',74),(493,'NY',24),(494,'NY',99),(495,'NY',24),(496,'NY',24),(497,'NY',47),(498,'NY',64),(499,'NY',80),(500,'NY',10),(501,'NY',8),(502,'NY',13),(503,'NY',42),(504,'NY',71),(505,'NY',30),(506,'NY',37),(507,'NY',93),(508,'NY',58),(509,'NY',11),(510,'NY',81),(511,'NY',73),(512,'NY',23); /*!40000 ALTER TABLE `tc_a` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tc_b` -- DROP TABLE IF EXISTS `tc_b`; CREATE TABLE `tc_b` ( `id` double default NULL, KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tc_b` -- LOCK TABLES `tc_b` WRITE; /*!40000 ALTER TABLE `tc_b` DISABLE KEYS */; INSERT INTO `tc_b` VALUES (2),(11),(12),(16),(17),(18),(20),(27),(35),(36),(39),(44),(46),(54),(63),(68),(72),(81),(83),(85),(88),(91),(93),(95),(107),(108),(116),(122),(125),(138),(143),(144),(145),(146),(147),(153),(157),(180),(182),(186),(189),(202),(211),(212),(213),(214),(237),(238),(240),(242),(244),(246),(250),(252),(253),(256),(258),(276),(277),(278),(288),(289),(297),(304),(314),(317),(318),(323),(331),(336),(342),(353),(357),(364),(380),(383),(393),(396),(401),(407),(408),(410),(412),(414),(420),(429),(431),(432),(447),(452),(472),(484),(488),(492),(500),(501),(505),(506),(511),(512); /*!40000 ALTER TABLE `tc_b` ENABLE KEYS */; UNLOCK TABLES; /*!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 */; -- Dump completed on 2007-05-09 16:50:16