USE ris;

ALTER TABLE `hl7_logs`
	CHANGE COLUMN `TINDAKAN_MEDIS` `REF_ID` CHAR(11) NOT NULL AFTER `ID`,
	DROP INDEX `TINDAKAN_MEDIS_JENIS_KODE`,
	ADD UNIQUE INDEX `REF_ID_JENIS_KODE` (`REF_ID`, `JENIS`, `KODE`);
