-- Add PDF file path column to certificates table for storing generated PDF paths
-- This allows the system to track which PDF was generated for each certificate

ALTER TABLE certificates ADD COLUMN pdf_file_path VARCHAR(255) DEFAULT NULL AFTER description;
ALTER TABLE certificates ADD COLUMN generated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER pdf_file_path;

-- Add index for faster lookups
ALTER TABLE certificates ADD KEY idx_pdf_file (pdf_file_path);
