-- phpMyAdmin SQL Dump -- version 2.11.11.3 -- http://www.phpmyadmin.net -- -- Host: 68.178.143.158 -- Generation Time: Mar 21, 2017 at 01:09 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 `resources` -- CREATE TABLE `resources` ( `resSerial` int(11) NOT NULL AUTO_INCREMENT, `companyID` int(11) NOT NULL, `resName` varchar(100) NOT NULL, `unitID` int(11) NOT NULL, `rate` varchar(50) NOT NULL, `rescatID` int(11) NOT NULL, `ressubcatID` int(11) NOT NULL, `rescode` varchar(11) NOT NULL, `disciplineID` int(11) NOT NULL, `vendFname` varchar(50) NOT NULL, `vendLname` varchar(50) NOT NULL, `desig` varchar(100) NOT NULL, `vendmobile` varchar(20) NOT NULL, `vendemail` varchar(50) NOT NULL, `vendphone` varchar(20) NOT NULL, `vendfax` varchar(20) NOT NULL, `vendweb` varchar(30) NOT NULL, `prod` varchar(50) NOT NULL, `dateCreated` date NOT NULL, `dateHidden` date NOT NULL, `resStatus` tinyint(4) NOT NULL, `resTieroneID` int(11) NOT NULL, `resTiertwoID` int(11) NOT NULL, `resBrandID` int(11) NOT NULL, `resModelID` int(11) NOT NULL, `resColor` varchar(50) NOT NULL, `resWeight` varchar(100) NOT NULL, PRIMARY KEY (`resSerial`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=110 ; -- -- Dumping data for table `resources` -- INSERT INTO `resources` VALUES(6, 2, 'endor Name', 18, '', 5, 1, '7', 0, 'salman', '', '', '333333', 'salmanzaibi15@gmail.com', '123456789', '123456878', '', '', '2013-04-17', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(7, 3, 'Saudi Consolidated Engg Company', 18, '', 5, 1, 'SCEC', 9, 'Yusuf ', 'Ahmed', '', '+966 5 0266 8404', 'y-ahmed@scecka.com', '+966 13 894 6816', '+966 13 894 2341', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(8, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 29, 'Asghar ', 'Niaz', '', '', 'masghar.niaz@iccksa.com', '', '', '', '', '2013-09-28', '2016-01-12', 0, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(9, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 27, 'AbdulRasheed ', 'Sait', '', '', 'Abdul.Sait@drakescull.com', '', '', '', '', '2013-09-28', '2016-01-12', 0, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(10, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 17, 'Sameeh ', 'Al Tamimi', '', '', 'Sameeh.Tamimi@drakescull.com', '', '', '', '', '2013-09-28', '2016-01-12', 0, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(11, 3, 'Saudi Consolidated Engg Company', 18, '', 5, 1, 'SCEC', 16, 'Orlando ', 'Garcia', '', '', 'garcia@scecka.com', '', '', '', '', '2013-09-28', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(12, 3, 'Electronic Special Equipment Company', 18, '0', 5, 1, 'ESEC', 34, 'Rami ', 'Maamari', '', '+966 5 0666 4112', 'rmaamari@Alajou.com ', '', '', '', '', '2016-08-21', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(13, 3, 'Saudi Consolidated Engg Company', 18, '', 5, 1, 'SCEC', 9, 'Khalidi ', 'Asger', '', '', 'khalidi@scecka.com', '+966 13 894 6816', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(14, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 29, 'Khalid ', 'El-Daly', '', '', '', '', '', '', '', '2013-09-28', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(15, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 17, 'Saleh Muradweij', '', '', '', 'saleh.muradweij@drakescull.com', '+966 13 887 0158', '', '', '', '2014-02-18', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(16, 2, 'vv', 18, '', 5, 1, 'v', 0, 'sasa', '', 'ss', '333333', 'salmanzaibi15@gmail.com', '123456789', '215', '', '', '2014-02-22', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(17, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 17, 'Hesham ', 'Elbakry', '', '', 'Hesham.Elbakry@drakescull.com', '', '', '', '', '2014-02-18', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(18, 3, 'International Contracting Company', 18, '0', 5, 1, 'ICC', 17, 'Munir', 'Nasser', '', '', '', '', '', '', '', '2015-07-19', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(20, 3, 'OTHER', 18, '', 5, 1, 'OTHER', 17, 'Other', '', '', '', '', '', '', '', '', '2013-09-01', '0000-00-00', 2, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(21, 3, 'SNC-Lavalin Fayez Engineering', 18, '', 5, 1, 'SLFE', 42, 'Ahmed', 'Anwer', '', '+966 5 4797 2404', 'Ahmed.Anwer@slfe.com.sa', '+966 13 510 7777 ', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(22, 34, 'Ayash', 18, '', 5, 1, 'AYASH', 43, 'Ayash', '', '', '', '', '', '', '', '', '2013-09-29', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(23, 3, 'Integrated Telecom Company', 18, '', 5, 1, 'ITC', 34, 'Ali Raza', '', '', '+966 5 0725 1386', '', '', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(24, 3, 'Saudi Telecom Company', 18, '', 5, 1, 'STC', 34, 'A Dahrani', '', '', '+966 5 5777 9990', '', '', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(25, 3, 'Mobily Telecom Company', 18, '', 5, 1, 'MOBILY', 34, 'Mohd ', 'Abdullah', '', '+966 5 4555 4010', '', '', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(26, 3, 'Saudi Electrical Company', 18, '', 5, 1, 'SEC', 11, 'Faisal', '', '', '+966 5 4212 1225', '', '+966 12 213 5053', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(27, 3, 'Integrated Telecom Company', 18, '', 5, 1, 'ITC', 34, 'Ali ', 'Khan', '', '+966 5 4500 0492', '', '+966 11 406 2203', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(28, 3, 'Saudi Telecom Company', 18, '', 5, 1, 'STC', 34, 'Hate', 'Al Thebyani ', '', '+966 5 5888 7239', '', '+966 5 0473 7668', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(29, 3, 'Mobily Telecom Company', 18, '', 5, 1, 'MOBILY', 34, 'S. Abdumajid ', '', '', '+966 5 6032 1833', '', '', '', '', '', '2013-10-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(30, 3, 'Saudi Telecom Company', 18, '', 5, 1, 'STC', 34, 'Hassan ', 'Bin Mohammad AlShahri', '', '', '', '', '', '', '', '2013-10-10', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(31, 3, 'Saudi Telecom Company', 18, '', 5, 1, 'STC', 34, 'Hani', 'Rajab', '', '+966 556 600 366', 'hrzahrani@stc.com.sa', '+966 12 612 7824', '+966 12 612 7701', '', '', '2013-10-10', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(32, 3, 'Mobily Telecom Company', 18, '', 5, 1, 'MOBILY', 34, 'Khalid', 'Al-Subhi', '', '+966 5 4234 9000', '', '', '', '', '', '2013-10-24', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(33, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 17, 'Anwar', 'Shammout', '', '+966 5 5563 9196', 'anwar.shammout@drakescull.com', '', '', '', '', '2013-11-09', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(34, 28, 'Tile Setter', 44, '0', 5, 11, '', 51, 'Unknown', '', '', '', '', '', '', '', '', '2015-06-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(35, 63, 'Professional Hands Est.', 18, '', 5, 1, 'PHE', 58, 'Ali', '', '', '', 'ali.phe@yahoo.com', '', '', '', '', '2014-01-11', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(36, 2, 'i', 18, '', 5, 1, 'i', 0, 'i', '', 'i', '', '', '', '', '', '', '2014-02-22', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(37, 28, 'Ayash Earthworks', 31, '10000000', 5, 11, '', 53, 'Abu', 'Waleed', 'General Manager', '1234567890', 'abs@wbs.com', '1234567890', '1234567890', '', '', '2015-06-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(38, 3, 'International Contracting Company', 18, '', 5, 1, 'ICC', 17, 'Ahmed', 'Karar', 'Company Representative', '+966 5 0066 1164', 'ahmed.Karar@drakescull.com', '', '', '', '', '2014-04-01', '2016-01-12', 0, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(39, 3, 'Saudi Consolidated Engg Company', 18, '', 5, 1, 'SCEC', 17, 'Jamil', 'Akhtar ', 'Design Engineer', '', 'Jamil.Akhtar@khatibalami.com', '', '', '', '', '2014-04-01', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(40, 3, 'Maher Al-Marzooki Est', 18, '', 5, 1, 'MAM', 34, 'Mohan', 'Raj', '', '+966 5 0524 5167', 'mohanrajpk@marzooki.com', '', '', '', '', '2014-04-01', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(41, 28, 'U-Trade', 31, '1', 5, 10, '', 39, 'Wahid', 'Khan', 'CTO', '9.23E+11', 'wahid.k@utrade.co', '+92512574664 x 5', '', '', '', '2017-02-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(42, 28, 'XigmaPro', 31, '1500', 5, 10, '', 38, '', '', '', '', '', '', '', '', '', '2015-06-05', '2017-03-14', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(43, 28, 'SELF', 31, '0', 5, 10, '', 125, '', '', '', '', '', '', '', '', '', '2015-06-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(44, 28, 'DGSET 2500 kVa', 37, '10000000', 3, 19, '', 53, '', '', '', '', '', '', '', '', '', '2015-06-05', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(45, 3, 'Tea Boy', 11, '100', 1, 8, 'TB', 25, '', '', '', '', '', '', '', '', '', '2015-07-20', '0000-00-00', 2, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(46, 3, 'Sand-Const', 7, '25', 2, 21, 'SAND-C', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(47, 3, 'International Contracting Company', 18, '450000000', 5, 1, 'ICC', 17, 'Luca ', 'Amitrano', 'Company Representative', '', 'Luca.Amitrano@drakescull.com', '+966555057459', '', 'www.drakescull.com', '', '2016-01-12', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(48, 3, 'Fatayerji Trading and Contracting Co', 18, '0', 5, 1, 'FCC', 9, 'Sameer', 'Fatayerji', '', '', '', '', '', 'www.fatayerji.com', '', '2016-04-27', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(49, 3, 'Said Ahmed El-Ajou Co Ltd for Trading', 18, '0', 5, 1, 'SAEA', 32, 'Rami', 'Maamari', '', '+966 5 0666 4112', 'rmaamari@Alajou.com', '', '', '', '', '2016-08-21', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(50, 3, 'Mason-Block', 11, '100', 1, 8, 'MAS-BLK', 9, '', '', '', '', '', '', '', '', '100', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(51, 3, 'Mason-Brick', 11, '100', 1, 8, 'MAS-BRK', 9, '', '', '', '', '', '', '', '', '100', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(52, 3, 'Electrician-LV', 11, '100', 1, 8, 'ELE-LV', 11, '', '', '', '', '', '', '', '', '100', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(53, 3, 'Electrician-MV', 11, '100', 1, 8, 'ELE-MV', 11, '', '', '', '', '', '', '', '', '100', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(54, 3, 'Carpenter-Rough', 11, '100', 1, 8, 'CARP-R', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(55, 3, 'Carpentar-Finishes', 11, '100', 1, 8, 'CARP-F', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(56, 3, 'Crushstone-12mm', 7, '100', 2, 21, 'CRUSH-12', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(57, 3, 'Crushstone-25mm', 7, '100', 2, 21, 'CRUSH-25', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(58, 3, 'Cement-Type1', 2, '100', 2, 21, 'CEMENT-1', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(59, 3, 'Sand-Backfil', 7, '20', 2, 21, 'SAND-B', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(60, 3, 'Steel Rebar-12mm', 2, '10', 2, 21, 'REBAR-12', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(61, 3, 'Steel Rebar-20mm', 2, '10', 2, 21, 'REBAR-20', 9, '', '', '', '', '', '', '', '', '', '2016-05-25', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(62, 3, 'Fatayerji Trading and Contracting Co', 18, '0', 5, 1, 'FCC', 9, 'Nohad', 'Hallab', 'Commercial Director', '', '', '+966 12 691 6231', '', '', '', '2016-06-16', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(63, 3, 'Fatayerji Trading and Contracting Co', 18, '0', 5, 1, 'FCC', 9, 'Tarek', 'Majdoub', '', '', 'tmajdoub@fatayerji.com', '', '', '', '', '2016-07-20', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(64, 3, 'Said Ahmed El-Ajou Co Ltd for Trading', 18, '0', 5, 1, 'SAEA', 32, 'Khalied', 'Makki', '', '+966 5 0669 5521', 'km@Alajou.com', '+966 12 660 6456 ', '+966 12 665 1632', '', '', '2016-08-21', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(65, 3, 'International Contracting Company', 18, '0', 5, 1, 'ICC', 29, 'Ziad', 'Baradai', 'Operations Director', '+966 5 0465 6920', 'ziad.baradia@drakeskull.com', '', '', '', '', '2016-12-11', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(66, 3, 'Drake and Scull International', 18, '0', 5, 1, 'DSI', 17, 'Wael', 'Allan', 'CEO', '', '', '+971 444 64 444', '+971 455 14 854', 'www.drakescull.com', '', '2016-12-19', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(67, 28, '1', 29, '111111111', 3, 16, '1', 0, '', '', '', '', '', '', '', '', '', '2017-02-13', '0000-00-00', 2, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(68, 28, 'wdasda', 43, '3', 1, 14, '', 36, '', '', '', '', '', '', '', '', '', '2017-03-06', '0000-00-00', 2, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(69, 261, 'Sand Fine ( 1⁄8 mm –  1⁄4 mm)', 54, '35', 2, 25, 'SAND2', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(70, 261, 'Sand Coarse ( 1⁄2 mm – 1 mm)', 54, '35', 2, 25, 'SAND4', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(71, 261, 'Sand Medium ( 1⁄4 mm –  1⁄2 mm)', 54, '35', 2, 25, 'SAND3', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(72, 261, 'Sand Coarse (1 mm – 2 mm)', 54, '40', 2, 25, 'SAND5', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(73, 261, 'Crushstone upto 19mm', 54, '40', 2, 25, 'CRUSH2', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(74, 261, 'Crushstone upto 22mm', 54, '40', 2, 25, 'CRUSH3', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(75, 261, 'Crushstone upto 50mm', 54, '110', 2, 25, 'CRUSH7', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(76, 261, 'Natural Stone 25-50mm', 54, '60', 2, 25, 'STONE5', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(77, 261, 'Natural Stone 75-150mm', 54, '65', 2, 25, 'STONE10', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(78, 261, 'Concrete 10MPa', 54, '175', 2, 25, 'CONC10', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(79, 261, 'Concrete 15MPa', 54, '180', 2, 25, 'CONC15', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(80, 261, 'Concrete 20MPa', 54, '185', 2, 25, 'CONC20', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(81, 261, 'Concrete 25MPa', 54, '190', 2, 25, 'CONC25', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(82, 261, 'Concrete 30MPa', 54, '200', 2, 25, 'CONC30', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(83, 261, 'Concrete 35MPa', 54, '220', 2, 25, 'CONC35', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(84, 261, 'Concrete 40MPa', 54, '230', 2, 25, 'CONC40', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(85, 261, 'Concrete 45MPa', 54, '260', 2, 25, 'CONC45', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(86, 261, 'Concrete 50MPa', 54, '300', 2, 25, 'CONC50', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(87, 261, 'Rebar 10mm (3/8in)', 74, '800', 2, 25, 'REBAR10', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(88, 261, 'Rebar 13mm (1/2in)', 74, '800', 2, 25, 'REBAR13', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(89, 261, 'Rebar 16Mm (5/8in)', 74, '800', 2, 25, 'REBAR16', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(90, 261, 'Rebar 19mm (3/4in)', 74, '800', 2, 25, 'REBAR19', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(91, 261, 'Rebar 25mm (1in)', 74, '800', 2, 25, 'REBAR25', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(92, 261, 'Senior Project Manager', 58, '250', 1, 22, 'SPM1', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(93, 261, 'Project Manager', 58, '200', 1, 22, 'PM1', 156, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(94, 261, 'Rebar 22mm (7/8in)', 74, '800', 2, 25, 'REBAR22', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(95, 261, 'Rebar 29mm (1-1/8in)', 74, '900', 2, 25, 'REBAR29', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(96, 261, 'TEST RESOURCE', 64, '0', 18, 46, 'TSTRES', 162, '', '', '', '', '', '', '', '', '', '2017-03-13', '2017-03-13', 0, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(97, 261, 'Project Engineer', 58, '150', 1, 23, 'PE1', 315, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(98, 261, 'Car ', 102, '0', 3, 26, 'CAR001', 162, 'Toyota', 'Corolla', '2017', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(99, 261, 'Dozer', 59, '0', 3, 27, 'DOZ001', 154, 'Caterpillar', 'D8R2', '2004', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(100, 261, 'Dozer', 59, '0', 3, 27, 'DOZ002', 154, 'Caterpillar', 'D10', '1985', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(101, 261, 'Excavator - Crawler ', 59, '0', 3, 27, 'EXCC001', 154, 'Hyundai', 'R140LC-9A', '2014', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(102, 261, 'Excavator - Wheeled', 59, '0', 3, 27, 'EXCW001', 154, 'Komatsu', 'PW220-7', '2012', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(103, 261, 'Backhoe Loader', 59, '0', 3, 26, 'BKLD001', 154, '', '', '', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(104, 261, 'Skid Steer Loader', 59, '0', 3, 26, 'SSL001', 154, 'Bobcat', 'S530', '2017', '', '', '', '', '', '', '2017-03-13', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(105, 28, 'AAwas', 33, '1000', 3, 17, 'AW', 219, 'Muhammad', 'Awais', 'PHP', '0300322222', 'awa@google.com', '453543535453', '546567676', 'www.yahoo.com', '45', '2017-03-14', '2017-03-14', 0, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(106, 261, 'Test Contractor', 64, '0', 5, 32, 'TC', 162, '', '', '', '', '', '', '', '', '', '2017-03-14', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(107, 261, 'Diesel Generator 2500kVA', 102, '7,000,000.00', 3, 28, 'DGS001', 156, 'Siemens', '', '', '', '', '', '', '', '', '2017-03-15', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(108, 261, 'Reinforced Cement Concrete', 54, '150', 4, 55, 'RCC001', 154, '', '', '', '', '', '', '', '', '', '2017-03-17', '0000-00-00', 1, 0, 0, 0, 0, '', ''); INSERT INTO `resources` VALUES(109, 261, 'Plain Cement Concrete', 54, '100', 4, 56, 'PCC001', 154, '', '', '', '', '', '', '', '', '', '2017-03-17', '0000-00-00', 1, 0, 0, 0, 0, '', '');