-- Migration: Add courier_assignments column to client table
-- Date: 2026-02-14
-- Purpose: Store courier partner assignments for each client by priority level

ALTER TABLE `tbl_client` ADD COLUMN `courier_assignments` LONGTEXT DEFAULT NULL COMMENT 'JSON object with priority level keys (1,2,3) mapped to courier partner IDs' AFTER `min_cod_amount`;

-- Add index for faster lookups if needed
ALTER TABLE `tbl_client` ADD KEY `idx_status` (`status`);
