-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: 127.0.0.1    Database: bdcbotx
-- ------------------------------------------------------
-- Server version	10.4.32-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 `ai_support_feature_items`
--

DROP TABLE IF EXISTS `ai_support_feature_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ai_support_feature_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ai_support_feature_item_status` tinyint(4) NOT NULL DEFAULT 1,
  `ai_support_feature_item_title` varchar(255) DEFAULT NULL,
  `ai_support_feature_item_short_description` text DEFAULT NULL,
  `ai_support_feature_tab_icon` varchar(255) DEFAULT NULL,
  `ai_support_feature_tab_image` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ai_support_feature_items`
--

LOCK TABLES `ai_support_feature_items` WRITE;
/*!40000 ALTER TABLE `ai_support_feature_items` DISABLE KEYS */;
INSERT INTO `ai_support_feature_items` VALUES (1,1,'Trained on your data from web URL','Trained on diverse data from web sources, including publicly available information, to assist with a wide range of topics.',NULL,NULL,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17'),(2,1,'Trained on your data from PDF file','Trained on diverse datasets, including structured information from PDF files, to provide accurate and versatile responses.',NULL,NULL,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17'),(3,1,'Trained on your data from text document','Trained on diverse datasets, including structured and unstructured information from text documents, to deliver accurate and contextual responses.',NULL,NULL,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17'),(4,1,'Trained on your data from FAQ','Trained on diverse datasets, including FAQs, to provide clear and concise answers to common and complex questions.',NULL,NULL,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17');
/*!40000 ALTER TABLE `ai_support_feature_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `app_configurations`
--

DROP TABLE IF EXISTS `app_configurations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `app_configurations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `app_name` varchar(255) DEFAULT NULL,
  `author_name` varchar(255) DEFAULT NULL,
  `footer_copyright` varchar(255) DEFAULT NULL,
  `app_email` varchar(255) DEFAULT NULL,
  `app_phone` varchar(255) DEFAULT NULL,
  `app_short_description` text DEFAULT NULL,
  `white_logo` varchar(255) DEFAULT NULL,
  `small_white_logo` varchar(255) DEFAULT NULL,
  `favicon` varchar(255) DEFAULT NULL,
  `background_image` varchar(255) DEFAULT NULL,
  `preloader_image` varchar(255) DEFAULT NULL,
  `email_configuration_status` tinyint(4) NOT NULL DEFAULT 0,
  `mailer` varchar(255) DEFAULT NULL,
  `port` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `encryption` varchar(255) DEFAULT NULL,
  `mail_from_name` varchar(255) DEFAULT NULL,
  `mail_from_address` varchar(255) DEFAULT NULL,
  `google_login_status` tinyint(4) NOT NULL DEFAULT 0,
  `google_client_id` varchar(255) DEFAULT NULL,
  `google_secret_id` varchar(255) DEFAULT NULL,
  `google_redirect_url` varchar(255) DEFAULT NULL,
  `facebook_login_status` tinyint(4) NOT NULL DEFAULT 0,
  `facebook_client_id` varchar(255) DEFAULT NULL,
  `facebook_secret_id` varchar(255) DEFAULT NULL,
  `facebook_redirect_url` varchar(255) DEFAULT NULL,
  `recaptcha_status` tinyint(4) NOT NULL DEFAULT 0,
  `recaptcha_site_key` varchar(255) DEFAULT NULL,
  `recaptcha_secret_key` varchar(255) DEFAULT NULL,
  `preloader_status` tinyint(4) NOT NULL DEFAULT 1,
  `language_status` tinyint(4) NOT NULL DEFAULT 1,
  `frontend_status` tinyint(4) NOT NULL DEFAULT 1,
  `facebook_url` varchar(255) DEFAULT NULL,
  `instagram_url` varchar(255) DEFAULT NULL,
  `linkedin_url` varchar(255) DEFAULT NULL,
  `youtube_url` varchar(255) 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 `app_configurations`
--

