JFIF  x x C         C     "        } !1AQa "q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz        w !1AQ aq"2B #3Rbr{ gilour

File "2023_04_09_111707_create_lessons_table.php"

Full Path: /home/u743136113/domains/arvi.seezify.com/public_html/database/migrations/2023_04_09_111707_create_lessons_table.php
File size: 1.29 KB
MIME-type: text/x-php
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
<?php

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

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('lessons', function (Blueprint $table) {
            $table->id();
            $table->string('title')->nullable();
            $table->unsignedBigInteger('user_id')->nullable();
            $table->unsignedBigInteger('course_id')->nullable();
            $table->unsignedBigInteger('section_id')->nullable();
            $table->string('lesson_type')->nullable();
            $table->string('duration')->nullable();
            $table->string('lesson_src')->nullable();
            $table->string('thumbnail')->nullable();
            $table->integer('is_free')->nullable();
            $table->integer('sort')->nullable();
            $table->mediumText('description')->nullable();
            $table->integer('status')->nullable();
            $table->timestamps();

            $table->index('user_id');
            $table->index('course_id');
            $table->index('section_id');
        });
    }

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