qimall/console/migrations/M240606173422CreateTableOrderExtra.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M240606173422CreateTableOrderExtra
 */
class M240606173422CreateTableOrderExtra extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = <<<SQL
                CREATE TABLE `qimall_order_extra` (
                  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                  `mall_id` int(10) unsigned NOT NULL COMMENT 'Mall Id',
                  `mch_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '多商户ID',
                  `store_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID',
                  `order_id` int(10) unsigned NOT NULL COMMENT '订单ID',
                  `message` varchar(255) DEFAULT NULL COMMENT '留言',
                  `updated_at` int(10) DEFAULT '0',
                  `created_at` int(10) DEFAULT '0',
                  PRIMARY KEY (`id`),
                  KEY `mall_id` (`mall_id`),
                  KEY `order_id` (`order_id`)
                ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='订单拓展信息表';
SQL;
            $this->execute($sql);
        } catch (\Exception $e) {

        }
    }

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

        return false;
    }
}