
CREATE TABLE `log_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `check_in_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `check_out_time` timestamp NULL DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0' COMMENT '0=not deleted,1=deleted',
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_details` longtext COLLATE utf8mb4_unicode_ci,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `updated_by` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `log_activity` */

insert  into `log_activity`(`id`,`check_in_time`,`check_out_time`,`user_id`,`deleted`,`subject`,`url`,`method`,`ip`,`agent`,`location_details`,`created_by`,`updated_by`,`created_at`,`updated_at`) values 
(5,'2024-03-08 05:57:15',NULL,14,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.209.99.30','Mozilla/5.0 (X11; CrOS x86_64 14541.0.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36','{\"ip\":\"125.209.99.30\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-08 00:57:15','2024-03-08 00:57:15'),
(6,'2024-03-08 08:44:39',NULL,15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.53','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.53\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-08 03:44:39','2024-03-08 03:44:39'),
(7,'2024-03-08 15:15:50',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-08 10:15:50','2024-03-08 10:15:50'),
(12,'2024-03-09 08:16:40',NULL,15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.252','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.252\",\"countryName\":null,\"countryCode\":\"PK\",\"regionCode\":null,\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8608\",\"longitude\":\"67.0104\",\"metroCode\":null,\"areaCode\":null,\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpInfo\"}',0,0,'2024-03-09 03:16:40','2024-03-09 03:16:40'),
(13,'2024-03-11 08:31:14','2024-03-11 12:01:34',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 03:31:14','2024-03-11 12:01:34'),
(14,'2024-03-11 08:38:37',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 03:38:37','2024-03-11 03:38:37'),
(15,'2024-03-11 10:24:09',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.71','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.71\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 05:24:09','2024-03-11 05:24:09'),
(16,'2024-03-11 11:42:22',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.71','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.71\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 06:42:22','2024-03-11 06:42:22'),
(17,'2024-03-11 15:17:59','2024-03-11 13:24:59',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 10:17:59','2024-03-11 13:24:59'),
(21,'2024-03-12 08:13:33','2024-03-12 10:34:20',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.84','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.84\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 03:13:33','2024-03-12 10:34:20'),
(22,'2024-03-12 08:54:19',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 03:54:19','2024-03-12 03:54:19'),
(23,'2024-03-12 09:15:42',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 04:15:42','2024-03-12 04:15:42'),
(24,'2024-03-12 10:13:10',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.219.61','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.219.61\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 05:13:10','2024-03-12 05:13:10'),
(25,'2024-03-12 10:20:37',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.219.61','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.219.61\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 05:20:37','2024-03-12 05:20:37'),
(26,'2024-03-12 11:31:10',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 06:31:10','2024-03-12 06:31:10'),
(27,'2024-03-12 11:32:53',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 06:32:53','2024-03-12 06:32:53'),
(28,'2024-03-12 12:45:41',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','72.255.58.55','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"72.255.58.55\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 07:45:41','2024-03-12 07:45:41'),
(29,'2024-03-12 13:04:14',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.137.239','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.137.239\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"BA\",\"regionName\":\"Balochistan\",\"cityName\":\"Barkhan\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"29.8977\",\"longitude\":\"69.5256\",\"metroCode\":null,\"areaCode\":\"BA\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 08:04:14','2024-03-12 08:04:14'),
(30,'2024-03-12 13:41:29',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.219.61','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.219.61\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 08:41:29','2024-03-12 08:41:29'),
(31,'2024-03-12 15:22:00','2024-03-12 11:53:24',20,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','72.255.58.55','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"72.255.58.55\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 10:22:00','2024-03-12 11:53:24'),
(32,'2024-03-13 08:07:07',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:07:07','2024-03-13 03:07:07'),
(33,'2024-03-13 08:19:45',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','223.123.112.235','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.112.235\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:19:45','2024-03-13 03:19:45'),
(34,'2024-03-13 08:22:53',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:22:53','2024-03-13 03:22:53'),
(35,'2024-03-13 08:33:34','2024-03-13 10:30:23',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.176.42','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.176.42\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:33:34','2024-03-13 10:30:23'),
(36,'2024-03-13 09:30:00',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 04:30:00','2024-03-13 04:30:00'),
(37,'2024-03-13 10:57:15',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.215.89','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.215.89\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 05:57:15','2024-03-13 05:57:15'),
(38,'2024-03-13 11:36:06',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','154.91.162.8','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"154.91.162.8\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44010\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 06:36:06','2024-03-13 06:36:06'),
(39,'2024-03-13 11:37:13',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 06:37:13','2024-03-13 06:37:13'),
(40,'2024-03-13 12:02:04',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 07:02:04','2024-03-13 07:02:04'),
(41,'2024-03-13 14:01:44','2024-03-13 09:50:09',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.215.89','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"111.88.215.89\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 09:01:44','2024-03-13 09:50:09'),
(42,'2024-03-13 14:07:33',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.157.78.23','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.157.78.23\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 09:07:33','2024-03-13 09:07:33'),
(43,'2024-03-13 17:44:52',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.205','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.205\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 12:44:52','2024-03-13 12:44:52'),
(44,'2024-03-13 21:31:52',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.163.51','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.163.51\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 16:31:52','2024-03-13 16:31:52'),
(45,'2024-03-14 02:40:25',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 21:40:25','2024-03-13 21:40:25'),
(46,'2024-03-14 05:03:58',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 00:03:58','2024-03-14 00:03:58'),
(47,'2024-03-14 08:16:32',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','223.123.111.228','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.111.228\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75800\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9551\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 03:16:32','2024-03-14 03:16:32'),
(48,'2024-03-14 08:30:08',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 03:30:08','2024-03-14 03:30:08'),
(49,'2024-03-14 09:15:30',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 04:15:30','2024-03-14 04:15:30'),
(50,'2024-03-14 09:36:10',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.217.54','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.217.54\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 04:36:10','2024-03-14 04:36:10'),
(51,'2024-03-14 11:01:18',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.128','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.128\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 06:01:18','2024-03-14 06:01:18'),
(52,'2024-03-14 11:03:18',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','223.123.104.54','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.104.54\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 06:03:18','2024-03-14 06:03:18'),
(53,'2024-03-14 11:28:41',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.217.54','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.217.54\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 06:28:41','2024-03-14 06:28:41'),
(54,'2024-03-14 12:53:39','2024-03-14 07:59:23',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.134.107','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.134.107\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7215\",\"longitude\":\"73.0433\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 07:53:39','2024-03-14 07:59:23'),
(55,'2024-03-14 14:50:38',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.247','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.247\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 09:50:38','2024-03-14 09:50:38'),
(56,'2024-03-15 08:23:05','2024-03-15 07:12:41',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.213','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.213\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 03:23:05','2024-03-15 07:12:41'),
(57,'2024-03-15 08:37:23',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 03:37:23','2024-03-15 03:37:23'),
(58,'2024-03-15 09:02:11',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 04:02:11','2024-03-15 04:02:11'),
(59,'2024-03-15 10:05:56','2024-03-15 09:29:55',23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 05:05:56','2024-03-15 09:29:55'),
(60,'2024-03-15 11:10:42',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 06:10:42','2024-03-15 06:10:42'),
(61,'2024-03-15 12:30:06',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.208.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.208.115\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 07:30:06','2024-03-15 07:30:06'),
(64,'2024-03-16 01:09:15',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 20:09:15','2024-03-15 20:09:15'),
(65,'2024-03-16 08:19:19','2024-03-16 10:33:29',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.139','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.139\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-16 03:19:19','2024-03-16 10:33:29'),
(66,'2024-03-17 16:53:23',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-17 11:53:23','2024-03-17 11:53:23'),
(67,'2024-03-18 08:27:32',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 03:27:32','2024-03-18 03:27:32'),
(68,'2024-03-18 08:39:00','2024-03-18 10:36:01',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.15','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.15\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 03:39:00','2024-03-18 10:36:01'),
(69,'2024-03-18 09:10:17','2024-03-18 07:23:11',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 04:10:17','2024-03-18 07:23:11'),
(70,'2024-03-18 10:06:53',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.223.13','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.223.13\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 05:06:53','2024-03-18 05:06:53'),
(71,'2024-03-18 11:27:46',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.112.168','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.112.168\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 06:27:46','2024-03-18 06:27:46'),
(72,'2024-03-18 14:47:55',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.34.154.254','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.34.154.254\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 09:47:55','2024-03-18 09:47:55'),
(73,'2024-03-18 21:11:14',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.182.41.4','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"182.182.41.4\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Tando Allahyar\",\"zipCode\":\"70010\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"25.4605\",\"longitude\":\"68.7175\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 16:11:14','2024-03-18 16:11:14'),
(74,'2024-03-19 08:23:12',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.113.246','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.113.246\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 03:23:12','2024-03-19 03:23:12'),
(75,'2024-03-19 08:38:16','2024-03-19 10:22:15',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.182','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.182\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 03:38:16','2024-03-19 10:22:15'),
(76,'2024-03-19 08:38:24',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 03:38:24','2024-03-19 03:38:24'),
(77,'2024-03-19 09:17:46',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.128.11','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.128.11\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"KP\",\"regionName\":\"Khyber Pakhtunkhwa\",\"cityName\":\"Zaida\",\"zipCode\":\"23540\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.0595\",\"longitude\":\"72.4669\",\"metroCode\":null,\"areaCode\":\"KP\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:17:46','2024-03-19 04:17:46'),
(78,'2024-03-19 09:18:44',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.128.11','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.128.11\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"KP\",\"regionName\":\"Khyber Pakhtunkhwa\",\"cityName\":\"Zaida\",\"zipCode\":\"23540\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.0595\",\"longitude\":\"72.4669\",\"metroCode\":null,\"areaCode\":\"KP\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:18:44','2024-03-19 04:18:44'),
(79,'2024-03-19 09:40:08',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:40:08','2024-03-19 04:40:08'),
(80,'2024-03-19 09:56:22','2024-03-19 07:20:18',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:56:22','2024-03-19 07:20:18'),
(81,'2024-03-19 10:29:32','2024-03-19 05:55:41',12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 05:29:32','2024-03-19 05:55:41'),
(82,'2024-03-19 10:41:13',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 05:41:13','2024-03-19 05:41:13'),
(83,'2024-03-19 10:57:52','2024-03-19 08:42:56',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 05:57:52','2024-03-19 08:42:56'),
(84,'2024-03-19 11:31:50',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 06:31:50','2024-03-19 06:31:50'),
(85,'2024-03-19 13:59:54','2024-03-19 09:31:22',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 08:59:54','2024-03-19 09:31:22'),
(86,'2024-03-19 17:46:11',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 12:46:11','2024-03-19 12:46:11'),
(87,'2024-03-19 21:17:36',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.221.88','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.221.88\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 16:17:36','2024-03-19 16:17:36'),
(88,'2024-03-19 21:43:10',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.163.251','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.163.251\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 16:43:10','2024-03-19 16:43:10'),
(89,'2024-03-20 08:20:27',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.115.145','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.115.145\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:20:27','2024-03-20 03:20:27'),
(90,'2024-03-20 08:20:44',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.115.145','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.115.145\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:20:44','2024-03-20 03:20:44'),
(91,'2024-03-20 08:32:26',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Rawalpindi\",\"zipCode\":\"46000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.6054\",\"longitude\":\"73.0354\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:32:26','2024-03-20 03:32:26'),
(92,'2024-03-20 08:41:19','2024-03-20 10:38:30',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.48','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.48\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:41:19','2024-03-20 10:38:30'),
(93,'2024-03-20 09:09:59',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.140.153','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.140.153\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"JK\",\"regionName\":\"Azad Jammu and Kashmir\",\"cityName\":\"Muzaffarabad\",\"zipCode\":\"24601\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.37\",\"longitude\":\"73.4708\",\"metroCode\":null,\"areaCode\":\"JK\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 04:09:59','2024-03-20 04:09:59'),
(94,'2024-03-20 09:24:55','2024-03-20 07:31:15',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 04:24:55','2024-03-20 07:31:15'),
(95,'2024-03-20 10:02:58',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.209.166','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.209.166\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 05:02:58','2024-03-20 05:02:58'),
(96,'2024-03-20 10:30:06',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.209.166','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.209.166\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 05:30:06','2024-03-20 05:30:06'),
(97,'2024-03-20 11:29:27',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 06:29:27','2024-03-20 06:29:27'),
(98,'2024-03-20 11:31:15',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 06:31:15','2024-03-20 06:31:15'),
(99,'2024-03-20 16:18:57',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.218.135','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.218.135\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 11:18:57','2024-03-20 11:18:57'),
(100,'2024-03-20 19:41:52',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 14:41:52','2024-03-20 14:41:52'),
(101,'2024-03-20 22:29:43',NULL,14,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','99.185.60.55','Mozilla/5.0 (X11; CrOS x86_64 14541.0.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"99.185.60.55\",\"countryName\":\"United States\",\"countryCode\":\"US\",\"regionCode\":\"MI\",\"regionName\":\"Michigan\",\"cityName\":\"West Bloomfield\",\"zipCode\":\"48323\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"42.5655\",\"longitude\":\"-83.3783\",\"metroCode\":null,\"areaCode\":\"MI\",\"timezone\":\"America\\/Detroit\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 17:29:43','2024-03-20 17:29:43'),
(102,'2024-03-20 22:43:35','2024-03-20 17:45:31',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 17:43:35','2024-03-20 17:45:31'),
(103,'2024-03-20 22:45:43','2024-03-20 23:06:07',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 17:45:43','2024-03-20 18:06:07'),
(104,'2024-03-20 23:06:10',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 18:06:10','2024-03-20 18:06:10'),
(105,'2024-03-20 23:06:47','2024-03-20 23:08:09',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.236','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.236\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 18:06:47','2024-03-20 18:08:09'),
(106,'2024-03-20 23:08:12','2024-03-20 23:09:29',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.236','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.236\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 18:08:12','2024-03-20 18:09:29'),
(107,'2024-03-21 00:07:46',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.236','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.236\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 19:07:46','2024-03-20 19:07:46'),
(108,'2024-03-21 01:01:02',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 20:01:02','2024-03-20 20:01:02'),
(109,'2024-03-21 08:26:05',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.105.132','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.105.132\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 03:26:05','2024-03-21 03:26:05'),
(110,'2024-03-21 08:38:23',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 03:38:23','2024-03-21 03:38:23'),
(111,'2024-03-21 08:44:53','2024-03-21 15:30:24',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.223.34','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.223.34\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8607\",\"longitude\":\"67.0011\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 03:44:53','2024-03-21 10:30:24'),
(112,'2024-03-21 09:08:08',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.137.92','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.137.92\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"JK\",\"regionName\":\"Azad Jammu and Kashmir\",\"cityName\":\"Muzaffarabad\",\"zipCode\":\"24601\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.37\",\"longitude\":\"73.4708\",\"metroCode\":null,\"areaCode\":\"JK\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 04:08:08','2024-03-21 04:08:08'),
(113,'2024-03-21 09:11:32',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 04:11:32','2024-03-21 04:11:32'),
(114,'2024-03-21 09:24:29',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 04:24:29','2024-03-21 04:24:29'),
(115,'2024-03-21 10:35:09','2024-03-21 14:32:05',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.218.135','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.218.135\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 05:35:09','2024-03-21 09:32:05'),
(116,'2024-03-21 11:00:13',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.218.135','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.218.135\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 06:00:13','2024-03-21 06:00:13'),
(117,'2024-03-21 11:43:36',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.211.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.211.180\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 06:43:36','2024-03-21 06:43:36'),
(118,'2024-03-21 12:01:26','2024-03-21 12:25:12',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 07:01:26','2024-03-21 07:25:12'),
(119,'2024-03-21 21:53:21',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 16:53:21','2024-03-21 16:53:21'),
(120,'2024-03-22 08:20:44',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.104.35','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.104.35\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 03:20:44','2024-03-22 03:20:44'),
(121,'2024-03-22 08:46:56','2024-03-22 11:50:10',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.6','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.6\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 03:46:56','2024-03-22 06:50:10'),
(122,'2024-03-22 09:05:51',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.134.240','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.134.240\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7215\",\"longitude\":\"73.0433\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 04:05:51','2024-03-22 04:05:51'),
(123,'2024-03-22 09:19:36',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 04:19:36','2024-03-22 04:19:36'),
(124,'2024-03-23 01:46:00','2024-03-23 01:46:16',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 20:46:00','2024-03-22 20:46:16'),
(125,'2024-03-23 01:46:20','2024-03-23 01:46:58',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 20:46:20','2024-03-22 20:46:58'),
(126,'2024-03-25 09:04:04','2024-03-25 15:00:20',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.214.103','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.214.103\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75850\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9811\",\"longitude\":\"67.0725\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 04:04:04','2024-03-25 10:00:20'),
(127,'2024-03-25 09:04:19',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.167.228','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.167.228\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Islamkot\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.699\",\"longitude\":\"70.1798\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 04:04:19','2024-03-25 04:04:19'),
(128,'2024-03-25 09:46:32',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 04:46:32','2024-03-25 04:46:32'),
(129,'2024-03-25 10:03:28',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.213.194','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.213.194\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 05:03:28','2024-03-25 05:03:28'),
(130,'2024-03-26 00:40:51',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 19:40:51','2024-03-25 19:40:51'),
(131,'2024-03-26 01:36:38',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 20:36:38','2024-03-25 20:36:38'),
(132,'2024-03-26 09:05:17',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.164.163','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.164.163\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8608\",\"longitude\":\"67.0104\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:05:17','2024-03-26 04:05:17'),
(133,'2024-03-26 09:07:19',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.164.163','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.164.163\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8608\",\"longitude\":\"67.0104\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:07:19','2024-03-26 04:07:19'),
(134,'2024-03-26 09:12:56','2024-03-26 15:00:19',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.195.103','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.195.103\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75780\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8794\",\"longitude\":\"66.992\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:12:56','2024-03-26 10:00:19'),
(135,'2024-03-26 09:39:09',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:39:09','2024-03-26 04:39:09'),
(136,'2024-03-26 10:12:26',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Rawalpindi\",\"zipCode\":\"46000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.6054\",\"longitude\":\"73.0354\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 05:12:26','2024-03-26 05:12:26'),
(137,'2024-03-26 11:56:07',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.156.45','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.156.45\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 06:56:07','2024-03-26 06:56:07'),
(138,'2024-03-26 11:58:39',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.255','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.255\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 06:58:39','2024-03-26 06:58:39'),
(139,'2024-03-26 14:24:32',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.255','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.255\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 09:24:32','2024-03-26 09:24:32'),
(140,'2024-03-26 20:57:08',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 15:57:08','2024-03-26 15:57:08'),
(141,'2024-03-26 23:43:46',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.115.165','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.115.165\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 18:43:46','2024-03-26 18:43:46'),
(142,'2024-03-27 01:02:08',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 20:02:08','2024-03-26 20:02:08'),
(143,'2024-03-27 08:59:32','2024-03-27 14:56:18',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.34.173','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.34.173\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 03:59:32','2024-03-27 09:56:18'),
(144,'2024-03-27 09:04:44',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.159','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.159\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 04:04:44','2024-03-27 04:04:44'),
(145,'2024-03-27 09:10:27',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 04:10:27','2024-03-27 04:10:27'),
(146,'2024-03-27 09:29:58',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 04:29:58','2024-03-27 04:29:58'),
(147,'2024-03-27 12:27:24','2024-03-27 12:27:30',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.139.82','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.139.82\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.6843\",\"longitude\":\"72.9885\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 07:27:24','2024-03-27 07:27:30'),
(148,'2024-03-27 22:16:34',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 17:16:34','2024-03-27 17:16:34'),
(149,'2024-03-28 02:07:05',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 21:07:05','2024-03-27 21:07:05'),
(150,'2024-03-28 09:00:53','2024-03-28 15:00:07',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.45.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.45.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 04:00:53','2024-03-28 10:00:07'),
(151,'2024-03-28 09:41:34',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.159','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.159\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 04:41:34','2024-03-28 04:41:34'),
(152,'2024-03-28 09:42:37',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 04:42:37','2024-03-28 04:42:37'),
(153,'2024-03-28 10:05:51',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 05:05:51','2024-03-28 05:05:51'),
(154,'2024-03-28 12:46:27',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.159','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.159\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 07:46:27','2024-03-28 07:46:27'),
(155,'2024-03-29 02:56:46',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 21:56:46','2024-03-28 21:56:46'),
(156,'2024-03-29 09:05:51','2024-03-29 12:16:06',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.35.136','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.35.136\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 04:05:51','2024-03-29 07:16:06'),
(157,'2024-03-29 09:08:25',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 04:08:25','2024-03-29 04:08:25'),
(158,'2024-03-29 09:28:45','2024-03-29 11:40:46',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 04:28:45','2024-03-29 06:40:46'),
(159,'2024-03-29 10:54:32',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 05:54:32','2024-03-29 05:54:32'),
(160,'2024-03-29 12:08:50',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 07:08:50','2024-03-29 07:08:50'),
(161,'2024-03-29 15:10:03',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 10:10:03','2024-03-29 10:10:03'),
(162,'2024-03-29 15:22:33',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 10:22:33','2024-03-29 10:22:33'),
(163,'2024-03-29 22:51:04',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 17:51:04','2024-03-29 17:51:04'),
(164,'2024-03-30 09:00:10','2024-03-30 14:59:16',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.43.96','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.43.96\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75800\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9551\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-30 04:00:10','2024-03-30 09:59:16'),
(165,'2024-04-01 09:06:20',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.104.144','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.73.104.144\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 04:06:20','2024-04-01 04:06:20'),
(166,'2024-04-01 12:56:09',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.104.144','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.73.104.144\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 07:56:09','2024-04-01 07:56:09'),
(167,'2024-04-01 20:54:02',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 15:54:02','2024-04-01 15:54:02'),
(168,'2024-04-01 22:47:10',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 17:47:10','2024-04-01 17:47:10'),
(169,'2024-04-02 01:51:31',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 20:51:31','2024-04-01 20:51:31'),
(170,'2024-04-02 08:02:32',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.109.97','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.109.97\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75800\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9551\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 03:02:32','2024-04-02 03:02:32'),
(171,'2024-04-02 08:16:52',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.104.57','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.73.104.57\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 03:16:52','2024-04-02 03:16:52'),
(172,'2024-04-02 08:24:20',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 03:24:20','2024-04-02 03:24:20'),
(173,'2024-04-02 09:04:08',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.150.167','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.150.167\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Lahore\",\"zipCode\":\"54000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"31.5826\",\"longitude\":\"74.3276\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:04:08','2024-04-02 04:04:08'),
(174,'2024-04-02 09:04:14','2024-04-02 15:00:02',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.162.195','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.155.162.195\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75080\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8741\",\"longitude\":\"67.1906\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:04:14','2024-04-02 10:00:02'),
(175,'2024-04-02 09:04:45',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.150.167','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.150.167\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Lahore\",\"zipCode\":\"54000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"31.5826\",\"longitude\":\"74.3276\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:04:45','2024-04-02 04:04:45'),
(176,'2024-04-02 09:19:40',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:19:40','2024-04-02 04:19:40'),
(177,'2024-04-02 16:00:39',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.210.104','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.210.104\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 11:00:39','2024-04-02 11:00:39'),
(178,'2024-04-02 22:08:16',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.209.110','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.209.110\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 17:08:16','2024-04-02 17:08:16'),
(179,'2024-04-02 22:48:56',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 17:48:56','2024-04-02 17:48:56'),
(180,'2024-04-03 00:05:09',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 19:05:09','2024-04-02 19:05:09');

/*Table structure for table `lower_respiratory_sobs` */


CREATE TABLE `lower_respiratory_sobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `OnExertionMild` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnExertionModerate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnExertionSevere` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Wheezing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Crackles` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `lower_respiratory_sobs` */

