Studyon Minte9.com
Magento




Upgrade custom SQL



If you look in any of the code modules (say DOCROOT\app\code\core\Mage\Catalog\ for example), you will see a folder called sql\modulename_setup which contains numerous files that perform the database upgrades relevant to their module version. 


http://stackoverflow.com/questions/5014792/how-to-upgrade-magento-when-the-database-structure-changes-between-versions