Schema Verification Failure

Diagnostic Findings

• Missing Columns: shipments.reconciliation_status Required

SQL Migration Steps

Please run the following database migration script to restore database integrity:

-- ==========================================================
-- COD Matcher - Database Migration Script
-- Target: Adds the missing 'reconciliation_status' column
-- ==========================================================

-- ----------------------------------------------------------
-- For MySQL Database:
-- ----------------------------------------------------------
-- Run this if you are running a MySQL / MariaDB server:
ALTER TABLE `shipments` 
ADD COLUMN `reconciliation_status` VARCHAR(50) NOT NULL DEFAULT 'Pending' 
AFTER `remittance_batch`;

-- ----------------------------------------------------------
-- For SQLite Database (Sandbox/Preview Mode):
-- ----------------------------------------------------------
-- Run this if you are running SQLite (if the column doesn't exist):
-- ALTER TABLE `shipments` ADD COLUMN `reconciliation_status` TEXT DEFAULT 'Pending';