17
trying to help you out, not critisizing, but just test it!
Make local install, subscribe yourself to some kind of notification and see what has happened in the XOOPS tables.
And you have to take care of the fact that users can NOT unsubscribe.
You might be able to do this last thing by filling the records but then afterwards disabling notifications subscribing only for the news module. Believe it is a setting in the prefs of last one that you can set which notifications come in order. Then look if notifying still works.