-- Add L.P.O (Local Purchase Order) number field to sales table
-- Run this query to add the lpo_number column if it doesn't exist

ALTER TABLE `db_sales` ADD COLUMN IF NOT EXISTS `lpo_number` VARCHAR(100) NULL DEFAULT NULL COMMENT 'Local Purchase Order Number' AFTER `reference_no`;

-- Add index for faster searching
ALTER TABLE `db_sales` ADD INDEX IF NOT EXISTS `idx_lpo_number` (`lpo_number`);
