[Vtigercrm-developers] Wrong type of column

[Jung Péter]

            Hi,
 
It happened all the time in vTiger 5.*...
Anno I posted a question, asking whether it is safe to change some of them to INT, but no one replied:
 
However, I found that some optimizing could/should be done on the existing database structure.
Attached is an SQL file that contains these optimizations.
 
My question is whether these modifications would cause problems upgrading vTiger to v6.0?
 
 
Sincerley,
                               Peter Jung
                               Parola Kft
 
Feladó: Mariusz Krzaczkowski
Küldve: 2014. május 16. 15:28
 
Why related_to in vtiger_modcomments column is of type varchar? All columns of id should be of type int, which is the purpose of adding varchar here?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140516/b2270ff5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: TCS_modifications.zip
Type: application/octet-stream
Size: 746 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140516/b2270ff5/attachment-0001.obj>