Proposed schema for notifciation mailing list schema

gistfile1.xml

<!--
  *
  * TABLE notification_mail_list
  *
  -->
<table name="notification_mail_list">
	<field name="subscription_id" type="I8">
		<KEY />
		<AUTOINCREMENT/>
	</field>
	<field name="email" type="X">
		<NOTNULL/>
	</field>
	<field name="confirmed" type="I1">
		<NOTNULL/>
		<DEFAULT VALUE="0"/>
	</field>
	<field name="context" type="I8">
		<NOTNULL/>
	</field>
	<descr>Stores subscriptions to the notification mailing list</descr>
</table>

That's what I mean by a _settings table to go with notification_mail_list. Or I might've missed your point...?

i'm just talking semantics. A table called notification_mail_list_settings shouldn't contain anything to do with blocked notifications or what notifications get emailed out to subscribed users. It would have to be called something else. Don't worry, I think we're probably on the same page at different paragraphs here..

OK, sounds good. Go for it!