|
# Entry for A.K.CONSTRUTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('akconstructionprojects002@gmail.com', 'PPE 2', 'A.K.CONSTRUTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'akconstructionprojects002', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2105');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2105');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2105');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2105');
|
|
|
|
# Entry for AARMAN UDYOG
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aarman.udyog@gmail.com', 'PPE 3', 'AARMAN UDYOG', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aarman.udyog', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2323');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2123');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2123');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2123');
|
|
|
|
# Entry for AARVI ENCON LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('janasanjaykumar@yahoo.in', 'PPE 4', 'AARVI ENCON LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'janasanjaykumar', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2107');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2107');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2107');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2107');
|
|
|
|
# Entry for AASHA
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ashaa201040@gmail.com', 'PPE 5', 'AASHA', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ashaa201040', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2324');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2324');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2324');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2324');
|
|
|
|
# Entry for AAXIS NANO TECHNOLOGIES PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('service.east@aaxisnano.com', 'PPE 6', 'AAXIS NANO TECHNOLOGIES PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'service.east', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2325');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2325');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2325');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2325');
|
|
|
|
# Entry for ABB INDIA LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sanjoy.adhikary@in.abb.com', 'PPE 7', 'ABB INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sanjoy.adhikary', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2110');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2110');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2110');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2110');
|
|
|
|
# Entry for AFG COMBUSTION PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@afgcombustion.com', 'PPE 8', 'AFG COMBUSTION PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2111');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2111');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2111');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2111');
|
|
|
|
# Entry for AGASTI TANK WORKS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('projects@agasticorporation.com', 'PPE 9', 'AGASTI TANK WORKS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'projects', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2112');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2112');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2112');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2112');
|
|
|
|
# Entry for ALERT SERVICES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subham.nayak@cotecna.co.in', 'PPE 10', 'ALERT SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subham.nayak', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2113');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2113');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2113');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2113');
|
|
|
|
# Entry for ALGODEX SYSTEMS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sandip.chavan@algodex.net', 'PPE 11', 'ALGODEX SYSTEMS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sandip.chavan', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2114');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2114');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2114');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2114');
|
|
|
|
# Entry for ALMEISAN ENERGY
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('iamsuman.mallik@gmail.com', 'PPE 12', 'ALMEISAN ENERGY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'iamsuman.mallik', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2115');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2115');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2115');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2115');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dhritinandang@gmail.com', 'PPE 13', 'AMAR DYUTI X RAY CLINIC', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dhritinandang', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2116');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2116');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2116');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2116');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('logistics@ame.net.in', 'PPE 14', 'AME INFRALOGISTICS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'logistics', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2117');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2117');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2117');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2117');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@anasyssolutions.com', 'PPE 15', 'ANASYS SOLUTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2118');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2118');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2118');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2118');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pradipb@anguil.com', 'PPE 16', 'ANGUIL ENVIRONMENTAL SYSTEMS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pradipb', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2119');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2119');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2119');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2119');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anikethhaldia@rediffmail.com', 'PPE 17', 'ANIKETH ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anikethhaldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2120');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2120');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2120');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2120');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hr@arcreation.co.in', 'PPE 18', 'ARCREATION DESIGN PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hr', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2121');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2121');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2121');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2121');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ardhendubikasdas@yahoo.com', 'PPE 19', 'ARDHENDU BIKAS DAS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ardhendubikasdas', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2122');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2122');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2122');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2122');
|
|
|
|
# Entry for ARUDRA ENGINEERS PRIVATE LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ajithkumar34725@gmail.com', 'PPE 20', 'ARUDRA ENGINEERS PRIVATE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ajithkumar34725', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2123');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2123');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2123');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2123');
|
|
|
|
# Entry for ASIATICS INFRATECHH PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@asiaticsinfratechh.com', 'PPE 21', 'ASIATICS INFRATECHH PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2124');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2124');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2124');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2124');
|
|
|
|
# Entry for B.N.P. ENGINEERING
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info.bnp2015@gmail.com', 'PPE 22', 'B.N.P. ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info.bnp2015', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2125');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2125');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2125');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2125');
|
|
|
|
# Entry for B.P.ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kalyansinharoy@yahoo.co.in', 'PPE 23', 'B.P.ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kalyansinharoy', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2126');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2126');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2126');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2126');
|
|
|
|
# Entry for BAPI ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sukumardolai7@gmail.com', 'PPE 24', 'BAPI ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sukumardolai7', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2127');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2127');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2127');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2127');
|
|
|
|
# Entry for BEAUTY OF NATURE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tapan_beautyofnature@rediffmail.com', 'PPE 25', 'BEAUTY OF NATURE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tapan_beautyofnature', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2128');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2128');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2128');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2128');
|
|
|
|
# Entry for BERA ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bera.enterprise@yahoo.in', 'PPE 26', 'BERA ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bera.enterprise', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2129');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2129');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2129');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2129');
|
|
|
|
# Entry for BHARAT ENGINEERING CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bechplproject18@gmail.com', 'PPE 27', 'BHARAT ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bechplproject18', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2130');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2130');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2130');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2130');
|
|
|
|
# Entry for BHARAT MOTOR
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bharatmotor2@gmail.com', 'PPE 28', 'BHARAT MOTOR', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bharatmotor2', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2131');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2131');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2131');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2131');
|
|
|
|
# Entry for BISTECH SOLUTIONS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pijushgolui1995@gmail.com', 'PPE 29', 'BISTECH SOLUTIONS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pijushgolui1995', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2132');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2132');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2132');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2132');
|
|
|
|
# Entry for BONACE ENGINEERS PVT. LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('vivek.gautam@bonace.org', 'PPE 30', 'BONACE ENGINEERS PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'vivek.gautam', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2133');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2133');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2133');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2133');
|
|
|
|
# Entry for BRIDGE & ROOF CO. (INDIA) LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bandr61026@gmail.com', 'PPE 31', 'BRIDGE & ROOF CO. (INDIA) LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bandr61026', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2134');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2134');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2134');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2134');
|
|
|
|
# Entry for BSS TECH CP (INDIA) PVT. LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anjan.elct@gmail.com', 'PPE 32', 'BSS TECH CP (INDIA) PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anjan.elct', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2135');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2135');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2135');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2135');
|
|
|
|
# Entry for BURCKHARDT COMPRESSION INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('amitkumar.singh@burckhardtcompression.com', 'PPE 33', 'BURCKHARDT COMPRESSION INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'amitkumar.singh', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2136');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2136');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2136');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2136');
|
|
|
|
# Entry for BUSCH VACUUM INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manash.sarkar@buschindia.com', 'PPE 34', 'BUSCH VACUUM INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manash.sarkar', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2137');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2137');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2137');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2137');
|
|
|
|
# Entry for CARRION AIR COOLING
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gm.carrionaircooling@gmail.com', 'PPE 35', 'CARRION AIR COOLING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gm.carrionaircooling', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2138');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2138');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2138');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2138');
|
|
|
|
# Entry for CHEMBON WATER TECHNOLOGIES LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('soumik.banerjee@chembondwater.com', 'PPE 36', 'CHEMBON WATER TECHNOLOGIES LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'soumik.banerjee', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2139');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2139');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2139');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2139');
|
|
|
|
# Entry for CHETAN CORPORATION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('chetancorpo@gmail.com', 'PPE 37', 'CHETAN CORPORATION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'chetancorpo', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2140');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2140');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2140');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2140');
|
|
|
|
# Entry for CIRIA INDIA LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Ajeet.Singh@morganplc.com', 'PPE 38', 'CIRIA INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Ajeet.Singh', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2141');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2141');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2141');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2141');
|
|
|
|
# Entry for CITY CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('citycons.haldia@gmail.com', 'PPE 39', 'CITY CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'citycons.haldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2142');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2142');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2142');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2142');
|
|
|
|
# Entry for CONVERGENCE SOLUTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sankalan@convergencesolutions.in', 'PPE 40', 'CONVERGENCE SOLUTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sankalan', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2143');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2143');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2143');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2143');
|
|
|
|
# Entry for COOLING POINT
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajumaity7890@gmail.com', 'PPE 41', 'COOLING POINT', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajumaity7890', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2144');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2144');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2144');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2144');
|
|
|
|
# Entry for COTECNA INSPECTION (I) PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Siddhartha.Mondal@cotecna.co.in', 'PPE 42', 'COTECNA INSPECTION (I) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Siddhartha.Mondal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2145');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2145');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2145');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2145');
|
|
|
|
# Entry for D.M.P. NIRMAN PRIVATE LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dmpnirman@yahoo.co.in', 'PPE 43', 'D.M.P. NIRMAN PRIVATE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dmpnirman', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2146');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2146');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2146');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2146');
|
|
|
|
# Entry for DEBRAJ SURVEY CONSULTANCY
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('debraj.survey@gmail.com', 'PPE 44', 'DEBRAJ SURVEY CONSULTANCY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'debraj.survey', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2147');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2147');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2147');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2147');
|
|
|
|
# Entry for DEMECH CHEMICAL PRODUCTS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bimal@demechchemical.com', 'PPE 45', 'DEMECH CHEMICAL PRODUCTS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bimal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2148');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2148');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2148');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2148');
|
|
|
|
# Entry for DES TECHNICO LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mrigankadtpl16@gmail.com', 'PPE 46', 'DES TECHNICO LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mrigankadtpl16', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2149');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2149');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2149');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2149');
|
|
|
|
# Entry for DEVELOPMENT CONSULTANT PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jayantashil88@gmail.com', 'PPE 47', 'DEVELOPMENT CONSULTANT PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jayantashil88', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2150');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2150');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2150');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2150');
|
|
|
|
# Entry for DHOON AUDIO VISUAL PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('support@dhoon.in', 'PPE 48', 'DHOON AUDIO VISUAL PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'support', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2151');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2151');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2151');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2151');
|
|
|
|
# Entry for DHP HEAVYLIFT SOLUTIONS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('chandrakant.rathod@dhpheavy.com', 'PPE 49', 'DHP HEAVYLIFT SOLUTIONS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'chandrakant.rathod', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2152');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2152');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2152');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2152');
|
|
|
|
# Entry for DK ENGINEERING CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('msdkenggconshaldia@rediffmail.com', 'PPE 50', 'DK ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'msdkenggconshaldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2153');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2153');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2153');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2153');
|
|
|
|
# Entry for DORF KETAL CHEMICAL (I) PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('priyanka.bhattacharjee@dorfketal.com', 'PPE 51', 'DORF KETAL CHEMICAL (I) PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'priyanka.bhattacharjee', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2154');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2154');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2154');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2154');
|
|
|
|
# Entry for ELECTROMECH ENGINEERING (THERMAX LTD)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('cs.enterprises1695@gmail.com', 'PPE 52', 'ELECTROMECH ENGINEERING (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'cs.enterprises1695', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2155');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2155');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2155');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2155');
|
|
|
|
# Entry for EMDADIYA INFRA PROJECTS PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('eminfra123@gmail.com', 'PPE 53', 'EMDADIYA INFRA PROJECTS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'eminfra123', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2156');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2156');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2156');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2156');
|
|
|
|
# Entry for ENDRESS HAUSER INDIA PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sourabh.bag@endress.com', 'PPE 54', 'ENDRESS HAUSER INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sourabh.bag', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2157');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2157');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2157');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2157');
|
|
|
|
# Entry for ENVEA INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('s.ghosh@envea.global', 'PPE 55', 'ENVEA INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 's.ghosh', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2158');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2158');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2158');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2158');
|
|
|
|
# Entry for EQUINOX SOFTWARE AND SERVICES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sachinpawar45@gmail.com', 'PPE 56', 'EQUINOX SOFTWARE AND SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sachinpawar45', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2159');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2159');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2159');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2159');
|
|
|
|
# Entry for ERNST & YOUNG LLP
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('om.nagumantri@in.ey.com', 'PPE 57', 'ERNST & YOUNG LLP', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'om.nagumantri', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2160');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2160');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2160');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2160');
|
|
|
|
# Entry for ESTEEM PROJECTS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('269@esteem.co.in', 'PPE 58', 'ESTEEM PROJECTS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', '269', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2161');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2161');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2161');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2161');
|
|
|
|
# Entry for ETEK ENGINEERING
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jsk926496@gmail.com', 'PPE 59', 'ETEK ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jsk926496', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2162');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2162');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2162');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2162');
|
|
|
|
# Entry for EXIDE INDUSTRIES LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Prosenjit.R@exide.co.in', 'PPE 60', 'EXIDE INDUSTRIES LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Prosenjit.R', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2163');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2163');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2163');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2163');
|
|
|
|
# Entry for FLOWSERVE SANMAR PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pd13@sanmargroup.com', 'PPE 61', 'FLOWSERVE SANMAR PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pd13', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2164');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2164');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2164');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2164');
|
|
|
|
# Entry for FORAYS SERVICES & CONSTRUCTIONS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('venugopal@forays.co.in', 'PPE 62', 'FORAYS SERVICES & CONSTRUCTIONS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'venugopal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2165');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2165');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2165');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2165');
|
|
|
|
# Entry for FORBES MARSHALL
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('lokeshsingh@forbesmarshall.com', 'PPE 63', 'FORBES MARSHALL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'lokeshsingh', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2166');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2166');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2166');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2166');
|
|
|
|
# Entry for FORTUNA IMPEX PVT.LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('timeoffice.support@hpl.co.in', 'PPE 64', 'FORTUNA IMPEX PVT.LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'timeoffice.support', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2167');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2167');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2167');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2167');
|
|
|
|
# Entry for FOX SOLUTION PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sudipto.sardar@foxindia.net', 'PPE 65', 'FOX SOLUTION PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sudipto.sardar', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2168');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2168');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2168');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2168');
|
|
|
|
# Entry for G4S SECURE SOLUTIONS (I) PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bappa.maulik@in.g4s.com', 'PPE 66', 'G4S SECURE SOLUTIONS (I) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bappa.maulik', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2169');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2169');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2169');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2169');
|
|
|
|
# Entry for GAINWELL COMMOSALES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('somnath.mondal@gainwellindia.com', 'PPE 67', 'GAINWELL COMMOSALES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'somnath.mondal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2170');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2170');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2170');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2170');
|
|
|
|
# Entry for GARDNER DENVER ENGINEERED PRODUCTS INDIA PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dwaipayan.das@irco.com', 'PPE 68', 'GARDNER DENVER ENGINEERED PRODUCTS INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dwaipayan.das', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2171');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2171');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2171');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2171');
|
|
|
|
# Entry for GARUDA POWER LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('surojit.manna@garudapower.com', 'PPE 69', 'GARUDA POWER LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'surojit.manna', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2172');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2172');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2172');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2172');
|
|
|
|
# Entry for GEE BEE NETWORK PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pgbagari@gbnetwork.co.in', 'PPE 70', 'GEE BEE NETWORK PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pgbagari', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2173');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2173');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2173');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2173');
|
|
|
|
# Entry for GIRISH CHANDRA GHOSH & GGS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gcg.ggs.kol@gmail.com', 'PPE 71', 'GIRISH CHANDRA GHOSH & GGS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gcg.ggs.kol', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2174');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2174');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2174');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2174');
|
|
|
|
# Entry for GLOBAL INTREGATED SYSTEMS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('diliphazra87@gmail.com', 'PPE 72', 'GLOBAL INTREGATED SYSTEMS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'diliphazra87', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2175');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2175');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2175');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2175');
|
|
|
|
# Entry for GOUTAM TRADING
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('goutamtrading@gmail.com', 'PPE 73', 'GOUTAM TRADING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'goutamtrading', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2176');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2176');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2176');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2176');
|
|
|
|
# Entry for GRIP CONSULTING ENGINEERS LLP
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('utpal.ray@gripconsultant.com', 'PPE 74', 'GRIP CONSULTING ENGINEERS LLP', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'utpal.ray', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2177');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2177');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2177');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2177');
|
|
|
|
# Entry for GRIVETY GLOBAL PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subhankarkarmakar023@gmail.com', 'PPE 75', 'GRIVETY GLOBAL PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subhankarkarmakar023', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2178');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2178');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2178');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2178');
|
|
|
|
# Entry for HAL OFFSHORE LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('admin.haldia@haloffshore.com', 'PPE 76', 'HAL OFFSHORE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'admin.haldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2179');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2179');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2179');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2179');
|
|
|
|
# Entry for HALDIA SEVA SADAN
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tarunpal2011@gmail.com', 'PPE 77', 'HALDIA SEVA SADAN', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tarunpal2011', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2180');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2180');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2180');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2180');
|
|
|
|
# Entry for HALDIA SHEET METAL WORKS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('haldia.sheet.2009@gmail.com', 'PPE 78', 'HALDIA SHEET METAL WORKS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'haldia.sheet.2009', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2181');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2181');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2181');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2181');
|
|
|
|
# Entry for HBL ENGINEERING LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('skarimullah@hbl.in', 'PPE 79', 'HBL ENGINEERING LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'skarimullah', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2182');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2182');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2182');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2182');
|
|
|
|
# Entry for HIMOYA CORROSION TECHNOLOGY PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('himoyacorrosion@gmail.com', 'PPE 80', 'HIMOYA CORROSION TECHNOLOGY PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'himoyacorrosion', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2183');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2183');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2183');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2183');
|
|
|
|
# Entry for HONEYWELL AUTOMATION INDIA LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('team.haldia@gmail.com', 'PPE 81', 'HONEYWELL AUTOMATION INDIA LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'team.haldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2184');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2184');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2184');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2184');
|
|
|
|
# Entry for HRITI ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('monig@eisec.com', 'PPE 82', 'HRITI ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'monig', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2185');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2185');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2185');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2185');
|
|
|
|
# Entry for IBM
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('arunray@in.ibm.com', 'PPE 83', 'IBM', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'arunray', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2186');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2186');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2186');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2186');
|
|
|
|
# Entry for IBM - CREATIVE INFO LINK PRIVATE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Projectmanager.ifms@hpl.co.in', 'PPE 84', 'IBM - CREATIVE INFO LINK PRIVATE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Projectmanager.ifms', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2187');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2187');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2187');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2187');
|
|
|
|
# Entry for IFB AGRO INDUSTRIES LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajesh_mehra@ifbagro.in', 'PPE 85', 'IFB AGRO INDUSTRIES LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajesh_mehra', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2188');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2188');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2188');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2188');
|
|
|
|
# Entry for INDUSTRIAL PLANT & SERVICE MALAYSIA BERHAD (MHI)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('saya.kobayashi@mcm.mitsubishicorp.com', 'PPE 86', 'INDUSTRIAL PLANT & SERVICE MALAYSIA BERHAD (MHI)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'saya.kobayashi', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2189');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2189');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2189');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2189');
|
|
|
|
# Entry for INDUSTRIAL SERVICES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('indus_8@yahoo.com', 'PPE 87', 'INDUSTRIAL SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'indus_8', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2190');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2190');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2190');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2190');
|
|
|
|
# Entry for INSPECTION SURVEY & SURVELLANCE(INDIA)PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('insurvey1980@gmail.com', 'PPE 88', 'INSPECTION SURVEY & SURVELLANCE(INDIA)PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'insurvey1980', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2191');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2191');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2191');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2191');
|
|
|
|
# Entry for INSPECTORATE GRIFTH INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ganesh.bera@bureauveritas.com', 'PPE 89', 'INSPECTORATE GRIFTH INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ganesh.bera', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2192');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2192');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2192');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2192');
|
|
|
|
# Entry for INSULREF TECHNOLOGIES PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('khatua.arindam@gmail.com', 'PPE 90', 'INSULREF TECHNOLOGIES PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'khatua.arindam', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2193');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2193');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2193');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2193');
|
|
|
|
# Entry for INTERTEK INDIA PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('monig@eisec.com', 'PPE 91', 'INTERTEK INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'monig', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2194');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2194');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2194');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2194');
|
|
|
|
# Entry for INVINCIBLE INDIAN CONSTRUCTION PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('iicpl.project@gmail.com', 'PPE 92', 'INVINCIBLE INDIAN CONSTRUCTION PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'iicpl.project', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2195');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2195');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2195');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2195');
|
|
|
|
# Entry for ION EXCHANGE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mailmearnabroy79@rediffmail.com', 'PPE 93', 'ION EXCHANGE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mailmearnabroy79', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2196');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2196');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2196');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2196');
|
|
|
|
# Entry for IR TECHNOLOGY SERVICES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('u_das@irtech.in', 'PPE 94', 'IR TECHNOLOGY SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'u_das', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2197');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2197');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2197');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2197');
|
|
|
|
# Entry for JANA INDUSTRIES & CO.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subhaschandrajana.2012@gmail.com', 'PPE 95', 'JANA INDUSTRIES & CO.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subhaschandrajana.2012', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2198');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2198');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2198');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2198');
|
|
|
|
# Entry for JMD ENTERPRISES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pipeproject-bomsupport@isgecynr.com', 'PPE 96', 'JMD ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pipeproject-bomsupport', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2199');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2199');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2199');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2199');
|
|
|
|
# Entry for JOHNNY & ROHNNY INFRA. PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('obidur.r@johnnyrohnny.com', 'PPE 97', 'JOHNNY & ROHNNY INFRA. PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'obidur.r', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2200');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2200');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2200');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2200');
|
|
|
|
# Entry for JOY MAA TARA ENTERPRISE (DCPL)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jayantashil88@gmail.com', 'PPE 98', 'JOY MAA TARA ENTERPRISE (DCPL)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jayantashil88', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2201');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2201');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2201');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2201');
|
|
|
|
# Entry for KARAN CONSTRUCTION COMPANY
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kcchpl123@gmail.com', 'PPE 99', 'KARAN CONSTRUCTION COMPANY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kcchpl123', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2202');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2202');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2202');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2202');
|
|
|
|
# Entry for KONE ELEVATOR INDIA PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kartikchandra.senapati@kone.com', 'PPE 100', 'KONE ELEVATOR INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kartikchandra.senapati', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2203');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2203');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2203');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2203');
|
|
|
|
# Entry for LEAK PROOF ENGINEERING (I) PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kolkata@leakproofseals.com', 'PPE 101', 'LEAK PROOF ENGINEERING (I) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kolkata', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2204');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2204');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2204');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2204');
|
|
|
|
# Entry for LLOYD INSULATIONS ( I ) LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('chandansinghh65@gmail.com', 'PPE 102', 'LLOYD INSULATIONS ( I ) LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'chandansinghh65', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2205');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2205');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2205');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2205');
|
|
|
|
# Entry for LTC INFRASTRUCTURE PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hpl.ltc@gmail.com', 'PPE 103', 'LTC INFRASTRUCTURE PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hpl.ltc', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2206');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2206');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2206');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2206');
|
|
|
|
# Entry for LUMMUS TECHNOLOGY
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('riazur.rahman@lummustech.com', 'PPE 104', 'LUMMUS TECHNOLOGY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'riazur.rahman', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2207');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2207');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2207');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2207');
|
|
|
|
# Entry for M M CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mmchaldia@gmail.com', 'PPE 105', 'M M CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mmchaldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2208');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2208');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2208');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2208');
|
|
|
|
# Entry for M S CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('msconstructionhpl@yahoo.com', 'PPE 106', 'M S CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'msconstructionhpl', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2209');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2209');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2209');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2209');
|
|
|
|
# Entry for M.M. POWER
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('prosenjitchanda1985@gmail.com', 'PPE 107', 'M.M. POWER', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'prosenjitchanda1985', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2210');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2210');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2210');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2210');
|
|
|
|
# Entry for M.S ENGINEERING
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mse.haldia@gmail.com', 'PPE 108', 'M.S ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mse.haldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2211');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2211');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2211');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2211');
|
|
|
|
# Entry for M/S ENGINEERS INDIA LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pronay.naskar@hpl.co.in', 'PPE 109', 'M/S ENGINEERS INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pronay.naskar', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2212');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2212');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2212');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2212');
|
|
|
|
# Entry for M/S HALDIA TRAVELS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('haldiatravels@gmail.com', 'PPE 110', 'M/S HALDIA TRAVELS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'haldiatravels', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2213');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2213');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2213');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2213');
|
|
|
|
# Entry for MAA ENTERPRISES (ION EXCHANGE)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('maa.enterprises2222@gmail.com', 'PPE 111', 'MAA ENTERPRISES (ION EXCHANGE)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'maa.enterprises2222', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2214');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2214');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2214');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2214');
|
|
|
|
# Entry for MACO CORPORATION (INDIA) PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gcde@macocorporation.com', 'PPE 112', 'MACO CORPORATION (INDIA) PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gcde', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2215');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_key`, `user_key`) VALUES ('1110', '2215');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2215');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2215');
|
|
|
|
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pmsudhanshu@magicrot.com', 'PPE 113', 'MAGICROT INDUSTRIAL SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pmsudhanshu', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2216');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2216');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2216');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2216');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mahamayaconstn@gmail.com', 'PPE 114', 'MAHAMAYA CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mahamayaconstn', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2217');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2217');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2217');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2217');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('indus_8@yahoo.com', 'PPE 115', 'MANDAYS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'indus_8', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2218');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2218');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2218');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2218');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sumit.shil@rotostat.in', 'PPE 116', 'MANPOWERGROUP SERVICES INDIA PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sumit.shil', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2219');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2219');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2219');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2219');
|
|
|
|
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mastek.haldiap123@mastekengineering.com', 'PPE 117', 'MASTEK ENGINEERING PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mastek.haldiap123', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2220');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2220');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2220');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2220');
|
|
|
|
# Entry for MATRI ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subhasdas74@gmail.com', 'PPE 118', 'MATRI ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subhasdas74', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2221');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2221');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2221');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2221');
|
|
|
|
# Entry for MATRI PROJECTS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('matriproject2021@gmail.com', 'PPE 119', 'MATRI PROJECTS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'matriproject2021', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2222');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2222');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2222');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2222');
|
|
|
|
# Entry for MAXIML LABS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rohit.nowal@maximl.com', 'PPE 120', 'MAXIML LABS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rohit.nowal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2223');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2223');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2223');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2223');
|
|
|
|
# Entry for MBS ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bghoshmbs@yahoo.com', 'PPE 121', 'MBS ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bghoshmbs', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2224');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2224');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2224');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2224');
|
|
|
|
# Entry for MICRO CLINICAL LABORATORY & DIAGNOSTIC CENTRE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('microclinicallab@gmail.com', 'PPE 122', 'MICRO CLINICAL LABORATORY & DIAGNOSTIC CENTRE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'microclinicallab', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2225');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2225');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2225');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2225');
|
|
|
|
# Entry for MKS ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aftabansarisbd15@gmail.com', 'PPE 123', 'MKS ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aftabansarisbd15', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2226');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2226');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2226');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2226');
|
|
|
|
# Entry for N G CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ng.construction76@gmail.com', 'PPE 124', 'N G CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ng.construction76', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2227');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2227');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2227');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2227');
|
|
|
|
# Entry for NALCO WATER INDIA LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jsaini@ecolab.com', 'PPE 125', 'NALCO WATER INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jsaini', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2228');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2228');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2228');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2228');
|
|
|
|
# Entry for NBC ASSOCIATES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sbalvinder654@gmail.com', 'PPE 126', 'NBC ASSOCIATES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sbalvinder654', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2229');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2229');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2229');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2229');
|
|
|
|
# Entry for NICCO ENGINEERING SERVICES LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mrthander79@gmail.com', 'PPE 127', 'NICCO ENGINEERING SERVICES LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mrthander79', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2230');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2230');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2230');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2230');
|
|
|
|
# Entry for NMD ENGG. WORKS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('nmdengwork@gmail.com', 'PPE 128', 'NMD ENGG. WORKS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'nmdengwork', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2231');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2231');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2231');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2231');
|
|
|
|
# Entry for ONSHORE CONTRUCTION CO. PVT. LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('onshore.hpl@onshoreconstruction.com', 'PPE 129', 'ONSHORE CONTRUCTION CO. PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'onshore.hpl', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2232');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2232');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2232');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2232');
|
|
|
|
# Entry for PAHARPUR COOLING TOWERS LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('krishnaprasad.maity@paharpur.com', 'PPE 130', 'PAHARPUR COOLING TOWERS LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'krishnaprasad.maity', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2233');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2233');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2233');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2233');
|
|
|
|
# Entry for PARISHRAM RESOURCES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('alok.gupta@sarens.in', 'PPE 131', 'PARISHRAM RESOURCES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'alok.gupta', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2234');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2234');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2234');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2234');
|
|
|
|
# Entry for PARTHA ENGINEERS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('newparthaengineers@gmail.com', 'PPE 132', 'PARTHA ENGINEERS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'newparthaengineers', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2235');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2235');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2235');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2235');
|
|
|
|
# Entry for PETROCHEM ENGINEERING CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('petrochem_construction@rediffmail.com', 'PPE 133', 'PETROCHEM ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'petrochem_construction', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2236');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2236');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2236');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2236');
|
|
|
|
# Entry for PETRODEK SYSTEM
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dk.raj0563@gmail.com', 'PPE 134', 'PETRODEK SYSTEM', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dk.raj0563', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2237');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2237');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2237');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2237');
|
|
|
|
# Entry for PHILS HEAVY ENGINEERING PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('site@philsengg.com', 'PPE 135', 'PHILS HEAVY ENGINEERING PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'site', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2238');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2238');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2238');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2238');
|
|
|
|
# Entry for PIONEER SAFETY INDUSTRIES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pioneersafetyindustries@gmail.com', 'PPE 136', 'PIONEER SAFETY INDUSTRIES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pioneersafetyindustries', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2239');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2239');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2239');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2239');
|
|
|
|
# Entry for PLANT TECHNOLOGY SERVICES (INDIA) PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sales.in@pts.group', 'PPE 137', 'PLANT TECHNOLOGY SERVICES (INDIA) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sales.in', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2240');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2240');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2240');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2240');
|
|
|
|
# Entry for PNP ENGINEERING WORKS PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pnpiso@yahoo.in', 'PPE 138', 'PNP ENGINEERING WORKS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pnpiso', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2241');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2241');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2241');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2241');
|
|
|
|
# Entry for PORTEX INDUSTRIAL SERVICES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('akarshadey83@gmail.com', 'PPE 139', 'PORTEX INDUSTRIAL SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'akarshadey83', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2242');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2242');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2242');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2242');
|
|
|
|
# Entry for POWER ENGINEERING
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('power.engineering08@gmail.com', 'PPE 140', 'POWER ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'power.engineering08', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2243');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2243');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2243');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2243');
|
|
|
|
# Entry for POWERGAIN ENGINEERS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sumanroy@powergainengineers.com', 'PPE 141', 'POWERGAIN ENGINEERS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sumanroy', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2244');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2244');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2244');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2244');
|
|
|
|
# Entry for PRABHA CONTINUOUS UTILITY SERVICE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hpl.pcus@gmail.com', 'PPE 142', 'PRABHA CONTINUOUS UTILITY SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hpl.pcus', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2245');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2245');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2245');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2245');
|
|
|
|
# Entry for PREMIUM PEST MANAGEMENT SERVICES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('premiumpest19@gmail.com', 'PPE 143', 'PREMIUM PEST MANAGEMENT SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'premiumpest19', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2246');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2246');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2246');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2246');
|
|
|
|
# Entry for PRESIDENCY RUBBER MILLS PVT. LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('prmrubber@gmail.com', 'PPE 144', 'PRESIDENCY RUBBER MILLS PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'prmrubber', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2247');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2247');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2247');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2247');
|
|
|
|
# Entry for PROFICIENT KILN SERVICES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manoj.pandey@proficientkiln.com', 'PPE 145', 'PROFICIENT KILN SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manoj.pandey', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2248');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2248');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2248');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2248');
|
|
|
|
# Entry for PROSAFE AUTOMATION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bablu03052015@gmail.com', 'PPE 146', 'PROSAFE AUTOMATION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bablu03052015', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2249');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2249');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2249');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2249');
|
|
|
|
# Entry for PVS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('haldia@pvspl.net', 'PPE 147', 'PVS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'haldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2250');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2250');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2250');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2250');
|
|
|
|
# Entry for RADHE RADHE ENTERPRISE (THERMAX LTD)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sudip.mondal357@gmail.com', 'PPE 148', 'RADHE RADHE ENTERPRISE (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sudip.mondal357', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2251');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2251');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2251');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2251');
|
|
|
|
# Entry for RAJ CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajconstruction.haldia.1@gmail.com', 'PPE 149', 'RAJ CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajconstruction.haldia.1', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2252');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2252');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2252');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2252');
|
|
|
|
# Entry for RAMESHWAR ENTERPRISES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ms.wahidkhan786@gmail.com', 'PPE 150', 'RAMESHWAR ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ms.wahidkhan786', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2253');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2253');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2253');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2253');
|
|
|
|
# Entry for RANDSTAD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('soumen.cni@gmail.com', 'PPE 151', 'RANDSTAD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'soumen.cni', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2254');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2254');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2254');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2254');
|
|
|
|
# Entry for RSM ASTUTE CONSULTING PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ashok.nat@rsmindia.in', 'PPE 152', 'RSM ASTUTE CONSULTING PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ashok.nat', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2255');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2255');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2255');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2255');
|
|
|
|
# Entry for S & IB SERVICES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('operations.rob@sibservices.in', 'PPE 153', 'S & IB SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'operations.rob', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2256');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2256');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2256');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2256');
|
|
|
|
# Entry for S B ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('brihaspatipradhan130@gmail.com', 'PPE 154', 'S B ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'brihaspatipradhan130', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2257');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2257');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2257');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2257');
|
|
|
|
# Entry for S B S CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sbscon94@gmail.com', 'PPE 155', 'S B S CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sbscon94', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2258');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2258');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2258');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2258');
|
|
|
|
# Entry for S S POWER (THERMAX LTD)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sr.sspower@gmail.com', 'PPE 156', 'S S POWER (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sr.sspower', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2259');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2259');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2259');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2259');
|
|
|
|
# Entry for S. SAYERS & CO.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ssayersandco@gmail.com', 'PPE 157', 'S. SAYERS & CO.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ssayersandco', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2260');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2260');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2260');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2260');
|
|
|
|
# Entry for S.E. CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('se.construction2018@gmail.com', 'PPE 158', 'S.E. CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'se.construction2018', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2261');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2261');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2261');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2261');
|
|
|
|
# Entry for S.K.S ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('suvankarbera3@gmail.com', 'PPE 159', 'S.K.S ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'suvankarbera3', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2262');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2262');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2262');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2262');
|
|
|
|
# Entry for S.M. ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sumanhaldia82@gmail.com', 'PPE 160', 'S.M. ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sumanhaldia82', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2263');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2263');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2263');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2263');
|
|
|
|
# Entry for SAFECON INDIA
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('safeconin@gmail.com', 'PPE 161', 'SAFECON INDIA', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'safeconin', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2264');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2264');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2264');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2264');
|
|
|
|
# Entry for SANTRA ENTERPRISE & CO.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sec_hal@rediffmail.com', 'PPE 162', 'SANTRA ENTERPRISE & CO.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sec_hal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2265');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2265');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2265');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2265');
|
|
|
|
# Entry for SARENS HEAVY LIFT INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('biswajit.nayak@sarens.in', 'PPE 163', 'SARENS HEAVY LIFT INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'biswajit.nayak', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2266');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2266');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2266');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2266');
|
|
|
|
# Entry for SB TANKSERVE PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sbtankserve@gmail.com', 'PPE 164', 'SB TANKSERVE PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sbtankserve', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2267');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2267');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2267');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2267');
|
|
|
|
# Entry for SCHNEIDER ELCTRIC INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('goutam3.dutta@se.com', 'PPE 165', 'SCHNEIDER ELCTRIC INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'goutam3.dutta', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2268');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2268');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2268');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2268');
|
|
|
|
# Entry for SCHNEIDER ELECTRIC INSFRASTRUCTURE LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('TANMOYRAKSHIT00028@GMAIL.COM', 'PPE 166', 'SCHNEIDER ELECTRIC INSFRASTRUCTURE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'TANMOYRAKSHIT00028', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2269');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2269');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2269');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2269');
|
|
|
|
# Entry for SCHNEIDER ELECTRICAL
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tirtha.das@se.com', 'PPE 167', 'SCHNEIDER ELECTRICAL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tirtha.das', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2270');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2270');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2270');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2270');
|
|
|
|
# Entry for SEAFOLK DIVING PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajendra@seafolkdive.com', 'PPE 168', 'SEAFOLK DIVING PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajendra', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2271');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2271');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2271');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2271');
|
|
|
|
# Entry for SGS INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('suprabhat.dutta@sgs.com', 'PPE 169', 'SGS INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'suprabhat.dutta', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2272');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2272');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2272');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2272');
|
|
|
|
# Entry for SHAKTI ENGINEERING CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('shaktiengghplhaldia@gmail.com', 'PPE 170', 'SHAKTI ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'shaktiengghplhaldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2273');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2273');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2273');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2273');
|
|
|
|
# Entry for SHARP TANK & STRUCTURALS PVT LTD (ZETWERK)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hipalash9@gmail.com', 'PPE 171', 'SHARP TANK & STRUCTURALS PVT LTD (ZETWERK)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hipalash9', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2274');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2274');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2274');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2274');
|
|
|
|
# Entry for SHIVHARE ROAD LINES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('srlhaldia@gmail.com', 'PPE 172', 'SHIVHARE ROAD LINES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'srlhaldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2275');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2275');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2275');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2275');
|
|
|
|
# Entry for SHOW & SONS ENTERPRISES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('senanup669@gmail.com', 'PPE 173', 'SHOW & SONS ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'senanup669', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2276');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2276');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2276');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2276');
|
|
|
|
# Entry for SHREE BUS SERVICE (TKUIPL)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sreebusservice@gmail.com', 'PPE 174', 'SHREE BUS SERVICE (TKUIPL)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sreebusservice', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2277');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2277');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2277');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2277');
|
|
|
|
# Entry for SIEMENS LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sandipan.mukhopadhyay@siemens.com', 'PPE 175', 'SIEMENS LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sandipan.mukhopadhyay', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2278');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2278');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2278');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2278');
|
|
|
|
# Entry for SIMO RESEARCH ENGINEERS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('research.simo@gmail.com', 'PPE 176', 'SIMO RESEARCH ENGINEERS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'research.simo', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2279');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2279');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2279');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2279');
|
|
|
|
# Entry for SINCLUS ENGINEERING & CONSULTING PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('roneswarsingha@gmail.com', 'PPE 177', 'SINCLUS ENGINEERING & CONSULTING PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'roneswarsingha', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2280');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2280');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2280');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2280');
|
|
|
|
# Entry for SKYLINE ENGINEERS
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('skyline.engineers17@gmail.com', 'PPE 178', 'SKYLINE ENGINEERS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'skyline.engineers17', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2281');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2281');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2281');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2281');
|
|
|
|
# Entry for SKYTECH SYSTEMS (INDIA) PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hiranmoy.dewan@skytechindia.com', 'PPE 179', 'SKYTECH SYSTEMS (INDIA) PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hiranmoy.dewan', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2282');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2282');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2282');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2282');
|
|
|
|
# Entry for SM COMPREHENSIVE SERVICE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smcomprehensiveservice@gmail.com', 'PPE 180', 'SM COMPREHENSIVE SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smcomprehensiveservice', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2283');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2283');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2283');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2283');
|
|
|
|
# Entry for SM ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smenterprisehal@gmail.com', 'PPE 181', 'SM ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smenterprisehal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2284');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2284');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2284');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2284');
|
|
|
|
# Entry for SMART SERVICE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smartservicero@gmail.com', 'PPE 182', 'SMART SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smartservicero', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2285');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2285');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2285');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2285');
|
|
# Entry for SPEED PRINT
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('speedprintdigital@gmail.com', 'PPE 183', 'SPEED PRINT', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'speedprintdigital', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2286');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2286');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2286');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2286');
|
|
|
|
# Entry for SREE GANESH ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smillingganesh@gmail.com', 'PPE 184', 'SREE GANESH ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smillingganesh', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2287');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2287');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2287');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2287');
|
|
|
|
# Entry for SRL
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Environmental.Laboratory@hpl.co.in', 'PPE 185', 'SRL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Environmental.Laboratory', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2288');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2288');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2288');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2288');
|
|
|
|
# Entry for STEAG ENERGY SERVICES (INDIA) PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sidhartha.roy@steag.in', 'PPE 186', 'STEAG ENERGY SERVICES (INDIA) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sidhartha.roy', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2289');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2289');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2289');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2289');
|
|
|
|
# Entry for SULABH INTERNATIONAL
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kpvermapatna@gmail.com', 'PPE 187', 'SULABH INTERNATIONAL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kpvermapatna', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2290');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2290');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2290');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2290');
|
|
|
|
# Entry for SULZER INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manish.pandey@sulzer.com', 'PPE 188', 'SULZER INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manish.pandey', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2291');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2291');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2291');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2291');
|
|
|
|
# Entry for SULZER PUMPS INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manish.pandey@sulzer.com', 'PPE 189', 'SULZER PUMPS INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manish.pandey', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2292');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2292');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2292');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2292');
|
|
|
|
# Entry for SUPERTECH ENGINEERING ENTERPRISES
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('supertecheng14@gmail.com', 'PPE 190', 'SUPERTECH ENGINEERING ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'supertecheng14', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2293');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2293');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2293');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2293');
|
|
|
|
# Entry for SUREFLO TECHCON PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rutuja@sureflo.in', 'PPE 191', 'SUREFLO TECHCON PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rutuja', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2294');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2294');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2294');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2294');
|
|
|
|
# Entry for SUREWORKS INFOTECH PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aixadmin.haldia@hpl.co.in', 'PPE 192', 'SUREWORKS INFOTECH PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aixadmin.haldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2295');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2295');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2295');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2295');
|
|
|
|
# Entry for TEAM LEASE (THERMAX LIMITED)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('guptamahesh732@gmail.com', 'PPE 193', 'TEAM LEASE (THERMAX LIMITED)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'guptamahesh732', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2296');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2296');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2296');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2296');
|
|
|
|
# Entry for TEAM WARRIOR PVT LTD (THERMAX LTD)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sureshk68527@gmail.com', 'PPE 194', 'TEAM WARRIOR PVT LTD (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sureshk68527', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2297');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2297');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2297');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2297');
|
|
|
|
# Entry for TECHMECH ENGINEERING (HAL OFFSHORE LTD)
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('techmechhaldia@gmail.com', 'PPE 195', 'TECHMECH ENGINEERING (HAL OFFSHORE LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'techmechhaldia', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2298');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2298');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2298');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2298');
|
|
|
|
# Entry for TECHNOFINE CALIBRATION SERVICES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@finecalibration.in', 'PPE 196', 'TECHNOFINE CALIBRATION SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2299');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2299');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2299');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2299');
|
|
|
|
# Entry for TEST METAL CORPORATION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tmc@tmcgroupindia.com', 'PPE 197', 'TEST METAL CORPORATION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tmc', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2300');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2300');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2300');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2300');
|
|
|
|
# Entry for THERMAX LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kajal.de@thermaxglobal.com', 'PPE 198', 'THERMAX LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kajal.de', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2301');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2301');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2301');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2301');
|
|
|
|
# Entry for THYSSENKRUPP UDHE INDIA PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jagabandhu.lenka@thyssenkrupp.com', 'PPE 199', 'THYSSENKRUPP UDHE INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jagabandhu.lenka', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2302');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2302');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2302');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2302');
|
|
|
|
# Entry for TK ELEVATOR
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('shuvendu.golder@tkelevator.com', 'PPE 200', 'TK ELEVATOR', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'shuvendu.golder', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2303');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2303');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2303');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2303');
|
|
|
|
# Entry for TQ CERT SERVICES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mandal_priyabrata@yahoo.com', 'PPE 201', 'TQ CERT SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mandal_priyabrata', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2304');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2304');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2304');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2304');
|
|
|
|
# Entry for TRACTEBEL ENGINEERING PRIVATE LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aswini.kabi@tractebel.engie.com', 'PPE 202', 'TRACTEBEL ENGINEERING PRIVATE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aswini.kabi', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2305');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2305');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2305');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2305');
|
|
|
|
# Entry for TRINITY TRADEX PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sales@trinitytradex.com', 'PPE 203', 'TRINITY TRADEX PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sales', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2306');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2306');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2306');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2306');
|
|
|
|
# Entry for TRISTAR CHEMICALS & COATINGS PVT. LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tristar.engg@yahoo.com', 'PPE 204', 'TRISTAR CHEMICALS & COATINGS PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tristar.engg', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2307');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2307');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2307');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2307');
|
|
|
|
# Entry for TRIVENI ENGINEERING & INDUSTRIES LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mktg@ptb.trivenigroup.com', 'PPE 205', 'TRIVENI ENGINEERING & INDUSTRIES LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mktg', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2308');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2308');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2308');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2308');
|
|
|
|
# Entry for TRIVENI TURBINE LIMITED
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jiteshgupta@triveniturbines.com', 'PPE 206', 'TRIVENI TURBINE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jiteshgupta', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2309');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2309');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2309');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2309');
|
|
|
|
# Entry for TUV
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gsudam@tuv-nord.com', 'PPE 207', 'TUV', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gsudam', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2310');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2310');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2310');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2310');
|
|
|
|
# Entry for TUV RHEINLAND INDIA PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Rakesh.Tiwari@ind.tuv.com', 'PPE 208', 'TUV RHEINLAND INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Rakesh.Tiwari', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2311');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2311');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2311');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2311');
|
|
|
|
# Entry for U K ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ak466d@gmail.com', 'PPE 209', 'U K ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ak466d', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2312');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2312');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2312');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2312');
|
|
|
|
# Entry for UDYOGI PLASTIC PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('project1@udyogi.net', 'PPE 210', 'UDYOGI PLASTIC PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'project1', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2313');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2313');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2313');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2313');
|
|
|
|
# Entry for UJALA T. P. SERVICE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anuj.mjk54@gmail.com', 'PPE 211', 'UJALA T. P. SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anuj.mjk54', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2314');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2314');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2314');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2314');
|
|
|
|
# Entry for UNIMARK HITECH SOLUTIONS LLP
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anis@unimark.in', 'PPE 212', 'UNIMARK HITECH SOLUTIONS LLP', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anis', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2315');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2315');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2315');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2315');
|
|
|
|
# Entry for UNIQUE CONSTRUCTION
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gmaiti472@gmail.com', 'PPE 213', 'UNIQUE CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gmaiti472', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2316');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2316');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2316');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2316');
|
|
|
|
# Entry for UNIVERSAL ENTERPRISE
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('enteruniversal.in@gmail.com', 'PPE 214', 'UNIVERSAL ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'enteruniversal.in', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2317');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2317');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2317');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2317');
|
|
|
|
# Entry for VERTIV
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sagar.mondal@vertiv.com', 'PPE 215', 'VERTIV', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sagar.mondal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2318');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2318');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2318');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2318');
|
|
|
|
# Entry for VIJAY TANKS & VESSELS PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('s3350admin@vijaytanks.com', 'PPE 216', 'VIJAY TANKS & VESSELS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 's3350admin', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2319');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2319');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2319');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2319');
|
|
|
|
# Entry for WRIGHT & COMPANY
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@wrightnco.com', 'PPE 217', 'WRIGHT & COMPANY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2320');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2320');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2320');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2320');
|
|
|
|
# Entry for YOUNG ENGG.& CALIBRATION SERVICES PVT LTD
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ujjal@nablcalibration.com', 'PPE 218', 'YOUNG ENGG.& CALIBRATION SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ujjal', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2321');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2321');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2321');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2321');
|
|
|
|
# Entry for ZETWERK MANUFACTURING BUSINESSESS PVT. LTD.
|
|
INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pratik.m@zetwerk.com', 'PPE 219', 'ZETWERK MANUFACTURING BUSINESSESS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pratik.m', 'A 04', 'WORK LEVEL - 5');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2322');
|
|
INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2322');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2322');
|
|
UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2322');
|
