|
Server : Apache/2.4.41 (Ubuntu) System : Linux vmi1525618.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64 User : www-data ( 33) PHP Version : 8.2.12 Disable Function : NONE Directory : /var/www/_hpe.edukrypt.in/ |
Upload File : |
SET sql_require_primary_key=0;
CREATE TABLE `addresses` (
`id` int(11) NOT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`address` text COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`pincode` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `admin_modules`
--
CREATE TABLE `admin_modules` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`module` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `admin_modules`
--
INSERT INTO `admin_modules` (`id`, `admin_id`, `role_id`, `module`, `created_at`, `updated_at`) VALUES
(4, 0, 2, 'Pdf', '2021-06-04 10:05:27', '2021-07-13 10:45:36'),
(5, 0, 1, 'Admin User', '2021-06-06 09:23:51', '2021-07-13 13:01:41'),
(6, 0, 2, 'Products', '2021-06-07 13:31:00', '2021-06-07 13:31:00'),
(7, 0, 2, 'MCQ', '2021-06-22 07:54:53', '2021-06-22 08:37:41'),
(8, 0, 2, 'User', '2021-06-24 07:50:31', '2021-06-24 07:50:31'),
(9, 0, 2, 'window Encryption', '2021-07-11 08:40:34', '2021-07-11 08:40:34'),
(10, 0, 2, 'video', '2021-07-13 10:43:17', '2021-07-13 10:43:17'),
(11, 0, 2, 'sub-admin', '2021-07-14 09:08:09', '2021-07-14 09:08:09'),
(12, 0, 2, 'Category', '2021-07-26 06:43:54', '2021-07-26 06:43:54'),
(13, 0, 2, 'Orders', '2021-07-27 08:56:01', '2021-07-27 08:56:01'),
(14, 0, 2, 'live studio', '2021-08-01 11:34:40', '2021-08-01 11:34:40'),
(15, 0, 2, 'E-book', '2021-09-13 14:40:36', '2021-09-13 14:40:36'),
(16, 2, 2, 'Promocodes', '2021-10-18 11:50:11', '2021-10-18 11:50:11'),
(17, 2, 2, 'Blog', '2021-10-18 11:50:21', '2021-10-18 11:50:21'),
(18, 2, 2, 'Notification', '2021-10-18 11:50:28', '2021-10-18 11:50:28');
-- --------------------------------------------------------
--
-- Table structure for table `admin_module_permissions`
--
CREATE TABLE `admin_module_permissions` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`module_id` int(11) NOT NULL,
`permission` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `admin_module_permissions`
--
INSERT INTO `admin_module_permissions` (`id`, `admin_id`, `module_id`, `permission`, `created_at`, `updated_at`) VALUES
(5, 1, 4, 'delete', '2021-06-06 12:04:57', '2021-06-06 12:04:57'),
(6, 1, 5, 'delete', '2021-06-06 12:04:57', '2021-06-06 12:04:57'),
(9, 1, 6, 'delete', '2021-06-07 13:31:47', '2021-06-07 13:31:47'),
(10, 1, 7, 'delete', '2021-06-22 08:37:56', '2021-06-22 08:37:56'),
(11, 1, 8, 'delete', '2021-06-24 07:51:15', '2021-06-24 07:51:15'),
(12, 1, 9, 'delete', '2021-07-11 08:41:29', '2021-07-11 08:41:29'),
(13, 2, 9, 'delete', '2021-07-13 13:35:03', '2021-07-13 13:35:03'),
(16, 2, 6, 'delete', '2021-07-14 07:26:40', '2021-07-14 07:26:40'),
(18, 2, 8, 'delete', '2021-07-14 07:26:40', '2021-07-14 07:26:40'),
(19, 2, 11, 'delete', '2021-07-14 09:08:50', '2021-07-14 09:08:50'),
(21, 2, 10, 'delete', '2021-07-15 11:28:12', '2021-07-15 11:28:12'),
(22, 2, 12, 'delete', '2021-07-26 06:44:35', '2021-07-26 06:44:35'),
(23, 2, 13, 'delete', '2021-07-27 08:56:40', '2021-07-27 08:56:40'),
(24, 2, 14, 'delete', '2021-08-01 11:35:23', '2021-08-01 11:35:23'),
(25, 2, 7, 'delete', '2021-09-07 13:54:23', '2021-09-07 13:54:23'),
(26, 2, 4, 'delete', '2021-09-12 09:49:18', '2021-09-12 09:49:18'),
(27, 2, 15, 'delete', '2021-09-13 14:41:02', '2021-09-13 14:41:02'),
(28, 2, 16, 'delete', '2021-10-18 11:51:22', '2021-10-18 11:51:22'),
(29, 2, 17, 'delete', '2021-10-18 11:51:22', '2021-10-18 11:51:22'),
(30, 2, 18, 'delete', '2021-10-18 11:51:22', '2021-10-18 11:51:22'),
(33, 16, 9, 'write', '2021-10-27 14:34:57', '2021-10-27 14:34:57'),
(34, 17, 9, 'delete', '2021-10-27 16:20:24', '2021-10-27 16:20:24'),
(36, 18, 9, 'delete', '2021-10-27 18:51:42', '2021-10-27 18:51:42'),
(37, 19, 9, 'write', '2021-10-27 22:19:01', '2021-10-27 22:19:01'),
(44, 24, 13, 'delete', '2022-01-15 23:13:00', '2022-01-15 23:13:00'),
(45, 24, 16, 'delete', '2022-01-15 23:13:00', '2022-01-15 23:13:00'),
(46, 24, 17, 'delete', '2022-01-15 23:13:00', '2022-01-15 23:13:00'),
(47, 24, 18, 'delete', '2022-01-15 23:13:00', '2022-01-15 23:13:00'),
(48, 24, 6, 'write', '2022-01-15 23:15:01', '2022-01-15 23:15:01'),
(50, 24, 8, 'delete', '2022-01-15 23:18:15', '2022-01-15 23:18:15'),
(51, 24, 13, 'write', '2022-01-15 23:19:14', '2022-01-15 23:19:14'),
(52, 24, 13, 'read', '2022-01-15 23:19:59', '2022-01-15 23:19:59'),
(53, 26, 6, 'write', '2022-01-17 23:26:17', '2022-01-17 23:26:17'),
(55, 26, 10, 'write', '2022-01-17 23:26:17', '2022-01-17 23:26:17'),
(57, 26, 14, 'write', '2022-01-17 23:26:17', '2022-01-17 23:26:17'),
(58, 26, 4, 'write', '2022-01-17 23:26:17', '2022-01-17 23:26:17'),
(59, 26, 15, 'write', '2022-01-17 23:26:17', '2022-01-17 23:26:17'),
(60, 26, 16, 'write', '2022-01-17 23:50:59', '2022-01-17 23:50:59'),
(61, 26, 17, 'write', '2022-01-17 23:50:59', '2022-01-17 23:50:59'),
(62, 26, 18, 'write', '2022-01-17 23:50:59', '2022-01-17 23:50:59'),
(63, 25, 13, 'delete', '2022-01-18 18:21:44', '2022-01-18 18:21:44'),
(64, 26, 8, 'delete', '2022-01-18 19:00:10', '2022-01-18 19:00:10'),
(65, 26, 13, 'delete', '2022-01-18 19:00:10', '2022-01-18 19:00:10'),
(66, 25, 8, 'delete', '2022-01-18 19:00:14', '2022-01-18 19:00:14'),
(67, 25, 6, 'delete', '2022-01-18 19:24:06', '2022-01-18 19:24:06'),
(68, 25, 11, 'delete', '2022-01-18 19:24:14', '2022-01-18 19:24:14'),
(69, 25, 10, 'read', '2022-01-18 19:24:30', '2022-01-18 19:24:30'),
(70, 25, 14, 'write', '2022-01-18 19:24:41', '2022-01-18 19:24:41'),
(71, 25, 4, 'delete', '2022-01-18 19:24:51', '2022-01-18 19:24:51'),
(72, 25, 16, 'delete', '2022-01-18 19:25:00', '2022-01-18 19:25:00'),
(73, 25, 17, 'delete', '2022-01-18 19:25:08', '2022-01-18 19:25:08'),
(74, 25, 18, 'delete', '2022-01-18 19:25:14', '2022-01-18 19:25:14'),
(76, 25, 15, 'write', '2022-01-18 19:30:34', '2022-01-18 19:30:34'),
(77, 27, 9, 'read', '2023-02-17 05:06:41', '2023-02-17 05:06:41');
-- --------------------------------------------------------
--
-- Table structure for table `admin_roles`
--
CREATE TABLE `admin_roles` (
`id` int(10) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL DEFAULT 0,
`role` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `admin_roles`
--
INSERT INTO `admin_roles` (`id`, `admin_id`, `role`, `created_at`, `updated_at`) VALUES
(1, 0, 'Superadmin', '2021-06-04 10:05:00', '2021-07-13 10:35:13'),
(2, 0, 'Admin', '2021-06-04 10:05:06', '2021-06-04 10:05:06'),
(13, 2, 'Teacher', '2023-02-17 05:04:05', '2023-02-17 05:05:24');
-- --------------------------------------------------------
--
-- Table structure for table `admin_users`
--
CREATE TABLE `admin_users` (
`id` int(20) UNSIGNED NOT NULL,
`parent_id` int(11) NOT NULL DEFAULT 0,
`role_id` int(11) NOT NULL,
`ip_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`institute` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`profile_pics` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `admin_users`
--
INSERT INTO `admin_users` (`id`, `parent_id`, `role_id`, `ip_address`, `username`, `email`, `phone`, `institute`, `password`, `profile_pics`, `salt`, `created_at`, `updated_at`) VALUES
(1, 0, 1, '127.0.0.1', 'Superadmin', 'admin@admin.com', '9911315020', 'Hub for Professional Excellence', '$2y$10$7JE3jhLDPtrozR553KZk4egdtl4hXUN.4XcyvqGU4OOU60Reg.CHW', NULL, 'QKUBouGfZ8ylZbVq', '2023-02-13 07:27:09', '2023-02-13 07:27:09'),
(2, 0, 2, '::1', 'Hub for Professional Excellence', 'accamadeeasy@gmail.com', '256774622229', 'Hub for Professional Excellence', '$2y$10$7JE3jhLDPtrozR553KZk4egdtl4hXUN.4XcyvqGU4OOU60Reg.CHW', 'NULL', 'QKUBouGfZ8ylZbVq', '2023-02-13 07:27:09', '2023-02-28 10:59:33'),
(27, 2, 13, '::1', 'Teacher', 'enccryption@gmail.com', '256704622229', 'Hub for Professional Excellence', '$2y$10$OQpoh1wF8hI1SXMum9vqSuL0yqLC3EXuVr04CooayENmNCPY2P/vi', NULL, 'QKUBouGfZ8ylZbVq', '2023-02-17 05:06:17', '2023-02-28 13:22:11');
-- --------------------------------------------------------
--
-- Table structure for table `billings`
--
CREATE TABLE `billings` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`payment_request_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`transaction_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`tax_invoice_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`serial_no` int(11) NOT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`quantity` int(11) NOT NULL,
`taxable_amount` float NOT NULL,
`tax_amount` float NOT NULL,
`total_amount` float NOT NULL,
`payment_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`instrument_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`place_of_supply` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`bill_type` enum('in','out') COLLATE utf8_unicode_ci NOT NULL,
`order_type` enum('paid','free') COLLATE utf8_unicode_ci NOT NULL,
`promo_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`cashback` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`discount` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`use_wallet` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
`long_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tracking_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tracking_status` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
`created_at` datetime NOT NULL COMMENT 'biliind date',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `blogs`
--
CREATE TABLE `blogs` (
`id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`blog_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`short_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sort_order` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`id` int(10) UNSIGNED NOT NULL,
`parent_id` int(11) NOT NULL,
`product_id` int(11) DEFAULT NULL,
`admin_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci DEFAULT NULL,
`type` enum('content','category') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'category',
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sort_order` int(11) NOT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`locked` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '0=>unlock,1=>locked',
`demo_type` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '1=>not demo,0=>demo',
`created_at` timestamp NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`id`, `parent_id`, `product_id`, `admin_id`, `name`, `description`, `type`, `image`, `slug`, `sort_order`, `status`, `locked`, `demo_type`, `created_at`, `updated_at`) VALUES
(1, 0, 1, 2, 'Chapter 01', 'Chapter 01', 'category', 'noimage.jpg', 'chapter-01', 1, 0, '1', '1', '2023-02-17 05:25:41', '2023-02-17 05:26:05'),
(2, 0, 1, 2, 'Chapter 02', 'Chapter 02', 'category', 'noimage.jpg', 'chapter-02', 2, 0, '1', '1', '2023-02-17 05:25:54', '2023-02-17 05:26:07'),
(3, 1, 1, 2, 'Topic 01', 'Topic 01', 'content', 'noimage.jpg', 'topic-01', 3, 1, '1', '1', '2023-02-17 05:26:22', '2023-02-17 05:26:22'),
(4, 1, 1, 2, 'Topic 02', 'Topic 02', 'content', 'noimage.jpg', 'topic-02', 4, 1, '1', '1', '2023-02-17 05:26:32', '2023-02-17 05:26:32'),
(5, 2, 1, 2, 'Topic 03', 'Topic 03', 'content', 'noimage.jpg', 'topic-03', 5, 1, '1', '1', '2023-02-17 05:28:02', '2023-02-17 05:28:02');
-- --------------------------------------------------------
--
-- Table structure for table `contents`
--
CREATE TABLE `contents` (
`id` int(11) NOT NULL,
`type` enum('video','pdf','practice_test','ebook') COLLATE utf8_unicode_ci NOT NULL,
`admin_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`video_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`demo_video_type` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`sort_order` int(11) NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `contents`
--
INSERT INTO `contents` (`id`, `type`, `admin_id`, `product_id`, `cat_id`, `video_id`, `demo_video_type`, `sort_order`, `created_at`, `updated_at`) VALUES
(13, 'pdf', 2, 1, 3, '45c5ce8c17c0efa5404a46362d4c59e3', '0', 1, '2023-02-21 18:43:15', '2023-02-21 07:43:15'),
(14, 'pdf', 2, 1, 3, 'f5f95fd00ba4332e49d59fe54c293b4a', '0', 2, '2023-02-21 18:43:15', '2023-02-21 07:43:15'),
(20, 'ebook', 2, 1, 3, 'bde070bf04b7c6d4b712faa5f85d1389', '0', 8, '2023-02-21 19:19:54', '2023-02-21 08:19:54'),
(21, 'ebook', 2, 1, 3, '9244d2f8d154fcfe38b34d3d04910f99', '0', 9, '2023-02-21 19:19:54', '2023-02-21 08:19:54'),
(22, 'practice_test', 2, 1, 3, '1', '0', 10, '2023-02-21 19:20:22', '2023-02-21 08:20:22'),
(23, 'video', 2, 1, 3, 'c35d574c3b6a48b943a6cce43609619b', '0', 11, '2023-02-27 18:03:29', '2023-02-27 07:03:29');
-- --------------------------------------------------------
--
-- Table structure for table `ebooks`
--
CREATE TABLE `ebooks` (
`id` int(11) NOT NULL,
`filename` text COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`etag` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`size` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'video',
`admin_id` int(11) NOT NULL,
`date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `ebooks`
--
INSERT INTO `ebooks` (`id`, `filename`, `path`, `etag`, `size`, `type`, `admin_id`, `date`, `created_at`, `updated_at`) VALUES
(19, 'ebook1.mp4', 'saas_ebooks/ebook1.mp4', '2c472b8a19c40a41a442136f1d608ea4', '10546624', 'pdf', 2, '2023-02-28', '2023-02-28 18:31:38', '2023-02-28 13:01:38'),
(20, 'ebook2.mp4', 'saas_ebooks/ebook2.mp4', 'b710afe375457d37f3b5037f61b96177', '10546625', 'pdf', 2, '2023-02-28', '2023-02-28 18:31:39', '2023-02-28 13:01:39'),
(21, 'ebook3.mp4', 'saas_ebooks/ebook3.mp4', 'd9e44de8725e538259f01be0be586073', '10546626', 'pdf', 2, '2023-02-28', '2023-02-28 18:31:39', '2023-02-28 13:01:39'),
(22, 'ebook4.mp4', 'saas_ebooks/ebook4.mp4', 'b1ceac3d4dc3da758e9e2b8f34b52ddc', '10546627', 'pdf', 2, '2023-02-28', '2023-02-28 18:31:39', '2023-02-28 13:01:39'),
(23, 'ebook5.mp4', 'saas_ebooks/ebook5.mp4', '4b0178ee40b98f0854c0072f249c38cb', '10546663', 'pdf', 2, '2023-02-28', '2023-02-28 18:31:39', '2023-02-28 13:01:39');
-- --------------------------------------------------------
--
-- Table structure for table `ebooks_mapping`
--
CREATE TABLE `ebooks_mapping` (
`id` int(11) NOT NULL,
`filename` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`public_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`etag` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`size` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pdf',
`tags` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`admin_id` int(11) NOT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `ebooks_mapping`
--
INSERT INTO `ebooks_mapping` (`id`, `filename`, `public_name`, `path`, `etag`, `size`, `type`, `tags`, `admin_id`, `created_at`, `updated_at`) VALUES
(5, 'ebook1.mp4', 'ebook1', 'saas_ebooks/ebook1.mp4', '2c472b8a19c40a41a442136f1d608ea4', '10546624', 'pdf', 'CAF Bills of Exchange', 2, '2023-02-28 18:32:21', '2023-02-28 13:02:21'),
(6, 'ebook2.mp4', 'ebook2', 'saas_ebooks/ebook2.mp4', 'b710afe375457d37f3b5037f61b96177', '10546625', 'pdf', 'CAF Bills of Exchange', 2, '2023-02-28 18:32:21', '2023-02-28 13:02:21'),
(7, 'ebook3.mp4', 'ebook3', 'saas_ebooks/ebook3.mp4', 'd9e44de8725e538259f01be0be586073', '10546626', 'pdf', 'CAF Bills of Exchange', 2, '2023-02-28 18:32:21', '2023-02-28 13:02:21'),
(8, 'ebook4.mp4', 'ebook4', 'saas_ebooks/ebook4.mp4', 'b1ceac3d4dc3da758e9e2b8f34b52ddc', '10546627', 'pdf', 'CAF Bills of Exchange', 2, '2023-02-28 18:32:21', '2023-02-28 13:02:21'),
(9, 'ebook5.mp4', 'ebook5', 'saas_ebooks/ebook5.mp4', '4b0178ee40b98f0854c0072f249c38cb', '10546663', 'pdf', 'CAF Bills of Exchange', 2, '2023-02-28 18:32:21', '2023-02-28 13:02:21');
-- --------------------------------------------------------
--
-- Table structure for table `email_logs`
--
CREATE TABLE `email_logs` (
`id` int(11) NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `email_logs`
--
INSERT INTO `email_logs` (`id`, `email`, `created_at`, `updated_at`) VALUES
(1, 'vishal@theinteractive.in', '2023-02-21 19:22:11', '2023-02-21 08:22:11'),
(2, 'vishal@theinteractive.in', '2023-02-21 19:42:15', '2023-02-21 08:42:15');
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`connection` text COLLATE utf8_unicode_ci NOT NULL,
`queue` text COLLATE utf8_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `global_settings`
--
CREATE TABLE `global_settings` (
`id` int(11) NOT NULL,
`mobile_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `global_settings`
--
INSERT INTO `global_settings` (`id`, `mobile_no`, `created_at`, `updated_at`) VALUES
(1, '9875523445', '2021-10-07 07:18:43', '2022-02-08 00:50:38');
-- --------------------------------------------------------
--
-- Table structure for table `learn_revisions`
--
CREATE TABLE `learn_revisions` (
`id` int(11) NOT NULL,
`chapters` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('learn','revision') COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `learn_revision_files`
--
CREATE TABLE `learn_revision_files` (
`id` int(11) NOT NULL,
`learn_revision_id` int(11) NOT NULL,
`files_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `logs`
--
CREATE TABLE `logs` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`activity` text COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `main_categories`
--
CREATE TABLE `main_categories` (
`id` int(10) UNSIGNED NOT NULL,
`parent_id` int(11) NOT NULL,
`product_id` int(11) DEFAULT NULL,
`admin_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci DEFAULT NULL,
`type` enum('content','category') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'category',
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sort_order` int(11) NOT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `main_categories`
--
INSERT INTO `main_categories` (`id`, `parent_id`, `product_id`, `admin_id`, `name`, `description`, `type`, `image`, `slug`, `sort_order`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, NULL, 2, 'CA Foundation', NULL, 'content', 'noimage.jpg', 'ca-foundation', 1, 1, '2023-02-17 03:23:07', '2023-02-17 03:23:07');
-- --------------------------------------------------------
--
-- Table structure for table `materials`
--
CREATE TABLE `materials` (
`id` int(11) NOT NULL,
`filename` text COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`etag` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`size` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'video',
`admin_id` int(11) NOT NULL,
`date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `materials`
--
INSERT INTO `materials` (`id`, `filename`, `path`, `etag`, `size`, `type`, `admin_id`, `date`, `created_at`, `updated_at`) VALUES
(16, 'Grave-Mistake.pdf', 'saas_public/Grave-Mistake.pdf', '45c5ce8c17c0efa5404a46362d4c59e3', '1118542', 'pdf', 2, '2023-02-21T10:15:24+0000', '2023-02-21 17:04:55', '2023-02-21 06:04:55'),
(17, 'Queen-of-Light-and-Ashes.pdf', 'saas_public/Queen-of-Light-and-Ashes.pdf', 'f5f95fd00ba4332e49d59fe54c293b4a', '1754650', 'pdf', 2, '2023-02-21T10:15:24+0000', '2023-02-21 17:04:55', '2023-02-21 06:04:55');
-- --------------------------------------------------------
--
-- Table structure for table `mcqs`
--
CREATE TABLE `mcqs` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`instruction` text COLLATE utf8_unicode_ci NOT NULL,
`time_limit` int(11) NOT NULL,
`retake_attempt` enum('1','0') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '1=>unlimited,0=>limited',
`nooftimes` int(11) DEFAULT 0,
`passing_percentage` int(11) NOT NULL,
`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `mcqs`
--
INSERT INTO `mcqs` (`id`, `admin_id`, `name`, `instruction`, `time_limit`, `retake_attempt`, `nooftimes`, `passing_percentage`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'Quiz 01', '<h3>Quiz Instructions</h3>\r\n<p>The quizzes consists of questions carefully designed to help you self-assess your comprehension of the information presented on the topics covered in the module. No data will be collected on the website regarding your responses or how many times you take the quiz.</p>', 5, '1', 0, 60, '1', '2023-02-16 15:06:53', '2023-02-16 04:06:53');
-- --------------------------------------------------------
--
-- Table structure for table `mcq_histories`
--
CREATE TABLE `mcq_histories` (
`id` int(11) NOT NULL,
`mcq_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`percentage` int(11) DEFAULT NULL,
`correct` int(11) DEFAULT NULL,
`wrong` int(11) DEFAULT NULL,
`attempt` int(11) DEFAULT NULL,
`lefts` int(11) DEFAULT NULL,
`marks` int(11) DEFAULT NULL,
`time_taken` time DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `mcq_options`
--
CREATE TABLE `mcq_options` (
`id` bigint(20) UNSIGNED NOT NULL,
`question_id` int(11) NOT NULL,
`sort_order` int(11) UNSIGNED NOT NULL,
`options` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`correct` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT '1=>True,0=>false',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `mcq_options`
--
INSERT INTO `mcq_options` (`id`, `question_id`, `sort_order`, `options`, `correct`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '<p style=\"margin-top: 0; margin-bottom: 0;\"> easy</p>', '', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(2, 1, 2, '<p style=\"margin-top: 0; margin-bottom: 0;\"> Cat</p>', '', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(3, 1, 3, '<p style=\"margin-top: 0; margin-bottom: 0;\"> Lion</p>', '', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(4, 1, 4, '<p style=\"margin-top: 0; margin-bottom: 0;\"> Elephant</p>', '1', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(5, 2, 1, '<p style=\"margin-top: 0; margin-bottom: 0;\"> easy</p>', '', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(6, 2, 2, '<p style=\"margin-top: 0; margin-bottom: 0;\"> Cat</p>', '1', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(7, 2, 3, '<p style=\"margin-top: 0; margin-bottom: 0;\"> Lion</p>', '', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(8, 2, 4, '<p style=\"margin-top: 0; margin-bottom: 0;\"> Elephant</p>', '1', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(9, 3, 1, '<p style=\"margin-top: 0; margin-bottom: 0;\"> True</p>', '1', '2023-02-16 04:06:01', '2023-02-16 04:06:01'),
(10, 3, 2, '<p style=\"margin-top: 0; margin-bottom: 0;\"> False</p>', '', '2023-02-16 04:06:01', '2023-02-16 04:06:01');
-- --------------------------------------------------------
--
-- Table structure for table `mcq_questions`
--
CREATE TABLE `mcq_questions` (
`id` bigint(20) UNSIGNED NOT NULL,
`parent_id` int(11) UNSIGNED DEFAULT 0 COMMENT 'sub-question-id',
`admin_id` int(11) NOT NULL,
`type` enum('mcq','fill','true_false','single_mcq') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'mcq',
`group_question` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=>true,0=>false',
`group_text` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
`question` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`solution` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
`answer` float DEFAULT 0 COMMENT 'fill',
`min` float DEFAULT 0 COMMENT 'fill',
`max` float DEFAULT 0 COMMENT 'fill',
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tags` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`mark` float NOT NULL DEFAULT 1,
`penalty` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `mcq_questions`
--
INSERT INTO `mcq_questions` (`id`, `parent_id`, `admin_id`, `type`, `group_question`, `group_text`, `question`, `solution`, `answer`, `min`, `max`, `code`, `tags`, `mark`, `penalty`, `created_at`, `updated_at`) VALUES
(1, 0, 2, 'single_mcq', 0, NULL, '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\"><img border=\"0\" style=\"width: 225px; height: 225px;\" src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxATDhASExANEhASEA8YFhURDxIQGBIZFxIWFhYR GBUYHSggGRolGxgXITEhJSkrLi4uFx8zODMtNyotLisBCgoKDg0OGxAQGisdHyEtLy0tLS0tNy0t LS0tLS0tLS4tLy0tLSstLS0tLS4tLy0tLS0tLTAtLS0tLS0tLS0tNP/AABEIAOEA4QMBIgACEQED EQH/xAAbAAEAAgMBAQAAAAAAAAAAAAAAAwYCBAUBB//EAEAQAAIBAgIGBgcGBQQDAQAAAAABAgMR BCEFEjFBUWEGE3GBkaEiMkJScrHBFGKSstHwM1OCouEVFiPSQ2PxB//EABgBAQEBAQEAAAAAAAAA AAAAAAACAwEE/8QAIhEBAQACAgMAAgMBAAAAAAAAAAECERIhAzFBUWFxgZEi/9oADAMBAAIRAxEA PwD7iAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAADyUkldtJcW7HkJpq6aa5O5q6Yw3WYepDK7jdXdleLUkm+F0il4LFSptTptq27YpcYtFS bTbp9ABHQqqcIzWyUU13q5ISoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHH6R4atUhFU84K7lF Ozlw7VyKonlyLrprFOnh5yTtJrVjylLJPu29xT8DhOsqU6SulJ2dvZivWfhl2tGmF6Z5ztcdCxth qXwJ+OaN08ikkkskj0zaABXekOlWm6NN2ftyW77i58Xu+XZNuW6bWk9PQptxgusmtudox7XvfJHC raXxEnnVa5QSgv8At5mikemkxkZ3K1tQ0liFsrVO9qf5kzo4TpJNZVYRkvep3i12xbd+59xxCOrC 9l7O/ny7Dtxjkyqw6Q6R3VqFrNfxGvyxe/m8uTOPUxVWTvKrVb+OS8lku4hk0kQSrPcJjC5WuhS0 hXi/RrVe+WuvCV0dXCdJmv40Lr3qSfnBtvwb7isqs/2iWFW4uEJlYtX+6KLV4xqyXwpfNnn+5qf8 qt/Z+pVKkGnrR27173+SSEk0mtjOcI7zq0x6S0d8Ky/pT+TJqfSDDvbKUfihJFSA4R3nV7oYylP1 akJN7lJX8NpOfPHFcEb2E0tXp7JuUfdqXku6XrLxtyJuDszXUHL0bpynUai/+Oo/Zk8n8L3nUIWA AAAAAAAAACtdK8ReVOnwTk/kvqZdE8P/ABKj5QXzl9PA5Ok62viKsvvuK7Iej80/EsvRqKWFg/ec 2/xNfQu9YoneTqAAhbT0rjOqoynv2RXGTyX75FJz3tttttve3tZ2OlGJ1q0afs01d/FJfSP5mcc1 wnTLO9hWdO0NK1aslhqtHDUY2tKUVOdV2u3mmox3dxZWzLG6Q0fhpRpYmvUVdpOUaSuqV80pWW22 f0NMcMs7xwlt/Sdyd3pVOi+k8cq8sJjYR61Q1qdWCSjVimk9mV03y27C1GeJw8VKMoyhUhKGtTqR s9aMuD+fcYEwrXxG0iJsRtXYQlQAAdGzSnftMaWUpR3ZSXfe68VfvMKPrEkv4kfgn+aJNEoAOAAA PGjt6G044tU6sm4bFN7Y8pPeuficUHLNuy6fQgVzo1pJ3VCb3Pq2+Wbh4ZrkmWMys01l2AA46AAA AAPnNCTcIt7XFN9rV2XHozUTw0V7spr+6/1KdQi1CKe1RSfalZnW0DpFUajU3anO137klkm+XPd4 muU3GWN1VwPJOyvuQjJNXTTXFMrPSvT8IwlQpTTqyVpOLuqUd7bXtcu19ucm2tunHxFbXqTn78pP u3eVjA0qGJaahUWq/Ze6XK/E3TZgzoW6ynfZ1lO/4kfJsTpbBvE6Y+3Or9otP7PbW/iXbby37NuV kfVWir9Ieg+FxeI6+fWRqO2vqatqlvaaex8dvYa+POyXGZcd67/j513+/wCnNTfc23OgeJlPROFc 9qnXtyi1BtLlrN+J3SHCYaFOnCnCKjCEVGMVnZXb272222+ZK2uRzy5887l+bsk1JEOI3EJs1YXI HFrcTHWIBNTpXzYGVNJK7sstryseUs5OW61o887t9+XgMRsUfekl3Xu/ImJAAAAAAAAC7yadmmmn wad0/Eu+i8WqtGM99rSXCSyaKQdropiLVZ09046y5ONotd6a/Cyc50rC9rQADJqAAAAAKPpXD9Xi KkbZOTkuyTv87mqW3T2jXVgpR/iQvbdrLfD9OZUU/wBvK3Jo1xu4yymq5mIlJTmlKcYx1G1Gcor0 pRWxO3Exo0UpRg/VnBW7bXXg9b8SOjWoKUZLZrKza2h0ItQT9hxaezYUnaHB3s4TWcGrNrKS3NeB tNnp2OjmD1pSqtZR9GPN+1LuyXict07JtXNJ4+FGhOrL1YK+W/gkeaIxyr4elWScVUjezd7Z2a8i uf8A7RjUsTHC0/bVOpNL3neMYd9lLvLHobC9VhqNPfClBPtSz8yMc+WVn4ejyeGYeHHO+8rf8jcM ZxTVmrpmQNHmQqUo7byjxSu12r6mcasXslF96MyCnTi5TbjF+lbNJ7EgJk1yI6tTcraz2b7c3yPX Qh7se5WMoQS2JIDGFOzu22+L+SW4kAAAAAAAAAAGzoupq4ii/wD2JfivF+TNY9jKzi+Eo/NC+ie3 0EAGDcAAAAADjaZ0Iql507Rqb09lTt4PmdkxnNLa0lzdhLos2oNSEoycZRcZLdJWf+UYlzxv2eot WcVUtn6MW2uaa+hxK2gG5Lq5SjC+fXJSaXCOq0/xeJpM2dwcqhRlOahH1peS3yfJFvhBUqcYRV7K 0V7z/ebIMHhadBasbzqS275S/wCqN/D0HfXlbXtsWyC91fV7ycrtWOOnyDSnQvE/61VxGIcqlHXj OE7X6x29GnZbNW3ki1fZKtr9VWtx6uVu0voOY/8APpp5c8vLrl8mo+eJnpZtLaBU250tWM360XlG fPk/mVvGUalKSjOnNNq6tZp997Gsylee42MJSSTb2JEeHXo3e1tvx3eB5qSl61lFeze9+1/QmOuA AAAAAAAAAAAGE52cVvb+l2/3xAzI68rRbSu1sWeeewkNvRFHXxNJZ5S1nbco537L2XeL6J7dvR/S OE3q1I9W27J62tF8m7Jxfau87hyNM6GhUi5QSjVSezJT+7Jb+3aiHotjXOnKnJ3dO2q3t1XeyfNN NdljH9xtPxXdABx0AAEdenrRcdaUbrbF2a7GasNH22Om+cqV2+162bN4Aa32eezXil92nZ+ba8jx YNe1OrLPfJQ/IlddptADClSjFWjFJclYzAAAAAaOmNHqtStkpxzg3x4Pk9hvAD57vaas02muDW1A 6HSjBuniOtisqsbyS3uOTa52t4HNhJNXWaNpdxjZqsgR05u8k9qfk9jJDrgAeXA9AAAAACGGc29y 9FfN/TwMq07LL1nkv17EZU4WSXDz5gZFj6K4O0ZVntn6MfhTzfe/yo4WBwrq1Y01fPOTXsxW1/Tt aL1TpqMVFKySSS4JEZ34vCfWTZVuisb16s0rJQat8U7r8r8TuaZr6mHqy36rS7XkvmanRbD6uGUt 9STl3ZRj/ak+9kfF/XYABx0AAAAAAAAAAAAAAAByOk9DWw+tbOnKL7m9WXdZ37inyptPWjt3rdLn yZ9Ax1HXo1YPZOnOPjFooVOV4p8Un4o0wZ5oHUWtGSyaajJPalLJedvFmyQYukpReWaTs9jXeTRd 0nxRaHpFW2wf3reKsSkOKfoN8Gn5gTAxdSPGPiiJYuG5t/DGUvkgJzGpNJXf/wB5Ij6yT2Qa5ysv JGOGg3eUnrS1pJZWsk7WS7gM6UHfWlte73VwJGz03tCYXrMRFP1YenLnZ+ivHP8ApYt0Sbd/o/o/ qqWtJf8AJUs5cluj3fNs6oBg3cLpfUaoQivbqpeEZSXmkdjC0lGnCKyUYxXgjj9L6bdGE17FVN98 ZRXm0dfDV4yhCSatKKaz23R3459TAA46Ah+10v5lP8cf1AEwAAAAAAAAAAAADGckk29iTPndD1I/ DH5Fq6S6RUYOjF+nUjaX3YvJ972IrJphGedRYl2hP4ZfIzpxtFLgkvIwxGerH3pLwXpP5W7yUtAF tj8cPzIHtOLcopb5w/MhSLrpeqo4eq/uSXirL5lIRZOlmI9GnT3ylrPsj/lorhGE6XnewhwvqLtl +ZmdWdot8F4vcvEUYasYrhFLwRaGZYOiMV/zPfeC7rN/VlfO30Tq2qVYX9aMZLnZ2fzj4k5elY+1 nABk1RYuip05xaT1oyWfNHz1U4q10lK9s0k7rzufRzj6V0BCq9eLUKl7+qpRk+LjxKxuk5Tbk4HT tamtWVqkVs1naS5a2/vJftuIxUuqjanTfruDd1HenLc3wR0MLoClqrrIxct+o5xi+5tvzOrh6EIR 1YRjGPBK3f2i2fCStP8A0TC/yKP4EDoAlQAAAAAAAAAAAAAruktBydSrVSVbXT9GUtWUXq2tFvLh ttbicWeAnCknONZVVqXThLVzaTV0tV5Z3TL4DsyqbjHziC1q0U24rZd5WVnKT8I27TZ0jCnDVcGr O6au3bK6l8y+tBRXBHeTnBRq2FioJwlKc8sleWvxslvNrRWjK0qtOTpzjCMk25rV2btV559hcAOV d4xV9NUIyxc3UuoqnTjC94qWcm5J77a1jmaMownrubjJRk4q7te3t990XpoieEpP/wAdP8Ef0ObL i+e4tKNTU1rxi73ve6Sur/vcbk8HJUlUb3Jyjb1V28Vv7y7LC07NdXTs9q1I2fca9TRGHle9KDur PbmuFiubnBUsPgpzg5qSW3VVvWtlm92Z7oivq4ijLNXmotcdf0NV9jaf9JbI6Hw6VlSilwV/1MsP ouhB3hShF3228xyOLcABCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH// 2Q== \"/></p> <p> </p> <p style=\"margin-top: 0; margin-bottom: 0;\">See Picture. What is animal name?</p>', '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\">Elephant, (family Elephantidae), largest living land animal, characterized by its long trunk (elongated upper lip and nose)</p>', 0, 0, 0, 'MCQ01', 'CMA', 1, '0', '2023-02-16 15:06:01', '2023-02-16 04:06:01'),
(2, 0, 2, 'mcq', 0, NULL, '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\"><img border=\"0\" style=\"width: 225px; height: 225px;\" src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxATDhASExANEhASEA8YFhURDxIQGBIZFxIWFhYR GBUYHSggGRolGxgXITEhJSkrLi4uFx8zODMtNyotLisBCgoKDg0OGxAQGisdHyEtLy0tLS0tNy0t LS0tLS0tLS4tLy0tLSstLS0tLS4tLy0tLS0tLTAtLS0tLS0tLS0tNP/AABEIAOEA4QMBIgACEQED EQH/xAAbAAEAAgMBAQAAAAAAAAAAAAAAAwYCBAUBB//EAEAQAAIBAgIGBgcGBQQDAQAAAAABAgMR BCEFEjFBUWEGE3GBkaEiMkJScrHBFGKSstHwM1OCouEVFiPSQ2PxB//EABgBAQEBAQEAAAAAAAAA AAAAAAACAwEE/8QAIhEBAQACAgMAAgMBAAAAAAAAAAECERIhAzFBUWFxgZEi/9oADAMBAAIRAxEA PwD7iAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAADyUkldtJcW7HkJpq6aa5O5q6Yw3WYepDK7jdXdleLUkm+F0il4LFSptTptq27YpcYtFS bTbp9ABHQqqcIzWyUU13q5ISoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHH6R4atUhFU84K7lF Ozlw7VyKonlyLrprFOnh5yTtJrVjylLJPu29xT8DhOsqU6SulJ2dvZivWfhl2tGmF6Z5ztcdCxth qXwJ+OaN08ikkkskj0zaABXekOlWm6NN2ftyW77i58Xu+XZNuW6bWk9PQptxgusmtudox7XvfJHC raXxEnnVa5QSgv8At5mikemkxkZ3K1tQ0liFsrVO9qf5kzo4TpJNZVYRkvep3i12xbd+59xxCOrC 9l7O/ny7Dtxjkyqw6Q6R3VqFrNfxGvyxe/m8uTOPUxVWTvKrVb+OS8lku4hk0kQSrPcJjC5WuhS0 hXi/RrVe+WuvCV0dXCdJmv40Lr3qSfnBtvwb7isqs/2iWFW4uEJlYtX+6KLV4xqyXwpfNnn+5qf8 qt/Z+pVKkGnrR27173+SSEk0mtjOcI7zq0x6S0d8Ky/pT+TJqfSDDvbKUfihJFSA4R3nV7oYylP1 akJN7lJX8NpOfPHFcEb2E0tXp7JuUfdqXku6XrLxtyJuDszXUHL0bpynUai/+Oo/Zk8n8L3nUIWA AAAAAAAAACtdK8ReVOnwTk/kvqZdE8P/ABKj5QXzl9PA5Ok62viKsvvuK7Iej80/EsvRqKWFg/ec 2/xNfQu9YoneTqAAhbT0rjOqoynv2RXGTyX75FJz3tttttve3tZ2OlGJ1q0afs01d/FJfSP5mcc1 wnTLO9hWdO0NK1aslhqtHDUY2tKUVOdV2u3mmox3dxZWzLG6Q0fhpRpYmvUVdpOUaSuqV80pWW22 f0NMcMs7xwlt/Sdyd3pVOi+k8cq8sJjYR61Q1qdWCSjVimk9mV03y27C1GeJw8VKMoyhUhKGtTqR s9aMuD+fcYEwrXxG0iJsRtXYQlQAAdGzSnftMaWUpR3ZSXfe68VfvMKPrEkv4kfgn+aJNEoAOAAA PGjt6G044tU6sm4bFN7Y8pPeuficUHLNuy6fQgVzo1pJ3VCb3Pq2+Wbh4ZrkmWMys01l2AA46AAA AAPnNCTcIt7XFN9rV2XHozUTw0V7spr+6/1KdQi1CKe1RSfalZnW0DpFUajU3anO137klkm+XPd4 muU3GWN1VwPJOyvuQjJNXTTXFMrPSvT8IwlQpTTqyVpOLuqUd7bXtcu19ucm2tunHxFbXqTn78pP u3eVjA0qGJaahUWq/Ze6XK/E3TZgzoW6ynfZ1lO/4kfJsTpbBvE6Y+3Or9otP7PbW/iXbby37NuV kfVWir9Ieg+FxeI6+fWRqO2vqatqlvaaex8dvYa+POyXGZcd67/j513+/wCnNTfc23OgeJlPROFc 9qnXtyi1BtLlrN+J3SHCYaFOnCnCKjCEVGMVnZXb272222+ZK2uRzy5887l+bsk1JEOI3EJs1YXI HFrcTHWIBNTpXzYGVNJK7sstryseUs5OW61o887t9+XgMRsUfekl3Xu/ImJAAAAAAAAC7yadmmmn wad0/Eu+i8WqtGM99rSXCSyaKQdropiLVZ09046y5ONotd6a/Cyc50rC9rQADJqAAAAAKPpXD9Xi KkbZOTkuyTv87mqW3T2jXVgpR/iQvbdrLfD9OZUU/wBvK3Jo1xu4yymq5mIlJTmlKcYx1G1Gcor0 pRWxO3Exo0UpRg/VnBW7bXXg9b8SOjWoKUZLZrKza2h0ItQT9hxaezYUnaHB3s4TWcGrNrKS3NeB tNnp2OjmD1pSqtZR9GPN+1LuyXict07JtXNJ4+FGhOrL1YK+W/gkeaIxyr4elWScVUjezd7Z2a8i uf8A7RjUsTHC0/bVOpNL3neMYd9lLvLHobC9VhqNPfClBPtSz8yMc+WVn4ejyeGYeHHO+8rf8jcM ZxTVmrpmQNHmQqUo7byjxSu12r6mcasXslF96MyCnTi5TbjF+lbNJ7EgJk1yI6tTcraz2b7c3yPX Qh7se5WMoQS2JIDGFOzu22+L+SW4kAAAAAAAAAAGzoupq4ii/wD2JfivF+TNY9jKzi+Eo/NC+ie3 0EAGDcAAAAADjaZ0Iql507Rqb09lTt4PmdkxnNLa0lzdhLos2oNSEoycZRcZLdJWf+UYlzxv2eot WcVUtn6MW2uaa+hxK2gG5Lq5SjC+fXJSaXCOq0/xeJpM2dwcqhRlOahH1peS3yfJFvhBUqcYRV7K 0V7z/ebIMHhadBasbzqS275S/wCqN/D0HfXlbXtsWyC91fV7ycrtWOOnyDSnQvE/61VxGIcqlHXj OE7X6x29GnZbNW3ki1fZKtr9VWtx6uVu0voOY/8APpp5c8vLrl8mo+eJnpZtLaBU250tWM360XlG fPk/mVvGUalKSjOnNNq6tZp997Gsylee42MJSSTb2JEeHXo3e1tvx3eB5qSl61lFeze9+1/QmOuA AAAAAAAAAAAGE52cVvb+l2/3xAzI68rRbSu1sWeeewkNvRFHXxNJZ5S1nbco537L2XeL6J7dvR/S OE3q1I9W27J62tF8m7Jxfau87hyNM6GhUi5QSjVSezJT+7Jb+3aiHotjXOnKnJ3dO2q3t1XeyfNN NdljH9xtPxXdABx0AAEdenrRcdaUbrbF2a7GasNH22Om+cqV2+162bN4Aa32eezXil92nZ+ba8jx YNe1OrLPfJQ/IlddptADClSjFWjFJclYzAAAAAaOmNHqtStkpxzg3x4Pk9hvAD57vaas02muDW1A 6HSjBuniOtisqsbyS3uOTa52t4HNhJNXWaNpdxjZqsgR05u8k9qfk9jJDrgAeXA9AAAAACGGc29y 9FfN/TwMq07LL1nkv17EZU4WSXDz5gZFj6K4O0ZVntn6MfhTzfe/yo4WBwrq1Y01fPOTXsxW1/Tt aL1TpqMVFKySSS4JEZ34vCfWTZVuisb16s0rJQat8U7r8r8TuaZr6mHqy36rS7XkvmanRbD6uGUt 9STl3ZRj/ak+9kfF/XYABx0AAAAAAAAAAAAAAAByOk9DWw+tbOnKL7m9WXdZ37inyptPWjt3rdLn yZ9Ax1HXo1YPZOnOPjFooVOV4p8Un4o0wZ5oHUWtGSyaajJPalLJedvFmyQYukpReWaTs9jXeTRd 0nxRaHpFW2wf3reKsSkOKfoN8Gn5gTAxdSPGPiiJYuG5t/DGUvkgJzGpNJXf/wB5Ij6yT2Qa5ysv JGOGg3eUnrS1pJZWsk7WS7gM6UHfWlte73VwJGz03tCYXrMRFP1YenLnZ+ivHP8ApYt0Sbd/o/o/ qqWtJf8AJUs5cluj3fNs6oBg3cLpfUaoQivbqpeEZSXmkdjC0lGnCKyUYxXgjj9L6bdGE17FVN98 ZRXm0dfDV4yhCSatKKaz23R3459TAA46Ah+10v5lP8cf1AEwAAAAAAAAAAAADGckk29iTPndD1I/ DH5Fq6S6RUYOjF+nUjaX3YvJ972IrJphGedRYl2hP4ZfIzpxtFLgkvIwxGerH3pLwXpP5W7yUtAF tj8cPzIHtOLcopb5w/MhSLrpeqo4eq/uSXirL5lIRZOlmI9GnT3ylrPsj/lorhGE6XnewhwvqLtl +ZmdWdot8F4vcvEUYasYrhFLwRaGZYOiMV/zPfeC7rN/VlfO30Tq2qVYX9aMZLnZ2fzj4k5elY+1 nABk1RYuip05xaT1oyWfNHz1U4q10lK9s0k7rzufRzj6V0BCq9eLUKl7+qpRk+LjxKxuk5Tbk4HT tamtWVqkVs1naS5a2/vJftuIxUuqjanTfruDd1HenLc3wR0MLoClqrrIxct+o5xi+5tvzOrh6EIR 1YRjGPBK3f2i2fCStP8A0TC/yKP4EDoAlQAAAAAAAAAAAAAruktBydSrVSVbXT9GUtWUXq2tFvLh ttbicWeAnCknONZVVqXThLVzaTV0tV5Z3TL4DsyqbjHziC1q0U24rZd5WVnKT8I27TZ0jCnDVcGr O6au3bK6l8y+tBRXBHeTnBRq2FioJwlKc8sleWvxslvNrRWjK0qtOTpzjCMk25rV2btV559hcAOV d4xV9NUIyxc3UuoqnTjC94qWcm5J77a1jmaMownrubjJRk4q7te3t990XpoieEpP/wAdP8Ef0ObL i+e4tKNTU1rxi73ve6Sur/vcbk8HJUlUb3Jyjb1V28Vv7y7LC07NdXTs9q1I2fca9TRGHle9KDur PbmuFiubnBUsPgpzg5qSW3VVvWtlm92Z7oivq4ijLNXmotcdf0NV9jaf9JbI6Hw6VlSilwV/1MsP ouhB3hShF3228xyOLcABCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH// 2Q== \"/></p> <p> </p> <p style=\"margin-top: 0; margin-bottom: 0;\">See Picture. What is animal name?</p>', '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\">Elephant, (family Elephantidae), largest living land animal, characterized by its long trunk (elongated upper lip and nose)</p>', 0, 0, 0, 'MCQ02', 'CMA', 1, '0', '2023-02-16 15:06:01', '2023-02-16 04:06:01'),
(3, 0, 2, 'true_false', 0, NULL, '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\"><img border=\"0\" style=\"width: 225px; height: 225px;\" src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxATDhASExANEhASEA8YFhURDxIQGBIZFxIWFhYR GBUYHSggGRolGxgXITEhJSkrLi4uFx8zODMtNyotLisBCgoKDg0OGxAQGisdHyEtLy0tLS0tNy0t LS0tLS0tLS4tLy0tLSstLS0tLS4tLy0tLS0tLTAtLS0tLS0tLS0tNP/AABEIAOEA4QMBIgACEQED EQH/xAAbAAEAAgMBAQAAAAAAAAAAAAAAAwYCBAUBB//EAEAQAAIBAgIGBgcGBQQDAQAAAAABAgMR BCEFEjFBUWEGE3GBkaEiMkJScrHBFGKSstHwM1OCouEVFiPSQ2PxB//EABgBAQEBAQEAAAAAAAAA AAAAAAACAwEE/8QAIhEBAQACAgMAAgMBAAAAAAAAAAECERIhAzFBUWFxgZEi/9oADAMBAAIRAxEA PwD7iAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAADyUkldtJcW7HkJpq6aa5O5q6Yw3WYepDK7jdXdleLUkm+F0il4LFSptTptq27YpcYtFS bTbp9ABHQqqcIzWyUU13q5ISoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHH6R4atUhFU84K7lF Ozlw7VyKonlyLrprFOnh5yTtJrVjylLJPu29xT8DhOsqU6SulJ2dvZivWfhl2tGmF6Z5ztcdCxth qXwJ+OaN08ikkkskj0zaABXekOlWm6NN2ftyW77i58Xu+XZNuW6bWk9PQptxgusmtudox7XvfJHC raXxEnnVa5QSgv8At5mikemkxkZ3K1tQ0liFsrVO9qf5kzo4TpJNZVYRkvep3i12xbd+59xxCOrC 9l7O/ny7Dtxjkyqw6Q6R3VqFrNfxGvyxe/m8uTOPUxVWTvKrVb+OS8lku4hk0kQSrPcJjC5WuhS0 hXi/RrVe+WuvCV0dXCdJmv40Lr3qSfnBtvwb7isqs/2iWFW4uEJlYtX+6KLV4xqyXwpfNnn+5qf8 qt/Z+pVKkGnrR27173+SSEk0mtjOcI7zq0x6S0d8Ky/pT+TJqfSDDvbKUfihJFSA4R3nV7oYylP1 akJN7lJX8NpOfPHFcEb2E0tXp7JuUfdqXku6XrLxtyJuDszXUHL0bpynUai/+Oo/Zk8n8L3nUIWA AAAAAAAAACtdK8ReVOnwTk/kvqZdE8P/ABKj5QXzl9PA5Ok62viKsvvuK7Iej80/EsvRqKWFg/ec 2/xNfQu9YoneTqAAhbT0rjOqoynv2RXGTyX75FJz3tttttve3tZ2OlGJ1q0afs01d/FJfSP5mcc1 wnTLO9hWdO0NK1aslhqtHDUY2tKUVOdV2u3mmox3dxZWzLG6Q0fhpRpYmvUVdpOUaSuqV80pWW22 f0NMcMs7xwlt/Sdyd3pVOi+k8cq8sJjYR61Q1qdWCSjVimk9mV03y27C1GeJw8VKMoyhUhKGtTqR s9aMuD+fcYEwrXxG0iJsRtXYQlQAAdGzSnftMaWUpR3ZSXfe68VfvMKPrEkv4kfgn+aJNEoAOAAA PGjt6G044tU6sm4bFN7Y8pPeuficUHLNuy6fQgVzo1pJ3VCb3Pq2+Wbh4ZrkmWMys01l2AA46AAA AAPnNCTcIt7XFN9rV2XHozUTw0V7spr+6/1KdQi1CKe1RSfalZnW0DpFUajU3anO137klkm+XPd4 muU3GWN1VwPJOyvuQjJNXTTXFMrPSvT8IwlQpTTqyVpOLuqUd7bXtcu19ucm2tunHxFbXqTn78pP u3eVjA0qGJaahUWq/Ze6XK/E3TZgzoW6ynfZ1lO/4kfJsTpbBvE6Y+3Or9otP7PbW/iXbby37NuV kfVWir9Ieg+FxeI6+fWRqO2vqatqlvaaex8dvYa+POyXGZcd67/j513+/wCnNTfc23OgeJlPROFc 9qnXtyi1BtLlrN+J3SHCYaFOnCnCKjCEVGMVnZXb272222+ZK2uRzy5887l+bsk1JEOI3EJs1YXI HFrcTHWIBNTpXzYGVNJK7sstryseUs5OW61o887t9+XgMRsUfekl3Xu/ImJAAAAAAAAC7yadmmmn wad0/Eu+i8WqtGM99rSXCSyaKQdropiLVZ09046y5ONotd6a/Cyc50rC9rQADJqAAAAAKPpXD9Xi KkbZOTkuyTv87mqW3T2jXVgpR/iQvbdrLfD9OZUU/wBvK3Jo1xu4yymq5mIlJTmlKcYx1G1Gcor0 pRWxO3Exo0UpRg/VnBW7bXXg9b8SOjWoKUZLZrKza2h0ItQT9hxaezYUnaHB3s4TWcGrNrKS3NeB tNnp2OjmD1pSqtZR9GPN+1LuyXict07JtXNJ4+FGhOrL1YK+W/gkeaIxyr4elWScVUjezd7Z2a8i uf8A7RjUsTHC0/bVOpNL3neMYd9lLvLHobC9VhqNPfClBPtSz8yMc+WVn4ejyeGYeHHO+8rf8jcM ZxTVmrpmQNHmQqUo7byjxSu12r6mcasXslF96MyCnTi5TbjF+lbNJ7EgJk1yI6tTcraz2b7c3yPX Qh7se5WMoQS2JIDGFOzu22+L+SW4kAAAAAAAAAAGzoupq4ii/wD2JfivF+TNY9jKzi+Eo/NC+ie3 0EAGDcAAAAADjaZ0Iql507Rqb09lTt4PmdkxnNLa0lzdhLos2oNSEoycZRcZLdJWf+UYlzxv2eot WcVUtn6MW2uaa+hxK2gG5Lq5SjC+fXJSaXCOq0/xeJpM2dwcqhRlOahH1peS3yfJFvhBUqcYRV7K 0V7z/ebIMHhadBasbzqS275S/wCqN/D0HfXlbXtsWyC91fV7ycrtWOOnyDSnQvE/61VxGIcqlHXj OE7X6x29GnZbNW3ki1fZKtr9VWtx6uVu0voOY/8APpp5c8vLrl8mo+eJnpZtLaBU250tWM360XlG fPk/mVvGUalKSjOnNNq6tZp997Gsylee42MJSSTb2JEeHXo3e1tvx3eB5qSl61lFeze9+1/QmOuA AAAAAAAAAAAGE52cVvb+l2/3xAzI68rRbSu1sWeeewkNvRFHXxNJZ5S1nbco537L2XeL6J7dvR/S OE3q1I9W27J62tF8m7Jxfau87hyNM6GhUi5QSjVSezJT+7Jb+3aiHotjXOnKnJ3dO2q3t1XeyfNN NdljH9xtPxXdABx0AAEdenrRcdaUbrbF2a7GasNH22Om+cqV2+162bN4Aa32eezXil92nZ+ba8jx YNe1OrLPfJQ/IlddptADClSjFWjFJclYzAAAAAaOmNHqtStkpxzg3x4Pk9hvAD57vaas02muDW1A 6HSjBuniOtisqsbyS3uOTa52t4HNhJNXWaNpdxjZqsgR05u8k9qfk9jJDrgAeXA9AAAAACGGc29y 9FfN/TwMq07LL1nkv17EZU4WSXDz5gZFj6K4O0ZVntn6MfhTzfe/yo4WBwrq1Y01fPOTXsxW1/Tt aL1TpqMVFKySSS4JEZ34vCfWTZVuisb16s0rJQat8U7r8r8TuaZr6mHqy36rS7XkvmanRbD6uGUt 9STl3ZRj/ak+9kfF/XYABx0AAAAAAAAAAAAAAAByOk9DWw+tbOnKL7m9WXdZ37inyptPWjt3rdLn yZ9Ax1HXo1YPZOnOPjFooVOV4p8Un4o0wZ5oHUWtGSyaajJPalLJedvFmyQYukpReWaTs9jXeTRd 0nxRaHpFW2wf3reKsSkOKfoN8Gn5gTAxdSPGPiiJYuG5t/DGUvkgJzGpNJXf/wB5Ij6yT2Qa5ysv JGOGg3eUnrS1pJZWsk7WS7gM6UHfWlte73VwJGz03tCYXrMRFP1YenLnZ+ivHP8ApYt0Sbd/o/o/ qqWtJf8AJUs5cluj3fNs6oBg3cLpfUaoQivbqpeEZSXmkdjC0lGnCKyUYxXgjj9L6bdGE17FVN98 ZRXm0dfDV4yhCSatKKaz23R3459TAA46Ah+10v5lP8cf1AEwAAAAAAAAAAAADGckk29iTPndD1I/ DH5Fq6S6RUYOjF+nUjaX3YvJ972IrJphGedRYl2hP4ZfIzpxtFLgkvIwxGerH3pLwXpP5W7yUtAF tj8cPzIHtOLcopb5w/MhSLrpeqo4eq/uSXirL5lIRZOlmI9GnT3ylrPsj/lorhGE6XnewhwvqLtl +ZmdWdot8F4vcvEUYasYrhFLwRaGZYOiMV/zPfeC7rN/VlfO30Tq2qVYX9aMZLnZ2fzj4k5elY+1 nABk1RYuip05xaT1oyWfNHz1U4q10lK9s0k7rzufRzj6V0BCq9eLUKl7+qpRk+LjxKxuk5Tbk4HT tamtWVqkVs1naS5a2/vJftuIxUuqjanTfruDd1HenLc3wR0MLoClqrrIxct+o5xi+5tvzOrh6EIR 1YRjGPBK3f2i2fCStP8A0TC/yKP4EDoAlQAAAAAAAAAAAAAruktBydSrVSVbXT9GUtWUXq2tFvLh ttbicWeAnCknONZVVqXThLVzaTV0tV5Z3TL4DsyqbjHziC1q0U24rZd5WVnKT8I27TZ0jCnDVcGr O6au3bK6l8y+tBRXBHeTnBRq2FioJwlKc8sleWvxslvNrRWjK0qtOTpzjCMk25rV2btV559hcAOV d4xV9NUIyxc3UuoqnTjC94qWcm5J77a1jmaMownrubjJRk4q7te3t990XpoieEpP/wAdP8Ef0ObL i+e4tKNTU1rxi73ve6Sur/vcbk8HJUlUb3Jyjb1V28Vv7y7LC07NdXTs9q1I2fca9TRGHle9KDur PbmuFiubnBUsPgpzg5qSW3VVvWtlm92Z7oivq4ijLNXmotcdf0NV9jaf9JbI6Hw6VlSilwV/1MsP ouhB3hShF3228xyOLcABCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH// 2Q== \"/></p> <p> </p> <p style=\"margin-top: 0; margin-bottom: 0;\">See Picture. What is animal name?</p>', '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\">Elephant, (family Elephantidae), largest living land animal, characterized by its long trunk (elongated upper lip and nose)</p>', 0, 0, 0, 'MCQ03', 'CMA', 1, '0', '2023-02-16 15:06:01', '2023-02-16 04:06:01'),
(4, 0, 2, 'fill', 0, NULL, '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\"><img border=\"0\" style=\"width: 225px; height: 225px;\" src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxATDhASExANEhASEA8YFhURDxIQGBIZFxIWFhYR GBUYHSggGRolGxgXITEhJSkrLi4uFx8zODMtNyotLisBCgoKDg0OGxAQGisdHyEtLy0tLS0tNy0t LS0tLS0tLS4tLy0tLSstLS0tLS4tLy0tLS0tLTAtLS0tLS0tLS0tNP/AABEIAOEA4QMBIgACEQED EQH/xAAbAAEAAgMBAQAAAAAAAAAAAAAAAwYCBAUBB//EAEAQAAIBAgIGBgcGBQQDAQAAAAABAgMR BCEFEjFBUWEGE3GBkaEiMkJScrHBFGKSstHwM1OCouEVFiPSQ2PxB//EABgBAQEBAQEAAAAAAAAA AAAAAAACAwEE/8QAIhEBAQACAgMAAgMBAAAAAAAAAAECERIhAzFBUWFxgZEi/9oADAMBAAIRAxEA PwD7iAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAADyUkldtJcW7HkJpq6aa5O5q6Yw3WYepDK7jdXdleLUkm+F0il4LFSptTptq27YpcYtFS bTbp9ABHQqqcIzWyUU13q5ISoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHH6R4atUhFU84K7lF Ozlw7VyKonlyLrprFOnh5yTtJrVjylLJPu29xT8DhOsqU6SulJ2dvZivWfhl2tGmF6Z5ztcdCxth qXwJ+OaN08ikkkskj0zaABXekOlWm6NN2ftyW77i58Xu+XZNuW6bWk9PQptxgusmtudox7XvfJHC raXxEnnVa5QSgv8At5mikemkxkZ3K1tQ0liFsrVO9qf5kzo4TpJNZVYRkvep3i12xbd+59xxCOrC 9l7O/ny7Dtxjkyqw6Q6R3VqFrNfxGvyxe/m8uTOPUxVWTvKrVb+OS8lku4hk0kQSrPcJjC5WuhS0 hXi/RrVe+WuvCV0dXCdJmv40Lr3qSfnBtvwb7isqs/2iWFW4uEJlYtX+6KLV4xqyXwpfNnn+5qf8 qt/Z+pVKkGnrR27173+SSEk0mtjOcI7zq0x6S0d8Ky/pT+TJqfSDDvbKUfihJFSA4R3nV7oYylP1 akJN7lJX8NpOfPHFcEb2E0tXp7JuUfdqXku6XrLxtyJuDszXUHL0bpynUai/+Oo/Zk8n8L3nUIWA AAAAAAAAACtdK8ReVOnwTk/kvqZdE8P/ABKj5QXzl9PA5Ok62viKsvvuK7Iej80/EsvRqKWFg/ec 2/xNfQu9YoneTqAAhbT0rjOqoynv2RXGTyX75FJz3tttttve3tZ2OlGJ1q0afs01d/FJfSP5mcc1 wnTLO9hWdO0NK1aslhqtHDUY2tKUVOdV2u3mmox3dxZWzLG6Q0fhpRpYmvUVdpOUaSuqV80pWW22 f0NMcMs7xwlt/Sdyd3pVOi+k8cq8sJjYR61Q1qdWCSjVimk9mV03y27C1GeJw8VKMoyhUhKGtTqR s9aMuD+fcYEwrXxG0iJsRtXYQlQAAdGzSnftMaWUpR3ZSXfe68VfvMKPrEkv4kfgn+aJNEoAOAAA PGjt6G044tU6sm4bFN7Y8pPeuficUHLNuy6fQgVzo1pJ3VCb3Pq2+Wbh4ZrkmWMys01l2AA46AAA AAPnNCTcIt7XFN9rV2XHozUTw0V7spr+6/1KdQi1CKe1RSfalZnW0DpFUajU3anO137klkm+XPd4 muU3GWN1VwPJOyvuQjJNXTTXFMrPSvT8IwlQpTTqyVpOLuqUd7bXtcu19ucm2tunHxFbXqTn78pP u3eVjA0qGJaahUWq/Ze6XK/E3TZgzoW6ynfZ1lO/4kfJsTpbBvE6Y+3Or9otP7PbW/iXbby37NuV kfVWir9Ieg+FxeI6+fWRqO2vqatqlvaaex8dvYa+POyXGZcd67/j513+/wCnNTfc23OgeJlPROFc 9qnXtyi1BtLlrN+J3SHCYaFOnCnCKjCEVGMVnZXb272222+ZK2uRzy5887l+bsk1JEOI3EJs1YXI HFrcTHWIBNTpXzYGVNJK7sstryseUs5OW61o887t9+XgMRsUfekl3Xu/ImJAAAAAAAAC7yadmmmn wad0/Eu+i8WqtGM99rSXCSyaKQdropiLVZ09046y5ONotd6a/Cyc50rC9rQADJqAAAAAKPpXD9Xi KkbZOTkuyTv87mqW3T2jXVgpR/iQvbdrLfD9OZUU/wBvK3Jo1xu4yymq5mIlJTmlKcYx1G1Gcor0 pRWxO3Exo0UpRg/VnBW7bXXg9b8SOjWoKUZLZrKza2h0ItQT9hxaezYUnaHB3s4TWcGrNrKS3NeB tNnp2OjmD1pSqtZR9GPN+1LuyXict07JtXNJ4+FGhOrL1YK+W/gkeaIxyr4elWScVUjezd7Z2a8i uf8A7RjUsTHC0/bVOpNL3neMYd9lLvLHobC9VhqNPfClBPtSz8yMc+WVn4ejyeGYeHHO+8rf8jcM ZxTVmrpmQNHmQqUo7byjxSu12r6mcasXslF96MyCnTi5TbjF+lbNJ7EgJk1yI6tTcraz2b7c3yPX Qh7se5WMoQS2JIDGFOzu22+L+SW4kAAAAAAAAAAGzoupq4ii/wD2JfivF+TNY9jKzi+Eo/NC+ie3 0EAGDcAAAAADjaZ0Iql507Rqb09lTt4PmdkxnNLa0lzdhLos2oNSEoycZRcZLdJWf+UYlzxv2eot WcVUtn6MW2uaa+hxK2gG5Lq5SjC+fXJSaXCOq0/xeJpM2dwcqhRlOahH1peS3yfJFvhBUqcYRV7K 0V7z/ebIMHhadBasbzqS275S/wCqN/D0HfXlbXtsWyC91fV7ycrtWOOnyDSnQvE/61VxGIcqlHXj OE7X6x29GnZbNW3ki1fZKtr9VWtx6uVu0voOY/8APpp5c8vLrl8mo+eJnpZtLaBU250tWM360XlG fPk/mVvGUalKSjOnNNq6tZp997Gsylee42MJSSTb2JEeHXo3e1tvx3eB5qSl61lFeze9+1/QmOuA AAAAAAAAAAAGE52cVvb+l2/3xAzI68rRbSu1sWeeewkNvRFHXxNJZ5S1nbco537L2XeL6J7dvR/S OE3q1I9W27J62tF8m7Jxfau87hyNM6GhUi5QSjVSezJT+7Jb+3aiHotjXOnKnJ3dO2q3t1XeyfNN NdljH9xtPxXdABx0AAEdenrRcdaUbrbF2a7GasNH22Om+cqV2+162bN4Aa32eezXil92nZ+ba8jx YNe1OrLPfJQ/IlddptADClSjFWjFJclYzAAAAAaOmNHqtStkpxzg3x4Pk9hvAD57vaas02muDW1A 6HSjBuniOtisqsbyS3uOTa52t4HNhJNXWaNpdxjZqsgR05u8k9qfk9jJDrgAeXA9AAAAACGGc29y 9FfN/TwMq07LL1nkv17EZU4WSXDz5gZFj6K4O0ZVntn6MfhTzfe/yo4WBwrq1Y01fPOTXsxW1/Tt aL1TpqMVFKySSS4JEZ34vCfWTZVuisb16s0rJQat8U7r8r8TuaZr6mHqy36rS7XkvmanRbD6uGUt 9STl3ZRj/ak+9kfF/XYABx0AAAAAAAAAAAAAAAByOk9DWw+tbOnKL7m9WXdZ37inyptPWjt3rdLn yZ9Ax1HXo1YPZOnOPjFooVOV4p8Un4o0wZ5oHUWtGSyaajJPalLJedvFmyQYukpReWaTs9jXeTRd 0nxRaHpFW2wf3reKsSkOKfoN8Gn5gTAxdSPGPiiJYuG5t/DGUvkgJzGpNJXf/wB5Ij6yT2Qa5ysv JGOGg3eUnrS1pJZWsk7WS7gM6UHfWlte73VwJGz03tCYXrMRFP1YenLnZ+ivHP8ApYt0Sbd/o/o/ qqWtJf8AJUs5cluj3fNs6oBg3cLpfUaoQivbqpeEZSXmkdjC0lGnCKyUYxXgjj9L6bdGE17FVN98 ZRXm0dfDV4yhCSatKKaz23R3459TAA46Ah+10v5lP8cf1AEwAAAAAAAAAAAADGckk29iTPndD1I/ DH5Fq6S6RUYOjF+nUjaX3YvJ972IrJphGedRYl2hP4ZfIzpxtFLgkvIwxGerH3pLwXpP5W7yUtAF tj8cPzIHtOLcopb5w/MhSLrpeqo4eq/uSXirL5lIRZOlmI9GnT3ylrPsj/lorhGE6XnewhwvqLtl +ZmdWdot8F4vcvEUYasYrhFLwRaGZYOiMV/zPfeC7rN/VlfO30Tq2qVYX9aMZLnZ2fzj4k5elY+1 nABk1RYuip05xaT1oyWfNHz1U4q10lK9s0k7rzufRzj6V0BCq9eLUKl7+qpRk+LjxKxuk5Tbk4HT tamtWVqkVs1naS5a2/vJftuIxUuqjanTfruDd1HenLc3wR0MLoClqrrIxct+o5xi+5tvzOrh6EIR 1YRjGPBK3f2i2fCStP8A0TC/yKP4EDoAlQAAAAAAAAAAAAAruktBydSrVSVbXT9GUtWUXq2tFvLh ttbicWeAnCknONZVVqXThLVzaTV0tV5Z3TL4DsyqbjHziC1q0U24rZd5WVnKT8I27TZ0jCnDVcGr O6au3bK6l8y+tBRXBHeTnBRq2FioJwlKc8sleWvxslvNrRWjK0qtOTpzjCMk25rV2btV559hcAOV d4xV9NUIyxc3UuoqnTjC94qWcm5J77a1jmaMownrubjJRk4q7te3t990XpoieEpP/wAdP8Ef0ObL i+e4tKNTU1rxi73ve6Sur/vcbk8HJUlUb3Jyjb1V28Vv7y7LC07NdXTs9q1I2fca9TRGHle9KDur PbmuFiubnBUsPgpzg5qSW3VVvWtlm92Z7oivq4ijLNXmotcdf0NV9jaf9JbI6Hw6VlSilwV/1MsP ouhB3hShF3228xyOLcABCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH// 2Q== \"/></p> <p style=\"margin-top: 0; margin-bottom: 0;\">See Picture. What is animal name?</p>', '<p style=\"margin-top: 0; margin-bottom: 0;\"></p> <p style=\"margin-top: 0; margin-bottom: 0;\">Elephant, (family Elephantidae), largest living land animal, characterized by its long trunk (elongated upper lip and nose)</p>', 21, 0, 0, 'MCQ04', 'CMA', 1, '0', '2023-02-16 15:06:01', '2023-02-16 04:06:01');
-- --------------------------------------------------------
--
-- Table structure for table `mcq_questions_sub`
--
CREATE TABLE `mcq_questions_sub` (
`id` bigint(20) UNSIGNED NOT NULL,
`question_id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`type` enum('mcq','fill','true_false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'mcq',
`question` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`solution` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
`answer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'fill',
`min` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'fill',
`max` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'fill',
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tags` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`mark` int(3) UNSIGNED NOT NULL DEFAULT 1,
`penalty` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `mcq_ques_gps`
--
CREATE TABLE `mcq_ques_gps` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`mcq_id` int(11) NOT NULL,
`mcq_question_id` bigint(11) UNSIGNED NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `mcq_ques_gps`
--
INSERT INTO `mcq_ques_gps` (`id`, `admin_id`, `mcq_id`, `mcq_question_id`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 1, '2023-02-16 15:07:28', '2023-02-16 04:07:28'),
(2, 2, 1, 2, '2023-02-16 15:07:28', '2023-02-16 04:07:28'),
(3, 2, 1, 3, '2023-02-16 15:07:28', '2023-02-16 04:07:28'),
(4, 2, 1, 4, '2023-02-16 15:07:28', '2023-02-16 04:07:28');
-- --------------------------------------------------------
--
-- Table structure for table `mcq_user_answers`
--
CREATE TABLE `mcq_user_answers` (
`id` int(11) NOT NULL,
`mcq_id` int(11) NOT NULL,
`mcq_history_id` int(11) NOT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`question_id` int(11) NOT NULL,
`option_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`fill_answer` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL,
`migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE `notifications` (
`id` int(11) NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`notification` longtext COLLATE utf8_unicode_ci NOT NULL,
`product_id` int(10) UNSIGNED DEFAULT NULL,
`public` tinyint(1) NOT NULL DEFAULT 1,
`created_at` datetime DEFAULT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `orderproductgroups`
--
CREATE TABLE `orderproductgroups` (
`id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
`promo_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`billing_id` int(11) NOT NULL,
`tax_invoice_no` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`tax_amount` float NOT NULL,
`taxable_amount` float NOT NULL,
`total_amount` float NOT NULL,
`discount` float NOT NULL,
`cashback` float NOT NULL,
`product_mode` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`product_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`product_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`days` int(11) NOT NULL,
`views` float NOT NULL,
`start_date` date NOT NULL,
`expire_date` date NOT NULL,
`updgrade` enum('new','renew') COLLATE utf8_unicode_ci NOT NULL,
`expired` tinyint(1) NOT NULL DEFAULT 0,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `otpsessions`
--
CREATE TABLE `otpsessions` (
`id` int(11) NOT NULL,
`message_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`phone` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`otp` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `pdf_tests`
--
CREATE TABLE `pdf_tests` (
`id` int(11) NOT NULL,
`filename` text COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`etag` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`size` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'video',
`admin_id` int(11) NOT NULL,
`date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `pdf_tests`
--
INSERT INTO `pdf_tests` (`id`, `filename`, `path`, `etag`, `size`, `type`, `admin_id`, `date`, `created_at`, `updated_at`) VALUES
(22, 'GraveMistake.pdf', 'saas_test/GraveMistake.pdf', '45c5ce8c17c0efa5404a46362d4c59e3', '1118542', 'pdf', 2, '2023-02-21T11:32:07+0000', '2023-02-21 17:02:28', '2023-02-21 06:02:28'),
(23, 'QueenofAshes.pdf', 'saas_test/QueenofAshes.pdf', 'f5f95fd00ba4332e49d59fe54c293b4a', '1754650', 'pdf', 2, '2023-02-21T11:32:26+0000', '2023-02-21 17:02:28', '2023-02-21 06:02:28'),
(24, 'waterfall.pdf', 'saas_test/waterfall.pdf', '518523970edc8d5478dc9c4534cc6b57', '29274902', 'pdf', 2, '2023-02-17T08:00:58+0000', '2023-02-21 17:02:28', '2023-02-21 06:02:28');
-- --------------------------------------------------------
--
-- Table structure for table `prices`
--
CREATE TABLE `prices` (
`id` bigint(20) UNSIGNED NOT NULL,
`product_id` bigint(20) NOT NULL,
`mode` enum('online','offline','pendrive','google_drive') COLLATE utf8_unicode_ci NOT NULL,
`duration` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'in days',
`views` float NOT NULL,
`price` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`discount_percnt` int(11) DEFAULT 0 COMMENT 'percentage',
`max_discount` float DEFAULT 0 COMMENT 'amount',
`sort_order` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `prices`
--
INSERT INTO `prices` (`id`, `product_id`, `mode`, `duration`, `views`, `price`, `discount_percnt`, `max_discount`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 1, 'google_drive', '30', 1, '100', 0, 0, 1, '2023-02-17 05:25:00', '2023-02-17 05:25:00'),
(2, 2, 'online', '30', 10, '100', 0, 0, 2, '2023-02-28 13:43:26', '2023-02-28 13:43:26');
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE `products` (
`id` int(11) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`teacher_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('course','testseries','books') COLLATE utf8_unicode_ci NOT NULL,
`short_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`features` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sort_order` int(11) NOT NULL,
`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`id`, `admin_id`, `cat_id`, `teacher_id`, `name`, `type`, `short_desc`, `description`, `video_url`, `features`, `image`, `slug`, `sort_order`, `status`, `created_at`, `updated_at`) VALUES
(2, 2, 1, 27, 'HPE Demo Course', 'course', '<p>HPE Demo Course</p>', '<p>HPE Demo Course</p>', 'sdf', NULL, '1677591127205826513.jpg', 'hpe-demo-course', 1, '1', '2023-02-28 13:22:51', '2023-02-28 13:43:03');
-- --------------------------------------------------------
--
-- Table structure for table `product_promocodes`
--
CREATE TABLE `product_promocodes` (
`id` int(11) NOT NULL,
`promo_id` int(11) NOT NULL,
`product_id` int(11) UNSIGNED NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `promocodes`
--
CREATE TABLE `promocodes` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`discount_type` enum('flat','percentage') COLLATE utf8_unicode_ci NOT NULL,
`amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`limit_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`promo_for` enum('all_courses','selected_courses') COLLATE utf8_unicode_ci NOT NULL,
`promo_type` enum('1','2') COLLATE utf8_unicode_ci NOT NULL COMMENT '2-Multiple,1-OneTime',
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `revision_materials`
--
CREATE TABLE `revision_materials` (
`id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`sort` int(11) NOT NULL,
`chapters` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('material','revision') COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `revision_materials`
--
INSERT INTO `revision_materials` (`id`, `product_id`, `admin_id`, `sort`, `chapters`, `type`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 1, 'as', 'revision', '2023-02-17 16:22:37', '2023-02-17 05:22:37'),
(2, 1, 2, 1, 'as', 'material', '2023-02-17 16:23:00', '2023-02-17 05:23:00');
-- --------------------------------------------------------
--
-- Table structure for table `revision_material_files`
--
CREATE TABLE `revision_material_files` (
`id` int(11) NOT NULL,
`revision_material_id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`files_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `revision_material_files`
--
INSERT INTO `revision_material_files` (`id`, `revision_material_id`, `admin_id`, `file_name`, `files_url`, `type`, `created_at`, `updated_at`) VALUES
(1, 2, 2, 'API Docs', 'saas_public/api-document.pdf', 'pdf', '2023-02-17 16:23:57', '2023-02-17 05:23:57');
-- --------------------------------------------------------
--
-- Table structure for table `re_s3buckets`
--
CREATE TABLE `re_s3buckets` (
`id` int(11) NOT NULL,
`filename` text COLLATE utf8_unicode_ci NOT NULL,
`public_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`duration` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`etag` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`size` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'video',
`tags` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`admin_id` int(11) NOT NULL,
`date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `re_s3buckets`
--
INSERT INTO `re_s3buckets` (`id`, `filename`, `public_name`, `duration`, `path`, `etag`, `size`, `type`, `tags`, `admin_id`, `date`, `created_at`, `updated_at`) VALUES
(10, 'sample1.mp4', 'sample1', '60', 'saas_videos/sample1.mp4', '83db26208db5d7c83c51a28ae6407e7e', '10546624', 'video', '3 Basic Chapters', 2, '2023-02-28', '2023-02-28 18:22:43', '2023-02-28 12:52:53'),
(11, 'sample2.mp4', 'sample2', '120', 'saas_videos/sample2.mp4', 'b2d4d5622f406a92b99959741306197b', '10546625', 'video', '3 Basic Chapters', 2, '2023-02-28', '2023-02-28 18:22:43', '2023-02-28 12:52:53'),
(12, 'sample3.mp4', 'sample3', '60', 'saas_videos/sample3.mp4', 'da69aac727aa710d58541811eb038600', '10546626', 'video', '3 Basic Chapters', 2, '2023-02-28', '2023-02-28 18:22:43', '2023-02-28 12:52:53'),
(13, 'sample4.mp4', 'sample4', '120', 'saas_videos/sample4.mp4', '7a3625126f2a94f5f951b05706185a60', '10546627', 'video', '3 Basic Chapters', 2, '2023-02-28', '2023-02-28 18:22:43', '2023-02-28 12:52:53'),
(14, 'sample5.mp4', 'sample5', '60', 'saas_videos/sample5.mp4', 'dcff879562807351461d464a23537efa', '10546663', 'video', '3 Basic Chapters', 2, '2023-02-28', '2023-02-28 18:22:43', '2023-02-28 12:52:53'),
(15, 'sample6.mp4', 'sample6', '120', 'saas_videos/sample6.mp4', 'ce8f36de6c3487b1a4441f8da0d0287c', '10546654', 'video', '3 Basic Chapters', 2, '2023-02-28', '2023-02-28 18:22:43', '2023-02-28 12:52:53'),
(16, 'sample7.mp4', 'sample7', '60', 'saas_videos/sample7.mp4', '2e7189c3ef947f66ac2b0c6deb11bca5', '10546644', 'video', '3 Basic Chapters', 2, '2023-02-28', '2023-02-28 18:22:43', '2023-02-28 12:52:53');
-- --------------------------------------------------------
--
-- Table structure for table `s3buckets`
--
CREATE TABLE `s3buckets` (
`id` int(11) NOT NULL,
`filename` text COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`etag` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`size` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('video','pdf') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'video',
`admin_id` int(11) NOT NULL,
`date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `s3buckets`
--
INSERT INTO `s3buckets` (`id`, `filename`, `path`, `etag`, `size`, `type`, `admin_id`, `date`, `created_at`, `updated_at`) VALUES
(34, 'sample1.mp4', 'saas_videos/sample1.mp4', '83db26208db5d7c83c51a28ae6407e7e', '10546624', 'video', 2, '2023-02-28', '2023-02-28 18:20:04', '2023-02-28 12:50:04'),
(35, 'sample2.mp4', 'saas_videos/sample2.mp4', 'b2d4d5622f406a92b99959741306197b', '10546625', 'video', 2, '2023-02-28', '2023-02-28 18:20:04', '2023-02-28 12:50:04'),
(36, 'sample3.mp4', 'saas_videos/sample3.mp4', 'da69aac727aa710d58541811eb038600', '10546626', 'video', 2, '2023-02-28', '2023-02-28 18:20:04', '2023-02-28 12:50:04'),
(37, 'sample4.mp4', 'saas_videos/sample4.mp4', '7a3625126f2a94f5f951b05706185a60', '10546627', 'video', 2, '2023-02-28', '2023-02-28 18:20:04', '2023-02-28 12:50:04'),
(38, 'sample5.mp4', 'saas_videos/sample5.mp4', 'dcff879562807351461d464a23537efa', '10546663', 'video', 2, '2023-02-28', '2023-02-28 18:20:04', '2023-02-28 12:50:04'),
(39, 'sample6.mp4', 'saas_videos/sample6.mp4', 'ce8f36de6c3487b1a4441f8da0d0287c', '10546654', 'video', 2, '2023-02-28', '2023-02-28 18:20:04', '2023-02-28 12:50:04'),
(40, 'sample7.mp4', 'saas_videos/sample7.mp4', '2e7189c3ef947f66ac2b0c6deb11bca5', '10546644', 'video', 2, '2023-02-28', '2023-02-28 18:20:04', '2023-02-28 12:50:04');
-- --------------------------------------------------------
--
-- Table structure for table `schedule_live_products`
--
CREATE TABLE `schedule_live_products` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`studio_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`prod_id` int(11) NOT NULL,
`program_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`start_time` time NOT NULL,
`end_time` time NOT NULL,
`sort_order` int(11) DEFAULT NULL,
`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`sch_chat` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `student_test_uploads`
--
CREATE TABLE `student_test_uploads` (
`id` int(11) NOT NULL,
`student_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`image_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`etag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `studios`
--
CREATE TABLE `studios` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`std_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`std_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`embed` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`std_embed_video` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`std_rtmp_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`std_rtmp_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `subadmin_modules`
--
CREATE TABLE `subadmin_modules` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`module_id` int(11) NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `subadmin_modules`
--
INSERT INTO `subadmin_modules` (`id`, `admin_id`, `role_id`, `module_id`, `created_at`, `updated_at`) VALUES
(1, 2, 6, 4, '2021-08-09 09:01:03', '2022-02-08 00:50:41'),
(2, 2, 6, 9, '2021-08-09 09:01:03', '2022-02-08 00:50:41'),
(3, 2, 9, 6, '2021-08-25 13:27:21', '2022-02-08 00:50:41'),
(4, 2, 9, 8, '2021-08-25 13:27:21', '2022-02-08 00:50:41'),
(5, 2, 11, 8, '2021-08-25 13:30:08', '2022-02-08 00:50:41'),
(6, 2, 11, 8, '2021-08-25 13:30:09', '2022-02-08 00:50:41'),
(7, 2, 7, 9, '2021-10-27 12:07:46', '2022-02-08 00:50:41'),
(10, 2, 16, 9, '2021-10-27 12:19:30', '2022-02-08 00:50:41'),
(11, 2, 16, 9, '2021-10-27 12:20:07', '2022-02-08 00:50:41'),
(12, 2, 16, 9, '2021-10-27 12:24:03', '2022-02-08 00:50:41'),
(13, 2, 10, 18, '2021-11-16 08:27:46', '2022-02-08 00:50:41'),
(14, 2, 10, 9, '2021-11-16 08:31:44', '2022-02-08 00:50:41'),
(15, 2, 11, 8, '2022-01-16 15:39:02', '2022-02-08 00:50:41'),
(16, 2, 11, 13, '2022-01-16 15:39:02', '2022-02-08 00:50:41'),
(17, 2, 11, 16, '2022-01-16 15:39:02', '2022-02-08 00:50:41'),
(18, 2, 11, 17, '2022-01-16 15:39:02', '2022-02-08 00:50:41'),
(19, 2, 11, 18, '2022-01-16 15:39:02', '2022-02-08 00:50:41'),
(20, 2, 12, 13, '2022-01-17 10:09:42', '2022-02-08 00:50:41'),
(21, 2, 13, 9, '2023-02-17 16:04:48', '2023-02-17 05:04:48');
-- --------------------------------------------------------
--
-- Table structure for table `tags`
--
CREATE TABLE `tags` (
`id` int(11) NOT NULL,
`video_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`time` bigint(20) NOT NULL,
`sort_order` int(11) NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `upload_mcq_files`
--
CREATE TABLE `upload_mcq_files` (
`id` bigint(20) UNSIGNED NOT NULL,
`filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `upload_mcq_files`
--
INSERT INTO `upload_mcq_files` (`id`, `filename`, `created_at`, `updated_at`) VALUES
(1, 'C:\\xampp\\htdocs\\paras_edukrypt_saas/public/uploads/quiz/16765401601666373188.docx', '2023-02-16 04:06:00', '2023-02-16 04:06:00');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(20) UNSIGNED NOT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`admin_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`phone` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`fcm_token` text COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`profile_pics` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `user_unique_id`, `ip_address`, `admin_id`, `name`, `email`, `phone`, `fcm_token`, `password`, `remember_token`, `status`, `profile_pics`, `created_at`, `updated_at`) VALUES
(2, '167698873363f4d13d9fc82', '::1', 2, 'Vashu', 'vishal@theinteractive.in', '9911315020', NULL, '$2y$10$EBJMNcO3m/qPGuQ5IL.YiOF1qTpRZGVGuDYxkNz9EM7wa.6MsaThO', NULL, '1', '', '2023-02-21 08:42:13', '2023-02-21 08:42:13');
-- --------------------------------------------------------
--
-- Table structure for table `users_classroom_tb`
--
CREATE TABLE `users_classroom_tb` (
`id` int(11) UNSIGNED NOT NULL,
`admin_id` int(11) UNSIGNED NOT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'student',
`created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user_device_ids`
--
CREATE TABLE `user_device_ids` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`model_id` text COLLATE utf8_unicode_ci NOT NULL,
`model_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL,
`device_type` enum('android','windows','ios') COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `videotags`
--
CREATE TABLE `videotags` (
`id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`sort` int(11) NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `videotags`
--
INSERT INTO `videotags` (`id`, `name`, `sort`, `created_at`, `updated_at`) VALUES
(10, '3 Basic Chapters', 1, '2022-04-30 18:10:44', '2022-04-30 18:10:44'),
(13, 'CAF Bills of Exchange', 1, '2022-05-03 13:30:09', '2022-05-03 14:49:57'),
(23, 'B.Com. Mathematics', 1, '2022-05-25 12:16:24', '2022-05-25 12:16:24');
-- --------------------------------------------------------
--
-- Table structure for table `video_histories`
--
CREATE TABLE `video_histories` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`user_unique_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`session` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`product_id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`video_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`duration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `webhooks`
--
CREATE TABLE `webhooks` (
`id` int(11) NOT NULL,
`data` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `website_info`
--
CREATE TABLE `website_info` (
`id` int(11) NOT NULL,
`admin_id` int(11) NOT NULL,
`site_name` text COLLATE utf8_unicode_ci DEFAULT NULL,
`site_state` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`site_tax_percentage` int(11) NOT NULL,
`site_logo` text COLLATE utf8_unicode_ci DEFAULT NULL,
`site_favicon` text COLLATE utf8_unicode_ci DEFAULT NULL,
`site_meta_tag` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
`invoice_prefix` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`site_status` tinyint(1) NOT NULL DEFAULT 1,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `website_info`
--
INSERT INTO `website_info` (`id`, `admin_id`, `site_name`, `site_state`, `site_tax_percentage`, `site_logo`, `site_favicon`, `site_meta_tag`, `invoice_prefix`, `site_status`, `created_at`, `updated_at`) VALUES
(3, 2, 'Paras Institute', 'Haryana', 18, NULL, NULL, NULL, 'NAVI', 1, '2023-02-21 16:52:56', '2023-02-21 16:52:56');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `addresses`
--
ALTER TABLE `addresses`
ADD PRIMARY KEY (`id`),
ADD KEY `user_unique_id` (`user_unique_id`);
--
-- Indexes for table `admin_modules`
--
ALTER TABLE `admin_modules`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `admin_module_permissions`
--
ALTER TABLE `admin_module_permissions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `admin_roles`
--
ALTER TABLE `admin_roles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `admin_users`
--
ALTER TABLE `admin_users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `billings`
--
ALTER TABLE `billings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `contents`
--
ALTER TABLE `contents`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ebooks`
--
ALTER TABLE `ebooks`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `path` (`path`);
--
-- Indexes for table `ebooks_mapping`
--
ALTER TABLE `ebooks_mapping`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `email_logs`
--
ALTER TABLE `email_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `global_settings`
--
ALTER TABLE `global_settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `learn_revisions`
--
ALTER TABLE `learn_revisions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `learn_revision_files`
--
ALTER TABLE `learn_revision_files`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `main_categories`
--
ALTER TABLE `main_categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `materials`
--
ALTER TABLE `materials`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mcqs`
--
ALTER TABLE `mcqs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mcq_histories`
--
ALTER TABLE `mcq_histories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mcq_options`
--
ALTER TABLE `mcq_options`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mcq_questions`
--
ALTER TABLE `mcq_questions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mcq_questions_sub`
--
ALTER TABLE `mcq_questions_sub`
ADD PRIMARY KEY (`id`),
ADD KEY `question_id` (`question_id`);
--
-- Indexes for table `mcq_ques_gps`
--
ALTER TABLE `mcq_ques_gps`
ADD PRIMARY KEY (`id`),
ADD KEY `fkmcqid` (`mcq_question_id`);
--
-- Indexes for table `mcq_user_answers`
--
ALTER TABLE `mcq_user_answers`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_mcq_history_id` (`mcq_history_id`),
ADD KEY `fk_mcq_id` (`mcq_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
ADD UNIQUE KEY `id` (`id`);
--
-- Indexes for table `orderproductgroups`
--
ALTER TABLE `orderproductgroups`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `otpsessions`
--
ALTER TABLE `otpsessions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `message_id` (`message_id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`(191));
--
-- Indexes for table `pdf_tests`
--
ALTER TABLE `pdf_tests`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `path` (`path`);
--
-- Indexes for table `prices`
--
ALTER TABLE `prices`
ADD PRIMARY KEY (`id`),
ADD KEY `product_id` (`product_id`);
--
-- Indexes for table `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `product_promocodes`
--
ALTER TABLE `product_promocodes`
ADD PRIMARY KEY (`id`),
ADD KEY `promo_id_fkey` (`promo_id`),
ADD KEY `product_id` (`product_id`);
--
-- Indexes for table `promocodes`
--
ALTER TABLE `promocodes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `revision_materials`
--
ALTER TABLE `revision_materials`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `revision_material_files`
--
ALTER TABLE `revision_material_files`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `re_s3buckets`
--
ALTER TABLE `re_s3buckets`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `etag` (`etag`);
--
-- Indexes for table `s3buckets`
--
ALTER TABLE `s3buckets`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `schedule_live_products`
--
ALTER TABLE `schedule_live_products`
ADD PRIMARY KEY (`id`),
ADD KEY `studio_fkey` (`studio_id`);
--
-- Indexes for table `student_test_uploads`
--
ALTER TABLE `student_test_uploads`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `studios`
--
ALTER TABLE `studios`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `std_id` (`std_id`);
--
-- Indexes for table `subadmin_modules`
--
ALTER TABLE `subadmin_modules`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `upload_mcq_files`
--
ALTER TABLE `upload_mcq_files`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `user_unique_id` (`user_unique_id`);
--
-- Indexes for table `users_classroom_tb`
--
ALTER TABLE `users_classroom_tb`
ADD PRIMARY KEY (`id`),
ADD KEY `user_id` (`user_unique_id`);
--
-- Indexes for table `user_device_ids`
--
ALTER TABLE `user_device_ids`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `videotags`
--
ALTER TABLE `videotags`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `video_histories`
--
ALTER TABLE `video_histories`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `session` (`session`);
--
-- Indexes for table `webhooks`
--
ALTER TABLE `webhooks`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `website_info`
--
ALTER TABLE `website_info`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `addresses`
--
ALTER TABLE `addresses`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `admin_modules`
--
ALTER TABLE `admin_modules`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `admin_module_permissions`
--
ALTER TABLE `admin_module_permissions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
--
-- AUTO_INCREMENT for table `admin_roles`
--
ALTER TABLE `admin_roles`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `admin_users`
--
ALTER TABLE `admin_users`
MODIFY `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `billings`
--
ALTER TABLE `billings`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `ebooks`
--
ALTER TABLE `ebooks`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `ebooks_mapping`
--
ALTER TABLE `ebooks_mapping`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `email_logs`
--
ALTER TABLE `email_logs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `global_settings`
--
ALTER TABLE `global_settings`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `learn_revisions`
--
ALTER TABLE `learn_revisions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `learn_revision_files`
--
ALTER TABLE `learn_revision_files`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `main_categories`
--
ALTER TABLE `main_categories`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `materials`
--
ALTER TABLE `materials`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `mcqs`
--
ALTER TABLE `mcqs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mcq_histories`
--
ALTER TABLE `mcq_histories`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mcq_options`
--
ALTER TABLE `mcq_options`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `mcq_questions`
--
ALTER TABLE `mcq_questions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `mcq_questions_sub`
--
ALTER TABLE `mcq_questions_sub`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mcq_ques_gps`
--
ALTER TABLE `mcq_ques_gps`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `mcq_user_answers`
--
ALTER TABLE `mcq_user_answers`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `orderproductgroups`
--
ALTER TABLE `orderproductgroups`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `otpsessions`
--
ALTER TABLE `otpsessions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pdf_tests`
--
ALTER TABLE `pdf_tests`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `prices`
--
ALTER TABLE `prices`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `product_promocodes`
--
ALTER TABLE `product_promocodes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `promocodes`
--
ALTER TABLE `promocodes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `revision_materials`
--
ALTER TABLE `revision_materials`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `revision_material_files`
--
ALTER TABLE `revision_material_files`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `re_s3buckets`
--
ALTER TABLE `re_s3buckets`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `s3buckets`
--
ALTER TABLE `s3buckets`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `schedule_live_products`
--
ALTER TABLE `schedule_live_products`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `student_test_uploads`
--
ALTER TABLE `student_test_uploads`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `studios`
--
ALTER TABLE `studios`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `subadmin_modules`
--
ALTER TABLE `subadmin_modules`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `upload_mcq_files`
--
ALTER TABLE `upload_mcq_files`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `users_classroom_tb`
--
ALTER TABLE `users_classroom_tb`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_device_ids`
--
ALTER TABLE `user_device_ids`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `videotags`
--
ALTER TABLE `videotags`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `video_histories`
--
ALTER TABLE `video_histories`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `webhooks`
--
ALTER TABLE `webhooks`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `website_info`
--
ALTER TABLE `website_info`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `mcq_questions_sub`
--
ALTER TABLE `mcq_questions_sub`
ADD CONSTRAINT `fk_parent_qid` FOREIGN KEY (`question_id`) REFERENCES `mcq_questions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `mcq_ques_gps`
--
ALTER TABLE `mcq_ques_gps`
ADD CONSTRAINT `fkmcqid` FOREIGN KEY (`mcq_question_id`) REFERENCES `mcq_questions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `mcq_user_answers`
--
ALTER TABLE `mcq_user_answers`
ADD CONSTRAINT `fk_mcq_history_id` FOREIGN KEY (`mcq_history_id`) REFERENCES `mcq_histories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `fk_mcq_id` FOREIGN KEY (`mcq_id`) REFERENCES `mcqs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `product_promocodes`
--
ALTER TABLE `product_promocodes`
ADD CONSTRAINT `product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `promo_id_fkey` FOREIGN KEY (`promo_id`) REFERENCES `promocodes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;