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

START TRANSACTION;



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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `category_name`, `created_at`, `updated_at`) VALUES
(1, 'Press Releases', '2025-02-21 01:11:54', '2025-03-06 12:20:02'),
(2, 'Interviews', '2025-02-21 01:16:14', '2025-02-21 01:16:14'),
(4, 'Seminars', '2025-02-21 01:26:06', '2025-02-21 01:26:06'),
(5, 'Press Conference', '2025-02-21 01:28:48', '2025-02-21 01:28:48'),
(6, 'Current Events', '2025-02-21 10:22:49', '2025-02-21 10:22:49'),
(7, 'Test', '2025-02-21 12:01:13', '2025-03-06 06:20:06'),
(8, 'Economy', '2025-02-25 13:27:02', '2025-02-25 13:27:45'),
(9, 'Sports', '2025-03-06 06:21:02', '2025-03-06 06:21:02');

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

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

CREATE TABLE `contact_us` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `subject` text DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `last_name`, `mobile_no`, `country`, `email`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(1, 'Illiana Jefferson', NULL, NULL, NULL, 'mebapyre@mailinator.com', 'Consequatur temporib', 'Velit velit culpa s', '2024-04-30 04:25:40', '2024-04-30 04:25:40'),
(2, 'Aimee Maynard', NULL, NULL, NULL, 'cifuwo@mailinator.com', 'Et aliqua Aut proid', 'Id dicta reiciendis', '2024-04-30 04:25:57', '2024-04-30 04:25:57'),
(3, 'Cameron Atkins', NULL, NULL, NULL, 'hucures@mailinator.com', 'Vitae fugiat vitae a', 'Molestiae amet blan', '2024-04-30 04:31:23', '2024-04-30 04:31:23'),
(4, 'Connor Rich', NULL, NULL, NULL, 'qupelulomo@mailinator.com', 'Mollitia in modi fug', 'Id aut elit et cons', '2024-04-30 04:32:00', '2024-04-30 04:32:00'),
(5, 'Shaine Taylor', NULL, NULL, NULL, 'mylovigo@mailinator.com', 'Sapiente impedit es', 'Nam nemo deserunt ap', '2024-05-01 06:50:54', '2024-05-01 06:50:54'),
(6, 'Regan James', NULL, NULL, NULL, 'bovipawyso@mailinator.com', 'In iste vitae velit', 'Quibusdam doloribus', '2024-05-01 07:32:08', '2024-05-01 07:32:08'),
(7, 'Desirae Rosa', NULL, NULL, NULL, 'rypir@mailinator.com', 'Reiciendis aut beata', 'Voluptate veritatis', '2024-06-11 16:18:15', '2024-06-11 16:18:15'),
(8, 'Desirae Rosa', NULL, NULL, NULL, 'rypir@mailinator.com', 'Reiciendis aut beata', 'Voluptate veritatis', '2024-06-11 16:18:15', '2024-06-11 16:18:15');

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

--
-- Table structure for table `contests`
--

