-- Remove constraint
ALTER TABLE orders DROP CONSTRAINT IF EXISTS check_remaining_amount_non_negative;

-- Remove remaining_amount column from orders table
ALTER TABLE orders DROP COLUMN IF EXISTS remaining_amount;