-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: jhbrake1_myjak3
-- ------------------------------------------------------
-- Server version	5.7.44

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

DROP TABLE IF EXISTS `ad_associations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ad_associations` (
  `user_id` int(10) unsigned NOT NULL,
  `ad_id` smallint(7) unsigned NOT NULL,
  `upload_id` int(10) unsigned NOT NULL,
  `dx_id` int(10) unsigned NOT NULL,
  `date_submitted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `approved` char(1) NOT NULL DEFAULT 'N',
  KEY `user_id` (`user_id`),
  KEY `upload_id` (`upload_id`),
  KEY `date_submitted` (`date_submitted`),
  KEY `dx_upload_id` (`dx_id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ad_associations`
--

LOCK TABLES `ad_associations` WRITE;
/*!40000 ALTER TABLE `ad_associations` DISABLE KEYS */;
INSERT INTO `ad_associations` VALUES (21,1,3,0,'2012-06-16 05:38:44','Y'),(21,2,4,1,'2012-06-16 05:38:44','Y'),(21,3,0,0,'2012-06-16 05:38:44','Y'),(21,6,7,0,'2012-06-16 05:38:44','Y'),(21,7,0,2,'2012-06-16 05:38:44','Y'),(21,8,8,0,'2012-06-16 05:38:44','Y'),(21,9,0,3,'2012-06-16 05:38:44','Y'),(21,10,0,4,'2012-06-16 05:38:44','Y'),(21,11,9,5,'2012-06-16 05:38:44','Y'),(21,12,10,6,'2012-06-16 05:38:44','Y'),(21,13,0,7,'2012-06-16 05:38:44','Y'),(21,14,11,0,'2012-06-16 05:38:44','Y'),(21,18,15,9,'2012-06-16 05:38:44','Y'),(21,19,0,10,'2012-06-16 05:38:44','Y'),(21,20,16,0,'2012-06-16 05:38:44','Y'),(21,22,18,11,'2012-06-16 05:38:44','Y'),(34,23,0,0,'2010-03-09 06:38:44','Y'),(35,24,0,0,'2010-01-01 06:38:44','Y'),(21,25,19,12,'2012-06-16 05:38:44','Y'),(35,26,0,0,'2010-03-09 06:38:44','Y'),(21,64,63,0,'2012-06-16 05:38:44','Y'),(36,65,65,0,'2010-03-09 06:38:44','Y'),(21,66,66,0,'2012-06-16 05:38:44','Y'),(21,67,67,0,'2012-06-16 05:38:44','Y'),(21,68,68,0,'2012-06-16 05:38:44','Y'),(21,74,74,0,'2012-06-16 05:38:44','Y'),(21,77,77,14,'2012-06-16 05:38:44','Y'),(21,2995,80,0,'2015-10-01 18:16:58','Y'),(3010,2996,107,0,'2018-12-27 08:18:19','Y'),(3010,2997,108,0,'2018-12-27 08:19:35','Y'),(3010,2998,109,0,'2018-12-27 08:20:30','Y'),(3010,2999,110,0,'2018-12-27 08:21:27','Y'),(3010,3000,111,0,'2018-12-27 08:22:03','Y'),(3010,3001,112,0,'2019-07-01 06:43:20','Y'),(3010,3002,113,0,'2019-07-01 06:45:13','Y'),(3010,3003,114,0,'2019-07-01 06:46:25','Y'),(3010,3004,115,0,'2019-07-01 06:47:53','Y');
/*!40000 ALTER TABLE `ad_associations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ad_categories`
--

DROP TABLE IF EXISTS `ad_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ad_categories` (
  `ad_category_id` tinyint(4) unsigned NOT NULL,
  `category` varchar(24) NOT NULL,
  PRIMARY KEY (`ad_category_id`),
  KEY `category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ad_categories`
--

LOCK TABLES `ad_categories` WRITE;
/*!40000 ALTER TABLE `ad_categories` DISABLE KEYS */;
INSERT INTO `ad_categories` VALUES (1,'construction accounting'),(2,'architecture'),(3,'banking'),(4,'day labor'),(5,'debris removal'),(6,'drafting service'),(7,'engineering'),(8,'general contracting'),(9,'information technology'),(10,'insurance'),(11,'interior design'),(12,'jobs'),(13,'construction law'),(14,'other'),(15,'project management'),(17,'punch list'),(18,'resume'),(19,'real estate'),(20,'sitework'),(22,'demolition'),(25,'underground utilities'),(27,'paving'),(30,'concrete'),(40,'masonry'),(50,'steel'),(61,'rough carpentry'),(62,'finish carpentry'),(63,'millwork'),(64,'cabinetry'),(72,'insulation'),(73,'roofing'),(92,'drywall'),(95,'accoustical ceiling'),(96,'floorcovering'),(99,'painting'),(100,'specialties'),(131,'pool'),(140,'elevators'),(154,'plumbing'),(157,'hvac'),(160,'electrical'),(164,'low voltage'),(170,'residential building'),(171,'sanitation'),(177,'heavy equipment'),(178,'tools'),(179,'machinery'),(180,'building materials'),(80,'doors'),(85,'windows'),(156,'refrigeration'),(120,'furnishings'),(103,'fireplaces & stoves'),(65,'lumber'),(67,'ornamental items');
/*!40000 ALTER TABLE `ad_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ads`
--

DROP TABLE IF EXISTS `ads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ads` (
  `ad_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL,
  `ad_category_id` char(20) NOT NULL,
  `price` int(10) unsigned NOT NULL,
  `minbid` int(10) unsigned NOT NULL,
  `description` tinytext NOT NULL,
  `ad_email` varchar(40) NOT NULL,
  `state_id` varchar(30) NOT NULL,
  `city` varchar(30) NOT NULL,
  PRIMARY KEY (`ad_id`),
  KEY `types` (`ad_category_id`),
  KEY `title` (`title`),
  KEY `states` (`state_id`),
  KEY `city` (`city`)
) ENGINE=MyISAM AUTO_INCREMENT=3005 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ads`
--

LOCK TABLES `ads` WRITE;
/*!40000 ALTER TABLE `ads` DISABLE KEYS */;
INSERT INTO `ads` VALUES (1,'Columns, composite (HB&G Permacast)','180',1050,0,'Composite Columns For Sale - HB&G Permacast Columns, 8\" x 8\', color white, plain, with cap and base. Have total of (5) columns. Also have Fiberon railing. Please see add under \"Ornamental Items\".','jbrake@nsconstruct.com','MI','Detroit'),(2,'Doors, interior, exterior','80',900,0,'Assorted interior and exterior doors, bifolds, slabs, prehungs. See attached pdf file for list.','jbrake@nsconstruct.com','MI','Lansing'),(3,'Door frames, steel','80',400,0,'Have (9) 3070 welded steel door frames, various swings, 4-7/8\" throat 2\" header. NEW- purchased from Gamalski Hardware in Auburn Hills. \r\n\r\nHave (1) 3070 welded steel door frame with 12\" sidelight, 4-7/8\" throat 2\" header\r\n\r\n$40.00 EACH\r\n \r\n','jbrake@nsconstruct.com','MI','Ann Arbor'),(6,'Pipe, drainage, HDPE 4\", sock','27',300,0,'HDPE perforated drainage pipe with sock - (3) 250\' Rolls - Meets DOT requirements \r\n','jbrake@nsconstruct.com','MI','Brighton'),(7,'Fasteners, gun nails','180',256,0,'FASTENERS: GUN NAILS            \r\nVarious sizes, gun nails, staples, see attached pdf file for detailed list','jbrake@nsconstruct.com','MI','Brighton'),(8,'Lighting, commercial, lay in 277 v','160',760,0,'Lay in Flourescent Fixtures - (19)each Cooper Lighting 277v 2x4, parabolic, NEW, IN BOX Webberville, MI (Lansing) area\r\n \r\nPrice $40.00 each \r\n','jbrake@nsconstruct.com','MI','Webberville'),(9,'Boards, pressure treated','65',2300,0,'Pressure treated boards, various sizes. See attached pdf for information. Minimum $1000.00 for broken lots.','jbrake@nsconstruct.com','MI','Ann Arbor'),(10,'Mouldings','180',4000,0,'Various mouldings - crown , casing, base, chair etc. See attached pdf.\r\n$1000.00 minimum for smaller lots.','jbrake@nsconstruct.com','MI','Brighton'),(11,'Porch Railing (Fiberon)','67',1950,0,'FIBERON RAILING SYSTEM     \r\n       \r\nDESCRIPTION: COLOR GRAY (9) BOXES  WASHINGTON POST KIT GRAY \r\n(7) BOXES  8\' RAILING KIT GRAY \r\n(11) BOXES 24 PC 32\" BALLISTER GRAY \r\n       \r\n   click on \"More Information\" to get pdf list\r\n','jbrake@nsconstruct.com','MI','Brighton'),(12,'Router Bits, Bosch','178',700,0,'Bosch router bits. Several varieties. New in package. See attached pdf for complete list. Lot price below. Add 20% to each if sold separately.','jbrake@nsconstruct.com','MI','Lansing'),(13,'Boards and siding, cedar','180',1650,0,'CEDAR SIDING 8\"     $700.00 \r\n          \r\n4 X 4 X4 DECORATIVE PORCH NEWEL POSTS SQUARE V GROOVE TOP HAVE (7) $14.00 EACH (TOTAL $98.00)\r\n\r\n2 X 8 X 18 SMOOTH HAVE (8) $120.00 EACH (TOTAL $960.00)\r\n \r\n\r\n\r\n \r\n','jbrake@nsconstruct.com','MI','Webberville'),(14,'Building paper','180',1500,0,'Building paper manufactured by PRIME BUILDING WRAP.\r\n9x100 rolls. Have 30 rolls,  $50.00 each. Minimum purchase 10 rolls.  See specs at: \r\nhttp://csfabric.com/','jbrake@nsconstruct.com','MI','Brighton'),(18,'Reclaimed Lumber','65',3,0,'Antique Reclaimed Wood\r\nCircle Sawn Flooring\r\nHand Hewn Beams\r\nCircle Sawn Timbers\r\nWater Washed Beams c1884\r\nCustom Made Wide Plank Flooring \r\nPine and Cedar Siding\r\nAntique Live Edge Siding','jbrake@nsconstruct.com','MT','Kalispell'),(19,'Reclaimed Oak Plank, circle sawn ','65',4,0,'Reclaimed circle sawn oak plank. see attached \"more information\" for details. Also have timbers and hand hewns. Price below is per board ft.','jbrake@nsconstruct.com','MT','Kalispell'),(20,'Makita Drill 6337D 14 V','178',25,0,'Used but like new makita drill. Drill only, no battery, no charger.','jbrake@nsconstruct.com','MI','Folerville'),(22,'KWC Kitchen Faucet -SOLD-','154',700,0,'Deck-mounted, single-hole, side-lever mixer with high-arc swivel spout and pull-down aerator/spray. Durable, solid, low-lead brass or solid stainless steel construction. Installs with lever on right side only. Paid $1200. New in box.\r\n','jbrake@comcast.net','MI','Williamston'),(23,'hand hewn beams','180',3,0,'these are beams from the 1800s starting @ 3 ','jakebrake2@hotmail.com','MT','kalispell'),(24,'furnace','157',900,0,'95% furnace 90000 btu \r\nslight damage','jimsmither@yahoo.com','MI','Rochester'),(25,'Kohler Toilets','154',350,0,'(2) Used San Raphael™ one-piece elongated toilets- K-3466 , color Sunlight, list price new is $1050.00. Brand new condition. $350.00 for both.','jhbrake@comcast.net','MI','Bloomfield Hills'),(26,'GEO THERMAL 5 TON','157',3400,0,'NEW IN BOX GEOTHERMAL UNIT WITH HOT WATER OPTION AND CUPRO NIKEL HEAT COIL','jimsmither@yahoo.com','MI','ROCHESTER'),(64,'Building paper','180',1000,0,'\"Prime\" building paper (wrap). Have 20 rolls. 9x100, $50.00 each.','jhbrake@nsconstruct.com','TX','Decatur'),(65,'Charming Brand-new renovation 3 Bedroom 2 full Bathroom ','19',245000,0,'For sale 3 Bedroom 2 full Bathrooms\r\n\r\nIn North Miami Beach\r\n\r\n Great location in NE 179 St & 15 Ave\r\n\r\n Charming Brand-new renovation 3 Bedroom 2 full Bathroom Single-Family Home. Brand-new Granite, Appliances and fully equipped with quality Dishes Kitch','giljobs@its202.com','FL','North Miami Beach'),(66,'Rebar Caps ','180',175,0,'Rebar Cap, Rebar #3 - 7, Overall Height 3 1/4 In, Dia 5 In, Orange, Polyethylene Construction, Fits Beam Size 3/8 to 7/8 In \r\n\r\nappox 175 pieces','jhbrake@comcast.net','MI','Lansing'),(67,'Simpson Ties assorted, many','95',100,0,'200-300 various ties, hangers, angles, etc. Various sizes. Sold as lot','jhbrake@comcast.net','MI','Lansing area'),(68,'Rustic Adirondack commercial seating','120',0,0,'Rustic adirondack chairs made from reclaimed wood. Several styles. Built for commercial use yet stylish enough for the residence. see website at\r\nhttp://www.adirondakchairs.net\r\n\r\n','eorder@adirondakchairs.net','MI','USA'),(74,'building paper','180',1000,0,'prime building wrap. 9x100. $50.00 per roll, 20 rolls.','jhbrake@comcast.net','FL','Orlando'),(76,'Shower Door, new Kohler','180',700,0,'kohler portrait bypass shower door, k-702101-L-NX, brushed nickel. new in box. purchased 4.30.09 and not needed. info & spec sheet here:  http://www.us.kohler.com/onlinecatalog/detail.jsp?item=11116802§ion=2&category=12&subcategory=129','jhbrake@comcast.net','MI','Bloomfield Hills'),(77,'Shower Door, kohler, new','180',700,0,'kohler portrait bypass shower door, k-702101-L-NX, brushed nickel. new in box. purchased 4.30.09 and not needed. kohler web info here: http://www.us.kohler.com/onlinecatalog/detail.jsp?item=11116802§ion=2&category=12&subcategory=129 fits up to 59-5/8\" ','jhbrake@comcast.net','MI','Bloomfield Hills'),(78,'Adirondack Chairs','120',475,0,'Custom ADK chairs from reclaimed lumber','jhbrake@comcast.net','MI','Fowlerville'),(2995,'1958 Ford F100 Pickup','14',3750,0,'Montana vehicle, NO RUST! ','jack.b@mycbay.com','MI','Detroit'),(2996,'Portable Water Chiller CW 5000 for CO2 Laser','179',400,0,'Authentic S&A manufacturer\r\nBuy CW-5000 water chillers directly from S&A\r\nCompetitive price, Fast Delivery.\r\nGet a Quotes Now!\r\nhttps://www.teyuchiller.com/water-chillers-cw-5000-cooling-capacity-800w_p7.html\r\n\r\nPortable water chiller CW-5000 is widely ap','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(2997,'Industrial Air Cooled Chiller CW 5200 ','179',500,0,'Authentic S&A Water Chiller, Annual Sales Volume 60,000 Units\r\nBuy Chillers at Factory Price, Get Live Quotes Now!\r\nFast Delivery, 2 Years Warranty, ISO, CE,RoSH,REACH approval\r\nhttps://www.teyuchiller.com/recirculating-compressor-water-chillers-cw-5200_p','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(2998,'Portable Water Chiller Unit for UV Laser Marking Machine ','179',660,0,'Wholesale Refrigeration Water Chiller, stable refrigeration performance\r\nBuy Chillers at Factory Price\r\nGet Live Quotes Now!\r\nhttps://www.teyuchiller.com/3w-5w-uv-laser-water-chillers-with-rack-mount-design_p43.html\r\n\r\nPortable water chiller unit RM 300 i','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(2999,'Closed Loop Water Chiller Unit for 1000W Fiber Laser Cutting','179',1600,0,'16 Years Experience\r\nFast Delivery, 2 Years Warranty\r\nBuy Chillers at Factory Price, Get Live Quotes Now!\r\nhttps://www.teyuchiller.com/laser-cooling-systems-cwfl-1000-with-dual-digital-temperature-controller_p15.html \r\n\r\nClosed loop water chiller unit CWF','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(3000,'Laser water cooled system for 1500W Fiber Laser Machine','179',1700,0,'16 Years Experience\r\nS&A Water Chiller manufacturer\r\nBuy Chillers at Factory Price \r\nGet Live Quotes Now!\r\nhttps://www.teyuchiller.com/water-chiller-units-cwfl-1500-with-environmental-refrigerant-for-fiber-lasers_p16.html \r\n\r\nLaser cooling machine CWFL-15','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(3001,'Portable Industrial Water Chiller CW 3000 for CNC Spindle','95',300,0,'Authentic water chiller CW3000\r\nS&A manufacturer\r\nBuy CW 3000 Chillers directly from S&A, Competitive price,Fast Delivery,2 Years Warranty \r\nGet a Quotes Now!\r\nhttps://www.teyuchiller.com/air-cooled-water-chillers-cw-3000-9l-water-tank-110v-200v-50hz-60hz','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(3002,'Industrial Air Cooled Chiller CW5000 for Sealed CO2 Laser Tu','179',400,0,'cw5000 chiller Manufacturer\r\nBuy from S&A manufacturer\r\nDistributor in US\r\nFast Delivery, 2 Years Warranty, Get a Quotes Now!\r\nhttps://www.teyuchiller.com/water-chillers-cw-5000-cooling-capacity-800w_p7.html\r\n\r\nIndustrial air cooled chiller CW-5000 is ver','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(3003,'Compact Water Chiller CW5200 for 130W DC Co2 Laser','179',500,0,'Refrigeration Water Chiller\r\nS&A manufacturer\r\n16 Years Experience\r\nRecirculating chillers with Cooling capacity Ranging From 0.6-30kW\r\nhttps://www.teyuchiller.com/recirculating-compressor-water-chillers-cw-5200_p8.html  \r\n\r\nCompact water chiller CW-5200 ','teyuchillers@teyu.com.cn','AL','Guangzhou,China'),(3004,'Refrigeration Air Cooled Chiller for UV Laser Marking Machin','179',500,0,'Water Chiller Manufacturer\r\n16 Years Experience\r\nWholesale water chiller, stable refrigeration performance ,ISO, CE,RoSH,REACH approval\r\nhttps://www.teyuchiller.com/high-precision-uv-laser-water-chillers-cwul-05-with-long-life-cycle_p18.html \r\n\r\nRefrigera','teyuchillers@teyu.com.cn','AL','Guangzhou,China');
/*!40000 ALTER TABLE `ads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `c_ads`
--

