-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Aug 21, 2025 at 06:06 AM
-- Server version: 9.3.0
-- PHP Version: 8.3.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `gateway_v1_6`
--

-- --------------------------------------------------------

--
-- Table structure for table `authorization_tokens`
--

CREATE TABLE `authorization_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `access_token` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `refresh_token` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `billing_requests`
--

CREATE TABLE `billing_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `plan_id` int UNSIGNED NOT NULL,
  `transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_info` text COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','accepted','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `campaigns`
--

CREATE TABLE `campaigns` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `device_ids` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_devices` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `to_number` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` timestamp NOT NULL,
  `end_date` timestamp NOT NULL,
  `start_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_id` int DEFAULT NULL,
  `message_body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('importing','running','paused','completed','failed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'importing',
  `import_fail_message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message_send_rate` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sim_info` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'x:y:z => x=SimSlotIndex, y=SubscriberId, z=SimDisplayName'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `chat_responses`
--

CREATE TABLE `chat_responses` (
  `id` int UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `contact_dial_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `email_notification` enum('1','') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label_id` int UNSIGNED NOT NULL,
  `unique_random_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `block_contact` enum('block','unblock') COLLATE utf8mb4_unicode_ci DEFAULT 'unblock'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contact_groups`
--

CREATE TABLE `contact_groups` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `contact_id` int UNSIGNED NOT NULL,
  `group_id` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_picture` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default_profile.png',
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `type` enum('customer','staff') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'customer',
  `owner_id` int DEFAULT NULL,
  `role_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_contacts`
--

CREATE TABLE `customer_contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscribe` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `message` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_numbers`
--

CREATE TABLE `customer_numbers` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `number_id` int UNSIGNED NOT NULL,
  `number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `forward_to_dial_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forward_to` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost` double NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expire_date` timestamp NOT NULL,
  `webhook_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `webhook_method` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_plans`
--

CREATE TABLE `customer_plans` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `plan_id` int UNSIGNED NOT NULL,
  `price` double NOT NULL DEFAULT '0',
  `contact_limit` int UNSIGNED NOT NULL DEFAULT '0',
  `daily_send_limit` int UNSIGNED NOT NULL DEFAULT '0',
  `daily_receive_limit` int UNSIGNED NOT NULL DEFAULT '0',
  `device_limit` int UNSIGNED NOT NULL DEFAULT '0',
  `is_current` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `payment_status` enum('paid','unpaid') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid',
  `status` enum('pending','accepted','rejected','hold') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `sms_limit` int UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `renew_date` timestamp NULL DEFAULT NULL,
  `recurring_type` enum('onetime','weekly','monthly','yearly') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'onetime',
  `expiry_notified` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `wa_device_limit` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_settings`
--

CREATE TABLE `customer_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `device_unique_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `android_version` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_version` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','remove','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sim_info` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'x:y:z => x=SimSlotIndex, y=SubscriberId, z=SimDisplayName',
  `device_type` enum('whatsapp','device') COLLATE utf8mb4_unicode_ci DEFAULT 'device'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `device_groups`
--

CREATE TABLE `device_groups` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `device_group_names`
--

CREATE TABLE `device_group_names` (
  `id` bigint UNSIGNED NOT NULL,
  `group_id` int NOT NULL,
  `device_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `drafts`
--

CREATE TABLE `drafts` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `numbers` longtext COLLATE utf8mb4_unicode_ci COMMENT 'array of contact numbers',
  `body` text COLLATE utf8mb4_unicode_ci,
  `schedule_datetime` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `exceptions`
--

CREATE TABLE `exceptions` (
  `id` int UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `number` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int UNSIGNED NOT NULL,
  `cost` double NOT NULL DEFAULT '0',
  `customer_id` int UNSIGNED NOT NULL,
  `type` enum('sent','receive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_log_id` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `f_a_q_s`
--

CREATE TABLE `f_a_q_s` (
  `id` bigint UNSIGNED NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` longtext COLLATE utf8mb4_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `import_status` enum('running','completed','failed') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `import_fail_message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
  `id` int UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ltm_translations`
--

CREATE TABLE `ltm_translations` (
  `id` bigint UNSIGNED NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `locale` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `group` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `key` text COLLATE utf8mb4_bin NOT NULL,
  `value` text COLLATE utf8mb4_bin,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `campaign_id` int UNSIGNED DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `numbers` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'array of contact numbers',
  `schedule_datetime` datetime DEFAULT NULL,
  `type` enum('sent','inbox','response') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `schedule_completed` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `message_obj` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'response after sending sms using API',
  `message_files` text COLLATE utf8mb4_unicode_ci COMMENT 'MMS files',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `message_logs`
--

CREATE TABLE `message_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `queue_id` int UNSIGNED DEFAULT NULL,
  `campaign_id` int UNSIGNED DEFAULT NULL,
  `message_id` int UNSIGNED NOT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'devices table id',
  `device_unique_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `to` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('sent','inbox','response') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','succeed','failed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `message_obj` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'response after sending sms using API',
  `message_files` text COLLATE utf8mb4_unicode_ci COMMENT 'MMS files',
  `response_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `response_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `sim_info` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'x:y:z => x=SimSlotIndex, y=SubscriberId, z=SimDisplayName',
  `send_type` enum('device','whatsapp') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'device'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_04_02_193005_create_translations_table', 1),
(2, '2014_10_12_000000_create_users_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2020_05_09_071403_create_customers_table', 1),
(6, '2020_05_11_060756_create_customer_numbers_table', 1),
(7, '2020_05_11_065506_create_numbers_table', 1),
(8, '2020_05_12_060602_create_plans_table', 1),
(9, '2020_05_12_060814_create_customer_plans_table', 1),
(10, '2020_05_13_104650_create_messages_table', 1),
(11, '2020_05_15_054719_create_drafts_table', 1),
(12, '2020_05_19_064929_create_billing_requests_table', 1),
(13, '2020_05_19_131808_create_customer_settings_table', 1),
(14, '2020_05_20_134223_create_number_requests_table', 1),
(15, '2020_05_28_112247_create_password_reset_table', 1),
(16, '2020_05_30_063350_create_settings_table', 1),
(17, '2020_06_27_140751_create_pages_table', 1),
(18, '2020_07_01_055442_create_contacts_table', 1),
(19, '2020_09_09_052310_create_groups_table', 1),
(20, '2020_09_09_052756_create_contact_groups_table', 1),
(21, '2020_09_13_075554_create_verify_customers_table', 1),
(22, '2021_08_03_140411_create_sms_queues_table', 1),
(23, '2021_08_29_075409_create_jobs_table', 1),
(24, '2021_09_13_074340_contact_email_notification', 1),
(25, '2021_09_27_123326_add_customer_number_table', 1),
(26, '2021_10_14_053316_create_campaigns_table', 1),
(27, '2021_10_20_074529_create_sms_templates_table', 1),
(28, '2021_10_31_082705_change_group_table', 1),
(29, '2021_11_16_175106_create_email_templates_table', 1),
(30, '2021_11_20_133503_create_f_a_q_s_table', 1),
(31, '2021_11_20_160902_create_tickets_table', 1),
(32, '2021_11_20_161036_create_ticket_descriptions_table', 1),
(33, '2021_11_28_144020_create_subscribes_table', 1),
(34, '2021_12_05_165847_create_message_logs_table', 1),
(35, '2021_12_12_112806_create_chat_responses_table', 1),
(36, '2022_01_03_073943_webhook_in_customer_table', 1),
(37, '2022_01_05_051314_create_exceptions_table', 1),
(38, '2022_01_05_142349_create_expenses_table', 1),
(39, '2022_01_17_062740_create_labels_table', 1),
(40, '2022_01_17_071220_add_label_id_in_contacts_table', 1),
(41, '2022_01_23_062650_add_color_in_labels_table', 1),
(42, '2022_02_05_061613_add_content_in_chat_responses', 1),
(43, '2022_03_01_024416_create_devices_table', 1),
(44, '2022_03_03_061238_create_responders_table', 1),
(45, '2022_03_03_071715_create_ussds_table', 1),
(46, '2022_03_06_050307_add_response_status_in_message', 1),
(47, '2022_03_10_074949_create_authorization_tokens_table', 1),
(48, '2022_04_18_045319_create_device_groups_table', 1),
(49, '2022_04_18_045701_create_device_group_names_table', 1),
(50, '2022_06_11_060404_modify_plans_table', 1),
(51, '2022_06_11_062245_modify_customer_plans_table', 1),
(52, '2022_06_21_064046_create_customer_contacts_table', 1),
(53, '2022_09_01_133342_add_sim_info_sub_id_column_to_devices_table', 1),
(54, '2023_05_11_130012_add_type_in_customers', 1),
(55, '2024_01_27_160338_create_permission_tables', 1),
(56, '2024_01_27_160852_add_unique_random_contacts_table', 1),
(57, '2024_01_27_210421_after_role_table', 1),
(58, '2024_05_04_165257_add_column_devices_table', 1),
(59, '2024_05_06_135636_add_block_contacts_table', 1),
(60, '2024_05_14_132231_add_wa_device_limit_in_plans', 1);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `numbers`
--

CREATE TABLE `numbers` (
  `id` bigint UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL COMMENT 'Who purchased the number',
  `number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `obj` text COLLATE utf8mb4_unicode_ci COMMENT 'this is the response after purchase',
  `purch_price` double NOT NULL DEFAULT '0' COMMENT 'Purchased price from number provider',
  `sell_price` double NOT NULL DEFAULT '0' COMMENT 'Selling price to the customer',
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `number_requests`
--

CREATE TABLE `number_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `number_id` int UNSIGNED NOT NULL,
  `status` enum('pending','accepted','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'This will be added in <head\\> tag',
  `status` enum('published','unpublished') COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` enum('header','footer') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `admin_id`, `url`, `name`, `title`, `description`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 1, 'privacy-policy', 'Privacy & Policy', 'Privacy & Policy', '\n                Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque vel velit euismod, fermentum arcu in, convallis nisl. Morbi ac bibendum leo. Sed varius eros et sapien dictum, nec aliquam felis efficitur. Ut nec nisi at urna varius tempus. Phasellus id tortor vitae dui malesuada fermentum et in ligula. Nullam imperdiet massa ac leo dictum, nec vestibulum libero tincidunt. Vestibulum id diam ac augue vestibulum auctor. Proin nec erat sed nulla fermentum laoreet ac sit amet odio. Mauris vitae malesuada orci. Nulla facilisi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque vel velit euismod, fermentum arcu in, convallis nisl. Morbi ac bibendum leo. Sed varius eros et sapien dictum, nec aliquam felis efficitur. Ut nec nisi at urna varius tempus. Phasellus id tortor vitae dui malesuada fermentum et in ligula. Nullam imperdiet massa ac leo dictum, nec vestibulum libero tincidunt. Vestibulum id diam ac augue vestibulum auctor. Proin nec erat sed nulla fermentum laoreet ac sit amet odio. Mauris vitae malesuada orci. Nulla facilisi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque vel velit euismod, fermentum arcu in, convallis nisl. Morbi ac bibendum leo. Sed varius eros et sapien dictum, nec aliquam felis efficitur. Ut nec nisi at urna varius tempus. Phasellus id tortor vitae dui malesuada fermentum et in ligula. Nullam imperdiet massa ac leo dictum, nec vestibulum libero tincidunt. Vestibulum id diam ac augue vestibulum auctor. Proin nec erat sed nulla fermentum laoreet ac sit amet odio. Mauris vitae malesuada orci. Nulla facilisi.\n            ', 'published', 'footer', '2025-08-21 06:06:05', '2025-08-21 06:06:05'),
(2, 1, 'terms-conditions', 'Terms & Conditions', 'Terms & Conditions', '\n                Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque vel velit euismod, fermentum arcu in, convallis nisl. Morbi ac bibendum leo. Sed varius eros et sapien dictum, nec aliquam felis efficitur. Ut nec nisi at urna varius tempus. Phasellus id tortor vitae dui malesuada fermentum et in ligula. Nullam imperdiet massa ac leo dictum, nec vestibulum libero tincidunt. Vestibulum id diam ac augue vestibulum auctor. Proin nec erat sed nulla fermentum laoreet ac sit amet odio. Mauris vitae malesuada orci. Nulla facilisi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque vel velit euismod, fermentum arcu in, convallis nisl. Morbi ac bibendum leo. Sed varius eros et sapien dictum, nec aliquam felis efficitur. Ut nec nisi at urna varius tempus. Phasellus id tortor vitae dui malesuada fermentum et in ligula. Nullam imperdiet massa ac leo dictum, nec vestibulum libero tincidunt. Vestibulum id diam ac augue vestibulum auctor. Proin nec erat sed nulla fermentum laoreet ac sit amet odio. Mauris vitae malesuada orci. Nulla facilisi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque vel velit euismod, fermentum arcu in, convallis nisl. Morbi ac bibendum leo. Sed varius eros et sapien dictum, nec aliquam felis efficitur. Ut nec nisi at urna varius tempus. Phasellus id tortor vitae dui malesuada fermentum et in ligula. Nullam imperdiet massa ac leo dictum, nec vestibulum libero tincidunt. Vestibulum id diam ac augue vestibulum auctor. Proin nec erat sed nulla fermentum laoreet ac sit amet odio. Mauris vitae malesuada orci. Nulla facilisi.\n            ', 'published', 'footer', '2025-08-21 06:06:05', '2025-08-21 06:06:05');

-- --------------------------------------------------------

--
-- Table structure for table `password_reset`
--

CREATE TABLE `password_reset` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL COMMENT 'users table or customers table',
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'manage_dashboard', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(2, 'manage_compose', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(3, 'manage_campaign', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(4, 'manage_contacts', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(5, 'manage_chatbox', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(6, 'manage_billing', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(7, 'manage_developer', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(8, 'manage_ticket', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(9, 'manage_settings', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(10, 'device_list', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(11, 'device_add', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04'),
(12, 'device_edit', 'web', '2025-08-21 06:06:05', '2025-08-21 06:06:05'),
(13, 'device_delete', 'web', '2025-08-21 06:06:05', '2025-08-21 06:06:05');

-- --------------------------------------------------------

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double NOT NULL,
  `contact_limit` int UNSIGNED NOT NULL,
  `daily_send_limit` int UNSIGNED NOT NULL,
  `daily_receive_limit` int UNSIGNED NOT NULL,
  `device_limit` int UNSIGNED NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `sms_limit` int UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `recurring_type` enum('onetime','weekly','monthly','yearly') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'onetime',
  `wa_device_limit` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` (`id`, `admin_id`, `title`, `price`, `contact_limit`, `daily_send_limit`, `daily_receive_limit`, `device_limit`, `status`, `sms_limit`, `created_at`, `updated_at`, `recurring_type`, `wa_device_limit`) VALUES
(1, 1, 'Trial', 0, 10, 10, 10, 1, 'active', 10, '2025-08-21 06:06:04', '2025-08-21 06:06:04', 'onetime', 0),
(2, 1, 'Basic', 19, 10000, 1000, 500, 10, 'active', 0, '2025-08-21 06:06:04', '2025-08-21 06:06:04', 'yearly', 0),
(3, 1, 'Gold', 29, 5000, 3000, 2000, 20, 'active', 0, '2025-08-21 06:06:04', '2025-08-21 06:06:04', 'yearly', 0),
(4, 1, 'Premium', 49, 10000, 10000, 5000, 50, 'active', 0, '2025-08-21 06:06:04', '2025-08-21 06:06:04', 'yearly', 0);

-- --------------------------------------------------------

--
-- Table structure for table `responders`
--

CREATE TABLE `responders` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `word` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `respond_type` enum('case_insensitive','case_sensitive','regular_expression','contains_message') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`, `customer_id`) VALUES
(1, 'main_customer', 'web', '2025-08-21 06:06:04', '2025-08-21 06:06:04', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) 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);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `admin_id`, `name`, `value`, `created_at`, `updated_at`) VALUES
(1, 1, 'template', '{\"email\":\"contact@picotech.com.bd\",\"phone_number\":\"+8801784396266\",\"address\":\"Modhure More, Nimbagan Road, Kurigram Sadar, Kurigram\",\"title\":\"PicoMSG - Android Phone As SMS Gateway\",\"description\":\"PicoMSG is very simple & easy to use. It\\u2019s a full-featured bulk SMS marketing tool using your android phone.\",\"first_title\":\"SaaS Business Tool\",\"first_description\":\"Just download, install and start SaaS business within few minutes\",\"sec_title\":\"Complete Solution\",\"sec_description\":\"Complete solution, never have to pay monthly charges or any cost.\",\"thr_title\":\"No Gateway Required\",\"thr_description\":\"No need to configure\\/pay to third-party SMS gateway provider.\",\"sec_thr_title\":\"About\",\"sec_thr_description\":\"PicoMSG is very simple & easy to use. It\\u2019s a full-featured bulk SMS marketing tool using your android phone. You don\\u2019t have to pay monthly fees, just download and install it on your hosting. You can use PicoMSG for personal and also for business purposes. You do not have to integrate any third-party SMS gateway to send bulk SMS using PicoMSG which will reduce a huge cost for your marketing. Just use your Android phone as an SMS gateway and send bulk sms using your own mobile number.\",\"main_title\":\"Lorem ipsum dolor sit amet\",\"sec_four_title\":[\"Lorem ipsum dolor sit amet\",\"Lorem ipsum dolor sit amet\"],\"sec_four_description\":[\"Lorem ipsum dolor sit amet\",\"Lorem ipsum dolor sit amet\"],\"sec_six_title\":\"Choose Your Best Plan\",\"sec_seven_title\":\"Features\",\"sec_seven_description\":\"PicoMSG is very simple & easy to use. It\\u2019s a full-featured bulk SMS marketing tool using your android phone. You don\\u2019t have to pay monthly fees, just download and install it on your hosting. You can use PicoMSG for personal and also for business purposes. You do not have to integrate any third-party SMS gateway to send bulk SMS using PicoMSG which will reduce a huge cost for your marketing. Just use your Android phone as an SMS gateway and send bulk sms using your own mobile number.\",\"bg_image_file_name\":\"1737466415_1.svg\",\"first_img_file_name\":\"1737466749_2.png\",\"sec_img_file_name\":\"1737466749_3.png\",\"thr_img_file_name\":\"1737466749_4.png\",\"sec_thr_bg_image_file\":\"1737466561_5.svg\",\"sec_seven_bg_image_file\":\"1737466646_6.svg\",\"section_marketing_tool_sub_title\":\"Key Business Features\",\"section_marketing_tool_main_title\":\"Best SMS Marketing Tool\",\"first_commenter_img\":\"1737466884_7.jpg\",\"sec_commenter_img\":\"1737467002_8.webp\",\"first_commenter_name\":\"Deviga Sperin\",\"first_commenter_comment\":\"Very top system, clean code!! It works 100%, I recommend it to everyone, and the support is wonderful, always willing to solve your problem! Thank you very much for this wonderful system\",\"sec_commenter_name\":\"Quality Webscript For Affordable price, Author is super friendly and help to fix bugs asap. Better than the competitors in the market. 1000% Recommended for your need\",\"sec_commenter_comment\":\"Quality Webscript For Affordable price, Author is super friendly and help to fix bugs asap. Better than the competitors in the market. 1000% Recommended for your need\",\"first_brand_title\":\"Download\",\"first_brand_description\":\"Just download the code within few minutes.\",\"sec_brand_title\":\"Install\",\"sec_brand_description\":\"Install the code in your shared hosting or VPS\",\"thr_brand_title\":\"Start Business\",\"thr_brand_description\":\"Configure all settings and start your business\",\"first_brand_img\":\"1737466510_9.png\",\"sec_brand_img\":\"1737466510_10.png\",\"thr_brand_img\":\"1737466510_11.png\"}', '2025-08-21 06:06:05', '2025-08-21 06:06:05'),
(2, 1, 'app_logo', '1737467324.png', '2025-08-21 06:06:05', '2025-08-21 06:06:05'),
(3, 1, 'app_name', 'PicoMSG', '2025-08-21 06:06:05', '2025-08-21 06:06:05'),
(4, 1, 'app_favicon', '1737469607.png', '2025-08-21 06:06:05', '2025-08-21 06:06:05');

-- --------------------------------------------------------

--
-- Table structure for table `sms_queues`
--

CREATE TABLE `sms_queues` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `message_id` int UNSIGNED NOT NULL,
  `campaign_id` int UNSIGNED DEFAULT NULL,
  `device_unique_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'devices table id',
  `to` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `schedule_datetime` datetime DEFAULT NULL,
  `delivered_at` timestamp NULL DEFAULT NULL,
  `schedule_completed` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `message_files` text COLLATE utf8mb4_unicode_ci COMMENT 'MMS files in json encoded',
  `status` enum('running','fetched','paused','failed','delivered') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'running',
  `response_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `response_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `subscriber_id` int NOT NULL COMMENT 'SubscriberId is the sim id from the device',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `send_type` enum('device','whatsapp') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'device'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sms_templates`
--

CREATE TABLE `sms_templates` (
  `id` int UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `subscribes`
--

CREATE TABLE `subscribes` (
  `id` bigint UNSIGNED NOT NULL,
  `subscribe_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscribe_email_verified_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `admin_id` int UNSIGNED NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document` longtext COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','open','processing','solved') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ticket_descriptions`
--

CREATE TABLE `ticket_descriptions` (
  `id` int UNSIGNED NOT NULL,
  `ticket_id` int UNSIGNED NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `sender` int DEFAULT NULL,
  `document` longtext COLLATE utf8mb4_unicode_ci,
  `receiver` int DEFAULT NULL,
  `sent_status` enum('admin','customer') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_picture` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default_profile.png',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `profile_picture`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', 'admin@demo.com', NULL, '$2y$10$sK4lugNJvmwPHJcAnJ3g1OxRFZ58SR2qoVMzk9zz2R1DgLzRHtBvu', NULL, 'default_profile.png', '2025-08-21 06:06:04', '2025-08-21 06:06:04', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `ussds`
--

CREATE TABLE `ussds` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `request` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `response` text COLLATE utf8mb4_unicode_ci,
  `device_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_unique_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscriber_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','fetched','failed','completed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `verify_customers`
--

CREATE TABLE `verify_customers` (
  `id` bigint UNSIGNED NOT NULL,
  `customer_id` int UNSIGNED NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','verified') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `authorization_tokens`
--
ALTER TABLE `authorization_tokens`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `billing_requests`
--
ALTER TABLE `billing_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `campaigns`
--
ALTER TABLE `campaigns`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `chat_responses`
--
ALTER TABLE `chat_responses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_groups`
--
ALTER TABLE `contact_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customers_email_unique` (`email`);

--
-- Indexes for table `customer_contacts`
--
ALTER TABLE `customer_contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_numbers`
--
ALTER TABLE `customer_numbers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_plans`
--
ALTER TABLE `customer_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_settings`
--
ALTER TABLE `customer_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `devices`
--
ALTER TABLE `devices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `devices_device_unique_id_unique` (`device_unique_id`);

--
-- Indexes for table `device_groups`
--
ALTER TABLE `device_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `device_group_names`
--
ALTER TABLE `device_group_names`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `drafts`
--
ALTER TABLE `drafts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exceptions`
--
ALTER TABLE `exceptions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `labels`
--
ALTER TABLE `labels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ltm_translations`
--
ALTER TABLE `ltm_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `message_logs`
--
ALTER TABLE `message_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `numbers`
--
ALTER TABLE `numbers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `number_requests`
--
ALTER TABLE `number_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_reset`
--
ALTER TABLE `password_reset`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `responders`
--
ALTER TABLE `responders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `responders_word_unique` (`word`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sms_queues`
--
ALTER TABLE `sms_queues`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sms_templates`
--
ALTER TABLE `sms_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscribes`
--
ALTER TABLE `subscribes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscribes_subscribe_email_unique` (`subscribe_email`);

--
-- Indexes for table `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ticket_descriptions`
--
ALTER TABLE `ticket_descriptions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `ussds`
--
ALTER TABLE `ussds`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `verify_customers`
--
ALTER TABLE `verify_customers`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `authorization_tokens`
--
ALTER TABLE `authorization_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `billing_requests`
--
ALTER TABLE `billing_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `campaigns`
--
ALTER TABLE `campaigns`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat_responses`
--
ALTER TABLE `chat_responses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contact_groups`
--
ALTER TABLE `contact_groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_contacts`
--
ALTER TABLE `customer_contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_numbers`
--
ALTER TABLE `customer_numbers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_plans`
--
ALTER TABLE `customer_plans`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_settings`
--
ALTER TABLE `customer_settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `devices`
--
ALTER TABLE `devices`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `device_groups`
--
ALTER TABLE `device_groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `device_group_names`
--
ALTER TABLE `device_group_names`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drafts`
--
ALTER TABLE `drafts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exceptions`
--
ALTER TABLE `exceptions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `labels`
--
ALTER TABLE `labels`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ltm_translations`
--
ALTER TABLE `ltm_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `message_logs`
--
ALTER TABLE `message_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `numbers`
--
ALTER TABLE `numbers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `number_requests`
--
ALTER TABLE `number_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `password_reset`
--
ALTER TABLE `password_reset`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `responders`
--
ALTER TABLE `responders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sms_queues`
--
ALTER TABLE `sms_queues`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sms_templates`
--
ALTER TABLE `sms_templates`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscribes`
--
ALTER TABLE `subscribes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ticket_descriptions`
--
ALTER TABLE `ticket_descriptions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ussds`
--
ALTER TABLE `ussds`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `verify_customers`
--
ALTER TABLE `verify_customers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

/*!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 */;