insert  into `lower_respiratory_sobs`(`id`,`form_id`,`GnInfoId`,`OnExertionMild`,`OnExertionModerate`,`OnExertionSevere`,`Wheezing`,`Crackles`,`created_at`,`updated_at`) values 
(8,NULL,8,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'On Exertion Mild','On Exertion Moderate','On Exertion Severe','Wheezing','Crackles','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `lower_respiratory_tract_infections` */


CREATE TABLE `lower_respiratory_tract_infections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `SputumColor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SputumQuantity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Brasky` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Whooping` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BloodInSputum` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `lower_respiratory_tract_infections` */

insert  into `lower_respiratory_tract_infections`(`id`,`form_id`,`GnInfoId`,`SputumColor`,`SputumQuantity`,`Brasky`,`Whooping`,`BloodInSputum`,`created_at`,`updated_at`) values 
(8,NULL,8,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(19,NULL,17,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 20:21:29','2024-04-01 20:21:29'),
(20,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:01:01','2024-04-01 21:01:01'),
(21,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:22:40','2024-04-01 21:22:40'),
(22,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:25:24','2024-04-01 21:25:24'),
(23,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:26:46','2024-04-01 21:26:46'),
(24,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:26:47','2024-04-01 21:26:47'),
(25,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:27:40','2024-04-01 21:27:40');

/*Table structure for table `main_complaints` */


CREATE TABLE `main_complaints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) DEFAULT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Onset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Severity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RelievingFactor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AssociatedSymptoms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `main_complaints` */

