If you want to write an extension that requires some additional product attributes, I recommend that you look in the Mage_Catalog core module. Specifically, you will want to check out the most recent mysql4-upgrade*.php files…