Setup a database migrations tool

[DawoudIO]

need a way to keep database scripts in sync as we add more features

[dferrans]

Phinx
This is a DATABASE migration tool writen in php
Is framework agnostic.
Is is realy easy to manage migrations:
URL: http://docs.phinx.org/en/latest/

Composer File:

{
    "require": {
       "robmorgan/phinx": "dev-master"
    }
}

[DawoudIO]

I just looked at https://phinx.org/ and it is cool, the only issue i see with it is that you need a command line system setup to migrate and most of the CRM users will not have than

[DawoudIO]

@crossan007 this is done correct?

[crossan007]

I'm not sure I'd say it's "Done."

Our current upgrade method looks like this:

• update the install.sql
• validate the install.sql against the previous version of install, and add any changes to the update.sql files

These update files are then applied by the SystemService as part of a database restore, or upon login

[crossan007]

It works, but could be improved if/when we move to ORM

[crossan007]

This is working. Closing ticket.