import { MigrationInterface, QueryRunner } from 'typeorm';

export class createCustomersTable1672265069601 implements MigrationInterface {
  name = 'createCustomersTable1672265069601';

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE \`customers\`
       ( \`id\` INT(11) NOT NULL AUTO_INCREMENT ,
        \`name\` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
        \`image\` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
        \`displayOrder\` INT(11) NULL , \`deleted\` TINYINT(1) NULL ,
        \`createdAt\` DATETIME NOT NULL , \`updatedAt\` DATETIME NOT NULL ,
        PRIMARY KEY (\`id\`)) ENGINE = InnoDB;`,
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    //
  }
}