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

START TRANSACTION;



--
-- Database: `gametopu_games`
--

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

--
-- Table structure for table `auto_vouchers`
--

CREATE TABLE `auto_vouchers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `variation_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `transaction_id` varchar(55) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `track_id` varchar(25) NOT NULL,
  `status` enum('unpaid','paid') NOT NULL DEFAULT 'unpaid',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(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 `jobs`
--

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

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(6711, 'default', '{\"uuid\":\"580dbc37-7823-4b51-a3df-d78031bbdd5b\",\"displayName\":\"App\\\\Mail\\\\OrderPlaced\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":15:{s:8:\\\"mailable\\\";O:20:\\\"App\\\\Mail\\\\OrderPlaced\\\":3:{s:5:\\\"order\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:16:\\\"App\\\\Models\\\\Order\\\";s:2:\\\"id\\\";i:29;s:9:\\\"relations\\\";a:3:{i:0;s:4:\\\"user\\\";i:1;s:9:\\\"variation\\\";i:2;s:7:\\\"product\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:12:\\\"rx@gmail.com\\\";}}s:6:\\\"mailer\\\";s:4:\\\"smtp\\\";}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"maxExceptions\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:3:\\\"job\\\";N;}\"}}', 0, NULL, 1746195110, 1746195110),
(6712, 'default', '{\"uuid\":\"5f5be243-86ce-4fd2-8e43-67700c443ce6\",\"displayName\":\"App\\\\Mail\\\\OrderPlaced\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":15:{s:8:\\\"mailable\\\";O:20:\\\"App\\\\Mail\\\\OrderPlaced\\\":3:{s:5:\\\"order\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:16:\\\"App\\\\Models\\\\Order\\\";s:2:\\\"id\\\";i:30;s:9:\\\"relations\\\";a:3:{i:0;s:4:\\\"user\\\";i:1;s:9:\\\"variation\\\";i:2;s:7:\\\"product\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:12:\\\"rx@gmail.com\\\";}}s:6:\\\"mailer\\\";s:4:\\\"smtp\\\";}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"maxExceptions\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:3:\\\"job\\\";N;}\"}}', 0, NULL, 1746195158, 1746195158);

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `collection_name` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `disk` varchar(255) NOT NULL,
  `conversions_disk` varchar(255) DEFAULT NULL,
  `size` bigint(20) NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) UNSIGNED 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 `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(45, 'App\\Models\\Popup', 2, '5c894204-030a-4972-8f79-3bc821cb3416', 'default', '1741531172_home_page_notice', '01JT8M0ZH4BKT3TV1ZQMX46DCW.jpg', 'image/jpeg', 'media', 'media', 292857, '[]', '[]', '[]', '[]', 1, '2025-05-02 13:47:25', '2025-05-02 13:47:25'),
(50, 'App\\Models\\Slider', 5, '641539f1-c85f-4848-b677-dcce2d2800fa', 'default', '01JNX7GAR9C9AR3DR89CT4JFKT', '01JXVCDTS1ZZQR0ZFWX4C88V6G.png', 'image/png', 'media', 'media', 205836, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:27:17', '2025-06-16 03:27:17'),
(51, 'App\\Models\\Slider', 4, '648f6dcb-5d43-4e1c-a884-4c994e3d6e23', 'default', '01JV02WV1XE0W0321ZA377QRXZ', '01JXVCDWKGWJ6Q010KKJRH5DE5.png', 'image/png', 'media', 'media', 750747, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:27:19', '2025-06-16 03:27:19'),
(52, 'App\\Models\\Slider', 6, '41fa3cb0-74b2-42e7-9431-15392b921bba', 'default', '01JMXXWW0SJ1Z5JDS75A9TNXHV', '01JXVCE8X2DPBBG9FDPTF106G9.jpg', 'image/jpeg', 'media', 'media', 498286, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:27:31', '2025-06-16 03:27:31'),
(53, 'App\\Models\\Product', 11, '5f390bcc-b767-421d-8caa-0e7dd31d4677', 'default', 'Untitled design', '01JXVCGC5VDM2G5XAHRNF0PEKN.png', 'image/png', 'media', 'media', 491138, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:28:40', '2025-06-16 03:28:40'),
(54, 'App\\Models\\Product', 15, 'aa28c67d-4b32-484e-a34c-1d14aa44fda0', 'default', '06022025214554880', '01JXVCHQJJS1CZBSCQ1R4ZE0DK.jpg', 'image/jpeg', 'media', 'media', 33283, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:29:25', '2025-06-16 03:29:25'),
(55, 'App\\Models\\Product', 14, 'a09a6317-1d35-4818-9a52-209483035fc7', 'default', '4', '01JXVCJ3Z3WZTGP3BDQ37RKFXR.png', 'image/png', 'media', 'media', 536825, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:29:37', '2025-06-16 03:29:37'),
(56, 'App\\Models\\Product', 13, '4a8ec5ae-1b42-4cfb-b163-cb196b9f7213', 'default', '3', '01JXVCJ6967D2EBF7T41C9QAKJ.png', 'image/png', 'media', 'media', 496170, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:29:40', '2025-06-16 03:29:40'),
(57, 'App\\Models\\Product', 12, '82bff89c-ed3b-482e-87b8-f0127bdb094f', 'default', '0402202505812580', '01JXVCJYQX0YB5BKPBEQ5Z5BGF.jpg', 'image/jpeg', 'media', 'media', 35567, '[]', '[]', '[]', '[]', 1, '2025-06-16 03:30:05', '2025-06-16 03:30:05');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `icon` text NOT NULL,
  `type` enum('user','guest','both') NOT NULL DEFAULT 'both',
  `order_column` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `link`, `icon`, `type`, `order_column`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Home', '/', '<svg data-v-7cfb45cd=\"\" width=\"25\" height=\"25\" viewBox=\"0 0 42 42\" class=\"inline-block mb-1\"><g data-v-7cfb45cd=\"\" stroke=\"none\" stroke-width=\"1\" fill=\"none\" fill-rule=\"evenodd\"><path data-v-7cfb45cd=\"\" d=\"M21.0847458,3.38674884 C17.8305085,7.08474576 17.8305085,10.7827427 21.0847458,14.4807396 C24.3389831,18.1787365 24.3389831,22.5701079 21.0847458,27.6548536 L21.0847458,42 L8.06779661,41.3066256 L6,38.5331279 L6,26.2681048 L6,17.2542373 L8.88135593,12.4006163 L21.0847458,2 L21.0847458,3.38674884 Z\" fill=\"currentColor\" fill-opacity=\"0.1\"></path> <path data-v-7cfb45cd=\"\" d=\"M11,8 L33,8 L11,8 Z M39,17 L39,36 C39,39.3137085 36.3137085,42 33,42 L11,42 C7.6862915,42 5,39.3137085 5,36 L5,17 L7,17 L7,36 C7,38.209139 8.790861,40 11,40 L33,40 C35.209139,40 37,38.209139 37,36 L37,17 L39,17 Z\" fill=\"currentColor\"></path> <path data-v-7cfb45cd=\"\" d=\"M22,27 C25.3137085,27 28,29.6862915 28,33 L28,41 L16,41 L16,33 C16,29.6862915 18.6862915,27 22,27 Z\" stroke=\"currentColor\" stroke-width=\"2\" fill=\"currentColor\" fill-opacity=\"0.1\"></path> <rect data-v-7cfb45cd=\"\" fill=\"currentColor\" transform=\"translate(32.000000, 11.313708) scale(-1, 1) rotate(-45.000000) translate(-32.000000, -11.313708) \" x=\"17\" y=\"10.3137085\" width=\"30\" height=\"2\" rx=\"1\"></rect> <rect data-v-7cfb45cd=\"\" fill=\"currentColor\" transform=\"translate(12.000000, 11.313708) rotate(-45.000000) translate(-12.000000, -11.313708) \" x=\"-3\" y=\"10.3137085\" width=\"30\" height=\"2\" rx=\"1\"></rect></g></svg>', 'both', 0, 1, '2024-06-30 18:50:15', '2024-06-30 18:50:15'),
(2, 'Tutorial', '/page/tutorials', '<svg data-v-7cfb45cd=\"\" viewBox=\"0 0 24 24\" width=\"25\" height=\"25\" stroke=\"currentColor\" stroke-width=\"2\" fill=\"none\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"inline-block mb-1\"><path data-v-7cfb45cd=\"\" d=\"M22.54 6.42a2.78 2.78 0 0 0-1.94-2C18.88 4 12 4 12 4s-6.88 0-8.6.46a2.78 2.78 0 0 0-1.94 2A29 29 0 0 0 1 11.75a29 29 0 0 0 .46 5.33A2.78 2.78 0 0 0 3.4 19c1.72.46 8.6.46 8.6.46s6.88 0 8.6-.46a2.78 2.78 0 0 0 1.94-2 29 29 0 0 0 .46-5.25 29 29 0 0 0-.46-5.33z\"></path> <polygon data-v-7cfb45cd=\"\" points=\"9.75 15.02 15.5 11.75 9.75 8.48 9.75 15.02\"></polygon></svg>', 'guest', 0, 1, '2024-06-30 18:50:53', '2024-07-01 09:50:48'),
(3, 'Topup', '/?#topup', '<svg data-v-7cfb45cd=\"\" width=\"25\" height=\"25\" viewBox=\"0 0 42 42\" class=\"inline-block mb-1\"><g data-v-7cfb45cd=\"\" stroke=\"none\" stroke-width=\"1\" fill=\"none\" fill-rule=\"evenodd\"><path data-v-7cfb45cd=\"\" d=\"M20.5890101,0.254646884 C12.8696785,5.50211755 8.0025785,14.258415 14.1941217,18.8708225 C23.16683,25.5550669 13.3362326,40.2698884 33.1021758,38.4149164 C29.6814884,40.8311956 25.5065164,42.2507054 21,42.2507054 C9.40202025,42.2507054 0,32.8486852 0,21.2507054 C0,9.79003409 9.18071714,0.473634138 20.5890101,0.254646884 Z\" fill=\"currentColor\" opacity=\"0.1\"></path> <path data-v-7cfb45cd=\"\" d=\"M25.9500282,20.3643496 L22.4308312,38.2677802 C22.3775703,38.5387376 22.1147395,38.7152155 21.8437821,38.6619546 C21.6570955,38.6252584 21.507413,38.4857901 21.4576354,38.3021581 L16.5951895,20.3643496 L20.099732,4.44663907 C20.1385204,4.27046145 20.2692032,4.12883813 20.4417012,4.07604096 C20.7057521,3.99522179 20.9853245,4.14376046 21.0661436,4.40781135 L25.9500282,20.3643496 Z M21.3022963,22.2852638 C22.4068658,22.2852638 23.3022963,21.3898333 23.3022963,20.2852638 C23.3022963,19.1806943 22.4068658,18.2852638 21.3022963,18.2852638 C20.1977268,18.2852638 19.3022963,19.1806943 19.3022963,20.2852638 C19.3022963,21.3898333 20.1977268,22.2852638 21.3022963,22.2852638 Z\" fill=\"currentColor\" transform=\"translate(21.272609, 20.629524) rotate(-315.000000) translate(-21.272609, -20.629524) \"></path> <circle data-v-7cfb45cd=\"\" stroke=\"currentColor\" stroke-width=\"2\" cx=\"21\" cy=\"21\" r=\"20\"></circle></g></svg>', 'guest', 0, 1, '2024-06-30 18:51:37', '2024-06-30 18:51:37'),
(4, 'Add Fund', '/add-funds', '<svg data-v-7cfb45cd=\"\" width=\"25\" height=\"25\" viewBox=\"0 0 24 24\" class=\"w-6 h-6 inline-block mb-1\">\n  <g data-v-7cfb45cd=\"\" stroke=\"none\" stroke-width=\"1\" fill=\"none\" fill-rule=\"evenodd\">\n    <path data-v-7cfb45cd=\"\" fill=\"currentColor\" d=\"M3 0V3H0V5H3V8H5V5H8V3H5V0H3M10 3V5H19V7H13C11.9 7 11 7.9 11 9V15C11 16.1 11.9 17 13 17H19V19H5V10H3V19C3 20.1 3.89 21 5 21H19C20.1 21 21 20.1 21 19V16.72C21.59 16.37 22 15.74 22 15V9C22 8.26 21.59 7.63 21 7.28V5C21 3.9 20.1 3 19 3H10M13 9H20V15H13V9M16 10.5A1.5 1.5 0 0 0 14.5 12A1.5 1.5 0 0 0 16 13.5A1.5 1.5 0 0 0 17.5 12A1.5 1.5 0 0 0 16 10.5Z\"></path>\n  </g>\n</svg>', 'user', 0, 1, '2024-06-30 18:52:26', '2024-06-30 18:52:26'),
(5, 'My Orders', '/orders', '<svg data-v-7cfb45cd=\"\" width=\"25\" height=\"25\" viewBox=\"0 0 24 24\" class=\"w-6 h-6 inline-block mb-1\">\n  <g data-v-7cfb45cd=\"\" fill=\"none\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2\" stroke=\"currentColor\">\n    <path data-v-7cfb45cd=\"\" d=\"M5 5a2 2 0 012-2h10a2 2 0 012 2v16l-7-3.5L5 21V5z\"></path>\n  </g>\n</svg>', 'user', 0, 1, '2024-06-30 18:52:51', '2024-06-30 18:52:51'),
(6, 'My Codes', '/codes', '<svg data-v-7cfb45cd=\"\" width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" class=\"css-i6dzq1 inline-block mb-1\" stroke=\"currentColor\" stroke-width=\"2\" fill=\"none\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect data-v-7cfb45cd=\"\" x=\"3\" y=\"3\" width=\"7\" height=\"7\"></rect> <rect data-v-7cfb45cd=\"\" x=\"14\" y=\"3\" width=\"7\" height=\"7\"></rect> <rect data-v-7cfb45cd=\"\" x=\"14\" y=\"14\" width=\"7\" height=\"7\"></rect> <rect data-v-7cfb45cd=\"\" x=\"3\" y=\"14\" width=\"7\" height=\"7\"></rect></svg>', 'user', 0, 1, '2024-06-30 18:53:13', '2024-06-30 18:53:13'),
(7, 'Account', '/account', '<svg data-v-7cfb45cd=\"\" width=\"25\" height=\"25\" viewBox=\"0 0 42 42\" class=\"inline-block mb-1\"><g data-v-7cfb45cd=\"\" stroke=\"none\" stroke-width=\"1\" fill=\"none\" fill-rule=\"evenodd\"><path data-v-7cfb45cd=\"\" d=\"M14.7118754,20.0876892 L8.03575361,20.0876892 C5.82661462,20.0876892 4.03575361,18.2968282 4.03575361,16.0876892 L4.03575361,12.031922 C4.03575361,8.1480343 6.79157254,4.90780265 10.4544842,4.15995321 C8.87553278,8.5612583 8.1226025,14.3600511 10.9452499,15.5413938 C13.710306,16.6986332 14.5947501,18.3118357 14.7118754,20.0876892 Z M14.2420017,23.8186831 C13.515543,27.1052019 12.7414284,30.2811559 18.0438552,31.7330419 L18.0438552,33.4450645 C18.0438552,35.6542035 16.2529942,37.4450645 14.0438552,37.4450645 L9.90612103,37.4450645 C6.14196811,37.4450645 3.09051926,34.3936157 3.09051926,30.6294627 L3.09051926,27.813861 C3.09051926,25.604722 4.88138026,23.813861 7.09051926,23.813861 L14.0438552,23.813861 C14.1102948,23.813861 14.1763561,23.8154808 14.2420017,23.8186831 Z M20.7553776,32.160536 C23.9336213,32.1190063 23.9061943,29.4103976 33.8698747,31.1666916 C34.7935223,31.3295026 35.9925894,31.0627305 37.3154077,30.4407183 C37.09778,34.8980343 33.4149547,38.4450645 28.9036761,38.4450645 C24.9909035,38.4450645 21.701346,35.7767637 20.7553776,32.160536 Z\" fill=\"currentColor\" opacity=\"0.1\"></path> <g data-v-7cfb45cd=\"\" transform=\"translate(2.000000, 3.000000)\"><path data-v-7cfb45cd=\"\" d=\"M8.5,1 C4.35786438,1 1,4.35786438 1,8.5 L1,13 C1,14.6568542 2.34314575,16 4,16 L13,16 C14.6568542,16 16,14.6568542 16,13 L16,4 C16,2.34314575 14.6568542,1 13,1 L8.5,1 Z\" stroke=\"currentColor\" stroke-width=\"2\"></path> <path data-v-7cfb45cd=\"\" d=\"M4,20 C2.34314575,20 1,21.3431458 1,23 L1,27.5 C1,31.6421356 4.35786438,35 8.5,35 L13,35 C14.6568542,35 16,33.6568542 16,32 L16,23 C16,21.3431458 14.6568542,20 13,20 L4,20 Z\" stroke=\"currentColor\" stroke-width=\"2\"></path> <path data-v-7cfb45cd=\"\" d=\"M23,1 C21.3431458,1 20,2.34314575 20,4 L20,13 C20,14.6568542 21.3431458,16 23,16 L32,16 C33.6568542,16 35,14.6568542 35,13 L35,8.5 C35,4.35786438 31.6421356,1 27.5,1 L23,1 Z\" stroke=\"currentColor\" stroke-width=\"2\"></path> <path data-v-7cfb45cd=\"\" d=\"M34.5825451,33.4769886 L38.3146092,33.4322291 C38.8602707,33.4256848 39.3079219,33.8627257 39.3144662,34.4083873 C39.3145136,34.4123369 39.3145372,34.4162868 39.3145372,34.4202367 L39.3145372,34.432158 C39.3145372,34.9797651 38.8740974,35.425519 38.3265296,35.4320861 L34.5944655,35.4768456 C34.048804,35.4833899 33.6011528,35.046349 33.5946085,34.5006874 C33.5945611,34.4967378 33.5945375,34.4927879 33.5945375,34.488838 L33.5945375,34.4769167 C33.5945375,33.9293096 34.0349773,33.4835557 34.5825451,33.4769886 Z\" fill=\"currentColor\" transform=\"translate(36.454537, 34.454537) rotate(-315.000000) translate(-36.454537, -34.454537) \"></path> <circle data-v-7cfb45cd=\"\" stroke=\"currentColor\" stroke-width=\"2\" cx=\"27.5\" cy=\"27.5\" r=\"7.5\"></circle></g></g></svg>', 'both', 0, 1, '2024-06-30 18:53:45', '2024-06-30 18:53:45');

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

--
-- 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),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_12_14_083707_create_settings_table', 1),
(6, '2024_01_05_061344_create_media_table', 1),
(7, '2024_01_05_131145_create_pages_table', 1),
(8, '2024_01_05_131543_create_popups_table', 1),
(9, '2024_01_05_153517_create_deposits_table', 1),
(10, '2024_01_05_153552_create_products_table', 1),
(11, '2024_01_05_153632_create_sliders_table', 1),
(12, '2024_01_05_153653_create_transactions_table', 1),
(13, '2024_01_05_153738_create_variations_table', 1),
(14, '2024_01_05_153813_create_vouchers_table', 1),
(15, '2024_01_05_153814_create_orders_table', 1),
(16, '2024_01_16_060402_create_general_settings', 1),
(17, '2024_03_10_112630_create_jobs_table', 1),
(18, '2024_04_23_071649_create_menus_table', 1),
(19, '2024_06_28_151327_create_auto_vouchers_table', 1);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `variation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `delivery_message` text DEFAULT NULL,
  `account_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`account_info`)),
  `provider_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`provider_data`)),
  `voucher_code` varchar(255) DEFAULT NULL,
  `track_id` varchar(25) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `attempts` tinyint(4) NOT NULL DEFAULT 0,
  `status` enum('completed','processing','auto-processing','hold','pending','cancelled') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `profit` decimal(16,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `order_column` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `order_column`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Tutorial', 'tutorials', '<h2>কিভাবে আমাদের ওয়েবসাইটে একাউন্ট খুলবেন?</h2><p>ভিডিও দেখতে ক্লিক করুন- See Video</p><h2>কিভাবে ওয়ালেটে টাকা এড করবেন?</h2><p>ভিডিও দেখতে ক্লিক করুন- See Video</p><h2>কিভাবে ওয়ালেট ব্যবহার করে অর্ডার করবেন?</h2><p>ভিডিও দেখতে ক্লিক করুন- See Video</p><h2>কিভাবে গুগল ব্যাকআপ কোড পাবেন?</h2><p>ভিডিও দেখতে ক্লিক করুন- See Video</p><h2>কিভাবে ফেসবুক ব্যাকআপ কোড পাবেন?</h2><p>ভিডিও দেখতে ক্লিক করুন- See Video</p>', 1, 1, '2024-07-01 09:36:02', '2024-07-03 07:04:28'),
(3, 'Terms And Conditions', 'terms-and-conditions', '<h2>নিয়ম ও শর্তাবলী</h2><h3>পরিচিতিঃ-</h3><p>বিডি গেমস্ বাজার এ আপনাকে স্বাগতম। বিডি গেমস্ বাজার দ্বারা পরিচালিত এই সাইট ব্যবহার করার আগে অনুগ্রহ করে এই ব্যবহারকারীর শর্তগুলি পড়ুন। আমরা আমাদের পণ্য বিক্রয়ের উদ্দেশ্যে এই সাইটটি পরিচালনা করি। আপনি যদি আমাদের পণ্যগুলো ক্রয় করতে আগ্রহী হন তবে আমাদের শর্তাবলির সাথে সম্মত হওয়া বাধ্যতামূলক।</p><h3>প্রোডাক্ট বিক্রয়ঃ-</h3><p>বিডি গেমস্ বাজার ওয়েবসাইটে শুধুমাত্র ভার্চুয়াল বা ডিজিটাল পণ্য বিক্রয় করা হয়। এক্ষেত্রে আমরা বিভিন্ন গেমস এর মূদ্রা ক্রয় করতে বিভিন্ন রকম কারেন্সি ব্যবহার করে থাকি যেমন:(BDT/USD/AUD/RS)। এবং সেসব কারেন্সি ব্যবহার করে আমরা ব্যবহারকারীর পছন্দমতো পণ্য তাদের কাছে ভার্চুয়ালি ডেলিভার করে থাকি। এছাড়াও আমরা ব্যবহারকারীর ভার্চুয়াল ওয়ালেটে কারেন্সি ও প্রদান করে থাকি।</p><h3>ডেলিভারির সময়সীমাঃ-</h3><p>বিডি গেমস্ বাজার এর সকল ভার্চুয়াল প্রোডাক্ট অথবা ডিজিটাল প্রোডাক্ট ডেলিভারির সময়সীমা ১-১০ মিনিট। কোনো যান্ত্রিক ত্রুটি অথবা ওয়েবসাইট কর্মকর্তাদের কোনো সমস্যার কারণে ডেলিভারি সময়ে কিছুটা পরিবর্তন আসতে পারে তবে এ পরিবর্তন অবশ্যই ২৪ ঘন্টার বেশি নয়। এককথায় কোনো সমস্যা না থাকলে আমরা ১-১০ মিনিটের মধ্যে অর্ডারগুলো সম্পন্ন করে থাকি।</p><h3>রিটার্ন এবং রিফান্ড নীতিঃ-</h3><p><strong>রিফান্ড নীতি-</strong> ওয়েবসাইটের ওয়ালেটে টাকা এড করার পর সেটি দিয়ে আপনি ওয়েবসাইটের যেকোনো প্রোডাক্ট অর্ডার করতে পারবেন তবে ওয়ালেটের টাকা উত্তোলন করা সম্ভব নয়। আমাদের সিস্টেমে কোনো সমস্যা হওয়ার কারনে যদি আপনার অর্ডার এ ব্যঘাত ঘটে তাহলে আমরা সেই অর্ডারের সম্পূর্ন মূল্য আপনার ওয়েবসাইট ওয়ালেটে রিফান্ড দিয়ে দিবো। এছাড়াও আপনার গেম আইডি অথবা ডিজিটাল প্রোডাক্ট ডেলিভারির আইডি তে যদি কোনো সমস্যা থেকে থাকে এবং উক্ত সমস্যার কারণে যদি আমরা আপনার অর্ডার টি ডেলিভারি না করতে পারি তাহলেও আপনাকে আপনার প্রোডাক্ট এর সম্পূর্ণ মূল্য ওয়েবসাইট ওয়ালেটে রিফান্ড দেওয়া হবে।</p><p><strong>রিটার্ন নীতি-</strong> যেহেতু আমাদের ওয়েবসাইট পুরোপুরি ভার্চুয়াল এবং ডিজিটাল পণ্য বিক্রয় করে থাকে সেহেতু আমাদের কোনো প্রোডাক্ট রিটার্ন নেওয়া সম্ভব নয়। প্রোডাক্ট ডেলিভারির পর সম্পূর্ণ দায়ভার ওয়েবসাইট ব্যবহারকারীদের নেওয়া বাধ্যতামূলক।</p><h3>বিক্রয় পরবর্তী সেবাঃ-</h3><p>সার্ভিস এবং প্রোডাক্ট বিক্রয়ের পর আমরা ব্যবহারকারীদের প্রোডাক্ট সম্পর্কে তথ্য অথবা প্রোডাক্ট এর বিবরণ এবং প্রোডাক্ট ব্যবহার করা সম্পর্কে সহ যতটুকু সম্ভব সেবা দিয়ে থাকি। তবে প্রোডাক্ট বহির্ভূত কোনো সেবা আমরা প্রোডাক্ট বিক্রয়ের পর দিয়ে থাকি না।</p><p><br></p>', 3, 1, '2024-07-03 07:02:56', '2024-07-03 07:04:28'),
(4, 'Return And Refund Policy', 'return-and-refund-policy', '<h3>রিফান্ড পলিসিঃ-</h3><p>ওয়েবসাইটের ওয়ালেটে টাকা এড করার পর সেটি দিয়ে আপনি ওয়েবসাইটের যেকোনো প্রডাক্ট অর্ডার করতে পারবেন তবে ওয়ালেটের টাকা উত্তোলন করা সম্ভব নয়। আমাদের সিস্টেমে কোনো সমস্যা হওয়ার কারনে যদি আপনার অর্ডার এ ব্যঘাত ঘটে তাহলে আমরা সেই অর্ডারের সম্পূর্ন মূল্য আপনার ওয়েবসাইট ওয়ালেটে রিফান্ড দিয়ে দিবো। এছাড়াও আপনার গেম আইডি অথবা ডিজিটাল প্রোডাক্ট ডেলিভারির আইডি তে যদি কোনো সমস্যা থেকে থাকে এবং উক্ত সমস্যার কারণে যদি আমরা আপনার অর্ডার টি ডেলিভারি না করতে পারি তাহলেও আপনাকে আপনার প্রোডাক্ট এর সম্পূর্ণ মূল্য ওয়েবসাইট ওয়ালেটে রিফান্ড দেওয়া হবে।</p><h3>রিটার্ন পলিসিঃ-</h3><p>যেহেতু আমাদের ওয়েবসাইট পুরোপুরি ভার্চুয়াল এবং ডিজিটাল পণ্য বিক্রয় করে থাকে সেহেতু আমাদের কোনো প্রোডাক্ট রিটার্ন নেওয়া সম্ভব নয়। প্রোডাক্ট ডেলিভারির পর সম্পূর্ণ দায়ভার ওয়েবসাইট কাস্টমারের।</p><h3>সার্ভিস এবং প্রোডাক্ট বিক্রয়ের পর সেবাঃ-</h3><p>সার্ভিস এবং প্রোডাক্ট বিক্রয়ের পর আমরা আপনাকে প্রোডাক্ট সম্পর্কে তথ্য অথবা প্রোডাক্ট এর বিবরণ সহ যতটুকু সম্ভব সেবা দিয়ে থাকি। তবে নিয়ম বহির্ভূত কোনো সেবা আমরা প্রোডাক্ট বিক্রয়ের পর দিয়ে থাকি না।</p><p><br></p>', 4, 1, '2024-07-03 07:03:20', '2024-07-03 07:04:28'),
(5, 'Contact Us', 'contact-us', '<h1>Start a Conversation</h1><p><br></p><p><br></p><p>Whatsapp (#)</p><p>No time to wait around? we us usally respond within a few minutes.</p><p><br></p><p><br></p><p>Phone</p><p>we re online right a few now, talk with are team in real time.</p><p><br></p><p>Email (#)</p><p>No time to wait around? we us usally respond within a few hours.</p><p><br></p>', 2, 1, '2024-07-03 07:04:12', '2025-06-16 03:11:07');

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

--
-- Table structure for table `popups`
--

CREATE TABLE `popups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `type` enum('once','daily') NOT NULL DEFAULT 'once',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `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 `popups`
--

INSERT INTO `popups` (`id`, `url`, `content`, `button_text`, `type`, `status`, `created_at`, `updated_at`) VALUES
(2, 'https://t.me/crazy_lab_bd', '<p>যেকোন সমস্যা হলে \'ক্লিক করুন\' এ ক্লিক করে টেলিগ্রাম এ মেসেজ করুন</p>', 'ক্লিক করুন', 'daily', 1, '2025-05-02 13:47:25', '2025-05-02 13:51:44');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `type` enum('ingame','topup','voucher') NOT NULL,
  `percentage` int(11) DEFAULT 0,
  `order_column` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `uid_checker` tinyint(1) NOT NULL DEFAULT 0,
  `has_tutorial` tinyint(1) NOT NULL DEFAULT 0,
  `tutorial_link` varchar(1024) DEFAULT NULL,
  `tutorial_text` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `title`, `slug`, `content`, `type`, `percentage`, `order_column`, `status`, `created_at`, `updated_at`, `uid_checker`, `has_tutorial`, `tutorial_link`, `tutorial_text`) VALUES
