ALTER TABLE `supplier` ADD COLUMN `isNoLongerTrading`  tinyint(1) NOT NULL DEFAULT 0 AFTER `abn`;
CREATE INDEX `isNoLongerTrading` ON `supplier`(`isNoLongerTrading`) USING BTREE ;
