-- ============================================================
-- Migration 023 — Cofre de Senhas
-- Banco: mikafo61_geral_db
-- ============================================================

CREATE TABLE IF NOT EXISTS cofre_senhas (
  id          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  nome        VARCHAR(150) NOT NULL,
  categoria   ENUM('banco','email','ecommerce','infra','sistema','outro') NOT NULL DEFAULT 'outro',
  url         VARCHAR(255) NULL,
  usuario     VARCHAR(255) NOT NULL,
  senha_enc   TEXT NOT NULL,
  observacoes TEXT NULL,
  created_by  INT UNSIGNED NOT NULL,
  updated_by  INT UNSIGNED NULL,
  created_at  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at  TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  deleted_at  DATETIME NULL,
  INDEX idx_categoria (categoria),
  INDEX idx_deleted   (deleted_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cofre_acessos_log (
  id        INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  cofre_id  INT UNSIGNED NOT NULL,
  user_id   INT UNSIGNED NOT NULL,
  acao      ENUM('visualizou','copiou_usuario','copiou_senha','criou','editou','excluiu') NOT NULL,
  ip        VARCHAR(45) NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_cofre (cofre_id),
  INDEX idx_user  (user_id),
  INDEX idx_data  (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