insert  into `main_complaints`(`id`,`form_id`,`GnInfoId`,`Description`,`Onset`,`Duration`,`Severity`,`RelievingFactor`,`AssociatedSymptoms`,`created_at`,`updated_at`) values 
(6,NULL,8,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Description','Onset','Duration','6','Aggravating/Relieving Factors','Associated Symptoms','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `meningitis` */


CREATE TABLE `meningitis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `OnsetAndProgression` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Headache` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Fever` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `meningitis` */

insert  into `meningitis`(`id`,`form_id`,`GnInfoId`,`OnsetAndProgression`,`Headache`,`Fever`,`created_at`,`updated_at`) values 
(8,NULL,8,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Sudden onset of symptoms','Headache may be described as the worst headache of my life','Nausea and Vomiting','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `migrations` */


CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values 
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_reset_tokens_table',1),
(3,'2019_08_19_000000_create_failed_jobs_table',1),
(4,'2019_12_14_000001_create_personal_access_tokens_table',1),
(5,'2023_09_28_165651_create_countries_table',1),
(6,'2023_09_28_165725_create_cities_table',1),
(7,'2023_09_28_165744_create_areas_table',1),
(8,'2023_09_28_165807_create_schools_table',1),
(9,'2023_09_28_165828_create_students_table',1),
(10,'2023_12_21_144142_create_forms_table',2),
(11,'2023_12_21_153634_create_form_steps_table',2),
(12,'2023_12_21_153945_create_form_step_fields_table',2),
(13,'2023_12_21_154330_create_form_step_field_options_table',2),
(14,'2023_12_21_154456_create_fields_registration_values_table',2),
(15,'2023_12_21_154638_create_student_registrations_table',2),
(16,'2023_12_25_142621_create_form_data_table',2),
(17,'2023_12_25_144459_create_form_entries_table',2),
(20,'2024_03_06_181628_create_log_activity_table',3),
(21,'2024_03_08_144147_add_cnic_to_users_table',4),
(22,'2024_03_13_191113_create_general_infos_table',5),
(23,'2024_03_13_191932_create_main_complaints_table',6),
(24,'2024_03_13_203040_create_secondary_complains_table',7),
(25,'2024_03_13_203152_create_recent_changes_or_concerns_table',8),
(26,'2024_03_13_203404_create_vital_signs_table',8),
(27,'2024_03_13_203621_create_fever_histories_table',8),
(28,'2024_03_13_203926_create_headaches_table',8),
(29,'2024_03_13_204140_create_meningitis_table',8),
(30,'2024_03_13_204313_create_abdominal_pain_histories_table',8),
(31,'2024_03_14_153824_create_personal_histories_table',8),
(32,'2024_03_14_154133_create_sleep_routines_table',8),
(33,'2024_03_14_154607_create_nutrition_histories_table',8),
(34,'2024_03_14_155223_create_chest_pains_table',8),
(35,'2024_03_14_155646_create_sobs_table',8),
(36,'2024_03_14_155855_create_respiratory_systems_table',8),
(37,'2024_03_14_161435_create_upper_resps_table',8),
(38,'2024_03_14_161618_create_coughs_table',8),
(39,'2024_03_14_161759_create_history_of_pneumonias_table',8),
(40,'2024_03_14_161950_create_lower_respiratory_tract_infections_table',8),
(41,'2024_03_14_162407_create_lower_respiratory_sobs_table',8),
(42,'2024_03_14_164641_create_history_of_infections_table',8),
(43,'2024_03_14_170028_create_skin_diseases_table',8),
(44,'2024_03_14_172305_create_chief_complaints_table',8),
(45,'2024_03_15_190253_create_previous_menstruation_treatment_or_interventions_table',8),
(46,'2024_03_18_160715_create_past_medical_conditions_table',8),
(47,'2024_03_18_161124_create_allergies_table',8),
(48,'2024_03_18_162219_create_socioeconomics_table',8);

/*Table structure for table `nutrition_histories` */


CREATE TABLE `nutrition_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `BreakfastIfYes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RotiTheyEat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Lunch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SkipMeals` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MealPreferences` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FoodAllergies` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DietaryRestrictions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `nutrition_histories` */

insert  into `nutrition_histories`(`id`,`form_id`,`GnInfoId`,`BreakfastIfYes`,`RotiTheyEat`,`Lunch`,`SkipMeals`,`MealPreferences`,`FoodAllergies`,`DietaryRestrictions`,`created_at`,`updated_at`) values 
(8,NULL,8,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Breakfast if yes','How much roti did they eat?','Lunch','Skip meals','Meal preferences especially dislikes','Food allergies','Dietary restrictions','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `password_reset_tokens` */


CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `password_reset_tokens` */

/*Table structure for table `past_medical_conditions` */


CREATE TABLE `past_medical_conditions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `LongTermHealthConditions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longterm_health_other` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AccidentOrInjuries` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Surgeries` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AnyCurrentMdications` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `past_medical_conditions` */

insert  into `past_medical_conditions`(`id`,`form_id`,`GnInfoId`,`LongTermHealthConditions`,`longterm_health_other`,`AccidentOrInjuries`,`Surgeries`,`AnyCurrentMdications`,`created_at`,`updated_at`) values 
(8,NULL,8,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Other','Please specify 2','Accident or Injuries','Surgeries','Any Current medications','2024-04-01 21:01:01','2024-04-01 21:27:40');

/*Table structure for table `personal_access_tokens` */


CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `personal_access_tokens` */

/*Table structure for table `personal_histories` */


CREATE TABLE `personal_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `LifestyleHabits` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentMedications` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sports` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `personal_histories` */

insert  into `personal_histories`(`id`,`form_id`,`GnInfoId`,`LifestyleHabits`,`CurrentMedications`,`sports`,`created_at`,`updated_at`) values 
(8,NULL,8,'Exercise',NULL,NULL,'2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Exercise',NULL,NULL,'2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Exercise',NULL,NULL,'2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Exercise',NULL,NULL,'2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Exercise',NULL,NULL,'2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Exercise',NULL,NULL,'2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Exercise',NULL,NULL,'2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Current Medications','Current Medications',NULL,'2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `previous_menstruation_treatment_or_interventions` */


CREATE TABLE `previous_menstruation_treatment_or_interventions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `PreviousMenstruationTreatmentOrInterventions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Specify` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `previous_menstruation_treatment_or_interventions` */

insert  into `previous_menstruation_treatment_or_interventions`(`id`,`form_id`,`GnInfoId`,`PreviousMenstruationTreatmentOrInterventions`,`Specify`,`comment`,`created_at`,`updated_at`) values 
(8,NULL,8,'Other','ewr','ewr','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Other','ewr','ewr','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Other','ewr','ewr','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Other','ewr','ewr','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Other','ewr','ewr','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Other','ewr','ewr','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Other','ewr','ewr','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Other','Please specify','Additional comments or concerns','2024-04-01 21:01:01','2024-04-01 21:26:46');

/*Table structure for table `recent_changes_or_concerns` */


CREATE TABLE `recent_changes_or_concerns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) DEFAULT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Onset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Severity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RelievingFactor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AssociatedSymptoms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `recent_changes_or_concerns` */

insert  into `recent_changes_or_concerns`(`id`,`form_id`,`GnInfoId`,`Description`,`Onset`,`Duration`,`Severity`,`RelievingFactor`,`AssociatedSymptoms`,`created_at`,`updated_at`) values 
(6,NULL,8,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Description','Onset','Duration','6','Aggravating/Relieving Factors','Associated Symptoms','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `respiratory_systems` */


CREATE TABLE `respiratory_systems` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `NasalPatency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Clubbing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Asthma` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `respiratory_systems` */

insert  into `respiratory_systems`(`id`,`form_id`,`GnInfoId`,`NasalPatency`,`Clubbing`,`Asthma`,`created_at`,`updated_at`) values 
(8,NULL,8,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Nasal patency','Clubbing','Asthma','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `schools` */


CREATE TABLE `schools` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `school_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `area` int(11) NOT NULL,
  `school_representative` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `schools` */

insert  into `schools`(`id`,`school_name`,`address`,`area`,`school_representative`,`email`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`) values 
(1,'The SET School','The Set School Gwalior Society',1,'Mrs Hina Arshad','mrsarshad79@gmail.com',1,1,1,'2024-01-16 05:06:05','2024-01-16 05:06:05'),
(2,'Save The Future School','Khada Market, Lyari',1,'Ms. Najma','ushna@msn.com',1,1,1,'2024-01-16 05:07:45','2024-01-16 05:07:45'),
(3,'Kiran Foundation School','Kiran Foundation School',1,'Sabina khatri','Sabina.khatri3@gmail.com',1,1,1,'2024-02-12 08:39:51','2024-02-12 08:50:44');

/*Table structure for table `secondary_complains` */


CREATE TABLE `secondary_complains` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) DEFAULT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Onset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Severity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RelievingFactor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AssociatedSymptoms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `secondary_complains` */

insert  into `secondary_complains`(`id`,`form_id`,`GnInfoId`,`Description`,`Onset`,`Duration`,`Severity`,`RelievingFactor`,`AssociatedSymptoms`,`created_at`,`updated_at`) values 
(6,NULL,8,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Description','Onset','Duration','9','Aggravating/Relieving Factors','Associated Symptoms','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `skin_diseases` */


CREATE TABLE `skin_diseases` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `Rashes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnsetOfRashes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `StartedFrom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Itching` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Fever` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Coryza` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `skin_diseases` */

insert  into `skin_diseases`(`id`,`form_id`,`GnInfoId`,`Rashes`,`OnsetOfRashes`,`Site`,`StartedFrom`,`Itching`,`Fever`,`Coryza`,`created_at`,`updated_at`) values 
(8,NULL,8,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Macular','Onset of rashes','Site','Started From','Itching','onset','Coryza','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `sleep_routines` */


CREATE TABLE `sleep_routines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `BedTime` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepDuration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepQuality` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BedtimeRoutine` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DaytimeNaps` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SnoringOrBreathing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RestlessnessDuringSleep` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepEnvironment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepRelatedBehaviors` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AffectingSleep` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ImpactingSleep` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Enuresis` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ImmunizationHistory` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `sleep_routines` */

insert  into `sleep_routines`(`id`,`form_id`,`GnInfoId`,`BedTime`,`SleepDuration`,`SleepQuality`,`BedtimeRoutine`,`DaytimeNaps`,`SnoringOrBreathing`,`RestlessnessDuringSleep`,`SleepEnvironment`,`SleepRelatedBehaviors`,`AffectingSleep`,`ImpactingSleep`,`Enuresis`,`ImmunizationHistory`,`created_at`,`updated_at`) values 
(8,NULL,8,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Bed time','Sleep duration','1','Bedtime routine','Daytime naps','Snoring or breathing difficulties','Restlessness during sleep','Sleep environment (noise, light, etc.)','Sleep-related behaviors (sleepwalking, teeth grinding, etc.)','Medical conditions affecting sleep','Medications impacting sleep','Enuresis','Immunization history','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `sobs` */


CREATE TABLE `sobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `OnExertion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnRst` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `sobs` */

insert  into `sobs`(`id`,`form_id`,`GnInfoId`,`OnExertion`,`OnRst`,`created_at`,`updated_at`) values 
(8,NULL,8,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'on exertion','on rest','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `socioeconomics` */


CREATE TABLE `socioeconomics` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `Water` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Milk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Rooms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AnySick people at home` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `infectious_disease` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FatherOccupation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DDX` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NoteToPrincipal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NoteToParent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `socioeconomics` */

insert  into `socioeconomics`(`id`,`form_id`,`GnInfoId`,`Water`,`Milk`,`Rooms`,`AnySick people at home`,`infectious_disease`,`FatherOccupation`,`DDX`,`NoteToPrincipal`,`NoteToParent`,`Picture`,`created_at`,`updated_at`) values 
(8,NULL,8,'Boiled','Boiled (unpasturized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-55998.jpeg','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-2475.jpeg','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-24271.jpeg','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-54790.pdf','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-8273.jpeg','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Boiled','Boiled (unpasturized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-13017.jpeg','2024-04-01 19:53:03','2024-04-01 20:21:29'),
(14,NULL,17,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-90942.pdf','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Tap','Boiled (unpasturized milk)','2',NULL,'Yes','Clerick','DDX','Note to principal','Note to parent','patient-53783.pdf','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `student_registrations` */


CREATE TABLE `student_registrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gr_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `student_registrations` */

/*Table structure for table `students` */


CREATE TABLE `students` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `age` int(11) DEFAULT NULL,
  `blood_group` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `height` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bmi` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_id` int(11) NOT NULL,
  `guardian_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_relation` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `students_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `students` */

insert  into `students`(`id`,`first_name`,`last_name`,`email`,`password`,`phone`,`gender`,`age`,`blood_group`,`height`,`weight`,`grade`,`bmi`,`school_id`,`guardian_name`,`guardian_email`,`guardian_phone`,`guardian_relation`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`) values 
(1,'Student','First','student@biopharmainfo.net','$2y$10$FbSKNXew45AkG5nXURV08O3GhyRUzSV0y1KudrTtNwS/wqGUm14Rm','1','male',NULL,NULL,NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,NULL,1,1,NULL,'2023-10-24 16:49:44','2023-10-24 16:49:44');

/*Table structure for table `upper_resps` */


CREATE TABLE `upper_resps` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `SoreThroat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `EarAche` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `EarDischarge` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RunnyNse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `upper_resps` */

insert  into `upper_resps`(`id`,`form_id`,`GnInfoId`,`SoreThroat`,`EarAche`,`EarDischarge`,`RunnyNse`,`created_at`,`updated_at`) values 
(8,NULL,8,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Sore throat','Ear Ache','White','Runny nose','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `users` */


CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `fullname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` int(11) NOT NULL,
  `gender` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_card_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `role` int(11) NOT NULL DEFAULT '2',
  `school_id` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cnic` longtext COLLATE utf8mb4_unicode_ci,
  `pmdc` longtext COLLATE utf8mb4_unicode_ci,
  `cnic_file` longtext COLLATE utf8mb4_unicode_ci,
  `pmdc_file` longtext COLLATE utf8mb4_unicode_ci,
  `cv` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `users` */

insert  into `users`(`id`,`fullname`,`email`,`phone`,`address`,`age`,`gender`,`id_card_no`,`password`,`status`,`role`,`school_id`,`created_by`,`updated_by`,`created_at`,`updated_at`,`deleted_at`,`remember_token`,`cnic`,`pmdc`,`cnic_file`,`pmdc_file`,`cv`) values 
(1,'Dr. Naqvi','dr.naqvi@biopharmainfo.net','-','-',50,'male','-','$2y$10$jLe5TO6ZpFnlpLFES.yYY.msjYr2gcWAL1Q3JWFFaajyMUTzjU066',1,1,NULL,1,1,'2023-10-24 16:49:44','2024-01-15 21:12:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(12,'Nayab Gohar','nayab@bicphs.com','03342986754','Home',23,'female',NULL,'$2y$10$zrCg.kPx/1fbb/WIoWEwreHtvt9mHg.6gQzcD6z/IniHt8bhaRCOy',1,1,NULL,1,1,'2024-01-11 10:33:59','2024-01-11 10:33:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(13,'Dr Aiman Aziz','azizaiman56@gmail.com','03331227523','Corniche society',25,'female',NULL,'$2y$10$CX3FyzDKMC6V97OGliwLSuJ8C2G/GHPC9TPG.X9ukTQxpRS6vVixW',1,2,1,1,1,'2024-01-11 11:05:47','2024-01-16 05:08:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(14,'Dr Marium Anwer','drmariamanwar098@gmail.com','03202212791','Aisha vision health clinic ,Bahadrabad',27,'female',NULL,'$2y$10$vTMEZgjzeh3fsBUbpV2gLeKtdhb7.Wsf/BenvZ2dCHjK8cDHqVXom',1,1,NULL,1,1,'2024-01-11 11:09:04','2024-01-11 11:09:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(15,'Syed Muhammad Murtaza','murtazabukhari118@gmail.com','03342164480','sadar',25,'male',NULL,'$2y$10$78HJmBbKPGSMPpZRp11pBOF9LD9z.ikFqeOgqXWK2W7mNlLqf8uUy',1,2,2,1,1,'2024-01-15 10:54:26','2024-01-16 05:09:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(16,'Sadia fazal','sadia.fazal667@gmail.com','03412362090','saddar karachi',32,'female',NULL,'$2y$10$.eYtwXsdfGzo1S6ps9yRO.JIGRqDJpHX5huSgotVrNEjpF4KJ07Ly',1,1,NULL,1,1,'2024-01-17 07:46:06','2024-01-17 07:46:06',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(17,'TestUser','testuser@ghazitech.com','00000000','None',33,'male','0000','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi',1,1,NULL,17,17,'2024-01-23 12:53:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(18,'Dr Nadia Mehnaz','nadiamehnaz8@gmail.com','03122996612','House no -A-7 good earth banglous,scheem 33,karachi',28,'female',NULL,'$2y$10$Pv7cEenKgjIgG/lNwoKyou57uyEWAzCLYLsAi1vLYJe6S0GG9qSJy',1,2,1,1,1,'2024-01-29 04:35:12','2024-01-29 04:35:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(19,'Dr Mustafa','mustafa@bicphs.com','0','-',40,'male',NULL,'$2y$10$H1hYPE3WkD56e9MorxTQMum/O/35N.BLBQI3JG9bjhYCXIZgrAcKe',1,1,NULL,1,1,'2024-01-31 20:19:42','2024-01-31 20:19:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(20,'Hadiqa Fazil','Hadiqafazil97@gmail.com','03000249546','Gulshan-e-iqbal',27,'female',NULL,'$2y$10$W7oPdYq.iRSGeuLmIEGwUetazataxTV0cqpRREhsm5vBNQBmFQEn.',1,1,1,1,1,'2024-02-06 08:38:55','2024-02-06 08:38:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(21,'Namra Naseer','namranaseer.nn@gmail.com','03084403791','696/ C Block 2 PECHS Tariq Road Karachi',27,'female',NULL,'$2y$10$DTzqU.qBvaJN1bUJb3bXQe8cE5F/N.52OWbzgtolxIpteFgEQBpsW',1,1,1,1,1,'2024-02-23 10:41:55','2024-02-23 10:42:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(22,'Dr Madiha Sikandar','sikandermadiha@gmail.com','03323259679','Hanging Gardens Flat no 9 Clifton Block 5',27,'female',NULL,'$2y$10$Hul3ukSw1LgD4KZzJim3TuEYhBeaCTlxJe1Gzyk2SVaYmQMxxEjEm',1,2,3,1,1,'2024-02-23 10:45:05','2024-02-23 10:45:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(23,'Dr. Hareem Riaz','hareem.riaz@gmail.com','03213844548','81 Q/2, PECHS Block 2. Karachi',33,'female',NULL,'$2y$10$qGL/Eo1/lbuWMTyfQ4JqcuJE1FYntfEtg34kHzrQ2MTUfGLsRB8W2',1,1,NULL,1,1,'2024-03-11 05:31:18','2024-03-13 03:07:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `vital_signs` */


CREATE TABLE `vital_signs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `pulse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `temperature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RespiratoryRate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bmi_weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bmi_height` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `vital_signs` */

insert  into `vital_signs`(`id`,`form_id`,`GnInfoId`,`pulse`,`temperature`,`bp`,`RespiratoryRate`,`bmi_weight`,`bmi_height`,`created_at`,`updated_at`) values 
(6,NULL,8,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Pulse','Temperature','bp','Respiratory Rate','BMI Weight','BMI Height','2024-04-01 21:01:01','2024-04-01 21:01:01');

