qimall/addons/CloudStock/console/migrations/M240908043951CreateTableOrderBatchDelivery.php

<?php

namespace addons\CloudStock\console\migrations;

use yii\db\Migration;

/**
 * Class M240908043951CreateTableOrderBatchDelivery
 */
class M240908043951CreateTableOrderBatchDelivery extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql="CREATE TABLE `qimall_addons_cloud_stock_order_batch_delivery`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `mall_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商城ID',
  `operator_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作人ID',
  `operator_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作人昵称',
  `delivery_file` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '批量发货文件地址',
  `express_id` int(10) NOT NULL DEFAULT 0 COMMENT '快递公司id',
  `express_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流公司名称',
  `delivery_num` int(10) NOT NULL DEFAULT 0 COMMENT '发货单数',
  `success_delivery_num` int(10) NOT NULL DEFAULT 0 COMMENT '成功发货单数',
  `delivery_status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '批量发货状态【0:处理中，1:已完成】',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态【1启用 0禁用 -1删除】',
  `created_at` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id`(`mall_id`) USING BTREE,
  INDEX `operator_name`(`operator_name`) USING BTREE,
  INDEX `created_at`(`created_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单批量发货记录表' ROW_FORMAT = DYNAMIC;";
        $this->execute($sql);
        $sql="CREATE TABLE `qimall_addons_cloud_stock_order_batch_delivery_error`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `mall_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商城ID',
  `batch_delivery_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'qimall_order_batch_delivery.id',
  `order_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `express_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流单号',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '错误原因',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态【1启用 0禁用 -1删除】',
  `created_at` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id`(`mall_id`) USING BTREE,
  INDEX `batch_delivery_id`(`batch_delivery_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单批量发货错误日志表' ROW_FORMAT = DYNAMIC;";
 $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M240908043951CreateTableOrderBatchDelivery cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M240908043951CreateTableOrderBatchDelivery cannot be reverted.\n";

        return false;
    }
    */
}