USE `bridge`;
CREATE TABLE IF NOT EXISTS `ska_penerimaan_execute` (
  `ID` bigINT NOT NULL AUTO_INCREMENT,
  `PENERIMAAN` INT NOT NULL COMMENT 'ID Tabel ska_penerimaan',
  `JENIS` TINYINT NOT NULL DEFAULT '2' COMMENT '2 = Final, 1=Batal',
  `FLAG` TINYINT NOT NULL DEFAULT '0' COMMENT '1 = Belum Eksekusi, 0=Sudah Eksekusi',
  `INPUT_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  KEY `PENERIMAAN` (`PENERIMAAN`),
  KEY `FLAG_FINAL` (`JENIS`),
  KEY `FLAG_BATAL` (`FLAG`)
) ENGINE=InnoDB;