SkillAgentSearch skills...

MySQL2Phinx

A command line PHP script to generate a phinx migration from an existing MySQL database

Install / Use

/learn @gwa/MySQL2Phinx
About this skill

Quality Score

0/100

Supported Platforms

Universal

README

MySQL2Phinx

A simple cli php script to generate a phinx migration from an existing MySQL database.

Usage

$ php -f mysql2phinx.php [database] [user] [password] > migration.php

Will create an initial migration class in the file migration.php for all tables in the database passed.

Caveat

The id column will be unsigned. Phinx does not currently supported unsigned primary columns. There is a workaround.

TODOs

Not all phinx functionality is covered! Check your migration code before use!

Currently not supported:

  • Column types:
    • [ ] float
    • [ ] decimal
    • [ ] time
    • [ ] binary
    • [ ] boolean
View on GitHub
GitHub Stars21
CategoryData
Updated2y ago
Forks14

Languages

PHP

Security Score

75/100

Audited on Oct 16, 2023

No findings