PHP Method Schema::Create, someline-starter Code Examples

This page contains top rated real world PHP examples of method Schema::Create from package someline-starter extracted from open source projects. You can rate examples to help us improve the quality of examples
Frequently Used Methods
Example #1
Show file File: 2014_09_07_162332_member_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #2
Show file File: 2015_09_30_223931_exem-emp.php Project: bening2011/GestBiblio-TCC
0
 /**
  * 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');
     });
 }
Example #3
Show file File: 2014_10_17_215838_user_role_tabel.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #4
Show file File: 2015_09_30_224003_usu-emp.php Project: bening2011/GestBiblio-TCC
0
 /**
  * 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');
     });
 }
Example #5
Show file File: 2014_08_01_094412_create_users.php Project: BDMADE/laracms
0
 /**
  * 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();
     });
 }
Example #6
Show file File: 2014_09_14_202735_library_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #7
Show file File: 2015_09_10_082212_albums.php Project: kumarsubedi93/laravel_docs
0
 /**
  * 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();
     });
 }
Example #8
Show file File: 2015_09_10_080707_countries.php Project: kumarsubedi93/laravel_docs
0
 /**
  * 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();
     });
 }
Example #9
Show file File: 2014_09_07_172143_members_hsc_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #10
Show file File: 2014_09_07_172216_members_masters_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #11
Show file File: 2014_09_07_191351_valid_members_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #12
Show file File: 2015_12_05_170008_create_table_horaires.php Project: HamzaElgarrab/Slackerz
0
 /**
  * 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();
     });
 }
Example #13
Show file File: 2014_10_17_201913_borrows_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #14
Show file File: 2015_09_10_080932_categories.php Project: kumarsubedi93/laravel_docs
0
 /**
  * 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();
     });
 }
Example #15
Show file File: 2014_09_07_165311_members_edu_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }
Example #16
Show file File: 2015_09_10_082313_galleries.php Project: kumarsubedi93/laravel_docs
0
 /**
  * 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();
     });
 }
Example #17
Show file File: 2015_12_05_170007_create_table_matieres.php Project: HamzaElgarrab/Slackerz
0
 /**
  * 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();
     });
 }
Example #18
Show file File: 2015_12_17_123422_create_profiles_table.php Project: pushmyprofile/buildyourday
0
 /**
  * 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();
     });
 }
Example #19
Show file File: 2016_01_06_112609_create_primes_table.php Project: bellaajhabib/payes
0
 /**
  * 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();
     });
 }
Example #20
Show file File: 2016_04_30_034833_create_admin_table.php Project: hakoncms/hakoncms
0
 /**
  * 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]);
 }
Example #21
Show file File: 2015_06_13_181337_create_results_table.php Project: KornelMbele/ResultSystem
0
 /**
  * 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");
     });
     //
 }
Example #22
Show file File: 2015_09_10_081415_package.php Project: kumarsubedi93/laravel_docs
0
 /**
  * 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();
     });
 }
Example #23
Show file File: 2014_09_07_175958_accounts_table.php Project: BDMADE/DBA
0
 /**
  * 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();
     });
 }