[Building Sakai] user deleted WEBDAV directory

[Jon Wheat]

Ok, let me ask this then.
 
I was speaking to my dba and he said I could possibly do a flash-back query to a new table and compare to see what is missing now.
Granted it won't be just 1 difference, but I may be able to narrow it down.
 
So that said - what table keeps track of this stuff ?  Is it the CONTENT_RESOURCE table ?
and does that make any sense ?
 
-Jon


>>> Seth Theriault <slt at columbia.edu> 1/27/2010 7:02 PM >>>
Robert Taylor wrote:

> There is the CONTENT_RESOURCE_DELETE table in the database 
> that I could be used to identify the missing filename and 
> original location within the content hosting tree.

Unless you have implemented the "soft delete" feature tracked 
in SAK-1525, the CONTENT_RESOURCE_DELETE table will do you NO 
GOOD whatsoever. The data in it is simply wrong and not to be 
trusted.

We are running SAK-1525 locally, but I also have an hourly 
cron job that builds a tree of symlinks based on the database 
metadata and keeps an archive copy of the output of a "find" 
on that tree going back 24 hours. It's not perfect, but it 
does give some idea of where the files were previously 
located.

Seth
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100128/9ab36093/attachment.html