1) Can there be multiple install scripts in the custom module? For example:
- data-install-1.0.0.php
- data-install-1.0.1.php
2) Assuming I have the following scripts inside app/code/local/Company/Helloworld/data/helloworld_setup:
- data-install-1.0.0.php
- data-install-1.0.1.php
- data-install-1.0.2.php
- data-install-2.0.0.php
- data-upgrade-1.0.0-1.0.1.php
- data-upgrade-1.0.1-1.0.2.php
- data-upgrade-1.0.2-2.0.0.php
- data-upgrade-2.0.0-2.0.1.php
Questions:
2.1) I already have version 1.0.0 of this module installed in my Magento:
<config>
<modules>
<Company_Helloworld>
<version>1.0.0</version>
</Company_Helloworld>
</modules>
...
</config>
What will be the order of execution of these scripts when:
2.1.a) I install version 1.0.2
2.1.b) I install version 2.0.0
2.2) I don't have any version of this module installed yet. What will be the order of execution of these scripts when:
2.2.a) I install version 1.0.0
2.2.b) I install version 2.0.0
2.2.c) I install version 3.0.0
3) I've seen in Magento core modules, the sql install scripts are named in two ways:
- mysql4-install-1.0.0.php
- install-1.0.0.php
When is mysql4- required in the script name? When can I remove mysql4- from the name? Does it depend on Magento version?