qimall/addons/StarChain/console/migrations/M240718101123AddOrderItemTable.php

<?php

namespace addons\StarChain\console\migrations;

use addons\StarChain\common\models\Order;
use yii\db\Migration;

/**
 * Class M240718101123AddOrderItemTable
 */
class M240718101123AddOrderItemTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            // 插入表数据
            $sql = <<<SQL
            CREATE TABLE `qimall_addons_star_chain_order_item` (
                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                `mall_id` int(10) unsigned NOT NULL COMMENT 'Mall Id',
                `order_id` int(10) unsigned NOT NULL COMMENT '供应链订单ID',
                `mall_order_id` int(10) unsigned NOT NULL COMMENT '主商城订单ID',
                `order_detail_id` int(10) unsigned NOT NULL COMMENT '主商城订单详情ID',
                `spu_id` varchar(32) NOT NULL COMMENT '供应链端商品ID',
                `sku_id` varchar(32) NOT NULL COMMENT '供应链端Sku Id',
                `num` int(10) unsigned NOT NULL COMMENT '购买数量',
                `updated_at` int(10) unsigned DEFAULT NULL,
                `created_at` int(10) unsigned DEFAULT NULL,
                PRIMARY KEY (`id`),
                KEY `idx_order_id` (`order_id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='供应链订单子订单';
SQL;
            $this->execute($sql);

            // 维护item表数据
            Order::maintainData();
        } catch (\Exception $e) {

        }
    }

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