--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Table structure for table `__efmigrationshistory`
--

CREATE TABLE `__efmigrationshistory` (
  `MigrationId` varchar(150) NOT NULL,
  `ProductVersion` varchar(32) NOT NULL,
  PRIMARY KEY (`MigrationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `adclickreports`
--

CREATE TABLE `adclickreports` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ServiceId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `AdCompanyId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Day` int NOT NULL,
  `Month` int NOT NULL,
  `Year` int NOT NULL,
  `TotalClick` int NOT NULL,
  `TotalConfirm` int NOT NULL,
  `TotalConversion` int NOT NULL,
  `UpdateDate` datetime(6) NOT NULL,
  `ClickConversionByMonth` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_AdClickReports_AdCompanyId` (`AdCompanyId`),
  KEY `IX_AdClickReports_ServiceId` (`ServiceId`),
  CONSTRAINT `FK_AdClickReports_AdCompany_AdCompanyId` FOREIGN KEY (`AdCompanyId`) REFERENCES `adcompany` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_AdClickReports_Services_ServiceId` FOREIGN KEY (`ServiceId`) REFERENCES `services` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8509 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `adclicks`
--

CREATE TABLE `adclicks` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ClickId` longtext NOT NULL,
  `PhoneNumber` longtext,
  `serviceId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `Url` longtext NOT NULL,
  `CreateDate` datetime(6) NOT NULL,
  `Year` int NOT NULL,
  `Month` int NOT NULL,
  `Day` int NOT NULL,
  `AdCompanyId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_AdClicks_AdCompanyId` (`AdCompanyId`),
  KEY `IX_AdClicks_serviceId` (`serviceId`),
  KEY `Month` (`Month`),
  KEY `Year` (`Year`),
  KEY `Day` (`Day`),
  CONSTRAINT `FK_AdClicks_AdCompany_AdCompanyId` FOREIGN KEY (`AdCompanyId`) REFERENCES `adcompany` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_AdClicks_Services_serviceId` FOREIGN KEY (`serviceId`) REFERENCES `services` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3451793 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `adcompany`
--

CREATE TABLE `adcompany` (
  `Id` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Name` longtext NOT NULL,
  `Description` longtext,
  `CallBackUrl` longtext,
  `CreateDate` datetime(6) NOT NULL,
  `Params` longtext,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `aspnetroleclaims`
--

CREATE TABLE `aspnetroleclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `RoleId` varchar(255) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_AspNetRoleClaims_RoleId` (`RoleId`),
  CONSTRAINT `FK_AspNetRoleClaims_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `aspnetroles`
--

CREATE TABLE `aspnetroles` (
  `Id` varchar(255) NOT NULL,
  `Name` varchar(256) DEFAULT NULL,
  `NormalizedName` varchar(256) DEFAULT NULL,
  `ConcurrencyStamp` longtext,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `RoleNameIndex` (`NormalizedName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `aspnetuserclaims`
--

CREATE TABLE `aspnetuserclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserId` varchar(255) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_AspNetUserClaims_UserId` (`UserId`),
  CONSTRAINT `FK_AspNetUserClaims_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `aspnetuserlogins`
--

CREATE TABLE `aspnetuserlogins` (
  `LoginProvider` varchar(255) NOT NULL,
  `ProviderKey` varchar(255) NOT NULL,
  `ProviderDisplayName` longtext,
  `UserId` varchar(255) NOT NULL,
  PRIMARY KEY (`LoginProvider`,`ProviderKey`),
  KEY `IX_AspNetUserLogins_UserId` (`UserId`),
  CONSTRAINT `FK_AspNetUserLogins_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `aspnetuserroles`
--

CREATE TABLE `aspnetuserroles` (
  `UserId` varchar(255) NOT NULL,
  `RoleId` varchar(255) NOT NULL,
  PRIMARY KEY (`UserId`,`RoleId`),
  KEY `IX_AspNetUserRoles_RoleId` (`RoleId`),
  CONSTRAINT `FK_AspNetUserRoles_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_AspNetUserRoles_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `aspnetusertokens`
--

CREATE TABLE `aspnetusertokens` (
  `UserId` varchar(255) NOT NULL,
  `LoginProvider` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Value` longtext,
  PRIMARY KEY (`UserId`,`LoginProvider`,`Name`),
  CONSTRAINT `FK_AspNetUserTokens_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `chargingservicelogs`
--

CREATE TABLE `chargingservicelogs` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Year` int NOT NULL,
  `Month` int NOT NULL,
  `Day` int NOT NULL,
  `TotalCharging` int NOT NULL,
  `create_at` datetime(6) NOT NULL,
  `ServiceId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_chargingServiceLogs_ServiceId` (`ServiceId`),
  CONSTRAINT `FK_chargingServiceLogs_Services_ServiceId` FOREIGN KEY (`ServiceId`) REFERENCES `services` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5194 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `landingpage`
--

CREATE TABLE `landingpage` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ServiceId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `URL` longtext NOT NULL,
  `LastUpdate` datetime(6) NOT NULL,
  `IsActive` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_LandingPage_ServiceId` (`ServiceId`),
  CONSTRAINT `FK_LandingPage_Services_ServiceId` FOREIGN KEY (`ServiceId`) REFERENCES `services` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `landingpagelogs`
--

CREATE TABLE `landingpagelogs` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `LandingPageId` int NOT NULL,
  `Status` tinyint(1) NOT NULL,
  `DateTime` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_LandingPageLogs_LandingPageId` (`LandingPageId`),
  CONSTRAINT `FK_LandingPageLogs_LandingPage_LandingPageId` FOREIGN KEY (`LandingPageId`) REFERENCES `landingpage` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=260353 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `Id` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Name` longtext NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `dateLive` datetime(6) NOT NULL,
  `url` longtext NOT NULL,
  `company` int NOT NULL,
  `CheckUsersAPI` longtext,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `servicesubscribers`
--

CREATE TABLE `servicesubscribers` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `subscriberPhone` varchar(255) NOT NULL,
  `ServiceId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `IsSubscribed` tinyint(1) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ServiceSubscribers_ServiceId` (`ServiceId`),
  KEY `IX_ServiceSubscribers_subscriberPhone` (`subscriberPhone`),
  CONSTRAINT `FK_ServiceSubscribers_Services_ServiceId` FOREIGN KEY (`ServiceId`) REFERENCES `services` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_ServiceSubscribers_Subscribers_subscriberPhone` FOREIGN KEY (`subscriberPhone`) REFERENCES `subscribers` (`phone`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=530290 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `phone` varchar(255) NOT NULL,
  `create_at` datetime(6) NOT NULL,
  PRIMARY KEY (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `subscriptionlogs`
--

CREATE TABLE `subscriptionlogs` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ServiceSubscriberId` int NOT NULL,
  `date` datetime(6) NOT NULL,
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_subscriptionLogs_ServiceSubscriberId` (`ServiceSubscriberId`),
  CONSTRAINT `FK_subscriptionLogs_ServiceSubscribers_ServiceSubscriberId` FOREIGN KEY (`ServiceSubscriberId`) REFERENCES `servicesubscribers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28089432 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `serviceSubscriberId` int NOT NULL,
  `start` datetime(6) NOT NULL,
  `end` datetime(6) DEFAULT NULL,
  `days` double DEFAULT NULL,
  `amount` decimal(65,30) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_subscriptions_serviceSubscriberId` (`serviceSubscriberId`),
  CONSTRAINT `FK_subscriptions_ServiceSubscribers_serviceSubscriberId` FOREIGN KEY (`serviceSubscriberId`) REFERENCES `servicesubscribers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=957934 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `sudanipushnotifymodels`
--

CREATE TABLE `sudanipushnotifymodels` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `msisdn` longtext NOT NULL,
  `service_code` longtext NOT NULL,
  `status` longtext NOT NULL,
  `sub_date` date DEFAULT NULL,
  `expire_date` text,
  `retry_date` longtext,
  `createDate` datetime(6) NOT NULL,
  `ServiceId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Day` int NOT NULL DEFAULT '0',
  `Month` int NOT NULL DEFAULT '0',
  `Year` int NOT NULL DEFAULT '0',
  `previous_subscribed` tinyint(1) DEFAULT NULL,
  `unsubscription` tinyint(1) DEFAULT NULL,
  `amount` decimal(65,30) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_SudaniPushNotifyModels_ServiceId` (`ServiceId`),
  KEY `day_index` (`Day`),
  KEY `month_index` (`Month`),
  KEY `year_index` (`Year`),
  CONSTRAINT `FK_SudaniPushNotifyModels_Services_ServiceId` FOREIGN KEY (`ServiceId`) REFERENCES `services` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18641841 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `sudaniservicereports`
--

CREATE TABLE `sudaniservicereports` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ServiceId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Day` int NOT NULL,
  `Month` int NOT NULL,
  `Year` int NOT NULL,
  `TotalNew` int NOT NULL,
  `TotalUnsub` int NOT NULL,
  `Total` int NOT NULL,
  `TotalAmount` decimal(65,30) NOT NULL,
  `UpdateDate` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_SudaniServiceReports_ServiceId` (`ServiceId`),
  CONSTRAINT `FK_SudaniServiceReports_Services_ServiceId` FOREIGN KEY (`ServiceId`) REFERENCES `services` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6694 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `__efmigrationshistory`
--

INSERT INTO `__efmigrationshistory` VALUES ('20220619132156_inital','6.0.6'),('20220619140122_updateDB','6.0.6'),('20220623081332_nullcolmuns','6.0.6'),('20220728091740_AddTables','6.0.7'),('20220801074211_addTable','6.0.7'),('20220801110635_editdaysType','6.0.7'),('20220901104421_init','6.0.7'),('20230904091403_addnewtable','6.0.7'),('20230904111740_addcheckapiservice','6.0.7'),('20230904114306_deletetable','6.0.7'),('20230904114503_AddServiceLog','6.0.7'),('20230904125845_AddServiceLogUpdate','6.0.7'),('20231106110920_initAll','6.0.7'),('20231106120324_adddatetonotify','6.0.7'),('20231107145702_adddatetonotifycapital','6.0.7'),('20231204170803_editsudaniNotfication','6.0.7'),('20231204172214_editsudaniNotficationbool','6.0.7'),('20231204172629_editsudaniNotficationdecimal','6.0.7'),('20240505130657_editsudanipush','6.0.7'),('20240521181833_editSudanipushmigr','6.0.7'),('20240522055835_editsubdate','6.0.7'),('20241127160933_addreportEntity','6.0.7'),('20250105190057_Adcomps','8.0.11'),('20250105190544_Adcompsnullparams','8.0.11'),('20250106120853_AdClicks','8.0.11'),('20250112130605_statusClickad','8.0.11'),('20250123111657_addlandingpage','8.0.11'),('20250123112018_sericeIdfix','8.0.11');


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `adclickreports`
--
-- WHERE:  1=1 LIMIT 10

INSERT INTO `adclickreports` VALUES (1,'07280e85-9a62-420f-a90f-6f9be9322a6e','08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',25,5,2025,0,0,0,'2025-05-25 23:59:43.874004',0),(2,'07280e85-9a62-420f-a90f-6f9be9322a6e','08dd309e-a0d4-4bcf-879a-2c0e35e949f6',25,5,2025,0,0,0,'2025-05-25 23:59:43.889090',0),(3,'07280e85-9a62-420f-a90f-6f9be9322a6e','08dd34ca-6d18-4f89-8f05-96b86eb43b00',25,5,2025,0,0,0,'2025-05-25 23:59:43.901505',0),(4,'07280e85-9a62-420f-a90f-6f9be9322a6e','08dd4aa9-5856-4f8d-875b-025449237bb1',25,5,2025,0,0,0,'2025-05-25 23:59:43.915236',0),(5,'08a372e3-335a-4ed4-a2d1-073d976ec0fe','08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',25,5,2025,0,0,0,'2025-05-25 23:59:43.928089',0),(6,'08a372e3-335a-4ed4-a2d1-073d976ec0fe','08dd309e-a0d4-4bcf-879a-2c0e35e949f6',25,5,2025,0,0,0,'2025-05-25 23:59:43.940859',0),(7,'08a372e3-335a-4ed4-a2d1-073d976ec0fe','08dd34ca-6d18-4f89-8f05-96b86eb43b00',25,5,2025,0,0,0,'2025-05-25 23:59:43.954740',0),(8,'08a372e3-335a-4ed4-a2d1-073d976ec0fe','08dd4aa9-5856-4f8d-875b-025449237bb1',25,5,2025,0,0,0,'2025-05-25 23:59:43.970217',0),(9,'15601bed-4a50-49e6-b3f2-2e98a4890e25','08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',25,5,2025,0,0,0,'2025-05-25 23:59:43.985841',0),(10,'15601bed-4a50-49e6-b3f2-2e98a4890e25','08dd309e-a0d4-4bcf-879a-2c0e35e949f6',25,5,2025,0,0,0,'2025-05-25 23:59:43.999519',0);


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `adclicks`
--
-- WHERE:  1=1 LIMIT 10

INSERT INTO `adclicks` VALUES (2,'1',NULL,'d46256ab-707a-4422-b00b-d043c5c4dcbc','','2025-01-06 12:30:23.454309',2025,1,6,'08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',2),(3,'1','2499','d46256ab-707a-4422-b00b-d043c5c4dcbc','','2025-01-06 12:45:04.653908',2025,1,6,'08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',0),(4,'1','2499','d46256ab-707a-4422-b00b-d043c5c4dcbc','','2025-01-06 12:45:15.722434',2025,1,6,'08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',0),(5,'1','2499','d46256ab-707a-4422-b00b-d043c5c4dcbc','http://sudanipay.com/subscription/hatrick/hatrick','2025-01-06 12:47:41.866762',2025,1,6,'08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',0),(6,'1','2499','d46256ab-707a-4422-b00b-d043c5c4dcbc','http://sudanipay.com/subscription/hatrick/hatrick','2025-01-06 12:47:48.525918',2025,1,6,'08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',0),(7,'1','2499','d46256ab-707a-4422-b00b-d043c5c4dcbc','sudanipay.com/subscription/hatrick/hatrick','2025-01-08 11:21:42.535720',2025,1,8,'08dd2e4d-b6ff-4fd0-893b-209c16d8ee48',0),(8,'1','2499','07280e85-9a62-420f-a90f-6f9be9322a6e','','2025-01-09 11:42:15.387720',2025,1,9,'08dd309e-a0d4-4bcf-879a-2c0e35e949f6',0),(9,'1','2499','07280e85-9a62-420f-a90f-6f9be9322a6e','','2025-01-09 11:42:30.466790',2025,1,9,'08dd309e-a0d4-4bcf-879a-2c0e35e949f6',0),(10,'6468333675',NULL,'07280e85-9a62-420f-a90f-6f9be9322a6e','','2025-01-09 11:55:46.011395',2025,1,9,'08dd309e-a0d4-4bcf-879a-2c0e35e949f6',0),(11,'6468335377',NULL,'07280e85-9a62-420f-a90f-6f9be9322a6e','','2025-01-09 11:56:24.347345',2025,1,9,'08dd309e-a0d4-4bcf-879a-2c0e35e949f6',0);


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `adcompany`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `adcompany` VALUES ('08dd2e4d-b6ff-4fd0-893b-209c16d8ee48','Mobile Arts','Test integration','https://apis.mymobibox.mobi/API/Auth/Tracking/S2S_CallBack.aspx','2025-01-06 12:29:07.406178','[\"MobiBox_Ref_ID\"]'),('08dd309e-a0d4-4bcf-879a-2c0e35e949f6','Golden Goose','Test integration',' https://n.gg.agency/ntf1/?token=43ab4448ce6953008a69b6c325b3a0d8','2025-01-09 11:13:21.774058','[\"click_id\"]'),('08dd34ca-6d18-4f89-8f05-96b86eb43b00','test zain ','forword parameters','http://dashboard.nxtserver.com/','2025-01-14 18:36:57.484000','[\"click_id\"]'),('08dd4aa9-5856-4f8d-875b-025449237bb1','Mobiqium','----','https://smobipiumlink.com/conversion/index.php','2025-02-11 14:35:34.849599','[\"jp\"]');


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `aspnetroleclaims`
--
-- WHERE:  1=1 LIMIT 50



--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `aspnetroles`
--
-- WHERE:  1=1 LIMIT 50



--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `aspnetuserclaims`
--
-- WHERE:  1=1 LIMIT 50



--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `aspnetuserlogins`
--
-- WHERE:  1=1 LIMIT 50



--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `aspnetuserroles`
--
-- WHERE:  1=1 LIMIT 50



--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------



--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `aspnetusertokens`
--
-- WHERE:  1=1 LIMIT 50



--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `chargingservicelogs`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `chargingservicelogs` VALUES (1,2023,9,20,1,'2023-09-20 02:00:04.021402','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(2,2023,9,20,3,'2023-09-20 02:00:04.413886','6f0a0077-e64b-42b2-823f-a121725f43b7'),(3,2023,9,20,13050,'2023-09-20 04:52:06.278628','07280e85-9a62-420f-a90f-6f9be9322a6e'),(4,2023,9,20,40527,'2023-09-20 17:17:26.044818','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(5,2023,9,20,16575,'2023-09-20 07:05:10.025414','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(6,2023,9,20,274,'2023-09-20 07:59:00.039581','76a4d141-2f39-4fbb-9374-ce196384e539'),(7,2023,9,21,1,'2023-09-21 11:01:27.380925','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(8,2023,9,21,3,'2023-09-21 11:01:27.350543','6f0a0077-e64b-42b2-823f-a121725f43b7'),(9,2023,9,21,274,'2023-09-21 11:43:58.029578','76a4d141-2f39-4fbb-9374-ce196384e539'),(10,2023,9,21,13217,'2023-09-21 13:53:43.351399','07280e85-9a62-420f-a90f-6f9be9322a6e'),(11,2023,9,21,18571,'2023-09-21 16:33:55.860448','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(12,2023,9,21,16879,'2023-09-21 16:06:31.701329','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(13,2023,9,22,1,'2023-09-22 02:00:03.818436','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(14,2023,9,22,3,'2023-09-22 02:00:04.527767','6f0a0077-e64b-42b2-823f-a121725f43b7'),(15,2023,9,22,10541,'2023-09-22 16:28:08.103051','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(16,2023,9,22,274,'2023-09-22 02:42:32.896661','76a4d141-2f39-4fbb-9374-ce196384e539'),(17,2023,9,22,13060,'2023-09-22 04:52:29.530629','07280e85-9a62-420f-a90f-6f9be9322a6e'),(18,2023,9,22,16658,'2023-09-22 07:05:12.890519','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(19,2023,9,23,1,'2023-09-23 02:00:03.834242','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(20,2023,9,23,3,'2023-09-23 02:00:04.453574','6f0a0077-e64b-42b2-823f-a121725f43b7'),(21,2023,9,23,274,'2023-09-23 02:42:54.416548','76a4d141-2f39-4fbb-9374-ce196384e539'),(22,2023,9,23,12892,'2023-09-23 04:53:51.985329','07280e85-9a62-420f-a90f-6f9be9322a6e'),(23,2023,9,23,16240,'2023-09-23 07:07:15.747007','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(24,2023,9,23,40215,'2023-09-23 17:01:58.076786','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(25,2023,9,24,1,'2023-09-24 02:00:03.708965','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(26,2023,9,24,3,'2023-09-24 02:00:03.942777','6f0a0077-e64b-42b2-823f-a121725f43b7'),(27,2023,9,24,274,'2023-09-24 02:41:36.869999','76a4d141-2f39-4fbb-9374-ce196384e539'),(28,2023,9,24,12895,'2023-09-24 04:49:01.249446','07280e85-9a62-420f-a90f-6f9be9322a6e'),(29,2023,9,24,16273,'2023-09-24 06:58:54.929364','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(30,2023,9,24,40418,'2023-09-24 16:40:25.794303','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(31,2023,9,25,1,'2023-09-25 02:00:03.677995','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(32,2023,9,25,3,'2023-09-25 02:00:04.396220','6f0a0077-e64b-42b2-823f-a121725f43b7'),(33,2023,9,25,274,'2023-09-25 02:41:46.967803','76a4d141-2f39-4fbb-9374-ce196384e539'),(34,2023,9,25,12904,'2023-09-25 04:49:23.581562','07280e85-9a62-420f-a90f-6f9be9322a6e'),(35,2023,9,25,16219,'2023-09-25 06:59:33.055800','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(36,2023,9,25,159083,'2023-09-25 11:12:39.323030','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(37,2023,9,26,1,'2023-09-26 02:00:03.519394','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(38,2023,9,26,3,'2023-09-26 02:00:03.856309','6f0a0077-e64b-42b2-823f-a121725f43b7'),(39,2023,9,26,274,'2023-09-26 02:41:45.698311','76a4d141-2f39-4fbb-9374-ce196384e539'),(40,2023,9,26,12775,'2023-09-26 04:49:54.706871','07280e85-9a62-420f-a90f-6f9be9322a6e'),(41,2023,9,26,16076,'2023-09-26 07:00:51.330507','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(42,2023,9,26,39678,'2023-09-26 16:51:23.638160','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(43,2023,9,27,1,'2023-09-27 17:16:00.371348','a982a115-a36a-4ec8-bc0c-206f2e72fa20'),(44,2023,9,27,3,'2023-09-27 17:16:00.602094','6f0a0077-e64b-42b2-823f-a121725f43b7'),(45,2023,9,27,273,'2023-09-27 17:57:16.412108','76a4d141-2f39-4fbb-9374-ce196384e539'),(46,2023,9,27,13059,'2023-09-27 20:05:50.834010','07280e85-9a62-420f-a90f-6f9be9322a6e'),(47,2023,9,27,16477,'2023-09-27 22:18:17.367266','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1'),(48,2023,9,27,159050,'2023-09-27 17:14:39.191959','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(49,2023,9,28,39660,'2023-09-28 16:56:16.441398','1e883fde-7cde-400e-91e5-70d3cc6b83c1'),(50,2023,9,28,1,'2023-09-28 02:00:03.686358','a982a115-a36a-4ec8-bc0c-206f2e72fa20');


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `landingpage`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `landingpage` VALUES (4,'54dae7f9-29ce-49bd-b484-8d2a651f79b8','https://dsplp.sd.zain.com/?p=2986526485&click_id=22233654','2025-09-15 19:45:47.518352',1),(5,'f0b71087-c93e-4829-a855-750adc5ce360','https://dsplp.sd.zain.com/?p=1451259342','2025-09-15 19:45:47.636739',1),(6,'07280e85-9a62-420f-a90f-6f9be9322a6e','https://sudanipay.com/subscription/soofra/soofra','2025-09-15 19:45:48.066209',1),(7,'f5fab354-5f30-4911-b02e-8eb3d61e5b33','https://sudanipay.com/subscription/farfish/farfish','2025-09-15 19:45:48.221899',1),(8,'15601bed-4a50-49e6-b3f2-2e98a4890e25','https://sudanipay.com/subscription/Wanees/wanees','2025-09-15 19:45:48.388660',1),(9,'1e883fde-7cde-400e-91e5-70d3cc6b83c1','https://sudanipay.com/subscription/hakaweena/hakaweena','2025-09-15 19:45:48.559601',1),(10,'6f0a0077-e64b-42b2-823f-a121725f43b7','https://sudanipay.com/subscription/shafakhana/shafakhana','2025-09-15 19:45:48.732360',1),(11,'a982a115-a36a-4ec8-bc0c-206f2e72fa20','https://sudanipay.com/subscription/mahaara/mahaara','2025-09-15 19:45:48.886234',1);


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `landingpagelogs`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `landingpagelogs` VALUES (1,4,1,'2025-01-26 22:08:14.474114'),(2,5,1,'2025-01-26 22:08:14.766984'),(3,6,1,'2025-01-26 22:08:15.410376'),(4,7,1,'2025-01-26 22:08:15.754874'),(5,8,1,'2025-01-26 22:08:16.125923'),(6,9,1,'2025-01-26 22:08:16.499585'),(7,10,1,'2025-01-26 22:08:16.892537'),(8,11,1,'2025-01-26 22:08:17.312668'),(9,4,1,'2025-01-26 22:18:14.308842'),(10,5,1,'2025-01-26 22:18:14.533047'),(11,6,1,'2025-01-26 22:18:15.113784'),(12,7,1,'2025-01-26 22:18:15.503474'),(13,8,1,'2025-01-26 22:18:15.878740'),(14,9,1,'2025-01-26 22:18:16.215634'),(15,10,1,'2025-01-26 22:18:16.571865'),(16,11,1,'2025-01-26 22:18:16.921044'),(18,4,1,'2025-01-26 22:20:37.039080'),(19,5,1,'2025-01-26 22:20:37.254528'),(20,6,1,'2025-01-26 22:20:37.823210'),(21,7,1,'2025-01-26 22:20:38.194668'),(22,8,1,'2025-01-26 22:20:38.584729'),(23,9,1,'2025-01-26 22:20:38.972055'),(24,10,1,'2025-01-26 22:20:39.334880'),(25,11,1,'2025-01-26 22:20:39.792702'),(27,4,1,'2025-01-26 22:22:59.807014'),(28,5,1,'2025-01-26 22:23:00.037431'),(29,6,1,'2025-01-26 22:23:00.608968'),(30,7,1,'2025-01-26 22:23:01.000609'),(31,8,1,'2025-01-26 22:23:01.384744'),(32,9,1,'2025-01-26 22:23:01.812498'),(33,10,1,'2025-01-26 22:23:02.194816'),(34,11,1,'2025-01-26 22:23:02.554774'),(36,4,1,'2025-01-26 22:25:22.973475'),(37,5,1,'2025-01-26 22:25:23.262393'),(38,6,1,'2025-01-26 22:25:23.819733'),(39,7,1,'2025-01-26 22:25:24.202064'),(40,8,1,'2025-01-26 22:25:24.597865'),(41,9,1,'2025-01-26 22:25:24.974208'),(42,10,1,'2025-01-26 22:25:25.338198'),(43,11,1,'2025-01-26 22:25:25.740236'),(45,4,1,'2025-01-26 22:26:38.773485'),(46,5,1,'2025-01-26 22:26:38.995580'),(47,6,1,'2025-01-26 22:26:39.581859'),(48,7,1,'2025-01-26 22:26:39.964014'),(49,8,1,'2025-01-26 22:26:40.339974'),(50,9,1,'2025-01-26 22:26:40.721607'),(51,10,1,'2025-01-26 22:26:41.079937'),(52,11,1,'2025-01-26 22:26:41.433894'),(54,4,1,'2025-01-26 22:36:36.658618'),(55,5,1,'2025-01-26 22:36:36.856753');


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `services`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `services` VALUES ('07280e85-9a62-420f-a90f-6f9be9322a6e','Soofra ','2022-09-25 08:03:58.000000','2023-11-01 11:18:39.931704','2022-10-01 00:00:00.000000','soofra.net',0,'http://soofra.net/sudani/addUsersToDashboard'),('08a372e3-335a-4ed4-a2d1-073d976ec0fe','Bookast','2023-03-01 14:00:20.963181','2023-03-01 14:00:20.963252','2023-03-01 16:00:00.000000','bookast.net',2,NULL),('15601bed-4a50-49e6-b3f2-2e98a4890e25','Waness','2024-05-19 09:14:58.915465','2024-05-19 09:14:58.915516','2024-05-01 12:14:00.000000','http://waness.net/',0,NULL),('1e883fde-7cde-400e-91e5-70d3cc6b83c1','hakaweena','2022-08-21 22:35:35.000000','2023-11-01 11:16:40.484701','2021-10-01 00:00:00.000000','hakaweena.com',0,NULL),('54dae7f9-29ce-49bd-b484-8d2a651f79b8','belhana','2022-07-28 13:40:48.000000','2024-03-19 10:52:32.304146','2022-08-01 00:00:00.000000','bilhana.net',1,NULL),('55bedf66-6c6b-4d2d-9a57-02492ab09e6d','Bookast Xceed','2024-11-04 10:22:49.853278','2024-11-04 10:22:49.853280','2024-11-01 12:22:00.000000','bookast.net',2,NULL),('68a14bd4-cebb-42f7-882b-82b12faeca25','marwa test api','2023-03-22 09:26:33.030660','2023-03-22 09:26:33.030662','2023-03-22 11:26:00.000000','test',1,NULL),('6f0a0077-e64b-42b2-823f-a121725f43b7','shafakhana','2022-12-18 07:26:12.000000','2023-09-19 09:43:35.556155','2022-12-20 00:00:00.000000','http://shafakhana.net/',0,'http://shafakhana.net/sudani/addUsersToDashboard'),('76a4d141-2f39-4fbb-9374-ce196384e539','mondialy','2022-11-19 16:07:00.000000','2023-11-01 12:20:33.853791','2022-11-20 00:00:00.000000','mondialy.net',0,'http://mondialy.net/sudani/addUsersToDashboard'),('a3df4755-000a-4044-93ae-f89593ac1058','ALVAR','2025-06-23 12:28:01.016811','2025-06-23 12:28:01.016861','2025-06-23 15:27:00.000000','http://al-var.com/',2,NULL),('a982a115-a36a-4ec8-bc0c-206f2e72fa20','Mahaara','2023-08-03 07:54:59.000000','2023-11-01 11:17:50.347649','2023-07-01 00:00:00.000000','http://mahaara.com/',0,NULL),('d46256ab-707a-4422-b00b-d043c5c4dcbc','hatrick Test','2022-08-08 11:47:13.000000','2024-12-18 13:44:03.784373','2022-08-08 13:47:00.000000','68.183.69.142',4,NULL),('f0b71087-c93e-4829-a855-750adc5ce360','TIRYAQ','2022-07-28 13:41:47.000000','2024-10-30 12:58:24.842065','2022-08-01 00:00:00.000000','164.92.184.24:8080',1,NULL),('f5fab354-5f30-4911-b02e-8eb3d61e5b33','Farfish','2022-08-26 21:03:23.000000','2023-10-31 17:48:24.690138','2022-08-26 23:03:00.000000','Farfish.net',0,NULL),('f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','Hatrick','2022-08-21 21:19:54.000000','2023-11-01 11:18:03.524652','2021-10-01 23:19:00.000000','hatrick.net',0,NULL),('f94c2e5e-cc90-4904-9edc-45cbfd208c5b','GazGiz','2025-06-24 08:18:31.033749','2025-06-24 08:18:31.033749','2025-06-23 11:18:00.000000','https://gazgiz.com/',2,NULL);


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `servicesubscribers`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `servicesubscribers` VALUES (12,'900986589','54dae7f9-29ce-49bd-b484-8d2a651f79b8','2022-08-03 07:36:23.730029',1,'2024-09-17 12:17:12.604086'),(13,'900986589','f0b71087-c93e-4829-a855-750adc5ce360','2022-08-03 08:00:29.966219',1,'2025-01-20 13:33:09.799981'),(14,'969188996','54dae7f9-29ce-49bd-b484-8d2a651f79b8','2022-08-03 08:16:36.732306',0,'2022-11-07 10:46:03.621135'),(15,'969188996','f0b71087-c93e-4829-a855-750adc5ce360','2022-08-03 09:49:54.218692',0,'2023-03-14 18:02:14.210792'),(16,'110012403','d46256ab-707a-4422-b00b-d043c5c4dcbc','2022-08-08 12:01:43.326765',1,'2022-08-21 07:08:44.281103'),(17,'119824204','d46256ab-707a-4422-b00b-d043c5c4dcbc','2022-08-09 08:19:15.788086',0,'2022-08-09 08:19:15.788086'),(18,'960788041','f0b71087-c93e-4829-a855-750adc5ce360','2022-08-10 12:40:29.963676',0,'2022-11-03 08:23:12.272460'),(19,'113200870','d46256ab-707a-4422-b00b-d043c5c4dcbc','2022-08-17 09:47:10.594981',1,'2022-08-17 09:47:10.594981'),(20,'100100753','d46256ab-707a-4422-b00b-d043c5c4dcbc','2022-08-17 12:29:42.549609',0,'2022-08-17 12:29:42.549609'),(21,'128725898','d46256ab-707a-4422-b00b-d043c5c4dcbc','2022-08-17 12:35:16.019054',0,'2022-08-17 12:58:28.492849'),(22,'120120630','d46256ab-707a-4422-b00b-d043c5c4dcbc','2022-08-21 08:01:05.682437',1,'2022-08-21 08:01:05.682437'),(23,'110012403','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-21 22:08:25.824143',0,'2023-01-11 11:24:42.876579'),(24,'110012403','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-21 22:52:40.042265',0,'2023-02-21 10:23:28.582959'),(25,'122507333','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-21 23:01:40.425063',1,'2024-07-25 21:32:36.947518'),(26,'119409987','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-21 23:30:10.893334',1,'2023-09-30 22:53:30.593833'),(27,'115972033','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-21 23:38:03.141206',0,'2022-08-21 23:38:03.141206'),(28,'915373955','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-21 23:43:01.455993',0,'2022-08-21 23:43:01.455993'),(29,'114006054','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 00:02:28.819681',1,'2023-09-30 22:53:30.854230'),(30,'963893721','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 01:57:03.458207',0,'2022-08-22 01:57:03.458207'),(31,'118460124','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 03:31:22.522875',0,'2024-02-29 14:42:03.476078'),(32,'114103105','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 03:42:54.468658',0,'2023-09-10 16:55:54.378074'),(33,'125605246','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 03:46:37.945363',1,'2023-09-30 22:53:31.112320'),(34,'124060497','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 04:15:46.690709',1,'2025-05-08 13:06:07.422003'),(35,'929244886','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 04:44:35.335352',0,'2022-08-22 04:44:35.335352'),(36,'124008416','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 05:00:43.370009',0,'2023-01-02 09:41:05.236119'),(37,'115613859','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 05:07:12.570209',0,'2022-08-22 05:07:12.570209'),(38,'129799227','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 06:25:14.563057',0,'2022-08-29 10:40:43.740907'),(39,'110641011','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 06:44:40.248296',0,'2024-02-29 14:43:44.831125'),(40,'111640966','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 07:28:57.027232',0,'2022-08-22 07:28:57.027232'),(41,'111640699','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 07:29:22.316687',0,'2024-08-11 08:26:02.508345'),(42,'120120912','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 07:37:50.531057',0,'2024-07-31 16:02:09.214679'),(43,'129405449','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 08:00:36.042987',0,'2023-09-20 13:32:30.809052'),(44,'119824204','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 08:33:17.823612',0,'2023-02-13 08:06:49.794763'),(45,'113200870','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 08:33:31.824580',1,'2023-01-03 19:43:45.172595'),(46,'119824204','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 08:35:35.688676',0,'2023-03-30 11:43:17.347365'),(47,'113200870','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 08:35:41.605246',1,'2022-12-02 09:44:50.813255'),(48,'120044795','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 08:53:27.538021',0,'2022-11-19 07:24:23.437839'),(49,'124439286','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 09:20:35.186397',0,'2022-08-22 09:20:35.186397'),(50,'117888112','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 09:23:31.038478',0,'2022-09-26 19:40:22.622281'),(51,'118735195','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 09:30:36.593989',0,'2023-09-10 16:55:56.596326'),(52,'126150212','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 09:41:17.426703',0,'2023-09-20 13:32:31.365638'),(53,'128780666','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 09:44:25.347838',0,'2022-08-22 09:44:25.347838'),(54,'116378549','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 09:45:17.017737',0,'2023-01-02 09:41:15.377555'),(55,'129592931','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 09:53:48.605418',0,'2022-08-22 09:53:48.605418'),(56,'124246704','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 09:53:51.597676',0,'2023-11-28 18:51:02.298083'),(57,'910481499','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 09:54:12.787081',0,'2022-08-22 09:54:12.787081'),(58,'125998009','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 10:01:54.848539',0,'2022-08-22 10:01:54.848539'),(59,'112939299','1e883fde-7cde-400e-91e5-70d3cc6b83c1','2022-08-22 10:03:18.879558',0,'2023-01-02 09:41:25.028896'),(60,'112387730','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 10:16:58.627240',1,'2023-11-08 07:49:41.483740'),(61,'116521297','f6c22909-28d4-493a-8e1d-5d1fd47c9ba1','2022-08-22 10:27:24.016286',0,'2023-09-25 04:55:31.404533');


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `subscribers`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `subscribers` VALUES (' 004 4239','2022-11-10 17:28:30.665294'),(' 012 0732','2024-02-29 11:50:27.807247'),('011012403','2024-02-15 12:57:05.290533'),('012892794','2022-10-02 18:19:18.454082'),('013569273','2023-01-08 06:56:59.528763'),('100000080','2023-09-20 11:21:18.509733'),('100000116','2022-09-01 07:14:58.288177'),('100000186','2022-10-24 19:24:13.398578'),('100000233','2022-08-22 22:29:31.758219'),('100000246','2022-08-22 13:27:06.385950'),('100000297','2022-11-22 12:43:41.585162'),('100000303','2022-12-25 21:37:35.036602'),('100000323','2022-10-26 14:37:23.153936'),('100000341','2023-01-23 20:22:12.923016'),('100000442','2023-01-11 13:56:46.349279'),('100000504','2023-09-20 02:52:10.156371'),('100000543','2023-09-10 13:15:05.832194'),('100000568','2022-08-23 05:59:53.054109'),('100000585','2022-08-22 17:20:43.981086'),('100000630','2022-08-22 13:02:12.998651'),('100000665','2022-08-22 13:17:28.701753'),('100000742','2022-08-22 16:20:09.723796'),('100000775','2022-11-25 07:53:19.365142'),('100000807','2023-09-20 08:45:29.520619'),('100000820','2022-08-30 14:58:45.316618'),('100000832','2022-12-16 14:59:10.639621'),('100000866','2025-06-09 10:24:38.954788'),('100001023','2023-01-30 19:12:09.195815'),('100001031','2023-01-08 15:33:50.240379'),('100001049','2022-09-20 05:42:14.377635'),('100001058','2023-09-20 11:40:34.106806'),('100001087','2022-08-29 20:44:46.206194'),('100001123','2023-01-28 06:28:28.518217'),('100001209','2022-08-25 19:22:48.122749'),('100001241','2022-10-02 05:27:13.800304'),('100001277','2023-01-23 03:59:23.955326'),('100001284','2023-09-20 10:51:27.307322'),('100001292','2022-12-18 16:55:03.286059'),('100001314','2022-11-20 21:44:40.125137'),('100001316','2022-09-07 16:20:31.918626'),('100001353','2022-08-22 22:37:02.840875'),('100001391','2023-01-18 20:10:01.472701'),('100001477','2023-01-11 13:57:57.211044'),('100001484','2022-11-23 21:16:33.984971'),('100001517','2023-01-27 16:12:42.260027'),('100001626','2022-12-09 12:30:08.182897'),('100001638','2022-09-04 09:23:26.825219'),('100001655','2023-09-20 08:03:18.946981'),('100001665','2022-08-22 15:00:47.868315'),('100001756','2023-09-20 11:14:58.454588');


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `subscriptionlogs`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `subscriptionlogs` VALUES (30,12,'2022-08-03 07:36:23.746663',1),(31,13,'2022-08-03 08:00:30.067518',1),(32,13,'2022-08-03 08:03:49.798824',1),(33,13,'2022-08-03 08:04:01.287720',0),(34,14,'2022-08-03 08:16:36.765843',1),(35,14,'2022-08-03 09:35:22.365235',1),(36,15,'2022-08-03 09:49:54.256023',1),(37,15,'2022-08-03 09:53:33.644861',1),(38,15,'2022-08-04 08:02:02.975724',1),(39,12,'2022-08-04 21:24:52.526549',1),(40,16,'2022-08-08 12:01:43.358947',1),(41,16,'2022-08-08 12:03:58.906393',0),(42,16,'2022-08-08 15:09:52.731056',0),(43,16,'2022-08-08 15:10:46.148125',1),(44,16,'2022-08-08 15:14:49.343241',1),(45,16,'2022-08-08 15:19:31.287477',0),(46,16,'2022-08-08 16:17:46.473359',0),(47,16,'2022-08-08 16:17:56.281146',0),(48,17,'2022-08-09 08:19:15.827178',0),(49,14,'2022-08-10 12:34:09.638237',1),(50,14,'2022-08-10 12:36:26.497909',1),(51,14,'2022-08-10 12:37:09.916803',0),(52,18,'2022-08-10 12:40:29.990461',1),(53,14,'2022-08-10 12:42:39.100854',1),(54,14,'2022-08-10 12:48:11.803772',1),(55,14,'2022-08-10 12:54:15.269385',1),(56,16,'2022-08-16 12:59:23.280399',0),(57,16,'2022-08-16 12:59:42.194974',0),(58,16,'2022-08-16 13:01:07.052077',1),(59,16,'2022-08-16 13:01:10.581989',1),(60,16,'2022-08-16 13:26:32.859807',1),(61,16,'2022-08-16 13:57:09.160672',1),(62,16,'2022-08-16 14:31:22.034626',1),(63,16,'2022-08-16 14:37:05.937922',1),(64,16,'2022-08-17 08:14:34.426875',1),(65,16,'2022-08-17 09:13:13.610268',1),(66,16,'2022-08-17 09:13:29.823498',0),(67,16,'2022-08-17 09:13:41.443950',0),(68,16,'2022-08-17 09:13:51.647906',1),(69,16,'2022-08-17 09:22:03.928928',1),(70,17,'2022-08-17 09:26:02.980133',0),(71,17,'2022-08-17 09:30:13.302031',0),(72,16,'2022-08-17 09:32:21.693169',1),(73,16,'2022-08-17 09:40:35.780208',1),(74,16,'2022-08-17 09:40:39.794003',1),(75,16,'2022-08-17 09:41:32.245170',1),(76,16,'2022-08-17 09:42:34.215093',1),(77,16,'2022-08-17 09:45:45.362391',1),(78,16,'2022-08-17 09:45:58.990187',1),(79,19,'2022-08-17 09:47:10.632113',1);


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `subscriptions`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `subscriptions` VALUES (13,12,'2022-08-03 07:36:23.730029','2022-09-05 07:20:44.093786',34,NULL),(14,13,'2022-08-03 08:00:29.966219','2022-08-03 08:04:01.239619',2,NULL),(15,14,'2022-08-03 08:16:36.732306','2022-08-10 12:37:09.890998',9,NULL),(16,15,'2022-08-03 09:49:54.218692','2022-11-03 08:23:21.832294',93,NULL),(17,16,'2022-08-08 12:01:43.326765','2022-08-08 12:03:58.876834',2,NULL),(18,16,'2022-08-08 15:10:46.123588','2022-08-08 15:19:31.249703',2,NULL),(19,18,'2022-08-10 12:40:29.963676','2022-11-03 08:23:12.272460',86,NULL),(20,14,'2022-08-10 12:42:39.079091','2022-09-12 12:41:53.146026',34,NULL),(21,16,'2022-08-16 13:01:06.987859','2022-08-17 09:13:29.773506',2,NULL),(22,16,'2022-08-17 09:13:51.626573','2022-08-21 07:05:00.175394',5,NULL),(23,19,'2022-08-17 09:47:10.594981',NULL,NULL,NULL),(24,21,'2022-08-17 12:35:16.019054','2022-08-17 12:58:28.492849',1,NULL),(25,16,'2022-08-21 07:07:32.666421','2022-08-21 07:08:24.621307',1,NULL),(26,16,'2022-08-21 07:08:44.281103',NULL,NULL,NULL),(27,22,'2022-08-21 08:01:05.682437',NULL,NULL,NULL),(28,23,'2022-08-21 22:11:39.794757','2022-08-21 22:18:54.273048',1,NULL),(29,23,'2022-08-21 22:19:35.756214','2022-08-22 12:15:57.785475',2,NULL),(30,24,'2022-08-21 22:52:40.042265','2022-08-21 22:55:59.882299',1,NULL),(31,25,'2022-08-21 23:01:40.425063','2023-01-02 09:40:28.346733',135,NULL),(32,26,'2022-08-21 23:31:09.281909','2023-01-02 09:40:38.390720',135,NULL),(33,29,'2022-08-22 00:02:46.649472','2023-09-21 13:04:53.020624',396,NULL),(34,31,'2022-08-22 03:31:57.146435','2022-12-13 09:55:53.520319',114,NULL),(35,32,'2022-08-22 03:42:54.468658','2023-09-10 16:55:54.378074',385,NULL),(36,33,'2022-08-22 03:46:37.945363','2023-09-21 13:04:53.267783',396,NULL),(37,34,'2022-08-22 04:15:46.690709','2023-09-10 16:55:55.113947',385,NULL),(38,36,'2022-08-22 05:00:43.370009','2023-01-02 09:41:05.236119',134,NULL),(39,38,'2022-08-22 06:25:24.995082','2022-08-29 10:40:43.740907',8,NULL),(40,39,'2022-08-22 06:44:40.248296','2023-09-21 13:04:54.031768',396,NULL),(41,41,'2022-08-22 07:29:22.316687','2022-11-17 15:15:44.376470',88,NULL),(42,42,'2022-08-22 07:37:50.531057','2022-09-28 07:42:01.255922',38,NULL),(43,43,'2022-08-22 08:00:53.741988','2023-09-20 13:32:30.809052',395,NULL),(44,48,'2022-08-22 08:53:27.538021','2022-11-19 07:24:23.437839',90,NULL),(45,24,'2022-08-22 09:26:06.528753','2022-08-22 09:55:13.112459',1,NULL),(46,51,'2022-08-22 09:30:36.593989','2023-09-10 16:55:56.596326',385,NULL),(47,52,'2022-08-22 09:41:17.426703','2023-09-20 13:32:31.365638',395,NULL),(48,56,'2022-08-22 09:53:51.597676','2023-01-24 19:39:54.587497',156,NULL),(49,24,'2022-08-22 09:55:25.909586','2022-08-22 12:24:44.345562',1,NULL),(50,59,'2022-08-22 10:03:32.811043','2023-01-02 09:41:25.028896',134,NULL),(51,60,'2022-08-22 10:16:58.627240','2023-09-10 16:55:57.336002',385,NULL),(52,61,'2022-08-22 10:27:24.016286','2022-12-25 06:17:25.638108',126,NULL),(53,64,'2022-08-22 10:43:03.917406','2023-09-20 13:32:32.162375',395,NULL),(54,66,'2022-08-22 10:56:21.107792','2023-09-21 13:04:55.976958',396,NULL),(55,67,'2022-08-22 10:58:26.222516','2023-01-19 09:12:22.204803',151,NULL),(56,68,'2022-08-22 11:03:01.541694','2023-09-10 16:55:58.790352',385,NULL),(57,70,'2022-08-22 11:20:24.854321','2022-09-09 17:59:45.950001',19,NULL),(58,72,'2022-08-22 11:31:40.670187','2023-09-21 13:04:56.478231',396,NULL),(59,73,'2022-08-22 11:58:45.427205','2022-11-04 10:49:44.456985',75,NULL),(60,74,'2022-08-22 12:21:34.438243','2023-09-20 13:32:33.228548',395,NULL),(61,75,'2022-08-22 12:23:44.634807',NULL,NULL,NULL),(62,76,'2022-08-22 12:23:44.871964','2023-09-20 09:34:19.816496',395,NULL);


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `sudanipushnotifymodels`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `sudanipushnotifymodels` VALUES (8,'249110733417','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-27','2023-11-08 20:35.14.0',NULL,'2023-11-07 17:37:53.822105','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(9,'249115561121','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-06','2023-11-08 20:35.20.0',NULL,'2023-11-07 17:37:54.214723','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(10,'249126932483','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-19','2023-11-08 20:35.13.0',NULL,'2023-11-07 17:37:54.635056','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(11,'249129459364','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-15','2023-11-08 20:35.43.0',NULL,'2023-11-07 17:38:15.200511','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(12,'249128475083','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-04','2023-11-08 20:37.42.0',NULL,'2023-11-07 17:40:15.857356','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(13,'249117866196','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-30','2023-11-08 20:39.35.0',NULL,'2023-11-07 17:42:16.500746','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(14,'249100142539','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-11','2023-11-08 20:39.50.0',NULL,'2023-11-07 17:42:37.069912','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(15,'249125185114','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-15','2023-11-08 20:40.52.0',NULL,'2023-11-07 17:43:37.596470','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(16,'249116362594','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-04','2023-11-08 20:41.16.0',NULL,'2023-11-07 17:43:58.067248','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(17,'249121050005','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-24','2023-11-08 20:41.29.0',NULL,'2023-11-07 17:44:18.532444','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(18,'249123775370','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-21','2023-11-08 20:41.50.0',NULL,'2023-11-07 17:44:39.111116','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(19,'249123650248','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-15','2023-11-08 20:42.06.0',NULL,'2023-11-07 17:44:39.520320','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(20,'249124510739','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-26','2023-11-08 20:42.09.0',NULL,'2023-11-07 17:44:59.980767','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(21,'249110810647','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-20','2023-11-08 20:42.47.0',NULL,'2023-11-07 17:45:20.429606','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(22,'249112620063','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-09','2023-11-08 20:42.44.0',NULL,'2023-11-07 17:45:20.826319','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(23,'249111669971','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-15','2023-11-08 20:43.09.0',NULL,'2023-11-07 17:46:01.313851','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(24,'249121768602','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-02','2023-11-08 20:43.09.0',NULL,'2023-11-07 17:46:01.787088','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(25,'249121190624','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-02','2023-11-08 20:43.48.0',NULL,'2023-11-07 17:46:22.229520','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(26,'249111783264','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-09','2023-11-08 20:44.05.0',NULL,'2023-11-07 17:46:42.695542','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(27,'249118674460','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-27','2023-11-08 20:44.00.0',NULL,'2023-11-07 17:46:43.133205','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(28,'249114588901','7d490ed6-8244-479c-8863-c034266c8f20','0','2023-01-07','2023-11-08 20:19.23.0',NULL,'2023-11-07 17:46:44.594287','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(29,'249125403107','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-31','2023-11-08 20:44.18.0',NULL,'2023-11-07 17:47:03.592004','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(30,'249127387901','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-28','2023-11-08 20:44.39.0',NULL,'2023-11-07 17:47:24.087365','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(31,'249122674950','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-18','2023-11-08 20:45.01.0',NULL,'2023-11-07 17:47:44.648212','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(32,'249128952361','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-10','2023-11-08 20:45.16.0',NULL,'2023-11-07 17:48:05.107707','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(33,'249128218767','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-20','2023-11-08 20:45.49.0',NULL,'2023-11-07 17:48:25.536461','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(34,'249128535612','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-18','2023-11-08 20:46.03.0',NULL,'2023-11-07 17:48:46.010232','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(35,'249119960505','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-24','2023-11-08 20:46.03.0',NULL,'2023-11-07 17:48:46.402157','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(36,'249112977410','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-27','2023-11-08 20:46.34.0',NULL,'2023-11-07 17:49:06.850879','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(37,'249115390678','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-28','2023-11-08 20:46.45.0',NULL,'2023-11-07 17:49:27.321543','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(38,'249111282048','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-02','2023-11-08 20:47.56.0',NULL,'2023-11-07 17:50:47.895360','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(39,'249124757129','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-09','2023-11-08 20:48.29.0',NULL,'2023-11-07 17:51:08.472214','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(40,'249123108406','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-10','2023-11-08 20:48.24.0',NULL,'2023-11-07 17:51:08.879547','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(41,'249116039806','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-08','2023-11-08 20:49.20.0',NULL,'2023-11-07 17:52:09.540235','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(42,'249117701042','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-19','2023-11-08 20:49.39.0',NULL,'2023-11-07 17:52:30.015020','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(43,'249116211194','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-06','2023-11-08 20:49.55.0',NULL,'2023-11-07 17:52:30.534583','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(44,'249100340630','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-28','2023-11-08 20:50.10.0',NULL,'2023-11-07 17:52:50.996870','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(45,'249115699703','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-14','2023-11-08 20:50.34.0',NULL,'2023-11-07 17:53:11.456345','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(46,'249117876914','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-21','2023-11-08 20:51.01.0',NULL,'2023-11-07 17:53:51.937068','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(47,'249129883286','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-07','2023-11-08 20:51.10.0',NULL,'2023-11-07 17:53:52.344407','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(48,'249117283143','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-28','2023-11-08 20:51.16.0',NULL,'2023-11-07 17:53:52.761380','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(49,'249116121374','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-24','2023-11-08 20:51.47.0',NULL,'2023-11-07 17:54:33.232638','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(50,'249113441712','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-10','2023-11-08 20:52.26.0',NULL,'2023-11-07 17:55:13.718138','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(51,'249117143468','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-01','2023-11-08 20:53.09.0',NULL,'2023-11-07 17:55:54.201180','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(52,'249114746692','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-18','2023-11-08 20:53.24.0',NULL,'2023-11-07 17:56:14.639832','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(53,'249127646427','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-18','2023-11-08 20:54.04.0',NULL,'2023-11-07 17:56:55.278934','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(54,'249112835681','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-16','2023-11-08 20:54.22.0',NULL,'2023-11-07 17:56:55.595407','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(55,'249126293072','7d490ed6-8244-479c-8863-c034266c8f20','1','2023-01-02','2023-11-08 20:54.06.0',NULL,'2023-11-07 17:56:56.020149','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(56,'249119919413','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-11-30','2023-11-08 20:54.28.0',NULL,'2023-11-07 17:57:16.486042','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL),(57,'249116922581','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-12-30','2023-11-08 20:54.29.0',NULL,'2023-11-07 17:57:16.895382','07280e85-9a62-420f-a90f-6f9be9322a6e',7,11,2023,NULL,NULL,NULL);


--
-- Host: localhost    Database: dashboard_db
-- ------------------------------------------------------


--
-- Dumping data for table `sudaniservicereports`
--
-- WHERE:  1=1 LIMIT 50

INSERT INTO `sudaniservicereports` VALUES (1490,'07280e85-9a62-420f-a90f-6f9be9322a6e',27,11,2024,0,15,1697,655165.000000000000000000000000000000,'2024-11-27 22:17:50.837829'),(1491,'15601bed-4a50-49e6-b3f2-2e98a4890e25',27,11,2024,0,0,2,565.000000000000000000000000000000,'2024-11-27 22:17:51.031826'),(1492,'1e883fde-7cde-400e-91e5-70d3cc6b83c1',27,11,2024,0,32,4750,1882955.000000000000000000000000000000,'2024-11-27 22:18:00.632478'),(1493,'6f0a0077-e64b-42b2-823f-a121725f43b7',27,11,2024,1,3,174,86500.000000000000000000000000000000,'2024-11-27 22:18:01.668232'),(1494,'76a4d141-2f39-4fbb-9374-ce196384e539',27,11,2024,1,12,1002,388630.000000000000000000000000000000,'2024-11-27 22:18:08.899803'),(1495,'a982a115-a36a-4ec8-bc0c-206f2e72fa20',27,11,2024,1,34,4345,1709080.000000000000000000000000000000,'2024-11-27 22:18:17.520748'),(1496,'d46256ab-707a-4422-b00b-d043c5c4dcbc',27,11,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:18:17.593062'),(1497,'f5fab354-5f30-4911-b02e-8eb3d61e5b33',27,11,2024,0,34,6350,2514785.000000000000000000000000000000,'2024-11-27 22:18:26.829101'),(1498,'f6c22909-28d4-493a-8e1d-5d1fd47c9ba1',27,11,2024,0,16,1602,801000.000000000000000000000000000000,'2024-11-27 22:18:34.514804'),(1499,'07280e85-9a62-420f-a90f-6f9be9322a6e',26,11,2024,0,6,1891,710840.000000000000000000000000000000,'2024-11-27 22:19:36.748549'),(1500,'15601bed-4a50-49e6-b3f2-2e98a4890e25',26,11,2024,1,0,4,1500.000000000000000000000000000000,'2024-11-27 22:19:36.771984'),(1501,'1e883fde-7cde-400e-91e5-70d3cc6b83c1',26,11,2024,1,38,5533,2133825.000000000000000000000000000000,'2024-11-27 22:19:44.937239'),(1502,'6f0a0077-e64b-42b2-823f-a121725f43b7',26,11,2024,2,1,188,93000.000000000000000000000000000000,'2024-11-27 22:19:45.783887'),(1503,'76a4d141-2f39-4fbb-9374-ce196384e539',26,11,2024,0,3,1131,428205.000000000000000000000000000000,'2024-11-27 22:19:52.675129'),(1504,'a982a115-a36a-4ec8-bc0c-206f2e72fa20',26,11,2024,1,26,5080,1937955.000000000000000000000000000000,'2024-11-27 22:20:00.809201'),(1505,'d46256ab-707a-4422-b00b-d043c5c4dcbc',26,11,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:20:00.914478'),(1506,'f5fab354-5f30-4911-b02e-8eb3d61e5b33',26,11,2024,1,31,7439,2896685.000000000000000000000000000000,'2024-11-27 22:20:10.462654'),(1507,'f6c22909-28d4-493a-8e1d-5d1fd47c9ba1',26,11,2024,1,15,1848,923500.000000000000000000000000000000,'2024-11-27 22:20:17.520819'),(1508,'07280e85-9a62-420f-a90f-6f9be9322a6e',1,11,2024,19,10,3023,1246985.000000000000000000000000000000,'2024-11-27 22:20:50.549312'),(1509,'15601bed-4a50-49e6-b3f2-2e98a4890e25',1,11,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:20:50.588388'),(1510,'1e883fde-7cde-400e-91e5-70d3cc6b83c1',1,11,2024,37,25,10316,4396645.000000000000000000000000000000,'2024-11-27 22:20:58.495111'),(1511,'6f0a0077-e64b-42b2-823f-a121725f43b7',1,11,2024,1,2,259,129000.000000000000000000000000000000,'2024-11-27 22:20:59.127917'),(1512,'76a4d141-2f39-4fbb-9374-ce196384e539',1,11,2024,1,7,1966,843610.000000000000000000000000000000,'2024-11-27 22:21:05.789031'),(1513,'a982a115-a36a-4ec8-bc0c-206f2e72fa20',1,11,2024,35,20,11054,4795325.000000000000000000000000000000,'2024-11-27 22:21:13.480880'),(1514,'d46256ab-707a-4422-b00b-d043c5c4dcbc',1,11,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:13.635555'),(1515,'07280e85-9a62-420f-a90f-6f9be9322a6e',2,11,2024,16,7,2634,1006915.000000000000000000000000000000,'2024-11-27 22:21:17.172963'),(1516,'15601bed-4a50-49e6-b3f2-2e98a4890e25',2,11,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:17.203089'),(1517,'f5fab354-5f30-4911-b02e-8eb3d61e5b33',1,11,2024,48,20,15679,6819630.000000000000000000000000000000,'2024-11-27 22:21:22.310100'),(1518,'1e883fde-7cde-400e-91e5-70d3cc6b83c1',2,11,2024,5,31,8669,3487430.000000000000000000000000000000,'2024-11-27 22:21:25.380782'),(1519,'6f0a0077-e64b-42b2-823f-a121725f43b7',2,11,2024,1,2,255,127000.000000000000000000000000000000,'2024-11-27 22:21:26.091168'),(1520,'f6c22909-28d4-493a-8e1d-5d1fd47c9ba1',1,11,2024,31,11,3628,1799000.000000000000000000000000000000,'2024-11-27 22:21:29.223914'),(1521,'76a4d141-2f39-4fbb-9374-ce196384e539',2,11,2024,1,12,1681,678355.000000000000000000000000000000,'2024-11-27 22:21:32.185798'),(1522,'a982a115-a36a-4ec8-bc0c-206f2e72fa20',2,11,2024,12,25,8771,3640585.000000000000000000000000000000,'2024-11-27 22:21:39.587487'),(1523,'d46256ab-707a-4422-b00b-d043c5c4dcbc',2,11,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:39.715519'),(1524,'f5fab354-5f30-4911-b02e-8eb3d61e5b33',2,11,2024,17,42,12930,5385165.000000000000000000000000000000,'2024-11-27 22:21:47.817933'),(1525,'07280e85-9a62-420f-a90f-6f9be9322a6e',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.231737'),(1526,'15601bed-4a50-49e6-b3f2-2e98a4890e25',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.248756'),(1527,'1e883fde-7cde-400e-91e5-70d3cc6b83c1',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.259114'),(1528,'6f0a0077-e64b-42b2-823f-a121725f43b7',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.267588'),(1529,'76a4d141-2f39-4fbb-9374-ce196384e539',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.275466'),(1530,'a982a115-a36a-4ec8-bc0c-206f2e72fa20',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.290981'),(1531,'d46256ab-707a-4422-b00b-d043c5c4dcbc',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.300633'),(1532,'f5fab354-5f30-4911-b02e-8eb3d61e5b33',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.309866'),(1533,'f6c22909-28d4-493a-8e1d-5d1fd47c9ba1',1,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.320004'),(1534,'07280e85-9a62-420f-a90f-6f9be9322a6e',2,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.330414'),(1535,'15601bed-4a50-49e6-b3f2-2e98a4890e25',2,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.340325'),(1536,'1e883fde-7cde-400e-91e5-70d3cc6b83c1',2,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.346936'),(1537,'6f0a0077-e64b-42b2-823f-a121725f43b7',2,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.354468'),(1538,'76a4d141-2f39-4fbb-9374-ce196384e539',2,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.360937'),(1539,'a982a115-a36a-4ec8-bc0c-206f2e72fa20',2,1,2024,0,0,0,0.000000000000000000000000000000,'2024-11-27 22:21:49.367376');


