-- MySQL dump 10.11
--
-- Host: localhost    Database: kleiner3_ukklein
-- ------------------------------------------------------
-- Server version	5.0.89-community

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

DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
  `addID` int(11) NOT NULL auto_increment,
  `addCustID` int(11) default '0',
  `addIsDefault` tinyint(4) default '0',
  `addName` varchar(255) default NULL,
  `addLastName` varchar(255) default NULL,
  `addAddress` varchar(255) default NULL,
  `addAddress2` varchar(255) default NULL,
  `addCity` varchar(255) default NULL,
  `addState` varchar(255) default NULL,
  `addZip` varchar(255) default NULL,
  `addCountry` varchar(255) default NULL,
  `addPhone` varchar(255) default NULL,
  `addShipFlags` tinyint(4) default '0',
  `addExtra1` varchar(255) default NULL,
  `addExtra2` varchar(255) default NULL,
  PRIMARY KEY  (`addID`),
  KEY `addCustID` (`addCustID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address`
--

LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin` (
  `adminID` int(11) NOT NULL,
  `adminVersion` varchar(100) default NULL,
  `adminUser` varchar(50) default NULL,
  `adminPassword` varchar(50) default NULL,
  `adminEmail` varchar(75) default NULL,
  `adminStoreURL` varchar(255) default NULL,
  `adminProdsPerPage` int(11) default '0',
  `adminShipping` int(11) default '0',
  `adminIntShipping` int(11) default '0',
  `adminCountry` int(11) default '0',
  `adminZipCode` varchar(50) default NULL,
  `adminUSPSUser` varchar(255) default NULL,
  `adminUSPSpw` varchar(255) default NULL,
  `adminUPSUser` varchar(255) default NULL,
  `adminUPSpw` varchar(255) default NULL,
  `adminUPSAccess` varchar(255) default NULL,
  `FedexAccountNo` varchar(255) default NULL,
  `FedexMeter` varchar(255) default NULL,
  `adminCanPostUser` varchar(255) default NULL,
  `adminEmailConfirm` tinyint(4) default '0',
  `adminPacking` tinyint(4) default '0',
  `adminDelUncompleted` int(11) default '0',
  `adminUSZones` tinyint(4) default '0',
  `adminUnits` tinyint(4) default '0',
  `adminStockManage` int(11) default '0',
  `adminHandling` double default '0',
  `adminHandlingPercent` double default '0',
  `adminTweaks` int(11) default '0',
  `adminCert` text,
  `adminUPSLicense` text,
  `adminDelCC` int(11) default '0',
  `adminClearCart` int(11) default '0',
  `adminlanguages` int(11) default '0',
  `adminlangsettings` int(11) default '0',
  `adminSecret` varchar(255) default NULL,
  `updLastCheck` date default NULL,
  `updRecommended` varchar(255) default NULL,
  `updSecurity` tinyint(1) default '0',
  `updShouldUpd` tinyint(1) default '0',
  `adminUPSAccount` varchar(255) default NULL,
  `adminUPSNegotiated` tinyint(4) default '0',
  `currRate1` double default '0',
  `currSymbol1` varchar(50) default NULL,
  `currRate2` double default '0',
  `currSymbol2` varchar(50) default NULL,
  `currRate3` double default '0',
  `currSymbol3` varchar(50) default NULL,
  `currConvUser` varchar(50) default NULL,
  `currConvPw` varchar(50) default NULL,
  `currLastUpdate` datetime default NULL,
  PRIMARY KEY  (`adminID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,'Ecommerce Plus PHP v5.8.3','mike','luckyboy','you@yourstoreurl.com','http://69.175.104.170/~kleiner3/',8,2,0,1,'YOURZIP','','','','','',NULL,NULL,NULL,0,0,4,0,1,0,0,0,0,'',NULL,7,0,0,0,NULL,'2010-03-15','5.9.2',1,1,NULL,0,0,NULL,0,NULL,0,NULL,NULL,NULL,'2010-03-14 10:52:30');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `adminlogin`
--

