Subversion-Projekte lars-tiefland.laravel_shop

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration {

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up(): void

    {

        Schema::create('directories', function (Blueprint $table) {

            $table->bigInteger("id")->autoIncrement();

            $table->string("name")->default("");

            $table->string("slug")->default("");

            $table->string("kennung")->default('');

            $table->unsignedTinyInteger('status')->default('0');

            $table->string('url')->default('');

            $table->text('description')->default('');

            $table->string('short_line_1')->default('');

            $table->bigInteger("directory_id")->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();

            $table->string('created_by')->default('');

            $table->string('updated_by')->default('');

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down(): void

    {

        Schema::dropIfExists('directories');

    }

};