qimall/console/migrations/M230105081906MembersCard.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 *
 * Class M230105081906MembersCard
 */
class M230105081906MembersCard extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            /*亲友卡新增*/
            $sql = "ALTER TABLE `qimall_user_level` ADD COLUMN `is_open_expired`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启会员期限', ADD COLUMN `expired_day`  int(11) NOT NULL DEFAULT 0 COMMENT '会员有效期';
            ALTER TABLE `qimall_order_marketing` ADD COLUMN `user_card_id`  varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户会员卡id map';
            INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('MembersCard', '亲友卡', 'IncomeMap', '1', '1', '1654569888', '1654569888');
            INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('MembersCard', '亲友卡', 'FromTypeMap', '1', '1', '1654569888', '1654569888');
            INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('会员等级过期', 'user-level/level-expired', '2', '0 */30 * * * *', '0', '1', '1672645798', '1672645798');
            CREATE TABLE `qimall_user_level_expired` (
                `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
                `mall_id` int(11) NOT NULL,
                `user_id` int(11) NOT NULL DEFAULT '0',
                `level` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员等级',
                `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
                `created_at` int(11) NOT NULL DEFAULT '0',
                `updated_at` int(11) NOT NULL DEFAULT '0',
                `expired_at` int(11) NOT NULL DEFAULT '0' COMMENT '会员有效期',
                PRIMARY KEY (`id`) USING BTREE,
                KEY `mall_id` (`mall_id`) USING BTREE,
                KEY `level` (`level`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='会员等级期限表';";
            $this->execute($sql);
        }catch (\Exception $e){

        }
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}