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…
Adding ‘catalog_product’ Type Attributes Programmatically in Mysql4 Install Files
Read More