XF 1.5 How to mass Expire all warnings?

[rdn]

Any query I can do this?
To mass expire all issued warnings?

Thanks!

 

[MySiteGuy]

truncate table warning;
truncate table warning_action_trigger;
update user set warning_points=0;

Note this does not expire the warnings, it wipes them out as if they never happened.