--
-- Host: localhost    Database: gpcvalves
-- ------------------------------------------------------


--
-- Table structure for table `Category`
--

CREATE TABLE `Category` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `protected` int(11) NOT NULL DEFAULT '0',
  `display` int(11) NOT NULL DEFAULT '0',
  `next` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `description` blob,
  `short_description` blob,
  `name` varchar(50) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Category`
--

INSERT INTO `Category` VALUES (1,0,0,0,23,NULL,NULL,'Top Level',NULL,0),(34,0,1,35,0,'Idally check valves are used to maintain unidirectional flow.  In practice, because of size and weight restrictions, a check valve may produce some back pressure (pressure drop) under flow conditions and allow some backflow (leakage).  The specific requirement usually dictates how much the valve may depart from ideal performance.  The main criteria used in specifying a check valve are: fluid, operating pressure, operating flow and allowable pressure drop, back leakage.  See a few representative valves in this category then contact the factory for your custom check valve requirement.  ',NULL,'Check Valves','GRP_CHK_VLV.JPG',0),(33,0,1,34,0,'These devices provide relief operation for situations of over-pressure or over-temperature.  These devices can be tailored for your specifications.',NULL,'Rupture/Thermal Relief Disks','GRP_RUPTHERM.JPG',0),(38,0,1,0,0,'General Pneumatics Corp. has a vast amount of experience with almost every conceivable configuration.  The downloadable write-up explains our technology and shows some examples of what we\'ve done.',NULL,'Joule-Thompson Cryostat','Front_J-T.jpg',0),(35,0,1,42,0,'A variety of relief valves are available with differing cracking pressure and pressure drop.  Consult factory for a valve tailored to your specification.',NULL,'Relief Valves','GRP_RELIEF_VLV.JPG',0),(42,0,1,43,0,'Mechanical cable provides the means of rotating ball valve. A variety of styles and sizes are available. Some units include integral pressure regulation. Typical applications include rapid inflation of life rafts and emergency slide evacuation systems for military and commercial aircraft.   ',NULL,'Cable Actuated Ball Valve','GRP_BALL_VLV_MED.JPG',0),(29,0,1,28,0,'Aspirators, or sometimes called ejectors, create a flow multiplier effect using a primary compressed gas source.  The high-flow, low-delta P conditions are well suited for inflation applications.',NULL,'Aspirators','GRP_ASPIRATORS.JPG',0),(30,0,1,29,41,'<br>A wide variety of actuated valves are available including direct acting solenoid valves utilizing either AC or DC power and motor actuated versions.',NULL,'<br><b><c>Actuated Valves</b></c>','GRP_ACT_VLV.JPG',0),(31,0,1,33,0,'These charge/Filler valves are suitable for use with standard hoses and fittings employed in charging high pressure gas storage vessels for military and industrial applications.  They are also used in conjunction with General Pneumatics 500 Series inflation valves.',NULL,'Charge/Filler Valves','GRP_FILL_VALVES_MED.JPG',0),(28,0,1,31,0,'General Pneumatics has custom-designed and built a variety of regulators and can design one for your specification.  Many of our Cable Operated Ball Valves also incorporate GP regulators. ',NULL,'Pressure Regulators','GRP_Regulators.jpg',0),(24,0,1,25,30,'General Pneumatics Corp. has long been known as a specialist in solving tough pneumatic engineering problems.  These displayed items are only a partial selection of pneumatic devices we are capable of producing for you.  ',NULL,'Pneumatic','GRP_ACT_VLV.JPG',0),(25,0,1,26,46,'Besides pneumatic components, let us put our enginering talent towards solving your specialty hydraulic component need.',NULL,'Hydraulic','862RHS20.JPG',0),(26,0,1,0,38,'The General Pneumatic\'s anti-clogging, flow-regulating J-T cryostat design allows for several hours of continuous operation with gas contamination levels that would clog conventional cryostats within six minutes. ',NULL,'Cryogenic','Front_J-T.jpg',0),(23,0,1,0,24,'Under Construction',NULL,'Products','',0),(43,0,1,0,0,'Various styles of inflation valves.  See also Cable Operated Ball Valves.',NULL,'Inflation Valves','536GPS.JPG',0),(46,0,1,0,0,'Used in tactical missile pneumatic and hydraulic systems to maintain unidirectional fluid flow and to limit the maximum system operating pressure',NULL,'Hydraulic Valve','862RHS20.JPG',0),(40,0,5,0,0,'',NULL,'Solenoid Valves','SOLENOID_VLV.jpg',0),(41,0,5,40,0,'',NULL,'Motor Actuated Valves','GRP_MOTOR_VLV.jpg',0);

--
-- Table structure for table `Inventory`
--

CREATE TABLE `Inventory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `categoryID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `categoryID` (`categoryID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=168 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Inventory`
--

INSERT INTO `Inventory` VALUES (4,1,5),(5,2,10),(3,3,11),(10,4,2),(7,5,2),(8,6,2),(9,7,2),(124,8,38),(143,9,28),(144,10,28),(145,12,28),(129,13,40),(130,14,40),(131,15,40),(132,16,40),(127,24,41),(133,18,40),(134,19,40),(83,20,40),(135,21,40),(136,22,40),(137,23,40),(128,25,41),(87,26,40),(157,27,42),(158,28,42),(159,29,42),(160,30,42),(162,32,42),(163,34,42),(164,35,42),(142,36,29),(138,37,29),(140,38,29),(141,40,29),(102,41,29),(146,42,33),(147,44,33),(148,45,33),(149,46,35),(150,47,35),(151,48,35),(152,49,35),(153,50,35),(154,51,35),(112,52,35),(155,53,35),(156,54,35),(166,55,43),(165,56,41),(120,57,43),(121,58,43),(122,59,43),(167,60,46);

--
-- Table structure for table `Invoice`
--

CREATE TABLE `Invoice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `purchasedby` int(11) NOT NULL DEFAULT '0',
  `deliverto` int(11) NOT NULL DEFAULT '0',
  `processed` int(11) NOT NULL DEFAULT '0',
  `shiptype` varchar(50) DEFAULT NULL,
  `shipcost` double(8,2) NOT NULL DEFAULT '0.00',
  `comment` blob,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Invoice`
--

INSERT INTO `Invoice` VALUES (1,'2002-06-07 13:16:03',1,1,1,'',0.00,'',NULL,NULL);

--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `body` blob,
  `template` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `featured` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `linkname` varchar(50) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` VALUES (1,'<HR SIZE = 6 COLOR = \"#6592A7\">\r\n<CENTER><H2><I>DECADES OF EXCELLENCE</I></H2></CENTER>\r\n<B>Providing Advanced Fluid Control Components and Systems for...<P></B>\r\n<ul>\r\n<li>Military & Civil Aircraft\r\n<li>Missile & Space Systems  \r\n<li>Nuclear\r\n<li>Medical and Industrial Applications\r\n</ul>',1,0,'Home_Page_Pic.jpg','','','',NULL,NULL),(22,'',4,1,'',NULL,NULL,'PMA Items','PMA Items',NULL),(2,'<table width=\"100%\" cellpadding=\"10\">\r\n  <tr> \r\n    <td colspan=2><center>\r\n        <img src=\"Images/ek_2.jpg\" width=\"288\" height=\"192\"> <img src=\"Images/ek_5.jpg\" width=\"288\" height=\"192\">\r\n      </center></td>\r\n  </tr>\r\n  <tr> \r\n    <td width=\"50%\"valign=top><H2><I><font color=\"#6592A7\">The General Pneumatics\' \r\n        Commitment</font></I></H2></font>\r\n      <font size=2>We\'re committed to the manufacture of critical, high quality \r\n      parts and systems. You can be certain that our exacting standards of quality \r\n      will provide the finest finished product. And because we understand the \r\n      financial aspects of business as well, we know how to keep the costs in \r\n      line. Our years of experience will be evident in the cost effectiveness \r\n      of our products. \r\n      <p>We offer a team apprach to product development. A team which works together \r\n        as one cohesive force to assure quality of design, manufacture, assembly, \r\n        testing and inspection. This combined talent ensures effective solutions \r\n        to whatever unique requirements you may have.</font> </td>\r\n    <td valign=top><H2><I><font color=\"#6592A7\">Engineering Expertise...A Century \r\n        of Knowledge</font></I></H2><font size=2>\r\n      Our engineering department represents more than a century of knowledge and \r\n      experience. Creative and innovative approaches to design have enabled General \r\n      Pneumatics to become one of the free world\'s leading producers of pneumatics \r\n      control valves and pressure regulators for the evacuation slides and rafts \r\n      on commercial aircraft. </font>\r\n      <P><font size=2>When you submit a specification or drawing to General Pneumatics, our \r\n        engineering department combines its talents to achieve the best possible \r\n        product. From the choice of materials to the performance of detailed computer \r\n        analyses each step is carefully studied in order to select the elements \r\n        best suited for your requirement.</font> </td>\r\n  </tr>\r\n</table>\r\n<table width=\"100%\" cellpadding=\"10\">\r\n  <tr>\r\n     <td colspan=\"2\" align=\"center\"><Font size=\"2\">Clean Room Class 7</font></td>\r\n  </tr>\r\n  <tr> \r\n    <td><img src=\"Images/ek_12.jpg\" width=\"288\" height=\"192\"></td>\r\n    <td><img src=\"Images/cleanroom2.jpg\" width=\"288\" height=\"216\"></td>\r\n  </tr>\r\n  <tr> \r\n    <td><img src=\"Images/cleanroom3.jpg\" width=\"288\" height=\"231\"></td>\r\n    <td><img src=\"Images/cleanroom1.jpg\" width=\"288\" height=\"216\"></td>\r\n  </tr>\r\n  <tr> \r\n    <td colspan=\"2\"><div align=\"center\"><img src=\"Images/testingroom.jpg\" width=\"288\" height=\"216\"></div></td>\r\n  </tr>\r\n</table>',4,1,'',NULL,NULL,'About our Company....','Company Info',NULL),(3,'<font size=2>The General Pneumatics Corporation, is a woman-Owned Business Enterprise (WBE) founded in 1959.  It has established \r\nworld-wide recognition for the custom design and manufacture of high reliability \r\npneumatic and hydraulic valves, pressure regulators, aspirators, and accumulators \r\nfor aerospace applications, and is the leading producer of inflation controls \r\nfor the emergency raft and evacuation slide systems on commercial and military \r\naircraft. The company also supplies hydraulic and pneumatics components for missiles \r\nsuch as the Sidewinder, Chaparral, Hawk, Patriot, phoenix, Stinger, Tomahawk, \r\nand Sparrow. The company headquarters is located in Orange, New Jersey in a 20,000 \r\nsq. ft. engineering and production manufacturing facility.</font> \r\n<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"10\" cellspacing=\"10\">\r\n  <tr> \r\n    <td><img src=\"Images/building-NJ.jpg\" width=\"288\" height=\"185\"></td>\r\n    <td><img src=\"Images/inventory_room.jpg\" width=\"288\" height=\"216\"></td>\r\n  </tr>\r\n  <tr> \r\n    <td><img src=\"Images/machine7.jpg\" width=\"288\" height=\"216\"></td>\r\n    <td><img src=\"Images/machine8.jpg\" width=\"288\" height=\"216\"></td>\r\n  </tr>\r\n  <tr> \r\n    <td><img src=\"Images/machine11.jpg\" width=\"288\" height=\"216\"></td>\r\n    <td><img src=\"Images/machine1.jpg\" width=\"288\" height=\"216\"></td>\r\n  </tr>\r\n  <tr> \r\n    <td><img src=\"Images/machine9.jpg\" width=\"288\" height=\"216\"></td>\r\n    <td><img src=\"Images/machine10.jpg\" width=\"288\" height=\"216\"></td>\r\n  </tr>\r\n</table>\r\n<p> </p>',4,1,'',NULL,NULL,'Company Information','Background & Facilities',NULL),(21,'<ul>\r\n  <li> Actuated Valves</li>\r\n  <li>Aspirator</li>\r\n  <li>Cable Actuated Ball Valves\r\n    <ul>\r\n      <li><a href=\"downloads/504%20Ball%20valve.pdf\" target=\"_blank\">504 Ball \r\n        valve</a></li>\r\n      <li><a href=\"downloads/510%20GPS%20Brochure.pdf\" target=\"_blank\">510 GPS \r\n        Brochure</a></li>\r\n      <li><a href=\"downloads/515GPS%20SERIES%20Brochure.pdf\" target=\"_blank\">515GPS \r\n        SERIES Brochure</a></li>\r\n      <li><a href=\"downloads/520GPS%20SERIES%20Brochure.pdf\" target=\"_blank\">520GPS \r\n        SERIES Brochure</a></li>\r\n      <li><a href=\"downloads/524GPS%20SERIES%20Brochure.pdf\" target=\"_blank\">524GPS \r\n        SERIES Brochure</a></li>\r\n      <li><a href=\"downloads/525GPS%20SERIES%20Brochure.pdf\" target=\"_blank\">525GPS \r\n        SERIES Brochure</a></li>\r\n    </ul>\r\n  </li>\r\n  <li>Charge/Filler Valves</li>\r\n  <li>Check Valves</li>\r\n  <li>Cryogenics</li>\r\n        <ul>\r\n            <li><a Href=\"http://www.gpcvalves.com/downloads/jt.pdf\" target=\"_blank\">J-T Cryostat</a></li>\r\n        </ul>\r\n  <li> Inflation Valves</li>\r\n  <li>Hydraulic</li>\r\n  <li>Pressure Regulators</li>\r\n  <li>Relief Valves</li>\r\n  <li>Rupture/Thermal Relief DisksMiscellaneous \r\n    <ul>\r\n      <li><a href=\"downloads/100%20Series%20Quick%20Disconnect.pdf\" target=\"_blank\">100 \r\n        Series Quick Disconnect</a><br>\r\n      </li>\r\n    </ul>\r\n  <li>Misc.\r\n    </li>\r\n  </li>\r\n</ul>',4,1,'',NULL,NULL,'Tech Specs','Tech Specs',NULL),(23,'',4,1,'',NULL,NULL,'Links','Links',NULL),(24,'',4,1,'',NULL,NULL,'Site Map','Site Map',NULL),(11,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(12,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(13,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(14,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(15,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(16,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(17,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(18,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(19,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(20,NULL,0,2,NULL,NULL,NULL,NULL,'','');

--
-- Table structure for table `Product`
--

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `short_description` blob,
  `linkname` varchar(50) DEFAULT NULL,
  `link` blob,
  `alloworder` smallint(6) DEFAULT NULL,
  `instock` smallint(6) DEFAULT NULL,
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `list1` longblob,
  `list2` longblob,
  `image` varchar(255) DEFAULT NULL,
  `prices` longblob,
  `weight` double(8,4) NOT NULL DEFAULT '0.0000',
  `display` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `long_description` blob,
  `shipcost` float(10,2) NOT NULL DEFAULT '0.00',
  `number` smallint(6) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  `inactive` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Product`
--

INSERT INTO `Product` VALUES (1,'Gas relief valve','P/N 523XYZ','Gas relief valve for air or inert gases.',NULL,NULL,0,1,'','',0.00,'','','Relief_Valves.gif','',0.0000,1,1,'Medium:  Air, Nitrogen, Helium\r\nPressure Rating: 8000 psi.\r\nCrackin pressure: 2000 psi.',0.00,1,NULL,NULL),(4,'Aspirators','0','',NULL,NULL,0,0,'','',0.00,'','','Aspirator.jpg','',0.0000,1,1,'',0.00,4,NULL,NULL),(2,'Pressure Regulators','0','',NULL,NULL,1,1,'','',0.00,'','','Regulators1.jpg','',0.0000,1,1,'',0.00,2,NULL,NULL),(3,'Model 173 Argon, Nitrogen J-T Cryostat','173DA0001','',NULL,NULL,1,1,'','',0.00,'','','173J-T.jpg','',0.0000,1,1,'',0.00,3,NULL,NULL),(5,'Regulators','0','',NULL,NULL,0,0,'','',0.00,'','','Regulators1.jpg','',0.0000,1,1,'',0.00,5,NULL,NULL),(6,'Relief Valves','0','',NULL,NULL,1,0,'','',0.00,'','','Relief_Valves.jpg','',0.0000,1,1,'',0.00,6,NULL,NULL),(7,'Solenoid Valves','0','',NULL,NULL,1,0,'','',0.00,'','','','',0.0000,1,1,'',0.00,7,NULL,NULL),(8,'Joule-Thompson Cryostat','0','<div class=Section1><p class=MsoNormal><span style=\'font-size:10.0pt;mso-bidi-font-size:12.0pt;\r\nfont-family:Arial\'>General Pnematics Corp. had built and tested nearly every conceivable J-T Cryostat configuration for noble and mixed gas blends. Click <b><u> <a\r\nhref=\"http://www.gpcvalves.com/downloads/jt.pdf\" target=\"_blank\">download\r\nfile </b></u> </a> for J-T Cryostat Write-up.</p></div>',NULL,NULL,0,0,'','',0.00,'','','Front_J-T.jpg','',0.0000,1,1,'<p class=MsoNormal><span style=\'font-size:10.0pt;mso-bidi-font-size:12.0pt;\r\nfont-family:Arial\'>Click <b><u> <a\r\nhref=\"http://www.gpcvalves.com/downloads/jt.pdf\" target=\"_blank\">download\r\nfile </b></u> </a> for J-T Cryostat Write-up that has more information.</p>',0.00,8,NULL,NULL),(9,'P/N: 824PAS06-2, Helium Regulator','824PAS06-2','High pressure helium regulator.',NULL,NULL,0,0,'','',0.00,'','','824PAS06-2.JPG','',0.0000,1,1,'',0.00,9,NULL,NULL),(10,'P/N: 888PAX06, Gas Pressure Regulator','888PAX06','1500-3500 PSIG operating pressure, air, nitrogen, carbon dioxide, etc.',NULL,NULL,0,0,'','',0.00,'','','888PAX06.JPG','',0.0000,1,1,'',0.00,10,NULL,NULL),(11,'Adjustable Pressure Regulator, Gas','923PAD04','Operating Pressure 250 to 3500 PSIG, Air or inert gases, Manual control.',NULL,NULL,0,1,'','',0.00,'','','923PAD04_HI_RES.JPG','',0.0000,1,1,'',0.00,11,NULL,NULL),(12,'P/N: 923PAD04, Adjustable Pressure Regulator','923PAD04','Manually Adjustable, Operating Pressure 250-3500 PSIG, Air or inert gases.',NULL,NULL,0,0,'','',0.00,'','','923PAD04.JPG','',0.0000,1,1,'',0.00,12,NULL,NULL),(13,'P/N: 489JHS00-1, 3-WAY SOLENOID VALVE','489JHS00-1','3-Way, 2-position solenoid valve for inert gases or hydraulic oil, operating pressure 3250 PSIG.',NULL,NULL,0,0,'','',0.00,'','','489JHS00-1.JPG','',0.0000,1,1,'',0.00,13,NULL,NULL),(14,'P/N: 608KWJ06-3, SOLENOID OPERATED BALL VALVE','608KWJ06-3','Solenoid rotates ball valve, for liquids or gases, operating pressure 1250 PSIG.',NULL,NULL,0,0,'','',0.00,'','','608KWJ06-3.JPG','',0.0000,1,1,'',0.00,14,NULL,NULL),(15,'P/N: 480JAA07, SOLENOID SHUT-OFF VALVE','480JAA07','Hermetic valve is designed for total immersion in fuel for 15 years.  Low current draw, low pressure gases or liquids.',NULL,NULL,0,0,'','',0.00,'','','480JAA07.JPG','',0.0000,1,1,'',0.00,15,NULL,NULL),(16,'P/N: 765JAS,  3-WAY SOLENOID VALVE','765JAS','High pressure general purpose 3-way solenoid valve for up to 6000 PSIG, with manual override, for inert gases or non-corrosive liquids.',NULL,NULL,0,0,'','',0.00,'','','765JAS.JPG','',0.0000,1,1,'',0.00,16,NULL,NULL),(24,'P/N: 006BGX12, LARGE MOTOR ACTUATED BALL VALVE','006BGX12','Large ball valve with pneumatic motor actuation, 3800 PSIG operating pressure. Prototype rocket valve application.',NULL,NULL,0,0,'','',0.00,'','','006BGX12.JPG','',0.0000,1,1,'',0.00,24,NULL,NULL),(18,'P/N: 747JAD07-1,  SOLENOID VALVE','747JAD07-1','High pressure solenoid shut-off valve for air or inert gases at 3000 PSIG.',NULL,NULL,0,0,'','',0.00,'','','747JAD07A.JPG','',0.0000,1,1,'',0.00,18,NULL,NULL),(19,'P/N: 789JAB07-4,  SOLENOID VALVE','789JAB07-4','Solenoid valve with integral restrictor.',NULL,NULL,0,0,'','',0.00,'','','789JAB07.JPG','',0.0000,1,1,'',0.00,19,NULL,NULL),(20,'P/N: 792JAS00-6, SOLENOID VALVE','792JAS00-6','Low-pressure, low-flow, for air or inert gases, normally closed.',NULL,NULL,0,0,'','',0.00,'','','792JAB07_LO_RES.JPG','',0.0000,1,1,'',0.00,20,NULL,NULL),(21,'P/N: 789JAB07-1, SOLENOID VALVE','789JAB07-1','Solenoid valve.',NULL,NULL,0,0,'','',0.00,'','','789JAB07-1.JPG','',0.0000,1,1,'',0.00,21,NULL,NULL),(22,'P/N: 775JAB07, SOLENOID VALVE','775JAB07','High pressure solenoid valve for 0-3100 PSIG, gases or liquids.',NULL,NULL,0,0,'','',0.00,'','','775JAB07.JPG','',0.0000,1,1,'',0.00,22,NULL,NULL),(23,'P/N: 779JAB07, SOLENOID VALVE','779JAB07','Solenoid valve for low pressure, low flow, normally closed.',NULL,NULL,0,0,'','',0.00,'','','779JAB07.JPG','',0.0000,1,1,'',0.00,23,NULL,NULL),(25,'P/N: 007BGX32, LARGE MOTOR ACTUATED BALL VALVE','007BGX32','Large ball valve with pneumatic motor actuation, 3800 PSIG operating pressure. Prototype rocket valve application.',NULL,NULL,0,0,'','',0.00,'','','007BGX32.JPG','',0.0000,1,1,'',0.00,25,NULL,NULL),(26,'P/N: 760 SOLENOID ASSY','760','Small high pressure solenoid valve with tubing assembly.',NULL,NULL,0,0,'','',0.00,'','','760SOL.JPG','',0.0000,1,1,'',0.00,26,NULL,NULL),(27,'P/N: 510GPS. CABLE OPERATED BALL VALVE','510GPS','Operating pressure 1500 to 3500 PSIG with air or inert gases.\r\n\r\nClick <b><u> <a\r\nhref=\"http://www.gpcvalves.com/downloads/510 gps brochure.pdf\" target=\"_blank\">download\r\nfile </b></u> </a> for more detailed product Write-up.</p></div>',NULL,NULL,0,0,'','',0.00,'','','510GPS-10.JPG','',0.0000,1,1,'',0.00,28,NULL,NULL),(28,'P/N: 479GPS.  CABLE OPERATED BALL VALVE.','479GPS','Operating pressure 1500 to 3500 PSIG with air or inert gases.',NULL,NULL,0,0,'','',0.00,'','','479GPS.JPG','',0.0000,1,1,'',0.00,27,NULL,NULL),(29,'P/N: 527GPS-1.  BALL VALVE & REGULATOR','527GPS-1','Combination ball valve and regulator.  Inlet pressure: 1500-3500 PSIG, Outlet pressure: 270-460 PSIG. Gases: air, carbon dioxide, or nitrogen.',NULL,NULL,0,0,'','',0.00,'','','527GPS-1.JPG','',0.0000,1,1,'',0.00,34,NULL,NULL),(30,'P/N: 515GPS-1.  BALL VALVE & REGULATOR.','515GPS-1','Combination ball valve and regulator.  Inlet pressure: 1500-3200 PSIG, Outlet pressure: 300-600 PSIG. Gases: air, carbon dioxide, or nitrogen.',NULL,NULL,0,0,'','',0.00,'','','515GPS-1.JPG','',0.0000,1,1,'',0.00,29,NULL,NULL),(32,'P/N: 520GPS.  BALL VALVE & REGULATOR.','520GPS','Combination ball valve and regulator.  Inlet pressure: 1500-3500 PSIG, Outlet pressure: 270-460 PSIG. Gases: air, carbon dioxide, or nitrogen.',NULL,NULL,0,0,'','',0.00,'','','520GPS.JPG','',0.0000,1,1,'',0.00,30,NULL,NULL),(33,'P/N: 524GPS','524GPS','Combination ball valve and regulator.  Inlet pressure: 1500-3000 PSIG, Outlet pressure: 150-300 PSIG. Gases: air, carbon dioxide, or nitrogen.',NULL,NULL,0,0,'','',0.00,'','','524GPS_LO_RES.JPG','',0.0000,1,1,'',0.00,32,NULL,NULL),(34,'P/N: 524GPS.  BALL VALVE & REGULATOR.','524GPS','Combination ball valve and regulator.  Inlet pressure: 1500-3000 PSIG, Outlet pressure: 150-300 PSIG. Gases: air, carbon dioxide, or nitrogen.',NULL,NULL,0,0,'','',0.00,'','','524GPS.JPG','',0.0000,1,1,'',0.00,33,NULL,NULL),(35,'P/N: 538GPS-1.  BALL VALVE & REGULATOR.','538GPS-1','Combination ball valve and regulator.  Inlet pressure: 1500-3500 PSIG, Outlet pressure: 270-460 PSIG. Gases: air, carbon dioxide, or nitrogen.',NULL,NULL,0,0,'','',0.00,'','','538GPS.JPG','',0.0000,1,1,'',0.00,35,NULL,NULL),(36,'P/N: 743GPS-8, Aspirator','743GPS-8','Uses working fluid 100 to 500 PSIG.  Ratio of secondary flow to primary flow is 4.1:1.',NULL,NULL,0,0,'','',0.00,'','','743GPS-8.JPG','',0.0000,1,1,'',0.00,36,NULL,NULL),(37,'P/N: 777GPS, Aspirator','777GPS','Primary operating pressure is 350 to 485 PSIG for optimum performance. Ratio of secondary flow to primary flow is 5.2:1.',NULL,NULL,0,0,'','',0.00,'','','777GPS.JPG','',0.0000,1,1,'',0.00,37,NULL,NULL),(38,'P/N: 756GPS, Aspirator','756GPS','Aspirator.',NULL,NULL,0,0,'','',0.00,'','','756GPS.JPG','',0.0000,1,1,'',0.00,38,NULL,NULL),(39,'P/N: 777PROT, Aspirator','777PROT','Aspirator.',NULL,NULL,0,0,'','',0.00,'','','777PROT_LO_RES.JPG','',0.0000,1,1,'',0.00,39,NULL,NULL),(40,'P/N: 785GPS, Aspirator','785GPS','Primary inlet pressure 500 to 600 PSIG.  Optimized for nitrogen/carbon dioxide mixture.',NULL,NULL,0,0,'','',0.00,'','','785GPS.JPG','',0.0000,1,1,'',0.00,40,NULL,NULL),(41,'P/N: 861, Aspirator','861','Flat aspirator.',NULL,NULL,0,0,'','',0.00,'','','861_LO.JPG','',0.0000,1,1,'',0.00,41,NULL,NULL),(42,'P/N: 826GPS07-1, Rupture Disk','826GPS07-1','Burst pressure: 4750 +/- 250 PSIG.',NULL,NULL,0,0,'','',0.00,'','','826GPS07-1.JPG','',0.0000,1,1,'',0.00,42,NULL,NULL),(43,'P/N: 828GPS07B, Thermal Relief Valve','828GPS07B','Operating pressure: 300 PSIG, thermal actuation at 174 +/- 5 deg. F.',NULL,NULL,0,0,'','',0.00,'','','828GPS07B_LO_RES.JPG','',0.0000,1,1,'',0.00,43,NULL,NULL),(44,'P/N: 858GPS10-2, Rupture Disk','858GPS10-2','Burst pressure: 2100 to 2500 PSIG.',NULL,NULL,0,0,'','',0.00,'','','858GPS10.JPG','',0.0000,1,1,'',0.00,44,NULL,NULL),(45,'P/N: 828GPS07B, Thermal Relief Valve','828GPS07B','Actuation at 174 +/- 5 deg. F, operating pressure 3000 PSIG.',NULL,NULL,0,0,'','',0.00,'','','828GPS07B.JPG','',0.0000,1,1,'',0.00,45,NULL,NULL),(46,'P/N: 806RLA02, Relief Valve','806RLA02','Cracking pressure (adjustable at factory)of 1.5 to 9.0 PSID, operating pressure 200 PSIG.',NULL,NULL,0,0,'','',0.00,'','','806RLA02A.JPG','',0.0000,1,1,'',0.00,46,NULL,NULL),(47,'P/N: 932ROS10, Bi-Directional Relief Valve','932ROS10','Used to prevent over-pressure or under-pressure.  Cracking pressure: 5.00 ± 0.75 PSID, cracking vacuum: 4.00 ± 0.50 PSID. ',NULL,NULL,0,0,'','',0.00,'','','932R0S10.JPG','',0.0000,1,1,'',0.00,47,NULL,NULL),(48,'804RAA03, Hot Gas Pressure Relief Valve','804RAA03','Used to limit pressure of hot gas systems. Relief pressure: up to 1500 PSID.',NULL,NULL,0,0,'','',0.00,'','','804RAA03-4A.JPG','',0.0000,1,1,'',0.00,48,NULL,NULL),(49,'P/N: 931ROB04, Relief Valve','931ROB04','Operating pressure: 200 PSIG, cracking pressure: 2 to 6 PSID (set at factory).',NULL,NULL,0,0,'','',0.00,'','','931R0B04.JPG','',0.0000,1,1,'',0.00,49,NULL,NULL),(50,'P/N: 468RAS03, Relief Valve','468RAS03','Relief valve incorporates red pop-up indicator.',NULL,NULL,0,0,'','',0.00,'','','468.JPG','',0.0000,1,1,'',0.00,50,NULL,NULL),(51,'P/N: 841CAS2-3, Relief Valve','841CAS2-3','Relief valve for installation into fabric air inflatable devices.',NULL,NULL,0,0,'','',0.00,'','','841CAS2-3.JPG','',0.0000,1,1,'',0.00,51,NULL,NULL),(52,'P/N: 862RHS20, Relief Valve','862RHS20','Operating pressure: 3200 PSIG, cracking pressure: 700 ± 200 PSID.',NULL,NULL,0,0,'','',0.00,'','','862RHS20.JPG','',0.0000,1,1,'',0.00,52,NULL,NULL),(53,'P/N: 860RAL12-1, Relief Valve','860RAL12-1','Relief Valve.',NULL,NULL,0,0,'','',0.00,'','','860RAL12-1.JPG','',0.0000,1,1,'',0.00,53,NULL,NULL),(54,'P/N: 985RAS00-1, Relief Valve','985RAS00-1','Large relief valve for installation into fabric air inflatable devices.',NULL,NULL,0,0,'','',0.00,'','','985RAS00-1.JPG','',0.0000,1,1,'',0.00,54,NULL,NULL),(55,'P/N: 503MAM02','503MAM02','Cable operated inflation valve with siphon tube.',NULL,NULL,0,0,'','',0.00,'','','503MAM02.JPG','',0.0000,1,1,'',0.00,55,NULL,NULL),(60,'Check/Relief Valve','P/N: 862RHS20','Operating pressure 3200 PSIG, uses inert gases, hydraulic fluid, and other non-corrosive fluid.',NULL,NULL,1,1,'','',0.00,'','','862RHS20.JPG','',0.0000,1,1,'',0.00,60,NULL,NULL),(56,'P/N: 536GPS, Inflation Valve','536GPS','Cable operated inflation valve.',NULL,NULL,0,0,'','',0.00,'','','536GPS.JPG','',0.0000,1,1,'',0.00,56,NULL,NULL),(57,'P/N: 540, Inflation Valve','540','Pilot-pressure operated, high-response, inflation valve.',NULL,NULL,0,0,'','',0.00,'','','540.JPG','',0.0000,1,1,'',0.00,57,NULL,NULL),(58,'P/N: 540-1, Inflation Valve.','540-1','Pilot-pressure operated, high-response, high-capacity, inflation valve.',NULL,NULL,0,0,'','',0.00,'','','540-1.JPG','',0.0000,1,1,'',0.00,58,NULL,NULL),(59,'P/N: 958CAB17, Inflation Valve.','0','Assembled and disassembled views of inflation valve for fabric mounting on air inflatable devices.',NULL,NULL,0,0,'','',0.00,'','','958CAB17_COMBO.jpg','',0.0000,1,1,'',0.00,59,NULL,NULL);

--
-- Table structure for table `Sale`
--

CREATE TABLE `Sale` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `invoiceID` int(11) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sale`
--

INSERT INTO `Sale` VALUES (1,1,1,'Gas relief valve','P/N 523XYZ',1100.00,'','',1,NULL);

--
-- Table structure for table `Shipping`
--

CREATE TABLE `Shipping` (
  `carrier` tinytext,
  `method` tinytext,
  `weight` double(16,2) DEFAULT NULL,
  `price` double(16,2) DEFAULT NULL,
  `record_type` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(5) DEFAULT NULL,
  `class` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shipping`
--


--
-- Table structure for table `Shopping`
--

CREATE TABLE `Shopping` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `product` int(11) NOT NULL DEFAULT '0',
  `session` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `label1` tinytext,
  `sitename` tinytext,
  `label2` tinytext,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shopping`
--

INSERT INTO `Shopping` VALUES (2,1,1032291645,1,'','gpcvalves','');

--
-- Dumping events for database 'gpcvalves'
--

--
-- Dumping routines for database 'gpcvalves'
--


