SQL to make all users subscribed to admin emails?

[FleaBag]

What SQL query do I run to set every user to receive e-mail from the admin? For some reason new users are being set to not receive by default and I need to contact them. Thanks in advance.

[Xenon]

UPDATE user SET adminemail=1

[FleaBag]

Thanks Xenon. Another quick question... Where in my templates do I set field to be set to receive e-mails rather than not receive e-mails?

[TECK]

in registration template.

[FleaBag]

Cheers Teck. :)