[Vtigercrm-developers] vtigercrm-developers Digest, Vol 71, Issue 2

Nathalia França nath.campreguer at gmail.com
Sat Dec 17 05:36:35 PST 2011


I'm trying to understand how Calendar module works and it relates to
activities somehow. Researching the database i found tables where
activities data is saved.
I'm not sure that it's correct but i'll tell what i found maybe it will
help you.

- Vtiger_activity is the table that keeps data of the main activities.
- Vtiger_recurringevents is the table that keeps data of the recurring
activities(The type of activities that can be repeated are events on
Calendar module)

Both tables are related trought activityid column.

I think the best way to delete and update activities is using the visual
mode because that way you won't corrupt your database. But if you need to
delete it in another way search for tables with events, fields and activity
on their names. It´s quite easy to understand their relation.

Please send me your progress it will help me too!
Nathalia Campreguer França

---------- Forwarded message ----------
> From: Antoni Bertran <tunyafix at gmail.com>
> To: vtigercrm-developers at lists.vtigercrm.com
> Cc:
> Date: Wed, 14 Dec 2011 11:36:24 +0100
> Subject: [Vtigercrm-developers] Repeat Activities, vtiger 5.2.1
> Hello! I have a question about Repeat Activities. I will post my questions
> and my assumption
> When I active the Repeat there is any difference between indicate "Until
> date" or not? If I indicate Until Date then create N activities. If I don't
> indicate Until Date I think the reminder doesn't work correctly.
> There is a database_schema but don't explain for what is using the tables.
> http://wiki.vtiger.com/index.php/Database_schema
> There is any table to keep the relations between Main Activities and
> Repeated Activities?
> To delete and update related Activities what have to do?
> Thanks!
> Antoni
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20111217/6e86226b/attachment-0002.html 

More information about the vtigercrm-developers mailing list