import { MigrationInterface, QueryRunner } from "typeorm";

export class Add2FA1751895314044 implements MigrationInterface {
    name = 'Add2FA1751895314044'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`users\` ADD \`is_email_verified\` tinyint NOT NULL DEFAULT 0`);
        await queryRunner.query(`ALTER TABLE \`users\` ADD \`email_verification_token\` varchar(255) NULL`);
        await queryRunner.query(`ALTER TABLE \`users\` ADD \`email_verification_token_expires_at\` timestamp NULL`);
        await queryRunner.query(`ALTER TABLE \`users\` ADD \`email_verified_at\` timestamp NULL`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`users\` DROP COLUMN \`email_verified_at\``);
        await queryRunner.query(`ALTER TABLE \`users\` DROP COLUMN \`email_verification_token_expires_at\``);
        await queryRunner.query(`ALTER TABLE \`users\` DROP COLUMN \`email_verification_token\``);
        await queryRunner.query(`ALTER TABLE \`users\` DROP COLUMN \`is_email_verified\``);
    }

}