-- Add payment_id column to commissions table if it doesn't exist
ALTER TABLE `commissions` ADD COLUMN `payment_id` BIGINT UNSIGNED NULL AFTER `withdrawal_request_id`;

-- Add foreign key constraint
ALTER TABLE `commissions` ADD CONSTRAINT `commissions_payment_id_foreign` 
FOREIGN KEY (`payment_id`) REFERENCES `payments`(`id`) ON DELETE SET NULL;

-- Add index for better query performance
CREATE INDEX `idx_commissions_payment_id` ON `commissions`(`payment_id`);