use bridge;

CREATE TABLE `ska_mapping_mak_ruangan` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `RUANGAN` varchar(10) NOT NULL,
  `MAK` varchar(100) NOT NULL COMMENT 'Kode MAK Kendali (pemisah tanda koma jika lebih dari 1)',
  `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 `RUANGAN` (`RUANGAN`),
  KEY `STATUS` (`STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;