-- Add POS enhancement statuses to sales table
ALTER TABLE `sales` MODIFY COLUMN `status` ENUM('draft','suspended','completed','cancelled','refunded') DEFAULT 'completed';
ALTER TABLE `sales` MODIFY COLUMN `type` ENUM('pos','invoice','quotation') DEFAULT 'pos';

-- Add suspended_at column for tracking when orders were suspended
ALTER TABLE `sales` ADD COLUMN `suspended_at` TIMESTAMP NULL AFTER `created_at`;
