-- http://www.phpmyadmin.net
--




-- --------------------------------------------------------

--
-- Table structure for table `company`
--

CREATE TABLE IF NOT EXISTS `company` (
  `companyID` int(11) NOT NULL AUTO_INCREMENT,
  `description` mediumblob,
  `services` mediumblob,
  `businessname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactaddress` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactcity` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactstate` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactzip` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactphone` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactfax` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contactinfo` mediumblob,
  `contactemail` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `aboutus` mediumblob,
  `terms` mediumblob,
  `privacypolicy` mediumblob,
  `homekeywords` mediumblob,
  `homeshortdescription` mediumblob,
  PRIMARY KEY (`companyID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`companyID`, `description`, `services`, `businessname`, `contactname`, `contactaddress`, `contactcity`, `contactstate`, `contactzip`, `contactphone`, `contactfax`, `contactinfo`, `contactemail`, `aboutus`, `terms`, `privacypolicy`, `homekeywords`, `homeshortdescription`) VALUES
(1, 0x20, 0x20, 'Your Company Here', 'Contact Name', 'Address', 'City', 'OR', 'ZIP', 'Phone', 'Fax', 0x4c6576656c20466f757220446576656c6f706d656e74205465616d3a3c6272202f3e4a6f7368204a6f6e6573202d204f776e65722f446576656c6f7065723c6272202f3e4d61747420436f726c6579202d20446576656c6f706572, 'support@yourURL.com', 0x20, 0x[BLOB], 0x[BLOB], 0x4c6576656c20466f75722044656d6f2c20466c6173682053686f7070696e6720436172742044656d6f2c2053686f7070696e67204361727420536f6674776172652c204f6e6c696e652045636f6d6d65726365, 0x[BLOB]);

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `countries` (
  `id_cnt` int(11) NOT NULL AUTO_INCREMENT,
  `name_cnt` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `iso2_cnt` char(2) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `iso3_cnt` char(3) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `sortorder` int(11) NOT NULL,
  PRIMARY KEY (`id_cnt`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=243 ;

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

INSERT INTO `countries` (`id_cnt`, `name_cnt`, `iso2_cnt`, `iso3_cnt`, `sortorder`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', 10),
(2, 'Albania', 'AL', 'ALB', 11),
(3, 'Algeria', 'DZ', 'DZA', 12),
(4, 'American Samoa', 'AS', 'ASM', 13),
(5, 'Andorra', 'AD', 'AND', 14),
(6, 'Angola', 'AO', 'AGO', 15),
(7, 'Anguilla', 'AI', 'AIA', 16),
(8, 'Antarctica', 'AQ', 'ATA', 17),
(9, 'Antigua and Barbuda', 'AG', 'ATG', 18),
(10, 'Argentina', 'AR', 'ARG', 19),
(11, 'Armenia', 'AM', 'ARM', 20),
(12, 'Aruba', 'AW', 'ABW', 21),
(13, 'Australia', 'AU', 'AUS', 3),
(14, 'Austria', 'AT', 'AUT', 23),
(15, 'Azerbaijan', 'AZ', 'AZE', 24),
(16, 'Bahamas', 'BS', 'BHS', 25),
(17, 'Bahrain', 'BH', 'BHR', 26),
(18, 'Bangladesh', 'BD', 'BGD', 27),
(19, 'Barbados', 'BB', 'BRB', 28),
(20, 'Belarus', 'BY', 'BLR', 29),
(21, 'Belgium', 'BE', 'BEL', 30),
(22, 'Belize', 'BZ', 'BLZ', 31),
(23, 'Benin', 'BJ', 'BEN', 32),
(24, 'Bermuda', 'BM', 'BMU', 33),
(25, 'Bhutan', 'BT', 'BTN', 34),
(26, 'Bolivia', 'BO', 'BOL', 35),
(28, 'Botswana', 'BW', 'BWA', 36),
(29, 'Bouvet Island', 'BV', 'BVT', 37),
(30, 'Brazil', 'BR', 'BRA', 38),
(32, 'Brunei Darussalam', 'BN', 'BRN', 39),
(33, 'Bulgaria', 'BG', 'BGR', 40),
(34, 'Burkina Faso', 'BF', 'BFA', 41),
(35, 'Burundi', 'BI', 'BDI', 42),
(36, 'Cambodia', 'KH', 'KHM', 43),
(37, 'Cameroon', 'CM', 'CMR', 44),
(38, 'Canada', 'CA', 'CAN', 2),
(39, 'Cape Verde', 'CV', 'CPV', 46),
(40, 'Cayman Islands', 'KY', 'CYM', 47),
(42, 'Chad', 'TD', 'TCD', 48),
(43, 'Chile', 'CL', 'CHL', 49),
(44, 'China', 'CN', 'CHN', 50),
(45, 'Christmas Island', 'CX', 'CXR', 51),
(47, 'Colombia', 'CO', 'COL', 52),
(48, 'Comoros', 'KM', 'COM', 53),
(49, 'Congo', 'CG', 'COG', 54),
(50, 'Cook Islands', 'CK', 'COK', 55),
(51, 'Costa Rica', 'CR', 'CRI', 56),
(52, 'Cote D''Ivoire', 'CI', 'CIV', 57),
(53, 'Croatia', 'HR', 'HRV', 58),
(54, 'Cuba', 'CU', 'CUB', 59),
(55, 'Cyprus', 'CY', 'CYP', 60),
(56, 'Czech Republic', 'CZ', 'CZE', 61),
(57, 'Denmark', 'DK', 'DNK', 62),
(58, 'Djibouti', 'DJ', 'DJI', 63),
(59, 'Dominica', 'DM', 'DMA', 64),
(60, 'Dominican Republic', 'DO', 'DOM', 65),
(61, 'East Timor', 'TP', 'TMP', 66),
(62, 'Ecuador', 'EC', 'ECU', 67),
(63, 'Egypt', 'EG', 'EGY', 68),
(64, 'El Salvador', 'SV', 'SLV', 69),
(65, 'Equatorial Guinea', 'GQ', 'GNQ', 70),
(66, 'Eritrea', 'ER', 'ERI', 71),
(67, 'Estonia', 'EE', 'EST', 72),
(68, 'Ethiopia', 'ET', 'ETH', 73),
(70, 'Faroe Islands', 'FO', 'FRO', 74),
(71, 'Fiji', 'FJ', 'FJI', 75),
(72, 'Finland', 'FI', 'FIN', 76),
(73, 'France', 'FR', 'FRA', 77),
(74, 'France, Metropolitan', 'FX', 'FXX', 78),
(75, 'French Guiana', 'GF', 'GUF', 79),
(76, 'French Polynesia', 'PF', 'PYF', 80),
(78, 'Gabon', 'GA', 'GAB', 81),
(79, 'Gambia', 'GM', 'GMB', 82),
(80, 'Georgia', 'GE', 'GEO', 83),
(81, 'Germany', 'DE', 'DEU', 84),
(82, 'Ghana', 'GH', 'GHA', 85),
(83, 'Gibraltar', 'GI', 'GIB', 86),
(84, 'Greece', 'GR', 'GRC', 87),
(85, 'Greenland', 'GL', 'GRL', 88),
(86, 'Grenada', 'GD', 'GRD', 89),
(87, 'Guadeloupe', 'GP', 'GLP', 90),
(88, 'Guam', 'GU', 'GUM', 91),
(89, 'Guatemala', 'GT', 'GTM', 92),
(90, 'Guinea', 'GN', 'GIN', 93),
(91, 'Guinea-bissau', 'GW', 'GNB', 94),
(92, 'Guyana', 'GY', 'GUY', 95),
(93, 'Haiti', 'HT', 'HTI', 96),
(95, 'Honduras', 'HN', 'HND', 97),
(96, 'Hong Kong', 'HK', 'HKG', 98),
(97, 'Hungary', 'HU', 'HUN', 99),
(98, 'Iceland', 'IS', 'ISL', 100),
(99, 'India', 'IN', 'IND', 101),
(100, 'Indonesia', 'ID', 'IDN', 102),
(102, 'Iraq', 'IQ', 'IRQ', 103),
(103, 'Ireland', 'IE', 'IRL', 104),
(104, 'Israel', 'IL', 'ISR', 105),
(105, 'Italy', 'IT', 'ITA', 106),
(106, 'Jamaica', 'JM', 'JAM', 107),
(107, 'Japan', 'JP', 'JPN', 108),
(108, 'Jordan', 'JO', 'JOR', 109),
(109, 'Kazakhstan', 'KZ', 'KAZ', 110),
(110, 'Kenya', 'KE', 'KEN', 111),
(111, 'Kiribati', 'KI', 'KIR', 112),
(113, 'Korea, Republic of', 'KR', 'KOR', 113),
(114, 'Kuwait', 'KW', 'KWT', 114),
(115, 'Kyrgyzstan', 'KG', 'KGZ', 115),
(117, 'Latvia', 'LV', 'LVA', 116),
(118, 'Lebanon', 'LB', 'LBN', 117),
(119, 'Lesotho', 'LS', 'LSO', 118),
(120, 'Liberia', 'LR', 'LBR', 119),
(122, 'Liechtenstein', 'LI', 'LIE', 120),
(123, 'Lithuania', 'LT', 'LTU', 121),
(124, 'Luxembourg', 'LU', 'LUX', 122),
(125, 'Macau', 'MO', 'MAC', 123),
(127, 'Madagascar', 'MG', 'MDG', 124),
(128, 'Malawi', 'MW', 'MWI', 125),
(129, 'Malaysia', 'MY', 'MYS', 126),
(130, 'Maldives', 'MV', 'MDV', 127),
(131, 'Mali', 'ML', 'MLI', 128),
(132, 'Malta', 'MT', 'MLT', 129),
(133, 'Marshall Islands', 'MH', 'MHL', 130),
(134, 'Martinique', 'MQ', 'MTQ', 131),
(135, 'Mauritania', 'MR', 'MRT', 132),
(136, 'Mauritius', 'MU', 'MUS', 133),
(137, 'Mayotte', 'YT', 'MYT', 134),
(138, 'Mexico', 'MX', 'MEX', 135),
(141, 'Monaco', 'MC', 'MCO', 136),
(142, 'Mongolia', 'MN', 'MNG', 137),
(143, 'Montserrat', 'MS', 'MSR', 138),
(144, 'Morocco', 'MA', 'MAR', 139),
(145, 'Mozambique', 'MZ', 'MOZ', 140),
(146, 'Myanmar', 'MM', 'MMR', 141),
(147, 'Namibia', 'NA', 'NAM', 142),
(148, 'Nauru', 'NR', 'NRU', 143),
(149, 'Nepal', 'NP', 'NPL', 144),
(150, 'Netherlands', 'NL', 'NLD', 145),
(151, 'Netherlands Antilles', 'AN', 'ANT', 146),
(152, 'New Caledonia', 'NC', 'NCL', 147),
(153, 'New Zealand', 'NZ', 'NZL', 148),
(154, 'Nicaragua', 'NI', 'NIC', 149),
(155, 'Niger', 'NE', 'NER', 150),
(156, 'Nigeria', 'NG', 'NGA', 151),
(157, 'Niue', 'NU', 'NIU', 152),
(158, 'Norfolk Island', 'NF', 'NFK', 153),
(160, 'Norway', 'NO', 'NOR', 154),
(161, 'Oman', 'OM', 'OMN', 155),
(162, 'Pakistan', 'PK', 'PAK', 156),
(163, 'Palau', 'PW', 'PLW', 157),
(164, 'Panama', 'PA', 'PAN', 158),
(165, 'Papua New Guinea', 'PG', 'PNG', 159),
(166, 'Paraguay', 'PY', 'PRY', 160),
(167, 'Peru', 'PE', 'PER', 161),
(168, 'Philippines', 'PH', 'PHL', 162),
(169, 'Pitcairn', 'PN', 'PCN', 163),
(170, 'Poland', 'PL', 'POL', 164),
(171, 'Portugal', 'PT', 'PRT', 165),
(172, 'Puerto Rico', 'PR', 'PRI', 166),
(173, 'Qatar', 'QA', 'QAT', 167),
(174, 'Reunion', 'RE', 'REU', 168),
(175, 'Romania', 'RO', 'ROM', 169),
(176, 'Russian Federation', 'RU', 'RUS', 170),
(177, 'Rwanda', 'RW', 'RWA', 171),
(178, 'Saint Kitts and Nevis', 'KN', 'KNA', 172),
(179, 'Saint Lucia', 'LC', 'LCA', 173),
(181, 'Samoa', 'WS', 'WSM', 174),
(182, 'San Marino', 'SM', 'SMR', 175),
(183, 'Sao Tome and Principe', 'ST', 'STP', 176),
(184, 'Saudi Arabia', 'SA', 'SAU', 177),
(185, 'Senegal', 'SN', 'SEN', 178),
(186, 'Seychelles', 'SC', 'SYC', 179),
(187, 'Sierra Leone', 'SL', 'SLE', 180),
(188, 'Singapore', 'SG', 'SGP', 181),
(190, 'Slovenia', 'SI', 'SVN', 182),
(191, 'Solomon Islands', 'SB', 'SLB', 183),
(192, 'Somalia', 'SO', 'SOM', 184),
(193, 'South Africa', 'ZA', 'ZAF', 185),
(195, 'Spain', 'ES', 'ESP', 186),
(196, 'Sri Lanka', 'LK', 'LKA', 187),
(197, 'St. Helena', 'SH', 'SHN', 188),
(198, 'St. Pierre and Miquelon', 'PM', 'SPM', 189),
(199, 'Sudan', 'SD', 'SDN', 190),
(200, 'Suriname', 'SR', 'SUR', 191),
(202, 'Swaziland', 'SZ', 'SWZ', 192),
(203, 'Sweden', 'SE', 'SWE', 193),
(204, 'Switzerland', 'CH', 'CHE', 194),
(205, 'Syrian Arab Republic', 'SY', 'SYR', 195),
(206, 'Taiwan', 'TW', 'TWN', 196),
(207, 'Tajikistan', 'TJ', 'TJK', 197),
(209, 'Thailand', 'TH', 'THA', 198),
(210, 'Togo', 'TG', 'TGO', 199),
(211, 'Tokelau', 'TK', 'TKL', 200),
(212, 'Tonga', 'TO', 'TON', 201),
(213, 'Trinidad and Tobago', 'TT', 'TTO', 202),
(214, 'Tunisia', 'TN', 'TUN', 203),
(215, 'Turkey', 'TR', 'TUR', 204),
(216, 'Turkmenistan', 'TM', 'TKM', 205),
(217, 'Turks and Caicos Islands', 'TC', 'TCA', 206),
(218, 'Tuvalu', 'TV', 'TUV', 207),
(219, 'Uganda', 'UG', 'UGA', 208),
(220, 'Ukraine', 'UA', 'UKR', 209),
(221, 'United Arab Emirates', 'AE', 'ARE', 210),
(222, 'United Kingdom', 'GB', 'GBR', 211),
(223, 'United States', 'US', 'USA', 1),
(224, 'US Minor Outlying Islands', 'UM', 'UMI', 213),
(225, 'Uruguay', 'UY', 'URY', 214),
(226, 'Uzbekistan', 'UZ', 'UZB', 215),
(227, 'Vanuatu', 'VU', 'VUT', 216),
(229, 'Venezuela', 'VE', 'VEN', 217),
(230, 'Viet Nam', 'VN', 'VNM', 218),
(231, 'Virgin Islands (British)', 'VG', 'VGB', 219),
(232, 'Virgin Islands (U.S.)', 'VI', 'VIR', 220),
(233, 'Wallis and Futuna Islands', 'WF', 'WLF', 221),
(234, 'Western Sahara', 'EH', 'ESH', 222),
(235, 'Yemen', 'YE', 'YEM', 223),
(236, 'Yugoslavia', 'YU', 'YUG', 224),
(237, 'Zaire', 'ZR', 'ZAR', 225),
(238, 'Zambia', 'ZM', 'ZMB', 226),
(239, 'Zimbabwe', 'ZW', 'ZWE', 227);

-- --------------------------------------------------------

--
-- Table structure for table `dblog`
--

CREATE TABLE IF NOT EXISTS `dblog` (
  `keyfield` int(11) NOT NULL AUTO_INCREMENT,
  `logentrydate` datetime DEFAULT '0000-00-00 00:00:00',
  `logentrytype` varchar(25) DEFAULT '0',
  PRIMARY KEY (`keyfield`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `details`
--

CREATE TABLE IF NOT EXISTS `details` (
  `details_id` int(11) NOT NULL AUTO_INCREMENT,
  `OrderID` int(11) NOT NULL DEFAULT '0',
  `ProductID` int(11) NOT NULL DEFAULT '0',
  `OrderTitle` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `OrderDescription` text CHARACTER SET utf8,
  `OrderPrice` float(7,2) DEFAULT NULL,
  `Quantity` int(11) NOT NULL DEFAULT '0',
  `Image1` varchar(255) CHARACTER SET utf8 DEFAULT '0',
  `orderoption1` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  `orderoption2` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  `orderoption3` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  `orderoption4` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  `orderoption5` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  `orderedItemCode` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `isGiftCard` tinyint(1) DEFAULT '0',
  `shipperID` int(11) DEFAULT '0',
  `OrderModelNumber` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `message` text CHARACTER SET utf8,
  `orderdate` varchar(50) CHARACTER SET utf8 DEFAULT '0000-00-00 00:00:00',
  `shipperfname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `shipperlname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `fromname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `toname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `deliverymethod` varchar(50) CHARACTER SET utf8 DEFAULT '0',
  `isDownload` tinyint(1) DEFAULT '0',
  `downloadID` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  `isTaxable` int(11) DEFAULT NULL,
  `downloadkey` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  PRIMARY KEY (`details_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1209 ;

--
-- Table structure for table `downloadkey`
--

CREATE TABLE IF NOT EXISTS `downloadkey` (
  `uniqueid` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `timestamp` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `downloads` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `orderid` int(11) DEFAULT '0',
  `productid` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  PRIMARY KEY (`uniqueid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `errortable`
--

CREATE TABLE IF NOT EXISTS `errortable` (
  `errorID` int(11) NOT NULL AUTO_INCREMENT,
  `errormessage` text CHARACTER SET utf8,
  `orderID` int(11) DEFAULT NULL,
  PRIMARY KEY (`errorID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=140 ;

-- --------------------------------------------------------

--
-- Table structure for table `giftcards`
--

CREATE TABLE IF NOT EXISTS `giftcards` (
  `giftcardid` varchar(20) CHARACTER SET utf8 NOT NULL,
  `giftcardamount` float(9,2) DEFAULT NULL,
  `giftcardmessage` text CHARACTER SET utf8,
  `isgiftcard` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`giftcardid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

CREATE TABLE IF NOT EXISTS `manufacturer` (
  `manufacturerID` int(11) NOT NULL AUTO_INCREMENT,
  `manufacturername` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Clicks` int(11) DEFAULT '0',
  PRIMARY KEY (`manufacturerID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

INSERT INTO `manufacturer` (`manufacturerID`, `manufacturername`, `Clicks`) VALUES
(1, 'MANUFACTURER', 0);

-- --------------------------------------------------------

--
-- Table structure for table `menulevel1`
--

CREATE TABLE IF NOT EXISTS `menulevel1` (
  `keyfield` int(11) NOT NULL AUTO_INCREMENT,
  `menuName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Clicks` int(11) DEFAULT '0',
  `menu1order` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`keyfield`),
  UNIQUE KEY `menuName` (`menuName`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `menulevel1`
--

INSERT INTO `menulevel1` (`keyfield`, `menuName`, `Clicks`, `menu1order`) VALUES
(6, 'Gift Cards', 13, 5),
(7, 'Downloads', 85, 6),
(13, 'Mens Clothing', 754, 1),
(14, 'Womens Clothing', 114, 2),
(15, 'Climbing Gear', 20, 3),
(16, 'Backpacks', 23, 4);

-- --------------------------------------------------------

--
-- Table structure for table `menulevel2`
--

CREATE TABLE IF NOT EXISTS `menulevel2` (
  `keyfield` int(11) NOT NULL AUTO_INCREMENT,
  `menuParentID` int(11) DEFAULT '0',
  `menuName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Clicks` int(11) DEFAULT '0',
  `menu2order` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`keyfield`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

--
-- Table structure for table `menulevel3`
--

CREATE TABLE IF NOT EXISTS `menulevel3` (
  `keyfield` int(11) NOT NULL AUTO_INCREMENT,
  `menuParentID` int(11) DEFAULT '0',
  `menuName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Clicks` int(11) DEFAULT '0',
  `menu3order` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`keyfield`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;

--
-- Table structure for table `optionitemimages`
--

CREATE TABLE IF NOT EXISTS `optionitemimages` (
  `optionitemimagesID` int(11) NOT NULL AUTO_INCREMENT,
  `optionitemID` int(11) DEFAULT NULL,
  `productID` int(11) DEFAULT NULL,
  `Image1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Image2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Image3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Image4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Image5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`optionitemimagesID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 AUTO_INCREMENT=141 ;

-- --------------------------------------------------------

--
-- Table structure for table `optionitemquantity`
--

CREATE TABLE IF NOT EXISTS `optionitemquantity` (
  `OptionItemQuantityID` int(11) NOT NULL AUTO_INCREMENT,
  `OptionItemID1` int(11) DEFAULT NULL,
  `OptionItemID2` int(11) DEFAULT NULL,
  `OptionItemID3` int(11) DEFAULT NULL,
  `OptionItemID4` int(11) DEFAULT NULL,
  `OptionItemID5` int(11) DEFAULT NULL,
  `ProductID` int(17) DEFAULT NULL,
  `Quantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`OptionItemQuantityID`),
  UNIQUE KEY `OptionItemQuantityID` (`OptionItemQuantityID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 AUTO_INCREMENT=4600 ;

-- --------------------------------------------------------

--
-- Table structure for table `optionitems`
--

CREATE TABLE IF NOT EXISTS `optionitems` (
  `optionitemID` int(11) NOT NULL AUTO_INCREMENT,
  `optionparentID` int(11) NOT NULL DEFAULT '0',
  `optionitemname` varchar(33) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `optionitemprice` float(7,2) NOT NULL DEFAULT '0.00',
  `optionorder` int(11) NOT NULL DEFAULT '1',
  `optionitemicon` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`optionitemID`),
  UNIQUE KEY `unique_name_ova` (`optionparentID`,`optionitemname`),
  KEY `idopt_ova` (`optionparentID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2989 ;


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

CREATE TABLE IF NOT EXISTS `options` (
  `optionID` int(11) NOT NULL AUTO_INCREMENT,
  `optionName` varchar(85) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `optionLabel` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`optionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

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

CREATE TABLE IF NOT EXISTS `orders` (
  `OrderID` int(11) NOT NULL AUTO_INCREMENT,
  `ClientID` int(11) NOT NULL DEFAULT '0',
  `Total` float(7,2) NOT NULL DEFAULT '0.00',
  `ShipMethod` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `OrderDate` varchar(20) CHARACTER SET utf8 DEFAULT '0000-00-00 00:00:00',
  `OrderStatus` varchar(50) CHARACTER SET utf8 DEFAULT 'Order Started',
  `UpdateDate` varchar(50) CHARACTER SET utf8 DEFAULT '0000-00-00 00:00:00',
  `PromoCode` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `GiftCard` varchar(255) DEFAULT NULL,
  `Tax` float(7,2) DEFAULT '0.00',
  `Shipping` float(7,2) DEFAULT '0.00',
  `ExpediteShipping` varchar(20) CHARACTER SET utf8 DEFAULT 'false',
  `TrackingNumber` varchar(100) CHARACTER SET utf8 DEFAULT '',
  `ShipCarrier` varchar(50) CHARACTER SET utf8 DEFAULT '',
  `TotalWeight` float(9,2) DEFAULT '0.00',
  `Email` varchar(255) DEFAULT NULL,
  `BillName` varchar(255) DEFAULT NULL,
  `BillLastName` varchar(255) DEFAULT NULL,
  `BillAddress` varchar(255) DEFAULT NULL,
  `BillCity` varchar(255) DEFAULT NULL,
  `BillState` varchar(255) DEFAULT NULL,
  `BillCountry` varchar(255) DEFAULT NULL,
  `BillZip` varchar(10) DEFAULT NULL,
  `BillPhone` varchar(15) DEFAULT NULL,
  `ShipName` varchar(255) DEFAULT NULL,
  `ShipLastName` varchar(255) DEFAULT NULL,
  `ShipAddress` varchar(255) DEFAULT NULL,
  `ShipCity` varchar(255) DEFAULT NULL,
  `ShipState` varchar(255) DEFAULT NULL,
  `ShipCountry` varchar(255) DEFAULT NULL,
  `ShipZip` varchar(10) DEFAULT NULL,
  `ShipPhone` varchar(15) DEFAULT NULL,
  `PaymentMethod` varchar(50) DEFAULT NULL,
  `PaypalEmailID` varchar(255) DEFAULT NULL,
  `PaypalTransactionID` varchar(255) DEFAULT NULL,
  `PaypalPayerID` varchar(255) DEFAULT NULL,
  `orderviewed` int(11) DEFAULT '0',
  `ordernotes` text,
  PRIMARY KEY (`OrderID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1231 ;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `orderstatus` (
  `orderstatus` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `orderstatus` (`orderstatus`) VALUES
('Order Shipped'),
('Order Confirmed'),
('Order on Hold'),
('Order Started'),
('Card Approved'),
('Card Denied'),
('PayPal Pending'),
('PayPal Error'),
('PayPal Approved'),
('Ready for Pickup');

-- --------------------------------------------------------

--
-- Table structure for table `perpage`
--

CREATE TABLE IF NOT EXISTS `perpage` (
  `perpageid` int(11) NOT NULL AUTO_INCREMENT,
  `perpage` int(11) NOT NULL,
  PRIMARY KEY (`perpageid`),
  UNIQUE KEY `perpageid` (`perpageid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `perpage`
--

INSERT INTO `perpage` (`perpageid`, `perpage`) VALUES
(1, 12),
(2, 48),
(3, 3);

-- --------------------------------------------------------

--
-- Table structure for table `pricepoints`
--

CREATE TABLE IF NOT EXISTS `pricepoints` (
  `pricepointID` int(11) NOT NULL AUTO_INCREMENT,
  `lessthan` tinyint(1) NOT NULL DEFAULT '0',
  `greaterthan` int(11) NOT NULL DEFAULT '0',
  `lowpoint` float(9,2) NOT NULL DEFAULT '0.00',
  `highpoint` float(9,2) DEFAULT '0.00',
  `pricepointorder` int(11) DEFAULT NULL,
  PRIMARY KEY (`pricepointID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `pricepoints`
--

INSERT INTO `pricepoints` (`pricepointID`, `lessthan`, `greaterthan`, `lowpoint`, `highpoint`, `pricepointorder`) VALUES
(1, 1, 0, 0.00, 10.00, 0),
(2, 0, 0, 25.00, 49.99, 4),
(3, 0, 0, 50.00, 99.99, 5),
(4, 0, 0, 100.00, 299.99, 6),
(5, 0, 1, 299.99, 9999999.00, 7),
(6, 0, 0, 10.00, 14.99, 1),
(7, 0, 0, 15.00, 19.99, 2),
(8, 0, 0, 20.00, 24.99, 3);

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `products` (
  `ProductID` int(11) NOT NULL AUTO_INCREMENT,
  `useQuantityTracking` tinyint(1) NOT NULL DEFAULT '0',
  `Price` float(7,2) DEFAULT '0.00',
  `ListPrice` float(7,2) DEFAULT '0.00',
  `quantity` int(7) DEFAULT '0',
  `Title` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Description` text CHARACTER SET utf8,
  `shortDescription` text,
  `Keywords` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `usespecs` int(11) DEFAULT '0',
  `allowreviews` int(11) DEFAULT '0',
  `specifications` text CHARACTER SET utf8,
  `Weight` float(9,2) DEFAULT '0.00',
  `InStock` int(11) DEFAULT NULL,
  `featureditem` int(11) DEFAULT '0',
  `manufacturer` varchar(255) CHARACTER SET utf8 DEFAULT '0',
  `isTaxable` int(11) DEFAULT '1',
  `isGiftCard` tinyint(1) DEFAULT '0',
  `isDownload` tinyint(1) DEFAULT '0',
  `downloadID` varchar(100) CHARACTER SET utf8 DEFAULT '0',
  `Image1` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Image2` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Image3` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Image4` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Image5` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `option1` int(11) DEFAULT NULL,
  `option2` int(11) DEFAULT NULL,
  `option3` int(11) DEFAULT NULL,
  `option4` int(11) DEFAULT NULL,
  `option5` int(11) DEFAULT NULL,
  `Cat1Name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat2Name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat3Name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat1bName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat2bName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat3bName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat1cName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat2cName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Cat3cName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ModelNumber` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `featureproduct1` varchar(255) DEFAULT NULL,
  `featureproduct2` varchar(255) DEFAULT NULL,
  `featureproduct3` varchar(255) DEFAULT NULL,
  `featureproduct4` varchar(255) DEFAULT NULL,
  `dateadded` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `isSpecial` int(11) NOT NULL DEFAULT '0',
  `useoptionitemimages` tinyint(1) NOT NULL DEFAULT '0',
  `isDonation` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ProductID`),
  UNIQUE KEY `ProductID` (`ProductID`),
  UNIQUE KEY `ModelNumber_2` (`ModelNumber`),
  FULLTEXT KEY `Title` (`Title`),
  FULLTEXT KEY `Description` (`Description`),
  FULLTEXT KEY `ModelNumber` (`ModelNumber`),
  FULLTEXT KEY `manufacturer` (`manufacturer`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=237 ;

--
-- Table structure for table `promocodes`
--

CREATE TABLE IF NOT EXISTS `promocodes` (
  `promoID` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `promodollar` float(7,2) NOT NULL DEFAULT '0.00',
  `dollarbased` int(11) DEFAULT '0',
  `promopercentage` float(7,2) NOT NULL DEFAULT '0.00',
  `percentagebased` int(11) DEFAULT '0',
  `promoshipping` float(7,2) NOT NULL DEFAULT '0.00',
  `shippingbased` int(11) DEFAULT '0',
  `promofreeitem` float(7,2) NOT NULL DEFAULT '0.00',
  `freeitembased` int(11) DEFAULT '0',
  `promoforme` float(7,2) NOT NULL DEFAULT '0.00',
  `formebased` int(11) DEFAULT '0',
  `promomessage` blob NOT NULL,
  `manufacturer` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `productname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `bymanufacturer` int(11) DEFAULT '0',
  `byproductname` int(11) DEFAULT '0',
  `byallproducts` int(11) DEFAULT '0',
  `isgiftcard` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`promoID`),
  UNIQUE KEY `promoID` (`promoID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `promocodes`
--

INSERT INTO `promocodes` (`promoID`, `promodollar`, `dollarbased`, `promopercentage`, `percentagebased`, `promoshipping`, `shippingbased`, `promofreeitem`, `freeitembased`, `promoforme`, `formebased`, `promomessage`, `manufacturer`, `productname`, `bymanufacturer`, `byproductname`, `byallproducts`, `isgiftcard`) VALUES
('freeshipping', 0.00, 0, 0.00, 0, 0.00, 1, 0.00, 0, 0.00, 0, 0x5468697320636f75706f6e20656e7469746c657320796f7520746f2066726565207368697070696e67206f6e2074686520656e74697265206f72646572, 'Black Diamond', '9.7 mm Free Rope', 0, 0, 1, 0),
('promo111', 0.00, 0, 15.00, 1, 0.00, 0, 0.00, 0, 0.00, 0, 0x42792063686f6f73696e672050726f6d6f3131312c20796f752068617665206561726e656420612031352520646973636f756e74206f666620796f757220746f74616c206f726465722070757263686173652e, 'Petzl north face', 'Pro Carabiner', 0, 0, 1, 0),
('promo112', 0.00, 0, 10.00, 1, 0.00, 0, 0.00, 0, 0.00, 0, 0x596f752077696c6c207265636965766520313025206f6666206f6620616c6c204361726162696e65722031202d20204c6f636b696e672050726f204361726162696e65727320696e20796f757220636172742e, 'Petzl Inc.', 'Carabiner 1 - Locking Pro', 0, 1, 0, 0),
('promo113', 0.00, 0, 15.00, 1, 0.00, 0, 0.00, 0, 0.00, 0, 0x42792063686f6f73696e672050726f6d6f3131332c20796f752068617665206561726e656420612031352520646973636f756e74206f666620796f757220746f74616c206f7264657220707572636861736520696620796f7520707572636861736520616e797468696e672066726f6d205065747a6c2c20696e632e, 'Petzl Inc.', 'Pro Silver Locking Carabiner', 1, 0, 0, 0),
('promo222', 20.00, 1, 0.00, 0, 0.00, 0, 0.00, 0, 0.00, 0, 0x4279207573696e672050726f6d6f3232322c20796f752068617665206561726e6564202432302e303020646f6c6c617220646973636f756e74206f666620796f757220746f74616c206f726465722070757263686173652e, 'Camp North Gear', 'Pro Silver Locking Carabiner', 0, 0, 1, 0),
('promo223', 20.00, 1, 0.00, 0, 0.00, 0, 0.00, 0, 0.00, 0, 0x[BLOB], 'Petzl Inc.', 'Carabiner 1 - Locking Pro', 0, 1, 0, 0),
('promo224', 20.00, 1, 0.00, 0, 0.00, 0, 0.00, 0, 0.00, 0, 0x[BLOB], 'Petzl Inc.', 'Carabiner 7 - Sport Set', 1, 0, 0, 0),
('promo444', 0.00, 0, 0.00, 0, 4.99, 1, 0.00, 0, 0.00, 0, 0x42792063686f6f73696e672050726f6d6f3434342c20796f752068617665206561726e656420342e3939206f6666207368697070696e672e, 'Camp North Gear', 'Pro Silver Locking Carabiner', 0, 0, 1, 0),
('promo445', 0.00, 0, 0.00, 0, 4.99, 1, 0.00, 0, 0.00, 0, 0x[BLOB], 'Black Diamond', 'Carabiner 1 - Locking Pro', 0, 1, 0, 0),
('promo446', 0.00, 0, 0.00, 0, 4.99, 1, 0.00, 0, 0.00, 0, 0x5468697320636f75706f6e20656e7469746c657320796f7520746f206120342e393920646f6c6c6172207368697070696e67207261746520646973636f756e7420696620796f7520686176652070757263686173656420616e792070726f64756374732066726f6d205065747a6c2c20496e632e, 'Petzl Inc.', 'Carabiner 7 - Sport Set', 1, 0, 0, 0),
('promo555', 0.00, 0, 0.00, 0, 0.00, 0, 0.00, 1, 0.00, 0, 0x[BLOB], 'Petzl north face', 'Pro Carabiner', 0, 0, 1, 0),
('promo556', 0.00, 0, 0.00, 0, 0.00, 0, 0.00, 1, 0.00, 0, 0x[BLOB], 'Camp North Gear', 'Carabiner 1 - Locking Pro', 0, 1, 0, 0),
('promo557', 0.00, 0, 0.00, 0, 0.00, 0, 0.00, 1, 0.00, 0, 0x[BLOB], 'Petzl Inc.', 'Carabiner 7 - Sport Set', 1, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `reviews`
--

CREATE TABLE IF NOT EXISTS `reviews` (
  `reviewID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL,
  `reviewapproved` int(2) NOT NULL DEFAULT '0',
  `rating` int(2) NOT NULL,
  `reviewtitle` varchar(255) NOT NULL,
  `reviewdescription` mediumblob NOT NULL,
  `datesubmitted` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`reviewID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

-- --------------------------------------------------------

--
-- Table structure for table `shippingrates`
--

CREATE TABLE IF NOT EXISTS `shippingrates` (
  `keyfield` int(11) NOT NULL AUTO_INCREMENT,
  `triggerrate` decimal(8,2) DEFAULT NULL,
  `shippingrate` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`keyfield`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=11 ;

-- --------------------------------------------------------

--
-- Table structure for table `shippingratesexpedite`
--

CREATE TABLE IF NOT EXISTS `shippingratesexpedite` (
  `IDfield` int(11) NOT NULL DEFAULT '1',
  `expediteamount` float(7,2) DEFAULT '0.00',
  `expeditemessage` blob,
  PRIMARY KEY (`IDfield`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shippingratesexpedite`
--

INSERT INTO `shippingratesexpedite` (`IDfield`, `expediteamount`, `expeditemessage`) VALUES
(1, 5.99, 0x536869707320696e20342064617973);

-- --------------------------------------------------------

--
-- Table structure for table `shippingweightrates`
--

CREATE TABLE IF NOT EXISTS `shippingweightrates` (
  `keyfield` int(11) NOT NULL AUTO_INCREMENT,
  `triggerrate` decimal(8,2) DEFAULT NULL,
  `shippingrate` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`keyfield`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=18 ;

--
-- Dumping data for table `shippingweightrates`
--

INSERT INTO `shippingweightrates` (`keyfield`, `triggerrate`, `shippingrate`) VALUES
(14, 1.00, 4.99),
(15, 5.00, 9.99),
(16, 20.00, 15.99),
(17, 0.00, 3.99);

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `states` (
  `id_sta` int(11) NOT NULL AUTO_INCREMENT,
  `idcnt_sta` int(11) NOT NULL DEFAULT '0',
  `code_sta` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `name_sta` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `sortorder` int(11) NOT NULL,
  PRIMARY KEY (`id_sta`),
  KEY `idcnt_sta` (`idcnt_sta`),
  KEY `code_sta` (`code_sta`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=83 ;

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

INSERT INTO `states` (`id_sta`, `idcnt_sta`, `code_sta`, `name_sta`, `sortorder`) VALUES
(1, 38, 'AL', 'Alabama', 10),
(2, 223, 'AK', 'Alaska', 11),
(4, 223, 'AZ', 'Arizona', 12),
(5, 223, 'AR', 'Arkansas', 13),
(12, 223, 'CA', 'California', 14),
(13, 223, 'CO', 'Colorado', 15),
(14, 223, 'CT', 'Connecticut', 16),
(15, 223, 'DE', 'Delaware', 17),
(18, 223, 'FL', 'Florida', 18),
(19, 223, 'GA', 'Georgia', 19),
(21, 223, 'HI', 'Hawaii', 21),
(22, 223, 'ID', 'Idaho', 22),
(23, 223, 'IL', 'Illinois', 23),
(24, 223, 'IN', 'Indiana', 24),
(25, 223, 'IA', 'Iowa', 25),
(26, 223, 'KS', 'Kansas', 26),
(27, 223, 'KY', 'Kentucky', 27),
(28, 223, 'LA', 'Louisiana', 28),
(29, 223, 'ME', 'Maine', 29),
(31, 223, 'MD', 'Maryland', 30),
(32, 223, 'MA', 'Massachusetts', 31),
(33, 223, 'MI', 'Michigan', 32),
(34, 223, 'MN', 'Minnesota', 33),
(35, 223, 'MS', 'Mississippi', 34),
(36, 223, 'MO', 'Missouri', 35),
(37, 223, 'MT', 'Montana', 36),
(38, 223, 'NE', 'Nebraska', 37),
(39, 223, 'NV', 'Nevada', 38),
(40, 223, 'NH', 'New Hampshire', 39),
(41, 223, 'NJ', 'New Jersey', 40),
(42, 223, 'NM', 'New Mexico', 41),
(43, 223, 'NY', 'New York', 42),
(44, 223, 'NC', 'North Carolina', 43),
(45, 223, 'ND', 'North Dakota', 44),
(47, 223, 'OH', 'Ohio', 45),
(48, 223, 'OK', 'Oklahoma', 46),
(49, 223, 'OR', 'Oregon', 47),
(51, 223, 'PA', 'Pennsylvania', 48),
(52, 223, 'PR', 'Puerto Rico', 49),
(53, 223, 'RI', 'Rhode Island', 50),
(54, 223, 'SC', 'South Carolina', 51),
(55, 223, 'SD', 'South Dakota', 52),
(56, 223, 'TN', 'Tennessee', 53),
(57, 223, 'TX', 'Texas', 54),
(58, 223, 'UT', 'Utah', 55),
(59, 223, 'VT', 'Vermont', 56),
(60, 223, 'VI', 'Virgin Islands', 57),
(61, 223, 'VA', 'Virginia', 58),
(62, 223, 'WA', 'Washington', 59),
(63, 223, 'WV', 'West Virginia', 60),
(64, 223, 'WI', 'Wisconsin', 61),
(65, 223, 'WY', 'Wyoming', 62),
(66, 38, 'AB', 'Alberta', 100),
(67, 38, 'BC', 'British Columbia', 101),
(68, 38, 'MB', 'Manitoba', 102),
(69, 38, 'NF', 'Newfoundland', 103),
(70, 38, 'NB', 'New Brunswick', 104),
(71, 38, 'NS', 'Nova Scotia', 105),
(72, 38, 'NT', 'Northwest Territories', 106),
(73, 38, 'NU', 'Nunavut', 107),
(74, 38, 'ON', 'Ontario', 108),
(75, 38, 'PE', 'Prince Edward Island', 109),
(76, 38, 'QC', 'Quebec', 110),
(77, 38, 'SK', 'Saskatchewan', 111),
(78, 38, 'YT', 'Yukon Territory', 112);

-- --------------------------------------------------------

--
-- Table structure for table `statistics`
--

CREATE TABLE IF NOT EXISTS `statistics` (
  `ProductID` int(11) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `lastUpdated` varchar(50) CHARACTER SET utf8 DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ProductID`),
  KEY `ProductID` (`ProductID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `subscribers`
--

CREATE TABLE IF NOT EXISTS `subscribers` (
  `subscriberID` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `firstname` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `lastname` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`subscriberID`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=273 ;

--
-- Table structure for table `taxrate`
--

CREATE TABLE IF NOT EXISTS `taxrate` (
  `taxID` int(11) NOT NULL AUTO_INCREMENT,
  `taxrate` decimal(4,2) DEFAULT NULL,
  `taxstateID` char(2) CHARACTER SET utf8 DEFAULT NULL,
  `taxcountryID` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `taxcountryrate` decimal(4,2) DEFAULT NULL,
  `taxallrate` decimal(4,2) DEFAULT NULL,
  `taxstateenable` int(11) DEFAULT '1',
  `taxallenable` int(11) DEFAULT '0',
  `taxcountryenable` int(11) DEFAULT '0',
  PRIMARY KEY (`taxID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
