Creating tables using setup scripts

When using database models, as explained in the previous recipe, the corresponding tables needs to be created during setup. These operations are placed in setup scripts and executed during the installation of an extension.

Getting ready

While running the installation of a module, there are four files executed to create schemas and insert data. To create schemas, the files used are as follows:

Setup/InstallSchema.php

Setup/UpgradeSchema.php

The installation file is executed only when there is no record in the setup_module table for the module. The upgrade file is executed only when the current version number in the setup_module table is lower than the version configured in your etc/module.xml file.

When it's necessary to insert default values into a table or new EAV attributes need to be created, these actions need to be configured in the following files:

Setup/InstallData.php

Setup/UpgradeData.php

Magento keeps track of which version is installed for an extension...