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

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_arifahpulsa_admin` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `db_arifahpulsa_admin`;

/*Table structure for table `tbl_mst_akses` */

DROP TABLE IF EXISTS `tbl_mst_akses`;

CREATE TABLE `tbl_mst_akses` (
  `mst_akses_id` int(11) NOT NULL AUTO_INCREMENT,
  `mst_akses_menu_id` int(11) DEFAULT NULL,
  `mst_akses_petugas_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`mst_akses_id`),
  KEY `hakaksesmenuid` (`mst_akses_menu_id`),
  KEY `hakaksespetugasid` (`mst_akses_petugas_id`),
  CONSTRAINT `tbl_mst_akses_ibfk_1` FOREIGN KEY (`mst_akses_menu_id`) REFERENCES `tbl_mst_menu` (`mst_menu_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tbl_mst_akses_ibfk_2` FOREIGN KEY (`mst_akses_petugas_id`) REFERENCES `tbl_mst_petugas` (`mst_petugas_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_mst_akses` */

insert  into `tbl_mst_akses`(`mst_akses_id`,`mst_akses_menu_id`,`mst_akses_petugas_id`) values 
(1,1000,1),
(2,250000,1),
(4,250002,1),
(7,250001,1),
(8,50000,1),
(9,60000,1),
(11,50020,1),
(12,60100,1),
(13,2000,1),
(14,8000,1),
(15,9000,1),
(16,7000,1),
(17,8500,1),
(18,4000,1),
(19,70000,1),
(20,5000,1),
(21,6000,1),
(22,50011,1),
(24,50010,1),
(26,50012,1),
(27,50013,1),
(28,50021,1),
(29,50022,1),
(30,50023,1),
(31,50030,1),
(32,50031,1),
(33,50032,1),
(34,50033,1),
(35,50040,1),
(36,50041,1),
(37,50042,1),
(38,50043,1),
(39,50050,1),
(40,50051,1),
(41,50052,1),
(42,50053,1),
(43,50060,1),
(44,50061,1),
(45,50062,1),
(46,50063,1),
(47,50070,1),
(48,50071,1),
(49,50072,1),
(50,50073,1),
(51,50080,1),
(52,50081,1),
(53,50082,1),
(54,50083,1),
(55,10000,1),
(56,9100,1),
(57,50090,1),
(58,50091,1),
(59,50092,1),
(60,50093,1),
(61,50103,1),
(62,50102,1),
(63,50100,1),
(64,50101,1),
(65,50110,1),
(66,50111,1),
(67,50112,1),
(68,50113,1),
(69,50120,1),
(70,50121,1),
(71,50122,1),
(72,50123,1),
(73,50130,1),
(74,50131,1),
(75,50132,1),
(76,50133,1),
(77,50140,1),
(78,50141,1),
(79,50142,1),
(80,50143,1),
(81,50150,1),
(82,50151,1),
(83,50152,1),
(84,50153,1),
(85,50160,1),
(86,50161,1),
(87,50162,1),
(88,50163,1),
(89,50170,1),
(90,50171,1),
(91,50172,1),
(92,50173,1),
(93,50180,1),
(94,50181,1),
(95,50182,1),
(96,50183,1),
(97,50190,1),
(98,50191,1),
(99,50192,1),
(100,50193,1),
(101,50200,1),
(102,50201,1),
(103,50202,1),
(104,50203,1),
(105,50210,1),
(106,50211,1),
(107,50212,1),
(108,50213,1),
(109,50220,1),
(110,50221,1),
(111,50222,1),
(112,50223,1),
(113,50230,1),
(114,50231,1),
(115,50232,1),
(116,50233,1),
(117,50240,1),
(118,50241,1),
(119,50242,1),
(120,50243,1),
(121,50250,1),
(122,50251,1),
(123,50252,1),
(124,50253,1),
(125,50260,1),
(126,50261,1),
(127,50262,1),
(128,50263,1),
(129,50270,1),
(130,50271,1),
(131,50272,1),
(132,50273,1),
(133,50280,1),
(134,50281,1),
(135,50282,1),
(136,50283,1),
(137,50290,1),
(138,50291,1),
(139,50292,1),
(140,50293,1),
(141,50300,1),
(142,50301,1),
(143,50302,1),
(144,50303,1),
(145,50310,1),
(146,50311,1),
(147,50312,1),
(148,50313,1),
(149,50320,1),
(150,50321,1),
(151,50322,1),
(152,50323,1),
(153,50330,1),
(154,50331,1),
(155,50332,1),
(156,50333,1),
(157,50341,1),
(158,50340,1),
(159,50342,1),
(160,50343,1),
(161,50350,1),
(162,50351,1),
(163,50352,1),
(164,50353,1),
(165,50360,1),
(166,50361,1),
(167,50362,1),
(168,50363,1),
(169,50370,1),
(170,50371,1),
(171,50372,1),
(172,50373,1),
(173,50380,1),
(174,50381,1),
(175,50382,1),
(176,50383,1),
(177,8100,1),
(178,60101,1),
(179,10001,1),
(180,10002,1),
(181,10003,1),
(182,10004,1),
(183,10005,1),
(184,10006,1),
(185,10007,1),
(186,8002,1),
(188,8003,1),
(191,8101,1),
(192,8102,1),
(193,8103,1),
(195,60102,1),
(196,60103,1),
(197,60104,1),
(198,60105,1),
(199,60106,1),
(200,60107,1),
(201,60108,1),
(202,60109,1),
(203,60110,1),
(204,60111,1),
(205,60112,1),
(206,60113,1),
(207,60114,1),
(208,60115,1),
(209,60116,1),
(210,60117,1),
(211,60118,1),
(212,60119,1),
(213,60120,1),
(214,60121,1),
(215,60122,1),
(216,60123,1),
(217,60124,1),
(218,60125,1),
(219,60126,1),
(220,60127,1),
(221,60128,1),
(222,60129,1),
(223,60130,1),
(224,60131,1),
(225,60132,1),
(226,60133,1),
(227,60134,1),
(228,60135,1),
(229,60136,1),
(230,60137,1),
(231,60138,1),
(232,60139,1),
(233,60140,1),
(234,60141,1),
(235,60142,1),
(236,60143,1),
(237,60144,1),
(238,60145,1),
(239,60146,1),
(240,2001,1),
(241,2002,1),
(243,3000,1),
(244,7101,1),
(245,7102,1),
(246,5101,1),
(247,5102,1),
(248,8001,1),
(251,8004,1),
(259,10008,1),
(263,1000,2),
(264,8000,2),
(266,8003,2),
(267,8004,2),
(268,8005,2),
(270,8005,1);

/*Table structure for table `tbl_mst_menu` */

DROP TABLE IF EXISTS `tbl_mst_menu`;

CREATE TABLE `tbl_mst_menu` (
  `mst_menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `mst_menu_grup` varchar(100) DEFAULT NULL,
  `mst_menu_nama` varchar(50) DEFAULT NULL,
  `mst_menu_link` varchar(50) DEFAULT NULL,
  `mst_menu_icon` varchar(30) DEFAULT NULL,
  `mst_menu_is_main` int(11) DEFAULT NULL,
  `mst_menu_class` varchar(100) DEFAULT NULL,
  `mst_menu_status` char(1) DEFAULT 'Y',
  PRIMARY KEY (`mst_menu_id`),
  KEY `mst_menu_grup` (`mst_menu_grup`,`mst_menu_nama`,`mst_menu_status`)
) ENGINE=InnoDB AUTO_INCREMENT=250003 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_mst_menu` */

insert  into `tbl_mst_menu`(`mst_menu_id`,`mst_menu_grup`,`mst_menu_nama`,`mst_menu_link`,`mst_menu_icon`,`mst_menu_is_main`,`mst_menu_class`,`mst_menu_status`) values 
(1000,'Dashboard','Dashboard','dashboard','nav-icon fa fa-home',0,'','Y'),
(2000,'User','User','user','nav-icon fas fa-child',0,NULL,'Y'),
(2001,'User Edit','User Edit','user/edit',NULL,NULL,NULL,'Y'),
(2002,'User Hapus','User Hapus','user/hapus',NULL,NULL,NULL,'Y'),
(3000,'Produk','Produk','produk','nav-icon fas fa-mitten',0,NULL,'Y'),
(4000,'Inbox','Inbox','inbox','nav-icon fas fa-bell',0,NULL,'Y'),
(5000,'Referral','Referral','#','nav-icon fas fa-infinity',0,NULL,'Y'),
(5101,'Referral','Master Referral','referral',NULL,5000,NULL,'Y'),
(5102,'Referral','Transaksi Referral ','referral_transaksi',NULL,5000,NULL,'Y'),
(6000,'Notifikasi','Notifikasi','notifikasi','nav-icon fas fa-bell',0,NULL,'Y'),
(7000,'Hadiah','Hadiah','#','nav-icon fas fa-mitten',0,NULL,'Y'),
(7101,'Hadiah','Master Hadiah','hadiah',NULL,7000,NULL,'Y'),
(7102,'Hadiah','Pemenang Hadiah','hadiah_pemenang',NULL,7000,NULL,'Y'),
(8000,'Deposit','Deposit','#','nav-icon fas fa-plug',0,NULL,'Y'),
(8001,'Deposit','Bank Otomatis','saldo_bank',NULL,8000,NULL,'Y'),
(8002,'Deposit','Bank Manual','saldo_bank_manual',NULL,8000,NULL,'Y'),
(8003,'Deposit','Transaksi','saldo_transaksi',NULL,8000,NULL,'Y'),
(8004,'Deposit','Saldo User','saldo_user',NULL,8000,NULL,'Y'),
(8005,'Deposit','Saldo User Tambah','saldo_user/tambah',NULL,0,NULL,'N'),
(8100,'Poin','Poin','#','nav-icon fas fa-coins',0,NULL,'Y'),
(8101,'Poin','Transaksi Poin','poin_transaksi',NULL,8100,NULL,'Y'),
(8102,'Poin','Poin User','poin_user',NULL,8100,NULL,'Y'),
(8103,'Poin','Poin User Tambah','poin_user/tambah',NULL,NULL,NULL,'Y'),
(8500,'Banner','Banner','banner','nav-icon fas fa-desktop',0,NULL,'Y'),
(9000,'Transfer','Transfer','transfer','nav-icon fab fa-gg-circle',0,NULL,'Y'),
(9100,'Menu','Menu','menu','nav-icon fa fa-list',0,NULL,'Y'),
(10000,'Kategori','Kategori','#','nav-icon fas fa-stream',0,NULL,'Y'),
(10001,'Kategori','Game','kategori/kategori_game',NULL,10000,NULL,'Y'),
(10002,'Kategori','HP','kategori/kategori_hp',NULL,10000,NULL,'Y'),
(10003,'Kategori','Internet','kategori/kategori_internet',NULL,10000,NULL,'Y'),
(10004,'Kategori','Multifinance','kategori/kategori_multifinance',NULL,10000,NULL,'Y'),
(10005,'Kategori','PBB','kategori/kategori_pbb',NULL,10000,NULL,'Y'),
(10006,'Kategori','PDAM','kategori/kategori_pdam',NULL,10000,NULL,'Y'),
(10007,'Kategori','TV','kategori/kategori_tv',NULL,10000,NULL,'Y'),
(10008,'Kategori','Produk','kategori/kategori_produk',NULL,10000,NULL,'Y'),
(50000,'Master','Master','#','nav-icon fas fa-tag',0,NULL,'Y'),
(50010,'Master Pulsa','Pulsa','master/master_pulsa',NULL,50000,NULL,'Y'),
(50011,'Master Pulsa','Pulsa Tambah','master/master_pulsa/tambah',NULL,0,NULL,'N'),
(50012,'Master Pulsa','Pulsa Edit','master/master_pulsa/edit',NULL,0,NULL,'N'),
(50013,'Master Pulsa','Pulsa Hapus','master/master_pulsa/hapus',NULL,0,NULL,'N'),
(50020,'Master Paket Data','Paket Data','master/master_paket_data',NULL,50000,NULL,'Y'),
(50021,'Master Paket Data','Paket Data Tambah','master/master_paket_data/tambah',NULL,NULL,NULL,'N'),
(50022,'Master Paket Data','Paket Data Edit','master/master_paket_data/edit',NULL,NULL,NULL,'N'),
(50023,'Master Paket Data','Paket Data Hapus','master/master_paket_data/hapus',NULL,NULL,NULL,'N'),
(50030,'Master Paket Nelfon','Paket Nelfon','master/master_paket_nelfon',NULL,50000,NULL,'Y'),
(50031,'Master Paket Nelfon','Paket Nelfon Tambah','master/master_paket_nelfon/tambah',NULL,NULL,NULL,'Y'),
(50032,'Master Paket Nelfon','Paket Nelfon Edit','master/master_paket_nelfon/edit',NULL,NULL,NULL,'Y'),
(50033,'Master Paket Nelfon','Paket Nelfon Hapus','master/master_paket_nelfon/hapus',NULL,NULL,NULL,'Y'),
(50040,'Master Paket SMS','Paket SMS','master/master_paket_sms',NULL,50000,NULL,'Y'),
(50041,'Master Paket SMS','Paket SMS Tambah','master/master_paket_sms/tambah',NULL,NULL,NULL,'Y'),
(50042,'Master Paket SMS','Paket SMS Edit','master/master_paket_sms/edit',NULL,NULL,NULL,'Y'),
(50043,'Master Paket SMS','Paket SMS Hapus','master/master_paket_sms/hapus',NULL,NULL,NULL,'Y'),
(50050,'Master Token PLN','Token PLN','master/master_token_pln',NULL,50000,NULL,'Y'),
(50051,'Master Token PLN','Token PLN Tambah','master/master_token_pln/tambah',NULL,NULL,NULL,'Y'),
(50052,'Master Token PLN','Token PLN Edit','master/master_token_pln/edit',NULL,NULL,NULL,'Y'),
(50053,'Master Token PLN','Token PLN Hapus','master/master_token_pln/hapus',NULL,NULL,NULL,'Y'),
(50060,'Master Masa Aktif','Masa Aktif','master/master_masa_aktif',NULL,50000,NULL,'Y'),
(50061,'Master Masa Aktif','Masa Aktif Tambah','master/master_masa_aktif/tambah',NULL,NULL,NULL,'Y'),
(50062,'Master Masa Aktif','Masa Aktif Edit','master/master_masa_aktif/edit',NULL,NULL,NULL,'Y'),
(50063,'Master Masa Aktif','Masa Aktif Hapus','master/master_masa_aktif/hapus',NULL,NULL,NULL,'Y'),
(50070,'Master Pulsa Transfer','Pulsa Transfer','master/master_pulsa_transfer',NULL,50000,NULL,'Y'),
(50071,'Master Pulsa Transfer','Pulsa Transfer Tambah','master/master_pulsa_transfer/tambah',NULL,NULL,NULL,'Y'),
(50072,'Master Pulsa Transfer','Pulsa Transfer Edit','master/master_pulsa_transfer/edit',NULL,NULL,NULL,'Y'),
(50073,'Master Pulsa Transfer','Pulsa Transfer Hapus','master/master_pulsa_transfer/hapus',NULL,NULL,NULL,'Y'),
(50080,'Master Game','Game','master/master_game',NULL,50000,NULL,'Y'),
(50081,'Master Game','Game Tambah','master/master_game/tambah',NULL,NULL,NULL,'Y'),
(50082,'Master Game','Game Edit','master/master_game/edit',NULL,NULL,NULL,'Y'),
(50083,'Master Game','Game Hapus','master/master_game/hapus',NULL,NULL,NULL,'Y'),
(50090,'Master Gopay','Gopay','master/master_gopay',NULL,50000,NULL,'Y'),
(50091,'Master Gopay','Gopay Tambah','master/master_gopay/tambah',NULL,NULL,NULL,'Y'),
(50092,'Master Gopay','Gopay Edit','master/master_gopay/edit',NULL,NULL,NULL,'Y'),
(50093,'Master Gopay','Gopay Hapus','master/master_gopay/hapus',NULL,NULL,NULL,'Y'),
(50100,'Master OVO','OVO','master/master_ovo',NULL,50000,NULL,'Y'),
(50101,'Master OVO','OVO Tambah','master/master_ovo/tambah',NULL,NULL,NULL,'Y'),
(50102,'Master OVO','OVO Edit','master/master_ovo/edit',NULL,NULL,NULL,'Y'),
(50103,'Master OVO','OVO Hapus','master/master_ovo/hapus',NULL,NULL,NULL,'Y'),
(50110,'Master LinkAja','Link Aja','master/master_linkaja',NULL,50000,NULL,'Y'),
(50111,'Master LinkAja','Link Aja Tambah','master/master_linkaja/tambah',NULL,NULL,NULL,'Y'),
(50112,'Master LinkAja','Link Aja Edit','master/master_linkaja/edit',NULL,NULL,NULL,'Y'),
(50113,'Master LinkAja','Link Aja Hapus','master/master_linkaja/hapus',NULL,NULL,NULL,'Y'),
(50120,'Master Maxim','Maxim','master/master_maxim',NULL,50000,NULL,'Y'),
(50121,'Master Maxim','Maxim Tambah','master/master_maxim/tambah',NULL,NULL,NULL,'Y'),
(50122,'Master Maxim','Maxim Edit','master/master_maxim/edit',NULL,NULL,NULL,'Y'),
(50123,'Master Maxim','Maxim Hapus','master/master_maxim/hapus',NULL,NULL,NULL,'Y'),
(50130,'Master DANA','DANA','master/master_dana',NULL,50000,NULL,'Y'),
(50131,'Master DANA','DANA Tambah','master/master_dana/tambah',NULL,NULL,NULL,'Y'),
(50132,'Master DANA','DANA Edit','master/master_dana/edit',NULL,NULL,NULL,'Y'),
(50133,'Master DANA','DANA Hapus','master/master_dana/hapus',NULL,NULL,NULL,'Y'),
(50140,'Master ShopeePay','ShopeePay','master/master_shopeepay',NULL,50000,NULL,'Y'),
(50141,'Master ShopeePay','ShopeePay Tambah','master/master_shopeepay/tambah',NULL,NULL,NULL,'Y'),
(50142,'Master ShopeePay','ShopeePay Edit','master/master_shopeepay/edit',NULL,NULL,NULL,'Y'),
(50143,'Master ShopeePay','ShopeePay Hapus','master/master_shopeepay/hapus',NULL,NULL,NULL,'Y'),
(50150,'Master Doku','Doku','master/master_doku',NULL,50000,NULL,'Y'),
(50151,'Master Doku','Doku Tambah','master/master_doku/tambah',NULL,NULL,NULL,'Y'),
(50152,'Master Doku','Doku Edit','master/master_doku/edit',NULL,NULL,NULL,'Y'),
(50153,'Master Doku','Doku Hapus','master/master_doku/hapus',NULL,NULL,NULL,'Y'),
(50160,'Master Grab','Grab','master/master_grab',NULL,50000,NULL,'Y'),
(50161,'Master Grab','Grab Tambah','master/master_grab/tambah',NULL,NULL,NULL,'Y'),
(50162,'Master Grab','Grab Edit','master/master_grab/edit',NULL,NULL,NULL,'Y'),
(50163,'Master Grab','Grab Hapus','master/master_grab/hapus',NULL,NULL,NULL,'Y'),
(50170,'Master Sakuku','Sakuku','master/master_sakuku',NULL,50000,NULL,'Y'),
(50171,'Master Sakuku','Sakuku Tambah','master/master_sakuku/tambah',NULL,NULL,NULL,'Y'),
(50172,'Master Sakuku','Sakuku Edit','master/master_sakuku/edit',NULL,NULL,NULL,'Y'),
(50173,'Master Sakuku','Sakuku Hapus','master/master_sakuku/hapus',NULL,NULL,NULL,'Y'),
(50180,'Master I-Saku','I-Saku','master/master_isaku',NULL,50000,NULL,'Y'),
(50181,'Master I-Saku','I-Saku Tambah','master/master_isaku/tambah',NULL,NULL,NULL,'Y'),
(50182,'Master I-Saku','I-Saku Edit','master/master_isaku/edit',NULL,NULL,NULL,'Y'),
(50183,'Master I-Saku','I-Saku Hapus','master/master_isaku/hapus',NULL,NULL,NULL,'Y'),
(50190,'Master Gojek Driver','Gojek Driver','master/master_gojek_driver',NULL,50000,NULL,'Y'),
(50191,'Master Gojek Driver','Gojek Driver Tambah','master/master_gojek_driver/tambah',NULL,NULL,NULL,'Y'),
(50192,'Master Gojek Driver','Gojek Driver Edit','master/master_gojek_driver/edit',NULL,NULL,NULL,'Y'),
(50193,'Master Gojek Driver','Gojek Driver Hapus','master/master_gojek_driver/hapus',NULL,NULL,NULL,'Y'),
(50200,'Master Maxim Driver','Maxim Driver','master/master_maxim_driver',NULL,50000,NULL,'Y'),
(50201,'Master Maxim Driver','Maxim Driver Tambah','master/master_maxim_driver/tambah',NULL,NULL,NULL,'Y'),
(50202,'Master Maxim Driver','Maxim Driver Edit','master/master_maxim_driver/edit',NULL,NULL,NULL,'Y'),
(50203,'Master Maxim Driver','Maxim Driver Hapus','master/master_maxim_driver/hapus',NULL,NULL,NULL,'Y'),
(50210,'Master Grab Driver','Grab Driver','master/master_grab_driver',NULL,50000,NULL,'Y'),
(50211,'Master Grab Driver','Grab Driver Tambah','master/master_grab_driver/tambah',NULL,NULL,NULL,'Y'),
(50212,'Master Grab Driver','Grab Driver Edit','master/master_grab_driver/edit',NULL,NULL,NULL,'Y'),
(50213,'Master Grab Driver','Grab Driver Hapus','master/master_grab_driver/hapus',NULL,NULL,NULL,'Y'),
(50220,'Master Shopee Driver','Shopee Driver','master/master_shopee_driver',NULL,50000,NULL,'Y'),
(50221,'Master Shopee Driver','Shopee Driver Tambah','master/master_shopee_driver/tambah',NULL,NULL,NULL,'Y'),
(50222,'Master Shopee Driver','Shopee Driver Edit','master/master_shopee_driver/edit',NULL,NULL,NULL,'Y'),
(50223,'Master Shopee Driver','Shopee Driver Hapus','master/master_shopee_driver/hapus',NULL,NULL,NULL,'Y'),
(50230,'Master Indomaret','Indomaret','master/master_indomaret',NULL,50000,NULL,'Y'),
(50231,'Master Indomaret','Indomaret Tambah','master/master_indomaret/tambah',NULL,NULL,NULL,'Y'),
(50232,'Master Indomaret','Indomaret Edit','master/master_indomaret/edit',NULL,NULL,NULL,'Y'),
(50233,'Master Indomaret','Indomaret Hapus','master/master_indomaret/hapus',NULL,NULL,NULL,'Y'),
(50240,'Master Alfamart','Alfamart','master/master_alfamart',NULL,50000,NULL,'Y'),
(50241,'Master Alfamart','Alfamart Tambah','master/master_alfamart/tambah',NULL,NULL,NULL,'Y'),
(50242,'Master Alfamart','Alfamart Edit','master/master_alfamart/edit',NULL,NULL,NULL,'Y'),
(50243,'Master Alfamart','Alfamart Hapus','master/master_alfamart/hapus',NULL,NULL,NULL,'Y'),
(50250,'Master Tokopedia','Tokopedia','master/master_tokopedia',NULL,50000,NULL,'Y'),
(50251,'Master Tokopedia','Tokopedia Tambah','master/master_tokopedia/tambah',NULL,NULL,NULL,'Y'),
(50252,'Master Tokopedia','Tokopedia Edit','master/master_tokopedia/edit',NULL,NULL,NULL,'Y'),
(50253,'Master Tokopedia','Tokopedia Hapus','master/master_tokopedia/hapus',NULL,NULL,NULL,'Y'),
(50260,'Master E-Materai','E-Materai ','master/master_materai',NULL,50000,NULL,'Y'),
(50261,'Master E-Materai','E-Materai Tambah','master/master_materai/tambah',NULL,NULL,NULL,'Y'),
(50262,'Master E-Materai','E-Materai Edit','master/master_materai/edit',NULL,NULL,NULL,'Y'),
(50263,'Master E-Materai','E-Materai Hapus','master/master_materai/hapus',NULL,NULL,NULL,'Y'),
(50270,'Master Traveloka','Traveloka','master/master_traveloka',NULL,50000,NULL,'Y'),
(50271,'Master Traveloka','Traveloka Tambah','master/master_traveloka/tambah',NULL,NULL,NULL,'Y'),
(50272,'Master Traveloka','Traveloka Edit','master/master_traveloka/edit',NULL,NULL,NULL,'Y'),
(50273,'Master Traveloka','Traveloka Hapus','master/master_traveloka/hapus',NULL,NULL,NULL,'Y'),
(50280,'Master M-TIX','M-TIX','master/master_mtix',NULL,50000,NULL,'Y'),
(50281,'Master M-TIX','M-TIX Tambah','master/master_mtix/tambah',NULL,NULL,NULL,'Y'),
(50282,'Master M-TIX','M-TIX Edit','master/master_mtix/edit',NULL,NULL,NULL,'Y'),
(50283,'Master M-TIX','M-TIX Hapus','master/master_mtix/hapus',NULL,NULL,NULL,'Y'),
(50290,'Master TIX-ID','TIX-ID','master/master_tixid',NULL,50000,NULL,'Y'),
(50291,'Master TIX-ID','TIX-ID Tambah','master/master_tixid/tambah',NULL,NULL,NULL,'Y'),
(50292,'Master TIX-ID','TIX-ID Edit','master/master_tixid/edit',NULL,NULL,NULL,'Y'),
(50293,'Master TIX-ID','TIX-ID Hapus','master/master_tixid/hapus',NULL,NULL,NULL,'Y'),
(50300,'Master Spotify','Spotify','master/master_spotify',NULL,50000,NULL,'Y'),
(50301,'Master Spotify','Spotify Tambah','master/master_spotify/tambah',NULL,NULL,NULL,'Y'),
(50302,'Master Spotify','Spotify Edit','master/master_spotify/edit',NULL,NULL,NULL,'Y'),
(50303,'Master Spotify','Spotify Hapus','master/master_spotify/hapus',NULL,NULL,NULL,'Y'),
(50310,'Master Googleplay','Googleplay','master/master_googleplay',NULL,50000,NULL,'Y'),
(50311,'Master Googleplay','Googleplay Tambah','master/master_googleplay/tambah',NULL,NULL,NULL,'Y'),
(50312,'Master Googleplay','Googleplay Edit','master/master_googleplay/edit',NULL,NULL,NULL,'Y'),
(50313,'Master Googleplay','Googleplay Hapus','master/master_googleplay/hapus',NULL,NULL,NULL,'Y'),
(50320,'Master Vidio','Vidio','master/master_vidio',NULL,50000,NULL,'Y'),
(50321,'Master Vidio','Vidio Tambah','master/master_vidio/tambah',NULL,NULL,NULL,'Y'),
(50322,'Master Vidio','Vidio Edit','master/master_vidio/edit',NULL,NULL,NULL,'Y'),
(50323,'Master Vidio','Vidio Hapus','master/master_vidio/hapus',NULL,NULL,NULL,'Y'),
(50330,'Master Unipin','Unipin','master/master_unipin',NULL,50000,NULL,'Y'),
(50331,'Master Unipin','Unipin Tambah','master/master_unipin/tambah',NULL,NULL,NULL,'Y'),
(50332,'Master Unipin','Unipin Edit','master/master_unipin/edit',NULL,NULL,NULL,'Y'),
(50333,'Master Unipin','Unipin Hapus','master/master_unipin/hapus',NULL,NULL,NULL,'Y'),
(50340,'Master WIFI-ID','WIFI-ID','master/master_wifiid',NULL,50000,NULL,'Y'),
(50341,'Master WIFI-ID','WIFI-ID Tambah','master/master_wifiid/tambah',NULL,NULL,NULL,'Y'),
(50342,'Master WIFI-ID','WIFI-ID Edit','master/master_wifiid/edit',NULL,NULL,NULL,'Y'),
(50343,'Master WIFI-ID','WIFI-ID Hapus','master/master_wifiid/hapus',NULL,NULL,NULL,'Y'),
(50350,'Master Bukalapak','Bukalapak','master/master_bukalapak',NULL,50000,NULL,'Y'),
(50351,'Master Bukalapak','Bukalapak Tambah','master/master_bukalapak/tambah',NULL,NULL,NULL,'Y'),
(50352,'Master Bukalapak','Bukalapak Edit','master/master_bukalapak/edit',NULL,NULL,NULL,'Y'),
(50353,'Master Bukalapak','Bukalapak Hapus','master/master_bukalapak/hapus',NULL,NULL,NULL,'Y'),
(50360,'Master E-Money','E-Money','master/master_emoney',NULL,50000,NULL,'Y'),
(50361,'Master E-Money','E-Money Tambah','master/master_emoney/tambah',NULL,NULL,NULL,'Y'),
(50362,'Master E-Money','E-Money Edit','master/master_emoney/edit',NULL,NULL,NULL,'Y'),
(50363,'Master E-Money','E-Money Hapus','master/master_emoney/hapus',NULL,NULL,NULL,'Y'),
(50370,'Master Tapcash','Tapcash','master/master_tapcash',NULL,50000,NULL,'Y'),
(50371,'Master Tapcash','Tapcash Tambah','master/master_tapcash/tambah',NULL,NULL,NULL,'Y'),
(50372,'Master Tapcash','Tapcash Edit','master/master_tapcash/edit',NULL,NULL,NULL,'Y'),
(50373,'Master Tapcash','Tapcash Hapus','master/master_tapcash/hapus',NULL,NULL,NULL,'Y'),
(50380,'Master Brizzi','Brizzi','master/master_brizzi',NULL,50000,NULL,'Y'),
(50381,'Master Brizzi','Brizzi Tambah','master/master_brizzi/tambah',NULL,NULL,NULL,'Y'),
(50382,'Master Brizzi','Brizzi Edit','master/master_brizzi/edit',NULL,NULL,NULL,'Y'),
(50383,'Master Brizzi','Brizzi Hapus','master/master_brizzi/hapus',NULL,NULL,NULL,'Y'),
(60000,'Transaksi','Transaksi','#','nav-icon far fa-credit-card',0,NULL,'Y'),
(60100,'Transaksi','Pulsa','transaksi/transaksi_pulsa','',60000,NULL,'Y'),
(60101,'Transaksi','Paket Data','transaksi/transaksi_paket_data',NULL,60000,NULL,'Y'),
(60102,'Transaksi','Paket Nelfon','transaksi/transaksi_paket_nelfon',NULL,60000,NULL,'Y'),
(60103,'Transaksi','Paket SMS','transaksi/transaksi_paket_sms',NULL,60000,NULL,'Y'),
(60104,'Transaksi','Token PLN','transaksi/transaksi_token_pln',NULL,60000,NULL,'Y'),
(60105,'Transaksi','Masa Aktif','transaksi/transaksi_masa_aktif',NULL,60000,NULL,'Y'),
(60106,'Transaksi','Pulsa Transfer','transaksi/transaksi_pulsa_transfer',NULL,60000,NULL,'Y'),
(60107,'Transaksi','Game','transaksi/transaksi_game',NULL,60000,NULL,'Y'),
(60108,'Transaksi','BPJS','transaksi/transaksi_bpjs',NULL,60000,NULL,'Y'),
(60109,'Transaksi','HP','transaksi/transaksi_hp',NULL,60000,NULL,'Y'),
(60110,'Transaksi','TV','transaksi/transaksi_tv',NULL,60000,NULL,'Y'),
(60111,'Transaksi','PLN','transaksi/transaksi_pln',NULL,60000,NULL,'Y'),
(60112,'Transaksi','Internet','transaksi/transaksi_internet',NULL,60000,NULL,'Y'),
(60113,'Transaksi','Multifinance','transaksi/transaksi_multifinance',NULL,60000,NULL,'Y'),
(60114,'Transaksi','PDAM','transaksi/transaksi_pdam',NULL,60000,NULL,'Y'),
(60115,'Transaksi','PBB','transaksi/transaksi_pbb',NULL,60000,NULL,'Y'),
(60116,'Transaksi','Gas Negara','transaksi/transaksi_gas',NULL,60000,NULL,'Y'),
(60117,'Transaksi','Gopay','transaksi/transaksi_gopay',NULL,60000,NULL,'Y'),
(60118,'Transaksi','OVO','transaksi/transaksi_ovo',NULL,60000,NULL,'Y'),
(60119,'Transaksi','LinkAja','transaksi/transaksi_linkaja',NULL,60000,NULL,'Y'),
(60120,'Transaksi','Maxim','transaksi/transaksi_maxim',NULL,60000,NULL,'Y'),
(60121,'Transaksi','DANA','transaksi/transaksi_dana',NULL,60000,NULL,'Y'),
(60122,'Transaksi','ShopeePay','transaksi/transaksi_shopeepay',NULL,60000,NULL,'Y'),
(60123,'Transaksi','Doku','transaksi/transaksi_doku',NULL,60000,NULL,'Y'),
(60124,'Transaksi','Grab','transaksi/transaksi_grab',NULL,60000,NULL,'Y'),
(60125,'Transaksi','Sakuku','transaksi/transaksi_sakuku',NULL,60000,NULL,'Y'),
(60126,'Transaksi','I-Saku','transaksi/transaksi_isaku',NULL,60000,NULL,'Y'),
(60127,'Transaksi','Gojek Driver','transaksi/transaksi_gojek_driver',NULL,60000,NULL,'Y'),
(60128,'Transaksi','Maxim Driver','transaksi/transaksi_maxim_driver',NULL,60000,NULL,'Y'),
(60129,'Transaksi','Grab Driver','transaksi/transaksi_grab_driver',NULL,60000,NULL,'Y'),
(60130,'Transaksi','Shopee Driver','transaksi/transaksi_shopee_driver',NULL,60000,NULL,'Y'),
(60131,'Transaksi','Indomaret','transaksi/transaksi_indomaret',NULL,60000,NULL,'Y'),
(60132,'Transaksi','Alfamart','transaksi/transaksi_alfamart',NULL,60000,NULL,'Y'),
(60133,'Transaksi','Tokopedia','transaksi/transaksi_tokopedia',NULL,60000,NULL,'Y'),
(60134,'Transaksi','E-Materai','transaksi/transaksi_materai',NULL,60000,NULL,'Y'),
(60135,'Transaksi','Traveloka','transaksi/transaksi_traveloka',NULL,60000,NULL,'Y'),
(60136,'Transaksi','M-TIX','transaksi/transaksi_mtix',NULL,60000,NULL,'Y'),
(60137,'Transaksi','TIX-ID','transaksi/transaksi_tixid',NULL,60000,NULL,'Y'),
(60138,'Transaksi','Spotify','transaksi/transaksi_spotify',NULL,60000,NULL,'Y'),
(60139,'Transaksi','Googleplay','transaksi/transaksi_googleplay',NULL,60000,NULL,'Y'),
(60140,'Transaksi','Vidio','transaksi/transaksi_vidio',NULL,60000,NULL,'Y'),
(60141,'Transaksi','Unipin','transaksi/transaksi_unipin',NULL,60000,NULL,'Y'),
(60142,'Transaksi','Wifi ID','transaksi/transaksi_wifiid',NULL,60000,NULL,'Y'),
(60143,'Transaksi','Bukalapak','transaksi/transaksi_bukalapak',NULL,60000,NULL,'Y'),
(60144,'Transaksi','E-Money','transaksi/transaksi_emoney',NULL,60000,NULL,'Y'),
(60145,'Transaksi','TapCash','transaksi/transaksi_tapcash',NULL,60000,NULL,'Y'),
(60146,'Transaksi','Brizzi','transaksi/transaksi_brizzi',NULL,60000,NULL,'Y'),
(70000,'Monitor','Monitor','monitor','nav-icon fas fa-server',0,NULL,'Y'),
(250000,'Utility','Utility','#','nav-icon fas fa-cog',0,'','Y'),
(250001,'Utility','Petugas','petugas/petugas','',250000,'','Y'),
(250002,'Utility','Hak Akses','petugas/hakakses','',250000,'','Y');

/*Table structure for table `tbl_mst_petugas` */

DROP TABLE IF EXISTS `tbl_mst_petugas`;

CREATE TABLE `tbl_mst_petugas` (
  `mst_petugas_id` int(11) NOT NULL AUTO_INCREMENT,
  `mst_petugas_kode` varchar(50) DEFAULT NULL,
  `mst_petugas_nama_lengkap` varchar(100) DEFAULT NULL,
  `mst_petugas_email` varchar(100) DEFAULT NULL,
  `mst_petugas_password` varchar(100) DEFAULT NULL,
  `mst_petugas_status` enum('Aktif','Tidak Aktif') DEFAULT NULL,
  PRIMARY KEY (`mst_petugas_id`),
  KEY `mst_petugas_kode` (`mst_petugas_kode`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_mst_petugas` */

insert  into `tbl_mst_petugas`(`mst_petugas_id`,`mst_petugas_kode`,`mst_petugas_nama_lengkap`,`mst_petugas_email`,`mst_petugas_password`,`mst_petugas_status`) values 
(1,'P-001','Administrator','admin@Arifah Pulsa.com','3acd0be86de7dcccdbf91b20f94a68cea535922d','Aktif'),
(2,'PT-7543','Agen AKL','agenakl@gmail.com','8cb2237d0679ca88db6464eac60da96345513964','Aktif');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;