qimall/addons/Seckill/console/migrations/M241126145855CreateAddonsSeckillActivityUser.php

<?php

namespace addons\Seckill\console\migrations;

use yii\db\Migration;

/**
 * Class M241126145855CreateAddonsSeckillActivityUser
 */
class M241126145855CreateAddonsSeckillActivityUser extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = <<<SQL
            CREATE TABLE `qimall_addons_seckill_activity_user` (
               `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
               `mall_id` int(11) NOT NULL DEFAULT '0',
               `activity_id` int(11) NOT NULL DEFAULT '0' COMMENT '活动ID',
               `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单ID',
               `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
               `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '数据状态[-1:删除;0:禁用;1启用]',
               `created_at` int(10) NOT NULL DEFAULT '0',
               `updated_at` int(10) NOT NULL DEFAULT '0',
               PRIMARY KEY (`id`) USING BTREE,
               KEY `activity_id` (`activity_id`) USING BTREE,
               KEY `user_id` (`user_id`) USING BTREE
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='秒杀活动用户参与表';
SQL;
            $this->execute($sql);
        }catch (\Exception $e){

        }

    }

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

        return false;
    }

}