CREATE TABLE `contests` (
  `id` int(10) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(5,2) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `contest_on` date DEFAULT NULL,
  `contest_no` varchar(255) DEFAULT NULL,
  `overview` text DEFAULT NULL,
  `specifications` text DEFAULT NULL,
  `price_type` varchar(255) DEFAULT NULL,
  `contest_end` date DEFAULT NULL,
  `draw_date` datetime DEFAULT NULL,
  `winning_amount` decimal(12,2) DEFAULT NULL,
  `price_delivery` varchar(250) DEFAULT NULL,
  `sort` varchar(255) DEFAULT NULL,
  `featured` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `competition_details` text DEFAULT NULL,
  `contest_number` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contests`
--

INSERT INTO `contests` (`id`, `slug`, `title`, `description`, `price`, `qty`, `contest_on`, `contest_no`, `overview`, `specifications`, `price_type`, `contest_end`, `draw_date`, `winning_amount`, `price_delivery`, `sort`, `featured`, `created_at`, `updated_at`, `deleted_at`, `competition_details`, `contest_number`) VALUES
(1, 'donovan-rosario', 'Donovan Rosario', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis sed ex eget mi sollicitudin consequat. Sed rhoncus ligula vel justo dignissim aliquam. Maecenas non est vitae ipsum luctus feugiat. Fusce purus nunc, sodales at condimentum sed, ullamcorper a nulla. Nam justo est, venenatis quis tellus in, volutpat eleifend nunc. Vestibulum congue laoreet mi non interdum. Ut ut dapibus tellus.', 151.00, 742, '2024-12-25', 'SHD9E', NULL, NULL, 'Cash Prize', '2024-12-30', '2024-12-31 19:20:08', 1500.00, 'Sample Test 1234', NULL, 1, '2024-05-01 03:22:08', '2024-12-23 05:55:15', NULL, '<p>Have a question or need help? Contact our friendly support team.</p>', 'SHD9E'),
(2, 'isabelle-hensley', 'Isabelle Hensley', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis sed ex eget mi sollicitudin consequat. Sed rhoncus ligula vel justo dignissim aliquam. Maecenas non est vitae ipsum luctus feugiat. Fusce purus nunc, sodales at condimentum sed, ullamcorper a nulla. Nam justo est, venenatis quis tellus in, volutpat eleifend nunc. Vestibulum congue laoreet mi non interdum. Ut ut dapibus tellus.', 0.50, 799, '2024-07-05', 'SDE0', NULL, NULL, 'Technology', '2024-12-19', '2024-12-20 14:55:05', NULL, NULL, NULL, 0, '2024-05-01 03:23:52', '2024-12-06 13:52:57', NULL, '<p>Have a question or need help? Contact our friendly support team.</p>', 'SDE0'),
(3, 'colt-boyer', 'Colt Boyer', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis sed ex eget mi sollicitudin consequat. Sed rhoncus ligula vel justo dignissim aliquam. Maecenas non est vitae ipsum luctus feugiat. Fusce purus nunc, sodales at condimentum sed, ullamcorper a nulla. Nam justo est, venenatis quis tellus in, volutpat eleifend nunc. Vestibulum congue laoreet mi non interdum. Ut ut dapibus tellus.', 60.00, 865, '2024-11-16', 'S7D9', NULL, NULL, 'Sports', '2024-11-20', '2024-11-20 02:01:00', NULL, NULL, NULL, 0, '2024-05-01 03:25:04', '2024-11-18 12:45:14', NULL, '<p>Have a question or need help? Contact our friendly support team.</p>', 'S7D9'),
(4, 'herman-hodge', 'Herman Hodge', NULL, 15.30, 100, '2024-11-10', 'SDE4', NULL, NULL, 'Cash Prize', '2024-12-16', '2024-12-20 00:00:00', 8976.00, NULL, NULL, 1, '2024-05-01 04:19:25', '2024-12-06 13:52:40', NULL, '<p>Herman Hodge demo</p>', 'SDE4'),
(5, 'ginger-dillon', 'Ginger Dillon', 'Amet quo expedita r', 70.98, 379, '2024-06-10', 'S89E', NULL, NULL, 'Fashion', '2024-10-28', '2024-10-29 00:00:00', NULL, NULL, '3', 1, '2024-05-01 04:55:02', '2024-06-10 18:18:29', NULL, '<p>Est dolor debitis a</p>', 'S89E'),
(6, 'clio-lindsey', 'Clio Lindsey', NULL, 98.70, 115, '2024-06-10', 'S7P9', NULL, NULL, 'Vouchers', '2024-10-31', '2024-10-31 00:00:00', NULL, NULL, NULL, 1, '2024-05-01 05:49:16', '2024-10-16 22:53:47', NULL, '<p>Praesentium ipsum d</p>', 'S7P9'),
(7, 'brenna-peterson', 'Brenna Peterson', NULL, 67.40, 959, '2024-05-10', 'S0UE', NULL, NULL, 'Holidays', '2024-06-26', NULL, NULL, NULL, NULL, 1, '2024-05-01 07:37:13', '2024-06-10 01:27:33', '2024-06-10 01:27:33', 'Culpa commodo quod r', 'S0UE'),
(8, 'infrade-contest', 'Infrade Contest', NULL, 12.00, 200, '2024-06-10', 'W345', NULL, NULL, 'Cash Prize', '2024-06-30', '2024-07-01 00:00:00', NULL, NULL, '1', 1, '2024-05-09 14:06:01', '2024-06-10 18:17:26', NULL, '<p>I am trying this contest to test and will tellyou about the system.</p>', 'W345'),
(9, 'test', 'Test', NULL, 10.00, 100, '2024-06-02', '12345', NULL, NULL, 'Cash Prize', '2024-06-30', NULL, NULL, NULL, NULL, NULL, '2024-06-01 14:44:47', '2024-06-05 12:32:54', '2024-06-05 12:32:54', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '12345'),
(10, 'test', 'Test', NULL, 100.00, 100, '2024-06-05', '123', NULL, NULL, 'Cash Prize', '2024-06-06', NULL, NULL, NULL, NULL, 0, '2024-06-05 12:27:28', '2024-06-05 12:27:57', '2024-06-05 12:27:57', 'Test Competition', '123'),
(11, 'mdasmd', ';mdasmd', NULL, 12.00, 13, NULL, ';lmxcl;xzmc', NULL, NULL, 'Cash Prize', NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-05 12:34:40', '2024-06-05 12:34:45', '2024-06-05 12:34:45', NULL, ';lmxcl;xzmc');

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

--
-- Table structure for table `contest_images`
--

CREATE TABLE `contest_images` (
  `id` int(10) UNSIGNED NOT NULL,
  `path` varchar(255) NOT NULL,
  `contest_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contest_images`
--

INSERT INTO `contest_images` (`id`, `path`, `contest_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'public/uploads/contests/F0h7jlR3UQshLgA8ie9XoQe1adb0YwRaXbDz9XT1.jpg', 1, '2024-05-01 03:22:08', '2024-12-23 05:54:45', '2024-12-23 05:54:45'),
(2, 'public/uploads/contests/pe8c8It6kASPX2MDkEeeOSFiHufWyaqkTJF29ZXH.jpg', 1, '2024-05-01 03:22:08', '2024-12-23 05:54:42', '2024-12-23 05:54:42'),
(3, 'public/uploads/contests/k2MCAsjiz0hYQgE8pbFlAUUs3SLy6w5dnrAB9012.jpg', 1, '2024-05-01 03:22:08', '2024-12-23 05:54:39', '2024-12-23 05:54:39'),
(4, 'public/uploads/contests/uc7gTz2bAYwFfGjbgshsWTFWtRMGbnARV8rQer9z.jpg', 2, '2024-05-01 03:23:52', '2024-05-01 03:23:52', NULL),
(5, 'public/uploads/contests/EdwjHiBRYVATtMFDqQVvSgNremp1TEzh0B65JeCf.jpg', 2, '2024-05-01 03:23:52', '2024-05-01 03:23:52', NULL),
(6, 'public/uploads/contests/ZLHRbJZEBfCMqtPBVmhcnU4cY1D2Mci36YP9o6mt.jpg', 2, '2024-05-01 03:23:52', '2024-05-01 03:23:52', NULL),
(7, 'public/uploads/contests/piisM1iZEnD2rDK3mSuVO3CwqypXKSRHvTVUynbR.jpg', 2, '2024-05-01 03:23:52', '2024-05-01 03:23:52', NULL),
(8, 'public/uploads/contests/cJyvkl09wJvKkLMzdsNHWR7oTGBNtiHoWJiBzmUx.jpg', 3, '2024-05-01 03:25:04', '2024-05-01 03:25:04', NULL),
(9, 'public/uploads/contests/h4Iur2CMIWCZ2VXvZ7UUyGJDHThjVj9e0gAhGQ61.jpg', 3, '2024-05-01 03:25:04', '2024-05-01 03:25:04', NULL),
(10, 'public/uploads/contests/UO2K1ZuavdZ8YW4LGj5HtQnDqRq7fL4XUPiWocyX.jpg', 3, '2024-05-01 03:25:04', '2024-05-01 03:25:04', NULL),
(11, 'public/uploads/contests/uig8JYxWJIyhyZhfvCx8IJ5670SnezrM57qn0jnB.jpg', 3, '2024-05-01 03:25:04', '2024-05-01 03:25:04', NULL),
(12, 'public/uploads/contests/ELeHUpuGPB3jpZAQlaUGSDim4fyOFMrOCPFvcFNQ.jpg', 3, '2024-05-01 03:25:04', '2024-05-01 03:25:04', NULL),
(13, 'public/uploads/contests/boLBawzjmCnsnYfKQkcsXj7s8ME86mmLlKmuC3VO.jpg', 4, '2024-05-01 04:19:25', '2024-05-01 04:19:25', NULL),
(14, 'public/uploads/contests/b8dSpsXRptZwVL62499ZDV1qHju6QN1NWuX4tm6u.jpg', 4, '2024-05-01 04:19:25', '2024-05-01 04:19:25', NULL),
(15, 'public/uploads/contests/2QOXW0taMrY1msfl9KembUmGSmj10C9T2TDsRgv4.jpg', 4, '2024-05-01 04:19:25', '2024-05-01 04:19:25', NULL),
(16, 'public/uploads/contests/NW3jn22HowzJAlHlsz30Uw6aqeamC1qhpPcqv4Wd.jpg', 4, '2024-05-01 04:19:25', '2024-05-01 04:19:25', NULL),
(17, 'public/uploads/contests/KI4iQt9F8WESyLdssjhh47S7R7VK2UYs5PoXEwU1.jpg', 5, '2024-05-01 04:55:02', '2024-05-01 04:55:02', NULL),
(18, 'public/uploads/contests/yTKy5Ft4VB1psGVBod0jG3LEQiGVdVv5y5SecS56.jpg', 5, '2024-05-01 04:55:02', '2024-05-01 04:55:02', NULL),
(19, 'public/uploads/contests/BFlzBRS7bLXqcdnPGX5o2HqFYYQw4Dx1EsmzpdIF.jpg', 5, '2024-05-01 04:55:02', '2024-05-01 04:55:02', NULL),
(20, 'public/uploads/contests/oXB21MgrjRPu41sdAIMoWH5D1Xw4CgLomRMu4bXF.jpg', 6, '2024-05-01 05:49:16', '2024-05-01 05:49:16', NULL),
(21, 'public/uploads/contests/mhjnDwYPKd9xDRrvqsB7niYoLtRx8V0Z6VANuOLy.jpg', 6, '2024-05-01 05:49:16', '2024-05-01 05:49:16', NULL),
(22, 'public/uploads/contests/nrsV5XzC4n9SVaBQt1MPv0ox9PKr3zbiS5A5Fziu.jpg', 6, '2024-05-01 05:49:16', '2024-05-01 05:49:16', NULL),
(23, 'public/uploads/contests/Cj9ddAJNn0ZvKqN8EUCXjnVx2jQiAWbUlLNTOfnW.jpg', 7, '2024-05-01 07:37:13', '2024-05-01 07:37:13', NULL),
(24, 'public/uploads/contests/iiNXd2uiI8aOE1FqguPNKrlcCMMVMrfjPNZYr09A.jpg', 7, '2024-05-01 07:37:13', '2024-05-01 07:37:13', NULL),
(25, 'public/uploads/contests/1P2O0vw5wDU5eoLXhQXVuHgTQFueYx9hDPRcqnJv.jpg', 8, '2024-05-09 14:06:01', '2024-05-09 14:06:01', NULL),
(26, 'public/uploads/contests/OzfrelqICc9w0J4ORxG4zYxlIb6g2kic9gOL8p5s.jpg', 8, '2024-05-09 14:06:01', '2024-05-09 14:06:01', NULL),
(27, 'public/uploads/contests/jJXsBhMV6etzTymQW6IEHnBkqSnjImmQ975SDO2m.jpg', 8, '2024-05-09 14:06:01', '2024-05-09 14:06:01', NULL),
(28, 'public/uploads/contests/VYh7ieeOaENrGbKQ4Szssuilljviep4Sdq5iAclF.jpg', 9, '2024-06-01 14:44:47', '2024-06-01 14:44:47', NULL),
(29, 'public/uploads/contests/xZmjDTBvV8NRemqxoFEUo7p7Bz1w0Ivobk6yij32.webp', 1, '2024-12-23 05:55:15', '2024-12-23 05:55:15', NULL),
(30, 'public/uploads/contests/IvbcDLNp8FrSBTxWiByKDnpDQ1phCxeIMGLyo1Gh.jpg', 1, '2024-12-23 05:55:15', '2024-12-23 05:55:15', NULL),
(31, 'public/uploads/contests/Nw8t9vylvgScy8fOFq4elBm1BBLjFxINbjxODjkj.jpg', 1, '2024-12-23 05:55:15', '2024-12-23 05:55:15', NULL);

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

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) VALUES
(1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93),
(2, 'AL', 'ALBANIA', 'Albania', 'ALB', 8, 355),
(3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 213),
(4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 1684),
(5, 'AD', 'ANDORRA', 'Andorra', 'AND', 20, 376),
(6, 'AO', 'ANGOLA', 'Angola', 'AGO', 24, 244),
(7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 1264),
(8, 'AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL, 0),
(9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 1268),
(10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 54),
(11, 'AM', 'ARMENIA', 'Armenia', 'ARM', 51, 374),
(12, 'AW', 'ARUBA', 'Aruba', 'ABW', 533, 297),
(13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61),
(14, 'AT', 'AUSTRIA', 'Austria', 'AUT', 40, 43),
(15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 994),
(16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 1242),
(17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 973),
(18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 880),
(19, 'BB', 'BARBADOS', 'Barbados', 'BRB', 52, 1246),
(20, 'BY', 'BELARUS', 'Belarus', 'BLR', 112, 375),
(21, 'BE', 'BELGIUM', 'Belgium', 'BEL', 56, 32),
(22, 'BZ', 'BELIZE', 'Belize', 'BLZ', 84, 501),
(23, 'BJ', 'BENIN', 'Benin', 'BEN', 204, 229),
(24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 1441),
(25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 975),
(26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 591),
(27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 387),
(28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 267),
(29, 'BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 0),
(30, 'BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55),
(31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, 246),
(32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 673),
(33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 359),
(34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 226),
(35, 'BI', 'BURUNDI', 'Burundi', 'BDI', 108, 257),
(36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 855),
(37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 237),
(38, 'CA', 'CANADA', 'Canada', 'CAN', 124, 1),
(39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 238),
(40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 1345),
(41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 236),
(42, 'TD', 'CHAD', 'Chad', 'TCD', 148, 235),
(43, 'CL', 'CHILE', 'Chile', 'CHL', 152, 56),
(44, 'CN', 'CHINA', 'China', 'CHN', 156, 86),
(45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 61),
(46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 672),
(47, 'CO', 'COLOMBIA', 'Colombia', 'COL', 170, 57),
(48, 'KM', 'COMOROS', 'Comoros', 'COM', 174, 269),
(49, 'CG', 'CONGO', 'Congo', 'COG', 178, 242),
(50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 242),
(51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 682),
(52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 506),
(53, 'CI', 'COTE D\'IVOIRE', 'Cote D\'Ivoire', 'CIV', 384, 225),
(54, 'HR', 'CROATIA', 'Croatia', 'HRV', 191, 385),
(55, 'CU', 'CUBA', 'Cuba', 'CUB', 192, 53),
(56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 357),
(57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 420),
(58, 'DK', 'DENMARK', 'Denmark', 'DNK', 208, 45),
(59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 253),
(60, 'DM', 'DOMINICA', 'Dominica', 'DMA', 212, 1767),
(61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 1809),
(62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 593),
(63, 'EG', 'EGYPT', 'Egypt', 'EGY', 818, 20),
(64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 503),
(65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 240),
(66, 'ER', 'ERITREA', 'Eritrea', 'ERI', 232, 291),
(67, 'EE', 'ESTONIA', 'Estonia', 'EST', 233, 372),
(68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 251),
(69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 500),
(70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 298),
(71, 'FJ', 'FIJI', 'Fiji', 'FJI', 242, 679),
(72, 'FI', 'FINLAND', 'Finland', 'FIN', 246, 358),
(73, 'FR', 'FRANCE', 'France', 'FRA', 250, 33),
(74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 594),
(75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 689),
(76, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 0),
(77, 'GA', 'GABON', 'Gabon', 'GAB', 266, 241),
(78, 'GM', 'GAMBIA', 'Gambia', 'GMB', 270, 220),
(79, 'GE', 'GEORGIA', 'Georgia', 'GEO', 268, 995),
(80, 'DE', 'GERMANY', 'Germany', 'DEU', 276, 49),
(81, 'GH', 'GHANA', 'Ghana', 'GHA', 288, 233),
(82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 350),
(83, 'GR', 'GREECE', 'Greece', 'GRC', 300, 30),
(84, 'GL', 'GREENLAND', 'Greenland', 'GRL', 304, 299),
(85, 'GD', 'GRENADA', 'Grenada', 'GRD', 308, 1473),
(86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 590),
(87, 'GU', 'GUAM', 'Guam', 'GUM', 316, 1671),
(88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 502),
(89, 'GN', 'GUINEA', 'Guinea', 'GIN', 324, 224),
(90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 245),
(91, 'GY', 'GUYANA', 'Guyana', 'GUY', 328, 592),
(92, 'HT', 'HAITI', 'Haiti', 'HTI', 332, 509),
(93, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, 0),
(94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 39),
(95, 'HN', 'HONDURAS', 'Honduras', 'HND', 340, 504),
(96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 852),
(97, 'HU', 'HUNGARY', 'Hungary', 'HUN', 348, 36),
(98, 'IS', 'ICELAND', 'Iceland', 'ISL', 352, 354),
(99, 'IN', 'INDIA', 'India', 'IND', 356, 91),
(100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 62),
(101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 98),
(102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 964),
(103, 'IE', 'IRELAND', 'Ireland', 'IRL', 372, 353),
(104, 'IL', 'ISRAEL', 'Israel', 'ISR', 376, 972),
(105, 'IT', 'ITALY', 'Italy', 'ITA', 380, 39),
(106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 1876),
(107, 'JP', 'JAPAN', 'Japan', 'JPN', 392, 81),
(108, 'JO', 'JORDAN', 'Jordan', 'JOR', 400, 962),
(109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 7),
(110, 'KE', 'KENYA', 'Kenya', 'KEN', 404, 254),
(111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 686),
(112, 'KP', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'Korea, Democratic People\'s Republic of', 'PRK', 408, 850),
(113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 82),
(114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 965),
(115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 996),
(116, 'LA', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'Lao People\'s Democratic Republic', 'LAO', 418, 856),
(117, 'LV', 'LATVIA', 'Latvia', 'LVA', 428, 371),
(118, 'LB', 'LEBANON', 'Lebanon', 'LBN', 422, 961),
(119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 266),
(120, 'LR', 'LIBERIA', 'Liberia', 'LBR', 430, 231),
(121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 218),
(122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 423),
(123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 370),
(124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 352),
(125, 'MO', 'MACAO', 'Macao', 'MAC', 446, 853),
(126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 389),
(127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 261),
(128, 'MW', 'MALAWI', 'Malawi', 'MWI', 454, 265),
(129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60),
(130, 'MV', 'MALDIVES', 'Maldives', 'MDV', 462, 960),
(131, 'ML', 'MALI', 'Mali', 'MLI', 466, 223),
(132, 'MT', 'MALTA', 'Malta', 'MLT', 470, 356),
(133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 692),
(134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 596),
(135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 222),
(136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 230),
(137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 269),
(138, 'MX', 'MEXICO', 'Mexico', 'MEX', 484, 52),
(139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 691),
(140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 373),
(141, 'MC', 'MONACO', 'Monaco', 'MCO', 492, 377),
(142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 976),
(143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 1664),
(144, 'MA', 'MOROCCO', 'Morocco', 'MAR', 504, 212),
(145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 258),
(146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 95),
(147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 264),
(148, 'NR', 'NAURU', 'Nauru', 'NRU', 520, 674),
(149, 'NP', 'NEPAL', 'Nepal', 'NPL', 524, 977),
(150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 31),
(151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 599),
(152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 687),
(153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64),
(154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 505),
(155, 'NE', 'NIGER', 'Niger', 'NER', 562, 227),
(156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 234),
(157, 'NU', 'NIUE', 'Niue', 'NIU', 570, 683),
(158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 672),
(159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 1670),
(160, 'NO', 'NORWAY', 'Norway', 'NOR', 578, 47),
(161, 'OM', 'OMAN', 'Oman', 'OMN', 512, 968),
(162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 92),
(163, 'PW', 'PALAU', 'Palau', 'PLW', 585, 680),
(164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 970),
(165, 'PA', 'PANAMA', 'Panama', 'PAN', 591, 507),
(166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 675),
(167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 595),
(168, 'PE', 'PERU', 'Peru', 'PER', 604, 51),
(169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 63),
(170, 'PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 0),
(171, 'PL', 'POLAND', 'Poland', 'POL', 616, 48),
(172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 351),
(173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 1787),
(174, 'QA', 'QATAR', 'Qatar', 'QAT', 634, 974),
(175, 'RE', 'REUNION', 'Reunion', 'REU', 638, 262),
(176, 'RO', 'ROMANIA', 'Romania', 'ROM', 642, 40),
(177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 70),
(178, 'RW', 'RWANDA', 'Rwanda', 'RWA', 646, 250),
(179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 290),
(180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 1869),
(181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 1758),
(182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 508),
(183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 1784),
(184, 'WS', 'SAMOA', 'Samoa', 'WSM', 882, 684),
(185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 378),
(186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 239),
(187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 966),
(188, 'SN', 'SENEGAL', 'Senegal', 'SEN', 686, 221),
(189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 381),
(190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 248),
(191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 232),
(192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 65),
(193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 421),
(194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 386),
(195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 677),
(196, 'SO', 'SOMALIA', 'Somalia', 'SOM', 706, 252),
(197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27),
(198, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, 0),
(199, 'ES', 'SPAIN', 'Spain', 'ESP', 724, 34),
(200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94),
(201, 'SD', 'SUDAN', 'Sudan', 'SDN', 736, 249),
(202, 'SR', 'SURINAME', 'Suriname', 'SUR', 740, 597),
(203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 47),
(204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268),
(205, 'SE', 'SWEDEN', 'Sweden', 'SWE', 752, 46),
(206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 41),
(207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 963),
(208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 886),
(209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 992),
(210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 255),
(211, 'TH', 'THAILAND', 'Thailand', 'THA', 764, 66),
(212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 670),
(213, 'TG', 'TOGO', 'Togo', 'TGO', 768, 228),
(214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 690),
(215, 'TO', 'TONGA', 'Tonga', 'TON', 776, 676),
(216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 1868),
(217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 216),
(218, 'TR', 'TURKEY', 'Turkey', 'TUR', 792, 90),
(219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 7370),
(220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 1649),
(221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 688),
(222, 'UG', 'UGANDA', 'Uganda', 'UGA', 800, 256),
(223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 380),
(224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 971),
(225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44),
(226, 'US', 'UNITED STATES', 'United States', 'USA', 840, 1),
(227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 1),
(228, 'UY', 'URUGUAY', 'Uruguay', 'URY', 858, 598),
(229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 998),
(230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 678),
(231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 58),
(232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 84),
(233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 1284),
(234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 1340),
(235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 681),
(236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 212),
(237, 'YE', 'YEMEN', 'Yemen', 'YEM', 887, 967),
(238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 260),
(239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 263);

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

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

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

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(10) UNSIGNED NOT NULL,
  `category` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `category`, `question`, `answer`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 'Aliquam accusantium', '<p>Magnam eu qui est, v.</p>', '2024-05-23 09:17:02', '2024-06-14 14:47:48', NULL),
(2, 2, 'Sample 2', '<p>Test 123</p>', '2024-05-23 18:45:11', '2024-06-14 14:47:48', NULL),
(3, 4, 'Sample', '<p>Sasas</p>', '2024-05-23 18:45:41', '2024-05-23 18:45:41', NULL),
(4, 1, 'My Testing Question?', '<p>My Tetsing Answer</p>', '2024-05-23 18:48:02', '2024-12-13 14:00:23', NULL),
(5, 1, 'My Second Question?', '<p>My test answer for second question</p>', '2024-05-23 18:48:02', '2024-12-13 14:00:23', NULL),
(6, 1, 'My Third Question', '<p>test answer for third question</p>', '2024-05-24 17:45:02', '2024-12-13 14:00:23', NULL),
(7, 1, 'Fourth Question?', '<p>My fourth answer will be displayed here.</p>', '2024-05-30 17:12:01', '2024-12-13 14:00:23', NULL);

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

--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories`
--

INSERT INTO `faq_categories` (`id`, `slug`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, 'rifa-tickets', 'Rifa Tickets', NULL, NULL, NULL),
(2, 'banking', 'Banking', NULL, NULL, NULL),
(3, 'winning', 'Winning', NULL, NULL, NULL),
(4, 'result-alerts', 'Result & Alerts', NULL, NULL, NULL),
(5, 'about-rifa-123', 'About Rifa 123', 'Test', NULL, '2024-06-11 22:37:04');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_04_25_081246_create_roles_table', 2),
(6, '2024_04_27_191728_new_column_in_users_table', 2),
(7, '2024_04_29_164544_create_contact_page_table', 3),
(8, '2024_04_29_164606_create_contact_us_table', 3),
(9, '2024_04_29_164622_create_about_page_table', 3),
(10, '2024_04_30_120104_create_about_us_table', 4),
(11, '2024_04_27_194653_create_permission_tables', 5),
(12, '2024_04_30_100316_create_contest_management_table', 5),
(13, '2024_04_30_100332_create_contest_management_images_table', 5),
(14, '2024_05_01_101713_add_columns_to_contests', 6),
(15, '2024_05_01_100533_new_columns_in_contests_table', 7),
(16, '2024_05_02_133606_add_columns_to_users', 7),
(17, '2024_05_06_110424_create_home_pages_table', 8),
(18, '2024_05_07_070835_new_columns_in_contest_table', 9),
(19, '2024_05_10_102207_featured_contest_column_in_contests_table', 10),
(21, '2024_05_14_041319_create_user_carts_table', 11),
(22, '2024_05_15_095733_featured_column_in_contest', 11),
(23, '2024_05_16_095129_create_users_fav_contests_table', 11),
(24, '2024_05_16_070546_new_table_faqs', 12),
(25, '2024_05_17_064006_faq_categories_table', 12),
(26, '2024_05_17_072424_change_faqs_category_type', 12),
(27, '2024_05_17_073932_add_fk_faqs_category_type', 12),
(28, '2024_05_21_055828_add_social_provider_columns_to_users_table', 12),
(29, '2024_05_22_100724_create_subscribers_table', 12),
(30, '2024_05_21_132030_user_additional_info_table', 13),
(31, '2024_05_22_065800_new_column_in_user_additional_info', 13),
(32, '2024_05_23_092325_user_status_column_in_users_table', 14),
(33, '2024_05_27_125855_add_col_to_users_table', 15),
(34, '2024_05_28_061629_create_orders_table', 15),
(35, '2024_05_28_061633_create_orders_items_table', 15),
(36, '2024_05_28_061659_create_payment_histories_table', 15),
(37, '2024_05_29_101020_add_column_to_about_us', 16),
(38, '2024_05_29_124639_create_site_settings_table', 17),
(39, '2024_05_31_135758_new_column_in_faq_categories', 18),
(40, '2024_06_04_150213_rename_is_active_column_name_in_subscribers', 19),
(41, '2024_06_06_120025_create_orders_tickets_table', 19),
(42, '2024_06_07_121548_add_relations_to_order_ticket_columns', 20),
(43, '2024_06_07_070840_draw_date_column_addition', 21),
(44, '2024_06_11_104758_contact_us_new_columns', 22),
(45, '2024_06_12_132344_change_draw_date_type_in_contests', 23),
(46, '2024_06_17_100953_add_column_to_users', 24),
(47, '2024_06_07_070828_add_relations_to_order_ticket_columns', 25),
(48, '2014_10_12_100000_create_password_reset_tokens_table', 26),
(49, '2024_07_16_102440_questions_table', 27),
(50, '2024_07_16_102529_question_options_table', 27),
(51, '2024_07_16_134606_winning_amount_in_contests', 27),
(52, '2024_07_17_081919_winning_amount_column_change', 28),
(53, '2024_07_18_081635_create_user_answers_table', 29),
(54, '2024_10_21_044522_add_transaction_id_in_orders', 30),
(55, '2025_02_11_125845_create_news_table', 31),
(56, '2025_02_13_100557_add_category_to_news', 32),
(57, '2025_02_18_073709_rename_long_desription_column_in_news_table', 33);

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

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

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

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

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

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

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(2, 'App\\Models\\User', 10),
(2, 'App\\Models\\User', 22),
(2, 'App\\Models\\User', 24),
(2, 'App\\Models\\User', 26);

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `long_description` longtext DEFAULT NULL,
  `news_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `category_id`, `title`, `image`, `short_description`, `long_description`, `news_date`, `created_at`, `updated_at`) VALUES
(11, 5, 'India News Live Today February 17, 2025', '1740737802.jpg', 'India News Live: Stay informed with our live blog covering India&rsquo;s latest in politics, economy, crime, and general news. Get real-time updates on political developments, financial trends, crime reports, and important events across the country. Stay connected with the most crucial stories shaping India, all in one place.', '<figure class=\"image\"><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740737800_istockphoto-530685719-2048x2048.jpg\"></figure><p>India News Live: Get real time updates on the latest happenings across India. From key political shifts and government decisions to economic developments and crime reports, we bring you real-time information as it unfolds. Our coverage also includes general news, spotlighting significant events and issues impacting daily life.</p>', '2025-02-18', '2025-02-18 02:41:26', '2025-02-28 12:06:57'),
(12, 5, 'Pi Coin News', '1740662751.jpg', 'It’s been a bloodbath in the crypto market in recent days, with Bitcoin (BTC) dumping back to the low $ 80,000s, but Pi Network (PI) is pumping hard.\r\n\r\nPI, which powers the Open Network blockchain launched by Pi Network one week ago, is up over 250% since its launch.', '<p>Pi Network Coin, which is the latest cryptocurrency to hit the market, on Thursday jumped by 36.77 per cent in the past 24 hours to $2.58. The sharp jumps at a time when the world’s largest cryptocurrency Bitcoin is down below $85,000, which is 20 per cent lower than its January peak of $109,350.</p><p>As of 12:58 pm on Thursday, the 24-hour trading volume was up 169.8 per cent to $3.34 billion, with a circulating supply of 10.154 billion, according to coingecko.com.</p><p>&nbsp;</p><p><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740663040_stock-photo-handsome-businessman-with-helmet-drawing-capex-inscription-architecture-business-plan-concept-1693695628.jpg\"></p>', '2025-02-20', '2025-02-20 03:58:14', '2025-02-28 05:53:50'),
(22, 8, 'Economy News', '1740493126.png', 'Economics is a social science that studies the production, distribution, and consumption of goods and services. Economics focuses on the behaviour and ...', '<p>Economics is a social science with stakes in many other fields, including political science, geography, mathematics, sociology, psychology, engineering, law, medicine and business.&nbsp;The central quest of economics is to determine the most logical and effective use of resources to meet private and social goals. Production and employment, investment and savings, health, money and the banking system, government policies on taxation and spending, international trade, industrial organization and regulation, urbanization, environmental issues and legal matters (such as the design and enforcement of property rights), are just a sampling of the concerns at the heart of the science of economics.</p><p><br><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740493121_economics-source-b80e91b606bd4729815840bad4ff3ecd.png\"></p>', '2025-02-25', '2025-02-25 14:18:46', '2025-02-25 14:18:46'),
(23, 5, 'From $100 to $2 billion fortune: This Indian H-1B visa holder moved to US in 1980s, now owns a billion-dollar company', '1740659374.jpg', 'A recent Forbes report on billionaire immigrants who started their careers in the US on an H-1B visa features only a handful of Indians. Among them is Raj Sardana, founder and CEO of Innova Solutions, who moved to the US for higher education, built a business from the ground up, and is now worth $2 billion.\r\n\r\nBorn in 1960 to Punjabi parents who migrated to India during the Partition of 1947, Sardana grew up in government housing in New Delhi. His family had no modern amenities—no heating, air conditioning, refrigerator, phone, TV, or car, according to HT.\r\n\r\n“Despite our humble beginnings, my parents instilled the values of relentless hard work and found a way to provide quality education to me and my brother,” Sardana recalled in an interview with Authority Magazine.', '<figure class=\"image\"><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740658961_67c03562639a0-index-wise--22-000-would-act-as-a-support-for-benchmark-nifty50-in-the-near-term-and-resistance-may-275020668-16x9.webp\"></figure><p>Akshay Bhagwat, Senior Vice-President of Derivatives Research at JM Financial Services, said the market would remain on a slippery footing as there\'s still some pain left. Index-wise, 22,000 would act as a support for benchmark Nifty50 in the near term and resistance may be found at Rs 22,800, the market expert told <strong>Business Today</strong> on Thursday</p>', '2025-02-27', '2025-02-27 12:29:34', '2025-02-27 12:47:23'),
(24, 1, 'Market Trades Green In Opening Trade', '1740661096.jpg', 'The Nifty 50 increases by 0.15 per cent to reach 22,582, whereas the BSE Sensex increases by 0.2 per cent to 74,740.14 in the opening trade', '<figure class=\"image\"><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740661076_stock-photo-business-person-looking-at-road-with-question-mark-sign-concept-230646745.jpg\"></figure><p>ndia\'s benchmark indices began higher on Thursday, driven by the financial sector following the Reserve Bank of India easing strict lending regulations for micro-credit and non-bank institutions.&nbsp;</p><p>&nbsp;</p><p>The Nifty 50 increased by 0.15 per cent to reach 22,582, whereas the BSE Sensex increased by 0.2 per cent to 74,740.14 in the opening trade.&nbsp;<br>&nbsp;</p><p>High-weighted financials increased by 0.6 per cent as banks advanced 0.5 per cent following the RBI\'s partial rollback of stricter regulations on loans for small borrowers and non-bank lenders.&nbsp;</p><p>&nbsp;</p>', '2025-02-27', '2025-02-27 12:58:16', '2025-02-27 12:58:16'),
(25, 5, 'Modi’s Busiest Bureaucrat, Tuhin Kanta Pandey, Named New Sebi Chief', '1740728694.jpg', 'India\'s incumbent Finance Secretary, Tuhin Kanta Pandey, is the new Sebi chief. BW Businessworld was the first to report his name as the frontrunner for the post on 14 February.\r\n\r\nBased on seniority, Pandey is India\'s senior-most IAS officer after Cabinet Secretary T V Somnathan. Pandey replaced Somanathan as Finance Secretary when the former was promoted to Cabinet Secretary in August 2024.', '<p>The 1987 batch Odisha cadre officer, Pandey, is one of India\'s busiest secretaries in the Modi 3.0 government, handling four critical departments.</p><p>When he served as Secretary of the Department of Investment &amp; Public Asset Management (DIPAM), Pandey was given additional responsibilities as Secretary of the Department of Public Enterprises (DPE) on 1 August, following the retirement of the incumbent, Ali Raza Rizvi. Then, on 30 August, Pandey was appointed Finance Secretary in the Ministry of Finance (MOF), and in November, he was assigned another role as Secretary of the Department of Personnel &amp; Training (DoPT) after the incumbent Vivek Joshi moved to his home state. Thus, the responsibility for four critical departments fell on Pandey, making him the busiest secretary in the Modi administration.<img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740728656_gettyimages-1648456053-1024x1024.jpg\"></p>', '2025-02-28', '2025-02-28 07:44:54', '2025-02-28 07:44:54'),
(26, 4, 'Where does it come from?', '1740736376.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet.', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet.<img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740736365_istockphoto-1272017072-2048x2048.jpg\"></p>', '2025-03-01', '2025-02-28 09:52:56', '2025-02-28 09:52:56'),
(27, 8, 'Where does it come from?', '1740736937.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet.', '<figure class=\"image\"><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740737758_business-meeting-concept-coworkers-team-working-new-startup-project-modern-office-analyze-business-documents-using-touch-tablet-94640997.jpg\"></figure><figure class=\"image\"><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740737510_mixed-group-around-table-business-meeting-21283913.jpg\"></figure><p>t is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like.</p>', '2025-03-01', '2025-02-28 10:02:04', '2025-02-28 10:16:00'),
(28, 5, 'Succession-like feud engulfs one of Singapore\'s richest families', '1740738036.jpg', 'A Succession-like feud has engulfed one of Singapore\'s richest families as property tycoon Kwek Leng Beng accused his son of plotting a boardroom takeover.', '<p>Sherman Kwek said he and the majority of CDL\'s board were disappointed by what he described as extreme actions taken by his father \"regarding this disagreement around the size and make-up of the CDL board.\"</p><p>“To reiterate, this has never been about ousting our esteemed chairman. These steps to strengthen our board have purely been to ensure CDL has the highest standards of governance to which it has become known,\" he said in a statement to the BBC.</p><p>Kwek Leng Beng, along with his father and brother, took control of then-loss-making CDL in 1971. He became the firm\'s executive chairman after his father\'s death in 1995.<img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740738032_istockphoto-1437931505-612x612.jpg\"></p>', '2025-02-28', '2025-02-28 10:20:36', '2025-02-28 10:20:36'),
(29, 5, 'Nvidia says AI chip sales strong despite DeepSeek fears', '1740740704.jpg', 'Flipkart-backed fintech firm Super.money on Tuesday acquired checkout financing platform BharatX in an all-cash deal as the company continues to launch new payment and credit offerings since its launch last year.', '<figure class=\"image\"><img src=\"https://caferoute66.com/dovehouse/public/uploads/ckeditor/1740740694_istockphoto-530685719-2048x2048.jpg\"></figure><p>&nbsp;<br>The deal amount has not been disclosed.<br><br>The company plans to introduce checkout financing for direct-to-consumer (D2C) and e-commerce brands, including Flipkart, beginning with consumer durables products through a credit line on Unified Payments Interface (UPI).</p>', '2025-02-28', '2025-02-28 11:05:04', '2025-02-28 11:05:04'),
(30, 5, 'Vodafone Idea gets Rs 16.73 cr GST notice, plans to challenge decision', '1740740945.jpg', 'Telecom operator Vodafone Idea (VIL) on Friday said it has received a Rs 16.73 crore Goods and Services Tax (GST) demand order from Deputy Commissioner, Large Taxpayer Unit, West Bengal.', '<p>The telco asserted it does not agree with the order and will take appropriate action for filing an appeal against the same.</p><p>In a BSE filing on details of order received by the company under the Central Goods and Services Tax Act, 2017, Vodafone Idea informed that order was received on February 27, 2025.</p>', '2025-02-28', '2025-02-28 11:09:05', '2025-03-06 11:17:59');

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

--
-- Table structure for table `orders_items`
--

CREATE TABLE `orders_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `contest_id` int(10) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price` double(15,2) NOT NULL,
  `item_discount` double(15,2) DEFAULT NULL,
  `item_tax` double(15,2) DEFAULT NULL,
  `total` double(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders_items`
--

INSERT INTO `orders_items` (`id`, `order_id`, `contest_id`, `quantity`, `price`, `item_discount`, `item_tax`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 3, 151.00, 0.00, 0.00, 453.00, '2024-12-23 07:04:16', '2024-12-23 07:04:16');

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

--
-- Table structure for table `orders_tickets`
--

CREATE TABLE `orders_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `contest_id` int(10) UNSIGNED NOT NULL,
  `ticket_id` varchar(255) NOT NULL,
  `ticket_no` int(11) NOT NULL,
  `ticket_status` varchar(255) DEFAULT 'open',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders_tickets`
--

INSERT INTO `orders_tickets` (`id`, `user_id`, `order_id`, `item_id`, `contest_id`, `ticket_id`, `ticket_no`, `ticket_status`, `created_at`, `updated_at`) VALUES
(1, 58, 1, 1, 1, 'SHD9E-001', 1, 'open', '2024-12-23 07:04:35', '2024-12-23 07:04:35'),
(2, 58, 1, 1, 1, 'SHD9E-002', 2, 'open', '2024-12-23 07:04:35', '2024-12-23 07:04:35'),
(3, 58, 1, 1, 1, 'SHD9E-003', 3, 'open', '2024-12-23 07:04:35', '2024-12-23 07:04:35');

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

--
-- Table structure for table `payment_histories`
--

CREATE TABLE `payment_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `discount` double(15,2) DEFAULT NULL,
  `tax` double(15,2) DEFAULT NULL,
  `grand_total` double(15,2) NOT NULL DEFAULT 0.00,
  `status` varchar(80) NOT NULL DEFAULT 'pending',
  `payment_status` varchar(80) NOT NULL DEFAULT 'unpaid',
  `previous_response` text DEFAULT NULL,
  `current_response` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_histories`
--

INSERT INTO `payment_histories` (`id`, `order_id`, `user_id`, `discount`, `tax`, `grand_total`, `status`, `payment_status`, `previous_response`, `current_response`, `created_at`, `updated_at`) VALUES
(1, 1, 12, 0.00, 0.00, 110.70, 'complete', 'complete', '{\"id\":\"cs_test_b1rop3Ukz9BlAGSfbVfMbxuXKYe2NyvHNibM5kzhL6voqdgvNjXeZjvVOn\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":20940,\"amount_total\":20940,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1716902999,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"harshavardhan@travash.com\",\"name\":\"Harshavardhan\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1716989399,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PLQ6uP8wDePtreD0MtstsJC\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_b1rop3Ukz9BlAGSfbVfMbxuXKYe2NyvHNibM5kzhL6voqdgvNjXeZjvVOn\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":20940,\"amount_total\":20940,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1716902999,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"harshavardhan@travash.com\",\"name\":\"Harshavardhan\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1716989399,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PLQ6uP8wDePtreD0MtstsJC\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-05-28 18:30:44', '2024-05-28 18:30:44'),
(2, 2, 12, 0.00, 0.00, 98.70, 'complete', 'complete', '{\"id\":\"cs_test_a1d9JCKBh6czueagJNVkXWjYiIll7h21uvIo2Rf8qO5J3MrMY2zbiJUGXQ\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":29610,\"amount_total\":29610,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1716903163,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"yhvreddy@outlook.com\",\"name\":\"Harshavardhan\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1716989563,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PLQ9YP8wDePtreD1tAFLfKh\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_a1d9JCKBh6czueagJNVkXWjYiIll7h21uvIo2Rf8qO5J3MrMY2zbiJUGXQ\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":29610,\"amount_total\":29610,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1716903163,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"yhvreddy@outlook.com\",\"name\":\"Harshavardhan\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1716989563,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PLQ9YP8wDePtreD1tAFLfKh\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-05-28 18:33:28', '2024-05-28 18:33:28'),
(3, 3, 12, 0.00, 0.00, 12.00, 'complete', 'complete', '{\"id\":\"cs_test_a19OPaVyjeDhbQtsQo8eHf5Fix08wcnfGJvi1HAyiCQ80GwH7WZzjV9I8o\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":6000,\"amount_total\":6000,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1716903344,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"yhvreddy@outlook.com\",\"name\":\"Harshavardhan\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1716989744,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PLQCPP8wDePtreD08RGzgPy\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_a19OPaVyjeDhbQtsQo8eHf5Fix08wcnfGJvi1HAyiCQ80GwH7WZzjV9I8o\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":6000,\"amount_total\":6000,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1716903344,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"yhvreddy@outlook.com\",\"name\":\"Harshavardhan\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1716989744,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PLQCPP8wDePtreD08RGzgPy\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-05-28 18:36:25', '2024-05-28 18:36:25'),
(4, 4, 12, 0.00, 0.00, 12.00, 'complete', 'complete', '{\"id\":\"cs_test_a1LPgG6ztovvplDimQAKT0hiVzqka9stYXMETmogZUuBLzqrksITQNuS2w\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":12000,\"amount_total\":12000,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717152357,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"yhvreddy@outlook.com\",\"name\":\"Harshavardhan Reddy\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717238757,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PMSz4P8wDePtreD0DjE4rnE\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_a1LPgG6ztovvplDimQAKT0hiVzqka9stYXMETmogZUuBLzqrksITQNuS2w\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":12000,\"amount_total\":12000,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717152357,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"yhvreddy@outlook.com\",\"name\":\"Harshavardhan Reddy\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717238757,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PMSz4P8wDePtreD0DjE4rnE\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-05-31 15:46:58', '2024-05-31 15:46:58'),
(5, 5, 12, 0.00, 0.00, 12.00, 'complete', 'complete', '{\"id\":\"cs_test_a1z3L1rYkl0xifXfcev1a35hXM07B3v7sGvkBblbZmL5fQFO3Vdf8yKoWX\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":2400,\"amount_total\":2400,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717404639,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"iamhtmldeveloper@gmail.com\",\"name\":\"Amol Bhandare\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717491039,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNWdlP8wDePtreD0fY7wCLB\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_a1z3L1rYkl0xifXfcev1a35hXM07B3v7sGvkBblbZmL5fQFO3Vdf8yKoWX\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":2400,\"amount_total\":2400,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717404639,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"iamhtmldeveloper@gmail.com\",\"name\":\"Amol Bhandare\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717491039,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNWdlP8wDePtreD0fY7wCLB\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-06-03 13:53:21', '2024-06-03 13:53:21'),
(6, 7, 12, 0.00, 0.00, 67.40, 'complete', 'complete', '{\"id\":\"cs_test_a18kFajoIM7CPAcLoxyrtBLbb74t53M0LRmn2D067P0Cwyo22e4Utxk0re\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":40440,\"amount_total\":40440,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717406963,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"iamhtmldeveloper@gmail.com\",\"name\":\"Amol Bhandare\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717493363,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNXD0P8wDePtreD0gqkF4HZ\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_a18kFajoIM7CPAcLoxyrtBLbb74t53M0LRmn2D067P0Cwyo22e4Utxk0re\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":40440,\"amount_total\":40440,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717406963,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"iamhtmldeveloper@gmail.com\",\"name\":\"Amol Bhandare\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717493363,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNXD0P8wDePtreD0gqkF4HZ\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-06-03 14:29:46', '2024-06-03 14:29:46'),
(7, 8, 12, 0.00, 0.00, 98.70, 'complete', 'complete', '{\"id\":\"cs_test_a1dVUPr82Qy3TWIYpMJIKTvSZdM1vOq6KbqiJKnAWY0Ds8SQfmrj2FpyO0\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":9870,\"amount_total\":9870,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717407728,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"iamhtmldeveloper@gmail.com\",\"name\":\"Amol Bhandare\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717494128,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNXPYP8wDePtreD0broZeoI\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_a1dVUPr82Qy3TWIYpMJIKTvSZdM1vOq6KbqiJKnAWY0Ds8SQfmrj2FpyO0\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":9870,\"amount_total\":9870,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717407728,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"IN\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"iamhtmldeveloper@gmail.com\",\"name\":\"Amol Bhandare\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717494128,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNXPYP8wDePtreD0broZeoI\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-06-03 14:42:45', '2024-06-03 14:42:45'),
(8, 9, 12, 0.00, 0.00, 12.00, 'complete', 'complete', '{\"id\":\"cs_test_a1laKO0FP3kK4a5kdKzpciYgd5XXvXAiMvR8TjYLxX8DTauuBZLLqkJpgv\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":1200,\"amount_total\":1200,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717408048,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"MT\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"amol@gmail.com\",\"name\":\"Amol andjfjf\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717494448,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNXVMP8wDePtreD1KLCpksO\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '{\"id\":\"cs_test_a1laKO0FP3kK4a5kdKzpciYgd5XXvXAiMvR8TjYLxX8DTauuBZLLqkJpgv\",\"object\":\"checkout.session\",\"after_expiration\":null,\"allow_promotion_codes\":null,\"amount_subtotal\":1200,\"amount_total\":1200,\"automatic_tax\":{\"enabled\":false,\"liability\":null,\"status\":null},\"billing_address_collection\":null,\"cancel_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/cancel\",\"client_reference_id\":null,\"client_secret\":null,\"consent\":null,\"consent_collection\":null,\"created\":1717408048,\"currency\":\"usd\",\"currency_conversion\":null,\"custom_fields\":[],\"custom_text\":{\"after_submit\":null,\"shipping_address\":null,\"submit\":null,\"terms_of_service_acceptance\":null},\"customer\":null,\"customer_creation\":\"if_required\",\"customer_details\":{\"address\":{\"city\":null,\"country\":\"MT\",\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":\"amol@gmail.com\",\"name\":\"Amol andjfjf\",\"phone\":null,\"tax_exempt\":\"none\",\"tax_ids\":[]},\"customer_email\":null,\"expires_at\":1717494448,\"invoice\":null,\"invoice_creation\":{\"enabled\":false,\"invoice_data\":{\"account_tax_ids\":null,\"custom_fields\":null,\"description\":null,\"footer\":null,\"issuer\":null,\"metadata\":[],\"rendering_options\":null}},\"livemode\":false,\"locale\":null,\"metadata\":[],\"mode\":\"payment\",\"payment_intent\":\"pi_3PNXVMP8wDePtreD1KLCpksO\",\"payment_link\":null,\"payment_method_collection\":\"if_required\",\"payment_method_configuration_details\":null,\"payment_method_options\":{\"card\":{\"request_three_d_secure\":\"automatic\"}},\"payment_method_types\":[\"card\"],\"payment_status\":\"paid\",\"phone_number_collection\":{\"enabled\":false},\"recovered_from\":null,\"saved_payment_method_options\":null,\"setup_intent\":null,\"shipping_address_collection\":null,\"shipping_cost\":null,\"shipping_details\":null,\"shipping_options\":[],\"status\":\"complete\",\"submit_type\":null,\"subscription\":null,\"success_url\":\"https:\\/\\/w3mantra.com\\/bmf\\/public\\/user\\/checkout\\/success?session_id={CHECKOUT_SESSION_ID}\",\"total_details\":{\"amount_discount\":0,\"amount_shipping\":0,\"amount_tax\":0},\"ui_mode\":\"hosted\",\"url\":null}', '2024-06-03 14:48:43', '2024-06-03 14:48:43'),
(9, 10, 12, 0.00, 0.00, 770.30, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":770.299999999999954525264911353588104248046875,\"switching\":false,\"orderCode\":\"8224308881472601\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T06:25:56.97+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 2\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":770.299999999999954525264911353588104248046875,\"switching\":false,\"orderCode\":\"8224308881472601\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T06:25:56.97+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 2\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-11 10:25:59', '2024-11-11 10:25:59'),
(10, 11, 12, 0.00, 0.00, 755.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"9446793725372604\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T07:52:42.12+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"9446793725372604\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T07:52:42.12+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-11 11:52:44', '2024-11-11 11:52:44'),
(11, 12, 12, 0.00, 0.00, 755.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"9893265496672609\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T08:03:34.563+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"9893265496672609\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T08:03:34.563+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-11 12:37:33', '2024-11-11 12:37:33'),
(12, 13, 12, 0.00, 0.00, 302.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":302,\"switching\":false,\"orderCode\":\"8489294604572606\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T09:11:39.147+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":302,\"switching\":false,\"orderCode\":\"8489294604572606\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-11T09:11:39.147+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-11 13:11:42', '2024-11-11 13:11:42'),
(13, 14, 12, 0.00, 0.00, 302.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":302,\"switching\":false,\"orderCode\":\"8722164238772600\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-13T07:03:54.717+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":302,\"switching\":false,\"orderCode\":\"8722164238772600\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-13T07:03:54.717+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Total Items 1\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-13 11:03:57', '2024-11-13 11:03:57'),
(14, 18, 12, 0.00, 0.00, 753.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":753,\"switching\":false,\"orderCode\":\"6913012042372601\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-18T08:47:08.043+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Colt Boyer - Tickets : 5 | Donovan Rosario - Tickets : 3\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":753,\"switching\":false,\"orderCode\":\"6913012042372601\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-18T08:47:08.043+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Colt Boyer - Tickets : 5 | Donovan Rosario - Tickets : 3\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-18 12:47:10', '2024-11-18 12:47:10'),
(15, 19, 12, 0.00, 0.00, 120.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":120,\"switching\":false,\"orderCode\":\"2171536909372605\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-18T09:39:47.54+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Colt Boyer - Tickets : 2\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":120,\"switching\":false,\"orderCode\":\"2171536909372605\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-18T09:39:47.54+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Colt Boyer - Tickets : 2\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-18 13:39:50', '2024-11-18 13:39:50'),
(16, 20, 47, 0.00, 0.00, 300.00, 'complete', 'paid', '{\"email\":\"pratik@travash.com\",\"bankId\":\"NET_MASTER\",\"amount\":300,\"switching\":false,\"orderCode\":\"5109314113772601\",\"statusId\":\"F\",\"fullName\":\"pratik test\",\"insDate\":\"2024-11-19T12:50:30.133+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Colt Boyer - Tickets : 5\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"pratik@travash.com\",\"bankId\":\"NET_MASTER\",\"amount\":300,\"switching\":false,\"orderCode\":\"5109314113772601\",\"statusId\":\"F\",\"fullName\":\"pratik test\",\"insDate\":\"2024-11-19T12:50:30.133+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Colt Boyer - Tickets : 5\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-19 16:50:32', '2024-11-19 16:50:32'),
(17, 21, 12, 0.00, 0.00, 755.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"1146059701172604\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-25T13:06:22.46+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 5\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"1146059701172604\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-25T13:06:22.46+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 5\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-25 17:06:24', '2024-11-25 17:06:24');
INSERT INTO `payment_histories` (`id`, `order_id`, `user_id`, `discount`, `tax`, `grand_total`, `status`, `payment_status`, `previous_response`, `current_response`, `created_at`, `updated_at`) VALUES
(18, 22, 12, 0.00, 0.00, 755.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"9710676449272606\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-25T16:35:21.913+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 5\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":755,\"switching\":false,\"orderCode\":\"9710676449272606\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-25T16:35:21.913+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 5\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-25 20:35:24', '2024-11-25 20:35:24'),
(19, 23, 12, 0.00, 0.00, 604.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":604,\"switching\":false,\"orderCode\":\"7631620599272601\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-25T16:57:23.203+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 4\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":604,\"switching\":false,\"orderCode\":\"7631620599272601\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-11-25T16:57:23.203+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 4\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-25 20:57:24', '2024-11-25 20:57:24'),
(20, 24, 47, 0.00, 0.00, 302.00, 'complete', 'paid', '{\"email\":\"pratik@travash.com\",\"bankId\":\"NET_MASTER\",\"amount\":302,\"switching\":false,\"orderCode\":\"3486122537672605\",\"statusId\":\"F\",\"fullName\":\"pratik test\",\"insDate\":\"2024-11-26T08:36:40.567+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 2\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"pratik@travash.com\",\"bankId\":\"NET_MASTER\",\"amount\":302,\"switching\":false,\"orderCode\":\"3486122537672605\",\"statusId\":\"F\",\"fullName\":\"pratik test\",\"insDate\":\"2024-11-26T08:36:40.567+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 2\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-11-26 12:36:42', '2024-11-26 12:36:42'),
(21, 25, 12, 0.00, 0.00, 604.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":604,\"switching\":false,\"orderCode\":\"3246120411072605\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-12-03T13:04:25.07+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 4\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":604,\"switching\":false,\"orderCode\":\"3246120411072605\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-12-03T13:04:25.07+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 4\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-12-03 17:04:26', '2024-12-03 17:04:26'),
(22, 26, 12, 0.00, 0.00, 906.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":906,\"switching\":false,\"orderCode\":\"7894811151272604\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-12-06T12:05:09.843+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 6\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":906,\"switching\":false,\"orderCode\":\"7894811151272604\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-12-06T12:05:09.843+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Donovan Rosario - Tickets : 6\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-12-06 10:05:12', '2024-12-06 10:05:12'),
(23, 27, 12, 0.00, 0.00, 3793.00, 'complete', 'paid', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":3793,\"switching\":false,\"orderCode\":\"4495176020372602\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-12-06T15:55:16.753+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Herman Hodge - Tickets : 20 | Donovan Rosario - Tickets : 23 | Isabelle Hensley - Tickets : 28\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '{\"email\":\"yhvreddy@outlook.com\",\"bankId\":\"NET_MASTER\",\"amount\":3793,\"switching\":false,\"orderCode\":\"4495176020372602\",\"statusId\":\"F\",\"fullName\":\"Harsha\",\"insDate\":\"2024-12-06T15:55:16.753+02:00\",\"cardNumber\":\"537489XXXXXX4682\",\"currencyCode\":\"978\",\"customerTrns\":\"Herman Hodge - Tickets : 20 | Donovan Rosario - Tickets : 23 | Isabelle Hensley - Tickets : 28\",\"merchantTrns\":null,\"transactionTypeId\":5,\"recurringSupport\":false,\"totalInstallments\":0,\"cardCountryCode\":\"MT\",\"cardIssuingBank\":\"Viva Payment Services S.a.\",\"currentInstallment\":0,\"cardUniqueReference\":\"EDD29D91A9C8C26A677AE3767C09869C942F9FAE\",\"cardTypeId\":1,\"digitalWalletId\":null}', '2024-12-06 13:55:19', '2024-12-06 13:55:19');

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

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

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

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

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'add', 'admin', '2024-05-01 06:40:23', '2024-05-01 06:40:23'),
(2, 'edit', 'admin', '2024-05-01 06:45:59', '2024-05-01 06:45:59'),
(3, 'delete', 'admin', '2024-05-01 06:45:59', '2024-05-01 06:45:59');

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int(10) UNSIGNED NOT NULL,
  `question` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `correct_answer` varchar(250) DEFAULT NULL,
  `correct_answer_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`id`, `question`, `created_at`, `updated_at`, `correct_answer`, `correct_answer_id`) VALUES
(2, 'Sample question 2', '2024-07-18 01:28:38', '2024-07-18 01:28:38', '22', 6);

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

--
-- Table structure for table `question_options`
--

CREATE TABLE `question_options` (
  `id` int(10) UNSIGNED NOT NULL,
  `question_id` int(10) UNSIGNED NOT NULL,
  `option` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `question_options`
--

INSERT INTO `question_options` (`id`, `question_id`, `option`, `created_at`, `updated_at`) VALUES
(5, 2, '11', '2024-07-18 01:28:38', '2024-07-18 01:29:06'),
(6, 2, '22', '2024-07-18 01:28:38', '2024-07-18 01:29:06'),
(7, 2, '33', '2024-07-18 01:28:38', '2024-07-18 01:29:06'),
(8, 2, '44', '2024-07-18 01:28:38', '2024-07-18 01:29:06');

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

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

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

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'User', 'web', '2024-05-01 06:40:23', '2024-05-01 06:40:23'),
(2, 'admin', 'web', '2024-05-01 06:45:59', '2024-05-01 06:45:59');

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

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

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

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `fav_icon` varchar(255) DEFAULT NULL,
  `copyrights` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `title`, `description`, `image`, `mobile`, `phone`, `email`, `type`, `logo`, `fav_icon`, `copyrights`, `url`, `link`, `created_at`, `updated_at`) VALUES
(1, 'Dovehouse Capital', NULL, NULL, '+91 1234567890', NULL, 'pratik@travash.com', 'site_details', 'public/uploads/settings/ggThEkkmQ54QmXwzPtDFkR6E0LpzqLT0TUjkuTdA.png', 'public/uploads/settings/Dsh9s62T3yuUlyfM4derf6cBklPKa5yZsbP8sgig.png', 'dovehouse capital', NULL, NULL, '2024-05-30 14:13:39', '2025-02-18 00:19:03'),
(172, 'tiktok', NULL, NULL, NULL, NULL, NULL, 'social_media', NULL, NULL, NULL, NULL, NULL, '2025-02-27 12:59:56', '2025-02-27 12:59:56'),
(171, 'twitter', NULL, NULL, NULL, NULL, NULL, 'social_media', NULL, NULL, NULL, NULL, NULL, '2025-02-27 12:59:56', '2025-02-27 12:59:56'),
(170, 'facebook', NULL, NULL, NULL, NULL, NULL, 'social_media', NULL, NULL, NULL, NULL, NULL, '2025-02-27 12:59:56', '2025-02-27 12:59:56'),
(32, NULL, NULL, 'public/uploads/settings/IdiggaJi0lrJGSVKpyjh3xvv9Ps3bcOWeK7InGWX.png', NULL, NULL, NULL, 'sold_out_image', NULL, NULL, NULL, NULL, NULL, '2024-07-19 04:57:10', '2025-02-17 04:47:41'),
(169, 'instagram', NULL, NULL, NULL, NULL, NULL, 'social_media', NULL, NULL, NULL, NULL, NULL, '2025-02-27 12:59:56', '2025-02-27 12:59:56'),
(168, 'youtube', NULL, NULL, NULL, NULL, NULL, 'social_media', NULL, NULL, NULL, NULL, NULL, '2025-02-27 12:59:56', '2025-02-27 12:59:56');

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `is_subscribe` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0: Inactive, 1: Active, 2: Unsubscribe',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`id`, `email`, `is_subscribe`, `created_at`, `updated_at`) VALUES
(1, 'yhvreddydev@gmail.com', 1, '2024-12-13 06:09:45', '2024-12-13 06:09:45'),
(2, 'yhvreddy@outlook.com', 1, '2024-12-13 06:33:42', '2024-12-13 06:33:42');

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

--
-- Table structure for table `users_fav_contests`
--

CREATE TABLE `users_fav_contests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `contest_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_additional_info`
--

CREATE TABLE `user_additional_info` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `timezone` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `flat_no` varchar(250) DEFAULT NULL,
  `landmark` varchar(250) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `profile_pic` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `country_code` varchar(15) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `postal_code` varchar(250) DEFAULT NULL,
  `country` varchar(250) DEFAULT NULL,
  `iso2` varchar(250) DEFAULT NULL,
  `gender` varchar(250) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_additional_info`
--

INSERT INTO `user_additional_info` (`id`, `user_id`, `dob`, `language`, `timezone`, `address`, `flat_no`, `landmark`, `phone`, `profile_pic`, `created_at`, `updated_at`, `country_code`, `city`, `state`, `postal_code`, `country`, `iso2`, `gender`) VALUES
(1, 58, '1995-10-17', NULL, NULL, 'df', 'sam', 'sdfdss', '+91890000922', 'public/uploads/customer_profile/YJWpfGFEvLJhKLjInIt0r0AcFCnVYPKkPUn5i6A1.jpg', '2024-12-11 07:30:35', '2024-12-23 10:12:12', '91', 'sdf', 'sdf', '343543', 'India', 'in', 'male'),
(2, 59, '2000-12-12', 'Select Language', '0', 'fsfsfsf', '423342', '2424242', '+919573304387', NULL, '2024-12-11 07:42:13', '2024-12-11 07:44:54', '91', 'sfsfsfsd', 'fsfsfsfs', '423423', 'India', 'in', 'male');

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

--
-- Table structure for table `user_answers`
--

CREATE TABLE `user_answers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `question_id` int(10) UNSIGNED NOT NULL,
  `answer_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_answers`
--

INSERT INTO `user_answers` (`id`, `user_id`, `question_id`, `answer_id`, `created_at`, `updated_at`) VALUES
(1, 58, 2, 6, '2024-12-23 07:04:05', '2024-12-23 07:04:05');

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

--
-- Table structure for table `user_carts`
--

CREATE TABLE `user_carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip_address` varchar(150) NOT NULL,
  `item_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price` double NOT NULL DEFAULT 0,
  `total_price` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_carts`
--

INSERT INTO `user_carts` (`id`, `ip_address`, `item_id`, `user_id`, `quantity`, `price`, `total_price`, `created_at`, `updated_at`) VALUES
(11, '106.221.191.122', 1, 59, 2, 151, 302, '2024-12-17 08:07:48', '2024-12-17 08:08:33'),
(10, '49.43.219.77', 2, 59, 4, 0.5, 2, '2024-12-17 08:04:12', '2024-12-17 08:04:12');

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

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

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

--
-- Indexes for table `contest_images`
--
ALTER TABLE `contest_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contest_images_contest_id_foreign` (`contest_id`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `faqs_category_foreign` (`category`);

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

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

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

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

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`),
  ADD KEY `news_category_id_foreign` (`category_id`);

--
-- Indexes for table `orders_items`
--
ALTER TABLE `orders_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_items_order_id_foreign` (`order_id`),
  ADD KEY `orders_items_contest_id_foreign` (`contest_id`);

--
-- Indexes for table `orders_tickets`
--
ALTER TABLE `orders_tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_tickets_contest_id_foreign` (`contest_id`),
  ADD KEY `orders_tickets_user_id_foreign` (`user_id`),
  ADD KEY `orders_tickets_order_id_foreign` (`order_id`),
  ADD KEY `orders_tickets_item_id_foreign` (`item_id`);

--
-- Indexes for table `payment_histories`
--
ALTER TABLE `payment_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_histories_order_id_foreign` (`order_id`),
  ADD KEY `payment_histories_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `question_options`
--
ALTER TABLE `question_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `question_options_question_id_foreign` (`question_id`);

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

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

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

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

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

--
-- Indexes for table `user_additional_info`
--
ALTER TABLE `user_additional_info`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_additional_info_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `user_carts`
--
ALTER TABLE `user_carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_carts_item_id_foreign` (`item_id`),
  ADD KEY `user_carts_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `contests`
--
ALTER TABLE `contests`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `contest_images`
--
ALTER TABLE `contest_images`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;

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

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `faq_categories`
--
ALTER TABLE `faq_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `orders_items`
--
ALTER TABLE `orders_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `orders_tickets`
--
ALTER TABLE `orders_tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `payment_histories`
--
ALTER TABLE `payment_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `question_options`
--
ALTER TABLE `question_options`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `users_fav_contests`
--
ALTER TABLE `users_fav_contests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_additional_info`
--
ALTER TABLE `user_additional_info`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `user_answers`
--
ALTER TABLE `user_answers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user_carts`
--
ALTER TABLE `user_carts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `contest_images`
--
ALTER TABLE `contest_images`
  ADD CONSTRAINT `contest_images_contest_id_foreign` FOREIGN KEY (`contest_id`) REFERENCES `contests` (`id`) ON DELETE CASCADE;

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

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

--
-- Constraints for table `news`
--
ALTER TABLE `news`
  ADD CONSTRAINT `news_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `question_options`
--
ALTER TABLE `question_options`
  ADD CONSTRAINT `question_options_question_id_foreign` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE CASCADE;

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

