-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 06, 2025 at 02:52 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.0.28

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_arifahpulsa_api`
--

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

--
-- Table structure for table `tbl_ktg_game`
--

CREATE TABLE `tbl_ktg_game` (
  `ktg_game_id` int(11) NOT NULL,
  `ktg_game_kode` varchar(100) DEFAULT NULL,
  `ktg_game_nama` varchar(100) DEFAULT NULL,
  `ktg_game_icon` varchar(100) DEFAULT NULL,
  `ktg_game_urutan` int(11) DEFAULT NULL,
  `ktg_game_keterangan` varchar(250) DEFAULT NULL,
  `ktg_game_notasi` varchar(250) DEFAULT NULL,
  `ktg_game_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_ktg_hp`
--

CREATE TABLE `tbl_ktg_hp` (
  `ktg_hp_id` int(11) NOT NULL,
  `ktg_hp_kode` varchar(100) DEFAULT NULL,
  `ktg_hp_nama` varchar(100) DEFAULT NULL,
  `ktg_hp_icon` varchar(100) DEFAULT NULL,
  `ktg_hp_urutan` int(11) DEFAULT NULL,
  `ktg_hp_keterangan` varchar(250) DEFAULT NULL,
  `ktg_hp_notasi` varchar(250) DEFAULT NULL,
  `ktg_hp_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_ktg_hp`
--

INSERT INTO `tbl_ktg_hp` (`ktg_hp_id`, `ktg_hp_kode`, `ktg_hp_nama`, `ktg_hp_icon`, `ktg_hp_urutan`, `ktg_hp_keterangan`, `ktg_hp_notasi`, `ktg_hp_status`) VALUES
(1, 'HALO', 'Telkomsel HALO', 'KTG-HALO.png', 1, 'Keterangan', 'Notasi', '0');

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

--
-- Table structure for table `tbl_ktg_internet`
--

CREATE TABLE `tbl_ktg_internet` (
  `ktg_internet_id` int(11) NOT NULL,
  `ktg_internet_kode` varchar(100) DEFAULT NULL,
  `ktg_internet_nama` varchar(100) DEFAULT NULL,
  `ktg_internet_icon` varchar(100) DEFAULT NULL,
  `ktg_internet_urutan` int(11) DEFAULT NULL,
  `ktg_internet_keterangan` varchar(250) DEFAULT NULL,
  `ktg_internet_notasi` varchar(250) DEFAULT NULL,
  `ktg_internet_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_ktg_internet`
--

INSERT INTO `tbl_ktg_internet` (`ktg_internet_id`, `ktg_internet_kode`, `ktg_internet_nama`, `ktg_internet_icon`, `ktg_internet_urutan`, `ktg_internet_keterangan`, `ktg_internet_notasi`, `ktg_internet_status`) VALUES
(1, 'TELKOM', 'TELKOM', 'KTG-TELKOM.png', 1, 'Keterangan', 'Notasi', '0');

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

--
-- Table structure for table `tbl_ktg_multifinance`
--

CREATE TABLE `tbl_ktg_multifinance` (
  `ktg_multifinance_id` int(11) NOT NULL,
  `ktg_multifinance_kode` varchar(100) DEFAULT NULL,
  `ktg_multifinance_nama` varchar(100) DEFAULT NULL,
  `ktg_multifinance_icon` varchar(100) DEFAULT NULL,
  `ktg_multifinance_urutan` int(11) DEFAULT NULL,
  `ktg_multifinance_keterangan` varchar(250) DEFAULT NULL,
  `ktg_multifinance_notasi` varchar(250) DEFAULT NULL,
  `ktg_multifinance_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_ktg_pbb`
--

CREATE TABLE `tbl_ktg_pbb` (
  `ktg_pbb_id` int(11) NOT NULL,
  `ktg_pbb_kode` varchar(100) DEFAULT NULL,
  `ktg_pbb_nama` varchar(100) DEFAULT NULL,
  `ktg_pbb_icon` varchar(100) DEFAULT NULL,
  `ktg_pbb_urutan` int(11) DEFAULT NULL,
  `ktg_pbb_keterangan` varchar(250) DEFAULT NULL,
  `ktg_pbb_notasi` varchar(250) DEFAULT NULL,
  `ktg_pbb_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_ktg_pdam`
--

CREATE TABLE `tbl_ktg_pdam` (
  `ktg_pdam_id` int(11) NOT NULL,
  `ktg_pdam_kode` varchar(100) DEFAULT NULL,
  `ktg_pdam_nama` varchar(100) DEFAULT NULL,
  `ktg_pdam_icon` varchar(100) DEFAULT NULL,
  `ktg_pdam_urutan` int(11) DEFAULT NULL,
  `ktg_pdam_keterangan` varchar(250) DEFAULT NULL,
  `ktg_pdam_notasi` varchar(250) DEFAULT NULL,
  `ktg_pdam_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_ktg_produk`
--

CREATE TABLE `tbl_ktg_produk` (
  `ktg_produk_id` int(11) NOT NULL,
  `ktg_produk_kode` varchar(100) DEFAULT NULL,
  `ktg_produk_nama` varchar(200) DEFAULT NULL,
  `ktg_produk_icon` varchar(100) DEFAULT NULL,
  `ktg_produk_keterangan` varchar(70) DEFAULT NULL,
  `ktg_produk_urutan` int(11) DEFAULT NULL,
  `ktg_produk_status` enum('0','1','2') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbl_ktg_tv`
--

