hrms-api-salary/src/migration/1709033553523-update_table_salaryProfile_add_isresult1.ts

import { MigrationInterface, QueryRunner } from "typeorm";

export class UpdateTableSalaryProfileAddIsresult11709033553523 implements MigrationInterface {
    name = 'UpdateTableSalaryProfileAddIsresult11709033553523'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`salaryPeriod\` CHANGE \`year\` \`year\` int NULL COMMENT 'ปีงบประมาณ'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`amount\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`amount\` double NULL COMMENT 'เงินเดือนฐาน'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`amountSpecial\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`amountSpecial\` double NULL COMMENT 'เงินพิเศษ'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`amountUse\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`amountUse\` double NULL COMMENT 'จำนวนเงินที่ใช้เลื่อน'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`positionSalaryAmount\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`positionSalaryAmount\` double NULL COMMENT 'เงินเดือนหลังเลื่อน'`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`positionSalaryAmount\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`positionSalaryAmount\` int NULL COMMENT 'เงินเดือนหลังเลื่อน'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`amountUse\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`amountUse\` int NULL COMMENT 'จำนวนเงินที่ใช้เลื่อน'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`amountSpecial\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`amountSpecial\` int NULL COMMENT 'เงินพิเศษ'`);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` DROP COLUMN \`amount\``);
        await queryRunner.query(`ALTER TABLE \`salaryProfile\` ADD \`amount\` int NULL COMMENT 'เงินเดือนฐาน'`);
        await queryRunner.query(`ALTER TABLE \`salaryPeriod\` CHANGE \`year\` \`year\` int NULL COMMENT 'ปีงบหระมาณ'`);
    }

}