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 '0',
                `target_assigned` double DEFAULT '0',
                `target_acheived` double DEFAULT '0',
                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','Monday,Friday','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','','','','','','');