<div class="gmail_quote"><div>Antoni,</div><div><br></div><div>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.</div>
<div>I'm not sure that it's correct but i'll tell what i found maybe it will help you.</div><div> </div><div>- Vtiger_activity is the table that keeps data of the main activities. </div><div>- 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)</div>
<div><br></div><div>Both tables are related trought activityid column.</div><div><br></div><div>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. </div>
<div><br></div><div><br></div><div>Please send me your progress it will help me too!</div><div>Nathalia Campreguer França</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
---------- Forwarded message ----------<br>From: Antoni Bertran <<a href="mailto:tunyafix@gmail.com">tunyafix@gmail.com</a>><br>To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
Cc: <br>Date: Wed, 14 Dec 2011 11:36:24 +0100<br>Subject: [Vtigercrm-developers] Repeat Activities, vtiger 5.2.1<br><div>Hello! I have a question about Repeat Activities. I will post my questions and my assumption</div><div>
<br></div><div>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.</div>
<div><br></div><div>There is a database_schema but don't explain for what is using the tables. </div><div><a href="http://wiki.vtiger.com/index.php/Database_schema" target="_blank">http://wiki.vtiger.com/index.php/Database_schema</a> </div>
<div>There is any table to keep the relations between Main Activities and Repeated Activities?</div><div><br></div><div>To delete and update related Activities what have to do? </div><div><br></div><div>Thanks!</div><div>
<br></div><div>Antoni</div><div><br></div></blockquote></div>