ALTER TABLE `inwards` ADD `inward_type` VARCHAR(50) NULL DEFAULT NULL AFTER `video`, ADD `in_no` VARCHAR(50) NULL DEFAULT NULL AFTER `inward_type`, ADD `purchase_no` VARCHAR(50) NULL DEFAULT NULL AFTER `in_no`, ADD `ref_no` VARCHAR(50) NULL DEFAULT NULL AFTER `purchase_no`;

ALTER TABLE `inward_rackstocks` ADD `inward_id` BIGINT NOT NULL DEFAULT '0' AFTER `status`;

ALTER TABLE `outwards` ADD `place_of_supply` VARCHAR(50) NULL DEFAULT NULL AFTER `custparty_id`, ADD `trade_type` VARCHAR(50) NULL DEFAULT NULL AFTER `place_of_supply`, ADD `ref_no` VARCHAR(50) NULL DEFAULT NULL AFTER `trade_type`, ADD `purchase_no` VARCHAR(50) NULL DEFAULT NULL AFTER `ref_no`, ADD `bill_address` VARCHAR(255) NULL DEFAULT NULL AFTER `purchase_no`, ADD `ship_address` VARCHAR(255) NULL DEFAULT NULL AFTER `bill_address`;

ALTER TABLE `custparties` ADD `state` VARCHAR(50) NULL DEFAULT NULL AFTER `address`;
ALTER TABLE `custparties` ADD `trade_type` VARCHAR(10) NULL DEFAULT NULL AFTER `state`;