import { MigrationInterface, QueryRunner } from "typeorm";

export default class SuggestionsCreate1630331556507
  implements MigrationInterface
{
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE IF NOT EXISTS suggestions (
        id INTEGER PRIMARY KEY,
        user TEXT NOT NULL,
        suggestion_id INTEGER NOT NULL,
        time TEXT NOT NULL,
        original_prefix TEXT NOT NULL,
        original_suffix TEXT NOT NULL,
        snapshot_prefix TEXT NOT NULL,
        snapshot_suffix TEXT NOT NULL,
        language TEXT,
        filename TEXT
      )`
    );
  }

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