phinx
phinx copied to clipboard
cakephp
PHP Database Migrations for Everyone
Prep: - [ ] 0.13 regression/compatibility test as `dev-... as 0.12` inside https://github.com/cakephp/migrations run - [ ] Creating release notes and possible migration guide/info - [ ] Making sure master...
Tried to create custom data types as per documentation, but they aren't working. phinx.yml: ```YAML paths: migrations: '%%PHINX_CONFIG_DIR%%/db/migrations' seeds: '%%PHINX_CONFIG_DIR%%/db/seeds' environments: default_migration_table: phinxlog default_environment: development production: adapter: mysql host: localhost...
PDOException can return an int|mixed. This code is directly passed to InvalidArgumentException which requires 'code' to be an int. So this will crash in php 8.1 en therefor not show...
PR fixes a bug where altering sqlite tables that had indexes or triggers would drop the indexes or triggers. This was because indexes and triggers are not contained in the...
The first commit of this PR handles #1972, which is to remove the use of NTEXT and replace it with NVARCHAR(MAX). The existing NTEXT and TEXT parsing to the Phinx...
- CURRENT_TIMESTAMP must match the precision of the defined column - applies to MySQL 5.6+ - ref: https://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html eg. $this->table('test_table')->addColumn('created_at', 'timestamp', ['limit' => 6, 'default' => 'CURRENT_TIMESTAMP'])
It would be great to be able to create tables with an **Identity Column**. The **old** PostgreSQL approach for creating identifiers: ``` CREATE TABLE test_old ( id serial PRIMARY KEY,...
For each adapter, there's a handful of ways to customize the DSN string we generate that is passed to PDO. However, there's not currently a good way we have to...
When using the SQLite adapter, tables can be created with a multi-column primary key. Trying to change the primary key to a multi-column one afterwards fails (whether it previously was...
