-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Host: 68.178.143.158
-- Generation Time: Mar 17, 2017 at 02:58 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 `resourcesubcategory`
--

CREATE TABLE `resourcesubcategory` (
  `resSubCatSerial` int(11) NOT NULL AUTO_INCREMENT,
  `resCatID` int(11) NOT NULL,
  `resSubCatCode` varchar(40) NOT NULL,
  `resSubCatName` varchar(255) NOT NULL,
  `creationDate` date NOT NULL,
  `companyID` int(11) NOT NULL,
  `resSubCatStatus` varchar(255) NOT NULL,
  PRIMARY KEY (`resSubCatSerial`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;

--
-- Dumping data for table `resourcesubcategory`
--

INSERT INTO `resourcesubcategory` (`resSubCatSerial`, `resCatID`, `resSubCatCode`, `resSubCatName`, `creationDate`, `companyID`, `resSubCatStatus`) VALUES
(1, 5, 'CON', 'Contractor', '2015-05-26', 3, '1'),
(2, 5, 'CONT', 'contractor', '2015-05-26', 215, '1'),
(3, 5, 'SUPP', 'Supplier', '2015-05-31', 3, '1'),
(4, 5, 'SUBCON', 'Subcontractor', '2015-05-31', 3, '1'),
(5, 5, 'MANUF', 'Manufacturer', '2015-05-31', 3, '1'),
(6, 3, 'RENT', 'Rental Equipment', '2015-06-03', 3, '1'),
(7, 3, 'OWN', 'Owned Equipment', '2015-06-03', 3, '1'),
(8, 1, 'OWN', 'Owned Manpower', '2015-06-03', 3, '1'),
(9, 16, 'SUBTEST', 'Test Sub Category', '2015-06-05', 28, '1'),
(10, 5, 'GC', 'General Contractor', '2015-06-05', 28, '1'),
(11, 5, 'SUBCON', 'Sub Contractor', '2015-06-05', 28, '1'),
(12, 5, 'MANUF', 'Manufacturer', '2015-06-05', 28, '1'),
(13, 5, 'SUPP', 'Supplier', '2015-06-05', 28, '1'),
(14, 1, 'PERM', 'Manpower - Permanant', '2015-06-05', 28, '1'),
(15, 1, 'TEMP', 'Manpower - Temporary', '2015-06-05', 28, '1'),
(16, 3, 'OWN', 'Equipment - Owned', '2015-06-05', 28, '1'),
(17, 3, 'RENT', 'Equipment - Rented', '2015-06-05', 28, '1'),
(18, 2, 'BULK', 'Materials - Bulk', '2015-06-05', 28, '1'),
(19, 3, 'TRANS', 'Equipment - Transferable', '2015-06-05', 28, '1'),
(20, 2, 'CON', 'Consumables', '2015-07-19', 3, '1'),
(21, 2, 'BLK', 'Bulk ', '2015-07-19', 3, '1'),
(22, 1, 'PRM', 'Manpower - Permanant/ Unlimited Contract', '2017-03-10', 261, '1'),
(23, 1, 'TMP', 'Manpower - Temporary / Limited Contract', '2017-03-10', 261, '1'),
(24, 2, 'LLD', 'Material - Long Lead', '2017-03-10', 261, '1'),
(25, 2, 'BLK', 'Material - Bulk / Consumables', '2017-03-10', 261, '1'),
(26, 3, 'OWN', 'Equipment - Owned', '2017-03-10', 261, '1'),
(27, 3, 'RNT', 'Equipment - Rental', '2017-03-10', 261, '1'),
(28, 3, 'TRA', 'Equipment - Transferable to the project', '2017-03-13', 261, '1'),
(29, 2, 'TRA', 'Material - Transferable to the project', '2017-03-13', 261, '1'),
(30, 5, 'MAN', 'Vendor - Manufacturer', '2017-03-13', 261, '1'),
(31, 5, 'SUP', 'Vendor - Supplier', '2017-03-13', 261, '1'),
(32, 5, 'CON', 'Vendor - Contractor', '2017-03-13', 261, '1'),
(33, 5, 'SUB', 'Vendor - Sub-Contractor', '2017-03-13', 261, '1'),
(34, 5, 'SUB', 'Vendor - Sub-Contractor', '2017-03-13', 254, '1'),
(35, 5, 'CON', 'Vendor - Contractor', '2017-03-13', 254, '1'),
(36, 5, 'SUP', 'Vendor - Supplier', '2017-03-13', 254, '1'),
(37, 5, 'MAN', 'Vendor - Manufacturer', '2017-03-13', 254, '1'),
(38, 2, 'TRA', 'Material - Transferable to the project', '2017-03-13', 254, '1'),
(39, 3, 'TRA', 'Equipment - Transferable to the project', '2017-03-13', 254, '1'),
(40, 3, 'RNT', 'Equipment - Rental', '2017-03-10', 254, '1'),
(41, 3, 'OWN', 'Equipment - Owned', '2017-03-10', 254, '1'),
(42, 2, 'BLK', 'Material - Bulk / Consumables', '2017-03-10', 254, '1'),
(43, 2, 'LLD', 'Material - Long Lead', '2017-03-10', 254, '1'),
(44, 1, 'TMP', 'Manpower - Temporary / Limited Contract', '2017-03-10', 254, '1'),
(45, 1, 'PRM', 'Manpower - Permanant/ Unlimited Contract', '2017-03-10', 254, '1'),
(46, 18, 'TSTRESSUBCAT', 'Testing the Resource Sub Category', '2017-03-13', 261, '0'),
(47, 1, 'TRA', 'Manpower - Transferable to the project', '2017-03-14', 261, '1'),
(48, 6, 'LAN', 'Asset - Land', '2017-03-14', 261, '1'),
(49, 6, 'BLD', 'Asset - Building', '2017-03-14', 261, '1'),
(50, 6, 'SOF', 'Asset - Software', '2017-03-14', 261, '1'),
(51, 2, 'MRO', 'Materials - Maintenance Repair Operations', '2017-03-15', 261, '1'),
(52, 6, 'FUR', 'Asset - Furniture', '2017-03-17', 261, '1');