Subversion-Projekte lars-tiefland.webanos.zeldi.de

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
4 lars 1 
<?php
2 
 
3 
    use Illuminate\Database\Migrations\Migration;
4 
    use Illuminate\Database\Schema\Blueprint;
5 
    use Illuminate\Support\Facades\Schema;
6 
 
7 
    return new class extends Migration
8 
    {
9 
        /**
10 
         * Run the migrations.
11 
         *
12 
         * @return void
13 
         */
14 
        public function up(): void
15 
        {
16 
            Schema::create( 'sales_portal_templates', function ( Blueprint $table )
17 
            {
18 
                $table->id();
19 
                $table->foreignId( 'sales_portal_id' )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
20 
                $table->string( 'name' )->default( '' );
21 
                $table->string( 'created_by' )->default( '' );
22 
                $table->string( 'updated_by' )->default( '' );
23 
                $table->text( 'content' )->default( '' );
24 
                $table->timestamps();
25 
            } );
26 
        }
27 
 
28 
        /**
29 
         * Reverse the migrations.
30 
         *
31 
         * @return void
32 
         */
33 
        public function down(): void
34 
        {
35 
            Schema::dropIfExists( 'sales_portal_templates' );
36 
        }
37 
    };