vtiger Forum Index vtiger
The Honest Open Source CRM
 

vtiger_activitytype table not working hard enough?
Click here to go to the original topic

 
       vtiger Forum Index -> Code Contributions - 5.0.2
Previous topic :: Next topic  
Author Message
Toto



Joined: 18 Jul 2006
Posts: 39

Posted: Thu Jul 27, 2006 10:22 pm    Post subject: vtiger_activitytype table not working hard enough?  

I noticed today that in V5beta2 the table vtiger_activity uses a varchar(50) to record the "activitytype" field, while there is a table vtiger_activitytype with an int(19) field "activitytypeid".

Wouldn't it be better to change vtiger_activity.activitytype to an int, to save space and time on comparissons, and refer back to the vtiger_activitytype when you require the name? The table already exists. It seems like it's not doing much, really.

Toto
Back to top  
 
       vtiger Forum Index -> Code Contributions - 5.0.2
Page 1 of 1


Powered by phpBB Search Engine Indexer
Powered by phpBB 2.0.15 © 2001, 2002 phpBB Group