| Zeile 16... |
Zeile 16... |
| 16 |
if ( !Schema::hasTable( 'directories' ) )
|
16 |
if ( !Schema::hasTable( 'directories' ) )
|
| 17 |
{
|
17 |
{
|
| 18 |
Schema::create( 'directories', function ( Blueprint $table )
|
18 |
Schema::create( 'directories', function ( Blueprint $table )
|
| 19 |
{
|
19 |
{
|
| 20 |
$table->bigInteger( "id" )->autoIncrement();
|
20 |
$table->bigInteger( "id" )->autoIncrement();
|
| - |
|
21 |
$table->bigInteger( "directory_id" )->nullable();
|
| - |
|
22 |
$table->foreign( 'directory_id' )->references( 'id' )->on( 'directory' )->cascadeOnUpdate()->nullOnDelete();
|
| 21 |
$table->string( "name" )->default( "" );
|
23 |
$table->string( "name" )->default( "" );
|
| 22 |
$table->string( "slug" )->default( "" );
|
24 |
$table->string( "slug" )->default( "" );
|
| 23 |
$table->string( "kennung" )->default( '' );
|
25 |
$table->string( "kennung" )->default( '' );
|
| 24 |
$table->unsignedTinyInteger( 'articlemaster' )->default( '0' );
|
26 |
$table->unsignedTinyInteger( 'articlemaster' )->default( '0' );
|
| 25 |
$table->unsignedTinyInteger( 'status' )->default( '0' );
|
27 |
$table->unsignedTinyInteger( 'status' )->default( '0' );
|
| 26 |
$table->string( 'url' )->default( '' );
|
28 |
$table->string( 'url' )->default( '' );
|
| 27 |
$table->text( 'description' )->default( '' );
|
29 |
$table->text( 'description' )->default( '' );
|
| 28 |
$table->string( 'short_line_1' )->default( '' );
|
30 |
$table->string( 'short_line_1' )->default( '' );
|
| 29 |
$table->bigInteger( "directory_id" )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
|
- |
|
| 30 |
$table->string( 'created_by' )->default( '' );
|
31 |
$table->string( 'created_by' )->default( '' );
|
| 31 |
$table->string( 'updated_by' )->default( '' );
|
32 |
$table->string( 'updated_by' )->default( '' );
|
| 32 |
$table->timestamps();
|
33 |
$table->timestamps();
|
| 33 |
} );
|
34 |
} );
|
| 34 |
}
|
35 |
}
|