The signup module

We want to provide the users with the functionality to enter their name, email address, and how they found our web site. We want all this stored in a database and to have an email automatically sent out to the users thanking them for signing up..

To start things off, we must first add some new tables to our existing database schema.

The structure of our newsletter table will be straightforward. We will need one table to capture the users' information and a related table that will hold the names of all the places where we advertised our site. I have constructed the following entity relationship diagram to show you a visual relationship of the tables:

Let's translate this diagram into XML and place it in the config/schema.xml file:

<table name="newsletter_adverts" idMethod="native" phpName="NewsletterAds">
<column name="newsletter_adverts_id" type="INTEGER" required="true" autoIncrement="true" primaryKey="true" />
<column name="advertised" type="VARCHAR" size...