Laravel迁移和PostgreSQL模式

Question

I'm using PostgreSQL and want to try Laravel.

First - my up() function:

public function up()
{
    Schema::create('entries.entries', function($t) {

        $t->increments('id');
        $t->string('username', 50);
        $t->string('email', 100);
        $t->text('comment');
        $t->timestamps();
    });
}

And i have two questions:

1) I haven't shema entries in my database, so, how can i change my up function to create it too? I dont want to do it manually.

2) I got an error when executed migration:

 sudo php artisan migrate

 [Illuminate\Database\QueryException]                                         
     SQLSTATE[3F000]: Invalid schema name: 7 ERROR:  no schema has been selected  
     to create in (SQL: create table "emigrations" ("migration" varchar(255) not null,
     "batch" integer not null))       

How can i fix it?

Answer 1

1) I don't think there is such functionality in Laravel but you can use an external package like https://github.com/pacuna/Laravel-PGSchema

2) Did you remove the default schema in your app/config/database.php file?

'pgsql' => array(
            'driver'   => 'pgsql',
            'host'     => 'localhost',
            'database' => 'forge',
            'username' => 'forge',
            'password' => '',
            'charset'  => 'utf8',
            'prefix'   => '',
            'schema'   => 'public',
        ),