import {MigrationInterface, QueryRunner} from "typeorm";

export class AddProductScore1655447688024 implements MigrationInterface {
    name = 'AddProductScore1655447688024'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "pages" ADD "productScore" integer NOT NULL DEFAULT '0'`);
        await queryRunner.query(`ALTER TABLE "pages" ALTER COLUMN "lastScrapedAt" SET DEFAULT 'NOW()'`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "pages" ALTER COLUMN "lastScrapedAt" SET DEFAULT '2022-06-07 07:41:11.827223+00'`);
        await queryRunner.query(`ALTER TABLE "pages" DROP COLUMN "productScore"`);
    }

}