ALTER TABLE `sales` ADD `service_id` INT NOT NULL AFTER `warehouse_id`; ALTER TABLE `sales` ADD `warehouse_last_id` INT NOT NULL AFTER `rep_id`; 2/8/2018 ALTER TABLE `sales_return_items` ADD `item_cost` DECIMAL(25,2) NOT NULL AFTER `discount`;