DROP TABLE IF EXISTS `adminlogin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adminlogin` (
  `adminloginid` int(11) NOT NULL auto_increment,
  `adminloginname` varchar(255) NOT NULL,
  `adminloginpassword` varchar(255) NOT NULL,
  `adminloginpermissions` varchar(255) NOT NULL,
  PRIMARY KEY  (`adminloginid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adminlogin`
--

LOCK TABLES `adminlogin` WRITE;
/*!40000 ALTER TABLE `adminlogin` DISABLE KEYS */;
/*!40000 ALTER TABLE `adminlogin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `affiliates`
--

DROP TABLE IF EXISTS `affiliates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `affiliates` (
  `affilID` varchar(32) NOT NULL,
  `affilPW` varchar(32) default NULL,
  `affilEmail` varchar(128) default NULL,
  `affilName` varchar(255) default NULL,
  `affilAddress` varchar(255) default NULL,
  `affilCity` varchar(255) default NULL,
  `affilState` varchar(255) default NULL,
  `affilZip` varchar(255) default NULL,
  `affilCountry` varchar(255) default NULL,
  `affilInform` tinyint(4) default '0',
  `affilDate` date default NULL,
  `affilCommision` double default '0',
  PRIMARY KEY  (`affilID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `affiliates`
--

LOCK TABLES `affiliates` WRITE;
/*!40000 ALTER TABLE `affiliates` DISABLE KEYS */;
/*!40000 ALTER TABLE `affiliates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cart` (
  `cartID` int(11) NOT NULL auto_increment,
  `cartSessionID` varchar(100) default NULL,
  `cartProdID` varchar(255) default NULL,
  `cartProdName` varchar(255) default NULL,
  `cartProdPrice` double default NULL,
  `cartDateAdded` datetime default NULL,
  `cartQuantity` int(11) default '0',
  `cartOrderID` int(11) default '0',
  `cartClientID` int(11) default '0',
  `cartCompleted` tinyint(4) default NULL,
  `cartListID` int(11) default '0',
  PRIMARY KEY  (`cartID`),
  KEY `cartClientID` (`cartClientID`),
  KEY `cartListID` (`cartListID`),
  KEY `cartProdID` (`cartProdID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart`
--

LOCK TABLES `cart` WRITE;
/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
INSERT INTO `cart` VALUES (1,'935000845','pc001','#1 PC multimedia package',1200,'2010-03-15 14:39:10',1,501,0,1,0);
/*!40000 ALTER TABLE `cart` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cartoptions`
--

DROP TABLE IF EXISTS `cartoptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cartoptions` (
  `coID` int(11) NOT NULL auto_increment,
  `coCartID` int(11) default NULL,
  `coOptID` int(11) default NULL,
  `coOptGroup` varchar(255) default NULL,
  `coCartOption` varchar(255) default NULL,
  `coPriceDiff` double default '0',
  `coWeightDiff` double default '0',
  PRIMARY KEY  (`coID`),
  KEY `coCartID` (`coCartID`),
  KEY `coOptID` (`coOptID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cartoptions`
--

LOCK TABLES `cartoptions` WRITE;
/*!40000 ALTER TABLE `cartoptions` DISABLE KEYS */;
INSERT INTO `cartoptions` VALUES (1,1,23,'Processor','Intel Pentium IV 1.5GHz',25.5,0),(2,1,28,'Hard Disk','60 Gigabytes',34,0),(3,1,30,'Monitor','15\" Standard',0,0),(4,1,35,'Network Card','Yes',15,0);
/*!40000 ALTER TABLE `cartoptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `countryID` int(11) NOT NULL,
  `countryName` varchar(255) default NULL,
  `countryName2` varchar(255) default NULL,
  `countryName3` varchar(255) default NULL,
  `countryEnabled` tinyint(4) default '0',
  `countryTax` double default '0',
  `countryOrder` int(11) default '0',
  `countryZone` int(11) default '0',
  `countryLCID` varchar(50) default NULL,
  `countryCurrency` varchar(50) default NULL,
  `countryCode` varchar(50) default NULL,
  `countryFreeShip` tinyint(4) default '0',
  PRIMARY KEY  (`countryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `countries`
--

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (1,'United States of America','United States of America','United States of America',1,0,2,1,'en_US','USD','US',0),(2,'Canada','Canada','Canada',1,0,0,2,'en_CA','CAD','CA',0),(3,'Afghanistan','Afghanistan','Afghanistan',0,0,0,4,'','AFA','AF',0),(4,'Albania','Albania','Albania',0,0,0,4,'','ALL','AL',0),(5,'Algeria','Algeria','Algeria',0,0,0,4,'','DZD','DZ',0),(6,'Andorra','Andorra','Andorra',0,0,0,3,'','EUR','AD',0),(7,'Angola','Angola','Angola',0,0,0,4,'','AOA','AO',0),(8,'Anguilla','Anguilla','Anguilla',0,0,0,4,'','XCD','AI',0),(10,'Antigua and Barbuda','Antigua and Barbuda','Antigua and Barbuda',0,0,0,4,'','XCD','AG',0),(11,'Argentina','Argentina','Argentina',1,0,0,2,'es_AR','ARS','AR',0),(12,'Armenia','Armenia','Armenia',0,0,0,4,'','AMD','AM',0),(13,'Aruba','Aruba','Aruba',0,0,0,4,'','AWG','AW',0),(14,'Australia','Australia','Australia',1,0,0,4,'en_AU','AUD','AU',0),(15,'Austria','Austria','Austria',1,0,0,3,'de_AT','EUR','AT',0),(16,'Azerbaijan','Azerbaijan','Azerbaijan',0,0,0,4,'','AZM','AZ',0),(17,'Bahamas','Bahamas','Bahamas',1,0,0,4,'en_US','BSD','BS',0),(18,'Bahrain','Bahrain','Bahrain',0,0,0,4,'','BHD','BH',0),(19,'Bangladesh','Bangladesh','Bangladesh',0,0,0,4,'','BDT','BD',0),(20,'Barbados','Barbados','Barbados',0,0,0,4,'','BBD','BB',0),(21,'Belarus','Belarus','Belarus',0,0,0,4,'','BYR','BY',0),(22,'Belgium','Belgium','Belgium',1,0,0,3,'fr_BE','EUR','BE',0),(23,'Belize','Belize','Belize',0,0,0,4,'','BZD','BZ',0),(24,'Benin','Benin','Benin',0,0,0,4,'','XOF','BJ',0),(25,'Bermuda','Bermuda','Bermuda',0,0,0,4,'','BMD','BM',0),(26,'Bhutan','Bhutan','Bhutan',0,0,0,4,'','BTN','BT',0),(27,'Bolivia','Bolivia','Bolivia',0,0,0,2,'','BOB','BO',0),(28,'Bosnia-Herzegovina','Bosnia-Herzegovina','Bosnia-Herzegovina',0,0,0,4,'','BAM','BA',0),(29,'Botswana','Botswana','Botswana',0,0,0,4,'','BWP','BW',0),(30,'Brazil','Brazil','Brazil',1,0,0,2,'pt_BR','BRL','BR',0),(31,'Brunei Darussalam','Brunei Darussalam','Brunei Darussalam',0,0,0,4,'','BND','BN',0),(32,'Bulgaria','Bulgaria','Bulgaria',0,0,0,4,'','BGL','BG',0),(33,'Burkina Faso','Burkina Faso','Burkina Faso',0,0,0,4,'','XOF','BF',0),(34,'Burundi','Burundi','Burundi',0,0,0,4,'','BIF','BI',0),(35,'Cambodia','Cambodia','Cambodia',0,0,0,4,'','KHR','KH',0),(36,'Cameroon','Cameroon','Cameroon',0,0,0,4,'','XAF','CM',0),(37,'Cape Verde','Cape Verde','Cape Verde',0,0,0,4,'','CVE','CV',0),(38,'Cayman Islands','Cayman Islands','Cayman Islands',0,0,0,4,'','KYD','KY',0),(39,'Central African Republic','Central African Republic','Central African Republic',0,0,0,4,'','XAF','CF',0),(40,'Chad','Chad','Chad',0,0,0,4,'','XAF','TD',0),(41,'Chile','Chile','Chile',1,0,0,2,'es_CL','CHL','CL',0),(42,'China','China','China',0,0,0,4,'','CNY','CN',0),(43,'Colombia','Colombia','Colombia',0,0,0,2,'','COP','CO',0),(44,'Comoros','Comoros','Comoros',0,0,0,4,'','KMF','KM',0),(45,'Costa Rica','Costa Rica','Costa Rica',1,0,0,2,'es_CR','CRI','CR',0),(46,'Croatia','Croatia','Croatia',0,0,0,4,'','HRK','HR',0),(47,'Cuba','Cuba','Cuba',0,0,0,4,'','CUP','CU',0),(48,'Cyprus','Cyprus','Cyprus',0,0,0,4,'','CYP','CY',0),(49,'Czech Republic','Czech Republic','Czech Republic',0,0,0,4,'','CZK','CZ',0),(50,'Denmark','Denmark','Denmark',1,0,0,3,'da_DK','DKK','DK',0),(51,'Djibouti','Djibouti','Djibouti',0,0,0,4,'','DJF','DJ',0),(52,'Dominica','Dominica','Dominica',0,0,0,4,'','XCD','DM',0),(53,'Dominican Republic','Dominican Republic','Dominican Republic',1,0,0,4,'','DOP','DO',0),(54,'East Timor','East Timor','East Timor',0,0,0,4,'','IDR','TP',0),(55,'Ecuador','Ecuador','Ecuador',0,0,0,4,'','USD','EC',0),(56,'Egypt','Egypt','Egypt',0,0,0,4,'','EGP','EG',0),(57,'El Salvador','El Salvador','El Salvador',0,0,0,2,'','SVC','SV',0),(58,'Equatorial Guinea','Equatorial Guinea','Equatorial Guinea',0,0,0,4,'','XAF','GQ',0),(59,'Estonia','Estonia','Estonia',0,0,0,4,'','EEK','EE',0),(60,'Ethiopia','Ethiopia','Ethiopia',0,0,0,4,'','ETB','ET',0),(61,'Falkland Islands','Falkland Islands','Falkland Islands',0,0,0,4,'','FKP','FK',0),(62,'Faroe Islands','Faroe Islands','Faroe Islands',0,0,0,4,'','DKK','FO',0),(63,'Fiji','Fiji','Fiji',0,0,0,4,'','FJD','FJ',0),(64,'Finland','Finland','Finland',1,0,0,3,'su_FI','EUR','FI',0),(65,'France','France','France',1,0,0,3,'fr_FR','EUR','FR',0),(66,'French Guiana','French Guiana','French Guiana',0,0,0,4,'','EUR','GF',0),(67,'French Polynesia','French Polynesia','French Polynesia',0,0,0,4,'','XPF','PF',0),(68,'Gabon','Gabon','Gabon',0,0,0,4,'','XAF','GA',0),(69,'Gambia','Gambia','Gambia',0,0,0,4,'','GMD','GM',0),(70,'Georgia, Republic of','Georgia, Republic of','Georgia, Republic of',0,0,0,4,'','GEL','GE',0),(71,'Germany','Germany','Germany',1,0,0,3,'de_DE','EUR','DE',0),(72,'Ghana','Ghana','Ghana',0,0,0,4,'','GHC','GH',0),(73,'Gibraltar','Gibraltar','Gibraltar',1,0,0,3,'','GBP','GI',0),(74,'Greece','Greece','Greece',1,0,0,3,'el_GR','EUR','GR',0),(75,'Greenland','Greenland','Greenland',1,0,0,3,'','DKK','GL',0),(76,'Grenada','Grenada','Grenada',0,0,0,4,'','XCD','GD',0),(77,'Guadeloupe','Guadeloupe','Guadeloupe',0,0,0,4,'','EUR','GP',0),(78,'Guam','Guam','Guam',0,0,0,1,'','USD','GU',0),(79,'Guatemala','Guatemala','Guatemala',1,0,0,2,'es_GT','GTQ','GT',0),(80,'Guinea','Guinea','Guinea',0,0,0,4,'','GNF','GN',0),(81,'Guinea-Bissau','Guinea-Bissau','Guinea-Bissau',0,0,0,4,'','XOF','GW',0),(82,'Guyana','Guyana','Guyana',0,0,0,2,'','GYD','GY',0),(83,'Haiti','Haiti','Haiti',0,0,0,4,'','USD','HT',0),(84,'Honduras','Honduras','Honduras',0,0,0,2,'','HNL','HN',0),(85,'Hong Kong','Hong Kong','Hong Kong',1,0,0,4,'en_HK','HKD','HK',0),(86,'Hungary','Hungary','Hungary',0,0,0,4,'hu_HU','HUF','HU',0),(87,'Iceland','Iceland','Iceland',1,0,0,3,'','ISK','IS',0),(88,'India','India','India',0,0,0,4,'en_IN','INR','IN',0),(89,'Indonesia','Indonesia','Indonesia',0,0,0,4,'','IDR','ID',0),(90,'Iraq','Iraq','Iraq',0,0,0,4,'','IQD','IQ',0),(91,'Ireland','Ireland','Ireland',1,0,0,3,'en_IE','EUR','IE',0),(92,'Israel','Israel','Israel',1,0,0,4,'','ILS','IL',0),(93,'Italy','Italy','Italy',1,0,0,3,'it_IT','EUR','IT',0),(94,'Jamaica','Jamaica','Jamaica',0,0,0,4,'','JMD','JM',0),(95,'Japan','Japan','Japan',1,0,0,4,'jp_JP','JPY','JP',0),(96,'Jordan','Jordan','Jordan',0,0,0,4,'','JOD','JO',0),(97,'Kazakhstan','Kazakhstan','Kazakhstan',0,0,0,4,'','KZT','KZ',0),(98,'Kenya','Kenya','Kenya',0,0,0,4,'','KES','KE',0),(99,'Kiribati','Kiribati','Kiribati',0,0,0,4,'','AUD','KI',0),(100,'North Korea','North Korea','North Korea',0,0,0,4,'ko_KR','KPW','KP',0),(101,'South Korea','South Korea','South Korea',0,0,0,4,'','KRW','KR',0),(102,'Kuwait','Kuwait','Kuwait',0,0,0,4,'','KWD','KW',0),(103,'Latvia','Latvia','Latvia',0,0,0,4,'','LVL','LV',0),(104,'Lebanon','Lebanon','Lebanon',0,0,0,4,'','LBP','LB',0),(105,'Lesotho','Lesotho','Lesotho',0,0,0,4,'','LSL','LS',0),(106,'Liberia','Liberia','Liberia',0,0,0,4,'','LRD','LR',0),(107,'England','England','England',0,0,0,3,'','GBP','GB',0),(108,'Liechtenstein','Liechtenstein','Liechtenstein',0,0,0,4,'','CHF','LI',0),(109,'Lithuania','Lithuania','Lithuania',0,0,0,4,'','LTL','LT',0),(110,'Luxembourg','Luxembourg','Luxembourg',1,0,0,3,'','EUR','LU',0),(111,'Macao','Macao','Macao',0,0,0,4,'','MOP','MO',0),(112,'Macedonia, Republic of','Macedonia, Republic of','Macedonia, Republic of',0,0,0,4,'','MKD','MK',0),(113,'Madagascar','Madagascar','Madagascar',0,0,0,4,'','MGF','MG',0),(114,'Malawi','Malawi','Malawi',0,0,0,4,'','MWK','MW',0),(115,'Malaysia','Malaysia','Malaysia',1,0,0,4,'','MYR','MY',0),(116,'Maldives','Maldives','Maldives',0,0,0,4,'','MVR','MV',0),(117,'Mali','Mali','Mali',0,0,0,4,'','XOF','ML',0),(118,'Malta','Malta','Malta',0,0,0,4,'','MTL','MT',0),(119,'Martinique','Martinique','Martinique',0,0,0,4,'','EUR','MQ',0),(120,'Mauritania','Mauritania','Mauritania',0,0,0,4,'','MRO','MR',0),(121,'Mauritius','Mauritius','Mauritius',0,0,0,4,'','MUR','MU',0),(122,'Mexico','Mexico','Mexico',1,0,0,2,'es_MX','MXN','MX',0),(123,'Moldova','Moldova','Moldova',0,0,0,4,'','MDL','MD',0),(124,'Monaco','Monaco','Monaco',1,0,0,3,'','FRF','MC',0),(125,'Mongolia','Mongolia','Mongolia',0,0,0,4,'','MNT','MN',0),(126,'Montserrat','Montserrat','Montserrat',0,0,0,4,'','XCD','MS',0),(127,'Morocco','Morocco','Morocco',0,0,0,4,'','MAD','MA',0),(128,'Mozambique','Mozambique','Mozambique',0,0,0,4,'','MZM','MZ',0),(129,'Myanmar','Myanmar','Myanmar',0,0,0,4,'','MMK','MM',0),(130,'Namibia','Namibia','Namibia',0,0,0,4,'','NAD','NA',0),(131,'Nauru','Nauru','Nauru',0,0,0,4,'','AUD','NR',0),(132,'Nepal','Nepal','Nepal',0,0,0,4,'','NPR','NP',0),(133,'Netherlands','Netherlands','Netherlands',1,0,0,3,'nl_NL','EUR','NL',0),(134,'Netherlands Antilles','Netherlands Antilles','Netherlands Antilles',0,0,0,4,'','ANG','AN',0),(135,'New Caledonia','New Caledonia','New Caledonia',0,0,0,4,'','XPF','NC',0),(136,'New Zealand','New Zealand','New Zealand',1,0,0,4,'en_NZ','NZD','NZ',0),(137,'Nicaragua','Nicaragua','Nicaragua',0,0,0,2,'','NIO','NI',0),(138,'Niger','Niger','Niger',0,0,0,4,'','XOF','NE',0),(139,'Nigeria','Nigeria','Nigeria',0,0,0,4,'','NGN','NG',0),(140,'Niue','Niue','Niue',0,0,0,4,'','NZD','NU',0),(141,'Norfolk Island','Norfolk Island','Norfolk Island',0,0,0,4,'','AUD','NF',0),(142,'Northern Ireland','Northern Ireland','Northern Ireland',1,0,0,3,'en_GB','GBP','GB',0),(143,'Norway','Norway','Norway',1,0,0,3,'no_NO','NOK','NO',0),(144,'Oman','Oman','Oman',0,0,0,4,'','OMR','OM',0),(145,'Pakistan','Pakistan','Pakistan',0,0,0,4,'','PKR','PK',0),(146,'Panama','Panama','Panama',1,0,0,2,'es_PA','PAB','PA',0),(147,'Papua New Guinea','Papua New Guinea','Papua New Guinea',0,0,0,4,'','PGK','PG',0),(148,'Paraguay','Paraguay','Paraguay',0,0,0,4,'','PYG','PY',0),(149,'Peru','Peru','Peru',0,0,0,2,'','PEN','PE',0),(150,'Philippines','Philippines','Philippines',0,0,0,4,'','PHP','PH',0),(151,'Pitcairn Island','Pitcairn Island','Pitcairn Island',0,0,0,4,'','NZD','PN',0),(152,'Poland','Poland','Poland',0,0,0,4,'pl_PL','PLN','PL',0),(153,'Portugal','Portugal','Portugal',1,0,0,3,'pt_PT','EUR','PT',0),(154,'Qatar','Qatar','Qatar',0,0,0,4,'','QAR','QA',0),(155,'Reunion','Reunion','Reunion',0,0,0,4,'','EUR','RE',0),(156,'Romania','Romania','Romania',0,0,0,4,'','RON','RO',0),(157,'Russia','Russia','Russia',0,0,0,4,'ru_RU','RUB','RU',0),(158,'Rwanda','Rwanda','Rwanda',0,0,0,4,'','RWF','RW',0),(159,'Saint Kitts','Saint Kitts','Saint Kitts',0,0,0,4,'','XCD','KN',0),(160,'Saint Lucia','Saint Lucia','Saint Lucia',0,0,0,4,'','XCD','LC',0),(161,'Saint Vincent and the Grenadines','Saint Vincent and the Grenadines','Saint Vincent and the Grenadines',0,0,0,4,'','XCD','VC',0),(162,'Western Samoa','Western Samoa','Western Samoa',0,0,0,4,'','WST','WS',0),(163,'San Marino','San Marino','San Marino',0,0,0,4,'','EUR','SM',0),(164,'Sao Tome and Principe','Sao Tome and Principe','Sao Tome and Principe',0,0,0,4,'','STD','ST',0),(165,'Saudi Arabia','Saudi Arabia','Saudi Arabia',0,0,0,4,'','SAR','SA',0),(166,'Senegal','Senegal','Senegal',0,0,0,4,'','XOF','SN',0),(167,'Seychelles','Seychelles','Seychelles',0,0,0,4,'','SCR','SC',0),(168,'Sierra Leone','Sierra Leone','Sierra Leone',0,0,0,4,'','SLL','SL',0),(169,'Singapore','Singapore','Singapore',1,0,0,4,'en_SG','SGD','SG',0),(170,'Slovak Republic','Slovak Republic','Slovak Republic',0,0,0,4,'','SKK','SK',0),(171,'Slovenia','Slovenia','Slovenia',0,0,0,4,'','SIT','SI',0),(172,'Solomon Islands','Solomon Islands','Solomon Islands',0,0,0,4,'','SBD','SB',0),(173,'Somalia','Somalia','Somalia',0,0,0,4,'','SOS','SO',0),(174,'South Africa','South Africa','South Africa',0,0,0,4,'en_ZA','ZAR','ZA',0),(175,'Spain','Spain','Spain',1,0,0,3,'es_ES','EUR','ES',0),(176,'Sri Lanka','Sri Lanka','Sri Lanka',0,0,0,4,'','LKR','LK',0),(177,'Saint Helena','Saint Helena','Saint Helena',0,0,0,4,'','SHP','SH',0),(178,'Saint Pierre and Miquelon','Saint Pierre and Miquelon','Saint Pierre and Miquelon',0,0,0,4,'','EUR','PM',0),(179,'Sudan','Sudan','Sudan',0,0,0,4,'','SDD','SD',0),(180,'Suriname','Suriname','Suriname',0,0,0,4,'','SRG','SR',0),(181,'Swaziland','Swaziland','Swaziland',0,0,0,4,'','SZL','SZ',0),(182,'Sweden','Sweden','Sweden',1,0,0,3,'sv_SE','SEK','SE',0),(183,'Switzerland','Switzerland','Switzerland',1,0,0,3,'fr_CH','CHF','CH',0),(184,'Syrian Arab Republic','Syrian Arab Republic','Syrian Arab Republic',0,0,0,4,'','SYP','SY',0),(185,'Taiwan','Taiwan','Taiwan',1,0,0,4,'','TWD','TW',0),(186,'Tajikistan','Tajikistan','Tajikistan',0,0,0,4,'','TJS','TJ',0),(187,'Tanzania','Tanzania','Tanzania',0,0,0,4,'','TZS','TZ',0),(188,'Thailand','Thailand','Thailand',1,0,0,4,'','THB','TH',0),(189,'Togo','Togo','Togo',0,0,0,4,'','XOF','TG',0),(190,'Tokelau','Tokelau','Tokelau',0,0,0,4,'','NZD','TK',0),(191,'Tonga','Tonga','Tonga',0,0,0,4,'','TOP','TO',0),(192,'Trinidad and Tobago','Trinidad and Tobago','Trinidad and Tobago',0,0,0,4,'','TTD','TT',0),(193,'Tunisia','Tunisia','Tunisia',0,0,0,4,'','TND','TN',0),(194,'Turkey','Turkey','Turkey',0,0,0,4,'','TRL','TR',0),(195,'Turkmenistan','Turkmenistan','Turkmenistan',0,0,0,4,'','TMM','TM',0),(196,'Turks and Caicos Islands','Turks and Caicos Islands','Turks and Caicos Islands',0,0,0,4,'','USD','TC',0),(197,'Tuvalu','Tuvalu','Tuvalu',0,0,0,4,'','TVD','TV',0),(198,'Uganda','Uganda','Uganda',0,0,0,4,'','UGX','UG',0),(199,'Ukraine','Ukraine','Ukraine',0,0,0,4,'','UAH','UA',0),(200,'United Arab Emirates','United Arab Emirates','United Arab Emirates',0,0,0,4,'','AED','AE',0),(201,'Great Britain','Great Britain','Great Britain',1,0,1,3,'en_GB','GBP','GB',0),(202,'Uruguay','Uruguay','Uruguay',0,0,0,4,'','UYU','UY',0),(203,'Uzbekistan','Uzbekistan','Uzbekistan',0,0,0,4,'','UZS','UZ',0),(204,'Vanuatu','Vanuatu','Vanuatu',0,0,0,4,'','VUV','VU',0),(205,'Vatican City','Vatican City','Vatican City',1,0,0,3,'','ITL','VA',0),(206,'Venezuela','Venezuela','Venezuela',0,0,0,2,'','VEB','VE',0),(207,'Vietnam','Vietnam','Vietnam',0,0,0,4,'','VND','VN',0),(208,'British Virgin Islands','British Virgin Islands','British Virgin Islands',0,0,0,4,'','USD','VG',0),(209,'Wallis and Futuna Islands','Wallis and Futuna Islands','Wallis and Futuna Islands',0,0,0,4,'','XPF','WF',0),(210,'Yemen','Yemen','Yemen',0,0,0,4,'','YER','YE',0),(211,'Zambia','Zambia','Zambia',0,0,0,4,'','ZMK','ZM',0),(212,'Zimbabwe','Zimbabwe','Zimbabwe',0,0,0,4,'','ZWD','ZW',0),(213,'Iran','Iran','Iran',0,0,0,4,'','IRR','IR',0),(214,'Channel Islands','Channel Islands','Channel Islands',0,0,0,3,'','GBP','GB',0),(215,'Puerto Rico','Puerto Rico','Puerto Rico',0,0,0,3,'','USD','PR',0),(216,'Isle of Man','Isle of Man','Isle of Man',0,0,0,3,'','GBP','GB',0),(217,'Azores','Azores','Azores',0,0,0,3,'','EUR','PT',0),(218,'Corsica','Corsica','Corsica',0,0,0,3,'','EUR','FR',0),(219,'Balearic Islands','Balearic Islands','Balearic Islands',0,0,0,3,'','EUR','ES',0),(221,'Serbia','Serbia','Serbia',0,0,0,3,'sr_RS','RSD','RS',0),(222,'Ivory Coast','Ivory Coast','Ivory Coast',0,0,0,3,'','XOF','CI',0),(223,'Montenegro','Montenegro','Montenegro',0,0,0,3,'','EUR','ME',0);
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `coupons`
--

DROP TABLE IF EXISTS `coupons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `coupons` (
  `cpnID` int(11) NOT NULL auto_increment,
  `cpnName` varchar(255) default NULL,
  `cpnName2` varchar(255) default NULL,
  `cpnName3` varchar(255) default NULL,
  `cpnWorkingName` varchar(255) default NULL,
  `cpnNumber` varchar(255) default NULL,
  `cpnType` int(11) default '0',
  `cpnEndDate` datetime default NULL,
  `cpnDiscount` double default '0',
  `cpnThreshold` double default '0',
  `cpnThresholdMax` double default '0',
  `cpnThresholdRepeat` double default '0',
  `cpnQuantity` int(11) default '0',
  `cpnQuantityMax` int(11) default '0',
  `cpnQuantityRepeat` int(11) default '0',
  `cpnNumAvail` int(11) default '0',
  `cpnCntry` tinyint(4) default '0',
  `cpnIsCoupon` tinyint(4) default '0',
  `cpnHandling` tinyint(1) default '0',
  `cpnSitewide` tinyint(4) default '0',
  PRIMARY KEY  (`cpnID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `coupons`
--

LOCK TABLES `coupons` WRITE;
/*!40000 ALTER TABLE `coupons` DISABLE KEYS */;
/*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpnassign`
--

DROP TABLE IF EXISTS `cpnassign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cpnassign` (
  `cpaID` int(11) NOT NULL auto_increment,
  `cpaCpnID` int(11) default '0',
  `cpaType` tinyint(4) default '0',
  `cpaAssignment` varchar(255) default NULL,
  PRIMARY KEY  (`cpaID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cpnassign`
--

LOCK TABLES `cpnassign` WRITE;
/*!40000 ALTER TABLE `cpnassign` DISABLE KEYS */;
/*!40000 ALTER TABLE `cpnassign` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customerlists`
--

DROP TABLE IF EXISTS `customerlists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customerlists` (
  `listID` int(11) NOT NULL auto_increment,
  `listName` varchar(255) NOT NULL,
  `listOwner` int(11) NOT NULL default '0',
  `listAccess` varchar(255) NOT NULL,
  PRIMARY KEY  (`listID`),
  KEY `listOwner` (`listOwner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customerlists`
--

LOCK TABLES `customerlists` WRITE;
/*!40000 ALTER TABLE `customerlists` DISABLE KEYS */;
/*!40000 ALTER TABLE `customerlists` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customerlogin`
--

DROP TABLE IF EXISTS `customerlogin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customerlogin` (
  `clID` int(11) NOT NULL auto_increment,
  `clUserName` varchar(50) default NULL,
  `clPW` varchar(50) default NULL,
  `clLoginLevel` tinyint(4) default '0',
  `clPercentDiscount` double default '0',
  `clActions` int(11) default '0',
  `clEmail` varchar(255) default NULL,
  `clDateCreated` datetime default NULL,
  PRIMARY KEY  (`clID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customerlogin`
--

LOCK TABLES `customerlogin` WRITE;
/*!40000 ALTER TABLE `customerlogin` DISABLE KEYS */;
/*!40000 ALTER TABLE `customerlogin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dropshipper`
--

DROP TABLE IF EXISTS `dropshipper`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dropshipper` (
  `dsID` int(11) NOT NULL auto_increment,
  `dsName` varchar(255) default NULL,
  `dsEmail` varchar(255) default NULL,
  `dsAddress` varchar(255) default NULL,
  `dsCity` varchar(255) default NULL,
  `dsState` varchar(255) default NULL,
  `dsZip` varchar(255) default NULL,
  `dsCountry` varchar(255) default NULL,
  `dsEmailHeader` text,
  `dsAction` int(11) default '0',
  PRIMARY KEY  (`dsID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dropshipper`
--

LOCK TABLES `dropshipper` WRITE;
/*!40000 ALTER TABLE `dropshipper` DISABLE KEYS */;
/*!40000 ALTER TABLE `dropshipper` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emailmessages`
--

DROP TABLE IF EXISTS `emailmessages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emailmessages` (
  `emailID` int(11) NOT NULL,
  `giftcertsubject` varchar(255) default NULL,
  `giftcertsubject2` varchar(255) default NULL,
  `giftcertsubject3` varchar(255) default NULL,
  `giftcertemail` text,
  `giftcertemail2` text,
  `giftcertemail3` text,
  `giftcertsendersubject` varchar(255) default NULL,
  `giftcertsendersubject2` varchar(255) default NULL,
  `giftcertsendersubject3` varchar(255) default NULL,
  `giftcertsender` text,
  `giftcertsender2` text,
  `giftcertsender3` text,
  `emailsubject` varchar(255) default NULL,
  `emailsubject2` varchar(255) default NULL,
  `emailsubject3` varchar(255) default NULL,
  `emailheaders` text,
  `emailheaders2` text,
  `emailheaders3` text,
  `receiptheaders` text,
  `receiptheaders2` text,
  `receiptheaders3` text,
  `dropshipsubject` varchar(255) default NULL,
  `dropshipsubject2` varchar(255) default NULL,
  `dropshipsubject3` varchar(255) default NULL,
  `dropshipheaders` text,
  `dropshipheaders2` text,
  `dropshipheaders3` text,
  `orderstatussubject` varchar(255) default NULL,
  `orderstatussubject2` varchar(255) default NULL,
  `orderstatussubject3` varchar(255) default NULL,
  `orderstatusemail` text,
  `orderstatusemail2` text,
  `orderstatusemail3` text,
  PRIMARY KEY  (`emailID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emailmessages`
--

LOCK TABLES `emailmessages` WRITE;
/*!40000 ALTER TABLE `emailmessages` DISABLE KEYS */;
INSERT INTO `emailmessages` VALUES (1,'You received a gift certificate from %fromname%','You received a gift certificate from %fromname%','You received a gift certificate from %fromname%','Hi %toname%, %fromname% has sent you a gift certificate to the value of %value%!<br />{Your friend left the following message: %message%}<br />To redeem your gift certificate, simply pop along to our online store at:<br />%storeurl%<br />Then select the goods you require and when checking out enter the gift certificate code below:<br />%certificateid%','Hi %toname%, %fromname% has sent you a gift certificate to the value of %value%!<br />{Your friend left the following message: %message%}<br />To redeem your gift certificate, simply pop along to our online store at:<br />%storeurl%<br />Then select the goods you require and when checking out enter the gift certificate code below:<br />%certificateid%','Hi %toname%, %fromname% has sent you a gift certificate to the value of %value%!<br />{Your friend left the following message: %message%}<br />To redeem your gift certificate, simply pop along to our online store at:<br />%storeurl%<br />Then select the goods you require and when checking out enter the gift certificate code below:<br />%certificateid%','You sent a gift certificate to %toname%','You sent a gift certificate to %toname%','You sent a gift certificate to %toname%','You sent a gift certificate to %toname%.<br />Below is a copy of the email they will receive. You may want to check it was delivered.','You sent a gift certificate to %toname%.<br />Below is a copy of the email they will receive. You may want to check it was delivered.','You sent a gift certificate to %toname%.<br />Below is a copy of the email they will receive. You may want to check it was delivered.','Thank you for your order','Thank you for your order','Thank you for your order','%emailmessage%<br />','%emailmessage%<br />','%emailmessage%<br />',NULL,NULL,NULL,'We have received the following order','We have received the following order','We have received the following order','%emailmessage%<br />','%emailmessage%<br />','%emailmessage%<br />','Order status updated','Order status updated','Order status updated','Dear %ordername%<br />Your order id %orderid% from %orderdate% has been updated from %oldstatus% to %newstatus% on %date%.<br />{Your tracking number is %trackingnum%<br />}{Additional Info: %statusinfo%<br />}','Dear %ordername%<br />Your order id %orderid% from %orderdate% has been updated from %oldstatus% to %newstatus% on %date%.<br />{Your tracking number is %trackingnum%<br />}{Additional Info: %statusinfo%<br />}','Dear %ordername%<br />Your order id %orderid% from %orderdate% has been updated from %oldstatus% to %newstatus% on %date%.<br />{Your tracking number is %trackingnum%<br />}{Additional Info: %statusinfo%<br />}');
/*!40000 ALTER TABLE `emailmessages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `giftcertificate`
--

DROP TABLE IF EXISTS `giftcertificate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `giftcertificate` (
  `gcID` varchar(255) NOT NULL,
  `gcTo` varchar(255) default NULL,
  `gcFrom` varchar(255) default NULL,
  `gcEmail` varchar(255) default NULL,
  `gcOrigAmount` double default '0',
  `gcRemaining` double default '0',
  `gcDateCreated` date default NULL,
  `gcDateUsed` date default NULL,
  `gcCartID` int(11) NOT NULL default '0',
  `gcOrderID` int(11) NOT NULL default '0',
  `gcAuthorized` tinyint(1) default '0',
  `gcMessage` text,
  PRIMARY KEY  (`gcID`),
  KEY `gcCartID` (`gcCartID`),
  KEY `gcOrderID` (`gcOrderID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `giftcertificate`
--

LOCK TABLES `giftcertificate` WRITE;
/*!40000 ALTER TABLE `giftcertificate` DISABLE KEYS */;
/*!40000 ALTER TABLE `giftcertificate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `giftcertsapplied`
--

DROP TABLE IF EXISTS `giftcertsapplied`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `giftcertsapplied` (
  `gcaGCID` varchar(255) NOT NULL,
  `gcaOrdID` int(11) NOT NULL default '0',
  `gcaAmount` double default '0',
  PRIMARY KEY  (`gcaGCID`,`gcaOrdID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `giftcertsapplied`
--

LOCK TABLES `giftcertsapplied` WRITE;
/*!40000 ALTER TABLE `giftcertsapplied` DISABLE KEYS */;
/*!40000 ALTER TABLE `giftcertsapplied` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `installedmods`
--

DROP TABLE IF EXISTS `installedmods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `installedmods` (
  `modkey` varchar(255) NOT NULL,
  `modtitle` varchar(255) NOT NULL,
  `modauthor` varchar(255) default NULL,
  `modauthorlink` varchar(255) default NULL,
  `modversion` varchar(255) default NULL,
  `modectversion` varchar(255) default NULL,
  `modlink` varchar(255) default NULL,
  `moddate` datetime NOT NULL,
  `modnotes` text,
  PRIMARY KEY  (`modkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `installedmods`
--

LOCK TABLES `installedmods` WRITE;
/*!40000 ALTER TABLE `installedmods` DISABLE KEYS */;
/*!40000 ALTER TABLE `installedmods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ipblocking`
--

DROP TABLE IF EXISTS `ipblocking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipblocking` (
  `dcid` int(11) NOT NULL auto_increment,
  `dcip1` int(11) default '0',
  `dcip2` int(11) default '0',
  PRIMARY KEY  (`dcid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ipblocking`
--

LOCK TABLES `ipblocking` WRITE;
/*!40000 ALTER TABLE `ipblocking` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipblocking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailinglist`
--

DROP TABLE IF EXISTS `mailinglist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailinglist` (
  `email` varchar(255) NOT NULL,
  `mlName` varchar(255) default NULL,
  `emailFormat` tinyint(4) default '0',
  `mlConfirmDate` date default NULL,
  `mlIPAddress` varchar(255) default NULL,
  `isconfirmed` tinyint(1) default '0',
  PRIMARY KEY  (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mailinglist`
--

LOCK TABLES `mailinglist` WRITE;
/*!40000 ALTER TABLE `mailinglist` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailinglist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manufacturer`
--

DROP TABLE IF EXISTS `manufacturer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `manufacturer` (
  `mfID` int(11) NOT NULL auto_increment,
  `mfName` varchar(255) default NULL,
  `mfEmail` varchar(255) default NULL,
  `mfAddress` varchar(255) default NULL,
  `mfCity` varchar(255) default NULL,
  `mfState` varchar(255) default NULL,
  `mfZip` varchar(255) default NULL,
  `mfCountry` varchar(255) default NULL,
  `mfLogo` varchar(255) default NULL,
  `mfURL` varchar(255) default NULL,
  `mfURL2` varchar(255) default NULL,
  `mfURL3` varchar(255) default NULL,
  `mfDescription` text,
  `mfDescription2` text,
  `mfDescription3` text,
  `mfOrder` int(11) default '0',
  PRIMARY KEY  (`mfID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `manufacturer`
--

LOCK TABLES `manufacturer` WRITE;
/*!40000 ALTER TABLE `manufacturer` DISABLE KEYS */;
/*!40000 ALTER TABLE `manufacturer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `multibuyblock`
--

DROP TABLE IF EXISTS `multibuyblock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multibuyblock` (
  `ssdenyid` int(11) NOT NULL auto_increment,
  `ssdenyip` varchar(255) NOT NULL,
  `sstimesaccess` int(11) default '0',
  `lastaccess` datetime default NULL,
  PRIMARY KEY  (`ssdenyid`),
  UNIQUE KEY `ssdenyip_2` (`ssdenyip`),
  KEY `ssdenyip` (`ssdenyip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `multibuyblock`
--

LOCK TABLES `multibuyblock` WRITE;
/*!40000 ALTER TABLE `multibuyblock` DISABLE KEYS */;
/*!40000 ALTER TABLE `multibuyblock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `multisections`
--

DROP TABLE IF EXISTS `multisections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multisections` (
  `pID` varchar(128) NOT NULL,
  `pSection` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pID`,`pSection`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `multisections`
--

LOCK TABLES `multisections` WRITE;
/*!40000 ALTER TABLE `multisections` DISABLE KEYS */;
/*!40000 ALTER TABLE `multisections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `optiongroup`
--

DROP TABLE IF EXISTS `optiongroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `optiongroup` (
  `optGrpID` int(11) NOT NULL auto_increment,
  `optGrpName` varchar(255) default NULL,
  `optGrpName2` varchar(255) default NULL,
  `optGrpName3` varchar(255) default NULL,
  `optGrpWorkingName` varchar(255) default NULL,
  `optType` int(11) default '0',
  `optFlags` int(11) default '0',
  `optGrpSelect` tinyint(1) default '0',
  PRIMARY KEY  (`optGrpID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `optiongroup`
--

LOCK TABLES `optiongroup` WRITE;
/*!40000 ALTER TABLE `optiongroup` DISABLE KEYS */;
INSERT INTO `optiongroup` VALUES (1,'Color',NULL,NULL,'Color',2,0,1),(2,'Size',NULL,NULL,'Size (Jackets)',2,0,1),(4,'Size',NULL,NULL,'Size (Socks)',2,0,1),(6,'Processor',NULL,NULL,'Processor (Multimedia)',2,0,1),(7,'Hard Disk',NULL,NULL,'Hard Disk',2,0,1),(8,'Monitor',NULL,NULL,'Monitor',2,0,1),(9,'Network Card',NULL,NULL,'Network Card',2,0,1),(10,'Processor',NULL,NULL,'Processor (Portables)',2,0,1);
/*!40000 ALTER TABLE `optiongroup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `options`
--

DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `options` (
  `optID` int(11) NOT NULL auto_increment,
  `optGroup` int(11) default NULL,
  `optName` varchar(255) default NULL,
  `optName2` varchar(255) default NULL,
  `optName3` varchar(255) default NULL,
  `optPriceDiff` double default '0',
  `optWholesalePriceDiff` double default '0',
  `optWeightDiff` double default '0',
  `optStock` int(11) default '0',
  `optRegExp` varchar(255) default NULL,
  `optDefault` tinyint(1) default '0',
  `optAltImage` varchar(255) default NULL,
  `optAltLargeImage` varchar(255) default NULL,
  PRIMARY KEY  (`optID`),
  KEY `optGroup` (`optGroup`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `options`
--

LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;
INSERT INTO `options` VALUES (1,1,'Blue',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(2,1,'Red',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(3,1,'Green',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(4,1,'Yellow',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(5,2,'Small',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(6,2,'Medium',NULL,NULL,1,0,0,0,NULL,0,NULL,NULL),(7,2,'Large',NULL,NULL,1.5,0,0,0,NULL,0,NULL,NULL),(8,2,'X-Large',NULL,NULL,2,0,0,0,NULL,0,NULL,NULL),(9,2,'XX-Large',NULL,NULL,2.2,0,0,0,NULL,0,NULL,NULL),(12,4,'8',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(13,4,'8 1/2',NULL,NULL,0.1,0,0,0,NULL,0,NULL,NULL),(14,4,'9',NULL,NULL,0.15,0,0,0,NULL,0,NULL,NULL),(15,4,'9 1/2',NULL,NULL,0.2,0,0,0,NULL,0,NULL,NULL),(16,4,'10',NULL,NULL,0.25,0,0,0,NULL,0,NULL,NULL),(21,6,'Intel Pentium III 1.3GHz',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(22,6,'Intel Pentium III 1.4GHz',NULL,NULL,15,0,0,0,NULL,0,NULL,NULL),(23,6,'Intel Pentium IV 1.5GHz',NULL,NULL,25.5,0,0,0,NULL,0,NULL,NULL),(24,6,'Intel Pentium IV 1.7GHz',NULL,NULL,45,0,0,0,NULL,0,NULL,NULL),(25,6,'Intel Pentium IV 2.0GHz',NULL,NULL,65,0,0,0,NULL,0,NULL,NULL),(26,7,'20 Gigabytes',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(27,7,'40 Gigabytes',NULL,NULL,10,0,0,0,NULL,0,NULL,NULL),(28,7,'60 Gigabytes',NULL,NULL,34,0,0,0,NULL,0,NULL,NULL),(29,7,'80 Gigabytes',NULL,NULL,44.5,0,0,0,NULL,0,NULL,NULL),(30,8,'15\" Standard',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(31,8,'17\" Trinitron',NULL,NULL,22,0,5,0,NULL,0,NULL,NULL),(32,8,'19\" Flatron',NULL,NULL,75,0,10,0,NULL,0,NULL,NULL),(33,8,'21\" Supertron',NULL,NULL,185,0,20,0,NULL,0,NULL,NULL),(34,9,'No',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(35,9,'Yes',NULL,NULL,15,0,0,0,NULL,0,NULL,NULL),(36,10,'Pentium III 1.0 GHz',NULL,NULL,0,0,0,0,NULL,0,NULL,NULL),(37,10,'Pentium III 1.3 GHz',NULL,NULL,33,0,0,0,NULL,0,NULL,NULL),(38,10,'Pentium IV 1.5 GHz',NULL,NULL,50,0,0,0,NULL,0,NULL,NULL),(39,10,'Pentium IV 1.7 GHz',NULL,NULL,75,0,0,0,NULL,0,NULL,NULL);
/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `ordID` int(11) NOT NULL auto_increment,
  `ordSessionID` varchar(255) default NULL,
  `ordName` varchar(255) default NULL,
  `ordLastName` varchar(255) default NULL,
  `ordAddress` varchar(255) default NULL,
  `ordAddress2` varchar(255) default NULL,
  `ordCity` varchar(255) default NULL,
  `ordState` varchar(255) default NULL,
  `ordZip` varchar(255) default NULL,
  `ordCountry` varchar(255) default NULL,
  `ordEmail` varchar(255) default NULL,
  `ordPhone` varchar(255) default NULL,
  `ordShipName` varchar(255) default NULL,
  `ordShipLastName` varchar(255) default NULL,
  `ordShipAddress` varchar(255) default NULL,
  `ordShipAddress2` varchar(255) default NULL,
  `ordShipCity` varchar(255) default NULL,
  `ordShipState` varchar(255) default NULL,
  `ordShipZip` varchar(255) default NULL,
  `ordShipCountry` varchar(255) default NULL,
  `ordShipPhone` varchar(255) default NULL,
  `ordAuthNumber` varchar(255) default NULL,
  `ordAuthStatus` varchar(255) default NULL,
  `ordAffiliate` varchar(255) default NULL,
  `ordPayProvider` int(11) default '0',
  `ordTransID` varchar(255) default NULL,
  `ordShipping` double default '0',
  `ordStateTax` double default '0',
  `ordCountryTax` double default '0',
  `ordHSTTax` double default '0',
  `ordHandling` double default '0',
  `ordShipType` varchar(255) default NULL,
  `ordShipCarrier` int(11) default '0',
  `ordClientID` int(11) default '0',
  `ordTotal` double default '0',
  `ordDate` datetime default NULL,
  `ordIP` varchar(255) default NULL,
  `ordDiscount` double default '0',
  `ordDiscountText` varchar(255) default NULL,
  `ordExtra1` varchar(255) default NULL,
  `ordExtra2` varchar(255) default NULL,
  `ordShipExtra1` varchar(255) default NULL,
  `ordShipExtra2` varchar(255) default NULL,
  `ordCheckoutExtra1` varchar(255) default NULL,
  `ordCheckoutExtra2` varchar(255) default NULL,
  `ordTrackNum` varchar(255) default NULL,
  `ordAVS` varchar(255) default NULL,
  `ordCVV` varchar(255) default NULL,
  `ordAddInfo` text,
  `ordCNum` text,
  `ordComLoc` tinyint(4) default '0',
  `ordStatus` tinyint(4) default '0',
  `ordStatusDate` datetime default NULL,
  `ordStatusInfo` text,
  `ordInvoice` varchar(255) default NULL,
  `ordReferer` varchar(255) default NULL,
  `ordQuerystr` varchar(255) default NULL,
  `ordLang` tinyint(4) default '0',
  PRIMARY KEY  (`ordID`),
  KEY `ordClientID` (`ordClientID`)
) ENGINE=MyISAM AUTO_INCREMENT=502 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (501,'935000845','A Customer',NULL,'1212 The Street',NULL,'San Jose','California','90210','United States of America','info@ecommercetemplates.com','1121212121212','',NULL,'',NULL,'','','','United States of America',NULL,'Email Only',NULL,NULL,4,NULL,2.5,0,0,0,0,'',0,0,1274.5,'2010-03-15 14:39:10','192.168.0.1',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'This is just an example order. It is also here to make sure your order numbers do not start at zero, which just doesn\'t look good.',NULL,0,3,'2010-03-15 14:39:10','',NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orderstatus`
--

DROP TABLE IF EXISTS `orderstatus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orderstatus` (
  `statID` int(11) NOT NULL,
  `statPrivate` varchar(255) default NULL,
  `emailstatus` tinyint(1) default '0',
  `statPublic` varchar(255) default NULL,
  `statPublic2` varchar(255) default NULL,
  `statPublic3` varchar(255) default NULL,
  PRIMARY KEY  (`statID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orderstatus`
--

LOCK TABLES `orderstatus` WRITE;
/*!40000 ALTER TABLE `orderstatus` DISABLE KEYS */;
INSERT INTO `orderstatus` VALUES (0,'Cancelled',0,'Order Cancelled','Order Cancelled','Order Cancelled'),(1,'Deleted',0,'Order Deleted','Order Deleted','Order Deleted'),(2,'Unauthorized',0,'Awaiting Payment','Awaiting Payment','Awaiting Payment'),(3,'New Order',0,'Order Received','Order Received','Order Received'),(4,'Authorized',1,'Payment Received','Payment Received','Payment Received'),(5,'Packing',1,'In Packing','In Packing','In Packing'),(6,'Shipped',1,'Order Shipped','Order Shipped','Order Shipped'),(7,'Completed',1,'Order Completed','Order Completed','Order Completed'),(8,'',1,'','',''),(9,'',1,'','',''),(10,'',1,'','',''),(11,'',1,'','',''),(12,'',1,'','',''),(13,'',1,'','',''),(14,'',1,'','',''),(15,'',1,'','',''),(16,'',1,'','',''),(17,'',1,'','','');
/*!40000 ALTER TABLE `orderstatus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payprovider`
--

DROP TABLE IF EXISTS `payprovider`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payprovider` (
  `payProvID` int(11) NOT NULL,
  `payProvName` varchar(255) default NULL,
  `payProvShow` varchar(255) default NULL,
  `payProvShow2` varchar(255) default NULL,
  `payProvShow3` varchar(255) default NULL,
  `payProvEnabled` tinyint(4) default NULL,
  `payProvAvailable` tinyint(4) default NULL,
  `payProvDemo` tinyint(4) default NULL,
  `payProvData1` varchar(255) default NULL,
  `payProvData2` varchar(255) default NULL,
  `payProvData3` varchar(255) default NULL,
  `payProvOrder` int(11) default '0',
  `payProvMethod` int(11) default '0',
  `ppHandlingCharge` double default '0',
  `ppHandlingPercent` double default '0',
  `pProvHeaders` text,
  `pProvHeaders2` text,
  `pProvHeaders3` text,
  `pProvDropShipHeaders` text,
  `pProvDropShipHeaders2` text,
  `pProvDropShipHeaders3` text,
  `payProvLevel` int(11) default '0',
  PRIMARY KEY  (`payProvID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payprovider`
--

LOCK TABLES `payprovider` WRITE;
/*!40000 ALTER TABLE `payprovider` DISABLE KEYS */;
INSERT INTO `payprovider` VALUES (1,'PayPal','PayPal','PayPal','PayPal',0,1,0,'','',NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(2,'2Checkout','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,2,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,'Auth.net SIM','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,3,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(4,'Email','Email','Email','Email',1,1,0,'','',NULL,4,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(5,'World Pay','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,5,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(6,'NOCHEX','NOCHEX','NOCHEX','NOCHEX',0,1,0,'','',NULL,6,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(7,'Payflow Pro','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,7,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(8,'Payflow Link','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,8,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(9,'SECPay','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,9,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(10,'Capture Card','Credit Card','Credit Card','Credit Card',0,1,0,'XXXXXOOOOOOO','',NULL,10,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(11,'PSiGate','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,11,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(12,'PSiGate SSL','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,12,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(13,'Auth.net AIM','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,13,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(14,'Custom','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,14,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(15,'Netbanx','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,15,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(16,'Linkpoint','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,16,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(17,'Email 2','Email 2','Email 2','Email 2',0,1,0,'','',NULL,17,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(18,'PayPal Direct','Credit Card','Credit Card','Credit Card',0,1,0,'','',NULL,18,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(19,'PayPal Express','PayPal Express','PayPal Express','PayPal Express',0,1,0,'','',NULL,19,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(20,'Google Checkout','Google Checkout','Google Checkout','Google Checkout',0,1,0,'','',NULL,20,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0),(21,'Amazon Simple Pay','Amazon Payments','Amazon Payments','Amazon Payments',0,1,0,'','',NULL,21,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `payprovider` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `postalzones`
--

DROP TABLE IF EXISTS `postalzones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `postalzones` (
  `pzID` int(11) NOT NULL,
  `pzName` varchar(50) default NULL,
  `pzMultiShipping` tinyint(4) default '0',
  `pzMethodName1` varchar(255) default NULL,
  `pzMethodName2` varchar(255) default NULL,
  `pzMethodName3` varchar(255) default NULL,
  `pzMethodName4` varchar(255) default NULL,
  `pzMethodName5` varchar(255) default NULL,
  `pzFSA` tinyint(4) default '1',
  PRIMARY KEY  (`pzID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `postalzones`
--

LOCK TABLES `postalzones` WRITE;
/*!40000 ALTER TABLE `postalzones` DISABLE KEYS */;
INSERT INTO `postalzones` VALUES (1,'United States',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(2,'Zone 2',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(3,'Zone 3',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(4,'Zone 4',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(5,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(6,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(7,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(8,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(9,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(10,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(11,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(12,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(13,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(14,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(15,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(16,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(17,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(18,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(19,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(20,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(21,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(22,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(23,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(24,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(101,'All States',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(102,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(103,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(104,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(105,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(106,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(107,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(108,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(109,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(110,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(111,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(112,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(113,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(114,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(115,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(116,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(117,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(118,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(119,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(120,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(121,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(122,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(123,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1),(124,'',0,'Standard Shipping','Express Shipping',NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `postalzones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pricebreaks`
--

DROP TABLE IF EXISTS `pricebreaks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pricebreaks` (
  `pbQuantity` int(11) NOT NULL,
  `pbProdID` varchar(255) NOT NULL,
  `pPrice` double default '0',
  `pWholesalePrice` double default '0',
  PRIMARY KEY  (`pbProdID`,`pbQuantity`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pricebreaks`
--

LOCK TABLES `pricebreaks` WRITE;
/*!40000 ALTER TABLE `pricebreaks` DISABLE KEYS */;
/*!40000 ALTER TABLE `pricebreaks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prodoptions`
--

DROP TABLE IF EXISTS `prodoptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prodoptions` (
  `poID` int(11) NOT NULL auto_increment,
  `poProdID` varchar(128) default NULL,
  `poOptionGroup` int(11) default NULL,
  PRIMARY KEY  (`poID`),
  KEY `poProdID` (`poProdID`),
  KEY `poOptionGroup` (`poOptionGroup`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `prodoptions`
--

LOCK TABLES `prodoptions` WRITE;
/*!40000 ALTER TABLE `prodoptions` DISABLE KEYS */;
INSERT INTO `prodoptions` VALUES (9,'monitor001',8),(21,'palmtop001',6),(22,'palmtop001',7),(23,'mouse001',1),(25,'portable001',10),(26,'pc001',8),(27,'pc001',6),(28,'pc001',7),(29,'pc001',9),(30,'testproduct',4);
/*!40000 ALTER TABLE `prodoptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `pID` varchar(128) NOT NULL,
  `pName` varchar(255) NOT NULL,
  `pName2` varchar(255) default NULL,
  `pName3` varchar(255) default NULL,
  `pSection` int(11) NOT NULL default '0',
  `pDescription` text,
  `pDescription2` text,
  `pDescription3` text,
  `pLongdescription` text,
  `pLongdescription2` text,
  `pLongdescription3` text,
  `pImage` varchar(255) default NULL,
  `pImage2` varchar(255) default NULL,
  `pImage3` varchar(255) default NULL,
  `pImage4` varchar(255) default NULL,
  `pImage5` varchar(255) default NULL,
  `pLargeImage` varchar(255) default NULL,
  `pLargeImage2` varchar(255) default NULL,
  `pLargeImage3` varchar(255) default NULL,
  `pLargeImage4` varchar(255) default NULL,
  `pLargeImage5` varchar(255) default NULL,
  `pGiantImage` varchar(255) default NULL,
  `pGiantImage2` varchar(255) default NULL,
  `pGiantImage3` varchar(255) default NULL,
  `pGiantImage4` varchar(255) default NULL,
  `pGiantImage5` varchar(255) default NULL,
  `pSearchParams` text,
  `pDownload` varchar(255) default NULL,
  `pPrice` double NOT NULL default '0',
  `pListPrice` double default '0',
  `pWholesalePrice` double default '0',
  `pShipping` double default '0',
  `pShipping2` double default '0',
  `pWeight` double default '0',
  `pDisplay` tinyint(1) default '1',
  `pSell` tinyint(1) default '1',
  `pStaticPage` tinyint(1) default '0',
  `pStockByOpts` tinyint(1) default '0',
  `pRecommend` tinyint(1) default '0',
  `pExemptions` tinyint(4) default '0',
  `pInStock` int(11) default '0',
  `pDropship` int(11) default '0',
  `pManufacturer` int(11) default '0',
  `pDims` varchar(255) default NULL,
  `pSKU` varchar(255) default NULL,
  `pDateAdded` date default NULL,
  `pTax` double default NULL,
  `pOrder` int(11) default '0',
  `pTotRating` int(11) default '0',
  `pNumRatings` int(11) default '0',
  PRIMARY KEY  (`pID`),
  KEY `pSection` (`pSection`),
  KEY `pOrder` (`pOrder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES ('fscanner001','Professional Scanner',NULL,NULL,2,'600 dpi full color quality for professional quality scanning results. Twice the resolution and twice the quality for your scans, but at an incredible low price.',NULL,NULL,'600 dpi full color quality for professional quality scanning results. Twice the resolution and twice the quality for your scans, but at an incredible low price.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/scanner2.gif',NULL,NULL,NULL,NULL,'prodimages/lscanner2.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,120,0,0,5,0,4.04,1,1,0,0,0,0,4,0,0,NULL,NULL,NULL,NULL,0,0,0),('inkjet001','Inkjet Printer',NULL,NULL,4,'This inkjet printer really packs a punch for the home user. Full color prints at photo quality. Perfect for everything from letters to the bank manager, to printing out your favourite digital family pictures.',NULL,NULL,'This inkjet printer really packs a punch for the home user. Full color prints at photo quality. Perfect for everything from letters to the bank manager, to printing out your favourite digital family pictures.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/inkjetprinter.gif',NULL,NULL,NULL,NULL,'prodimages/linkjetprinter.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,95,0,0,4,0,2.02,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('keyboard001','PC Keyboard',NULL,NULL,3,'With ergonomic tactile key action, this is a \"must buy\" for all PC users, home and professional alike. Connects via your PC\'s serial or PS2 port.',NULL,NULL,'With ergonomic tactile key action, this is a \"must buy\" for all PC users, home and professional alike. Connects via your PC\'s serial or PS2 port.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/keyboard.gif',NULL,NULL,NULL,NULL,'prodimages/lkeyboard.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,19,0,0,5,0,1,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('lprinter001','Laser Printer',NULL,NULL,4,'For the small or home office, this laser printer is the perfect solution. Up to 15 black and white pages per minute, and a full 600dpi resolution for the quality your business demands.',NULL,NULL,'For the small or home office, this laser printer is the perfect solution. Up to 15 black and white pages per minute, and a full 600dpi resolution for the quality your business demands.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/laserprinter.gif',NULL,NULL,NULL,NULL,'prodimages/llaserprinter.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,499,0,0,5,0,2,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('monitor001','PC Monitor',NULL,NULL,3,'17\" full color flat screen monitor, with 0.25 dot resolution and 16.25\" viewable area.',NULL,NULL,'17\" full color flat screen monitor, with 0.25 dot resolution and 16.25\" viewable area.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/monitor.gif',NULL,NULL,NULL,NULL,'prodimages/lmonitor.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,299,0,0,5,0,2.15,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('mouse001','PC Mouse',NULL,NULL,3,'Indispensible for using your PC, this mouse has easyglide action and simple connectivity to get your PC up and surfing the internet in no time.',NULL,NULL,'Indispensible for using your PC, this mouse has easyglide action and simple connectivity to get your PC up and surfing the internet in no time.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/mouse.gif',NULL,NULL,NULL,NULL,'prodimages/lmouse.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,0,1,0,0.15,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('palmtop001','Palmtop Computer',NULL,NULL,1,'The very latest in palmtop technology. All the power of a PC in a pocket sized system. Great for the mobile business person.',NULL,NULL,'The very latest in palmtop technology. All the power of a PC in a pocket sized system. Great for the mobile business person.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/palmtop.gif',NULL,NULL,NULL,NULL,'prodimages/lpalmtop.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,199,0,0,5,0,4.12,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('pc001','#1 PC multimedia package',NULL,NULL,1,'This is an example of how you can use the product options to create advanced product descriptions with automatic price calculations.',NULL,NULL,'Internet ready PC package. Just choose your monitor, hard disk size, processor speed and network card.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products. You can also include HTML Markup in the short and long product descriptions.',NULL,NULL,'prodimages/pc.gif',NULL,NULL,NULL,NULL,'prodimages/lpc.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1200,0,0,10,0,6,1,1,0,0,0,0,10,0,0,NULL,NULL,NULL,NULL,0,0,0),('portable001','Portable PC',NULL,NULL,1,'For those on the go, this portable PC is just the thing. Your choice of processor, 256mb ram and 4gb harddisk make this the perfect solution for all types of applications. Buy now while stocks last.',NULL,NULL,'For those on the go, this portable PC is just the thing. Your choice of processor, 256mb ram and 4gb harddisk make this the perfect solution for all types of applications. Buy now while stocks last.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/portable.gif',NULL,NULL,NULL,NULL,'prodimages/lportable.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1250,0,0,6,0,2,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('scanner001','Flatbed scanner',NULL,NULL,2,'Up to 300 dpi full color resolution and incredible speed make this a top choice for all your scanning needs. Scan professional quality photos, text or artwork in seconds.',NULL,NULL,'Up to 300 dpi full color resolution and incredible speed make this a top choice for all your scanning needs. Scan professional quality photos, text or artwork in seconds.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/scanner.gif',NULL,NULL,NULL,NULL,'prodimages/lscanner.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,89,0,0,6,0,5.1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('serialcab001','PC Serial Cable',NULL,NULL,3,'Can be used for connecting PC systems to peripheral devices such as serial printers and scanners.',NULL,NULL,'Can be used for connecting PC systems to peripheral devices such as serial printers and scanners.<br>As well as a larger image, you can use this \"Long Description\" to add extra detail or information about your products.',NULL,NULL,'prodimages/computercable.gif',NULL,NULL,NULL,NULL,'prodimages/lcomputercable.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2.5,0,0,0.2,0,0.1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0),('testproduct','Cheap Test Product',NULL,NULL,3,'This is a cheap product for testing. Note how you can use HTML Markup in product descriptions.<br>Also note that as you change the product options, the price changes automatically.',NULL,NULL,'This is a cheap product for testing. Note how you can use HTML Markup in product descriptions.<br>In the long description you can go into more detail about products.',NULL,NULL,'prodimages/computercable.gif',NULL,NULL,NULL,NULL,'prodimages/lcomputercable.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.01,0,0,0,0,3,1,1,0,0,0,0,21,0,0,NULL,NULL,NULL,NULL,0,0,0);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ratings`
--

DROP TABLE IF EXISTS `ratings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ratings` (
  `rtID` int(11) NOT NULL auto_increment,
  `rtProdID` varchar(255) NOT NULL,
  `rtRating` tinyint(4) default '0',
  `rtLanguage` tinyint(4) default '0',
  `rtDate` date default NULL,
  `rtApproved` tinyint(1) default '0',
  `rtIPAddress` varchar(255) default NULL,
  `rtPosterName` varchar(255) default NULL,
  `rtPosterLoginID` int(11) default '0',
  `rtPosterEmail` varchar(255) default NULL,
  `rtHeader` varchar(255) default NULL,
  `rtComments` text,
  PRIMARY KEY  (`rtID`),
  KEY `rtProdID` (`rtProdID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ratings`
--

LOCK TABLES `ratings` WRITE;
/*!40000 ALTER TABLE `ratings` DISABLE KEYS */;
/*!40000 ALTER TABLE `ratings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recentlyviewed`
--

DROP TABLE IF EXISTS `recentlyviewed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recentlyviewed` (
  `rvID` int(11) NOT NULL auto_increment,
  `rvProdID` varchar(255) NOT NULL,
  `rvProdName` varchar(255) NOT NULL,
  `rvProdSection` int(11) NOT NULL default '0',
  `rvProdURL` varchar(255) NOT NULL,
  `rvSessionID` varchar(255) NOT NULL,
  `rvCustomerID` int(11) NOT NULL default '0',
  `rvDate` datetime NOT NULL,
  PRIMARY KEY  (`rvID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recentlyviewed`
--

LOCK TABLES `recentlyviewed` WRITE;
/*!40000 ALTER TABLE `recentlyviewed` DISABLE KEYS */;
/*!40000 ALTER TABLE `recentlyviewed` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `relatedprods`
--

DROP TABLE IF EXISTS `relatedprods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `relatedprods` (
  `rpProdID` varchar(128) NOT NULL,
  `rpRelProdID` varchar(128) NOT NULL,
  PRIMARY KEY  (`rpProdID`,`rpRelProdID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `relatedprods`
--

LOCK TABLES `relatedprods` WRITE;
/*!40000 ALTER TABLE `relatedprods` DISABLE KEYS */;
/*!40000 ALTER TABLE `relatedprods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sections`
--

DROP TABLE IF EXISTS `sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sections` (
  `sectionID` int(11) NOT NULL auto_increment,
  `sectionName` varchar(255) default NULL,
  `sectionName2` varchar(255) default NULL,
  `sectionName3` varchar(255) default NULL,
  `sectionWorkingName` varchar(255) default NULL,
  `sectionurl` varchar(255) default NULL,
  `sectionurl2` varchar(255) default NULL,
  `sectionurl3` varchar(255) default NULL,
  `sectionImage` varchar(255) default NULL,
  `sectionDescription` text,
  `sectionDescription2` text,
  `sectionDescription3` text,
  `topSection` int(11) default '0',
  `rootSection` int(11) default '0',
  `sectionOrder` int(11) default '0',
  `sectionDisabled` tinyint(4) default '0',
  PRIMARY KEY  (`sectionID`),
  KEY `sectionOrder` (`sectionOrder`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sections`
--

LOCK TABLES `sections` WRITE;
/*!40000 ALTER TABLE `sections` DISABLE KEYS */;
INSERT INTO `sections` VALUES (1,'Systems',NULL,NULL,'Systems',NULL,NULL,NULL,'','Complete PC systems including tower systems, laptops and palmtop computers. The very best in PC power.',NULL,NULL,5,1,3,0),(2,'Scanners',NULL,NULL,'Scanners',NULL,NULL,NULL,'','RGB color scanners and scanner based systems for everything from digital snaps to professional prints.',NULL,NULL,6,1,5,0),(3,'Peripherals',NULL,NULL,'Peripherals',NULL,NULL,NULL,'','Keyboards, mice, cables and mousemats and all your other PC peripheral needs.',NULL,NULL,5,1,2,0),(4,'Printers',NULL,NULL,'Printers',NULL,NULL,NULL,'','Inkjet and laser printers for the very best in home and small office printing systems.',NULL,NULL,6,1,6,0),(5,'Computer Parts',NULL,NULL,'Computer Parts',NULL,NULL,NULL,'','Bits and pieces for your computer',NULL,NULL,0,0,1,0),(6,'Printers and Scanners',NULL,NULL,'Printers and Scanners',NULL,NULL,NULL,'','Printers and scanners for your PC',NULL,NULL,0,0,4,0);
/*!40000 ALTER TABLE `sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `states`
--

DROP TABLE IF EXISTS `states`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `states` (
  `stateID` int(11) NOT NULL,
  `stateName` varchar(50) default NULL,
  `stateAbbrev` varchar(50) default NULL,
  `stateTax` double default '0',
  `stateEnabled` tinyint(4) default NULL,
  `stateZone` int(11) default '0',
  `stateFreeShip` tinyint(4) default '1',
  PRIMARY KEY  (`stateID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `states`
--

LOCK TABLES `states` WRITE;
/*!40000 ALTER TABLE `states` DISABLE KEYS */;
INSERT INTO `states` VALUES (2,'Alabama','AL',0,1,101,1),(3,'Alaska','AK',0,1,101,1),(4,'American Samoa','AS',0,1,101,1),(5,'Arizona','AZ',0,1,101,1),(6,'Arkansas','AR',0,1,101,1),(7,'California','CA',0,1,101,1),(8,'Colorado','CO',0,1,101,1),(9,'Connecticut','CT',0,1,101,1),(10,'Delaware','DE',0,1,101,1),(11,'District Of Columbia','DC',0,1,101,1),(12,'Fdr. States Of Micronesia','FM',0,1,101,1),(13,'Florida','FL',0,1,101,1),(14,'Georgia','GA',0,1,101,1),(15,'Guam','GU',0,1,101,1),(16,'Hawaii','HI',0,1,101,1),(17,'Idaho','ID',0,1,101,1),(18,'Illinois','IL',0,1,101,1),(19,'Indiana','IN',0,1,101,1),(20,'Iowa','IA',0,1,101,1),(21,'Kansas','KS',0,1,101,1),(22,'Kentucky','KY',0,1,101,1),(23,'Louisiana','LA',0,1,101,1),(24,'Maine','ME',0,1,101,1),(25,'Marshall Islands','MH',0,1,101,1),(26,'Maryland','MD',0,1,101,1),(27,'Massachusetts','MA',0,1,101,1),(28,'Michigan','MI',0,1,101,1),(29,'Minnesota','MN',0,1,101,1),(30,'Mississippi','MS',0,1,101,1),(31,'Missouri','MO',0,1,101,1),(32,'Montana','MT',0,1,101,1),(33,'Nebraska','NE',0,1,101,1),(34,'Nevada','NV',0,1,101,1),(35,'New Hampshire','NH',0,1,101,1),(36,'New Jersey','NJ',0,1,101,1),(37,'New Mexico','NM',0,1,101,1),(38,'New York','NY',0,1,101,1),(39,'North Carolina','NC',0,1,101,1),(40,'North Dakota','ND',0,1,101,1),(41,'Northern Mariana Islands','MP',0,1,101,1),(42,'Ohio','OH',0,1,101,1),(43,'Oklahoma','OK',0,1,101,1),(44,'Oregon','OR',0,1,101,1),(45,'Palau','PW',0,1,101,1),(46,'Pennsylvania','PA',0,1,101,1),(47,'Puerto Rico','PR',0,1,101,1),(48,'Rhode Island','RI',0,1,101,1),(49,'South Carolina','SC',0,1,101,1),(50,'South Dakota','SD',0,1,101,1),(51,'Tennessee','TN',0,1,101,1),(52,'Texas','TX',0,1,101,1),(53,'Utah','UT',0,1,101,1),(54,'Vermont','VT',0,1,101,1),(55,'Virgin Islands','VI',0,1,101,1),(56,'Virginia','VA',0,1,101,1),(57,'Washington','WA',0,1,101,1),(58,'West Virginia','WV',0,1,101,1),(59,'Wisconsin','WI',0,1,101,1),(60,'Wyoming','WY',0,1,101,1),(61,'Armed Forces Africa','AE',0,0,101,1),(62,'Armed Forces Americas','AA',0,0,101,1),(63,'Armed Forces Canada','AE',0,0,101,1),(64,'Armed Forces Europe','AE',0,0,101,1),(65,'Armed Forces Middle East','AE',0,0,101,1),(66,'Armed Forces Pacific','AP',0,0,101,1);
/*!40000 ALTER TABLE `states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tmplogin`
--

DROP TABLE IF EXISTS `tmplogin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmplogin` (
  `tmploginid` varchar(100) NOT NULL,
  `tmploginname` varchar(50) default NULL,
  `tmploginchk` int(11) default '0',
  `tmplogindate` datetime default NULL,
  PRIMARY KEY  (`tmploginid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tmplogin`
--

LOCK TABLES `tmplogin` WRITE;
/*!40000 ALTER TABLE `tmplogin` DISABLE KEYS */;
/*!40000 ALTER TABLE `tmplogin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `uspsmethods`
--

DROP TABLE IF EXISTS `uspsmethods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uspsmethods` (
  `uspsID` int(11) NOT NULL,
  `uspsMethod` varchar(150) NOT NULL,
  `uspsShowAs` varchar(150) NOT NULL,
  `uspsUseMethod` tinyint(4) default '0',
  `uspsFSA` tinyint(4) default '0',
  `uspsLocal` tinyint(4) default '0',
  PRIMARY KEY  (`uspsID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `uspsmethods`
--

LOCK TABLES `uspsmethods` WRITE;
/*!40000 ALTER TABLE `uspsmethods` DISABLE KEYS */;
INSERT INTO `uspsmethods` VALUES (1,'EXPRESS','Express Mail',0,0,1),(2,'PRIORITY','Priority Mail',0,0,1),(3,'PARCEL','Parcel Post',1,1,1),(14,'Media','Media Mail',0,0,1),(15,'BPM','Bound Printed Matter',0,0,1),(16,'FIRST CLASS','First-Class Mail',0,0,1),(30,'4','Global Express Guaranteed',0,0,0),(31,'6','Global Express Guaranteed',0,0,0),(32,'7','Global Express Guaranteed',0,0,0),(33,'1','Express Mail International',0,0,0),(34,'10','Express Mail International',0,0,0),(35,'2','Priority Mail International',0,0,0),(36,'8','Priority Mail International',0,0,0),(37,'9','Priority Mail International',0,0,0),(38,'13','First-Class Mail',1,0,0),(39,'14','First-Class Mail',0,0,0),(40,'15','First-Class Mail',0,0,0),(41,'11','Priority Mail',0,0,0),(101,'01','UPS Next Day Air&reg;',1,0,1),(102,'02','UPS 2nd Day Air&reg;',1,0,1),(103,'03','UPS Ground',1,1,1),(104,'07','UPS Worldwide Express',1,0,1),(105,'08','UPS Worldwide Expedited',1,0,1),(106,'11','UPS Standard',1,0,1),(107,'12','UPS 3 Day Select&reg;',1,0,1),(108,'13','UPS Next Day Air Saver&reg;',1,0,1),(109,'14','UPS Next Day Air&reg; Early A.M.&reg;',1,0,1),(110,'54','UPS Worldwide Express Plus',1,0,1),(111,'59','UPS 2nd Day Air A.M.&reg;',1,0,1),(112,'65','UPS Express Saver',1,0,1),(201,'1010','Regular',1,1,1),(202,'1020','Expedited',1,0,1),(203,'1030','Xpresspost',1,0,1),(204,'1040','Priority Courier',1,0,1),(205,'1120','Expedited Evening',1,0,1),(206,'1130','XpressPost Evening',1,0,1),(207,'1220','Expedited Saturday',1,0,1),(208,'1230','XpressPost Saturday',1,0,1),(210,'2005','Small Packets Surface',1,0,0),(211,'2010','Surface USA',1,0,0),(212,'2015','Small Packets Air USA',1,0,0),(213,'2020','Air USA',1,0,0),(214,'2025','Expedited USA Commercial',1,0,0),(215,'2030','XPressPost USA',1,0,0),(216,'2040','Purolator USA',1,0,0),(217,'2050','PuroPak USA',1,0,0),(218,'3005','Small Packets Surface International',1,0,0),(221,'3010','Parcel Surface International',1,0,0),(222,'3015','Small Packets Air International',1,0,0),(223,'3020','Air International',1,0,0),(224,'3025','XPressPost International',1,0,0),(225,'3040','Purolator International',1,0,0),(226,'3050','PuroPak International',1,0,0),(301,'PRIORITYOVERNIGHT','FedEx Priority Overnight®',1,0,1),(302,'STANDARDOVERNIGHT','FedEx Standard Overnight®',1,0,1),(303,'FIRSTOVERNIGHT','FedEx First Overnight®',1,0,1),(304,'FEDEX2DAY','FedEx 2Day®',1,0,1),(305,'FEDEXEXPRESSSAVER','FedEx Express Saver®',1,0,1),(306,'INTERNATIONALPRIORITY','FedEx International Priority® ',1,0,1),(307,'INTERNATIONALECONOMY','FedEx International Economy®',1,0,1),(308,'INTERNATIONALFIRST','FedEx International Next Flight® ',1,0,1),(310,'FEDEX1DAYFREIGHT','FedEx 1Day Freight®',1,0,0),(311,'FEDEX2DAYFREIGHT','FedEx 2Day Freight®',1,0,0),(312,'FEDEX3DAYFREIGHT','FedEx 3Day Freight®',1,0,0),(313,'FEDEXGROUND','FedEx Ground®',1,1,0),(314,'GROUNDHOMEDELIVERY','FedEx Home Delivery®',1,0,0),(315,'INTERNATIONALPRIORITYFREIGHT','FedEx International Priority Freight®',1,0,0),(316,'INTERNATIONALECONOMYFREIGHT','FedEx International Economy Freight®',1,0,0),(317,'EUROPEFIRSTINTERNATIONALPRIORITY','FedEx Europe First® - Int\'l Priority',1,0,1);
/*!40000 ALTER TABLE `uspsmethods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zonecharges`
--

DROP TABLE IF EXISTS `zonecharges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zonecharges` (
  `zcID` int(11) NOT NULL auto_increment,
  `zcZone` int(11) default '0',
  `zcWeight` double default '0',
  `zcRate` double default '0',
  `zcRate2` double default '0',
  `zcRate3` double default '0',
  `zcRate4` double default '0',
  `zcRate5` double default '0',
  `zcRatePC` tinyint(1) default '0',
  `zcRatePC2` tinyint(1) default '0',
  `zcRatePC3` tinyint(1) default '0',
  `zcRatePC4` tinyint(1) default '0',
  `zcRatePC5` tinyint(1) default '0',
  PRIMARY KEY  (`zcID`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zonecharges`
--

LOCK TABLES `zonecharges` WRITE;
/*!40000 ALTER TABLE `zonecharges` DISABLE KEYS */;
INSERT INTO `zonecharges` VALUES (1,1,0.2,0.3,0.4,0,0,0,0,0,0,0,0),(2,1,0.5,0.5,0.6,0,0,0,0,0,0,0,0),(3,1,1,0.9,1,0,0,0,0,0,0,0,0),(4,1,1.5,1.3,1.4,0,0,0,0,0,0,0,0),(5,1,2,1.5,1.6,0,0,0,0,0,0,0,0),(6,1,5,2,2.1,0,0,0,0,0,0,0,0),(7,1,-1,0.5,0.6,0,0,0,0,0,0,0,0),(8,2,0.2,0.4,0.5,0,0,0,0,0,0,0,0),(9,2,0.5,0.7,0.8,0,0,0,0,0,0,0,0),(10,2,1,1.1,1.2,0,0,0,0,0,0,0,0),(11,2,1.5,1.6,1.7,0,0,0,0,0,0,0,0),(12,2,2,2,2.1,0,0,0,0,0,0,0,0),(13,2,5,3,3.1,0,0,0,0,0,0,0,0),(14,2,-1,0.7,0.8,0,0,0,0,0,0,0,0),(15,3,-1.1,0.8,0.9,0,0,0,0,0,0,0,0),(16,3,0.2,0.5,0.6,0,0,0,0,0,0,0,0),(17,3,0.5,0.8,0.9,0,0,0,0,0,0,0,0),(18,3,1,1.2,1.3,0,0,0,0,0,0,0,0),(19,3,1.5,1.7,1.8,0,0,0,0,0,0,0,0),(20,3,2,2.2,2.3,0,0,0,0,0,0,0,0),(21,3,5,3.2,3.3,0,0,0,0,0,0,0,0),(22,4,-1,1,1.1,0,0,0,0,0,0,0,0),(23,4,1,1.5,1.6,0,0,0,0,0,0,0,0),(24,4,2,2.8,2.9,0,0,0,0,0,0,0,0),(25,4,3,3.8,3.9,0,0,0,0,0,0,0,0),(26,4,4,4.8,4.9,0,0,0,0,0,0,0,0),(27,101,-1,1,1.1,0,0,0,0,0,0,0,0),(28,101,1,1,1.1,0,0,0,0,0,0,0,0);
/*!40000 ALTER TABLE `zonecharges` 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 2010-03-17  9:45:38