-- MySQL dump 10.10
--
-- Host: localhost    Database: eric
-- ------------------------------------------------------
-- Server version	5.0.26-community-nt

/*!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 `test_table`
--

DROP TABLE IF EXISTS `test_table`;
CREATE TABLE `test_table` (
  `tail_num` char(6) NOT NULL default '',
  `aircraft_serial` char(20) NOT NULL default '',
  `aircraft_model_code` char(7) NOT NULL default '',
  `aircraft_engine_code` char(5) NOT NULL default '',
  `year_built` year(4) NOT NULL default '0000',
  `aircraft_type_id` tinyint(3) unsigned NOT NULL default '0',
  `aircraft_engine_type_id` tinyint(3) unsigned NOT NULL default '0',
  `registrant_type_id` tinyint(3) unsigned NOT NULL default '0',
  `name` char(50) NOT NULL default '',
  `address1` char(33) NOT NULL default '',
  `address2` char(33) NOT NULL default '',
  `city` char(18) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` char(10) NOT NULL default '',
  `region` char(1) NOT NULL default '',
  `county` char(3) NOT NULL default '',
  `country` char(2) NOT NULL default '',
  `certification` char(10) NOT NULL default '',
  `status_code` char(1) NOT NULL default '',
  `mode_s_code` char(8) NOT NULL default '',
  `fract_owner` char(1) NOT NULL default '',
  `last_action_date` date NOT NULL default '0000-00-00',
  `cert_issue_date` date NOT NULL default '0000-00-00',
  `air_worth_date` date NOT NULL default '0000-00-00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test_table`
--

LOCK TABLES `test_table` WRITE;
/*!40000 ALTER TABLE `test_table` DISABLE KEYS */;
INSERT INTO `test_table` VALUES ('N1','1071','3980115','54556',1988,5,4,5,'FEDERAL AVIATION ADMINISTRATION','NATL FLIGHT PROGRAM OVERSIGHT OFC','6125 SW 68TH ST RM 137N','OKLA CITY','OK','73169-1225','2','109','US','1T','V','50000001','','2005-05-20','1990-02-14','1988-09-09'),('N1A','4116','3870220','17025',1971,3,1,3,'GOODYEAR TIRE & RUBBER CO','1144 E MARKET ST','','AKRON','OH','44316-1000','C','153','US','1N','V','50000002','','2003-11-19','2003-11-19','2001-02-28'),('N1AA','0593','2130001','17042',2003,4,1,3,'APPLIED ECONOMICS CONSULTING GROUP INC','2414 EXPOSITION BLVD STE 280','','AUSTIN','TX','78703-2261','2','453','US','1N','V','50000003','','2005-09-20','2003-07-02','2003-06-24'),('N1AC','3138','33601K9','41514',1971,4,1,3,'EAA AVIATION FOUNDATION INC','PO BOX 3065','','OSHKOSH','WI','54903-3065','C','139','US','42','A','50000005','','2005-08-16','0000-00-00','1975-10-17'),('N1AD','81023','05611WQ','41593',2001,4,1,3,'AVIATORS DREAM INC','6627 DOGWOOD CT','','FORT WAYNE','IN','46804-4620','C','003','US','42','A','50000006','','2004-07-20','2001-07-06','2001-10-26');
/*!40000 ALTER TABLE `test_table` 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 2006-11-10  1:23:29