有没有方法可以删除所有帖子的所有修订版本？

[Morfik (Mikhail Morfikov)]

Ok, so it would be something like this, right?

discourse-# \connect discourse
discourse=# delete from post_revisions *;
discourse=# update posts set public_version=1 where public_version>1;
discourse=# update posts set version=1 where version>1;