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

Complexity

Conditions	1
Paths	1

Size

Total Lines	42
Code Lines	29

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php

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

        });