PHP实例开发源码—Catfish(鲶鱼) CMS 开源PHP内容管理系统.zip

# [Phinx](https://phinx.org): Simple PHP Database Migrations [](https://travis-ci.org/robmorgan/phinx) [](https://ci.appveyor.com/project/robmorgan/phinx) [](https://scrutinizer-ci.com/g/robmorgan/phinx/) [](https://packagist.org/packages/robmorgan/phinx) [](https://packagist.org/packages/robmorgan/phinx) Phinx makes it ridiculously easy to manage the database migrations for your PHP app. In less than 5 minutes you can install Phinx and create your first database migration. Phinx is just about migrations without all the bloat of a database ORM system or framework. **Check out http://docs.phinx.org for the comprehensive documentation.**  ### Features * Write database migrations using database agnostic PHP code. * Migrate up and down. * Migrate on deployment. * Seed data after database creation. * Get going in less than 5 minutes. * Stop worrying about the state of your database. * Take advantage of SCM features such as branching. * Integrate with any app. ### Supported Adapters Phinx natively supports the following database adapters: * MySQL * PostgreSQL * SQLite * Microsoft SQL Server ## Install & Run ### Composer The fastest way to install Phinx is to add it to your project using Composer (http://getcomposer.org/). 1. Install Composer: ``` curl -sS https://getcomposer.org/installer | php ``` 1. Require Phinx as a dependency using Composer: ``` php composer.phar require robmorgan/phinx ``` 1. Install Phinx: ``` php composer.phar install ``` 1. Execute Phinx: ``` php vendor/bin/phinx ``` ### As a Phar You can also use the Box application to build Phinx as a Phar archive (https://box-project.github.io/box2/). 1. Clone Phinx from GitHub ``` git clone git://github.com/robmorgan/phinx.git cd phinx ``` 1. Install Composer ``` curl -s https://getcomposer.org/installer | php ``` 1. Install the Phinx dependencies ``` php composer.phar install ``` 1. Install Box: ``` curl -LSs https://box-project.github.io/box2/installer.php | php ``` 1. Create a Phar archive ``` php box.phar build ``` ## Documentation Check out http://docs.phinx.org for the comprehensive documentation. ## Contributing Please read the [CONTRIBUTING](CONTRIBUTING.md) document. ## News & Updates Follow Rob (@\_rjm\_) on Twitter to stay up to date (http://twitter.com/_rjm_) ## Misc ### Version History **0.5.3** (Monday, 7th March 2016) * Critical fix: allow `migration_name` to be `null`. Introduced in 0.5.2 * Status command now shows migration start and end times * Bug fix for rolling back by date * Documentation improvements **0.5.2** (Tuesday, 1st March 2016) * Status command now includes missing migration names * Added support for Postgres table comments * Added `insert()` for the TablePrefixAdapter * Fixed the migration verbosity flag * Added MySQL 5.7 JSON support * Added support for MySQL `FULLTEXT` indexes * Postgres now supports `BIGSERIAL` for primary keys * Added support for MySQL index limits * Initial support for multiple migration paths (using glob) * Documentation improvements * Unit test enhancements **0.5.1** (Wednesday, 30th December 2015) * **PHP 5.3 is no longer supported!** * Add support for Symfony 3.0 components * Ensure that the `status` command returns the correct exit code * Allow `$version` to be passed into templates * Support for MySQL `YEAR` column type * Multiple documentation updates and corrections **0.5.0** (Monday, 30th November 2015) * Support for seeding data after database creation * The migration and seed directories are now nested under `db` by default * Moved `Phinx\Migration\Util` to `Phinx\Util\Util` * All `insert()` methods now have a slightly different method signature * Fixed key/insert operations for MySQL * Introduced `AdapterInterface::hasIndexByName()` * Improved `dropForeignKey()` handling for SQLite * Added support for the MySQL `binary` datatype. BLOBs now use the proper type. * The status command shows a count of pending migrations in JSON output * We are now testing against PHP 7 **0.4.6** (Friday, 11th September 2015) * You can now set custom migration templates in the config files * Support for MySQL unsigned booleans * Support for Postgres `smallint` column types * Support for `AFTER` when using `changeColumn()` with MySQL * Support for `precision` and `scale` when using the Postgres `decimal` type * Fixed a bug where duplicate migration names could be used * The schema table is now created with a primary key * Fixed issues when using the MySQL `STRICT_TRANS_TABLE` mode * Improved the docs in the default migration template * Made Box PHAR ignore the bundled `phinx.yml` configuration file * Updated Box installer URL * Internal code improvements * Documentation improvements **0.4.5** (Tuesday, 1st September 2015) * The rollback command now supports a date argument * Fixed DBLIB DSN strings for Microsoft SQL Server * Postgres support for `jsonb` columns added * The `addTimestamps()` helper method no longer updates the `created_at` column * Fix for Postgres named foreign keys * Unit test improvements (including strict warnings) * Documentation improvements **0.4.4** (Sunday, 14th June 2015) * The `change` method is now the default * Added a generic adapter insert method. Warning: The implementation will change! * Updated Symfony depdencies to ~2.7 * Support for MySQL `BLOB` column types * SQLite migration fixes * Documentation improvements **0.4.3** (Monday, 23rd Feburary 2015) * Postgres bugfix for modifying column DEFAULTs * MySQL bugfix for setting column INTEGER lengths * SQLite bugfix for creating multiple indexes with similar names **0.4.2.1** (Saturday, 7th Feburary 2015) * Proper release, updated docs **0.4.2** (Friday, 6th Feburary 2015) * Postgres support for `json` columns added * MySQL support for `enum` and `set` columns added * Allow setting `identity` option on columns * Template configuration and generation made more extensible * Created a base class for `ProxyAdapter` and `TablePrefixAdapter` * Switched to PSR-4 **0.4.1** (Tuesday, 23rd December 2014) * MySQL support for reserved words in hasColumn and getColumns methods * Better MySQL Adapter test coverage and performance fixes * Updated dependent Symfony components to 2.6.x **0.4.0** (Sunday, 14th December 2014) * Adding initial support for running Phinx via a web interface * Support for table prefixes and suffixes * Bugfix for foreign key options * MySQL keeps column default when renaming columns * MySQL support for tiny/medium and longtext columns added * Changed SQL Server binary columns to varbinary * MySQL supports table comments * Postgres supports column comments * Empty strings are now supported for default column values * Booleans are now supported for default column values * Fixed SQL Server default constraint error when changing column types * Migration timestamps are now created in UTC * Locked Symfony Components to 2.5.0 * Support for custom migration base classes * Cleaned up source code formatting * Migrations have access to the output stream * Support for custom PDO connections when a PHP config * Added support for Postgres UUID type * Fixed issue with Postgres dropping foreign keys **0.3.8** (Sunday, 5th October 2014) * Added new CHAR & Geospatial column types * Added MySQL unix socket support * Added precision & scale support for SQL Server * Several bug fix