phinx
phinx copied to clipboard
cakephp
PHP Database Migrations for Everyone
I was looking for a tool to handle the migrations for me (although I am using Doctrine DBAL I am not using Entities or the RM ATM). Right now I...
For some reason the SQL queries in this migration run just fine if I execute them in HeidiSQL. The triggers are created. It just doesn't work for some reason when...
Hello, is it possible to conditionally execute a migration? I'm working on a software that communicates with a few databases of different types. Depending on its type, (e.g. X or...
The AdapterInterface violates the separation as it knows about the MigrationInteface in the `migrated` method. We are for example using phinx´ adapter structure but have a slightly different MigrationInterface (...
Is it possible to set up migrations without timestamp in the file? Also, is it possible to use some other unique stamp of file, for example version? I want to...
Can I override addTimestamps() method? I don't like some of the default settings it using like the `timestamp` type for both created_at and updated_at and that only the created_at gets...
### Use case: Migration A: `xxxxx_create_table_orders.php` Many migrations and months later Migration Z: `xxxxx_drop_table_orders.php` To make migration Z reversible, I need to implement `up` and `down` methods. The `up` have...
Im trying to an insert with the mysql function NOW() for a timestamp, but i get incorrect datetime value 'NOW()' which makes me think that it is sending it through...
Hi. I would like to use geometry type in Postgresql. However geometry seems to be replaced by geography. https://github.com/cakephp/phinx/blob/a15a5ffdb2f0b1d391891d44de831d1caf96d53a/src/Phinx/Db/Adapter/PostgresAdapter.php#L951-L962 I want to use `ST_CONTAINS(geometry, geometry)` But it can not be...
Is it possible to group seeds into categories/groups? My use case is I'm converting an old application into more modern practices, DB migrations being one of them. The application stores...
