ALTER TABLE `order`
ADD `isBackorder` tinyint(1) NOT NULL DEFAULT '0' AFTER `servicejobId`;
CREATE INDEX `isBackorder` ON `order`(`isBackorder`) USING BTREE;


ALTER TABLE `orderitem`
ADD `invoiceQty` double(14,4) NOT NULL DEFAULT 0.0000  AFTER `extraInfo`;
CREATE INDEX `invoiceQty` ON `orderitem`(`invoiceQty`) USING BTREE;
