CreateNoteTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	30
Duplicated Lines	0 %

Importance

Changes

0

<?php
class CreateNoteTable extends Migration
{
    public function up()
    {
        Schema::create('notes', function (Blueprint $table) {
            $table->increments('id');
            $table->boolean('published')->default(0);
            $table->enum('type', ['general', 'delivery', 'payment']);
            $table->boolean('cookies');
            $table->enum('level', ['info', 'warning', 'error']);
            $table->timestamp('start_at')->nullable();
            $table->timestamp('end_at')->nullable();
            $table->timestamps();
        });

        Schema::create('note_translations', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('note_id')->unsigned();
            $table->string('locale');
            $table->string('content');

            $table->unique(['note_id', 'locale']);
            $table->foreign('note_id')->references('id')->on('notes')->onDelete('cascade');
        });
    }

    public function down()
    {
        Schema::dropIfExists('note_translations');
        Schema::dropIfExists('notes');
    }