import {
  MigrationInterface,
  QueryRunner,
  TableColumn,
  TableForeignKey,
} from 'typeorm';

export class AlterAppUserTableToAddProvinceAndFcmtoken1729751937498
  implements MigrationInterface
{
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.addColumns('app_users', [
      new TableColumn({
        name: 'province_id',
        type: 'uuid',
        isNullable: true,
      }),
      new TableColumn({
        name: 'zipcode',
        type: 'varchar',
        isNullable: true,
      }),
      new TableColumn({
        name: 'fcm_token',
        type: 'varchar',
        isNullable: true,
      }),
    ]);

    await queryRunner.createForeignKey(
      'app_users',
      new TableForeignKey({
        columnNames: ['province_id'],
        referencedColumnNames: ['id'],
        referencedTableName: 'provinces',
        onDelete: 'SET NULL',
      }),
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.dropColumn('app_users', 'province_id');
    await queryRunner.dropColumn('app_users', 'zipcode');
    await queryRunner.dropColumn('app_users', 'fcm_token');
  }
}