rs5th,
@rs5th@lemmy.scottlabs.io avatar

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 &lt; 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>
  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • uselessserver093
  • Food
  • aaaaaaacccccccce
  • [email protected]
  • test
  • CafeMeta
  • testmag
  • MUD
  • RhythmGameZone
  • RSS
  • dabs
  • Socialism
  • KbinCafe
  • TheResearchGuardian
  • Ask_kbincafe
  • oklahoma
  • feritale
  • SuperSentai
  • KamenRider
  • All magazines