USE `inventory`;
CREATE TABLE IF NOT EXISTS `log_status_mutasi` (
  `ID` INT NOT NULL AUTO_INCREMENT,
  `JENIS` SMALLINT NOT NULL,
  `REF` INT NOT NULL,
  `STATUS` SMALLINT DEFAULT '1',
  `INPUT_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  KEY `JENIS` (`JENIS`),
  KEY `REF` (`REF`),
  KEY `STATUS` (`STATUS`)
) ENGINE=InnoDB;