(11, 'UID TOP UP (BD)', 'uid-top-up-bd', '<p>⦿ শুধুমাত্র Bangladesh সার্ভারে ID Code দিয়ে টপ আপ হবে।</p><p>⦿ Player ID Code ভুল দিয়ে Diamond না পেলে Games Bazar কর্তৃপক্ষ দায়ী নয়।</p><p>⦿ Order কমপ্লিট হওয়ার পরেও আইডিতে ডাইমন্ড না গেলে সাপোর্টে মেসেজ দিন। ⦿ অর্ডার Cancel হলে কি কারণে তা Cancel হয়েছে তা অর্ডার হিস্টোরিতে দেওয়া থাকে অনুগ্রহ পুর্বক দেখে পুনরায় সঠিক তথ্য দিয়ে অর্ডার করবেন ।</p>', 'topup', 0, 0, 1, '2025-05-02 10:21:27', '2025-05-02 10:21:27', 1, 0, NULL, NULL),
(12, 'UNIPIN+VOUCHER [CODE]', 'unipinvoucher-code', '<h2><strong>RULES &amp; CONDITIONS</strong><br><strong>অর্ডার করার আগে ভালো ভাবে পড়ে নিন</strong></h2><p>⦿ শুধুমাত্র BD সার্ভারে VOUCHER দিয়ে টপ আপ হবে</p><p>⦿&nbsp; কোড রিডিম করুন&nbsp; &nbsp;<strong>shop.garena.my</strong> থেকে ।</p><p>⦿ UPBD দেখালে Unipin Gift Card&nbsp; এ ব্যবহার করতে হবে</p><p>⦿ BDMB দেখালে Unipin Voucher এ ব্যবহার করতে হবে</p><p><br></p>', 'voucher', 0, 0, 1, '2025-05-02 13:26:56', '2025-05-02 13:26:56', 0, 0, NULL, NULL),
(13, 'EVO ACCESS', 'evo-access', '<p>Please Enter your Correct uid</p>', 'topup', 0, 0, 1, '2025-05-02 13:28:43', '2025-05-02 13:28:43', 1, 0, NULL, NULL),
(14, 'Airdrop UID TOP-UP', 'airdrop-uid-top-up', '<h2>Airdrop UID TOP-UP</h2><p><br></p>', 'topup', 0, 0, 1, '2025-05-02 13:29:26', '2025-05-02 13:29:26', 1, 0, NULL, NULL),
(15, 'Garena Shell', 'garena-shell', '<p>Garena Shell</p>', 'voucher', 0, 0, 1, '2025-05-02 14:03:52', '2025-05-02 14:03:52', 0, 0, NULL, NULL);

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `group` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT 0,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payload`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `group`, `name`, `locked`, `payload`, `created_at`, `updated_at`) VALUES
(1, 'general', 'site_name', 0, '\"RX GAME SHOP\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(2, 'general', 'site_title', 0, '\"Buy Free Fire Diamonds Easily\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(3, 'general', 'home_title', 0, '\"Home - RX GAME SHOP\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(4, 'general', 'paginate_per_page', 0, '20', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(5, 'general', 'logo', 0, '\"settings\\/01JXVC38CB83K22B4BY9AKDNBY.jpg\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(6, 'general', 'favicon', 0, '\"settings\\/01JXVC38CCD1721EAKKD4GVZZ4.jpg\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(7, 'general', 'add_money_video_link', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(8, 'general', 'backup_code_video_link', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(9, 'general', 'tutorial_video_link', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(10, 'general', 'google_client_id', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(11, 'general', 'google_client_secret', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(12, 'general', 'header_tags', 0, 'null', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(13, 'general', 'footer_js', 0, 'null', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(14, 'general', 'wallet', 0, 'true', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(15, 'general', 'smtp_from_address', 0, '\"info@6xfly.xyz\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(16, 'general', 'smtp_host', 0, '\"mail.6xfly.xyz\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(17, 'general', 'smtp_port', 0, '\"465\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(18, 'general', 'smtp_username', 0, '\"info@6xfly.xyz\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(19, 'general', 'smtp_password', 0, '\"ywK@6QBBcJ6m\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(20, 'general', 'uddoktapay_api_key', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(21, 'general', 'uddoktapay_api_url', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(22, 'general', 'uddoktapay_min_amount', 0, '20', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(23, 'general', 'uddoktapay_max_amount', 0, '50000', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(24, 'general', 'facebook_link', 0, '\"https:\\/\\/facebook.com\\/\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(25, 'general', 'youtube_link', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(26, 'general', 'messenger_link', 0, '\"https:\\/\\/m.me\\/\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(27, 'general', 'whatsapp_number', 0, '\"#\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(28, 'general', 'support_number', 0, '\"99999999999\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(29, 'general', 'email_address', 0, '\"admin@gmail.com\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(30, 'general', 'support_time', 0, '\"9AM - 10PM\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(31, 'general', 'background_image', 0, 'true', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(32, 'general', 'footer_menu', 0, 'true', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(33, 'general', 'theme_color', 0, '\"#077acb\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(34, 'general', 'logo_color', 0, '\"#424242\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(35, 'general', 'background_color', 0, '\"#f8f9fc\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(36, 'general', 'font_color', 0, '\"#000000\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(37, 'general', 'navigation_background_color', 0, '\"#ffffff\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(38, 'general', 'navigation_font_color', 0, '\"#000000\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(39, 'general', 'footer_color', 0, '\"#373e69\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(40, 'general', 'footer_font_color', 0, '\"#ffffff\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(41, 'general', 'content_box_color', 0, '\"#ffffff\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(42, 'general', 'notice_background_color', 0, '\"#077acb\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(43, 'general', 'notice_font_color', 0, '\"#ffffff\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(44, 'general', 'seo_description', 0, '\"Discover the ultimate destination for gaming products at Games Bazar. Shop the latest TopUp Events, Diamonds, Packages, and more online. Enjoy competitive prices, fast delivery, and excellent customer service. Elevate your gaming experience with BD Games Bazar.\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(45, 'general', 'seo_keywords', 0, '\"Free Fire,Topup,Id code,Free diamond,Garena,Topup garena,Fftopup,Ff topup,Ff hack,Diamond hack,Low price diamond,BD Games Bazar,bdgamesbazar.com,bdgamesbazar com,bdgamesbazar net,Free fire topup,Free fire airdrop,Garena shell,Uid topup,Weekly topup,Monthly topup,100\\u2105 bonus topup free fire,Less is more topup,Unipin voucher bd,Unipin buy,Weekly lite\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(46, 'general', 'fb_og_image', 0, 'null', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(47, 'general', 'twitter_og_image', 0, 'null', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(48, 'general', 'enable_notice', 0, 'true', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(49, 'general', 'notice_title', 0, 'null', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(50, 'general', 'notice_content', 0, '\"\\u0986\\u09ae\\u09be\\u09a6\\u09c7\\u09b0 \\u0993\\u09df\\u09c7\\u09ac\\u09b8\\u09be\\u0987\\u099f\\u09c7 \\u09e8\\u09ea \\u0998\\u09a8\\u09cd\\u099f\\u09be\\u0987 UniPin \\u09a8\\u09bf\\u09a4\\u09c7 \\u09aa\\u09be\\u09b0\\u09ac\\u09c7\\u09a8, \\u09e7 \\u09b8\\u09c7\\u0995\\u09c7\\u09a8\\u09cd\\u09a1\\u0987 \\u0985\\u099f\\u09cb \\u09a1\\u09c7\\u09b2\\u09bf\\u09ad\\u09be\\u09b0\\u09bf \\u09b9\\u09ac\\u09c7\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(51, 'general', 'base_currency', 0, '\"BDT\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(52, 'general', 'currency_symbol', 0, '\"\\u09f3\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(53, 'general', 'enable_pwa', 0, 'false', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(54, 'general', 'pwa_icon', 0, '\"settings\\/01J1PRZ8NWJ16ZSPPD73V63REK.jpg\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(55, 'general', 'enable_uid_checker', 0, 'false', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(56, 'general', 'enable_auto_topup', 0, 'false', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(57, 'general', 'topup_provider', 0, '\"FreeFire\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(58, 'general', 'free_fire_server_url', 0, '\"https:\\/\\/t.me\\/crazy_lab_bd\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(59, 'general', 'free_fire_server_api_key', 0, '\"https:\\/\\/t.me\\/crazy_lab_bd\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50'),
(60, 'general', 'version', 0, '\"1.1.4\"', '2024-06-30 17:25:57', '2025-06-16 03:23:50');

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `order_column` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sliders` (`id`, `url`, `order_column`, `status`, `created_at`, `updated_at`) VALUES
(4, '#', 0, 1, '2025-05-02 13:52:10', '2025-06-16 03:25:07'),
(5, '#', 0, 1, '2025-05-02 13:55:24', '2025-06-16 03:25:02'),
(6, '#', 0, 1, '2025-05-02 13:55:45', '2025-06-16 03:24:57');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `deposit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `payment_method` varchar(55) NOT NULL,
  `transaction_id` varchar(55) NOT NULL,
  `trx_type` enum('+','-') NOT NULL DEFAULT '-',
  `remarks` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `variations`
--

CREATE TABLE `variations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `stock` int(11) NOT NULL DEFAULT 0,
  `automatic` tinyint(4) NOT NULL DEFAULT 0,
  `provider` varchar(255) DEFAULT NULL,
  `provider_product_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `buy_rate` decimal(16,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variations`
