Gel4y Mini Shell

Edit file

File name : 2023_01_25_160400_create_email_historic_table.php

Content :

<?php

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

class CreateEmailHistoricTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        /**
         * email_historic       - Histórico de envio de e-mails em massa
         * html                 - Html disparado
         * filter               - Filtro em formato get
         * user_id              - ID do usuário que fez o disparo
         * sends                - Quantidade de clientes na lista
         */

Schema::create('email_historic', function (Blueprint $table) {
            $table->id();
            $table->longText('html');
            $table->longText('filter');
            $table->foreignId('user_id')->constrained();
            $table->integer('sends');
            $table->timestamps();
        });
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('email_historic');
    }
}