PHP App\Modules\Abstracts\Models\Blueprint Examples

Example #1

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

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

Example #2

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 #3

File: 2015_12_30_140518_create_group_user_table.php Project: helin16/moneypool

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->integer('userId');
     $table->integer('groupId');
     $table->index(['userId'], 'userId');
     $table->index(['groupId'], 'groupId');
 }

Example #4

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 #5

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');
 }

Example #6

File: 2015_12_30_140626_create_transaction_table.php Project: helin16/moneypool

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->integer('poolId');
     $table->double('amount', 14, 2);
     $table->char('transGroupId', 32);
     $table->char('comments', 100);
     $table->index(['poolId'], 'poolId');
     $table->index(['comments'], 'comments');
     $table->index(['transGroupId'], 'transGroupId');
 }

Example #7

File: 2015_12_30_140431_create_user_table.php Project: helin16/moneypool

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->char('firstname', 100);
     $table->char('lastname', 100);
     $table->char('email', 100);
     $table->index(['firstname'], 'firstname');
     $table->index(['lastname'], 'lastname');
     $table->index(['email'], 'email');
 }

Example #8

File: 2015_12_30_140558_create_moneypool_table.php Project: helin16/moneypool

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->char('entityName', 100);
     $table->integer('entityId');
     $table->double('amount', 14, 2);
     $table->index(['entityName'], 'entityName');
     $table->index(['entityId'], 'entityId');
 }

Example #9

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 #10

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

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->text('content');
 }

Example #11

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

 protected function _extraColumns(App\Modules\Abstracts\Models\Blueprint $table)
 {
     $table->char('name', 100)->unique();
     $table->char('description', 255);
     $table->index(['name'], 'name');
 }