vtiger

[chriscast]

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.

[pinaki]

Hi chriscast,

In vtiger, all the tablenames related to a module are saved in the array variable $tab_name in the class file of that module (for e.g. Contacts.php for Contacts module). Also since crmid of vtiger_crmentity table is the base key (it has on delete cascade defined on it for other tables), deleting the row from vtiger_crmentity table will remove it from most of the tables of a module. Others you will have to manually check and delete.

Please be careful when database records directly as you can seriously damage your vtiger installation. I would recommend a backup before proceeding.

Let me know how you go.

Thanks
Pinaki
vTiger team