qimall/console/migrations/M230204032343CreateImportLogTable.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230204032343CreateImportLogTable
 */
class M230204032343CreateImportLogTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $log_sql = "CREATE TABLE `qimall_import_log` (
            `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
            `mall_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商城ID',
            `source` varchar(255) NOT NULL DEFAULT '' COMMENT '来源',
            `upload_file` varchar(255) NOT NULL DEFAULT '' COMMENT '上传文件存在路径',
            `counts` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '导入数量',
            `success_counts` smallint(6) unsigned NOT NULL DEFAULT '6' COMMENT '导入成功数量',
            `fail_counts` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '导入失败数量',
            `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态：1：导入成功；2导入失败；3：导入中；4：导入中断',
            `created_at` int(11) unsigned NOT NULL DEFAULT '0',
            `updated_at` int(11) unsigned NOT NULL DEFAULT '0',
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
        $this->execute($log_sql);

        $log_fail_sql = "CREATE TABLE `qimall_import_fail_log` (
            `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
            `mall_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商城ID',
            `import_log_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '导入批次id',
            `data_row_id` varchar(60) NOT NULL DEFAULT '' COMMENT '数据行标识',
            `reason` mediumtext NOT NULL COMMENT '失败原因',
            `extra` text COMMENT '导入的内容',
            `created_at` int(11) unsigned NOT NULL DEFAULT '0',
            `updated_at` int(11) unsigned NOT NULL DEFAULT '0',
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4;";
        $this->execute($log_fail_sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}