⚝
One Hat Cyber Team
⚝
Your IP:
216.73.217.31
Server IP:
95.217.99.93
Server:
Linux sv1.sonichosted.com 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64
Server Software:
LiteSpeed
PHP Version:
8.2.29
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
lifestylescentra
/
www
/
database
/
migrations
/
View File Name :
2024_03_06_055051_create_members_table.php
<?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('members', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('user_id'); $table->string('member_id'); $table->string('locker_no')->nullable(); $table->enum('gender', ['male', 'female', 'other'])->nullable(); $table->date('dob')->nullable(); $table->integer('height')->nullable()->comment('in cm'); $table->integer('weight')->nullable()->comment('in kg'); $table->integer('chest')->nullable()->comment('in inch'); $table->string('referred_by')->nullable(); $table->unsignedBigInteger('created_by')->nullable(); $table->unsignedBigInteger('updated_by')->nullable(); $table->enum('blood_group', ['A+', 'A-', 'B+', 'B-', 'AB+', 'AB-', 'O+', 'O-'])->nullable()->comment('A+, A-, B+, B-, AB+, AB-, O+, O-'); $table->string('phone')->nullable(); $table->string('emergency_contact')->nullable(); $table->string('emergency_phone')->nullable(); $table->string('emergency_relation')->nullable(); $table->string('profile_image')->nullable(); $table->boolean('status')->default(1)->comment('0=Inactive, 1=Active'); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->foreign('created_by')->references('id')->on('admins')->onDelete('set null'); $table->foreign('updated_by')->references('id')->on('admins')->onDelete('set null'); $table->softDeletes(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('members'); } };