CREATE TABLE `tb_closing` (
  `UserId` VARCHAR(25) NOT NULL,
  `TglClosing` DATE NOT NULL,
  `SaldoAwal` DECIMAL(15,5) DEFAULT 0,
  `UangMasuk` DECIMAL(15,5) DEFAULT 0,
  `TotalAkhir` DECIMAL(15,5) DEFAULT 0,
  `UangLaci` DECIMAL(15,5) DEFAULT 0,
  `NoClose` VARCHAR(11),
  `CreatedAt` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `UpdatedAt` TIMESTAMP NULL,
  PRIMARY KEY (`UserId`, `TglClosing`)
);

ALTER TABLE `tr_jualr_m`
DROP INDEX `NoClose`,
ADD INDEX ( `NoClose`,`kasir`);