/** * 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' => '*****@*****.**', '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(); }); }