-- Tabel Laporan Opsmit — jalankan sekali jika tabel belum ada:
--   mysql -u root -p perawatan < laporan_opsmit.sql
CREATE TABLE IF NOT EXISTS laporan_opsmit (
  id              INT AUTO_INCREMENT PRIMARY KEY,
  divisi          VARCHAR(30)  NOT NULL,
  tanggal         DATE         NOT NULL,
  nomor           VARCHAR(30)  NULL,
  kategori_alat   VARCHAR(100) NULL,
  ma              DECIMAL(8,2) NULL,
  jam_jalan       DECIMAL(10,2) NULL,
  jam_bd          DECIMAL(10,2) NULL,
  jumlah_alat     INT NULL,
  total_alat      INT NULL,
  unit            VARCHAR(50)  NULL,
  ma_unit         DECIMAL(8,2) NULL,
  jam_jalan_unit  DECIMAL(10,2) NULL,
  jam_bd_unit     DECIMAL(10,2) NULL,
  keterangan      TEXT NULL,
  status_sekarang VARCHAR(30)  NULL,
  estimasi_ready  DATE NULL,
  created_by      VARCHAR(50)  NULL,
  created_at      TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_divisi_tanggal (divisi, tanggal)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;