-- =====================================================
-- Database Schema Update for Approver Attachments
-- =====================================================
-- Add approver_attachments column to analyst_test_results table
-- Run this in phpMyAdmin or MySQL command line

ALTER TABLE `analyst_test_results` 
ADD COLUMN IF NOT EXISTS `approver_attachments` JSON NULL DEFAULT NULL 
COMMENT 'JSON array of approver attachments' 
AFTER `reviewer_attachments`;

-- Verify the column was added
DESCRIBE `analyst_test_results`;

-- =====================================================
-- Expected Result:
-- You should see approver_attachments column in the table structure
-- =====================================================
