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


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


-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 28, 2016 at 11:22 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `a001`
--