CREATE TABLE `tbl_ktg_tv` (
  `ktg_tv_id` int(11) NOT NULL,
  `ktg_tv_kode` varchar(100) DEFAULT NULL,
  `ktg_tv_nama` varchar(100) DEFAULT NULL,
  `ktg_tv_icon` varchar(100) DEFAULT NULL,
  `ktg_tv_urutan` int(11) DEFAULT NULL,
  `ktg_tv_keterangan` varchar(250) DEFAULT NULL,
  `ktg_tv_notasi` varchar(250) DEFAULT NULL,
  `ktg_tv_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_alfamart`
--

CREATE TABLE `tbl_mst_alfamart` (
  `mst_alfamart_id` int(11) NOT NULL,
  `mst_alfamart_kode` varchar(100) DEFAULT NULL,
  `mst_alfamart_nama` varchar(150) DEFAULT NULL,
  `mst_alfamart_keterangan` varchar(250) DEFAULT NULL,
  `mst_alfamart_notasi` varchar(250) DEFAULT NULL,
  `mst_alfamart_harga` double DEFAULT 0,
  `mst_alfamart_admin` double DEFAULT 0,
  `mst_alfamart_poin` int(11) DEFAULT NULL,
  `mst_alfamart_urutan` int(11) DEFAULT NULL,
  `mst_alfamart_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_banner`
--

CREATE TABLE `tbl_mst_banner` (
  `mst_banner_id` int(11) NOT NULL,
  `mst_banner_kode` varchar(100) DEFAULT NULL,
  `mst_banner_kategori` varchar(100) DEFAULT NULL,
  `mst_banner_tipe` enum('Gambar','Video') DEFAULT NULL,
  `mst_banner_video` varchar(20) DEFAULT NULL,
  `mst_banner_gambar` varchar(100) DEFAULT NULL,
  `mst_banner_judul` varchar(150) DEFAULT NULL,
  `mst_banner_isi` text DEFAULT NULL,
  `mst_banner_link` text DEFAULT NULL,
  `mst_banner_status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_banner`
--

INSERT INTO `tbl_mst_banner` (`mst_banner_id`, `mst_banner_kode`, `mst_banner_kategori`, `mst_banner_tipe`, `mst_banner_video`, `mst_banner_gambar`, `mst_banner_judul`, `mst_banner_isi`, `mst_banner_link`, `mst_banner_status`) VALUES
(1, 'BANNER-001', 'PAKET DATA', 'Gambar', '', 'KTG-BANNER-001-809.jpg', 'Kuota XL Murah Meriah', 'Yuk beli paket data XL termurah disini', '', '0'),
(2, 'BANNER-002', 'PAKET NELFON', 'Gambar', '', 'KTG-BANNER-002-419.jpg', 'Pulsa telkomel paling murah', '', '', '0');

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

--
-- Table structure for table `tbl_mst_bonus`
--

CREATE TABLE `tbl_mst_bonus` (
  `mst_bonus_id` int(11) NOT NULL,
  `mst_bonus_kode` varchar(100) DEFAULT NULL,
  `mst_bonus_nama` varchar(100) DEFAULT NULL,
  `mst_bonus_poin` int(11) DEFAULT NULL,
  `mst_bonus_admin` double DEFAULT NULL,
  `mst_bonus_harga` double DEFAULT NULL,
  `mst_bonus_keterangan` varchar(250) DEFAULT NULL,
  `mst_bonus_notasi` varchar(250) DEFAULT NULL,
  `mst_bonus_status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_mst_bonus`
--

INSERT INTO `tbl_mst_bonus` (`mst_bonus_id`, `mst_bonus_kode`, `mst_bonus_nama`, `mst_bonus_poin`, `mst_bonus_admin`, `mst_bonus_harga`, `mst_bonus_keterangan`, `mst_bonus_notasi`, `mst_bonus_status`) VALUES
(1, 'BONUS-001', 'Silver', 20, 0, 1000, 'Kamu akan mendapatkan bonus 20 poin dari transaksi yang dilakukan oleh downline/orang yang menggunakan kode referal kamu', 'Poin akan masuk apabila transaksi yang dilakukan oleh downline/orang yang menggunakan kode referal kamu', '0'),
(2, 'BONUS-002', 'Gold', 50, 0, 8000, 'Kamu akan mendapatkan bonus 50 poin dari transaksi yang dilakukan oleh downline/orang yang menggunakan kode referal kamu', 'Poin akan masuk apabila transaksi yang dilakukan oleh downline/orang yang menggunakan kode referal kamu', '0'),
(3, 'BONUS-003', 'Diamond', 100, 0, 15000, 'Kamu akan mendapatkan bonus 100 poin dari transaksi yang dilakukan oleh downline/orang yang menggunakan kode', 'Poin akan masuk apabila transaksi yang dilakukan oleh downline/orang yang menggunakan kode referal kamu', '0');

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

--
-- Table structure for table `tbl_mst_brizzi`
--

CREATE TABLE `tbl_mst_brizzi` (
  `mst_brizzi_id` int(11) NOT NULL,
  `mst_brizzi_kode` varchar(100) DEFAULT NULL,
  `mst_brizzi_nama` varchar(150) DEFAULT NULL,
  `mst_brizzi_keterangan` varchar(250) DEFAULT NULL,
  `mst_brizzi_notasi` varchar(250) DEFAULT NULL,
  `mst_brizzi_harga` double DEFAULT 0,
  `mst_brizzi_admin` double DEFAULT 0,
  `mst_brizzi_poin` int(11) DEFAULT NULL,
  `mst_brizzi_urutan` int(11) DEFAULT NULL,
  `mst_brizzi_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_bukalapak`
--

CREATE TABLE `tbl_mst_bukalapak` (
  `mst_bukalapak_id` int(11) NOT NULL,
  `mst_bukalapak_kode` varchar(100) DEFAULT NULL,
  `mst_bukalapak_nama` varchar(150) DEFAULT NULL,
  `mst_bukalapak_keterangan` varchar(250) DEFAULT NULL,
  `mst_bukalapak_notasi` varchar(250) DEFAULT NULL,
  `mst_bukalapak_harga` double DEFAULT 0,
  `mst_bukalapak_admin` double DEFAULT 0,
  `mst_bukalapak_poin` int(11) DEFAULT NULL,
  `mst_bukalapak_urutan` int(11) DEFAULT NULL,
  `mst_bukalapak_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_dana`
--

CREATE TABLE `tbl_mst_dana` (
  `mst_dana_id` int(11) NOT NULL,
  `mst_dana_kode` varchar(100) DEFAULT NULL,
  `mst_dana_nama` varchar(150) DEFAULT NULL,
  `mst_dana_keterangan` varchar(250) DEFAULT NULL,
  `mst_dana_notasi` varchar(250) DEFAULT NULL,
  `mst_dana_harga` double DEFAULT 0,
  `mst_dana_admin` double DEFAULT 0,
  `mst_dana_poin` int(11) DEFAULT NULL,
  `mst_dana_urutan` int(11) DEFAULT NULL,
  `mst_dana_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_deposit`
--

CREATE TABLE `tbl_mst_deposit` (
  `mst_deposit_id` int(11) NOT NULL,
  `mst_deposit_kode` varchar(100) DEFAULT NULL,
  `mst_deposit_nama` varchar(100) DEFAULT NULL,
  `mst_deposit_admin` double DEFAULT NULL,
  `mst_deposit_persen` double(11,2) DEFAULT 0.00,
  `mst_deposit_icon` varchar(100) DEFAULT NULL,
  `mst_deposit_status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_mst_deposit`
--

INSERT INTO `tbl_mst_deposit` (`mst_deposit_id`, `mst_deposit_kode`, `mst_deposit_nama`, `mst_deposit_admin`, `mst_deposit_persen`, `mst_deposit_icon`, `mst_deposit_status`) VALUES
(1, 'MYBVA', 'Maybank Virtual Account', 4250, 0.00, 'maybank.png', '0'),
(2, 'PERMATAVA', 'Permata Virtual Account', 4250, 0.00, 'permata.png', '0'),
(3, 'BNIVA', 'BNI Virtual Account', 4250, 0.00, 'bni.png', '0'),
(4, 'BRIVA', 'BRI Virtual Account', 4250, 0.00, 'bri.png', '0'),
(5, 'MANDIRIVA', 'Mandiri Virtual Account', 4250, 0.00, 'mandiri.png', '0'),
(6, 'BCAVA', 'BCA Virtual Account', 5500, 0.00, 'bca.png', '0'),
(7, 'SMSVA', 'Sinarmas Virtual Account', 4250, 0.00, 'sinarmas.png', '0'),
(8, 'CIMBVA', 'CIMB Niaga Virtual Account', 4250, 0.00, 'cimb.png', '0'),
(9, 'BSIVA', 'BSI Virtual Account', 4250, 0.00, 'bsi.png', '0'),
(10, 'OCBCVA', 'OCBC NISP Virtual Account', 4250, 0.00, 'ocbc.png', '0'),
(11, 'DANAMONVA', 'Danamon Virtual Account', 4250, 0.00, 'danamon.png', '0'),
(12, 'BNCVA', 'BNC Virtual Account', 4250, 0.00, 'bnc.png', '0'),
(13, 'ALFAMART', 'Alfamart', 3500, 0.00, 'alfamart.png', '0'),
(14, 'INDOMARET', 'Indomaret', 3500, 0.00, 'indomaret.png', '0'),
(15, 'ALFAMIDI', 'Alfamidi', 3500, 0.00, 'alfamidi.png', '0'),
(16, 'OVO', 'OVO', 0, 3.00, 'ovo.png', '0'),
(17, 'QRISC', 'QRIS', 750, 0.70, 'qris.png', '1'),
(18, 'SHOPEEPAY', 'ShopeePay', 0, 3.00, 'shopeepay.png', '0');

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

--
-- Table structure for table `tbl_mst_deposit_manual`
--

CREATE TABLE `tbl_mst_deposit_manual` (
  `mst_deposit_id` int(11) NOT NULL,
  `mst_deposit_kode` varchar(100) DEFAULT NULL,
  `mst_deposit_nama_bank` varchar(100) DEFAULT NULL,
  `mst_deposit_nomor_rekening` varchar(25) DEFAULT NULL,
  `mst_deposit_nama_rekening` varchar(100) DEFAULT NULL,
  `mst_deposit_admin` double DEFAULT NULL,
  `mst_deposit_icon` varchar(100) DEFAULT NULL,
  `mst_deposit_notasi` varchar(100) DEFAULT NULL,
  `mst_deposit_keterangan` text DEFAULT NULL,
  `mst_deposit_status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_doku`
--

CREATE TABLE `tbl_mst_doku` (
  `mst_doku_id` int(11) NOT NULL,
  `mst_doku_kode` varchar(100) DEFAULT NULL,
  `mst_doku_nama` varchar(150) DEFAULT NULL,
  `mst_doku_keterangan` varchar(250) DEFAULT NULL,
  `mst_doku_notasi` varchar(250) DEFAULT NULL,
  `mst_doku_harga` double DEFAULT 0,
  `mst_doku_admin` double DEFAULT 0,
  `mst_doku_poin` int(11) DEFAULT NULL,
  `mst_doku_urutan` int(11) DEFAULT NULL,
  `mst_doku_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_emoney`
--

CREATE TABLE `tbl_mst_emoney` (
  `mst_emoney_id` int(11) NOT NULL,
  `mst_emoney_kode` varchar(100) DEFAULT NULL,
  `mst_emoney_nama` varchar(150) DEFAULT NULL,
  `mst_emoney_keterangan` varchar(250) DEFAULT NULL,
  `mst_emoney_notasi` varchar(250) DEFAULT NULL,
  `mst_emoney_harga` double DEFAULT 0,
  `mst_emoney_admin` double DEFAULT 0,
  `mst_emoney_poin` int(11) DEFAULT NULL,
  `mst_emoney_urutan` int(11) DEFAULT NULL,
  `mst_emoney_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_game`
--

CREATE TABLE `tbl_mst_game` (
  `mst_game_id` int(11) NOT NULL,
  `mst_game_kode` varchar(100) DEFAULT NULL,
  `mst_game_kategori` varchar(100) DEFAULT NULL,
  `mst_game_nama` varchar(150) DEFAULT NULL,
  `mst_game_keterangan` varchar(250) DEFAULT NULL,
  `mst_game_notasi` varchar(250) DEFAULT NULL,
  `mst_game_harga` double DEFAULT 0,
  `mst_game_admin` double DEFAULT 0,
  `mst_game_poin` int(11) DEFAULT NULL,
  `mst_game_urutan` int(11) DEFAULT NULL,
  `mst_game_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_gojek_driver`
--

CREATE TABLE `tbl_mst_gojek_driver` (
  `mst_gojek_driver_id` int(11) NOT NULL,
  `mst_gojek_driver_kode` varchar(100) DEFAULT NULL,
  `mst_gojek_driver_nama` varchar(150) DEFAULT NULL,
  `mst_gojek_driver_keterangan` varchar(250) DEFAULT NULL,
  `mst_gojek_driver_notasi` varchar(250) DEFAULT NULL,
  `mst_gojek_driver_harga` double DEFAULT 0,
  `mst_gojek_driver_admin` double DEFAULT 0,
  `mst_gojek_driver_poin` int(11) DEFAULT NULL,
  `mst_gojek_driver_urutan` int(11) DEFAULT NULL,
  `mst_gojek_driver_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_googleplay`
--

CREATE TABLE `tbl_mst_googleplay` (
  `mst_googleplay_id` int(11) NOT NULL,
  `mst_googleplay_kode` varchar(100) DEFAULT NULL,
  `mst_googleplay_nama` varchar(150) DEFAULT NULL,
  `mst_googleplay_keterangan` varchar(250) DEFAULT NULL,
  `mst_googleplay_notasi` varchar(250) DEFAULT NULL,
  `mst_googleplay_harga` double DEFAULT 0,
  `mst_googleplay_admin` double DEFAULT 0,
  `mst_googleplay_poin` int(11) DEFAULT NULL,
  `mst_googleplay_urutan` int(11) DEFAULT NULL,
  `mst_googleplay_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_gopay`
--

CREATE TABLE `tbl_mst_gopay` (
  `mst_gopay_id` int(11) NOT NULL,
  `mst_gopay_kode` varchar(100) DEFAULT NULL,
  `mst_gopay_nama` varchar(150) DEFAULT NULL,
  `mst_gopay_keterangan` varchar(250) DEFAULT NULL,
  `mst_gopay_notasi` varchar(250) DEFAULT NULL,
  `mst_gopay_harga` double DEFAULT 0,
  `mst_gopay_admin` double DEFAULT 0,
  `mst_gopay_poin` int(11) DEFAULT NULL,
  `mst_gopay_urutan` int(11) DEFAULT NULL,
  `mst_gopay_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_grab`
--

CREATE TABLE `tbl_mst_grab` (
  `mst_grab_id` int(11) NOT NULL,
  `mst_grab_kode` varchar(100) DEFAULT NULL,
  `mst_grab_nama` varchar(150) DEFAULT NULL,
  `mst_grab_keterangan` varchar(250) DEFAULT NULL,
  `mst_grab_notasi` varchar(250) DEFAULT NULL,
  `mst_grab_harga` double DEFAULT 0,
  `mst_grab_admin` double DEFAULT 0,
  `mst_grab_poin` int(11) DEFAULT NULL,
  `mst_grab_urutan` int(11) DEFAULT NULL,
  `mst_grab_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_grab_driver`
--

CREATE TABLE `tbl_mst_grab_driver` (
  `mst_grab_driver_id` int(11) NOT NULL,
  `mst_grab_driver_kode` varchar(100) DEFAULT NULL,
  `mst_grab_driver_nama` varchar(150) DEFAULT NULL,
  `mst_grab_driver_keterangan` varchar(250) DEFAULT NULL,
  `mst_grab_driver_notasi` varchar(250) DEFAULT NULL,
  `mst_grab_driver_harga` double DEFAULT 0,
  `mst_grab_driver_admin` double DEFAULT 0,
  `mst_grab_driver_poin` int(11) DEFAULT NULL,
  `mst_grab_driver_urutan` int(11) DEFAULT NULL,
  `mst_grab_driver_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_hadiah`
--

CREATE TABLE `tbl_mst_hadiah` (
  `mst_hadiah_id` int(11) NOT NULL,
  `mst_hadiah_kode` varchar(100) DEFAULT NULL,
  `mst_hadiah_nama` varchar(100) DEFAULT NULL,
  `mst_hadiah_jenis` enum('Saldo','Produk') DEFAULT NULL,
  `mst_hadiah_harga` double DEFAULT NULL,
  `mst_hadiah_stok` int(11) DEFAULT NULL,
  `mst_hadiah_terpakai` int(11) DEFAULT NULL,
  `mst_hadiah_periode_awal` datetime DEFAULT NULL,
  `mst_hadiah_periode_akhir` datetime DEFAULT NULL,
  `mst_hadiah_foto` varchar(100) DEFAULT NULL,
  `mst_hadiah_keterangan` text DEFAULT NULL,
  `mst_hadiah_status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_inbox`
--

CREATE TABLE `tbl_mst_inbox` (
  `mst_inbox_id` int(11) NOT NULL,
  `mst_inbox_kode` varchar(100) DEFAULT NULL,
  `mst_inbox_user_kode` longtext DEFAULT NULL,
  `mst_inbox_jenis` enum('Teks','Gambar') DEFAULT NULL,
  `mst_inbox_gambar` varchar(100) DEFAULT NULL,
  `mst_inbox_judul` varchar(200) DEFAULT NULL,
  `mst_inbox_isi` longtext DEFAULT NULL,
  `mst_inbox_tanggal` datetime DEFAULT NULL,
  `mst_inbox_jangka_waktu` int(11) DEFAULT 1,
  `mst_inbox_status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_indomaret`
--

CREATE TABLE `tbl_mst_indomaret` (
  `mst_indomaret_id` int(11) NOT NULL,
  `mst_indomaret_kode` varchar(100) DEFAULT NULL,
  `mst_indomaret_nama` varchar(150) DEFAULT NULL,
  `mst_indomaret_keterangan` varchar(250) DEFAULT NULL,
  `mst_indomaret_notasi` varchar(250) DEFAULT NULL,
  `mst_indomaret_harga` double DEFAULT 0,
  `mst_indomaret_admin` double DEFAULT 0,
  `mst_indomaret_poin` int(11) DEFAULT NULL,
  `mst_indomaret_urutan` int(11) DEFAULT NULL,
  `mst_indomaret_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_isaku`
--

CREATE TABLE `tbl_mst_isaku` (
  `mst_isaku_id` int(11) NOT NULL,
  `mst_isaku_kode` varchar(100) DEFAULT NULL,
  `mst_isaku_nama` varchar(150) DEFAULT NULL,
  `mst_isaku_keterangan` varchar(250) DEFAULT NULL,
  `mst_isaku_notasi` varchar(250) DEFAULT NULL,
  `mst_isaku_harga` double DEFAULT 0,
  `mst_isaku_admin` double DEFAULT 0,
  `mst_isaku_poin` int(11) DEFAULT NULL,
  `mst_isaku_urutan` int(11) DEFAULT NULL,
  `mst_isaku_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_limit`
--

CREATE TABLE `tbl_mst_limit` (
  `mst_limit_id` double NOT NULL,
  `mst_limit_uri` varchar(200) DEFAULT NULL,
  `mst_limit_count` int(11) DEFAULT NULL,
  `mst_limit_hour` int(11) DEFAULT NULL,
  `mst_limit_api_key` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_limit`
--

INSERT INTO `tbl_mst_limit` (`mst_limit_id`, `mst_limit_uri`, `mst_limit_count`, `mst_limit_hour`, `mst_limit_api_key`) VALUES
(1, 'uri:deposit_activity/v1/api_deposit_activity_transaksi/index:post', 1, 1687835685, 'TOKEN-4BB60CD24E-821-27-06-2023--08:06:22'),
(2, 'uri:main_activity/v1/api_main_activity_firebase/index:post', 1, 1687835813, 'TOKEN-4BB60CD24E-821-27-06-2023--08:06:22'),
(3, 'uri:main_activity/v1/api_main_activity_firebase/index:post', 1, 1687836060, 'TOKEN-4571FF133F-773-27-06-2023--10:06:00'),
(4, 'uri:deposit_activity/v1/api_deposit_activity_transaksi/index:post', 1, 1687836087, 'TOKEN-4571FF133F-773-27-06-2023--10:06:00'),
(5, 'uri:main_activity/v1/api_main_activity_firebase/index:post', 1, 1687836205, 'TOKEN-EBD1D7C4A4-173-27-06-2023--10:06:24'),
(6, 'uri:main_activity/v1/api_main_activity_firebase/index:post', 1, 1727839724, 'TOKEN-B6E05BE9B2-195-02-10-2024--10:10:35'),
(7, 'uri:bonus_activity/v1/api_bonus_activity_transaksi/index:post', 1, 1727839887, 'TOKEN-B6E05BE9B2-195-02-10-2024--10:10:35'),
(8, 'uri:main_activity/v1/api_main_activity_firebase/index:post', 1, 1727886375, 'TOKEN-90FD833EA7-795-02-10-2024--23:10:10'),
(9, 'uri:main_activity/v1/api_main_activity_firebase/index:post', 1, 1728005906, 'TOKEN-F8A18043BC-441-03-10-2024--03:10:48'),
(10, 'uri:pulsa_activity/v1/api_pulsa_activity_transaksi/index:post', 1, 1727996371, 'TOKEN-F8A18043BC-441-03-10-2024--03:10:48'),
(11, 'uri:main_activity/v1/api_main_activity_firebase/index:post', 1, 1729216408, 'TOKEN-296C3F7273-144-04-10-2024--09:10:17'),
(12, 'uri:pulsa_activity/v1/api_pulsa_activity_transaksi/index:post', 1, 1728740948, 'TOKEN-296C3F7273-144-04-10-2024--09:10:17'),
(13, 'uri:deposit_activity/v1/api_deposit_activity_transaksi/index:post', 1, 1729243891, 'TOKEN-296C3F7273-144-04-10-2024--09:10:17');

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

--
-- Table structure for table `tbl_mst_linkaja`
--

CREATE TABLE `tbl_mst_linkaja` (
  `mst_linkaja_id` int(11) NOT NULL,
  `mst_linkaja_kode` varchar(100) DEFAULT NULL,
  `mst_linkaja_nama` varchar(150) DEFAULT NULL,
  `mst_linkaja_keterangan` varchar(250) DEFAULT NULL,
  `mst_linkaja_notasi` varchar(250) DEFAULT NULL,
  `mst_linkaja_harga` double DEFAULT 0,
  `mst_linkaja_admin` double DEFAULT 0,
  `mst_linkaja_poin` int(11) DEFAULT NULL,
  `mst_linkaja_urutan` int(11) DEFAULT NULL,
  `mst_linkaja_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_masa_aktif`
--

CREATE TABLE `tbl_mst_masa_aktif` (
  `mst_masa_aktif_id` int(11) NOT NULL,
  `mst_masa_aktif_kode` varchar(100) DEFAULT NULL,
  `mst_masa_aktif_operator` varchar(100) DEFAULT NULL,
  `mst_masa_aktif_nama` varchar(150) DEFAULT NULL,
  `mst_masa_aktif_keterangan` varchar(250) DEFAULT NULL,
  `mst_masa_aktif_notasi` varchar(250) DEFAULT NULL,
  `mst_masa_aktif_harga` double DEFAULT 0,
  `mst_masa_aktif_admin` double DEFAULT 0,
  `mst_masa_aktif_poin` int(11) DEFAULT NULL,
  `mst_masa_aktif_urutan` int(11) DEFAULT NULL,
  `mst_masa_aktif_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_materai`
--

CREATE TABLE `tbl_mst_materai` (
  `mst_materai_id` int(11) NOT NULL,
  `mst_materai_kode` varchar(100) DEFAULT NULL,
  `mst_materai_nama` varchar(150) DEFAULT NULL,
  `mst_materai_keterangan` varchar(250) DEFAULT NULL,
  `mst_materai_notasi` varchar(250) DEFAULT NULL,
  `mst_materai_harga` double DEFAULT 0,
  `mst_materai_admin` double DEFAULT 0,
  `mst_materai_poin` int(11) DEFAULT NULL,
  `mst_materai_urutan` int(11) DEFAULT NULL,
  `mst_materai_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_maxim`
--

CREATE TABLE `tbl_mst_maxim` (
  `mst_maxim_id` int(11) NOT NULL,
  `mst_maxim_kode` varchar(100) DEFAULT NULL,
  `mst_maxim_nama` varchar(150) DEFAULT NULL,
  `mst_maxim_keterangan` varchar(250) DEFAULT NULL,
  `mst_maxim_notasi` varchar(250) DEFAULT NULL,
  `mst_maxim_harga` double DEFAULT 0,
  `mst_maxim_admin` double DEFAULT 0,
  `mst_maxim_poin` int(11) DEFAULT NULL,
  `mst_maxim_urutan` int(11) DEFAULT NULL,
  `mst_maxim_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_maxim_driver`
--

CREATE TABLE `tbl_mst_maxim_driver` (
  `mst_maxim_driver_id` int(11) NOT NULL,
  `mst_maxim_driver_kode` varchar(100) DEFAULT NULL,
  `mst_maxim_driver_nama` varchar(150) DEFAULT NULL,
  `mst_maxim_driver_keterangan` varchar(250) DEFAULT NULL,
  `mst_maxim_driver_notasi` varchar(250) DEFAULT NULL,
  `mst_maxim_driver_harga` double DEFAULT 0,
  `mst_maxim_driver_admin` double DEFAULT 0,
  `mst_maxim_driver_poin` int(11) DEFAULT NULL,
  `mst_maxim_driver_urutan` int(11) DEFAULT NULL,
  `mst_maxim_driver_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_menu`
--

CREATE TABLE `tbl_mst_menu` (
  `mst_menu_id` int(11) NOT NULL,
  `mst_menu_kode` varchar(100) DEFAULT NULL,
  `mst_menu_grup` enum('Isi Ulang','Bayar Tagihan','Dompet Digital','Saldo Driver','Voucher','Uang Elektronik') DEFAULT NULL,
  `mst_menu_nama` varchar(100) DEFAULT NULL,
  `mst_menu_tipe` enum('Activity','Webview') DEFAULT NULL,
  `mst_menu_link` varchar(250) DEFAULT NULL,
  `mst_menu_icon` varchar(100) DEFAULT NULL,
  `mst_menu_urutan` int(11) DEFAULT NULL,
  `mst_menu_keterangan` varchar(250) DEFAULT NULL,
  `mst_menu_notasi` varchar(250) DEFAULT NULL,
  `mst_menu_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_menu`
--

INSERT INTO `tbl_mst_menu` (`mst_menu_id`, `mst_menu_kode`, `mst_menu_grup`, `mst_menu_nama`, `mst_menu_tipe`, `mst_menu_link`, `mst_menu_icon`, `mst_menu_urutan`, `mst_menu_keterangan`, `mst_menu_notasi`, `mst_menu_status`) VALUES
(1, 'M-001', 'Isi Ulang', 'Pulsa', 'Activity', 'IsiUlang.PulsaActivity.PulsaMasukkanActivity', 'icon_pulsa.png', 1, 'Nomor HP diperlukan untuk melakukan transaksi', 'Saat ini tersedia diskon besar-besaran pulsa telkomsel, axis dan tri. Transaksi sekarang!', '0'),
(2, 'M-002', 'Isi Ulang', 'Paket Data', 'Activity', 'IsiUlang.PaketDataActivity.PaketDataMasukkanActivity', 'icon_paket_data.png', 2, 'Nomor HP diperlukan untuk melakukan transaksi', 'Banyak pilihan paket data murah meriah. Buruan beli paket data sesuai kebutuhan kamu sekarang', '0'),
(3, 'M-003', 'Isi Ulang', 'Paket Nelfon', 'Activity', 'IsiUlang.PaketNelfonActivity.PaketNelfonMasukkanActivity', 'icon_paket_nelfon.png', 3, 'Nomor HP diperlukan untuk melakukan transaksi', 'Pilih paket nelfon suka-suka', '0'),
(4, 'M-004', 'Isi Ulang', 'Paket SMS', 'Activity', 'IsiUlang.PaketSmsActivity.PaketSmsMasukkanActivity', 'icon_paket_sms.png', 4, NULL, NULL, '0'),
(5, 'M-005', 'Isi Ulang', 'Token PLN', 'Activity', 'IsiUlang.TokenPlnActivity.TokenPlnMasukkanActivity', 'icon_pln.png', 5, 'Nomor meter atau id pelanggan', 'Beli token PLN sekarang, murah meriah', '0'),
(6, 'M-006', 'Isi Ulang', 'Masa Aktif', 'Activity', 'IsiUlang.MasaAktifActivity.MasaAktifMasukkanActivity', 'icon_masa_aktif.png', 6, 'Nomor HP diperlukan untuk melakukan transaksi', 'Perpanjang masa aktif kartu kamu sekarang', '0'),
(7, 'M-007', 'Isi Ulang', 'Pulsa Transfer', 'Activity', 'IsiUlang.PulsaTransferActivity.PulsaTransferMasukkanActivity', 'icon_pulsa_transfer.png', 7, NULL, 'Pulsa transfer dengan harga lebih murah', '0'),
(8, 'M-008', 'Isi Ulang', 'Game', 'Activity', 'IsiUlang.GameActivity.GameKategoriActivity.GameKategoriActivity', 'icon_game.png', 8, NULL, NULL, '0'),
(9, 'M-009', 'Bayar Tagihan', 'BPJS', 'Activity', 'BayarTagihan.BpjsActivity.BpjsMasukkanActivity', 'icon_bpjs.png', 1, 'Nomor pelanggan BPSJ Kesehatan dibutuhkan untuk melakukan transaksi', 'Setelah memasukkan nomor, tekan cek tagihan diabwah', '0'),
(10, 'M-010', 'Bayar Tagihan', 'HP', 'Activity', 'BayarTagihan.HpActivity.HpKategoriActivity.HpKategoriActivity', 'icon_hp.png', 2, 'Nomor HP dibutuhkan untuk melakukan transaksi', '', '0'),
(11, 'M-011', 'Bayar Tagihan', 'TV', 'Activity', 'BayarTagihan.TvActivity.TvKategoriActivity.TvKategoriActivity', 'icon_tv.png', 3, 'Nomor pelanggan TV', NULL, '0'),
(12, 'M-012', 'Bayar Tagihan', 'PLN', 'Activity', 'BayarTagihan.PlnActivity.PlnMasukkanActivity', 'icon_pln_pasca.png', 4, 'Nomor pelanggan PLN dibutuhkan untuk melakukan transaksi', NULL, '0'),
(13, 'M-013', 'Bayar Tagihan', 'Internet', 'Activity', 'BayarTagihan.InternetActivity.InternetKategoriActivity.InternetKategoriActivity', 'icon_internet.png', 5, NULL, NULL, '0'),
(14, 'M-014', 'Bayar Tagihan', 'Multifinance', 'Activity', 'BayarTagihan.MultifinanceActivity.MultifinanceKategoriActivity.MultifinanceKategoriActivity', 'icon_multifinance.png', 6, NULL, NULL, '0'),
(15, 'M-015', 'Bayar Tagihan', 'PDAM', 'Activity', 'BayarTagihan.PdamActivity.PdamKategoriActivity.PdamKategoriActivity', 'icon_pdam.png', 7, NULL, NULL, '0'),
(16, 'M-016', 'Bayar Tagihan', 'PBB', 'Activity', 'BayarTagihan.PbbActivity.PbbKategoriActivity.PbbKategoriActivity', 'icon_pbb.png', 8, NULL, NULL, '0'),
(17, 'M-017', 'Bayar Tagihan', 'Gas Negara', 'Activity', 'BayarTagihan.GasActivity.GasMasukkanActivity', 'icon_gas.png', 9, 'Nomor pelanggan gas negara dibutuhkan untuk melakukan transaksi', NULL, '0'),
(18, 'M-018', 'Dompet Digital', 'Gopay', 'Activity', 'DompetDigital.GopayActivity.GopayMasukkanActivity', 'icon_gopay.png', 1, 'Nomor HP dibutuhkan untuk melakukan transaksi', 'Saldo Gopay murah meriah', '0'),
(19, 'M-019', 'Dompet Digital', 'OVO', 'Activity', 'DompetDigital.OvoActivity.OvoMasukkanActivity', 'icon_ovo.png', 2, NULL, NULL, '0'),
(20, 'M-020', 'Dompet Digital', 'LinkAja', 'Activity', 'DompetDigital.LinkajaActivity.LinkajaMasukkanActivity', 'icon_linkaja.png', 3, NULL, NULL, '0'),
(21, 'M-021', 'Dompet Digital', 'Maxim', 'Activity', 'DompetDigital.MaximActivity.MaximMasukkanActivity', 'icon_maxim.png', 4, 'ID Maxim customer dibutuhkan pada saat melakukan transaksi ', NULL, '0'),
(22, 'M-022', 'Dompet Digital', 'ShopeePay', 'Activity', 'DompetDigital.ShopeepayActivity.ShopeepayMasukkanActivity', 'icon_shopeepay.png', 5, NULL, NULL, '0'),
(23, 'M-023', 'Dompet Digital', 'Doku', 'Activity', 'DompetDigital.DokuActivity.DokuMasukkanActivity', 'icon_doku.png', 6, NULL, NULL, '0'),
(24, 'M-024', 'Dompet Digital', 'Grab', 'Activity', 'DompetDigital.GrabActivity.GrabMasukkanActivity', 'icon_grab.png', 7, NULL, NULL, '0'),
(25, 'M-025', 'Dompet Digital', 'Sakuku', 'Activity', 'DompetDigital.SakukuActivity.SakukuMasukkanActivity', 'icon_sakuku.png', 8, NULL, NULL, '0'),
(26, 'M-026', 'Dompet Digital', 'i-saku', 'Activity', 'DompetDigital.IsakuActivity.IsakuMasukkanActivity', 'icon_isaku.png', 9, NULL, NULL, '0'),
(27, 'M-027', 'Saldo Driver', 'Gojek Driver', 'Activity', 'SaldoDriver.GojekDriverActivity.GojekDriverMasukkanActivity', 'icon_gojek_driver.png', 1, 'Nomor HP dibutuhkan untuk melakukan transaksi', NULL, '0'),
(28, 'M-028', 'Saldo Driver', 'Maxim Driver', 'Activity', 'SaldoDriver.MaximDriverActivity.MaximDriverMasukkanActivity', 'icon_maxim_driver.png', 2, NULL, NULL, '0'),
(29, 'M-029', 'Saldo Driver', 'Grab Driver', 'Activity', 'SaldoDriver.GrabDriverActivity.GrabDriverMasukkanActivity', 'icon_grab_driver.png', 3, NULL, NULL, '0'),
(30, 'M-030', 'Saldo Driver', 'Shopee Driver', 'Activity', 'SaldoDriver.ShopeeDriverActivity.ShopeeDriverMasukkanActivity', 'icon_shopee_driver.png', 4, NULL, NULL, '0'),
(31, 'M-031', 'Voucher', 'Indomaret', 'Activity', 'Voucher.IndomaretActivity.IndomaretMasukkanActivity', 'icon_indomaret.png', 1, NULL, NULL, '0'),
(32, 'M-032', 'Voucher', 'Alfamart', 'Activity', 'Voucher.AlfamartActivity.AlfamartMasukkanActivity', 'icon_alfamart.png', 2, NULL, NULL, '0'),
(33, 'M-033', 'Voucher', 'Tokopedia', 'Activity', 'Voucher.TokopediaActivity.TokopediaMasukkanActivity', 'icon_tokopedia.png', 3, NULL, NULL, '0'),
(34, 'M-034', 'Voucher', 'E-Materai', 'Activity', 'Voucher.MateraiActivity.MateraiMasukkanActivity', 'icon_materai.png', 4, 'Masukkan nomor HP untuk melakukan pembelian e-materai', 'E-Materai digunakan untuk pembubuhan materai secara digital', '0'),
(35, 'M-035', 'Voucher', 'Traveloka', 'Activity', 'Voucher.TravelokaActivity.TravelokaMasukkanActivity', 'icon_traveloka.png', 5, NULL, NULL, '0'),
(36, 'M-036', 'Voucher', 'M-TIX', 'Activity', 'Voucher.MtixActivity.MtixMasukkanActivity', 'icon_mtix.png', 6, NULL, NULL, '0'),
(37, 'M-037', 'Voucher', 'TIX-ID', 'Activity', 'Voucher.TixidActivity.TixidMasukkanActivity', 'icon_tixid.png', 7, NULL, NULL, '0'),
(38, 'M-038', 'Voucher', 'Spotify', 'Activity', 'Voucher.SpotifyActivity.SpotifyMasukkanActivity', 'icon_spotify.png', 8, NULL, NULL, '0'),
(39, 'M-039', 'Voucher', 'Googleplay', 'Activity', 'Voucher.GoogleplayActivity.GoogleplayMasukkanActivity', 'icon_googleplay.png', 9, NULL, NULL, '0'),
(40, 'M-040', 'Voucher', 'Vidio', 'Activity', 'Voucher.VidioActivity.VidioMasukkanActivity', 'icon_vidio.png', 10, NULL, NULL, '0'),
(41, 'M-041', 'Voucher', 'Unipin', 'Activity', 'Voucher.UnipinActivity.UnipinMasukkanActivity', 'icon_unipin.png', 11, NULL, NULL, '0'),
(42, 'M-042', 'Voucher', 'WIFI-ID', 'Activity', 'Voucher.WifiidActivity.WifiidMasukkanActivity', 'icon_wifiid.png', 12, NULL, NULL, '0'),
(43, 'M-043', 'Uang Elektronik', 'E-Money', 'Activity', 'UangElektronikActivity.EmoneyActivity.EmoneyMasukkanActivity', 'icon_emoney.png', 1, 'Masukkan nomor yang ada pada kartu E-Money', 'Setelah melakukan pengisian saldo E-Money, kamu diwajibkan update saldo di ATM Mandiri atau visa kasir Indomaret dan Alfamart ', '0'),
(44, 'M-044', 'Uang Elektronik', 'TapCash', 'Activity', 'UangElektronikActivity.TapcashActivity.TapcashMasukkanActivity', 'icon_tapcash.png', 2, 'Masukkan nomor yang ada pada kartu TapCash', 'Setelah melakukan pengisian saldo TapCash, kamu diwajibkan update saldo di ATM BNI atau visa kasir Indomaret dan Alfamart ', '0'),
(45, 'M-045', 'Uang Elektronik', 'Brizzi', 'Activity', 'UangElektronikActivity.BrizziActivity.BrizziMasukkanActivity', 'icon_brizzi.png', 3, 'Masukkan nomor yang ada pada kartu Brizzi', 'Setelah melakukan pengisian saldo Brizzi, kamu diwajibkan update saldo di ATM BRI atau visa kasir Indomaret dan Alfamart ', '0'),
(46, 'M-046', 'Uang Elektronik', 'Flazz', 'Activity', '-', 'icon_flazz.png', 4, 'Fitur uang elektronik flazz dalam tahap pengembangan', NULL, '1'),
(47, 'M-047', 'Voucher', 'Bukalapak', 'Activity', 'Voucher.BukalapakActivity.BukalapakMasukkanActivity', 'icon_bukalapak.png', 13, NULL, NULL, '0'),
(48, 'M-048', 'Dompet Digital', 'Dana', 'Activity', 'DompetDigital.DanaActivity.DanaMasukkanActivity', 'icon_dana.png', 5, 'Nomor HP diperlukan untuk melakukan transaksi', NULL, '0');

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

--
-- Table structure for table `tbl_mst_mtix`
--

CREATE TABLE `tbl_mst_mtix` (
  `mst_mtix_id` int(11) NOT NULL,
  `mst_mtix_kode` varchar(100) DEFAULT NULL,
  `mst_mtix_nama` varchar(150) DEFAULT NULL,
  `mst_mtix_keterangan` varchar(250) DEFAULT NULL,
  `mst_mtix_notasi` varchar(250) DEFAULT NULL,
  `mst_mtix_harga` double DEFAULT 0,
  `mst_mtix_admin` double DEFAULT 0,
  `mst_mtix_poin` int(11) DEFAULT NULL,
  `mst_mtix_urutan` int(11) DEFAULT NULL,
  `mst_mtix_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_notifikasi`
--

CREATE TABLE `tbl_mst_notifikasi` (
  `mst_notifikasi_id` int(11) NOT NULL,
  `mst_notifikasi_judul` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mst_notifikasi_isi` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_mst_notifikasi`
--

INSERT INTO `tbl_mst_notifikasi` (`mst_notifikasi_id`, `mst_notifikasi_judul`, `mst_notifikasi_isi`) VALUES
(1, 'Smean', 'Transaksi lancar dan aman'),
(2, 'Smean', 'Jangan Lupa untuk Membayar tagihan PLN, BPJS, dan tagihan lainnya menggunakan Smean dan raih poin sebanyak banyaknya');

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

--
-- Table structure for table `tbl_mst_ovo`
--

CREATE TABLE `tbl_mst_ovo` (
  `mst_ovo_id` int(11) NOT NULL,
  `mst_ovo_kode` varchar(100) DEFAULT NULL,
  `mst_ovo_nama` varchar(150) DEFAULT NULL,
  `mst_ovo_keterangan` varchar(250) DEFAULT NULL,
  `mst_ovo_notasi` varchar(250) DEFAULT NULL,
  `mst_ovo_harga` double DEFAULT 0,
  `mst_ovo_admin` double DEFAULT 0,
  `mst_ovo_poin` int(11) DEFAULT NULL,
  `mst_ovo_urutan` int(11) DEFAULT NULL,
  `mst_ovo_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_paket_data`
--

CREATE TABLE `tbl_mst_paket_data` (
  `mst_paket_data_id` int(11) NOT NULL,
  `mst_paket_data_kode` varchar(100) DEFAULT NULL,
  `mst_paket_data_operator` varchar(70) DEFAULT NULL,
  `mst_paket_data_nama` varchar(150) DEFAULT NULL,
  `mst_paket_data_keterangan` varchar(250) DEFAULT NULL,
  `mst_paket_data_notasi` varchar(250) DEFAULT NULL,
  `mst_paket_data_harga` double DEFAULT 0,
  `mst_paket_data_admin` double DEFAULT 0,
  `mst_paket_data_poin` int(11) DEFAULT NULL,
  `mst_paket_data_urutan` int(11) DEFAULT NULL,
  `mst_paket_data_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_paket_nelfon`
--

CREATE TABLE `tbl_mst_paket_nelfon` (
  `mst_paket_nelfon_id` int(11) NOT NULL,
  `mst_paket_nelfon_kode` varchar(100) DEFAULT NULL,
  `mst_paket_nelfon_operator` varchar(70) DEFAULT NULL,
  `mst_paket_nelfon_nama` varchar(150) DEFAULT NULL,
  `mst_paket_nelfon_keterangan` varchar(250) DEFAULT NULL,
  `mst_paket_nelfon_notasi` varchar(250) DEFAULT NULL,
  `mst_paket_nelfon_harga` double DEFAULT 0,
  `mst_paket_nelfon_admin` double DEFAULT 0,
  `mst_paket_nelfon_poin` int(11) DEFAULT NULL,
  `mst_paket_nelfon_urutan` int(11) DEFAULT NULL,
  `mst_paket_nelfon_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_paket_sms`
--

CREATE TABLE `tbl_mst_paket_sms` (
  `mst_paket_sms_id` int(11) NOT NULL,
  `mst_paket_sms_kode` varchar(100) DEFAULT NULL,
  `mst_paket_sms_operator` varchar(70) DEFAULT NULL,
  `mst_paket_sms_nama` varchar(150) DEFAULT NULL,
  `mst_paket_sms_keterangan` varchar(250) DEFAULT NULL,
  `mst_paket_sms_notasi` varchar(250) DEFAULT NULL,
  `mst_paket_sms_harga` double DEFAULT 0,
  `mst_paket_sms_admin` double DEFAULT 0,
  `mst_paket_sms_poin` int(11) DEFAULT NULL,
  `mst_paket_sms_urutan` int(11) DEFAULT NULL,
  `mst_paket_sms_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_poin`
--

CREATE TABLE `tbl_mst_poin` (
  `mst_poin_id` double NOT NULL,
  `mst_poin_kode` varchar(100) DEFAULT NULL,
  `mst_poin_user_kode` varchar(100) DEFAULT NULL,
  `mst_poin_jumlah` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_poin`
--

INSERT INTO `tbl_mst_poin` (`mst_poin_id`, `mst_poin_kode`, `mst_poin_user_kode`, `mst_poin_jumlah`) VALUES
(1, 'POIN-00561CF5E9-589-210622', 'USER-D405F838D9-173-210622', 0),
(2, 'POIN-F9C9E18062-100-101035', 'USER-43C4D7D237-958-101035', 1);

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

--
-- Table structure for table `tbl_mst_produk`
--

CREATE TABLE `tbl_mst_produk` (
  `mst_produk_id` int(11) NOT NULL,
  `mst_produk_kode` varchar(100) DEFAULT NULL,
  `mst_produk_kategori_kode` varchar(100) DEFAULT NULL,
  `mst_produk_nama` varchar(200) DEFAULT NULL,
  `mst_produk_satuan` varchar(100) DEFAULT NULL,
  `mst_produk_harga` double DEFAULT 0,
  `mst_produk_diskon` double DEFAULT 0,
  `mst_produk_deskripsi` text DEFAULT NULL,
  `mst_produk_foto` varchar(100) DEFAULT NULL,
  `mst_produk_nama_penjual` varchar(100) DEFAULT NULL,
  `mst_produk_nohp_penjual` varchar(100) DEFAULT NULL,
  `mst_produk_rekomendasi` enum('0','1') DEFAULT '0',
  `mst_produk_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbl_mst_pulsa`
--

CREATE TABLE `tbl_mst_pulsa` (
  `mst_pulsa_id` int(11) NOT NULL,
  `mst_pulsa_kode` varchar(100) DEFAULT NULL,
  `mst_pulsa_operator` varchar(70) DEFAULT NULL,
  `mst_pulsa_nama` varchar(150) DEFAULT NULL,
  `mst_pulsa_keterangan` varchar(250) DEFAULT NULL,
  `mst_pulsa_notasi` varchar(250) DEFAULT NULL,
  `mst_pulsa_harga` double DEFAULT 0,
  `mst_pulsa_admin` double DEFAULT 0,
  `mst_pulsa_poin` int(11) DEFAULT NULL,
  `mst_pulsa_urutan` int(11) DEFAULT NULL,
  `mst_pulsa_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_mst_pulsa`
--

INSERT INTO `tbl_mst_pulsa` (`mst_pulsa_id`, `mst_pulsa_kode`, `mst_pulsa_operator`, `mst_pulsa_nama`, `mst_pulsa_keterangan`, `mst_pulsa_notasi`, `mst_pulsa_harga`, `mst_pulsa_admin`, `mst_pulsa_poin`, `mst_pulsa_urutan`, `mst_pulsa_status`) VALUES
(1, 'XF5', 'XL', 'Xl Pulsa Transfer 5.000', ' Valid 100%', 'Normal', 5542, 0, 0, 1, '0'),
(3, 'IRP5', 'Indosat', 'Indosat Reguler 5.000', 'Valid 100%', 'Promo', 5570, 0, 0, 1, '0'),
(4, 'SRP2', 'Telkomsel', 'Telkomsel Reguler 2.000', ' Valid 100%', 'Promo', 2442, 0, 0, 0, '0'),
(5, 'SRP5', 'Telkomsel', 'Telkomsel Reguler 5.000', 'Valid 100%', 'Promo', 5190, 0, 0, 1, '0'),
(6, 'IRP10', 'Indosat', 'Indosat Reguler 10.000', 'Valid 100%', 'Promo', 10180, 0, 0, 0, '0'),
(7, 'TR1', 'Tri', 'Tri Reguler 1.000', 'Tri Reguler ', 'Promo Cuan', 2000, 100, 1, 1, '0');

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

--
-- Table structure for table `tbl_mst_pulsa_transfer`
--

CREATE TABLE `tbl_mst_pulsa_transfer` (
  `mst_pulsa_transfer_id` int(11) NOT NULL,
  `mst_pulsa_transfer_kode` varchar(100) DEFAULT NULL,
  `mst_pulsa_transfer_operator` varchar(70) DEFAULT NULL,
  `mst_pulsa_transfer_nama` varchar(150) DEFAULT NULL,
  `mst_pulsa_transfer_keterangan` varchar(250) DEFAULT NULL,
  `mst_pulsa_transfer_notasi` varchar(250) DEFAULT NULL,
  `mst_pulsa_transfer_harga` double DEFAULT 0,
  `mst_pulsa_transfer_admin` double DEFAULT 0,
  `mst_pulsa_transfer_poin` int(11) DEFAULT NULL,
  `mst_pulsa_transfer_urutan` int(11) DEFAULT NULL,
  `mst_pulsa_transfer_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_sakuku`
--

CREATE TABLE `tbl_mst_sakuku` (
  `mst_sakuku_id` int(11) NOT NULL,
  `mst_sakuku_kode` varchar(100) DEFAULT NULL,
  `mst_sakuku_nama` varchar(150) DEFAULT NULL,
  `mst_sakuku_keterangan` varchar(250) DEFAULT NULL,
  `mst_sakuku_notasi` varchar(250) DEFAULT NULL,
  `mst_sakuku_harga` double DEFAULT 0,
  `mst_sakuku_admin` double DEFAULT 0,
  `mst_sakuku_poin` int(11) DEFAULT NULL,
  `mst_sakuku_urutan` int(11) DEFAULT NULL,
  `mst_sakuku_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_saldo`
--

CREATE TABLE `tbl_mst_saldo` (
  `mst_saldo_id` double NOT NULL,
  `mst_saldo_kode` varchar(100) DEFAULT NULL,
  `mst_saldo_user_kode` varchar(100) DEFAULT NULL,
  `mst_saldo_jumlah` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_saldo`
--

INSERT INTO `tbl_mst_saldo` (`mst_saldo_id`, `mst_saldo_kode`, `mst_saldo_user_kode`, `mst_saldo_jumlah`) VALUES
(1, 'SALDO-B3AAF888F5-70-210622', 'USER-D405F838D9-173-210622', 0),
(2, 'SALDO-6388489FCC-293-101035', 'USER-43C4D7D237-958-101035', 0);

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

--
-- Table structure for table `tbl_mst_shopeepay`
--

CREATE TABLE `tbl_mst_shopeepay` (
  `mst_shopeepay_id` int(11) NOT NULL,
  `mst_shopeepay_kode` varchar(100) DEFAULT NULL,
  `mst_shopeepay_nama` varchar(150) DEFAULT NULL,
  `mst_shopeepay_keterangan` varchar(250) DEFAULT NULL,
  `mst_shopeepay_notasi` varchar(250) DEFAULT NULL,
  `mst_shopeepay_harga` double DEFAULT 0,
  `mst_shopeepay_admin` double DEFAULT 0,
  `mst_shopeepay_poin` int(11) DEFAULT NULL,
  `mst_shopeepay_urutan` int(11) DEFAULT NULL,
  `mst_shopeepay_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_shopee_driver`
--

CREATE TABLE `tbl_mst_shopee_driver` (
  `mst_shopee_driver_id` int(11) NOT NULL,
  `mst_shopee_driver_kode` varchar(100) DEFAULT NULL,
  `mst_shopee_driver_nama` varchar(150) DEFAULT NULL,
  `mst_shopee_driver_keterangan` varchar(250) DEFAULT NULL,
  `mst_shopee_driver_notasi` varchar(250) DEFAULT NULL,
  `mst_shopee_driver_harga` double DEFAULT 0,
  `mst_shopee_driver_admin` double DEFAULT 0,
  `mst_shopee_driver_poin` int(11) DEFAULT NULL,
  `mst_shopee_driver_urutan` int(11) DEFAULT NULL,
  `mst_shopee_driver_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_spotify`
--

CREATE TABLE `tbl_mst_spotify` (
  `mst_spotify_id` int(11) NOT NULL,
  `mst_spotify_kode` varchar(100) DEFAULT NULL,
  `mst_spotify_nama` varchar(150) DEFAULT NULL,
  `mst_spotify_keterangan` varchar(250) DEFAULT NULL,
  `mst_spotify_notasi` varchar(250) DEFAULT NULL,
  `mst_spotify_harga` double DEFAULT 0,
  `mst_spotify_admin` double DEFAULT 0,
  `mst_spotify_poin` int(11) DEFAULT NULL,
  `mst_spotify_urutan` int(11) DEFAULT NULL,
  `mst_spotify_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_tapcash`
--

CREATE TABLE `tbl_mst_tapcash` (
  `mst_tapcash_id` int(11) NOT NULL,
  `mst_tapcash_kode` varchar(100) DEFAULT NULL,
  `mst_tapcash_nama` varchar(150) DEFAULT NULL,
  `mst_tapcash_keterangan` varchar(250) DEFAULT NULL,
  `mst_tapcash_notasi` varchar(250) DEFAULT NULL,
  `mst_tapcash_harga` double DEFAULT 0,
  `mst_tapcash_admin` double DEFAULT 0,
  `mst_tapcash_poin` int(11) DEFAULT NULL,
  `mst_tapcash_urutan` int(11) DEFAULT NULL,
  `mst_tapcash_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_tixid`
--

CREATE TABLE `tbl_mst_tixid` (
  `mst_tixid_id` int(11) NOT NULL,
  `mst_tixid_kode` varchar(100) DEFAULT NULL,
  `mst_tixid_nama` varchar(150) DEFAULT NULL,
  `mst_tixid_keterangan` varchar(250) DEFAULT NULL,
  `mst_tixid_notasi` varchar(250) DEFAULT NULL,
  `mst_tixid_harga` double DEFAULT 0,
  `mst_tixid_admin` double DEFAULT 0,
  `mst_tixid_poin` int(11) DEFAULT NULL,
  `mst_tixid_urutan` int(11) DEFAULT NULL,
  `mst_tixid_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_token_pln`
--

CREATE TABLE `tbl_mst_token_pln` (
  `mst_token_pln_id` int(11) NOT NULL,
  `mst_token_pln_kode` varchar(100) DEFAULT NULL,
  `mst_token_pln_nama` varchar(150) DEFAULT NULL,
  `mst_token_pln_keterangan` varchar(250) DEFAULT NULL,
  `mst_token_pln_notasi` varchar(250) DEFAULT NULL,
  `mst_token_pln_harga` double DEFAULT 0,
  `mst_token_pln_admin` double DEFAULT 0,
  `mst_token_pln_poin` int(11) DEFAULT NULL,
  `mst_token_pln_urutan` int(11) DEFAULT NULL,
  `mst_token_pln_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_tokopedia`
--

CREATE TABLE `tbl_mst_tokopedia` (
  `mst_tokopedia_id` int(11) NOT NULL,
  `mst_tokopedia_kode` varchar(100) DEFAULT NULL,
  `mst_tokopedia_nama` varchar(150) DEFAULT NULL,
  `mst_tokopedia_keterangan` varchar(250) DEFAULT NULL,
  `mst_tokopedia_notasi` varchar(250) DEFAULT NULL,
  `mst_tokopedia_harga` double DEFAULT 0,
  `mst_tokopedia_admin` double DEFAULT 0,
  `mst_tokopedia_poin` int(11) DEFAULT NULL,
  `mst_tokopedia_urutan` int(11) DEFAULT NULL,
  `mst_tokopedia_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_traveloka`
--

CREATE TABLE `tbl_mst_traveloka` (
  `mst_traveloka_id` int(11) NOT NULL,
  `mst_traveloka_kode` varchar(100) DEFAULT NULL,
  `mst_traveloka_nama` varchar(150) DEFAULT NULL,
  `mst_traveloka_keterangan` varchar(250) DEFAULT NULL,
  `mst_traveloka_notasi` varchar(250) DEFAULT NULL,
  `mst_traveloka_harga` double DEFAULT 0,
  `mst_traveloka_admin` double DEFAULT 0,
  `mst_traveloka_poin` int(11) DEFAULT NULL,
  `mst_traveloka_urutan` int(11) DEFAULT NULL,
  `mst_traveloka_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_unipin`
--

CREATE TABLE `tbl_mst_unipin` (
  `mst_unipin_id` int(11) NOT NULL,
  `mst_unipin_kode` varchar(100) DEFAULT NULL,
  `mst_unipin_nama` varchar(150) DEFAULT NULL,
  `mst_unipin_keterangan` varchar(250) DEFAULT NULL,
  `mst_unipin_notasi` varchar(250) DEFAULT NULL,
  `mst_unipin_harga` double DEFAULT 0,
  `mst_unipin_admin` double DEFAULT 0,
  `mst_unipin_poin` int(11) DEFAULT NULL,
  `mst_unipin_urutan` int(11) DEFAULT NULL,
  `mst_unipin_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_update`
--

CREATE TABLE `tbl_mst_update` (
  `mst_update_id` int(11) NOT NULL,
  `mst_update_kode` varchar(100) DEFAULT NULL,
  `mst_update_tipe` enum('Update','Maintenance') DEFAULT NULL,
  `mst_update_versi` int(11) DEFAULT NULL,
  `mst_update_judul` varchar(100) DEFAULT NULL,
  `mst_update_isi` varchar(200) DEFAULT NULL,
  `mst_update_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_update`
--

INSERT INTO `tbl_mst_update` (`mst_update_id`, `mst_update_kode`, `mst_update_tipe`, `mst_update_versi`, `mst_update_judul`, `mst_update_isi`, `mst_update_status`) VALUES
(1, 'UPDATE-001', 'Maintenance', 1, 'Update', 'Silahkan update aplikasi kamu sekarang, ada beberapa perubahan penting', '1');

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

--
-- Table structure for table `tbl_mst_user`
--

CREATE TABLE `tbl_mst_user` (
  `mst_user_id` double NOT NULL,
  `mst_user_kode` varchar(100) DEFAULT NULL,
  `mst_user_nama_lengkap` varchar(100) DEFAULT NULL,
  `mst_user_nomor_hp` varchar(20) DEFAULT NULL,
  `mst_user_email` varchar(100) DEFAULT NULL,
  `mst_user_password` varchar(100) DEFAULT NULL,
  `mst_user_tipe` enum('Normal','Silver','Gold','Diamond') DEFAULT 'Normal',
  `mst_user_referal_kode` varchar(100) DEFAULT NULL,
  `mst_user_referal_bonus` double DEFAULT 5,
  `mst_user_upline` varchar(100) DEFAULT NULL,
  `mst_user_firebase` varchar(200) DEFAULT NULL,
  `mst_user_token` varchar(200) DEFAULT NULL,
  `mst_user_zona_waktu` varchar(100) DEFAULT NULL,
  `mst_user_tanggal_daftar` datetime DEFAULT NULL,
  `mst_user_terkhir_aktif` datetime DEFAULT NULL,
  `mst_user_status` enum('0','1','2') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_user`
--

INSERT INTO `tbl_mst_user` (`mst_user_id`, `mst_user_kode`, `mst_user_nama_lengkap`, `mst_user_nomor_hp`, `mst_user_email`, `mst_user_password`, `mst_user_tipe`, `mst_user_referal_kode`, `mst_user_referal_bonus`, `mst_user_upline`, `mst_user_firebase`, `mst_user_token`, `mst_user_zona_waktu`, `mst_user_tanggal_daftar`, `mst_user_terkhir_aktif`, `mst_user_status`) VALUES
(1, 'USER-D405F838D9-173-210622', 'Dummy Account', '08123456789', 'dummy@gmail.com', 'd33c7a22ab2d40bb585a164b774c10b6c58dabb9', 'Gold', 'FR8A31', 50, NULL, 'eeN2DM0YTSiCyMX1AiZD3i:APA91bFWCdcPnMHDQXess5mmhHfmmcvQTptV7MKOeWP4fkGLlFhbIpYPyMKUTJGtABbUuCE6Ak4F-WcarkZ28XccDXFHqhhj2yNYSMx3o3jCYKu1PhYl9t4ZinTozOQaXc-coUS2AAQa', 'TOKEN-EBD1D7C4A4-173-27-06-2023--10:06:24', 'Asia/Jakarta', '1999-01-01 21:11:22', '2023-06-27 10:27:28', '0'),
(2, 'USER-43C4D7D237-958-101035', 'Mami', '085333088857', 'mami@mami.gmail.com', 'cc9f816a42431cf852cdc7a3fad42a6f65ffce24', 'Normal', 'MMIA57', 5, NULL, 'fQggwNrVS4ujPGguws_FZ7:APA91bGut3MCcdWOqLjfzTV4EKOv1xqGINxFPq6rlklZ5_auHUrxsJL7VBUh0gfV96LmC3W1owTaZBAeWGjz8xR6k3mvBxygjzepiF4Dw1i_sRskZusU45MG3v2Ktux5bAWZZg7raLE9', 'TOKEN-296C3F7273-144-04-10-2024--09:10:17', NULL, '2024-10-02 10:28:35', NULL, '0');

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

--
-- Table structure for table `tbl_mst_user_log`
--

CREATE TABLE `tbl_mst_user_log` (
  `id` double NOT NULL,
  `uri` text NOT NULL,
  `mst_user_kode` varchar(50) DEFAULT NULL,
  `mst_user_nama_lengkap` varchar(255) DEFAULT NULL,
  `mst_user_nomor_hp` varchar(20) DEFAULT NULL,
  `mst_user_email` varchar(200) DEFAULT NULL,
  `method` varchar(6) NOT NULL,
  `params` text DEFAULT NULL,
  `api_key` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `time` datetime NOT NULL,
  `rtime` float DEFAULT NULL,
  `authorized` varchar(1) NOT NULL,
  `response_code` smallint(3) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_mst_vidio`
--

CREATE TABLE `tbl_mst_vidio` (
  `mst_vidio_id` int(11) NOT NULL,
  `mst_vidio_kode` varchar(100) DEFAULT NULL,
  `mst_vidio_nama` varchar(150) DEFAULT NULL,
  `mst_vidio_keterangan` varchar(250) DEFAULT NULL,
  `mst_vidio_notasi` varchar(250) DEFAULT NULL,
  `mst_vidio_harga` double DEFAULT 0,
  `mst_vidio_admin` double DEFAULT 0,
  `mst_vidio_poin` int(11) DEFAULT NULL,
  `mst_vidio_urutan` int(11) DEFAULT NULL,
  `mst_vidio_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_mst_wifiid`
--

CREATE TABLE `tbl_mst_wifiid` (
  `mst_wifiid_id` int(11) NOT NULL,
  `mst_wifiid_kode` varchar(100) DEFAULT NULL,
  `mst_wifiid_nama` varchar(150) DEFAULT NULL,
  `mst_wifiid_keterangan` varchar(250) DEFAULT NULL,
  `mst_wifiid_notasi` varchar(250) DEFAULT NULL,
  `mst_wifiid_harga` double DEFAULT 0,
  `mst_wifiid_admin` double DEFAULT 0,
  `mst_wifiid_poin` int(11) DEFAULT NULL,
  `mst_wifiid_urutan` int(11) DEFAULT NULL,
  `mst_wifiid_status` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_alfamart`
--

CREATE TABLE `tbl_trx_alfamart` (
  `trx_alfamart_id` double NOT NULL,
  `trx_alfamart_kode` varchar(100) DEFAULT NULL,
  `trx_alfamart_user_kode` varchar(100) DEFAULT NULL,
  `trx_alfamart_nomor` varchar(100) DEFAULT NULL,
  `trx_alfamart_nama` varchar(200) DEFAULT NULL,
  `trx_alfamart_admin` double DEFAULT NULL,
  `trx_alfamart_harga` double DEFAULT NULL,
  `trx_alfamart_poin` int(11) DEFAULT NULL,
  `trx_alfamart_sn` varchar(250) DEFAULT NULL,
  `trx_alfamart_keterangan` varchar(250) DEFAULT NULL,
  `trx_alfamart_notasi` varchar(250) DEFAULT NULL,
  `trx_alfamart_tanggal` datetime DEFAULT NULL,
  `trx_alfamart_icon` varchar(100) DEFAULT NULL,
  `trx_alfamart_rc` varchar(10) DEFAULT NULL,
  `trx_alfamart_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_bonus`
--

CREATE TABLE `tbl_trx_bonus` (
  `trx_bonus_id` double NOT NULL,
  `trx_bonus_kode` varchar(100) DEFAULT NULL,
  `trx_bonus_user_kode` varchar(100) DEFAULT NULL,
  `trx_bonus_nama` varchar(200) DEFAULT NULL,
  `trx_bonus_admin` double DEFAULT NULL,
  `trx_bonus_harga` double DEFAULT NULL,
  `trx_bonus_poin` int(11) DEFAULT NULL,
  `trx_bonus_keterangan` varchar(250) DEFAULT NULL,
  `trx_bonus_notasi` varchar(250) DEFAULT NULL,
  `trx_bonus_tanggal` datetime DEFAULT NULL,
  `trx_bonus_icon` varchar(100) DEFAULT NULL,
  `trx_bonus_rc` varchar(10) DEFAULT NULL,
  `trx_bonus_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_bpjs`
--

CREATE TABLE `tbl_trx_bpjs` (
  `trx_bpjs_id` double NOT NULL,
  `trx_bpjs_kode` varchar(100) DEFAULT NULL,
  `trx_bpjs_user_kode` varchar(100) DEFAULT NULL,
  `trx_bpjs_nomor` varchar(70) DEFAULT NULL,
  `trx_bpjs_nama` varchar(120) DEFAULT NULL,
  `trx_bpjs_admin` double DEFAULT NULL,
  `trx_bpjs_harga` double DEFAULT NULL,
  `trx_bpjs_jumlah_peserta` int(11) DEFAULT NULL,
  `trx_bpjs_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_bpjs_alamat` varchar(150) DEFAULT NULL,
  `trx_bpjs_periode` varchar(100) DEFAULT NULL,
  `trx_bpjs_sn` varchar(100) DEFAULT NULL,
  `trx_bpjs_keterangan` varchar(250) DEFAULT NULL,
  `trx_bpjs_notasi` varchar(250) DEFAULT NULL,
  `trx_bpjs_tanggal` datetime DEFAULT NULL,
  `trx_bpjs_icon` varchar(100) DEFAULT NULL,
  `trx_bpjs_rc` varchar(10) DEFAULT NULL,
  `trx_bpjs_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_brizzi`
--

CREATE TABLE `tbl_trx_brizzi` (
  `trx_brizzi_id` double NOT NULL,
  `trx_brizzi_kode` varchar(100) DEFAULT NULL,
  `trx_brizzi_user_kode` varchar(100) DEFAULT NULL,
  `trx_brizzi_nomor` varchar(100) DEFAULT NULL,
  `trx_brizzi_nama` varchar(200) DEFAULT NULL,
  `trx_brizzi_admin` double DEFAULT NULL,
  `trx_brizzi_harga` double DEFAULT NULL,
  `trx_brizzi_poin` int(11) DEFAULT NULL,
  `trx_brizzi_sn` varchar(250) DEFAULT NULL,
  `trx_brizzi_keterangan` varchar(250) DEFAULT NULL,
  `trx_brizzi_notasi` varchar(250) DEFAULT NULL,
  `trx_brizzi_tanggal` datetime DEFAULT NULL,
  `trx_brizzi_icon` varchar(100) DEFAULT NULL,
  `trx_brizzi_rc` varchar(10) DEFAULT NULL,
  `trx_brizzi_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_bukalapak`
--

CREATE TABLE `tbl_trx_bukalapak` (
  `trx_bukalapak_id` double NOT NULL,
  `trx_bukalapak_kode` varchar(100) DEFAULT NULL,
  `trx_bukalapak_user_kode` varchar(100) DEFAULT NULL,
  `trx_bukalapak_nomor` varchar(100) DEFAULT NULL,
  `trx_bukalapak_nama` varchar(200) DEFAULT NULL,
  `trx_bukalapak_admin` double DEFAULT NULL,
  `trx_bukalapak_harga` double DEFAULT NULL,
  `trx_bukalapak_poin` int(11) DEFAULT NULL,
  `trx_bukalapak_sn` varchar(250) DEFAULT NULL,
  `trx_bukalapak_keterangan` varchar(250) DEFAULT NULL,
  `trx_bukalapak_notasi` varchar(250) DEFAULT NULL,
  `trx_bukalapak_tanggal` datetime DEFAULT NULL,
  `trx_bukalapak_icon` varchar(100) DEFAULT NULL,
  `trx_bukalapak_rc` varchar(10) DEFAULT NULL,
  `trx_bukalapak_status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_dana`
--

CREATE TABLE `tbl_trx_dana` (
  `trx_dana_id` double NOT NULL,
  `trx_dana_kode` varchar(100) DEFAULT NULL,
  `trx_dana_user_kode` varchar(100) DEFAULT NULL,
  `trx_dana_nomor` varchar(100) DEFAULT NULL,
  `trx_dana_nama` varchar(200) DEFAULT NULL,
  `trx_dana_admin` double DEFAULT NULL,
  `trx_dana_harga` double DEFAULT NULL,
  `trx_dana_poin` int(11) DEFAULT NULL,
  `trx_dana_sn` varchar(250) DEFAULT NULL,
  `trx_dana_keterangan` varchar(250) DEFAULT NULL,
  `trx_dana_notasi` varchar(250) DEFAULT NULL,
  `trx_dana_tanggal` datetime DEFAULT NULL,
  `trx_dana_icon` varchar(100) DEFAULT NULL,
  `trx_dana_rc` varchar(10) DEFAULT NULL,
  `trx_dana_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_deposit`
--

CREATE TABLE `tbl_trx_deposit` (
  `trx_deposit_id` double NOT NULL,
  `trx_deposit_kode` varchar(100) DEFAULT NULL,
  `trx_deposit_user_kode` varchar(100) DEFAULT NULL,
  `trx_deposit_tripay_reference` varchar(100) DEFAULT NULL,
  `trx_deposit_metode` varchar(50) DEFAULT NULL,
  `trx_deposit_tanggal` datetime DEFAULT NULL,
  `trx_deposit_jumlah` double DEFAULT NULL,
  `trx_deposit_admin` double DEFAULT NULL,
  `trx_deposit_channel` varchar(100) DEFAULT NULL,
  `trx_deposit_va` varchar(20) DEFAULT NULL,
  `trx_deposit_link` varchar(200) DEFAULT NULL,
  `trx_deposit_keterangan` varchar(250) DEFAULT NULL,
  `trx_deposit_notasi` varchar(250) DEFAULT NULL,
  `trx_deposit_icon` varchar(50) DEFAULT NULL,
  `trx_deposit_rc` enum('0','1','2','3') DEFAULT NULL,
  `trx_deposit_status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_trx_deposit`
--

INSERT INTO `tbl_trx_deposit` (`trx_deposit_id`, `trx_deposit_kode`, `trx_deposit_user_kode`, `trx_deposit_tripay_reference`, `trx_deposit_metode`, `trx_deposit_tanggal`, `trx_deposit_jumlah`, `trx_deposit_admin`, `trx_deposit_channel`, `trx_deposit_va`, `trx_deposit_link`, `trx_deposit_keterangan`, `trx_deposit_notasi`, `trx_deposit_icon`, `trx_deposit_rc`, `trx_deposit_status`) VALUES
(1, 'DEPOSIT-CECDA687FC-108-041023', 'USER-43C4D7D237-958-101035', 'DEPOSIT-CECDA687FC-108-041023', 'Manual', '2024-10-03 04:08:23', 100000, 500, 'Manual', 'Manual', 'Manual', 'Pengisian saldo manual', 'Penambahan saldo manual yang dilakukan oleh admin, jika terdapat kesalahan mohon menghubungi customer service!', 'icon_deposit.png', '1', 'Sukses');

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

--
-- Table structure for table `tbl_trx_doku`
--

CREATE TABLE `tbl_trx_doku` (
  `trx_doku_id` double NOT NULL,
  `trx_doku_kode` varchar(100) DEFAULT NULL,
  `trx_doku_user_kode` varchar(100) DEFAULT NULL,
  `trx_doku_nomor` varchar(100) DEFAULT NULL,
  `trx_doku_nama` varchar(200) DEFAULT NULL,
  `trx_doku_admin` double DEFAULT NULL,
  `trx_doku_harga` double DEFAULT NULL,
  `trx_doku_poin` int(11) DEFAULT NULL,
  `trx_doku_sn` varchar(250) DEFAULT NULL,
  `trx_doku_keterangan` varchar(250) DEFAULT NULL,
  `trx_doku_notasi` varchar(250) DEFAULT NULL,
  `trx_doku_tanggal` datetime DEFAULT NULL,
  `trx_doku_icon` varchar(100) DEFAULT NULL,
  `trx_doku_rc` varchar(10) DEFAULT NULL,
  `trx_doku_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_emoney`
--

CREATE TABLE `tbl_trx_emoney` (
  `trx_emoney_id` double NOT NULL,
  `trx_emoney_kode` varchar(100) DEFAULT NULL,
  `trx_emoney_user_kode` varchar(100) DEFAULT NULL,
  `trx_emoney_nomor` varchar(100) DEFAULT NULL,
  `trx_emoney_nama` varchar(200) DEFAULT NULL,
  `trx_emoney_admin` double DEFAULT NULL,
  `trx_emoney_harga` double DEFAULT NULL,
  `trx_emoney_poin` int(11) DEFAULT NULL,
  `trx_emoney_sn` varchar(250) DEFAULT NULL,
  `trx_emoney_keterangan` varchar(250) DEFAULT NULL,
  `trx_emoney_notasi` varchar(250) DEFAULT NULL,
  `trx_emoney_tanggal` datetime DEFAULT NULL,
  `trx_emoney_icon` varchar(100) DEFAULT NULL,
  `trx_emoney_rc` varchar(10) DEFAULT NULL,
  `trx_emoney_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_game`
--

CREATE TABLE `tbl_trx_game` (
  `trx_game_id` double NOT NULL,
  `trx_game_kode` varchar(100) DEFAULT NULL,
  `trx_game_user_kode` varchar(100) DEFAULT NULL,
  `trx_game_kategori` varchar(100) DEFAULT NULL,
  `trx_game_nomor` varchar(100) DEFAULT NULL,
  `trx_game_nama` varchar(200) DEFAULT NULL,
  `trx_game_admin` double DEFAULT NULL,
  `trx_game_harga` double DEFAULT NULL,
  `trx_game_poin` int(11) DEFAULT NULL,
  `trx_game_sn` varchar(250) DEFAULT NULL,
  `trx_game_keterangan` varchar(250) DEFAULT NULL,
  `trx_game_notasi` varchar(250) DEFAULT NULL,
  `trx_game_tanggal` datetime DEFAULT NULL,
  `trx_game_icon` varchar(100) DEFAULT NULL,
  `trx_game_rc` varchar(10) DEFAULT NULL,
  `trx_game_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_gas`
--

CREATE TABLE `tbl_trx_gas` (
  `trx_gas_id` double NOT NULL,
  `trx_gas_kode` varchar(100) DEFAULT NULL,
  `trx_gas_user_kode` varchar(100) DEFAULT NULL,
  `trx_gas_nomor` varchar(100) DEFAULT NULL,
  `trx_gas_nama` varchar(120) DEFAULT NULL,
  `trx_gas_admin` double DEFAULT NULL,
  `trx_gas_harga` double DEFAULT NULL,
  `trx_gas_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_gas_periode` varchar(50) DEFAULT NULL,
  `trx_gas_meter_awal` varchar(100) DEFAULT NULL,
  `trx_gas_meter_akhir` varchar(100) DEFAULT NULL,
  `trx_gas_sn` varchar(100) DEFAULT NULL,
  `trx_gas_keterangan` varchar(250) DEFAULT NULL,
  `trx_gas_notasi` varchar(250) DEFAULT NULL,
  `trx_gas_tanggal` datetime DEFAULT NULL,
  `trx_gas_icon` varchar(70) DEFAULT NULL,
  `trx_gas_rc` varchar(10) DEFAULT NULL,
  `trx_gas_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_gojek_driver`
--

CREATE TABLE `tbl_trx_gojek_driver` (
  `trx_gojek_driver_id` double NOT NULL,
  `trx_gojek_driver_kode` varchar(100) DEFAULT NULL,
  `trx_gojek_driver_user_kode` varchar(100) DEFAULT NULL,
  `trx_gojek_driver_nomor` varchar(100) DEFAULT NULL,
  `trx_gojek_driver_nama` varchar(200) DEFAULT NULL,
  `trx_gojek_driver_admin` double DEFAULT NULL,
  `trx_gojek_driver_harga` double DEFAULT NULL,
  `trx_gojek_driver_poin` int(11) DEFAULT NULL,
  `trx_gojek_driver_sn` varchar(250) DEFAULT NULL,
  `trx_gojek_driver_keterangan` varchar(250) DEFAULT NULL,
  `trx_gojek_driver_notasi` varchar(250) DEFAULT NULL,
  `trx_gojek_driver_tanggal` datetime DEFAULT NULL,
  `trx_gojek_driver_icon` varchar(100) DEFAULT NULL,
  `trx_gojek_driver_rc` varchar(10) DEFAULT NULL,
  `trx_gojek_driver_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_googleplay`
--

CREATE TABLE `tbl_trx_googleplay` (
  `trx_googleplay_id` double NOT NULL,
  `trx_googleplay_kode` varchar(100) DEFAULT NULL,
  `trx_googleplay_user_kode` varchar(100) DEFAULT NULL,
  `trx_googleplay_nomor` varchar(100) DEFAULT NULL,
  `trx_googleplay_nama` varchar(200) DEFAULT NULL,
  `trx_googleplay_admin` double DEFAULT NULL,
  `trx_googleplay_harga` double DEFAULT NULL,
  `trx_googleplay_poin` int(11) DEFAULT NULL,
  `trx_googleplay_sn` varchar(250) DEFAULT NULL,
  `trx_googleplay_keterangan` varchar(250) DEFAULT NULL,
  `trx_googleplay_notasi` varchar(250) DEFAULT NULL,
  `trx_googleplay_tanggal` datetime DEFAULT NULL,
  `trx_googleplay_icon` varchar(100) DEFAULT NULL,
  `trx_googleplay_rc` varchar(10) DEFAULT NULL,
  `trx_googleplay_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_gopay`
--

CREATE TABLE `tbl_trx_gopay` (
  `trx_gopay_id` double NOT NULL,
  `trx_gopay_kode` varchar(100) DEFAULT NULL,
  `trx_gopay_user_kode` varchar(100) DEFAULT NULL,
  `trx_gopay_nomor` varchar(100) DEFAULT NULL,
  `trx_gopay_nama` varchar(200) DEFAULT NULL,
  `trx_gopay_admin` double DEFAULT NULL,
  `trx_gopay_harga` double DEFAULT NULL,
  `trx_gopay_poin` int(11) DEFAULT NULL,
  `trx_gopay_sn` varchar(250) DEFAULT NULL,
  `trx_gopay_keterangan` varchar(250) DEFAULT NULL,
  `trx_gopay_notasi` varchar(250) DEFAULT NULL,
  `trx_gopay_tanggal` datetime DEFAULT NULL,
  `trx_gopay_icon` varchar(100) DEFAULT NULL,
  `trx_gopay_rc` varchar(10) DEFAULT NULL,
  `trx_gopay_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_grab`
--

CREATE TABLE `tbl_trx_grab` (
  `trx_grab_id` double NOT NULL,
  `trx_grab_kode` varchar(100) DEFAULT NULL,
  `trx_grab_user_kode` varchar(100) DEFAULT NULL,
  `trx_grab_nomor` varchar(100) DEFAULT NULL,
  `trx_grab_nama` varchar(200) DEFAULT NULL,
  `trx_grab_admin` double DEFAULT NULL,
  `trx_grab_harga` double DEFAULT NULL,
  `trx_grab_poin` int(11) DEFAULT NULL,
  `trx_grab_sn` varchar(250) DEFAULT NULL,
  `trx_grab_keterangan` varchar(250) DEFAULT NULL,
  `trx_grab_notasi` varchar(250) DEFAULT NULL,
  `trx_grab_tanggal` datetime DEFAULT NULL,
  `trx_grab_icon` varchar(100) DEFAULT NULL,
  `trx_grab_rc` varchar(10) DEFAULT NULL,
  `trx_grab_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_grab_driver`
--

CREATE TABLE `tbl_trx_grab_driver` (
  `trx_grab_driver_id` double NOT NULL,
  `trx_grab_driver_kode` varchar(100) DEFAULT NULL,
  `trx_grab_driver_user_kode` varchar(100) DEFAULT NULL,
  `trx_grab_driver_nomor` varchar(100) DEFAULT NULL,
  `trx_grab_driver_nama` varchar(200) DEFAULT NULL,
  `trx_grab_driver_admin` double DEFAULT NULL,
  `trx_grab_driver_harga` double DEFAULT NULL,
  `trx_grab_driver_poin` int(11) DEFAULT NULL,
  `trx_grab_driver_sn` varchar(250) DEFAULT NULL,
  `trx_grab_driver_keterangan` varchar(250) DEFAULT NULL,
  `trx_grab_driver_notasi` varchar(250) DEFAULT NULL,
  `trx_grab_driver_tanggal` datetime DEFAULT NULL,
  `trx_grab_driver_icon` varchar(100) DEFAULT NULL,
  `trx_grab_driver_rc` varchar(10) DEFAULT NULL,
  `trx_grab_driver_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_hadiah`
--

CREATE TABLE `tbl_trx_hadiah` (
  `trx_hadiah_id` int(11) NOT NULL,
  `trx_hadiah_kode` varchar(100) DEFAULT NULL,
  `trx_hadiah_user_kode` varchar(100) DEFAULT NULL,
  `trx_hadiah_nama` varchar(150) DEFAULT NULL,
  `trx_hadiah_harga` double DEFAULT NULL,
  `trx_hadiah_jenis` varchar(100) DEFAULT NULL,
  `trx_hadiah_tanggal` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_hp`
--

CREATE TABLE `tbl_trx_hp` (
  `trx_hp_id` double NOT NULL,
  `trx_hp_kode` varchar(100) DEFAULT NULL,
  `trx_hp_user_kode` varchar(100) DEFAULT NULL,
  `trx_hp_kategori_kode` varchar(100) DEFAULT NULL,
  `trx_hp_kategori_nama` varchar(90) DEFAULT NULL,
  `trx_hp_nomor` varchar(70) DEFAULT NULL,
  `trx_hp_nama` varchar(120) DEFAULT NULL,
  `trx_hp_admin` double DEFAULT NULL,
  `trx_hp_harga` double DEFAULT NULL,
  `trx_hp_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_hp_sn` varchar(100) DEFAULT NULL,
  `trx_hp_keterangan` varchar(250) DEFAULT NULL,
  `trx_hp_notasi` varchar(250) DEFAULT NULL,
  `trx_hp_tanggal` datetime DEFAULT NULL,
  `trx_hp_icon` varchar(100) DEFAULT NULL,
  `trx_hp_rc` varchar(10) DEFAULT NULL,
  `trx_hp_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_indomaret`
--

CREATE TABLE `tbl_trx_indomaret` (
  `trx_indomaret_id` double NOT NULL,
  `trx_indomaret_kode` varchar(100) DEFAULT NULL,
  `trx_indomaret_user_kode` varchar(100) DEFAULT NULL,
  `trx_indomaret_nomor` varchar(100) DEFAULT NULL,
  `trx_indomaret_nama` varchar(200) DEFAULT NULL,
  `trx_indomaret_admin` double DEFAULT NULL,
  `trx_indomaret_harga` double DEFAULT NULL,
  `trx_indomaret_poin` int(11) DEFAULT NULL,
  `trx_indomaret_sn` varchar(250) DEFAULT NULL,
  `trx_indomaret_keterangan` varchar(250) DEFAULT NULL,
  `trx_indomaret_notasi` varchar(250) DEFAULT NULL,
  `trx_indomaret_tanggal` datetime DEFAULT NULL,
  `trx_indomaret_icon` varchar(100) DEFAULT NULL,
  `trx_indomaret_rc` varchar(10) DEFAULT NULL,
  `trx_indomaret_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_internet`
--

CREATE TABLE `tbl_trx_internet` (
  `trx_internet_id` double NOT NULL,
  `trx_internet_kode` varchar(100) DEFAULT NULL,
  `trx_internet_user_kode` varchar(100) DEFAULT NULL,
  `trx_internet_kategori_kode` varchar(100) DEFAULT NULL,
  `trx_internet_kategori_nama` varchar(100) DEFAULT NULL,
  `trx_internet_nomor` varchar(70) DEFAULT NULL,
  `trx_internet_nama` varchar(120) DEFAULT NULL,
  `trx_internet_admin` double DEFAULT NULL,
  `trx_internet_harga` double DEFAULT NULL,
  `trx_internet_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_internet_periode` varchar(100) DEFAULT NULL,
  `trx_internet_sn` varchar(100) DEFAULT NULL,
  `trx_internet_keterangan` varchar(250) DEFAULT NULL,
  `trx_internet_notasi` varchar(250) DEFAULT NULL,
  `trx_internet_tanggal` datetime DEFAULT NULL,
  `trx_internet_icon` varchar(70) DEFAULT NULL,
  `trx_internet_rc` varchar(10) DEFAULT NULL,
  `trx_internet_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_isaku`
--

CREATE TABLE `tbl_trx_isaku` (
  `trx_isaku_id` double NOT NULL,
  `trx_isaku_kode` varchar(100) DEFAULT NULL,
  `trx_isaku_user_kode` varchar(100) DEFAULT NULL,
  `trx_isaku_nomor` varchar(100) DEFAULT NULL,
  `trx_isaku_nama` varchar(200) DEFAULT NULL,
  `trx_isaku_admin` double DEFAULT NULL,
  `trx_isaku_harga` double DEFAULT NULL,
  `trx_isaku_poin` int(11) DEFAULT NULL,
  `trx_isaku_sn` varchar(250) DEFAULT NULL,
  `trx_isaku_keterangan` varchar(250) DEFAULT NULL,
  `trx_isaku_notasi` varchar(250) DEFAULT NULL,
  `trx_isaku_tanggal` datetime DEFAULT NULL,
  `trx_isaku_icon` varchar(100) DEFAULT NULL,
  `trx_isaku_rc` varchar(10) DEFAULT NULL,
  `trx_isaku_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_linkaja`
--

CREATE TABLE `tbl_trx_linkaja` (
  `trx_linkaja_id` double NOT NULL,
  `trx_linkaja_kode` varchar(100) DEFAULT NULL,
  `trx_linkaja_user_kode` varchar(100) DEFAULT NULL,
  `trx_linkaja_nomor` varchar(100) DEFAULT NULL,
  `trx_linkaja_nama` varchar(200) DEFAULT NULL,
  `trx_linkaja_admin` double DEFAULT NULL,
  `trx_linkaja_harga` double DEFAULT NULL,
  `trx_linkaja_poin` int(11) DEFAULT NULL,
  `trx_linkaja_sn` varchar(250) DEFAULT NULL,
  `trx_linkaja_keterangan` varchar(250) DEFAULT NULL,
  `trx_linkaja_notasi` varchar(250) DEFAULT NULL,
  `trx_linkaja_tanggal` datetime DEFAULT NULL,
  `trx_linkaja_icon` varchar(100) DEFAULT NULL,
  `trx_linkaja_rc` varchar(10) DEFAULT NULL,
  `trx_linkaja_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_masa_aktif`
--

CREATE TABLE `tbl_trx_masa_aktif` (
  `trx_masa_aktif_id` double NOT NULL,
  `trx_masa_aktif_kode` varchar(100) DEFAULT NULL,
  `trx_masa_aktif_user_kode` varchar(100) DEFAULT NULL,
  `trx_masa_aktif_operator` varchar(100) DEFAULT NULL,
  `trx_masa_aktif_nomor` varchar(100) DEFAULT NULL,
  `trx_masa_aktif_nama` varchar(200) DEFAULT NULL,
  `trx_masa_aktif_admin` double DEFAULT NULL,
  `trx_masa_aktif_harga` double DEFAULT NULL,
  `trx_masa_aktif_poin` int(11) DEFAULT NULL,
  `trx_masa_aktif_sn` varchar(250) DEFAULT NULL,
  `trx_masa_aktif_keterangan` varchar(250) DEFAULT NULL,
  `trx_masa_aktif_notasi` varchar(250) DEFAULT NULL,
  `trx_masa_aktif_tanggal` datetime DEFAULT NULL,
  `trx_masa_aktif_icon` varchar(100) DEFAULT NULL,
  `trx_masa_aktif_rc` varchar(10) DEFAULT NULL,
  `trx_masa_aktif_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_materai`
--

CREATE TABLE `tbl_trx_materai` (
  `trx_materai_id` double NOT NULL,
  `trx_materai_kode` varchar(100) DEFAULT NULL,
  `trx_materai_user_kode` varchar(100) DEFAULT NULL,
  `trx_materai_nomor` varchar(100) DEFAULT NULL,
  `trx_materai_nama` varchar(200) DEFAULT NULL,
  `trx_materai_admin` double DEFAULT NULL,
  `trx_materai_harga` double DEFAULT NULL,
  `trx_materai_poin` int(11) DEFAULT NULL,
  `trx_materai_sn` varchar(250) DEFAULT NULL,
  `trx_materai_keterangan` varchar(250) DEFAULT NULL,
  `trx_materai_notasi` varchar(250) DEFAULT NULL,
  `trx_materai_tanggal` datetime DEFAULT NULL,
  `trx_materai_icon` varchar(100) DEFAULT NULL,
  `trx_materai_rc` varchar(10) DEFAULT NULL,
  `trx_materai_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_maxim`
--

CREATE TABLE `tbl_trx_maxim` (
  `trx_maxim_id` double NOT NULL,
  `trx_maxim_kode` varchar(100) DEFAULT NULL,
  `trx_maxim_user_kode` varchar(100) DEFAULT NULL,
  `trx_maxim_nomor` varchar(100) DEFAULT NULL,
  `trx_maxim_nama` varchar(200) DEFAULT NULL,
  `trx_maxim_admin` double DEFAULT NULL,
  `trx_maxim_harga` double DEFAULT NULL,
  `trx_maxim_poin` int(11) DEFAULT NULL,
  `trx_maxim_sn` varchar(250) DEFAULT NULL,
  `trx_maxim_keterangan` varchar(250) DEFAULT NULL,
  `trx_maxim_notasi` varchar(250) DEFAULT NULL,
  `trx_maxim_tanggal` datetime DEFAULT NULL,
  `trx_maxim_icon` varchar(100) DEFAULT NULL,
  `trx_maxim_rc` varchar(10) DEFAULT NULL,
  `trx_maxim_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_maxim_driver`
--

CREATE TABLE `tbl_trx_maxim_driver` (
  `trx_maxim_driver_id` double NOT NULL,
  `trx_maxim_driver_kode` varchar(100) DEFAULT NULL,
  `trx_maxim_driver_user_kode` varchar(100) DEFAULT NULL,
  `trx_maxim_driver_nomor` varchar(100) DEFAULT NULL,
  `trx_maxim_driver_nama` varchar(200) DEFAULT NULL,
  `trx_maxim_driver_admin` double DEFAULT NULL,
  `trx_maxim_driver_harga` double DEFAULT NULL,
  `trx_maxim_driver_poin` int(11) DEFAULT NULL,
  `trx_maxim_driver_sn` varchar(250) DEFAULT NULL,
  `trx_maxim_driver_keterangan` varchar(250) DEFAULT NULL,
  `trx_maxim_driver_notasi` varchar(250) DEFAULT NULL,
  `trx_maxim_driver_tanggal` datetime DEFAULT NULL,
  `trx_maxim_driver_icon` varchar(100) DEFAULT NULL,
  `trx_maxim_driver_rc` varchar(10) DEFAULT NULL,
  `trx_maxim_driver_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_mtix`
--

CREATE TABLE `tbl_trx_mtix` (
  `trx_mtix_id` double NOT NULL,
  `trx_mtix_kode` varchar(100) DEFAULT NULL,
  `trx_mtix_user_kode` varchar(100) DEFAULT NULL,
  `trx_mtix_nomor` varchar(100) DEFAULT NULL,
  `trx_mtix_nama` varchar(200) DEFAULT NULL,
  `trx_mtix_admin` double DEFAULT NULL,
  `trx_mtix_harga` double DEFAULT NULL,
  `trx_mtix_poin` int(11) DEFAULT NULL,
  `trx_mtix_sn` varchar(250) DEFAULT NULL,
  `trx_mtix_keterangan` varchar(250) DEFAULT NULL,
  `trx_mtix_notasi` varchar(250) DEFAULT NULL,
  `trx_mtix_tanggal` datetime DEFAULT NULL,
  `trx_mtix_icon` varchar(100) DEFAULT NULL,
  `trx_mtix_rc` varchar(10) DEFAULT NULL,
  `trx_mtix_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_multifinance`
--

CREATE TABLE `tbl_trx_multifinance` (
  `trx_multifinance_id` double NOT NULL,
  `trx_multifinance_kode` varchar(100) DEFAULT NULL,
  `trx_multifinance_user_kode` varchar(100) DEFAULT NULL,
  `trx_multifinance_kategori_kode` varchar(100) DEFAULT NULL,
  `trx_multifinance_kategori_nama` varchar(100) DEFAULT NULL,
  `trx_multifinance_nomor` varchar(70) DEFAULT NULL,
  `trx_multifinance_nama` varchar(120) DEFAULT NULL,
  `trx_multifinance_admin` double DEFAULT NULL,
  `trx_multifinance_harga` double DEFAULT NULL,
  `trx_multifinance_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_multifinance_periode` varchar(100) DEFAULT NULL,
  `trx_multifinance_sn` varchar(100) DEFAULT NULL,
  `trx_multifinance_keterangan` varchar(250) DEFAULT NULL,
  `trx_multifinance_notasi` varchar(250) DEFAULT NULL,
  `trx_multifinance_tanggal` datetime DEFAULT NULL,
  `trx_multifinance_icon` varchar(100) DEFAULT NULL,
  `trx_multifinance_rc` varchar(10) DEFAULT NULL,
  `trx_multifinance_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_ovo`
--

CREATE TABLE `tbl_trx_ovo` (
  `trx_ovo_id` double NOT NULL,
  `trx_ovo_kode` varchar(100) DEFAULT NULL,
  `trx_ovo_user_kode` varchar(100) DEFAULT NULL,
  `trx_ovo_nomor` varchar(100) DEFAULT NULL,
  `trx_ovo_nama` varchar(200) DEFAULT NULL,
  `trx_ovo_admin` double DEFAULT NULL,
  `trx_ovo_harga` double DEFAULT NULL,
  `trx_ovo_poin` int(11) DEFAULT NULL,
  `trx_ovo_sn` varchar(250) DEFAULT NULL,
  `trx_ovo_keterangan` varchar(250) DEFAULT NULL,
  `trx_ovo_notasi` varchar(250) DEFAULT NULL,
  `trx_ovo_tanggal` datetime DEFAULT NULL,
  `trx_ovo_icon` varchar(100) DEFAULT NULL,
  `trx_ovo_rc` varchar(10) DEFAULT NULL,
  `trx_ovo_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_paket_data`
--

CREATE TABLE `tbl_trx_paket_data` (
  `trx_paket_data_id` double NOT NULL,
  `trx_paket_data_kode` varchar(100) DEFAULT NULL,
  `trx_paket_data_user_kode` varchar(100) DEFAULT NULL,
  `trx_paket_data_operator` varchar(100) DEFAULT NULL,
  `trx_paket_data_nomor` varchar(100) DEFAULT NULL,
  `trx_paket_data_nama` varchar(200) DEFAULT NULL,
  `trx_paket_data_admin` double DEFAULT NULL,
  `trx_paket_data_harga` double DEFAULT NULL,
  `trx_paket_data_poin` int(11) DEFAULT NULL,
  `trx_paket_data_sn` varchar(250) DEFAULT NULL,
  `trx_paket_data_keterangan` varchar(250) DEFAULT NULL,
  `trx_paket_data_notasi` varchar(250) DEFAULT NULL,
  `trx_paket_data_tanggal` datetime DEFAULT NULL,
  `trx_paket_data_icon` varchar(100) DEFAULT NULL,
  `trx_paket_data_rc` varchar(10) DEFAULT NULL,
  `trx_paket_data_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_paket_nelfon`
--

CREATE TABLE `tbl_trx_paket_nelfon` (
  `trx_paket_nelfon_id` double NOT NULL,
  `trx_paket_nelfon_kode` varchar(100) DEFAULT NULL,
  `trx_paket_nelfon_user_kode` varchar(100) DEFAULT NULL,
  `trx_paket_nelfon_operator` varchar(100) DEFAULT NULL,
  `trx_paket_nelfon_nomor` varchar(100) DEFAULT NULL,
  `trx_paket_nelfon_nama` varchar(200) DEFAULT NULL,
  `trx_paket_nelfon_admin` double DEFAULT NULL,
  `trx_paket_nelfon_harga` double DEFAULT NULL,
  `trx_paket_nelfon_poin` int(11) DEFAULT NULL,
  `trx_paket_nelfon_sn` varchar(250) DEFAULT NULL,
  `trx_paket_nelfon_keterangan` varchar(250) DEFAULT NULL,
  `trx_paket_nelfon_notasi` varchar(250) DEFAULT NULL,
  `trx_paket_nelfon_tanggal` datetime DEFAULT NULL,
  `trx_paket_nelfon_icon` varchar(100) DEFAULT NULL,
  `trx_paket_nelfon_rc` varchar(10) DEFAULT NULL,
  `trx_paket_nelfon_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_paket_sms`
--

CREATE TABLE `tbl_trx_paket_sms` (
  `trx_paket_sms_id` double NOT NULL,
  `trx_paket_sms_kode` varchar(100) DEFAULT NULL,
  `trx_paket_sms_user_kode` varchar(100) DEFAULT NULL,
  `trx_paket_sms_operator` varchar(100) DEFAULT NULL,
  `trx_paket_sms_nomor` varchar(100) DEFAULT NULL,
  `trx_paket_sms_nama` varchar(200) DEFAULT NULL,
  `trx_paket_sms_admin` double DEFAULT NULL,
  `trx_paket_sms_harga` double DEFAULT NULL,
  `trx_paket_sms_poin` int(11) DEFAULT NULL,
  `trx_paket_sms_sn` varchar(250) DEFAULT NULL,
  `trx_paket_sms_keterangan` varchar(250) DEFAULT NULL,
  `trx_paket_sms_notasi` varchar(250) DEFAULT NULL,
  `trx_paket_sms_tanggal` datetime DEFAULT NULL,
  `trx_paket_sms_icon` varchar(100) DEFAULT NULL,
  `trx_paket_sms_rc` varchar(10) DEFAULT NULL,
  `trx_paket_sms_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_pbb`
--

CREATE TABLE `tbl_trx_pbb` (
  `trx_pbb_id` double NOT NULL,
  `trx_pbb_kode` varchar(100) DEFAULT NULL,
  `trx_pbb_user_kode` varchar(100) DEFAULT NULL,
  `trx_pbb_kategori_kode` varchar(100) DEFAULT NULL,
  `trx_pbb_kategori_nama` varchar(100) DEFAULT NULL,
  `trx_pbb_nomor` varchar(70) DEFAULT NULL,
  `trx_pbb_nama` varchar(120) DEFAULT NULL,
  `trx_pbb_alamat` varchar(150) DEFAULT NULL,
  `trx_pbb_kelurahan` varchar(100) DEFAULT NULL,
  `trx_pbb_kecamatan` varchar(100) DEFAULT NULL,
  `trx_pbb_kota` varchar(100) DEFAULT NULL,
  `trx_pbb_luas_tanah` varchar(50) DEFAULT NULL,
  `trx_pbb_luas_bangunan` varchar(50) DEFAULT NULL,
  `trx_pbb_admin` double DEFAULT NULL,
  `trx_pbb_harga` double DEFAULT NULL,
  `trx_pbb_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_pbb_tahun` varchar(100) DEFAULT NULL,
  `trx_pbb_sn` varchar(100) DEFAULT NULL,
  `trx_pbb_keterangan` varchar(250) DEFAULT NULL,
  `trx_pbb_notasi` varchar(250) DEFAULT NULL,
  `trx_pbb_tanggal` datetime DEFAULT NULL,
  `trx_pbb_icon` varchar(100) DEFAULT NULL,
  `trx_pbb_rc` varchar(10) DEFAULT NULL,
  `trx_pbb_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_pdam`
--

CREATE TABLE `tbl_trx_pdam` (
  `trx_pdam_id` double NOT NULL,
  `trx_pdam_kode` varchar(100) DEFAULT NULL,
  `trx_pdam_user_kode` varchar(100) DEFAULT NULL,
  `trx_pdam_kategori_kode` varchar(100) DEFAULT NULL,
  `trx_pdam_kategori_nama` varchar(100) DEFAULT NULL,
  `trx_pdam_nomor` varchar(100) DEFAULT NULL,
  `trx_pdam_nama` varchar(120) DEFAULT NULL,
  `trx_pdam_segmen` varchar(50) DEFAULT NULL,
  `trx_pdam_admin` double DEFAULT NULL,
  `trx_pdam_harga` double DEFAULT NULL,
  `trx_pdam_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_pdam_periode` varchar(100) DEFAULT NULL,
  `trx_pdam_meter_awal` varchar(50) DEFAULT NULL,
  `trx_pdam_meter_akhir` varchar(50) DEFAULT NULL,
  `trx_pdam_sn` varchar(100) DEFAULT NULL,
  `trx_pdam_keterangan` varchar(250) DEFAULT NULL,
  `trx_pdam_notasi` varchar(250) DEFAULT NULL,
  `trx_pdam_tanggal` datetime DEFAULT NULL,
  `trx_pdam_icon` varchar(100) DEFAULT NULL,
  `trx_pdam_rc` varchar(10) DEFAULT NULL,
  `trx_pdam_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_pendapatan`
--

CREATE TABLE `tbl_trx_pendapatan` (
  `trx_pendapatan_id` double NOT NULL,
  `trx_pendapatan_kode` varchar(100) DEFAULT NULL,
  `trx_pendapatan_user_kode` varchar(100) DEFAULT NULL,
  `trx_pendapatan_kategori` enum('Hadiah','Deposit','Transfer','Bonus','Pulsa','Paket Data','Paket Nelfon','Paket SMS','Token PLN','Masa Aktif','Pulsa Transfer','Game','BPJS','HP','TV','PLN','Internet','Multifinance','PDAM','PBB','GAS','Gopay','OVO','LinkAja','Maxim','Dana','ShopeePay','Doku','Grab','Sakuku','Isaku','Gojek Driver','Maxim Driver','Grab Driver','Shopee Driver','Indomaret','Alfamart','Tokopedia','Materai','Traveloka','Mtix','Tixid','Spotify','Googleplay','Vidio','Unipin','Wifiid','Bukalapak','Emoney','Tapcash','Brizzi') DEFAULT NULL,
  `trx_pendapatan_jumlah` double DEFAULT NULL,
  `trx_pendapatan_tanggal` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_trx_pendapatan`
--

INSERT INTO `tbl_trx_pendapatan` (`trx_pendapatan_id`, `trx_pendapatan_kode`, `trx_pendapatan_user_kode`, `trx_pendapatan_kategori`, `trx_pendapatan_jumlah`, `trx_pendapatan_tanggal`) VALUES
(1, 'DEPOSIT-CECDA687FC-108-041023', 'USER-43C4D7D237-958-101035', 'Deposit', 500, '2024-10-03 04:08:23'),
(2, 'PULSA-6622A3D4CC-23-051031', 'USER-43C4D7D237-958-101035', 'Pulsa', 100, '2024-10-04 05:59:31');

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

--
-- Table structure for table `tbl_trx_pln`
--

CREATE TABLE `tbl_trx_pln` (
  `trx_pln_id` double NOT NULL,
  `trx_pln_kode` varchar(100) DEFAULT NULL,
  `trx_pln_user_kode` varchar(100) DEFAULT NULL,
  `trx_pln_nomor` varchar(100) DEFAULT NULL,
  `trx_pln_nama` varchar(120) DEFAULT NULL,
  `trx_pln_segment` varchar(100) DEFAULT NULL,
  `trx_pln_daya` varchar(100) DEFAULT NULL,
  `trx_pln_admin` double DEFAULT NULL,
  `trx_pln_harga` double DEFAULT NULL,
  `trx_pln_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_pln_periode` varchar(100) DEFAULT NULL,
  `trx_pln_meter_awal` varchar(100) DEFAULT NULL,
  `trx_pln_meter_akhir` varchar(100) DEFAULT NULL,
  `trx_pln_sn` varchar(100) DEFAULT NULL,
  `trx_pln_keterangan` varchar(250) DEFAULT NULL,
  `trx_pln_notasi` varchar(250) DEFAULT NULL,
  `trx_pln_tanggal` datetime DEFAULT NULL,
  `trx_pln_icon` varchar(100) DEFAULT NULL,
  `trx_pln_rc` varchar(10) DEFAULT NULL,
  `trx_pln_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_poin`
--

CREATE TABLE `tbl_trx_poin` (
  `trx_poin_id` double NOT NULL,
  `trx_poin_kode` varchar(100) DEFAULT NULL,
  `trx_poin_user_kode` varchar(100) DEFAULT NULL,
  `trx_poin_nama` varchar(200) DEFAULT NULL,
  `trx_poin_keterangan` varchar(200) DEFAULT NULL,
  `trx_poin_jumlah` double DEFAULT NULL,
  `trx_poin_tanggal` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_trx_poin`
--

INSERT INTO `tbl_trx_poin` (`trx_poin_id`, `trx_poin_kode`, `trx_poin_user_kode`, `trx_poin_nama`, `trx_poin_keterangan`, `trx_poin_jumlah`, `trx_poin_tanggal`) VALUES
(1, 'PULSA-6622A3D4CC-23-051031', 'USER-43C4D7D237-958-101035', 'Pulsa', 'Poin dari transaksi pulsa', 1, '2024-10-04 05:59:31');

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

--
-- Table structure for table `tbl_trx_pulsa`
--

CREATE TABLE `tbl_trx_pulsa` (
  `trx_pulsa_id` double NOT NULL,
  `trx_pulsa_kode` varchar(100) DEFAULT NULL,
  `trx_pulsa_user_kode` varchar(100) DEFAULT NULL,
  `trx_pulsa_operator` varchar(100) DEFAULT NULL,
  `trx_pulsa_nomor` varchar(50) DEFAULT NULL,
  `trx_pulsa_nama` varchar(200) DEFAULT NULL,
  `trx_pulsa_admin` double DEFAULT NULL,
  `trx_pulsa_harga` double DEFAULT NULL,
  `trx_pulsa_poin` int(11) DEFAULT NULL,
  `trx_pulsa_sn` varchar(250) DEFAULT NULL,
  `trx_pulsa_keterangan` varchar(250) DEFAULT NULL,
  `trx_pulsa_notasi` varchar(250) DEFAULT NULL,
  `trx_pulsa_tanggal` datetime DEFAULT NULL,
  `trx_pulsa_icon` varchar(100) DEFAULT NULL,
  `trx_pulsa_rc` varchar(10) DEFAULT NULL,
  `trx_pulsa_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_trx_pulsa`
--

INSERT INTO `tbl_trx_pulsa` (`trx_pulsa_id`, `trx_pulsa_kode`, `trx_pulsa_user_kode`, `trx_pulsa_operator`, `trx_pulsa_nomor`, `trx_pulsa_nama`, `trx_pulsa_admin`, `trx_pulsa_harga`, `trx_pulsa_poin`, `trx_pulsa_sn`, `trx_pulsa_keterangan`, `trx_pulsa_notasi`, `trx_pulsa_tanggal`, `trx_pulsa_icon`, `trx_pulsa_rc`, `trx_pulsa_status`) VALUES
(1, 'PULSA-5EE6949EB2-22-151054', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '', ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala', '2024-10-03 15:24:54', 'icon_pulsa.png', '39', '0'),
(2, 'PULSA-40036A6B78-219-151040', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '', ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala', '2024-10-03 15:42:40', 'icon_pulsa.png', '39', '0'),
(3, 'PULSA-48E3C475A4-835-011058', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '', ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala', '2024-10-04 01:28:58', 'icon_pulsa.png', '39', '0'),
(4, 'PULSA-5FFBBF67FE-737-011009', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '', ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala', '2024-10-04 01:54:09', 'icon_pulsa.png', '39', '0'),
(5, 'PULSA-0CF9C74EE8-501-041036', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:00:36', 'icon_pulsa.png', '02', 'Gagal'),
(6, 'PULSA-8A8EC94F8F-905-041020', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:03:20', 'icon_pulsa.png', '02', 'Gagal'),
(7, 'PULSA-703FC6098C-770-041057', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:25:57', 'icon_pulsa.png', '02', 'Gagal'),
(8, 'PULSA-D3AEEC3BD0-781-041049', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:32:49', 'icon_pulsa.png', '02', 'Gagal'),
(9, 'PULSA-CCEFF26A2D-822-051058', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:06:58', 'icon_pulsa.png', '02', 'Gagal'),
(10, 'PULSA-9867FC0285-107-051024', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:28:24', 'icon_pulsa.png', '02', 'Gagal'),
(11, 'PULSA-DEA911CD4D-423-051040', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:38:40', 'icon_pulsa.png', '02', 'Gagal'),
(12, 'PULSA-F480AF6D50-726-051034', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:55:34', 'icon_pulsa.png', '02', 'Gagal'),
(13, 'PULSA-6622A3D4CC-23-051031', 'USER-43C4D7D237-958-101035', 'Tri', '089525888602', 'Tri Reguler 1.000', 100, 2000, 1, 'R241004.0559.21005C', 'Tri Reguler ', '', '2024-10-04 05:59:31', 'icon_pulsa.png', '00', 'Sukses'),
(14, 'PULSA-B65857FCA7-22-101022', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 10:26:22', 'icon_pulsa.png', '02', 'Gagal'),
(15, 'PULSA-13D576AE9C-863-101033', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085255459947', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 10:30:33', 'icon_pulsa.png', '02', 'Gagal'),
(16, 'PULSA-D4D1905F48-944-111050', 'USER-43C4D7D237-958-101035', 'Telkomsel', '08533388857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 11:44:50', 'icon_pulsa.png', '02', 'Gagal'),
(17, 'PULSA-FF71FC5BDB-901-121004', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-06 12:10:04', 'icon_pulsa.png', '02', 'Gagal'),
(18, 'PULSA-4C55A4CE9F-521-061053', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-08 06:44:53', 'icon_pulsa.png', '02', 'Gagal'),
(19, 'PULSA-7F87FEA7A7-157-201008', 'USER-43C4D7D237-958-101035', 'Telkomsel', '085333088857', 'Telkomsel Reguler 2.000', 0, 2442, 0, '-', ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-12 20:49:08', 'icon_pulsa.png', '02', 'Gagal');

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

--
-- Table structure for table `tbl_trx_pulsa_transfer`
--

CREATE TABLE `tbl_trx_pulsa_transfer` (
  `trx_pulsa_transfer_id` double NOT NULL,
  `trx_pulsa_transfer_kode` varchar(100) DEFAULT NULL,
  `trx_pulsa_transfer_user_kode` varchar(100) DEFAULT NULL,
  `trx_pulsa_transfer_operator` varchar(100) DEFAULT NULL,
  `trx_pulsa_transfer_nomor` varchar(100) DEFAULT NULL,
  `trx_pulsa_transfer_nama` varchar(200) DEFAULT NULL,
  `trx_pulsa_transfer_admin` double DEFAULT NULL,
  `trx_pulsa_transfer_harga` double DEFAULT NULL,
  `trx_pulsa_transfer_poin` int(11) DEFAULT NULL,
  `trx_pulsa_transfer_sn` varchar(250) DEFAULT NULL,
  `trx_pulsa_transfer_keterangan` varchar(250) DEFAULT NULL,
  `trx_pulsa_transfer_notasi` varchar(250) DEFAULT NULL,
  `trx_pulsa_transfer_tanggal` datetime DEFAULT NULL,
  `trx_pulsa_transfer_icon` varchar(100) DEFAULT NULL,
  `trx_pulsa_transfer_rc` varchar(10) DEFAULT NULL,
  `trx_pulsa_transfer_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_sakuku`
--

CREATE TABLE `tbl_trx_sakuku` (
  `trx_sakuku_id` double NOT NULL,
  `trx_sakuku_kode` varchar(100) DEFAULT NULL,
  `trx_sakuku_user_kode` varchar(100) DEFAULT NULL,
  `trx_sakuku_nomor` varchar(100) DEFAULT NULL,
  `trx_sakuku_nama` varchar(200) DEFAULT NULL,
  `trx_sakuku_admin` double DEFAULT NULL,
  `trx_sakuku_harga` double DEFAULT NULL,
  `trx_sakuku_poin` int(11) DEFAULT NULL,
  `trx_sakuku_sn` varchar(250) DEFAULT NULL,
  `trx_sakuku_keterangan` varchar(250) DEFAULT NULL,
  `trx_sakuku_notasi` varchar(250) DEFAULT NULL,
  `trx_sakuku_tanggal` datetime DEFAULT NULL,
  `trx_sakuku_icon` varchar(100) DEFAULT NULL,
  `trx_sakuku_rc` varchar(10) DEFAULT NULL,
  `trx_sakuku_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_shopeepay`
--

CREATE TABLE `tbl_trx_shopeepay` (
  `trx_shopeepay_id` double NOT NULL,
  `trx_shopeepay_kode` varchar(100) DEFAULT NULL,
  `trx_shopeepay_user_kode` varchar(100) DEFAULT NULL,
  `trx_shopeepay_nomor` varchar(100) DEFAULT NULL,
  `trx_shopeepay_nama` varchar(200) DEFAULT NULL,
  `trx_shopeepay_admin` double DEFAULT NULL,
  `trx_shopeepay_harga` double DEFAULT NULL,
  `trx_shopeepay_poin` int(11) DEFAULT NULL,
  `trx_shopeepay_sn` varchar(250) DEFAULT NULL,
  `trx_shopeepay_keterangan` varchar(250) DEFAULT NULL,
  `trx_shopeepay_notasi` varchar(250) DEFAULT NULL,
  `trx_shopeepay_tanggal` datetime DEFAULT NULL,
  `trx_shopeepay_icon` varchar(100) DEFAULT NULL,
  `trx_shopeepay_rc` varchar(10) DEFAULT NULL,
  `trx_shopeepay_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_shopee_driver`
--

CREATE TABLE `tbl_trx_shopee_driver` (
  `trx_shopee_driver_id` double NOT NULL,
  `trx_shopee_driver_kode` varchar(100) DEFAULT NULL,
  `trx_shopee_driver_user_kode` varchar(100) DEFAULT NULL,
  `trx_shopee_driver_nomor` varchar(100) DEFAULT NULL,
  `trx_shopee_driver_nama` varchar(200) DEFAULT NULL,
  `trx_shopee_driver_admin` double DEFAULT NULL,
  `trx_shopee_driver_harga` double DEFAULT NULL,
  `trx_shopee_driver_poin` int(11) DEFAULT NULL,
  `trx_shopee_driver_sn` varchar(250) DEFAULT NULL,
  `trx_shopee_driver_keterangan` varchar(250) DEFAULT NULL,
  `trx_shopee_driver_notasi` varchar(250) DEFAULT NULL,
  `trx_shopee_driver_tanggal` datetime DEFAULT NULL,
  `trx_shopee_driver_icon` varchar(100) DEFAULT NULL,
  `trx_shopee_driver_rc` varchar(10) DEFAULT NULL,
  `trx_shopee_driver_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_spotify`
--

CREATE TABLE `tbl_trx_spotify` (
  `trx_spotify_id` double NOT NULL,
  `trx_spotify_kode` varchar(100) DEFAULT NULL,
  `trx_spotify_user_kode` varchar(100) DEFAULT NULL,
  `trx_spotify_nomor` varchar(100) DEFAULT NULL,
  `trx_spotify_nama` varchar(200) DEFAULT NULL,
  `trx_spotify_admin` double DEFAULT NULL,
  `trx_spotify_harga` double DEFAULT NULL,
  `trx_spotify_poin` int(11) DEFAULT NULL,
  `trx_spotify_sn` varchar(250) DEFAULT NULL,
  `trx_spotify_keterangan` varchar(250) DEFAULT NULL,
  `trx_spotify_notasi` varchar(250) DEFAULT NULL,
  `trx_spotify_tanggal` datetime DEFAULT NULL,
  `trx_spotify_icon` varchar(100) DEFAULT NULL,
  `trx_spotify_rc` varchar(10) DEFAULT NULL,
  `trx_spotify_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_tapcash`
--

CREATE TABLE `tbl_trx_tapcash` (
  `trx_tapcash_id` double NOT NULL,
  `trx_tapcash_kode` varchar(100) DEFAULT NULL,
  `trx_tapcash_user_kode` varchar(100) DEFAULT NULL,
  `trx_tapcash_nomor` varchar(100) DEFAULT NULL,
  `trx_tapcash_nama` varchar(200) DEFAULT NULL,
  `trx_tapcash_admin` double DEFAULT NULL,
  `trx_tapcash_harga` double DEFAULT NULL,
  `trx_tapcash_poin` int(11) DEFAULT NULL,
  `trx_tapcash_sn` varchar(250) DEFAULT NULL,
  `trx_tapcash_keterangan` varchar(250) DEFAULT NULL,
  `trx_tapcash_notasi` varchar(250) DEFAULT NULL,
  `trx_tapcash_tanggal` datetime DEFAULT NULL,
  `trx_tapcash_icon` varchar(100) DEFAULT NULL,
  `trx_tapcash_rc` varchar(10) DEFAULT NULL,
  `trx_tapcash_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_tixid`
--

CREATE TABLE `tbl_trx_tixid` (
  `trx_tixid_id` double NOT NULL,
  `trx_tixid_kode` varchar(100) DEFAULT NULL,
  `trx_tixid_user_kode` varchar(100) DEFAULT NULL,
  `trx_tixid_nomor` varchar(100) DEFAULT NULL,
  `trx_tixid_nama` varchar(200) DEFAULT NULL,
  `trx_tixid_admin` double DEFAULT NULL,
  `trx_tixid_harga` double DEFAULT NULL,
  `trx_tixid_poin` int(11) DEFAULT NULL,
  `trx_tixid_sn` varchar(250) DEFAULT NULL,
  `trx_tixid_keterangan` varchar(250) DEFAULT NULL,
  `trx_tixid_notasi` varchar(250) DEFAULT NULL,
  `trx_tixid_tanggal` datetime DEFAULT NULL,
  `trx_tixid_icon` varchar(100) DEFAULT NULL,
  `trx_tixid_rc` varchar(10) DEFAULT NULL,
  `trx_tixid_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_token_pln`
--

CREATE TABLE `tbl_trx_token_pln` (
  `trx_token_pln_id` double NOT NULL,
  `trx_token_pln_kode` varchar(100) DEFAULT NULL,
  `trx_token_pln_user_kode` varchar(100) DEFAULT NULL,
  `trx_token_pln_pelanggan_nomor` varchar(100) DEFAULT NULL,
  `trx_token_pln_pelanggan_id` varchar(100) DEFAULT NULL,
  `trx_token_pln_pelanggan_nama` varchar(100) DEFAULT NULL,
  `trx_token_pln_pelanggan_segment` varchar(100) DEFAULT NULL,
  `trx_token_pln_pelanggan_daya` varchar(100) DEFAULT NULL,
  `trx_token_pln_nama` varchar(200) DEFAULT NULL,
  `trx_token_pln_admin` double DEFAULT NULL,
  `trx_token_pln_harga` double DEFAULT NULL,
  `trx_token_pln_poin` int(11) DEFAULT NULL,
  `trx_token_pln_sn` varchar(250) DEFAULT NULL,
  `trx_token_pln_keterangan` varchar(250) DEFAULT NULL,
  `trx_token_pln_notasi` varchar(250) DEFAULT NULL,
  `trx_token_pln_tanggal` datetime DEFAULT NULL,
  `trx_token_pln_icon` varchar(100) DEFAULT NULL,
  `trx_token_pln_rc` varchar(10) DEFAULT NULL,
  `trx_token_pln_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_tokopedia`
--

CREATE TABLE `tbl_trx_tokopedia` (
  `trx_tokopedia_id` double NOT NULL,
  `trx_tokopedia_kode` varchar(100) DEFAULT NULL,
  `trx_tokopedia_user_kode` varchar(100) DEFAULT NULL,
  `trx_tokopedia_nomor` varchar(100) DEFAULT NULL,
  `trx_tokopedia_nama` varchar(200) DEFAULT NULL,
  `trx_tokopedia_admin` double DEFAULT NULL,
  `trx_tokopedia_harga` double DEFAULT NULL,
  `trx_tokopedia_poin` int(11) DEFAULT NULL,
  `trx_tokopedia_sn` varchar(250) DEFAULT NULL,
  `trx_tokopedia_keterangan` varchar(250) DEFAULT NULL,
  `trx_tokopedia_notasi` varchar(250) DEFAULT NULL,
  `trx_tokopedia_tanggal` datetime DEFAULT NULL,
  `trx_tokopedia_icon` varchar(100) DEFAULT NULL,
  `trx_tokopedia_rc` varchar(10) DEFAULT NULL,
  `trx_tokopedia_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_transaksi`
--

CREATE TABLE `tbl_trx_transaksi` (
  `trx_transaksi_id` double NOT NULL,
  `trx_transaksi_kode` varchar(100) DEFAULT NULL,
  `trx_transaksi_user_kode` varchar(100) DEFAULT NULL,
  `trx_transaksi_kategori` enum('Hadiah','Deposit','Transfer','Infaq','Bonus','Pulsa','Paket Data','Paket Nelfon','Paket SMS','Token PLN','Masa Aktif','Pulsa Transfer','Game','BPJS','HP','TV','PLN','Internet','Multifinance','PDAM','PBB','GAS','Gopay','OVO','LinkAja','Maxim','Dana','ShopeePay','Doku','Grab','Sakuku','Isaku','Gojek Driver','Maxim Driver','Grab Driver','Shopee Driver','Indomaret','Alfamart','Tokopedia','Materai','Traveloka','Mtix','Tixid','Spotify','Googleplay','Vidio','Unipin','Wifiid','Bukalapak','Emoney','Tapcash','Brizzi') DEFAULT NULL,
  `trx_transaksi_nomor` varchar(100) DEFAULT NULL,
  `trx_transaksi_nama` varchar(200) DEFAULT NULL,
  `trx_transaksi_jumlah` double DEFAULT NULL,
  `trx_transaksi_keterangan` varchar(250) DEFAULT NULL,
  `trx_transaksi_notasi` varchar(250) DEFAULT NULL,
  `trx_transaksi_tanggal` datetime DEFAULT NULL,
  `trx_transaksi_icon` varchar(100) DEFAULT NULL,
  `trx_transaksi_rc` varchar(10) DEFAULT NULL,
  `trx_transaksi_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_trx_transaksi`
--

INSERT INTO `tbl_trx_transaksi` (`trx_transaksi_id`, `trx_transaksi_kode`, `trx_transaksi_user_kode`, `trx_transaksi_kategori`, `trx_transaksi_nomor`, `trx_transaksi_nama`, `trx_transaksi_jumlah`, `trx_transaksi_keterangan`, `trx_transaksi_notasi`, `trx_transaksi_tanggal`, `trx_transaksi_icon`, `trx_transaksi_rc`, `trx_transaksi_status`) VALUES
(1, 'DEPOSIT-CECDA687FC-108-041023', 'USER-43C4D7D237-958-101035', 'Deposit', 'Manual', 'Isi saldo', 100500, 'Pengisian saldo manual', '', '2024-10-03 04:08:23', 'icon_deposit.png', '1', 'Sukses'),
(2, 'PULSA-5EE6949EB2-22-151054', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala ', '2024-10-03 15:24:54', 'icon_pulsa.png', '39', '0'),
(3, 'PULSA-40036A6B78-219-151040', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala ', '2024-10-03 15:42:40', 'icon_pulsa.png', '39', '0'),
(4, 'PULSA-48E3C475A4-835-011058', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala ', '2024-10-04 01:28:58', 'icon_pulsa.png', '39', '0'),
(5, 'PULSA-5FFBBF67FE-737-011009', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Transaksi masih pending, cek status transaksi secara berkala ', '2024-10-04 01:54:09', 'icon_pulsa.png', '39', '0'),
(6, 'PULSA-0CF9C74EE8-501-041036', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:00:36', 'icon_pulsa.png', '02', 'Gagal'),
(7, 'PULSA-8A8EC94F8F-905-041020', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:03:20', 'icon_pulsa.png', '02', 'Gagal'),
(8, 'PULSA-703FC6098C-770-041057', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:25:57', 'icon_pulsa.png', '02', 'Gagal'),
(9, 'PULSA-D3AEEC3BD0-781-041049', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 04:32:49', 'icon_pulsa.png', '02', 'Gagal'),
(10, 'PULSA-CCEFF26A2D-822-051058', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:06:58', 'icon_pulsa.png', '02', 'Gagal'),
(11, 'PULSA-9867FC0285-107-051024', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:28:24', 'icon_pulsa.png', '02', 'Gagal'),
(12, 'PULSA-DEA911CD4D-423-051040', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:38:40', 'icon_pulsa.png', '02', 'Gagal'),
(13, 'PULSA-F480AF6D50-726-051034', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 05:55:34', 'icon_pulsa.png', '02', 'Gagal'),
(14, 'PULSA-6622A3D4CC-23-051031', 'USER-43C4D7D237-958-101035', 'Pulsa', '089525888602', 'Tri Reguler 1.000', 2100, 'Tri Reguler ', '', '2024-10-04 05:59:31', 'icon_pulsa.png', '00', 'Sukses'),
(15, 'PULSA-B65857FCA7-22-101022', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 10:26:22', 'icon_pulsa.png', '02', 'Gagal'),
(16, 'PULSA-13D576AE9C-863-101033', 'USER-43C4D7D237-958-101035', 'Pulsa', '085255459947', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 10:30:33', 'icon_pulsa.png', '02', 'Gagal'),
(17, 'PULSA-D4D1905F48-944-111050', 'USER-43C4D7D237-958-101035', 'Pulsa', '08533388857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-04 11:44:50', 'icon_pulsa.png', '02', 'Gagal'),
(18, 'PULSA-FF71FC5BDB-901-121004', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-06 12:10:04', 'icon_pulsa.png', '02', 'Gagal'),
(19, 'PULSA-4C55A4CE9F-521-061053', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-08 06:44:53', 'icon_pulsa.png', '02', 'Gagal'),
(20, 'PULSA-7F87FEA7A7-157-201008', 'USER-43C4D7D237-958-101035', 'Pulsa', '085333088857', 'Telkomsel Reguler 2.000', 2442, ' Valid 100%', 'Pembelian pulsa gagal, saldo kamu telah dikembalikan!', '2024-10-12 20:49:08', 'icon_pulsa.png', '02', 'Gagal');

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

--
-- Table structure for table `tbl_trx_transfer`
--

CREATE TABLE `tbl_trx_transfer` (
  `trx_transfer_id` int(11) NOT NULL,
  `trx_transfer_kode` varchar(100) DEFAULT NULL,
  `trx_transfer_user_kode` varchar(100) DEFAULT NULL,
  `trx_transfer_tujuan_kode` varchar(100) DEFAULT NULL,
  `trx_transfer_tujuan_nomor` varchar(100) DEFAULT NULL,
  `trx_transfer_tujuan_nama` varchar(150) DEFAULT NULL,
  `trx_transfer_admin` double DEFAULT NULL,
  `trx_transfer_jumlah` double DEFAULT NULL,
  `trx_transfer_tanggal` datetime DEFAULT NULL,
  `trx_transfer_keterangan` varchar(250) DEFAULT NULL,
  `trx_transfer_icon` varchar(100) DEFAULT NULL,
  `trx_transfer_rc` varchar(10) DEFAULT NULL,
  `trx_transfer_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_traveloka`
--

CREATE TABLE `tbl_trx_traveloka` (
  `trx_traveloka_id` double NOT NULL,
  `trx_traveloka_kode` varchar(100) DEFAULT NULL,
  `trx_traveloka_user_kode` varchar(100) DEFAULT NULL,
  `trx_traveloka_nomor` varchar(100) DEFAULT NULL,
  `trx_traveloka_nama` varchar(200) DEFAULT NULL,
  `trx_traveloka_admin` double DEFAULT NULL,
  `trx_traveloka_harga` double DEFAULT NULL,
  `trx_traveloka_poin` int(11) DEFAULT NULL,
  `trx_traveloka_sn` varchar(250) DEFAULT NULL,
  `trx_traveloka_keterangan` varchar(250) DEFAULT NULL,
  `trx_traveloka_notasi` varchar(250) DEFAULT NULL,
  `trx_traveloka_tanggal` datetime DEFAULT NULL,
  `trx_traveloka_icon` varchar(100) DEFAULT NULL,
  `trx_traveloka_rc` varchar(10) DEFAULT NULL,
  `trx_traveloka_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_tv`
--

CREATE TABLE `tbl_trx_tv` (
  `trx_tv_id` double NOT NULL,
  `trx_tv_kode` varchar(100) DEFAULT NULL,
  `trx_tv_user_kode` varchar(100) DEFAULT NULL,
  `trx_tv_kategori_kode` varchar(100) DEFAULT NULL,
  `trx_tv_kategori_nama` varchar(100) DEFAULT NULL,
  `trx_tv_nomor` varchar(100) DEFAULT NULL,
  `trx_tv_nama` varchar(120) DEFAULT NULL,
  `trx_tv_admin` double DEFAULT NULL,
  `trx_tv_harga` double DEFAULT NULL,
  `trx_tv_lembar_tagihan` int(11) DEFAULT NULL,
  `trx_tv_periode` varchar(100) DEFAULT NULL,
  `trx_tv_sn` varchar(100) DEFAULT NULL,
  `trx_tv_keterangan` varchar(250) DEFAULT NULL,
  `trx_tv_notasi` varchar(250) DEFAULT NULL,
  `trx_tv_tanggal` datetime DEFAULT NULL,
  `trx_tv_icon` varchar(100) DEFAULT NULL,
  `trx_tv_rc` varchar(10) DEFAULT NULL,
  `trx_tv_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_unipin`
--

CREATE TABLE `tbl_trx_unipin` (
  `trx_unipin_id` double NOT NULL,
  `trx_unipin_kode` varchar(100) DEFAULT NULL,
  `trx_unipin_user_kode` varchar(100) DEFAULT NULL,
  `trx_unipin_nomor` varchar(100) DEFAULT NULL,
  `trx_unipin_nama` varchar(200) DEFAULT NULL,
  `trx_unipin_admin` double DEFAULT NULL,
  `trx_unipin_harga` double DEFAULT NULL,
  `trx_unipin_poin` int(11) DEFAULT NULL,
  `trx_unipin_sn` varchar(250) DEFAULT NULL,
  `trx_unipin_keterangan` varchar(250) DEFAULT NULL,
  `trx_unipin_notasi` varchar(250) DEFAULT NULL,
  `trx_unipin_tanggal` datetime DEFAULT NULL,
  `trx_unipin_icon` varchar(100) DEFAULT NULL,
  `trx_unipin_rc` varchar(10) DEFAULT NULL,
  `trx_unipin_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_vidio`
--

CREATE TABLE `tbl_trx_vidio` (
  `trx_vidio_id` double NOT NULL,
  `trx_vidio_kode` varchar(100) DEFAULT NULL,
  `trx_vidio_user_kode` varchar(100) DEFAULT NULL,
  `trx_vidio_nomor` varchar(100) DEFAULT NULL,
  `trx_vidio_nama` varchar(200) DEFAULT NULL,
  `trx_vidio_admin` double DEFAULT NULL,
  `trx_vidio_harga` double DEFAULT NULL,
  `trx_vidio_poin` int(11) DEFAULT NULL,
  `trx_vidio_sn` varchar(250) DEFAULT NULL,
  `trx_vidio_keterangan` varchar(250) DEFAULT NULL,
  `trx_vidio_notasi` varchar(250) DEFAULT NULL,
  `trx_vidio_tanggal` datetime DEFAULT NULL,
  `trx_vidio_icon` varchar(100) DEFAULT NULL,
  `trx_vidio_rc` varchar(10) DEFAULT NULL,
  `trx_vidio_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_trx_wifiid`
--

CREATE TABLE `tbl_trx_wifiid` (
  `trx_wifiid_id` double NOT NULL,
  `trx_wifiid_kode` varchar(100) DEFAULT NULL,
  `trx_wifiid_user_kode` varchar(100) DEFAULT NULL,
  `trx_wifiid_nomor` varchar(100) DEFAULT NULL,
  `trx_wifiid_nama` varchar(200) DEFAULT NULL,
  `trx_wifiid_admin` double DEFAULT NULL,
  `trx_wifiid_harga` double DEFAULT NULL,
  `trx_wifiid_poin` int(11) DEFAULT NULL,
  `trx_wifiid_sn` varchar(250) DEFAULT NULL,
  `trx_wifiid_keterangan` varchar(250) DEFAULT NULL,
  `trx_wifiid_notasi` varchar(250) DEFAULT NULL,
  `trx_wifiid_tanggal` datetime DEFAULT NULL,
  `trx_wifiid_icon` varchar(100) DEFAULT NULL,
  `trx_wifiid_rc` varchar(10) DEFAULT NULL,
  `trx_wifiid_status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_ktg_game`
--
ALTER TABLE `tbl_ktg_game`
  ADD PRIMARY KEY (`ktg_game_id`),
  ADD KEY `ktg_game_status` (`ktg_game_status`),
  ADD KEY `ktg_game_kode` (`ktg_game_kode`);
ALTER TABLE `tbl_ktg_game` ADD FULLTEXT KEY `ktg_game_nama` (`ktg_game_nama`);

--
-- Indexes for table `tbl_ktg_hp`
--
ALTER TABLE `tbl_ktg_hp`
  ADD PRIMARY KEY (`ktg_hp_id`),
  ADD KEY `ktg_hp_status` (`ktg_hp_status`),
  ADD KEY `ktg_hp_kode` (`ktg_hp_kode`);
ALTER TABLE `tbl_ktg_hp` ADD FULLTEXT KEY `ktg_hp_nama` (`ktg_hp_nama`);

--
-- Indexes for table `tbl_ktg_internet`
--
ALTER TABLE `tbl_ktg_internet`
  ADD PRIMARY KEY (`ktg_internet_id`),
  ADD KEY `ktg_internet_status` (`ktg_internet_status`),
  ADD KEY `ktg_internet_kode` (`ktg_internet_kode`);
ALTER TABLE `tbl_ktg_internet` ADD FULLTEXT KEY `ktg_internet_nama` (`ktg_internet_nama`);

--
-- Indexes for table `tbl_ktg_multifinance`
--
ALTER TABLE `tbl_ktg_multifinance`
  ADD PRIMARY KEY (`ktg_multifinance_id`),
  ADD KEY `ktg_multifinance_status` (`ktg_multifinance_status`),
  ADD KEY `ktg_multifinance_kode` (`ktg_multifinance_kode`);
ALTER TABLE `tbl_ktg_multifinance` ADD FULLTEXT KEY `ktg_multifinance_nama` (`ktg_multifinance_nama`);

--
-- Indexes for table `tbl_ktg_pbb`
--
ALTER TABLE `tbl_ktg_pbb`
  ADD PRIMARY KEY (`ktg_pbb_id`),
  ADD KEY `ktg_pbb_status` (`ktg_pbb_status`),
  ADD KEY `ktg_pbb_kode` (`ktg_pbb_kode`);
ALTER TABLE `tbl_ktg_pbb` ADD FULLTEXT KEY `ktg_pbb_nama` (`ktg_pbb_nama`);

--
-- Indexes for table `tbl_ktg_pdam`
--
ALTER TABLE `tbl_ktg_pdam`
  ADD PRIMARY KEY (`ktg_pdam_id`),
  ADD KEY `ktg_pdam_kode` (`ktg_pdam_kode`),
  ADD KEY `ktg_pdam_status` (`ktg_pdam_status`);
ALTER TABLE `tbl_ktg_pdam` ADD FULLTEXT KEY `ktg_pdam_nama` (`ktg_pdam_nama`);

--
-- Indexes for table `tbl_ktg_produk`
--
ALTER TABLE `tbl_ktg_produk`
  ADD PRIMARY KEY (`ktg_produk_id`);

--
-- Indexes for table `tbl_ktg_tv`
--
ALTER TABLE `tbl_ktg_tv`
  ADD PRIMARY KEY (`ktg_tv_id`),
  ADD KEY `ktg_tv_kode` (`ktg_tv_kode`),
  ADD KEY `ktg_tv_status` (`ktg_tv_status`);
ALTER TABLE `tbl_ktg_tv` ADD FULLTEXT KEY `ktg_tv_nama` (`ktg_tv_nama`);

--
-- Indexes for table `tbl_mst_alfamart`
--
ALTER TABLE `tbl_mst_alfamart`
  ADD PRIMARY KEY (`mst_alfamart_id`),
  ADD KEY `mst_alfamart_kode` (`mst_alfamart_kode`),
  ADD KEY `mst_alfamart_status` (`mst_alfamart_status`),
  ADD KEY `mst_alfamart_urutan` (`mst_alfamart_urutan`);
ALTER TABLE `tbl_mst_alfamart` ADD FULLTEXT KEY `mst_alfamart_nama` (`mst_alfamart_nama`);

--
-- Indexes for table `tbl_mst_banner`
--
ALTER TABLE `tbl_mst_banner`
  ADD PRIMARY KEY (`mst_banner_id`),
  ADD KEY `mst_banner_kode` (`mst_banner_kode`),
  ADD KEY `mst_banner_status` (`mst_banner_status`);

--
-- Indexes for table `tbl_mst_bonus`
--
ALTER TABLE `tbl_mst_bonus`
  ADD PRIMARY KEY (`mst_bonus_id`),
  ADD KEY `mst_bonus_kode` (`mst_bonus_kode`),
  ADD KEY `mst_bonus_status` (`mst_bonus_status`);
ALTER TABLE `tbl_mst_bonus` ADD FULLTEXT KEY `mst_bonus_nama` (`mst_bonus_nama`);

--
-- Indexes for table `tbl_mst_brizzi`
--
ALTER TABLE `tbl_mst_brizzi`
  ADD PRIMARY KEY (`mst_brizzi_id`),
  ADD KEY `mst_brizzi_kode` (`mst_brizzi_kode`),
  ADD KEY `mst_brizzi_urutan` (`mst_brizzi_urutan`),
  ADD KEY `mst_brizzi_status` (`mst_brizzi_status`);
ALTER TABLE `tbl_mst_brizzi` ADD FULLTEXT KEY `mst_brizzi_nama` (`mst_brizzi_nama`);

--
-- Indexes for table `tbl_mst_bukalapak`
--
ALTER TABLE `tbl_mst_bukalapak`
  ADD PRIMARY KEY (`mst_bukalapak_id`),
  ADD KEY `mst_bukalapak_kode` (`mst_bukalapak_kode`),
  ADD KEY `mst_bukalapak_urutan` (`mst_bukalapak_urutan`),
  ADD KEY `mst_bukalapak_status` (`mst_bukalapak_status`);
ALTER TABLE `tbl_mst_bukalapak` ADD FULLTEXT KEY `mst_bukalapak_nama` (`mst_bukalapak_nama`);

--
-- Indexes for table `tbl_mst_dana`
--
ALTER TABLE `tbl_mst_dana`
  ADD PRIMARY KEY (`mst_dana_id`),
  ADD KEY `mst_dana_kode` (`mst_dana_kode`),
  ADD KEY `mst_dana_urutan` (`mst_dana_urutan`),
  ADD KEY `mst_dana_status` (`mst_dana_status`);
ALTER TABLE `tbl_mst_dana` ADD FULLTEXT KEY `mst_dana_nama` (`mst_dana_nama`);

--
-- Indexes for table `tbl_mst_deposit`
--
ALTER TABLE `tbl_mst_deposit`
  ADD PRIMARY KEY (`mst_deposit_id`),
  ADD KEY `mst_deposit_kode` (`mst_deposit_kode`),
  ADD KEY `mst_deposit_status` (`mst_deposit_status`),
  ADD KEY `mst_deposit_persen` (`mst_deposit_persen`),
  ADD KEY `mst_deposit_admin` (`mst_deposit_admin`);
ALTER TABLE `tbl_mst_deposit` ADD FULLTEXT KEY `mst_deposit_nama` (`mst_deposit_nama`);

--
-- Indexes for table `tbl_mst_deposit_manual`
--
ALTER TABLE `tbl_mst_deposit_manual`
  ADD PRIMARY KEY (`mst_deposit_id`),
  ADD KEY `mst_deposit_kode` (`mst_deposit_kode`),
  ADD KEY `mst_deposit_status` (`mst_deposit_status`),
  ADD KEY `mst_deposit_persen` (`mst_deposit_nomor_rekening`),
  ADD KEY `mst_deposit_admin` (`mst_deposit_admin`);
ALTER TABLE `tbl_mst_deposit_manual` ADD FULLTEXT KEY `mst_deposit_nama` (`mst_deposit_nama_bank`);

--
-- Indexes for table `tbl_mst_doku`
--
ALTER TABLE `tbl_mst_doku`
  ADD PRIMARY KEY (`mst_doku_id`),
  ADD KEY `mst_doku_kode` (`mst_doku_kode`),
  ADD KEY `mst_doku_urutan` (`mst_doku_urutan`),
  ADD KEY `mst_doku_status` (`mst_doku_status`);
ALTER TABLE `tbl_mst_doku` ADD FULLTEXT KEY `mst_doku_nama` (`mst_doku_nama`);

--
-- Indexes for table `tbl_mst_emoney`
--
ALTER TABLE `tbl_mst_emoney`
  ADD PRIMARY KEY (`mst_emoney_id`),
  ADD KEY `mst_emoney_kode` (`mst_emoney_kode`),
  ADD KEY `mst_emoney_urutan` (`mst_emoney_urutan`),
  ADD KEY `mst_emoney_status` (`mst_emoney_status`);
ALTER TABLE `tbl_mst_emoney` ADD FULLTEXT KEY `mst_emoney_nama` (`mst_emoney_nama`);

--
-- Indexes for table `tbl_mst_game`
--
ALTER TABLE `tbl_mst_game`
  ADD PRIMARY KEY (`mst_game_id`),
  ADD KEY `mst_game_kode` (`mst_game_kode`),
  ADD KEY `mst_game_kategori` (`mst_game_kategori`),
  ADD KEY `mst_game_urutan` (`mst_game_urutan`),
  ADD KEY `mst_game_status` (`mst_game_status`);
ALTER TABLE `tbl_mst_game` ADD FULLTEXT KEY `mst_game_nama` (`mst_game_nama`);

--
-- Indexes for table `tbl_mst_gojek_driver`
--
ALTER TABLE `tbl_mst_gojek_driver`
  ADD PRIMARY KEY (`mst_gojek_driver_id`),
  ADD KEY `mst_gojek_driver_kode` (`mst_gojek_driver_kode`),
  ADD KEY `mst_gojek_driver_urutan` (`mst_gojek_driver_urutan`),
  ADD KEY `mst_gojek_driver_status` (`mst_gojek_driver_status`);
ALTER TABLE `tbl_mst_gojek_driver` ADD FULLTEXT KEY `mst_gojek_driver_nama` (`mst_gojek_driver_nama`);

--
-- Indexes for table `tbl_mst_googleplay`
--
ALTER TABLE `tbl_mst_googleplay`
  ADD PRIMARY KEY (`mst_googleplay_id`),
  ADD KEY `mst_googleplay_kode` (`mst_googleplay_kode`),
  ADD KEY `mst_googleplay_urutan` (`mst_googleplay_urutan`),
  ADD KEY `mst_googleplay_status` (`mst_googleplay_status`);
ALTER TABLE `tbl_mst_googleplay` ADD FULLTEXT KEY `mst_googleplay_nama` (`mst_googleplay_nama`);

--
-- Indexes for table `tbl_mst_gopay`
--
ALTER TABLE `tbl_mst_gopay`
  ADD PRIMARY KEY (`mst_gopay_id`),
  ADD KEY `mst_gopay_kode` (`mst_gopay_kode`),
  ADD KEY `mst_gopay_urutan` (`mst_gopay_urutan`),
  ADD KEY `mst_gopay_status` (`mst_gopay_status`);
ALTER TABLE `tbl_mst_gopay` ADD FULLTEXT KEY `mst_gopay_nama` (`mst_gopay_nama`);

--
-- Indexes for table `tbl_mst_grab`
--
ALTER TABLE `tbl_mst_grab`
  ADD PRIMARY KEY (`mst_grab_id`),
  ADD KEY `mst_grab_kode` (`mst_grab_kode`),
  ADD KEY `mst_grab_urutan` (`mst_grab_urutan`),
  ADD KEY `mst_grab_status` (`mst_grab_status`);
ALTER TABLE `tbl_mst_grab` ADD FULLTEXT KEY `mst_grab_nama` (`mst_grab_nama`);

--
-- Indexes for table `tbl_mst_grab_driver`
--
ALTER TABLE `tbl_mst_grab_driver`
  ADD PRIMARY KEY (`mst_grab_driver_id`),
  ADD KEY `mst_grab_driver_kode` (`mst_grab_driver_kode`),
  ADD KEY `mst_grab_driver_urutan` (`mst_grab_driver_urutan`),
  ADD KEY `mst_grab_driver_status` (`mst_grab_driver_status`);
ALTER TABLE `tbl_mst_grab_driver` ADD FULLTEXT KEY `mst_grab_driver_nama` (`mst_grab_driver_nama`);

--
-- Indexes for table `tbl_mst_hadiah`
--
ALTER TABLE `tbl_mst_hadiah`
  ADD PRIMARY KEY (`mst_hadiah_id`),
  ADD KEY `mst_hadiah_kode` (`mst_hadiah_kode`),
  ADD KEY `mst_hadiah_periode_awal` (`mst_hadiah_periode_awal`),
  ADD KEY `mst_hadiah_periode_akhir` (`mst_hadiah_periode_akhir`),
  ADD KEY `mst_hadiah_status` (`mst_hadiah_status`);
ALTER TABLE `tbl_mst_hadiah` ADD FULLTEXT KEY `mst_hadiah_nama` (`mst_hadiah_nama`);

--
-- Indexes for table `tbl_mst_inbox`
--
ALTER TABLE `tbl_mst_inbox`
  ADD PRIMARY KEY (`mst_inbox_id`),
  ADD KEY `mst_inbox_kode` (`mst_inbox_kode`),
  ADD KEY `mst_inbox_tanggal` (`mst_inbox_tanggal`),
  ADD KEY `mst_inbox_status` (`mst_inbox_status`);

--
-- Indexes for table `tbl_mst_indomaret`
--
ALTER TABLE `tbl_mst_indomaret`
  ADD PRIMARY KEY (`mst_indomaret_id`),
  ADD KEY `mst_indomaret_kode` (`mst_indomaret_kode`),
  ADD KEY `mst_indomaret_urutan` (`mst_indomaret_urutan`),
  ADD KEY `mst_indomaret_status` (`mst_indomaret_status`);
ALTER TABLE `tbl_mst_indomaret` ADD FULLTEXT KEY `mst_indomaret_nama` (`mst_indomaret_nama`);

--
-- Indexes for table `tbl_mst_isaku`
--
ALTER TABLE `tbl_mst_isaku`
  ADD PRIMARY KEY (`mst_isaku_id`),
  ADD KEY `mst_isaku_kode` (`mst_isaku_kode`),
  ADD KEY `mst_isaku_urutan` (`mst_isaku_urutan`),
  ADD KEY `mst_isaku_status` (`mst_isaku_status`);
ALTER TABLE `tbl_mst_isaku` ADD FULLTEXT KEY `mst_isaku_nama` (`mst_isaku_nama`);

--
-- Indexes for table `tbl_mst_limit`
--
ALTER TABLE `tbl_mst_limit`
  ADD PRIMARY KEY (`mst_limit_id`),
  ADD KEY `mst_limit_count` (`mst_limit_count`),
  ADD KEY `mst_limit_hour` (`mst_limit_hour`),
  ADD KEY `mst_limit_api_key` (`mst_limit_api_key`);
ALTER TABLE `tbl_mst_limit` ADD FULLTEXT KEY `mst_limit_uri` (`mst_limit_uri`);

--
-- Indexes for table `tbl_mst_linkaja`
--
ALTER TABLE `tbl_mst_linkaja`
  ADD PRIMARY KEY (`mst_linkaja_id`),
  ADD KEY `mst_linkaja_kode` (`mst_linkaja_kode`),
  ADD KEY `mst_linkaja_urutan` (`mst_linkaja_urutan`),
  ADD KEY `mst_linkaja_status` (`mst_linkaja_status`);
ALTER TABLE `tbl_mst_linkaja` ADD FULLTEXT KEY `mst_linkaja_nama` (`mst_linkaja_nama`);

--
-- Indexes for table `tbl_mst_masa_aktif`
--
ALTER TABLE `tbl_mst_masa_aktif`
  ADD PRIMARY KEY (`mst_masa_aktif_id`),
  ADD KEY `mst_masa_aktif_kode` (`mst_masa_aktif_kode`),
  ADD KEY `mst_masa_aktif_operator` (`mst_masa_aktif_operator`),
  ADD KEY `mst_masa_aktif_urutan` (`mst_masa_aktif_urutan`),
  ADD KEY `mst_masa_aktif_status` (`mst_masa_aktif_status`);
ALTER TABLE `tbl_mst_masa_aktif` ADD FULLTEXT KEY `mst_masa_aktif_nama` (`mst_masa_aktif_nama`);

--
-- Indexes for table `tbl_mst_materai`
--
ALTER TABLE `tbl_mst_materai`
  ADD PRIMARY KEY (`mst_materai_id`),
  ADD KEY `mst_materai_kode` (`mst_materai_kode`),
  ADD KEY `mst_materai_urutan` (`mst_materai_urutan`),
  ADD KEY `mst_materai_status` (`mst_materai_status`);
ALTER TABLE `tbl_mst_materai` ADD FULLTEXT KEY `mst_materai_nama` (`mst_materai_nama`);
ALTER TABLE `tbl_mst_materai` ADD FULLTEXT KEY `mst_materai_keterangan` (`mst_materai_keterangan`);

--
-- Indexes for table `tbl_mst_maxim`
--
ALTER TABLE `tbl_mst_maxim`
  ADD PRIMARY KEY (`mst_maxim_id`),
  ADD KEY `mst_maxim_kode` (`mst_maxim_kode`),
  ADD KEY `mst_maxim_urutan` (`mst_maxim_urutan`),
  ADD KEY `mst_maxim_status` (`mst_maxim_status`);
ALTER TABLE `tbl_mst_maxim` ADD FULLTEXT KEY `mst_maxim_nama` (`mst_maxim_nama`);

--
-- Indexes for table `tbl_mst_maxim_driver`
--
ALTER TABLE `tbl_mst_maxim_driver`
  ADD PRIMARY KEY (`mst_maxim_driver_id`),
  ADD KEY `mst_maxim_driver_kode` (`mst_maxim_driver_kode`),
  ADD KEY `mst_maxim_driver_urutan` (`mst_maxim_driver_urutan`),
  ADD KEY `mst_maxim_driver_status` (`mst_maxim_driver_status`);
ALTER TABLE `tbl_mst_maxim_driver` ADD FULLTEXT KEY `mst_maxim_driver_nama` (`mst_maxim_driver_nama`);

--
-- Indexes for table `tbl_mst_menu`
--
ALTER TABLE `tbl_mst_menu`
  ADD PRIMARY KEY (`mst_menu_id`),
  ADD KEY `mst_menu_kode` (`mst_menu_kode`),
  ADD KEY `mst_menu_grup` (`mst_menu_grup`),
  ADD KEY `mst_menu_urutan` (`mst_menu_urutan`),
  ADD KEY `mst_menu_status` (`mst_menu_status`);
ALTER TABLE `tbl_mst_menu` ADD FULLTEXT KEY `mst_menu_nama` (`mst_menu_nama`);

--
-- Indexes for table `tbl_mst_mtix`
--
ALTER TABLE `tbl_mst_mtix`
  ADD PRIMARY KEY (`mst_mtix_id`),
  ADD KEY `mst_mtix_kode` (`mst_mtix_kode`),
  ADD KEY `mst_mtix_urutan` (`mst_mtix_urutan`),
  ADD KEY `mst_mtix_status` (`mst_mtix_status`);
ALTER TABLE `tbl_mst_mtix` ADD FULLTEXT KEY `mst_mtix_nama` (`mst_mtix_nama`);

--
-- Indexes for table `tbl_mst_notifikasi`
--
ALTER TABLE `tbl_mst_notifikasi`
  ADD PRIMARY KEY (`mst_notifikasi_id`);
ALTER TABLE `tbl_mst_notifikasi` ADD FULLTEXT KEY `mst_notifikasi_judul` (`mst_notifikasi_judul`);
ALTER TABLE `tbl_mst_notifikasi` ADD FULLTEXT KEY `mst_notifikasi_isi` (`mst_notifikasi_isi`);

--
-- Indexes for table `tbl_mst_ovo`
--
ALTER TABLE `tbl_mst_ovo`
  ADD PRIMARY KEY (`mst_ovo_id`),
  ADD KEY `mst_ovo_kode` (`mst_ovo_kode`),
  ADD KEY `mst_ovo_urutan` (`mst_ovo_urutan`),
  ADD KEY `mst_ovo_status` (`mst_ovo_status`);
ALTER TABLE `tbl_mst_ovo` ADD FULLTEXT KEY `mst_ovo_nama` (`mst_ovo_nama`);

--
-- Indexes for table `tbl_mst_paket_data`
--
ALTER TABLE `tbl_mst_paket_data`
  ADD PRIMARY KEY (`mst_paket_data_id`),
  ADD KEY `mst_paket_data_kode` (`mst_paket_data_kode`),
  ADD KEY `mst_paket_data_operator` (`mst_paket_data_operator`),
  ADD KEY `mst_paket_data_urutan` (`mst_paket_data_urutan`),
  ADD KEY `mst_paket_data_status` (`mst_paket_data_status`);
ALTER TABLE `tbl_mst_paket_data` ADD FULLTEXT KEY `mst_paket_data_nama` (`mst_paket_data_nama`);

--
-- Indexes for table `tbl_mst_paket_nelfon`
--
ALTER TABLE `tbl_mst_paket_nelfon`
  ADD PRIMARY KEY (`mst_paket_nelfon_id`),
  ADD KEY `mst_paket_nelfon_kode` (`mst_paket_nelfon_kode`),
  ADD KEY `mst_paket_nelfon_operator` (`mst_paket_nelfon_operator`),
  ADD KEY `mst_paket_nelfon_urutan` (`mst_paket_nelfon_urutan`),
  ADD KEY `mst_paket_nelfon_status` (`mst_paket_nelfon_status`);
ALTER TABLE `tbl_mst_paket_nelfon` ADD FULLTEXT KEY `mst_paket_nelfon_nama` (`mst_paket_nelfon_nama`);

--
-- Indexes for table `tbl_mst_paket_sms`
--
ALTER TABLE `tbl_mst_paket_sms`
  ADD PRIMARY KEY (`mst_paket_sms_id`),
  ADD KEY `mst_paket_sms_kode` (`mst_paket_sms_kode`),
  ADD KEY `mst_paket_sms_operator` (`mst_paket_sms_operator`),
  ADD KEY `mst_paket_sms_urutan` (`mst_paket_sms_urutan`),
  ADD KEY `mst_paket_sms_status` (`mst_paket_sms_status`);
ALTER TABLE `tbl_mst_paket_sms` ADD FULLTEXT KEY `mst_paket_sms_nama` (`mst_paket_sms_nama`);

--
-- Indexes for table `tbl_mst_poin`
--
ALTER TABLE `tbl_mst_poin`
  ADD PRIMARY KEY (`mst_poin_id`),
  ADD KEY `mst_poin_kode` (`mst_poin_kode`),
  ADD KEY `mst_poin_user_kode` (`mst_poin_user_kode`);

--
-- Indexes for table `tbl_mst_produk`
--
ALTER TABLE `tbl_mst_produk`
  ADD PRIMARY KEY (`mst_produk_id`);

--
-- Indexes for table `tbl_mst_pulsa`
--
ALTER TABLE `tbl_mst_pulsa`
  ADD PRIMARY KEY (`mst_pulsa_id`),
  ADD KEY `mst_pulsa_kode` (`mst_pulsa_kode`),
  ADD KEY `mst_pulsa_operator` (`mst_pulsa_operator`),
  ADD KEY `mst_pulsa_urutan` (`mst_pulsa_urutan`),
  ADD KEY `mst_pulsa_status` (`mst_pulsa_status`);
ALTER TABLE `tbl_mst_pulsa` ADD FULLTEXT KEY `mst_pulsa_nama` (`mst_pulsa_nama`);

--
-- Indexes for table `tbl_mst_pulsa_transfer`
--
ALTER TABLE `tbl_mst_pulsa_transfer`
  ADD PRIMARY KEY (`mst_pulsa_transfer_id`),
  ADD KEY `mst_pulsa_transfer_kode` (`mst_pulsa_transfer_kode`),
  ADD KEY `mst_pulsa_transfer_operator` (`mst_pulsa_transfer_operator`),
  ADD KEY `mst_pulsa_transfer_urutan` (`mst_pulsa_transfer_urutan`),
  ADD KEY `mst_pulsa_transfer_status` (`mst_pulsa_transfer_status`);
ALTER TABLE `tbl_mst_pulsa_transfer` ADD FULLTEXT KEY `mst_pulsa_transfer_nama` (`mst_pulsa_transfer_nama`);

--
-- Indexes for table `tbl_mst_sakuku`
--
ALTER TABLE `tbl_mst_sakuku`
  ADD PRIMARY KEY (`mst_sakuku_id`),
  ADD KEY `mst_sakuku_kode` (`mst_sakuku_kode`),
  ADD KEY `mst_sakuku_urutan` (`mst_sakuku_urutan`),
  ADD KEY `mst_sakuku_status` (`mst_sakuku_status`);
ALTER TABLE `tbl_mst_sakuku` ADD FULLTEXT KEY `mst_sakuku_nama` (`mst_sakuku_nama`);

--
-- Indexes for table `tbl_mst_saldo`
--
ALTER TABLE `tbl_mst_saldo`
  ADD PRIMARY KEY (`mst_saldo_id`),
  ADD KEY `mst_saldo_kode` (`mst_saldo_kode`),
  ADD KEY `mst_saldo_user_kode` (`mst_saldo_user_kode`);

--
-- Indexes for table `tbl_mst_shopeepay`
--
ALTER TABLE `tbl_mst_shopeepay`
  ADD PRIMARY KEY (`mst_shopeepay_id`),
  ADD KEY `mst_shopeepay_kode` (`mst_shopeepay_kode`),
  ADD KEY `mst_shopeepay_urutan` (`mst_shopeepay_urutan`),
  ADD KEY `mst_shopeepay_status` (`mst_shopeepay_status`);
ALTER TABLE `tbl_mst_shopeepay` ADD FULLTEXT KEY `mst_shopeepay_nama` (`mst_shopeepay_nama`);

--
-- Indexes for table `tbl_mst_shopee_driver`
--
ALTER TABLE `tbl_mst_shopee_driver`
  ADD PRIMARY KEY (`mst_shopee_driver_id`),
  ADD KEY `mst_shopee_driver_kode` (`mst_shopee_driver_kode`),
  ADD KEY `mst_shopee_driver_urutan` (`mst_shopee_driver_urutan`),
  ADD KEY `mst_shopee_driver_status` (`mst_shopee_driver_status`);
ALTER TABLE `tbl_mst_shopee_driver` ADD FULLTEXT KEY `mst_shopee_driver_nama` (`mst_shopee_driver_nama`);

--
-- Indexes for table `tbl_mst_spotify`
--
ALTER TABLE `tbl_mst_spotify`
  ADD PRIMARY KEY (`mst_spotify_id`),
  ADD KEY `mst_spotify_kode` (`mst_spotify_kode`),
  ADD KEY `mst_spotify_urutan` (`mst_spotify_urutan`),
  ADD KEY `mst_spotify_status` (`mst_spotify_status`);
ALTER TABLE `tbl_mst_spotify` ADD FULLTEXT KEY `mst_spotify_nama` (`mst_spotify_nama`);

--
-- Indexes for table `tbl_mst_tapcash`
--
ALTER TABLE `tbl_mst_tapcash`
  ADD PRIMARY KEY (`mst_tapcash_id`),
  ADD KEY `mst_tapcash_kode` (`mst_tapcash_kode`),
  ADD KEY `mst_tapcash_urutan` (`mst_tapcash_urutan`),
  ADD KEY `mst_tapcash_status` (`mst_tapcash_status`);
ALTER TABLE `tbl_mst_tapcash` ADD FULLTEXT KEY `mst_tapcash_nama` (`mst_tapcash_nama`);

--
-- Indexes for table `tbl_mst_tixid`
--
ALTER TABLE `tbl_mst_tixid`
  ADD PRIMARY KEY (`mst_tixid_id`),
  ADD KEY `mst_tixid_kode` (`mst_tixid_kode`),
  ADD KEY `mst_tixid_urutan` (`mst_tixid_urutan`),
  ADD KEY `mst_tixid_status` (`mst_tixid_status`);
ALTER TABLE `tbl_mst_tixid` ADD FULLTEXT KEY `mst_tixid_nama` (`mst_tixid_nama`);

--
-- Indexes for table `tbl_mst_token_pln`
--
ALTER TABLE `tbl_mst_token_pln`
  ADD PRIMARY KEY (`mst_token_pln_id`),
  ADD KEY `mst_token_pln_kode` (`mst_token_pln_kode`),
  ADD KEY `mst_token_pln_urutan` (`mst_token_pln_urutan`),
  ADD KEY `mst_token_pln_status` (`mst_token_pln_status`);
ALTER TABLE `tbl_mst_token_pln` ADD FULLTEXT KEY `mst_token_pln_nama` (`mst_token_pln_nama`);

--
-- Indexes for table `tbl_mst_tokopedia`
--
ALTER TABLE `tbl_mst_tokopedia`
  ADD PRIMARY KEY (`mst_tokopedia_id`),
  ADD KEY `mst_tokopedia_kode` (`mst_tokopedia_kode`),
  ADD KEY `mst_tokopedia_urutan` (`mst_tokopedia_urutan`),
  ADD KEY `mst_tokopedia_status` (`mst_tokopedia_status`);
ALTER TABLE `tbl_mst_tokopedia` ADD FULLTEXT KEY `mst_tokopedia_nama` (`mst_tokopedia_nama`);

--
-- Indexes for table `tbl_mst_traveloka`
--
ALTER TABLE `tbl_mst_traveloka`
  ADD PRIMARY KEY (`mst_traveloka_id`),
  ADD KEY `mst_traveloka_kode` (`mst_traveloka_kode`),
  ADD KEY `mst_traveloka_urutan` (`mst_traveloka_urutan`),
  ADD KEY `mst_traveloka_status` (`mst_traveloka_status`);
ALTER TABLE `tbl_mst_traveloka` ADD FULLTEXT KEY `mst_traveloka_nama` (`mst_traveloka_nama`);

--
-- Indexes for table `tbl_mst_unipin`
--
ALTER TABLE `tbl_mst_unipin`
  ADD PRIMARY KEY (`mst_unipin_id`),
  ADD KEY `mst_unipin_kode` (`mst_unipin_kode`),
  ADD KEY `mst_unipin_urutan` (`mst_unipin_urutan`),
  ADD KEY `mst_unipin_status` (`mst_unipin_status`);
ALTER TABLE `tbl_mst_unipin` ADD FULLTEXT KEY `mst_unipin_nama` (`mst_unipin_nama`);

--
-- Indexes for table `tbl_mst_update`
--
ALTER TABLE `tbl_mst_update`
  ADD PRIMARY KEY (`mst_update_id`),
  ADD KEY `mst_update_kode` (`mst_update_kode`),
  ADD KEY `mst_update_status` (`mst_update_status`);

--
-- Indexes for table `tbl_mst_user`
--
ALTER TABLE `tbl_mst_user`
  ADD PRIMARY KEY (`mst_user_id`),
  ADD UNIQUE KEY `mst_user_nomor_hp` (`mst_user_nomor_hp`),
  ADD UNIQUE KEY `mst_user_email` (`mst_user_email`),
  ADD KEY `mst_user_kode` (`mst_user_kode`),
  ADD KEY `mst_user_password` (`mst_user_password`),
  ADD KEY `mst_user_upline` (`mst_user_upline`),
  ADD KEY `mst_user_token` (`mst_user_token`),
  ADD KEY `mst_user_status` (`mst_user_status`);
ALTER TABLE `tbl_mst_user` ADD FULLTEXT KEY `mst_user_nama_lengkap` (`mst_user_nama_lengkap`);
ALTER TABLE `tbl_mst_user` ADD FULLTEXT KEY `mst_user_firebase` (`mst_user_firebase`);

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

--
-- Indexes for table `tbl_mst_vidio`
--
ALTER TABLE `tbl_mst_vidio`
  ADD PRIMARY KEY (`mst_vidio_id`),
  ADD KEY `mst_vidio_kode` (`mst_vidio_kode`),
  ADD KEY `mst_vidio_urutan` (`mst_vidio_urutan`),
  ADD KEY `mst_vidio_status` (`mst_vidio_status`);
ALTER TABLE `tbl_mst_vidio` ADD FULLTEXT KEY `mst_vidio_nama` (`mst_vidio_nama`);

--
-- Indexes for table `tbl_mst_wifiid`
--
ALTER TABLE `tbl_mst_wifiid`
  ADD PRIMARY KEY (`mst_wifiid_id`),
  ADD KEY `mst_wifiid_kode` (`mst_wifiid_kode`),
  ADD KEY `mst_wifiid_urutan` (`mst_wifiid_urutan`),
  ADD KEY `mst_wifiid_status` (`mst_wifiid_status`);
ALTER TABLE `tbl_mst_wifiid` ADD FULLTEXT KEY `mst_wifiid_nama` (`mst_wifiid_nama`);

--
-- Indexes for table `tbl_trx_alfamart`
--
ALTER TABLE `tbl_trx_alfamart`
  ADD PRIMARY KEY (`trx_alfamart_id`),
  ADD KEY `trx_alfamart_kode` (`trx_alfamart_kode`),
  ADD KEY `trx_alfamart_user_kode` (`trx_alfamart_user_kode`),
  ADD KEY `trx_alfamart_nomor` (`trx_alfamart_nomor`),
  ADD KEY `trx_alfamart_tanggal` (`trx_alfamart_tanggal`),
  ADD KEY `trx_alfamart_status` (`trx_alfamart_status`);
ALTER TABLE `tbl_trx_alfamart` ADD FULLTEXT KEY `trx_alfamart_nama` (`trx_alfamart_nama`);

--
-- Indexes for table `tbl_trx_bonus`
--
ALTER TABLE `tbl_trx_bonus`
  ADD PRIMARY KEY (`trx_bonus_id`),
  ADD KEY `trx_bonus_kode` (`trx_bonus_kode`),
  ADD KEY `trx_bonus_user_kode` (`trx_bonus_user_kode`),
  ADD KEY `trx_bonus_tanggal` (`trx_bonus_tanggal`),
  ADD KEY `trx_bonus_status` (`trx_bonus_status`);
ALTER TABLE `tbl_trx_bonus` ADD FULLTEXT KEY `trx_bonus_nama` (`trx_bonus_nama`);

--
-- Indexes for table `tbl_trx_bpjs`
--
ALTER TABLE `tbl_trx_bpjs`
  ADD PRIMARY KEY (`trx_bpjs_id`),
  ADD KEY `trx_bpjs_tanggal` (`trx_bpjs_tanggal`),
  ADD KEY `trx_bpjs_kode` (`trx_bpjs_kode`),
  ADD KEY `trx_bpjs_user_kode` (`trx_bpjs_user_kode`),
  ADD KEY `trx_bpjs_nomor` (`trx_bpjs_nomor`),
  ADD KEY `trx_bpjs_status` (`trx_bpjs_status`),
  ADD KEY `trx_bpjs_tanggal_2` (`trx_bpjs_tanggal`);
ALTER TABLE `tbl_trx_bpjs` ADD FULLTEXT KEY `trx_bpjs_nama` (`trx_bpjs_nama`);

--
-- Indexes for table `tbl_trx_brizzi`
--
ALTER TABLE `tbl_trx_brizzi`
  ADD PRIMARY KEY (`trx_brizzi_id`),
  ADD KEY `trx_brizzi_kode` (`trx_brizzi_kode`),
  ADD KEY `trx_brizzi_user_kode` (`trx_brizzi_user_kode`),
  ADD KEY `trx_brizzi_nomor` (`trx_brizzi_nomor`),
  ADD KEY `trx_brizzi_tanggal` (`trx_brizzi_tanggal`),
  ADD KEY `trx_brizzi_status` (`trx_brizzi_status`);
ALTER TABLE `tbl_trx_brizzi` ADD FULLTEXT KEY `trx_brizzi_nama` (`trx_brizzi_nama`);

--
-- Indexes for table `tbl_trx_bukalapak`
--
ALTER TABLE `tbl_trx_bukalapak`
  ADD PRIMARY KEY (`trx_bukalapak_id`),
  ADD KEY `trx_bukalapak_kode` (`trx_bukalapak_kode`),
  ADD KEY `trx_bukalapak_user_kode` (`trx_bukalapak_user_kode`),
  ADD KEY `trx_bukalapak_nomor` (`trx_bukalapak_nomor`),
  ADD KEY `trx_bukalapak_tanggal` (`trx_bukalapak_tanggal`),
  ADD KEY `trx_bukalapak_status` (`trx_bukalapak_status`);
ALTER TABLE `tbl_trx_bukalapak` ADD FULLTEXT KEY `trx_bukalapak_nama` (`trx_bukalapak_nama`);

--
-- Indexes for table `tbl_trx_dana`
--
ALTER TABLE `tbl_trx_dana`
  ADD PRIMARY KEY (`trx_dana_id`),
  ADD KEY `trx_dana_kode` (`trx_dana_kode`),
  ADD KEY `trx_dana_user_kode` (`trx_dana_user_kode`),
  ADD KEY `trx_dana_nomor` (`trx_dana_nomor`),
  ADD KEY `trx_dana_tanggal` (`trx_dana_tanggal`),
  ADD KEY `trx_dana_status` (`trx_dana_status`);
ALTER TABLE `tbl_trx_dana` ADD FULLTEXT KEY `trx_dana_nama` (`trx_dana_nama`);

--
-- Indexes for table `tbl_trx_deposit`
--
ALTER TABLE `tbl_trx_deposit`
  ADD PRIMARY KEY (`trx_deposit_id`),
  ADD KEY `trx_deposit_kode` (`trx_deposit_kode`),
  ADD KEY `trx_deposit_user_kode` (`trx_deposit_user_kode`),
  ADD KEY `trx_deposit_tripay_reference` (`trx_deposit_tripay_reference`),
  ADD KEY `trx_deposit_tanggal` (`trx_deposit_tanggal`),
  ADD KEY `trx_deposit_metode` (`trx_deposit_metode`),
  ADD KEY `trx_deposit_status` (`trx_deposit_status`);

--
-- Indexes for table `tbl_trx_doku`
--
ALTER TABLE `tbl_trx_doku`
  ADD PRIMARY KEY (`trx_doku_id`),
  ADD KEY `trx_doku_kode` (`trx_doku_kode`),
  ADD KEY `trx_doku_user_kode` (`trx_doku_user_kode`),
  ADD KEY `trx_doku_nomor` (`trx_doku_nomor`),
  ADD KEY `trx_doku_tanggal` (`trx_doku_tanggal`),
  ADD KEY `trx_doku_status` (`trx_doku_status`);
ALTER TABLE `tbl_trx_doku` ADD FULLTEXT KEY `trx_doku_nama` (`trx_doku_nama`);

--
-- Indexes for table `tbl_trx_emoney`
--
ALTER TABLE `tbl_trx_emoney`
  ADD PRIMARY KEY (`trx_emoney_id`),
  ADD KEY `trx_emoney_kode` (`trx_emoney_kode`),
  ADD KEY `trx_emoney_user_kode` (`trx_emoney_user_kode`),
  ADD KEY `trx_emoney_nomor` (`trx_emoney_nomor`),
  ADD KEY `trx_emoney_tanggal` (`trx_emoney_tanggal`),
  ADD KEY `trx_emoney_status` (`trx_emoney_status`);
ALTER TABLE `tbl_trx_emoney` ADD FULLTEXT KEY `trx_emoney_nama` (`trx_emoney_nama`);

--
-- Indexes for table `tbl_trx_game`
--
ALTER TABLE `tbl_trx_game`
  ADD PRIMARY KEY (`trx_game_id`),
  ADD KEY `trx_game_kode` (`trx_game_kode`),
  ADD KEY `trx_game_user_kode` (`trx_game_user_kode`),
  ADD KEY `trx_game_kategori` (`trx_game_kategori`),
  ADD KEY `trx_game_nomor` (`trx_game_nomor`),
  ADD KEY `trx_game_tanggal` (`trx_game_tanggal`),
  ADD KEY `trx_game_status` (`trx_game_status`);
ALTER TABLE `tbl_trx_game` ADD FULLTEXT KEY `trx_game_nama` (`trx_game_nama`);

--
-- Indexes for table `tbl_trx_gas`
--
ALTER TABLE `tbl_trx_gas`
  ADD PRIMARY KEY (`trx_gas_id`),
  ADD KEY `trx_gas_tanggal` (`trx_gas_tanggal`),
  ADD KEY `trx_gas_kode` (`trx_gas_kode`),
  ADD KEY `trx_gas_user_kode` (`trx_gas_user_kode`),
  ADD KEY `trx_gas_nomor` (`trx_gas_nomor`),
  ADD KEY `trx_gas_status` (`trx_gas_status`);
ALTER TABLE `tbl_trx_gas` ADD FULLTEXT KEY `trx_gas_nama` (`trx_gas_nama`);

--
-- Indexes for table `tbl_trx_gojek_driver`
--
ALTER TABLE `tbl_trx_gojek_driver`
  ADD PRIMARY KEY (`trx_gojek_driver_id`),
  ADD KEY `trx_gojek_driver_kode` (`trx_gojek_driver_kode`),
  ADD KEY `trx_gojek_driver_user_kode` (`trx_gojek_driver_user_kode`),
  ADD KEY `trx_gojek_driver_nomor` (`trx_gojek_driver_nomor`),
  ADD KEY `trx_gojek_driver_tanggal` (`trx_gojek_driver_tanggal`),
  ADD KEY `trx_gojek_driver_status` (`trx_gojek_driver_status`);
ALTER TABLE `tbl_trx_gojek_driver` ADD FULLTEXT KEY `trx_gojek_driver_nama` (`trx_gojek_driver_nama`);

--
-- Indexes for table `tbl_trx_googleplay`
--
ALTER TABLE `tbl_trx_googleplay`
  ADD PRIMARY KEY (`trx_googleplay_id`),
  ADD KEY `trx_googleplay_kode` (`trx_googleplay_kode`),
  ADD KEY `trx_googleplay_user_kode` (`trx_googleplay_user_kode`),
  ADD KEY `trx_googleplay_nomor` (`trx_googleplay_nomor`),
  ADD KEY `trx_googleplay_tanggal` (`trx_googleplay_tanggal`),
  ADD KEY `trx_googleplay_status` (`trx_googleplay_status`);
ALTER TABLE `tbl_trx_googleplay` ADD FULLTEXT KEY `trx_googleplay_nama` (`trx_googleplay_nama`);

--
-- Indexes for table `tbl_trx_gopay`
--
ALTER TABLE `tbl_trx_gopay`
  ADD PRIMARY KEY (`trx_gopay_id`),
  ADD KEY `trx_gopay_tanggal` (`trx_gopay_tanggal`),
  ADD KEY `trx_gopay_kode` (`trx_gopay_kode`),
  ADD KEY `trx_gopay_user_kode` (`trx_gopay_user_kode`),
  ADD KEY `trx_gopay_nomor` (`trx_gopay_nomor`),
  ADD KEY `trx_gopay_status` (`trx_gopay_status`);
ALTER TABLE `tbl_trx_gopay` ADD FULLTEXT KEY `trx_gopay_nama` (`trx_gopay_nama`);

--
-- Indexes for table `tbl_trx_grab`
--
ALTER TABLE `tbl_trx_grab`
  ADD PRIMARY KEY (`trx_grab_id`),
  ADD KEY `trx_grab_kode` (`trx_grab_kode`),
  ADD KEY `trx_grab_user_kode` (`trx_grab_user_kode`),
  ADD KEY `trx_grab_nomor` (`trx_grab_nomor`),
  ADD KEY `trx_grab_tanggal` (`trx_grab_tanggal`),
  ADD KEY `trx_grab_status` (`trx_grab_status`);
ALTER TABLE `tbl_trx_grab` ADD FULLTEXT KEY `trx_grab_nama` (`trx_grab_nama`);

--
-- Indexes for table `tbl_trx_grab_driver`
--
ALTER TABLE `tbl_trx_grab_driver`
  ADD PRIMARY KEY (`trx_grab_driver_id`),
  ADD KEY `trx_grab_driver_kode` (`trx_grab_driver_kode`),
  ADD KEY `trx_grab_driver_user_kode` (`trx_grab_driver_user_kode`),
  ADD KEY `trx_grab_driver_nomor` (`trx_grab_driver_nomor`),
  ADD KEY `trx_grab_driver_tanggal` (`trx_grab_driver_tanggal`),
  ADD KEY `trx_grab_driver_status` (`trx_grab_driver_status`);
ALTER TABLE `tbl_trx_grab_driver` ADD FULLTEXT KEY `trx_grab_driver_nama` (`trx_grab_driver_nama`);

--
-- Indexes for table `tbl_trx_hadiah`
--
ALTER TABLE `tbl_trx_hadiah`
  ADD PRIMARY KEY (`trx_hadiah_id`),
  ADD KEY `trx_hadiah_kode` (`trx_hadiah_kode`),
  ADD KEY `trx_hadiah_user_kode` (`trx_hadiah_user_kode`),
  ADD KEY `trx_hadiah_tanggal` (`trx_hadiah_tanggal`),
  ADD KEY `trx_hadiah_jenis` (`trx_hadiah_jenis`);
ALTER TABLE `tbl_trx_hadiah` ADD FULLTEXT KEY `trx_hadiah_nama` (`trx_hadiah_nama`);

--
-- Indexes for table `tbl_trx_hp`
--
ALTER TABLE `tbl_trx_hp`
  ADD PRIMARY KEY (`trx_hp_id`),
  ADD KEY `trx_hp_tanggal` (`trx_hp_tanggal`),
  ADD KEY `trx_hp_kode` (`trx_hp_kode`),
  ADD KEY `trx_hp_user_kode` (`trx_hp_user_kode`),
  ADD KEY `trx_hp_kategori_nama` (`trx_hp_kategori_nama`),
  ADD KEY `trx_hp_kategori_kode` (`trx_hp_kategori_kode`),
  ADD KEY `trx_hp_nomor` (`trx_hp_nomor`),
  ADD KEY `trx_hp_status` (`trx_hp_status`);
ALTER TABLE `tbl_trx_hp` ADD FULLTEXT KEY `trx_hp_nama` (`trx_hp_nama`);

--
-- Indexes for table `tbl_trx_indomaret`
--
ALTER TABLE `tbl_trx_indomaret`
  ADD PRIMARY KEY (`trx_indomaret_id`),
  ADD KEY `trx_indomaret_kode` (`trx_indomaret_kode`),
  ADD KEY `trx_indomaret_user_kode` (`trx_indomaret_user_kode`),
  ADD KEY `trx_indomaret_nomor` (`trx_indomaret_nomor`),
  ADD KEY `trx_indomaret_tanggal` (`trx_indomaret_tanggal`),
  ADD KEY `trx_indomaret_status` (`trx_indomaret_status`);
ALTER TABLE `tbl_trx_indomaret` ADD FULLTEXT KEY `trx_indomaret_nama` (`trx_indomaret_nama`);

--
-- Indexes for table `tbl_trx_internet`
--
ALTER TABLE `tbl_trx_internet`
  ADD PRIMARY KEY (`trx_internet_id`),
  ADD KEY `trx_internet_tanggal` (`trx_internet_tanggal`),
  ADD KEY `trx_internet_kode` (`trx_internet_kode`),
  ADD KEY `trx_internet_user_kode` (`trx_internet_user_kode`),
  ADD KEY `trx_internet_kategori_nama` (`trx_internet_kategori_nama`),
  ADD KEY `trx_internet_nomor` (`trx_internet_nomor`),
  ADD KEY `trx_internet_status` (`trx_internet_status`);
ALTER TABLE `tbl_trx_internet` ADD FULLTEXT KEY `trx_internet_nama` (`trx_internet_nama`);

--
-- Indexes for table `tbl_trx_isaku`
--
ALTER TABLE `tbl_trx_isaku`
  ADD PRIMARY KEY (`trx_isaku_id`),
  ADD KEY `trx_isaku_kode` (`trx_isaku_kode`),
  ADD KEY `trx_isaku_user_kode` (`trx_isaku_user_kode`),
  ADD KEY `trx_isaku_nomor` (`trx_isaku_nomor`),
  ADD KEY `trx_isaku_tanggal` (`trx_isaku_tanggal`),
  ADD KEY `trx_isaku_status` (`trx_isaku_status`);
ALTER TABLE `tbl_trx_isaku` ADD FULLTEXT KEY `trx_isaku_nama` (`trx_isaku_nama`);

--
-- Indexes for table `tbl_trx_linkaja`
--
ALTER TABLE `tbl_trx_linkaja`
  ADD PRIMARY KEY (`trx_linkaja_id`),
  ADD KEY `trx_linkaja_kode` (`trx_linkaja_kode`),
  ADD KEY `trx_linkaja_user_kode` (`trx_linkaja_user_kode`),
  ADD KEY `trx_linkaja_nomor` (`trx_linkaja_nomor`),
  ADD KEY `trx_linkaja_tanggal` (`trx_linkaja_tanggal`),
  ADD KEY `trx_linkaja_status` (`trx_linkaja_status`);
ALTER TABLE `tbl_trx_linkaja` ADD FULLTEXT KEY `trx_linkaja_nama` (`trx_linkaja_nama`);

--
-- Indexes for table `tbl_trx_masa_aktif`
--
ALTER TABLE `tbl_trx_masa_aktif`
  ADD PRIMARY KEY (`trx_masa_aktif_id`),
  ADD KEY `trx_masa_aktif_kode` (`trx_masa_aktif_kode`),
  ADD KEY `trx_masa_aktif_user_kode` (`trx_masa_aktif_user_kode`),
  ADD KEY `trx_masa_aktif_operator` (`trx_masa_aktif_operator`),
  ADD KEY `trx_masa_aktif_nomor` (`trx_masa_aktif_nomor`),
  ADD KEY `trx_masa_aktif_tanggal` (`trx_masa_aktif_tanggal`),
  ADD KEY `trx_masa_aktif_status` (`trx_masa_aktif_status`);
ALTER TABLE `tbl_trx_masa_aktif` ADD FULLTEXT KEY `trx_masa_aktif_nama` (`trx_masa_aktif_nama`);

--
-- Indexes for table `tbl_trx_materai`
--
ALTER TABLE `tbl_trx_materai`
  ADD PRIMARY KEY (`trx_materai_id`),
  ADD KEY `trx_materai_kode` (`trx_materai_kode`),
  ADD KEY `trx_materai_user_kode` (`trx_materai_user_kode`),
  ADD KEY `trx_materai_nomor` (`trx_materai_nomor`),
  ADD KEY `trx_materai_tanggal` (`trx_materai_tanggal`),
  ADD KEY `trx_materai_status` (`trx_materai_status`);
ALTER TABLE `tbl_trx_materai` ADD FULLTEXT KEY `trx_materai_nama` (`trx_materai_nama`);

--
-- Indexes for table `tbl_trx_maxim`
--
ALTER TABLE `tbl_trx_maxim`
  ADD PRIMARY KEY (`trx_maxim_id`),
  ADD KEY `trx_maxim_kode` (`trx_maxim_kode`),
  ADD KEY `trx_maxim_user_kode` (`trx_maxim_user_kode`),
  ADD KEY `trx_maxim_nomor` (`trx_maxim_nomor`),
  ADD KEY `trx_maxim_tanggal` (`trx_maxim_tanggal`),
  ADD KEY `trx_maxim_status` (`trx_maxim_status`);
ALTER TABLE `tbl_trx_maxim` ADD FULLTEXT KEY `trx_maxim_nama` (`trx_maxim_nama`);

--
-- Indexes for table `tbl_trx_maxim_driver`
--
ALTER TABLE `tbl_trx_maxim_driver`
  ADD PRIMARY KEY (`trx_maxim_driver_id`),
  ADD KEY `trx_maxim_driver_kode` (`trx_maxim_driver_kode`),
  ADD KEY `trx_maxim_driver_user_kode` (`trx_maxim_driver_user_kode`),
  ADD KEY `trx_maxim_driver_nomor` (`trx_maxim_driver_nomor`),
  ADD KEY `trx_maxim_driver_tanggal` (`trx_maxim_driver_tanggal`),
  ADD KEY `trx_maxim_driver_status` (`trx_maxim_driver_status`);
ALTER TABLE `tbl_trx_maxim_driver` ADD FULLTEXT KEY `trx_maxim_driver_nama` (`trx_maxim_driver_nama`);

--
-- Indexes for table `tbl_trx_mtix`
--
ALTER TABLE `tbl_trx_mtix`
  ADD PRIMARY KEY (`trx_mtix_id`),
  ADD KEY `trx_mtix_kode` (`trx_mtix_kode`),
  ADD KEY `trx_mtix_user_kode` (`trx_mtix_user_kode`),
  ADD KEY `trx_mtix_nomor` (`trx_mtix_nomor`),
  ADD KEY `trx_mtix_tanggal` (`trx_mtix_tanggal`),
  ADD KEY `trx_mtix_status` (`trx_mtix_status`);
ALTER TABLE `tbl_trx_mtix` ADD FULLTEXT KEY `trx_mtix_nama` (`trx_mtix_nama`);

--
-- Indexes for table `tbl_trx_multifinance`
--
ALTER TABLE `tbl_trx_multifinance`
  ADD PRIMARY KEY (`trx_multifinance_id`),
  ADD KEY `trx_multifinance_kode` (`trx_multifinance_kode`),
  ADD KEY `trx_multifinance_kategori_kode` (`trx_multifinance_kategori_kode`),
  ADD KEY `trx_multifinance_kategori_nama` (`trx_multifinance_kategori_nama`),
  ADD KEY `trx_multifinance_nomor` (`trx_multifinance_nomor`),
  ADD KEY `trx_multifinance_tanggal` (`trx_multifinance_tanggal`),
  ADD KEY `trx_multifinance_status` (`trx_multifinance_status`);
ALTER TABLE `tbl_trx_multifinance` ADD FULLTEXT KEY `trx_multifinance_nama` (`trx_multifinance_nama`);

--
-- Indexes for table `tbl_trx_ovo`
--
ALTER TABLE `tbl_trx_ovo`
  ADD PRIMARY KEY (`trx_ovo_id`),
  ADD KEY `trx_ovo_kode` (`trx_ovo_kode`),
  ADD KEY `trx_ovo_user_kode` (`trx_ovo_user_kode`),
  ADD KEY `trx_ovo_nomor` (`trx_ovo_nomor`),
  ADD KEY `trx_ovo_tanggal` (`trx_ovo_tanggal`),
  ADD KEY `trx_ovo_status` (`trx_ovo_status`);
ALTER TABLE `tbl_trx_ovo` ADD FULLTEXT KEY `trx_ovo_nama` (`trx_ovo_nama`);

--
-- Indexes for table `tbl_trx_paket_data`
--
ALTER TABLE `tbl_trx_paket_data`
  ADD PRIMARY KEY (`trx_paket_data_id`),
  ADD KEY `trx_paket_data_kode` (`trx_paket_data_kode`),
  ADD KEY `trx_paket_data_user_kode` (`trx_paket_data_user_kode`),
  ADD KEY `trx_paket_data_operator` (`trx_paket_data_operator`),
  ADD KEY `trx_paket_data_nomor` (`trx_paket_data_nomor`),
  ADD KEY `trx_paket_data_tanggal` (`trx_paket_data_tanggal`),
  ADD KEY `trx_paket_data_status` (`trx_paket_data_status`);
ALTER TABLE `tbl_trx_paket_data` ADD FULLTEXT KEY `trx_paket_data_nama` (`trx_paket_data_nama`);

--
-- Indexes for table `tbl_trx_paket_nelfon`
--
ALTER TABLE `tbl_trx_paket_nelfon`
  ADD PRIMARY KEY (`trx_paket_nelfon_id`),
  ADD KEY `trx_paket_nelfon_kode` (`trx_paket_nelfon_kode`),
  ADD KEY `trx_paket_nelfon_user_kode` (`trx_paket_nelfon_user_kode`),
  ADD KEY `trx_paket_nelfon_operator` (`trx_paket_nelfon_operator`),
  ADD KEY `trx_paket_nelfon_nomor` (`trx_paket_nelfon_nomor`),
  ADD KEY `trx_paket_nelfon_tanggal` (`trx_paket_nelfon_tanggal`),
  ADD KEY `trx_paket_nelfon_status` (`trx_paket_nelfon_status`);
ALTER TABLE `tbl_trx_paket_nelfon` ADD FULLTEXT KEY `trx_paket_nelfon_nama` (`trx_paket_nelfon_nama`);

--
-- Indexes for table `tbl_trx_paket_sms`
--
ALTER TABLE `tbl_trx_paket_sms`
  ADD PRIMARY KEY (`trx_paket_sms_id`),
  ADD KEY `trx_paket_sms_kode` (`trx_paket_sms_kode`),
  ADD KEY `trx_paket_sms_user_kode` (`trx_paket_sms_user_kode`),
  ADD KEY `trx_paket_sms_operator` (`trx_paket_sms_operator`),
  ADD KEY `trx_paket_sms_nomor` (`trx_paket_sms_nomor`),
  ADD KEY `trx_paket_sms_tanggal` (`trx_paket_sms_tanggal`),
  ADD KEY `trx_paket_sms_status` (`trx_paket_sms_status`);
ALTER TABLE `tbl_trx_paket_sms` ADD FULLTEXT KEY `trx_paket_sms_nama` (`trx_paket_sms_nama`);

--
-- Indexes for table `tbl_trx_pbb`
--
ALTER TABLE `tbl_trx_pbb`
  ADD PRIMARY KEY (`trx_pbb_id`),
  ADD KEY `trx_pbb_tanggal` (`trx_pbb_tanggal`),
  ADD KEY `trx_pbb_kode` (`trx_pbb_kode`),
  ADD KEY `trx_pbb_user_kode` (`trx_pbb_user_kode`),
  ADD KEY `trx_pbb_kategori_nama` (`trx_pbb_kategori_nama`),
  ADD KEY `trx_pbb_nomor` (`trx_pbb_nomor`),
  ADD KEY `trx_pbb_status` (`trx_pbb_status`);
ALTER TABLE `tbl_trx_pbb` ADD FULLTEXT KEY `trx_pbb_nama` (`trx_pbb_nama`);

--
-- Indexes for table `tbl_trx_pdam`
--
ALTER TABLE `tbl_trx_pdam`
  ADD PRIMARY KEY (`trx_pdam_id`),
  ADD KEY `trx_pdam_tanggal` (`trx_pdam_tanggal`),
  ADD KEY `trx_pdam_kode` (`trx_pdam_kode`),
  ADD KEY `trx_pdam_user_kode` (`trx_pdam_user_kode`),
  ADD KEY `trx_pdam_kategori_nama` (`trx_pdam_kategori_nama`),
  ADD KEY `trx_pdam_nomor` (`trx_pdam_nomor`),
  ADD KEY `trx_pdam_status` (`trx_pdam_status`);
ALTER TABLE `tbl_trx_pdam` ADD FULLTEXT KEY `trx_pdam_nama` (`trx_pdam_nama`);

--
-- Indexes for table `tbl_trx_pendapatan`
--
ALTER TABLE `tbl_trx_pendapatan`
  ADD PRIMARY KEY (`trx_pendapatan_id`),
  ADD KEY `trx_pendapatan_kode` (`trx_pendapatan_kode`),
  ADD KEY `trx_pendapatan_user_kode` (`trx_pendapatan_user_kode`),
  ADD KEY `trx_pendapatan_kategori` (`trx_pendapatan_kategori`),
  ADD KEY `trx_pendapatan_tanggal` (`trx_pendapatan_tanggal`);

--
-- Indexes for table `tbl_trx_pln`
--
ALTER TABLE `tbl_trx_pln`
  ADD PRIMARY KEY (`trx_pln_id`),
  ADD KEY `trx_pln_tanggal` (`trx_pln_tanggal`),
  ADD KEY `trx_pln_kode` (`trx_pln_kode`),
  ADD KEY `trx_pln_user_kode` (`trx_pln_user_kode`),
  ADD KEY `trx_pln_nomor` (`trx_pln_nomor`),
  ADD KEY `trx_pln_status` (`trx_pln_status`);
ALTER TABLE `tbl_trx_pln` ADD FULLTEXT KEY `trx_pln_nama` (`trx_pln_nama`);

--
-- Indexes for table `tbl_trx_poin`
--
ALTER TABLE `tbl_trx_poin`
  ADD PRIMARY KEY (`trx_poin_id`),
  ADD KEY `trx_poin_kode` (`trx_poin_kode`),
  ADD KEY `trx_poin_user_kode` (`trx_poin_user_kode`),
  ADD KEY `trx_poin_tanggal` (`trx_poin_tanggal`);

--
-- Indexes for table `tbl_trx_pulsa`
--
ALTER TABLE `tbl_trx_pulsa`
  ADD PRIMARY KEY (`trx_pulsa_id`),
  ADD KEY `trx_pulsa_tanggal` (`trx_pulsa_tanggal`),
  ADD KEY `trx_pulsa_kode` (`trx_pulsa_kode`),
  ADD KEY `trx_pulsa_user_kode` (`trx_pulsa_user_kode`),
  ADD KEY `trx_pulsa_operator` (`trx_pulsa_operator`),
  ADD KEY `trx_pulsa_nomor` (`trx_pulsa_nomor`),
  ADD KEY `trx_pulsa_status` (`trx_pulsa_status`);
ALTER TABLE `tbl_trx_pulsa` ADD FULLTEXT KEY `trx_pulsa_nama` (`trx_pulsa_nama`);

--
-- Indexes for table `tbl_trx_pulsa_transfer`
--
ALTER TABLE `tbl_trx_pulsa_transfer`
  ADD PRIMARY KEY (`trx_pulsa_transfer_id`),
  ADD KEY `trx_pulsa_transfer_kode` (`trx_pulsa_transfer_kode`),
  ADD KEY `trx_pulsa_transfer_user_kode` (`trx_pulsa_transfer_user_kode`),
  ADD KEY `trx_pulsa_transfer_operator` (`trx_pulsa_transfer_operator`),
  ADD KEY `trx_pulsa_transfer_nomor` (`trx_pulsa_transfer_nomor`),
  ADD KEY `trx_pulsa_transfer_tanggal` (`trx_pulsa_transfer_tanggal`),
  ADD KEY `trx_pulsa_transfer_status` (`trx_pulsa_transfer_status`);
ALTER TABLE `tbl_trx_pulsa_transfer` ADD FULLTEXT KEY `trx_pulsa_transfer_nama` (`trx_pulsa_transfer_nama`);

--
-- Indexes for table `tbl_trx_sakuku`
--
ALTER TABLE `tbl_trx_sakuku`
  ADD PRIMARY KEY (`trx_sakuku_id`),
  ADD KEY `trx_sakuku_kode` (`trx_sakuku_kode`),
  ADD KEY `trx_sakuku_user_kode` (`trx_sakuku_user_kode`),
  ADD KEY `trx_sakuku_nomor` (`trx_sakuku_nomor`),
  ADD KEY `trx_sakuku_tanggal` (`trx_sakuku_tanggal`),
  ADD KEY `trx_sakuku_status` (`trx_sakuku_status`);
ALTER TABLE `tbl_trx_sakuku` ADD FULLTEXT KEY `trx_sakuku_nama` (`trx_sakuku_nama`);

--
-- Indexes for table `tbl_trx_shopeepay`
--
ALTER TABLE `tbl_trx_shopeepay`
  ADD PRIMARY KEY (`trx_shopeepay_id`),
  ADD KEY `trx_shopeepay_kode` (`trx_shopeepay_kode`),
  ADD KEY `trx_shopeepay_user_kode` (`trx_shopeepay_user_kode`),
  ADD KEY `trx_shopeepay_nomor` (`trx_shopeepay_nomor`),
  ADD KEY `trx_shopeepay_tanggal` (`trx_shopeepay_tanggal`),
  ADD KEY `trx_shopeepay_status` (`trx_shopeepay_status`);
ALTER TABLE `tbl_trx_shopeepay` ADD FULLTEXT KEY `trx_shopeepay_nama` (`trx_shopeepay_nama`);

--
-- Indexes for table `tbl_trx_shopee_driver`
--
ALTER TABLE `tbl_trx_shopee_driver`
  ADD PRIMARY KEY (`trx_shopee_driver_id`),
  ADD KEY `trx_shopee_driver_kode` (`trx_shopee_driver_kode`),
  ADD KEY `trx_shopee_driver_user_kode` (`trx_shopee_driver_user_kode`),
  ADD KEY `trx_shopee_driver_nomor` (`trx_shopee_driver_nomor`),
  ADD KEY `trx_shopee_driver_tanggal` (`trx_shopee_driver_tanggal`),
  ADD KEY `trx_shopee_driver_status` (`trx_shopee_driver_status`);
ALTER TABLE `tbl_trx_shopee_driver` ADD FULLTEXT KEY `trx_shopee_driver_nama` (`trx_shopee_driver_nama`);

--
-- Indexes for table `tbl_trx_spotify`
--
ALTER TABLE `tbl_trx_spotify`
  ADD PRIMARY KEY (`trx_spotify_id`),
  ADD KEY `trx_spotify_kode` (`trx_spotify_kode`),
  ADD KEY `trx_spotify_user_kode` (`trx_spotify_user_kode`),
  ADD KEY `trx_spotify_nomor` (`trx_spotify_nomor`),
  ADD KEY `trx_spotify_tanggal` (`trx_spotify_tanggal`),
  ADD KEY `trx_spotify_status` (`trx_spotify_status`);
ALTER TABLE `tbl_trx_spotify` ADD FULLTEXT KEY `trx_spotify_nama` (`trx_spotify_nama`);

--
-- Indexes for table `tbl_trx_tapcash`
--
ALTER TABLE `tbl_trx_tapcash`
  ADD PRIMARY KEY (`trx_tapcash_id`),
  ADD KEY `trx_tapcash_kode` (`trx_tapcash_kode`),
  ADD KEY `trx_tapcash_user_kode` (`trx_tapcash_user_kode`),
  ADD KEY `trx_tapcash_nomor` (`trx_tapcash_nomor`),
  ADD KEY `trx_tapcash_tanggal` (`trx_tapcash_tanggal`),
  ADD KEY `trx_tapcash_status` (`trx_tapcash_status`);
ALTER TABLE `tbl_trx_tapcash` ADD FULLTEXT KEY `trx_tapcash_nama` (`trx_tapcash_nama`);

--
-- Indexes for table `tbl_trx_tixid`
--
ALTER TABLE `tbl_trx_tixid`
  ADD PRIMARY KEY (`trx_tixid_id`),
  ADD KEY `trx_tixid_kode` (`trx_tixid_kode`),
  ADD KEY `trx_tixid_user_kode` (`trx_tixid_user_kode`),
  ADD KEY `trx_tixid_nomor` (`trx_tixid_nomor`),
  ADD KEY `trx_tixid_tanggal` (`trx_tixid_tanggal`),
  ADD KEY `trx_tixid_status` (`trx_tixid_status`);
ALTER TABLE `tbl_trx_tixid` ADD FULLTEXT KEY `trx_tixid_nama` (`trx_tixid_nama`);

--
-- Indexes for table `tbl_trx_token_pln`
--
ALTER TABLE `tbl_trx_token_pln`
  ADD PRIMARY KEY (`trx_token_pln_id`),
  ADD KEY `trx_token_pln_kode` (`trx_token_pln_kode`),
  ADD KEY `trx_token_pln_user_kode` (`trx_token_pln_user_kode`),
  ADD KEY `trx_token_pln_pelanggan_nomor` (`trx_token_pln_pelanggan_nomor`),
  ADD KEY `trx_token_pln_pelanggan_id` (`trx_token_pln_pelanggan_id`),
  ADD KEY `trx_token_pln_tanggal` (`trx_token_pln_tanggal`),
  ADD KEY `trx_token_pln_status` (`trx_token_pln_status`);
ALTER TABLE `tbl_trx_token_pln` ADD FULLTEXT KEY `trx_token_pln_pelanggan_nama` (`trx_token_pln_pelanggan_nama`);
ALTER TABLE `tbl_trx_token_pln` ADD FULLTEXT KEY `trx_token_pln_nama` (`trx_token_pln_nama`);

--
-- Indexes for table `tbl_trx_tokopedia`
--
ALTER TABLE `tbl_trx_tokopedia`
  ADD PRIMARY KEY (`trx_tokopedia_id`),
  ADD KEY `trx_tokopedia_kode` (`trx_tokopedia_kode`),
  ADD KEY `trx_tokopedia_user_kode` (`trx_tokopedia_user_kode`),
  ADD KEY `trx_tokopedia_nomor` (`trx_tokopedia_nomor`),
  ADD KEY `trx_tokopedia_tanggal` (`trx_tokopedia_tanggal`),
  ADD KEY `trx_tokopedia_status` (`trx_tokopedia_status`);
ALTER TABLE `tbl_trx_tokopedia` ADD FULLTEXT KEY `trx_tokopedia_nama` (`trx_tokopedia_nama`);

--
-- Indexes for table `tbl_trx_transaksi`
--
ALTER TABLE `tbl_trx_transaksi`
  ADD PRIMARY KEY (`trx_transaksi_id`),
  ADD KEY `trx_transaksi_kode` (`trx_transaksi_kode`),
  ADD KEY `trx_transaksi_user_kode` (`trx_transaksi_user_kode`),
  ADD KEY `trx_transaksi_kategori` (`trx_transaksi_kategori`),
  ADD KEY `trx_transaksi_nomor` (`trx_transaksi_nomor`),
  ADD KEY `trx_transaksi_tanggal` (`trx_transaksi_tanggal`),
  ADD KEY `trx_transaksi_status` (`trx_transaksi_status`);
ALTER TABLE `tbl_trx_transaksi` ADD FULLTEXT KEY `trx_transaksi_nama` (`trx_transaksi_nama`);

--
-- Indexes for table `tbl_trx_transfer`
--
ALTER TABLE `tbl_trx_transfer`
  ADD PRIMARY KEY (`trx_transfer_id`),
  ADD KEY `trx_transfer_kode` (`trx_transfer_kode`),
  ADD KEY `trx_transfer_tujuan_kode` (`trx_transfer_tujuan_kode`),
  ADD KEY `trx_transfer_tujuan_nomor` (`trx_transfer_tujuan_nomor`),
  ADD KEY `trx_transfer_tanggal` (`trx_transfer_tanggal`),
  ADD KEY `trx_transfer_status` (`trx_transfer_status`);
ALTER TABLE `tbl_trx_transfer` ADD FULLTEXT KEY `trx_transfer_tujuan_nama` (`trx_transfer_tujuan_nama`);

--
-- Indexes for table `tbl_trx_traveloka`
--
ALTER TABLE `tbl_trx_traveloka`
  ADD PRIMARY KEY (`trx_traveloka_id`),
  ADD KEY `trx_traveloka_kode` (`trx_traveloka_kode`),
  ADD KEY `trx_traveloka_user_kode` (`trx_traveloka_user_kode`),
  ADD KEY `trx_traveloka_nomor` (`trx_traveloka_nomor`),
  ADD KEY `trx_traveloka_tanggal` (`trx_traveloka_tanggal`),
  ADD KEY `trx_traveloka_status` (`trx_traveloka_status`);
ALTER TABLE `tbl_trx_traveloka` ADD FULLTEXT KEY `trx_traveloka_nama` (`trx_traveloka_nama`);

--
-- Indexes for table `tbl_trx_tv`
--
ALTER TABLE `tbl_trx_tv`
  ADD PRIMARY KEY (`trx_tv_id`),
  ADD KEY `trx_tv_tanggal` (`trx_tv_tanggal`),
  ADD KEY `trx_tv_kode` (`trx_tv_kode`),
  ADD KEY `trx_tv_user_kode` (`trx_tv_user_kode`),
  ADD KEY `trx_tv_kategori_nama` (`trx_tv_kategori_nama`),
  ADD KEY `trx_tv_nomor` (`trx_tv_nomor`),
  ADD KEY `trx_tv_status` (`trx_tv_status`);
ALTER TABLE `tbl_trx_tv` ADD FULLTEXT KEY `trx_tv_nama` (`trx_tv_nama`);

--
-- Indexes for table `tbl_trx_unipin`
--
ALTER TABLE `tbl_trx_unipin`
  ADD PRIMARY KEY (`trx_unipin_id`),
  ADD KEY `trx_unipin_kode` (`trx_unipin_kode`),
  ADD KEY `trx_unipin_user_kode` (`trx_unipin_user_kode`),
  ADD KEY `trx_unipin_nomor` (`trx_unipin_nomor`),
  ADD KEY `trx_unipin_tanggal` (`trx_unipin_tanggal`),
  ADD KEY `trx_unipin_status` (`trx_unipin_status`);
ALTER TABLE `tbl_trx_unipin` ADD FULLTEXT KEY `trx_unipin_nama` (`trx_unipin_nama`);

--
-- Indexes for table `tbl_trx_vidio`
--
ALTER TABLE `tbl_trx_vidio`
  ADD PRIMARY KEY (`trx_vidio_id`),
  ADD KEY `trx_vidio_kode` (`trx_vidio_kode`),
  ADD KEY `trx_vidio_user_kode` (`trx_vidio_user_kode`),
  ADD KEY `trx_vidio_nomor` (`trx_vidio_nomor`),
  ADD KEY `trx_vidio_tanggal` (`trx_vidio_tanggal`),
  ADD KEY `trx_vidio_status` (`trx_vidio_status`);
ALTER TABLE `tbl_trx_vidio` ADD FULLTEXT KEY `trx_vidio_nama` (`trx_vidio_nama`);

--
-- Indexes for table `tbl_trx_wifiid`
--
ALTER TABLE `tbl_trx_wifiid`
  ADD PRIMARY KEY (`trx_wifiid_id`),
  ADD KEY `trx_wifiid_kode` (`trx_wifiid_kode`),
  ADD KEY `trx_wifiid_user_kode` (`trx_wifiid_user_kode`),
  ADD KEY `trx_wifiid_nomor` (`trx_wifiid_nomor`),
  ADD KEY `trx_wifiid_tanggal` (`trx_wifiid_tanggal`),
  ADD KEY `trx_wifiid_status` (`trx_wifiid_status`);
ALTER TABLE `tbl_trx_wifiid` ADD FULLTEXT KEY `trx_wifiid_nama` (`trx_wifiid_nama`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_ktg_game`
--
ALTER TABLE `tbl_ktg_game`
  MODIFY `ktg_game_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ktg_hp`
--
ALTER TABLE `tbl_ktg_hp`
  MODIFY `ktg_hp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_ktg_internet`
--
ALTER TABLE `tbl_ktg_internet`
  MODIFY `ktg_internet_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_ktg_multifinance`
--
ALTER TABLE `tbl_ktg_multifinance`
  MODIFY `ktg_multifinance_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ktg_pbb`
--
ALTER TABLE `tbl_ktg_pbb`
  MODIFY `ktg_pbb_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ktg_pdam`
--
ALTER TABLE `tbl_ktg_pdam`
  MODIFY `ktg_pdam_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ktg_produk`
--
ALTER TABLE `tbl_ktg_produk`
  MODIFY `ktg_produk_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ktg_tv`
--
ALTER TABLE `tbl_ktg_tv`
  MODIFY `ktg_tv_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_alfamart`
--
ALTER TABLE `tbl_mst_alfamart`
  MODIFY `mst_alfamart_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tbl_mst_bonus`
--
ALTER TABLE `tbl_mst_bonus`
  MODIFY `mst_bonus_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_mst_brizzi`
--
ALTER TABLE `tbl_mst_brizzi`
  MODIFY `mst_brizzi_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_bukalapak`
--
ALTER TABLE `tbl_mst_bukalapak`
  MODIFY `mst_bukalapak_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_dana`
--
ALTER TABLE `tbl_mst_dana`
  MODIFY `mst_dana_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_deposit`
--
ALTER TABLE `tbl_mst_deposit`
  MODIFY `mst_deposit_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `tbl_mst_deposit_manual`
--
ALTER TABLE `tbl_mst_deposit_manual`
  MODIFY `mst_deposit_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_doku`
--
ALTER TABLE `tbl_mst_doku`
  MODIFY `mst_doku_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_emoney`
--
ALTER TABLE `tbl_mst_emoney`
  MODIFY `mst_emoney_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_game`
--
ALTER TABLE `tbl_mst_game`
  MODIFY `mst_game_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_gojek_driver`
--
ALTER TABLE `tbl_mst_gojek_driver`
  MODIFY `mst_gojek_driver_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_googleplay`
--
ALTER TABLE `tbl_mst_googleplay`
  MODIFY `mst_googleplay_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_gopay`
--
ALTER TABLE `tbl_mst_gopay`
  MODIFY `mst_gopay_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_grab`
--
ALTER TABLE `tbl_mst_grab`
  MODIFY `mst_grab_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_grab_driver`
--
ALTER TABLE `tbl_mst_grab_driver`
  MODIFY `mst_grab_driver_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_hadiah`
--
ALTER TABLE `tbl_mst_hadiah`
  MODIFY `mst_hadiah_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_inbox`
--
ALTER TABLE `tbl_mst_inbox`
  MODIFY `mst_inbox_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_mst_indomaret`
--
ALTER TABLE `tbl_mst_indomaret`
  MODIFY `mst_indomaret_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_isaku`
--
ALTER TABLE `tbl_mst_isaku`
  MODIFY `mst_isaku_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_limit`
--
ALTER TABLE `tbl_mst_limit`
  MODIFY `mst_limit_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tbl_mst_linkaja`
--
ALTER TABLE `tbl_mst_linkaja`
  MODIFY `mst_linkaja_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_masa_aktif`
--
ALTER TABLE `tbl_mst_masa_aktif`
  MODIFY `mst_masa_aktif_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_materai`
--
ALTER TABLE `tbl_mst_materai`
  MODIFY `mst_materai_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_maxim`
--
ALTER TABLE `tbl_mst_maxim`
  MODIFY `mst_maxim_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_maxim_driver`
--
ALTER TABLE `tbl_mst_maxim_driver`
  MODIFY `mst_maxim_driver_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_menu`
--
ALTER TABLE `tbl_mst_menu`
  MODIFY `mst_menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `tbl_mst_mtix`
--
ALTER TABLE `tbl_mst_mtix`
  MODIFY `mst_mtix_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tbl_mst_ovo`
--
ALTER TABLE `tbl_mst_ovo`
  MODIFY `mst_ovo_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_paket_data`
--
ALTER TABLE `tbl_mst_paket_data`
  MODIFY `mst_paket_data_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_paket_nelfon`
--
ALTER TABLE `tbl_mst_paket_nelfon`
  MODIFY `mst_paket_nelfon_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_paket_sms`
--
ALTER TABLE `tbl_mst_paket_sms`
  MODIFY `mst_paket_sms_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_poin`
--
ALTER TABLE `tbl_mst_poin`
  MODIFY `mst_poin_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_mst_produk`
--
ALTER TABLE `tbl_mst_produk`
  MODIFY `mst_produk_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tbl_mst_pulsa_transfer`
--
ALTER TABLE `tbl_mst_pulsa_transfer`
  MODIFY `mst_pulsa_transfer_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_sakuku`
--
ALTER TABLE `tbl_mst_sakuku`
  MODIFY `mst_sakuku_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_saldo`
--
ALTER TABLE `tbl_mst_saldo`
  MODIFY `mst_saldo_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_mst_shopeepay`
--
ALTER TABLE `tbl_mst_shopeepay`
  MODIFY `mst_shopeepay_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_shopee_driver`
--
ALTER TABLE `tbl_mst_shopee_driver`
  MODIFY `mst_shopee_driver_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_spotify`
--
ALTER TABLE `tbl_mst_spotify`
  MODIFY `mst_spotify_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_tapcash`
--
ALTER TABLE `tbl_mst_tapcash`
  MODIFY `mst_tapcash_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_tixid`
--
ALTER TABLE `tbl_mst_tixid`
  MODIFY `mst_tixid_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_token_pln`
--
ALTER TABLE `tbl_mst_token_pln`
  MODIFY `mst_token_pln_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_tokopedia`
--
ALTER TABLE `tbl_mst_tokopedia`
  MODIFY `mst_tokopedia_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_traveloka`
--
ALTER TABLE `tbl_mst_traveloka`
  MODIFY `mst_traveloka_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_unipin`
--
ALTER TABLE `tbl_mst_unipin`
  MODIFY `mst_unipin_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_update`
--
ALTER TABLE `tbl_mst_update`
  MODIFY `mst_update_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_mst_user`
--
ALTER TABLE `tbl_mst_user`
  MODIFY `mst_user_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_mst_user_log`
--
ALTER TABLE `tbl_mst_user_log`
  MODIFY `id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22962;

--
-- AUTO_INCREMENT for table `tbl_mst_vidio`
--
ALTER TABLE `tbl_mst_vidio`
  MODIFY `mst_vidio_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mst_wifiid`
--
ALTER TABLE `tbl_mst_wifiid`
  MODIFY `mst_wifiid_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_alfamart`
--
ALTER TABLE `tbl_trx_alfamart`
  MODIFY `trx_alfamart_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_bonus`
--
ALTER TABLE `tbl_trx_bonus`
  MODIFY `trx_bonus_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_bpjs`
--
ALTER TABLE `tbl_trx_bpjs`
  MODIFY `trx_bpjs_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_brizzi`
--
ALTER TABLE `tbl_trx_brizzi`
  MODIFY `trx_brizzi_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_bukalapak`
--
ALTER TABLE `tbl_trx_bukalapak`
  MODIFY `trx_bukalapak_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_dana`
--
ALTER TABLE `tbl_trx_dana`
  MODIFY `trx_dana_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_deposit`
--
ALTER TABLE `tbl_trx_deposit`
  MODIFY `trx_deposit_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_trx_doku`
--
ALTER TABLE `tbl_trx_doku`
  MODIFY `trx_doku_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_emoney`
--
ALTER TABLE `tbl_trx_emoney`
  MODIFY `trx_emoney_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_game`
--
ALTER TABLE `tbl_trx_game`
  MODIFY `trx_game_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_gas`
--
ALTER TABLE `tbl_trx_gas`
  MODIFY `trx_gas_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_gojek_driver`
--
ALTER TABLE `tbl_trx_gojek_driver`
  MODIFY `trx_gojek_driver_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_googleplay`
--
ALTER TABLE `tbl_trx_googleplay`
  MODIFY `trx_googleplay_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_gopay`
--
ALTER TABLE `tbl_trx_gopay`
  MODIFY `trx_gopay_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_grab`
--
ALTER TABLE `tbl_trx_grab`
  MODIFY `trx_grab_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_grab_driver`
--
ALTER TABLE `tbl_trx_grab_driver`
  MODIFY `trx_grab_driver_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_hadiah`
--
ALTER TABLE `tbl_trx_hadiah`
  MODIFY `trx_hadiah_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_hp`
--
ALTER TABLE `tbl_trx_hp`
  MODIFY `trx_hp_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_indomaret`
--
ALTER TABLE `tbl_trx_indomaret`
  MODIFY `trx_indomaret_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_internet`
--
ALTER TABLE `tbl_trx_internet`
  MODIFY `trx_internet_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_isaku`
--
ALTER TABLE `tbl_trx_isaku`
  MODIFY `trx_isaku_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_linkaja`
--
ALTER TABLE `tbl_trx_linkaja`
  MODIFY `trx_linkaja_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_masa_aktif`
--
ALTER TABLE `tbl_trx_masa_aktif`
  MODIFY `trx_masa_aktif_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_materai`
--
ALTER TABLE `tbl_trx_materai`
  MODIFY `trx_materai_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_maxim`
--
ALTER TABLE `tbl_trx_maxim`
  MODIFY `trx_maxim_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_maxim_driver`
--
ALTER TABLE `tbl_trx_maxim_driver`
  MODIFY `trx_maxim_driver_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_mtix`
--
ALTER TABLE `tbl_trx_mtix`
  MODIFY `trx_mtix_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_multifinance`
--
ALTER TABLE `tbl_trx_multifinance`
  MODIFY `trx_multifinance_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_ovo`
--
ALTER TABLE `tbl_trx_ovo`
  MODIFY `trx_ovo_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_paket_data`
--
ALTER TABLE `tbl_trx_paket_data`
  MODIFY `trx_paket_data_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_paket_nelfon`
--
ALTER TABLE `tbl_trx_paket_nelfon`
  MODIFY `trx_paket_nelfon_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_paket_sms`
--
ALTER TABLE `tbl_trx_paket_sms`
  MODIFY `trx_paket_sms_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_pbb`
--
ALTER TABLE `tbl_trx_pbb`
  MODIFY `trx_pbb_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_pdam`
--
ALTER TABLE `tbl_trx_pdam`
  MODIFY `trx_pdam_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_pendapatan`
--
ALTER TABLE `tbl_trx_pendapatan`
  MODIFY `trx_pendapatan_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_trx_pln`
--
ALTER TABLE `tbl_trx_pln`
  MODIFY `trx_pln_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_poin`
--
ALTER TABLE `tbl_trx_poin`
  MODIFY `trx_poin_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_trx_pulsa`
--
ALTER TABLE `tbl_trx_pulsa`
  MODIFY `trx_pulsa_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `tbl_trx_pulsa_transfer`
--
ALTER TABLE `tbl_trx_pulsa_transfer`
  MODIFY `trx_pulsa_transfer_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_sakuku`
--
ALTER TABLE `tbl_trx_sakuku`
  MODIFY `trx_sakuku_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_shopeepay`
--
ALTER TABLE `tbl_trx_shopeepay`
  MODIFY `trx_shopeepay_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_shopee_driver`
--
ALTER TABLE `tbl_trx_shopee_driver`
  MODIFY `trx_shopee_driver_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_spotify`
--
ALTER TABLE `tbl_trx_spotify`
  MODIFY `trx_spotify_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_tapcash`
--
ALTER TABLE `tbl_trx_tapcash`
  MODIFY `trx_tapcash_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_tixid`
--
ALTER TABLE `tbl_trx_tixid`
  MODIFY `trx_tixid_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_token_pln`
--
ALTER TABLE `tbl_trx_token_pln`
  MODIFY `trx_token_pln_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_tokopedia`
--
ALTER TABLE `tbl_trx_tokopedia`
  MODIFY `trx_tokopedia_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_transaksi`
--
ALTER TABLE `tbl_trx_transaksi`
  MODIFY `trx_transaksi_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `tbl_trx_transfer`
--
ALTER TABLE `tbl_trx_transfer`
  MODIFY `trx_transfer_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_traveloka`
--
ALTER TABLE `tbl_trx_traveloka`
  MODIFY `trx_traveloka_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_tv`
--
ALTER TABLE `tbl_trx_tv`
  MODIFY `trx_tv_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_unipin`
--
ALTER TABLE `tbl_trx_unipin`
  MODIFY `trx_unipin_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_vidio`
--
ALTER TABLE `tbl_trx_vidio`
  MODIFY `trx_vidio_id` double NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_trx_wifiid`
--
ALTER TABLE `tbl_trx_wifiid`
  MODIFY `trx_wifiid_id` double NOT NULL AUTO_INCREMENT;
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 */;