-- MySQL dump 10.13  Distrib 8.0.34, for Linux (x86_64)
--
-- Host: localhost    Database: dashboard
-- ------------------------------------------------------
-- Server version	8.0.34-0ubuntu0.20.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `sudanipushnotifymodels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sudanipushnotifymodels` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `msisdn` longtext NOT NULL,
  `service_code` longtext NOT NULL,
  `status` longtext NOT NULL,
  `sub_date` longtext,
  `expire_date` longtext,
  `retry_date` longtext,
  `createDate` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sudanipushnotifymodels`
--

LOCK TABLES `sudanipushnotifymodels` WRITE;
/*!40000 ALTER TABLE `sudanipushnotifymodels` DISABLE KEYS */;
INSERT INTO `sudanipushnotifymodels` VALUES (7,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-06-27 21:30.45.0','','2022-06-26 19:31:04.935011'),(8,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-06-28 23:30.55.0','','2022-06-27 21:31:04.650140'),(9,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-06-29 23:38.53.0','','2022-06-29 01:30:04.116910'),(10,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-06-29 23:38.53.0','','2022-06-29 10:08:55.698131'),(11,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-06-30 23:39.02.0','','2022-06-29 21:39:21.526946'),(12,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-01 23:40.36.0','','2022-06-30 21:40:40.350924'),(13,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-02 23:40.45.0','','2022-07-01 21:41:01.125748'),(14,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-03 23:43.54.0','','2022-07-02 21:43:56.804240'),(15,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-04 23:45.43.0','','2022-07-03 21:45:47.195614'),(16,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-05 23:46.12.0','','2022-07-04 21:46:26.772701'),(17,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-06 23:46.17.0','','2022-07-05 21:46:27.360704'),(18,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','0','2019-11-25 09:41:46','2019-10-26 09:41:46','','2022-07-06 13:42:52.032652'),(19,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','0','2019-11-25 09:41:46','2019-10-26 09:41:46','','2022-07-06 14:17:34.123947'),(20,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-07 16:18.22.0','','2022-07-06 14:18:29.868202'),(21,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-07 23:46.21.0','','2022-07-06 21:46:26.830417'),(22,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-08 16:43.21.0','','2022-07-07 14:43:40.607222'),(23,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-09 05:50.09.0','','2022-07-08 03:50:15.489790'),(24,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-09 19:12.25.0','','2022-07-08 17:12:43.217041'),(25,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-10 05:50.16.0','','2022-07-09 05:30:03.085066'),(26,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-10 19:12.37.0','','2022-07-10 01:30:04.775260'),(27,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-11 05:50.33.0','','2022-07-10 04:00:04.293817'),(28,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-12 05:50.37.0','','2022-07-11 06:00:03.450760'),(29,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-11 19:12.41.0','','2022-07-11 10:00:04.315484'),(30,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-12 19:12.52.0','','2022-07-11 19:00:04.020403'),(31,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-13 05:50.49.0','','2022-07-12 10:00:04.332712'),(32,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-13 19:12.54.0','','2022-07-12 17:30:04.227758'),(33,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-14 05:50.52.0','','2022-07-13 20:30:03.367095'),(34,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-15 05:50.58.0','','2022-07-14 11:30:04.289937'),(35,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-15 19:13.05.0','','2022-07-14 18:30:03.567331'),(36,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-16 05:51.04.0','','2022-07-15 10:00:03.527088'),(37,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-16 19:13.09.0','','2022-07-16 00:00:04.755970'),(38,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-17 05:51.07.0','','2022-07-16 12:30:04.334016'),(39,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-18 05:51.13.0','','2022-07-17 07:42:08.688693'),(40,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-17 19:14.04.0','','2022-07-17 07:42:08.894698'),(41,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-18 19:14.11.0','','2022-07-17 17:14:28.606852'),(42,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-19 05:51.31.0','','2022-07-18 03:51:38.311293'),(43,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-19 19:14.21.0','','2022-07-18 17:14:26.115305'),(44,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-20 05:51.36.0','','2022-07-19 03:51:39.027995'),(45,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-20 19:14.38.0','','2022-07-19 17:14:46.703580'),(46,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-21 05:51.40.0','','2022-07-20 03:52:00.335253'),(47,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-22 01:14.56.0','','2022-07-20 23:15:01.493820'),(48,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-22 15:52.11.0','','2022-07-21 13:52:20.274449'),(49,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-23 01:15.02.0','','2022-07-21 23:15:08.431162'),(50,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-23 15:52.16.0','','2022-07-22 13:52:19.027001'),(51,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-24 01:15.07.0','','2022-07-22 23:15:26.637278'),(52,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-24 15:52.21.0','','2022-07-23 13:52:24.149135'),(53,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-25 01:15.10.0','','2022-07-23 23:15:28.973988'),(54,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-25 15:52.28.0','','2022-07-24 13:52:39.260588'),(55,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-26 01:15.17.0','','2022-07-24 23:15:37.319193'),(56,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-26 15:52.33.0','','2022-07-25 13:52:51.286717'),(57,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-27 01:15.21.0','','2022-07-25 23:15:36.766000'),(58,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-27 15:52.37.0','','2022-07-26 13:52:54.075535'),(59,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-28 01:15.24.0','','2022-07-26 23:15:36.978676'),(60,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-28 15:52.42.0','','2022-07-27 13:52:50.154874'),(61,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-29 01:15.27.0','','2022-07-27 23:15:37.512349'),(62,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-29 15:52.45.0','','2022-07-28 13:52:49.847419'),(63,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-30 01:15.33.0','','2022-07-28 23:15:41.772530'),(64,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-30 15:52.54.0','','2022-07-29 13:53:13.259159'),(65,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-07-31 01:15.38.0','','2022-07-29 23:15:40.913534'),(66,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-07-31 15:52.58.0','','2022-07-30 13:53:13.798715'),(67,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-01 01:15.46.0','','2022-07-30 23:15:58.220841'),(68,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-03 15:53.12.0','','2022-08-02 13:53:14.396325'),(69,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-04 01:16.02.0','','2022-08-02 23:16:04.449464'),(70,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-04 15:53.16.0','','2022-08-03 13:53:19.844354'),(71,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-05 01:16.05.0','','2022-08-03 23:16:20.617425'),(72,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-05 15:53.20.0','','2022-08-04 13:53:37.483318'),(73,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-06 01:16.08.0','','2022-08-04 23:16:20.302049'),(74,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-06 15:53.24.0','','2022-08-05 13:53:41.169027'),(75,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-07 01:16.13.0','','2022-08-05 23:16:20.658961'),(76,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-07 15:53.30.0','','2022-08-06 13:53:39.907659'),(77,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-08 01:16.16.0','','2022-08-06 23:16:17.565103'),(78,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-08 15:53.35.0','','2022-08-07 13:53:38.559551'),(79,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-09 01:16.19.0','','2022-08-07 23:16:41.298330'),(80,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-09 15:53.37.0','','2022-08-08 13:53:59.231552'),(81,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-10 01:16.21.0','','2022-08-08 23:16:41.739737'),(82,'249110012403','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-07-06 16:18.22.0','2022-08-10 01:16.21.0','','2022-08-09 08:30:25.467876'),(83,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-10 15:53.42.0','','2022-08-09 13:53:59.854531'),(84,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-11 15:53.47.0','','2022-08-10 13:53:59.469813'),(85,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-12 15:53.51.0','','2022-08-11 13:53:58.661806'),(86,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-13 15:53.56.0','','2022-08-12 13:53:59.990218'),(87,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-14 19:49.09.0','','2022-08-13 17:49:29.574690'),(88,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-15 19:49.17.0','','2022-08-14 17:49:24.035562'),(89,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-16 19:49.31.0','','2022-08-15 17:49:46.696853'),(90,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-17 19:49.40.0','','2022-08-16 17:49:43.142237'),(91,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-18 19:49.50.0','','2022-08-17 17:50:04.225138'),(92,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-19 19:50.01.0','','2022-08-18 17:50:05.296854'),(93,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-20 19:50.11.0','','2022-08-19 17:50:32.395964'),(94,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-21 19:50.20.0','','2022-08-20 17:50:27.775497'),(95,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-22 19:50.29.0','','2022-08-21 17:50:32.255342'),(96,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-23 19:50.37.0','','2022-08-22 17:50:48.084631'),(97,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-24 19:50.44.0','','2022-08-23 17:50:47.424160'),(98,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-25 19:50.50.0','','2022-08-24 17:51:07.279292'),(99,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-26 19:50.56.0','','2022-08-25 17:51:07.175622'),(100,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-27 19:51.04.0','','2022-08-26 17:51:07.471262'),(101,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-28 19:51.11.0','','2022-08-27 17:51:28.322455'),(102,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-29 19:51.24.0','','2022-08-28 17:51:31.209665'),(103,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-30 19:51.35.0','','2022-08-29 17:51:48.728127'),(104,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-08-31 19:51.38.0','','2022-08-30 17:51:53.099551'),(105,'249128725898','7d490ed6-8244-479c-8863-c034266c8f20','1','2022-05-22 12:56.57.0','2022-09-01 19:51.50.0','','2022-08-31 17:51:52.170935');
/*!40000 ALTER TABLE `sudanipushnotifymodels` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-09-04  8:51:01
