Can't send different emails for different statuses (Approved, Pending, Member)

[Brianna Laugher]

The same email is sent to applied-but-not-yet-approved members regardless of which status you pick for them (No Change, Applied, Pending, Member). This means it is not easy to give context-specific messages in that email.
e.g. In "Applied" you might like to say "Your application is being processed".
In "Pending" you might like to say "Your application has been accepted, now please pay this membership fee."
In "Approved" you might like to say "Welcome, here is some info...."

But at the moment all these messages must be packed into a single email template.

[Stewart Smith (stewart)]

I think this would be the correct approach to get this:
ALTER TABLE member_types ADD COLUMN start_message_id int FOREIGN KEY REFERENCES site_messages(id);

and then have a "edit membership types" page that lets you set this.

we should also allow add/removal of the items in site_messages.