/**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('members', function ($table) {
         $table->integer('id')->primary();
         $table->integer('membership_id')->default('N/A');
         $table->string('name')->default('N/A');
         $table->string('father')->default('N/A');
         $table->string('husband')->default('N/A');
         $table->text('village')->default('N/A');
         $table->text('postOffice')->default('N/A');
         $table->text('thana')->default('N/A');
         $table->text('district')->default('N/A');
         $table->text('present_address')->default('N/A');
         $table->text('birthday')->nullable();
         $table->string('phone')->default('N/A');
         $table->string('acknowledgement_name')->default('N/A');
         $table->string('acknowledgement_relationship')->default('N/A');
         $table->text('date_of_enrollment')->default('0');
         $table->integer('roll')->default('N/A');
         $table->text('date_of_past_enrollment')->default('0');
         $table->text('date_of_cancel')->default('0');
         $table->integer('cancel_roll')->default('0');
         $table->integer('status')->default('0');
         $table->text('date_of_membership');
         $table->integer('created_by_id')->default('N/A');
         $table->integer('updated_by_id')->default('N/A');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('exem-emp', function ($table) {
         $table->integer('exemplar')->unsigned();
         $table->foreign('exemplar')->references('id_exemplar')->on('exemplar');
         $table->integer('emprestimo')->unsigned();
         $table->foreign('emprestimo')->references('id_emprestimo')->on('emprestimo');
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('roles', function ($table) {
         $table->integer('id')->primary();
         $table->string('role')->nullable();
         $table->integer('created_by_id')->nullable();
         $table->integer('updated_by_id')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('usu-emp', function ($table) {
         $table->integer('cliente')->unsigned();
         $table->foreign('cliente')->references('id_cliente')->on('cliente');
         $table->integer('emprestimo')->unsigned();
         $table->foreign('emprestimo')->references('id_emprestimo')->on('emprestimo');
         $table->integer('usuario')->unsigned();
         $table->foreign('usuario')->references('id_usuario')->on('usuario');
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('users', function ($table) {
         $table->integer('id')->primary();
         $table->string('username', 128)->unique();
         $table->string('password');
         $table->string('email')->unique();
         $table->string('remember_token')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('libraries', function ($table) {
         $table->integer('id')->primary();
         $table->string('book_name')->nullable();
         $table->integer('book_copy')->nullable();
         $table->string('book_img_name')->nullable();
         $table->integer('created_by_id')->nullable();
         $table->integer('updated_by_id')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('albums', function (Blueprint $table) {
         $table->increments('id');
         $table->string('title', 100);
         $table->string('url', 100)->unique();
         $table->text('short_description');
         $table->text('detail_description');
         $table->enum('status', ['Active', 'Inactive'])->default('Inactive');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('countries', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name', 100);
         $table->string('url', 100)->unique()->comment('it is helping for searching countries');
         $table->text('image');
         $table->text('short_description');
         $table->text('detial_description');
         $table->enum('status', ['Active', 'Inactive'])->default('Inactive');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('hscs', function ($table) {
         $table->integer('id')->primary();
         $table->integer('membership_id')->nullable();
         $table->string('result')->nullable();
         $table->date('year')->nullable();
         $table->string('board')->nullable();
         $table->integer('created_by_id')->nullable();
         $table->integer('updated_by_id')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('masters', function ($table) {
         $table->integer('id')->primary();
         $table->integer('membership_id')->default('N/A');
         $table->string('result')->default('N/A');
         $table->date('year')->default('N/A');
         $table->string('university')->default('N/A');
         $table->integer('created_by_id')->default('N/A');
         $table->integer('updated_by_id')->default('N/A');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('valids', function ($table) {
         $table->integer('id')->primary();
         $table->integer('membership_id')->nullable();
         $table->string('valid')->nullable();
         $table->string('toDate')->nullable();
         $table->string('UpToDate')->nullable();
         $table->integer('created_by_id')->nullable();
         $table->integer('updated_by_id')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::DropIfExists('horaires');
     Schema::Create('horaires', function (Blueprint $table) {
         $table->engine = 'InnoDB';
         $table->increments('id');
         $table->date('date');
         $table->time('h_debut');
         $table->time('h_fin');
         $table->integer('matiere_id')->unsigned();
         $table->foreign('matiere_id')->references('id')->on('matieres')->onDelete('cascade');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('borrows', function ($table) {
         $table->integer('id')->primary();
         $table->string('membership_id')->nullable();
         $table->string('book_name')->nullable();
         $table->string('borrow_date')->nullable();
         $table->string('return_date')->nullable();
         $table->integer('book_copy')->nullable();
         $table->integer('created_by_id')->nullable();
         $table->integer('updated_by_id')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('categories', function (Blueprint $table) {
         $table->increments('id');
         $table->integer('country_id')->unsigned();
         $table->foreign('country_id')->references('id')->on('countries');
         $table->string('name', '100');
         $table->string('url', 100)->unique();
         $table->text('image');
         $table->text('short_description');
         $table->text('detail_description');
         $table->enum('status', ['Active', 'Inactive'])->default('Inactive');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('educations', function ($table) {
         $table->integer('id')->primary();
         $table->integer('membership_id')->nullable();
         $table->string('SSC')->default('N/A');
         $table->string('HSC')->default('N/A');
         $table->string('Hons')->default('N/A');
         $table->string('Masters')->default('N/A');
         $table->string('BarAtLaw')->default('N/A');
         $table->integer('created_by_id')->nullable();
         $table->integer('updated_by_id')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('galleries', function (Blueprint $table) {
         $table->increments('id');
         $table->integer('albums_id')->unsigned();
         $table->foreign('albums_id')->references('id')->on('albums')->onUpdate('cascade')->ondelete('cascade');
         $table->string('title', 100);
         $table->string('url', 100)->unique();
         $table->text('image');
         $table->text('short_description');
         $table->text('detail_description');
         $table->enum('status', ['Active', 'Inactive'])->default('Inactive');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::DropIfExists('matieres');
     Schema::Create('matieres', function (Blueprint $table) {
         $table->engine = 'InnoDB';
         $table->increments('id');
         $table->String('nom', 200);
         $table->integer('enseignant_id')->unsigned();
         $table->integer('promo_id')->unsigned();
         $table->integer('module_id')->unsigned();
         $table->foreign('enseignant_id')->references('id')->on('enseignants')->onDelete('cascade');
         $table->foreign('promo_id')->references('id')->on('promos')->onDelete('cascade');
         $table->foreign('module_id')->references('id')->on('modules')->onDelete('cascade');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     //
     Schema::Create('profiles', function (Blueprint $table) {
         $table->integer('user_id')->unsigned()->nullable();
         $table->foreign('user_id')->references('id')->on('users');
         $table->date('birthday');
         $table->string('image');
         $table->string('housenumber')->nullable();
         $table->string('addressline1')->nullable();
         $table->string('addressline2')->nullable();
         $table->string('postcode')->nullable();
         $table->string('county')->nullable();
         $table->string('country')->nullable();
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('primes', function (Blueprint $table) {
         $table->increments('id');
         $table->string('description');
         $table->timestamps();
     });
     Schema::Create('personnels_prime', function (Blueprint $table) {
         $table->integer('personnels_id')->unsigned()->index();
         $table->foreign('personnels_id')->references('id')->on('personnels')->onDelete('cascade');
         $table->float('montant_prime');
         $table->string('exoneree');
         $table->integer('prime_order');
         $table->integer('prime_id')->unsigned()->index();
         $table->foreign('prime_id')->references('id')->on('primes')->onDelete('cascade');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     # Create table
     Schema::Create('hakon_admin', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name');
         $table->string('email');
         $table->string('username');
         $table->string('password');
         $table->timestamps();
     });
     /*
      * [TODO] Remove this seed after installation plugin is finished.
      * - User and password will be automaticaly generated by the installation plugin177
      */
     # Generate password
     $password = eFuzyon\Password::Generate('hakoncms');
     # Seed Table
     DB::table('hakon_admin')->insert(['id' => 1, 'name' => 'Hakon', 'email' => 'hakon@efuzyon.com', 'username' => 'hakoncms', 'password' => $password]);
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('results', function (Blueprint $table) {
         $table->increments("id");
         $table->string("regno");
         $table->string("c_code");
         $table->float("cat1");
         $table->float("cat2");
         $table->float("total1");
         $table->float("final");
         $table->float("total2");
         $table->string("grade");
         $table->float("gpa");
         $table->integer("student_id")->unsigned();
         $table->foreign("student_id")->refences('id')->on("students")->onDelete("cascade");
         $table->timestamp("created_at");
         $table->timestamp("updated_at");
     });
     //
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('packages', function (Blueprint $table) {
         $table->increments('id');
         $table->integer('categories_id')->unsigned();
         $table->foreign('categories_id')->references('id')->on('categories')->onUpdate('cascade')->ondelete('cascade');
         $table->string('title', 100);
         $table->string('url', 100)->unique();
         $table->text('image');
         $table->enum('is_special', ['Y', 'N'])->default('N');
         $table->enum('grade', ['easy', 'moderate', 'hard'])->default('hard');
         $table->string('currency', 100);
         $table->string('price');
         $table->string('route', 100);
         $table->string('duration', 100);
         $table->string('itinerary', 100);
         $table->text('const_description');
         $table->text('short_description');
         $table->text('detail_description');
         $table->enum('status', ['Active', 'Inactive'])->default('Inactive');
         $table->timestamps();
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::Create('accounts', function ($table) {
         $table->integer('id')->primary();
         $table->integer('membership_id')->default(0);
         $table->float('admission_fee')->default(0);
         $table->float('late_fee')->default(0);
         $table->float('benevolent_fund')->default(0);
         $table->float('monthly_fee')->default(0);
         $table->float('benevolent_fund_dues')->default(0);
         $table->float('monthly_fee_dues')->default(0);
         $table->float('relief_fund')->default(0);
         $table->float('medical_fund')->default(0);
         $table->float('building_fund')->default(0);
         $table->float('library_fund')->default(0);
         $table->float('memberlist_fee')->default(0);
         $table->float('application_form_fee')->default(0);
         $table->float('auditorium_fee')->default(0);
         $table->float('drawer_fee')->default(0);
         //$table->float('sales_of_okalotnama')->default(0);
         // $table->float('attendence_fee')->default(0);
         //$table->float('bellbond_fee')->default(0);
         // $table->float('clerk_licence_fee')->default(0);
         $table->float('membership_certificate_fee')->default(0);
         $table->float('blood_test_fee')->default(0);
         $table->float('provident_fund')->default(0);
         $table->float('family_welfare_fund')->default(0);
         $table->float('others')->default(0);
         $table->float('totals')->default(0);
         $table->date('from')->default(0);
         $table->date('to')->default(0);
         $table->integer('bank_statement')->default('0');
         $table->integer('created_by_id')->default(0);
         $table->integer('updated_by_id')->default(0);
         $table->timestamps();
     });
 }