Magento

Hi,

I’m wondering if I could alter the table newsletter_subscriber in order to add a field.

Actually, I’m having a partnership with an other site which will ask theire clients if they wish to recieve my newsletter.

This partnership will work as follow :
My partner will run a file which will call
http://www.mysite.com/partners/membership.php?email=blabla@blala.bla&name;=blibilibli&last;=blobloblo

I would like to inject these email into my newsletter_subscriber table in magento database. The file I’m willing to add will containe the origine of the optin email so I can distinguish my sources.

Is Adding a field into this table likely to crash the site ?

Hi,

Addition of this field in table won\’t crash the site.
You can choose the way how to add this field, it depends on how you want to use this field in future.
Of course you can add this field by standard MySQL query, but the most recommended way is to create your own module where you will add this field in install script.
For more information you can read this article http://www.magentocommerce.com/wiki/5_-_modules_and_development/0_-_module_development_in_magento/custom_module_with_custom_database_table

<NS>