-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 18, 2026 at 09:11 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.0.30

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: `db_rental_ps`
--

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

--
-- Table structure for table `absensi`
--

CREATE TABLE `absensi` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `tanggal` date NOT NULL,
  `jam_masuk` datetime DEFAULT NULL,
  `jam_keluar` datetime DEFAULT NULL,
  `durasi_menit` int(11) DEFAULT 0,
  `status` enum('hadir','izin','alpha') DEFAULT 'hadir',
  `catatan` varchar(255) DEFAULT '',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `absensi`
--

INSERT INTO `absensi` (`id`, `user_id`, `username`, `tanggal`, `jam_masuk`, `jam_keluar`, `durasi_menit`, `status`, `catatan`, `created_at`) VALUES
(1, 1, 'admin', '2026-04-07', '2026-04-07 11:30:13', '2026-04-07 11:30:27', 0, 'hadir', '', '2026-04-07 11:30:13'),
(2, 1, 'admin', '2026-04-09', '2026-04-09 18:06:08', '2026-04-09 18:07:11', 1, 'hadir', '', '2026-04-09 18:06:08');

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` (`id`, `user_id`, `username`, `action`, `details`, `created_at`) VALUES
(9268, 1, 'admin', 'HAPUS DATA', 'Seluruh data transaksi dihapus oleh admin. Tabel: transactions, activity_logs', '2026-04-18 07:10:52');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` int(11) NOT NULL,
  `nama_member` varchar(100) NOT NULL,
  `telepon` varchar(20) DEFAULT NULL,
  `saldo` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `nama_member`, `telepon`, `saldo`, `created_at`) VALUES
(4, 'REHSWEL', '0818110242', 38400, '2026-02-25 10:07:02');

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

--
-- Table structure for table `member_topups`
--

