I have a module that should be updated:
Magento_Securitytxt schema: current version - none, required version - 1.0.0
If I use this code:
UPDATE `mg_setup_module` SET schema_version="1.0.0", data_version="1.0.0" WHERE module="Magento_Securitytxt";
It is not updating, because Magento_Securitytxt does not exist within mg_setup_module at the moment.
How can I create Magento_Securitytxt within mg_setup_module?
Try to run upgrade cli command from Magento root directory
Php bin/magento setup:upgrade
Php bin/magento setup:static-content:deploy -f
Php bin/magento cache:flush
After that you can check mg_setup_module table in database you can see your module in there.