CREATE TABLE certificate_issuances (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    recipient_name VARCHAR(150) NOT NULL,
    certificate_code VARCHAR(20) NOT NULL UNIQUE,
    issued_at DATETIME NOT NULL,
    created_at DATETIME NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;