-- Panel giriş + işlem audit (phpMyAdmin — isteğe bağlı; PHP otomatik de kurar)

CREATE TABLE IF NOT EXISTS `panel_giris_log` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `kuryeFirmaId` VARCHAR(32) NOT NULL DEFAULT '',
  `kullaniciId` VARCHAR(32) NOT NULL DEFAULT '',
  `kullaniciAdi` VARCHAR(128) NOT NULL DEFAULT '',
  `gosterimAdi` VARCHAR(255) NOT NULL DEFAULT '',
  `olay` VARCHAR(32) NOT NULL DEFAULT '',
  `ip` VARCHAR(64) NOT NULL DEFAULT '',
  `userAgent` VARCHAR(512) NOT NULL DEFAULT '',
  `tarih` VARCHAR(16) NOT NULL DEFAULT '',
  `saat` VARCHAR(16) NOT NULL DEFAULT '',
  `olusturma` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_firma_zaman` (`kuryeFirmaId`, `olusturma`),
  KEY `idx_kullanici` (`kullaniciId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `panel_islem_log` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `kuryeFirmaId` VARCHAR(32) NOT NULL DEFAULT '',
  `kullaniciId` VARCHAR(32) NOT NULL DEFAULT '',
  `kullaniciAdi` VARCHAR(128) NOT NULL DEFAULT '',
  `gosterimAdi` VARCHAR(255) NOT NULL DEFAULT '',
  `islem` VARCHAR(64) NOT NULL DEFAULT '',
  `hedefTablo` VARCHAR(64) NOT NULL DEFAULT '',
  `hedefId` VARCHAR(64) NOT NULL DEFAULT '',
  `detay` TEXT,
  `ip` VARCHAR(64) NOT NULL DEFAULT '',
  `tarih` VARCHAR(16) NOT NULL DEFAULT '',
  `saat` VARCHAR(16) NOT NULL DEFAULT '',
  `olusturma` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_firma_zaman` (`kuryeFirmaId`, `olusturma`),
  KEY `idx_islem` (`islem`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Son girişler:
-- SELECT * FROM panel_giris_log ORDER BY id DESC LIMIT 50;
-- Silme / kritik işlemler:
-- SELECT * FROM panel_islem_log WHERE islem LIKE '%sil%' ORDER BY id DESC LIMIT 50;