import { MigrationInterface, QueryRunner } from "typeorm";

export class BreachPassword1743169195137 implements MigrationInterface {
    name = 'BreachPassword1743169195137'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE TABLE \`breach_password\` (\`id\` int NOT NULL AUTO_INCREMENT, \`password\` varchar(255) NOT NULL, \`source\` varchar(100) NULL, \`imported_at\` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), UNIQUE INDEX \`IDX_b14a51d06991633c8daf655b4a\` (\`password\`), PRIMARY KEY (\`id\`)) ENGINE=InnoDB`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP INDEX \`IDX_b14a51d06991633c8daf655b4a\` ON \`breach_password\``);
        await queryRunner.query(`DROP TABLE \`breach_password\``);
    }

}