qimall/addons/AvoidTax/console/migrations/M230601180812AddTable.php

<?php

namespace addons\AvoidTax\console\migrations;

use yii\db\Migration;

/**
 * Class M230601180812AddTable
 */
class M230601180812AddTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            // 插入表数据
            $sql = "CREATE TABLE `qimall_addons_tax_ly_import_sign_user` (
                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                `mall_id` int(10) unsigned NOT NULL,
                `user_id` int(10) unsigned NOT NULL,
                `batch_num` varchar(32) NOT NULL COMMENT '批次号',
                `sign_users` longtext COMMENT '导入用户信息',
                `response` longtext COMMENT '返回的内容',
                `created_at` int(10) DEFAULT NULL,
                `updated_at` int(10) DEFAULT NULL,
                PRIMARY KEY (`id`)
            ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户签约导入表';
            CREATE TABLE `qimall_addons_tax_ly_silent_sign` (
                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                `mall_id` int(10) NOT NULL,
                `user_id` int(10) unsigned NOT NULL,
                `name` varchar(32) NOT NULL COMMENT '真实姓名',
                `phone` varchar(32) NOT NULL COMMENT '手机号码',
                `id_card` varchar(32) NOT NULL COMMENT '身份证',
                `account_id` varchar(32) NOT NULL COMMENT '企业账号ID',
                `template_id` varchar(32) DEFAULT NULL COMMENT '企业合同ID',
                `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
                `callback_url` varchar(255) DEFAULT NULL COMMENT '成功回调链接',
                `extra_msg` varchar(255) DEFAULT NULL COMMENT '附加信息',
                `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
                `response` longtext COMMENT '响应信息',
                `created_at` int(10) DEFAULT NULL,
                `updated_at` int(10) DEFAULT NULL,
                PRIMARY KEY (`id`)
            ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户电签表';
            ";
            $this->execute($sql);
        } catch (\Exception $e) {

        }
    }

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

        return false;
    }
}