TrxShell [ lionsindia.in ]

Name	Size	Permission
.DS_Store	6 KB	-rw-r--r--
.gitkeep	0 B	-rw-r--r--
2014_04_02_193005_create_trans...	778 B	-rw-r--r--
2014_10_12_000000_create_users...	1.43 KB	-rw-r--r--
2014_10_12_100000_create_passw...	683 B	-rw-r--r--
2014_10_12_200000_add_two_fact...	934 B	-rw-r--r--
2019_08_19_000000_create_faile...	820 B	-rw-r--r--
2020_09_11_160850_create_sessi...	833 B	-rw-r--r--
2020_09_11_190632_create_webma...	4.15 KB	-rw-r--r--
2020_09_11_190633_create_webma...	2.53 KB	-rw-r--r--
2020_09_11_190635_create_webma...	1.14 KB	-rw-r--r--
2020_09_11_190637_create_webma...	786 B	-rw-r--r--
2020_09_11_190638_create_webma...	850 B	-rw-r--r--
2020_09_11_190640_create_webma...	1.49 KB	-rw-r--r--
2020_09_11_190641_create_topic...	1.96 KB	-rw-r--r--
2020_09_11_190643_create_setti...	3.5 KB	-rw-r--r--
2020_09_11_190645_create_secti...	1.54 KB	-rw-r--r--
2020_09_11_190647_create_photo...	864 B	-rw-r--r--
2020_09_11_190648_create_permi...	1.84 KB	-rw-r--r--
2020_09_11_190650_create_menus...	1.03 KB	-rw-r--r--
2020_09_11_190652_create_maps_...	1.13 KB	-rw-r--r--
2020_09_11_190654_create_event...	1015 B	-rw-r--r--
2020_09_11_190656_create_count...	785 B	-rw-r--r--
2020_09_11_190657_create_conta...	749 B	-rw-r--r--
2020_09_11_190659_create_conta...	1.57 KB	-rw-r--r--
2020_09_11_190701_create_comme...	1012 B	-rw-r--r--
2020_09_11_190703_create_banne...	1.39 KB	-rw-r--r--
2020_09_11_190704_create_attac...	936 B	-rw-r--r--
2020_09_11_190706_create_analy...	1.37 KB	-rw-r--r--
2020_09_11_190708_create_analy...	959 B	-rw-r--r--
2020_09_11_190912_create_relat...	832 B	-rw-r--r--
2020_09_11_190914_create_topic...	690 B	-rw-r--r--
2020_09_11_190916_create_topic...	729 B	-rw-r--r--
2020_09_11_190917_create_webma...	1.76 KB	-rw-r--r--
2020_09_11_201046_create_langu...	1.11 KB	-rw-r--r--
2024_07_24_111443_create_membe...	1.38 KB	-rw-r--r--
2024_07_30_111551_add_addition...	1.11 KB	-rw-r--r--
2024_08_01_052435_add_new_fiel...	856 B	-rw-r--r--

Code Editor : 2024_07_24_111443_create_members_table.php

<?php

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

class CreateMembersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('members', function (Blueprint $table) {
            $table->id();
            $table->string('full_name');
            $table->text('full_address');
            $table->string('mobile_numbers');  // Assuming a single string; consider JSON or separate table for multiple numbers
            $table->string('position');
            $table->string('district');
            $table->date('dob');
            $table->year('yoj');  // Year of Joining
            $table->string('hc');  // Assuming this is a string field; adjust the datatype as needed
            $table->string('photo')->nullable();
            $table->string('profession');
            $table->string('spouse_name')->nullable();
            $table->string('blood_group');
            $table->string('spouse_blood_group')->nullable();
            $table->date('wedding_date')->nullable();
            $table->string('email_id')->unique();
            $table->timestamps();
        });
    }

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

${this.title}

Code Editor : 2024_07_24_111443_create_members_table.php