import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1740481571257 implements MigrationInterface {
    name = 'Migrations1740481571257'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE INDEX "IDX_ef2fb839248017665e5033e730" ON "users" ("first_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_0408cb491623b121499d4fa238" ON "users" ("last_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email") `);
        await queryRunner.query(`CREATE INDEX "IDX_ace513fa30d485cfd25c11a9e4" ON "users" ("role") `);
        await queryRunner.query(`CREATE INDEX "IDX_82d2ea5f3f8a99449e541918b5" ON "users" ("country") `);
        await queryRunner.query(`CREATE INDEX "IDX_3b810c99fae8b4b46555c8bdfc" ON "users" ("gender") `);
        await queryRunner.query(`CREATE INDEX "IDX_7e90f6e505c30378486bf42191" ON "users" ("total_followers") `);
        await queryRunner.query(`CREATE INDEX "IDX_f64da742898680d416e245894f" ON "users" ("total_following") `);
        await queryRunner.query(`CREATE INDEX "IDX_140782cea9e98f68821f1e94c2" ON "users" ("engagement_ratio") `);
        await queryRunner.query(`CREATE INDEX "IDX_1539ab6ddd56a616ae1779ba03" ON "users" ("platforms") `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP INDEX "public"."IDX_1539ab6ddd56a616ae1779ba03"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_140782cea9e98f68821f1e94c2"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_f64da742898680d416e245894f"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_7e90f6e505c30378486bf42191"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_3b810c99fae8b4b46555c8bdfc"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_82d2ea5f3f8a99449e541918b5"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_ace513fa30d485cfd25c11a9e4"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_97672ac88f789774dd47f7c8be"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_0408cb491623b121499d4fa238"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_ef2fb839248017665e5033e730"`);
    }

}