-- MySQL dump 8.23
--
-- Host: localhost    Database: fserrano
---------------------------------------------------------
-- Server version	3.23.58

--
-- Table structure for table `jmcaribbean`
--

CREATE TABLE `jmcaribbean` (
  `number` int(11) NOT NULL auto_increment,
  `product` varchar(50) NOT NULL default '',
  `company` varchar(50) NOT NULL default '',
  `application` varchar(50) NOT NULL default '',
  `image` varchar(50) default NULL,
  `reference` mediumtext,
  `description` longtext NOT NULL,
  `condition` varchar(25) default NULL,
  `recommendation` mediumtext,
  PRIMARY KEY  (`number`),
  UNIQUE KEY `number` (`number`),
  FULLTEXT KEY `product` (`product`),
  FULLTEXT KEY `company` (`company`),
  FULLTEXT KEY `application` (`application`),
  FULLTEXT KEY `condition` (`condition`),
  FULLTEXT KEY `recommendation` (`recommendation`)
) TYPE=MyISAM;

--
-- Dumping data for table `jmcaribbean`
--


INSERT INTO `jmcaribbean` VALUES (71,'Geoweb','Presto Products','Soil Reinforcement Fabrics','soilReinforcement.gif','http://www.prestogeo.com','Provide separation and confinement to dissimilar soils; add modulus and tensile reinforcement to weak soil/aggregate systems.','Geocells','Soil confinement system to be used in conjuction with geotextile for best performance.');
INSERT INTO `jmcaribbean` VALUES (69,'Mirafi HP570','TC Mirafi','Soil Reinforcement Fabrics','soilReinforcement.gif','http://www.tcmirafi.com','Provide separation and confinement to dissimilar soils; add modulus and tensile reinforcement to weak soil/aggregate systems.','High Strength Geotextile','Recommended for weak soils and heavy vehicular load conditions.');
INSERT INTO `jmcaribbean` VALUES (59,'600X','TC Mirafi','Soil Reinforcement Fabrics','soilReinforcement.gif','http://www.tcmirafi.com','Provide separation and confinement to dissimilar soils; add modulus and tensile reinforcement to weak soil/aggregate systems.','Slit Film Geotextile','For heavier loads.\r\nIf you have weak soils go to Mirafi HP370 or HP570 on this page.');
INSERT INTO `jmcaribbean` VALUES (58,'500XL','TC Mirafi','Soil Reinforcement Fabrics','soilReinforcement.gif','http://www.tcmirafi.com','Provide separation and confinement to dissimilar soils; add modulus and tensile reinforcement to weak soil/aggregate systems.','Slit Film Geotextile','For light loads.\r\nIF you have weak soils go to Mirafi HP370 or HP570 on this page.');
INSERT INTO `jmcaribbean` VALUES (57,'2500HP','Mirafi','Soil Reinforcement Fabrics','soilReinforcement.gif','http://www.tcmirafi.com','Provide separation and confinement to dissimilar soils; add modulus and tensile reinforcement to weak soil/aggregate systems.','High Strength Geotextile','');
INSERT INTO `jmcaribbean` VALUES (56,'MiraDrain 4000','MiraDri','Prefabricated Drainage System','prefabricatedDrainage.gif','http://www.miradri.com','Designed to replace most conventional aggregate-filled drain systems for virtually every subsurface drainage need - particularly against concrete walls.','MiraDrain Geocomposite','');
INSERT INTO `jmcaribbean` VALUES (68,'Mirafi HP370','Mirafi','Soil Reinforcement Fabrics','soilReinforcement.gif','http://www.tcmirafi.com','Provide separation and confinement to dissimilar soils; add modulus and tensile reinforcement to weak soil/aggregate systems.','High Strength Geotextile','Recommended for low strength soils and moderate vehicular load conditions.');
INSERT INTO `jmcaribbean` VALUES (53,'2100HP','Mirafi','Armored Erosion Control Fabrics','armoredErosion.gif','http://www.tcmirafi.com','Placed under riprap and gabions to prevent erosion of underlying soils.','Soil','');
INSERT INTO `jmcaribbean` VALUES (72,'500X','Mirafi','Sediment Control System','sedimentControl.gif','','Provides silt retention to keep sediment on the job site, outlasts hay bales or burlap, and is available as a ready-to-install system.','','');
INSERT INTO `jmcaribbean` VALUES (54,'Envirofence','Mirafi','Sediment Control System','sedimentControl.gif','http://www.tcmirafi.com/products/product_x.html','Provides silt retention to keep sediment on the job site, outlasts hay bales or burlap, and is available as a ready-to-install system.','Sediment','');
INSERT INTO `jmcaribbean` VALUES (52,'500X','Mirafi','Soil Reinforcement Fabrics','soilReinforcement.gif','http://www.tcmirafi.com','Provide separation and confinement to dissimilar soils; add modulus and tensile reinforcement to weak soil/aggregate systems.','Slit Film Geotextile','For moderate vehicular loads.\r\nIf you have weak soils go to Mirafi HP370 or HP570 on this page.');
INSERT INTO `jmcaribbean` VALUES (74,'700XG','Mirafi','Reinforced Soil Wall','Reinforced-Soil-Wall.gif','http://www.mirafi.com','Fabric provides a rough textured, strong membrane that reinforces layers of soil to form an earthen embankment.','','');
INSERT INTO `jmcaribbean` VALUES (75,'1000HP','Mirafi','High Performance Stabilization','High-Performance-Stabilizat.gif','http://www.mirafi.com','Provide and extremely high level of tear strength and puncture resistance for tough soil-reinforcement conditions; well-suited for land reclamation and storage pond capping.','','');
INSERT INTO `jmcaribbean` VALUES (76,'Mirascape','Mirafi','Landscape Fabric','Landscape-Fabric.gif','http://www.mirafi.com','Provides vegetation control while allowing free passage of air and soil moisture.','','');
INSERT INTO `jmcaribbean` VALUES (78,'900N','Mirafi','Asphalt Overlay','Asphalt-Overlay.gif','http://www.mirafi.com','Forms a tough, waterproof membrane between existing pavement and new asphalt overlay that strengthens the pavement and reduces reflective cracking.','','');
INSERT INTO `jmcaribbean` VALUES (84,'160N','Mirafi','Pond Liners And Underlining Fabrics','Pond-Liners-and-Underlyning.gif','http://www.mirafi.com','Provides gas ventilation and puncture protection for a geomembrane.','','');

