lacemi/data/upgrade/v1.2.4/v1.2.4.sql

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;