-- Tabel: Laporan Kasir / Pembayaran Tunai
-- Kolom: tanggal, shift (Pagi/Siang/Malam), nominal, keterangan (null)

CREATE TABLE IF NOT EXISTS `laporan_kasir` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tanggal` date NOT NULL,
  `shift` enum('Pagi','Siang','Malam') NOT NULL,
  `nominal` bigint(20) NOT NULL DEFAULT 0,
  `keterangan` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tanggal` (`tanggal`),
  KEY `shift` (`shift`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
