DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees` (
                `employeeid` varchar(250) NOT NULL,
                `firstname` varchar(250) DEFAULT NULL,
                `address` text,
                `homephone` varchar(250) DEFAULT NULL,
                `categoryid` varchar(250) DEFAULT NULL,
                `password` varchar(250) DEFAULT NULL,
                `days` text,
                `region_ids` text,
                `group_id` bigint(20) DEFAULT NULL,
                `target_assigned` double DEFAULT NULL,
                `target_acheived` double DEFAULT NULL,
                PRIMARY KEY (`employeeid`)
              );
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('10','G-PAPAN AKBER                 ','dfafdfaf',
                'dfafd','SUPPLY MAN          ','123','0,1,2,3','1      ,1010103,1010105,1010106,1010108',
                '1','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('11','A-FAROOQUE                    ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('13','G-BILLAWAL                    ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('14','G-SIRAJ AHMED                 ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('15','G-ZAMEER WHOLE SALE BOOKING   ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('16','G-ZAMEER LOLAI GEN W-S        ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('17','G-FAROOQUE AHMED              ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('18','OTHERS                        ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('19','G-MUSHTAQUE AHMED             ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('2','C- MUZAMIL SHAH               ','                                                                                ',
                '                    ','OFFICE              
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('21','G-MAZAHAR ALI                 ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('22','A-MUSHTAQUE AHMED             ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('24','A-MAZHAR  ALI                 ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('26','A-RIAZ ALI                    ','KHUDA ABBAD MOHALA LARKANA                                                      ',
                '03133866388         ','BOOKING MAN         ','123','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('27','A-URGENT LOCAL SUPLY          ','KHUDA ABBAD MOHALA LARKANA                                                      ',
                '03133866388         ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('28','G-RIAZ ALI                    ','KHUDA ABBAD MOHALA LARKANA                                                      ',
                '03133866388         ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('29','G-URGENT LOCAL SUPLY          ','KHUDA ABBAD MOHALA                                                              ',
                '03133866388         ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('3','A-GHULAM SHABIR               ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('30','A-MAJID SHAIKH                ','LARKANA                                                                         ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('31','WHOLESALE GENERAL RECEOVERY   ','                                                                                ',
                '                    ','RECOVERY            
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('32','WHOLESALE ABBOT RECOVERY      ','                                                                                ',
                '                    ','RECOVERY            
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('33','GENERAL RETAIL RECOVERY       ','                                                                                ',
                '                    ','RECOVERY            
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('34','MEDICAL REPRESENTATIVE ORDER  ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('35','NEW PRODUCT AVAILIBILITY      ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('36','G-AKBER ALI SHAIKH            ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('37','G-WASEEM AHMED                ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('38','G-MUZAFAR ALI                 ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('4','A-TARIQUE ABBASI              ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('5','A-ZAMEER W.S ABBOTT BOOKING   ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('6','A-ZAMEER W.S ABBOTT SUPLY     ','                                                                                ',
                '                    ','SUPPLY MAN          
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('7','A-AHSAN BHUTTO                ','GAJAN PUR                                                                       ',
                '03133663953         ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('8','G-AHSAN BHUTTO                ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');
insert  into `employees`(`employeeid`,`firstname`,`address`,`homephone`,`categoryid`,`password`,`days`,`region_ids`,`group_id`,
                `target_assigned`,`target_acheived`) values ('9','G-GHULAM SHABIR               ','                                                                                ',
                '                    ','BOOKING MAN         
','','','',
                '','','');