/*
SQLyog Ultimate - MySQL GUI v8.2 
MySQL - 5.5.8 : Database - jai_medicos
*********************************************************************
*/




/*Table structure for table `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,
  `regions` text,
  `group_id` bigint(20) DEFAULT NULL,
  `target_assigned` double DEFAULT NULL,
  `target_acheived` double DEFAULT NULL,
  PRIMARY KEY (`employeeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `employees` */

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

