XF 1.1 Query to turn off alerts for imported members

[Nudaii]

will be importing a large forum on sunday, after having been on vb since ..well forever basically

beta feedback reports that members would prefer all their alerts set to off, and then they can manually go in and select those they wish to enable

is there a query to default Off alerts?

 

[Paul B]

Take a backup first.

UPDATE xf_user_option
SET alert_optout = 'post_insert,post_insert_attachment,post_like,post_quote,profile_post_comment_other_commenter,profile_post_comment_your_post,profile_post_comment_your_profile,profile_post_insert,profile_post_like,user_following,user_trophy';

 

[Nudaii]

thanks