
-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Host: 68.178.143.158
-- Generation Time: Dec 17, 2016 at 05:38 AM
-- Server version: 5.5.43
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Database: `pmAnywhere3`
--

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

--
-- Table structure for table `globalmf`
--

CREATE TABLE `globalmf` (
  `specCode` varchar(50) NOT NULL,
  `MFID` int(11) NOT NULL AUTO_INCREMENT,
  `MFIDA` int(11) NOT NULL,
  `MFIDB` int(11) NOT NULL,
  `MFIDC` int(11) NOT NULL,
  `MFIDD` int(11) NOT NULL,
  `gmf_name` varchar(255) NOT NULL,
  `creationDate` varchar(40) NOT NULL,
  `gmflist_id` int(11) NOT NULL,
  `companyID` int(11) NOT NULL,
  `MFtype` varchar(50) NOT NULL,
  PRIMARY KEY (`MFID`),
  KEY `gmflist_id` (`gmflist_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6019 ;

--
-- Dumping data for table `globalmf`
--

INSERT INTO `globalmf` VALUES('00.00.00.00', 5000, 0, 0, 0, 0, 'Procurement Scopes', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('01.00.00.00', 5001, 1, 0, 0, 0, 'General Requirements', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('02.00.00.00', 5002, 2, 0, 0, 0, 'Existing Conditions', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('03.00.00.00', 5003, 3, 0, 0, 0, 'Concrete', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('04.00.00.00', 5004, 4, 0, 0, 0, 'Masonry', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('05.00.00.00', 5006, 5, 0, 0, 0, 'Metals', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('06.00.00.00', 5007, 6, 0, 0, 0, 'Wood Plastics and Composites', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('07.00.00.00', 5008, 7, 0, 0, 0, 'Thermal and Moisture Protection', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('08.00.00.00', 5009, 8, 0, 0, 0, 'Openings', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('09.00.00.00', 5010, 9, 0, 0, 0, 'Finishes', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('10.00.00.00', 5011, 10, 0, 0, 0, 'Specialties', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('11.00.00.00', 5012, 11, 0, 0, 0, 'Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('12.00.00.00', 5013, 12, 0, 0, 0, 'Furnishings', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('13.00.00.00', 5014, 13, 0, 0, 0, 'Special Construction', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('14.00.00.00', 5015, 14, 0, 0, 0, 'Conveying Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('15.00.00.00', 5016, 15, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('16.00.00.00', 5017, 16, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('17.00.00.00', 5018, 17, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('18.00.00.00', 5019, 18, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('19.00.00.00', 5020, 19, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('20.00.00.00', 5021, 20, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('21.00.00.00', 5022, 21, 0, 0, 0, 'Fire Suppression', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('22.00.00.00', 5023, 22, 0, 0, 0, 'Plumbing', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('23.00.00.00', 5024, 23, 0, 0, 0, 'Heating Ventilating and Air Conditioning (HVAC)', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('24.00.00.00', 5025, 24, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('25.00.00.00', 5026, 25, 0, 0, 0, 'Integrated Automation', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('26.00.00.00', 5027, 26, 0, 0, 0, 'Electrical', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('27.00.00.00', 5028, 27, 0, 0, 0, 'Communications', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('28.00.00.00', 5029, 28, 0, 0, 0, 'Electronic Safety and Security', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('29.00.00.00', 5030, 29, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('30.00.00.00', 5031, 30, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('31.00.00.00', 5032, 31, 0, 0, 0, 'Earthwork', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('32.00.00.00', 5033, 32, 0, 0, 0, 'Exterior Improvements', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('33.00.00.00', 5034, 33, 0, 0, 0, 'Utilities', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('34.00.00.00', 5035, 34, 0, 0, 0, 'Transportation', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('35.00.00.00', 5036, 35, 0, 0, 0, 'Waterway and Marine Construction', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('36.00.00.00', 5037, 36, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('37.00.00.00', 5038, 37, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('38.00.00.00', 5039, 38, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('39.00.00.00', 5040, 39, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('40.00.00.00', 5041, 40, 0, 0, 0, 'Process Interconnections', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('41.00.00.00', 5042, 41, 0, 0, 0, 'Material Processing and Handling Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('42.00.00.00', 5043, 42, 0, 0, 0, 'Process Heating Cooling and Drying Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('43.00.00.00', 5044, 43, 0, 0, 0, 'Process Gas and Liquid Handling Purification and Storage Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('44.00.00.00', 5045, 44, 0, 0, 0, 'Pollution and Waste Control Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('45.00.00.00', 5046, 45, 0, 0, 0, 'Industry-Specific Manufacturing Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('44.00.00.00', 6014, 44, 0, 0, 0, 'Pollution and Waste Control Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('45.00.00.00', 6015, 45, 0, 0, 0, 'Industry-Specific Manufacturing Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('46.00.00.00', 6016, 46, 0, 0, 0, 'Water and Wastewater Equipment', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('47.00.00.00', 6017, 47, 0, 0, 0, 'Blank', '2016-08-07', 45, 48, 'Global');
INSERT INTO `globalmf` VALUES('48.00.00.00', 6018, 48, 0, 0, 0, 'Electrical Power Generation', '2016-08-07', 45, 48, 'Global');
