qimall/addons/Community/console/migrations/M230810023255CommunitySmsNoticeCronTask.php

<?php

namespace addons\Community\console\migrations;

use yii\db\Migration;

/**
 * Class M230810023255CommunitySmsNoticeCronTask
 */
class M230810023255CommunitySmsNoticeCronTask extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->execute("CREATE TABLE `qimall_addons_community_notice` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`mall_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Mall ID',
	`status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '状态 [1启用 0禁用 -1删除]',
	`created_at` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
	`user_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
	`send_at` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发送时间',
	`content` JSON NULL DEFAULT NULL COMMENT '发送内容',
	`res` JSON NULL DEFAULT NULL COMMENT '响应内容',
	`mobile` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '接收号码' COLLATE 'utf8mb4_general_ci',
	`area_code` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '区号' COLLATE 'utf8mb4_general_ci',
	`gateway` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '网关' COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `user_id` (`user_id`) USING BTREE,
	INDEX `send_at` (`send_at`) USING BTREE
)
COMMENT='短信通知'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");

        $this->execute("INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('社区团购 - 每分钟检测一次短信发送', 'community/notice-task/send', 2, '0 */1 * * * *', 0, 1, 1673594361, 1673594361);");
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}