Hugging Face's logo

Spaces:
pbl6-cats
/
PBL6-informative-system
Sleeping

App Files Community
PBL6-informative-system
File size: 2,196 Bytes 
9e8f9e3
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
import { MigrationInterface, QueryRunner } from "typeorm";

export class ModifyPayment1730651201156 implements MigrationInterface {
    name = 'ModifyPayment1730651201156'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "value"`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_amount" integer NOT NULL`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_bank_code" character varying`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_bank_tran_no" character varying`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_card_type" integer NOT NULL DEFAULT '0'`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_order_info" character varying`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_paydate" character varying`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_response_code" integer`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_transaction_no" character varying`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "vnp_transaction_status" integer`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_transaction_status"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_transaction_no"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_response_code"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_paydate"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_order_info"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_card_type"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_bank_tran_no"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_bank_code"`);
        await queryRunner.query(`ALTER TABLE "payments" DROP COLUMN "vnp_amount"`);
        await queryRunner.query(`ALTER TABLE "payments" ADD "value" integer NOT NULL`);
    }

}