+global\CreateTicketsTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines

33

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up()
    {
        Schema::create(config('laravel-tickets.database.tickets-table'), function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->string('subject');
            $table->enum('priority', config('laravel-tickets.priorities'));
            $table->enum('state', [ 'OPEN', 'ANSWERED', 'CLOSED' ])->default('OPEN');
            $table->timestamps();

            $table->foreign('user_id')->on(config('laravel-tickets.database.users-table'))->references('id');
        });

        Schema::create(config('laravel-tickets.database.ticket-messages-table'), function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('ticket_id');
            $table->unsignedBigInteger('user_id');
            $table->text('message');
            $table->timestamps();

            $table->foreign('user_id')->on(config('laravel-tickets.database.users-table'))->references('id');
            $table->foreign('ticket_id')->on(config('laravel-tickets.database.tickets-table'))->references('id');
        });

        Schema::create(config('laravel-tickets.database.ticket-uploads-table'), function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('ticket_message_id');
            $table->string('path');
            $table->timestamps();

            $table->foreign('ticket_message_id')->on(config('laravel-tickets.database.ticket-messages-table'))->references('id');
        });
    }