phinx icon indicating copy to clipboard operation
phinx copied to clipboard

Adding Schema Support To Phinx

Open JRDuncan opened this issue 1 year ago • 0 comments

Looks like phinx just creates/looks for objects in default schema

example: SQL Server Create table will create table in dbo schema. Mysql will create table in database (database same as schema for mysql) that is set in connection property.

`<?php

use Phinx\Migration\AbstractMigration;

class MyNewMigration extends AbstractMigration { public function change() { $users = $this->table('users', '<schema_name>'); $users->addColumn('username', 'string', ['limit' => 20]) ->addColumn('password', 'string', ['limit' => 40]) ->addColumn('password_salt', 'string', ['limit' => 40]) ->addColumn('email', 'string', ['limit' => 100]) ->addColumn('first_name', 'string', ['limit' => 30]) ->addColumn('last_name', 'string', ['limit' => 30]) ->addColumn('created', 'datetime') ->addColumn('updated', 'datetime', ['null' => true]) ->addIndex(['username', 'email'], ['unique' => true]) ->create(); } }`

JRDuncan avatar Mar 02 '23 15:03 JRDuncan