-- AlterTable OrderItem
ALTER TABLE `OrderItem` 
    ADD COLUMN `additionalGstPercent` DECIMAL(10, 2) NOT NULL DEFAULT 0.00,
    ADD COLUMN `additionalGstAmount` DECIMAL(10, 2) NOT NULL DEFAULT 0.00,
    DROP COLUMN `whTaxPercent`,
    DROP COLUMN `whTaxAmount`;

-- AlterTable OrderPayment
ALTER TABLE `OrderPayment` 
    MODIFY COLUMN `paymentType` ENUM('CASH', 'CHEQUE', 'BANK_TRANSFER', 'CREDIT') NOT NULL,
    MODIFY COLUMN `status` ENUM('PAID', 'PARTIAL', 'REFUNDED', 'DECLINED', 'CREDIT') NOT NULL DEFAULT 'PAID',
    DROP COLUMN `whtAmount`;
