| Zeile 17... |
Zeile 17... |
| 17 |
{
|
17 |
{
|
| 18 |
Schema::create( 'items', function ( Blueprint $table )
|
18 |
Schema::create( 'items', function ( Blueprint $table )
|
| 19 |
{
|
19 |
{
|
| 20 |
$table->id();
|
20 |
$table->id();
|
| 21 |
$table->foreignId( "manufacturer_id" )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
|
21 |
$table->foreignId( "manufacturer_id" )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
|
| - |
|
22 |
$table->foreignId( "directory_id" )->unsigned( false )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
|
| - |
|
23 |
$table->foreignId( "shipping_group_id" )->unsigned( false )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
|
| 22 |
$table->string( "name" )->default( '' );
|
24 |
$table->string( "name" )->default( '' );
|
| 23 |
$table->string( "slug" )->default( '' );
|
25 |
$table->string( "slug" )->default( '' );
|
| 24 |
$table->unsignedTinyInteger( 'status' )->default( '0' );
|
26 |
$table->unsignedTinyInteger( 'status' )->default( '0' );
|
| 25 |
$table->text( 'description' )->default( '' );
|
27 |
$table->text( 'description' )->default( '' );
|
| 26 |
$table->string( 'ean', 13 )->default( '' );
|
28 |
$table->string( 'ean', 13 )->default( '' );
|
| 27 |
$table->string( 'kennung' )->default( '' );
|
29 |
$table->string( 'kennung' )->default( '' );
|
| 28 |
$table->string( 'short_line_1' )->default( '' );
|
30 |
$table->string( 'short_line_1' )->default( '' );
|
| 29 |
$table->foreignId( "directory_id" )->unsigned( false )->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 |
}
|