ALTER TABLE `visit`
ADD `ifQuoteVisit` tinyint(1) NOT NULL DEFAULT 0 after `visitNo`;
CREATE INDEX `quoteVisit` ON `visit`(`ifQuoteVisit`);

ALTER TABLE `visit`
ADD `quoteValue` double(10,4) NOT NULL DEFAULT 0.0000 AFTER `ifQuoteVisit`;
CREATE INDEX `quoteValue` ON `visit`(`quoteValue`);

ALTER TABLE `visit`
ADD `quoteComments`varchar(1000) NOT NULL DEFAULT '' AFTER `quoteValue`;
