-- MySQL dump 10.13  Distrib 5.6.14, for osx10.7 (i386)
--
-- Host: localhost    Database: wmdb
-- ------------------------------------------------------
-- Server version	5.6.14

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

DROP TABLE IF EXISTS `testCrash`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testCrash` (
  `orderid` int(11) NOT NULL DEFAULT '0',
  `customerid` int(11) NOT NULL,
  `customertype` varchar(45) DEFAULT 'Standard',
  `orderDate` date DEFAULT NULL,
  `subtotal` varchar(45) DEFAULT NULL,
  `tax` decimal(13,4) DEFAULT NULL,
  `shippingquote` decimal(13,4) DEFAULT NULL,
  `total` decimal(13,4) DEFAULT NULL,
  `terms` int(11) DEFAULT '2',
  `comment` text,
  `tmpcc` varchar(45) DEFAULT NULL,
  `shippingaddressid` int(11) DEFAULT NULL,
  `billingaddressid` int(11) DEFAULT NULL,
  `customerrefnum` varchar(45) DEFAULT NULL,
  `customerreftype` varchar(45) DEFAULT NULL,
  `shippingmethod` varchar(45) DEFAULT NULL,
  `salesperson` varchar(45) DEFAULT NULL,
  `ordermethod` int(11) DEFAULT NULL,
  `ccseccode` int(11) DEFAULT NULL,
  `ccexp` varchar(45) DEFAULT NULL,
  `ordernote` text,
  `ordertype` varchar(45) DEFAULT NULL,
  `orderstatus` varchar(45) DEFAULT 'NEW',
  `ordercontactname` varchar(255) DEFAULT NULL,
  `ordercontactphone` varchar(255) DEFAULT NULL,
  `ordercontactfax` varchar(255) DEFAULT NULL,
  `ordercontactemail` varchar(255) DEFAULT NULL,
  `bankinfo` int(11) DEFAULT '0',
  `cardholder` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testCrash`
--

LOCK TABLES `testCrash` WRITE;
/*!40000 ALTER TABLE `testCrash` DISABLE KEYS */;
INSERT INTO `testCrash` VALUES (51184,0,'Academic','2010-08-16','7.35000000000000000e+02',NULL,7.0000,742.0000,2,NULL,NULL,148367,148368,'',NULL,NULL,'CH',NULL,NULL,NULL,NULL,'Quote','NEW','Dr. Foo Bar','555-555-5555','','sales@wavemetrics.com',0,NULL),(55860,0,'Standard','2012-06-15','5.95000000000000000e+02',NULL,0.0000,595.0000,2,NULL,NULL,163230,163231,'',NULL,NULL,'CH',NULL,NULL,NULL,NULL,'Quote','NEW','Dr. Foo Bar','555-555-5555','','sales@wavemetrics.com',0,NULL),(55988,0,'Academic','2012-07-03','1.91750000000000000e+03',NULL,0.0000,1917.5000,2,NULL,NULL,163615,163616,'',NULL,NULL,'CH',NULL,NULL,NULL,NULL,'Quote','NEW','Dr. Foo Bar','555-555-5555','','sales@wavemetrics.com',0,NULL),(62538,0,'Standard','2015-04-07','1.25000000000000000e+02',NULL,0.0000,125.0000,2,NULL,NULL,186009,186010,NULL,NULL,NULL,'AG',NULL,NULL,NULL,NULL,'Quote','NEW','Dr. Foo Bar','555-555-5555','','sales@wavemetrics.com',0,NULL),(65594,0,'Standard','2016-07-27',NULL,NULL,NULL,0.0000,2,NULL,NULL,194576,194577,NULL,NULL,NULL,'AG',NULL,NULL,NULL,NULL,NULL,'NEW','Dr. Foo Bar','555-555-5555',NULL,'sales@wavemetrics.com',0,NULL),(70013,0,'Academic','2017-08-21','1.39800000000000000e+03',NULL,0.0000,1398.0000,1,NULL,'',205103,205104,'','P.O. Number',NULL,'AG',NULL,NULL,'',NULL,'Quote','NEW','Dr. Foo Bar','555-555-5555','','sales@wavemetrics.com',0,'');
/*!40000 ALTER TABLE `testCrash` 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 2017-10-23 14:56:40