import { MigrationInterface, QueryRunner } from "typeorm";

export class UpdateTableProfileemployeeAddGroupNew1711033284607 implements MigrationInterface {
    name = 'UpdateTableProfileemployeeAddGroupNew1711033284607'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` ADD \`salaryLevelNew\` double NULL COMMENT 'ขั้นเงินเดือน(ใหม่)'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` ADD \`group\` int NULL COMMENT 'กลุ่มบัญชีการจ้าง'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` ADD \`groupNew\` int NULL COMMENT 'กลุ่มบัญชีการจ้าง(ใหม่)'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` ADD \`positionSalaryDayAmount\` double NOT NULL COMMENT 'เงินเดือนหลังเลื่อน(รายวัน)' DEFAULT '0'`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` DROP COLUMN \`positionSalaryDayAmount\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` DROP COLUMN \`groupNew\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` DROP COLUMN \`group\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfileEmployee\` DROP COLUMN \`salaryLevelNew\``);
    }

}