David Walsh
38 lines
1.4 KiB
TypeScript
38 lines
1.4 KiB
TypeScript
import { MigrationInterface, QueryRunner, TableColumn, TableIndex } from 'typeorm';
|
|
|
|
const targetTable = 'rfqm_jobs';
|
|
const isCompletedColumn = new TableColumn({
|
|
name: 'is_completed',
|
|
type: 'boolean',
|
|
default: false,
|
|
isNullable: false,
|
|
});
|
|
const workerAddressColumn = new TableColumn({
|
|
name: 'worker_address',
|
|
type: 'varchar',
|
|
isNullable: true,
|
|
});
|
|
const lastLookResultColumn = new TableColumn({
|
|
name: 'last_look_result',
|
|
type: 'boolean',
|
|
isNullable: true,
|
|
});
|
|
|
|
const isCompletedIndex = new TableIndex({ name: `rfqm_jobs_is_completed_index`, columnNames: ['is_completed'] });
|
|
|
|
export class AddWorkerAddressLastLookResultToRfqmJobs1623452505377 implements MigrationInterface {
|
|
public async up(queryRunner: QueryRunner): Promise<void> {
|
|
await queryRunner.addColumn(targetTable, isCompletedColumn);
|
|
await queryRunner.addColumn(targetTable, workerAddressColumn);
|
|
await queryRunner.addColumn(targetTable, lastLookResultColumn);
|
|
await queryRunner.createIndex(targetTable, isCompletedIndex);
|
|
}
|
|
|
|
public async down(queryRunner: QueryRunner): Promise<void> {
|
|
await queryRunner.dropIndex(targetTable, isCompletedIndex);
|
|
await queryRunner.dropColumn(targetTable, isCompletedColumn);
|
|
await queryRunner.dropColumn(targetTable, workerAddressColumn);
|
|
await queryRunner.dropColumn(targetTable, lastLookResultColumn);
|
|
}
|
|
}
|