webshell

Ghost Exploiter Team Official

Directory >> /home/softsuitetech/public_html/DEMO/l4g_updated/database/migrations/

File / Folder	Size	Action
.	-
2014_10_12_100000_creat...	0.653KB	edt ren
2023_03_11_110516_creat...	4.162KB	edt ren
2023_03_11_110517_creat...	11.549KB	edt ren
2023_08_18_113119_add_g...	0.633KB	edt ren

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    protected $connection = 'db_user';
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::connection($this->connection)->create('Role', function (Blueprint $table) {
            $table->id();
            $table->string('name', 50);
            $table->string('description', 50);
        });

Schema::connection($this->connection)->create('permission', function (Blueprint $table) {
            $table->id();
            $table->string('bezeichnung', 50);
        });

Schema::connection($this->connection)->create('ZT_Permission_Role', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('role_id');
            $table->unsignedBigInteger('permission_id');
            $table->foreign('role_id')->references('id')->on('Role');
            $table->foreign('permission_id')->references('id')->on('permission');
        });

Schema::connection($this->connection)->create('Pages', function (Blueprint $table) {
            $table->id();
            $table->string('name', 50);
        });

Schema::connection($this->connection)->create('Pages_Roles_Access', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('page_id');
            $table->unsignedBigInteger('role_id');
            $table->string('name', 50);
            $table->foreign('page_id')->references('id')->on('Pages');
            $table->foreign('role_id')->references('id')->on('Role');
        });

Schema::connection($this->connection)->create('Changable', function (Blueprint $table) {
            $table->id();
            $table->string('name', 50);
        });

Schema::connection($this->connection)->create('Page_Change_Detail', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('page_id');
            $table->unsignedBigInteger('change_id');
            $table->string('text', 255);
            $table->foreign('page_id')->references('id')->on('Pages');
            $table->foreign('change_id')->references('id')->on('Changable');
        });

Schema::connection($this->connection)->create('Employee', function (Blueprint $table) {
            $table->id('id');
            $table->unsignedBigInteger('role_id');
            $table->string('name', 50);
            $table->string('firstname', 50);
            $table->string('email', 50);
            $table->string('username', 50);
            $table->string('password', 255);
            $table->string('salt', 255);
            $table->datetime('created_at', 6);
            $table->timestamp('updated_at');
            $table->boolean('delete_flag');
            $table->text('access_token')->nullable();
            $table->foreign('role_id')->references('id')->on('Role');
        });

Schema::connection($this->connection)->create('password_resets', function (Blueprint $table) {
            $table->string('email')->index();
            $table->string('token')->index();
            $table->timestamp('created_at')->nullable();
        });
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::connection($this->connection)->dropIfExists('Employee');
        Schema::connection($this->connection)->dropIfExists('Page_Change_Detail');
        Schema::connection($this->connection)->dropIfExists('Changable');
        Schema::connection($this->connection)->dropIfExists('Pages_Roles_Access');
        Schema::connection($this->connection)->dropIfExists('Pages');
        Schema::connection($this->connection)->dropIfExists('ZT_Permission_Role');
        Schema::connection($this->connection)->dropIfExists('Permission');
        Schema::connection($this->connection)->dropIfExists('Role');
        Schema::connection($this->connection)->dropIfExists('password_reset');
        Schema::connection($this->connection)->dropIfExists('carts');
        Schema::connection($this->connection)->dropIfExists('cart_details');
    }
};

<=Back