+global\CreateMeetingAttachmentsTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	27
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up()
    {
        Schema::create('meeting_attachments', function (Blueprint $table) {
            $table->increments('id');

            $table->string('filename');
            $table->string('storage_filename');

            $table->float('size')->comment('kilobytes');

            $table->unsignedInteger('meeting_id')->nullable();
            $table->foreign('meeting_id')
                ->references('id')
                ->on('meetings')
                ->onDelete('set null') // so we can later see that the attachment is not used and delete the file
                ->onUpdate('cascade');

            $table->unsignedInteger('owner_id')->nullable();
            $table->foreign('owner_id')
                ->references('id')
                ->on('members')
                ->onDelete('set null')
                ->onUpdate('cascade');

            $table->timestamps();
        });
    }