$php artisan make:seeder RoleTableSeeder
Define a new class namely 'Role' in App namespace
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Role extends Model {
/**
* The database table used by the model.
*
* @var string
*/
protected $table = 'user_roles';
/**
* The attributes that are mass assignable.
*
* @var array
*/
protected $fillable = ['role_id', 'role', 'description'];
/**
* The attributes excluded from the model's JSON form.
*
* @var array
*/
// protected $hidden = ['password', 'remember_token'];
}
// modify the content of the Seeder class
<?php
use Illuminate\Database\Seeder;
use App\Role;
class RoleTableSeeder extends Seeder {
/**
* Run the database seeds.
*
* @return void
*/
public function run() {
Role::insert(
array(
'role_id' => 0,
'role' => 'Admin',
'description' => 'The admin can administrate everything including the website and the database'
)
);
//
Role::insert(
array(
'role_id' => 1,
'role' => 'Assistant',
'description' => 'The assistant can help to create/update data in the database'
)
);
//
Role::insert(
array(
'role_id' => 2,
'role' => 'Visitor',
'description' => 'The visitor can help consult some information in the database'
)
);
}
}
// Run or refresh database seeding
$php artisan db:seed $php artisan db:seed --class=RoleTableSeeder
php artisan migrate:refresh --seed