phinx
phinx copied to clipboard
PHP Database Migrations for Everyone
Fixes #2288 (originally https://github.com/cakephp/migrations/issues/719) and applies #2272 to 0.13.x (CakePHP Migrations 3.x - CakePHP 4)
The docs for the query builder: https://github.com/cakephp/phinx/blob/615485032e67d9500cbfa2e53acdb0449e26f191/docs/en/migrations.rst?plain=1#L1646-L1676 These are out of date and need to be updated to make reference to the specific builder methods (e.g. `getSelectBuilder`) that people are...
This is to allow the use of the native uuid for mariadb 10.7+ users. For other database it's simply an alias to the existing uuid type. Sqlite is explicitly not...
For sqlite, doing a migration/seed gives an output similar to following: ``` using adapter sqlite using database ./data ``` where the we only print out the database name, but omit...
Fixes #2270. In the end I chose to copy/adapt OutputStyle::getErrorOutput as a new protected method on the abstract command rather than using SymfonyStyle because: 1. creating SymfonyStyle requires both $input...
I am working on a project where database has both triggers and statistics and when I try to drop trigger and after that drop statistics I got an error that...
Hello, I didn't find any references to namespaces in the docs when creating migrations, so, after debugging the code, I found out how it could be done. This PR adds...
Currently the SqlServerAdapter has this property that cannot be changed: `protected string $schema = 'dbo'` Please allow us to change this.
PR reworks how we handle the foreign key pragma in sqlite, so that we turn on the pragma before doing any plan actions, and turn it back on after all...
If I do: ```php $this->table('foo') ->addColumn('id_2', 'integer') ->create(); $this->table('foo') ->changePrimaryKey('id_2') ->update(); ``` After the create I'll have: ```sql CREATE TABLE `foo` (`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, `id_2` INTEGER...