deleted database items

[shawncooper]

Please help
Someone accidently deleted an account,
In the accounts tables i marked the account as deleted = 0 so i can see acount again, but all cases relating to account are gone, if i view cases table they are not even their marked as deleted.
Thanks

[mikesolomon]

have a look at the table accounts_cases

this holds the link between accounts & cases and the entries should be in there marked as deleted

[rafael.q.g@hotmail.com]

Then you just have to execute this sql:
update accounts_cases set deleted=0 where account_id='your_account_id'

[robertbmirth]

Rafael's query, as I hope you know, will undelete all case relationships related to the account, so if you have some older relationships that you have previously removed, you'll also undelete those relationships as well. If that is the case, don't forget to prune your older relationships.