Platine\Framework\Migration\AddAuditsTable20220323095520

Complexity

Total Complexity

2

Size/Duplication

Total Lines	51
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	4	1
A	up()	0	42	1

<?php

declare(strict_types=1);

namespace Platine\Framework\Migration;

use Platine\Database\Schema\CreateTable;
use Platine\Framework\Migration\AbstractMigration;

class AddAuditsTable20220323095520 extends AbstractMigration
{
    public function up(): void
    {
      //Action when migrate up
        $this->create('audits', function (CreateTable $table) {
            $table->integer('id')
                  ->autoincrement()
                  ->primary();

            $table->string('event')
                    ->description('The audit event')
                    ->index()
                    ->notNull();

            $table->text('detail')
                  ->description('The audit detail');

            $table->string('url')
                  ->description('The audit action URL');

            $table->string('ip')
                 ->description('The IP address')
                 ->notNull();

            $table->string('user_agent')
                  ->description('The user agent');

            $table->string('tags')
                  ->description('The audit tags');

            $table->datetime('date')
                    ->description('audit date')
                    ->notNull();

            $table->integer('user_id')
                    ->description('The audit user')
                    ->notNull();

            $table->foreign('user_id')
                    ->references('users', 'id')
                    ->onDelete('NO ACTION');

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

    public function down(): void
    {
      //Action when migrate down
        $this->drop('audits');
    }
}