import { MigrationInterface, QueryRunner } from "typeorm"

export class AddUserOldPasswordEntity1743751185577 implements MigrationInterface {
  name = "AddUserOldPasswordEntity1743751185577"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE "user_old_passwords" ("id" SERIAL NOT NULL, "user_id" integer NOT NULL, "password" character varying, "created_at" TIMESTAMP DEFAULT NOW(), "updated_at" TIMESTAMP DEFAULT NOW(), "deleted_at" TIMESTAMP, CONSTRAINT "PK_0f974b0eac48985bc9f44570538" PRIMARY KEY ("id"))`,
    )
    await queryRunner.query(
      `ALTER TABLE "user_old_passwords" ADD CONSTRAINT "FK_88b084297dca563cafc952d6853" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "user_old_passwords" DROP CONSTRAINT "FK_88b084297dca563cafc952d6853"`,
    )
    await queryRunner.query(`DROP TABLE "user_old_passwords"`)
  }
}