import { MigrationInterface, QueryRunner } from "typeorm";

export class BreachData1742487346581 implements MigrationInterface {
    name = 'BreachData1742487346581'

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

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

}