Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 152 | Revision 154 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 152 Revision 153
Zeile 1... Zeile 1...
1
<?php
1
<?php
Zeile 2... Zeile 2...
2
 
2
 
3
use Illuminate\Database\Migrations\Migration;
3
    use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
4
    use Illuminate\Database\Schema\Blueprint;
Zeile 5... Zeile 5...
5
use Illuminate\Support\Facades\Schema;
5
    use Illuminate\Support\Facades\Schema;
6
 
-
 
7
return new class extends Migration {
-
 
8
    /**
-
 
9
     * Run the migrations.
-
 
10
     *
-
 
11
     * @return void
-
 
12
     */
6
 
-
 
7
    return new class extends Migration
-
 
8
    {
-
 
9
        /**
-
 
10
         * Run the migrations.
-
 
11
         *
-
 
12
         * @return void
-
 
13
         */
13
    public function up(): void
14
        public function up(): void
-
 
15
        {
14
    {
16
            Schema::create( 'price_agencies', function ( Blueprint $table )
15
        Schema::create('price_agencies', function (Blueprint $table) {
17
            {
-
 
18
                $table->id();
-
 
19
                $table->string( 'name' )->default( '' );
16
            $table->id();
20
                $table->string( "short", 4 )->default( '' );
17
            $table->string('name')->default('');
21
                $table->string( "re_short", 4 )->default( '' );
-
 
22
                $table->unsignedTinyInteger( 'preisindex_ek' )->default( '1' );
-
 
23
                $table->string( 'importtool' )->default( '' );
18
            $table->unsignedBigInteger('datensaetze')->default('0');
24
                $table->enum( 'ebay', '["0","1"]' )->default( '0' );
19
            $table->string("logo_url")->default('');
25
                $table->enum( 'klonziel', '["0","1"]' )->default( '0' );
-
 
26
                $table->string( 'konroot' )->default( '' );
20
            $table->string('home_url')->default('');
27
                $table->enum( 'home', '["0","1"]' )->default( '0' );
21
            $table->string("csv_url")->default('');
28
                $table->enum( 'erfassung', '["0","1"]' )->default( '0' );
22
            $table->string('trigger_url')->default('');
29
                $table->string( 'database' )->default( '' );
23
            $table->string('voting_url')->default('');
30
                $table->string( 'order_db' )->default( '' );
24
            $table->string('access_url')->default('');
31
                $table->string( 'mail_server' )->default( '' );
25
            $table->string('access_user')->default('');
32
                $table->string( 'mail_user' )->default( '' );
-
 
33
                $table->string( 'mail_password' )->default( '' );
26
            $table->string('access_password')->default('');
34
                $table->string( 'domain' )->default( '' );
27
            $table->text('comment')->default('');
35
                $table->unsignedTinyInteger( 'status' )->default( '0' );
-
 
36
                $table->unsignedInteger( 'rang' )->default( '0' );
-
 
37
                $table->text( 'such_algo' )->default( '' );
28
            $table->json('locked_manufacturers')->default('[]');
38
                $table->boolean( "uses_dump" )->default( '1' );
29
            $table->string('config')->default('');
39
                $table->boolean( "plesk" )->default( '1' );
30
            $table->unsignedTinyInteger('status')->default("0");
40
                $table->string( 'user' )->default( '' );
31
            $table->unsignedTinyInteger('only_deliverable')->default("1");
41
                $table->string( 'server' )->default( '' );
32
            $table->float('min_price')->default('0.0');
42
                $table->string( 'plesk_key' )->default( '' );
33
            $table->timestamps();
43
                $table->timestamps();
Zeile 34... Zeile 44...
34
        });
44
            } );
35
    }
45
        }
36
 
46
 
37
    /**
47
        /**
38
     * Reverse the migrations.
48
         * Reverse the migrations.
39
     *
49
         *
40
     * @return void
50
         * @return void
41
     */
51
         */
42
    public function down(): void
52
        public function down(): void
43
    {
53
        {