File: /var/www/html/tmpr/../tmpr/../tmpr/../tmpr/..//VCARDEXPORTS/telemarketing.sql
/*!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.5.25-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: telemarketing
-- ------------------------------------------------------
-- Server version 10.5.25-MariaDB
/*!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 */;
/*!40101 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 `admin_menu_items`
--
DROP TABLE IF EXISTS `admin_menu_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_menu_items` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(191) NOT NULL,
`link` varchar(191) NOT NULL,
`page_id` bigint(20) unsigned DEFAULT NULL,
`parent` bigint(20) unsigned NOT NULL DEFAULT 0,
`sort` int(11) NOT NULL DEFAULT 0,
`class` varchar(191) DEFAULT NULL,
`menu` bigint(20) unsigned NOT NULL,
`depth` int(11) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `admin_menu_items_menu_foreign` (`menu`),
CONSTRAINT `admin_menu_items_menu_foreign` FOREIGN KEY (`menu`) REFERENCES `admin_menus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_menu_items`
--
LOCK TABLES `admin_menu_items` WRITE;
/*!40000 ALTER TABLE `admin_menu_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_menu_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_menus`
--
DROP TABLE IF EXISTS `admin_menus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_menus` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_menus`
--
LOCK TABLES `admin_menus` WRITE;
/*!40000 ALTER TABLE `admin_menus` DISABLE KEYS */;
INSERT INTO `admin_menus` VALUES (1,'primary menu','2024-08-12 04:49:28','2024-08-12 04:49:28'),(2,'footer 1','2024-08-12 04:49:28','2024-08-12 04:49:28'),(3,'dashboard menu 1','2024-08-12 04:49:28','2024-08-12 04:49:28');
/*!40000 ALTER TABLE `admin_menus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `agent_is_availables`
--
DROP TABLE IF EXISTS `agent_is_availables`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent_is_availables` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `agent_is_availables`
--
LOCK TABLES `agent_is_availables` WRITE;
/*!40000 ALTER TABLE `agent_is_availables` DISABLE KEYS */;
/*!40000 ALTER TABLE `agent_is_availables` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `agent_job_boards`
--
DROP TABLE IF EXISTS `agent_job_boards`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent_job_boards` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `agent_job_boards`
--
LOCK TABLES `agent_job_boards` WRITE;
/*!40000 ALTER TABLE `agent_job_boards` DISABLE KEYS */;
/*!40000 ALTER TABLE `agent_job_boards` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `agents`
--
DROP TABLE IF EXISTS `agents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agents` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`assined_for_customer_id` bigint(20) unsigned DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `agents`
--
LOCK TABLES `agents` WRITE;
/*!40000 ALTER TABLE `agents` DISABLE KEYS */;
/*!40000 ALTER TABLE `agents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `applications`
--
DROP TABLE IF EXISTS `applications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `applications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext DEFAULT NULL,
`value` longtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `applications`
--
LOCK TABLES `applications` WRITE;
/*!40000 ALTER TABLE `applications` DISABLE KEYS */;
INSERT INTO `applications` VALUES (1,'site_name','Brand TeleMarketing','2024-08-12 04:49:28','2024-08-12 04:59:59'),(2,'site_email','brand@thebrand.ai','2024-08-12 04:49:28','2024-08-12 04:59:59'),(3,'site_phone','+254722407698','2024-08-12 04:49:28','2024-08-12 04:59:59'),(4,'site_facebook','https://www.facebook.com/thecodestudio','2024-08-12 04:49:28','2024-08-12 04:49:28'),(5,'site_instagram','https://www.instagram.com/thecodestudio/','2024-08-12 04:49:28','2024-08-12 04:49:28'),(6,'site_twitter','https://twitter.com/thecodestudio','2024-08-12 04:49:28','2024-08-12 04:49:28'),(7,'site_youtube','https://www.youtube.com/channel/thecodestudio','2024-08-12 04:49:28','2024-08-12 04:49:28'),(8,'site_linkedin','https://www.linkedin.com/company/thecodestudio','2024-08-12 04:49:28','2024-08-12 04:49:28'),(9,'site_gateway_supports','gateways.png','2024-08-12 04:49:28','2024-08-12 04:49:28'),(10,'site_logo','uploads/application/dX4tOZvFA47WBQbiMSeYN3FRvJEDr63rSg4z6MeR.png','2024-08-12 04:49:28','2024-08-12 04:59:59'),(11,'site_dark_logo','uploads/application/yyMTbm5ItsotOWd3jEBEzXr9g9OfoDDnm3lZLcVf.png','2024-08-12 04:49:28','2024-08-12 04:59:59'),(12,'site_favicon','uploads/application/NaBQ6wDoQUWNJg6nHTwIzUWTfXlg7UQp6aVd8orI.png','2024-08-12 04:49:28','2024-08-12 04:59:59'),(13,'test_phone','+254722407698','2024-08-12 04:59:59','2024-08-12 04:59:59'),(14,'site_colors','','2024-08-12 04:59:59','2024-08-12 04:59:59'),(15,'site_timezone','Africa/Nairobi','2024-08-12 04:59:59','2024-08-12 05:06:05'),(16,'site_dashboard','EXTENDED','2024-08-12 04:59:59','2024-08-12 04:59:59'),(17,'site_frontend_theme','ACTIVE','2024-08-12 04:59:59','2024-08-12 04:59:59'),(18,'site_trailer_thumbnail','uploads/trailer/JhjTXJdUnonwq0dLlMVrLZJWDK4K1uPyyvIj5GmL.png','2024-08-12 04:59:59','2024-08-12 04:59:59'),(19,'site_trailer_url','','2024-08-12 04:59:59','2024-08-12 04:59:59'),(20,'google_recaptcha_key','','2024-08-12 04:59:59','2024-08-12 04:59:59'),(21,'google_recaptcha_secret_key','','2024-08-12 04:59:59','2024-08-12 04:59:59'),(22,'google_recaptcha_mode','NO','2024-08-12 04:59:59','2024-08-12 05:06:05'),(23,'kyc','NO','2024-08-12 04:59:59','2024-08-12 05:06:05'),(24,'open_ai_key','','2024-08-12 04:59:59','2024-08-12 04:59:59');
/*!40000 ALTER TABLE `applications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `call_durations`
--
DROP TABLE IF EXISTS `call_durations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `call_durations` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`campaign_name` longtext DEFAULT NULL,
`phone` longtext DEFAULT NULL,
`accountSid` longtext DEFAULT NULL,
`sid` longtext DEFAULT NULL,
`duration` longtext DEFAULT NULL,
`deduction` longtext DEFAULT NULL,
`app_deduction` longtext DEFAULT NULL,
`total_deduction` longtext DEFAULT NULL,
`status` longtext DEFAULT NULL,
`active` tinyint(1) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `call_durations`
--
LOCK TABLES `call_durations` WRITE;
/*!40000 ALTER TABLE `call_durations` DISABLE KEYS */;
/*!40000 ALTER TABLE `call_durations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `call_histories`
--
DROP TABLE IF EXISTS `call_histories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `call_histories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`caller_uuid` longtext DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`identity_id` bigint(20) unsigned DEFAULT NULL,
`my_number` longtext DEFAULT NULL,
`caller_number` longtext DEFAULT NULL,
`pick_up_time` longtext DEFAULT NULL,
`hang_up_time` longtext DEFAULT NULL,
`record_file` longtext DEFAULT NULL,
`status` longtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `call_histories`
--
LOCK TABLES `call_histories` WRITE;
/*!40000 ALTER TABLE `call_histories` DISABLE KEYS */;
INSERT INTO `call_histories` VALUES (1,'d64d11f5-7244-4d12-8ee0-7e872ddfeef1',1,1,NULL,'+254722407698','2024-08-12 02:37:55','',NULL,'dialed','2024-08-12 02:37:55','2024-08-12 02:37:55'),(2,'064e6ce2-0da8-4700-b58b-4187a23a010b',1,1,NULL,'+254722407698','2024-08-12 02:38:38','',NULL,'dialed','2024-08-12 02:38:38','2024-08-12 02:38:38'),(3,'1f5b75b5-88c8-4795-ba0f-16e265f6646b',1,1,NULL,'+254722407698','2024-08-12 02:38:54','',NULL,'dialed','2024-08-12 02:38:54','2024-08-12 02:38:54'),(4,'436b060a-9754-4d2d-a0df-b02bc3824aa7',1,1,NULL,'+254742466789','2024-08-12 02:44:13','',NULL,'dialed','2024-08-12 02:44:13','2024-08-12 02:44:13'),(5,'1cdd973f-e33f-42c9-a677-77ebe683a440',1,1,NULL,'0742466789','2024-08-12 02:44:23','',NULL,'dialed','2024-08-12 02:44:23','2024-08-12 02:44:23'),(6,'ed1ae908-134a-4d6a-9588-72095624aa9a',1,1,NULL,'+254742466789','2024-08-12 02:44:39','',NULL,'dialed','2024-08-12 02:44:39','2024-08-12 02:44:39'),(7,'c34cce79-f6ad-4f60-b728-2df9af0beac8',1,1,NULL,'+254722407698','2024-08-12 02:45:00','',NULL,'dialed','2024-08-12 02:45:00','2024-08-12 02:45:00'),(8,'abbfae5b-69f2-44ea-a37a-6958c3931766',1,1,NULL,'+254 722407698','2024-08-12 02:45:08','',NULL,'dialed','2024-08-12 02:45:08','2024-08-12 02:45:08'),(9,'6825f364-043a-43d0-852f-617d7b404abc',1,1,NULL,'+254 722407698','2024-08-12 02:45:12','',NULL,'dialed','2024-08-12 02:45:12','2024-08-12 02:45:12'),(10,'967ee2d3-d6ab-4727-a548-6fc8f3288000',1,1,NULL,'+254722407698','2024-08-12 02:45:20','',NULL,'dialed','2024-08-12 02:45:20','2024-08-12 02:45:20'),(11,'87a66cee-d2cf-4233-9419-f02dc8a8f8eb',1,1,NULL,'+254722407698','2024-08-12 02:47:53','',NULL,'dialed','2024-08-12 02:47:53','2024-08-12 02:47:53'),(12,'254e8b9d-ba13-494e-b2db-cb26141b9067',1,1,NULL,'+254722407699','2024-08-12 02:48:05','',NULL,'dialed','2024-08-12 02:48:05','2024-08-12 02:48:05'),(13,'e3915410-151b-4f5e-be88-3bf46ce55d68',1,1,NULL,'+254 722 407698','2024-08-12 02:48:50','',NULL,'dialed','2024-08-12 02:48:50','2024-08-12 02:48:50'),(14,'04a66ed1-cf86-4d1f-81ce-e81ce323297c',1,1,NULL,'+254722407698','2024-08-12 02:53:25','',NULL,'dialed','2024-08-12 02:53:25','2024-08-12 02:53:25'),(15,'81f374f5-1786-4ae4-8239-356387cc3730',1,1,NULL,'+254722407698','2024-08-12 02:53:38','',NULL,'dialed','2024-08-12 02:53:38','2024-08-12 02:53:38'),(16,'bf0c178e-6f19-48fe-ba95-6ae3ca72ad9a',1,1,NULL,'+254722407699','2024-08-12 02:53:50','',NULL,'dialed','2024-08-12 02:53:50','2024-08-12 02:53:50'),(17,'aa69fb87-6787-4b4e-9ab0-29381206290d',1,1,NULL,'+254722407698','2024-08-12 02:55:38','',NULL,'dialed','2024-08-12 02:55:38','2024-08-12 02:55:38'),(18,'846b48f9-0933-4c00-8177-b6a81556395b',1,1,NULL,'+254722407698','2024-08-12 02:55:59','',NULL,'dialed','2024-08-12 02:55:59','2024-08-12 02:55:59'),(19,'e6283495-2cfb-4965-a052-ca307f99e1ad',1,1,NULL,'+254722407698','2024-08-12 02:56:40','',NULL,'dialed','2024-08-12 02:56:40','2024-08-12 02:56:40');
/*!40000 ALTER TABLE `call_histories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `campaign_schedules`
--
DROP TABLE IF EXISTS `campaign_schedules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaign_schedules` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`group_id` bigint(20) unsigned DEFAULT NULL,
`provider` bigint(20) unsigned DEFAULT NULL,
`say` longtext DEFAULT NULL,
`audio` longtext DEFAULT NULL,
`xml` longtext DEFAULT NULL,
`start_at` longtext DEFAULT NULL,
`status` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `campaign_schedules`
--
LOCK TABLES `campaign_schedules` WRITE;
/*!40000 ALTER TABLE `campaign_schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaign_schedules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `campaign_sms_status_logs`
--
DROP TABLE IF EXISTS `campaign_sms_status_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaign_sms_status_logs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`contact_id` bigint(20) unsigned DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`agent_name` longtext DEFAULT NULL,
`message` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `campaign_sms_status_logs`
--
LOCK TABLES `campaign_sms_status_logs` WRITE;
/*!40000 ALTER TABLE `campaign_sms_status_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaign_sms_status_logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `campaign_voice_status_logs`
--
DROP TABLE IF EXISTS `campaign_voice_status_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaign_voice_status_logs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`contact_id` bigint(20) unsigned DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`agent_name` longtext DEFAULT NULL,
`status` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `campaign_voice_status_logs`
--
LOCK TABLES `campaign_voice_status_logs` WRITE;
/*!40000 ALTER TABLE `campaign_voice_status_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaign_voice_status_logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `campaign_voices`
--
DROP TABLE IF EXISTS `campaign_voices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaign_voices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`contact_id` bigint(20) unsigned DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`phone` longtext DEFAULT NULL,
`status` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `campaign_voices`
--
LOCK TABLES `campaign_voices` WRITE;
/*!40000 ALTER TABLE `campaign_voices` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaign_voices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `campaigns`
--
DROP TABLE IF EXISTS `campaigns`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaigns` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`name` longtext DEFAULT NULL,
`description` longtext DEFAULT NULL,
`group_id` bigint(20) unsigned DEFAULT NULL,
`provider` bigint(20) unsigned DEFAULT NULL,
`say` longtext DEFAULT NULL,
`audio` longtext DEFAULT NULL,
`xml` longtext DEFAULT NULL,
`expectation` longtext DEFAULT NULL,
`status` tinyint(1) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `campaigns`
--
LOCK TABLES `campaigns` WRITE;
/*!40000 ALTER TABLE `campaigns` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaigns` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contacts`
--
DROP TABLE IF EXISTS `contacts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contacts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`name` longtext DEFAULT NULL,
`phone` longtext DEFAULT NULL,
`country` longtext DEFAULT NULL,
`gender` longtext DEFAULT NULL,
`dob` longtext DEFAULT NULL,
`profession` longtext DEFAULT NULL,
`reference` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contacts`
--
LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cron_jobs`
--
DROP TABLE IF EXISTS `cron_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cron_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`cron_name` longtext DEFAULT NULL,
`status` tinyint(1) DEFAULT NULL,
`issue` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cron_jobs`
--
LOCK TABLES `cron_jobs` WRITE;
/*!40000 ALTER TABLE `cron_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `cron_jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `csv_import_queues`
--
DROP TABLE IF EXISTS `csv_import_queues`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `csv_import_queues` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `csv_import_queues`
--
LOCK TABLES `csv_import_queues` WRITE;
/*!40000 ALTER TABLE `csv_import_queues` DISABLE KEYS */;
/*!40000 ALTER TABLE `csv_import_queues` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `custom_css_scripts`
--
DROP TABLE IF EXISTS `custom_css_scripts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_css_scripts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` longtext DEFAULT NULL,
`code` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `custom_css_scripts`
--
LOCK TABLES `custom_css_scripts` WRITE;
/*!40000 ALTER TABLE `custom_css_scripts` DISABLE KEYS */;
/*!40000 ALTER TABLE `custom_css_scripts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `department_agents`
--
DROP TABLE IF EXISTS `department_agents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `department_agents` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`agent_id` bigint(20) unsigned DEFAULT NULL,
`agent_user__id` bigint(20) unsigned DEFAULT NULL,
`department_id` bigint(20) unsigned DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `department_agents`
--
LOCK TABLES `department_agents` WRITE;
/*!40000 ALTER TABLE `department_agents` DISABLE KEYS */;
/*!40000 ALTER TABLE `department_agents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `department_providers`
--
DROP TABLE IF EXISTS `department_providers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `department_providers` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`department_id` bigint(20) unsigned DEFAULT NULL,
`provider_id` bigint(20) unsigned DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0,
`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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `department_providers`
--
LOCK TABLES `department_providers` WRITE;
/*!40000 ALTER TABLE `department_providers` DISABLE KEYS */;
INSERT INTO `department_providers` VALUES (3,1,1,1,'2024-08-12 02:37:07','2024-08-12 02:37:07');
/*!40000 ALTER TABLE `department_providers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `departments`
--
DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departments` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) DEFAULT NULL,
`inbound` tinyint(1) NOT NULL DEFAULT 0,
`outbound` tinyint(1) NOT NULL DEFAULT 0,
`ivr` tinyint(1) NOT NULL DEFAULT 0,
`json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`json`)),
`channel` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`channel`)),
`call_forward` tinyint(1) NOT NULL DEFAULT 0,
`status` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `departments`
--
LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` VALUES (1,1,'Brand Sales',0,1,0,NULL,NULL,0,1,'2024-08-12 02:35:01','2024-08-12 02:37:07');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `document_kycs`
--
DROP TABLE IF EXISTS `document_kycs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `document_kycs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`documents_path` longtext DEFAULT NULL,
`approval` longtext DEFAULT NULL,
`seen` tinyint(1) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `document_kycs`
--
LOCK TABLES `document_kycs` WRITE;
/*!40000 ALTER TABLE `document_kycs` DISABLE KEYS */;
/*!40000 ALTER TABLE `document_kycs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `failed_jobs`
--
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(191) NOT NULL,
`connection` text NOT NULL,
`queue` text NOT NULL,
`payload` longtext NOT NULL,
`exception` longtext NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `failed_jobs`
--
LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `features`
--
DROP TABLE IF EXISTS `features`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `features` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext DEFAULT NULL,
`slug` longtext DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `features`
--
LOCK TABLES `features` WRITE;
/*!40000 ALTER TABLE `features` DISABLE KEYS */;
/*!40000 ALTER TABLE `features` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_contacts`
--
DROP TABLE IF EXISTS `group_contacts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_contacts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`group_id` bigint(20) unsigned DEFAULT NULL,
`contact_id` bigint(20) unsigned DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_contacts`
--
LOCK TABLES `group_contacts` WRITE;
/*!40000 ALTER TABLE `group_contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_contacts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`name` longtext DEFAULT NULL,
`description` longtext DEFAULT NULL,
`status` tinyint(1) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups`
--
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identities`
--
DROP TABLE IF EXISTS `identities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `identities` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`identity` longtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identities`
--
LOCK TABLES `identities` WRITE;
/*!40000 ALTER TABLE `identities` DISABLE KEYS */;
INSERT INTO `identities` VALUES (1,1,'Santos','2024-08-12 04:57:15','2024-08-12 04:57:15');
/*!40000 ALTER TABLE `identities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `item_limit_counts`
--
DROP TABLE IF EXISTS `item_limit_counts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_limit_counts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`domain` longtext DEFAULT NULL,
`subscription_id` bigint(20) unsigned DEFAULT NULL,
`credit` longtext DEFAULT NULL,
`all_time_credit` longtext DEFAULT NULL,
`emails` longtext DEFAULT NULL,
`sms` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `item_limit_counts`
--
LOCK TABLES `item_limit_counts` WRITE;
/*!40000 ALTER TABLE `item_limit_counts` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_limit_counts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ivrs`
--
DROP TABLE IF EXISTS `ivrs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ivrs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`ivr_name` longtext DEFAULT NULL,
`audio_file` longtext DEFAULT NULL,
`key1` int(11) DEFAULT NULL,
`key1_value` longtext DEFAULT NULL,
`key2` int(11) DEFAULT NULL,
`key2_value` longtext DEFAULT NULL,
`key3` int(11) DEFAULT NULL,
`key3_value` longtext DEFAULT NULL,
`key4` int(11) DEFAULT NULL,
`key4_value` longtext DEFAULT NULL,
`key5` int(11) DEFAULT NULL,
`key5_value` longtext DEFAULT NULL,
`key6` int(11) DEFAULT NULL,
`key6_value` longtext DEFAULT NULL,
`key7` int(11) DEFAULT NULL,
`key7_value` longtext DEFAULT NULL,
`key8` int(11) DEFAULT NULL,
`key8_value` longtext DEFAULT NULL,
`key9` int(11) DEFAULT NULL,
`key9_value` longtext DEFAULT NULL,
`key0` int(11) DEFAULT NULL,
`key0_value` longtext DEFAULT NULL,
`key_star` longtext DEFAULT NULL,
`key_star_value` longtext DEFAULT NULL,
`key_hash` longtext DEFAULT NULL,
`key_hash_value` longtext DEFAULT NULL,
`xml_file` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ivrs`
--
LOCK TABLES `ivrs` WRITE;
/*!40000 ALTER TABLE `ivrs` DISABLE KEYS */;
/*!40000 ALTER TABLE `ivrs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jobs`
--
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(191) NOT NULL,
`payload` longtext NOT NULL,
`attempts` tinyint(3) unsigned NOT NULL,
`reserved_at` int(10) unsigned DEFAULT NULL,
`available_at` int(10) unsigned NOT NULL,
`created_at` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jobs`
--
LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `languages`
--
DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `languages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`code` longtext DEFAULT NULL,
`name` longtext DEFAULT NULL,
`image` longtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `languages`
--
LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` VALUES (1,'en','English','Flag_of_the_United_States.png','2024-08-12 04:49:28','2024-08-12 04:49:28');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `leads_export_histories`
--
DROP TABLE IF EXISTS `leads_export_histories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leads_export_histories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`campaign_name` longtext DEFAULT NULL,
`total_contacts` longtext DEFAULT NULL,
`picked` longtext DEFAULT NULL,
`busy` longtext DEFAULT NULL,
`swiched_off` longtext DEFAULT NULL,
`lead` longtext DEFAULT NULL,
`total` longtext DEFAULT NULL,
`picked_percentage` longtext DEFAULT NULL,
`busy_percentage` longtext DEFAULT NULL,
`swiched_off_percentage` longtext DEFAULT NULL,
`lead_percentage` longtext DEFAULT NULL,
`lead_percentage_expectation` longtext DEFAULT NULL,
`export_date` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `leads_export_histories`
--
LOCK TABLES `leads_export_histories` WRITE;
/*!40000 ALTER TABLE `leads_export_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `leads_export_histories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `live_call_durations`
--
DROP TABLE IF EXISTS `live_call_durations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `live_call_durations` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dialer_session_uuid` longtext DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`phone` longtext DEFAULT NULL,
`start_at` longtext DEFAULT NULL,
`end_at` longtext DEFAULT NULL,
`duration` longtext DEFAULT NULL,
`app_deduction` longtext DEFAULT NULL,
`total_deduction` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `live_call_durations`
--
LOCK TABLES `live_call_durations` WRITE;
/*!40000 ALTER TABLE `live_call_durations` DISABLE KEYS */;
/*!40000 ALTER TABLE `live_call_durations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`sender` varchar(191) DEFAULT NULL,
`recipient` varchar(191) DEFAULT NULL,
`content` text DEFAULT NULL,
`mms` text DEFAULT NULL,
`user_number` varchar(191) DEFAULT NULL,
`my_number` varchar(191) DEFAULT NULL,
`sent_at` timestamp NULL DEFAULT NULL,
`seen` tinyint(1) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(191) NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migrations`
--
LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2017_08_11_073824_create_menus_wp_table',1),(4,'2017_08_11_074006_create_menu_items_wp_table',1),(5,'2019_08_19_000000_create_failed_jobs_table',1),(6,'2019_12_14_000001_create_personal_access_tokens_table',1),(7,'2021_12_02_054619_create_subscriptions_table',1),(8,'2021_12_06_090312_create_features_table',1),(9,'2021_12_06_091145_create_packages_table',1),(10,'2021_12_06_092549_create_payment_histories_table',1),(11,'2021_12_06_130511_create_item_limit_counts_table',1),(12,'2021_12_11_103235_create_jobs_table',1),(13,'2021_12_12_071853_create_system_currencies_table',1),(14,'2021_12_20_061259_create_recent_activities_table',1),(15,'2021_12_29_101706_create_newsletters_table',1),(16,'2022_01_01_080725_create_seos_table',1),(17,'2022_01_01_080956_create_applications_table',1),(18,'2022_01_16_060106_create_saas_contents_table',1),(19,'2022_01_17_212415_create_pages_table',1),(20,'2022_06_09_135759_create_providers_table',1),(21,'2022_06_14_120852_create_contacts_table',1),(22,'2022_06_17_123302_create_groups_table',1),(23,'2022_06_17_131918_create_group_contacts_table',1),(24,'2022_06_17_201226_create_quota_logs_table',1),(25,'2022_06_17_214735_create_campaigns_table',1),(26,'2022_06_18_005348_create_campaign_schedules_table',1),(27,'2022_06_28_101033_create_campaign_voices_table',1),(28,'2022_06_28_122343_create_campaign_voice_status_logs_table',1),(29,'2022_07_02_001647_create_leads_export_histories_table',1),(30,'2022_07_04_061939_create_call_durations_table',1),(31,'2022_07_05_005832_create_live_call_durations_table',1),(32,'2022_07_15_122354_create_sessions_table',1),(33,'2022_08_01_000929_create_patches_table',1),(34,'2022_08_05_094213_create_twilio_call_costs_table',1),(35,'2022_08_05_110809_create_package_supported_countries_table',1),(36,'2022_08_14_030944_create_ivrs_table',1),(37,'2022_08_17_150205_create_agents_table',1),(38,'2022_08_22_071957_create_cron_jobs_table',1),(39,'2022_08_30_114957_create_custom_css_scripts_table',1),(40,'2022_09_01_202251_create_document_kycs_table',1),(41,'2022_09_01_202736_create_agent_job_boards_table',1),(42,'2022_09_02_111842_create_campaign_sms_status_logs_table',1),(43,'2022_09_06_073859_create_twilio_sms_costs_table',1),(44,'2022_09_21_040737_create_third_parties_table',1),(45,'2022_10_18_043513_create_w_p__tokens_table',1),(46,'2022_11_24_225242_create_shops_table',1),(47,'2022_12_25_183945_create_languages_table',1),(48,'2023_03_26_215650_create_identities_table',1),(49,'2023_04_02_232037_create_messages_table',1),(50,'2023_04_16_231454_create_call_histories_table',1),(51,'2023_04_19_190736_create_sms_schedules_table',1),(52,'2023_04_19_203206_create_sms_contents_table',1),(53,'2023_06_20_143611_url_shortener',1),(54,'2023_07_31_175230_create_agent_is_availables_table',1),(55,'2023_07_31_175256_create_queue_lists_table',1),(56,'2023_09_06_235047_create_mojsms_table',1),(57,'2023_09_13_201124_create_csv_import_queues_table',1),(58,'2023_10_13_114230_create_departments_table',1),(59,'2023_10_16_225825_create_department_providers_table',1),(60,'2023_10_23_104037_create_department_agents_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mojsms`
--
DROP TABLE IF EXISTS `mojsms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mojsms` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`bearer_token` longtext DEFAULT NULL,
`sender_id` varchar(191) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mojsms`
--
LOCK TABLES `mojsms` WRITE;
/*!40000 ALTER TABLE `mojsms` DISABLE KEYS */;
/*!40000 ALTER TABLE `mojsms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `newsletters`
--
DROP TABLE IF EXISTS `newsletters`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `newsletters` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext DEFAULT NULL,
`phone` longtext DEFAULT NULL,
`email` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `newsletters`
--
LOCK TABLES `newsletters` WRITE;
/*!40000 ALTER TABLE `newsletters` DISABLE KEYS */;
/*!40000 ALTER TABLE `newsletters` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `package_supported_countries`
--
DROP TABLE IF EXISTS `package_supported_countries`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `package_supported_countries` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`package_id` bigint(20) unsigned DEFAULT NULL,
`twilio_call_costs_id` bigint(20) unsigned DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `package_supported_countries`
--
LOCK TABLES `package_supported_countries` WRITE;
/*!40000 ALTER TABLE `package_supported_countries` DISABLE KEYS */;
/*!40000 ALTER TABLE `package_supported_countries` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `packages`
--
DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext DEFAULT NULL,
`slug` longtext DEFAULT NULL,
`credit` longtext DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT 1,
`trial` tinyint(1) NOT NULL DEFAULT 0,
`feature_id` longtext DEFAULT NULL,
`price` double NOT NULL DEFAULT 0,
`emails` longtext DEFAULT NULL,
`sms` longtext DEFAULT NULL,
`range` longtext DEFAULT NULL,
`range_type` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `packages`
--
LOCK TABLES `packages` WRITE;
/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`page_name` longtext DEFAULT NULL,
`slug` longtext DEFAULT NULL,
`thumbnail` longtext DEFAULT NULL,
`blocks` longtext DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pages`
--
LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_resets`
--
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
`email` varchar(191) NOT NULL,
`token` varchar(191) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_resets`
--
LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `patches`
--
DROP TABLE IF EXISTS `patches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patches` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`file_from` longtext DEFAULT NULL,
`file_to` longtext DEFAULT NULL,
`modified_date` longtext DEFAULT NULL,
`renamed_path` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `patches`
--
LOCK TABLES `patches` WRITE;
/*!40000 ALTER TABLE `patches` DISABLE KEYS */;
/*!40000 ALTER TABLE `patches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `payment_histories`
--
DROP TABLE IF EXISTS `payment_histories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_histories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`invoice` longtext DEFAULT NULL,
`domain` longtext DEFAULT NULL,
`subscription_id` bigint(20) unsigned DEFAULT NULL,
`package_id` bigint(20) unsigned DEFAULT NULL,
`payment_status` longtext DEFAULT NULL,
`payment_gateway` longtext DEFAULT NULL,
`amount` double DEFAULT NULL,
`trx_id` longtext DEFAULT NULL,
`start_at` longtext DEFAULT NULL,
`end_at` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `payment_histories`
--
LOCK TABLES `payment_histories` WRITE;
/*!40000 ALTER TABLE `payment_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_histories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `personal_access_tokens`
--
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(191) NOT NULL,
`tokenable_id` bigint(20) unsigned NOT NULL,
`name` varchar(191) NOT NULL,
`token` varchar(64) NOT NULL,
`abilities` text DEFAULT NULL,
`last_used_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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `personal_access_tokens`
--
LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `providers`
--
DROP TABLE IF EXISTS `providers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `providers` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`provider_name` varchar(191) DEFAULT NULL,
`account_sid` longtext DEFAULT NULL,
`auth_token` longtext DEFAULT NULL,
`phone` varchar(191) DEFAULT NULL,
`say` longtext DEFAULT NULL,
`audio` longtext DEFAULT NULL,
`xml` longtext DEFAULT NULL,
`provider` longtext DEFAULT NULL,
`hourly_quota` longtext DEFAULT NULL,
`ivr` tinyint(1) DEFAULT NULL,
`capability_token` longtext DEFAULT NULL,
`status` tinyint(1) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `providers`
--
LOCK TABLES `providers` WRITE;
/*!40000 ALTER TABLE `providers` DISABLE KEYS */;
INSERT INTO `providers` VALUES (1,1,'Twilio','AC56cb5f608532040fa8487b33f9219b5d','87e513b6135b8847012422ae71d4ef93','+19787407926',NULL,NULL,NULL,NULL,'40',1,'AP514d3cccfd25a9294397e46e9f95c842',1,'2024-08-12 02:33:30','2024-08-12 02:45:36');
/*!40000 ALTER TABLE `providers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `queue_lists`
--
DROP TABLE IF EXISTS `queue_lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `queue_lists` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`caller_number` longtext DEFAULT NULL,
`my_number` longtext DEFAULT NULL,
`serial` longtext DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `queue_lists`
--
LOCK TABLES `queue_lists` WRITE;
/*!40000 ALTER TABLE `queue_lists` DISABLE KEYS */;
/*!40000 ALTER TABLE `queue_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `quota_logs`
--
DROP TABLE IF EXISTS `quota_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quota_logs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`provider_id` bigint(20) unsigned DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`contact_id` bigint(20) unsigned DEFAULT NULL,
`to_number` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `quota_logs`
--
LOCK TABLES `quota_logs` WRITE;
/*!40000 ALTER TABLE `quota_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `quota_logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `recent_activities`
--
DROP TABLE IF EXISTS `recent_activities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recent_activities` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`message` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `recent_activities`
--
LOCK TABLES `recent_activities` WRITE;
/*!40000 ALTER TABLE `recent_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `recent_activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `saas_contents`
--
DROP TABLE IF EXISTS `saas_contents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saas_contents` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`cid` longtext DEFAULT NULL,
`text` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `saas_contents`
--
LOCK TABLES `saas_contents` WRITE;
/*!40000 ALTER TABLE `saas_contents` DISABLE KEYS */;
/*!40000 ALTER TABLE `saas_contents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `seos`
--
DROP TABLE IF EXISTS `seos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seos` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext DEFAULT NULL,
`value` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `seos`
--
LOCK TABLES `seos` WRITE;
/*!40000 ALTER TABLE `seos` DISABLE KEYS */;
/*!40000 ALTER TABLE `seos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
`id` varchar(191) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`ip_address` varchar(45) DEFAULT NULL,
`user_agent` text DEFAULT NULL,
`payload` text NOT NULL,
`last_activity` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `sessions_user_id_index` (`user_id`),
KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sessions`
--
LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shops`
--
DROP TABLE IF EXISTS `shops`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shops` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`purchased_user_id` bigint(20) unsigned DEFAULT NULL,
`phone` longtext DEFAULT NULL,
`country` longtext DEFAULT NULL,
`credit_cost` longtext DEFAULT NULL,
`start_at` longtext DEFAULT NULL,
`end_at` longtext DEFAULT NULL,
`released` tinyint(1) DEFAULT NULL,
`confirmed` tinyint(1) DEFAULT NULL,
`renew` tinyint(1) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shops`
--
LOCK TABLES `shops` WRITE;
/*!40000 ALTER TABLE `shops` DISABLE KEYS */;
/*!40000 ALTER TABLE `shops` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sms_contents`
--
DROP TABLE IF EXISTS `sms_contents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sms_contents` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`content` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sms_contents`
--
LOCK TABLES `sms_contents` WRITE;
/*!40000 ALTER TABLE `sms_contents` DISABLE KEYS */;
/*!40000 ALTER TABLE `sms_contents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sms_schedules`
--
DROP TABLE IF EXISTS `sms_schedules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sms_schedules` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`campaign_id` bigint(20) unsigned DEFAULT NULL,
`group_id` bigint(20) unsigned DEFAULT NULL,
`provider` bigint(20) unsigned DEFAULT NULL,
`start_at` longtext DEFAULT NULL,
`status` longtext DEFAULT NULL,
`third_party_provider` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sms_schedules`
--
LOCK TABLES `sms_schedules` WRITE;
/*!40000 ALTER TABLE `sms_schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `sms_schedules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subscriptions`
--
DROP TABLE IF EXISTS `subscriptions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscriptions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`package_id` bigint(20) unsigned DEFAULT NULL,
`domain` longtext DEFAULT NULL,
`credit` double DEFAULT NULL,
`emails` longtext DEFAULT NULL,
`sms` longtext DEFAULT NULL,
`start_at` longtext DEFAULT NULL,
`end_at` longtext DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT 0,
`payment_status` longtext DEFAULT NULL,
`payment_gateway` longtext DEFAULT NULL,
`amount` double DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subscriptions`
--
LOCK TABLES `subscriptions` WRITE;
/*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `system_currencies`
--
DROP TABLE IF EXISTS `system_currencies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `system_currencies` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext DEFAULT NULL,
`code` longtext DEFAULT NULL,
`symbol` longtext DEFAULT NULL,
`icon` longtext DEFAULT NULL,
`amount` longtext DEFAULT NULL,
`default` tinyint(1) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `system_currencies`
--
LOCK TABLES `system_currencies` WRITE;
/*!40000 ALTER TABLE `system_currencies` DISABLE KEYS */;
INSERT INTO `system_currencies` VALUES (1,'US Dollar','840','USD','$','1',1,'2024-08-12 04:49:28','2024-08-12 04:49:28');
/*!40000 ALTER TABLE `system_currencies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `third_parties`
--
DROP TABLE IF EXISTS `third_parties`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `third_parties` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` longtext DEFAULT NULL,
`application_name` longtext DEFAULT NULL,
`application_url` longtext DEFAULT NULL,
`user_email` longtext DEFAULT NULL,
`user_token` longtext DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `third_parties`
--
LOCK TABLES `third_parties` WRITE;
/*!40000 ALTER TABLE `third_parties` DISABLE KEYS */;
/*!40000 ALTER TABLE `third_parties` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `twilio_call_costs`
--
DROP TABLE IF EXISTS `twilio_call_costs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `twilio_call_costs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`country` longtext DEFAULT NULL,
`code` longtext DEFAULT NULL,
`twilio_cost` longtext DEFAULT NULL,
`teleman_cost` longtext DEFAULT NULL,
`teleman_cost_per_second` longtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `twilio_call_costs`
--
LOCK TABLES `twilio_call_costs` WRITE;
/*!40000 ALTER TABLE `twilio_call_costs` DISABLE KEYS */;
INSERT INTO `twilio_call_costs` VALUES (1,'kenya','+254','0.01','0.05','$0.0008333333','2024-08-12 02:55:13','2024-08-12 02:55:13');
/*!40000 ALTER TABLE `twilio_call_costs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `twilio_sms_costs`
--
DROP TABLE IF EXISTS `twilio_sms_costs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `twilio_sms_costs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`twilio_call_cost_id` bigint(20) unsigned DEFAULT NULL,
`teleman_sms_cost` longtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `twilio_sms_costs`
--
LOCK TABLES `twilio_sms_costs` WRITE;
/*!40000 ALTER TABLE `twilio_sms_costs` DISABLE KEYS */;
INSERT INTO `twilio_sms_costs` VALUES (1,1,NULL,'2024-08-12 02:55:13','2024-08-12 02:55:13');
/*!40000 ALTER TABLE `twilio_sms_costs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `urlShortener`
--
DROP TABLE IF EXISTS `urlShortener`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `urlShortener` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`originalUrl` varchar(191) NOT NULL,
`urlKey` varchar(191) NOT NULL,
`active` varchar(191) NOT NULL DEFAULT 'yes',
`userId` bigint(20) unsigned DEFAULT NULL,
`activeOn` varchar(191) DEFAULT NULL,
`hasSvg` text DEFAULT NULL,
`hasImage` text DEFAULT NULL,
`shortUrl` varchar(191) NOT NULL,
`createdAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`),
KEY `urlshortener_id_index` (`id`),
KEY `urlshortener_originalurl_index` (`originalUrl`),
KEY `urlshortener_urlkey_index` (`urlKey`),
KEY `urlshortener_userid_index` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `urlShortener`
--
LOCK TABLES `urlShortener` WRITE;
/*!40000 ALTER TABLE `urlShortener` DISABLE KEYS */;
/*!40000 ALTER TABLE `urlShortener` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`email` varchar(191) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`otp` longtext DEFAULT NULL,
`password` varchar(191) NOT NULL,
`phone` varchar(191) DEFAULT NULL,
`domain` longtext DEFAULT NULL,
`rest_name` longtext DEFAULT NULL,
`rest_address` longtext DEFAULT NULL,
`role` longtext DEFAULT NULL,
`country` longtext DEFAULT NULL,
`country_code` longtext DEFAULT NULL,
`region_name` longtext DEFAULT NULL,
`city` longtext DEFAULT NULL,
`zip` longtext DEFAULT NULL,
`lat` longtext DEFAULT NULL,
`lon` longtext DEFAULT NULL,
`timezone` longtext DEFAULT NULL,
`restriction` tinyint(1) DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Santos','sokottah2@gmail.com',NULL,NULL,'$2y$10$QtqY8f5aeL4j2XcQ6x.XzO6sUlWQg.5uf56F6EDMY6sPq5hCBMDL6',NULL,NULL,NULL,NULL,'admin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'2024-08-12 04:50:10','2024-08-12 04:50:10');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `w_p__tokens`
--
DROP TABLE IF EXISTS `w_p__tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `w_p__tokens` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `w_p__tokens`
--
LOCK TABLES `w_p__tokens` WRITE;
/*!40000 ALTER TABLE `w_p__tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `w_p__tokens` 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 2025-04-17 15:20:21