XF 1.3 Enable Watch this thread on replys via SQL

[OakleyForum]

A while ago, I disabled Watch this thread for users when they reply, but I would like to re-enable this, just no t the email part for all existing members. I know it has to be done via SQL, can anyone help?

I want it so moving forward all members have the check box "Watch this thread" checked, when replying and creating threads. But current members, not just new registrations. I saw the SQL code for disabling, but what about enabling?

 

[Paul B]

UPDATE xf_user_option SET default_watch_state = 'watch_no_email'

 

[OakleyForum]

Thanks