--

INSERT INTO `variations` (`id`, `product_id`, `title`, `price`, `stock`, `automatic`, `provider`, `provider_product_id`, `created_at`, `updated_at`, `buy_rate`) VALUES
(70, 11, '25 Diamond', 22.00, 999998, 0, NULL, NULL, '2025-05-02 10:22:31', '2025-05-02 14:12:38', 22.00),
(71, 11, '50 Diamond', 45.00, 99999, 0, NULL, NULL, '2025-05-02 10:23:25', '2025-05-02 10:23:25', 45.00),
(72, 12, '20 UC', 19.00, 99998, 0, NULL, NULL, '2025-05-02 13:31:59', '2025-05-02 14:11:50', 19.00);

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

--
-- Table structure for table `visitors`
--

CREATE TABLE `visitors` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `visited_at` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `visitors`
--

INSERT INTO `visitors` (`id`, `ip_address`, `visited_at`, `created_at`, `updated_at`) VALUES
(2681, '103.134.57.114', '2025-05-02', '2025-05-02 10:06:39', '2025-05-02 10:06:39'),
(2682, '103.134.57.113', '2025-05-02', '2025-05-02 10:07:41', '2025-05-02 10:07:41'),
(2683, '3.21.129.107', '2025-05-02', '2025-05-02 10:32:58', '2025-05-02 10:32:58'),
(2684, '149.154.161.197', '2025-05-02', '2025-05-02 10:46:58', '2025-05-02 10:46:58'),
(2685, '103.24.16.244', '2025-05-02', '2025-05-02 10:47:11', '2025-05-02 10:47:11'),
(2686, '149.154.161.198', '2025-05-02', '2025-05-02 10:47:32', '2025-05-02 10:47:32'),
(2687, '103.69.150.77', '2025-05-02', '2025-05-02 10:48:31', '2025-05-02 10:48:31'),
(2688, '103.25.251.228', '2025-05-02', '2025-05-02 11:21:10', '2025-05-02 11:21:10'),
(2689, '103.79.179.0', '2025-05-02', '2025-05-02 11:21:26', '2025-05-02 11:21:26'),
(2690, '59.152.6.225', '2025-05-02', '2025-05-02 11:24:44', '2025-05-02 11:24:44'),
(2691, '149.154.161.253', '2025-05-02', '2025-05-02 13:02:59', '2025-05-02 13:02:59'),
(2692, '37.111.243.40', '2025-05-02', '2025-05-02 13:03:34', '2025-05-02 13:03:34'),
(2693, '2400:c600:3652:beeb:1:0:54a0:c223', '2025-05-02', '2025-05-02 13:05:25', '2025-05-02 13:05:25'),
(2694, '103.134.57.119', '2025-05-02', '2025-05-02 13:25:22', '2025-05-02 13:25:22'),
(2695, '103.79.179.3', '2025-05-02', '2025-05-02 13:58:05', '2025-05-02 13:58:05'),
(2696, '103.134.57.115', '2025-06-16', '2025-06-16 03:07:21', '2025-06-16 03:07:21'),
(2697, '23.106.56.11', '2025-06-16', '2025-06-16 03:30:22', '2025-06-16 03:30:22');

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

