-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 25, 2026 at 09:25 AM
-- Server version: 11.8.6-MariaDB-log
-- PHP Version: 7.2.34

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u963586588_database1`
--

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

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

CREATE TABLE `vouchers` (
  `id` int(11) NOT NULL,
  `tenant_id` int(11) NOT NULL,
  `router_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `status` enum('unused','active','expired') DEFAULT 'unused',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `start_time` datetime DEFAULT NULL,
  `expiry_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `vouchers` (`id`, `tenant_id`, `router_id`, `package_id`, `code`, `status`, `created_at`, `active`, `start_time`, `expiry_time`) VALUES
(128, 80, 0, 7, 'KP27BA', 'unused', '2026-04-21 10:44:51', 1, NULL, NULL),
(129, 80, 0, 7, 'N8EV4S', 'unused', '2026-04-21 10:44:51', 1, NULL, NULL),
(130, 80, 0, 7, 'ZNTSP4', 'unused', '2026-04-21 10:49:14', 1, NULL, NULL),
(131, 80, 0, 9, 'HPQBTL', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(132, 80, 0, 9, 'UBW2HN', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(133, 80, 0, 9, 'EFC2ZW', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(134, 80, 0, 9, 'KG8WPX', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(135, 80, 0, 9, 'MKA7QB', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(136, 80, 0, 9, 'BKHE52', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(137, 80, 0, 9, 'RY46EB', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(138, 80, 0, 9, 'XWH39E', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(139, 80, 0, 9, 'FW7STL', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(140, 80, 0, 9, '56SZRT', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(141, 80, 0, 9, '3S9J27', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(143, 80, 0, 9, 'TF5H3L', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(145, 80, 0, 9, 'BUTGX2', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(146, 80, 0, 9, 'K5L3DA', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(147, 80, 0, 9, 'NJA4PX', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(148, 80, 0, 9, '6HX3TD', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(149, 80, 0, 9, 'JLKM4T', 'unused', '2026-04-21 13:07:52', 1, NULL, NULL),
(231, 80, 0, 7, 'RDXYQ5', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(232, 80, 0, 7, 'TAWX47', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(233, 80, 0, 7, 'R6EZTA', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(234, 80, 0, 7, 'ZVGWYR', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(235, 80, 0, 7, 'WHKS32', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(236, 80, 0, 7, 'ZRMU4Y', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(237, 80, 0, 7, 'N659SZ', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(238, 80, 0, 7, '6TCZG8', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(239, 80, 0, 7, 'DRYT6X', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(240, 80, 0, 7, 'GQSJA2', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(241, 80, 0, 7, '3U6D5L', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(242, 80, 0, 7, 'T82BKD', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(243, 80, 0, 7, 'FUPR4T', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(244, 80, 0, 7, 'KDWZA7', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(245, 80, 0, 7, '26UPAS', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(246, 80, 0, 7, 'EXKCN2', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(247, 80, 0, 7, 'U5RG4F', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(248, 80, 0, 7, 'KZ3CPH', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(249, 80, 0, 7, 'UBVMZ4', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(250, 80, 0, 7, 'AFKVXW', 'unused', '2026-04-21 16:21:24', 1, NULL, NULL),
(251, 80, 0, 7, 'LNDFQPU3C2JA', 'unused', '2026-04-21 16:23:24', 1, NULL, NULL),
(252, 80, 0, 7, 'UCTHLZ', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(253, 80, 0, 7, 'BHX7MK', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(254, 80, 0, 7, 'DU2ANV', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(255, 80, 0, 7, '6FZUQT', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(256, 80, 0, 7, 'XTZR9U', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(257, 80, 0, 7, 'K9F4SG', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(258, 80, 0, 7, 'VMB52E', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(259, 80, 0, 7, 'Z5R2EW', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(260, 80, 0, 7, 'PVMKNU', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(261, 80, 0, 7, '6CXK7P', 'unused', '2026-04-21 17:35:51', 1, NULL, NULL),
(262, 80, 0, 9, '5G7WAT', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(263, 80, 0, 9, '5RMTWV', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(264, 80, 0, 9, 'PF6QHB', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(265, 80, 0, 9, 'F5BTGD', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(266, 80, 0, 9, 'FY8KPT', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(267, 80, 0, 9, 'ZSQVNA', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(268, 80, 0, 9, 'JFPH39', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(269, 80, 0, 9, '7MR9LQ', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(270, 80, 0, 9, 'CUYGQL', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(271, 80, 0, 9, 'AR58GX', 'unused', '2026-04-21 17:38:39', 1, NULL, NULL),
(272, 80, 0, 9, 'QHVJKU', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(273, 80, 0, 9, 'NKDU36', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(274, 80, 0, 9, '5CNQ7S', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(275, 80, 0, 9, 'ES6NWH', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(276, 80, 0, 9, 'T7DYNB', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(277, 80, 0, 9, 'B6ESNL', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(278, 80, 0, 9, 'Q4KNDL', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(279, 80, 0, 9, 'CFRA9W', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(280, 80, 0, 9, 'R43SQU', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(281, 80, 0, 9, '5R8ZJ7', 'unused', '2026-04-21 17:38:43', 1, NULL, NULL),
(282, 80, 0, 9, '4G6UDB', 'unused', '2026-04-21 17:38:50', 1, NULL, NULL),
(283, 80, 0, 9, 'XUP325', 'unused', '2026-04-21 17:38:50', 1, NULL, NULL),
(284, 80, 0, 9, 'EMUJ53', 'unused', '2026-04-21 17:38:50', 1, NULL, NULL),
(285, 80, 0, 9, '83FCTM', 'unused', '2026-04-21 17:38:50', 1, NULL, NULL),
(286, 80, 0, 9, 'U2EB3J', 'unused', '2026-04-21 17:38:50', 1, NULL, NULL),
(287, 80, 0, 9, 'P9BXHM', 'unused', '2026-04-21 17:38:50', 1, NULL, NULL),
(288, 80, 0, 9, 'ES3TKM', 'unused', '2026-04-21 17:38:50', 1, NULL, NULL),
(289, 80, 0, 9, 'VA2DY4MR', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(290, 80, 0, 9, 'ZE3VXBMK', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(291, 80, 0, 9, 'FMADZN24', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(292, 80, 0, 9, 'LRQ8N27S', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(293, 80, 0, 9, 'L4FBQHXM', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(294, 80, 0, 9, 'ZVTWSXJ5', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(295, 80, 0, 9, 'LZSBXDQ8', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(296, 80, 0, 9, '2L59WZTG', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(297, 80, 0, 9, 'ABZRHQYD', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(298, 80, 0, 9, 'JWBENA8T', 'unused', '2026-04-21 19:11:15', 1, NULL, NULL),
(299, 80, 0, 9, 'QC5B3K', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(300, 80, 0, 9, 'FH2YKT', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(301, 80, 0, 9, '2ZTALN', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(303, 80, 0, 9, 'G6Y4BU', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(304, 80, 0, 9, 'CG6XZP', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(305, 80, 0, 9, '429XMJ', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(306, 80, 0, 9, '92LDFH', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(307, 80, 0, 9, '4SZYJD', 'unused', '2026-04-21 19:11:38', 1, NULL, NULL),
(309, 80, 0, 9, 'B25DK3', 'unused', '2026-04-21 19:40:15', 1, NULL, NULL),
(310, 80, 0, 9, '2QATU9', 'unused', '2026-04-21 19:40:15', 1, NULL, NULL),
(311, 80, 0, 9, 'D2VYZM', 'unused', '2026-04-21 19:40:15', 1, NULL, NULL),
(312, 80, 0, 9, 'VKX8MF', 'unused', '2026-04-21 19:40:15', 1, NULL, NULL),
(313, 80, 0, 9, 'LECXA4', 'unused', '2026-04-21 19:40:15', 1, NULL, NULL),
(317, 80, 0, 9, 'G9KPTV', 'unused', '2026-04-21 19:40:15', 1, NULL, NULL),
(318, 80, 0, 9, 'HPFNDR', 'unused', '2026-04-21 19:40:15', 1, NULL, NULL),
(319, 80, 0, 9, 'G3CP2A', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(320, 80, 0, 9, 'BKWQV6', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(323, 80, 0, 9, '8K2LQG', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(324, 80, 0, 9, 'CK2BXR', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(325, 80, 0, 9, 'WSCF3P', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(326, 80, 0, 9, 'XW8TUB', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(327, 80, 0, 9, 'DATZ2M', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(328, 80, 0, 9, 'QE5SHT', 'unused', '2026-04-21 20:34:47', 1, NULL, NULL),
(329, 80, 0, 9, 'L8J4YD', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(330, 80, 0, 9, '34ZMA8', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(331, 80, 0, 9, '285BFJ', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(332, 80, 0, 9, 'PBJU56', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(333, 80, 0, 9, 'QTFU63', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(334, 80, 0, 9, '238UJA', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(337, 80, 0, 9, '7A5TRE', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(338, 80, 0, 9, '6PQF5W', 'unused', '2026-04-21 20:52:23', 1, NULL, NULL),
(340, 80, 0, 9, '3TU98K', 'unused', '2026-04-22 03:53:41', 1, NULL, NULL),
(341, 80, 0, 9, 'U6YT9V', 'unused', '2026-04-22 03:53:41', 1, NULL, NULL),
(345, 80, 0, 9, '7JD4QS', 'unused', '2026-04-22 03:53:41', 1, NULL, NULL),
(346, 80, 0, 9, 'RG8FJT', 'unused', '2026-04-22 03:53:41', 1, NULL, NULL),
(347, 80, 0, 9, 'LFGCWS', 'unused', '2026-04-22 03:53:41', 1, NULL, NULL),
(349, 80, 0, 10, 'F4GVLQ', 'unused', '2026-04-22 06:01:53', 1, NULL, NULL),
(350, 80, 0, 10, 'P38BZR', 'unused', '2026-04-22 06:01:53', 1, NULL, NULL),
(351, 80, 0, 10, 'U76J8V', 'unused', '2026-04-22 06:01:53', 1, NULL, NULL),
(352, 80, 0, 10, 'CUN35A', 'unused', '2026-04-22 06:01:53', 1, NULL, NULL),
(354, 80, 0, 10, '9WGT2C', 'unused', '2026-04-22 06:01:53', 1, NULL, NULL),
(355, 80, 0, 10, 'MBPNTF', 'active', '2026-04-22 06:01:53', 1, NULL, NULL),
(356, 80, 0, 10, '3QVNA7', 'unused', '2026-04-22 06:01:53', 1, NULL, NULL),
(359, 80, 0, 10, 'QXBAYM', 'unused', '2026-04-22 06:01:53', 1, NULL, NULL),
(361, 80, 0, 10, 'NB8M95', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(362, 80, 0, 10, 'AQCK7S', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(363, 80, 0, 10, 'BVCTZA', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(364, 80, 0, 10, 'ZUHABT', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(365, 80, 0, 10, 'YH9ZE3', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(366, 80, 0, 10, '4CK2BQ', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(367, 80, 0, 10, 'AXS532', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(368, 80, 0, 10, '7PWZEA', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(369, 80, 0, 10, '8JBGRU', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(370, 80, 0, 10, 'T34MJU', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(371, 80, 0, 10, 'TG9WHD', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(372, 80, 0, 10, 'A6KPZT', 'active', '2026-04-22 10:14:14', 1, NULL, NULL),
(373, 80, 0, 10, 'MNUXDV', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(374, 80, 0, 10, 'PMYLUJ', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(375, 80, 0, 10, 'FPVWHE', 'unused', '2026-04-22 10:14:14', 1, NULL, NULL),
(376, 80, 0, 7, '6NG3VL', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(377, 80, 0, 7, 'HLD63W', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(378, 80, 0, 7, '4376CE', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(379, 80, 0, 7, 'GA46FB', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(380, 80, 0, 7, 'X7HV49', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(381, 80, 0, 7, 'NMEX47', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(382, 80, 0, 7, 'YLP4CK', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(383, 80, 0, 7, 'AWF4D3', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(384, 80, 0, 7, 'Q6GB3T', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(385, 80, 0, 7, 'J2XYFV', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(386, 80, 0, 7, 'ZK6WRP', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(387, 80, 0, 7, 'EV5X3C', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(388, 80, 0, 7, 'UTCPER', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(389, 80, 0, 7, 'M2DP6S', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(390, 80, 0, 7, '67G2B8', 'unused', '2026-04-22 12:35:10', 1, NULL, NULL),
(391, 80, 0, 7, 'GF6VY4', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(392, 80, 0, 7, 'K5MV24', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(393, 80, 0, 7, 'P9RF47', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(394, 80, 0, 7, 'E6ANVW', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(395, 80, 0, 7, 'TAQDM6', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(396, 80, 0, 7, 'FWQHB7', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(397, 80, 0, 7, 'TFGQRK', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(398, 80, 0, 7, 'GDKM52', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(399, 80, 0, 7, '3XLU5B', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(400, 80, 0, 7, '7EQMFV', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(401, 80, 0, 7, '5LK3DS', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(402, 80, 0, 7, 'P64KBU', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(403, 80, 0, 7, '9CF6DZ', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(404, 80, 0, 7, 'GBRVTK', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(405, 80, 0, 7, '4NG9AJ', 'unused', '2026-04-22 12:43:18', 1, NULL, NULL),
(406, 80, 0, 8, '2GPLHS', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(407, 80, 0, 8, 'N3YTWJ', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(408, 80, 0, 8, 'KQCWT4', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(409, 80, 0, 8, 'B9F2HU', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(410, 80, 0, 8, '8RGVCN', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(411, 80, 0, 8, '9CMUFT', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(412, 80, 0, 8, '2TXZHD', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(413, 80, 0, 8, 'UNRVJL', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(414, 80, 0, 8, 'RDBYWE', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(415, 80, 0, 8, 'CH8PYJ', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(416, 80, 0, 8, 'E4S7RJ', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(417, 80, 0, 8, '6WDP92', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(418, 80, 0, 8, '5MREVQ', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(419, 80, 0, 8, 'ENQ7P3', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(420, 80, 0, 8, 'C769GE', 'unused', '2026-04-22 12:57:18', 1, NULL, NULL),
(421, 80, 0, 8, 'DECP4Y', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(422, 80, 0, 8, 'RJWXQT', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(423, 80, 0, 8, 'KVER2M', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(424, 80, 0, 8, 'RUDZMS', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(425, 80, 0, 8, 'XA4HLP', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(426, 80, 0, 8, '9HW4QP', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(427, 80, 0, 8, 'FEBXWT', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(428, 80, 0, 8, 'V72FPY', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(429, 80, 0, 8, 'SF7XPJ', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(430, 80, 0, 8, 'MP6VGW', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(431, 80, 0, 8, 'ZLUDBJ', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(432, 80, 0, 8, 'LPUJHG', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(433, 80, 0, 8, 'GF67V2', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(434, 80, 0, 8, 'R2J3UV', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(435, 80, 0, 8, 'RXK675', 'unused', '2026-04-22 13:01:49', 1, NULL, NULL),
(436, 80, 0, 10, 'L9F3T4', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(437, 80, 0, 10, 'GZWMJT', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(438, 80, 0, 10, 'KH3CJ2', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(439, 80, 0, 10, 'ZXG345', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(440, 80, 0, 10, '8Q3SCT', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(441, 80, 0, 10, 'XS3RE6', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(442, 80, 0, 10, 'H3WPY4', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(443, 80, 0, 10, '4CW3RV', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(444, 80, 0, 10, '9GUR4S', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(445, 80, 0, 10, '6MGPA3', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(446, 80, 0, 10, 'B3GQMW', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(447, 80, 0, 10, 'TUBH7P', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(448, 80, 0, 10, 'EMDBZY', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(449, 80, 0, 10, 'Y6CQ3F', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(450, 80, 0, 10, '6LMC7H', 'unused', '2026-04-22 13:07:15', 1, NULL, NULL),
(452, 80, 0, 9, 'YBSWHE', 'unused', '2026-04-22 18:29:25', 1, NULL, NULL),
(453, 80, 0, 9, 'A9RDFP', 'unused', '2026-04-22 18:29:25', 1, NULL, NULL),
(455, 80, 0, 9, '73XQM6', 'unused', '2026-04-22 18:29:25', 1, NULL, NULL),
(457, 80, 0, 9, '7X3G28', 'unused', '2026-04-22 18:29:25', 1, NULL, NULL),
(459, 80, 0, 9, 'SEFLBC', 'unused', '2026-04-22 18:29:25', 1, NULL, NULL),
(460, 80, 0, 9, 'Z2TJLM', 'unused', '2026-04-22 18:29:25', 1, NULL, NULL),
(462, 80, 0, 9, '6GFS49', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(463, 80, 0, 9, 'RF4ZUT', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(464, 80, 0, 9, 'JS7XFT', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(465, 80, 0, 9, 'RHMTUJ', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(466, 80, 0, 9, 'PLN3MD', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(467, 80, 0, 9, 'QVNRL4', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(468, 80, 0, 9, 'QHK23Y', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(469, 80, 0, 9, 'YD46QC', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(470, 80, 0, 9, 'YK98XH', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(471, 80, 0, 9, '5PQRGZ', 'unused', '2026-04-22 20:59:14', 1, NULL, NULL),
(472, 80, 0, 10, 'UWM76N', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(473, 80, 0, 10, '3NV6E5', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(476, 80, 0, 10, 'SXA6QF', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(477, 80, 0, 10, 'DPU9YJ', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(478, 80, 0, 10, 'ZRNEKX', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(479, 80, 0, 10, 'ZNCP4U', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(480, 80, 0, 10, 'NH7942', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(481, 80, 0, 10, '9VX8SD', 'unused', '2026-04-22 21:06:38', 1, NULL, NULL),
(484, 80, 0, 10, 'QBCDX8', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(485, 80, 0, 10, 'YBV72S', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(486, 80, 0, 10, 'MYXEAB', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(487, 80, 0, 10, '8U7A5F', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(488, 80, 0, 10, 'JQ3LPG', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(489, 80, 0, 10, 'XCSZ9E', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(490, 80, 0, 10, '6SP7V9', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(491, 80, 0, 10, 'WPY4SR', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(492, 80, 0, 10, 'Z59WEV', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(493, 80, 0, 10, '8WJKVR', 'unused', '2026-04-23 09:09:30', 1, NULL, NULL),
(494, 80, 0, 10, 'BKPY98', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(495, 80, 0, 10, '4KH62V', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(496, 80, 0, 10, 'LGFQZP', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(497, 80, 0, 10, 'AWKF8C', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(498, 80, 0, 10, '8NJYHP', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(499, 80, 0, 10, 'R6Y2A3', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(500, 80, 0, 10, '24FB89', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(502, 80, 0, 10, 'PTVLCG', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(503, 80, 0, 10, 'PC8ENV', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(504, 80, 0, 10, '64PBLJ', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(505, 80, 0, 10, 'SDYM6W', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(506, 80, 0, 10, 'SQRBZ7', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(507, 80, 0, 10, '76E2L3', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(508, 80, 0, 10, 'EUK6TW', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(510, 80, 0, 10, 'RBA3KW', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(511, 80, 0, 10, 'S6TUMR', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(512, 80, 0, 10, 'F8NWMZ', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(513, 80, 0, 10, 'WBZPRX', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(514, 80, 0, 10, 'YU9WJF', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(515, 80, 0, 10, '3XFGB9', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(516, 80, 0, 10, '6ERMLF', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(517, 80, 0, 10, 'SN6BAU', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(518, 80, 0, 10, 'X8G34S', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(519, 80, 0, 10, '96Q7PT', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(520, 80, 0, 10, '8N7WJ9', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(521, 80, 0, 10, 'X6C7HT', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(522, 80, 0, 10, 'G3CPUR', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(523, 80, 0, 10, 'LZ7XQT', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(524, 80, 0, 10, 'CR49YD', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(525, 80, 0, 10, 'M6SJV3', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(526, 80, 0, 10, 'UT4M98', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(527, 80, 0, 10, 'HE8TMF', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(528, 80, 0, 10, 'KRAUZN', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(529, 80, 0, 10, 'SHP8QU', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(530, 80, 0, 10, 'M5SLP3', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(531, 80, 0, 10, 'DWYLZ3', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(532, 80, 0, 10, 'ZUPD5E', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(533, 80, 0, 10, 'DQ9M67', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(534, 80, 0, 10, '4MEF2Q', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(535, 80, 0, 10, 'MQDNV7', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(536, 80, 0, 10, 'DN94XQ', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(537, 80, 0, 10, 'ZL48AJ', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(538, 80, 0, 10, 'JYD8FW', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(539, 80, 0, 10, 'Z98E3T', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(540, 80, 0, 10, '7BQZL9', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(541, 80, 0, 10, 'N26JAH', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(542, 80, 0, 10, 'AFC46T', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(543, 80, 0, 10, 'Z7C9PS', 'unused', '2026-04-23 09:09:47', 1, NULL, NULL),
(578, 80, 0, 8, 'VW82PG', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(579, 80, 0, 8, 'EMA4TG', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(580, 80, 0, 8, 'FJCZE3', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(581, 80, 0, 8, 'PFTYDR', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(582, 80, 0, 8, 'QW4FGL', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(583, 80, 0, 8, '5VP3NB', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(584, 80, 0, 8, 'ZBUN2D', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(586, 80, 0, 8, 'ZXQK2W', 'unused', '2026-04-23 20:10:58', 1, NULL, NULL),
(706, 80, 0, 8, 'QNRCSAXZ', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(707, 80, 0, 8, 'G5KVRLSN', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(708, 80, 0, 8, 'MZV6R3UJ', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(709, 80, 0, 8, 'TZ64KU9X', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(710, 80, 0, 8, 'Z52KSB4V', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(711, 80, 0, 8, '7ZGSTB9F', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(712, 80, 0, 8, 'P95LHV3U', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(713, 80, 0, 8, 'JK4BPY23', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(714, 80, 0, 8, 'UGL2MZTS', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(715, 80, 0, 8, 'F6LDK5MY', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(716, 80, 0, 8, 'X5UEVR2S', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(717, 80, 0, 8, '8PV2GFHA', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(718, 80, 0, 8, 'BUYFPLH9', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(719, 80, 0, 8, 'GNDS4VKX', 'unused', '2026-04-24 06:10:27', 1, NULL, NULL),
(753, 78, 0, 25, 'B39B1D6C', 'unused', '2026-04-24 16:33:50', 1, NULL, NULL),
(754, 78, 0, 25, 'AA2B2D2E', 'unused', '2026-04-24 16:33:51', 1, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `tenant_id` (`tenant_id`),
  ADD KEY `router_id` (`router_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `vouchers`
--
ALTER TABLE `vouchers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=755;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
