--
-- Host: pmAnywhere3.db.11472283.hostedresource.com    Database: pmAnywhere3
-- ------------------------------------------------------


--
-- Dumping data for table `internal_personnel`
--
-- WHERE:  internal_personnel_company_id=28

INSERT INTO `internal_personnel` VALUES (50,'Jackson Harry','Jackson Harry','','jackson.isbd@gmail.com',0,'Engineer','JACKSON','JHE','1234567890',39,'Full Control','2013-09-10',0,28,'','','External','',''),(62,'Sohail Consolidate','Sohail Consolidate','','ms1sm@hotmail.com',0,'CEO','SM2','SM2','1234567890',53,'Consolidate','2013-12-09',0,28,'','','External','',''),(68,'Sohail Comment','Sohail','Review','ms1sm@hotmail.com',1,'engr','SMR','SMR','SMR',219,'Comment','2014-01-21',0,28,'','','External','',''),(69,'Salman Ahmed','Salman ','Ahmed','salman_zaibi15@yahoo.com',1,'Engineer','SALMAN','SAH','1234567890',39,'Full Control','2014-01-25',1,28,'','','Internal','Team',''),(77,'Wahid Khan ','Wahid Khan ','','wahid.k@utrade.co',1,'CTO','WAHIDK','WKN','WAHIDKHAN.',39,'Full Control','2014-05-03',0,28,'','','External','',''),(82,'Sarfaraz','Sarfaraz','','sarfraz.m@utrade.co',1,'Developer','SARFARAZ','SAF','1234567890',39,'Full Control','2014-06-02',2,28,'','','External','',''),(197,'cn1 cn1','cn1','cn1','saloo_pk@hotmail.com',1,'','cn1','cn1','cn.1',251,'Consolidate','2015-07-09',1,28,'','','External','',''),(198,'Review1 Review1','Review1','Review1','Review1@Review1.com',0,'Review1','Review1','Rev','Review1',39,'Comment','2015-07-09',0,28,'','','External','',''),(199,'draft1 draft1','draft1','draft1','salmanzaibi15@gmail.com',1,'draft1','DRA','DRA','DRA',39,'Drafting','2015-07-20',2,28,'','','External','',''),(202,'Tariq Karim','Tariq','Karim','joseph.gatelogix@gmail.com',1,'Dev','Tariq','taq','123456',38,'Consolidate','',0,28,'123456789','','External','',''),(203,'OKOK OO','OKOK','OO','OKOK',1,'','','','',0,'','',0,28,'03335366807','','External','',''),(220,'Cabot Solutions','Cabot','Solutions','bindhu.a@cabotsolutions.com',1,'IT','cabot','CBT','solutions',38,'Consolidate','2016-12-01',0,28,'','','External','',''),(228,'Muhammad Awais','Muhammad','Awais','awais_123@hotmail.com',0,'Test Desa','awais_123','tes','123456',136,'Full Control','2017-03-09',2,28,'55-666-777','','External','',''),(229,'SMR SMR','SMR','SMR','saloo_pk@hotmail.com',0,'SMR','SMR1','111','SMR',219,'Comment','2017-04-17',2,28,'','','External','',''),(230,'Imran Moughal','Imran','Moughal','im1sa@hotmail.com',1,'GM','im1sa','IMS','1234567890',309,'Comment','2017-05-05',2,28,'','','External','',''),(231,'Muhammad Awais','Muhammad','Awais','awais_123@hotmail.com',1,'Developer','mawais','MAW','123456',250,'Comment','2017-05-05',1,28,'','','External','',''),(232,'Khalil Nayyer','Khalil','Nayyer','mk1nm@hotmail.com',1,'dm','mk1nm','mk1','mk1',322,'Comment','2017-05-05',1,28,'','','External','',''),(233,'MuhammadE AwaisE','MuhammadE','AwaisE','awais_123@hotmail.comds',0,'Test DesaE','awais_125','awa','123',219,'Comment','2017-05-05',1,28,'','','External','',''),(237,'TestFirstName1 TestLastName1','TestFirstName1','TestLastName1','test@test.com',1,'Test Designation 1','dra1','DR1','dra.1',0,'Drafting','2017-05-05',1,28,'','','Internal','Client','18'),(242,'External Developer','External','Developer','one@one-ppm.com',1,'Developer','Developer1','DE1','1.2',40,'Comment','2017-07-12',1,28,'','','External','Vendor',''),(248,'Adeel Mir','Adeel','Mir','mr.ad143@gmail.com',1,'Software Engineer','Adeel','A-D','trojan123',39,'Full Control','2018-01-31',1,28,'','03445396424','Internal','Team',''),(255,'tester 1','tester','1','value@alyousefi.com',0,'','tester1','ttt','tester.1',219,'Comment','2018-03-17',1,28,'','','External','Consultant',''),(279,'Self Self','Self','Self','self@self.com',0,'Selfie','self','sel','self',306,'Comment','2018-05-18',1,28,'','','Internal','Consultant','20'),(280,'Zeesahn Ur Rehman','Zeesahn','Ur Rehman','zeeshan.rehman@gmail.com',1,'CEO','zeeshan.rehman@gmail.com','ZUR','ZeeshanPM',262,'Consolidate','2018-06-23',1,28,'','','Internal','',''),(281,'SalmanR Ahmed','SalmanR','Ahmed','salmanzaibi15@gmail.com',1,'Project Manager','salmanzaibi15@gmail.com','SAR','salmanRPM',39,'Comment','2018-06-23',1,28,'','','Internal','','');


