 -- --------------------------------------------------------
 
 --
--- 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,
+-- Table structure for table `hr_m_agama`
+--
+
+CREATE TABLE IF NOT EXISTS `hr_m_agama` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nm_agama` varchar(20) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
+
+--
+-- Dumping data for table `hr_m_agama`
+--
+
+INSERT INTO `hr_m_agama` (`id`, `nm_agama`) VALUES
+(1, 'Islam'),
+(2, 'Kristen'),
+(3, 'Hindu'),
+(4, 'Budha');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `hr_m_bagian`
+--
+
+CREATE TABLE IF NOT EXISTS `hr_m_bagian` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nm_bagian` varchar(20) DEFAULT NULL,
+  `kd_jns_usaha` 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_kary`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `m_hrm_karyawan`
--


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

--
-- Table structure for table `m_hrm_sex`
--

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

--
-- Dumping data for table `m_hrm_sex`
--


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

--
-- Table structure for table `m_hrm_statuskary`
--

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

--
-- Dumping data for table `m_hrm_statuskary`
--


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


) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- 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,
