Database Migrations in Joomla

Question

Is there a way to use database migrations using Joomla? I am looking for a mechanism similar to the one found in Rails or Symfony.

I would like to apply the changes to the database whenever the model changes. adding a column, creating a new relationship, deleting some tables, ...

To this question , the accepted answer seems like a very cool option, but I don't know if there is anything special for Joomla.

Thank!

Answer 1

If you want to update your own database component schema, you can refer to the following section: http://forum.joomla.org/viewtopic.php?p=1607199

, :

• https://github.com/davejkiger/mysql-php-migrations
• https://github.com/Billiam/MySQL-PHP-AutoMigrations

Answer 2

Joomla , sql- phpMyAdmin.

joomla (core plugins one), . (, jos_users id).

joomla, ( ).

Answer 3

2 Joomla, :

1) Just put your SQL changes (e.g. ceate table or alter or any thing) /administrator/components/com_admin/SQL/updates/YOU_DB_ENGINE/anyfilename.sql go to the web interface, then / administrator => extension => manage => database and simple fix.

2) you can take a look at / administrator / components / com _installer / models / database.php and implement the custom migration process on it so that you can use the custom folder