 --
 
 CREATE TABLE IF NOT EXISTS `ref_sta_unit` (
-`id` int(11) NOT NULL,
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `induk` int(11) NOT NULL,
   `name` varchar(255) NOT NULL,
-  `eselon` tinyint(1) NOT NULL
+  `eselon` tinyint(1) NOT NULL,
+  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=100000 ;
 
 --

(255, 0, 'DTU ANALISIS JABATAN AKT. II', 0, '2012-05-01', '2012-05-04', '2012-05-01', '2012-05-04', '2012-05-01', '2012-05-04', 0, 0, 'R701 PKU', '', '2012-05-07 11:28:13', '', '[READY]', 1),
(256, 0, 'DTU PEMANTAUAN PENGENDALIAN INTERNAL AKT. I', 0, '2012-06-04', '2012-06-08', '2012-05-07', '2012-05-11', '2012-06-04', '2012-06-08', 0, 0, '', 'semula: DTU PENINGKATAN IMPLEMENTASI PENGENDALIAN INTERNAL AKT. I', '2012-06-13 11:18:44', '', '[READY]', 1),
(258, 0, 'DTU FREE OPEN SOURCE SOFTWARE AKT. II', 0, '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', 0, 0, 'Lab803 PKU', '', '2012-06-11 11:35:55', '', '[READY]', 1),
(259, 0, 'DTU MANAJEMEN RISIKO AKT. III', 0, '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', 0, 0, 'R601 PKU', '', '2012-06-11 11:34:07', '', '[READY]', 1);
INSERT INTO `testing` (`id_training`, `id_program`, `name_training`, `hours_training`, `revision_plan_start_training`, `revision_plan_finish_training`, `plan_start_training`, `plan_finish_training`, `start_training`, `finish_training`, `plan_participant_training`, `participant_training`, `location_training`, `note_training`, `update_training`, `main_user`, `status_training`, `certificate_type`) VALUES
(260, 0, 'DTU PENYUSUNAN SOP (STANDARD OPERATING PROCEDURED) AKT. II', 0, '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', 0, 0, 'R701 PKU', '', '2012-06-11 11:35:05', '', '[READY]', 1),
(261, 0, 'DTU PEMERIKSAAN PELANGGARAN DISIPLIN PEGAWAI AKT. II', 0, '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', 0, 0, 'Hotel/Eksternal', '', '2012-06-11 11:36:24', '', '[READY]', 1),
(262, 0, 'DTU PERSIAPAN PURNABHAKTI AKT. II', 0, '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', '2012-05-07', '2012-05-11', 0, 0, 'Aula PKU', '', '2012-06-14 09:20:27', '', '[READY]', 1),
(263, 0, 'DTU GENERAL ENGLISH AKT. I', 0, '2012-05-07', '2012-05-29', '2012-05-07', '2012-05-29', '2012-05-07', '2012-05-29', 0, 0, 'R603 PKU', '', '2012-06-11 11:39:38', '', '[READY]', 1),

(491, 0, 'PENYEGARAN BUSINESS ENGLISH FOR GOVERNMENT OFFICIALS I', 0, '0000-00-00', '0000-00-00', '2006-06-10', '2006-07-13', '2006-06-10', '2006-07-13', 0, 0, 'Purnawarman', '', '0000-00-00 00:00:00', '', '[READY]', 1),
(492, 0, 'PENYEGARAN BUSINESS ENGLISH FOR GOVERNMENT OFFICIALS II', 0, '0000-00-00', '0000-00-00', '2006-11-28', '2006-12-01', '2006-11-28', '2006-12-01', 0, 0, 'Purnawarman', '', '0000-00-00 00:00:00', '', '[READY]', 1),
(493, 0, 'DTU EDP AUDITING I', 0, '0000-00-00', '0000-00-00', '2005-07-18', '2005-07-22', '2005-07-18', '2005-07-22', 0, 0, 'Purnawarman', '', '0000-00-00 00:00:00', '', '[READY]', 1),
(494, 0, 'DTU EDP AUDITING II', 0, '0000-00-00', '0000-00-00', '2005-08-22', '2005-08-26', '2005-08-22', '2005-08-26', 0, 0, 'Purnawarman', '', '0000-00-00 00:00:00', '', '[READY]', 1),
(495, 0, 'DTU EDP AUDITING III', 0, '0000-00-00', '0000-00-00', '2005-11-14', '2005-11-18', '2005-11-14', '2005-11-18', 0, 0, 'Purnawarman', '', '0000-00-00 00:00:00', '', '[READY]', 1),
(496, 0, 'DTU STATISTICAL AUDIT SAMPLING I', 0, '0000-00-00', '0000-00-00', '2005-04-19', '2005-04-26', '2005-04-19', '2005-04-26', 0, 0, 'Purnawarman', '', '0000-00-00 00:00:00', '', '[READY]', 1);
INSERT INTO `testing` (`id_training`, `id_program`, `name_training`, `hours_training`, `revision_plan_start_training`, `revision_plan_finish_training`, `plan_start_training`, `plan_finish_training`, `start_training`, `finish_training`, `plan_participant_training`, `participant_training`, `location_training`, `note_training`, `update_training`, `main_user`, `status_training`, `certificate_type`) VALUES
(497, 0, 'DTU STATISTICAL AUDIT SAMPLING II', 0, '0000-00-00', '0000-00-00', '2005-05-22', '2005-05-31', '2005-05-22', '2005-05-31', 0, 0, 'Purnawarman', '', '0000-00-00 00:00:00', '', '[READY]', 1),
(498, 0, 'DTU PENGELOLAAN WEB I', 0, '0000-00-00', '0000-00-00', '2005-07-23', '2005-08-22', '2005-07-23', '2005-08-22', 0, 0, 'Jurangmangu', '', '0000-00-00 00:00:00', '', '[READY]', 1),
(499, 0, 'DTU PENGELOLAAN WEB II', 0, '0000-00-00', '0000-00-00', '2005-11-14', '2005-12-01', '2005-11-14', '2005-12-01', 0, 0, 'Jurangmangu', '', '0000-00-00 00:00:00', '', '[READY]', 1),
