phinx
phinx copied to clipboard
cakephp
PHP Database Migrations for Everyone
I used the seeding feature for the first time today and found that it is useless for Postgres. My SQL seed file will create all the schemas and tables as...
Attempting to rename a column of type 'datetime2(6)' on SQL Server results in phinx complaining, ``` [RuntimeException] The SqlServer type: "datetime2" is not supported ``` This is a pretty simple...
Good morning, since as of phinx 0.13 PKs are unsigned by default, I would like to write a migration to update existing table and make their PKs unsigned, in order...
Our file contain 483236 lines. Should not Phinx be able to split/batch data ? ```php Exception: SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535 In...
- While running phinx migration on multiple databases always exhaust the database CPU > Use Case 1 database has 17 migrations to execute and there are total of 500 database,...
Adds a feature flag to use datetime on MySQL for addTimestamps() function instead of timestamp. Implements #1635 timestamp columns do not support dates past 2038-01-19 on MySQL
The documentation at https://book.cakephp.org/phinx/0/en/index.html only includes v0.13. This should be updated for v0.16.
Right now commands like `migrate` write errors to STDOUT. This is wrong. Errors, especially from commands that are commonly used non-interactively, need to be written to STDERR so that scripts...
Using phinx version ``0.16.0``. Using the mysql adapter. Code example: ```php $table = $this->table('trades'); $table ->renameColumn('uid_a', 'initiatorUserId') ->update(); ``` The resulting SQL command is: ```sql ALTER TABLE `trades` CHANGE COLUMN...
This is an inconsistency that triggers multiple issues along the road Right now, not defining table primary key gets it added as "int unsigned". But any integer added would be...
