Create/Alter table using Magento setup script

Posted on October 8, 2012 · Posted in Magento

Copy  below code in your Magento setup script to create/modify table using Magento convention. Raw SQL script is highly discouraged, modify below code as per your need and place it in your sql/modulename_setup/ file to update Magento DB with your table create/modify.