One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Dir : ~/var/www/work/modules/Popup/Migrations/

View File Name : 2022_02_08_072809_create_popup_table.php

<?php

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

    class CreatePopupTable extends Migration
    {
        /**
         * Run the migrations.
         *
         * @return void
         */
        public function up()
        {
            Schema::create(\Modules\Popup\Models\Popup::getTableName(), function (Blueprint $table) {
                $table->bigIncrements('id');
                $table->string('title')->nullable();
                $table->text('content')->nullable();
                $table->string('status', 50)->nullable()->default('draft');

                $table->text('include_url')->nullable();
                $table->text('exclude_url')->nullable();

                $table->string('schedule_type')->nullable()->default('day');
                $table->string('schedule_amount')->nullable()->default(0);

                $table->bigInteger('create_user')->nullable();
                $table->bigInteger('update_user')->nullable();

                $table->timestamps();
            });

            Schema::create(\Modules\Popup\Models\PopupTranslation::getTableName(), function (Blueprint $table) {
                $table->bigIncrements('id');
                $table->string('title')->nullable();
                $table->text('content')->nullable();

                $table->bigInteger('create_user')->nullable();
                $table->bigInteger('update_user')->nullable();

                $table->integer('origin_id')->unsigned();
                $table->string('locale')->index();
                $table->unique(['origin_id', 'locale']);

                $table->timestamps();
            });
        }

        /**
         * Reverse the migrations.
         *
         * @return void
         */
        public function down()
        {
            Schema::dropIfExists(\Modules\Popup\Models\Popup::getTableName());
            Schema::dropIfExists(\Modules\Popup\Models\PopupTranslation::getTableName());
        }
    }