ALTER TABLE `stocktransfer` ADD COLUMN `status` varchar(20) NOT NULL DEFAULT '' AFTER `totalAmount`;
CREATE INDEX `status` ON `stocktransfer`(`status`) USING BTREE;

ALTER TABLE `stocktransfer` ADD COLUMN `transferType` varchar(50) NOT NULL DEFAULT '' AFTER `status`;
CREATE INDEX `transferType` ON `stocktransfer`(`transferType`) USING BTREE;

ALTER TABLE `stocktransferitem` ADD COLUMN `pickedQty` float(11,4) unsigned DEFAULT 0 AFTER `qty`;
CREATE INDEX `pickedQty` ON `stocktransferitem`(`pickedQty`) USING BTREE;


ALTER TABLE `orderitem` ADD `isAutoCreatedByStockTransfer` TINYINT(1) NULL DEFAULT '0' AFTER `invoiceQty`;
ALTER TABLE `orderitem` ADD INDEX(`isAutoCreatedByStockTransfer`);


ALTER TABLE `receivingitem` ADD `isAutoCreatedByStockTransfer` TINYINT(1) NOT NULL DEFAULT '0' AFTER `syncedWithXero`;
ALTER TABLE `receivingitem` ADD INDEX(`isAutoCreatedByStockTransfer`);

ALTER TABLE `productqtylog` ADD `statusId` int(10) unsigned DEFAULT NULL after `type`;
ALTER TABLE `productqtylog` ADD INDEX(`statusId`);
