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');

    }

}