File: /var/www/html/tmpr/..//tmpr/../VCARDEXPORTS/whatsapp.sql
/*!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.5.25-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: whatsapp
-- ------------------------------------------------------
-- 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 `activities`
--
DROP TABLE IF EXISTS `activities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activities` (
`id` bigint(20) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL DEFAULT 0,
`reviewer_id` int(11) NOT NULL DEFAULT 0,
`product_id` int(10) unsigned NOT NULL DEFAULT 0,
`message` text DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `activities`
--
LOCK TABLES `activities` WRITE;
/*!40000 ALTER TABLE `activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_notifications`
--
DROP TABLE IF EXISTS `admin_notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_notifications` (
`id` bigint(20) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL DEFAULT 0,
`title` varchar(255) DEFAULT NULL,
`is_read` tinyint(1) NOT NULL DEFAULT 0,
`click_url` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_notifications`
--
LOCK TABLES `admin_notifications` WRITE;
/*!40000 ALTER TABLE `admin_notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_notifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_password_resets`
--
DROP TABLE IF EXISTS `admin_password_resets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_password_resets` (
`id` bigint(20) unsigned NOT NULL,
`email` varchar(40) DEFAULT NULL,
`token` varchar(40) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_password_resets`
--
LOCK TABLES `admin_password_resets` WRITE;
/*!40000 ALTER TABLE `admin_password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_password_resets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admins`
--
DROP TABLE IF EXISTS `admins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admins` (
`id` bigint(20) unsigned NOT NULL,
`name` varchar(40) DEFAULT NULL,
`email` varchar(40) DEFAULT NULL,
`username` varchar(40) DEFAULT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`remember_token` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admins`
--
LOCK TABLES `admins` WRITE;
/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
INSERT INTO `admins` VALUES (1,'Super Admin','admin@gmail.com','admin',NULL,'65bf57e38aebf1707038691.png','$2y$10$P1yRgIT3Oc1vlVWwGL57d.4Pr4De4t4u2aZIzkRi6GsTyciwmvjzm','XNbbACu1lQyITQq9qrjuiD0rCiScj1V1Fp2fxCLuYz7TbLGpvI3zRSBUVWco',NULL,'2024-02-04 03:24:51');
/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `apps`
--
DROP TABLE IF EXISTS `apps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `apps` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`uuid` char(36) NOT NULL,
`key` varchar(191) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`cloudapi_id` bigint(20) unsigned DEFAULT NULL,
`title` varchar(191) DEFAULT NULL,
`website` varchar(191) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `apps_uuid_unique` (`uuid`),
UNIQUE KEY `apps_key_unique` (`key`),
KEY `apps_user_id_foreign` (`user_id`),
KEY `apps_cloudapi_id_foreign` (`cloudapi_id`),
CONSTRAINT `apps_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE SET NULL,
CONSTRAINT `apps_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `apps`
--
LOCK TABLES `apps` WRITE;
/*!40000 ALTER TABLE `apps` DISABLE KEYS */;
/*!40000 ALTER TABLE `apps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `author_level_user`
--
DROP TABLE IF EXISTS `author_level_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `author_level_user` (
`author_level_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `author_level_user`
--
LOCK TABLES `author_level_user` WRITE;
/*!40000 ALTER TABLE `author_level_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `author_level_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `author_levels`
--
DROP TABLE IF EXISTS `author_levels`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `author_levels` (
`id` bigint(20) unsigned NOT NULL,
`name` varchar(40) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`minimum_earning` decimal(28,8) NOT NULL DEFAULT 0.00000000,
`fee` decimal(28,8) NOT NULL DEFAULT 0.00000000,
`status` tinyint(1) NOT NULL DEFAULT 0,
`details` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `author_levels`
--
LOCK TABLES `author_levels` WRITE;
/*!40000 ALTER TABLE `author_levels` DISABLE KEYS */;
/*!40000 ALTER TABLE `author_levels` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `carts`
--
DROP TABLE IF EXISTS `carts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `carts` (
`id` bigint(20) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL DEFAULT 0,
`user_id` int(10) unsigned DEFAULT 0,
`session_id` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`category_id` int(10) unsigned NOT NULL DEFAULT 0,
`category` varchar(255) DEFAULT NULL,
`license` varchar(255) NOT NULL,
`is_extended` tinyint(1) NOT NULL DEFAULT 0,
`extended_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
`price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
`seller_fee` decimal(28,8) NOT NULL DEFAULT 0.00000000,
`buyer_fee` decimal(28,8) NOT NULL DEFAULT 0.00000000,
`quantity` int(11) NOT NULL DEFAULT 1,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `carts`
--
LOCK TABLES `carts` WRITE;
/*!40000 ALTER TABLE `carts` DISABLE KEYS */;
/*!40000 ALTER TABLE `carts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `categories`
--
DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) NOT NULL,
`slug` varchar(191) DEFAULT NULL,
`type` varchar(191) NOT NULL DEFAULT 'category',
`status` int(11) NOT NULL DEFAULT 1,
`is_featured` int(11) NOT NULL DEFAULT 1,
`lang` varchar(191) NOT NULL DEFAULT 'en',
`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 `categories`
--
LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `categorymetas`
--
DROP TABLE IF EXISTS `categorymetas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categorymetas` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`category_id` bigint(20) unsigned NOT NULL,
`type` varchar(191) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
KEY `categorymetas_category_id_foreign` (`category_id`),
CONSTRAINT `categorymetas_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `categorymetas`
--
LOCK TABLES `categorymetas` WRITE;
/*!40000 ALTER TABLE `categorymetas` DISABLE KEYS */;
/*!40000 ALTER TABLE `categorymetas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chat_messages`
--
DROP TABLE IF EXISTS `chat_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_messages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`cloudapi_id` bigint(20) unsigned NOT NULL,
`phone_number` varchar(191) NOT NULL,
`message_history` text NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT '2024-08-12 15:35:07',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `chat_messages_cloudapi_id_foreign` (`cloudapi_id`),
CONSTRAINT `chat_messages_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat_messages`
--
LOCK TABLES `chat_messages` WRITE;
/*!40000 ALTER TABLE `chat_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cloudapiorders`
--
DROP TABLE IF EXISTS `cloudapiorders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cloudapiorders` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`trx` varchar(191) DEFAULT NULL,
`amount` double DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`phone` int(11) NOT NULL,
`status` varchar(191) NOT NULL DEFAULT 'pending',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `cloudapiorders_user_id_foreign` (`user_id`),
CONSTRAINT `cloudapiorders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cloudapiorders`
--
LOCK TABLES `cloudapiorders` WRITE;
/*!40000 ALTER TABLE `cloudapiorders` DISABLE KEYS */;
/*!40000 ALTER TABLE `cloudapiorders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cloudapis`
--
DROP TABLE IF EXISTS `cloudapis`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cloudapis` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`uuid` char(36) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) NOT NULL,
`phone` varchar(191) DEFAULT NULL,
`user_name` varchar(191) DEFAULT NULL,
`phone_number_id` varchar(191) DEFAULT NULL,
`wa_business_id` varchar(191) DEFAULT NULL,
`meta_app_id` varchar(191) DEFAULT NULL,
`access_token` varchar(255) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`image` varchar(191) DEFAULT NULL,
`about` text DEFAULT NULL,
`address` varchar(191) DEFAULT NULL,
`description` text DEFAULT NULL,
`industry` varchar(191) DEFAULT NULL,
`email` varchar(191) DEFAULT NULL,
`website` varchar(191) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cloudapis_uuid_unique` (`uuid`),
KEY `cloudapis_user_id_foreign` (`user_id`),
CONSTRAINT `cloudapis_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cloudapis`
--
LOCK TABLES `cloudapis` WRITE;
/*!40000 ALTER TABLE `cloudapis` DISABLE KEYS */;
/*!40000 ALTER TABLE `cloudapis` 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` varchar(191) DEFAULT NULL,
`phone` varchar(191) DEFAULT NULL,
`param1` varchar(191) NOT NULL,
`param2` varchar(191) NOT NULL,
`param3` varchar(191) NOT NULL,
`param4` varchar(191) NOT NULL,
`param5` varchar(191) NOT NULL,
`param6` varchar(191) NOT NULL,
`param7` varchar(191) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `contacts_user_id_foreign` (`user_id`),
CONSTRAINT `contacts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) 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 `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 `gateways`
--
DROP TABLE IF EXISTS `gateways`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gateways` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`currency` varchar(191) DEFAULT NULL,
`logo` varchar(191) DEFAULT NULL,
`charge` double NOT NULL DEFAULT 0,
`multiply` double NOT NULL DEFAULT 1,
`namespace` varchar(191) NOT NULL,
`min_amount` double NOT NULL DEFAULT 1,
`max_amount` double NOT NULL DEFAULT 1000,
`is_auto` int(11) NOT NULL DEFAULT 0,
`image_accept` int(11) DEFAULT NULL,
`test_mode` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL DEFAULT 1,
`phone_required` int(11) NOT NULL DEFAULT 0,
`data` text DEFAULT NULL,
`comment` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gateways`
--
LOCK TABLES `gateways` WRITE;
/*!40000 ALTER TABLE `gateways` DISABLE KEYS */;
INSERT INTO `gateways` VALUES (1,'paypal','usd','/uploads/payment-gateway/paypal.png',2,1,'App\\Gateway\\Paypal',1,1000,1,0,1,0,0,'{\"client_id\":\"\",\"client_secret\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(2,'stripe','usd','/uploads/payment-gateway/stripe.png',2,1,'App\\Gateway\\Stripe',1,1000,1,0,1,0,0,'{\"publishable_key\":\"\",\"secret_key\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(3,'mollie','usd','/uploads/payment-gateway/mollie.png',2,1,'App\\Gateway\\Mollie',1,1000,1,0,1,1,0,'{\"api_key\":\"test_WqUGsP9qywy3eRVvWMRayxmVB5dx2r\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(4,'paystack',NULL,'/uploads/payment-gateway/paystack.png',2,1,'App\\Gateway\\Paystack',1,1000,1,0,1,0,0,'{\"public_key\":\"\",\"secret_key\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(5,'razorpay','inr','/uploads/payment-gateway/rajorpay.png',2,1,'App\\Gateway\\Razorpay',1,10000,1,0,1,0,0,'{\"key_id\":\"\",\"key_secret\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(6,'instamojo','inr','/uploads/payment-gateway/instamojo.png',2,1,'App\\Gateway\\Instamojo',1,1000,1,0,1,0,1,'{\"x_api_key\":\"\",\"x_auth_token\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(7,'toyyibpay','rm','/uploads/payment-gateway/toyybipay.png',2,1,'App\\Gateway\\Toyyibpay',1,1000,1,0,1,0,1,'{\"user_secret_key\":\"\",\"cateogry_code\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(8,'flutterwave',NULL,'/uploads/payment-gateway/flutterwave.png',2,1,'App\\Gateway\\Flutterwave',1,1000,1,0,1,0,1,'{\"public_key\":\"\",\"secret_key\":\"\",\"encryption_key\":\"\",\"payment_options\":\"card\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(9,'payu',NULL,'/uploads/payment-gateway/payu.png',2,1,'App\\Gateway\\Payu',1,1000,1,0,1,0,1,'{\"merchant_key\":\"\",\"merchant_salt\":\"\",\"auth_header\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(10,'thawani',NULL,'/uploads/payment-gateway/uhawan.png',1,1,'App\\Gateway\\Thawani',1,1000,1,0,1,0,1,'{\"secret_key\":\"\",\"publishable_key\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08'),(11,'mercadopago',NULL,'/uploads/payment-gateway/mercado-pago.png',2,1,'App\\Gateway\\Mercado',1,1000,1,0,1,0,0,'{\"secret_key\":\"\",\"public_key\":\"\"}',NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08');
/*!40000 ALTER TABLE `gateways` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groupcontacts`
--
DROP TABLE IF EXISTS `groupcontacts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groupcontacts` (
`group_id` bigint(20) unsigned NOT NULL,
`contact_id` bigint(20) unsigned NOT NULL,
KEY `groupcontacts_group_id_foreign` (`group_id`),
KEY `groupcontacts_contact_id_foreign` (`contact_id`),
CONSTRAINT `groupcontacts_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
CONSTRAINT `groupcontacts_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groupcontacts`
--
LOCK TABLES `groupcontacts` WRITE;
/*!40000 ALTER TABLE `groupcontacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `groupcontacts` 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 NOT NULL,
`name` varchar(191) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `groups_user_id_foreign` (`user_id`),
CONSTRAINT `groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) 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 `inventory`
--
DROP TABLE IF EXISTS `inventory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`cloudapi_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `inventory_user_id_foreign` (`user_id`),
KEY `inventory_cloudapi_id_foreign` (`cloudapi_id`),
CONSTRAINT `inventory_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE CASCADE,
CONSTRAINT `inventory_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `inventory`
--
LOCK TABLES `inventory` WRITE;
/*!40000 ALTER TABLE `inventory` DISABLE KEYS */;
/*!40000 ALTER TABLE `inventory` 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 `menus`
--
DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menus` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`position` varchar(191) NOT NULL,
`data` text NOT NULL,
`lang` varchar(191) NOT NULL DEFAULT 'en',
`status` varchar(191) NOT NULL DEFAULT '1',
`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 `menus`
--
LOCK TABLES `menus` WRITE;
/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
INSERT INTO `menus` VALUES (1,'Header','main-menu','[{\"text\":\"Home\",\"icon\":\"\",\"href\":\"/\",\"target\":\"_self\",\"title\":\"\"},{\"text\":\"Pricing\",\"icon\":\"empty\",\"href\":\"/pricing\",\"target\":\"_self\",\"title\":\"\"},{\"text\":\"About\",\"icon\":\"empty\",\"href\":\"/about\",\"target\":\"_self\",\"title\":\"\"},{\"text\":\"Features\",\"icon\":\"empty\",\"href\":\"/features\",\"target\":\"_self\",\"title\":\"\"},{\"text\":\"Blogs\",\"icon\":\"empty\",\"href\":\"/blogs\",\"target\":\"_self\",\"title\":\"\"},{\"text\":\"Contact\",\"icon\":\"empty\",\"href\":\"/contact\",\"target\":\"_self\",\"title\":\"\"}]','en','1','2024-08-12 15:35:08','2024-08-12 15:35:08');
/*!40000 ALTER TABLE `menus` 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=37 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,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2022_11_04_174202_create_cloudapiorders_table',1),(6,'2022_11_04_174204_create_cloudapis_table',1),(7,'2022_11_04_174205_create_apps_table',1),(8,'2022_11_07_154504_create_templates_table',1),(9,'2022_11_24_200110_create_smstransactions_table',1),(10,'2022_11_26_175433_create_smstesttransactions_table',1),(11,'2022_12_09_155744_create_schedulemessages_table',1),(12,'2022_12_09_164619_create_contacts_table',1),(13,'2022_12_09_165556_create_schedulecontacts_table',1),(14,'2023_02_04_181414_create_replies_table',1),(15,'2023_02_11_160234_create_supports_table',1),(16,'2023_02_11_160247_create_supportlogs_table',1),(17,'2023_02_12_163752_create_plans_table',1),(18,'2023_02_12_163758_create_gateways_table',1),(19,'2023_02_12_163759_create_orders_table',1),(20,'2023_02_12_170152_create_notifications_table',1),(21,'2023_02_13_130039_create_permission_tables',1),(22,'2023_02_14_181559_create_options_table',1),(23,'2023_02_19_082229_create_posts_table',1),(24,'2023_02_19_082240_create_categories_table',1),(25,'2023_02_19_082254_create_postcategories_table',1),(26,'2023_02_19_084742_create_categorymetas_table',1),(27,'2023_02_19_084751_create_postmetas_table',1),(28,'2023_02_19_085200_create_menus_table',1),(29,'2023_03_02_184250_create_jobs_table',1),(30,'2023_03_08_151642_create_groups_table',1),(31,'2023_03_08_151657_create_groupcontacts_table',1),(32,'2023_06_25_225906_create_chatmessages_table',1),(33,'2023_07_16_192430_create_order_table',1),(34,'2023_07_16_194128_create_inventory_table',1),(35,'2023_07_17_045751_create_products_table',1),(36,'2023_09_05_083732_add_column_to_table_name',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `model_has_permissions`
--
DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model_has_permissions` (
`permission_id` bigint(20) unsigned NOT NULL,
`model_type` varchar(191) NOT NULL,
`model_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `model_has_permissions`
--
LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `model_has_roles`
--
DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model_has_roles` (
`role_id` bigint(20) unsigned NOT NULL,
`model_type` varchar(191) NOT NULL,
`model_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`role_id`,`model_id`,`model_type`),
KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `model_has_roles`
--
LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`title` varchar(191) DEFAULT NULL,
`comment` text DEFAULT NULL,
`url` varchar(191) DEFAULT NULL,
`seen` int(11) NOT NULL DEFAULT 0,
`is_admin` int(11) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `notifications_user_id_foreign` (`user_id`),
CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notifications`
--
LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `options`
--
DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `options` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(191) NOT NULL,
`value` text NOT NULL,
`lang` varchar(191) NOT NULL DEFAULT 'en',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `options`
--
LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;
INSERT INTO `options` VALUES (1,'primary_data','{\"logo\":\"\\/uploads\\/2023\\/07\\/1689248021hH7LW2wg2bpg0zMmCgU1.png\",\"favicon\":\"uploads\\/favicon.png\",\"contact_email\":\"contact@email.com\",\"contact_phone\":\"911234567890\",\"address\":\"Somewhere, India\",\"socials\":{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"youtube\":\"https:\\/\\/youtube.com\\/\",\"twitter\":\"https:\\/\\/twitter.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"linkedin\":\"https:\\/\\/linkedin.com\\/\"},\"footer_logo\":\"\\/uploads\\/2023\\/07\\/1689248021hH7LW2wg2bpg0zMmCgU1.png\"}','en'),(2,'tax','0','en'),(3,'base_currency','{\"name\":\"USD\",\"icon\":\"$\",\"position\":\"left\"}','en'),(4,'invoice_data','{\"company_name\":\"Ionfirm\",\"address\":\"somewhere\",\"city\":\"SM\",\"country\":\"India\",\"post_code\":\"123456\"}','en'),(5,'languages','{\"en\":\"English\"}','en'),(6,'seo_home','{\"site_name\":\"Home\",\"matatag\":\"\",\"matadescription\":\"\",\"twitter_site_title\":\"home\",\"preview\":\"\"}','en'),(7,'seo_blog','{\"site_name\":\"Blogs\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(8,'seo_about','{\"site_name\":\"About Us\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(9,'seo_pricing','{\"site_name\":\"Pricing\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(10,'seo_contact','{\"site_name\":\"Contact Us\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(11,'seo_faq','{\"site_name\":\"Faq\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(12,'seo_team','{\"site_name\":\"Our Team\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(13,'seo_features','{\"site_name\":\"Features\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(14,'seo_how_its_works','{\"site_name\":\"How its work\",\"matatag\":\"\",\"matadescription\":\"\",\"preview\":\"\"}','en'),(15,'contact-page','{\"address\":\"Somewhere, India,\",\"country\":\"IN 123456,IN\",\"map_link\":\"https:\\/\\/www.google.com.bd\\/maps\\/@24,85,15z\",\"contact1\":\"911234567890\",\"contact2\":\"911234567890\",\"email1\":\"support@email.com\",\"email2\":\"contact@email.com\"}','en'),(16,'banner','{\"phone_image_1\":\"\\/uploads\\/2023\\/07\\/1689923457QhzwCWj99WL6f41UBHgW.png\",\"phone_image_2\":\"\\/uploads\\/2023\\/07\\/1689924738gt1rdvhoAHo2IapTRUaB.png\",\"phone_image_3\":\"\\/uploads\\/2023\\/07\\/1689928142oYi04rnhNDRPuRTX1Rmr.png\",\"banner_header\":\"Revolutionize Your Marketing with WhatsCloud\",\"usedthis\":\"50k+ Used This Platform\",\"btnfirst\":\"Explore\",\"btnsecond\":\"Sign In\"}','en'),(17,'features','{\"feature_image\":\"\\/uploads\\/2023\\/07\\/16899299773QP4MmQdCj0eNyvLnIvB.png\",\"feature_header\":\"Features that makes platform different!\",\"feature_subheader\":\"Discover the Array of Distinctive Features Setting Our Platform Apart\",\"feature_1\":\"Secure API\",\"feature_1_details\":\"Ensure Ironclad Security with our Reliable and Encrypted API Connection for Peace of Mind.\",\"feature_2\":\"Template Messaging\",\"feature_2_details\":\"Effortlessly Create and Send Customizable Template Messages for Engaging and Consistent Communication.\",\"feature_3\":\"Auto Responder\",\"feature_3_details\":\"Deliver Instant Replies and Streamline Communication with Automated Responses for Enhanced Customer Engagement.\",\"feature_4\":\"24-7 Availablity\",\"feature_4_details\":\"Experience Uninterrupted Access Anytime, Anywhere with our 24\\/7 Availability for Seamless webhook Communication.\"}','en'),(18,'about_section','{\"frame_image\":\"\\/uploads\\/2023\\/07\\/1689930896RqN0uj9bXBeV24CJNcKV.png\",\"frame_image_2\":\"\\/uploads\\/2023\\/07\\/1689234953Np7Efhu6VmYKmsRX1MRb.png\",\"about_header\":\"Empowering Connections, Transforming Experiences\",\"about_subheader\":\"\\\"WhatsCloud is a revolutionary platform that empowers connections and transforms experiences. With its cutting-edge features and seamless integration, WhatsCloud revolutionizes communication, enabling businesses to reach new heights. Experience enhanced engagement, streamlined workflows, and unparalleled convenience, all within a secure and reliable environment. Join WhatsCloud and unlock the power of connected communication.\",\"feature_image_2\":null,\"about_api\":\"1200\",\"satisfied_user\":\"937\",\"customer_review\":\"772\",\"about_countries\":\"63\"}','en'),(19,'overview','{\"overview_image_1\":\"\\/uploads\\/2023\\/07\\/1689243060p2FHn4w9Wq8rrYA0kF5F.png\",\"overview_image_2\":\"\\/uploads\\/2023\\/07\\/1689243060jaJk7IZY9OLt8SUNt8km.png\",\"overview_image_3\":\"\\/uploads\\/2023\\/07\\/1689243060MbsrkuaHHC5dNb1K9k9A.png\",\"overview_header\":\"Embrace the Future with WhatsCloud\",\"overview_subheader\":\"Welcome to WhatsCloud, the innovative platform designed to revolutionize communication. Seamlessly connect with your audience, streamline workflows, and unlock new opportunities for growth. Experience the power of advanced features, robust security, and unparalleled convenience. Embrace the future of communication with WhatsCloud.\",\"overview_title_1\":\"Create & Send Templates\",\"overview_subtitle_1\":\"Effortlessly create and send customizable templates for engaging and consistent communication with ease and efficiency.\",\"overview_title_2\":\"Live Chat & Bulk Messaging\",\"overview_subtitle_2\":\"Experience seamless live chat functionality and send bulk messages for efficient and effective communication with your audience.\",\"overview_title_3\":\"Effortless Scheduling Experience\",\"overview_subtitle_3\":null}','en'),(20,'work','{\"step_image_1\":\"\\/uploads\\/2023\\/07\\/1689245834tJGWFYTxCNIqycDmIvMy.jpg\",\"step_image_2\":\"\\/uploads\\/2023\\/07\\/1689245834sVbI8r1CEg6Dv4mAC3n7.jpg\",\"step_image_3\":\"\\/uploads\\/2023\\/07\\/1689245834iwbfQlcsm9jOsiX6r1SS.jpg\",\"video_image\":\"\\/2023\\/07\\/16892458346uaAcMQyjZPetSmRBXU3.jpeg\",\"work_header\":\"How to Connect - 3 easy steps\",\"work_subheader\":\"Effortlessly integrate your WhatsApp Cloud API with our platform in three simple steps and harness the potential of seamless communication.\",\"step_title_1\":\"Set Up Your Facebook Developer Account\",\"step_subtitle_1\":\"Create an App\",\"step_description_1\":\"Initiate the process by creating an app on your Facebook Developer Account.\",\"step_title_2\":\"Select Business as Your App Type\",\"step_subtitle_2\":\"Provide Basic Business Information\",\"step_description_2\":\"Enter essential details about your business to proceed with the integration.\",\"step_title_3\":\"Access WhatsApp Integration\",\"step_subtitle_3\":\"Accept Terms and Conditions\",\"step_description_3\":\"Scroll down and click Continue to agree to WhatsApp Cloud APIs terms and conditions. Fill in your business information, connect your phone number, and start utilizing WhatsApp Cloud.\",\"video_header\":null,\"video_url\":\"https:\\/\\/YouTube.com\"}','en'),(21,'downlaod','{\"download_header\":\"Get Unlimited Experience With Whatscloud\",\"download_subheader\":\"Start it Today\",\"hero_image_1\":null,\"hero_image_2\":null}','en');
/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `order_manage`
--
DROP TABLE IF EXISTS `order_manage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_manage` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`cloudapi_id` bigint(20) unsigned NOT NULL,
`recipient_phone` varchar(191) NOT NULL,
`product_name` varchar(191) NOT NULL,
`quantity` int(11) NOT NULL,
`additional_instructions` text DEFAULT NULL,
`order_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`status` varchar(191) NOT NULL,
`total_amount` decimal(8,2) NOT NULL,
`delivery_address` varchar(191) NOT NULL,
`invoices` varchar(191) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_manage_user_id_foreign` (`user_id`),
KEY `order_manage_cloudapi_id_foreign` (`cloudapi_id`),
CONSTRAINT `order_manage_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE CASCADE,
CONSTRAINT `order_manage_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order_manage`
--
LOCK TABLES `order_manage` WRITE;
/*!40000 ALTER TABLE `order_manage` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_manage` 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,
`invoice_no` varchar(191) DEFAULT NULL,
`payment_id` varchar(191) DEFAULT NULL,
`plan_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`gateway_id` bigint(20) unsigned NOT NULL,
`amount` double DEFAULT NULL,
`tax` double DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`will_expire` date DEFAULT NULL,
`meta` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `orders_plan_id_foreign` (`plan_id`),
KEY `orders_user_id_foreign` (`user_id`),
KEY `orders_gateway_id_foreign` (`gateway_id`),
CONSTRAINT `orders_gateway_id_foreign` FOREIGN KEY (`gateway_id`) REFERENCES `gateways` (`id`) ON DELETE CASCADE,
CONSTRAINT `orders_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) 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 `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 `permissions`
--
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`guard_name` varchar(191) NOT NULL,
`group_name` varchar(191) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT 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 `permissions`
--
LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'about','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(2,'blogs','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(3,'blogs-category','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(4,'blog-tags','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(5,'faq','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(6,'features','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(7,'team','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(8,'language','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(9,'menu','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(10,'custom-page','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(11,'partners','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(12,'seo','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(13,'testimonials','web','Appearance','2024-08-12 15:35:08','2024-08-12 15:35:08'),(14,'page-settings','web','Site Settings','2024-08-12 15:35:08','2024-08-12 15:35:08'),(15,'admin','web','Site Settings','2024-08-12 15:35:08','2024-08-12 15:35:08'),(16,'developer-settings','web','Site Settings','2024-08-12 15:35:08','2024-08-12 15:35:08'),(17,'roles','web','Site Settings','2024-08-12 15:35:08','2024-08-12 15:35:08'),(18,'apps','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(19,'contacts','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(20,'customer','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(21,'cloudapi','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(22,'notification','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(23,'schedule','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(24,'templates','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(25,'message-transactions','web','User Logs','2024-08-12 15:35:08','2024-08-12 15:35:08'),(26,'cron-job','web','SAAS Functionalities','2024-08-12 15:35:08','2024-08-12 15:35:08'),(27,'gateways','web','SAAS Functionalities','2024-08-12 15:35:08','2024-08-12 15:35:08'),(28,'order','web','SAAS Functionalities','2024-08-12 15:35:08','2024-08-12 15:35:08'),(29,'subscriptions','web','SAAS Functionalities','2024-08-12 15:35:08','2024-08-12 15:35:08'),(30,'support','web','SAAS Functionalities','2024-08-12 15:35:08','2024-08-12 15:35:08');
/*!40000 ALTER TABLE `permissions` 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,
`expires_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 `plans`
--
DROP TABLE IF EXISTS `plans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plans` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) DEFAULT NULL,
`labelcolor` varchar(191) DEFAULT NULL,
`iconname` varchar(191) DEFAULT NULL,
`price` double DEFAULT NULL,
`is_featured` int(11) NOT NULL DEFAULT 0,
`is_recommended` int(11) NOT NULL DEFAULT 0,
`is_trial` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL DEFAULT 0,
`days` int(11) NOT NULL DEFAULT 0,
`trial_days` int(11) DEFAULT NULL,
`data` text 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 `plans`
--
LOCK TABLES `plans` WRITE;
/*!40000 ALTER TABLE `plans` DISABLE KEYS */;
INSERT INTO `plans` VALUES (1,'Starter','price-color-1','fas fa-star',10,1,0,0,1,30,0,'{\"messages_limit\":\"1000\",\"contact_limit\":\"100\",\"cloudapi_limit\":\"3\",\"template_limit\":\"20\",\"apps_limit\":\"10\",\"chatbot\":\"true\",\"bulk_message\":\"false\",\"schedule_message\":\"false\",\"access_chat_list\":\"false\"}','2023-03-05 18:29:25','2023-03-05 18:31:25'),(2,'Enterprise','price-color-2','far fa-check-circle',50,1,1,1,1,30,10,'{\"messages_limit\":\"-1\",\"contact_limit\":\"-1\",\"cloudapi_limit\":\"-1\",\"template_limit\":\"-1\",\"apps_limit\":\"-1\",\"chatbot\":\"true\",\"bulk_message\":\"true\",\"schedule_message\":\"true\",\"access_chat_list\":\"true\"}','2023-03-05 18:30:39','2023-03-05 18:33:59'),(3,'Basic','price-color-3','fab fa-angellist',20,1,0,0,1,30,0,'{\"messages_limit\":\"-1\",\"contact_limit\":\"100\",\"cloudapi_limit\":\"100\",\"template_limit\":\"100\",\"apps_limit\":\"10\",\"chatbot\":\"false\",\"bulk_message\":\"false\",\"schedule_message\":\"true\",\"access_chat_list\":\"true\"}','2023-03-05 18:32:49','2023-03-05 18:32:49');
/*!40000 ALTER TABLE `plans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `postcategories`
--
DROP TABLE IF EXISTS `postcategories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `postcategories` (
`post_id` bigint(20) unsigned NOT NULL,
`category_id` bigint(20) unsigned NOT NULL,
KEY `postcategories_post_id_foreign` (`post_id`),
KEY `postcategories_category_id_foreign` (`category_id`),
CONSTRAINT `postcategories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
CONSTRAINT `postcategories_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `postcategories`
--
LOCK TABLES `postcategories` WRITE;
/*!40000 ALTER TABLE `postcategories` DISABLE KEYS */;
/*!40000 ALTER TABLE `postcategories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `postmetas`
--
DROP TABLE IF EXISTS `postmetas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `postmetas` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL,
`key` varchar(191) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
KEY `postmetas_post_id_foreign` (`post_id`),
CONSTRAINT `postmetas_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `postmetas`
--
LOCK TABLES `postmetas` WRITE;
/*!40000 ALTER TABLE `postmetas` DISABLE KEYS */;
/*!40000 ALTER TABLE `postmetas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `posts`
--
DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) NOT NULL,
`slug` varchar(191) DEFAULT NULL,
`type` varchar(191) NOT NULL DEFAULT 'blog',
`status` int(11) NOT NULL DEFAULT 1,
`featured` int(11) NOT NULL DEFAULT 1,
`lang` varchar(191) NOT NULL DEFAULT 'en',
`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 `posts`
--
LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products`
--
DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inventory_id` bigint(20) unsigned NOT NULL,
`name` varchar(191) NOT NULL,
`price` decimal(8,2) NOT NULL,
`quantity` int(11) NOT NULL DEFAULT 0,
`status` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `products_inventory_id_index` (`inventory_id`),
CONSTRAINT `products_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventory` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `products`
--
LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `replies`
--
DROP TABLE IF EXISTS `replies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `replies` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`cloudapi_id` bigint(20) unsigned NOT NULL,
`template_id` bigint(20) unsigned DEFAULT NULL,
`keyword` varchar(191) DEFAULT NULL,
`reply` text DEFAULT NULL,
`match_type` varchar(191) NOT NULL DEFAULT 'equal',
`reply_type` varchar(191) NOT NULL DEFAULT 'text',
`parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`parameters`)),
`api_key` varchar(191) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `replies_user_id_foreign` (`user_id`),
KEY `replies_cloudapi_id_foreign` (`cloudapi_id`),
KEY `replies_template_id_foreign` (`template_id`),
CONSTRAINT `replies_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE CASCADE,
CONSTRAINT `replies_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE SET NULL,
CONSTRAINT `replies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `replies`
--
LOCK TABLES `replies` WRITE;
/*!40000 ALTER TABLE `replies` DISABLE KEYS */;
/*!40000 ALTER TABLE `replies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role_has_permissions`
--
DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_has_permissions` (
`permission_id` bigint(20) unsigned NOT NULL,
`role_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`role_id`),
KEY `role_has_permissions_role_id_foreign` (`role_id`),
CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role_has_permissions`
--
LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1);
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`guard_name` varchar(191) NOT 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 `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'superadmin','web','2024-08-12 15:35:08','2024-08-12 15:35:08');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `schedulecontacts`
--
DROP TABLE IF EXISTS `schedulecontacts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schedulecontacts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`contact_id` bigint(20) unsigned DEFAULT NULL,
`schedulemessage_id` bigint(20) unsigned DEFAULT NULL,
`status_code` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `schedulecontacts_contact_id_foreign` (`contact_id`),
KEY `schedulecontacts_schedulemessage_id_foreign` (`schedulemessage_id`),
CONSTRAINT `schedulecontacts_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
CONSTRAINT `schedulecontacts_schedulemessage_id_foreign` FOREIGN KEY (`schedulemessage_id`) REFERENCES `schedulemessages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `schedulecontacts`
--
LOCK TABLES `schedulecontacts` WRITE;
/*!40000 ALTER TABLE `schedulecontacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `schedulecontacts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `schedulemessages`
--
DROP TABLE IF EXISTS `schedulemessages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schedulemessages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`cloudapi_id` bigint(20) unsigned DEFAULT NULL,
`template_id` bigint(20) unsigned DEFAULT NULL,
`title` varchar(191) DEFAULT NULL,
`body` text DEFAULT NULL,
`schedule_at` datetime DEFAULT NULL,
`zone` varchar(191) DEFAULT NULL,
`date` date DEFAULT NULL,
`time` date DEFAULT NULL,
`status` varchar(191) NOT NULL DEFAULT 'pending',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `schedulemessages_user_id_foreign` (`user_id`),
KEY `schedulemessages_cloudapi_id_foreign` (`cloudapi_id`),
KEY `schedulemessages_template_id_foreign` (`template_id`),
CONSTRAINT `schedulemessages_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE SET NULL,
CONSTRAINT `schedulemessages_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE SET NULL,
CONSTRAINT `schedulemessages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `schedulemessages`
--
LOCK TABLES `schedulemessages` WRITE;
/*!40000 ALTER TABLE `schedulemessages` DISABLE KEYS */;
/*!40000 ALTER TABLE `schedulemessages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smstesttransactions`
--
DROP TABLE IF EXISTS `smstesttransactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smstesttransactions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`app_id` bigint(20) unsigned DEFAULT NULL,
`cloudapi_id` bigint(20) unsigned DEFAULT NULL,
`phone` varchar(191) DEFAULT NULL,
`body` text DEFAULT NULL,
`charge` double DEFAULT NULL,
`messaging_id` varchar(191) DEFAULT NULL,
`status_code` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `smstesttransactions_user_id_foreign` (`user_id`),
KEY `smstesttransactions_app_id_foreign` (`app_id`),
KEY `smstesttransactions_cloudapi_id_foreign` (`cloudapi_id`),
CONSTRAINT `smstesttransactions_app_id_foreign` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`) ON DELETE SET NULL,
CONSTRAINT `smstesttransactions_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE SET NULL,
CONSTRAINT `smstesttransactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `smstesttransactions`
--
LOCK TABLES `smstesttransactions` WRITE;
/*!40000 ALTER TABLE `smstesttransactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `smstesttransactions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smstransactions`
--
DROP TABLE IF EXISTS `smstransactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smstransactions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`cloudapi_id` bigint(20) unsigned DEFAULT NULL,
`app_id` bigint(20) unsigned DEFAULT NULL,
`template_id` bigint(20) unsigned DEFAULT NULL,
`from` varchar(191) DEFAULT NULL,
`to` varchar(191) DEFAULT NULL,
`type` varchar(191) DEFAULT 'from_api',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `smstransactions_user_id_foreign` (`user_id`),
KEY `smstransactions_cloudapi_id_foreign` (`cloudapi_id`),
KEY `smstransactions_app_id_foreign` (`app_id`),
KEY `smstransactions_template_id_foreign` (`template_id`),
CONSTRAINT `smstransactions_app_id_foreign` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`) ON DELETE SET NULL,
CONSTRAINT `smstransactions_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE SET NULL,
CONSTRAINT `smstransactions_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE SET NULL,
CONSTRAINT `smstransactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `smstransactions`
--
LOCK TABLES `smstransactions` WRITE;
/*!40000 ALTER TABLE `smstransactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `smstransactions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `supportlogs`
--
DROP TABLE IF EXISTS `supportlogs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `supportlogs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`is_admin` int(11) NOT NULL DEFAULT 0,
`seen` int(11) NOT NULL DEFAULT 0,
`comment` text NOT NULL,
`support_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `supportlogs_support_id_foreign` (`support_id`),
KEY `supportlogs_user_id_foreign` (`user_id`),
CONSTRAINT `supportlogs_support_id_foreign` FOREIGN KEY (`support_id`) REFERENCES `supports` (`id`) ON DELETE CASCADE,
CONSTRAINT `supportlogs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `supportlogs`
--
LOCK TABLES `supportlogs` WRITE;
/*!40000 ALTER TABLE `supportlogs` DISABLE KEYS */;
/*!40000 ALTER TABLE `supportlogs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `supports`
--
DROP TABLE IF EXISTS `supports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `supports` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ticket_no` int(11) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`subject` varchar(191) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 2,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `supports_user_id_foreign` (`user_id`),
CONSTRAINT `supports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `supports`
--
LOCK TABLES `supports` WRITE;
/*!40000 ALTER TABLE `supports` DISABLE KEYS */;
/*!40000 ALTER TABLE `supports` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `templates`
--
DROP TABLE IF EXISTS `templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `templates` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`uuid` char(36) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`cloudapi_id` bigint(20) unsigned DEFAULT NULL,
`title` varchar(191) DEFAULT NULL,
`body` text DEFAULT NULL,
`type` varchar(191) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`test_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `templates_uuid_unique` (`uuid`),
KEY `templates_user_id_foreign` (`user_id`),
KEY `templates_cloudapi_id_foreign` (`cloudapi_id`),
CONSTRAINT `templates_cloudapi_id_foreign` FOREIGN KEY (`cloudapi_id`) REFERENCES `cloudapis` (`id`) ON DELETE CASCADE,
CONSTRAINT `templates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `templates`
--
LOCK TABLES `templates` WRITE;
/*!40000 ALTER TABLE `templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `templates` 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,
`avatar` varchar(191) DEFAULT NULL,
`authkey` varchar(191) DEFAULT NULL,
`wallet` varchar(191) DEFAULT NULL,
`role` varchar(191) NOT NULL DEFAULT 'user',
`email` varchar(191) NOT NULL,
`phone` varchar(191) DEFAULT NULL,
`address` varchar(191) DEFAULT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(191) NOT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`meta` text DEFAULT NULL,
`plan` text DEFAULT NULL,
`plan_id` int(11) DEFAULT NULL,
`will_expire` date 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,'Admin','uploads/avatar.png',NULL,NULL,'admin','admin@gmail.com',NULL,NULL,NULL,'$2y$10$kGCDSq/41sTxrAjA3gTBI.XOVh3OQist6lpc8K/jjHb/R07giArV6',1,NULL,NULL,NULL,NULL,NULL,'2024-08-12 15:35:08','2024-08-12 15:35:08');
/*!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 2025-04-17 15:25:38