Create Table

CREATE TABLE `stokawal` (
  `Tanggal` date NOT NULL,
  `ID_Barang` varchar(50) NOT NULL,
  `Jumlah` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `UserID` varchar(20) DEFAULT NULL,
  `TglSimpan` datetime DEFAULT CURRENT_TIMESTAMP,
  `Catatan` varchar(255) DEFAULT NULL,
  `SumberInput` varchar(10) NOT NULL DEFAULT 'VOICE',
  `Satuan` varchar(100) NOT NULL,
  `ID_Gudang` varchar(3) NOT NULL,
  PRIMARY KEY (`ID_Barang`,`ID_Gudang`,`Tanggal`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1