We have a scenario where we have a core engine with module add-ons. What
modules that will be used differ from deployment to deployment. Each of
these modules might need different things in the db (both structure and
data) and I want each module to be in charge of its own db structure.
Each module is contained in its own source directory and what modules to
use is determined in the build process (each module has it’s own build
script (with some inherited from a “main” build script) and I want db
scripts to be executed in this process).
I really like Migrations and would like to use it. Is it possible to use
in a scenario like this? What do I need to do in order to make it work
(if possible)? Keep in mind that all modifications from all modules goes
into the same database and that the order of how the module build
scripts are executed might vary from deployment to deployment so the
numbering scheme and schema_info table might be troublesome in this
case. I guess I need to be able to get a module name/code into it
somewhere somehow.
Any answers/ideas appreciated!
/Marcus