/** * 1.检测pickup_cardcode表是否需要更新，如果需要则更新pickup_cardcode表 */ $sql = "describe `{$prefix}pickup_cardcode` `usedtime`;"; $need_alter_field = Db::query($sql); if ($need_alter_field&&$need_alter_field[0]['Type']=='int(10)') {//pickup_cardcode Db::startTrans(); try { //3.原有字段更新 $sql = "ALTER TABLE `{$prefix}pickup_cardcode` MODIFY COLUMN `createtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '添加时间' AFTER `card_status`, MODIFY COLUMN `usedtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '使用时间' AFTER `createtime`;"; Db::execute($sql); Db::commit(); } catch (Exception $e) { \think\Log::write("更新{$prefix}pickup_cardcode表字段失败，异常：" . $e->getTraceAsString()); Db::rollback(); } } /** * 2.检测pickup_order表是否需要更新，如果需要则更新pickup_order表 */ $sql = "describe `{$prefix}pickup_order` `ship_date`;"; $need_alter_field = Db::query($sql); if ($need_alter_field&&$need_alter_field[0]['Type']=='int(10)') {//pickup_order Db::startTrans(); try { //3.原有字段更新 $sql = "ALTER TABLE `{$prefix}pickup_order` MODIFY COLUMN `gift_goods_title` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '礼品名称' AFTER `gift_goods_ids`, MODIFY COLUMN `gift_goods_image` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '礼品图片' AFTER `gift_goods_title`; MODIFY COLUMN `ship_date_expected` bigint(11) NOT NULL DEFAULT 0 COMMENT '预约发货日期' AFTER `address`, MODIFY COLUMN `createtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '下单时间' AFTER `card_id`, MODIFY COLUMN `ship_date` bigint(11) NOT NULL DEFAULT 0 COMMENT '发货时间' AFTER `kd_number`;"; Db::execute($sql); Db::commit(); } catch (Exception $e) { \think\Log::write("更新{$prefix}pickup_order表字段失败，异常：" . $e->getTraceAsString()); Db::rollback(); } } /** * 3.检测pickup_package表是否需要更新，如果需要则更新pickup_cardcode表 */ $sql = "describe `{$prefix}pickup_package` `start_time`;"; $need_alter_field = Db::query($sql); if ($need_alter_field&&$need_alter_field[0]['Type']=='int(10)') {//pickup_package Db::startTrans(); try { //3.原有字段更新 $sql = "ALTER TABLE `{$prefix}pickup_package` MODIFY COLUMN `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT '活动开始时间' AFTER `status`, MODIFY COLUMN `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT '活动结束时间' AFTER `start_time`, MODIFY COLUMN `createtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '创建时间' AFTER `goods_list`;"; Db::execute($sql); Db::commit(); } catch (Exception $e) { \think\Log::write("更新{$prefix}pickup_package表字段失败，异常：" . $e->getTraceAsString()); Db::rollback(); } } // } }