import {MigrationInterface, QueryRunner, Table} from "typeorm"; export class CreateProducts1648820162516 implements MigrationInterface { public async up(queryRunner: QueryRunner): Promise { await queryRunner.createTable(new Table({ name: 'products', columns: [ { name: 'id', type: 'uuid', isPrimary: true, isGenerated: true, default: 'uuid_generate_v4()', }, { name: 'name', type: 'varchar', }, { name: 'unit_price', type: 'decimal(12,2)', }, { name: 'is_discontinued', type: 'boolean', }, { name: 'description', type: 'text', }, { name: 'image', type: 'varchar', }, { name: 'created_at', type: 'timestamptz', default: 'now()', }, { name: 'updated_at', type: 'timestamptz', default: 'now()', }, ] })); } public async down(queryRunner: QueryRunner): Promise { await queryRunner.dropTable('products'); } }