/*
SQLyog Community v13.1.2 (64 bit)
MySQL - 10.1.37-MariaDB : Database - mpc_proc
*********************************************************************
*/

/*!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*/`mpc_proc` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `mpc_proc`;

/*Table structure for table `base_menu` */

DROP TABLE IF EXISTS `base_menu`;

CREATE TABLE `base_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(100) NOT NULL,
  `menu_trans` varchar(100) NOT NULL COMMENT 'hold translate prefix eg: edit_menu',
  `menu_desc` longtext,
  `menu_sort` int(11) DEFAULT NULL COMMENT 'sorting menu asc or desc order',
  `menu_icon` varchar(30) DEFAULT NULL,
  `menu_url` varchar(100) NOT NULL COMMENT 'url',
  `menu_url_ext` varchar(50) DEFAULT NULL COMMENT 'url extension',
  `parent_id` int(11) NOT NULL,
  `menu_permission` varchar(100) DEFAULT NULL COMMENT 'store permission string here',
  `menu_status` char(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1;

/*Data for the table `base_menu` */

insert  into `base_menu`(`menu_id`,`menu_name`,`menu_trans`,`menu_desc`,`menu_sort`,`menu_icon`,`menu_url`,`menu_url_ext`,`parent_id`,`menu_permission`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'Home','Admin::base.home','user\'s home page / dashboard',1,'fa fa-home','home',NULL,0,NULL,'1','2018-04-22 04:51:49','2018-04-22 12:51:49',NULL),
(2,'Administration','Admin::base.administration','Admin Module',2,'fa fa-cogs','administration',NULL,0,NULL,'1','2018-04-22 04:54:25','2018-04-22 12:54:25',NULL),
(3,'Dashboard','Admin::base.config_dashboard','admin\'s dashboard',1,'fa fa-tachometer-alt','admin.dashboard',NULL,2,NULL,'0','2018-04-22 04:55:44','2018-04-22 12:55:44',NULL),
(4,'Users','Admin::user.users','User management',2,'fa fa-users','user.index',NULL,2,NULL,'1','2018-04-22 04:56:50','2018-04-22 12:56:50',NULL),
(5,'Roles','Admin::role.roles','Roles Management',3,'fa fa-user-secret','admin.roles',NULL,2,NULL,'1','2018-04-22 05:01:48','2018-04-22 13:01:48',NULL),
(6,'Permission','Admin::permission.permission','Permission Management',4,'fa fa-sitemap','admin.permission',NULL,2,NULL,'1','2018-04-22 05:02:40','2018-04-22 13:02:40',NULL),
(7,'Menus','Admin::menu.menu_management','Menu management',5,'fa fa-bars','admin.menus',NULL,2,NULL,'1','2018-04-22 05:03:50','2018-04-22 13:03:50',NULL),
(8,'Logs','Admin::base.logs','System log',6,'fa fa-code','admin.logs',NULL,2,NULL,'0','2018-04-22 05:05:53','2018-04-22 13:05:53',NULL),
(9,'Configuration','Admin::base.config','System config',7,'fa fa-cog','admin.config',NULL,2,NULL,'0','2018-04-22 05:07:41','2018-04-22 13:07:41',NULL),
(10,'Audit Trail','Admin::base.audit_trail','user activity log',8,'fa fa-clipboard','admin.auditrail',NULL,2,NULL,'1','2018-04-22 05:09:18','2018-04-22 13:09:18',NULL),
(11,'Data Rujukan','Data Rujukan','Pengurusan Data Rujukan',3,'fa fa-atlas','data',NULL,0,NULL,'1','2018-11-10 13:09:06','0000-00-00 00:00:00',NULL),
(14,'Jawatan','Jawatan','Pengurusan Data Jawatan\r\n',5,'fa fa-bars','data.jawatan.index',NULL,11,NULL,'1',NULL,'0000-00-00 00:00:00',NULL),
(23,'Laporan','Laporan','Senarai Laporan',5,'fa fa-file-pdf','report.expensessummary.index',NULL,0,NULL,'0','2019-03-22 02:28:31','0000-00-00 00:00:00',NULL),
(38,'Gred','Gred','Pengurusan Data Gred',6,NULL,'data.gred.index',NULL,11,NULL,'1',NULL,'0000-00-00 00:00:00',NULL),
(39,'Destinasi','Destinasi','Pengurusan Data Destinasi Penerbangan',7,NULL,'data.location.index',NULL,11,NULL,'0',NULL,'0000-00-00 00:00:00',NULL),
(40,'Peruntukan','Peruntukan','Pengurusan Data Peruntukan',8,NULL,'data.allocation.index',NULL,11,NULL,'1',NULL,'0000-00-00 00:00:00',NULL),
(41,'Pesawat','Pesawat','Pengurusan Data Syarikat Penerbangan',9,NULL,'data.flightcompany.index',NULL,11,NULL,'0',NULL,'0000-00-00 00:00:00',NULL),
(42,'Bahagian','Bahagian','Pengurusan Data Bahagian',3,NULL,'data.unit.index',NULL,11,NULL,'1',NULL,'0000-00-00 00:00:00',NULL),
(43,'Permohonan','Permohonan','Pengurusan Permohonan Baru',6,'fa fa-folder-open','proses.permohonan',NULL,0,NULL,'1','2019-03-22 02:28:33','0000-00-00 00:00:00',NULL),
(45,'Kelulusan','Kelulusan','Pengurusan Kelulusan Permohonan (< RM10,000)',9,'fa fa-folder-minus','proses.permohonan.lulus',NULL,0,NULL,'1','2019-03-22 02:52:26','0000-00-00 00:00:00',NULL),
(46,'Sokongan','Sokongan','Pengurusan Sokongan Permohonan',7,'fa fa-calendar-check','proses.permohonan.sokong',NULL,0,NULL,'1','2019-03-23 16:21:54','0000-00-00 00:00:00',NULL),
(47,'Pembangunan','Pembangunan','Pengurusan Data Jenis Pembangunan',10,NULL,'data.pembangunan.index',NULL,11,NULL,'0','2019-04-13 06:59:15','2019-04-13 06:59:15',NULL),
(48,'Pengumuman','Pengumuman','Pengurusan Pengumuman',2,'fa fa-bullhorn','data.announcement.index',NULL,2,NULL,'1','2019-08-06 06:15:10','2019-08-06 06:15:10',NULL),
(49,'Semakan RO','Semakan RO','Pengurusan Semakan Permohonan',8,'fa fa-calendar-check','proses.permohonan.semak',NULL,0,NULL,'0','2020-05-28 04:27:06','0000-00-00 00:00:00',NULL),
(50,'Senarai','Senarai','Pengesahan Akhir Bahagian Kewangan',10,'fa fa-file-invoice-dollar','proses.permohonan.selesai',NULL,0,NULL,'0','2020-05-28 04:27:06','2020-10-28 08:13:41',NULL),
(51,'Carian Dokumen','Carian Dokumen','Carian Dokumen Permohonan',13,'fa fa-file-pdf','proses.permohonan.caridokumen',NULL,0,NULL,'1','2020-07-23 03:07:12','0000-00-00 00:00:00',NULL),
(52,'Operasi','Operasi','Pengurusan Semakan Permohonan Operasi',1,NULL,'proses.permohonan.semak',NULL,49,NULL,'1','2020-09-11 19:52:25','2020-09-11 19:52:28',NULL),
(53,'Pembangunan','Pembangunan','Pengurusan Semakan Permohonan Pembangunan',2,NULL,'proses.permohonan.semak2',NULL,49,NULL,'1','2020-09-11 19:53:09','2020-09-11 19:53:11',NULL),
(54,'Kelulusan','Kelulusan','Pengurusan Kelulusan Permohonan (> RM10,000 Dan <=RM20,000)',10,'fa fa-folder-minus','proses.permohonan.lulus2',NULL,0,NULL,'1','2020-09-12 23:41:05','2020-09-12 23:41:08',NULL),
(55,'Kelulusan','Kelulusan','Pengurusan Kelulusan Permohonan (> RM20,000)',10,'fa fa-folder-minus','proses.permohonan.lulus3',NULL,0,NULL,'1','2020-09-12 23:42:23','2020-09-12 23:42:26',NULL),
(56,'Semakan Invois','Semakan Invois','Pengurusan Semakan Invois',12,'fa fa-file-pdf','proses.permohonan.invois',NULL,0,NULL,'1','2020-09-13 20:32:08','2020-09-13 20:32:12',NULL),
(57,'Sub Peruntukan','Sub Peruntukan','Pengurusan Sub Peruntukan',3,NULL,'data.suballocation.index',NULL,11,NULL,'1','2020-09-14 09:46:25','0000-00-00 00:00:00',NULL),
(58,'Permohonan Aset Alih','Permohonan Aset Alih','Pengurusan Permohonan Aset Alih',13,'fa fa-suitcase','proses.permohonan.asetalih',NULL,0,NULL,'1','2020-09-21 22:48:14','2020-09-21 22:48:19',NULL),
(59,'Keputusan Mesyuarat','Keputusan Mesyuarat','Pengurusan Muatnaik Fail / Keputusan Mesyuarat',11,'fa fa-suitcase','proses.permohonan.uploadfile',NULL,0,NULL,'1','2020-09-22 01:48:40','2020-09-22 01:48:45',NULL),
(60,'Jenis Mesyuarat','Jenis Mesyuarat','Pengurusan Jenis Mesyuarat',4,NULL,'data.meetingtype.index',NULL,11,NULL,'1','2020-10-08 00:29:46','2020-10-08 00:29:50',NULL),
(61,'Sub Kategori','Sub Kategori','Pengurusan Sub Kategori Aset Alih dan Bukan Alih',2,NULL,'data.assettype.index',NULL,11,NULL,'1','2020-10-08 10:21:38','2020-10-08 10:21:41',NULL),
(62,'Carian Permohonan','Carian Permohonan','Carian Semua Jenis Permohonan',14,'fa fa-search','proses.permohonan.searchall',NULL,0,NULL,'1','2020-10-08 11:21:09','2020-10-08 11:21:13',NULL),
(63,'Kategori','Kategori','Pengurusan Kategori Aset Alih dan Bukan Alih',1,NULL,'data.asset.index',NULL,11,NULL,'1','2020-10-09 03:17:47','2020-10-09 03:17:53',NULL),
(64,'RO Lengkap','RO Lengkap','Senarai Permohonan RO Lengkap',1,NULL,'proses.permohonan.comment',NULL,50,NULL,'1','2020-10-28 07:27:46','2020-10-28 07:27:46',NULL),
(65,'Invois Lengkap','Invois Lengkap','Senarai Permohonan Invois Lengkap',2,NULL,'proses.permohonan.selesai',NULL,50,NULL,'1','2020-10-28 07:29:06','2020-10-28 07:29:06',NULL),
(66,'Operasi','Operasi','Operasi',8,'fa fa-calendar-check','proses.permohonan.searchall',NULL,0,NULL,'1','2020-12-03 03:11:21','2020-12-03 13:26:58',NULL),
(67,'RO Baru','RO Baru','RO Baru',1,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/1/1',66,NULL,'1','2020-12-03 03:42:38','2020-12-03 13:26:58',NULL),
(68,'RO Lengkap','RO Lengkap','RO Lengkap',2,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/1/2',66,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(69,'RO Lulus','RO Lulus','RO Lulus',3,NULL,'proses.permohonan.globallistfin','permohonan/globallistfin/11/1/3',66,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(70,'RO Batal','RO Batal','RO Batal',4,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/1/4',66,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(71,'Invois Baru','Invois Baru','Invois Baru',5,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/1/5',66,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(72,'Invois Lengkap','Invois Lengkap','Invois Lengkap',6,NULL,'proses.permohonan.globallistfin','permohonan/globallistfin/11/1/6',66,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(73,'Invois Selesai','Invois Selesai','Invois Selesai',7,NULL,'proses.permohonan.globallistfin','permohonan/globallistfin/11/1/7',66,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(74,'Pembangunan','Pembangunan','Pembangunan',8,'fa fa-calendar-check','proses.permohonan.searchall',NULL,0,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(75,'RO Baru','RO Baru','RO Baru',1,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/2/1',74,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(76,'RO Lengkap','RO Lengkap','RO Lengkap',2,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/2/2',74,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(77,'RO Lulus','RO Lulus','RO Lulus',3,NULL,'proses.permohonan.globallistfin','permohonan/globallistfin/11/2/3',74,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(78,'RO Batal','RO Batal','RO Batal',4,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/2/4',74,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(79,'Invois Baru','Invois Baru','Invois Baru',5,NULL,'proses.permohonan.globallistpct','permohonan/globallistpct/10/2/5',74,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(80,'Invois Lengkap','Invois Lengkap','Invois Lengkap',6,NULL,'proses.permohonan.globallistfin','permohonan/globallistfin/11/2/6',74,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL),
(81,'Invois Selesai','Invois Selesai','Invois Selesai',7,NULL,'proses.permohonan.globallistfin','permohonan/globallistfin/11/2/7',74,NULL,'1','2020-12-03 13:26:58','2020-12-03 13:26:58',NULL);

/*!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 */;
