qimall/addons/Purchase/console/migrations/M221026074140CreateQimallAddonsPurchaseManager.php

<?php

namespace addons\Purchase\console\migrations;

use yii\db\Migration;

/**
 * Class M221026074140CreateQimallAddonsPurchaseManager
 */
class M221026074140CreateQimallAddonsPurchaseManager extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "CREATE TABLE `qimall_addons_purchase_manager`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NULL DEFAULT 0 COMMENT '商城ID',
  `user_id` int(10) NULL DEFAULT 0 COMMENT '会员ID',
  `mobile` bigint(20) NULL DEFAULT 0 COMMENT '手机号码',
  `apply_uid` int(10) NULL DEFAULT 0 COMMENT '申请人',
  `license` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '营业执照',
  `store_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '店铺抬头',
  `idcart_front` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证照(正)',
  `idcart_back` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '身份证照(反)',
  `idcart_hands` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '身份证照(手持)',
  `is_poss` tinyint(1) NOT NULL DEFAULT 0 COMMENT '审核状态[0审核中 1审核通过 -1拒绝]',
  `reason` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '失败原因',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id`(`mall_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '店长表' ROW_FORMAT = Dynamic;";
        $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}