-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `callnroam`
--

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

--
-- Table structure for table `addoncharge`
--

CREATE TABLE `addoncharge` (
  `id` int NOT NULL,
  `add_on_type` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `product` varchar(255) DEFAULT NULL,
  `charge` varchar(255) DEFAULT NULL,
  `charge_type` varchar(255) DEFAULT NULL,
  `charge_rate` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `addoncharge`
--

INSERT INTO `addoncharge` (`id`, `add_on_type`, `title`, `description`, `product`, `charge`, `charge_type`, `charge_rate`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'processing fee', 'Service Charge', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 'lorem ipsum', 'lorem ipsum', 'Fixed', '0.99', 'active', '2021-10-18 19:17:32', '2022-01-05 07:57:12', NULL),
(2, 'processing fee', 'Service Charge', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 'lorem ipsum', 'lorem ipsum', 'Fixed', '1.99', 'active', '2021-10-18 19:17:32', '2022-01-05 07:57:17', NULL),
(3, 'processing fee', 'Manual Recharge Convenience Fee', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 'lorem ipsum', 'lorem ipsum', 'Fixed', '0.99', 'inactive', '2021-10-18 19:17:32', '2022-01-05 07:57:22', NULL),
(4, 'did rental', 'Processing Fee', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 'lorem ipsum', 'lorem ipsum', 'Fixed', '0.5', 'active', '2021-10-18 19:17:32', '2022-01-05 07:57:27', NULL),
(5, '3', 'Access number Charge', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 'lorem ipsum', 'lorem ipsum', 'Fixed', '0.5', 'active', '2021-10-18 19:17:32', '2022-01-05 05:21:05', '2022-01-05 05:21:05'),
(6, 'processing fee', 'lorem', 'offers\r\noffersoffersoffersoffersoffersoffers', 'lorem', '500', 'loprem', '20', 'inactive', '2022-01-05 07:54:46', '2022-01-05 07:57:02', NULL);

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

--
-- Table structure for table `addontype`
--

CREATE TABLE `addontype` (
  `id` int NOT NULL,
  `addontype` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `addontype`
--

INSERT INTO `addontype` (`id`, `addontype`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Manual Recharge Service Fee', 'active', '2021-10-13 21:07:40', '2022-01-04 04:50:22', NULL),
(2, 'DID Rental', 'inactive', '2021-10-17 13:21:10', '2022-01-03 23:03:39', NULL),
(3, 'Access Number Charge', 'active', '2021-10-17 13:21:17', '2021-10-17 13:21:17', NULL),
(4, 'Processing Fee', 'active', '2021-10-17 13:21:25', '2021-10-17 13:21:25', NULL),
(5, 'Service Charge', 'active', '2021-10-17 13:21:31', '2021-10-19 23:24:25', NULL),
(7, 'demo', 'active', '2021-10-19 23:12:17', '2021-10-19 23:23:35', '2021-10-19 23:23:35'),
(8, 'demo123', 'active', '2021-10-19 23:13:39', '2021-10-19 23:23:31', '2021-10-19 23:23:31'),
(9, 'gfhgf', 'active', '2021-10-19 23:14:06', '2021-10-19 23:23:28', '2021-10-19 23:23:28'),
(10, 'Test', 'active', '2021-10-20 00:34:28', '2021-10-20 01:55:17', NULL),
(11, 'abc', 'inactive', '2022-01-04 08:20:52', '2022-01-05 05:17:44', '2022-01-05 05:17:44');

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

--
-- Table structure for table `cms`
--

CREATE TABLE `cms` (
  `id` int NOT NULL,
  `module_name` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keyword` text,
  `meta_description` text,
  `description` text,
  `meta_tag` varchar(255) DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `cms`
--

INSERT INTO `cms` (`id`, `module_name`, `name`, `meta_title`, `meta_keyword`, `meta_description`, `description`, `meta_tag`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Default', 'Calling Rates', 'Best International Calling Rates | Check Your Rates', 'International Calling Rates', 'Check Our International Calling Rates From Our Wide Country\r\nSelection And Start Saving Money Now With CallnRoam.', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>', 'International Calling Rates', '2021-10-07 16:54:09', '2022-01-05 06:35:32', NULL),
(2, 'Default', 'About Us', 'Best International Calling Rates | Check Your Rates', 'International Calling Rates', 'Check Our International Calling Rates From Our Wide Country\r\nSelection And Start Saving Money Now With CallnRoam.', '<p><strong style=\"color: rgb(0, 0, 0);\">Lorem Ipsum</strong><span style=\"color: rgb(0, 0, 0);\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap in<span class=\"ql-cursor\">﻿﻿﻿﻿﻿﻿</span>to electronic typesetting, remaining essentially unchanged.</span></p><p><span style=\"color: rgb(0, 0, 0);\">It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', 'International Calling Rates', '2021-10-07 16:54:09', '2022-02-10 23:24:20', NULL),
(3, 'Default', 'Terms And Conditions', 'Best International Calling Rates | Check Your Rates', 'International Calling Rates', 'Check Our International Calling Rates From Our Wide Country\r\nSelection And Start Saving Money Now With CallnRoam.', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. </p><p>It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. </p><p>Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p>', 'International Calling Rates', '2021-10-07 16:54:09', '2022-02-11 04:10:03', NULL),
(4, 'Section Title', NULL, 'sub section', NULL, NULL, NULL, NULL, '2022-03-03 05:25:24', '2022-03-03 05:25:24', NULL),
(5, 'Section Title', NULL, 'sub section', NULL, NULL, NULL, NULL, '2022-03-03 05:25:42', '2022-03-03 05:25:42', NULL),
(6, 'Section Title', NULL, 'sub section', NULL, NULL, NULL, NULL, '2022-03-03 05:30:37', '2022-03-03 05:30:37', NULL),
(7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-03-03 05:33:38', '2022-03-03 05:33:38', NULL);

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'india', 'in', 'active', '2022-02-21 00:44:22', '2022-02-21 00:44:22', NULL);

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

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

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

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `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_0900_ai_ci;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `category`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Pinoy Unti-Call Plan', 'active', '2021-10-06 15:58:56', '2022-01-21 05:06:25', NULL),
(2, 'Rates and Billing', 'active', '2021-10-06 15:58:56', '2022-01-03 08:52:38', NULL),
(3, 'International Calling', 'active', '2021-10-06 15:58:56', '2021-10-07 13:08:08', NULL),
(4, 'Easy Roaming', 'active', '2021-10-06 15:58:56', '2021-10-07 13:08:08', NULL),
(5, 'General: About The Service', 'active', '2021-10-06 15:58:56', '2022-01-03 23:02:35', NULL),
(6, 'test', 'inactive', '2022-01-04 06:50:54', '2022-01-04 06:51:07', NULL),
(7, 'abc', 'active', '2022-01-04 07:37:29', '2022-01-04 07:37:29', NULL),
(8, 'eight', 'inactive', '2022-01-04 23:14:17', '2022-01-05 04:59:23', '2022-01-05 04:59:23');

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

--
-- Table structure for table `faqquestionanswer`
--

CREATE TABLE `faqquestionanswer` (
  `id` int NOT NULL,
  `faq_id` int DEFAULT NULL,
  `question` text,
  `answer` text,
  `status` enum('active','inactive') DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `faqquestionanswer`
--

INSERT INTO `faqquestionanswer` (`id`, `faq_id`, `question`, `answer`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 5, '<p>tests</p>', '<p>this is testing</p>', 'active', '2021-10-07 13:10:33', '2022-01-21 05:06:53', NULL),
(2, 1, '<p>How can I order a CallnRoam card?</p>', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum</p>', 'active', '2021-10-07 08:26:36', '2022-01-11 23:30:47', NULL),
(3, 5, '<p>What is Callback facility?</p>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum</p>', 'active', '2021-10-07 13:10:33', '2021-10-13 18:31:25', NULL),
(4, 5, '<p>What services do you offer?</p>', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer too<strong>k a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passag</strong>es, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum</p>', 'active', '2021-10-07 08:26:36', '2022-01-05 07:18:49', NULL),
(5, 5, '<p>What is CallnRoam?</p>', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum</p>', 'active', '2021-10-07 08:26:36', '2022-01-05 04:59:12', '2022-01-05 04:59:12'),
(6, 2, '<p><strong style=\"color: rgb(0, 0, 0);\">Lorem Ipsum</strong><span style=\"color: rgb(0, 0, 0);\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 15.</span></p>', '<p><span style=\"color: rgb(0, 0, 0);\">eap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', 'active', '2022-01-05 07:19:25', '2022-01-05 07:19:49', NULL);

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

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int NOT NULL,
  `language_title` varchar(255) DEFAULT NULL,
  `language_code` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `language`
--

INSERT INTO `language` (`id`, `language_title`, `language_code`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'English', 'en', 'active', '2021-10-19 18:19:55', '2022-01-04 04:53:37', NULL),
(2, 'hindi', 'hn', 'inactive', '2022-01-04 08:45:06', '2022-01-05 05:25:06', '2022-01-05 05:25:06'),
(3, 'English', 'en', 'active', '2022-02-18 03:30:59', '2022-02-18 03:30:59', NULL);

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0000_00_00_000000_create_settings_table', 1),
(2, '2021_02_03_000000_create_failed_jobs_table', 1),
(3, '2021_02_03_000000_create_users_table', 1),
(4, '2021_02_03_100000_create_password_resets_table', 1),
(5, '2021_10_11_075126_create_permission_tables', 2);

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

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `offers`
--

CREATE TABLE `offers` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `discount_type` enum('percentage','absolute') DEFAULT NULL,
  `offer_type` enum('discount','bonus') DEFAULT NULL,
  `offer_coupon_type` enum('offer','agent') DEFAULT NULL,
  `offer_for_users` varchar(255) DEFAULT NULL,
  `auto_recharge` varchar(255) DEFAULT NULL,
  `product` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `offer_image` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `coupon_code` varchar(255) DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `offers`
--

INSERT INTO `offers` (`id`, `name`, `description`, `discount_type`, `offer_type`, `offer_coupon_type`, `offer_for_users`, `auto_recharge`, `product`, `amount`, `start_date`, `end_date`, `offer_image`, `status`, `coupon_code`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '1111Valentine\'s Day 2020 - 10% Bonus - PAYG1', '<p class=\"ql-align-justify\"><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><br></p>', 'percentage', 'discount', 'offer', 'All', 'all', 'test', '50', '2020-02-13 13:00:00', '2020-02-14 13:00:00', NULL, 'active', 'LOVE20\r\n', '2021-10-07 08:00:40', '2022-01-05 07:58:30', NULL),
(2, 'Holi 2020 - 10% Bonus on India ic plan', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-03-08 13:00:00', '2020-03-10 13:00:00', NULL, 'active', 'HOLI20\r\n', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(3, 'Women\'s Day 2020 10% Discount', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-03-07 13:00:00', '2020-03-08 13:00:00', NULL, 'active', 'WOMAN20\r\n', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(4, 'Monther\'s Day 2020 10% Discount', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-05-07 13:00:00', '2020-05-10 13:00:00', NULL, 'active', 'MOM2020\r\n', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(5, 'Philippines Independece Day Offer - 10% off', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-06-11 13:00:00', '2020-06-12 13:00:00', NULL, 'active', 'PINOY20\r\n', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(6, 'Father\'s Day 2019 10% Discount', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-06-18 13:00:00', '2020-06-21 13:00:00', NULL, 'active', 'DAD20\r\n', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(7, 'Labor Day 2020 - 10% on all Plans', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-09-06 13:00:00', '2020-09-07 13:00:00', NULL, 'active', 'LABOR20\r\n', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(8, 'Inpromptu Promo - $1 off TK 30', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-10-04 13:00:00', '2020-09-30 13:00:00', NULL, 'active', 'CALLGLOBE\r\n', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(9, 'Halloween 2020 - 10% Discount on all Plans', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-10-29 13:00:00', '2020-11-12 13:00:00', NULL, 'active', 'SPOOKY20', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(10, 'Diwali 2020 - 20% Bonus - india ic plans', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-11-05 13:00:00', '2020-11-25 13:00:00', NULL, 'active', 'DIWALI20', '2021-10-07 08:00:40', '2022-01-05 05:13:34', '2022-01-05 05:13:34'),
(11, 'xmas 2020 - 20% Bonus - PAYG World', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-12-23 13:00:00', '2020-12-25 13:00:00', NULL, 'active', 'MERRY20', '2021-10-07 08:00:40', '2022-01-05 05:13:42', '2022-01-05 05:13:42'),
(12, 'xmas 2020 - 20% Discount - TK30', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-12-23 13:00:00', '2020-12-01 13:00:00', NULL, 'active', 'MERRY20', '2021-10-07 08:00:40', '2022-01-05 05:14:09', '2022-01-05 05:14:09'),
(13, 'New Year 2021 Promo- 15% off - TK30', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-12-29 13:00:00', '2020-01-01 13:00:00', NULL, 'active', 'NEW21', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(14, 'New Year 2021 Promo 15 % Bonus PAYG World', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-12-29 13:00:00', '2020-01-29 13:00:00', NULL, 'active', 'NEW21', '2021-10-07 08:00:40', '2021-10-07 08:00:40', NULL),
(15, 'Thanksgiving 2020 - 15% Discount - ALL Plans*', '<p>ghgvvvvj</p>', 'percentage', 'discount', 'offer', 'All', 'all', 'sdfdsfsd', '20', '2020-11-25 13:00:00', '2020-11-29 13:00:00', NULL, 'active', 'THANKS20', '2021-10-07 08:00:40', '2021-10-21 23:21:25', NULL),
(16, 'lorem text', '<p class=\"ql-align-justify\"><strong>Lorem Ipsum<em>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</em></strong></p><p><br></p>', 'percentage', 'discount', 'offer', 'lorem', 'all', 'lorem', '1000', NULL, NULL, NULL, 'active', NULL, '2022-01-05 07:47:31', '2022-01-05 07:49:58', NULL);

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

--
-- Table structure for table `offertemplate`
--

CREATE TABLE `offertemplate` (
  `id` int NOT NULL,
  `template_name` varchar(255) DEFAULT NULL,
  `product` varchar(255) DEFAULT NULL,
  `recharge_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `offertemplate`
--

INSERT INTO `offertemplate` (`id`, `template_name`, `product`, `recharge_date`, `end_date`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Demotest', 'CallnRoam - Roam India Unlimited', '2022-01-20 00:00:00', '2022-01-05 00:00:00', 'active', '2021-10-13 16:23:28', '2022-01-04 23:40:33', NULL),
(2, 'Christmas Special Offer', 'Pay As You Go - World', '2014-12-24 00:00:00', '2014-12-22 00:00:00', 'inactive', '2021-10-13 16:23:28', '2021-10-13 17:43:44', NULL),
(3, 'Valentines Day', 'Pay As You Go - World', '2015-02-11 00:00:00', '2015-02-15 00:00:00', 'inactive', '2021-10-13 16:23:28', '2021-10-13 17:43:48', NULL),
(4, 'TG15', 'Pay As You Go - World', '2015-11-25 00:00:00', '2015-11-29 00:00:00', 'inactive', '2021-10-13 16:23:28', '2021-10-13 17:43:55', NULL),
(5, 'Happy Makar Sankranti', 'India @ 1c', '2016-01-14 00:00:00', '2016-01-14 00:00:00', 'inactive', '2021-10-13 16:23:28', '2021-10-13 17:44:00', NULL),
(6, 'Happy Pongal !', 'India @ 1c', '2016-01-15 00:00:00', '2016-01-16 00:00:00', 'active', '2021-10-13 16:23:28', '2021-10-13 17:42:20', NULL),
(7, 'new-year-international-bonus', 'Pay As You Go - World', '2016-12-31 00:00:00', '2017-01-01 00:00:00', 'active', '2021-10-13 16:23:28', '2021-10-13 17:42:31', NULL),
(8, 'Valentines-Day', 'Global Unlimited', '2017-02-12 00:00:00', '2018-06-12 00:00:00', 'active', '2021-10-13 16:23:28', '2021-10-13 17:42:51', NULL),
(9, 'Philippines Independence Day', 'Pinoy Unli-Call', '2018-06-12 00:00:00', '2015-10-21 00:00:00', 'active', '2021-10-13 16:23:28', '2021-10-13 17:38:33', NULL),
(10, 'ests', 'tes', '2022-01-05 00:00:00', '2022-01-05 00:00:00', 'active', '2022-01-05 02:39:40', '2022-01-05 05:31:41', '2022-01-05 05:31:41'),
(11, 'test', 'test', '2022-01-06 00:00:00', '2022-01-31 00:00:00', 'inactive', '2022-01-30 23:35:36', '2022-01-31 05:52:11', '2022-01-31 05:52:11');

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

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

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `module_name` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

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

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`, `module_name`) VALUES
(1, 'admin-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Admin Management'),
(2, 'admin-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Admin Management'),
(3, 'admin-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Admin Management'),
(4, 'admin-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Admin Management'),
(5, 'admin-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Admin Management'),
(6, 'role-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Role Management'),
(7, 'role-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Role Management'),
(8, 'role-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Role Management'),
(9, 'role-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Role Management'),
(10, 'role-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Role Management'),
(11, 'subscriber-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Subscriber Management'),
(12, 'subscriber-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Subscriber Management'),
(13, 'subscriber-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Subscriber Management'),
(14, 'subscriber-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Subscriber Management'),
(15, 'subscriber-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Subscriber Management'),
(16, 'faq-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Faq Management'),
(17, 'faq-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Faq Management'),
(18, 'faq-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Faq Management'),
(19, 'faq-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Faq Management'),
(20, 'faq-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Faq Management'),
(21, 'faqquestionanswer-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'FAQ Question Answer Management'),
(22, 'faqquestionanswer-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'FAQ Question Answer Management'),
(23, 'faqquestionanswer-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'FAQ Question Answer Management'),
(24, 'faqquestionanswer-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'FAQ Question Answer Management'),
(25, 'faqquestionanswer-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'FAQ Question Answer Management'),
(26, 'cms-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Cms Management'),
(27, 'cms-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Cms Management'),
(28, 'cms-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Cms Management'),
(29, 'cms-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Cms Management'),
(30, 'cms-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Cms Management'),
(31, 'sliders-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Sliders Management'),
(32, 'sliders-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Sliders Management'),
(33, 'sliders-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Sliders Management'),
(34, 'sliders-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Sliders Management'),
(35, 'sliders-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Sliders Management'),
(36, 'offers-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offers Management'),
(37, 'offers-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offers Management'),
(38, 'offers-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offers Management'),
(39, 'offers-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offers Management'),
(40, 'offers-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offers Management'),
(41, 'addontype-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Type Management'),
(42, 'addontype-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Type Management'),
(43, 'addontype-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Type Management'),
(44, 'addontype-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Type Management'),
(45, 'addontype-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Type Management'),
(46, 'addoncharge-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Charge Management'),
(47, 'addoncharge-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Charge Management'),
(48, 'addoncharge-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Charge Management'),
(49, 'addoncharge-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Charge Management'),
(50, 'addoncharge-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Addon Charge Management'),
(51, 'language-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Language Management'),
(52, 'language-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Language Management'),
(53, 'language-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Language Management'),
(54, 'language-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Language Management'),
(55, 'language-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Language Management'),
(56, 'offertemplate-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offer Template Management'),
(57, 'offertemplate-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offer Template Management'),
(58, 'offertemplate-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offer Template Management'),
(59, 'offertemplate-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offer Template Management'),
(60, 'offertemplate-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'Offer Template Management'),
(61, 'settings-list', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'settings Management'),
(62, 'settings-create', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'settings Management'),
(63, 'settings-edit', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'settings Management'),
(64, 'settings-delete', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'settings Management'),
(65, 'settings-show', 'web', '2021-10-11 22:14:11', '2021-10-11 22:14:11', 'settings Management');

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

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

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'superadmin', 'web', '2021-10-12 20:11:35', '2021-10-12 20:11:35'),
(2, 'admin', 'web', '2021-10-12 20:11:35', '2021-10-12 20:11:35'),
(3, 'cms', 'web', '2021-10-12 20:11:35', '2021-10-12 20:11:35'),
(4, 'user', 'web', '2021-10-12 20:11:35', '2021-10-12 20:11:35');

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

--
-- 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=utf8mb3 COLLATE=utf8_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),
(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),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(26, 3),
(28, 3),
(29, 3),
(31, 3),
(33, 3),
(34, 3),
(41, 3),
(43, 3),
(44, 3),
(46, 3),
(48, 3),
(49, 3);

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

--
-- Table structure for table `service_provider`
--

CREATE TABLE `service_provider` (
  `id` int NOT NULL,
  `country_id` bigint DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `logo` text,
  `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_0900_ai_ci;

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

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

CREATE TABLE `settings` (
  `id` int UNSIGNED NOT NULL,
  `code` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('BOOLEAN','NUMBER','DATE','TEXT','SELECT','FILE','TEXTAREA') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `hidden` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

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

INSERT INTO `settings` (`id`, `code`, `type`, `label`, `value`, `hidden`, `created_at`, `updated_at`) VALUES
(1, 'first', 'FILE', 'first', 'login.png', 0, '2021-10-06 00:04:15', '2022-01-31 06:26:58'),
(2, 'favicon_logo', 'FILE', 'Favicon Logo', 'favicon_logo.png', 0, '2021-10-06 00:04:15', '2021-10-24 21:42:43'),
(3, 'application_title', 'TEXT', 'Application Title', 'google-pay.png', 0, '2021-10-06 00:04:15', '2022-01-31 00:50:16'),
(4, 'copyright1', 'TEXT', 'Copy Right1', 'kb-article.jpg', 0, '2021-10-06 00:04:15', '2022-01-31 00:42:54');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `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_0900_ai_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `type`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(16, 'top', 'active', '2022-02-01 04:17:19', '2022-02-01 07:06:28', '2022-02-01 07:06:28'),
(17, 'left', 'active', '2022-02-01 06:55:34', '2022-02-01 07:06:44', '2022-02-01 07:06:44'),
(18, 'top', 'active', '2022-02-01 07:07:10', '2022-02-07 23:31:21', NULL),
(19, 'top', 'active', '2022-02-01 07:35:21', '2022-02-01 07:35:21', NULL),
(20, 'left', 'active', '2022-02-02 01:34:36', '2022-02-02 02:24:19', NULL),
(21, 'top', 'active', '2022-02-18 03:50:27', '2022-02-18 03:50:27', NULL);

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

--
-- Table structure for table `sliders_image`
--

CREATE TABLE `sliders_image` (
  `id` int NOT NULL,
  `sliders_id` int DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `text_position` varchar(255) DEFAULT NULL,
  `description` text,
  `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_0900_ai_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- Indexes for table `language`
--
ALTER TABLE `language`
  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 `offers`
--
ALTER TABLE `offers`
  ADD PRIMARY KEY (`id`);

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

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

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

--
-- 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 `service_provider`
--
ALTER TABLE `service_provider`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_code_unique` (`code`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `addoncharge`
--
ALTER TABLE `addoncharge`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `addontype`
--
ALTER TABLE `addontype`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `cms`
--
ALTER TABLE `cms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `faq`
--
ALTER TABLE `faq`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `faqquestionanswer`
--
ALTER TABLE `faqquestionanswer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `language`
--
ALTER TABLE `language`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `offers`
--
ALTER TABLE `offers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `offertemplate`
--
ALTER TABLE `offertemplate`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

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

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

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

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `sliders_image`
--
ALTER TABLE `sliders_image`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- 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;

