dimanche 9 juillet 2017

Laravel sql server change table name for schema

I'm working on a project and i'm trying to set some tables with a schema on my SQL Server Data Base, so i manually change the tables name to the schema_name.table_name on the migration file and it worked, so here is an example:

Schema::create('electoral.centro_votacions', function (Blueprint $table) {
        $table->bigInteger('id_estado');

        $table->bigInteger('id_municipio');

        $table->bigInteger('id_parroquia');

        $table->bigInteger('id');

        $table->string('nombre');

        $table->longText('direccion');

        $table->foreign(['id_parroquia','id_municipio','id_estado'])->references(['id','id_municipio','id_estado'])->on('electoral.parroquias');
        $table->primary('id');
});

But when i'm trying to make a eloquent query on php php artisan tinker it doesn't work i just get an error saying, for example making a query App\CentroVotacion::all();:

Illuminate\Database\QueryException with message 'SQLSTATE[42S02]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'centro_votacions'. (SQL: select * from [centro_votacions])'

Of course I get it there is no table "centro_votacions" there is a table called "electoral.centro_votacions", so the thing, is how can i make laravel change the query so that i can find the "electoral.centro_votacions" table and other schemas on my SQL Server DB?.



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2tEQF5n
via IFTTT

Aucun commentaire:

Enregistrer un commentaire