import { MigrationInterface, QueryRunner } from "typeorm";

export class SuggestionsDataCreate1635230521296 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE IF NOT EXISTS suggestions_data (
          id INT PRIMARY KEY,
          original_prefix TEXT NOT NULL,
          original_suffix TEXT NOT NULL,
          snapshot_prefix TEXT NOT NULL,
          snapshot_suffix TEXT NOT NULL
        )`
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`DROP TABLE suggestions_data`);
  }
}