PHP App\Modules\Abstracts\Models\Blueprint::char示例

示例#1

文件： 2016_01_16_153618_create_comment_table.php 项目： 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');
 }

示例#2

文件： 2015_12_30_140431_create_user_table.php 项目： 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');
 }

示例#3

文件： 2015_12_30_140626_create_transaction_table.php 项目： 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');
 }

示例#4

文件： 2015_12_30_140440_create_credential_table.php 项目： 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');
 }

示例#5

文件： 2016_01_16_153700_create_client_table.php 项目： 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');
 }

示例#6

文件： 2015_12_30_140558_create_moneypool_table.php 项目： 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');
 }

示例#7

文件： 2016_01_16_154800_create_shipment_table.php 项目： 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');
 }

示例#8

文件： 2015_12_30_140528_create_group_table.php 项目： 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');
 }