[Vtigercrm-developers] How can I really delete entities from MySQL?

[Asha]

Hi Christian Castelli,

There are multiple queries involved for each module to delete an item from
the database as the information for each item is spread across multiple
tables. Simple thing would be to delete only from vtiger_crmentity table.
But this will not be clean.

On Wed, Aug 27, 2008 at 2:48 PM, Christian Castelli <
christian.castelli at trackset.com> wrote:

> Hi there,
> I'm new to vTiger and I've discovered that when I delete an item from
> the system (via browser), vTiger set to 1 the field vtiger_crmentity in
> the database.
> I can see all deleted items by a simpel query (and if I'm not wrong, in
> future releases it will be possibile to restore these items by the GUI,
> won't it?).
> My question is: how can I really delete those items in MySQL (in order
> to make it cleaner) that I've deleted from vTiger? What queries are
> involved?
> Thanks.
> --
> Christian Castelli
> Software Developer
> christian.castelli at trackset.com
>
>
> Italian Office
> Via Sant'Ilario Sud,109
> 56021 Cascina (PI) - Italia
> TEL +39 050 70 03 79
> FAX +39 050 80 70 136
> www.trackset.com <http://www.trackset.com>
>
> Questo messaggio è destinato alle sole persone indicate e può contenere
> informazioni riservate.
> Se ricevuto per errore, si prega di avvisare immediatamente il mittente
> e cancellare l'originale. Ogni altro uso del messaggio è vietato.
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>



-- 
Regards,
Asha
vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20080904/9b5a0845/attachment-0003.html