DROP TABLE IF EXISTS `c_ads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `c_ads` (
  `c_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(77) NOT NULL,
  `category` varchar(33) NOT NULL,
  `services` varchar(255) NOT NULL,
  `c_mail` varchar(33) NOT NULL,
  `city` varchar(21) NOT NULL,
  `state_id` varchar(15) NOT NULL,
  `zip` int(10) NOT NULL,
  `verified` varchar(2) DEFAULT NULL,
  `contact` varchar(33) NOT NULL,
  `date_entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`c_id`),
  KEY `c_cat` (`category`),
  KEY `state_code` (`state_id`),
  KEY `company_name` (`company_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2905 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `c_ads`
--

LOCK TABLES `c_ads` WRITE;
/*!40000 ALTER TABLE `c_ads` DISABLE KEYS */;
INSERT INTO `c_ads` VALUES (3,'Nisbet-NorthStar, Inc.','General Contracting','Church and school construction. Industrial, build-outs and clean room construction. Many references. Since 1984.','jhbrake@nsconstruct.com','Fowlerville','MI',48836,NULL,'Jack Brake','2009-08-07 21:07:25'),(4,'DYNAMIC HEATING & COOLING','HVAC','Since 1985 Dynamic Heating and Cooling designs and installs air conditioning and heating systems for both residential and commercial customers in southeastern michigan including Oakland and Macomb county. We have a proven track record. ','jimsmither@yahoo.com','Rochester Hills','MI',48309,NULL,'James Smither','2009-08-08 21:55:45'),(7,'Adirondak Jak, Inc.','Furnishings','Custom commercial and residential furnishings from reclaimed wood. Specializing in porch and deck seating. Rustic outdoor seating.  See web at:\r\nwww.adirondakchairs.net','eorder@adirondakchairs,net','Fowlerville','MI',48836,NULL,'Jack Brake','2009-08-09 23:30:51');
/*!40000 ALTER TABLE `c_ads` 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` (
  `state_id` varchar(4) NOT NULL,
  `state_name` varchar(30) NOT NULL,
  PRIMARY KEY (`state_id`),
  KEY `state_name` (`state_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!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 ('AK','Alaska'),('AL','Alabama'),('AR','Arkansas'),('AZ','Arizona'),('CA','California'),('CO','Colorado'),('CT','Connecticut'),('DC','District of Columbia'),('DE','Delaware'),('FL','Florida'),('GA','Georgia'),('HA','Hawaii'),('IA','Iowa'),('ID','Idaho'),('IL','Illinois'),('IN','Indiana'),('KS','Kansas'),('KY','Kentucky'),('LA','Louisiana'),('MA','Massachusetts'),('MD','Maryland'),('ME','Maine'),('MI','Michigan'),('MN','Minnesota'),('MO','Missouri'),('MS','Mississippi'),('MT','Montana'),('NC','North Carolina'),('ND','North Dakota'),('NE','Nebraska'),('NH','New Hampshire'),('NJ','New Jersey'),('NM','New Mexico'),('NV','Nevada'),('NY','New York'),('OH','Ohio'),('OK','Oklahoma'),('OR','Oregon'),('PA','Pennsylvania'),('RI','Rhode Island'),('SC','South Carolina'),('SD','South Dakota'),('TN','Tennessee'),('UT','Utah'),('VA','Virginia'),('VT','Vermont'),('WA','Washington'),('WI','Wisconsin'),('WV','West Virginia'),('WY','Wyoming'),('TX','Texas');
/*!40000 ALTER TABLE `states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trade_associations`
--

DROP TABLE IF EXISTS `trade_associations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trade_associations` (
  `user_id` int(10) unsigned NOT NULL,
  `c_id` int(10) unsigned NOT NULL,
  `upload_id` int(10) unsigned NOT NULL,
  `dx_id` int(10) unsigned NOT NULL,
  `date_submitted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `approved` char(1) NOT NULL DEFAULT 'N',
  KEY `user_id` (`user_id`),
  KEY `upload_id` (`upload_id`),
  KEY `date_submitted` (`date_submitted`),
  KEY `dx_upload_id` (`dx_id`),
  KEY `c_id` (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trade_associations`
--

LOCK TABLES `trade_associations` WRITE;
/*!40000 ALTER TABLE `trade_associations` DISABLE KEYS */;
INSERT INTO `trade_associations` VALUES (22,3,27,0,'2009-08-09 00:15:35','Y'),(21,4,29,0,'2009-08-09 00:15:35','Y'),(21,7,64,0,'2009-08-09 23:30:51','Y');
/*!40000 ALTER TABLE `trade_associations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `uploads`
--

DROP TABLE IF EXISTS `uploads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uploads` (
  `upload_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file_name` varchar(40) NOT NULL,
  `file_size` int(6) unsigned NOT NULL,
  `file_type` varchar(30) NOT NULL,
  `date_entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`upload_id`),
  KEY `date_entered` (`date_entered`),
  KEY `file_name` (`file_name`)
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `uploads`
--

LOCK TABLES `uploads` WRITE;
/*!40000 ALTER TABLE `uploads` DISABLE KEYS */;
INSERT INTO `uploads` VALUES (3,'hbg_columns.jpg',19250,'image/pjpeg','2009-03-10 08:51:45'),(4,'milliken_logo.gif',4508,'image/gif','2009-03-10 09:02:27'),(7,'corr_pipe.bmp',36666,'image/bmp','2009-03-12 07:45:15'),(8,'cooper_lightingLogo.jpg',4674,'image/pjpeg','2009-03-12 08:01:09'),(9,'fiberon.jpg',170992,'image/pjpeg','2009-03-12 23:49:35'),(10,'bosch_router_bits.jpg',9059,'image/pjpeg','2009-03-13 06:27:01'),(11,'prime_wrap.jpg',97142,'image/pjpeg','2009-03-14 03:10:59'),(15,'goin_west.jpg',14356,'image/pjpeg','2009-03-14 11:22:07'),(16,'5166531140056ca4.jpg',3401,'image/pjpeg','2009-06-04 21:26:31'),(18,'kwc_faucet.jpg',3758,'image/pjpeg','2009-08-04 07:55:05'),(19,'kohler_toilet.jpg',4982,'image/pjpeg','2009-08-07 05:58:54'),(27,'jackB.jpg',1369,'image/pjpeg','2009-08-07 21:07:25'),(29,'bryant.gif',2584,'image/gif','2009-08-08 21:55:45'),(63,'prime_wrap.png',495218,'','2009-08-09 23:11:17'),(64,'jackb.jpg',1369,'image/pjpeg','2009-08-09 23:30:51'),(65,'pict0024.jpg',83428,'image/jpeg','2009-08-10 01:15:31'),(66,'rerod_cap.jpg',3981,'image/jpeg','2009-08-10 18:03:10'),(67,'simpson.gif',2305,'image/gif','2009-08-10 18:11:37'),(68,'adirondac.jpg',43091,'image/jpeg','2009-08-10 18:30:11'),(73,'prime_wrap.jpg',97142,'image/pjpeg','2009-08-12 04:18:43'),(76,'kohler_shrdr.jpg',11312,'image/jpeg','2009-09-17 20:56:42'),(77,'kohler_shrdr.jpg',11312,'image/jpeg','2009-09-17 21:11:31'),(78,'classic300.jpg',9966,'image/jpeg','2011-09-24 19:53:18'),(79,'yellow brick rd.jpg',81147,'image/jpeg','2012-05-14 12:09:25'),(80,'img_2119 (640x473).jpg',263965,'image/jpeg','2015-10-01 18:16:58'),(81,'cw-5000-2017.jpg',62915,'image/jpeg','2017-08-16 07:23:40'),(82,'cw-5200-2017.jpg',60281,'image/jpeg','2017-08-16 07:24:18'),(83,'cw-6000-2017.jpg',86740,'image/jpeg','2017-08-16 07:24:41'),(84,'cw-6100－2017.jpg',87709,'image/jpeg','2017-08-16 07:25:03'),(85,'cw6200an250s01-2017.jpg',72496,'image/jpeg','2017-08-16 07:26:37'),(86,'cw-5000-2017.jpg',62915,'image/jpeg','2017-09-06 03:53:35'),(87,'cw-6000-2017.jpg',86740,'image/jpeg','2017-09-06 03:54:10'),(88,'cw-6100－2017.jpg',87709,'image/jpeg','2017-09-06 03:54:42'),(89,'cw-6200－2017.jpg',88030,'image/jpeg','2017-09-06 03:55:05'),(90,'cw-6300-2017.jpg',91078,'image/jpeg','2017-09-06 03:55:39'),(91,'cw-5000-2017.jpg',88658,'image/jpeg','2017-11-10 06:56:42'),(92,'cw-6000-2017.jpg',86740,'image/jpeg','2017-11-10 06:57:09'),(93,'cw-6100－2017.jpg',87709,'image/jpeg','2017-11-10 06:57:37'),(94,'cw-6200－2017.jpg',88030,'image/jpeg','2017-11-10 06:58:02'),(95,'cw-6300-2017.jpg',91078,'image/jpeg','2017-11-10 06:58:35'),(96,'cw-3000-2017.jpg',88561,'image/jpeg','2018-01-15 08:18:26'),(97,'cw-5000-2017.jpg',88658,'image/jpeg','2018-01-15 08:19:02'),(98,'cw-5200-2017.jpg',85208,'image/jpeg','2018-01-15 08:19:34'),(99,'cwul-10-en.jpg',73076,'image/jpeg','2018-01-15 08:19:59'),(100,'cw-6000-2017.jpg',86740,'image/jpeg','2018-01-15 08:20:27'),(101,'cw-5000-2017.jpg',88658,'image/jpeg','2018-04-07 06:06:18'),(102,'cw-5200-2017.jpg',85208,'image/jpeg','2018-04-07 06:08:15'),(103,'cw-6000-2017.jpg',86740,'image/jpeg','2018-04-07 06:08:39'),(104,'cwfl-800-en.jpg',62646,'image/jpeg','2018-04-07 06:09:05'),(105,'cwfl-1000-en.jpg',63489,'image/jpeg','2018-04-07 06:09:36'),(106,'cwfl-1500-en.jpg',66892,'image/jpeg','2018-04-07 06:10:19'),(107,'cw-5000co2 chiller.jpg',99358,'image/jpeg','2018-12-27 08:18:19'),(108,'cw5200chiller.jpg',82229,'image/jpeg','2018-12-27 08:19:34'),(109,'rack chiller.jpg',94704,'image/jpeg','2018-12-27 08:20:30'),(110,'cwfl-1000.jpg',96949,'image/jpeg','2018-12-27 08:21:27'),(111,'cwfl-1500.jpg',96557,'image/jpeg','2018-12-27 08:22:03'),(112,'cw-3000.jpg',109627,'image/jpeg','2019-07-01 06:43:19'),(113,'cw-5000co2 chiller.jpg',99358,'image/jpeg','2019-07-01 06:45:13'),(114,'cw5200chiller.jpg',82229,'image/jpeg','2019-07-01 06:46:25'),(115,'cwul-05.jpg',125284,'image/jpeg','2019-07-01 06:47:53'),(116,'cwfl-2000.jpg',94226,'image/jpeg','2019-07-01 06:49:13');
/*!40000 ALTER TABLE `uploads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(40) NOT NULL,
  `eKey` varchar(64) NOT NULL,
  `pass` char(40) NOT NULL,
  `first_name` varchar(15) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `active` char(32) DEFAULT NULL,
  `registration_date` datetime NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `eKey` (`eKey`),
  KEY `pass` (`pass`)
) ENGINE=MyISAM AUTO_INCREMENT=3197 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (21,'jhbrake@comcast.net','21xc646354dskjghfklh35465464','8cb2237d0679ca88db6464eac60da96345513964','Jack','Brake',NULL,'2009-02-07 21:16:33'),(22,'jhbrake@nsconstruct.com','e1dbabd28cff4ba0f9052fe414e0a99f','1f4153ccf37011c73804ca4b1a8739b2e79226d6','Jack','Brake',NULL,'2009-02-08 10:00:05'),(24,'nsconstruct@comcast.net','8ab736b50610efb026c8acc0ea67c689','83787f060a59493aefdcd4b2369990e7303e186e','Jack','Brake',NULL,'2009-02-08 20:51:23'),(33,'eorder@adirondakchairs.net','a0323793e761e781d8f5d2c088172c12','8913dbc65c2fd0c0798c7a94dc0faa94e1955ed7','Adirondak','Jak',NULL,'2009-08-03 18:55:24'),(26,'info@mycbay.com','62b9b773ca2117a82f480b4f5242d36c','e67ab40570dcefa307da43af7c0ec634685df3f1','Joe','Usertest','NULL','2009-03-22 17:37:03'),(27,'jack@mycbay.com','8aba44e827413ad6e759b249cd0e2f14','dfcd82197467e1b56faf5f53c88b0b0cd4c8b302','Joe','Usertest','daf9b8d831b1b71454134c96224ce890','2009-03-22 17:42:56'),(28,'wsauvola@aol.com','579eb45af4c80dad9e3722e2678d49e0','fd54855c0f15e5366e797628850e1faf0148e310','Wayne','Sauvola',NULL,'2009-05-07 18:00:13'),(34,'jakebrake2@hotmail.com','39ee259df5d7a4ab1b326e97bedf2a52','b230d8449306ce028208e2f171e0b8df11996829','john','brake jr.',NULL,'2009-08-04 08:44:38'),(41,'jbrake@nsconstruct.com','ec5c79b3034a28ee80a5dd2f271053d9','7110eda4d09e062aa5e4a390b0a572ac0d2c0220','Jack','Brake','ce7ad3138f8b70e5c7f25e1e13ddd859','2010-03-05 13:39:45'),(42,'adirondak@mycbay.com','83c6526803ab5e8c433e22096b518bcd','7110eda4d09e062aa5e4a390b0a572ac0d2c0220','Jack','Brake',NULL,'2010-03-05 23:13:51');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'jhbrake1_myjak3'
--

--
-- Dumping routines for database 'jhbrake1_myjak3'
--
/*!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 2026-05-10 13:56:56