<?php
namespace app\migrations;
use yii\db\Migration;

class m220803_150614_create_qimall_system_version_log extends Migration
{


    public function safeUp()
    {
        $table = 'qimall_system_version_log';
        $sql="select * from information_schema.TABLES where TABLE_NAME = '{$table}';";
        $res = $this->db->createCommand($sql)->execute();
        if(!empty($res)) return '';
        $this->execute("CREATE TABLE `qimall_system_version_log` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `mian_version` varchar(32) NOT NULL DEFAULT '' COMMENT '当前主商城版本',
          `addons_version` text COMMENT '当前插件版本',
          `upgrade_mian_version` varchar(32) NOT NULL DEFAULT '' COMMENT '升级主商城版本',
          `upgrade_addons_version` text COMMENT '升级插件版本',
          `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态：0-更新中，1-更新完成',
          `created_at` int(11) NOT NULL DEFAULT '0',
          `updated_at` int(11) NOT NULL DEFAULT '0',
          PRIMARY KEY (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统更新记录表'");
    }

    public function safeDown()
    {
        $this->dropTable('qimall_system_version_log');
    }
}