rs5th, 10 months ago I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything. <span style="font-weight:bold;color:#a71d5d;">DELETE FROM</span><span style="color:#323232;"> activity </span><span style="font-weight:bold;color:#a71d5d;">WHERE</span><span style="color:#323232;"> published < NOW() </span><span style="font-weight:bold;color:#a71d5d;">-</span><span style="color:#323232;"> INTERVAL </span><span style="color:#183691;">'1 day'</span><span style="color:#323232;">; </span>
I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything.
<span style="font-weight:bold;color:#a71d5d;">DELETE FROM</span><span style="color:#323232;"> activity </span><span style="font-weight:bold;color:#a71d5d;">WHERE</span><span style="color:#323232;"> published < NOW() </span><span style="font-weight:bold;color:#a71d5d;">-</span><span style="color:#323232;"> INTERVAL </span><span style="color:#183691;">'1 day'</span><span style="color:#323232;">; </span>