LOCK TABLES `app_configurations` WRITE;
/*!40000 ALTER TABLE `app_configurations` DISABLE KEYS */;
/*!40000 ALTER TABLE `app_configurations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `app_notifications`
--

DROP TABLE IF EXISTS `app_notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `app_notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `is_seen` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `app_notifications`
--

LOCK TABLES `app_notifications` WRITE;
/*!40000 ALTER TABLE `app_notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `app_notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `blogs`
--

DROP TABLE IF EXISTS `blogs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blogs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `blogs`
--

LOCK TABLES `blogs` WRITE;
/*!40000 ALTER TABLE `blogs` DISABLE KEYS */;
INSERT INTO `blogs` VALUES (1,1,NULL,'AI-Powered Personalization in 2024','ai-powered-personalization-in-2024','Discover how AI-driven personalization is revolutionizing customer experience in 2024, enabling businesses to deliver tailored content, products, and services like never before.','In 2024, artificial intelligence is taking customer experience to new heights by enabling businesses to offer highly personalized services. With AI algorithms analyzing customer data in real-time, companies can now deliver individualized recommendations, targeted marketing, and seamless user experiences. From e-commerce sites offering personalized product suggestions to content platforms recommending videos, AI-driven personalization is enhancing customer satisfaction and engagement. This blog explores the technologies behind AI personalization, including machine learning, natural language processing, and data analytics, and examines how businesses are leveraging these tools to stay ahead in a competitive market while improving customer loyalty and retention.',NULL,'2024-12-05 01:31:17',NULL),(2,1,NULL,'How AI is Shaping the Future of Automation in 2024','how-ai-is-shaping-the-future-of-automation-in-2024','Explore how AI is revolutionizing automation in 2024, enhancing productivity, efficiency, and decision-making across industries like manufacturing, logistics, and customer service.','In 2024, artificial intelligence continues to drive the future of automation, transforming industries and workflows. From autonomous machines in manufacturing to AI-powered chatbots in customer service, AI is enhancing operational efficiency and reducing human error. This blog dives into the latest advancements in AI automation, including machine learning algorithms, robotics, and predictive analytics. We’ll explore how these technologies are optimizing supply chains, improving customer experiences, and streamlining business processes. As AI adoption grows, we also discuss the potential challenges and the opportunities it presents for businesses to innovate and stay competitive.',NULL,'2024-12-05 01:31:17',NULL),(3,1,NULL,'Emerging AI Technologies Revolutionizing Industries in 2024','emerging-ai-technologies-revolutionizing-industries-in-2024','Discover how AI-driven personalization is revolutionizing customer experience in 2024, enabling businesses to deliver tailored content, products, and services like never before.','In 2024, artificial intelligence is taking customer experience to new heights by enabling businesses to offer highly personalized services. With AI algorithms analyzing customer data in real-time, companies can now deliver individualized recommendations, targeted marketing, and seamless user experiences. From e-commerce sites offering personalized product suggestions to content platforms recommending videos, AI-driven personalization is enhancing customer satisfaction and engagement. This blog explores the technologies behind AI personalization, including machine learning, natural language processing, and data analytics, and examines how businesses are leveraging these tools to stay ahead in a competitive market while improving customer loyalty and retention.',NULL,'2024-12-05 01:31:17',NULL);
/*!40000 ALTER TABLE `blogs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbot_conversations`
--

DROP TABLE IF EXISTS `chatbot_conversations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbot_conversations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `chatbot_id` varchar(255) NOT NULL,
  `session_id` varchar(255) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `country_code` varchar(255) DEFAULT NULL,
  `message_user` varchar(255) DEFAULT NULL,
  `conversations_type` varchar(255) DEFAULT NULL,
  `message_content` varchar(255) 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 `chatbot_conversations`
--

LOCK TABLES `chatbot_conversations` WRITE;
/*!40000 ALTER TABLE `chatbot_conversations` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbot_conversations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbot_leads`
--

DROP TABLE IF EXISTS `chatbot_leads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbot_leads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `chatbot_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) 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 `chatbot_leads`
--

LOCK TABLES `chatbot_leads` WRITE;
/*!40000 ALTER TABLE `chatbot_leads` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbot_leads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbot_source_pdfs`
--

DROP TABLE IF EXISTS `chatbot_source_pdfs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbot_source_pdfs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `chatbot_id` varchar(255) DEFAULT NULL,
  `pdf_path` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `length` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `chatbot_source_pdfs`
--

LOCK TABLES `chatbot_source_pdfs` WRITE;
/*!40000 ALTER TABLE `chatbot_source_pdfs` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbot_source_pdfs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbot_source_qas`
--

DROP TABLE IF EXISTS `chatbot_source_qas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbot_source_qas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `chatbot_id` varchar(255) DEFAULT NULL,
  `question` varchar(255) DEFAULT NULL,
  `answer` longtext DEFAULT NULL,
  `length` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `chatbot_source_qas`
--

LOCK TABLES `chatbot_source_qas` WRITE;
/*!40000 ALTER TABLE `chatbot_source_qas` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbot_source_qas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbot_source_summaries`
--

DROP TABLE IF EXISTS `chatbot_source_summaries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbot_source_summaries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `chatbot_id` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `length` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `chatbot_source_summaries`
--

LOCK TABLES `chatbot_source_summaries` WRITE;
/*!40000 ALTER TABLE `chatbot_source_summaries` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbot_source_summaries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbot_source_urls`
--

DROP TABLE IF EXISTS `chatbot_source_urls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbot_source_urls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `chatbot_id` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `length` int(11) NOT NULL DEFAULT 0,
  `type` tinyint(4) DEFAULT NULL,
  `trained_duration` tinyint(4) DEFAULT NULL,
  `status` tinyint(4) 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 `chatbot_source_urls`
--

LOCK TABLES `chatbot_source_urls` WRITE;
/*!40000 ALTER TABLE `chatbot_source_urls` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbot_source_urls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbot_source_video_links`
--

DROP TABLE IF EXISTS `chatbot_source_video_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbot_source_video_links` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `chatbot_id` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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 `chatbot_source_video_links`
--

LOCK TABLES `chatbot_source_video_links` WRITE;
/*!40000 ALTER TABLE `chatbot_source_video_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbot_source_video_links` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chatbots`
--

DROP TABLE IF EXISTS `chatbots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chatbots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `chatbot_id` varchar(255) DEFAULT NULL,
  `chatbot_name` varchar(255) DEFAULT NULL,
  `selected_font` varchar(255) DEFAULT NULL,
  `custom_font_path` varchar(255) DEFAULT NULL,
  `custom_font_name` varchar(255) DEFAULT NULL,
  `lead_title` varchar(255) DEFAULT NULL,
  `lead_name` varchar(255) DEFAULT NULL,
  `lead_name_enable` tinyint(4) NOT NULL DEFAULT 0,
  `lead_email` varchar(255) DEFAULT NULL,
  `lead_email_enable` tinyint(4) NOT NULL DEFAULT 0,
  `lead_phone` varchar(255) DEFAULT NULL,
  `lead_phone_enable` tinyint(4) NOT NULL DEFAULT 0,
  `escalation_email` varchar(255) DEFAULT NULL,
  `remove_branding` varchar(255) NOT NULL DEFAULT '1',
  `bubble_icon` varchar(255) DEFAULT NULL,
  `bubble_icon_Color` varchar(255) DEFAULT NULL,
  `bubble_background` varchar(255) DEFAULT NULL,
  `bubble_position` tinyint(4) NOT NULL DEFAULT 2,
  `header_logo` varchar(255) DEFAULT NULL,
  `header_title` varchar(255) DEFAULT NULL,
  `header_title_color` varchar(255) DEFAULT NULL,
  `header_subtitle` varchar(255) DEFAULT NULL,
  `header_subtitle_color` varchar(255) DEFAULT NULL,
  `header_background_color` varchar(255) DEFAULT NULL,
  `body_initial_messages` varchar(255) DEFAULT NULL,
  `body_suggested_messages` varchar(255) DEFAULT NULL,
  `body_chatbot_message_color` varchar(255) DEFAULT NULL,
  `body_chatbot_message_background` varchar(255) DEFAULT NULL,
  `body_user_message_color` varchar(255) DEFAULT NULL,
  `body_user_message_background` varchar(255) DEFAULT NULL,
  `body_background` varchar(255) DEFAULT NULL,
  `footer_message_placeholder` varchar(255) DEFAULT NULL,
  `footer_message_placeholder_color` varchar(255) DEFAULT NULL,
  `footer_message_color` varchar(255) DEFAULT NULL,
  `footer_information` varchar(255) DEFAULT NULL,
  `footer_background` varchar(255) DEFAULT NULL,
  `embed_code` longtext DEFAULT NULL,
  `sources_file_path` varchar(255) DEFAULT NULL,
  `visibility` tinyint(4) NOT NULL DEFAULT 1,
  `domain_permission_status` tinyint(4) NOT NULL DEFAULT 1,
  `permission_domain` text DEFAULT NULL,
  `rate_limit_msg_count` int(11) DEFAULT NULL,
  `rate_limit_second_count` int(11) DEFAULT NULL,
  `rate_limit_alert_msg` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `chatbots`
--

LOCK TABLES `chatbots` WRITE;
/*!40000 ALTER TABLE `chatbots` DISABLE KEYS */;
/*!40000 ALTER TABLE `chatbots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact_us`
--

DROP TABLE IF EXISTS `contact_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact_us` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) 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 `contact_us`
--

LOCK TABLES `contact_us` WRITE;
/*!40000 ALTER TABLE `contact_us` DISABLE KEYS */;
/*!40000 ALTER TABLE `contact_us` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `credit_configurations`
--

DROP TABLE IF EXISTS `credit_configurations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `credit_configurations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `chatbot_conversation_credit` int(11) NOT NULL DEFAULT 0,
  `chatbot_url_training_credit` int(11) NOT NULL DEFAULT 0,
  `chatbot_pdf_training_credit` int(11) NOT NULL DEFAULT 0,
  `chatbot_plain_text_training_credit` int(11) NOT NULL DEFAULT 0,
  `chatbot_qa_training_credit` int(11) NOT NULL DEFAULT 0,
  `branding_remove_credit` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `credit_configurations`
--

LOCK TABLES `credit_configurations` WRITE;
/*!40000 ALTER TABLE `credit_configurations` DISABLE KEYS */;
/*!40000 ALTER TABLE `credit_configurations` 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(255) 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 `frontend_settings`
--

DROP TABLE IF EXISTS `frontend_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `frontend_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `hero_slogan` varchar(255) DEFAULT NULL,
  `hero_slogan_button_text` varchar(255) DEFAULT NULL,
  `hero_slogan_button_icon` varchar(255) DEFAULT NULL,
  `hero_title` varchar(255) DEFAULT NULL,
  `hero_title_animation_text` varchar(255) DEFAULT NULL,
  `hero_button_text` varchar(255) DEFAULT NULL,
  `hero_short_description` text DEFAULT NULL,
  `about_section_title` varchar(255) DEFAULT NULL,
  `about_title` varchar(255) DEFAULT NULL,
  `about_short_description` text DEFAULT NULL,
  `about_preview_image` varchar(255) DEFAULT NULL,
  `about_video_link` varchar(255) DEFAULT NULL,
  `main_feature_title` varchar(255) DEFAULT NULL,
  `main_feature_short_description` text DEFAULT NULL,
  `embedded_feature_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `embedded_feature_title` varchar(255) DEFAULT NULL,
  `embedded_feature_short_description` text DEFAULT NULL,
  `embedded_feature_image` varchar(255) DEFAULT NULL,
  `playground_feature_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `playground_feature_title` varchar(255) DEFAULT NULL,
  `playground_feature_short_description` text DEFAULT NULL,
  `ai_support_feature_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `ai_support_feature_title` varchar(255) DEFAULT NULL,
  `ai_support_feature_short_description` text DEFAULT NULL,
  `customize_feature_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `customize_feature_title` varchar(255) DEFAULT NULL,
  `customize_feature_short_description` text DEFAULT NULL,
  `customize_left_feature_item_image` varchar(255) DEFAULT NULL,
  `customize_right_feature_item_image` varchar(255) DEFAULT NULL,
  `pricing_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `pricing_title` varchar(255) DEFAULT NULL,
  `pricing_short_description` text DEFAULT NULL,
  `blog_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `blog_title` varchar(255) DEFAULT NULL,
  `blog_short_description` text DEFAULT NULL,
  `lets_go_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `lets_go_title` varchar(255) DEFAULT NULL,
  `lets_go_short_description` text DEFAULT NULL,
  `lets_go_button` varchar(255) DEFAULT NULL,
  `lets_talk_section_status` tinyint(4) NOT NULL DEFAULT 1,
  `lets_talk_title` varchar(255) DEFAULT NULL,
  `lets_talk_short_description` text DEFAULT NULL,
  `lets_talk_button` varchar(255) 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 `frontend_settings`
--

LOCK TABLES `frontend_settings` WRITE;
/*!40000 ALTER TABLE `frontend_settings` DISABLE KEYS */;
INSERT INTO `frontend_settings` VALUES (1,1,'Our mission and your','Growth',NULL,'AI-Powered support for your','Business,Platform,Agency','Get Started','Help your users help themselves with an AI-Powered bdcBot, knowledge base, AI-Assisted ticketing, and email support. Lorem ipsum dolor sit amet contrestu sintru Lorem ipsum dolor.','About Us','Spend less time on support','Watch the story of how Aidbase came to be, and how we\'re helping businesses and creators around the world.',NULL,NULL,'Spend less time on support','A complete support ecosystem to help you spend less time supporting your users - and more time growing your business.',1,'Get embedded code','A well-trained AI chatbot can deliver better results than humans in 9/10 cases. And it never sleeps! Connect your data sources and automate customer service. The AI chatbot will learn from your data and will deliver a human-like support experience - around the clock. Lorem ipsum dolor...',NULL,1,'bdcBotx','A well-trained AI chatbot can deliver better results than humans in 9/10 cases. And it never sleeps!',1,'Training Source','Connect your data sources and get a ChatGPT-like bdcBot for your products.',1,'Customize','Upload your own logo.',NULL,NULL,1,'Choose your comfortable Package','Select the package that best matches your requirements, offering the right features, compatibility, and ease of use to ensure optimal performance and smooth integration with your project or system.',1,'Latest Blogs & News','Stay updated with the latest blogs and news, offering insights, trends, and expert opinions to keep you informed and ahead in your field.',1,'Why are you waiting for?','Help your users help themselves - with an automated customer experience. You can get started with Aidbase for free, no credit card required.','Let\'s go',1,'Contact Us','Get in touch with us for any inquiries, support, or feedback. We\'re here to assist you and will respond as soon as possible.','Let\'s Talk',NULL,NULL);
/*!40000 ALTER TABLE `frontend_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) 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 `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` 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(255) 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 `main_feature_items`
--

DROP TABLE IF EXISTS `main_feature_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `main_feature_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `main_feature_item_status` tinyint(4) NOT NULL DEFAULT 1,
  `main_feature_item_image` varchar(255) DEFAULT NULL,
  `main_feature_item_title` varchar(255) DEFAULT NULL,
  `main_feature_item_short_description` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `main_feature_items`
--

LOCK TABLES `main_feature_items` WRITE;
/*!40000 ALTER TABLE `main_feature_items` DISABLE KEYS */;
INSERT INTO `main_feature_items` VALUES (1,1,NULL,'Multi ChatBot','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(2,1,NULL,'Color configuration','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(3,1,NULL,'Custom Font','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(4,1,NULL,'Lead Collection','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(5,1,NULL,'Chat Escalation','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(6,1,NULL,'4 Way Training','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(7,1,NULL,'Chat Log Display','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(8,1,NULL,'Chat Analytics','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL),(9,1,NULL,'OpenAI Configuration','Create an AI chatbot and make it an expert on your business.',NULL,NULL,NULL);
/*!40000 ALTER TABLE `main_feature_items` 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(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 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,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_07_10_044644_create_support_tickets_table',1),(5,'2024_10_08_040824_create_app_configurations_table',1),(6,'2024_10_14_091039_create_multi_languages_table',1),(7,'2024_10_16_091113_create_packages_table',1),(8,'2024_10_17_050427_create_orders_table',1),(9,'2024_10_17_094054_create_subscribers_table',1),(10,'2024_10_20_035101_create_payment_gateways_table',1),(11,'2024_10_22_123122_create_ticket_replies_table',1),(12,'2024_10_29_110021_create_app_notifications_table',1),(13,'2024_11_13_104423_create_open_ai_configurations_table',1),(14,'2024_11_13_120021_create_credit_configurations_table',1),(15,'2024_11_14_060355_create_chatbots_table',1),(16,'2024_11_14_114722_create_chatbot_source_urls_table',1),(17,'2024_11_14_114741_create_chatbot_source_summaries_table',1),(18,'2024_11_14_114806_create_chatbot_source_qas_table',1),(19,'2024_11_14_114833_create_chatbot_source_pdfs_table',1),(20,'2024_11_14_114917_create_chatbot_source_video_links_table',1),(21,'2024_11_14_114942_create_chatbot_leads_table',1),(22,'2024_11_14_115002_create_chatbot_conversations_table',1),(23,'2024_11_20_071756_create_frontend_settings_table',1),(24,'2024_11_21_025149_create_main_feature_items_table',1),(25,'2024_11_21_053206_create_playground_feature_items_table',1),(26,'2024_11_24_015541_create_ai_support_feature_items_table',1),(27,'2024_11_25_012441_create_blogs_table',1),(28,'2024_11_26_083045_create_terms_conditions_table',1),(29,'2024_11_26_104249_create_privacy_policies_table',1),(30,'2024_11_29_140626_create_contact_us_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `multi_languages`
--

DROP TABLE IF EXISTS `multi_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multi_languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `language_name` varchar(255) DEFAULT NULL,
  `iso_code` varchar(255) DEFAULT NULL,
  `flag_image` varchar(255) DEFAULT NULL,
  `default_language` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `multi_languages`
--

LOCK TABLES `multi_languages` WRITE;
/*!40000 ALTER TABLE `multi_languages` DISABLE KEYS */;
INSERT INTO `multi_languages` VALUES (1,1,1,'English','en',NULL,'1',NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17');
/*!40000 ALTER TABLE `multi_languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `open_ai_configurations`
--

DROP TABLE IF EXISTS `open_ai_configurations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `open_ai_configurations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `model` varchar(255) DEFAULT NULL,
  `secret_key` varchar(255) DEFAULT NULL,
  `character_limit` 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 `open_ai_configurations`
--

LOCK TABLES `open_ai_configurations` WRITE;
/*!40000 ALTER TABLE `open_ai_configurations` DISABLE KEYS */;
/*!40000 ALTER TABLE `open_ai_configurations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `refer_id` int(11) DEFAULT NULL,
  `package_id` int(11) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `gateway_id` varchar(255) DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount_type` tinyint(4) DEFAULT NULL,
  `conversion_rate` decimal(12,2) NOT NULL DEFAULT 0.00,
  `platform_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `status` tinyint(4) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` 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,
  `user_id` bigint(20) unsigned NOT NULL,
  `package_name` varchar(255) DEFAULT NULL,
  `monthly_price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `yearly_price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `credit` int(11) NOT NULL DEFAULT 0,
  `icon` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `is_trail` tinyint(4) NOT NULL DEFAULT 0,
  `is_popular` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 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 */;
INSERT INTO `packages` VALUES (1,1,'Trail',0.00,0.00,1000,NULL,1,1,0,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17'),(2,1,'Silver',120.00,410.00,100,NULL,1,0,0,NULL,NULL,NULL),(3,1,'Gold',250.00,500.00,300,NULL,1,0,0,NULL,NULL,NULL),(4,1,'Platinum',410.00,700.00,500,NULL,1,0,0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_gateways`
--

DROP TABLE IF EXISTS `payment_gateways`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_gateways` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `mode` varchar(255) NOT NULL DEFAULT '1',
  `image` varchar(255) DEFAULT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `secret_key` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `currency_rate` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_gateways`
--

LOCK TABLES `payment_gateways` WRITE;
/*!40000 ALTER TABLE `payment_gateways` DISABLE KEYS */;
INSERT INTO `payment_gateways` VALUES (1,1,'PayPal','paypal','1','assets/images/payment-gateway/paypal.png',NULL,NULL,'USD','1',1,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17'),(2,1,'Stripe','stripe','1','assets/images/payment-gateway/stripe.png',NULL,NULL,'USD','1',1,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17'),(3,1,'Mollie','mollie','1','assets/images/payment-gateway/mollie.png',NULL,NULL,'USD','1',1,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17'),(4,1,'Paystack','paystack','1','assets/images/payment-gateway/paystack.png',NULL,NULL,'USD','1',1,NULL,'2024-12-05 01:31:17','2024-12-05 01:31:17');
/*!40000 ALTER TABLE `payment_gateways` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `playground_feature_items`
--

DROP TABLE IF EXISTS `playground_feature_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `playground_feature_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `playground_middle_image` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_image_one` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_title_one` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_short_description_one` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_image_two` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_title_two` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_short_description_two` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_image_three` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_title_three` varchar(255) DEFAULT NULL,
  `playground_left_feature_item_short_description_three` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_image_one` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_title_one` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_short_description_one` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_image_two` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_title_two` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_short_description_two` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_image_three` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_title_three` varchar(255) DEFAULT NULL,
  `playground_right_feature_item_short_description_three` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `playground_feature_items`
--

LOCK TABLES `playground_feature_items` WRITE;
/*!40000 ALTER TABLE `playground_feature_items` DISABLE KEYS */;
INSERT INTO `playground_feature_items` VALUES (1,NULL,NULL,'Always online','Your chatbot doesn\'t need breaks. it\'s online 24/7.',NULL,'Fully customizable','Your chatbot doesn\'t need breaks. it\'s online 24/7.',NULL,'Fast retrain','Your chatbot doesn\'t need breaks. it\'s online 24/7.',NULL,'Trained on your data','Your chatbot doesn\'t need breaks. it\'s online 24/7.',NULL,'No Code','Your chatbot doesn\'t need breaks. it\'s online 24/7.',NULL,'Custom prompts','Your chatbot doesn\'t need breaks. it\'s online 24/7.',NULL,NULL,NULL);
/*!40000 ALTER TABLE `playground_feature_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `privacy_policies`
--

DROP TABLE IF EXISTS `privacy_policies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `privacy_policies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`description`)),
  `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 `privacy_policies`
--

LOCK TABLES `privacy_policies` WRITE;
/*!40000 ALTER TABLE `privacy_policies` DISABLE KEYS */;
/*!40000 ALTER TABLE `privacy_policies` 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(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext 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 `subscribers`
--

DROP TABLE IF EXISTS `subscribers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscribers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `package_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `monthly_price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `yearly_price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `credit` int(11) NOT NULL DEFAULT 0,
  `use_credit` int(11) NOT NULL DEFAULT 0,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `is_trail` tinyint(4) NOT NULL DEFAULT 0,
  `subscription_type` tinyint(4) DEFAULT NULL,
  `expired_by` tinyint(4) DEFAULT NULL,
  `last_email_sent` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `subscribers`
--

LOCK TABLES `subscribers` WRITE;
/*!40000 ALTER TABLE `subscribers` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscribers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `support_tickets`
--

DROP TABLE IF EXISTS `support_tickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `support_tickets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tracking_no` varchar(255) NOT NULL,
  `ticket_title` varchar(255) NOT NULL,
  `ticket_description` longtext NOT NULL,
  `last_reply_id` bigint(20) unsigned DEFAULT NULL,
  `last_reply_by` bigint(20) unsigned DEFAULT NULL,
  `last_reply_time` timestamp NULL DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `files` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`files`)),
  `created_by` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL 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 `support_tickets`
--

LOCK TABLES `support_tickets` WRITE;
/*!40000 ALTER TABLE `support_tickets` DISABLE KEYS */;
/*!40000 ALTER TABLE `support_tickets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms_conditions`
--

DROP TABLE IF EXISTS `terms_conditions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terms_conditions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`description`)),
  `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 `terms_conditions`
--

LOCK TABLES `terms_conditions` WRITE;
/*!40000 ALTER TABLE `terms_conditions` DISABLE KEYS */;
/*!40000 ALTER TABLE `terms_conditions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket_replies`
--

DROP TABLE IF EXISTS `ticket_replies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_replies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint(20) unsigned NOT NULL,
  `body` longtext DEFAULT NULL,
  `files` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`files`)),
  `created_by` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL 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 `ticket_replies`
--

LOCK TABLES `ticket_replies` WRITE;
/*!40000 ALTER TABLE `ticket_replies` DISABLE KEYS */;
/*!40000 ALTER TABLE `ticket_replies` 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,
  `role` tinyint(4) NOT NULL DEFAULT 2,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `raw_password` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `picture` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `facebook_id` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_google_id_unique` (`google_id`),
  UNIQUE KEY `users_facebook_id_unique` (`facebook_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 `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,1,1,'Mr. Admin','admin@gmail.com',NULL,'$2y$12$.rYdPc4nUpm56wBqZfbLTOi.damMOrLJa83lXbwofeRJvwHS.HZiO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` 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 2024-12-05 13:31:31
