Platine\Framework\Migration\AddProductsTable20231207060117::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	36
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up(): void
    {
        //Action when migrate up
        $this->create('products', function (CreateTable $table) {
            $table->integer('id')
                  ->autoincrement()
                 ->primary();
            
            $table->string('name')
                 ->description('The product name')
                 ->notNull();
            
            $table->string('description')
                 ->description('The product description');
            
            $table->float('price')
                   ->defaultValue(0)
                   ->description('The product price')
                   ->notNull();
            
            $table->float('quantity')
                   ->defaultValue(0)
                   ->description('The product quantity')
                   ->notNull();
            
            $table->integer('product_category_id')
                 ->description('Product category')
                  ->notNull();
            
            $table->timestamps();
            
            $table->foreign('product_category_id')
                  ->references('product_categories', 'id')
                  ->onDelete('NO ACTION');

            $table->engine('INNODB');
        });
}