

CREATE TABLE IF NOT EXISTS `sahibinden_logs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mode_used` enum('csv','cookie','playwright') NOT NULL,
  `status` enum('success','error','fallback_triggered') NOT NULL,
  `products_checked` int(11) DEFAULT 0,
  `products_updated` int(11) DEFAULT 0,
  `message` text NOT NULL, -- Masked/Sanitized messages only
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
