phinx
phinx copied to clipboard
cakephp
PHP Database Migrations for Everyone
DEPRECATION: Since symfony/console 6.1: Relying on the static property "$defaultName" for setting a command name is deprecated. Add the "Symfony\Component\Console\Attribute\AsCommand" attribute to the "Phinx\Console\Command\Init" class instead. tested on PHP 8.1,...
For those of us that use Phinx as standalone tool, it may be convenient that `--version` argument actually displays the version number and not only "hey, I'm Phinx": ``` $...
The [docs](https://book.cakephp.org/phinx/0/en/configuration.html) seems outdated. My config looks like this: ``` environments: default_migration_table: phinxlog default_environment: development ``` But I get a warning: `warning no environment specified, defaulting to: development`. How to...
Hi guys, We're in the process of migrating our database migrations into phinx. Our tables all use binary(16) as datatype for the Primary Key column. To generate that value we...
Hi there, basically just checking to see if this something you all would consider adding. Postgres supports enums on columns but it's a two-step process where you make an enum...
This may be a bit complex, but there is a "standardized" way of handling an `updated_at` column in postgres. The idea is you create a function like this: ``` CREATE...
mariadb has a native uuid type since 10.7. We already have: - uuid -> char(36) - binaryuuid -> binary(16) Can we also add a "nativeuuid" type? In terms of PDO...
Running a migration with Phinx v 0.13.4 I get this error message: ``` == 20221014105116 ModifyPermissionForGlobalStyling: migrating PHP Deprecated: As of 4.5.0, using newQuery() is deprecated. Instead, use `insertQuery()`, `deleteQuery()`,...
This change in the PostgreSQL adapter allows you to create a "character varying" column without a limit. Otherwise, even if we set the limit to "null" it still takes this...
Moved https://github.com/cakephp/migrations/issues/330 over to here. Currently ```php $table->changeColumn('status', 'string', [ 'encoding' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', ]); ``` Kills most other settings like ```php 'null' => true, 'default' => null,...
