ALTER TABLE `supplier`
ADD COLUMN `accountNo` varchar(50) NOT NULL DEFAULT '' AFTER `supplierGroupId`;
CREATE INDEX `accountNo` ON `supplier`(`accountNo`) USING BTREE;

ALTER TABLE `supplier`
ADD COLUMN `creditLimit` float(12,4) NOT NULL DEFAULT 0.0000 AFTER `supplierGroupId`;
CREATE INDEX `creditLimit` ON `supplier`(`creditLimit`) USING BTREE;

ALTER TABLE `supplier`
ADD COLUMN `notes` varchar(500) NOT NULL DEFAULT '' AFTER `supplierGroupId`;
