import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1740482140570 implements MigrationInterface {
    name = 'Migrations1740482140570'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE INDEX "IDX_1e411e1fb24725497faa92a344" ON "youtube_channels" ("title") `);
        await queryRunner.query(`CREATE INDEX "IDX_1c2cd8f0e059681a7b4233c95d" ON "youtube_channels" ("description") `);
        await queryRunner.query(`CREATE INDEX "IDX_b70269784b30f9574b1949d152" ON "youtube_channels" ("channel_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_71af16db465dcde91a8cf38978" ON "youtube_channels" ("country_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_cf9a5eca2854299ab925586184" ON "youtube_channels" ("city_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_989e367212fd3d06a79a035aa2" ON "youtube_channels" ("gender") `);
        await queryRunner.query(`CREATE INDEX "IDX_ea3e2b5af448efdaf9199a8fc2" ON "facebook_posts" ("title") `);
        await queryRunner.query(`CREATE INDEX "IDX_79d8dbfc42811d472ed4e6a994" ON "facebook_pages" ("user_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_5f0fae8bbd9ee99465b686986b" ON "facebook_pages" ("description") `);
        await queryRunner.query(`CREATE INDEX "IDX_a8791de7929f533d8d38ffa98c" ON "facebook_pages" ("name") `);
        await queryRunner.query(`CREATE INDEX "IDX_099757c50b30bb0248bc07a16f" ON "facebook_pages" ("emails") `);
        await queryRunner.query(`CREATE INDEX "IDX_537bb774e60000ac58dd943e09" ON "facebook_pages" ("city") `);
        await queryRunner.query(`CREATE INDEX "IDX_88135305fccb1f74fc05562b4f" ON "facebook_pages" ("country") `);
        await queryRunner.query(`CREATE INDEX "IDX_5eb1e546d239a808273717b742" ON "facebook_pages" ("gender") `);
        await queryRunner.query(`CREATE INDEX "IDX_5fc1a0c04f3e0f721c9f0f50f2" ON "instagram_medias" ("username") `);
        await queryRunner.query(`CREATE INDEX "IDX_e936e71c572140093203097ccc" ON "instagram_profiles" ("user_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_9f5c5fa625198f3f617a96695d" ON "instagram_profiles" ("description") `);
        await queryRunner.query(`CREATE INDEX "IDX_a73b6c379819726ee32f73c9f3" ON "instagram_profiles" ("name") `);
        await queryRunner.query(`CREATE INDEX "IDX_fffd49525f709131b604a6a899" ON "instagram_profiles" ("country_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_f0b63664fd6461fc0e81f7c2f8" ON "instagram_profiles" ("city_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_2f87b68e00c3ba66fb692d18f6" ON "instagram_profiles" ("gender") `);
        await queryRunner.query(`CREATE INDEX "IDX_3af689b188ac698f88413d0b75" ON "tiktok_profiles" ("bio_description") `);
        await queryRunner.query(`CREATE INDEX "IDX_6e7ff24671293050b97a236068" ON "tiktok_profiles" ("open_id") `);
        await queryRunner.query(`CREATE INDEX "IDX_b2158ebcfe6a6ab47cbaf03813" ON "tiktok_profiles" ("username") `);
        await queryRunner.query(`CREATE INDEX "IDX_3efb71616f0e39fefb83c66dde" ON "tiktok_profiles" ("display_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_f1ae328457ff1cfad8e35e19b6" ON "tiktok_profiles" ("country_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_140202f98e82d44e7a0264299b" ON "tiktok_profiles" ("city_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_7d98d7af8d15671df59536647f" ON "tiktok_profiles" ("gender") `);
        await queryRunner.query(`CREATE INDEX "IDX_b33c5ad87580b8bcab8c44a7fa" ON "xiaohongshu_profiles" ("name") `);
        await queryRunner.query(`CREATE INDEX "IDX_fb380084aa8cd274d135da0a2c" ON "xiaohongshu_profiles" ("user_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_5322238580bd33f9fe67791ddd" ON "xiaohongshu_profiles" ("country_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_29b4cd3b18cf784eba26ba4b03" ON "xiaohongshu_profiles" ("description") `);
        await queryRunner.query(`CREATE INDEX "IDX_259b73bd59e4f6a6bbafdfb596" ON "xiaohongshu_profiles" ("city_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_2358fd1252c4f8b3dae38a85ee" ON "xiaohongshu_profiles" ("gender") `);
        await queryRunner.query(`CREATE INDEX "IDX_e44168c54becf5d2ebbafe1af4" ON "social_medias" ("social_id") `);
        await queryRunner.query(`CREATE INDEX "IDX_258e8333d8bf0cb5a3fb68a761" ON "social_medias" ("social_user_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_aa79448dc3e959720ab4c13651" ON "categories" ("title") `);
        await queryRunner.query(`CREATE INDEX "IDX_420d9f679d41281f282f5bc7d0" ON "categories" ("slug") `);
        await queryRunner.query(`CREATE INDEX "IDX_38b72100fbc5d6fcc98bd89c0b" ON "keywords" ("keyword") `);
        await queryRunner.query(`CREATE INDEX "IDX_8a57a7c6665c212c3324f8b35d" ON "campaigns" ("campaign_name") `);
        await queryRunner.query(`CREATE INDEX "IDX_a0d1755d181035fa13ffb64307" ON "campaigns" ("slug") `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP INDEX "public"."IDX_a0d1755d181035fa13ffb64307"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_8a57a7c6665c212c3324f8b35d"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_38b72100fbc5d6fcc98bd89c0b"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_420d9f679d41281f282f5bc7d0"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_aa79448dc3e959720ab4c13651"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_258e8333d8bf0cb5a3fb68a761"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_e44168c54becf5d2ebbafe1af4"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_2358fd1252c4f8b3dae38a85ee"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_259b73bd59e4f6a6bbafdfb596"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_29b4cd3b18cf784eba26ba4b03"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_5322238580bd33f9fe67791ddd"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_fb380084aa8cd274d135da0a2c"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_b33c5ad87580b8bcab8c44a7fa"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_7d98d7af8d15671df59536647f"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_140202f98e82d44e7a0264299b"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_f1ae328457ff1cfad8e35e19b6"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_3efb71616f0e39fefb83c66dde"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_b2158ebcfe6a6ab47cbaf03813"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_6e7ff24671293050b97a236068"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_3af689b188ac698f88413d0b75"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_2f87b68e00c3ba66fb692d18f6"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_f0b63664fd6461fc0e81f7c2f8"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_fffd49525f709131b604a6a899"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_a73b6c379819726ee32f73c9f3"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_9f5c5fa625198f3f617a96695d"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_e936e71c572140093203097ccc"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_5fc1a0c04f3e0f721c9f0f50f2"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_5eb1e546d239a808273717b742"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_88135305fccb1f74fc05562b4f"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_537bb774e60000ac58dd943e09"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_099757c50b30bb0248bc07a16f"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_a8791de7929f533d8d38ffa98c"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_5f0fae8bbd9ee99465b686986b"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_79d8dbfc42811d472ed4e6a994"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_ea3e2b5af448efdaf9199a8fc2"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_989e367212fd3d06a79a035aa2"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_cf9a5eca2854299ab925586184"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_71af16db465dcde91a8cf38978"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_b70269784b30f9574b1949d152"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_1c2cd8f0e059681a7b4233c95d"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_1e411e1fb24725497faa92a344"`);
    }

}