PHP App\Modules\Abstracts\Models\Blueprint::unsignedMediumInteger Examples

Example #1

File: 2015_12_30_140518_create_group_user_table.php Project: tlan16/active-shipping

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->unsignedMediumInteger('user_id');
     $table->unsignedMediumInteger('group_id');
     $table->index(['user_id'], 'user_id');
     $table->index(['group_id'], 'group_id');
 }

Example #2

File: 2016_01_16_153700_create_client_table.php Project: tlan16/active-shipping

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->char('name', 50);
     $table->unsignedMediumInteger('user_id')->nullable();
     $table->index(['name'], 'name');
     $table->index(['user_id'], 'user_id');
 }

Example #3

File: 2016_01_16_154800_create_shipment_table.php Project: tlan16/active-shipping

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->unsignedMediumInteger('client_id');
     $table->unsignedMediumInteger('shipper_id');
     $table->date('date');
     $table->date('ETD')->nullable();
     $table->date('ETA')->nullable();
     $table->char('PO_numbers');
     $table->unsignedMediumInteger('POL');
     $table->unsignedMediumInteger('PLD');
     $table->char('comments');
     $table->index(['client_id'], 'client_id');
     $table->index(['shipper_id'], 'shipper_id');
     $table->index(['date'], 'date');
     $table->index(['ETD'], 'ETA');
     $table->index(['PO_numbers'], 'PO_numbers');
     $table->index(['POL'], 'POL');
     $table->index(['PLD'], 'PLD');
 }

Example #4

File: 2015_12_30_140440_create_credential_table.php Project: tlan16/active-shipping

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->unsignedMediumInteger('user_id');
     $table->char('username', 50);
     $table->char('password', 100);
     $table->enum('type', Credential::getCredentialTypes());
     $table->index(['user_id'], 'user_id');
     $table->index(['username'], 'username');
     $table->index(['password'], 'password');
     $table->index(['type'], 'type');
 }