On 2014-05-28 21:32, Jeff Larsen wrote:
In our case, the destruction of the metadata is what will keep the
bosses happy. They are "anti-discovery". We have a very short
retention period primarily to protect users from themselves in a way
that does not require admins to waste time with recovery from backup
media.
Can I just do the following in sql?
delete from rcpt where piler_id in (select piler_id from metadata
where deleted = 1);
delete from rcpt where id in (select id from metadata where deleted=1);
delete from attachment where piler_id in (select piler_id from
metadata where deleted = 1);
delete from metadata where deleted = 1;
the rest looks ok
Janos