--
-- Table structure for table `vouchers`
--

CREATE TABLE `vouchers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `variation_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `transaction_id` varchar(55) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vouchers`
--

INSERT INTO `vouchers` (`id`, `variation_id`, `order_id`, `code`, `status`, `created_at`, `updated_at`, `transaction_id`) VALUES
(142, 72, 29, '\"BDMB-Q-S-05579854 8115-5347-6261-7754\"', 0, '2025-05-02 13:32:39', '2025-05-02 14:11:50', 'BNWKUMTFYKU9');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `auto_vouchers`
--
ALTER TABLE `auto_vouchers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auto_vouchers_variation_id_foreign` (`variation_id`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deposits_user_id_foreign` (`user_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 `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

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

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

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`);

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_slug_unique` (`slug`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_group_name_unique` (`group`,`name`);

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_transaction_id_unique` (`transaction_id`),
  ADD KEY `transactions_user_id_foreign` (`user_id`);

--
-- Indexes for table `variations`
--
ALTER TABLE `variations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variations_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vouchers_variation_id_foreign` (`variation_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `auto_vouchers`
--
ALTER TABLE `auto_vouchers`
  ADD CONSTRAINT `auto_vouchers_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `deposits`
--
ALTER TABLE `deposits`
  ADD CONSTRAINT `deposits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `variations`
--
ALTER TABLE `variations`
  ADD CONSTRAINT `variations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD CONSTRAINT `vouchers_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

