|
Server IP : 103.191.208.50 / Your IP : 216.73.216.226 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 5.6.40 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/celkcksm/cms.ncriptech.com/database/migrations/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateSubjectsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('subjects', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('title')->unique();
$table->string('code')->unique();
$table->integer('credit_hour');
$table->tinyInteger('subject_type')->default('1')->comment('0 Optional & 1 Compulsory');
$table->tinyInteger('class_type')->default('1')->comment('1 Theory, 2 Practical & 3 Both');
$table->decimal('total_marks',5,2)->nullable();
$table->decimal('passing_marks',5,2)->nullable();
$table->text('description')->nullable();
$table->boolean('status')->default('1');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('subjects');
}
}