butcherman / Tech_Bench

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateFileLinkInstructionsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('file_link_instructions', function(Blueprint $table) {

            $table->increments('link_instructions_id');

            $table->integer('link_id')->unsigned();

            $table->longText('instruction')->nullable();

            $table->timestamps();

            $table->foreign('link_id')->references('link_id')->on('file_links')->onUpdate('cascade')->onDelete('cascade');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('file_link_instructions');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateJobsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('jobs', function(Blueprint $table) {

            $table->bigIncrements('id');

            $table->string('queue')->index();

            $table->longText('payload');

            $table->unsignedTinyInteger('attempts');

            $table->unsignedInteger('reserved_at')->nullable();

            $table->unsignedInteger('available_at');

            $table->unsignedInteger('created_at');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('jobs');

    }

}