import {MigrationInterface, QueryRunner, Table} from "typeorm";

export class CreateProducts1648820162516 implements MigrationInterface {

    public async up(queryRunner: QueryRunner): Promise<void> {
        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<void> {
        await queryRunner.dropTable('products');
    }

}