4000 Malaysian Business owners DB mymechanic.me

DROP TABLE IF EXISTS `knowlarity_call_info`;
/*!40101 SET @saved_cs_client    = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `knowlarity_call_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_missed_number` varchar(20) DEFAULT NULL,
  `agent_missed_number` varchar(20) DEFAULT NULL,
  `dispnumber` varchar(20) DEFAULT NULL,
  `extension` varchar(100) DEFAULT NULL,
  `callid` char(36) DEFAULT NULL,
  `call_duration` int(11) DEFAULT NULL,
  `destination` varchar(20) DEFAULT NULL,
  `caller_id` varchar(20) DEFAULT NULL,
  `end_time` datetime(6) DEFAULT NULL,
  `action` int(11) DEFAULT NULL,
  `timezone` varchar(100) DEFAULT NULL,
  `resource_url` longtext,
  `hangup_cause` int(11) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `start_time` datetime(6) DEFAULT NULL,
  `call_type` varchar(100) DEFAULT NULL,
  `create_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5680 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `knowlarity_call_info`
--

LOCK TABLES `knowlarity_call_info` WRITE;
/*!40000 ALTER TABLE `knowlarity_call_info` DISABLE KEYS */;
INSERT INTO `knowlarity_call_info` VALUES (1,'','','+60392121214','None','53016a13-549c-46fa-aad2-230b1f763cc0',0,'Call Missed','+60162111591','2024-01-16 14:20:44.000000',1,'Asia/Kuala_Lumpur','',911,'outgoing','2024-01-16 14:20:44.000000','incoming','2024-01-16 16:50:46'),(2,'','','+60392121214','None','76580ec6-f1fe-4b74-992e-307ed83ad320',205,'+601154182368','+601129302936','2023-11-23 19:36:37.000000',1,'Asia/Kuala_Lumpur','https://kservices.knowlarity.com/kstorage/read?uuid=76580ec6-f1fe-4b74-992e-307ed83ad320_r.mp3&server_name=SINGAPORE&base_dir=recording',900,'outgoing','2023-11-23 19:33:12.000000','incoming','2023-11-23 22:06:39'),(3,'','','+60392121214','None','88af25f8-a0e0-4c14-8170-aae4da113078',33,'+919870235941','+60173934825','2024-01-18 09:34:31.000000',1,'Asia/Kuala_Lumpur','https://kservices.knowlarity.com/kstorage/read?uuid=9e397fce-44bb-4f98-bf96-903ebce88e4f_r.mp3&server_name=SINGAPORE&base_dir=recording',900,'outgoing','2024-01-18 09:33:58.000000','incoming','2024-01-18 12:04:33'),(4,'','','+60392121214','None','bde09fa3-e148-40fe-a9b8-8d956a29ebe4',61,'Call Missed','+601137713201','2023-11-23 23:53:01.000000',1,'Asia/Kuala_Lumpur','',900,'outgoing','2023-11-23 23:52:00.000000','incoming','2023-11-24 02:23:04'),