seahorse [Ohio]MA to mainEnglish · 1 year agoDear lemmy, today I fucked upmessage-squaremessage-square27fedilinkarrow-up184arrow-down13file-text
arrow-up181arrow-down1message-squareDear lemmy, today I fucked upseahorse [Ohio]MA to mainEnglish · 1 year agomessage-square27fedilinkfile-text
Deleted something I shouldn’t have. I learned my lesson, but I had to revert to a backup that was about 3 days old. My bad.
minus-squareSmokeInFoglinkfedilinkEnglisharrow-up2·1 year agoW3 Schools entry on SQL DELETE statement I don’t know the actual table definitions for lemmy, but it should look something like: DELETE FROM activitypub WHERE createdDate < ((SELECT CURRENT_DATE) - interval '2 weeks')
W3 Schools entry on SQL DELETE statement
I don’t know the actual table definitions for lemmy, but it should look something like:
DELETE FROM activitypub WHERE createdDate < ((SELECT CURRENT_DATE) - interval '2 weeks')