 -- --------------------------------------------------------
 
 --
--- Struktur dari tabel `ref_religion`
+-- Table structure for table `ref_religion`
 --
 
 CREATE TABLE IF NOT EXISTS `ref_religion` (

  `modified` datetime DEFAULT NULL,
  `modifiedBy` int(11) DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_tb_program_subject_tb_program1` (`tb_program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Struktur dari tabel `tb_rights`
--

CREATE TABLE IF NOT EXISTS `tb_rights` (
  `itemname` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  PRIMARY KEY (`itemname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktur dari tabel `tb_room`
--

CREATE TABLE IF NOT EXISTS `tb_room` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `ref_satker_id` int(3) NOT NULL DEFAULT '0',
  `code` varchar(25) NOT NULL,
  `name` varchar(255) NOT NULL,

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

--
-- Table structure for table `tb_authitemchild`
--

CREATE TABLE IF NOT EXISTS `tb_authitemchild` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tb_employee`
--

CREATE TABLE IF NOT EXISTS `tb_employee` (
`id` int(11) NOT NULL,
  `ref_satker_id` int(3) NOT NULL DEFAULT '0',
  `ref_unit_id` int(3) NOT NULL DEFAULT '0',
  `ref_religion_id` int(3) NOT NULL DEFAULT '0',
