-- File Manager kurulum SQL
-- Joomla 4.3.4

CREATE TABLE IF NOT EXISTS `#__filemanager_log` (
  `id`          INT(11)      NOT NULL AUTO_INCREMENT,
  `user_id`     INT(11)      NOT NULL DEFAULT 0,
  `action`      VARCHAR(20)  NOT NULL DEFAULT '',
  `filename`    VARCHAR(255) NOT NULL DEFAULT '',
  `file_path`   VARCHAR(500) NOT NULL DEFAULT '',
  `file_size`   INT(11)      NOT NULL DEFAULT 0,
  `mime_type`   VARCHAR(100) NOT NULL DEFAULT '',
  `ip_address`  VARCHAR(45)  NOT NULL DEFAULT '',
  `created_at`  DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_id`  (`user_id`),
  KEY `idx_action`   (`action`),
  KEY `idx_created`  (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
