SET NAMES utf8; SET FOREIGN_KEY_CHECKS=0; ALTER TABLE `t_customer` ADD COLUMN IF NOT EXISTS `customer_phone2` varchar(255) NULL DEFAULT '' AFTER `customer_add`; ALTER TABLE `t_customer` ADD COLUMN IF NOT EXISTS `customer_phone3` varchar(255) NULL DEFAULT '' AFTER `customer_phone2`; ALTER TABLE `t_process_out_calculation` ADD COLUMN IF NOT EXISTS `clearing_storehouse` int(1) NOT NULL DEFAULT 0 AFTER `call_time`; SET FOREIGN_KEY_CHECKS=1;