[BLOB], 'image/jpeg', 'Diterima', '2025-12-25 09:42:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-25 09:42:30', NULL, NULL);

--
-- Indexes for table `info_warga`
--
ALTER TABLE `info_warga`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tanggal` (`tanggal_mulai`);

--
-- Indexes for table `laporan`
--
ALTER TABLE `laporan`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode_laporan` (`kode_laporan`),
  ADD KEY `idx_kode` (`kode_laporan`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_tanggal` (`tanggal_lapor`),
  ADD KEY `idx_no_hp_tanggal` (`no_hp`,`tanggal_lapor`);

--
-- AUTO_INCREMENT for table `info_warga`
--
ALTER TABLE `info_warga`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `laporan`
--
ALTER TABLE `laporan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
COMMIT;

