 ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
 
 --
--- Dumping data for table `jns_usaha`
---
-
-INSERT INTO `jns_usaha` (`id`, `jns_usaha_kd`, `nama`, `ket`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`) VALUES
-(1, 'JU001', 'ATK', 'Bidang Usaha ATK', '2016-11-19 23:19:17', NULL, NULL, NULL, NULL, NULL),
-(2, 'JU002', 'Air Minum', 'Bidang Usaha Air Minum', '2016-11-19 23:19:39', NULL, NULL, NULL, NULL, NULL);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `log`
---
-
-CREATE TABLE IF NOT EXISTS `log` (
-  `ip` varchar(255) DEFAULT NULL,
-  `user_id` int(11) DEFAULT NULL,
-  `user_name` varchar(255) DEFAULT NULL,
-  `affected_table` varchar(50) DEFAULT NULL,
-  `affected_id` int(11) DEFAULT NULL,
-  `query` longtext,
-  `action` longtext,
-  `data` longtext,
-  `wording_log` longtext,
-  `created_at` longtext
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `log`
---
-
-INSERT INTO `log` (`ip`, `user_id`, `user_name`, `affected_table`, `affected_id`, `query`, `action`, `data`, `wording_log`, `created_at`) VALUES
-('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:27:03''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:27:03'),
-('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik Update'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:27:20''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik Update","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:27:20'),
-('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik Update'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:29:54''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik Update","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:29:54'),
-('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:30:05''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:30:05'),
-('127.0.0.1', NULL, 'guest', 'p_m_satuan', 1, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''001'', ''Pensil'', ''OK'', ''JU001'', ''2016-11-26 18:46:17'')', 'update', '{"satuan_kd":"001","satuan_name":"Pensil","satuan_desc":"OK","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-26 18:46:17'),
-('127.0.0.1', NULL, 'guest', 'p_m_satuan', 1, 'UPDATE `p_m_satuan` SET `satuan_kd` = ''001'', `satuan_name` = ''Pcs'', `satuan_desc` = ''OK'', `kd_jns_usaha` = ''JU001'', `updated_at` = ''2016-11-26 18:46:59''\nWHERE `id` = ''1''', 'update', '{"satuan_kd":"001","satuan_name":"Pcs","satuan_desc":"OK","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-26 18:46:59'),
-('127.0.0.1', NULL, 'guest', 'p_m_satuan', 2, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''002'', ''Unit'', ''Ok'', ''JU001'', ''2016-11-27 11:57:59'')', 'update', '{"satuan_kd":"002","satuan_name":"Unit","satuan_desc":"Ok","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-27 11:57:59'),
-('127.0.0.1', NULL, 'guest', 'p_m_satuan', 3, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''003'', ''m2'', ''ok'', ''JU001'', ''2016-11-27 12:00:14'')', 'update', '{"satuan_kd":"003","satuan_name":"m2","satuan_desc":"ok","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-27 12:00:14'),
-('127.0.0.1', NULL, 'guest', 'p_m_satuan', 4, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''004'', ''biji'', ''oks'', ''JU001'', ''2016-11-27 12:02:40'')', 'update', '{"satuan_kd":"004","satuan_name":"biji","satuan_desc":"oks","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-27 12:02:40');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `menu`
---
-
-CREATE TABLE IF NOT EXISTS `menu` (
-  `id_menu` int(11) NOT NULL AUTO_INCREMENT,
-  `nama` varchar(200) DEFAULT NULL,
-  `uri` varchar(200) DEFAULT NULL,
-  `id_menu_induk` int(11) DEFAULT NULL,
-  `urutan` int(11) DEFAULT NULL,
-  `module` varchar(100) DEFAULT NULL,
-  `aktif` varchar(50) DEFAULT NULL,
-  `postition` varchar(255) DEFAULT NULL,
-  `created_at` datetime DEFAULT NULL,
-  `created_by` int(11) DEFAULT NULL,
-  `updated_at` datetime DEFAULT NULL,
-  `updated_by` int(11) DEFAULT NULL,
-  `deleted_at` datetime DEFAULT NULL,
-  `deleted_by` int(11) DEFAULT NULL,
-  PRIMARY KEY (`id_menu`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
-
---
--- Dumping data for table `menu`
---
-
-INSERT INTO `menu` (`id_menu`, `nama`, `uri`, `id_menu_induk`, `urutan`, `module`, `aktif`, `postition`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`) VALUES
-(1, 'User Management', 'setting/users', 4, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:25:52', NULL, NULL, NULL, NULL, NULL),
-(2, 'User Group', 'setting/users_group', 4, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:26:30', NULL, NULL, NULL, NULL, NULL),
-(3, 'Menu Management', 'setting/menu_management', 4, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:26:58', NULL, NULL, NULL, NULL, NULL),
-(4, 'For Admin', '#', 0, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:30:47', NULL, NULL, NULL, NULL, NULL);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `menu_akses`
---
-
-CREATE TABLE IF NOT EXISTS `menu_akses` (
-  `id_menu_akses` int(11) NOT NULL AUTO_INCREMENT,
-  `id_menu_fk` int(11) DEFAULT NULL,
-  `id_users_group_fk` int(11) DEFAULT NULL,
-  PRIMARY KEY (`id_menu_akses`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-
---
--- Dumping data for table `menu_akses`
---
-
-INSERT INTO `menu_akses` (`id_menu_akses`, `id_menu_fk`, `id_users_group_fk`) VALUES
-(4, 4, 1),
-(5, 1, 1),
-(6, 2, 1),
-(7, 3, 1);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `mv_hrm_bagian`
---
-
-CREATE TABLE IF NOT EXISTS `mv_hrm_bagian` (
-  `id_bagian` int(11) NOT NULL AUTO_INCREMENT,
-  `nm_bagian` varchar(20) DEFAULT NULL,
-  PRIMARY KEY (`id_bagian`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-
---
--- Dumping data for table `mv_hrm_bagian`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `m_hrm_agama`
---
-
-CREATE TABLE IF NOT EXISTS `m_hrm_agama` (
-  `id_agama` int(11) NOT NULL AUTO_INCREMENT,
-  `nm_agama` varchar(10) DEFAULT NULL,
-  PRIMARY KEY (`id_agama`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-
---
--- Dumping data for table `m_hrm_agama`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `m_hrm_bagian`
---
-
-CREATE TABLE IF NOT EXISTS `m_hrm_bagian` (
-  `id_bagian` int(11) NOT NULL AUTO_INCREMENT,
-  `nm_bagian` varchar(20) DEFAULT NULL,
-  PRIMARY KEY (`id_bagian`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-
---
--- Dumping data for table `m_hrm_bagian`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `m_hrm_gaji`
---
-
-CREATE TABLE IF NOT EXISTS `m_hrm_gaji` (
-  `id_gaji` int(11) NOT NULL AUTO_INCREMENT,
+-- Dumping data for table `hr_m_bagian`
+--
+
+INSERT INTO `hr_m_bagian` (`id`, `nm_bagian`, `kd_jns_usaha`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`) VALUES
+(1, 'Sales', 'JU001', '2016-11-27 21:06:51', NULL, '2016-11-27 21:08:40', NULL, NULL, NULL),
+(2, 'HRD', 'JU001', '2016-11-27 21:09:16', NULL, NULL, NULL, NULL, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `hr_m_gaji`
+--
+
+CREATE TABLE IF NOT EXISTS `hr_m_gaji` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `id_kary` int(11) DEFAULT NULL,
   `gaji_kary` decimal(18,2) DEFAULT NULL,
   `naik_gaji_kary` decimal(18,2) DEFAULT NULL,

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 27, 2016 at 07:57 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `a001`
--

  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `hr_m_karyawan`
--


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

--
-- Table structure for table `hr_m_sex`
--

CREATE TABLE IF NOT EXISTS `hr_m_sex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nm_sex` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `hr_m_sex`
--

INSERT INTO `hr_m_sex` (`id`, `nm_sex`) VALUES
(1, 'Laki-laki'),
(2, 'Perempuan');

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

--
-- Table structure for table `hr_m_statuskary`
--

CREATE TABLE IF NOT EXISTS `hr_m_statuskary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nm_statuskary` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `hr_m_statuskary`
--

INSERT INTO `hr_m_statuskary` (`id`, `nm_statuskary`) VALUES
(1, 'Kontrak'),
(2, 'Tetap'),
(3, 'Freelance');

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

--
-- Table structure for table `jns_usaha`
--

CREATE TABLE IF NOT EXISTS `jns_usaha` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jns_usaha_kd` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `ket` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `jns_usaha`
--

INSERT INTO `jns_usaha` (`id`, `jns_usaha_kd`, `nama`, `ket`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`) VALUES
(1, 'JU001', 'ATK', 'Bidang Usaha ATK', '2016-11-19 23:19:17', NULL, NULL, NULL, NULL, NULL),
(2, 'JU002', 'Air Minum', 'Bidang Usaha Air Minum', '2016-11-19 23:19:39', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `ip` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `affected_table` varchar(50) DEFAULT NULL,
  `affected_id` int(11) DEFAULT NULL,
  `query` longtext,
  `action` longtext,
  `data` longtext,
  `wording_log` longtext,
  `created_at` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `log`
--

INSERT INTO `log` (`ip`, `user_id`, `user_name`, `affected_table`, `affected_id`, `query`, `action`, `data`, `wording_log`, `created_at`) VALUES
('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:27:03''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:27:03'),
('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik Update'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:27:20''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik Update","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:27:20'),
('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik Update'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:29:54''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik Update","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:29:54'),
('::1', NULL, 'guest', 'users', 2, 'UPDATE `users` SET `username` = ''janitramalik'', `name_users` = ''Janitra Al Malik'', `password` = ''ea59fa85c6f4f65851700ecb7f7a9616'', `id_users_group_fk` = ''1'', `blockage` = ''N'', `updated_at` = ''2016-11-20 22:30:05''\nWHERE `id` = ''2''', 'update', '{"username":"janitramalik","name_users":"Janitra Al Malik","password":"ea59fa85c6f4f65851700ecb7f7a9616","id_users_group_fk":"1","blockage":"N"}', 'guest update users', '2016-11-20 22:30:05'),
('127.0.0.1', NULL, 'guest', 'p_m_satuan', 1, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''001'', ''Pensil'', ''OK'', ''JU001'', ''2016-11-26 18:46:17'')', 'update', '{"satuan_kd":"001","satuan_name":"Pensil","satuan_desc":"OK","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-26 18:46:17'),
('127.0.0.1', NULL, 'guest', 'p_m_satuan', 1, 'UPDATE `p_m_satuan` SET `satuan_kd` = ''001'', `satuan_name` = ''Pcs'', `satuan_desc` = ''OK'', `kd_jns_usaha` = ''JU001'', `updated_at` = ''2016-11-26 18:46:59''\nWHERE `id` = ''1''', 'update', '{"satuan_kd":"001","satuan_name":"Pcs","satuan_desc":"OK","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-26 18:46:59'),
('127.0.0.1', NULL, 'guest', 'p_m_satuan', 2, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''002'', ''Unit'', ''Ok'', ''JU001'', ''2016-11-27 11:57:59'')', 'update', '{"satuan_kd":"002","satuan_name":"Unit","satuan_desc":"Ok","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-27 11:57:59'),
('127.0.0.1', NULL, 'guest', 'p_m_satuan', 3, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''003'', ''m2'', ''ok'', ''JU001'', ''2016-11-27 12:00:14'')', 'update', '{"satuan_kd":"003","satuan_name":"m2","satuan_desc":"ok","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-27 12:00:14'),
('127.0.0.1', NULL, 'guest', 'p_m_satuan', 4, 'INSERT INTO `p_m_satuan` (`satuan_kd`, `satuan_name`, `satuan_desc`, `kd_jns_usaha`, `created_at`) VALUES (''004'', ''biji'', ''oks'', ''JU001'', ''2016-11-27 12:02:40'')', 'update', '{"satuan_kd":"004","satuan_name":"biji","satuan_desc":"oks","kd_jns_usaha":"JU001"}', 'guest update p_m_satuan', '2016-11-27 12:02:40'),
('127.0.0.1', NULL, 'guest', 'hr_m_bagian', 1, 'INSERT INTO `hr_m_bagian` (`nm_bagian`, `kd_jns_usaha`, `created_at`) VALUES (''HRD'', ''JU001'', ''2016-11-27 21:06:51'')', 'update', '{"nm_bagian":"HRD","kd_jns_usaha":"JU001"}', 'guest update hr_m_bagian', '2016-11-27 21:06:51'),
('127.0.0.1', NULL, 'guest', 'hr_m_bagian', 1, 'UPDATE `hr_m_bagian` SET `nm_bagian` = ''Sales'', `kd_jns_usaha` = ''JU001'', `updated_at` = ''2016-11-27 21:08:40''\nWHERE `id` = ''1''', 'update', '{"nm_bagian":"Sales","kd_jns_usaha":"JU001"}', 'guest update hr_m_bagian', '2016-11-27 21:08:40'),
('127.0.0.1', NULL, 'guest', 'hr_m_bagian', 2, 'INSERT INTO `hr_m_bagian` (`nm_bagian`, `kd_jns_usaha`, `created_at`) VALUES (''HRD'', ''JU001'', ''2016-11-27 21:09:16'')', 'update', '{"nm_bagian":"HRD","kd_jns_usaha":"JU001"}', 'guest update hr_m_bagian', '2016-11-27 21:09:16');

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

--
-- Table structure for table `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id_menu` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(200) DEFAULT NULL,
  `uri` varchar(200) DEFAULT NULL,
  `id_menu_induk` int(11) DEFAULT NULL,
  `urutan` int(11) DEFAULT NULL,
  `module` varchar(100) DEFAULT NULL,
  `aktif` varchar(50) DEFAULT NULL,
  `postition` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_menu`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id_menu`, `nama`, `uri`, `id_menu_induk`, `urutan`, `module`, `aktif`, `postition`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`) VALUES
(1, 'User Management', 'setting/users', 4, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:25:52', NULL, NULL, NULL, NULL, NULL),
(2, 'User Group', 'setting/users_group', 4, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:26:30', NULL, NULL, NULL, NULL, NULL),
(3, 'Menu Management', 'setting/menu_management', 4, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:26:58', NULL, NULL, NULL, NULL, NULL),
(4, 'For Admin', '#', 0, NULL, NULL, 'Y', 'admin-top-left', '2016-11-21 20:30:47', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `menu_akses`
--

CREATE TABLE IF NOT EXISTS `menu_akses` (
  `id_menu_akses` int(11) NOT NULL AUTO_INCREMENT,
  `id_menu_fk` int(11) DEFAULT NULL,
  `id_users_group_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_menu_akses`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `menu_akses`
--

INSERT INTO `menu_akses` (`id_menu_akses`, `id_menu_fk`, `id_users_group_fk`) VALUES
(4, 4, 1),
(5, 1, 1),
(6, 2, 1),
(7, 3, 1);

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

