   `modified` datetime DEFAULT NULL,
   `modifiedBy` int(11) DEFAULT NULL,
   `deleted` datetime DEFAULT NULL,
-  `deletedBy` int(11) DEFAULT NULL,
-  PRIMARY KEY (`id`),
-  KEY `fk_tb_training_assignment_tb_training_subject1` (`tb_training_subject_id`),
-  KEY `fk_tb_training_assignment_tb_trainer1` (`tb_trainer_id`)
+  `deletedBy` int(11) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
 --
--- Struktur dari tabel `tb_training_assignment_student`
+-- Table structure for table `tb_training_assignment_student`
 --
 
 CREATE TABLE IF NOT EXISTS `tb_training_assignment_student` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
+`id` int(11) NOT NULL,
   `tb_training_assignment_id` int(11) NOT NULL,
   `tb_student_id` int(11) NOT NULL,
   `activity` decimal(5,2) DEFAULT '1.00' COMMENT 'NILAI AKTIFITAS',

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

--
-- Struktur dari tabel `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tb_training_unit_plan`
--

CREATE TABLE IF NOT EXISTS `tb_training_unit_plan` (
`id` int(11) NOT NULL,
  `tb_training_id` int(11) NOT NULL,
  `ref_unit_id` int(3) NOT NULL,
  `spread` varchar(500) NOT NULL COMMENT 'KAP, GBPP, SILABI',
