/*
SQLyog Ultimate v12.5.1 (64 bit)
MySQL - 10.1.38-MariaDB : Database - db_arifahpulsa_api
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_arifahpulsa_api` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `db_arifahpulsa_api`;

/*Table structure for table `tbl_ktg_game` */


CREATE TABLE `tbl_ktg_game` (
  `ktg_game_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`ktg_game_id`),
  KEY `ktg_game_status` (`ktg_game_status`),
  KEY `ktg_game_kode` (`ktg_game_kode`),
  FULLTEXT KEY `ktg_game_nama` (`ktg_game_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_ktg_game` */

/*Table structure for table `tbl_ktg_hp` */


CREATE TABLE `tbl_ktg_hp` (
  `ktg_hp_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`ktg_hp_id`),
  KEY `ktg_hp_status` (`ktg_hp_status`),
  KEY `ktg_hp_kode` (`ktg_hp_kode`),
  FULLTEXT KEY `ktg_hp_nama` (`ktg_hp_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_ktg_hp` */

/*Table structure for table `tbl_ktg_internet` */


CREATE TABLE `tbl_ktg_internet` (
  `ktg_internet_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`ktg_internet_id`),
  KEY `ktg_internet_status` (`ktg_internet_status`),
  KEY `ktg_internet_kode` (`ktg_internet_kode`),
  FULLTEXT KEY `ktg_internet_nama` (`ktg_internet_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_ktg_internet` */

/*Table structure for table `tbl_ktg_multifinance` */


CREATE TABLE `tbl_ktg_multifinance` (
  `ktg_multifinance_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`ktg_multifinance_id`),
  KEY `ktg_multifinance_status` (`ktg_multifinance_status`),
  KEY `ktg_multifinance_kode` (`ktg_multifinance_kode`),
  FULLTEXT KEY `ktg_multifinance_nama` (`ktg_multifinance_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_ktg_multifinance` */

/*Table structure for table `tbl_ktg_pbb` */


CREATE TABLE `tbl_ktg_pbb` (
  `ktg_pbb_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`ktg_pbb_id`),
  KEY `ktg_pbb_status` (`ktg_pbb_status`),
  KEY `ktg_pbb_kode` (`ktg_pbb_kode`),
  FULLTEXT KEY `ktg_pbb_nama` (`ktg_pbb_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_ktg_pbb` */

/*Table structure for table `tbl_ktg_pdam` */


CREATE TABLE `tbl_ktg_pdam` (
  `ktg_pdam_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`ktg_pdam_id`),
  KEY `ktg_pdam_kode` (`ktg_pdam_kode`),
  KEY `ktg_pdam_status` (`ktg_pdam_status`),
  FULLTEXT KEY `ktg_pdam_nama` (`ktg_pdam_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_ktg_pdam` */

/*Table structure for table `tbl_ktg_produk` */


CREATE TABLE `tbl_ktg_produk` (
  `ktg_produk_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`ktg_produk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tbl_ktg_produk` */

/*Table structure for table `tbl_ktg_tv` */


CREATE TABLE `tbl_ktg_tv` (
  `ktg_tv_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`ktg_tv_id`),
  KEY `ktg_tv_kode` (`ktg_tv_kode`),
  KEY `ktg_tv_status` (`ktg_tv_status`),
  FULLTEXT KEY `ktg_tv_nama` (`ktg_tv_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_ktg_tv` */

/*Table structure for table `tbl_mst_alfamart` */


CREATE TABLE `tbl_mst_alfamart` (
  `mst_alfamart_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_alfamart_id`),
  KEY `mst_alfamart_kode` (`mst_alfamart_kode`),
  KEY `mst_alfamart_status` (`mst_alfamart_status`),
  KEY `mst_alfamart_urutan` (`mst_alfamart_urutan`),
  FULLTEXT KEY `mst_alfamart_nama` (`mst_alfamart_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_alfamart` */

/*Table structure for table `tbl_mst_banner` */


CREATE TABLE `tbl_mst_banner` (
  `mst_banner_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  `mst_banner_link` text,
  `mst_banner_status` enum('0','1') DEFAULT NULL,
  PRIMARY KEY (`mst_banner_id`),
  KEY `mst_banner_kode` (`mst_banner_kode`),
  KEY `mst_banner_status` (`mst_banner_status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the 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.jpg','Kuota XL Murah Meriah','Yuk beli paket data XL termurah disini','','0'),
(2,'BANNER-002','PAKET NELFON','Gambar','','KTG-BANNER-002.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 AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`mst_bonus_id`),
  KEY `mst_bonus_kode` (`mst_bonus_kode`),
  KEY `mst_bonus_status` (`mst_bonus_status`),
  FULLTEXT KEY `mst_bonus_nama` (`mst_bonus_nama`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

/*Data for the 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 AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_brizzi_id`),
  KEY `mst_brizzi_kode` (`mst_brizzi_kode`),
  KEY `mst_brizzi_urutan` (`mst_brizzi_urutan`),
  KEY `mst_brizzi_status` (`mst_brizzi_status`),
  FULLTEXT KEY `mst_brizzi_nama` (`mst_brizzi_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_brizzi` */

/*Table structure for table `tbl_mst_bukalapak` */


CREATE TABLE `tbl_mst_bukalapak` (
  `mst_bukalapak_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_bukalapak_id`),
  KEY `mst_bukalapak_kode` (`mst_bukalapak_kode`),
  KEY `mst_bukalapak_urutan` (`mst_bukalapak_urutan`),
  KEY `mst_bukalapak_status` (`mst_bukalapak_status`),
  FULLTEXT KEY `mst_bukalapak_nama` (`mst_bukalapak_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_bukalapak` */

/*Table structure for table `tbl_mst_dana` */


CREATE TABLE `tbl_mst_dana` (
  `mst_dana_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_dana_id`),
  KEY `mst_dana_kode` (`mst_dana_kode`),
  KEY `mst_dana_urutan` (`mst_dana_urutan`),
  KEY `mst_dana_status` (`mst_dana_status`),
  FULLTEXT KEY `mst_dana_nama` (`mst_dana_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_dana` */

/*Table structure for table `tbl_mst_deposit` */


CREATE TABLE `tbl_mst_deposit` (
  `mst_deposit_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`mst_deposit_id`),
  KEY `mst_deposit_kode` (`mst_deposit_kode`),
  KEY `mst_deposit_status` (`mst_deposit_status`),
  KEY `mst_deposit_persen` (`mst_deposit_persen`),
  KEY `mst_deposit_admin` (`mst_deposit_admin`),
  FULLTEXT KEY `mst_deposit_nama` (`mst_deposit_nama`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;

/*Data for the 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 AUTO_INCREMENT,
  `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,
  `mst_deposit_status` enum('0','1') DEFAULT NULL,
  PRIMARY KEY (`mst_deposit_id`),
  KEY `mst_deposit_kode` (`mst_deposit_kode`),
  KEY `mst_deposit_status` (`mst_deposit_status`),
  KEY `mst_deposit_persen` (`mst_deposit_nomor_rekening`),
  KEY `mst_deposit_admin` (`mst_deposit_admin`),
  FULLTEXT KEY `mst_deposit_nama` (`mst_deposit_nama_bank`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_deposit_manual` */

/*Table structure for table `tbl_mst_doku` */


CREATE TABLE `tbl_mst_doku` (
  `mst_doku_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_doku_id`),
  KEY `mst_doku_kode` (`mst_doku_kode`),
  KEY `mst_doku_urutan` (`mst_doku_urutan`),
  KEY `mst_doku_status` (`mst_doku_status`),
  FULLTEXT KEY `mst_doku_nama` (`mst_doku_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_doku` */

/*Table structure for table `tbl_mst_emoney` */


CREATE TABLE `tbl_mst_emoney` (
  `mst_emoney_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_emoney_id`),
  KEY `mst_emoney_kode` (`mst_emoney_kode`),
  KEY `mst_emoney_urutan` (`mst_emoney_urutan`),
  KEY `mst_emoney_status` (`mst_emoney_status`),
  FULLTEXT KEY `mst_emoney_nama` (`mst_emoney_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_emoney` */

/*Table structure for table `tbl_mst_game` */


CREATE TABLE `tbl_mst_game` (
  `mst_game_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_game_id`),
  KEY `mst_game_kode` (`mst_game_kode`),
  KEY `mst_game_kategori` (`mst_game_kategori`),
  KEY `mst_game_urutan` (`mst_game_urutan`),
  KEY `mst_game_status` (`mst_game_status`),
  FULLTEXT KEY `mst_game_nama` (`mst_game_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_game` */

/*Table structure for table `tbl_mst_gojek_driver` */


CREATE TABLE `tbl_mst_gojek_driver` (
  `mst_gojek_driver_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_gojek_driver_id`),
  KEY `mst_gojek_driver_kode` (`mst_gojek_driver_kode`),
  KEY `mst_gojek_driver_urutan` (`mst_gojek_driver_urutan`),
  KEY `mst_gojek_driver_status` (`mst_gojek_driver_status`),
  FULLTEXT KEY `mst_gojek_driver_nama` (`mst_gojek_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_gojek_driver` */

/*Table structure for table `tbl_mst_googleplay` */


CREATE TABLE `tbl_mst_googleplay` (
  `mst_googleplay_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_googleplay_id`),
  KEY `mst_googleplay_kode` (`mst_googleplay_kode`),
  KEY `mst_googleplay_urutan` (`mst_googleplay_urutan`),
  KEY `mst_googleplay_status` (`mst_googleplay_status`),
  FULLTEXT KEY `mst_googleplay_nama` (`mst_googleplay_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_googleplay` */

/*Table structure for table `tbl_mst_gopay` */


CREATE TABLE `tbl_mst_gopay` (
  `mst_gopay_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_gopay_id`),
  KEY `mst_gopay_kode` (`mst_gopay_kode`),
  KEY `mst_gopay_urutan` (`mst_gopay_urutan`),
  KEY `mst_gopay_status` (`mst_gopay_status`),
  FULLTEXT KEY `mst_gopay_nama` (`mst_gopay_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_gopay` */

/*Table structure for table `tbl_mst_grab` */


CREATE TABLE `tbl_mst_grab` (
  `mst_grab_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_grab_id`),
  KEY `mst_grab_kode` (`mst_grab_kode`),
  KEY `mst_grab_urutan` (`mst_grab_urutan`),
  KEY `mst_grab_status` (`mst_grab_status`),
  FULLTEXT KEY `mst_grab_nama` (`mst_grab_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_grab` */

/*Table structure for table `tbl_mst_grab_driver` */


CREATE TABLE `tbl_mst_grab_driver` (
  `mst_grab_driver_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_grab_driver_id`),
  KEY `mst_grab_driver_kode` (`mst_grab_driver_kode`),
  KEY `mst_grab_driver_urutan` (`mst_grab_driver_urutan`),
  KEY `mst_grab_driver_status` (`mst_grab_driver_status`),
  FULLTEXT KEY `mst_grab_driver_nama` (`mst_grab_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_grab_driver` */

/*Table structure for table `tbl_mst_hadiah` */


CREATE TABLE `tbl_mst_hadiah` (
  `mst_hadiah_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  `mst_hadiah_status` enum('0','1') DEFAULT NULL,
  PRIMARY KEY (`mst_hadiah_id`),
  KEY `mst_hadiah_kode` (`mst_hadiah_kode`),
  KEY `mst_hadiah_periode_awal` (`mst_hadiah_periode_awal`),
  KEY `mst_hadiah_periode_akhir` (`mst_hadiah_periode_akhir`),
  KEY `mst_hadiah_status` (`mst_hadiah_status`),
  FULLTEXT KEY `mst_hadiah_nama` (`mst_hadiah_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_hadiah` */

/*Table structure for table `tbl_mst_inbox` */


CREATE TABLE `tbl_mst_inbox` (
  `mst_inbox_id` int(11) NOT NULL AUTO_INCREMENT,
  `mst_inbox_kode` varchar(100) DEFAULT NULL,
  `mst_inbox_user_kode` longtext,
  `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,
  `mst_inbox_tanggal` datetime DEFAULT NULL,
  `mst_inbox_jangka_waktu` int(11) DEFAULT '1',
  `mst_inbox_status` enum('0','1') DEFAULT NULL,
  PRIMARY KEY (`mst_inbox_id`),
  KEY `mst_inbox_kode` (`mst_inbox_kode`),
  KEY `mst_inbox_tanggal` (`mst_inbox_tanggal`),
  KEY `mst_inbox_status` (`mst_inbox_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_inbox` */

/*Table structure for table `tbl_mst_indomaret` */


CREATE TABLE `tbl_mst_indomaret` (
  `mst_indomaret_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_indomaret_id`),
  KEY `mst_indomaret_kode` (`mst_indomaret_kode`),
  KEY `mst_indomaret_urutan` (`mst_indomaret_urutan`),
  KEY `mst_indomaret_status` (`mst_indomaret_status`),
  FULLTEXT KEY `mst_indomaret_nama` (`mst_indomaret_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_indomaret` */

/*Table structure for table `tbl_mst_isaku` */


CREATE TABLE `tbl_mst_isaku` (
  `mst_isaku_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_isaku_id`),
  KEY `mst_isaku_kode` (`mst_isaku_kode`),
  KEY `mst_isaku_urutan` (`mst_isaku_urutan`),
  KEY `mst_isaku_status` (`mst_isaku_status`),
  FULLTEXT KEY `mst_isaku_nama` (`mst_isaku_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_mst_linkaja` */


CREATE TABLE `tbl_mst_linkaja` (
  `mst_linkaja_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_linkaja_id`),
  KEY `mst_linkaja_kode` (`mst_linkaja_kode`),
  KEY `mst_linkaja_urutan` (`mst_linkaja_urutan`),
  KEY `mst_linkaja_status` (`mst_linkaja_status`),
  FULLTEXT KEY `mst_linkaja_nama` (`mst_linkaja_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_linkaja` */

/*Table structure for table `tbl_mst_masa_aktif` */


CREATE TABLE `tbl_mst_masa_aktif` (
  `mst_masa_aktif_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_masa_aktif_id`),
  KEY `mst_masa_aktif_kode` (`mst_masa_aktif_kode`),
  KEY `mst_masa_aktif_operator` (`mst_masa_aktif_operator`),
  KEY `mst_masa_aktif_urutan` (`mst_masa_aktif_urutan`),
  KEY `mst_masa_aktif_status` (`mst_masa_aktif_status`),
  FULLTEXT KEY `mst_masa_aktif_nama` (`mst_masa_aktif_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_masa_aktif` */

/*Table structure for table `tbl_mst_materai` */


CREATE TABLE `tbl_mst_materai` (
  `mst_materai_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_materai_id`),
  KEY `mst_materai_kode` (`mst_materai_kode`),
  KEY `mst_materai_urutan` (`mst_materai_urutan`),
  KEY `mst_materai_status` (`mst_materai_status`),
  FULLTEXT KEY `mst_materai_nama` (`mst_materai_nama`),
  FULLTEXT KEY `mst_materai_keterangan` (`mst_materai_keterangan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_materai` */

/*Table structure for table `tbl_mst_maxim` */


CREATE TABLE `tbl_mst_maxim` (
  `mst_maxim_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_maxim_id`),
  KEY `mst_maxim_kode` (`mst_maxim_kode`),
  KEY `mst_maxim_urutan` (`mst_maxim_urutan`),
  KEY `mst_maxim_status` (`mst_maxim_status`),
  FULLTEXT KEY `mst_maxim_nama` (`mst_maxim_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_maxim` */

/*Table structure for table `tbl_mst_maxim_driver` */


CREATE TABLE `tbl_mst_maxim_driver` (
  `mst_maxim_driver_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_maxim_driver_id`),
  KEY `mst_maxim_driver_kode` (`mst_maxim_driver_kode`),
  KEY `mst_maxim_driver_urutan` (`mst_maxim_driver_urutan`),
  KEY `mst_maxim_driver_status` (`mst_maxim_driver_status`),
  FULLTEXT KEY `mst_maxim_driver_nama` (`mst_maxim_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_maxim_driver` */

/*Table structure for table `tbl_mst_menu` */


CREATE TABLE `tbl_mst_menu` (
  `mst_menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_menu_id`),
  KEY `mst_menu_kode` (`mst_menu_kode`),
  KEY `mst_menu_grup` (`mst_menu_grup`),
  KEY `mst_menu_urutan` (`mst_menu_urutan`),
  KEY `mst_menu_status` (`mst_menu_status`),
  FULLTEXT KEY `mst_menu_nama` (`mst_menu_nama`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

/*Data for the 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 AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_mtix_id`),
  KEY `mst_mtix_kode` (`mst_mtix_kode`),
  KEY `mst_mtix_urutan` (`mst_mtix_urutan`),
  KEY `mst_mtix_status` (`mst_mtix_status`),
  FULLTEXT KEY `mst_mtix_nama` (`mst_mtix_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_mtix` */

/*Table structure for table `tbl_mst_notifikasi` */


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

/*Data for the table `tbl_mst_notifikasi` */

insert  into `tbl_mst_notifikasi`(`mst_notifikasi_id`,`mst_notifikasi_judul`,`mst_notifikasi_isi`) values 
(1,'arifahpulsa','Transaksi lancar dan aman'),
(2,'arifahpulsa','Jangan Lupa untuk Membayar tagihan PLN, BPJS, dan tagihan lainnya menggunakan Arifah Pulsa dan raih poin sebanyak banyaknya');

/*Table structure for table `tbl_mst_ovo` */


CREATE TABLE `tbl_mst_ovo` (
  `mst_ovo_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_ovo_id`),
  KEY `mst_ovo_kode` (`mst_ovo_kode`),
  KEY `mst_ovo_urutan` (`mst_ovo_urutan`),
  KEY `mst_ovo_status` (`mst_ovo_status`),
  FULLTEXT KEY `mst_ovo_nama` (`mst_ovo_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_ovo` */

/*Table structure for table `tbl_mst_paket_data` */


CREATE TABLE `tbl_mst_paket_data` (
  `mst_paket_data_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_paket_data_id`),
  KEY `mst_paket_data_kode` (`mst_paket_data_kode`),
  KEY `mst_paket_data_operator` (`mst_paket_data_operator`),
  KEY `mst_paket_data_urutan` (`mst_paket_data_urutan`),
  KEY `mst_paket_data_status` (`mst_paket_data_status`),
  FULLTEXT KEY `mst_paket_data_nama` (`mst_paket_data_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_paket_data` */

/*Table structure for table `tbl_mst_paket_nelfon` */


CREATE TABLE `tbl_mst_paket_nelfon` (
  `mst_paket_nelfon_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_paket_nelfon_id`),
  KEY `mst_paket_nelfon_kode` (`mst_paket_nelfon_kode`),
  KEY `mst_paket_nelfon_operator` (`mst_paket_nelfon_operator`),
  KEY `mst_paket_nelfon_urutan` (`mst_paket_nelfon_urutan`),
  KEY `mst_paket_nelfon_status` (`mst_paket_nelfon_status`),
  FULLTEXT KEY `mst_paket_nelfon_nama` (`mst_paket_nelfon_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_paket_nelfon` */

/*Table structure for table `tbl_mst_paket_sms` */


CREATE TABLE `tbl_mst_paket_sms` (
  `mst_paket_sms_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_paket_sms_id`),
  KEY `mst_paket_sms_kode` (`mst_paket_sms_kode`),
  KEY `mst_paket_sms_operator` (`mst_paket_sms_operator`),
  KEY `mst_paket_sms_urutan` (`mst_paket_sms_urutan`),
  KEY `mst_paket_sms_status` (`mst_paket_sms_status`),
  FULLTEXT KEY `mst_paket_sms_nama` (`mst_paket_sms_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_paket_sms` */

/*Table structure for table `tbl_mst_poin` */


CREATE TABLE `tbl_mst_poin` (
  `mst_poin_id` double NOT NULL AUTO_INCREMENT,
  `mst_poin_kode` varchar(100) DEFAULT NULL,
  `mst_poin_user_kode` varchar(100) DEFAULT NULL,
  `mst_poin_jumlah` double DEFAULT NULL,
  PRIMARY KEY (`mst_poin_id`),
  KEY `mst_poin_kode` (`mst_poin_kode`),
  KEY `mst_poin_user_kode` (`mst_poin_user_kode`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the 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);

/*Table structure for table `tbl_mst_produk` */


CREATE TABLE `tbl_mst_produk` (
  `mst_produk_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  `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',
  PRIMARY KEY (`mst_produk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tbl_mst_produk` */

/*Table structure for table `tbl_mst_pulsa` */


CREATE TABLE `tbl_mst_pulsa` (
  `mst_pulsa_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_pulsa_id`),
  KEY `mst_pulsa_kode` (`mst_pulsa_kode`),
  KEY `mst_pulsa_operator` (`mst_pulsa_operator`),
  KEY `mst_pulsa_urutan` (`mst_pulsa_urutan`),
  KEY `mst_pulsa_status` (`mst_pulsa_status`),
  FULLTEXT KEY `mst_pulsa_nama` (`mst_pulsa_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_pulsa` */

/*Table structure for table `tbl_mst_pulsa_transfer` */


CREATE TABLE `tbl_mst_pulsa_transfer` (
  `mst_pulsa_transfer_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_pulsa_transfer_id`),
  KEY `mst_pulsa_transfer_kode` (`mst_pulsa_transfer_kode`),
  KEY `mst_pulsa_transfer_operator` (`mst_pulsa_transfer_operator`),
  KEY `mst_pulsa_transfer_urutan` (`mst_pulsa_transfer_urutan`),
  KEY `mst_pulsa_transfer_status` (`mst_pulsa_transfer_status`),
  FULLTEXT KEY `mst_pulsa_transfer_nama` (`mst_pulsa_transfer_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_pulsa_transfer` */

/*Table structure for table `tbl_mst_sakuku` */


CREATE TABLE `tbl_mst_sakuku` (
  `mst_sakuku_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_sakuku_id`),
  KEY `mst_sakuku_kode` (`mst_sakuku_kode`),
  KEY `mst_sakuku_urutan` (`mst_sakuku_urutan`),
  KEY `mst_sakuku_status` (`mst_sakuku_status`),
  FULLTEXT KEY `mst_sakuku_nama` (`mst_sakuku_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_sakuku` */

/*Table structure for table `tbl_mst_saldo` */


CREATE TABLE `tbl_mst_saldo` (
  `mst_saldo_id` double NOT NULL AUTO_INCREMENT,
  `mst_saldo_kode` varchar(100) DEFAULT NULL,
  `mst_saldo_user_kode` varchar(100) DEFAULT NULL,
  `mst_saldo_jumlah` double DEFAULT NULL,
  PRIMARY KEY (`mst_saldo_id`),
  KEY `mst_saldo_kode` (`mst_saldo_kode`),
  KEY `mst_saldo_user_kode` (`mst_saldo_user_kode`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the 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);

/*Table structure for table `tbl_mst_shopee_driver` */


CREATE TABLE `tbl_mst_shopee_driver` (
  `mst_shopee_driver_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_shopee_driver_id`),
  KEY `mst_shopee_driver_kode` (`mst_shopee_driver_kode`),
  KEY `mst_shopee_driver_urutan` (`mst_shopee_driver_urutan`),
  KEY `mst_shopee_driver_status` (`mst_shopee_driver_status`),
  FULLTEXT KEY `mst_shopee_driver_nama` (`mst_shopee_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_shopee_driver` */

/*Table structure for table `tbl_mst_shopeepay` */


CREATE TABLE `tbl_mst_shopeepay` (
  `mst_shopeepay_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_shopeepay_id`),
  KEY `mst_shopeepay_kode` (`mst_shopeepay_kode`),
  KEY `mst_shopeepay_urutan` (`mst_shopeepay_urutan`),
  KEY `mst_shopeepay_status` (`mst_shopeepay_status`),
  FULLTEXT KEY `mst_shopeepay_nama` (`mst_shopeepay_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_shopeepay` */

/*Table structure for table `tbl_mst_spotify` */


CREATE TABLE `tbl_mst_spotify` (
  `mst_spotify_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_spotify_id`),
  KEY `mst_spotify_kode` (`mst_spotify_kode`),
  KEY `mst_spotify_urutan` (`mst_spotify_urutan`),
  KEY `mst_spotify_status` (`mst_spotify_status`),
  FULLTEXT KEY `mst_spotify_nama` (`mst_spotify_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_spotify` */

/*Table structure for table `tbl_mst_tapcash` */


CREATE TABLE `tbl_mst_tapcash` (
  `mst_tapcash_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_tapcash_id`),
  KEY `mst_tapcash_kode` (`mst_tapcash_kode`),
  KEY `mst_tapcash_urutan` (`mst_tapcash_urutan`),
  KEY `mst_tapcash_status` (`mst_tapcash_status`),
  FULLTEXT KEY `mst_tapcash_nama` (`mst_tapcash_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_tapcash` */

/*Table structure for table `tbl_mst_tixid` */


CREATE TABLE `tbl_mst_tixid` (
  `mst_tixid_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_tixid_id`),
  KEY `mst_tixid_kode` (`mst_tixid_kode`),
  KEY `mst_tixid_urutan` (`mst_tixid_urutan`),
  KEY `mst_tixid_status` (`mst_tixid_status`),
  FULLTEXT KEY `mst_tixid_nama` (`mst_tixid_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_tixid` */

/*Table structure for table `tbl_mst_token_pln` */


CREATE TABLE `tbl_mst_token_pln` (
  `mst_token_pln_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_token_pln_id`),
  KEY `mst_token_pln_kode` (`mst_token_pln_kode`),
  KEY `mst_token_pln_urutan` (`mst_token_pln_urutan`),
  KEY `mst_token_pln_status` (`mst_token_pln_status`),
  FULLTEXT KEY `mst_token_pln_nama` (`mst_token_pln_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_token_pln` */

/*Table structure for table `tbl_mst_tokopedia` */


CREATE TABLE `tbl_mst_tokopedia` (
  `mst_tokopedia_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_tokopedia_id`),
  KEY `mst_tokopedia_kode` (`mst_tokopedia_kode`),
  KEY `mst_tokopedia_urutan` (`mst_tokopedia_urutan`),
  KEY `mst_tokopedia_status` (`mst_tokopedia_status`),
  FULLTEXT KEY `mst_tokopedia_nama` (`mst_tokopedia_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_tokopedia` */

/*Table structure for table `tbl_mst_traveloka` */


CREATE TABLE `tbl_mst_traveloka` (
  `mst_traveloka_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_traveloka_id`),
  KEY `mst_traveloka_kode` (`mst_traveloka_kode`),
  KEY `mst_traveloka_urutan` (`mst_traveloka_urutan`),
  KEY `mst_traveloka_status` (`mst_traveloka_status`),
  FULLTEXT KEY `mst_traveloka_nama` (`mst_traveloka_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_traveloka` */

/*Table structure for table `tbl_mst_unipin` */


CREATE TABLE `tbl_mst_unipin` (
  `mst_unipin_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_unipin_id`),
  KEY `mst_unipin_kode` (`mst_unipin_kode`),
  KEY `mst_unipin_urutan` (`mst_unipin_urutan`),
  KEY `mst_unipin_status` (`mst_unipin_status`),
  FULLTEXT KEY `mst_unipin_nama` (`mst_unipin_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_unipin` */

/*Table structure for table `tbl_mst_update` */


CREATE TABLE `tbl_mst_update` (
  `mst_update_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_update_id`),
  KEY `mst_update_kode` (`mst_update_kode`),
  KEY `mst_update_status` (`mst_update_status`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the 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_vidio` */


CREATE TABLE `tbl_mst_vidio` (
  `mst_vidio_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_vidio_id`),
  KEY `mst_vidio_kode` (`mst_vidio_kode`),
  KEY `mst_vidio_urutan` (`mst_vidio_urutan`),
  KEY `mst_vidio_status` (`mst_vidio_status`),
  FULLTEXT KEY `mst_vidio_nama` (`mst_vidio_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_vidio` */

/*Table structure for table `tbl_mst_wifiid` */


CREATE TABLE `tbl_mst_wifiid` (
  `mst_wifiid_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`mst_wifiid_id`),
  KEY `mst_wifiid_kode` (`mst_wifiid_kode`),
  KEY `mst_wifiid_urutan` (`mst_wifiid_urutan`),
  KEY `mst_wifiid_status` (`mst_wifiid_status`),
  FULLTEXT KEY `mst_wifiid_nama` (`mst_wifiid_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_mst_wifiid` */

/*Table structure for table `tbl_trx_alfamart` */


CREATE TABLE `tbl_trx_alfamart` (
  `trx_alfamart_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_alfamart_id`),
  KEY `trx_alfamart_kode` (`trx_alfamart_kode`),
  KEY `trx_alfamart_user_kode` (`trx_alfamart_user_kode`),
  KEY `trx_alfamart_nomor` (`trx_alfamart_nomor`),
  KEY `trx_alfamart_tanggal` (`trx_alfamart_tanggal`),
  KEY `trx_alfamart_status` (`trx_alfamart_status`),
  FULLTEXT KEY `trx_alfamart_nama` (`trx_alfamart_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_alfamart` */

/*Table structure for table `tbl_trx_bonus` */


CREATE TABLE `tbl_trx_bonus` (
  `trx_bonus_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_bonus_id`),
  KEY `trx_bonus_kode` (`trx_bonus_kode`),
  KEY `trx_bonus_user_kode` (`trx_bonus_user_kode`),
  KEY `trx_bonus_tanggal` (`trx_bonus_tanggal`),
  KEY `trx_bonus_status` (`trx_bonus_status`),
  FULLTEXT KEY `trx_bonus_nama` (`trx_bonus_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_bonus` */

/*Table structure for table `tbl_trx_bpjs` */


CREATE TABLE `tbl_trx_bpjs` (
  `trx_bpjs_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_bpjs_id`),
  KEY `trx_bpjs_tanggal` (`trx_bpjs_tanggal`),
  KEY `trx_bpjs_kode` (`trx_bpjs_kode`),
  KEY `trx_bpjs_user_kode` (`trx_bpjs_user_kode`),
  KEY `trx_bpjs_nomor` (`trx_bpjs_nomor`),
  KEY `trx_bpjs_status` (`trx_bpjs_status`),
  KEY `trx_bpjs_tanggal_2` (`trx_bpjs_tanggal`),
  FULLTEXT KEY `trx_bpjs_nama` (`trx_bpjs_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_bpjs` */

/*Table structure for table `tbl_trx_brizzi` */


CREATE TABLE `tbl_trx_brizzi` (
  `trx_brizzi_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_brizzi_id`),
  KEY `trx_brizzi_kode` (`trx_brizzi_kode`),
  KEY `trx_brizzi_user_kode` (`trx_brizzi_user_kode`),
  KEY `trx_brizzi_nomor` (`trx_brizzi_nomor`),
  KEY `trx_brizzi_tanggal` (`trx_brizzi_tanggal`),
  KEY `trx_brizzi_status` (`trx_brizzi_status`),
  FULLTEXT KEY `trx_brizzi_nama` (`trx_brizzi_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_brizzi` */

/*Table structure for table `tbl_trx_bukalapak` */


CREATE TABLE `tbl_trx_bukalapak` (
  `trx_bukalapak_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_bukalapak_id`),
  KEY `trx_bukalapak_kode` (`trx_bukalapak_kode`),
  KEY `trx_bukalapak_user_kode` (`trx_bukalapak_user_kode`),
  KEY `trx_bukalapak_nomor` (`trx_bukalapak_nomor`),
  KEY `trx_bukalapak_tanggal` (`trx_bukalapak_tanggal`),
  KEY `trx_bukalapak_status` (`trx_bukalapak_status`),
  FULLTEXT KEY `trx_bukalapak_nama` (`trx_bukalapak_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_bukalapak` */

/*Table structure for table `tbl_trx_dana` */


CREATE TABLE `tbl_trx_dana` (
  `trx_dana_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_dana_id`),
  KEY `trx_dana_kode` (`trx_dana_kode`),
  KEY `trx_dana_user_kode` (`trx_dana_user_kode`),
  KEY `trx_dana_nomor` (`trx_dana_nomor`),
  KEY `trx_dana_tanggal` (`trx_dana_tanggal`),
  KEY `trx_dana_status` (`trx_dana_status`),
  FULLTEXT KEY `trx_dana_nama` (`trx_dana_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_dana` */

/*Table structure for table `tbl_trx_deposit` */


CREATE TABLE `tbl_trx_deposit` (
  `trx_deposit_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_deposit_id`),
  KEY `trx_deposit_kode` (`trx_deposit_kode`),
  KEY `trx_deposit_user_kode` (`trx_deposit_user_kode`),
  KEY `trx_deposit_tripay_reference` (`trx_deposit_tripay_reference`),
  KEY `trx_deposit_tanggal` (`trx_deposit_tanggal`),
  KEY `trx_deposit_metode` (`trx_deposit_metode`),
  KEY `trx_deposit_status` (`trx_deposit_status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tbl_trx_deposit` */

/*Table structure for table `tbl_trx_doku` */


CREATE TABLE `tbl_trx_doku` (
  `trx_doku_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_doku_id`),
  KEY `trx_doku_kode` (`trx_doku_kode`),
  KEY `trx_doku_user_kode` (`trx_doku_user_kode`),
  KEY `trx_doku_nomor` (`trx_doku_nomor`),
  KEY `trx_doku_tanggal` (`trx_doku_tanggal`),
  KEY `trx_doku_status` (`trx_doku_status`),
  FULLTEXT KEY `trx_doku_nama` (`trx_doku_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_doku` */

/*Table structure for table `tbl_trx_emoney` */


CREATE TABLE `tbl_trx_emoney` (
  `trx_emoney_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_emoney_id`),
  KEY `trx_emoney_kode` (`trx_emoney_kode`),
  KEY `trx_emoney_user_kode` (`trx_emoney_user_kode`),
  KEY `trx_emoney_nomor` (`trx_emoney_nomor`),
  KEY `trx_emoney_tanggal` (`trx_emoney_tanggal`),
  KEY `trx_emoney_status` (`trx_emoney_status`),
  FULLTEXT KEY `trx_emoney_nama` (`trx_emoney_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_emoney` */

/*Table structure for table `tbl_trx_game` */


CREATE TABLE `tbl_trx_game` (
  `trx_game_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_game_id`),
  KEY `trx_game_kode` (`trx_game_kode`),
  KEY `trx_game_user_kode` (`trx_game_user_kode`),
  KEY `trx_game_kategori` (`trx_game_kategori`),
  KEY `trx_game_nomor` (`trx_game_nomor`),
  KEY `trx_game_tanggal` (`trx_game_tanggal`),
  KEY `trx_game_status` (`trx_game_status`),
  FULLTEXT KEY `trx_game_nama` (`trx_game_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_game` */

/*Table structure for table `tbl_trx_gas` */


CREATE TABLE `tbl_trx_gas` (
  `trx_gas_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_gas_id`),
  KEY `trx_gas_tanggal` (`trx_gas_tanggal`),
  KEY `trx_gas_kode` (`trx_gas_kode`),
  KEY `trx_gas_user_kode` (`trx_gas_user_kode`),
  KEY `trx_gas_nomor` (`trx_gas_nomor`),
  KEY `trx_gas_status` (`trx_gas_status`),
  FULLTEXT KEY `trx_gas_nama` (`trx_gas_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_gas` */

/*Table structure for table `tbl_trx_gojek_driver` */


CREATE TABLE `tbl_trx_gojek_driver` (
  `trx_gojek_driver_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_gojek_driver_id`),
  KEY `trx_gojek_driver_kode` (`trx_gojek_driver_kode`),
  KEY `trx_gojek_driver_user_kode` (`trx_gojek_driver_user_kode`),
  KEY `trx_gojek_driver_nomor` (`trx_gojek_driver_nomor`),
  KEY `trx_gojek_driver_tanggal` (`trx_gojek_driver_tanggal`),
  KEY `trx_gojek_driver_status` (`trx_gojek_driver_status`),
  FULLTEXT KEY `trx_gojek_driver_nama` (`trx_gojek_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_gojek_driver` */

/*Table structure for table `tbl_trx_googleplay` */


CREATE TABLE `tbl_trx_googleplay` (
  `trx_googleplay_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_googleplay_id`),
  KEY `trx_googleplay_kode` (`trx_googleplay_kode`),
  KEY `trx_googleplay_user_kode` (`trx_googleplay_user_kode`),
  KEY `trx_googleplay_nomor` (`trx_googleplay_nomor`),
  KEY `trx_googleplay_tanggal` (`trx_googleplay_tanggal`),
  KEY `trx_googleplay_status` (`trx_googleplay_status`),
  FULLTEXT KEY `trx_googleplay_nama` (`trx_googleplay_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_googleplay` */

/*Table structure for table `tbl_trx_gopay` */


CREATE TABLE `tbl_trx_gopay` (
  `trx_gopay_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_gopay_id`),
  KEY `trx_gopay_tanggal` (`trx_gopay_tanggal`),
  KEY `trx_gopay_kode` (`trx_gopay_kode`),
  KEY `trx_gopay_user_kode` (`trx_gopay_user_kode`),
  KEY `trx_gopay_nomor` (`trx_gopay_nomor`),
  KEY `trx_gopay_status` (`trx_gopay_status`),
  FULLTEXT KEY `trx_gopay_nama` (`trx_gopay_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_gopay` */

/*Table structure for table `tbl_trx_grab` */


CREATE TABLE `tbl_trx_grab` (
  `trx_grab_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_grab_id`),
  KEY `trx_grab_kode` (`trx_grab_kode`),
  KEY `trx_grab_user_kode` (`trx_grab_user_kode`),
  KEY `trx_grab_nomor` (`trx_grab_nomor`),
  KEY `trx_grab_tanggal` (`trx_grab_tanggal`),
  KEY `trx_grab_status` (`trx_grab_status`),
  FULLTEXT KEY `trx_grab_nama` (`trx_grab_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_grab` */

/*Table structure for table `tbl_trx_grab_driver` */


CREATE TABLE `tbl_trx_grab_driver` (
  `trx_grab_driver_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_grab_driver_id`),
  KEY `trx_grab_driver_kode` (`trx_grab_driver_kode`),
  KEY `trx_grab_driver_user_kode` (`trx_grab_driver_user_kode`),
  KEY `trx_grab_driver_nomor` (`trx_grab_driver_nomor`),
  KEY `trx_grab_driver_tanggal` (`trx_grab_driver_tanggal`),
  KEY `trx_grab_driver_status` (`trx_grab_driver_status`),
  FULLTEXT KEY `trx_grab_driver_nama` (`trx_grab_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_grab_driver` */

/*Table structure for table `tbl_trx_hadiah` */


CREATE TABLE `tbl_trx_hadiah` (
  `trx_hadiah_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_hadiah_id`),
  KEY `trx_hadiah_kode` (`trx_hadiah_kode`),
  KEY `trx_hadiah_user_kode` (`trx_hadiah_user_kode`),
  KEY `trx_hadiah_tanggal` (`trx_hadiah_tanggal`),
  KEY `trx_hadiah_jenis` (`trx_hadiah_jenis`),
  FULLTEXT KEY `trx_hadiah_nama` (`trx_hadiah_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_hadiah` */

/*Table structure for table `tbl_trx_hp` */


CREATE TABLE `tbl_trx_hp` (
  `trx_hp_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_hp_id`),
  KEY `trx_hp_tanggal` (`trx_hp_tanggal`),
  KEY `trx_hp_kode` (`trx_hp_kode`),
  KEY `trx_hp_user_kode` (`trx_hp_user_kode`),
  KEY `trx_hp_kategori_nama` (`trx_hp_kategori_nama`),
  KEY `trx_hp_kategori_kode` (`trx_hp_kategori_kode`),
  KEY `trx_hp_nomor` (`trx_hp_nomor`),
  KEY `trx_hp_status` (`trx_hp_status`),
  FULLTEXT KEY `trx_hp_nama` (`trx_hp_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_hp` */

/*Table structure for table `tbl_trx_indomaret` */


CREATE TABLE `tbl_trx_indomaret` (
  `trx_indomaret_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_indomaret_id`),
  KEY `trx_indomaret_kode` (`trx_indomaret_kode`),
  KEY `trx_indomaret_user_kode` (`trx_indomaret_user_kode`),
  KEY `trx_indomaret_nomor` (`trx_indomaret_nomor`),
  KEY `trx_indomaret_tanggal` (`trx_indomaret_tanggal`),
  KEY `trx_indomaret_status` (`trx_indomaret_status`),
  FULLTEXT KEY `trx_indomaret_nama` (`trx_indomaret_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_indomaret` */

/*Table structure for table `tbl_trx_internet` */


CREATE TABLE `tbl_trx_internet` (
  `trx_internet_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_internet_id`),
  KEY `trx_internet_tanggal` (`trx_internet_tanggal`),
  KEY `trx_internet_kode` (`trx_internet_kode`),
  KEY `trx_internet_user_kode` (`trx_internet_user_kode`),
  KEY `trx_internet_kategori_nama` (`trx_internet_kategori_nama`),
  KEY `trx_internet_nomor` (`trx_internet_nomor`),
  KEY `trx_internet_status` (`trx_internet_status`),
  FULLTEXT KEY `trx_internet_nama` (`trx_internet_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_internet` */

/*Table structure for table `tbl_trx_isaku` */


CREATE TABLE `tbl_trx_isaku` (
  `trx_isaku_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_isaku_id`),
  KEY `trx_isaku_kode` (`trx_isaku_kode`),
  KEY `trx_isaku_user_kode` (`trx_isaku_user_kode`),
  KEY `trx_isaku_nomor` (`trx_isaku_nomor`),
  KEY `trx_isaku_tanggal` (`trx_isaku_tanggal`),
  KEY `trx_isaku_status` (`trx_isaku_status`),
  FULLTEXT KEY `trx_isaku_nama` (`trx_isaku_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_isaku` */

/*Table structure for table `tbl_trx_linkaja` */


CREATE TABLE `tbl_trx_linkaja` (
  `trx_linkaja_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_linkaja_id`),
  KEY `trx_linkaja_kode` (`trx_linkaja_kode`),
  KEY `trx_linkaja_user_kode` (`trx_linkaja_user_kode`),
  KEY `trx_linkaja_nomor` (`trx_linkaja_nomor`),
  KEY `trx_linkaja_tanggal` (`trx_linkaja_tanggal`),
  KEY `trx_linkaja_status` (`trx_linkaja_status`),
  FULLTEXT KEY `trx_linkaja_nama` (`trx_linkaja_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_linkaja` */

/*Table structure for table `tbl_trx_masa_aktif` */


CREATE TABLE `tbl_trx_masa_aktif` (
  `trx_masa_aktif_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_masa_aktif_id`),
  KEY `trx_masa_aktif_kode` (`trx_masa_aktif_kode`),
  KEY `trx_masa_aktif_user_kode` (`trx_masa_aktif_user_kode`),
  KEY `trx_masa_aktif_operator` (`trx_masa_aktif_operator`),
  KEY `trx_masa_aktif_nomor` (`trx_masa_aktif_nomor`),
  KEY `trx_masa_aktif_tanggal` (`trx_masa_aktif_tanggal`),
  KEY `trx_masa_aktif_status` (`trx_masa_aktif_status`),
  FULLTEXT KEY `trx_masa_aktif_nama` (`trx_masa_aktif_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_masa_aktif` */

/*Table structure for table `tbl_trx_materai` */


CREATE TABLE `tbl_trx_materai` (
  `trx_materai_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_materai_id`),
  KEY `trx_materai_kode` (`trx_materai_kode`),
  KEY `trx_materai_user_kode` (`trx_materai_user_kode`),
  KEY `trx_materai_nomor` (`trx_materai_nomor`),
  KEY `trx_materai_tanggal` (`trx_materai_tanggal`),
  KEY `trx_materai_status` (`trx_materai_status`),
  FULLTEXT KEY `trx_materai_nama` (`trx_materai_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_materai` */

/*Table structure for table `tbl_trx_maxim` */


CREATE TABLE `tbl_trx_maxim` (
  `trx_maxim_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_maxim_id`),
  KEY `trx_maxim_kode` (`trx_maxim_kode`),
  KEY `trx_maxim_user_kode` (`trx_maxim_user_kode`),
  KEY `trx_maxim_nomor` (`trx_maxim_nomor`),
  KEY `trx_maxim_tanggal` (`trx_maxim_tanggal`),
  KEY `trx_maxim_status` (`trx_maxim_status`),
  FULLTEXT KEY `trx_maxim_nama` (`trx_maxim_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_maxim` */

/*Table structure for table `tbl_trx_maxim_driver` */


CREATE TABLE `tbl_trx_maxim_driver` (
  `trx_maxim_driver_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_maxim_driver_id`),
  KEY `trx_maxim_driver_kode` (`trx_maxim_driver_kode`),
  KEY `trx_maxim_driver_user_kode` (`trx_maxim_driver_user_kode`),
  KEY `trx_maxim_driver_nomor` (`trx_maxim_driver_nomor`),
  KEY `trx_maxim_driver_tanggal` (`trx_maxim_driver_tanggal`),
  KEY `trx_maxim_driver_status` (`trx_maxim_driver_status`),
  FULLTEXT KEY `trx_maxim_driver_nama` (`trx_maxim_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_maxim_driver` */

/*Table structure for table `tbl_trx_mtix` */


CREATE TABLE `tbl_trx_mtix` (
  `trx_mtix_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_mtix_id`),
  KEY `trx_mtix_kode` (`trx_mtix_kode`),
  KEY `trx_mtix_user_kode` (`trx_mtix_user_kode`),
  KEY `trx_mtix_nomor` (`trx_mtix_nomor`),
  KEY `trx_mtix_tanggal` (`trx_mtix_tanggal`),
  KEY `trx_mtix_status` (`trx_mtix_status`),
  FULLTEXT KEY `trx_mtix_nama` (`trx_mtix_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_mtix` */

/*Table structure for table `tbl_trx_multifinance` */


CREATE TABLE `tbl_trx_multifinance` (
  `trx_multifinance_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_multifinance_id`),
  KEY `trx_multifinance_kode` (`trx_multifinance_kode`),
  KEY `trx_multifinance_kategori_kode` (`trx_multifinance_kategori_kode`),
  KEY `trx_multifinance_kategori_nama` (`trx_multifinance_kategori_nama`),
  KEY `trx_multifinance_nomor` (`trx_multifinance_nomor`),
  KEY `trx_multifinance_tanggal` (`trx_multifinance_tanggal`),
  KEY `trx_multifinance_status` (`trx_multifinance_status`),
  FULLTEXT KEY `trx_multifinance_nama` (`trx_multifinance_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_multifinance` */

/*Table structure for table `tbl_trx_ovo` */


CREATE TABLE `tbl_trx_ovo` (
  `trx_ovo_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_ovo_id`),
  KEY `trx_ovo_kode` (`trx_ovo_kode`),
  KEY `trx_ovo_user_kode` (`trx_ovo_user_kode`),
  KEY `trx_ovo_nomor` (`trx_ovo_nomor`),
  KEY `trx_ovo_tanggal` (`trx_ovo_tanggal`),
  KEY `trx_ovo_status` (`trx_ovo_status`),
  FULLTEXT KEY `trx_ovo_nama` (`trx_ovo_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_ovo` */

/*Table structure for table `tbl_trx_paket_data` */


CREATE TABLE `tbl_trx_paket_data` (
  `trx_paket_data_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_paket_data_id`),
  KEY `trx_paket_data_kode` (`trx_paket_data_kode`),
  KEY `trx_paket_data_user_kode` (`trx_paket_data_user_kode`),
  KEY `trx_paket_data_operator` (`trx_paket_data_operator`),
  KEY `trx_paket_data_nomor` (`trx_paket_data_nomor`),
  KEY `trx_paket_data_tanggal` (`trx_paket_data_tanggal`),
  KEY `trx_paket_data_status` (`trx_paket_data_status`),
  FULLTEXT KEY `trx_paket_data_nama` (`trx_paket_data_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_paket_data` */

/*Table structure for table `tbl_trx_paket_nelfon` */


CREATE TABLE `tbl_trx_paket_nelfon` (
  `trx_paket_nelfon_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_paket_nelfon_id`),
  KEY `trx_paket_nelfon_kode` (`trx_paket_nelfon_kode`),
  KEY `trx_paket_nelfon_user_kode` (`trx_paket_nelfon_user_kode`),
  KEY `trx_paket_nelfon_operator` (`trx_paket_nelfon_operator`),
  KEY `trx_paket_nelfon_nomor` (`trx_paket_nelfon_nomor`),
  KEY `trx_paket_nelfon_tanggal` (`trx_paket_nelfon_tanggal`),
  KEY `trx_paket_nelfon_status` (`trx_paket_nelfon_status`),
  FULLTEXT KEY `trx_paket_nelfon_nama` (`trx_paket_nelfon_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_paket_nelfon` */

/*Table structure for table `tbl_trx_paket_sms` */


CREATE TABLE `tbl_trx_paket_sms` (
  `trx_paket_sms_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_paket_sms_id`),
  KEY `trx_paket_sms_kode` (`trx_paket_sms_kode`),
  KEY `trx_paket_sms_user_kode` (`trx_paket_sms_user_kode`),
  KEY `trx_paket_sms_operator` (`trx_paket_sms_operator`),
  KEY `trx_paket_sms_nomor` (`trx_paket_sms_nomor`),
  KEY `trx_paket_sms_tanggal` (`trx_paket_sms_tanggal`),
  KEY `trx_paket_sms_status` (`trx_paket_sms_status`),
  FULLTEXT KEY `trx_paket_sms_nama` (`trx_paket_sms_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_paket_sms` */

/*Table structure for table `tbl_trx_pbb` */


CREATE TABLE `tbl_trx_pbb` (
  `trx_pbb_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_pbb_id`),
  KEY `trx_pbb_tanggal` (`trx_pbb_tanggal`),
  KEY `trx_pbb_kode` (`trx_pbb_kode`),
  KEY `trx_pbb_user_kode` (`trx_pbb_user_kode`),
  KEY `trx_pbb_kategori_nama` (`trx_pbb_kategori_nama`),
  KEY `trx_pbb_nomor` (`trx_pbb_nomor`),
  KEY `trx_pbb_status` (`trx_pbb_status`),
  FULLTEXT KEY `trx_pbb_nama` (`trx_pbb_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_pbb` */

/*Table structure for table `tbl_trx_pdam` */


CREATE TABLE `tbl_trx_pdam` (
  `trx_pdam_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_pdam_id`),
  KEY `trx_pdam_tanggal` (`trx_pdam_tanggal`),
  KEY `trx_pdam_kode` (`trx_pdam_kode`),
  KEY `trx_pdam_user_kode` (`trx_pdam_user_kode`),
  KEY `trx_pdam_kategori_nama` (`trx_pdam_kategori_nama`),
  KEY `trx_pdam_nomor` (`trx_pdam_nomor`),
  KEY `trx_pdam_status` (`trx_pdam_status`),
  FULLTEXT KEY `trx_pdam_nama` (`trx_pdam_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_pdam` */

/*Table structure for table `tbl_trx_pendapatan` */


CREATE TABLE `tbl_trx_pendapatan` (
  `trx_pendapatan_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_pendapatan_id`),
  KEY `trx_pendapatan_kode` (`trx_pendapatan_kode`),
  KEY `trx_pendapatan_user_kode` (`trx_pendapatan_user_kode`),
  KEY `trx_pendapatan_kategori` (`trx_pendapatan_kategori`),
  KEY `trx_pendapatan_tanggal` (`trx_pendapatan_tanggal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_pendapatan` */

/*Table structure for table `tbl_trx_pln` */


CREATE TABLE `tbl_trx_pln` (
  `trx_pln_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_pln_id`),
  KEY `trx_pln_tanggal` (`trx_pln_tanggal`),
  KEY `trx_pln_kode` (`trx_pln_kode`),
  KEY `trx_pln_user_kode` (`trx_pln_user_kode`),
  KEY `trx_pln_nomor` (`trx_pln_nomor`),
  KEY `trx_pln_status` (`trx_pln_status`),
  FULLTEXT KEY `trx_pln_nama` (`trx_pln_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_pln` */

/*Table structure for table `tbl_trx_poin` */


CREATE TABLE `tbl_trx_poin` (
  `trx_poin_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_poin_id`),
  KEY `trx_poin_kode` (`trx_poin_kode`),
  KEY `trx_poin_user_kode` (`trx_poin_user_kode`),
  KEY `trx_poin_tanggal` (`trx_poin_tanggal`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tbl_trx_poin` */

/*Table structure for table `tbl_trx_pulsa` */


CREATE TABLE `tbl_trx_pulsa` (
  `trx_pulsa_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_pulsa_id`),
  KEY `trx_pulsa_tanggal` (`trx_pulsa_tanggal`),
  KEY `trx_pulsa_kode` (`trx_pulsa_kode`),
  KEY `trx_pulsa_user_kode` (`trx_pulsa_user_kode`),
  KEY `trx_pulsa_operator` (`trx_pulsa_operator`),
  KEY `trx_pulsa_nomor` (`trx_pulsa_nomor`),
  KEY `trx_pulsa_status` (`trx_pulsa_status`),
  FULLTEXT KEY `trx_pulsa_nama` (`trx_pulsa_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_pulsa` */

/*Table structure for table `tbl_trx_pulsa_transfer` */


CREATE TABLE `tbl_trx_pulsa_transfer` (
  `trx_pulsa_transfer_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_pulsa_transfer_id`),
  KEY `trx_pulsa_transfer_kode` (`trx_pulsa_transfer_kode`),
  KEY `trx_pulsa_transfer_user_kode` (`trx_pulsa_transfer_user_kode`),
  KEY `trx_pulsa_transfer_operator` (`trx_pulsa_transfer_operator`),
  KEY `trx_pulsa_transfer_nomor` (`trx_pulsa_transfer_nomor`),
  KEY `trx_pulsa_transfer_tanggal` (`trx_pulsa_transfer_tanggal`),
  KEY `trx_pulsa_transfer_status` (`trx_pulsa_transfer_status`),
  FULLTEXT KEY `trx_pulsa_transfer_nama` (`trx_pulsa_transfer_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_pulsa_transfer` */

/*Table structure for table `tbl_trx_sakuku` */


CREATE TABLE `tbl_trx_sakuku` (
  `trx_sakuku_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_sakuku_id`),
  KEY `trx_sakuku_kode` (`trx_sakuku_kode`),
  KEY `trx_sakuku_user_kode` (`trx_sakuku_user_kode`),
  KEY `trx_sakuku_nomor` (`trx_sakuku_nomor`),
  KEY `trx_sakuku_tanggal` (`trx_sakuku_tanggal`),
  KEY `trx_sakuku_status` (`trx_sakuku_status`),
  FULLTEXT KEY `trx_sakuku_nama` (`trx_sakuku_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_sakuku` */

/*Table structure for table `tbl_trx_shopee_driver` */


CREATE TABLE `tbl_trx_shopee_driver` (
  `trx_shopee_driver_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_shopee_driver_id`),
  KEY `trx_shopee_driver_kode` (`trx_shopee_driver_kode`),
  KEY `trx_shopee_driver_user_kode` (`trx_shopee_driver_user_kode`),
  KEY `trx_shopee_driver_nomor` (`trx_shopee_driver_nomor`),
  KEY `trx_shopee_driver_tanggal` (`trx_shopee_driver_tanggal`),
  KEY `trx_shopee_driver_status` (`trx_shopee_driver_status`),
  FULLTEXT KEY `trx_shopee_driver_nama` (`trx_shopee_driver_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_shopee_driver` */

/*Table structure for table `tbl_trx_shopeepay` */


CREATE TABLE `tbl_trx_shopeepay` (
  `trx_shopeepay_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_shopeepay_id`),
  KEY `trx_shopeepay_kode` (`trx_shopeepay_kode`),
  KEY `trx_shopeepay_user_kode` (`trx_shopeepay_user_kode`),
  KEY `trx_shopeepay_nomor` (`trx_shopeepay_nomor`),
  KEY `trx_shopeepay_tanggal` (`trx_shopeepay_tanggal`),
  KEY `trx_shopeepay_status` (`trx_shopeepay_status`),
  FULLTEXT KEY `trx_shopeepay_nama` (`trx_shopeepay_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_shopeepay` */

/*Table structure for table `tbl_trx_spotify` */


CREATE TABLE `tbl_trx_spotify` (
  `trx_spotify_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_spotify_id`),
  KEY `trx_spotify_kode` (`trx_spotify_kode`),
  KEY `trx_spotify_user_kode` (`trx_spotify_user_kode`),
  KEY `trx_spotify_nomor` (`trx_spotify_nomor`),
  KEY `trx_spotify_tanggal` (`trx_spotify_tanggal`),
  KEY `trx_spotify_status` (`trx_spotify_status`),
  FULLTEXT KEY `trx_spotify_nama` (`trx_spotify_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_spotify` */

/*Table structure for table `tbl_trx_tapcash` */


CREATE TABLE `tbl_trx_tapcash` (
  `trx_tapcash_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_tapcash_id`),
  KEY `trx_tapcash_kode` (`trx_tapcash_kode`),
  KEY `trx_tapcash_user_kode` (`trx_tapcash_user_kode`),
  KEY `trx_tapcash_nomor` (`trx_tapcash_nomor`),
  KEY `trx_tapcash_tanggal` (`trx_tapcash_tanggal`),
  KEY `trx_tapcash_status` (`trx_tapcash_status`),
  FULLTEXT KEY `trx_tapcash_nama` (`trx_tapcash_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_tapcash` */

/*Table structure for table `tbl_trx_tixid` */


CREATE TABLE `tbl_trx_tixid` (
  `trx_tixid_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_tixid_id`),
  KEY `trx_tixid_kode` (`trx_tixid_kode`),
  KEY `trx_tixid_user_kode` (`trx_tixid_user_kode`),
  KEY `trx_tixid_nomor` (`trx_tixid_nomor`),
  KEY `trx_tixid_tanggal` (`trx_tixid_tanggal`),
  KEY `trx_tixid_status` (`trx_tixid_status`),
  FULLTEXT KEY `trx_tixid_nama` (`trx_tixid_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_tixid` */

/*Table structure for table `tbl_trx_token_pln` */


CREATE TABLE `tbl_trx_token_pln` (
  `trx_token_pln_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_token_pln_id`),
  KEY `trx_token_pln_kode` (`trx_token_pln_kode`),
  KEY `trx_token_pln_user_kode` (`trx_token_pln_user_kode`),
  KEY `trx_token_pln_pelanggan_nomor` (`trx_token_pln_pelanggan_nomor`),
  KEY `trx_token_pln_pelanggan_id` (`trx_token_pln_pelanggan_id`),
  KEY `trx_token_pln_tanggal` (`trx_token_pln_tanggal`),
  KEY `trx_token_pln_status` (`trx_token_pln_status`),
  FULLTEXT KEY `trx_token_pln_pelanggan_nama` (`trx_token_pln_pelanggan_nama`),
  FULLTEXT KEY `trx_token_pln_nama` (`trx_token_pln_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_token_pln` */

/*Table structure for table `tbl_trx_tokopedia` */


CREATE TABLE `tbl_trx_tokopedia` (
  `trx_tokopedia_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_tokopedia_id`),
  KEY `trx_tokopedia_kode` (`trx_tokopedia_kode`),
  KEY `trx_tokopedia_user_kode` (`trx_tokopedia_user_kode`),
  KEY `trx_tokopedia_nomor` (`trx_tokopedia_nomor`),
  KEY `trx_tokopedia_tanggal` (`trx_tokopedia_tanggal`),
  KEY `trx_tokopedia_status` (`trx_tokopedia_status`),
  FULLTEXT KEY `trx_tokopedia_nama` (`trx_tokopedia_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_tokopedia` */

/*Table structure for table `tbl_trx_transaksi` */


CREATE TABLE `tbl_trx_transaksi` (
  `trx_transaksi_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_transaksi_id`),
  KEY `trx_transaksi_kode` (`trx_transaksi_kode`),
  KEY `trx_transaksi_user_kode` (`trx_transaksi_user_kode`),
  KEY `trx_transaksi_kategori` (`trx_transaksi_kategori`),
  KEY `trx_transaksi_nomor` (`trx_transaksi_nomor`),
  KEY `trx_transaksi_tanggal` (`trx_transaksi_tanggal`),
  KEY `trx_transaksi_status` (`trx_transaksi_status`),
  FULLTEXT KEY `trx_transaksi_nama` (`trx_transaksi_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tbl_trx_transaksi` */

/*Table structure for table `tbl_trx_transfer` */


CREATE TABLE `tbl_trx_transfer` (
  `trx_transfer_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_transfer_id`),
  KEY `trx_transfer_kode` (`trx_transfer_kode`),
  KEY `trx_transfer_tujuan_kode` (`trx_transfer_tujuan_kode`),
  KEY `trx_transfer_tujuan_nomor` (`trx_transfer_tujuan_nomor`),
  KEY `trx_transfer_tanggal` (`trx_transfer_tanggal`),
  KEY `trx_transfer_status` (`trx_transfer_status`),
  FULLTEXT KEY `trx_transfer_tujuan_nama` (`trx_transfer_tujuan_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_transfer` */

/*Table structure for table `tbl_trx_traveloka` */


CREATE TABLE `tbl_trx_traveloka` (
  `trx_traveloka_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_traveloka_id`),
  KEY `trx_traveloka_kode` (`trx_traveloka_kode`),
  KEY `trx_traveloka_user_kode` (`trx_traveloka_user_kode`),
  KEY `trx_traveloka_nomor` (`trx_traveloka_nomor`),
  KEY `trx_traveloka_tanggal` (`trx_traveloka_tanggal`),
  KEY `trx_traveloka_status` (`trx_traveloka_status`),
  FULLTEXT KEY `trx_traveloka_nama` (`trx_traveloka_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_traveloka` */

/*Table structure for table `tbl_trx_tv` */


CREATE TABLE `tbl_trx_tv` (
  `trx_tv_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_tv_id`),
  KEY `trx_tv_tanggal` (`trx_tv_tanggal`),
  KEY `trx_tv_kode` (`trx_tv_kode`),
  KEY `trx_tv_user_kode` (`trx_tv_user_kode`),
  KEY `trx_tv_kategori_nama` (`trx_tv_kategori_nama`),
  KEY `trx_tv_nomor` (`trx_tv_nomor`),
  KEY `trx_tv_status` (`trx_tv_status`),
  FULLTEXT KEY `trx_tv_nama` (`trx_tv_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_tv` */

/*Table structure for table `tbl_trx_unipin` */


CREATE TABLE `tbl_trx_unipin` (
  `trx_unipin_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_unipin_id`),
  KEY `trx_unipin_kode` (`trx_unipin_kode`),
  KEY `trx_unipin_user_kode` (`trx_unipin_user_kode`),
  KEY `trx_unipin_nomor` (`trx_unipin_nomor`),
  KEY `trx_unipin_tanggal` (`trx_unipin_tanggal`),
  KEY `trx_unipin_status` (`trx_unipin_status`),
  FULLTEXT KEY `trx_unipin_nama` (`trx_unipin_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_unipin` */

/*Table structure for table `tbl_trx_vidio` */


CREATE TABLE `tbl_trx_vidio` (
  `trx_vidio_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_vidio_id`),
  KEY `trx_vidio_kode` (`trx_vidio_kode`),
  KEY `trx_vidio_user_kode` (`trx_vidio_user_kode`),
  KEY `trx_vidio_nomor` (`trx_vidio_nomor`),
  KEY `trx_vidio_tanggal` (`trx_vidio_tanggal`),
  KEY `trx_vidio_status` (`trx_vidio_status`),
  FULLTEXT KEY `trx_vidio_nama` (`trx_vidio_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_vidio` */

/*Table structure for table `tbl_trx_wifiid` */


CREATE TABLE `tbl_trx_wifiid` (
  `trx_wifiid_id` double NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`trx_wifiid_id`),
  KEY `trx_wifiid_kode` (`trx_wifiid_kode`),
  KEY `trx_wifiid_user_kode` (`trx_wifiid_user_kode`),
  KEY `trx_wifiid_nomor` (`trx_wifiid_nomor`),
  KEY `trx_wifiid_tanggal` (`trx_wifiid_tanggal`),
  KEY `trx_wifiid_status` (`trx_wifiid_status`),
  FULLTEXT KEY `trx_wifiid_nama` (`trx_wifiid_nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_trx_wifiid` */

