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