CREATE TABLE `member_topups` (
  `id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `member_topups`
--

INSERT INTO `member_topups` (`id`, `member_id`, `amount`, `created_at`) VALUES
(6, 4, 50000, '2026-02-25 17:07:05');

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

--
-- Table structure for table `orders_fnb`
--

CREATE TABLE `orders_fnb` (
  `id` int(11) NOT NULL,
  `trx_id` int(11) DEFAULT NULL,
  `tv_id` int(11) DEFAULT NULL,
  `nama_barang` varchar(100) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `harga_jual` int(11) DEFAULT NULL,
  `total_harga` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `overlay_settings`
--

CREATE TABLE `overlay_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(80) NOT NULL,
  `setting_value` varchar(255) NOT NULL DEFAULT '',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `overlay_settings`
--

INSERT INTO `overlay_settings` (`id`, `setting_key`, `setting_value`, `updated_at`) VALUES
(1, 'ov_position', 'BL', '2026-02-19 07:57:07'),
(2, 'ov_timer_size', '10', '2026-02-25 07:34:33'),
(3, 'ov_label_size', '8', '2026-02-25 07:36:35'),
(4, 'ov_info_size', '8', '2026-02-19 08:07:36'),
(5, 'ov_rental_size', '8', '2026-02-19 08:07:36'),
(6, 'ov_color_normal', '#00FF9D', '2026-02-19 07:57:07'),
(7, 'ov_color_warning', '#FFD84D', '2026-02-19 07:57:07'),
(8, 'ov_color_danger', '#FF4D6A', '2026-02-19 07:57:07'),
(9, 'ov_color_openbill', '#00E5FF', '2026-02-19 07:57:07'),
(10, 'ov_color_info', '#FFFFFF', '2026-02-19 07:57:07'),
(11, 'ov_color_label', '#FFFFFF', '2026-02-19 08:07:05'),
(12, 'ov_margin', '8', '2026-02-19 08:07:36'),
(13, 'ov_show_tvno', '1', '2026-02-24 10:45:32'),
(14, 'ov_show_customer', '1', '2026-02-24 10:46:05'),
(15, 'ov_show_rental', '1', '2026-02-24 10:46:05'),
(16, 'ov_show_label', '1', '2026-02-24 10:46:05'),
(17, 'ov_bg_alpha', '8', '2026-02-19 08:07:05'),
(98, 'ov_pos_timer', 'TR', '2026-02-24 10:45:42'),
(99, 'ov_pos_tvno', 'TL', '2026-02-19 08:37:17'),
(100, 'ov_pos_customer', 'BL', '2026-02-24 10:46:05'),
(101, 'ov_pos_rental', 'BR', '2026-02-25 07:14:39');

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` int(11) NOT NULL,
  `nama_paket` varchar(50) NOT NULL,
  `harga` int(11) NOT NULL,
  `durasi_menit` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `nama_paket`, `harga`, `durasi_menit`) VALUES
(4, '1 MENIT', 1000, 1),
(5, '1 JAM', 8000, 60),
(6, '2 JAM', 23000, 120),
(7, '2 JAM', 12444, 60);

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

--
-- Table structure for table `pricing`
--

CREATE TABLE `pricing` (
  `id` int(11) NOT NULL,
  `nama_paket` varchar(100) NOT NULL,
  `durasi` int(11) NOT NULL,
  `harga` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `snacks`
--

CREATE TABLE `snacks` (
  `id` int(11) NOT NULL,
  `nama_barang` varchar(100) NOT NULL,
  `harga_beli` int(11) NOT NULL,
  `harga_jual` int(11) NOT NULL,
  `stok` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `snacks`
--

INSERT INTO `snacks` (`id`, `nama_barang`, `harga_beli`, `harga_jual`, `stok`) VALUES
(5, 'TEMPE', 1000, 2000, 0);

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

--
-- Table structure for table `snack_sales`
--

CREATE TABLE `snack_sales` (
  `id` int(11) NOT NULL,
  `trx_id` int(11) DEFAULT NULL,
  `snack_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sticks`
--

CREATE TABLE `sticks` (
  `id` int(11) NOT NULL,
  `nama_stik` varchar(100) NOT NULL,
  `status` enum('available','in_use','broken') DEFAULT 'available',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sticks`
--

INSERT INTO `sticks` (`id`, `nama_stik`, `status`, `created_at`) VALUES
(5, 'STICK A', 'available', '2026-02-25 10:06:12'),
(6, 'STICK B', 'available', '2026-02-25 10:06:14');

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

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `id` int(11) NOT NULL,
  `setting_name` varchar(100) DEFAULT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `system_settings`
--

INSERT INTO `system_settings` (`id`, `setting_name`, `setting_value`) VALUES
(1, 'license_key', NULL),
(6, 'adb_path', 'C:\\\\xampp\\\\htdocs\\\\escobarweb\\\\adb.exe'),
(7, 'app_name', 'ESCO DIGITAL'),
(8, 'default_open_bill_rate', '0'),
(9, 'min_open_bill', '0'),
(10, 'round_open_bill', '0'),
(12, 'img_expired_file', 'tv_expired_1771579473.jpg'),
(13, 'img_standby_file', 'tv_standby_1771579478.jpg'),
(16, 'base_url', 'http://192.168.0.101/escobarweb'),
(18, 'billing_show_image', '1'),
(19, 'billing_sleep_tv', '0'),
(28, 'expired_action', 'show_image'),
(29, 'expired_image_path', 'uploads/expired_image_1772000192.jpg'),
(31, 'server_url', 'http://192.168.1.51/escobarweb'),
(41, 'wa_admin_number', '0818110244'),
(42, 'payment_methods', '[{\"id\":1,\"nama\":\"Cash\",\"icon\":\"bx-money\",\"aktif\":true,\"ket\":\"Pembayaran tunai langsung\"},{\"id\":2,\"nama\":\"Transfer Bank\",\"icon\":\"bx-transfer\",\"aktif\":true,\"ket\":\"BCA \\/ BRI \\/ Mandiri \\/ BNI\"},{\"id\":3,\"nama\":\"QRIS\",\"icon\":\"bx-qr\",\"aktif\":true,\"ket\":\"GoPay, OVO, Dana, ShopeePay, dll\"},{\"id\":4,\"nama\":\"Member Saldo\",\"icon\":\"bx-wallet\",\"aktif\":true,\"ket\":\"Potong saldo member VIP\"},{\"id\":5,\"nama\":\"Voucher\",\"icon\":\"bx-gift\",\"aktif\":true,\"ket\":\"Kode voucher diskon\"}]'),
(46, 'python_path', 'C:\\Users\\ceco\\AppData\\Local\\Programs\\Python\\Python312\\python.exe'),
(47, 'perm_manage_units', '1'),
(48, 'perm_manage_members', '0'),
(49, 'perm_manage_inventory', '0'),
(50, 'perm_view_history', '0'),
(51, 'perm_view_closing', '1');

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

--
-- Table structure for table `topup_history`
--

CREATE TABLE `topup_history` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(10) UNSIGNED NOT NULL,
  `nominal` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `saldo_sekarang` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `operator_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `sumber` varchar(50) NOT NULL DEFAULT 'Manual',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `tv_id` int(11) NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `paket_id` int(11) DEFAULT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `total_bayar` int(11) DEFAULT 0,
  `payment_method` varchar(50) DEFAULT 'Cash',
  `status` enum('ongoing','paused','completed') NOT NULL DEFAULT 'ongoing',
  `target_selesai` datetime DEFAULT NULL,
  `sisa_detik_pause` int(11) DEFAULT 0,
  `pindah_log` text DEFAULT NULL,
  `jenis_paket` enum('fixed','open') DEFAULT 'fixed',
  `rate_per_jam` int(11) DEFAULT 0,
  `stik_info` varchar(50) DEFAULT NULL,
  `remaining_seconds` int(11) DEFAULT 0,
  `payment_status` enum('paid','pending') NOT NULL DEFAULT 'paid',
  `diskon` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `voucher_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tuya_devices`
--

CREATE TABLE `tuya_devices` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(100) NOT NULL DEFAULT '',
  `device_id` varchar(100) NOT NULL DEFAULT '',
  `ip_address` varchar(50) NOT NULL DEFAULT '',
  `local_key` varchar(100) NOT NULL DEFAULT '',
  `tv_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'TV yang dikontrol plug ini (opsional)',
  `version` varchar(10) NOT NULL DEFAULT '3.4',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tvs`
--

CREATE TABLE `tvs` (
  `id` int(11) NOT NULL,
  `nama_tv` varchar(50) NOT NULL,
  `ip_address` varchar(20) NOT NULL,
  `status` enum('available','active','paused') DEFAULT 'available',
  `current_trx_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tvs`
--

INSERT INTO `tvs` (`id`, `nama_tv`, `ip_address`, `status`, `current_trx_id`) VALUES
(10, 'TV 01', '192.168.1.53', 'available', NULL),
(12, 'TV 02', '192.168.1.54', 'available', NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `nama_operator` varchar(100) DEFAULT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('admin','pegawai') NOT NULL DEFAULT 'pegawai',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `nama_operator`, `username`, `password`, `role`, `created_at`) VALUES
(1, 'Super Admin', 'admin', '$2y$10$evX57EXzoa1Tusqwyxij0eu1fwunJYY4DelbB.JBN1NkpCldFFhZO', 'admin', '2026-02-15 08:58:54'),
(2, 'test', 'test', '$2y$10$nNLrgNwF8vp4p95MaV3oquxhnZyuFlUnJj/aghH47pexyuwEmJvBG', 'pegawai', '2026-04-10 04:02:40');

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

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

CREATE TABLE `vouchers` (
  `id` int(10) UNSIGNED NOT NULL,
  `kode` varchar(50) NOT NULL,
  `nama` varchar(100) NOT NULL DEFAULT '',
  `jenis` enum('nominal','persen','menit') NOT NULL DEFAULT 'nominal',
  `nilai` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `min_jam` decimal(4,1) UNSIGNED NOT NULL DEFAULT 0.0,
  `status` enum('aktif','used','expired','nonaktif') NOT NULL DEFAULT 'aktif',
  `used_by_trx` int(10) UNSIGNED DEFAULT NULL,
  `used_at` datetime DEFAULT NULL,
  `expired_at` datetime DEFAULT NULL,
  `keterangan` varchar(255) NOT NULL DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absensi`
--
ALTER TABLE `absensi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_tanggal` (`user_id`,`tanggal`);

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `telepon` (`telepon`);

--
-- Indexes for table `member_topups`
--
ALTER TABLE `member_topups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `orders_fnb`
--
ALTER TABLE `orders_fnb`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `overlay_settings`
--
ALTER TABLE `overlay_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

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

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

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

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

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

--
-- Indexes for table `system_settings`
--
ALTER TABLE `system_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_name` (`setting_name`);

--
-- Indexes for table `topup_history`
--
ALTER TABLE `topup_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_member` (`member_id`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_end_status` (`end_time`,`status`);

--
-- Indexes for table `tuya_devices`
--
ALTER TABLE `tuya_devices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tv` (`tv_id`);

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

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

--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode` (`kode`),
  ADD KEY `idx_kode` (`kode`),
  ADD KEY `idx_status` (`status`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `pricing`
--
ALTER TABLE `pricing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `snack_sales`
--
ALTER TABLE `snack_sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `vouchers`
--
ALTER TABLE `vouchers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
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 */;
