CREATE TABLE secrets (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE,
    environment ENUM ('DEV','TEST','PROD'),
    category VARCHAR(50),
    encrypted_key MEDIUMTEXT,
    encrypted_value MEDIUMTEXT,
    algorithm VARCHAR(30),
    version INT,
    enabled TINYINT DEFAULT 1,
    tempo_creazione TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    tempo_modifica TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    operatore VARCHAR(50) DEFAULT 'system'
);