daniel142005 - 2:07 am on Jun 8, 2010 (gmt 0)
I also found the trashcan option to be useful since it's generally less annoying to be able to undo a delete than it is to have to confirm every delete you make. Using Mysql I just add a "Delete" field, if it's 0 then the entry is not deleted. When they delete it I either set it to a 1 or I set it to a timestamp with a future date. If it's a 1 it means it's deleted but I don't want it to automatically purge, and if it's a timestamp the script will automatically clean it up once the date is reached. It can be a pain to add it to all your SQL queries, but it's generally worth it in the end... especially for the IT admins that would have to restore a previous backup to restore the data without it.