ALTER TABLE `rooms101_rtsdev`.`roomsales`
    MODIFY COLUMN `hotel_billing_id` int(11) NULL DEFAULT 0 AFTER `sales_id`,
    MODIFY COLUMN `price` decimal(9, 2) NULL DEFAULT 0.00 AFTER `departdate`,
    MODIFY COLUMN `cost` decimal(9, 2) NULL DEFAULT 0.00 AFTER `price`,
    MODIFY COLUMN `grossrevenue` decimal(9, 2) NULL DEFAULT 0.00 AFTER `cost`,
    MODIFY COLUMN `roombilldate` date NULL AFTER `grossrevenue`;
