ALTER TABLE `rooms101_rtsmba`.`addonsales`
    MODIFY COLUMN `price` decimal(9, 2) NULL DEFAULT 0.00 AFTER `qty`,
    MODIFY COLUMN `cost` decimal(9, 2) NULL DEFAULT 0.00 AFTER `price`,
    ADD COLUMN `grossrevenue` decimal(8, 2) NULL AFTER `cost`,
    MODIFY COLUMN `status` int(5) NOT NULL DEFAULT 0 AFTER `cost`;
